18 places near 31188, Landkreis Hildesheim, Niedersachsen, Deutschland
filter by placetype:
  1. Astenbeck
    Astenbeck, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  2. Derneburg
    Derneburg, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  3. Hackenstedt
    Hackenstedt, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  4. Holle
    Holle, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  5. Sottrum
    Sottrum, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  6. Elbe
    Elbe, Deutschland (Drainage)
  7. Weser River
    Weser River, Deutschland (Drainage)
  8. Gemeinde Holle
    Gemeinde Holle, Landkreis Hildesheim, Niedersachsen, Deutschland (LocalAdmin)
  9. Landkreis Hildesheim
    Landkreis Hildesheim, 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.08 seconds ⌛; show me the details?

        
0.08 seconds ⌛

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