18 places near Osterbrook, Emsland, Niedersachsen, Deutschland
filter by placetype:
  1. Osterbrock
    Osterbrock, Emsland, Niedersachsen, Deutschland (Town)
  2. Siedlung Osterbrock
    Siedlung Osterbrock, Emsland, Niedersachsen, Deutschland (Town)
  3. Osterbrook
    Osterbrook, Emsland, Niedersachsen, Deutschland (Town)
  4. Ems River
    Ems River, Deutschland (Drainage)
  5. Gemeinde Geeste
    Gemeinde Geeste, Emsland, Niedersachsen, Deutschland (LocalAdmin)
  6. Gemeinde Meppen
    Gemeinde Meppen, Emsland, Niedersachsen, Deutschland (LocalAdmin)
  7. Grafschaft Bentheim
    Grafschaft Bentheim, Niedersachsen, Deutschland (County)
  8. Emsland
    Emsland, Niedersachsen, 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.036 seconds ⌛; show me the details?

        
0.036 seconds ⌛

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