35 places near MSA Detroit-Warren-Livonia, Michigan, United States
filter by placetype:
  1. Dupont Heights
    Dupont Heights, Oakland, Michigan, United States (Suburb)
  2. East Side
    East Side, Oakland, Michigan, United States (Suburb)
  3. North Side
    North Side, Oakland, Michigan, United States (Suburb)
  4. Sterling Lakes
    Sterling Lakes, Oakland, Michigan, United States (Suburb)
  5. West Side
    West Side, Oakland, Michigan, United States (Suburb)
  6. Auburn Hills
    Auburn Hills, Oakland, Michigan, United States (Town)
  7. Lake Angelus
    Lake Angelus, Oakland, Michigan, United States (Town)
  8. Pontiac
    Pontiac, Oakland, Michigan, United States (Town)
  9. Pontiac North
    Pontiac North, Oakland, Michigan, United States (Town)
  10. Shelby
    Shelby, Macomb, Michigan, United States (Town)

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

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

        
0.035 seconds ⌛

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