21 places near Mesmerode, Region Hannover, Niedersachsen, Deutschland
filter by placetype:
  1. Bokeloh
    Bokeloh, Region Hannover, Niedersachsen, Deutschland (Town)
  2. Hagenburg
    Hagenburg, Landkreis Schaumburg, Niedersachsen, Deutschland (Town)
  3. Mesmerode
    Mesmerode, Region Hannover, Niedersachsen, Deutschland (Town)
  4. Niengraben
    Niengraben, Region Hannover, Niedersachsen, Deutschland (Town)
  5. Kolonie Idensen
    Kolonie Idensen, Region Hannover, Niedersachsen, Deutschland (Town)
  6. Weser River
    Weser River, Deutschland (Drainage)
  7. Gemeinde Wunstorf
    Gemeinde Wunstorf, Region Hannover, Niedersachsen, Deutschland (LocalAdmin)
  8. Gemeinde Hagenburg
    Gemeinde Hagenburg, Landkreis Schaumburg, Niedersachsen, Deutschland (LocalAdmin)
  9. Gemeinde Haste
    Gemeinde Haste, Landkreis Schaumburg, Niedersachsen, Deutschland (LocalAdmin)
  10. Landkreis Schaumburg
    Landkreis Schaumburg, Niedersachsen, Deutschland (County)

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

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

        
0.016 seconds ⌛

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