-
Notifications
You must be signed in to change notification settings - Fork 0
/
update_all.sh
46 lines (37 loc) · 1.33 KB
/
update_all.sh
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
# Run this script to update all automated data downloads, chart generations, and database files
#
# This script WILL NOT:
# * Update ECOS budget records
# * Update SSA wage table
cd get_data
## Get data
python3 get_EPARegion1_NPDES_permits.py
python3 get_MassBudget_environmental.py
python3 get_DEP_staff_SODA.py
python3 get_EEA_data_portal.py
python3 get_eea_dp_cso.py
## Historical data; does not need to be regularly updated
## Scripts could be updated manually to reference more recent years.
# python3 get_Census_ACS.py
# python3 get_Census_statepop.py
## The SSAWage data is updated manually using the link on the data page
## Transformations - only need to be run once
# python3 transform_ECOS_data.py
# python3 transform_NECIR_CSO_data.py
# python3 get_DEP_staff.py # Note that this dataset requires a manual export to an xlsx to be updated; note also that the database seems to have been last updated in 2016
## Deprecated - no longer needs to be run
# python3 get_DEP_enforcement_actions.py # Deprecated
## Assemble DB
python3 assemble_db.py
cd ../analysis
## Update charts
python3 SSA_wages_viz.py
python3 MADEP_staff.py
python3 MADEP_budget_viz.py
python3 MADEP_enforcements_viz.py
python3 ECOS_budgets_viz.py
python3 NECIR_CSO_map.py
python3 EEA_DP_CSO_map.py
## Exclude large files from git repository
cd ..
sh ignore_large_files.sh