20 places near Gemeinde Kremmen, Oberhavel, Bundesland Brandenburg, Deutschland
filter by placetype:
  1. Beetz
    Beetz, Oberhavel, Bundesland Brandenburg, Deutschland (Town)
  2. Kremmen
    Kremmen, Oberhavel, Bundesland Brandenburg, Deutschland (Town)
  3. Sommerfeld
    Sommerfeld, Oberhavel, Bundesland Brandenburg, Deutschland (Town)
  4. Elbe
    Elbe, Deutschland (Drainage)
  5. Gemeinde Kremmen
    Gemeinde Kremmen, Oberhavel, Bundesland Brandenburg, Deutschland (LocalAdmin)
  6. Gemeinde Löwenberger Land
    Gemeinde Löwenberger Land, Oberhavel, Bundesland Brandenburg, Deutschland (LocalAdmin)
  7. Ostprignitz-Ruppin
    Ostprignitz-Ruppin, Bundesland Brandenburg, Deutschland (County)
  8. Oberhavel
    Oberhavel, 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.049 seconds ⌛; show me the details?

        
0.049 seconds ⌛

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