25 places near Colonnella, Teramo, Abruzzo, Italia
filter by placetype:
  1. Colonnella
    Colonnella, Teramo, Abruzzo, Italia (Town)
  2. Martinsicuro
    Martinsicuro, Teramo, Abruzzo, Italia (Town)
  3. Cappelletti
    Cappelletti, Teramo, Abruzzo, Italia (Town)
  4. Centobuchi
    Centobuchi, Ascoli Piceno, Marche, Italia (Town)
  5. Prosperi
    Prosperi, Teramo, Abruzzo, Italia (Town)
  6. Colonnella
    Colonnella, Teramo, Abruzzo, Italia (LocalAdmin)
  7. Controguerra
    Controguerra, Teramo, Abruzzo, Italia (LocalAdmin)
  8. Teramo
    Teramo, Abruzzo, Italia (County)
  9. Ascoli Piceno
    Ascoli Piceno, Marche, Italia (County)
  10. Europe/Belgrade
    Europe/Belgrade (Timezone)

Search again including deprecated places, unknown places, places that visit Null Island or everything?

This query took 0.022 seconds ⌛; show me the details?

        
0.022 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  13.86785,
                  42.871552
                ]
              }
            }
          }
        }
      ],
      "must_not": [
        {
          "terms": {
            "woe:placetype": [
              0,
              11,
              25
            ]
          }
        },
        {
          "term": {
            "geom:latitude": {
              "value": 0.0
            }
          }
        },
        {
          "term": {
            "geom:longitude": {
              "value": 0.0
            }
          }
        },
        {
          "exists": {
            "field": "woe:superseded_by"
          }
        }
      ]
    }
  },
  "aggs": {
    "placetypes": {
      "terms": {
        "field": "woe:placetype_name",
        "size": 10000
      }
    }
  },
  "sort": [
    {
      "woe:scale": {
        "order": "desc",
        "mode": "max"
      }
    },
    {
      "woe:id": {
        "order": "asc",
        "mode": "max"
      }
    }
  ]
}