[postgis-users] Not able to excute spatial query on postgresql database with postgis support

[Michael Fuhr]

On Wed, Nov 01, 2006 at 11:11:33AM -0600, vamsee movva wrote:
> SELECT getbbox(the_geom) FROM la_blocks WHERE stfid = '220750501002999';
>                                  getbbox
> ----------------------------------------------------------------------------
> BOX(-89.5361709594727 28.8551273345947,-88.8792343139648 29.6479110717773)
> (1 row)
> 
> I think, the number of rings is the problem

This geometry sits over part of Plaquemines Parish, which makes
sense since that Parish's FIPS code is 22075.  Plaquemines Parish
has a lot of water so I'm wondering if the rings represent land/water
boundaries.  Do you know if that's the case?  Is that relevant to
your needs?  Might you be able to use only the exterior ring,
possibly simplified?

-- 
Michael Fuhr