23 places near Sessa Aurunca, Caserta, Campania, Italia
filter by placetype:
  1. Sessa Aurunca
    Sessa Aurunca, Caserta, Campania, Italia (Town)
  2. Marzuli
    Marzuli, Caserta, Campania, Italia (Town)
  3. Sant'agata
    Sant'agata, Caserta, Campania, Italia (Town)
  4. Tuoro Podesti
    Tuoro Podesti, Caserta, Campania, Italia (Town)
  5. Sessa Aurunca
    Sessa Aurunca, Caserta, Campania, Italia (LocalAdmin)
  6. Carinola
    Carinola, Caserta, Campania, Italia (LocalAdmin)
  7. Caserta
    Caserta, Campania, Italia (County)
  8. Europe/Belgrade
    Europe/Belgrade (Timezone)
  9. Europe/Rome
    Europe/Rome (Timezone)
  10. Campania
    Campania, Italia (State)

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

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

        
0.024 seconds ⌛

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