OSM2PGSQL(1) General Commands Manual OSM2PGSQL(1)
NAME
osm2pgsql - Openstreetmap data to PostgreSQL converter.
SYNOPSIS
osm2pgsql [options] planet.osm
osm2pgsql [options] planet.osm.{gz,bz2}
osm2pgsql [options] file1.osm file2.osm file3.osm
DESCRIPTION
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.
-r, --input-reader
Input frontend.
libxml2 - Parse XML using libxml2. (default)
primitive - Primitive XML parsing.
pbf - OSM binary format.
-O, --output
Output backend.
pgsql - Output to a PostGIS database. (default)
null - No output. Useful for testing.
-x, --extra-attributes
Include attributes for each object in the database.
This includes the username, userid, timestamp and version.
Note: this option also requires additional entries in your style file.
-k, --hstore
Generate an additional hstore (key/value) column to postgresql tables
-z, --hstore-column
Generate an additional hstore (key/value) column to containing all tags that start with the specified string, for example --hstore-
column "name:" will produce an extra hstore column that contains all name:xx tags
-G, --multi-geometry
Generate multi-geometry features in postgresql tables.
-K, --keep-coastlines
Keep coastline data rather than filtering it out.
By default natural=coastline tagged data will be discarded based on the assumption that post-processed Coastline Checker shapefiles
will be used.
-h, --help
Help information.
Add -vh to display supported projections.
Use -E to access any espg projections (usually in /usr/share/proj/epsg)
-v, --verbose
Verbose output.
SUPPORTED PROJECTIONS
Latlong (-l) SRS: 4326 (none)
WGS84 Mercator (-M) SRS: 3395 +proj=merc +datum=WGS84 +k=1.0 +units=m +over +no_defs
Spherical Mercator (-m) SRS:900913 +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null
+no_defs +over
SEE ALSO
proj(1), postgres(1).
AUTHOR
osm2pgsql was written by Jon Burgess and Artem Pavlenko.
This manual page was written by Andreas Putzo <andreas@putzo.net>, for the Debian project (but may be used by others).
May 26, 2009 OSM2PGSQL(1)