19 places near Ahlerstedt, Landkreis Stade, Niedersachsen, Deutschland
filter by placetype:
  1. Ahlerstedt
    Ahlerstedt, Landkreis Stade, Niedersachsen, Deutschland (Town)
  2. Klethen
    Klethen, Landkreis Stade, Niedersachsen, Deutschland (Town)
  3. Bockholt
    Bockholt, Landkreis Stade, Niedersachsen, Deutschland (Town)
  4. Weser River
    Weser River, Deutschland (Drainage)
  5. Gemeinde Ahlerstedt
    Gemeinde Ahlerstedt, Landkreis Stade, Niedersachsen, Deutschland (LocalAdmin)
  6. Gemeinde Harsefeld
    Gemeinde Harsefeld, Landkreis Stade, Niedersachsen, Deutschland (LocalAdmin)
  7. Rotenburg an der Wümme
    Rotenburg an der Wümme, Niedersachsen, Deutschland (County)
  8. Landkreis Stade
    Landkreis Stade, Niedersachsen, Deutschland (County)
  9. Stadtkreis Hamburg
    Stadtkreis Hamburg, Freie und Hansestadt Hamburg, 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.037 seconds ⌛; show me the details?

        
0.037 seconds ⌛

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