17 places near Sandkrug, Landkreis Stade, Niedersachsen, Deutschland
filter by placetype:
  1. Helmste
    Helmste, Landkreis Stade, Niedersachsen, Deutschland (Town)
  2. Sandkrug
    Sandkrug, Landkreis Stade, Niedersachsen, Deutschland (Town)
  3. Gemeinde Deinste
    Gemeinde Deinste, Landkreis Stade, Niedersachsen, Deutschland (LocalAdmin)
  4. Gemeinde Harsefeld
    Gemeinde Harsefeld, Landkreis Stade, Niedersachsen, Deutschland (LocalAdmin)
  5. Rotenburg an der Wümme
    Rotenburg an der Wümme, Niedersachsen, Deutschland (County)
  6. Landkreis Stade
    Landkreis Stade, Niedersachsen, Deutschland (County)
  7. Stadtkreis Hamburg
    Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (County)
  8. Europe/Berlin
    Europe/Berlin (Timezone)
  9. Niedersachsen
    Niedersachsen, Niedersachsen, Deutschland (State)
  10. Schleswig-Holstein
    Schleswig-Holstein, Schleswig-Holstein, Deutschland (State)

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

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

        
0.022 seconds ⌛

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