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.
-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)
-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