[postgis-users] issue with pgsql2shp

[strk at refractions.net]

Geometry collections are probably EMPTY geoms (collapsed geoms
that all fall in a single Grid cell). You can skip them filtering
with isEmpty().

--strk;

On Mon, Jun 05, 2006 at 01:03:08PM -0500, John Cole wrote:
> Strk,
>   I'm using the SnapToGrid on a polygon feature and it is returning
> multipolygon and geometrycollections which pgsql2shp doesn't seem to like.
> 
> Here is my query:
> 
> select geometrytype(snaptogrid(segmentize(transform(the_geom, 26916), 10),
> 250)) as the_geom from tgr_water_polygons
> 
> Is there a way to keep snaptogrid from returning geometrycollections?
> 
> Thanks,
> 
> John
> This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.