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

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

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

        
0.095 seconds ⌛

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