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? Jul 2, 2013 at 13:00
  • Hi, I am storing into postgis db sorry@AlexandreNeto
    – Tom
    Jul 3, 2013 at 11:37
  • The software are you "importing" your points to would also be helpfull. Jul 3, 2013 at 13:55
  • I found the solution using the_geom column
    – Tom
    Jul 5, 2013 at 9:22

1 Answer 1


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 and acknowledge you have read our privacy policy.

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