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

Request meter data for PWS respondents from David Anderson (Waters Bureau). In survey , they are supposed to provided meter data .

Note: Julie could make more precise requests for meter records specifically categorized as PWS but casts a wider net to get all data because some records are not so obviously classified as a PWS. 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.

(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). In cases where the PWS did not return the survey, meter data for that PWS is used from Waters Bureau data records to fill the gaps.

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

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

3.3

Survey also asks 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 which is entered into the Waters DB (some must report diversion data by permit requirement, but not all)

3.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.

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

where…

Public water data (input) - Data related to quantifying and tracking water use associated with a distribution system

Output - The output factor gives her an amount water used by the PWS. This number can be compared to the survey or WATERs query results.

The output is used to estimate future demand

Waters Data Report Data Elements

The following dictionary describes the data elements used in report generated by Emily

Other Information/Questions

• what pieces of this could be automated?

• Julie thinks they could work with NMED to do unique identifiers for systems

  • may make use of federal numbers. that way identifier data linked

• Daniel Ramirez is a new person on SIDWIS DB

• OSE received a USGS grant for service boundaries for all suppliers in the state

  • Could start to work with Daniel on that

• Daniel assigns ID numbers