[Talk-ca] GeoBase PostGIS & OpenStreetMap

[Steve Singer]

5~On Fri, 5 Dec 2008, Sam Vekemans wrote:

> aware.  We just have to ask the right questions. :)
>
> So from your idea i got:
> 1. Merging the OSM reference id# database (our big Canada file) with the
> GeoBase dataset onto a separate PostGIS database.

Yes

> 2. Purging the results of close lines/nodes. (street names maybe?) ...
> creating a GeoBase/OSM database. Where it just looks for that, and removes
> the extra OSM stuff that it doesnt need.

I'm not sure I would 'purge' but generate a mapping of geobase id's to 
existing OSM ways.  We could then take that mapping and add

1. Add the geobase id to    the real osm database along with any other 
geobase tags we like
2. Exclude those nodes from the bulk import of the rest of the geobase data.


> 3. Then importing it back to OSM.  .. purging it with the original OSM Id's.
> Am i following that right?

I would not try to reimport OSM nodes from the spatial database back into 
OSM, just update/add tags if required.

>
> Cheers,
> Sam
>

Steve