19 places near Esbeck, Landkreis Hildesheim, Niedersachsen, Deutschland
filter by placetype:
  1. Deilmissen
    Deilmissen, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  2. Heinsen
    Heinsen, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  3. Sehlde
    Sehlde, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  4. Esbeck
    Esbeck, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  5. Weser River
    Weser River, Deutschland (Drainage)
  6. Gemeinde Salzhemmendorf
    Gemeinde Salzhemmendorf, Hameln-Pyrmont, Niedersachsen, Deutschland (LocalAdmin)
  7. Gemeinde Eime
    Gemeinde Eime, Landkreis Hildesheim, Niedersachsen, Deutschland (LocalAdmin)
  8. Gemeinde Elze
    Gemeinde Elze, Landkreis Hildesheim, Niedersachsen, Deutschland (LocalAdmin)
  9. Landkreis Hildesheim
    Landkreis Hildesheim, Niedersachsen, Deutschland (County)
  10. Hameln-Pyrmont
    Hameln-Pyrmont, Niedersachsen, Deutschland (County)

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

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

        
0.049 seconds ⌛

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