[postgis-users] exterior rings in multipolygons

[Sandro Santilli]

On Wed, Jul 27, 2011 at 12:01:23AM -0500, Mr. Puneet Kishor wrote:
> 
> On Jul 26, 2011, at 7:53 PM, Ben Madin wrote:
> 
> > Maybe you could share the polygon - does it pass tests like st_isvalid()?
> 
> it does pass the ST_IsValid() test with flying colors, but the truth is... the entire poly never got imported. So, from ArcMap, I exported poly id 280 to a shapefile. Then I opened that shapefile in QGIS, and overlaid the same poly from the Pg table. See the attached image. The orange line is the poly 280 from Pg, and the green solid is the same poly 280 from the shapefile. Most of the poly is missing in the Pg version.
> 
> The shapefile can be downloaded from http://dl.dropbox.com/u/3526821/280.zip

That zipfile imports as 2 distinct polygons here [1],
giving the whole point set

$Id: shp2pgsql-core.h 5646 2010-05-27 13:19:12Z pramsey $

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html