EQuIS Training - US EPA
EQuIS TrainingEQuIS Workflow and EQuIS ProfessionalAPRIL 26, 2016Janet Magurn, PresidentTinna Chan, Systems Engineer
Introductions What is your background? RPMs? Hydros? Risk Assessors? Other? Have you ever used EQuIS? EQuIS Professional? EQuIS Enterprise? EQuIS Data Processor (EDP)? What software do you use? What would you like to get out of this class?
Introduction to EQuIS
Agenda Introduction to EQuIS Products and Workflows EarthSoft Resources Basic EQuIS Concepts and Terminology EQuIS Professional Navigation Crosstab Reports Graphs and Charts EQuIS for ArcGIS EQuIS Data Processor (EDP) Discussion
Objectives Understand the difference between EQuIS Professional and EQuIS Enterprise Explore EQuIS Workflows Review available resources provided by EarthSoft Learn how data is organized in the EQuIS database Review EQuIS-specific terminology
What S is the most widely used environmentaldata management workflow in the world andhelps thousands of organizationsmanage environmental, geotechnical,limnological and “other” sample data.
One Database, Two User InterfacesEQuIS se(Oracle/SQL)EQuIS provides twosets of modules for different user typesconnected to the sameOracle or SQL Server database. Data managers, ScientistsDesktop application (installation)Data importing, editingAdvanced analysis, modeling*Ultimate power and flexibility* May require additional third-party software Managers, Auditors, ExecutivesWeb application (no installation)Same database, same dataSimple, quick, easy to useWorkflow Automation
EQuIS Products and WorkflowsField ortingEnvironmentalDataManagementVisualizationOwn the workflow, make better decisions
EQuIS Workflow ViewSensors,Instrumentsand hboardsField ingInspections
EQuIS Schematic ViewEDGE(Field Data Collection)LaboratoryLIMSPlanning& InputSPM(Task Management)EDP(Data Processor& Checker)Professional(User Interface)EQuISSchemasEnterprise(User Interface)Powerful Reporting ToolsDashboards and Widgets(Reports/Alerts/Graphics)DQM, Alive, LakeWatch,Third Party InterfacesLive(Data Loggers)
EDGE(Field Data Collection)EPA Region 2EQuIS WorkflowEPA Region 2: Cathy LaiLai.ngateng@epa.govRegion2 equisedd@epa.govLaboratoryLIMSValidatorsEDP(Data Processor& Checker)Data Providers(Compile field and lab datainto an EDD and submits toRegion 2)EQuISSchemasEnterprise(User Interface)Dashboards and Widgets(Reports/Alerts/Graphics)
EQuIS DatabaseEDGE(Field Data Collection)LaboratoryLIMSPlanning& InputSPM(Task Management)EDP(Data Processor& Checker)Professional(User Interface)EQuISSchemasEnterprise(User Interface)Powerful Reporting ToolsDashboards and Widgets(Reports/Alerts/Graphics)DQM, Alive, LakeWatch,Third Party InterfacesLive(Data Loggers)
EQuISDatabaseSQL Server Oracle SQL Express Schemas for environmental data management Oracle, Microsoft Azure, Microsoft SQL Server, SQLServer Express One project to thousands of projects within insingle databaseRuns ondatabaseserver
EDPEDGE(Field Data Collection)LaboratoryLIMSPlanning& InputSPM(Task Management)EDP(Data Processor& Checker)Professional(User Interface)EQuISSchemasEnterprise(User Interface)Powerful Reporting ToolsDashboards and Widgets(Reports/Alerts/Graphics)DQM, Alive, LakeWatch,Third Party InterfacesLive(Data Loggers)
Standalone EDP andProfessional EDPEDPPurposeErrors highlighted Check Electronic DataDeliverables, (EDDs)for formatting, logic Find, view, andCORRECT errors Easily find the “needlein the haystackHighlightsEDD sectionswith errorsMissing requiredfield, makecorrectionReference value not found,select correct value frompull down menu
Enterprise EDPEDPPurpose Automated Workflowreceives (via ftp, email,or web) and processesEDDs. Acceptance and/orrejection notificationsare automatically sent.Successful EDD SubmissionNotifications
ProfessionalEDGE(Field Data Collection)LaboratoryLIMSPlanning& InputSPM(Task Management)EDP(Data Processor& Checker)Professional(User Interface)EQuISSchemasEnterprise(User Interface)Powerful Reporting ToolsDashboards and Widgets(Reports/Alerts/Graphics)DQM, Alive, LakeWatch,Third Party InterfacesLive(Data Loggers)
EQuISProfessionalReports Contamination plumes Groundwater gradients Graphs, tabular andcrosstab reports, Advanced, formattedprint-ready reports
EQuIS forArcGISPurpose Access EQuIS datadirectly withinArcGIS Desktop Add EQuIS layers toan ArcGIS Map Link to industryleading third partyapplications
EQuIS EnterpriseEDGE(Field Data Collection)LaboratoryLIMSPlanning& InputSPM(Task Management)EDP(Data Processor& Checker)Professional(User Interface)EQuISSchemasEnterprise(User Interface)Powerful Reporting ToolsDashboards and Widgets(Reports/Alerts/Graphics)DQM, Alive, LakeWatch,Third Party InterfacesLive(Data Loggers)
Dashboards and WidgetsEnterpriseHighly configurabledashboards andproject-specific widgetsfor endless flexibility.
ReportsEnterprise Export to GoogleEarth, Excel, GISand other popularformats. Map directly inEQuIS Enterprisewith the Map Widgetand ArcGIS Online
EIA Workflow AutomationEnterpriseEQuIS InformationAgents (EIAs)automatically sendreports when New data arrives Exceedances occur Based on ascheduled event
Document ManagementEnterpriseUse the Explorerwidget in EQuISEnterprise, to takedrawings, graphs,photos, etc. andassociate them to alocation.
Available EarthSoft Resources
EQuIS Resources EarthSoft Community Center- http://community.earthsoft.com Online Data Dictionary Online Documentation EQuIS Academy Recordings and other Downloads Discussion Forum EarthSoft Website- http://www.earthsoft.com Upcoming Training Schedule Additional Product Information and Corporate Overview Upcoming Office Hours and Previous Office Hour Videos Lists of available EDD Formats For support, the designated Point of Contact (POC) may contactsupport@earthsoft.com
EQuIS Webpages EPA Region 2 Format Download or-epar2/
EQuIS Webpages EPA Region 2 Format Download or-epar2/ EPA Region 2 Superfund Electronic Data Submission erfund-electronicdata-submission For technical EQuIS support, EPA Region 2 EQuIS users maycontact:Cathy LaiLai.Ngateng@epa.govRegion2 EQUISedd@epa.gov
Basic Concepts andTerminology
What are we going to talk about?General Database Terms Relational Databases One-to-Many Relationships Parent-Child Relationships Primary Keys Referential IntegrityEQuIS-specific Terms Data Tables Reference Tables Facilities Locations Location Groups Location GroupsAnalytesAnalyte GroupsAction LevelsCrosstab ReportsEnvironmental SamplingTerms CAS RNs Sample Types Matrices EDDs E-Data
General Database Terms
Relational DatabasesRelational databases stores their data in tables and canenforce restrictions on the data by a set of rules calledrelationships.
One-to-Many RelationshipsOne-to-many relationships are relationshipsin which a record in one table can be relatedto many records in another table.There can be manysampling points within asingle project site.For example, “Gas StationX” may contain 8 differentmonitoring wells.
Parent-Child RelationshipsParent-child relationships are rules that enforceorganization in a database by requiring a record in a childtable to have a corresponding record in a parent table.The structure allows repeating information using parentchild relationships: each parent can have many childrenbut each child only has one parent.
Primary KeysA Primary key is a field or a set of fields in a table thatconstitute a unique record within that table.One primary key field in this tableallows for each chemical to be listedonly once.A set of primary key fields this table allows forstorage of multiple coordinate systems persampling point.Primary keys must be:1) populated (not null)2) unique
Referential IntegrityReferential integrity is the collective set of rules thatensures consistent data within the database, including Primary Keys One-to-Many Relationships Parent-Child Relationships
EQuIS-specific Terms
Data TablesData tables contain information acquired from, derivedfrom, or describing some part of a specific project.Data tables are designated by the prefixDT SAMPLE.DT ,as in
Reference TablesReference tables contain lists of reference values, valid values orlook-up values.Reference tables are designated by the prefix RT , as in RT ANALYTE.rt analyte Cas rnChemical Name000056-55-3 Benz(a)anthracene000065-85-0 Benzoic Acid000067-64-1 Acetone000071-43-2 Benzene000074-83-9 Bromomethane000074-87-3Chloromethane000075-01-4 .Vinyl chloride
FacilitiesFacilities are the physical (site) or logical (project)extent of data that is made available for reporting ormodeling.Facility
LocationsLocations are uniquely designated sampling points, typicallyon the ground surface, that can be identified spatially by x,y, and z coordinates.Stored in EQuIS inDT LOCATIONas a “SYS LOC CODE”.X coordinateY coordinateTotal depthSurface elevationDrillerStart date others
Location GroupsLocation Groups are collection of locations for reporting andgraphing.
Analytes‘Analytes’ are defined as the substance you analyze orquantify by an analytical procedure.Many different names can be used to mean the same thing:analyte, chemical, compound, constituent, contaminant,determinant
Analyte GroupsAnalyte Groups are collections of analytes for reporting andgraphing.
Action LevelsAction levels are values against which results orparameter measurements are compared to. Action Levelsmay also be referred to as standards, comparison criteria,or other names.Action Level
Crosstab ReportsData as contained in a database:Cross Tabbed data:Crossed tabbed data is much easier to read andunderstand.
Environmental SamplingTerms
CAS RNsCAS RNs are abbreviations for Chemical Abstracts ServiceRegistry Numbers. The CAS RN, often referred to as “CASnumber,” is a unique numeric identifier which refers to achemical substance.For example, 58-08-2 is the CAS Registry Number forcaffeine.Compare to chemical name synonyms:661-97-2 1,2,3, 3-Hexafluoro-2,3-dichloropropaneCFC-216 vs. Freon 216To find CAS numbers, visit http://www.cas.org http://www.chemfinder.com
Sample Types“Sample types” refer to the classification of samplesbased on the sampling purpose and procedure.Sample types are stored in RT SAMPLE TYPE and mayinclude: NNormal Environmental Sample FBField Blank BSBlank Spike BDBlank Spike Duplicate TBTrip Blank RBMaterial Rinse Blank MSLab Matrix Spike .
MatricesMatrix describes the media from which the sample wastaken.Matrices are stored in Groundwater Soil Air Fish Tissue .RT MATRIXand may include:
EDDsEDDs, or Electronic Data Deliverables, are electronictabular formats for sharing, manipulating, and using data.An Access database, an Excelspreadsheet, a tab delimitedtext file, and even zipped filesare all examples of EDDs.EDDEFWEDD or4-FileFormat
E-DataE-Data refers to data that are available in a usableelectronic format.EDPChecksUnlike EDDs, E-Data is NOT directly checked by theEQuIS Data Processor
EQuIS Professional
ProfessionalEDGE(Field Data Collection)LaboratoryLIMSPlanning& InputSPM(Task Management)EDP(Data Processor& Checker)Professional(User Interface)EQuISSchemasEnterprise(User Interface)Powerful Reporting ToolsDashboards and Widgets(Reports/Alerts/Graphics)DQM, Alive, LakeWatch,Third Party InterfacesLive(Data Loggers)
EQuISProfessionalPurpose: Part of anEnvironmentalDataManagementWorkflow and isused to check,edit, and loaddata. Report, graph,and export thedata to a varietyof templates andapplications.
EQuIS Professional NavigationAvailable ToolsIn every Table and Tabular Report in EQuIS Professional Filter Pin Columns Column Chooser Find andReplace Refresh
Location GroupsLocation Groups are collection of locations for reporting andgraphing.
Analyte GroupsAnalyte Groups are collections of analytes for reporting andgraphing.
Action LevelsAction levels are values against which results orparameter measurements are compared to. Action Levelsmay also be referred to as standards, comparison criteria,or other names.Action Level
EQuIS Reports
The Purpose of EQuIS ReportsEQuIS Professional offers many different types of reports.Reports may be used to build simple queries or create highlyformatted output. There are several types of reportsavailable: Tabular Reports Crosstab Reports Time Series Charts XYZ Plots (Contours, Surface Plots)
TabularReports Query data frommultiple tableswith one report Easy to selectparameters andsave Pick Reportsfor future use Can filter datafurther and useother tools withintabular reports
CrosstabReports Build Crosstab Reportswith tabular queries tobetter understanddata Apply Microsoft Exceltemplates and publishdesigns to thedatabase Publish Crosstabdesigns to make themvisible to all users
TimeSeriesChartsCreate Time SeriesCharts withtabular queries
XYZChartsCreate XYZ Chartswith tabularqueries
Access EQuIS Professional1. Login to EQuIS Professional from Start All Programs EarthSoft EQuIS Professional.2. Select the Facility into which data will be viewed orreported.
EQuIS for ArcGIS
Required Permissions and SoftwareEQuIS for ArcGIS EQuIS Professional v6.0 or higher must be installed and registered on theworkstation .NET Framework v4.0 or higher must be installed ArcGIS 10.0 or higher must be installed Read permissions are required for the desired facilities for EQuIS forArcGIS Connection and Layer Building Read/write permissions are required for the desired facilities for Adding orModifying Locations and Location Groups
EQuIS forArcGISPurpose Access EQuIS datadirectly withinArcGIS Desktop Add EQuIS layers toan ArcGIS Map Link to industryleading third partyapplications
Access EQuIS for ArcGIS1. Launch ArcMap from Start All Programs ArcGIS ArcMap 10.x.2. From the EQuIS for ArcGIS toolbar, select Add Facility and login to thedesired facility.
Thank you forattending!Questions? Comments? Suggestions?Contact us:EarthSoft Trainings, training@earthsoft.comJanet Magurn, President, jmagurn@earthsoft.comTinna Chan, Systems Engineer, tinna.chan@earthsoft.com
Earth, Excel, GIS and other popular formats. Map directly in EQuIS Enterprise with the Map Widget . sampling point. Referential Integrity Referential integrity is th
query, and map the information found in an EQuIS databases. The EQuIS for ArcGIS interface is ideal for displaying and effectively communicating project information. IMPORTANT: The following fields must be populated in EQuIS Professional (e.g., the IDENTIFIER and COORD_TYPE_CODE and be populated) in order to use EQuIS for ArcGIS: DT .
Rapid Flow, Titration, Turbidimetry, Ultraviolet- Visible Spectroscopy (UV/VIS) Parameter/Analyte Water pH EPA 150.1 Turbidity EPA 180.1 Calcium EPA 200.7 Iron EPA 200.7 Magnesium EPA 200.7 Potassium EPA 200.7 Silica, Total EPA 200.7 Sodium EPA 200.7 Aluminum EPA 200.8 Antimony EPA 200.8 Arsenic EPA 200.8 .
Option 1: Plug a Tableau workbook directly into the EQuIS database. Issues: Requires a more expensive Tableau license More filtering has to be done, either in SQL or in Tableau Each workbook needs to be specifically set up. More Coding (SQL, T-SQL, Tableau functions) You lose all the extra functionality that EQuIS reports .
EPA Test Method 1: EPA Test Method 2 EPA Test Method 3A. EPA Test Method 4 . Method 3A Oxygen & Carbon Dioxide . EPA Test Method 3A. Method 6C SO. 2. EPA Test Method 6C . Method 7E NOx . EPA Test Method 7E. Method 10 CO . EPA Test Method 10 . Method 25A Hydrocarbons (THC) EPA Test Method 25A. Method 30B Mercury (sorbent trap) EPA Test Method .
vii References The following resources were used in producing this manual: EPA: Package Treatment Plants MO-12, EPA 430/9-77-005, April 1977 EPA: Summary Report: The Causes and Control of Activated Sludge Bulking and Foaming, EPA 625/8-87/012, July 1987 EPA: Manual: Nitrogen Control, EPA 625/R-93/010, September 1993 EPA: Handbook: Retrofitting POTWs, EPA 625/6-89/020, July 1989
EPA Method 7E –NO, NO 2, NOx Yes EPA Method 8 –SO 2, SO 3 Yes EPA Method 10 –CO Yes EPA Method 11 –H 2 S ( 50 ppm Yes EPA Method 16 –TRS Yes, including mercaptans and other reduced sulphurs EPA Method 18 –VOC’s Yes EPA Method 26 –HCl, HF Yes EPA CTM 027 –NH 3 Yes. ADVANTAGES OF FTIR
40 CFR Part 63 [EPA-HQ-OAR-2019-0314, EPA-HQ-OAR-2019-0312, EPA-HQ-OAR-2019-0313, EPA-HQ-OAR-2017-0670, EPA-HQ-OAR-2017-0668, EPA-HQ-OAR-2017-0669; FRL-10006-70-OAR] RIN 2060-AT49 and RIN 2060-AT72 NESHAP: Surface Coating
(half serious, half playful) Yes – except for last summer, when you never came near me –Sheila (Act 1) Suggesting that she doesn [t fully trust him, despite the fact that theyre going to be married soon, but again shows how she is childish, and relatively light-hearted, as she is still half playful [ even in something which could be seen as quite serious. men with important work to do .
