34 places near Roberts Elementary School, Macomb, Michigan, United States
filter by placetype:
  1. Roberts Elementary School
    Roberts Elementary School, Macomb, Michigan, United States (POI)
  2. Yates
    Yates, Oakland, Michigan, United States (Suburb)
  3. Hampton
    Hampton, Oakland, Michigan, United States (Suburb)
  4. Livernois-Tienken
    Livernois-Tienken, Oakland, Michigan, United States (Suburb)
  5. McGregor
    McGregor, Oakland, Michigan, United States (Suburb)
  6. Rochester Hills
    Rochester Hills, Oakland, Michigan, United States (Town)
  7. Shelby
    Shelby, 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.017 seconds ⌛; show me the details?

        
0.017 seconds ⌛

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