[postgis-users] linux strange geometry columns

Stephen Woodbridge woodbri at swoodbridge.com
Fri Jun 16 05:41:11 PDT 2006


This is the new canonical form for geometries. Your linux server has a 
new version of postgis on it. If you want to see the old format then

select astext(the_geom) from ...

-Steve

francesco wrote:
> 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
> 




More information about the postgis-users mailing list