20 places near 5066 Sarstedt, Landkreis Hildesheim, Niedersachsen, Deutschland
filter by placetype:
  1. Sarstedt Bahnhof
    Sarstedt Bahnhof, Landkreis Hildesheim, Niedersachsen, Deutschland (POI)
  2. Ahrbergen
    Ahrbergen, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  3. Giften
    Giften, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  4. Ruthe
    Ruthe, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  5. Sarstedt
    Sarstedt, Landkreis Hildesheim, Niedersachsen, Deutschland (Town)
  6. Elbe
    Elbe, Deutschland (Drainage)
  7. Weser River
    Weser River, Deutschland (Drainage)
  8. Gemeinde Giesen
    Gemeinde Giesen, Landkreis Hildesheim, Niedersachsen, Deutschland (LocalAdmin)
  9. Gemeinde Sarstedt
    Gemeinde Sarstedt, Landkreis Hildesheim, Niedersachsen, Deutschland (LocalAdmin)
  10. Landkreis Hildesheim
    Landkreis Hildesheim, Niedersachsen, Deutschland (County)

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": [
                  9.85204,
                  52.23328
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}