[postgis-users] TRANSFORM failures with some multiploygons - datasample attached

[cyw at dls.net]

postgis_full_version
POSTGIS="1.3.3" GEOS="3.0.0-CAPI-1.4.1" PROJ="Rel. 4.6.0, 21 Dec 2007" 
USE_STATS

----- Original Message ----- 
From: "Paul Ramsey" <pramsey at cleverelephant.ca>
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Sent: Thursday, October 09, 2008 10:09 PM
Subject: Re: [postgis-users] TRANSFORM failures with some multiploygons - 
datasample attached


> I'm not seeing this problem on your polygon. What does
>
> select postgis_full_version()
>
> say?
>
> On Thu, Oct 9, 2008 at 7:56 PM,  <cyw at dls.net> wrote:
>> Hi All,
>>
>> In debugging the problem below, I found that TRANSFORM would fail with 
>> some
>> of my city multipolygons.
>>
>> I would think that the TRANSFORM function should be independent of the 
>> shape
>> or complexity of the polygons or lines.
>>
>> Attached is one of the city multipolygons that failed the TRANSFORM
>> function.
>>
>> Thanks,
>> CYW
>>
>>
>> ----- Original Message ----- From: <cyw at dls.net>
>> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
>> Sent: Thursday, October 09, 2008 8:13 PM
>> Subject: [postgis-users] transform - update lake
>> setthe_geom=transform(the_geom, 26971)
>>
>>
>>> I have a table city which contains Multipolygons (SRID=4326) in latitude
>>> and longitude. To project it to  a plane coordinate (SRID=26971), I did:
>>>
>>>   update lake set the_geom=transform(the_geom, 26971);
>>>
>>> It ran without any error. But some of the resulted values in the_geom
>>> column became null or empty.
>>>
>>> Any hitnts why it did this?
>>>
>>> Before the transformation, I viewed the table with QuantumGIS, it looked
>>> OK. Afterwards, QuantumGIS showed nothing.
>>>
>>> Thanks,
>>> CYW
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> 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
>>
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>