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

[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
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: transform-screen.doc
Type: application/msword
Size: 65536 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081009/f6cab351/attachment.doc>