32 places near 4247 Affinghausen, Landkreis Diepholz, Niedersachsen, Deutschland
filter by placetype:
  1. Affinghausen
    Affinghausen, Landkreis Diepholz, Niedersachsen, Deutschland (Town)
  2. Behlmer
    Behlmer, Landkreis Diepholz, Niedersachsen, Deutschland (Town)
  3. Bensen
    Bensen, Landkreis Diepholz, Niedersachsen, Deutschland (Town)
  4. Dörriesloh
    Dörriesloh, Landkreis Diepholz, Niedersachsen, Deutschland (Town)
  5. Eitzen
    Eitzen, Landkreis Diepholz, Niedersachsen, Deutschland (Town)
  6. Hache
    Hache, Landkreis Diepholz, Niedersachsen, Deutschland (Town)
  7. Karolei
    Karolei, Landkreis Diepholz, Niedersachsen, Deutschland (Town)
  8. Klageholz
    Klageholz, Landkreis Diepholz, Niedersachsen, Deutschland (Town)
  9. Weseloh
    Weseloh, Landkreis Diepholz, Niedersachsen, Deutschland (Town)
  10. Wiefhausen
    Wiefhausen, Landkreis Diepholz, Niedersachsen, Deutschland (Town)

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": [
                  8.88874,
                  52.787991
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}