19 places near Mecklenhorst, Region Hannover, Niedersachsen, Deutschland
filter by placetype:
  1. Mecklenhorst
    Mecklenhorst, Region Hannover, Niedersachsen, Deutschland (Town)
  2. Neustadt am Rübenberge
    Neustadt am Rübenberge, Region Hannover, Niedersachsen, Deutschland (Town)
  3. Otternhagen
    Otternhagen, Region Hannover, Niedersachsen, Deutschland (Town)
  4. Suttorf
    Suttorf, Region Hannover, Niedersachsen, Deutschland (Town)
  5. Weser River
    Weser River, Deutschland (Drainage)
  6. Gemeinde Garbsen
    Gemeinde Garbsen, Region Hannover, Niedersachsen, Deutschland (LocalAdmin)
  7. Gemeinde Neustadt am Rübenberge
    Gemeinde Neustadt am Rübenberge, Region Hannover, Niedersachsen, Deutschland (LocalAdmin)
  8. Gemeinde Wunstorf
    Gemeinde Wunstorf, Region Hannover, Niedersachsen, Deutschland (LocalAdmin)
  9. Nienburg-Weser
    Nienburg-Weser, Niedersachsen, Deutschland (County)
  10. Region Hannover
    Region Hannover, Niedersachsen, Deutschland (County)

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

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

        
0.037 seconds ⌛

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