39 places near 48088, Macomb, Michigan, United States
filter by placetype:
  1. Warren Woods Middle School
    Warren Woods Middle School, Macomb, Michigan, United States (POI)
  2. Pinewood Elementary School
    Pinewood Elementary School, Macomb, Michigan, United States (POI)
  3. De La Salle Collegiate High School
    De La Salle Collegiate High School, Macomb, Michigan, United States (POI)
  4. Warren Woods Christian School
    Warren Woods Christian School, Macomb, Michigan, United States (POI)
  5. Macomb Community College-South
    Macomb Community College-South, Macomb, Michigan, United States (POI)
  6. Bella Vista Estates
    Bella Vista Estates, Macomb, Michigan, United States (Suburb)
  7. Blossom
    Blossom, Macomb, Michigan, United States (Suburb)
  8. North Warren
    North Warren, Macomb, Michigan, United States (Suburb)
  9. Warren Con
    Warren Con, Macomb, Michigan, United States (Suburb)
  10. Warren Woods
    Warren Woods, Macomb, Michigan, United States (Suburb)

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

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

        
0.054 seconds ⌛

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