25 places near Calvi Risorta, 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. Visciano
    Visciano, Caserta, Campania, Italia (Town)
  4. Calvi Risorta
    Calvi Risorta, Caserta, Campania, Italia (Town)
  5. Calvi Risorta
    Calvi Risorta, Caserta, Campania, Italia (LocalAdmin)
  6. Teano
    Teano, Caserta, Campania, Italia (LocalAdmin)
  7. Rocchetta e Croce
    Rocchetta e Croce, Caserta, Campania, Italia (LocalAdmin)
  8. Pignataro Maggiore
    Pignataro Maggiore, Caserta, Campania, Italia (LocalAdmin)
  9. Sparanise
    Sparanise, Caserta, Campania, Italia (LocalAdmin)
  10. Caserta
    Caserta, Campania, Italia (County)

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

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

        
0.039 seconds ⌛

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