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

...

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.

...

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)

...

The output is used to estimate future demand

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

...