24 places near Marzili, Bern-Mittelland, Kanton Bern, Schweiz
  1. Breitenrain
    Breitenrain, Bern-Mittelland, Kanton Bern, Schweiz (Suburb)
  2. Engehalde
    Engehalde, Bern-Mittelland, Kanton Bern, Schweiz (Suburb)
  3. Kirchenfel
    Kirchenfel, Bern-Mittelland, Kanton Bern, Schweiz (Suburb)
  4. Langgasse
    Langgasse, Bern-Mittelland, Kanton Bern, Schweiz (Suburb)
  5. Marzili
    Marzili, Bern-Mittelland, Kanton Bern, Schweiz (Suburb)
  6. Mattenhof
    Mattenhof, Bern-Mittelland, Kanton Bern, Schweiz (Suburb)
  7. Weisenbuhl
    Weisenbuhl, 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.026 seconds ⌛; show me the details?

        
0.026 seconds ⌛

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