PostGISとOsmosisセットアップめも

gistfile1.sh

wget http://bretth.dev.openstreetmap.org/osmosis-build/osmosis-latest.zip
unzip osmosis-latest.zip
chmod +x osmosis-0.41/bin/osmosis
sudo -u postgres
createuser osm
createdb osm
psql -U osm -c 'CREATE EXTENSION hstore'
psql -U osm < /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql
psql -U osm < /usr/share/postgresql/9.1/contrib/postgis-1.5/spatial_ref_sys.sql
psql -U osm < ./osmosis-0.41/script/pgsnapshot_schema_0.6.sql
psql -U osm < ./osmosis-0.41/script/pgsnapshot_schema_0.6_action.sql
psql -U osm < ./osmosis-0.41/script/pgsnapshot_schema_0.6_bbox.sql
psql -U osm < ./osmosis-0.41/script/pgsnapshot_schema_0.6_linestring.sql
exit
wget http://planet.openstreetmap.org/pbf/planet-latest.osm.pbf
./osmosis-0.41/bin/osmosis -v --rbf file=planet-latest.osm.pbf workers=4 --bp file=382313.poly --wp password=***