33 places near Havel Elementary School, Macomb, Michigan, United States
filter by placetype:
  1. Jack Harvey Elementary School
    Jack Harvey Elementary School, Macomb, Michigan, United States (POI)
  2. Graebner Elementary School
    Graebner Elementary School, Macomb, Michigan, United States (POI)
  3. Havel Elementary School
    Havel Elementary School, Macomb, Michigan, United States (POI)
  4. Downtown
    Downtown, Macomb, Michigan, United States (Suburb)
  5. Clinton
    Clinton, Macomb, Michigan, United States (Town)
  6. Sterling-Heights
    Sterling-Heights, Macomb, Michigan, United States (Town)
  7. Mid West
    Mid West, United States (Colloquial)
  8. Southeast Michigan
    Southeast Michigan, Michigan, United States (Colloquial)
  9. East Coast
    East Coast, United States (Colloquial)
  10. US Eastern States
    US Eastern States, United States (Colloquial)

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

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

        
0.038 seconds ⌛

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