[postgis-users] How do I parse postGIS types in my app code?

W. Matthew Wilson matt at tplus1.com
Sun Feb 27 07:48:15 PST 2011


I have a column with type geography('point').

When I load the contents of that column into python, I get something like this:

'0101000020E6100000D0A39872F4E955C0D66EBBD05CF94440'

I know how to use the ST_X and ST_Y functions in order to extract
latitude and longitude (thanks to this list, BTW) but sometimes I
would like to not have to do that in SQL.

Any ideas?

Matt

-- 
W. Matthew Wilson
matt at tplus1.com
http://tplus1.com



More information about the postgis-users mailing list