28 places near Columbiaville, Lapeer, Michigan, United States
filter by placetype:
  1. Great Lakes Region
    Great Lakes Region, United States (Colloquial)
  2. Middle America
    Middle America, United States (Colloquial)
  3. Interior Plains
    Interior Plains, United States (Colloquial)
  4. Upper Midwest
    Upper Midwest, United States (Colloquial)
  5. Continental United States
    Continental United States, United States (Colloquial)
  6. Appalachian Trail
    Appalachian Trail, United States (Colloquial)
  7. East North Central States
    East North Central States, United States (Colloquial)
  8. Lapeer
    Lapeer, Michigan, United States (County)
  9. America/New_York
    America/New_York, United States (Timezone)
  10. America/Detroit
    America/Detroit, United States (Timezone)

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

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

        
0.019 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"
      }
    }
  ],
  "from": 10
}