30 places near Stralau, Stadtkreis Berlin, Bundesland Berlin, Deutschland
filter by placetype:
  1. Berlin-Ostkreuz Bahnhof
    Berlin-Ostkreuz Bahnhof, Stadtkreis Berlin, Bundesland Berlin, Deutschland (POI)
  2. Berlin-Rummelsburg Bahnhof
    Berlin-Rummelsburg Bahnhof, Stadtkreis Berlin, Bundesland Berlin, Deutschland (POI)
  3. Berlin-Treptower Park Bahnhof
    Berlin-Treptower Park Bahnhof, Stadtkreis Berlin, Bundesland Berlin, Deutschland (POI)
  4. Friedrichsberg
    Friedrichsberg, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  5. Rummelsburg
    Rummelsburg, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  6. Stralau
    Stralau, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  7. Weiße Taube
    Weiße Taube, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  8. Wilhelmsberg
    Wilhelmsberg, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  9. Plänterwald
    Plänterwald, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  10. Alt-Treptow
    Alt-Treptow, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)

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

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

        
0.031 seconds ⌛

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