18 places near 33633 Spreenhagen, Oder-Spree, Bundesland Brandenburg, Deutschland
filter by placetype:
  1. Latzwall
    Latzwall, Oder-Spree, Bundesland Brandenburg, Deutschland (Town)
  2. Spreenhagen
    Spreenhagen, Oder-Spree, Bundesland Brandenburg, Deutschland (Town)
  3. Elbe
    Elbe, Deutschland (Drainage)
  4. Spree River
    Spree River, Deutschland (Drainage)
  5. Gemeinde Spreenhagen
    Gemeinde Spreenhagen, Oder-Spree, Bundesland Brandenburg, Deutschland (LocalAdmin)
  6. Oder-Spree
    Oder-Spree, Bundesland Brandenburg, Deutschland (County)
  7. Dahme-Spreewald
    Dahme-Spreewald, Bundesland Brandenburg, Deutschland (County)
  8. Europe/Berlin
    Europe/Berlin (Timezone)
  9. Bundesland Brandenburg
    Bundesland Brandenburg, Bundesland Brandenburg, Deutschland (State)
  10. Deutschland
    Deutschland, Deutschland (Country)

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

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

        
0.022 seconds ⌛

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