[OSGeo Africa] Question on PostGIS

[Charles Rethman]

Hello PostGIS experts out there, I have a technical question for you all...

I need to effect 'clips' in PostGIS and I have tried using ST_Difference. I got very messy outputs and then I read in the PostGis Manual the the function doesn't work with Collections. In importing my shape file data into PostGIS, I created multi-polygon geometries--so I presume that is why the ST_Difference function won't give me sensible results.

Is there a function or a way in PostGIS of converting multi-polygons into single polygons (a kind of 'explode' function) so that I don't have to re-import all my shape files (I really HATE those old shape files!)

I am using PostGIS 2.1 on postgres 9.3...

Thank you for your time,

Charles Rethman
Director, Cape Town Office

Cell: +27 71 6735502
Tel: +27 21 6861510
Skype: cwrethman
PO Box 23507, Claremont, 7735, South Africa
19 Sans Souci Road, Newlands, 7700, Cape Town


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/africa/attachments/20140314/561b4938/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: email footer13x5.png
Type: image/png
Size: 42448 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/africa/attachments/20140314/561b4938/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 495 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.osgeo.org/pipermail/africa/attachments/20140314/561b4938/attachment-0001.pgp>