How split a MultiPolygon in singles Polygon

272 views
Skip to first unread message

Andrea P.

unread,
Sep 4, 2011, 5:42:27 AM9/4/11
to SpatiaLite Users
Hi,
I have a dataset of multipolygons.

I'm searching a solution to obtain a dataset of single polygons.

This mean pass from a table of 10 records (every geom multipolygon has
almost 2 polygons part,
to a new table of almost 20+ records.

I see the option CastToSingle(geom),
but it simply return NULL if the MultiPolygon has more then 1 part.

Thx,
Andrea.

Andrea P.

unread,
Sep 4, 2011, 5:58:50 AM9/4/11
to SpatiaLite Users
Hi,
I found this thread.
http://groups.google.com/group/spatialite-users/browse_thread/thread/4b8c15cf4dfb4ada/f1239c44d01b221c?fwc=1

It respond clearly to my question.

Regards,
Reply all
Reply to author
Forward
0 new messages