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: [email protected] [mailto:[email protected]] 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 <[email protected]>: > 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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
