21 places near Gemeinde Hatten, Landkreis Oldenburg, Niedersachsen, Deutschland
filter by placetype:
  1. Hatterwüsting
    Hatterwüsting, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  2. Heidhusen
    Heidhusen, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  3. Munderloh
    Munderloh, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  4. Sandtange
    Sandtange, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  5. Hattermühle
    Hattermühle, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  6. Ems River
    Ems River, Deutschland (Drainage)
  7. Weser River
    Weser River, Deutschland (Drainage)
  8. Gemeinde Hatten
    Gemeinde Hatten, Landkreis Oldenburg, Niedersachsen, Deutschland (LocalAdmin)
  9. Gemeinde Hude
    Gemeinde Hude, Landkreis Oldenburg, Niedersachsen, Deutschland (LocalAdmin)
  10. Landkreis Diepholz
    Landkreis Diepholz, Niedersachsen, Deutschland (County)

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": [
                  8.32413,
                  53.04845
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}