Coordinate of a point
Sebastian Albrecht
albrecht at FIELAX.DE
Mon Sep 12 08:48:12 PDT 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