17 places near 16798, Oberhavel, Bundesland Brandenburg, Deutschland
filter by placetype:
  1. Gramzow
    Gramzow, Oberhavel, Bundesland Brandenburg, Deutschland (Town)
  2. Zootzen
    Zootzen, Oberhavel, Bundesland Brandenburg, Deutschland (Town)
  3. Elbe
    Elbe, Deutschland (Drainage)
  4. Gemeinde Fürstenberg/havel
    Gemeinde Fürstenberg/havel, Oberhavel, Bundesland Brandenburg, Deutschland (LocalAdmin)
  5. Gemeinde Gransee
    Gemeinde Gransee, Oberhavel, Bundesland Brandenburg, Deutschland (LocalAdmin)
  6. Oberhavel
    Oberhavel, Bundesland Brandenburg, Deutschland (County)
  7. Europe/Berlin
    Europe/Berlin (Timezone)
  8. Bundesland Brandenburg
    Bundesland Brandenburg, Bundesland Brandenburg, 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.058 seconds ⌛; show me the details?

        
0.058 seconds ⌛

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