25 places near Mandrelle, Chieti, Abruzzo, Italia
filter by placetype:
  1. Altino
    Altino, Chieti, Abruzzo, Italia (Town)
  2. Casoli
    Casoli, Chieti, Abruzzo, Italia (Town)
  3. Roccascalegna
    Roccascalegna, Chieti, Abruzzo, Italia (Town)
  4. Selva D'altino
    Selva D'altino, Chieti, Abruzzo, Italia (Town)
  5. La Serra
    La Serra, Chieti, Abruzzo, Italia (Town)
  6. Mandrelle
    Mandrelle, Chieti, Abruzzo, Italia (Town)
  7. Roccascalegna
    Roccascalegna, Chieti, Abruzzo, Italia (LocalAdmin)
  8. Casoli
    Casoli, Chieti, Abruzzo, Italia (LocalAdmin)
  9. Altino
    Altino, Chieti, Abruzzo, Italia (LocalAdmin)
  10. Chieti
    Chieti, Abruzzo, Italia (County)

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

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

        
0.021 seconds ⌛

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