Open Street Map snippets

How to get a list bars around Colosseo

You can visit the wiki page on Open Street Map about the tag amenity=bar.

CSV output

You just have to execute the following query to get a full list in CSV.

[out:csv( ::id,"name",::count,"addr:street","addr:housenumber",::lat,::lon;
true; "|"
)][timeout:30];
rel[name="Colosseo"][tourism="attraction"];
(nwr[amenity=bar](around:1000.0);
);
out center;
out count;
@idname@countaddr:streetaddr:housenumber@lat@lon
962348457Ice Club Via della Madonna dei Monti18/1941.894091612.4885583
1572583515The Public House Via delle Tre Cannelle841.896622612.4860016
1701218666Camden Town 41.888556412.4950752
2092013187My Bar Via di San Giovanni in Laterano1241.889897312.4946166
2128214065San Clemente Via di San Giovanni in Laterano12641.888923312.4979123
2515010849Black Market Via Panisperna10141.897236112.4947481
3217327590"0,75" Via dei Cerchi6541.887951912.4839357
3320437843La Follia Via Capo d'Africa2641.888841512.4952573
4192923989Anima Mundi Via del Velabro141.889392412.4835302
4260275091Nag's Head Via Quattro Novembre13841.897290212.4845518
4367948894Brewdog Roma Via delle Terme di Tito8041.891761712.4929546
4394361989Bar Circo Massimo Viale Aventino 41.883309312.4873351
4455036165 41.896442012.4965110
4455036167 41.896847112.4989455
4556016298Divin Ostilia 41.889528712.4954434
4847967789 41.889727512.4953425
4886058322Antico Caffe del Brasile - Torrefazione Via dei Serpenti 41.895758312.4902776
6296292485Shamrock Irish bar & restaurant 41.888754712.4955163
6573371207Voodoo Bar Via delle Terme di Traiano441.893423712.4980792
6573379647The Sanctuary - Eco Retreat Via delle Terme di Traiano441.893429712.4983340
6695937286Antigallery Piazza degli Zingari341.895579112.4929538
6698598585Blackmarket Hall Via dei Ciancaleoni3141.896752512.4935707
6775922386Voodoo Bar 41.893417412.4980998
7896481085Coco Caffe 41.892496812.4925672
8511677046sMa Bar 41.887625412.5033537
8561505117 41.890133112.4955767
0 26

JSON output

You just have to execute the following query to get a full list in JSON format.


[out:json][timeout:30];
el[name="Colosseo"][tourism="attraction"];
(nwr[amenity=bar](around:1000.0);
);
out center;
out count;
This will give the following output.

  {
    "version": 0.6,
    "generator": "Overpass API 0.7.56.9 76e5016d",
    "osm3s": {
      "timestamp_osm_base": "2021-07-22T16:53:11Z",
      "copyright": "The data included in this document is from www.openstreetmap.org. The data is made available under ODbL."
    },
    "elements": [

  {
    "type": "node",
    "id": 962348457,
    "lat": 41.8940916,
    "lon": 12.4885583,
    "tags": {
      "addr:housenumber": "18/19",
      "addr:street": "Via della Madonna dei Monti",
      "amenity": "bar",
      "email": "info@iceclubroma.it",
      "name": "Ice Club",
      "opening_hours": "Mo-Su 17:00-01:00",
      "phone": "+39 06 97845581",
      "website": "http://iceclubroma.it/"
    }
  },
  {
    "type": "node",
    "id": 1572583515,
    "lat": 41.8966226,
    "lon": 12.4860016,
    "tags": {
      "addr:housenumber": "8",
      "addr:postcode": "00187",
      "addr:street": "Via delle Tre Cannelle",
      "amenity": "bar",
      "internet_access": "wlan",
      "name": "The Public House",
      "opening_hours": "Mo-Su 12:00-02:00",
      "phone": "+39 06 679 7591",
      "website": "http://www.thepublichouserome.com/"
    }
  },
  {
    "type": "node",
    "id": 1701218666,
    "lat": 41.8885564,
    "lon": 12.4950752,
    "tags": {
      "amenity": "bar",
      "name": "Camden Town"
    }
  },
  {
    "type": "node",
    "id": 2092013187,
    "lat": 41.8898973,
    "lon": 12.4946166,
    "tags": {
      "addr:housenumber": "12",
      "addr:street": "Via di San Giovanni in Laterano",
      "amenity": "bar",
      "name": "My Bar",
      "operator": "Anfiteatro S.r.l.",
      "phone": "+39 06 7004425",
      "ref:vatin": "IT06747541008"
    }
  },
  {
    "type": "node",
    "id": 2128214065,
    "lat": 41.8889233,
    "lon": 12.4979123,
    "tags": {
      "addr:city": "Roma",
      "addr:country": "IT",
      "addr:housenumber": "126",
      "addr:postcode": "00184",
      "addr:street": "Via di San Giovanni in Laterano",
      "amenity": "bar",
      "cuisine": "italian",
      "name": "San Clemente",
      "source": "GPS",
      "website": "http://www.iclementini.it/"
    }
  },
  {
    "type": "node",
    "id": 2515010849,
    "lat": 41.8972361,
    "lon": 12.4947481,
    "tags": {
      "addr:city": "Roma",
      "addr:country": "IT",
      "addr:housenumber": "101",
      "addr:postcode": "00184",
      "addr:street": "Via Panisperna",
      "amenity": "bar",
      "email": "blackmarketmonti@gmail.com",
      "internet_access": "yes",
      "internet_access:fee": "no",
      "microbrewery": "no",
      "name": "Black Market",
      "opening_hours": "15:00-02:00",
      "phone": "+39 3398227541",
      "smoking": "no",
      "website": "http://black-market.it"
    }
  },
  {
    "type": "node",
    "id": 3217327590,
    "lat": 41.8879519,
    "lon": 12.4839357,
    "tags": {
      "addr:city": "Roma",
      "addr:housenumber": "65",
      "addr:street": "Via dei Cerchi",
      "amenity": "bar",
      "name": "0,75",
      "opening_hours": "Mo-Su 11:00-02:00",
      "phone": "+39 066875706"
    }
  },
  {
    "type": "node",
    "id": 3320437843,
    "lat": 41.8888415,
    "lon": 12.4952573,
    "tags": {
      "addr:housenumber": "26",
      "addr:street": "Via Capo d'Africa",
      "amenity": "bar",
      "name": "La Follia",
      "operator": "Dolce Calabria SAS di Morello Alessandra & C.",
      "phone": "+39 06 45477438",
      "ref:vatin": "IT11279721002",
      "restaurant:type:it": "wine_bar",
      "shop": "pastry"
    }
  },
  {
    "type": "node",
    "id": 4192923989,
    "lat": 41.8893924,
    "lon": 12.4835302,
    "tags": {
      "addr:housenumber": "1",
      "addr:street": "Via del Velabro",
      "amenity": "bar",
      "cuisine": "italian",
      "description": "Lounge, Bar, Lunch, Dinner",
      "email": "animamundiroma@gmail.com",
      "internet_access": "wlan",
      "name": "Anima Mundi",
      "opening_hours": "Mo-Su 10:00-02:00",
      "phone": "+39 06 96030061",
      "website": "animamundiroma.it"
    }
  },
  {
    "type": "node",
    "id": 4260275091,
    "lat": 41.8972902,
    "lon": 12.4845518,
    "tags": {
      "addr:housenumber": "138",
      "addr:street": "Via Quattro Novembre",
      "amenity": "bar",
      "name": "Nag's Head"
    }
  },
  {
    "type": "node",
    "id": 4367948894,
    "lat": 41.8917617,
    "lon": 12.4929546,
    "tags": {
      "addr:housenumber": "80",
      "addr:postcode": "00184",
      "addr:street": "Via delle Terme di Tito",
      "amenity": "bar",
      "name": "Brewdog Roma",
      "name:en": "Brewdog Rome",
      "name:it": "Brew Dog Roma",
      "opening_hours": "Su-Th 12:00-01:00 ; Fr-Sa 12 : 00-02 : 00"
    }
  },
  {
    "type": "node",
    "id": 4394361989,
    "lat": 41.8833093,
    "lon": 12.4873351,
    "tags": {
      "addr:street": "Viale Aventino",
      "amenity": "bar",
      "cuisine": "italian",
      "name": "Bar Circo Massimo",
      "name:it": "Bar Circo Massimo"
    }
  },
  {
    "type": "node",
    "id": 4455036165,
    "lat": 41.8964420,
    "lon": 12.4965110,
    "tags": {
      "amenity": "bar"
    }
  },
  {
    "type": "node",
    "id": 4455036167,
    "lat": 41.8968471,
    "lon": 12.4989455,
    "tags": {
      "amenity": "bar"
    }
  },
  {
    "type": "node",
    "id": 4556016298,
    "lat": 41.8895287,
    "lon": 12.4954434,
    "tags": {
      "amenity": "bar",
      "name": "Divin Ostilia",
      "name:it": "Divin Ostilia",
      "opening_hours": "Mo-Su 12:00-01:00"
    }
  },
  {
    "type": "node",
    "id": 4847967789,
    "lat": 41.8897275,
    "lon": 12.4953425,
    "tags": {
      "amenity": "bar"
    }
  },
  {
    "type": "node",
    "id": 4886058322,
    "lat": 41.8957583,
    "lon": 12.4902776,
    "tags": {
      "addr:street": "Via dei Serpenti",
      "amenity": "bar",
      "cuisine": "sandwich;coffee_shop",
      "internet_access": "wlan",
      "name": "Antico Caffe del Brasile - Torrefazione",
      "name:de": "Antico Caffe del Brasile - Torrefazione"
    }
  },
  {
    "type": "node",
    "id": 6296292485,
    "lat": 41.8887547,
    "lon": 12.4955163,
    "tags": {
      "amenity": "bar",
      "name": "Shamrock Irish bar & restaurant"
    }
  },
  {
    "type": "node",
    "id": 6573371207,
    "lat": 41.8934237,
    "lon": 12.4980792,
    "tags": {
      "addr:housenumber": "4",
      "addr:street": "Via delle Terme di Traiano",
      "addr:unit": "a",
      "amenity": "bar",
      "name": "Voodoo Bar",
      "opening_hours": "Mo-Th 18:00-02:00; Fr-Sa 18:00-03:00; Su 18:00-02:00",
      "phone": "+39 06 8379 6815",
      "website": "https://www.facebook.com/voodobar/"
    }
  },
  {
    "type": "node",
    "id": 6573379647,
    "lat": 41.8934297,
    "lon": 12.4983340,
    "tags": {
      "addr:housenumber": "4",
      "addr:street": "Via delle Terme di Traiano",
      "addr:unit": "a",
      "amenity": "bar",
      "name": "The Sanctuary - Eco Retreat",
      "opening_hours": "Tu-We 18:00-02:00; Th 18:00-03:00; Fr 18:00-04:00; Sa 11:00-04:00; Su 11:00-02:00",
      "phone": "+39 06 8379 6820",
      "website": "http://www.thesanctuaryroma.it/"
    }
  },
  {
    "type": "node",
    "id": 6695937286,
    "lat": 41.8955791,
    "lon": 12.4929538,
    "tags": {
      "addr:housenumber": "3",
      "addr:postcode": "00184",
      "addr:street": "Piazza degli Zingari",
      "amenity": "bar",
      "name": "Antigallery"
    }
  },
  {
    "type": "node",
    "id": 6698598585,
    "lat": 41.8967525,
    "lon": 12.4935707,
    "tags": {
      "addr:housenumber": "31",
      "addr:postcode": "00184",
      "addr:street": "Via dei Ciancaleoni",
      "amenity": "bar",
      "name": "Blackmarket Hall",
      "website": "http://www.blackmarketartgallery.it"
    }
  },
  {
    "type": "node",
    "id": 6775922386,
    "lat": 41.8934174,
    "lon": 12.4980998,
    "tags": {
      "amenity": "bar",
      "name": "Voodoo Bar"
    }
  },
  {
    "type": "node",
    "id": 7896481085,
    "lat": 41.8924968,
    "lon": 12.4925672,
    "tags": {
      "amenity": "bar",
      "name": "Coco Caffe"
    }
  },
  {
    "type": "node",
    "id": 8511677046,
    "lat": 41.8876254,
    "lon": 12.5033537,
    "tags": {
      "amenity": "bar",
      "name": "sMa Bar",
      "wheelchair": "limited"
    }
  },
  {
    "type": "node",
    "id": 8561505117,
    "lat": 41.8901331,
    "lon": 12.4955767,
    "tags": {
      "amenity": "bar",
      "name:en": "The Court Cocktail Bar"
    }
  },
  {
    "type": "count",
    "id": 0,
    "tags": {
      "nodes": "26",
      "ways": "0",
      "relations": "0",
      "total": "26"
    }
  }

    ]
  }

XML output

You just have to execute the following query to get a full list in XML format.


  [timeout:30];


  rel[name="Colosseo"][tourism="attraction"];
  (nwr[amenity=bar](around:1000.0);
  );
  out center;
  out count;
This will give the following output.

  
  <?xml version="1.0" encoding="UTF-8"?>
  <osm version="0.6" generator="Overpass API 0.7.56.9 76e5016d">
  <note>The data included in this document is from www.openstreetmap.org. The data is made available under ODbL.</note>
  <meta osm_base="2021-07-22T16:58:28Z"/>

    <node id="962348457" lat="41.8940916" lon="12.4885583">
      <tag k="addr:housenumber" v="18/19"/>
      <tag k="addr:street" v="Via della Madonna dei Monti"/>
      <tag k="amenity" v="bar"/>
      <tag k="email" v="info@iceclubroma.it"/>
      <tag k="name" v="Ice Club"/>
      <tag k="opening_hours" v="Mo-Su 17:00-01:00"/>
      <tag k="phone" v="+39 06 97845581"/>
      <tag k="website" v="http://iceclubroma.it/"/>
    </node>
    <node id="1572583515" lat="41.8966226" lon="12.4860016">
      <tag k="addr:housenumber" v="8"/>
      <tag k="addr:postcode" v="00187"/>
      <tag k="addr:street" v="Via delle Tre Cannelle"/>
      <tag k="amenity" v="bar"/>
      <tag k="internet_access" v="wlan"/>
      <tag k="name" v="The Public House"/>
      <tag k="opening_hours" v="Mo-Su 12:00-02:00"/>
      <tag k="phone" v="+39 06 679 7591"/>
      <tag k="website" v="http://www.thepublichouserome.com/"/>
    </node>
    <node id="1701218666" lat="41.8885564" lon="12.4950752">
      <tag k="amenity" v="bar"/>
      <tag k="name" v="Camden Town"/>
    </node>
    <node id="2092013187" lat="41.8898973" lon="12.4946166">
      <tag k="addr:housenumber" v="12"/>
      <tag ?o?-?s
>?~8�������????����?s
���������������w����C=k="addr:street" v="Via di San Giovanni in Laterano"/>
      <tag k="amenity" v="bar"/>
      <tag k="name" v="My Bar"/>
      <tag k="operator" v="Anfiteatro S.r.l."/>
      <tag k="phone" v="+39 06 7004425"/>
      <tag k="ref:vatin" v="IT06747541008"/>
    </node>
    <node id="2128214065" lat="41.8889233" lon="12.4979123">
      <tag k="addr:city" v="Roma"/>
      <tag k="addr:country" v="IT"/>
      <tag k="addr:housenumber" v="126"/>
      <tag k="addr:postcode" v="00184"/>
      <tag k="addr:street" v="Via di San Giovanni in Laterano"/>
      <tag k="amenity" v="bar"/>
      <tag k="cuisine" v="italian"/>
      <tag k="name" v="San Clemente"/>
      <tag k="source" v="GPS"/>
      <tag k="website" v="http://www.iclementini.it/"/>
    </node>
    <node id="2515010849" lat="41.8972361" lon="12.4947481">
      <tag k="addr:city" v="Roma"/>
      <tag k="addr:country" v="IT"/>
      <tag k="addr:housenumber" v="101"/>
      <tag k="addr:postcode" v="00184"/>
      <tag k="addr:street" v="Via Panisperna"/>
      <tag k="amenity" v="bar"/>
      <tag k="email" v="blackmarketmonti@gmail.com"/>
      <tag k="internet_access" v="yes"/>
      <tag k="internet_access:fee" v="no"/>
      <tag k="microbrewery" v="no"/>
      <tag k="name" v="Black Market"/>
      <tag k="opening_hours" v="15:00-02:00"/>
      <tag k="phone" v="+39 3398227541"/>
      <tag k="smoking" v="no"/>
      <tag k="website" v="http://black-market.it"/>
    </node>
    <node id="3217327590" lat="41.8879519" lon="12.4839357">
      <tag k="addr:city" v="Roma"/>
      <tag k="addr:housenumber" v="65"/>
      <tag k="addr:street" v="Via dei Cerchi"/>
      <tag k="amenity" v="bar"/>
      <tag k="name" v="0,75"/>
      <tag k="opening_hours" v="Mo-Su 11:00-02:00"/>
      <tag k="phone" v="+39 066875706"/>
    </node>
    <node id="3320437843" lat="41.8888415" lon="12.4952573">
      <tag k="addr:housenumber" v="26"/>
      <tag k="addr:street" v="Via Capo d'Africa"/>
      <tag k="amenity" v="bar"/>
      <tag k="name" v="La Follia"/>
      <tag k="operator" v="Dolce Calabria SAS di Morello Alessandra &amp; C."/>
      <tag k="phone" v="+39 06 45477438"/>
      <tag k="ref:vatin" v="IT11279721002"/>
      <tag k="restaurant:type:it" v="wine_bar"/>
      <tag k="shop" v="pastry"/>
    </node>
    <node id="4192923989" lat="41.8893924" lon="12.4835302">
      <tag k="addr:housenumber" v="1"/>
      <tag k="addr:street" v="Via del Velabro"/>
      <tag k="amenity" v="bar"/>
      <tag k="cuisine" v="italian"/>
      <tag k="description" v="Lounge, Bar, Lunch, Dinner"/>
      <tag k="email" v="animamundiroma@gmail.com"/>
      <tag k="internet_access" v="wlan"/>
      <tag k="name" v="Anima Mundi"/>
      <tag k="opening_hours" v="Mo-Su 10:00-02:00"/>
      <tag k="phone" v="+39 06 96030061"/>
      <tag k="website" v="animamundiroma.it"/>
    </node>
    <node id="4260275091" lat="41.8972902" lon="12.4845518">
      <tag k="addr:housenumber" v="138"/>
      <tag k="addr:street" v="Via Quattro Novembre"/>
      <tag k="amenity" v="bar"/>
      <tag k="name" v="Nag's Head"/>
    </node>
    <node id="4367948894" lat="41.8917617" lon="12.4929546">
      <tag k="addr:housenumber" v="80"/>
      <tag k="addr:postcode" v="00184"/>
      <tag k="addr:street" v="Via delle Terme di Tito"/>
      <tag k="amenity" v="bar"/>
      <tag k="name" v="Brewdog Roma"/>
      <tag k="name:en" v="Brewdog Rome"/>
      <tag k="name:it" v="Brew Dog Roma"/>
      <tag k="opening_hours" v="Su-Th 12:00-01:00 ; Fr-Sa 12 : 00-02 : 00"/>
    </node>
    <node id="4394361989" lat="41.8833093" lon="12.4873351">
      <tag k="addr:street" v="Viale Aventino"/>
      <tag k="amenity" v="bar"/>
      <tag k="cuisine" v="italian"/>
      <tag k="name" v="Bar Circo Massimo"/>
      <tag k="name:it" v="Bar Circo Massimo"/>
    </node>
    <node id="4455036165" lat="41.8964420" lon="12.4965110">
      <tag k="amenity" v="bar"/>
    </node>
    <node id="4455036167" lat="41.8968471" lon="12.4989455">
      <tag k="amenity" v="bar"/>
    </node>
    <node id="4556016298" lat="41.8895287" lon="12.4954434">
      <tag k="amenity" v="bar"/>
      <tag k="name" v="Divin Ostilia"/>
      <tag k="name:it" v="Divin Ostilia"/>
      <tag k="opening_hours" v="Mo-Su 12:00-01:00"/>
    </node>
    <node id="4847967789" lat="41.8897275" lon="12.4953425">
      <tag k="amenity" v="bar"/>
    </node>
    <node id="4886058322" lat="41.8957583" lon="12.4902776">
      <tag k="addr:street" v="Via dei Serpenti"/>
      <tag k="amenity" v="bar"/>
      <tag k="cuisine" v="sandwich;coffee_shop"/>
      <tag k="internet_access" v="wlan"/>
      <tag k="name" v="Antico Caffe del Brasile - Torrefazione"/>
      <tag k="name:de" v="Antico Caffe del Brasile - Torrefazione"/>
    </node>
    <node id="6296292485" lat="41.8887547" lon="12.4955163">
      <tag k="amenity" v="bar"/>
      <tag k="name" v="Shamrock Irish bar &amp; restaurant"/>
    </node>
    <node id="6573371207" lat="41.8934237" lon="12.4980792">
      <tag k="addr:housenumber" v="4"/>
      <tag k="addr:street" v="Via delle Terme di Traiano"/>
      <tag k="addr:unit" v="a"/>
      <tag k="amenity" v="bar"/>
      <tag k="name" v="Voodoo Bar"/>
      <tag k="opening_hours" v="Mo-Th 18:00-02:00; Fr-Sa 18:00-03:00; Su 18:00-02:00"/>
      <tag k="phone" v="+39 06 8379 6815"/>
      <tag k="website" v="https://www.facebook.com/voodobar/"/>
    </node>
    <node id="6573379647" lat="41.8934297" lon="12.4983340">
      <tag k="addr:housenumber" v="4"/>
      <tag k="addr:street" v="Via delle Terme di Traiano"/>
      <tag k="addr:unit" v="a"/>
      <tag k="amenity" v="bar"/>
      <tag k="name" v="The Sanctuary - Eco Retreat"/>
      <tag k="opening_hours" v="Tu-We 18:00-02:00; Th 18:00-03:00; Fr 18:00-04:00; Sa 11:00-04:00; Su 11:00-02:00"/>
      <tag k="phone" v="+39 06 8379 6820"/>
      <tag k="website" v="http://www.thesanctuaryroma.it/"/>
    </node>
    <node id="6695937286" lat="41.8955791" lon="12.4929538">
      <tag k="addr:housenumber" v="3"/>
      <tag k="addr:postcode" v="00184"/>
      <tag k="addr:street" v="Piazza degli Zingari"/>
      <tag k="amenity" v="bar"/>
      <tag k="name" v="Antigallery"/>
    </node>
    <node id="6698598585" lat="41.8967525" lon="12.4935707">
      <tag k="addr:housenumber" v="31"/>
      <tag k="addr:postcode" v="00184"/>
      <tag k="addr:street" v="Via dei Ciancaleoni"/>
      <tag k="amenity" v="bar"/>
      <tag k="name" v="Blackmarket Hall"/>
      <tag k="website" v="http://www.blackmarketartgallery.it"/>
    </node>
    <node id="6775922386" lat="41.8934174" lon="12.4980998">
      <tag k="amenity" v="bar"/>
      <tag k="name" v="Voodoo Bar"/>
    </node>
    <node id="7896481085" lat="41.8924968" lon="12.4925672">
      <tag k="amenity" v="bar"/>
      <tag k="name" v="Coco Caffe"/>
    </node>
    <node id="8511677046" lat="41.8876254" lon="12.5033537">
      <tag k="amenity" v="bar"/>
      <tag k="name" v="sMa Bar"/>
      <tag k="wheelchair" v="limited"/>
    </node>
    <node id="8561505117" lat="41.8901331" lon="12.4955767">
      <tag k="amenity" v="bar"/>
      <tag k="name:en" v="The Court Cocktail Bar"/>
    </node>
    <count id="0">
      <tag k="nodes" v="26"/>
      <tag k="ways" v="0"/>
      <tag k="relations" v="0"/>
      <tag k="total" v="26"/>
    </count>

  </osm>

Back to Open Street Map cookbook page