[postgis-users] [!! SPAM] multipolygon to single polygon

ju julien.guilloux at ecrins-parcnational.fr
Thu Apr 26 08:02:22 PDT 2012

not clear...

1) if you have 4 polygons in 4 rows table distinct, this is not a multi 
object issu. for  this case use
  dissolve to group polygone into only one, this is not a topic of dump.

2) if you have 1 geometry and 1 row on the tablme, so this is a multi 
object topic
you must sperate the differents objet of the collection

here : http://www.postgis.org/docs/ST_GeometryN.html

--Extracting all geometries (useful when you want to assign an id)
SELECT gid, n, ST_GeometryN(the_geom, n)
FROM sometable CROSS JOIN generate_series(1,100) n
WHERE n<= ST_NumGeometries(the_geom);

best regards, julien

Le 26/04/2012 16:27, Mehmet Erkek a écrit :
> I have multipolygons which I would like to convert a single polygon. 
> is there a way to do this? please check the attached image. I tried 
> st_dump and afterwards st_union , but eventually I get a multipolygon 
> again, not polygon.
> *Mehmet Erkek***
> www.REIDIN.com <http://www.reidin.com/>
> This message is for the designated recipient only and may contain 
> privileged, proprietary, or otherwise private information. If you have 
> received it in error, please notify the sender immediately and delete 
> the original. Any other use of the email by you is prohibited. Please 
> Consider the Environment Before Printing This Email
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

Julien-Pierre Guilloux
Service scientifique - Géomatique
Parc National des Ecrins
Domaine de Charance
05 000 GAP
tél :
fax :
julien.guilloux at ecrins-parcnational.fr

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120426/1458f28e/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 11627 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120426/1458f28e/attachment.png>

More information about the postgis-users mailing list