28 places near 81032, Caserta, Campania, Italia
filter by placetype:
  1. Casal di Principe
    Casal di Principe, Caserta, Campania, Italia (Town)
  2. Gricignano d'Aversa
    Gricignano d'Aversa, Caserta, Campania, Italia (Town)
  3. Carinaro
    Carinaro, Caserta, Campania, Italia (Town)
  4. Succivo
    Succivo, Caserta, Campania, Italia (Town)
  5. Teverola
    Teverola, Caserta, Campania, Italia (Town)
  6. Casaluce
    Casaluce, Caserta, Campania, Italia (LocalAdmin)
  7. Gricignano di Aversa
    Gricignano di Aversa, Caserta, Campania, Italia (LocalAdmin)
  8. Marcianise
    Marcianise, Caserta, Campania, Italia (LocalAdmin)
  9. Carinaro
    Carinaro, Caserta, Campania, Italia (LocalAdmin)
  10. Succivo
    Succivo, Caserta, Campania, Italia (LocalAdmin)

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

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

        
0.056 seconds ⌛

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