27 places near Brunnadern, Bern-Mittelland, Kanton Bern, Schweiz
  1. Brunnadern
    Brunnadern, Bern-Mittelland, Kanton Bern, Schweiz (Suburb)
  2. Elfenau
    Elfenau, Bern-Mittelland, Kanton Bern, Schweiz (Suburb)
  3. Kirchenfel
    Kirchenfel, Bern-Mittelland, Kanton Bern, Schweiz (Suburb)
  4. Melchenbühl
    Melchenbühl, Bern-Mittelland, Kanton Bern, Schweiz (Suburb)
  5. Schosshald
    Schosshald, Bern-Mittelland, Kanton Bern, Schweiz (Suburb)
  6. Wabern
    Wabern, Bern-Mittelland, Kanton Bern, Schweiz (Suburb)
  7. Wittigkofen
    Wittigkofen, Bern-Mittelland, Kanton Bern, Schweiz (Suburb)
  8. Bern
    Bern, Bern-Mittelland, Kanton Bern, Schweiz (Town)
  9. Rhein
    Rhein, Deutschland (Drainage)
  10. Aare River
    Aare River, Schweiz (Drainage)

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

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

        
0.03 seconds ⌛

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