33 places near 48312, Macomb, Michigan, United States
filter by placetype:
  1. Huron Academy
    Huron Academy, Macomb, Michigan, United States (POI)
  2. Willow Woods Elementary School
    Willow Woods Elementary School, Macomb, Michigan, United States (POI)
  3. Bozymowski Center Middle School
    Bozymowski Center Middle School, Macomb, Michigan, United States (POI)
  4. Downtown
    Downtown, Macomb, Michigan, United States (Suburb)
  5. Clinton
    Clinton, Macomb, Michigan, United States (Town)
  6. Sterling-Heights
    Sterling-Heights, Macomb, Michigan, United States (Town)
  7. Warren
    Warren, Macomb, Michigan, United States (Town)
  8. Mid West
    Mid West, United States (Colloquial)
  9. Southeast Michigan
    Southeast Michigan, Michigan, United States (Colloquial)
  10. East Coast
    East Coast, United States (Colloquial)

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

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

        
0.028 seconds ⌛

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