Coordinate of a point
Sebastian Albrecht
albrecht at FIELAX.DE
Mon Sep 12 11:48:12 EDT 2005
Hello Gianfranco,
>How can I find the coordinate of a point stored in postgres?
>What postgis SQL command do I have to use?
>
>
You could use the X() and Y() functions to get the latitude and
longitude values of your point. If you have a point column "geom" in a
table "data" the SQL string would be:
SELECT X(geom), Y(geom) FROM data;
Regards,
Sebastian
More information about the mapserver-users
mailing list