Skip to content

About

Takes poison center call data and processes, cleans, geocodes, analyzes, and uploads it for use in a call center dashboard

Resources

Stars

0 stars

Watchers

1 watching

Forks

Repository files navigation

WAPC data-o-matic

Summary:

This script takes a CSV file containing new call records and cleans, validates, and processes it; appends it to the existing data; and updates the ArcGIS Online feature service.

Table of Contents:

  1. Introductory settings (setting variables, importing libraries)
  2. Import new data table into the geodatabase
  3. Import table
  4. Make sure date field isn't null and try again if so
  5. Make sure date field is in date format
  6. Only keep today's records
  7. Clean data
  8. Change county names to title case
  9. Remove non-Washington calls and those from unknown counties
  10. Add spaces to the substance category field for better display
  11. Make sure number fields are the correct field type
  12. Geocode the clean data
  13. Geocode with a county-based address locator
  14. Stop and complain if there are unmatched records
  15. Add new data to this month's table
  16. Delete tables from previous month(s)
  17. Create separate feature classes for today's cases and this hour's cases
  18. Create feature class for today's choropleth map
  19. Calculate number of cases per county for today
  20. Join today's county totals to the county polygons
  21. Delete intermediate tables and feature classes
  22. Update the ArcGIS Online feature service (this part taken from [https://github.com/arcpy/update-hosted-feature-service])

About

Takes poison center call data and processes, cleans, geocodes, analyzes, and uploads it for use in a call center dashboard

Resources

Stars

0 stars

Watchers

1 watching

Forks

Releases

Packages

Used by

Contributors

Languages