Pull Sonoma County Data from ArcGIS

[Mr0grog]

We have a scraper that parses Sonoma County data from the dashboard at: https://socoemergency.org/emergency/novel-coronavirus/coronavirus-cases/

However, it looks like Sonoma has moved to storing data in ArcGIS under the hood. You can see charts based on that at: https://experience.arcgis.com/experience/1edbb41952a8417385652279305e878d/page/page_11/

And dig around to find some of the data sets:

• Cases & deaths: https://services1.arcgis.com/P5Mv5GY5S66M8Z1Q/ArcGIS/rest/services/NCOV_Cases_Sonoma_County/FeatureServer/0
• Tests: https://services1.arcgis.com/P5Mv5GY5S66M8Z1Q/ArcGIS/rest/services/NCOV_Testing_Data/FeatureServer/0
• Cases by demographic groups, infection sources, hospitalization, underlying conditions, and symptoms (!): https://services1.arcgis.com/P5Mv5GY5S66M8Z1Q/ArcGIS/rest/services/NCOV_Cases_Sonoma_County_Statistics/FeatureServer
• Cases by exposure location/type: https://services1.arcgis.com/P5Mv5GY5S66M8Z1Q/ArcGIS/rest/services/NCOV_CaseData_ExposureLocation/FeatureServer/0
• Cases from gatherings/group exposure: https://services1.arcgis.com/P5Mv5GY5S66M8Z1Q/ArcGIS/rest/services/NCOV_CaseData_ExposureGathering/FeatureServer/0

Lots more you can find digging around in their ArcGIS service: https://services1.arcgis.com/P5Mv5GY5S66M8Z1Q/ArcGIS/rest/services

This isn’t high priority since the current scraper is working fine, but it looks like this provides more detail in an easier to handle, more reliable form.