0
244
ViewsHow to get lat and long from geom column in postgres DB
I have a table in postgres DB named "building_footprints".
Please see attached image
and running below query to table
SELECT row_to_json(fc) FROM (
SELECT 'FeatureCollection' As type, array_to_json(array_agg(f)) As features FROM (
SELECT 'Feature' As type, ST_AsGeoJSON(lg.the_geom)::json As geometry,
row_to_json((gid, the_geom)) As properties FROM building_footprints As lg
) As f) As fc
Query Result is:
I want to convert coordinates value(coordinates":[[[[530500.00039933,545400.008863266],) in to lat/long.
·
Santiago Trujillo
1 answers
Answer question0
try this
SELECT id, the_geom , ST_X(the_geom::geometry), ST_Y(the_geom::geometry) FROM building_footprints;
you should have postgis extension installed!
·
Santiago Trujillo
Report
Answer question