26 places near MSA Columbia, Missouri, United States
filter by placetype:
  1. Woodlinville
    Woodlinville, Boone, Missouri, United States (Town)
  2. Mid West
    Mid West, United States (Colloquial)
  3. US Western States
    US Western States, United States (Colloquial)
  4. Southwestern States
    Southwestern States, United States (Colloquial)
  5. Old Southwest
    Old Southwest, United States (Colloquial)
  6. Southern States
    Southern States, United States (Colloquial)
  7. US Eastern States
    US Eastern States, United States (Colloquial)
  8. Northeastern States
    Northeastern States, United States (Colloquial)
  9. Civil War Border States
    Civil War Border 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": [
                  -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"
      }
    }
  ]
}