26 places near Kessenich, Stadtkreis Bonn, Nordrhein-Westfalen, Deutschland
filter by placetype:
  1. Stadtteil Kessenich
    Stadtteil Kessenich, Stadtkreis Bonn, Nordrhein-Westfalen, Deutschland (LocalAdmin)
  2. Stadtteil Dottendorf
    Stadtteil Dottendorf, Stadtkreis Bonn, Nordrhein-Westfalen, Deutschland (LocalAdmin)
  3. Stadtteil Gronau
    Stadtteil Gronau, Stadtkreis Bonn, Nordrhein-Westfalen, Deutschland (LocalAdmin)
  4. Rhein-Sieg-Kreis
    Rhein-Sieg-Kreis, Nordrhein-Westfalen, Deutschland (County)
  5. Stadtkreis Bonn
    Stadtkreis Bonn, Nordrhein-Westfalen, Deutschland (County)
  6. Europe/Berlin
    Europe/Berlin (Timezone)
  7. Europe/Paris
    Europe/Paris (Timezone)
  8. Nordrhein-Westfalen
    Nordrhein-Westfalen, Nordrhein-Westfalen, Deutschland (State)
  9. Deutschland
    Deutschland, Deutschland (Country)
  10. Atlantic Ocean
    Atlantic Ocean (Ocean)

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

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

        
0.043 seconds ⌛

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