[postgis-users] KML: unix vs windows

Laurens Jansen laurens at pz.nl
Sun Jan 17 06:14:52 PST 2010


Hi,
when i use the asKML functions on a Postgis-UNIX machine I get the a
fine and correct KML layer in return. Doing the same on a
Postgis-Windows machine, the KML layer is incorrect; the coordinates
on the windows differ from those in the Unix machine (see KML file
below); those on the Unix machine are the right points on the map ....
Anyone experienced same behavior? The Postgresql versions differ a lil
bit; where using 8.2.13 on the Unix (FreeBSD) machine compared to the
8.4.1 on the Windows (2003 server) machine, but since the Unix machine
is giving the correct results i dont think its a postgresql version
problem. We have updated GDAL and PROJ to the latest versions on the
windows machine, still we experience the problems ....
Regards laurens

SQL:
SELECT asKML(the_geom) FROM table WHERE gid = 1

on a Unix machine:
<MultiGeometry>
  <Polygon>
   <outerBoundaryIs>
     <LinearRing>
        <coordinates>
           4.89123288936406,52.3373804303248,0
           4.89118534786195,52.3374077015756,0
           etc etc

on the Windows machine
<MultiGeometry>
   <Polygon>
     <outerBoundaryIs>
       <LinearRing>
         <coordinates>
            4.891594203993788,52.338389215425934,0
            4.891546655317309,52.338416489781068,0



More information about the postgis-users mailing list