32 places near Hakenfelde, Stadtkreis Berlin, Bundesland Berlin, Deutschland
filter by placetype:
  1. Gartenfeld
    Gartenfeld, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  2. Hakenfelde
    Hakenfelde, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  3. Johannesstift
    Johannesstift, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  4. Jörsfelde
    Jörsfelde, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  5. Klosterfelde
    Klosterfelde, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  6. Neustadt
    Neustadt, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  7. Pichelsberg
    Pichelsberg, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  8. Pichelsdorf
    Pichelsdorf, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  9. Radeland
    Radeland, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  10. Ruhleben
    Ruhleben, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)

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.20831,
                  52.558769
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}