29 places near Andelfingen, Kanton Zürich, Schweiz
  1. Andelfingen
    Andelfingen, Andelfingen, Kanton Zürich, Schweiz (Town)
  2. Grossandelfingen
    Grossandelfingen, Andelfingen, Kanton Zürich, Schweiz (Town)
  3. Oerlingen
    Oerlingen, Andelfingen, Kanton Zürich, Schweiz (Town)
  4. Dätwil
    Dätwil, Andelfingen, Kanton Zürich, Schweiz (Town)
  5. Kleinandelfingen
    Kleinandelfingen, Andelfingen, Kanton Zürich, Schweiz (Town)
  6. Rhein
    Rhein, Deutschland (Drainage)
  7. Donau
    Donau, Magyarország (Drainage)
  8. Kleinandelfingen
    Kleinandelfingen, Andelfingen, Kanton Zürich, Schweiz (LocalAdmin)
  9. Andelfingen
    Andelfingen, Andelfingen, Kanton Zürich, Schweiz (LocalAdmin)
  10. Ossingen
    Ossingen, Andelfingen, Kanton Zürich, Schweiz (LocalAdmin)

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

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

        
0.022 seconds ⌛

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