34 places near 48091, Macomb, Michigan, United States
filter by placetype:
  1. Early Childhood Center
    Early Childhood Center, Macomb, Michigan, United States (POI)
  2. Bart Alternative Education Center
    Bart Alternative Education Center, Macomb, Michigan, United States (POI)
  3. South Warren
    South Warren, Macomb, Michigan, United States (Suburb)
  4. Fitzgerald
    Fitzgerald, Macomb, Michigan, United States (Suburb)
  5. Center Line
    Center Line, Macomb, Michigan, United States (Town)
  6. Clinton
    Clinton, Macomb, Michigan, United States (Town)
  7. Detroit
    Detroit, Wayne, Michigan, United States (Town)
  8. Warren
    Warren, Macomb, Michigan, United States (Town)
  9. Mid West
    Mid West, United States (Colloquial)
  10. Southeast Michigan
    Southeast Michigan, Michigan, United States (Colloquial)

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

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

        
0.037 seconds ⌛

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