On Tue, Nov 17, 2009 at 3:34 PM, Anthony <[email protected]> wrote: > On Tue, Nov 17, 2009 at 3:18 PM, Anthony <[email protected]> wrote: >> On Tue, Nov 17, 2009 at 3:10 PM, Ian Dees <[email protected]> wrote: >>> Ah, so this is only removing duplicate nodes and not creating boundary >>> relations out of exactly-overlapping ways. >> >> I have some sql that can do this for property parcels. Only works >> with simple polygons (not multipolygons) at the moment, and it's not >> well documented, but I'll put it up on the wiki. >> > > http://wiki.openstreetmap.org/wiki/User:%E2%A0%A0%E2%A0%81%E2%A0%9D%E2%A0%9E%E2%A0%93%E2%A0%95%E2%A0%9D%E2%A0%BD/SQL > http://wiki.openstreetmap.org/wiki/User:%E2%A0%A0%E2%A0%81%E2%A0%9D%E2%A0%9E%E2%A0%93%E2%A0%95%E2%A0%9D%E2%A0%BD/Perl > > If anyone would like to convert that into something generally useful, > it'd be much appreciated. > Oh yeah. Warning. It uses the "window function" rank(), which means Postgresql 8.4 or higher.
_______________________________________________ Imports mailing list [email protected] http://lists.openstreetmap.org/listinfo/imports
