Summary

These notes were based on a recorded ‘Deep Dive’ with Julie to expand on the details of the steps she goes through to compile her Water Use by Categories report. The video, whose timecode related to notes, is referenced here, can be found at following URL:

Share recording with viewers:

https://us02web.zoom.us/rec/share/yPcuMr3661NJU9LDr3-cWv4qJI2ieaa80yRL_foFnxtpGYmyvRI2EUkPKAyztsRs Password: 1v#2A774 

1.1

how do you get access to Waters DB?

...

Julie asks for specific criteria: OSC OSE file (permit number) , name of entity, county, meter data (surface and ground water withdrawals), x/y coordinates to locate point of diversion, they give you POD ? (Point of diversion of water) , use code, owner first name, owner last name

...

Julie gets PWS list from NMED because of their relationships w/ EPA they have a list of all public water suppliers in the state so she can have most current list of PWS . Many Some PWS are regionalizing, and consolidate and NMED is first to know. Sometimes new PWS are created (and don’t exist in Waters db). NMED updates PWS every 5-7 years. Julie does not know where they are in the update cycle however.

PWS have to report to NMED every 3 years quarter (or so) their water quality data so this is an opportunity to update their information. NMED also has same difficulty to stay in contact with PWS’s and keep info up to date.

Next step is to make sure that all meter data is accounted for in Waters DB master list that is in NMED PWS list. She doesn’t entirely rely on NMED list but may fill gaps in certain cases where discrepancies exist.

Julie indicated sometimes NMED has different meter data than OSE does. (fact of life, not easily resolved)

if WatersDB and NMED have a discrepancy for a given field, Julie makes a judgement call as to what the final value will be. She annotates her decisions on the discrepancy.

...