22 places near Sparanise, Caserta, Campania, Italia
filter by placetype:
  1. Calvi Risorta
    Calvi Risorta, Caserta, Campania, Italia (Town)
  2. Calvi Risorta
    Calvi Risorta, Caserta, Campania, Italia (LocalAdmin)
  3. Teano
    Teano, Caserta, Campania, Italia (LocalAdmin)
  4. Francolise
    Francolise, Caserta, Campania, Italia (LocalAdmin)
  5. Pignataro Maggiore
    Pignataro Maggiore, Caserta, Campania, Italia (LocalAdmin)
  6. Sparanise
    Sparanise, 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.02 seconds ⌛; show me the details?

        
0.02 seconds ⌛

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