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

        
0.018 seconds ⌛

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