21 places near Pian, Oberhavel, Bundesland Brandenburg, Deutschland
filter by placetype:
  1. Himmelpfort
    Himmelpfort, Oberhavel, Bundesland Brandenburg, Deutschland (Town)
  2. Sähle
    Sähle, Uckermark, Bundesland Brandenburg, Deutschland (Town)
  3. Zootzen
    Zootzen, Oberhavel, Bundesland Brandenburg, Deutschland (Town)
  4. Pian
    Pian, Oberhavel, Bundesland Brandenburg, Deutschland (Town)
  5. Elbe
    Elbe, Deutschland (Drainage)
  6. Gemeinde Fürstenberg/havel
    Gemeinde Fürstenberg/havel, Oberhavel, Bundesland Brandenburg, Deutschland (LocalAdmin)
  7. Gemeinde Lychen
    Gemeinde Lychen, Uckermark, Bundesland Brandenburg, Deutschland (LocalAdmin)
  8. Mecklenburg-Strelitz
    Mecklenburg-Strelitz, Mecklenburg-Vorpommern, Deutschland (County)
  9. Uckermark
    Uckermark, Bundesland Brandenburg, Deutschland (County)
  10. Oberhavel
    Oberhavel, Bundesland Brandenburg, Deutschland (County)

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

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

        
0.028 seconds ⌛

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