<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">Wow Martijn.<div><br></div><div>Thank you SO much. It seems to have worked. This will get a lot of use, I think. You really should get it into PostGIS as a function, for better visibility and for the benefit of the world. </div><div><br></div><div>I can’t wait to try it on one of my larger problems (e.g. a cadastral data set with about 2 million parcels).</div><div><br></div><div>For everyone else, here’s the paper: <a href="http://www.gdmc.nl/ken/files/12_pfg.pdf">http://www.gdmc.nl/ken/files/12_pfg.pdf</a></div><div><br></div><div><div apple-content-edited="true">
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div>--</div><div>John Abraham</div><div><a href="mailto:jea@hbaspecto.com">jea@hbaspecto.com</a></div><div>403-232-1060</div></span>
</div>
<br><div><div>On Oct 3, 2014, at 1:23 PM, Martijn Meijers <<a href="mailto:b.m.meijers@tudelft.nl">b.m.meijers@tudelft.nl</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">Hi John,<br><br>We know the pain you describe.<br><br>For this we've developed at our research group:<br><br> * <a href="https://github.com/tudelft-gist/pprepair">https://github.com/tudelft-gist/pprepair</a><br><br>Documentation here:<br><br> * <a href="http://tudelft-gist.github.io/pprepair/">http://tudelft-gist.github.io/pprepair/</a><br><br>Not integrated with PostGIS at the moment and only reading shapefiles, but it should clean exactly the type of data that you describe into properly noded polygons (with gaps and overlaps removed/filled).<br><br><br>Martijn<br><br>-- <br>Martijn Meijers<br><br><a href="mailto:b.m.meijers@tudelft.nl">mailto:b.m.meijers@tudelft.nl</a><br>http://www.gdmc.nl/martijn<br><br>GIS-technology<br>Faculty of Architecture and the Built Environment<br>Delft University of Technology<br><br>P.O. Box 5030 | Julianalaan 134 (building 8), room 01.oost.330<br>2600 GA Delft | 2628 BL Delft<br>The Netherlands<br><br>tel (+31) 15 2785642<br><br></blockquote></div><br></div></body></html>