33 places near 48066, Macomb, Michigan, United States
filter by placetype:
  1. Alumni Memorial School
    Alumni Memorial School, Macomb, Michigan, United States (POI)
  2. Pierce Elementary School
    Pierce Elementary School, Macomb, Michigan, United States (POI)
  3. Roseville High School
    Roseville High School, Macomb, Michigan, United States (POI)
  4. Clinton
    Clinton, Macomb, Michigan, United States (Town)
  5. Detroit
    Detroit, Wayne, Michigan, United States (Town)
  6. Roseville
    Roseville, Macomb, Michigan, United States (Town)
  7. St. Clair Shores
    St. Clair Shores, 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.047 seconds ⌛; show me the details?

        
0.047 seconds ⌛

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