This manual page documents briefly the
osm2pgsql
command.
osm2pgsql
imports data from OSM file(s) into a PostgreSQL database
suitable for use by the Mapnik renderer.
OSM planet snapshots can be downloaded from http://planet.openstreetmap.org
OPTIONS
These programs follow the usual GNU command line syntax, with long
options starting with two dashes (`-').
A summary of options is included below.
-a|--append
Add the OSM file into the database without removing
existing data.
-b|--bbox
Apply a bounding box filter on the imported data
Must be specified as: minlon,minlat,maxlon,maxlat
e.g. --bbox-0.5,51.25,0.5,51.75
-c|--create
Remove existing data from the database. This is the
default if --append is not specified.
-d|--database
The name of the PostgreSQL database to connect
to (default: gis).
-l|--latlong
Store data in degrees of latitude & longitude.
-m|--merc
Store data in proper spherical mercator (default)
-M|--oldmerc
Store data in the legay OSM mercator format
-E|--proj num
Use projection EPSG:num
-u|--utf8-sanitize
Repair bad UTF8 input data (present in planet
dumps prior to August 2007). Adds about 10% overhead.
-p|--prefix
Prefix for table names (default planet_osm)
-s|--slim
Store temorary data in the database. This greatly reduces the RAM usage but is much slower.
-S|--style
Location of the style file. Default to /usr/share/osm2pgsql/default.style
-C|--cache
Only for slim mode: Use up to this this many MB for caching nodes. Default is 800MB.
-U|--username
Postgresql user name.
-W|--password
Force password prompt.
-H|--host
Database server hostname or socket location.
-P|--port
Database server port.
-e|--expire-tiles [min_zoom-]max_zoom
Create a tile expiry list.
-o|--expire-output filename
Output filename for expired tiles list.
-O|--output
Output backend.
pgsql - Output to a PostGIS database. (default)
null - No output. Useful for testing.
-h|--help
Help information.
Add -vh to display supported projections.
Use -E to access any espg projections (usually in /usr/share/proj/epsg)