[postgis-users] Re: shp2pgsql (was "asKML")

[Andy Anderson]

Sorry, that subject line should have been "shp2pgsql". That question  
will come later, I'm sure! :-)

On May 27, 2008, at 4:20 PM, Andy Anderson wrote:

> I've been working around one minor issue and it occurred to me that  
> someone here might be able to explain the rationale for its design.
>
> I start with a shapefile of US states, which to me appears to be a  
> set of multipolygons, one for each state. So, for example, Hawaii is  
> a single multipolygon containing 27 polygons (at this scale).
>
> I then use shp2pgsql to produce a table of polygons, and Hawaii ends  
> up as 27 multipolygons each containing one polygon!
>
> Is there a good reason for this? Or do I have a misconception about  
> how Hawaii is being stored in the shapefile?
>
> Thanks,
>
> -- Andy
>