3 places near Andelfingen, Kanton Zürich, Schweiz
filter by placetype:
  1. Baden-Württemberg
    Baden-Württemberg, Baden-Württemberg, Deutschland (State)
  2. Kanton Schaffhausen
    Kanton Schaffhausen, Kanton Schaffhausen, Schweiz (State)
  3. Kanton Zürich
    Kanton Zürich, Kanton Zürich, Schweiz (State)

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

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

        
0.06 seconds ⌛

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