22 places near Ortsteil Prenzlauer Berg, Stadtkreis Berlin, Bundesland Berlin, Deutschland
  1. Berlin-Prenzlauer Allee Bahnhof
    Berlin-Prenzlauer Allee Bahnhof, Stadtkreis Berlin, Bundesland Berlin, Deutschland (POI)
  2. Eberswalder Strasse Bahnhof
    Eberswalder Strasse Bahnhof, Stadtkreis Berlin, Bundesland Berlin, Deutschland (POI)
  3. Friedrichsberg
    Friedrichsberg, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  4. Friedrichshain-Kreuzberg
    Friedrichshain-Kreuzberg, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Suburb)
  5. Berlin
    Berlin, Stadtkreis Berlin, Bundesland Berlin, Deutschland (Town)
  6. Elbe
    Elbe, Deutschland (Drainage)
  7. Spree River
    Spree River, Deutschland (Drainage)
  8. Ortsteil Pankow
    Ortsteil Pankow, Stadtkreis Berlin, Bundesland Berlin, Deutschland (LocalAdmin)
  9. Ortsteil Prenzlauer Berg
    Ortsteil Prenzlauer Berg, Stadtkreis Berlin, Bundesland Berlin, Deutschland (LocalAdmin)
  10. Stadtkreis Berlin
    Stadtkreis Berlin, Bundesland Berlin, Deutschland (County)

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

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

        
0.049 seconds ⌛

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