23 places near Gemeinde Ahlerstedt, Landkreis Stade, Niedersachsen, Deutschland
filter by placetype:
  1. Rotenburg an der Wümme
    Rotenburg an der Wümme, Niedersachsen, Deutschland (County)
  2. Landkreis Stade
    Landkreis Stade, Niedersachsen, Deutschland (County)
  3. Stadtkreis Hamburg
    Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (County)
  4. Europe/Berlin
    Europe/Berlin (Timezone)
  5. Niedersachsen
    Niedersachsen, Niedersachsen, Deutschland (State)
  6. Schleswig-Holstein
    Schleswig-Holstein, Schleswig-Holstein, Deutschland (State)
  7. Deutschland
    Deutschland, Deutschland (Country)
  8. Atlantic Ocean
    Atlantic Ocean (Ocean)
  9. Pacific Ocean
    Pacific Ocean (Ocean)
  10. Europe
    Europe (Continent)

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

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

        
0.043 seconds ⌛

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