36 places near Warren Woods, Macomb, Michigan, United States
filter by placetype:
  1. Warren Woods Middle School
    Warren Woods Middle School, Macomb, Michigan, United States (POI)
  2. Briarwood Elementary School
    Briarwood Elementary School, Macomb, Michigan, United States (POI)
  3. Warren Woods Tower High School
    Warren Woods Tower High School, Macomb, Michigan, United States (POI)
  4. South Warren
    South Warren, Macomb, Michigan, United States (Suburb)
  5. North Warren
    North Warren, Macomb, Michigan, United States (Suburb)
  6. Warren Con
    Warren Con, Macomb, Michigan, United States (Suburb)
  7. Warren Woods
    Warren Woods, Macomb, Michigan, United States (Suburb)
  8. Clinton
    Clinton, Macomb, Michigan, United States (Town)
  9. Detroit
    Detroit, Wayne, Michigan, United States (Town)
  10. Warren
    Warren, Macomb, Michigan, United States (Town)

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

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

        
0.024 seconds ⌛

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