[postgis-users] gpc - shp2psql - polygon/multipolygon

[Paul Ramsey]

update thetable set the_geom = geometryn(the_geom,0);

Takes the first element of every multipolygon and uses that as the new
geometry. 

"Robert W. Burgholzer" wrote:
> 
> OK,
> So far so good with the install of scot_gpc stuff. Compile and install went
> fine.
> 
> My question is, all my tables are imported using shp2pgsql, and all fields end
> up as multipolygons, even simple rectangles. scot_gpc doesn't handle these as
> of now. Is there any switch to force polygon creation, or does anyone know of
> a way to do a cast or conversion of some sort?
> 
> Now, I am not averse to trying to help out and making it capable of handling
> multi-polygons, although I am a bit low on the learning curve right now, but
> I'll start looking at it.
> 
> If anyone has any suggestions as to how to get some polygons out of
> multipolygons, please share.
> 
> rob
> 
> >===== Original Message From Nicolas Ribot <nicolas.ribot at scot.cnes.fr> =====
> >Hi Robert,
> >
> >I opened the thread concerning GPC to get some help about postgis C
> >interface...
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 
      __
     /
     | Paul Ramsey
     | Refractions Research
     | Email: pramsey at refractions.net
     | Phone: (250) 885-0632
     \_