Workflow (Sequence Diagram)

Diagram Sequence Steps Detail

1.1

1.2

Julie takes her existing list, contacts NMED to request their list of public water suppliers

1.3

Creates a compehensive list that is a merge of WATERS and NMED PWD lists. Merges them manually. If not present in waters list, then adds entry from NMED list.

2.1

Sends paper survey. Note attempted electronic survey (survey monkey) but response was low. Paper survey get higher response.

2.2

Approximately 30 percent of PWS respondents return the paper survey. Many holes/gaps here in terms of response. Of the PWS respondents who respond, only a handful submit associated diversion data reports.

3.1

Fetch meter data for PWS respondents. In survey , they are supposed to provided meter data .

(Note she doesn’t update waters db with newer meter data from survey if found. Someone else does that)

3.2

Comparison is between meter data returned from the Waters Bureau and the PWS survey respondent data. A reconciliation with what meter data is in Waters DB vs survey is performed (QA/QC).

Some data element values may require clarification for cases like data value may seem out of bounds from other values or significant change from previous survey.

3.3

Survey does ask for diversion data.

They will submit report of diversion data (what workflow is this?) and may also submit same diversion data as part of the survey.
(Note: one way or another Julie get diversion data. Via survey or as a requirement of their permit (some must report diversion data by permit requirement, but not all).

4.1

Julie could make more precise requests but casts a wider net to get all data. She then filters manually for those meter entries that are not labeled clearly as a PWS. Some are categorized with other labels yet are PWS.

4.2

Comparison is in conjunction with information returned from waters bureau and the survey respondent information.

4.3

i.e. data element seems out of bounds
Significant change from survey entry for same data element.

4.4

District offices also familiar with public water suppliers

They also receive meter reading data (paper or online, which is NOT part of Julie’s workflow to request the same as part of the survey)

5.1

Gallons per capita per day (GPCD)

Water Conservation Bureau has a GPCD calculator.

Pub water -> GPCD calculator -> (let’s public water system track how much water is being used by their customers)

Use above to est. future demand