4 places near 33052 Leegebruch, Oberhavel, Bundesland Brandenburg, Deutschland
filter by placetype:
  1. Germendorf
    Germendorf, Oberhavel, Bundesland Brandenburg, Deutschland (Town)
  2. Leegebruch
    Leegebruch, Oberhavel, Bundesland Brandenburg, Deutschland (Town)
  3. Oranienburg
    Oranienburg, Oberhavel, Bundesland Brandenburg, Deutschland (Town)
  4. Velten
    Velten, Oberhavel, Bundesland Brandenburg, Deutschland (Town)

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

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

        
0.039 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  13.19271,
                  52.725681
                ]
              }
            }
          }
        },
        {
          "term": {
            "woe:placetype": 7
          }
        }
      ],
      "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"
      }
    }
  ]
}