18 places near Gemeinde Hammah, Landkreis Stade, Niedersachsen, Deutschland
filter by placetype:
  1. Groß Sterneberg
    Groß Sterneberg, Landkreis Stade, Niedersachsen, Deutschland (Town)
  2. Hammah
    Hammah, Landkreis Stade, Niedersachsen, Deutschland (Town)
  3. Klein Villah
    Klein Villah, Landkreis Stade, Niedersachsen, Deutschland (Town)
  4. Gemeinde Hammah
    Gemeinde Hammah, Landkreis Stade, Niedersachsen, Deutschland (LocalAdmin)
  5. Gemeinde Stade
    Gemeinde Stade, Landkreis Stade, Niedersachsen, Deutschland (LocalAdmin)
  6. Landkreis Stade
    Landkreis Stade, Niedersachsen, Deutschland (County)
  7. Stadtkreis Hamburg
    Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (County)
  8. Landkreis Pinneberg
    Landkreis Pinneberg, Schleswig-Holstein, Deutschland (County)
  9. Europe/Berlin
    Europe/Berlin (Timezone)
  10. Niedersachsen
    Niedersachsen, Niedersachsen, Deutschland (State)

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

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

        
0.021 seconds ⌛

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