[postgis-users] KML: unix vs windows

[Paragon Corporation]

Laurens,

Not sure you are following this thread.

http://trac.osgeo.org/postgis/ticket/387

I checked and noticed the spatial_ref_sys records for 28992 are different on
1.36 and 1.4.1/1.5 installs (my answers on Linux behave the same way as
windows so I don't think its a packaging problem)

So if you like the 1.3.6 answer better -- updating the proj4text to the one
in 1.3.6 might do the trick.  Though I suspect that may not be the right
solution since I have no clue which is right or if one is designed for a
newer proj library.


Hope that helps,
Regina 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Laurens
Jansen
Sent: Monday, January 18, 2010 12:37 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] KML: unix vs windows

Hi Vincent,

Enclosed i added a sample sql.dump of the table; i think u should be able to
restore etc and run some tests?

regards laurens

2010/1/18 Picavet Vincent <Vincent.Picavet at mediapost.fr>:
> Hello Laurens,
>
>> 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
>
> Could you please post a fully self contained example ? Something with 
> the geometry itself inside the query, so that I can execute your query 
> on my own ? I've got several windows boxes with various flavours of 
> windows, postgresql and postgis installed and can test this strange 
> behaviour if you give me a working query without prerequisite.
>
> Thanks,
> Vincent
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>