30 places near Friedrichshain-Kreuzberg, Stadtkreis Berlin, Bundesland Berlin, Deutschland
filter by placetype:
  1. Fennpfuhl
    Fennpfuhl, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  2. Friedrichshain-Kreuzberg
    Friedrichshain-Kreuzberg, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  3. Berlin
    Berlin, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Town)
  4. Elbe
    Elbe, Deutschland (Drainage)
  5. Spree River
    Spree River, Deutschland (Drainage)
  6. Ortsteil Prenzlauer Berg
    Ortsteil Prenzlauer Berg, Stadtkreis Berlin, Bundesland Berlin, Deutschland (LocalAdmin)
  7. Ortsteil Friedrichshain
    Ortsteil Friedrichshain, Stadtkreis Berlin, Bundesland Berlin, Deutschland (LocalAdmin)
  8. Ortsteil Lichtenberg
    Ortsteil Lichtenberg, Stadtkreis Berlin, Bundesland Berlin, Deutschland (LocalAdmin)
  9. Stadtkreis Berlin
    Stadtkreis Berlin, Bundesland Berlin, 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.058 seconds ⌛; show me the details?

        
0.058 seconds ⌛

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