Skip to content

Instantly share code, notes, and snippets.

@springmeyer
Created April 30, 2012 04:24
Show Gist options
  • Save springmeyer/2555509 to your computer and use it in GitHub Desktop.
Save springmeyer/2555509 to your computer and use it in GitHub Desktop.
shapefile sanitization crosswalk from HOT export tool
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 1 column, instead of 3 in line 2.
# from http://hot-export.geofabrik.de/jobs/36
# http://hot-export.geofabrik.de/download/000044/extract.shp.zip
1,"osm_id","osm_id"
2,"z_order","z_order"
3,"way_area","way_area"
4,"addr:housename","addr_house"
5,"addr:interpolation","addr_inter"
6,"motorcar","motorcar"
7,"boundary","boundary"
8,"name","name"
9,"population","population"
10,"tunnel","tunnel"
11,"aerialway","aerialway"
12,"construction","constructi"
13,"highway","highway"
14,"width","width"
15,"embankment","embankment"
16,"junction","junction"
17,"lock","lock"
18,"access","access"
19,"addr:housenumber","addr_hou_1"
20,"admin_level","admin_leve"
21,"denomination","denominati"
22,"generator:source","generator_"
23,"railway","railway"
24,"covered","covered"
25,"layer","layer"
26,"route","route"
27,"surface","surface"
28,"barrier","barrier"
29,"tracktype","tracktype"
30,"wood","wood"
31,"cutting","cutting"
32,"disused","disused"
33,"bridge","bridge"
34,"oneway","oneway"
35,"ref","ref"
36,"service","service"
37,"foot","foot"
38,"toll","toll"
39,"tower:type","tower_type"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment