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

[Luigi Castro Cardeles]

Hi,

maybe this is some type of bug from pgadmin3. sometimes it did not show the
contents of the_geom column.

if your analyse of empty geometry is only at pgadmin so you are wrong and
your the_geom columns are not empty (select gid, the_geom from city where
the_geom is null returns nothing;).
try using psql to see some geometry.

best regards,

2008/10/10 <cyw at dls.net>

> See attached. I viewed it fom PgAdmin UI.  Did the queries you suggested,
> the_geom was not NULL.
>
> The sql below returns nothing:
>             select gid, the_geom from city where the_geom is null;
>
> The sql below returns npoints = 218:
>   select gid, npoints(the_geom) from city where polygon_id=35665106;
>
> Thanks,
> CYW
>
> ----- 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:12 PM
> Subject: Re: [postgis-users] TRANSFORM failures with some multiploygons -
> datasample attached
>
>
>  It ran without any error. But some of the resulted values in the_geom
>>>> column became null or empty.
>>>>
>>>
>> How did you check this?
>>
>> select gid from thetable where the_geom is null?
>> select gid from thetabel where npoints(the_geom) =
>>
>> P
>> _______________________________________________
>> 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
>
>


-- 
Luigi Castro Cardeles
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081010/6fe64c92/attachment.html>