Osm2pgsql
Aus Geoinformation HSR
Version vom 23. Juli 2011, 13:29 Uhr von Stefan (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „Einer der beliebtesten "OSM-Daten zu PostgreSQL/PostGIS-DB" Converter und Loader. (Autor: jburgess777(at)googlemail.com). Siehe auch OSM Technisches und [[P…“)
Einer der beliebtesten "OSM-Daten zu PostgreSQL/PostGIS-DB" Converter und Loader. (Autor: jburgess777(at)googlemail.com).
Siehe auch OSM Technisches und PostGIS-Terminal.
osm2pgsql is mainly written for rendering data with data. So it only imports tags which are going to be useful for rendering. These tags are defined in the file 'default.style' (svn, trac). It also manipulates data for mapnik (i.e. placing nodes in the centre of gravity of polygons).
Installation
- Install PostgreSQL and PostGIS and create a postgres user with the same name as your system username (the utility explained next connects always with the default user name).
- Create a database and add hstore (and intarray) support.
- Get osm2pgsql
- Get http://svn.openstreetmap.org/applications/utils/export/osm2pgsql/default.style since this is currently left out in the osm2pgsql delivery.
- Download OSM dump - See Planet.osm for mirrors and partial extracts.
- Download OpenJUMP from http://www.openjump.org. Nightly build is recommended.
- run osm2pgsql like this:
> osm2pgsql -d <pg_database> --hstore <osmdumpname.osm> or > osm2pgsql -c -d liechtenstein -U postgres -W -H localhost -P 5432 -s -k -x -p osm -S default.style ..\liechtenstein.osm.bz2
- Everything will be automatic after that and the result is ready-to-use PostGIS tables '_point', '_line' and '_polygon' containing OSM data.
Output Database
Original-Dokumentation der Schemata von OSM und Osm2pgsql:
- osm2pgsql schema: osm2pgsql Schema (default.style)
- Original OSM schema: pgsnapshot_schema_0.6
- Artikel zum Laden von OSM Daten, "Loading OpenStreetMap data into PostGIS: An Almost Idiot's Guide": [1]
Overview with notes on the Osm2pgsql output schema (default.style):
- Table group 'OSM original'
- osm_nodes:
- osm_ways:
- osm_rels:
- Table group 'Osm2pgsql':
- osm_point: with point geometry
- osm_line: with polyline geometry
- osm_polygon: with polygon geometry (one of the unique features of Osm2pgsql!
- osm_roads: a special table with polyline geometry