Hi again, with the updated spatial_ref on SRID:28992 i get the same answer from the query on the Win32 system. Many thanks for all your help!
greeting Laurens 2010/1/18 Laurens Jansen <[email protected]>: > Hi Regina > > 2010/1/18 Paragon Corporation <[email protected]>: >> Laurens, >> >> Not sure you are following this thread. >> >> http://trac.osgeo.org/postgis/ticket/387 >> > I am following the thread, but was also trying to get meself some to eat ...:P > >> 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. >> >> > I will try to update tha spatial_ref for the 28992 records; dunno > which is better also, but since the 1.3.6-answer are the ones that > seems be right i asume they are somehow more correct ... > >> Hope that helps, > > I will let u know >> Regina >> > Regards Laurens >> -----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 >> > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
