23 places near Caserta, Campania, Italia
filter by placetype:
  1. Calvi Vecchia
    Calvi Vecchia, Caserta, Campania, Italia (Town)
  2. Pignataro Maggiore
    Pignataro Maggiore, Caserta, Campania, Italia (Town)
  3. Calvi Risorta
    Calvi Risorta, Caserta, Campania, Italia (Town)
  4. Rocchetta e Croce
    Rocchetta e Croce, Caserta, Campania, Italia (Town)
  5. Calvi Risorta
    Calvi Risorta, Caserta, Campania, Italia (LocalAdmin)
  6. Giano Vetusto
    Giano Vetusto, Caserta, Campania, Italia (LocalAdmin)
  7. Pignataro Maggiore
    Pignataro Maggiore, Caserta, Campania, Italia (LocalAdmin)
  8. Caserta
    Caserta, Campania, Italia (County)
  9. Europe/Belgrade
    Europe/Belgrade (Timezone)
  10. Europe/Rome
    Europe/Rome (Timezone)

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

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

        
0.023 seconds ⌛

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