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