[postgis-users] KML: unix vs windows

[Laurens Jansen]

Hi Oliver,

2010/1/18 Olivier Courtin <olivier.courtin at oslandia.com>:
>
> 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>
>
As for upgrading our Unix platform it will take me some more time
cause i am working against one off the main test and developing
machines and i don't want to upgrade the PostGIS libraries on that
machine.
The Windows machine Ive updated the PostGIS to the 1.5 branch

SELECT postgis_full_version()
"POSTGIS="1.5.0SVN" GEOS="3.2.0-CAPI-1.6.0" PROJ="Rel. 4.6.1, 21
August 2008" LIBXML="2.7.6" USE_STATS"

Unfortunately i still get the same result set:

SELECT asKML(the_geom) FROM table WHERE gid = 1
"<MultiGeometry>
  <Polygon>
    <outerBoundaryIs>
      <LinearRing>
      <coordinates>
         4.891594203993788,52.338389215425934,0
         4.891546655317309,52.338416489781068,0
         etc etc"

In the mean time the Windows 2008 PostgreSQL configuration with a
PostGIS 1.3 version does indeed give back a better result set and a
proper display of the KML-layers on the map; at least that gives us
some alternatives for our client who seems to insist on a Windows
hosting ....

I will get back on the Unix PostGIS1.5 as soon as possible

Regards Laurens

>
> Tks in advance !
>
> --
> Olivier
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>