1. Brandenburg
   Brandenburg, Stadtkreis Brandenburg an der Havel, Bundesland Brandenburg, Deutschland (Town)
2. Brielow
   Brielow, Potsdam-Mittelmark, Bundesland Brandenburg, Deutschland (Town)
3. Beetzsee
   Beetzsee, Potsdam-Mittelmark, Bundesland Brandenburg, Deutschland (Town)
4. Elbe
   Elbe, Deutschland (Drainage)
5. Gemeinde Brandenburg an der Havel
   Gemeinde Brandenburg an der Havel, Stadtkreis Brandenburg an der Havel, Bundesland Brandenburg, Deutschland (LocalAdmin)
6. Gemeinde Beetzsee
   Gemeinde Beetzsee, Potsdam-Mittelmark, Bundesland Brandenburg, Deutschland (LocalAdmin)
7. Gemeinde Havelsee
   Gemeinde Havelsee, Potsdam-Mittelmark, Bundesland Brandenburg, Deutschland (LocalAdmin)
8. Potsdam-Mittelmark
   Potsdam-Mittelmark, Bundesland Brandenburg, Deutschland (County)
9. Havelland
   Havelland, Bundesland Brandenburg, Deutschland (County)
10. Stadtkreis Brandenburg an der Havel
    Stadtkreis Brandenburg an der Havel, Bundesland Brandenburg, Deutschland (County)

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

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

        
0.023 seconds ⌛
{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  12.5378,
                  52.460739
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}