33 places near Trüllikon, Andelfingen, Kanton Zürich, Schweiz
  1. Ober-schlatt
    Ober-schlatt, Diessenhofen, Kanton Thurgau, Schweiz (Town)
  2. Schlatt
    Schlatt, Diessenhofen, Kanton Thurgau, Schweiz (Town)
  3. Trüllikon
    Trüllikon, Andelfingen, Kanton Zürich, Schweiz (Town)
  4. Unterschlatt
    Unterschlatt, Diessenhofen, Kanton Thurgau, Schweiz (Town)
  5. Rudolfingen
    Rudolfingen, Andelfingen, Kanton Zürich, Schweiz (Town)
  6. Langenmoos
    Langenmoos, Andelfingen, Kanton Zürich, Schweiz (Town)
  7. Mett-Oberschlatt
    Mett-Oberschlatt, Diessenhofen, Kanton Thurgau, Schweiz (Town)
  8. Mettschlatt
    Mettschlatt, Diessenhofen, Kanton Thurgau, Schweiz (Town)
  9. Wildensbuch
    Wildensbuch, Andelfingen, Kanton Zürich, Schweiz (Town)
  10. Rhein
    Rhein, Deutschland (Drainage)

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

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

        
0.057 seconds ⌛

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