[Imports] [Talk-ca] Shp2OSM : various questions

[Anthony]

On Tue, Nov 17, 2009 at 3:34 PM, Anthony <osm at inbox.org> wrote:
> On Tue, Nov 17, 2009 at 3:18 PM, Anthony <osm at inbox.org> wrote:
>> On Tue, Nov 17, 2009 at 3:10 PM, Ian Dees <ian.dees at gmail.com> 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.