26 places near San Felice a Cancello, Caserta, Campania, Italia
filter by placetype:
  1. Arienzo
    Arienzo, Caserta, Campania, Italia (Town)
  2. Santa Maria a Vico
    Santa Maria a Vico, Caserta, Campania, Italia (Town)
  3. Masseria Assini
    Masseria Assini, Caserta, Campania, Italia (Town)
  4. San Felice a Cancello
    San Felice a Cancello, Caserta, Campania, Italia (Town)
  5. Botteghino
    Botteghino, Caserta, Campania, Italia (Town)
  6. San Felice a Cancello
    San Felice a Cancello, Caserta, Campania, Italia (LocalAdmin)
  7. Santa Maria a Vico
    Santa Maria a Vico, Caserta, Campania, Italia (LocalAdmin)
  8. Roccarainola
    Roccarainola, Napoli, Campania, Italia (LocalAdmin)
  9. Napoli
    Napoli, Campania, Italia (County)
  10. Caserta
    Caserta, Campania, Italia (County)

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

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

        
0.026 seconds ⌛

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