28 places near Spicciano, Caserta, Campania, Italia
filter by placetype:
  1. San Carlo
    San Carlo, Caserta, Campania, Italia (Town)
  2. San Clemente
    San Clemente, Caserta, Campania, Italia (Town)
  3. Vandria
    Vandria, Caserta, Campania, Italia (Town)
  4. Ceschetto
    Ceschetto, Caserta, Campania, Italia (Town)
  5. Spicciano
    Spicciano, Caserta, Campania, Italia (Town)
  6. Fortinelli
    Fortinelli, Caserta, Campania, Italia (Town)
  7. Sessa Aurunca
    Sessa Aurunca, Caserta, Campania, Italia (LocalAdmin)
  8. Rocca d'Evandro
    Rocca d'Evandro, Caserta, Campania, Italia (LocalAdmin)
  9. Roccamonfina
    Roccamonfina, Caserta, Campania, Italia (LocalAdmin)
  10. Galluccio
    Galluccio, Caserta, Campania, Italia (LocalAdmin)

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": [
                  13.94502,
                  41.324108
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}