OpenStreetMap
how a bad query can get you working for 2 days
Posted by baditaflorin on 3 July 2014 in English. Last updated on 4 July 2014.i was using this into the overpass api
[timeout:86400]; (way(34.759984,-12.216797,71.587596,36.298828)[shop];); out meta;
instead of
[timeout:86400]; (way(34.759984,-12.216797,71.587596,36.298828)[shop];); /added by auto repair/ (._;>;); /end of auto repair/ out meta;
Discussion
Comment from Rovastar on 3 July 2014 at 23:40
Well I am not surprised as you seem to want to download half the database via the API.
The best solution for you is likely to be: Download the planet files for Europe (or whatever regions you need) Convert the whole thing into PSQL via osm2pgsql Do SQL queries on that data locally.
Comment from baditaflorin on 4 July 2014 at 00:42
i am in a remote area where the internet is slow and sometimes it crashes.
I will stay 2 days to download the europe-latest.osm.pbf and 2 more day to wait for osm2pgsql to do is job.
Also, i don`t have the 200-300 GB needed on my hard-drive
Comment from Pieren on 4 July 2014 at 08:44
Then you simply cannot achieve your task. Or change your goals, do you really need all POI’s in Europe ? we have some tools to filter pbf files directly.
Comment from baditaflorin on 4 July 2014 at 08:51
Overpass turbo suggested that the query that i was doing is wrong, and i should repair it like this
[timeout:86400]; (way(34.759984,-12.216797,71.587596,36.298828)[leisure];);
/added by auto repair/ (._;>;); /end of auto repair/ out body;
maybe now it will work
I downloaded germany ( 8 hours ) but i don`t have enough memory on c:\ for processing the file , i a trying now to make room