20 places near Gemeinde Ketzin, Havelland, Bundesland Brandenburg, Deutschland
filter by placetype:
  1. Etzin
    Etzin, Havelland, Bundesland Brandenburg, Deutschland (Town)
  2. Fernewerder
    Fernewerder, Havelland, Bundesland Brandenburg, Deutschland (Town)
  3. Tremmen
    Tremmen, Havelland, Bundesland Brandenburg, Deutschland (Town)
  4. Vor Ketzin
    Vor Ketzin, Havelland, Bundesland Brandenburg, Deutschland (Town)
  5. Elbe
    Elbe, Deutschland (Drainage)
  6. Gemeinde Ketzin
    Gemeinde Ketzin, Havelland, Bundesland Brandenburg, Deutschland (LocalAdmin)
  7. Gemeinde Nauen
    Gemeinde Nauen, Havelland, Bundesland Brandenburg, Deutschland (LocalAdmin)
  8. Potsdam-Mittelmark
    Potsdam-Mittelmark, Bundesland Brandenburg, Deutschland (County)
  9. Havelland
    Havelland, Bundesland Brandenburg, Deutschland (County)
  10. Europe/Berlin
    Europe/Berlin (Timezone)

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

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

        
0.053 seconds ⌛

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