21 places near Haschenbrok, Landkreis Oldenburg, Niedersachsen, Deutschland
filter by placetype:
  1. Bissel
    Bissel, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  2. Charlottendorf Ost
    Charlottendorf Ost, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  3. Haast
    Haast, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  4. Halenhorst
    Halenhorst, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  5. Haschenbrok
    Haschenbrok, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  6. Hengstlage
    Hengstlage, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  7. Sage
    Sage, Landkreis Oldenburg, Niedersachsen, Deutschland (Town)
  8. Ems River
    Ems River, Deutschland (Drainage)
  9. Gemeinde Großenkneten
    Gemeinde Großenkneten, Landkreis Oldenburg, Niedersachsen, Deutschland (LocalAdmin)
  10. Landkreis Oldenburg
    Landkreis Oldenburg, Niedersachsen, Deutschland (County)

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

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

        
0.032 seconds ⌛

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