21 places near Oberkrämer, Oberhavel, Bundesland Brandenburg, Deutschland
filter by placetype:
  1. Eichstädt
    Eichstädt, Oberhavel, Bundesland Brandenburg, Deutschland (Town)
  2. Neu-Vehlefanz
    Neu-Vehlefanz, Oberhavel, Bundesland Brandenburg, Deutschland (Town)
  3. Oberkrämer
    Oberkrämer, Oberhavel, Bundesland Brandenburg, Deutschland (Town)
  4. Elbe
    Elbe, Deutschland (Drainage)
  5. Gemeinde Schönwalde
    Gemeinde Schönwalde, Havelland, Bundesland Brandenburg, Deutschland (LocalAdmin)
  6. Oberkrämer
    Oberkrämer, Oberhavel, Bundesland Brandenburg, Deutschland (LocalAdmin)
  7. Stadtkreis Berlin
    Stadtkreis Berlin, Bundesland Berlin, Deutschland (County)
  8. Oberhavel
    Oberhavel, Bundesland Brandenburg, Deutschland (County)
  9. Havelland
    Havelland, Bundesland Brandenburg, Deutschland (County)
  10. Europe/Berlin
    Europe/Berlin (Timezone)

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

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

        
0.029 seconds ⌛

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