16 places near Borrentin, Landkreis Demmin, Mecklenburg-Vorpommern, Deutschland
filter by placetype:
  1. Borrentin
    Borrentin, Landkreis Demmin, Mecklenburg-Vorpommern, Deutschland (Town)
  2. Metschow
    Metschow, Landkreis Demmin, Mecklenburg-Vorpommern, Deutschland (Town)
  3. Gemeinde Meesiger
    Gemeinde Meesiger, Landkreis Demmin, Mecklenburg-Vorpommern, Deutschland (LocalAdmin)
  4. Gemeinde Borrentin
    Gemeinde Borrentin, Landkreis Demmin, Mecklenburg-Vorpommern, Deutschland (LocalAdmin)
  5. Ostsee
    Ostsee, Mecklenburg-Vorpommern, Deutschland (Colloquial)
  6. Landkreis Demmin
    Landkreis Demmin, Mecklenburg-Vorpommern, Deutschland (County)
  7. Europe/Berlin
    Europe/Berlin (Timezone)
  8. Mecklenburg-Vorpommern
    Mecklenburg-Vorpommern, Mecklenburg-Vorpommern, Deutschland (State)
  9. Deutschland
    Deutschland, Deutschland (Country)
  10. Atlantic Ocean
    Atlantic Ocean (Ocean)

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

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

        
0.046 seconds ⌛

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