[postgis-users] KML: unix vs windows

Laurens Jansen laurens at pz.nl
Sun Jan 17 14:21:55 PST 2010


Hi Oliver,

thanks for your response;

ad 1: as_EKWKT? Hmm .. i can't find that function in the postgis
functions, perhaps u mean 'asewkt'? A select with that function does
give tha same result sets on both platforms:
SELECT asEWKT(the_geom) FROM table WHERE gid = 1
results UNIX
"SRID=28992;MULTIPOLYGON(((121197.452 483388.474 0 0,121194.232643364
483391.530431554 0
etc etc
results Windows
"SRID=28992;MULTIPOLYGON(((121197.452 483388.474 0 0,121194.232643364
483391.530431554 0
etc etc

ad 2. SELECT postgis_full_version()
UNIX
"POSTGIS="1.3.6" GEOS="3.0.0-CAPI-1.4.1" PROJ="Rel. 4.6.1, 21 August
2008" USE_STATS"
Windows
"POSTGIS="1.4.1" GEOS="3.2.0-CAPI-1.6.0" PROJ="Rel. 4.6.1, 21 August
2008" USE_STATS"

ad 3 Our Unix platform is 32 bits, we encountered the problems on the
Windows machine on both 32 and 64 bits systems; both gave a wrong
result set with the asKML functions ...

Regards Laurens

2010/1/17 Olivier Courtin <olivier.courtin at oslandia.com>:
>
> On Jan 17, 2010, at 3:14 PM, Laurens Jansen wrote:
>
> Hi Laurens,
>
>> 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
>
> Thanks for this report, could you send:
> - As_EKWKT result (from the same points)
> - SELECT postgis_full_version()     result
> - if your Unix platform is 32 or 64 bits
>
> Tks,
>
> --
> Olivier
>
>
>
>
>
>
> _______________________________________________
> 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