HI I’m trying to import OSM data into postgres. I’ve tried downloading files (e.g http://download.geofabrik.de/australia-oceania/australia-latest.osm.pbf ) and importing using osm2pgsql. The import seems to succeed, but the resulting data do not look right. The resulting data appear be a very sparse grid, and do not represent streets at all. I’ve tried using similar datasets from other regions such as Europe and the result is similar.
SHP files seem to be fine. I only have a problem with PBF and OSM. Unfortunately SHP is not available for Australia.
Here’s an example of my import command:
osm2pgsql -c -s -d $dbname -U $user -W -H $host -E 4283 -S default.style australia-latest.osm.pbf
Anyone had any luck getting OSM data into postgres?