26 places near MSA Columbia, Missouri, 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. Continental United States
    Continental United States, United States (Colloquial)
  5. West North Central States
    West North Central States, United States (Colloquial)
  6. East North Central States
    East North Central States, United States (Colloquial)
  7. Boone
    Boone, Missouri, United States (County)
  8. Cooper
    Cooper, Missouri, United States (County)
  9. Howard
    Howard, Missouri, United States (County)
  10. America/Chicago
    America/Chicago, United States (Timezone)

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

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

        
0.034 seconds ⌛

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