24 places near Borghorst, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland
  1. Stadtteil Altengamme
    Stadtteil Altengamme, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (LocalAdmin)
  2. Stadtkreis Hamburg
    Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (County)
  3. Harburg
    Harburg, Niedersachsen, Deutschland (County)
  4. Herzogtum Lauenburg
    Herzogtum Lauenburg, Schleswig-Holstein, Deutschland (County)
  5. Europe/Berlin
    Europe/Berlin (Timezone)
  6. Freie und Hansestadt Hamburg
    Freie und Hansestadt Hamburg, Freie und Hansestadt Hamburg, Deutschland (State)
  7. Schleswig-Holstein
    Schleswig-Holstein, Schleswig-Holstein, Deutschland (State)
  8. Deutschland
    Deutschland, Deutschland (Country)
  9. Atlantic Ocean
    Atlantic Ocean (Ocean)
  10. Pacific Ocean
    Pacific Ocean (Ocean)

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

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

        
0.044 seconds ⌛

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