33 places near Mizzou Arena, Boone, Missouri, United States
filter by placetype:
  1. Hearnes Center
    Hearnes Center, Boone, Missouri, United States (POI)
  2. Audrey J Walton Stadium
    Audrey J Walton Stadium, Boone, Missouri, United States (POI)
  3. Ralph & Debbie Taylor Stadium
    Ralph & Debbie Taylor Stadium, Boone, Missouri, United States (POI)
  4. Mizzou Arena
    Mizzou Arena, Boone, Missouri, United States (POI)
  5. Grasslands
    Grasslands, Boone, Missouri, United States (Suburb)
  6. Providence Hill
    Providence Hill, Boone, Missouri, United States (Suburb)
  7. Seven Oaks
    Seven Oaks, Boone, Missouri, United States (Suburb)
  8. Columbia
    Columbia, Boone, Missouri, United States (Town)
  9. Mid West
    Mid West, United States (Colloquial)
  10. US Western States
    US Western States, United States (Colloquial)

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

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

        
0.054 seconds ⌛

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