18 places near Mandelsloh, Region Hannover, Niedersachsen, Deutschland
filter by placetype:
  1. Amedorf
    Amedorf, Region Hannover, Niedersachsen, Deutschland (Town)
  2. Brase
    Brase, Region Hannover, Niedersachsen, Deutschland (Town)
  3. Mandelsloh
    Mandelsloh, Region Hannover, Niedersachsen, Deutschland (Town)
  4. Welze
    Welze, Region Hannover, Niedersachsen, Deutschland (Town)
  5. Weser River
    Weser River, Deutschland (Drainage)
  6. Gemeinde Neustadt am Rübenberge
    Gemeinde Neustadt am Rübenberge, Region Hannover, Niedersachsen, Deutschland (LocalAdmin)
  7. Gemeinde Wedemark
    Gemeinde Wedemark, Region Hannover, Niedersachsen, Deutschland (LocalAdmin)
  8. Soltau-Fallingbostel
    Soltau-Fallingbostel, Niedersachsen, Deutschland (County)
  9. Region Hannover
    Region Hannover, Niedersachsen, 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.052 seconds ⌛; show me the details?

        
0.052 seconds ⌛

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