27 places near Cisterna, Caserta, Campania, Italia
filter by placetype:
  1. Merrone
    Merrone, Caserta, Campania, Italia (Town)
  2. Pontelatone
    Pontelatone, Caserta, Campania, Italia (Town)
  3. Prea
    Prea, Caserta, Campania, Italia (Town)
  4. Sasso
    Sasso, Caserta, Campania, Italia (Town)
  5. Strangolagalli
    Strangolagalli, Caserta, Campania, Italia (Town)
  6. Arbusti
    Arbusti, Caserta, Campania, Italia (Town)
  7. Cisterna
    Cisterna, Caserta, Campania, Italia (Town)
  8. Castel di Sasso
    Castel di Sasso, Caserta, Campania, Italia (Town)
  9. Castel di Sasso
    Castel di Sasso, Caserta, Campania, Italia (LocalAdmin)
  10. Piana di Monte Verna
    Piana di Monte Verna, Caserta, Campania, Italia (LocalAdmin)

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

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

        
0.027 seconds ⌛

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