28 places near Spree River, Deutschland
  1. Gemeinde Friedland
    Gemeinde Friedland, Oder-Spree, Bundesland Brandenburg, Deutschland (LocalAdmin)
  2. Gemeinde Tauche
    Gemeinde Tauche, Oder-Spree, Bundesland Brandenburg, Deutschland (LocalAdmin)
  3. Gemeinde Schwielochsee
    Gemeinde Schwielochsee, Dahme-Spreewald, Bundesland Brandenburg, Deutschland (LocalAdmin)
  4. Spree-Neiße
    Spree-Neiße, Bundesland Brandenburg, Deutschland (County)
  5. Oder-Spree
    Oder-Spree, Bundesland Brandenburg, Deutschland (County)
  6. Dahme-Spreewald
    Dahme-Spreewald, Bundesland Brandenburg, Deutschland (County)
  7. Europe/Berlin
    Europe/Berlin (Timezone)
  8. Europe/Warsaw
    Europe/Warsaw (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.035 seconds ⌛; show me the details?

        
0.035 seconds ⌛

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