18 places near 31028, Landkreis Hildesheim, Niedersachsen, Deutschland
filter by placetype:
  1. Banteln
    Banteln, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  2. Betheln
    Betheln, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  3. Dötzum
    Dötzum, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  4. Eddinghausen
    Eddinghausen, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  5. Gronau
    Gronau, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  6. Weser River
    Weser River, Deutschland (Drainage)
  7. Gemeinde Betheln
    Gemeinde Betheln, Landkreis Hildesheim, Niedersachsen, Deutschland (LocalAdmin)
  8. Gemeinde Gronau
    Gemeinde Gronau, 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.063 seconds ⌛; show me the details?

        
0.063 seconds ⌛

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