[OSM-talk] Using osm2pgsql can I import into postgres in a projection other than Spherical Mercator (epsg:900913) like wgs84 (epsg:4326)

Thomas Wood grand.edgemaster at gmail.com
Fri Oct 2 00:19:32 BST 2009


Provided it can read postgres, and the styles can be adapted to a
mapnik-like database structure.

Data will be imported into 4 tables - planet_osm_point,
planet_osm_line, planet_osm_polygon and planet_osm_roads.
Each tag defined in the default.style file (packaged with osm2pgsql)
will be used as a field, in addition to the fields osm_id
(self-explanatory) and way (the geometry).

2009/10/1 John Mitchell <mitchelljj98 at gmail.com>:
> 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
>



-- 
Regards,
Thomas Wood
(Edgemaster)




More information about the talk mailing list