[OSM-talk] Using osm2pgsql can I import into postgres in a projection other than Spherical Mercator (epsg:900913) like wgs84 (epsg:4326)
John Mitchell
mitchelljj98 at gmail.com
Thu Oct 1 23:35:13 BST 2009
Thanks,
For the below information it noted that:
*This will import the data from the OSM file(s) into a PostgreSQL database
suitable for use by the Mapnik renderer*
I am assuming that this command will also work correctly if my renderer is
instead geoserver since I already have been using geoserver I would prefer
to use it instead of Mapnik.
On Thu, Oct 1, 2009 at 6:15 PM, Thomas Wood <grand.edgemaster at gmail.com>wrote:
> $ osm2pgsql --help
> osm2pgsql SVN version 0.65-14123
>
> Usage:
> osm2pgsql [options] planet.osm
> osm2pgsql [options] planet.osm.{gz,bz2}
> osm2pgsql [options] file1.osm file2.osm file3.osm
>
> This will import the data from the OSM file(s) into a PostgreSQL database
> suitable for use by the Mapnik renderer
>
> Options:
> -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 legacy 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 temporary data in the database. This greatly
> reduces the RAM usage but is much slower.
> -S|--style Location of the style file. Defaults to
> ./default.style
> -C|--cache Only for slim mode: Use upto this many MB for
> caching nodes
> Default is 800
> -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.
> -h|--help Help information.
> -v|--verbose Verbose output.
>
> Add -v to display supported projections.
> Use -E to access any espg projections (usually in /usr/share/proj/epsg)
>
>
> 2009/10/1 John Mitchell <mitchelljj98 at gmail.com>:
> > Hi,
> >
> > Your documentation states for using osm2pqsql (listed below) :
> >
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> >
> > Before you can use osm2pqsql for the first time with the Spherical
> Mercator
> > projection (see below), you need to initialize configuration data for
> this
> > projection. Do this by running the .sql file included with osm2pqsql:
> >
> > [Syntax on Windows]
> > $ psql -d gis -f c:\osm2pgsql\900913.sql
> >
> ------------------------------------------------------------------------------------------------------------------
> >
> > Using osm2pgsql can I import into postgres in a projection other than
> > Spherical Mercator (epsg:900913) like wgs84 (epsg:4326)?
> >
> > Thanks,
> >
> > John
> >
> > --
> > John J. Mitchell
> >
> > _______________________________________________
> > talk mailing list
> > talk at openstreetmap.org
> > http://lists.openstreetmap.org/listinfo/talk
> >
> >
>
>
>
> --
> Regards,
> Thomas Wood
> (Edgemaster)
>
--
John J. Mitchell
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20091001/e12968e0/attachment.html>
More information about the talk
mailing list