20 places near Mettlen, Emmental, Kanton Bern, Schweiz
  1. Mettlen
    Mettlen, Emmental, Kanton Bern, Schweiz (Town)
  2. Rhein
    Rhein, Deutschland (Drainage)
  3. Aare River
    Aare River, Schweiz (Drainage)
  4. Romoos
    Romoos, Entlebuch, Kanton Luzern, Schweiz (LocalAdmin)
  5. Trub
    Trub, Emmental, Kanton Bern, Schweiz (LocalAdmin)
  6. Alps
    Alps (Colloquial)
  7. Entlebuch
    Entlebuch, Kanton Luzern, Schweiz (County)
  8. Emmental
    Emmental, Kanton Bern, Schweiz (County)
  9. Europe/Paris
    Europe/Paris (Timezone)
  10. Europe/Rome
    Europe/Rome (Timezone)

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

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

        
0.034 seconds ⌛

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