27 places near Mattstetten, Bern-Mittelland, Kanton Bern, Schweiz
  1. Bäriswil
    Bäriswil, Bern-Mittelland, Kanton Bern, Schweiz (Town)
  2. Schönbühl
    Schönbühl, Bern-Mittelland, Kanton Bern, Schweiz (Town)
  3. Urtenen
    Urtenen, Bern-Mittelland, Kanton Bern, Schweiz (Town)
  4. Mattstetten
    Mattstetten, Bern-Mittelland, Kanton Bern, Schweiz (Town)
  5. Sand
    Sand, Bern-Mittelland, Kanton Bern, Schweiz (Town)
  6. Urtenen-schönbühl
    Urtenen-schönbühl, Bern-Mittelland, Kanton Bern, Schweiz (Town)
  7. Rhein
    Rhein, Deutschland (Drainage)
  8. Aare River
    Aare River, Schweiz (Drainage)
  9. Bäriswil
    Bäriswil, Bern-Mittelland, Kanton Bern, Schweiz (LocalAdmin)
  10. Hindelbank
    Hindelbank, Emmental, Kanton Bern, Schweiz (LocalAdmin)

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

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

        
0.018 seconds ⌛

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