Database solution for Crash analysis and Shiny app

Chicago / vision-zero-dashboard

Vision Zero Dashboard

MIT License

14 stars 20 forks source link

Closed ParfaitG closed 3 years ago

ParfaitG commented 5 years ago

PR Updates include:

Database migration script to create database and tables and push .rds data frames into SQLite.
R Markdown and HTML output using SQLite database to summarize crash data
Shinydashboard app using SQLite database to query table and plot data by selections