25 places near Granstedt, Rotenburg an der Wümme, Niedersachsen, Deutschland
filter by placetype:
  1. Gemeinde Seedorf
    Gemeinde Seedorf, Rotenburg an der Wümme, Niedersachsen, Deutschland (LocalAdmin)
  2. Gemeinde Selsingen
    Gemeinde Selsingen, Rotenburg an der Wümme, Niedersachsen, Deutschland (LocalAdmin)
  3. Rotenburg an der Wümme
    Rotenburg an der Wümme, Niedersachsen, Deutschland (County)
  4. Landkreis Stade
    Landkreis Stade, Niedersachsen, Deutschland (County)
  5. Landkreis Cuxhaven
    Landkreis Cuxhaven, Niedersachsen, Deutschland (County)
  6. Europe/Berlin
    Europe/Berlin (Timezone)
  7. Niedersachsen
    Niedersachsen, Niedersachsen, Deutschland (State)
  8. Schleswig-Holstein
    Schleswig-Holstein, Schleswig-Holstein, Deutschland (State)
  9. Deutschland
    Deutschland, Deutschland (Country)
  10. Atlantic Ocean
    Atlantic Ocean (Ocean)

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

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

        
0.04 seconds ⌛

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