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†
planet_osm_line | 線形状なもの |
planet_osm_point | 点 |
planet_osm_polygon | 面形状のもの(たまに点のものがrectになって登録されてるので注意) |
planet_osm_roads | 道路 |
osm_id で紐付ける
planet_osm_ways | id,nodes,tags |
planet_osm_rels | id,way,rel,pants |
planet_osm_nodes | id,lat,lng |
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);