Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.
Sign up to join this community
After storing lon lat values as a GEOGRAPHY data type, how do I retrieve the individual lat lon values?
Failed attempt:
SELECT id, geog, ST_X(geog), ST_Y(geog) FROM locations;
Error:
No function matches the given name and argument types. You might need to add explicit type casts.
The ST_X(point) function only supports the geometry (as for now).
One workaround is to cast the geog to geom using ::geometry.
Hense your query should be like this:
SELECT id, geog, ST_X(geog::geometry), ST_Y(geog::geometry) FROM locations;
And since it's geog the SRID would be 4326.
Also here's a good source for the geog type.
Undefined object: 7 ERROR: type "geometry" does not exist. Any ideas? stackoverflow.com/questions/15780931/…
Try to use this query.
SELECT ST_XMax(geog), ST_YMax(geog), ST_AsEWKT(geog)
FROM locations LIMIT 10;
it works for me.
SELECT ST_XMax(ST_GeographyFromText('SRID=4326;POINT(-73.968504 40.779741)')); gives me ERROR: function st_xmax(geography) does not exist.
Jun 15, 2016 at 14:57
try to use this query.
SELECT X(the_geom), Y(the_geom), ST_AsEWKT(the_geom)
FROM locations LIMIT 10;
i hope it helps you
X() and Y() functions don't seem to exist. Where did you get those?
X() and Y() are valid in an older revision of PostGIS--perhaps 8.x?. Updated, that query would use ST_X() and ST_Y() instead.