6 places near 33052 Leegebruch, Oberhavel, Bundesland Brandenburg, Deutschland
filter by placetype:
  1. Gemeinde Hohen Neuendorf
    Gemeinde Hohen Neuendorf, Oberhavel, Bundesland Brandenburg, Deutschland (LocalAdmin)
  2. Gemeinde Leegebruch
    Gemeinde Leegebruch, Oberhavel, Bundesland Brandenburg, Deutschland (LocalAdmin)
  3. Gemeinde Oranienburg
    Gemeinde Oranienburg, Oberhavel, Bundesland Brandenburg, Deutschland (LocalAdmin)
  4. Gemeinde Velten
    Gemeinde Velten, Oberhavel, Bundesland Brandenburg, Deutschland (LocalAdmin)
  5. Gemeinde Kremmen
    Gemeinde Kremmen, Oberhavel, Bundesland Brandenburg, Deutschland (LocalAdmin)
  6. Oberkrämer
    Oberkrämer, Oberhavel, Bundesland Brandenburg, Deutschland (LocalAdmin)

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

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

        
0.031 seconds ⌛

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