28 places near Columbiaville, Lapeer, Michigan, United States
filter by placetype:
  1. Columbiaville Elementary School
    Columbiaville Elementary School, Lapeer, Michigan, United States (POI)
  2. Columbiaville
    Columbiaville, Lapeer, Michigan, United States (Town)
  3. Shelby
    Shelby, Macomb, Michigan, United States (Town)
  4. Marathon
    Marathon, Lapeer, Michigan, United States (Town)
  5. Mid West
    Mid West, United States (Colloquial)
  6. Southeast Michigan
    Southeast Michigan, Michigan, United States (Colloquial)
  7. East Coast
    East Coast, United States (Colloquial)
  8. US Eastern States
    US Eastern States, United States (Colloquial)
  9. Northeastern States
    Northeastern States, United States (Colloquial)
  10. Canada International Border States
    Canada International Border States, United States (Colloquial)

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

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

        
0.02 seconds ⌛

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