[postgis-users] KML: unix vs windows

[Laurens Jansen]

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 <laurens at pz.nl>:
> Hi Regina
>
> 2010/1/18 Paragon Corporation <lr at pcorp.us>:
>> 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: 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
>>>
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>