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

[Andy Anderson]

Re: "You have a misconception.  If it's a multipolygon in the shape  
file, it will be a multipolygon in postgis. "

No misconception in that regard. The issue was that I expected there  
to be a one-to-one feature correspondence, and it appeared that there  
wasn't.

But digging further back in my work process, I did figure out the  
issue. At one point I switched shapefiles from an ESRI-provided one to  
a US Census-provided one, and the latter does actually have the state  
polygons exploded into separate features. (Perhaps that's to allow it  
work with less-sophisticated software, including older Arc versions.)

-- Andy

On May 27, 2008, at 5:26 PM, Paul Ramsey wrote:

> 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
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users