20 places near Oberhavel, Bundesland Brandenburg, Deutschland
filter by placetype:
  1. Klevesche Häuser
    Klevesche Häuser, Oberhavel, Bundesland Brandenburg, Deutschland (Town)
  2. Löwenberg
    Löwenberg, Oberhavel, Bundesland Brandenburg, Deutschland (Town)
  3. Moncaprice
    Moncaprice, Oberhavel, Bundesland Brandenburg, Deutschland (Town)
  4. Neuhäsen
    Neuhäsen, Oberhavel, Bundesland Brandenburg, Deutschland (Town)
  5. Neulöwenberg
    Neulöwenberg, Oberhavel, Bundesland Brandenburg, Deutschland (Town)
  6. Elbe
    Elbe, Deutschland (Drainage)
  7. Gemeinde Löwenberger Land
    Gemeinde Löwenberger Land, Oberhavel, Bundesland Brandenburg, Deutschland (LocalAdmin)
  8. Oberhavel
    Oberhavel, Bundesland Brandenburg, Deutschland (County)
  9. Europe/Berlin
    Europe/Berlin (Timezone)
  10. Bundesland Brandenburg
    Bundesland Brandenburg, Bundesland Brandenburg, Deutschland (State)

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

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

        
0.019 seconds ⌛

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