24 places near Roggow, Uecker-Randow, Mecklenburg-Vorpommern, Deutschland
filter by placetype:
  1. Gemeinde Zerrenthin
    Gemeinde Zerrenthin, Uecker-Randow, Mecklenburg-Vorpommern, Deutschland (LocalAdmin)
  2. Uecker-Randow
    Uecker-Randow, Mecklenburg-Vorpommern, Deutschland (County)
  3. Uckermark
    Uckermark, Bundesland Brandenburg, Deutschland (County)
  4. Europe/Berlin
    Europe/Berlin (Timezone)
  5. Mecklenburg-Vorpommern
    Mecklenburg-Vorpommern, Mecklenburg-Vorpommern, Deutschland (State)
  6. Deutschland
    Deutschland, Deutschland (Country)
  7. Atlantic Ocean
    Atlantic Ocean (Ocean)
  8. Pacific Ocean
    Pacific Ocean (Ocean)
  9. Europe
    Europe (Continent)
  10. USSR
    USSR (Supername)

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

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

        
0.012 seconds ⌛

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