osm download†

左下と右上の点を box で指定

wget 'http://api.openstreetmap.org/api/0.6/map?bbox=140.617126,42.841655,140.710510,42.894497' -O niseko.osm

osm2postgres†

download cygwin version†

http://wiki.openstreetmap.org/wiki/Osm2pgsql#Windows

準備†

create database osm;
\c osm
create extension postgis;

実行†

osm2pgsql-bin/osm2pgsql.exe niseko.osm -U postgres -H localhost -d osm -S osm2pgsql-bin/default.style

table†

osm_id で紐付ける

download†

特定範囲の osm データを取得する

wget -O zao.osm "http://api.openstreetmap.org/api/0.6/map?bbox=140.375856,38.140679,140.438684,38.176313"

取り込み†

create database zao;
\c zao
create extension postgis;
create extension pgrouting;
create extension hstore;

osm2pgsql zao.osm --number-processes 1 -k -s -U postgres -H localhost -P 35432 -d zao -W

日本全国†

osm2pgsql -U postgres -C 2400 -k -c -d japan -S /usr/local/share/osm2pgsql/default.style  japan-latest.osm.pbf

pgrouting†

select pgr_dijkstra( 'select  * from edge' , 242920053, 242920117);