18 places near Derneburg, 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. Heersum
    Heersum, 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.031 seconds ⌛; show me the details?

        
0.031 seconds ⌛

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