[postgis-users] Re: How to fix not valid polygons

[Stephen Woodbridge]

Amit Kulkarni wrote:
> I did it inside a traditional GIS and then dump/import to PostGIS.
> 
> ArcGIS has a 'Explode Multi-part' feature. I wrote some VBA code, and
> exploded lines (trivial change for polygons I believe) were marked with
> a comment. I unfortunately don't have the code because the laptop
> crashed, a BSOD.
> 
> But, the other developers may have a better solution.

Amit,
Thank you for the suggestion. I don't have ArcGIS and was hoping to do 
this in postGIS.

List,
Is it possible to deconstruct geometry (polygons specifically) short of 
hacking up the AsText() string representation of them?

-Steve

> -------------------------------------
> 
> Anyway, is this the best approach? Do you see problems with this 
> approach? What are my other options? getting good polygons to start
> with does not appear to be an option at this point.