34 places near Warren, Macomb, Michigan, United States
filter by placetype:
  1. Conner Creek Academy
    Conner Creek Academy, Macomb, Michigan, United States (POI)
  2. Downtown
    Downtown, Macomb, Michigan, United States (Suburb)
  3. Lorraine
    Lorraine, Macomb, Michigan, United States (Suburb)
  4. North Warren
    North Warren, Macomb, Michigan, United States (Suburb)
  5. Warren Con
    Warren Con, Macomb, Michigan, United States (Suburb)
  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.04 seconds ⌛; show me the details?

        
0.04 seconds ⌛

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