32 places near Detroit River, United States
filter by placetype:
  1. Windsor
    Windsor, Essex, Ontario, Canada (Town)
  2. Clinton
    Clinton, Macomb, Michigan, United States (Town)
  3. Detroit
    Detroit, Wayne, Michigan, United States (Town)
  4. Lasalle
    Lasalle, Essex, Ontario, Canada (Town)
  5. Detroit River
    Detroit River, United States (Drainage)
  6. Mid West
    Mid West, United States (Colloquial)
  7. Southeast Michigan
    Southeast Michigan, Michigan, United States (Colloquial)
  8. East Coast
    East Coast, United States (Colloquial)
  9. US Eastern States
    US Eastern States, United States (Colloquial)
  10. Northeastern States
    Northeastern States, United States (Colloquial)

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

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

        
0.029 seconds ⌛

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