[postgis-users] KML: unix vs windows

[Olivier Courtin]

On Jan 18, 2010, at 10:09 AM, Laurens Jansen wrote:

Hi Laurens,

> ad 2. The ST_AsGeoJson results set differ also:
>
> SELECT ST_AsGeoJson(the_geom) FROM table WHERE gid=1
> Unix:
> "{"type":"MultiPolygon","coordinates":[[[
> [121197.452000000019325,483388.473999999987427,0.000000000000000],
> [121194.232643363691750,483391.530431554128882,0.000000000000000],
> Windows:
> "{"type":"MultiPolygon","coordinates":[[[
> [121197.45200000002,483388.47399999999,0],
> [121194.23264336369,483391.53043155413,0]


Yes there's differences, but they're really smalls,
and not really meaningfull.



> ad 3 the result sets for tthe transform functions
>
> SELECT ST_AsEWKT(ST_Transform(the_geom, 4326)) FROM table WHERE gid=1
> Unix:
> "SRID=4326;MULTIPOLYGON(((
> 4.89123288936406 52.3373804303248 0 0,
> 4.89118534786195 52.3374077015756 0 0,
> Windows:
> "SRID=4326;MULTIPOLYGON(((
> 4.89159420399379 52.3383892154259 0 0,
> 4.89154665531731 52.3384164897811 0 0,
>
> Iam also building a PostgreSQL with PostGIS 1.3 on a Windows machine,
> and wil check resultset against that configuration.

Ok this one really differ !
So it's look like ST_Transform doesn't return the same decimal
value upon platforms.

Do you have the ability to update on both plaforms  PostGIS
version to 1.5.0 branch, and check again ?

Unix:          <http://postgis.org/download/postgis-1.5.0b2.tar.gz>
Windows:  <http://postgis.refractions.net/download/windows/experimental.php 
 >


Tks in advance !

--
Olivier