electronic submission of laboratory data and sample information for ust reports stl - sacramento,...

Electronic Submission Of Electronic Submission Of Laboratory Data And Sample Laboratory Data And Sample Information For UST ReportsInformation For UST Reports

STL - Sacramento, September 20, 2001STL - Sacramento, September 20, 2001Michael W. GjerdeMichael W. Gjerde

Division of Clean Water Programs, SWRCB Division of Clean Water Programs, SWRCB (916) 341-5682 (916) 341-5682

[email protected]@cwp.swrcb.ca.gov

EDF Overview Why Why WhoWho WhatWhat WhereWhere WhenWhen How toHow to How MuchHow Much HelpHelp

Why Assembly Bill 2886 (2000) Assembly Bill 2886 (2000) Bring accurate and timely data about MTBE into Bring accurate and timely data about MTBE into

centralized public database (GeoTracker)centralized public database (GeoTracker) SWRCB to adopt emergency regulations SWRCB to adopt emergency regulations

concerning electronic submission of UST reportsconcerning electronic submission of UST reports First attempt to get statewide submission of First attempt to get statewide submission of

electronic dataelectronic data Applies to soil and water samples from UST sitesApplies to soil and water samples from UST sites

What Is GeoTracker

A data warehouse that integrates data across A data warehouse that integrates data across environmental programs via the Internetenvironmental programs via the Internet

Is the choice of the SWRCB to manage the Is the choice of the SWRCB to manage the MTBE problemMTBE problem

Provides public access and supports business-to-Provides public access and supports business-to-government transactions government transactions

Facilitates decentralized data management- lead Facilitates decentralized data management- lead agencies “own” and manage their dataagencies “own” and manage their data

Simplifies data exchange and improves data Simplifies data exchange and improves data qualityquality

© 2001 EcoInteractive

Expected Benefits Enable easy exchange of information between the Enable easy exchange of information between the

regulatory agencies, industry, and the publicregulatory agencies, industry, and the public Builds an information network to integrate data-Builds an information network to integrate data-Supports Supports

other programsother programs Provides statewide access to permit, compliance, and Provides statewide access to permit, compliance, and

enforcement actions- enforcement actions- Integrated easy accessIntegrated easy access Moves agencies and regulated businesses to electronic Moves agencies and regulated businesses to electronic

reporting- reporting- Improves data qualityImproves data quality Allows analysis of previously unknown relationships- Allows analysis of previously unknown relationships- Better Better

decisionsdecisions


Who Laboratories to prepare chemical analytical Laboratories to prepare chemical analytical

results in specified Electronic Deliverable results in specified Electronic Deliverable Format (EDF) for soil and water samplesFormat (EDF) for soil and water samples

RPs to submit electronic laboratory. sample RPs to submit electronic laboratory. sample information, and locational data to SWRCB information, and locational data to SWRCB in addition to regular hard copy reports sent in addition to regular hard copy reports sent to lead agencyto lead agency

Lead Agency to match electronic lab Lead Agency to match electronic lab submission with receipt of hard copy reportssubmission with receipt of hard copy reports

What Adds Article 12 (Sections 2729 and 2729.1) Adds Article 12 (Sections 2729 and 2729.1)

to Chapter 16, Division 3, Title 23, CCRto Chapter 16, Division 3, Title 23, CCR Authority: Water Code Sections 13195 to Authority: Water Code Sections 13195 to

1319813198 Requires: Requires:

• Electronic submission of laboratory reports for Electronic submission of laboratory reports for soil and water samplessoil and water samples

• Locational and sample dataLocational and sample data

Electronic Laboratory Reports - September 1, 2001

Electronic submittal of EDF laboratory data Electronic submittal of EDF laboratory data over the Internet shall be in addition to hard-over the Internet shall be in addition to hard-copy laboratory reports…copy laboratory reports…

Generated by either COELT or other Generated by either COELT or other laboratory software. laboratory software.

All data shall be checked for errors prior to All data shall be checked for errors prior to submittal, using the EDCC software submittal, using the EDCC software consistency checking tool. consistency checking tool.

EDF ““EDF” is Electronic Deliverable Format EDF” is Electronic Deliverable Format

developed for the United States Army Corps developed for the United States Army Corps of Engineers. of Engineers.

Data standard Data standard Set of relational database files Set of relational database files Data components include: Data components include:

• the chain-of custody information, the chain-of custody information, • laboratory results, laboratory results, • and quality assurance information. and quality assurance information.

How Laboratories Produce and Report EDF Data

Laboratory exports data from their LIMSLaboratory exports data from their LIMS Data is converted into EDF1.2i upload format withData is converted into EDF1.2i upload format with

• Laboratory LIMS software toolsLaboratory LIMS software tools• COELT software provided by EDF ProgramCOELT software provided by EDF Program

EDD is verified with error checking toolsEDD is verified with error checking tools• GeoTracker web toolGeoTracker web tool• EDCC software provided by EDF ProgramEDCC software provided by EDF Program

Electronic EDF data is transferred to client with Electronic EDF data is transferred to client with hard copy reporthard copy report


Examples of EDF Contents

Analytical Results• Laboratory Ids• Analysis Date• Preparation batch• Results

QA/QC data• Control Limits• Surrogates• Blanks• Spikes

Chain-of-Custody Data• Global ID• Field Point Name• Sample Ids• Collection Date/Time• Preservation

EDCC Error Checking Program

Format Errors• Fields submitted in incorrect order• Incorrect valid valuesLogic Errors, such as…• Analysis date prior to sample date• Test without resultsContent Errors• Detection limits greater than reporting limits

Electronic Reporting of Sampling Locations

Begins January 1, 2002Begins January 1, 2002GeoTracker HelpGeoTracker Help

800-506-9118800-506-9118geotrackerhelp@[email protected]

Location (XYZ) Data Survey XYZ Guidelines and RestrictionsSurvey XYZ Guidelines and Restrictions The latitude and longitude of groundwater The latitude and longitude of groundwater

monitoring wells accurate to within one meter, monitoring wells accurate to within one meter, The surveyed elevation, relative to mean sea The surveyed elevation, relative to mean sea

level, of well casing in monitoring wells level, of well casing in monitoring wells sampled,sampled,

Groundwater information (DTW, FP, status),Groundwater information (DTW, FP, status), Site map for sample locationsSite map for sample locations..

Potential RP Data FlowSSWWRRCCBB

Responsible PartyResponsible Party

GEO_Z

Elevation SurveyElevation Su rvey

Analytical LaboratoryAnalytical Laboratory Location SurveyLocation Survey

Environmental Contractor• Depth to water• Free Product• Well status

Environmental Contractor• Depth to water• Free Product• Well status

EDFFLAT+ hardcopy GEO_XY

GEO_WELL

• Prepare hard copy report• Data Interpretat ion

• Submit EDD to GeoTracker• Submit report to lead agency

• Submit EDD to GeoTracker• Submit report to lead agency


Sept. 1, 2001

Site MapSite Map

AB2886 Data FlowSSWWRRCCBB

Responsible PartyResponsible Party

ElectronicUpload

Secure GeoTracker AB2886 PagesSubmission & Error Checking

Lead Agency receives electronicdata from holding area

GeoTrackerData warehouse

•EDF-laboratory results•Elevation•Location•DTW, free product, & MW status•Site Map

Lead AgencyCase Worker

Paper Reports

Internet Tools& Reports


GLOBAL_ID FIELD_PT_NAME

GEO-WELL

GEO_XY

GEO_Z

EDFANALYTICAL

TABLES

GeoTracker EDD Relational Files




GLOBAL_ID

Site Map

GW_MEAS_DATE

SURVEY_METHOD

XY_SURVEY_DATE LATITUDE

ELEV_SURVEY_DAT

LONGITUDE

ELEVATION

DTW

RISER_HEIGHT GW_MEAS_DESC

XY_DATUM

XY_SURVEY_ORG XY_EQUIP_TYPE

XY_SURVEY_DESC

ELEV_DATUM ELEV_SURVEY_ORG

ELEV_SRVY_DESC

XY_SURVEY_METH

FIELD_PT_CLASS

STATUS

DTFPROD

TOT_DEPTH

RISER_HT

XY_ACC_VAL

ELEV_ACC_VAL

Location Data

Requires Requires Survey QualitySurvey Quality Locations Locations Sub-meter accuracy-Sub-meter accuracy-

Latitude/Longitude (decimal degrees, HPGN NAD83)Latitude/Longitude (decimal degrees, HPGN NAD83) State Business and Professions Code Sec. State Business and Professions Code Sec.

8726 (a, b, f, m), Sec. 6731.1 (a, b, c)8726 (a, b, f, m), Sec. 6731.1 (a, b, c) Requires submission of metadataRequires submission of metadata

Survey XY_Z Restriction & GuidelinesSurvey XY_Z Restriction & Guidelines


Use of survey quality GPS technologyUse of survey quality GPS technology- Do not use Mapping grade 1 to 5 meter GPS units- Do not use Mapping grade 1 to 5 meter GPS units- Do not use recreational/navigational GPS unitsDo not use recreational/navigational GPS units

Classical Survey Techniques combined with HPGN Classical Survey Techniques combined with HPGN reference pointsreference points• Triangulation Triangulation • Traverse Traverse (Federal Geodetic Control Subcom. 3(Federal Geodetic Control Subcom. 3rdrd order) order)

• TrilaterationTrilateration Classical Survey Techniques combined with GPSClassical Survey Techniques combined with GPS

Location Survey Methods

Elevation Data Potential Issues

RequiresRequires• Measured elevation to top of well casing Measured elevation to top of well casing

Use of licensed surveyorUse of licensed surveyor Requires submission of metadataRequires submission of metadata Survey XY_Z Restriction & GuidelinesSurvey XY_Z Restriction & Guidelines


Digital differential levelingDigital differential leveling

Differential leveling using HPGN GPS Differential leveling using HPGN GPS vertical reference points vertical reference points >> 3 surrounding reference points 3 surrounding reference points

Elevation Survey Methods

Get Ready For Electronic Reporting

Verify that your analytical lab can produce EDFVerify that your analytical lab can produce EDF• Review/modify your laboratory contractsReview/modify your laboratory contracts• Test your lab’s EDF format by using the desktop Test your lab’s EDF format by using the desktop

EDCC application from SWRCB AB2886 web siteEDCC application from SWRCB AB2886 web site Plan ahead for location and elevation dataPlan ahead for location and elevation data Check GeoTracker “AB2886” link for new Check GeoTracker “AB2886” link for new

documents and informationdocuments and information


Web Pages http://www.swrcb.ca.http://www.swrcb.ca.govgov. .

• http://www.swrcb.ca.gov/cwphome/ust/docs/ab2886/list.htmlhttp://www.swrcb.ca.gov/cwphome/ust/docs/ab2886/list.html• Implementation sectionImplementation section• Direct Link from main page, Emergency regulationsDirect Link from main page, Emergency regulations

SWRCB GeoTracker Database SWRCB GeoTracker Database • http://geotracker.swrcb.ca.gov/http://geotracker.swrcb.ca.gov/

Passwords and LoginPasswords and Login• https://geotracker.swrcb.ca.gov/ab2886/https://geotracker.swrcb.ca.gov/ab2886/

http://geotracker.swrcb.ca.gov/


Security Identification

• Responsible parties will need to obtain a password to submit data

• RPs can request a password on-line


On-line Password Request

Permission for Consultants to Submit Data

RP or “Authorized RP Agent”

Site 1 Site 2 Site 3

• Consultant 1• Consultant 2• Consultant 3



Request Facilities

Obtains Password

Consultants Request Facilities

Reg. Yes/No

RP Yes/No

Responsible Party Electronic Reporting Interface


• Request/view LUST sites associated with RPs

• Find GeoTracker LUST site and well Ids

• Use error checking tools & get error reports

• Upload/submit EDDs

RPs Request Permission to Submit EDD for Sites

Approve/Deny Permission to Submit EDD for Sites

Obtain Global IDs and Sampling Point Names

Download Global IDs for Sites associated with a RP’s password

Upload Sampling Point Names

Global ID122446122446122446213356213356

Field Pt NameMW-01MW-02 MW-03MW-01MW-02

Facility IDC366C366 C366CR112`CR112

Error Check Before Submission


Error Check Before Submission

• The “browse” button will let you choose a file from your computer

• The “import” button will submit the file to error checking program

• Dynamic error check reports will be returned


Uploading Data For Submission• The “browse” button will let you choose a file from your

computer• The “import” button will submit the file to the SWRCB• All data will be “error checked” and data must pass the

error check to be submitted• Confirmation number will be returned

Who Pays Electronic Reporting CostsElectronic Reporting Costs

• Laboratory AnalysisLaboratory Analysis• Elevation SurveysElevation Surveys• Depth to WaterDepth to Water• Locational SurveysLocational Surveys

““The UST Clean Up Fund will pay for all The UST Clean Up Fund will pay for all costs that are reasonable, necessary,….and costs that are reasonable, necessary,….and eligibleeligible.”.”

Enforcement The Cleanup Fund may not reimburse the costs of The Cleanup Fund may not reimburse the costs of

laboratory analysis performed after September 1, laboratory analysis performed after September 1, 2001 if they do not include EDF2001 if they do not include EDF

Lead Agency may refuse to sign off on proposed Lead Agency may refuse to sign off on proposed case closurescase closures

Lead Agency may decline to review reports Lead Agency may decline to review reports submitted without the EDFsubmitted without the EDF

Lead Agency will take enforcement action, starting Lead Agency will take enforcement action, starting with informal actions such as phone call or letter.with informal actions such as phone call or letter.

Available Support For EDF Guidelines & RestrictionsGuidelines & Restrictions- Documentation - Documentation Laboratory TrainingLaboratory Training- Ten (3-day) sessions - Ten (3-day) sessions

state-wide state-wide Online Training and TutorialsOnline Training and Tutorials Desktop Software Tools:Desktop Software Tools:

• COELT- COE Loading ToolCOELT- COE Loading Tool• EDCC- Electronic Deliverable Consistency Checker EDCC- Electronic Deliverable Consistency Checker

(also GeoTracker web version)(also GeoTracker web version) Help Desk Support 1-800-506-3887Help Desk Support 1-800-506-3887


Available Support For Location Data

Survey XYZ Guidelines & RestrictionsSurvey XYZ Guidelines & Restrictions-- RP/Consultant/Regulator RP/Consultant/Regulator training sessions training sessions

state-wide state-wide Online Training and TutorialsOnline Training and Tutorials Desktop Software Tools:Desktop Software Tools:

• DataStream FreeDataStream Free• DataStream Free DocumentationDataStream Free Documentation

Help Desk Support 1-800-506-9118Help Desk Support 1-800-506-9118


Summary WHY - AB 2886WHY - AB 2886 WHO - Labs, RPs, Lead Agencies, SWRCBWHO - Labs, RPs, Lead Agencies, SWRCB WHAT - EDF lab reports, Sample Information WHAT - EDF lab reports, Sample Information WHERE - over Internet to SWRCB GeoTrackerWHERE - over Internet to SWRCB GeoTracker WHEN - Sept 1, 2001 lab data, January 1, 2002 WHEN - Sept 1, 2001 lab data, January 1, 2002

locational datalocational data HOW - Passwords, manage sites, submit dataHOW - Passwords, manage sites, submit data HELP - SWRCB Web Pages, Help desksHELP - SWRCB Web Pages, Help desks

What Type of Data Must Be Electronically Reported?

AB2886 Electronic Data DeliverablesAB2886 Electronic Data Deliverables

Begins September 1, 2001Begins September 1, 2001 Laboratory Soil and Groundwater Sample ResultsLaboratory Soil and Groundwater Sample ResultsBegins January 1, 2002Begins January 1, 2002 Sample Locations (latitude/longitude)Sample Locations (latitude/longitude) Monitoring Well Elevation DataMonitoring Well Elevation Data Groundwater Well Data (DTW, free product & status)Groundwater Well Data (DTW, free product & status) Site MapSite Map


QUESTIONS?

electronic submission of laboratory data and sample information for ust reports stl - sacramento,...

Documents