25 places near Bornheim, Rhein-Sieg-Kreis, Nordrhein-Westfalen, Deutschland
filter by placetype:
  1. Gemeinde Niederkassel
    Gemeinde Niederkassel, Rhein-Sieg-Kreis, Nordrhein-Westfalen, Deutschland (LocalAdmin)
  2. Rhein-Sieg-Kreis
    Rhein-Sieg-Kreis, Nordrhein-Westfalen, Deutschland (County)
  3. Erftkreis
    Erftkreis, Nordrhein-Westfalen, Deutschland (County)
  4. Europe/Amsterdam
    Europe/Amsterdam (Timezone)
  5. Europe/Berlin
    Europe/Berlin (Timezone)
  6. Europe/Paris
    Europe/Paris (Timezone)
  7. Nordrhein-Westfalen
    Nordrhein-Westfalen, Nordrhein-Westfalen, Deutschland (State)
  8. Deutschland
    Deutschland, Deutschland (Country)
  9. Atlantic Ocean
    Atlantic Ocean (Ocean)
  10. Pacific Ocean
    Pacific Ocean (Ocean)

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

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

        
0.012 seconds ⌛

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