Include ALL known fields in .xls file exports

ruckeralex commented 4 years ago

Include all known fields in .xls file export, from both the main tool page (http://water.openoakland.org/) and the Water System detail page (e.g., http://water.openoakland.org/system.html?id=CA3303100).

All fields should include:

Everything that is on the raw HR2W source data sheet (https://www.waterboards.ca.gov/water_issues/programs/hr2w/docs/data/hr2w_web_data_active.xlsx) -- such as Regulating Agency, Violation Number, Enforcement Action Number, and Service Connections
% Exceedance and # Over Exceedance
In/Out of Tulare Lake Basin
Legislative Districts - State Senate
Legislative Districts - CA Assembly
Regional Water Board

sharkberto commented 4 years ago

Added fields to export via https://github.com/openoakland/clean-water/pull/8/ - Still needed to allow export:

Classification Service Connections Legislative Districts - CA Assembly Legislative Districts - State Senate Regional Water Board

sharkberto commented 4 years ago

@ruckeralex @aaronhans where is the field for "Regional Water Board"? I'm trying to meld all the data in python so we don't have missing fields

r-b-g-b / clean-water-tool