extract POIs for a region

Question

I am currently working on a list of available hotels in the Republic of Georgia. As the OSM-Database has lots of POIs, is it possible to access this data for that purpose? I would like to run a query to retrieve hotels with addresses, phone numbers and other details that are entered. The coordinates would not matter for my purpose.

The result should be an Excel-file or similar table format.

How can I do this? All help appreciated!

Answer 1

You can get the data in JSON format in two steps from Overpass API:

First, obtain the area by pasting the following request

<osm-script output="json">

<coord-query lat="42.2" lon="43.3"/>
<print/>

</osm-script>

into the Overpass API query form.

From the result, you can read off the area with name "Georgia" that the relevant area id is 3600028699.

Now you can query for the really wanted data, again on Overpass API query form:

<osm-script output="json">

<query type="node">
  <area-query ref="3600028699"/>
  <has-kv k="tourism" v="hotel"/>
</query>
<print/>
<area-query ref="3600028699"/>
<query type="way">
  <recurse type="node-way"/>
  <has-kv k="tourism" v="hotel"/>
</query>
<print/>

</osm-script>

This results in a 92 KB big JSON file containing all information about nodes or ways in Georgia tagged with tourism=hotel. If you want additionally hostels, repeat the second step with tourism=hostel and so on.

Note that some elements have addresses and phone numbers and others have not, depending on how they have been mapped in the database.

extract POIs for a region

Follow this question

Related questions