17 places near Mahlerten, Landkreis Hildesheim, Niedersachsen, Deutschland
filter by placetype:
  1. Burgstemmen
    Burgstemmen, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  2. Heyersum
    Heyersum, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  3. Mahlerten
    Mahlerten, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  4. Nordstemmen
    Nordstemmen, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  5. Weser River
    Weser River, Deutschland (Drainage)
  6. Gemeinde Nordstemmen
    Gemeinde Nordstemmen, Landkreis Hildesheim, Niedersachsen, Deutschland (LocalAdmin)
  7. Landkreis Hildesheim
    Landkreis Hildesheim, Niedersachsen, Deutschland (County)
  8. Region Hannover
    Region Hannover, Niedersachsen, Deutschland (County)
  9. Europe/Berlin
    Europe/Berlin (Timezone)
  10. Niedersachsen
    Niedersachsen, Niedersachsen, Deutschland (State)

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

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

        
0.055 seconds ⌛

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