The latest data file can be retrieved by running the script in the fetch directory.
node index.js
The excel file can be transformed into the json format the site needs by running this series of scripts:
- Translate the Excel active violations data to JSON:
excel.js
Then we need to slightly reformat this by running:
node format.js
- Split up the violations into separate files per water system ID:
write.js
The shape files are linked on the HR2W site as well https://www.waterboards.ca.gov/water_issues/programs/hr2w/, put them in the ./shaprefiles directory and run:
node shapes.js
Which generates a fresh locations.json file, then we can split that up:
- Create a separate JSON file with the metadata for each water system:
write-locs.js
The browseable website is in the docs/ folder
Attempt to get the latest data: fetch/index.js (This needs to run on a lambda or something so it can run regularly)
Apply the legislative data to the files in the docs/data folder: legislators.js
Add the legislative district to each system:
node add-legislators-to-violations.js
Add a LEGISLATOR node to the violations.json file