24 places near Dehrenberg, Hameln-Pyrmont, Niedersachsen, Deutschland
filter by placetype:
  1. Gemeinde Aerzen
    Gemeinde Aerzen, Hameln-Pyrmont, Niedersachsen, Deutschland (LocalAdmin)
  2. Gemeinde Emmerthal
    Gemeinde Emmerthal, Hameln-Pyrmont, Niedersachsen, Deutschland (LocalAdmin)
  3. Gemeinde Hameln
    Gemeinde Hameln, Hameln-Pyrmont, Niedersachsen, Deutschland (LocalAdmin)
  4. Lippe
    Lippe, Nordrhein-Westfalen, Deutschland (County)
  5. Hameln-Pyrmont
    Hameln-Pyrmont, Niedersachsen, Deutschland (County)
  6. Europe/Berlin
    Europe/Berlin (Timezone)
  7. Niedersachsen
    Niedersachsen, Niedersachsen, 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.028 seconds ⌛; show me the details?

        
0.028 seconds ⌛

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