25 places near 30 Berlin, Deutschland
filter by placetype:
  1. Ortsteil Prenzlauer Berg
    Ortsteil Prenzlauer Berg, Stadtkreis Berlin, Bundesland Berlin, Deutschland (LocalAdmin)
  2. Ortsteil Friedrichshain
    Ortsteil Friedrichshain, Stadtkreis Berlin, Bundesland Berlin, Deutschland (LocalAdmin)
  3. Ortsteil Weißensee
    Ortsteil Weißensee, Stadtkreis Berlin, Bundesland Berlin, Deutschland (LocalAdmin)
  4. Stadtkreis Berlin
    Stadtkreis Berlin, Bundesland Berlin, Deutschland (County)
  5. Europe/Berlin
    Europe/Berlin (Timezone)
  6. Bundesland Berlin
    Bundesland Berlin, Bundesland Berlin, Deutschland (State)
  7. Deutschland
    Deutschland, Deutschland (Country)
  8. Atlantic Ocean
    Atlantic Ocean (Ocean)
  9. Pacific Ocean
    Pacific Ocean (Ocean)
  10. Europe
    Europe (Continent)

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

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

        
0.083 seconds ⌛

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