Hello everybody !
I’m trying to import some data from openstreetmap into a postgresql database since 2 days and I can’t manage to do it, that is why I need someone’s help !
I think it is not quite difficult, but I am a great beginner in using PostgreSQL, PostGIS, osm2pgsql, osm data, and the windows command prompt.
Here is the situation:
I follow this tutorial (https://github.com/mapserver/mapserver/wiki/RenderingOsmDataWindows#wiki-osm-import) (but not the MapServer part)
I’m (unfortunately) using Windows 7 (x64). I’have installed PostgreSQL 9.2, PostGIS 2.0, and osm2pgsql.
My openstreetmap data are rhone-alpes.osm (France).
PostgreSQL is here: “C:\Program Files\PostgreSQL\9.2\bin”
osm2pgsql is here: “C:\Program Files\osm2pgsql”
rhone-alpes.osm.bz2 is here : “C:\aGlumLieu\GeoMkt”
The name of my PostgreSQL database is “osm”
Here is the problem:
I don’t understand how to import those data into my database “osm”, even if i have read many, many tutorials…
I try with this:
osm2pgsql -U postgres -W -m -d osm -p osm -E 3857 -S "C:\Program Files\osm2pgsql\default.style" rhone-alpes.osm.bz2
osm2pgsql -U postgres -W -m -d osm -p osm -E 3857 -S "C:\Program Files\osm2pgsql\default.style" C:\aGlumLieu\GeoMkt\rhone-alpes.osm.bz2
But there is an error, and I always have this message:
osm2pgsql SVN version af61cae663 (64bit id space) release notes: 'Windows version built by Dominik Perpeet <http://www.customdebug.com/osm2pgsql/index.html>' osm2pgsql: illegal option --W Usage error. For further information see: osm2pgsql.exe -h|--help
Does someone know the right way to do it ?
Have a good day !
Ps: Thank you so much to Openstreetmap and its community, you’re are doing something awesome ! \o/