If I import from a POST DB a set of points that are referenced by grid reference, will the long/lat decimal also be added to the file? or will I have to convert the points to long/lat myself?

In short: I am importing grid references, but want to display long/lat + store the long/lat?

Any suggestions?

  • Import where? Please tell what software are you using. Is POST DB, a postgis database? – Alexandre Neto Jul 2 '13 at 13:00
  • Hi, I am storing into postgis db sorry@AlexandreNeto – Tom Jul 3 '13 at 11:37
  • The software are you "importing" your points to would also be helpfull. – Alexandre Neto Jul 3 '13 at 13:55
  • I found the solution using the_geom column – Tom Jul 5 '13 at 9:22

Assuming that your data is already in the desired Geographic Coordinate Reference System (CRS), if your table does not have any Latitute and Longitude columns, you can always calculate them still in Postgis, using st_x and st_y functions, before "importing" it elsewhere. The SQL code will be something like this:

SELECT *, st_y(the_geom) as latitude, st_x(the_geom) as longitude
FROM your_table

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.