25 places near Colonnella, Teramo, Abruzzo, Italia
filter by placetype:
  1. Colonnella
    Colonnella, Teramo, Abruzzo, Italia (Town)
  2. Corropoli
    Corropoli, Teramo, Abruzzo, Italia (Town)
  3. Martinsicuro
    Martinsicuro, Teramo, Abruzzo, Italia (Town)
  4. Prosperi
    Prosperi, Teramo, Abruzzo, Italia (Town)
  5. Colonnella
    Colonnella, Teramo, Abruzzo, Italia (LocalAdmin)
  6. Controguerra
    Controguerra, Teramo, Abruzzo, Italia (LocalAdmin)
  7. Martinsicuro
    Martinsicuro, 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.036 seconds ⌛; show me the details?

        
0.036 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  13.87198,
                  42.8605
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}