Improved SCAT data workflow to increase efficiency and data accuracy

Abstract

#2017-302 Traditional Shoreline Cleanup Assessment Technique (SCAT) data workflows typically entail collecting data in the field using notebooks, handheld GPS units and digital cameras, transcribing these data onto paper forms, and then manually entering into a local database. Processed data are pushed to a SCAT geographical information system (GIS) specialist, ultimately providing exports as paper and electronic versions of maps, spreadsheets and reports. The multiple and sometimes iterative steps required can affect the dissemination of accurate and timely information to decision makers and compound the potential for introducing errors into the data. To improve this process a revised SCAT data workflow has been developed that decreases data processing steps and time requirements while increasing data accuracy in several facets of the process. The workflow involves using mobile data collection devices in the field to capture attribute data, photographs and geospatial data. These data are uploaded to a web-enabled database that allows field team members to complete, review and adjust their data, along with data manager approval before presentation to others in the response. For response personnel with internet access and proper login credentials, SCAT data, including photographs, reports and results can be searched for by attribute, time or location, and reviewed online in form view or on a web map. For traditional SCAT spatial analysis products, approved data can be exported and processed in a GIS as normal, but can also be returned to the web-enabled database to be viewed on a map or distributed via web mapping services (WMS) to other web GIS data viewers or common operating pictures (COPs). Field testing of the improved workflow shows decreased data processing time for data, a more robust yet streamlined quality assurance and quality control process (QA/QC), and easier more inclusive access to the data relative to traditional paper forms and data processing. While the improved workflow entails a steeper learning curve and a heavier reliance on technology than traditional SCAT workflows, the benefits are significant.