39 places near Green Garden, Macomb, Michigan, United States
filter by placetype:
  1. Jefferson Middle School
    Jefferson Middle School, Macomb, Michigan, United States (POI)
  2. Greenwood Elementary School
    Greenwood Elementary School, Macomb, Michigan, United States (POI)
  3. Arbor Elementary School
    Arbor Elementary School, Macomb, Michigan, United States (POI)
  4. St Germaine Elementary School
    St Germaine Elementary School, Macomb, Michigan, United States (POI)
  5. Green Garden
    Green Garden, Macomb, Michigan, United States (Suburb)
  6. Ingleside Gardens
    Ingleside Gardens, Macomb, Michigan, United States (Suburb)
  7. Mack Avenue Half Acres
    Mack Avenue Half Acres, Macomb, Michigan, United States (Suburb)
  8. Statler Heights
    Statler Heights, Macomb, Michigan, United States (Suburb)
  9. Thiele
    Thiele, Macomb, Michigan, United States (Suburb)
  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.032 seconds ⌛; show me the details?

        
0.032 seconds ⌛

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