[Talk-ca] Port Stanley Ontario geobase conversion uploaded

[John Peterson]

I've been working on merging the 040I11 section of Ontario near Port
Stanley.  This is now uploaded and Osmarender has rendered tiles.  You can
try the following link:
http://www.openstreetmap.org/?lat=42.6678&lon=-81.21645&zoom=14

The roads with no name are the ones uploaded from GeoBase.  I've also tried
to merge in data to existing ways, including lanes, surface, bridge, layer
and geobase:uuid (often a list).  I didn't machine revise any nodes, or
split any ways that already existed.  I think those operations need a human
looking at them.

Please take a look.

I don't have a solution for the many-to-many relationship between osm ways
and geobase ways.  For now I've left the existing osm way and attached a
list of geobase uuids.  If you can show me a better method, I'll switch to
it.

I also left the new uploaded roads with the types derived from GeoBase.
Sometimes this means adjacent ways of the same road are coded differently.

I did this partially manually and partially scripted -- my scripts are very
much a work in progress, mostly cobbling together parts from others.  I
used:

0) fix up existing roads that are really badly aligned.
1) geobase2osm -- make a bounding box and an original extract from geobase
2) xapi download to get a matching extract from osm
3) homebrew osm intersection splitter so roadmatcher matches better
4) osm2gml and cut and past to make .jml files for roadmatcher
5) zip to create a roadmatcher source package
6) roadmatcher autoconflate
7) roadmatcher exportresults
8) unzip Result.shp
9) shp2text to extract the columns I need in xml form
10) homebrew scripts to create standalone, matched, and unknown files from
the geobase original
11) bulk_upload.pl to upload the new alone sections
12) mercaartor and an osm import file with nodes at each alone/matched
junction, manually stitch together the maps using the nodes as a guide
13) repeat to find more standalone roads (the match gets better as there are
more junctions for roadmatcher).
14) homebrew script to find matched bridges and upload them
15) mercaartor to manually merge the bridges into existing ways
16) homebrew script to merge attributes from the geobase matched file into
the osm original.
17) script to drive curl for automated update (very ugly -- there must be a
better way).

This is still too manual for large areas, and I don't have the answer for
fully automating the original fixup step, the stitch together step or the
bridges step.

John Peterson