29 places near Bundesland Berlin, Bundesland Berlin, Deutschland
filter by placetype:
  1. Friedrichshain-Kreuzberg
    Friedrichshain-Kreuzberg, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  2. Berlin
    Berlin, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Town)
  3. Elbe
    Elbe, Deutschland (Drainage)
  4. Spree River
    Spree River, Deutschland (Drainage)
  5. Ortsteil Mitte
    Ortsteil Mitte, Stadtkreis Berlin, Bundesland Berlin, Deutschland (LocalAdmin)
  6. Ortsteil Kreuzberg
    Ortsteil Kreuzberg, Stadtkreis Berlin, Bundesland Berlin, Deutschland (LocalAdmin)
  7. Ortsteil Friedrichshain
    Ortsteil Friedrichshain, Stadtkreis Berlin, Bundesland Berlin, Deutschland (LocalAdmin)
  8. Stadtkreis Berlin
    Stadtkreis Berlin, Bundesland Berlin, Deutschland (County)
  9. Europe/Berlin
    Europe/Berlin (Timezone)
  10. Bundesland Berlin
    Bundesland Berlin, Bundesland Berlin, Deutschland (State)

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.425,
                  52.507
                ]
              }
            }
          }
        }
      ],
      "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
}