Workflow (Dec 2018 thru Feb 2019)

Morgan

• Finish Mocking up SWUDS export views in VAHydro (get them as close as you can) *http://deq2.bse.vt.edu/d.bet/nwis_withdrawal_facility

Rob + Joey

Process developed for ensuring data integrity, and facilitating SWUDS export of monthly and annual values regardless of the frequency of reported values.

1. Remove any unused variables from vocab epa_echo
   • dmr_day_mgd
   • dmr_wk_mgd
2. Define any new variables
   • dmr_period_mgd
   • dmr_mon_mgm
   • dmr_ann_mgy
3. vpdes workflow in druapl php (these will be auto-set when Morgan's code runs)
   1. dmr_period_mgd: given variable time period with mean MGD over period
   2. dmr_mon_mgd: generate and save corresponding monthly MGD values for each month
   3. dmr_mon_mgm: generate and save monthly MGM values for each month (days * MGD)
   4. dmr_ann_mgy: generate and save annual MGY = sum(MGM)
   5. dmr_ann_mgd: generate and save annual MGD = MGY / 365
4. Update Morgan's code to utilize the variable dmr_period_mgd
5. Run Morgan's importing script for d.bet (to update existing)
6. QA Import on d.bet to confirm data is getting stored properly for all variables above
7. Update and finalize SWUDS export views to utilize the variables above
8. Migrate all variables and views from d.bet to d.dh
9. Run Morgan's importing script for d.dh and QA data import
10. Migrate SWUDS Views to d.dh and generate final SWUDS exports