23 places near Gemeinde Mühlenbecker Land, Oberhavel, Bundesland Brandenburg, Deutschland
filter by placetype:
  1. Feldheim
    Feldheim, Oberhavel, Bundesland Brandenburg, Deutschland (Town)
  2. Schönfließ
    Schönfließ, Oberhavel, Bundesland Brandenburg, Deutschland (Town)
  3. Summt
    Summt, Oberhavel, Bundesland Brandenburg, Deutschland (Town)
  4. Zühlsdorf
    Zühlsdorf, Oberhavel, Bundesland Brandenburg, Deutschland (Town)
  5. Elbe
    Elbe, Deutschland (Drainage)
  6. Gemeinde Birkenwerder
    Gemeinde Birkenwerder, Oberhavel, Bundesland Brandenburg, Deutschland (LocalAdmin)
  7. Gemeinde Hohen Neuendorf
    Gemeinde Hohen Neuendorf, Oberhavel, Bundesland Brandenburg, Deutschland (LocalAdmin)
  8. Gemeinde Mühlenbecker Land
    Gemeinde Mühlenbecker Land, Oberhavel, Bundesland Brandenburg, Deutschland (LocalAdmin)
  9. Stadtkreis Berlin
    Stadtkreis Berlin, Bundesland Berlin, Deutschland (County)
  10. Barnim
    Barnim, Bundesland Brandenburg, Deutschland (County)

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

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

        
0.046 seconds ⌛

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