36 places near Oakland/Troy Airport, Oakland, Michigan, United States
filter by placetype:
  1. Oakland/Troy Airport
    Oakland/Troy Airport, Oakland, Michigan, United States (Airport)
  2. East Birmingham
    East Birmingham, Oakland, Michigan, United States (Suburb)
  3. Eton
    Eton, Oakland, Michigan, United States (Suburb)
  4. Pembroke
    Pembroke, Oakland, Michigan, United States (Suburb)
  5. Sheffield
    Sheffield, Oakland, Michigan, United States (Suburb)
  6. Nordwood Estates
    Nordwood Estates, Oakland, Michigan, United States (Suburb)
  7. Beverly Hills
    Beverly Hills, Oakland, Michigan, United States (Town)
  8. Birmingham
    Birmingham, Oakland, Michigan, United States (Town)
  9. Clawson
    Clawson, Oakland, Michigan, United States (Town)
  10. Clinton
    Clinton, Macomb, Michigan, United States (Town)

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

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

        
0.025 seconds ⌛

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