4

This is my first time working with OpenStreetMap data.

I am trying to import some data from OpenStreetMap into PostgreSQL. I have been downloading the data using the following query : 

wget 'http://overpass-api.de/api/interpreter?data=node(52.06,5.04,52.08,5.06);out;' -O utrecht2.osm

Then, I have imported the resulting file into PostgreSQL using osm2pqsql:

osm2pgsql -c -d utrecht -C 1000 --flat-nodes /home/me/Documents/01_perso/28_routing --hstore -S default.style utrecht2.osm

Everything seem to run without any error (that I can see at least).

I am using the default.style file that can be found here for the import.

Finally, I am looking at the data that has been imported into my Postgresql table. What annoys me is that only the planet_osm_point table contains information. All other tables are empty.

When looking at the area using the OSM website, it is clear to me that there should be way more information available, in terms of polygons, roads, etc

I have tried to reduce my search area several times, wondering if I hadn't reached the overpass API limits but without success so far.

Could someone point me towards the reason why I don't get any road, polygon, line information into my database?

PolyGeo
  • 65,136
  • 29
  • 109
  • 338
jlengrand
  • 193
  • 6
  • overpass is okay for small extracts but http://extract.bbbike.org/ will extract areas in shapefile use pgadmin shapefile import to postgis. http://gis.stackexchange.com/questions/7803/bulk-load-multiple-shapefiles-into-postgis it is faster. – Mapperz Mar 01 '15 at 15:08
  • Thanks @Mapperz. So far I have been using the bulk downloads from geofabrik (EX : http://download.geofabrik.de/europe/netherlands.html) but wanted to try out a smaller area for starters :). – jlengrand Mar 01 '15 at 16:02

1 Answers1

5

As you query to have only nodes it is that all you get. See http://wiki.openstreetmap.org/wiki/Overpass_API/Language_Guide#Nodes for more details.

Your query should be

http://overpass-api.de/api/interpreter?data=(node(52.06,5.04,52.08,5.06);<;>;);out;

nicolas-f
  • 379
  • 3
  • 8