31 places near 14089, Stadtkreis Berlin, Bundesland Berlin, Deutschland
  1. Gatow Airport
    Gatow Airport, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Airport)
  2. Groß Glienicke
    Groß Glienicke, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  3. Hottengrund
    Hottengrund, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  4. Neu Kladow
    Neu Kladow, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  5. Spandauer Weinberge
    Spandauer Weinberge, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  6. Wochenend West
    Wochenend West, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  7. Groß Glienicke
    Groß Glienicke, Stadtkreis Potsdam, Bundesland Brandenburg, Deutschland (Suburb)
  8. Berlin
    Berlin, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Town)
  9. Potsdam
    Potsdam, Stadtkreis Potsdam, Bundesland Brandenburg, Deutschland (Town)
  10. Elbe
    Elbe, Deutschland (Drainage)

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

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

        
0.039 seconds ⌛

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