Transcription
Region 4SuperfundE-DataManagementUnderstandR4 data managementrequirementsUnderstandContractor’s role insubmitting data to R4ExploreEQuIS Tools and ResourcesExploreWhere EPA going with datamanagement and datavisualization
R4 Superfund andData Management, .r.,. 1.-. - .u.-q-.-Region 4 Superfund: E e,etron ic DataSubmission··lh19u11 . tu i-npl 11i.dEQ.ul:!i 7 lit!ld uPl!lr.i dltdlEJ'AA.4 fu1m.rl fil .b .11th111t. lMhpun G&Nu1it,a 1'1111111 ru1mwi1,nlll 1nd lldi11!i11lor,:1ubmi1tJl.,.,,JlnMnf bi;J11irck111d1n EDP.u,iniitL ff'lj ru1mwiLnWo'k.lhAi :jj -ur !4o( h11dt.n11w'lhlEDI 1rnl ,e lfn11hr t.l wl b.lUll'111 1!dtW.11t.bblib1111:hiruJl'.&. 11 ITii'd ;rdilll::11" d l:'!l"Ltbliii. Th 11 111I lilM «nL16h d.itii duk-b IU1milLn1J., iii. llitnu tHion,.Thi' ElPATlitUihi i, . . u . ui 10 . d'111!il i;:r-tilli&iu':I; V,1kJtilir Wl.YJ- 1111111 d 111!il l\O,ubfliwtic'n.-C fl .1ruf.,f1MTnlr.-.l fo.AATjd,pl · hiifh 111f'li !hilt mkn: 1llpll witi-rM 11111. IJ' L '-.,. lllij«.1l, 11dl'f0tmSur,11rru11d-wlll, , .LN'.lli-hl[ilmt'1'. 1 h .Su.:Mrfond l 'i161!ii111111'1fo El"' t\.ofl f1)fd 4 h1111- 1Ulod.1111wida,:l'!id Iii 1,U ndlr-d.utd il tr'.en.it.a.Uo&INWll!:ilir(Eru,11 .n f dlir1 witn t, iLII u .i:mitud'-tOoIIW14i1."6lil l1&--dr.»-11'11nil !Iii .i:mil!lidcri»-L'"I&1lrui"6lilu,lfti:h ft.fnletn'ut.&1.S't'il)am IGISI 0.1111 S;11'!!m1IU ru,mA:-.1111 J.in lraKUUlli fet',eliLll'.'lint1 u·1J:wb111tm11.w;-ElDOi.u111puritNd';,inUUI En"1 Mlll 11.1lill IFS.b111itwu 11 ,::NKkfu,,.1 M D.NO(-C09-f:O"J 1111.-:t2005 – 2010 launches DART; ELEMENT replaces R4LIMS If 'l'UU iti'ltthin,i nuild.itinl[il'll Wilub LIpiOCll '-Cf'rl'I.IL n. 11'u!n!M11I (:IHmplellf-d111l111'\lh .fl,.ua-.,,l'l.mtcDi"vidf DffiElllr'l-'Alffl&- IPDf) u E11 ,1i.iunmtnt.lo()i1!.i116Zmll'i.un2008 - 2013 R4 *upgrades* EDD Format Files,*upgrades* servers, database schema, DARTDashboard llin'l-1111ti.l TildnkPruutdIii.II 2010 Environmental Data Submission SOP 2013 Executive Order for Open Data 2014 EQuIS Database transferred from Lab toSuperfund 2016 Superfund dbase moved to the Cloud 2016 R4 Quality Management Plans and updatedSOP 2017 National E-data Management Vision 2018 National Geospatial Data Directive 2019 Updated R4 E-Data Guidance""kb. f r,,A,:R,.j.on.-Cktr111Hfl : IJtdjliifp46r mM.h,r--.ar::!Cf,I1EriA-:R.IJIAn,- A11 . , 'l IJiJ': l'INidl.-e-Gi'l'1J!P:odua1 / fa 1m 1-kl--1111 p .(N) bffon-4-Bll nHftD Tlffl ft! ,0,IDf\l.dlil! !&!Ell:fi Creating-au d Su bmitt:ing· EnviJ'lonrnen ta]·Da ta,rThit &r.i u111Mnt.1lfl11tt-S.i:mi.wu 11:NltM.lrll Sf MD.fflQc,.a09- fl Ol EJ A f'AN.bn.-4 ElD0f.t:mn111.flki Eiuidttc f11erdtlli-dliL.1ikidKL ielli.-lilq;a.,.d',!u b.-1ib-nft1.M.l' ,Hf imFfl r.im.ll ndi :i.wudilUniroI "I r' lilit. lllr, IUlpl111 1hw L011bl uU11.w;-. .Jucu 11L lot 'Iiipi'«iu. i, d'uwn'lin. WW11b-l11rH lu : 11 etui11.,.eu,.J ,1.iJiin:l [0 . , 1l p1ipln 1111.d 1ub1rilthVllirr19U 11 . ED il ld lLIM Pll!J i.il d'111!.l. Tlii:lirlt ,u!J::i(rl.iria;-,.a.1'4nU.&6amilf1l i-.-ill111d11id l\Opr-ucjiju,,.I.lnlu1mllit13 1h1n'I O2010 Superfund DD issues Policy Memo; Website fotn'ub.Of 1 lu1 th.fi'Cl!IH!ic:n--of lhM IEOO2010 - Present ""mNl«.('rml lm j:Nf WIJlil - . u t.od ' ' '" iW .,o.d':v,-.U11'l,0,»-11'11i,:h1i.:odii\.Ii 1twlyi:,.-.trf-d.tw :Mt1rU1 . d inart. i"' url uf 1hr 000, 111,td1twflvF lilM.p du1111l'(:SEMDfflOC.O ufln lliifji1,S[Sl) f181111fn:ttn.--i'.'.1.wli1.-fDnL.ILI M DARTft!oil .p 2007 R4 contracts w/B&V for EQuIS technicalassistancen . ,.,.,trl'llllu114llll fl.Yfl Hlct.il:'!H '1111,llh.-tha fl)f',(Dfn\.rl Ji, iladi, d'lifta llid '1111,, tllr ii .,Yr Ilil.illlfUKlW,, llii !111-ecn.,lim hrN[d . ll uid t 44rincji I «h .l IEDf uM1:i.,l.6'pq:ult'!tloiliup-d u nmriii,nI Lir11lrUI "" .riiri df:lilLific:111nlo al .,.l;ar rllitl!u il:itd li1'lllrifDD·. E.,.,· lilli!fli1M:li .,.l;ar .,.,.-. 11.t:ilti G&nd lnUJ , umJw;i.llpdiir. r;i ru,mi" lu, al"61S. ml:'!li!filJ.:hirikipiH.I l i ,!Fi;:u, 1-cir twStep·l Prioru-Sampling-Eventf6r PJ1Pt.-111d ,,. j:11,eikl i.mmil:'1" ur t.lw-d.i1111 11 1l,. S.U'llq:Mtl.fid lu ,p! u . dH IIIU'1wbn'lli!Ul d IUdiirT,lit in IIIdI -d. l i'r1-.urNid. Ml!ll11ir pro,,ritl f Ulili"-d1 llilir IEPA t.ii::or1 4w]lnutJ'l' twt.li!! pf6 .dtii1 lb1ul D.i11116u'!util1 S.mll'llt'f'ln.J -tmlir1 ti IPMOAR"T:@ EiJ .p;oi,,cb h111Lilill.J-'F6r n 1n d iL1o:oo1 d 1Ump[n.J,-thii.,.,.tllOmu1tb ab1.1 ' 1:Miixn !11rii1E riAhNion-.t mplll C6a,di!'Wlbl' (l:SASD-w CLP d'i Uiilo-MOAJH («h11r In). If W04J .,.WO'l-1::H pro,,.d'lld . i:FN.i;.t1ro, C:On.141.114llAR"Ti@t1 P111. pw.Step-Z Prepare·Your·EDDU.1::-dWl[miu.d !ilur:I filiil lfn lhic lirrr liilx11ni- ll"'41.1 lu !Ii J.!!ffiil!idl C,.1111,i;Nlrid.n 1111 - liq Ll.l'idhi-lllbll'lt!'lli1t.:1d111l111 i n 111 fDrn'll!!-if:lildliil dllililfr,AiJt.ition-C EOO f.Plmll l filir Gu1 t.l M.Step 3, Val, date Your EDD CD.upln'I"(ut.litb .t.Oal111Pru icS.r (]1. m ill111 l1.J1nu illl'1" 111, llllt,u, "1t01.QI: ln:ii t.l ilil,u bn'LuicHi.--C.h fur (hi' ndelectronic-data-submissionIIpr6uir .nlj
Step 1: Identify Point of Contacts and submit a POC EDDStep 2: Set up EQuIS account and GeoPlatform AccountR4 SuperfundDataManagementPlanning Analytical, Field, WellConstruction, Geology, etc Set up EQuIS AccountView Site DataRun Data Gap ReportEDD ChecklistEQuIS DashboardDevelop DMP Plan your Event –CLP/Regional/Other LabSample Booking- ARF Check Data with EDP Submit Data Geospatial Data Set up GeoPlatformAccount View Site Data GeoPlatform Dashboard Develop DMP New Reports - Submit GISData
E-Data Prime POC - One Person per SiteHave one POC that is the liaison with R4DART and EarthSoft(field software).They can do everything in each application (and they likelyspend much of their time in EQuIS). They are responsible fortraining their site team. Attends Monthly E-Data Provider Call Build/Use Enterprise Dashboards Import and Correct Data Prepare Tables and Crosstabs Set up Sample Plans and Contracts Maintain data Build Groups and Action Levels (MCLs) Configure EDGE and/or Collect Forms
Sampling Coordinator – One Person per FieldEventThis is the person that books the field event with the R4 SampleCustodian/R4DART. This person likely receives a copy of the fieldassignment information from R4 Superfund QA Coordinator. CLP/Regional Lab: Submit 1-Analytical Request Form(excel spreadsheet) to R4 Sample Custodian. Other Lab: Submit 1-Analytical Request Form (excelspreadsheet) to R4DART. Update and resubmit 2-Analytical Request Form (edd)to epar4@equisonline.com
Field Team Leader – One Person per Field EventThis is the person in the field that signs the Chain-of-Custody.This person likely receives an automated email confirming thefield assignment locations and requested sample analysis. Use Scribe, EDGE and/or Collect Forms Signatory on the e-COCsField Team is to contact the E-Data Prime POC for fieldsoftware related issues!
E-Data ProviderThey are responsible for emailing site data toepar4@equisonline.com.Remember – data must be checked with EDP to autocreate a user certificate! Import and Correct Data
GIS Data POCThey are responsible for uploading GIS data tohttps://r4.ercloud.org/R4 GIS Data Submittal/index.html. Ensure all GIS, CAD, and image formatted files used to developmaps for any document developed R4 are delivered to the EPAin approved format.
Data Planning9
Preflmin ry m!fflt&st lnspec11oo·f .IV,;ilRemoval Actions maybe stand-alone actionsOR they may occurduring any phase ofthe remedial processThe SuperfundP1rocess
Emergency ResponsesPhases ofSuperfundProcess –What is yourexitstrategy? Short Form DMP that references the Removal Program DMP No QAPP Required - sometimes prepared on long-term responses Primarily Scribe, EQuIS as data archiveTime-Critical Removal Short Form DMP that references the Removal Program DMP QAPP Required - may contain the Short Form DMP but does not have to Primarily Scribe, EQuIS as data archiveTypical Remedial Projects or Site Assessments Short Form DMP that references the Superfund Division DMP (TBD) QAPP Required - should contain the Short Form DMP as an attachment Primarily EQuIS, access to all prior dataComplex Remedial Projects DMP as stand-alone document QAPP Required - will contain references to the stand alone DMP Primarily EQuIS, access to all prior data
When is a Data Management PlanningNeeded?
Gro u:nd1.- llt:Fi:D[lt!,/'T s.f f (0L ud( 5ollln.:sl:1;itio"onW II,.-.e:ter,T mpou ;r, fi dllMlnc: ,INa ,1 HJ!SullsurfK-tJ'((lire lbooncls.edlmm tw.ner111,111",J I,,J-lNK"MIi:, INflll @tiloosI,el5,(1EPAR.4 Lo e; looEPAR.4 Loe; loo ,l!{R4 SuperfundEnvironmentalData SubmissionTable 2-4Required EDDFiles. Well Coo ·EP.Actllln1IE.*KWolili [jjPt-blbl,Wtll!i.lIR.e:iiden.tia II,ll)Iibll t5"!J}l)lyi!Wlrulro:&eAml:!le tAl ,111. ruOilr;,e l5-011,G.ai'f'l'ilb i,!il!;,l1llrE"-c:1lion 4\f; p oIt,mdAroc. ',f I,j"I.N.K:a:.M"i]I-l,J]IMJ:,;:N,N,K:a: :a:,:NM"Qr,:;nT,G J.rEl'AR.C!WG IIGl",DIJ Ll lh'i t arl ltril!Q,M,J.,,K ;::tXXX:,,: ii:M.K.K-{)C 7Ji :a:I(EPA1!1.t - te Leve:is ;MK MEi-1 I,J"1)t7iiii-l-l,J"-l-lI",J· ' ii:M.K."" "·K .,.,-I"EPM.t lilflo:t\ogyPAR.1.WellllmR Fl Id Fl rn ltsEP.ll,R4 Fsami;,leE A 4 TSTSPA 4 RE5. 191:lgAd roe sVI 911ilding P':1- m VI Outd a ir LOO!tforr;eq ulrl!d; Ji.KJil[Ji "·K.KJil[Ji ""Ki!;:X"Ki!;:·" NK.N,K:a: NK.N,K:a:I!:QC'll,J-l-l-lWhe 11 roequested, :tu m cs and p'ha t os !lioul:I be !liubmlttetil. Exsm le'!iare m in Itlo,n · lch nw t b e !!:ub m ltted In ,11 n EDD.e::11:u ,pt f 1M" ell 1;:n ;en 111 ule!- l[,J VI B.llbc."ie5 ,CIM"QI c;n.KJi"'\115 P esVl e t Re:su,Jiii I uilding l reipecioon,,,, ot Re;:iulredcl d;;, M&- br-111;1 ln ta-f.i,a;, Pra , jPl; .-nd Cona, P-m.11tr; o;;;;d u,J :,,:IJ:,f,;:""NI(M.I(M.I(":,,:""X,f.M ,f,;:.M -I,;:mo:n or ln - wells. loaUom. etc. Hl tor1c lnfurma l lo may be !!en! a n PDFNNle,
SampleBookingWorkflow:Analytical Request Form (ARF)RPM /OSC-RPM/SI TE MANAG ER:Reviews Sampling Pla n\QAPP and emails approvalto Co ntractorNardina entersinformatio n intoProject Log togenerateProject ID and ProjectNumbers---'.-R4DARTFIELD TEAMR4 or ContractorEmailNotification' Email-Fiekl AssignmentConfirmation emailReceives ContractSubmitPOC Site Co ntacts EDDtoR4DARTContractor submits1-Analysis Request Form(Excel) to NardinaStep 1Setup Site Con tactsStep 2Pre Field EventL. -- -EC jilS -. ,.Contracto r updates2-Analysis Request FormEDD (Excel) with Project10\Project Numbers, startdate and lab.Email to R4DART
Data &VisualizationDatabases EQuIS MS AccessPlatform GeoPlatform EQuISTechnical Software Rockworks Modflow SADA CAD Surfer ArcGIS (ESRI) EnviroInsite (EarthSoft) Scribe (EPA) EDGE (EarthSoft) Collect (EarthSoft) Survey 1-2-3 (ESRI) Collector (ESRI)
R4 Superfund and Data Management 2005 -2010 launches DART; ELEMENT replaces R4LIMS 2007 R4 contracts w/B&V for EQuIS technical assistance 2008 - 2013 R4 *upgrades* EDD Format Files, *upgrades* servers, database schema, DART Dashboard 2010 - Present 2010 Superfund DD issues Policy Memo; Website 2010 Environmental Data Submission SOP 2013 Executive Order for Open Data
