[postgis-users] linux strange geometry columns

[Robert Burgholzer]

Looks like WKB (Well-Known-Binary). Perhaps you may use the function "AsEWKT(geometry)" to give you the textual form you are used to?

r.b.

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of francesco
Sent: Friday, June 16, 2006 8:18 AM
To: PostGIS Users Discussion
Subject: [postgis-users] linux strange geometry columns

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 

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users