25 places near Castel Campagnano, Caserta, Campania, Italia
filter by placetype:
  1. Alvignanello
    Alvignanello, Caserta, Campania, Italia (Town)
  2. Amorosi
    Amorosi, Benevento, Campania, Italia (Town)
  3. Castel Campagnano
    Castel Campagnano, Caserta, Campania, Italia (Town)
  4. Squille
    Squille, Caserta, Campania, Italia (Town)
  5. Ruviano
    Ruviano, Caserta, Campania, Italia (LocalAdmin)
  6. Amorosi
    Amorosi, Benevento, Campania, Italia (LocalAdmin)
  7. Castel Campagnano
    Castel Campagnano, Caserta, Campania, Italia (LocalAdmin)
  8. Melizzano
    Melizzano, Benevento, Campania, Italia (LocalAdmin)
  9. Caserta
    Caserta, Campania, Italia (County)
  10. Benevento
    Benevento, Campania, Italia (County)

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

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

        
0.018 seconds ⌛

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