[postgis-users] rookie question: how to extract latitude and longitude values from geography(POINT) column?

[David Fawcett]

I haven't tried them specifically with the geography type, but I would
assume that ST_AsText(), ST_X(), and ST_Y() should work.

Something like:

SELECT ST_X(myGeogColName), ST_Y(myGeogColName)
   FROM myTable;

Take a look at the docs here:
http://postgis.refractions.net/documentation/manual-1.3/ch06.html#id2575402

David.

On Wed, Jan 5, 2011 at 8:46 AM, W. Matthew Wilson <matt at tplus1.com> wrote:
> 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.
>
> Thanks in advance!
>
> Matt
> --
> W. Matthew Wilson
> matt at tplus1.com
> http://tplus1.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>