29 places near 3207, Bern-Mittelland, Kanton Bern, Schweiz
  1. Käppeli
    Käppeli, Bern-Mittelland, Kanton Bern, Schweiz (Town)
  2. Wileroltigen
    Wileroltigen, Bern-Mittelland, Kanton Bern, Schweiz (Town)
  3. Golaten
    Golaten, Bern-Mittelland, Kanton Bern, Schweiz (Town)
  4. Marfeldingen
    Marfeldingen, Bern-Mittelland, Kanton Bern, Schweiz (Town)
  5. Oberruntigen
    Oberruntigen, Seeland, Kanton Bern, Schweiz (Town)
  6. Oltigen
    Oltigen, Seeland, Kanton Bern, Schweiz (Town)
  7. Rhein
    Rhein, Deutschland (Drainage)
  8. Aare River
    Aare River, Schweiz (Drainage)
  9. Mühleberg
    Mühleberg, Bern-Mittelland, Kanton Bern, Schweiz (LocalAdmin)
  10. Golaten
    Golaten, Bern-Mittelland, Kanton Bern, Schweiz (LocalAdmin)

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

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

        
0.558 seconds ⌛

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