[OSM-dev] TIGER import.rb

Dave Hansen dave at sr71.net
Wed Jun 13 16:25:50 BST 2007

I've hacked up the tiger import code a bit.  Instead of having it upload
to osm directly, I decided to have it produce .osm files that JOSM could
open.  I bet this might be a good approach in the future for other
people, too.  It allows you to make sure that the map "looks right", and
to run things like the JOSM validator plugin on it. At this point, the
only validator warnings that it produces are for untagged and unnamed
ways.  I need to verify that the TIGER db even _has_ names for these. 

I've also created a couple of ruby classes to make handing the node,
segment, and way classes a bit easier.  This is my first coding in ruby,
ever, so please be gentle. :)

The node creation code will detect close nodes and merge them.  This
uses raw lat/lon and pretends they're actual distance units for now.
I'm sure this can be easily fixed up to use real distances

This will create ordered ways, and will coalesce all adjacent ways with
the same name into a single way.  It will flip segments and ways as
necessary to make them fit.  I had some performance problems with this,
but I feel like it's running at a workable speed now.

One last thing...  Do we really need the mysql database?  After
importing a single zip code, the database only looks to me to be ~2MB.
I also don't see any SELECT statements which look too horribly complex.
Any chance we could just build the DB's contents in-memory?  We'd be
left with scripts that take TIGER .zip files and produce .osms.  We
could post those individually somewhere and have people familiar with
the area go over them before actually uploading them.  

-- Dave

-------------- next part --------------
A non-text attachment was scrubbed...
Name: dave-import.rb
Type: application/x-ruby
Size: 12906 bytes
Desc: not available
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20070613/48668174/attachment.rb>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: imort.diff
Type: text/x-patch
Size: 11000 bytes
Desc: not available
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20070613/48668174/attachment.bin>

More information about the dev mailing list