FOSS4G 2022 general tracks

Automating Generating a Web Map from Online Tabular Data: UC Davis Potential Worksite Exposure Interactive Web Map
2022-08-25, 17:50–17:55 (Europe/Rome), Room Limonaia

Tables are a great way to store data and this format is often used to make data available for the public on websites. While these tables technically meet their intended goal of sharing data, they do not make it easy to understand the spatial and temporal patterns in the data they contain. In this talk, I will demonstrate how an automated toolchain of web scraping and text processing in R, and interactive visualization in Leaflet is automated with GitHub Actions and applied to aid data interpretation and generate new insights from a daily-updated online tabular dataset using a case study of the University of California Davis’ Potential Worksite Exposure Reporting data for COVID-19.
In the United States, California Assembly Bill 685 (AB685) requires employers in the state of California to notify employees of potential worksite exposures to COVID-19 to the geographic scale of individual buildings. The University of California Davis meets this requirement by listing any potential exposures on a website, giving the date reported, the dates of the potential exposure, and the building name as reported by the employee. To make a map from this data, the dates and building names had to be standardized and joined to a vector layer of campus buildings before they can be added to an interactive Leaflet map. Because the data updates daily, the whole process needed to be automated so no one had to run the scripts every day to update the map. The result is a map that gives uses a much clearer understanding of the spatial and temporal distribution of potential exposures to COVID-19 on campus.

Michele Tobias is a biogeomorphologist with a background in geospatial methods for ecology. At University of California Davis (UC Davis) DataLab, she helps researchers understand and design geospatial methods and workflows, from data collection to spatial analysis to data visualization and cartography. Michele earned her PhD from UC Davis in Geography where she studied California’s sandy beach ecosystem with a mix of traditional phytosociological methods and innovative remote sensing tools. She has a bachelor’s degree in Geography (focused on biogeography) and German (focusing on linguistics) from UCLA and a master’s degree in Ecology (resource ecology & management) from University of Michigan. She worked at the UC Davis Information Center for the Environment as a postdoctoral scholar. Michele’s research interests include applying spatial analysis methods to new avenues of research. Michele has served on the OSGeo Board of Directors since December 2020.