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

[Paul Ramsey]

You have a misconception. If it's a multipolygon in the shape file, it
will be a multipolygon in postgis.  When you open up the table view of
your file in ArcView, how many rows are devoted to Hawaii? One, or 27?

P

On Tue, May 27, 2008 at 1:23 PM, Andy Anderson <aanderson at amherst.edu> wrote:
> 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
>>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>