5 places near Sparanise, Caserta, Campania, Italia
filter by placetype:
  1. Calvi Risorta
    Calvi Risorta, Caserta, Campania, Italia (LocalAdmin)
  2. Teano
    Teano, Caserta, Campania, Italia (LocalAdmin)
  3. Francolise
    Francolise, Caserta, Campania, Italia (LocalAdmin)
  4. Pignataro Maggiore
    Pignataro Maggiore, Caserta, Campania, Italia (LocalAdmin)
  5. Sparanise
    Sparanise, Caserta, Campania, Italia (LocalAdmin)

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

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

        
0.038 seconds ⌛

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