18 places near Gemeinde Kotzen, Havelland, Bundesland Brandenburg, Deutschland
filter by placetype:
  1. Kotzen
    Kotzen, Havelland, Bundesland Brandenburg, Deutschland (Town)
  2. Kriele
    Kriele, Havelland, Bundesland Brandenburg, Deutschland (Town)
  3. Landin
    Landin, Havelland, Bundesland Brandenburg, Deutschland (Town)
  4. Elbe
    Elbe, Deutschland (Drainage)
  5. Gemeinde Kotzen
    Gemeinde Kotzen, Havelland, Bundesland Brandenburg, Deutschland (LocalAdmin)
  6. Mühlenberge
    Mühlenberge, Havelland, Bundesland Brandenburg, Deutschland (LocalAdmin)
  7. Havelland
    Havelland, Bundesland Brandenburg, Deutschland (County)
  8. Europe/Berlin
    Europe/Berlin (Timezone)
  9. Bundesland Brandenburg
    Bundesland Brandenburg, Bundesland Brandenburg, Deutschland (State)
  10. Sachsen-Anhalt
    Sachsen-Anhalt, Sachsen-Anhalt, Deutschland (State)

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

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

        
0.024 seconds ⌛

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