2021 SAG Award Winners

Missouri OA/ITSD - Office of Geospatial Information and Department of Health and Senior Services

Project Goal

The Missouri Office of Geospatial Information (OGI) partnered with Missouri Department of Health and Senior Services (DHSS) and State Emergency Management Agency (SEMA) to create and maintain over 50 new internal and public-facing information GIS applications for Missouri's response to the Coronavirus pandemic.
OGI was contacted if an application required a spatial component,. Beginning in February 2020 through present day, most applications required a turnaround time of just a few days. Fast development on the ArcGIS Online platform was critical to our success.
Besides reporting COVID cases, applications were developed for local public health orders, school closures, testing locations, and unemployment due to COVID. Requests were diverse, from creating a new PPE ordering system, to a daily team health report for all state employees, to identifying beds in long-term care facilities when patients were ready to be discharged from the hospital, but not ready to return home yet.

Business Problem Solved

The Strategic National Stockpile (SNS) Warehouse was responsible for distribution of PPE (personal protective equipment, masks, gowns), COVID Vaccine Ancillary supplies (needles, alcohol pads, cotton swabs), and BinaxNOW Antigen Test Kits. Utilizing Survey123 forms for ordering, Crowdsource applications for approving, and Business Analyst infographics for shipping slips, staff in the warehouse could fill orders and ship items out the door. In addition to warehouse functions, DHSS/OGI built the BinaxNOW Antigen Test Kit Hub Site to organize all BinaxNOW test kit applications and dashboards in one place.

In Oct/Nov 2020, 700+ patients in Missouri hospitals needed placement in Long-Term Care (LTC) facilities. The hospital association needed a tool to find LTC facilities with bed availability. Within a week, a Survey was built, deployed and is currently used daily by LTC facilities to locate nearby nursing homes with bed availability to help with patient discharge planning.

Technology Implemented

Survey 123, Crowdsourcing, Business Analyst, ArcGIS Online Web App Builder, Dashboard, Operational Dashboards,

Development Team Biography

Office of Geospatial Information
Holly Withrow, Brandon Wolfe, Tracy Schloss, David Nykodym, Mustafa Rahim, Jeff Patridge, Kendra Williams, Colin Duewell, Aaron Kale, Jon Haslag, Jason Hinsen, Colin Duewell, Elizabeth Retherford, Alexis Gieseker, Debbie Briedwell, Arnold Williams

Department of Health and Senior Services
Paula Nickelson, John Whitaker

State Emergency Management Agency
James Remillard, Elizabeth Weyrauch