26 places near Mittelland, Kanton Appenzell Ausserrhoden, Schweiz
  1. Bühler
    Bühler, Mittelland, Kanton Appenzell Ausserrhoden, Schweiz (Town)
  2. Rhein
    Rhein, Deutschland (Drainage)
  3. Donau
    Donau, Magyarország (Drainage)
  4. St. Gallen
    St. Gallen, Skt. Gallen, Kanton St. Gallen, Schweiz (LocalAdmin)
  5. Appenzell
    Appenzell, Appenzell-Innerrhoden, Kanton Appenzell Innerrhoden, Schweiz (LocalAdmin)
  6. Bühler
    Bühler, Mittelland, Kanton Appenzell Ausserrhoden, Schweiz (LocalAdmin)
  7. Gais
    Gais, Mittelland, Kanton Appenzell Ausserrhoden, Schweiz (LocalAdmin)
  8. Schlatt-Haslen
    Schlatt-Haslen, Appenzell-Innerrhoden, Kanton Appenzell Innerrhoden, Schweiz (LocalAdmin)
  9. Speicher
    Speicher, Mittelland, Kanton Appenzell Ausserrhoden, Schweiz (LocalAdmin)
  10. Teufen
    Teufen, Mittelland, Kanton Appenzell Ausserrhoden, Schweiz (LocalAdmin)

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

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

        
0.033 seconds ⌛

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