> -----Original Message----- > From: postgis-users-boun...@postgis.refractions.net > [mailto:postgis-users-boun...@postgis.refractions.net] On > Behalf Of W. Matthew Wilson > Sent: Wednesday, 05 January 2011 09:47 > To: postgis-users@postgis.refractions.net > Subject: [postgis-users] rookie question: how to extract > latitude and longitude values from geography(POINT) column? > > I'm storing destinations as geography POINT columns. Is > there some function that converts a geography(POINT) column's > latitude and longitude into plain numbers? > > I'm using google maps to draw markers on a map for these > destinations and I need to pass in the latitude and longitude > as a pair of numbers.
You can try: # select ST_AsText(geom) from foo; ..which will give you WKT formatted output which you can parse. More geography type functions are at http://postgis.refractions.net/documentation/manual-1.5/ch08.html#PostGI S_GeographyFunctions ..Tom _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
