[postgis-users] linux strange geometry columns

francesco francesco.pirotti at unipd.it
Fri Jun 16 05:17:38 PDT 2006


hello folks,

does anyone know why when I put postgis data in postgres server in my linux 
machine the geometry column looks odd?

These are the values I get instead of the good old 
"SRID=26591;POINT(1400110.156 4851149.612) " ....

0101000020DF670000250681755C6235410E2DB26D8D825241
0101000020DF6700008FC2F5C8A0633541819543CB4F825241
0101000020DF6700005A643B1F04793541CDCCCC9CBD835241
0101000020DF67000060E5D0A2037935415A643BA7B8835241

It reads the data perfectly from mapserver, but I cannot use a filter on 
the data type because my sql function looks for key words like "POINT" and 
"LINE" which of course it does not find in that bunch of numbers....

Thank for the time,
Francesco Pirotti


CIRGEO
Interdepartment Research Center of Photogrammetry,
Remote Sensing, Cartography and GIS
University of Padua
Viale dell'Università 16 - Legnaro - PD
www.cirgeo.unipd.it
phone +39.328.2126861
phone +39.049.827.2522/2688
fax. +39.049.8272686 




More information about the postgis-users mailing list