Skip to main content
Database Administrators

Return to Question

Tweeted twitter.com/StackDBAs/status/1087454940170240000
edited title
Link
Evan Carroll
Evan Carroll
  • 64.7k
  • 49
  • 251
  • 496

Storing How can I store latitude and longitude without PostGIS?

deleted 12 characters in body; edited tags; edited title
Source Link
Erwin Brandstetter
Erwin Brandstetter
  • 182.1k
  • 28
  • 457
  • 620

Storing latitude and longitude in Postgresql

I know there are similar questions on here that have been answered but unfortunately none of them work for me. I am hacking my way through creating a page which will display multiple locations on a map. I am using HTML 5 mapping plus googleGoogle maps. I have converted the addresses I have, into long/lat and they are stored in a CSV file along with other attributes.

I have tried storing as point, character varying and number as well as trying to create my own definition but have had no success. The table already exists and I just need to add these additional columns. I would rather not use POSTGISPostGIS since that feels like adding in an additional level of complexity which I could well do without.

So what do you suggest?

thanks

Storing latitude and longitude in Postgresql

I know there are similar questions on here that have been answered but unfortunately none of them work for me. I am hacking my way through creating a page which will display multiple locations on a map. I am using HTML 5 mapping plus google maps. I have converted the addresses I have, into long/lat and they are stored in a CSV file along with other attributes.

I have tried storing as point, character varying and number as well as trying to create my own definition but have had no success. The table already exists and I just need to add these additional columns. I would rather not use POSTGIS since that feels like adding in an additional level of complexity which I could well do without.

So what do you suggest?

thanks

Storing latitude and longitude

I know there are similar questions on here that have been answered but unfortunately none of them work for me. I am hacking my way through creating a page which will display multiple locations on a map. I am using HTML 5 mapping plus Google maps. I have converted the addresses I have, into long/lat and they are stored in a CSV file along with other attributes.

I have tried storing as point, character varying and number as well as trying to create my own definition but have had no success. The table already exists and I just need to add these additional columns. I would rather not use PostGIS since that feels like adding in an additional level of complexity which I could well do without.

So what do you suggest?

Source Link
lz7cjc
lz7cjc
  • 111
  • 1
  • 1
  • 3

Storing latitude and longitude in Postgresql

I know there are similar questions on here that have been answered but unfortunately none of them work for me. I am hacking my way through creating a page which will display multiple locations on a map. I am using HTML 5 mapping plus google maps. I have converted the addresses I have, into long/lat and they are stored in a CSV file along with other attributes.

I have tried storing as point, character varying and number as well as trying to create my own definition but have had no success. The table already exists and I just need to add these additional columns. I would rather not use POSTGIS since that feels like adding in an additional level of complexity which I could well do without.

So what do you suggest?

thanks