search

hackoregon / transportation-system-backend

2018 repo for the transportation api backend
MIT License
8 stars 2 forks source link

Move crash data ingestion processing into this repository #16

Closed znmeb closed 6 years ago

znmeb commented 6 years ago

As it stands now, the file odot_crash_data.sql Is generated by code in another repository, https://github.com/hackoregon/crash-data-wrangling, from the original MDB file we received from ODOT. It only takes a few minutes to generate the SQL file and it's fully automated in containers now, so the code should be moved here.

My plan is to do it as soon as the API is up and running against the SQL dump file we already have; the process as it now stands leaves a fully-populated database container service running, so we can either run it separately to generate the dump and then start a new container from it, or just bring up the database container with the raw data file.

znmeb commented 6 years ago

Closing here - I put up a master task list at https://github.com/hackoregon/transportation-systems/issues/19