I need the longitude and latitude of the centre of geography data in PostGIS. The format is called EPSG 2206 and the columns in record are "length","shape_area" and "the_geom"
i use the query to get longitude and latitude.
Longitude
SELECT ST_X(the_geom) FROM myTable;
Latitude
SELECT ST_Y(the_geom) FROM myTable;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With