summary of 2014 scro groundwater data projects michael mcginnis south central region office

Summary of 2014 SCRO Groundwater Data ProjectsMichael McGinnisSouth Central Region Office

SCRO GW Data Deficiencies (Start of 2014)

• ROs have different methods of collecting gw data, indexing new WCRs, and tracking gw data requests.

• Historical WCRs.

• Recent WCRs (2011-Current) + May Surprise Addition.

• No construction info for current SCRO well runs.

• No review of current SCRO well runs for reliability or aquifer match which caused outlier points when contouring.

South Central Region Office 2

RO WCR Data Requests New SWN Requests New WCRs Historical WCRs Biannual GW Level Measurements

NRO •1 WRT handles requests•Response time: 2 Wks or less•Doesn't always go on well measurement runs•No request status tracking

•1 WRT assigns new SWNs•Typically 3 wks response•Added to GWIDS if RO measures

•1,500-2,000 new WCRs/yr•1 FT+ 1 SA assign TRS and scan•All new WCR entered in db (MDLog)•Added to GWIDS if RO measures

•All scanned (excl 2014)•All historical info entered (MDLog)

•3-4 WRTs sent•Owner permission (signed form letter)•Have construction info for all wells

NCRO •1 WRT handles requests•Response time: 2 -3 Wks or less•Doesn't always go on well measurement runs•Request status tracking wrkbk

•1 WRT assigns new SWNs•Typically 3 wks response•Added to GWIDS if RO measures

•8-10,000 new WCRs/yr•1 person + 1 SA assign TRS and scan•All new WCR info entered into db (Wellma)

•All scanned (excl. 2014)•2003-Current info entered (WellMa)

•4 WRTs sent + 2-3 EGs on another run?•Have construction info for all wells?

SCRO •1 WRT handles requests•Response time: 2 -3 Wks or less•Always goes on well measurement runs•Request status tracking wrkbk (new)

•1 WRT assigns new SWNs•Typically 3-4 wks response

•3,000 new WCRs/yr•1 person + 2 SAs assign TRS and scan•TRS, type, WCR#, CO entered in wrkbk

•All scanned (excl. 2014)•36K info entered (WellMa)•150K+ not entered

•2 WRTs sent•1,800 wells meas. each period•No construction info for wells

SRO •1 WRT handles requests•Response time: 2-3 Wks or less•Always goes on well measurement runs•No request tracking wrkbk?

•1 WRT assigns new SWNs•Typically 3-4 wks response•New SWN entered in db along with scanned 429

•? new WCRs/yr•1 WRT assigns TRS and scans•All new WCR info entered in db (Pierotti). OTs help with data entry.

•Mid-90s-Current scanned•Mid 90s-Current entered (Pierotti db)

•1 WRT + 1 EG sent for 1 well run. 1 WRT + 3 EGs sent on another well run•Have construction info for all wells?

Groundwater Data Collection Methods by Region Office


Historical WCRs (Early 2014)

• ~170,000 paper copies.

• ~36,000 entered into WellMa in 2008-2009 after temporary funding.

• ~134,000 still unentered.


Current WCRs (Early 2014)• Start of 2013, WCRs had only been scanned through

2011.

• Two SAs located, scanned and entered TRS, WCR#, County, and type through 2013.

• Two new SAs hired 05/14. Started on 2014 WCRs

• THEN the May Surprise ...


May Gift from SRO


SLO WCR Project

• SLO WCR pages originally misestimated at 18-20,000.

• Decided to scan in-house instead of sending to contractor.

• Combination of WRTs, SAs, and F&W Sci. Aides started scanning and adding index info in June. Some unexpected problems on some WCRs: Duplicates, No WCR#, No TRS.

• Finished scanning/indexing in November.

• Starting on remaining 2014 WCRs.South Central Region Office 7

Final SLO WCR Page Counts And Hours Spent

Well Type DCP DDO DES DIR DMO DRE DTW NCP NDH NDO NIH NIJ NIN NIR NMO NPU NRE NSP NST NTW NUN NVE

TOTAL Unique WCRs

TOTAL WCR Pages

Subtotal 1 531,202 19 16 9 1 54 213,93

3 1 3 862,5031,377 334 42 35 75 539 774 5821,11

738,30

0

Final cost including QA/QC = ~$1.80 per page

Classification Total Hrs Scanning/Indexing

F&W Scientific Aide (2) 82.5Student Assistant-Engr (3)

109.8

WR Tech II (3) 256.0Engineer, WR (1) 133.3Senior Engineer (1) 12.0

TOTAL 593.6

Total Hours By Classification


Click to edit the outline text format

Second Outline Level

Third Outline Level

Fourth Outline Level

Fifth Outline Level

Sixth Outline Level

Seventh Outline Level

Eighth Outline Level

Ninth Outline LevelClick to edit Master text styles


Second Outline Level Third

Outline Level


Fifth Outline Level

Sixth Outline Level






Third Outline Level


Fifth Outline Level

Sixth Outline Level





Second Outline Level Third

Outline Level


Fifth Outline Level

Sixth Outline Level






Third Outline Level


Fifth Outline Level

Sixth Outline Level




Scanning WCRs In-house

• Pros

1) Can add new WCR#s and missing TRS info.

2) Can delete duplicates and unwanted pages like county well permits.

3) Weekly progress status.

4) QA/QC done by experienced groundwater personnel. Can rescan misfeeds or edited WCRs.

5) Can use extra personnel (ex. Sci. Aides) when not on other assignments.

6) Training personnel on WCRs.

• Cons

1) Base scanning/indexing is less expensive from contractor ($0.58/pg.). But unknown costs for pre- and post-scanning organizing.

2) Could have been completed quicker.

3) DWR personnel could have worked on other projects.


Locating Construction Info for Current SCRO Measured Wells.

MeaAreaDescription SWN 429Link TRS County429 Con Info?

WCR? WCR#Well Type

Date Drilled

Depth TopPerf BtmPerfAquifer Type

NOTES OwnerName

Kings River Fan 15S18E11A002M 15S18E11 FRE10 N N - IRR - - - - -No WCR found; info from 429; top of Corcoran clay at 450 to 500 ft blw surface

Ed Gusti?

Kings River Fan 15S18E11R001M 15S18E11 FRE10 Y Y 00075038 IRR02/08/196

3420.0 200.0 320.0 Unc

top of corcoran clay at 450 to 500 ft blw surface

Guisti Farms

Kings River Fan 15S18E24J001M 15S18E24 FRE10 N N - IRR - - - - -No WCR found; info from 429; top of corcoran clay at 350 ft blw surface

Kings River Fan 15S18E29J001M 15S18E29 FRE10 N N - IRR - - - - -No WCR found; info from 429; top of corcoran clay at 550 ft blw surface

Kings River Fan 15S18E32E001M 15S18E32 FRE10 N Y 00031684 IRR01/20/195

5302.0 120.0 296.0 Unc

1st perf: 120 to 263; 2nd perf: 274 to 296; top of corcoran clay at 550 ft blw surface

Noble Ranch

Kings River Fan 15S18E33E001M 15S18E33 FRE10 N N - - - - - - Unc No WCR found; unconfined

Kings River Fan 15S18E33N001M 15S18E33 FRE10 Y Y 00076380 IRR03/17/198

1360.0 264.0 360.0 Unc Unconfined Britz Inc.

Kings River Fan 15S19E07Q001M 15S19E07 FRE10 N N - - - - - -Outside of CC

No WCR found; USGS well; outside of corcoran clay

Kings River Fan 15S19E21A001M 15S19E21 FRE10 N N - - - - - -Outside of CC

No WCR found; outside of corcoran clay

Kings River Fan 15S19E21C003M 15S19E21 FRE10 N Y 00031901 IRR01/14/197

7522.0 270.0 522.0

Outside of CC

Possible WCR match; Page 2 WCR# 00040311; name-address-SWN match; outside corcoran clay

Clarence DeFreitas


Locating Construction Info for Current SCRO Measured Wells (cont.).


Reviewing SCRO Wells Using B. Brewster's GW-GIS Tool


Reviewing SCRO Wells Using B. Brewster's GW-GIS Tool

Questionable Wells Types:

• Wells perforated below Corcoran clay

• Wells along eastern edge of SJV (decomposed granite)

• Multi-completion monitoring wells

• Unusual hydrographs

• No WCR or 429

• Data entry problemsSouth Central Region Office 14

Questions?or

Extra WCR Scanning Tips?

• Michael McGinnis

• [email protected]


WCR Scanning Tips (If Time)

Reviewing/Editing Scanned WCRs using Irfan View vs. MS Photo Viewer

• Higher quality images

• Insert new text (ex. new WCR#) in image

• Multiple open images


Adding New WCR# (step 1)



Click to add text


summary of 2014 scro groundwater data projects michael mcginnis south central region office

Documents

new wcr info

new swns

new wcrsyr

new sas

current info

wks response new swn

construction info

wrt assigns trs