Wastewater core

[dsweber2]

originating from an issue over in covidcast-indicators

Summary:

This adds a new endpoint for wastewater data, initially just NWSS data at the finest resolution, as described in the wastewater PRD. It also adds any notes I've picked up about endpoint development.

Prerequisites:

• [X] Unless it is a documentation hotfix it should be merged against the dev branch
• [X] Branch is up-to-date with the branch to be merged with, i.e. dev
• [ ] Build is successful
• [ ] Code is cleaned up and formatted
• [ ] squash merge

Ongoing:

Very much a draft at the moment. here's a list of the tasks:

• [x] write acquisition code
  • [x] extract
  • [x] transform
  • [x] load
• [ ] write API code
• [ ] test acquisition code
• [ ] test sql code
• [ ] integration tests Things that will wait until a later PR/occur in different endpoints
• [ ] add endpoint to clients
• [ ] update epidata documentation
• [ ] PR to add generic utils to delphi_utils (e.g. sig_digit_round`)
• [ ] add the aggregated signal

Open to suggestion of things that should go into the ongoing pile, as docs for adding endpoints are somewhat sparse.

[dsweber2]

In case you're taking a look, the files that are ready are

• nwss_csv.py
• nwss_constants.py
• nwss_database.py
• epidata_development.md
• new_endpoint_tutorial.md
• wastewater.sql

[sonarcloud[bot]]

Quality Gate failed

Failed conditions
27.3% Duplication on New Code (required ≤ 20%)
C Reliability Rating on New Code (required ≥ A)

See analysis details on SonarCloud

Catch issues before they fail your Quality Gate with our IDE extension SonarLint