extract-all-osm-roads.txt

Loading OSM Planet into Postgres and then extracting InaSAFE style roads

wget -c ftp://ftp.spline.de/pub/openstreetmap/pbf/planet-latest.osm.pbf



createdb -T template_postgis osm


echo "# Latest osm tools" >> /etc/apt/sources/list
echo "deb http://ppa.launchpad.net/kakrueger/openstreetmap/ubuntu precise main" >> /etc/apt/sources/list

apt-get update

apt-get install osm2pgsql

osm2pgsql -s -S /usr/share/osm2pgsql/default.style -c -l -d osm /tmp/planet-latest.osm.pbf

psql -f <path-to-osm-reporter>/resources/roads.sql osm


pgsql2shp -f osm-roads.shp osm "SELECT st_transform(way, 4326) AS the_geom, name, highway as osm_type, type FROM planet_osm_line WHERE highway != 'no';"

tar cfj osm-roads.tar.bz2 osm-roads.*