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

Michael Fuhr mike at fuhr.org
Fri Nov 3 07:27:47 PST 2006

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

More information about the postgis-users mailing list