27 places near Rittergut Esbeck, Landkreis Hildesheim, Niedersachsen, Deutschland
filter by placetype:
  1. Freden
    Freden, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  2. Großfreden
    Großfreden, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  3. Kleinfreden
    Kleinfreden, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  4. Klump
    Klump, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  5. Schildhorst
    Schildhorst, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  6. Siedlung Leinetal
    Siedlung Leinetal, Landkreis Northeim, Niedersachsen, Deutschland (Town)
  7. Domäne Haus Freden
    Domäne Haus Freden, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  8. Rittergut Esbeck
    Rittergut Esbeck, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  9. Elbe
    Elbe, Deutschland (Drainage)
  10. Weser River
    Weser River, Deutschland (Drainage)

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

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

        
0.029 seconds ⌛

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