Events
EQuIS® Open Training August 23-25, at Minnesota PCA
May 16, 2011
Class Description:
This Open Training will provide the skills and techniques for managing and analyzing environmental data using EarthSoft’s Environmental Quality Information System (EQuIS). Attendees will gain experience working with environmental geology and analytical chemistry data. Workflow automation and web reporting will be covered using EQuIS Enterprise. Attendees will learn to use EQuIS Professional with several widely used reporting, visualization, and analysis tools which may include EnviroInsite, HoleBASE, EVS/EnterVol and others.
While the first portion of the class will be focused on the implementation and use of EQuIS, the final day will include in-depth training on the EQuIS for ArcGIS module. Attendees will learn how to import EQuIS data into ESRI’s ArcGIS® application and learn how to present data visually using pie charts, graduated symbols and contours. A site characterization exercise will train attendees to access data in the ArcView GIS spatial environment. Other topics include:
- Spider Diagrams (aka chem data boxes or tabular labels)
- 3rd party interface integration
- ArcGIS 3D Analyst (ArcScene) integration
- Animated graphics and 3D labeling utilities
Location and Requirements
This course will be held at MPCA, 520 Lafayette Rd N, St. Paul, Minnesota (Training Room 1, lower level).
Please bring your own laptop for use during this training class. Instructions for downloading and installing EQuIS, visualization and analysis tools, and ArcGIS evaluation software will be provided two weeks prior to the training.
Cost and Registration
The early registration fee of $1,500 ($1,800 for registration after August 10, 2011) includes instruction, and hand-on use of EQuIS, and class notes. To register for the course, please fill out the included Training Registration form and fax to 503-345-0212 or email to training@earthsoft.com.
EQuIS Open Training Agenda
Day 1 – Getting Started with EQuIS, Importing and Viewing Data
AM Session: EQuIS Database Management Basics
- What is EQuIS?
- Basic Concepts and Terminology
- Data Management Workflow and Planning
- EQuIS Workflow
- Database Setup and Administration
- Creating a new project
PM Session 1: EQuIS Professional EDP
- EQuIS Data Processor (EDP)
- Reconciling Field and Laboratory EDDs
- Submitting and Loading Data
- Rolling Back Data
PM Session 2: EQuIS Professional: Tables, Forms, Action Levels and Groups
- Data and Reference Table Inspections
- Using Data Views
- Creating Analyte, Location and Facility Groups
- Action Levels
Day 2 – Data Retrieval with EQuIS Professional and EQuIS Enterprise
AM Session: EQuIS Professional – Reports and Exports
- Fields and Tools Available
- Crosstab Reports
- Trend and Contour Plots
PM Session: EQuIS Enterprise — Loading Data, Reports and Information Agents
- Enterprise EQuIS Data Processor
- Double Closed Loop Data Quality Checking
- Creating and Using EZView Reports
- EQuIS Information Agents (EIA)
Day 3 – Mapping with EQuIS for ArcGIS
AM Session: EQuIS for ArcGIS
- Connect to your EQuIS database
- Map sample locations, geodatabase output, metadata
- Querying the EQuIS database (EZView)
- Symbology and Style Gallery
PM Session: EQuIS for ArcGIS – Data Retrieval with GIS
- 3rd Party Application Interfaces
- Spider Diagrams (tabular labels) with EnviroInsite
- ArcGIS 3D Analyst (ArcScene) integration
Download the pdf agenda and registration form here.
EQuIS® Open Training June 14–16, Denver, Colorado
May 12, 2011
Class Description:
This EQuIS Training Class will provide the skills and techniques for managing and analyzing environmental data using EarthSoft’s Environmental Quality Information System, or EQuIS. Attendees will gain hands-on experience working with environmental geology and analytical chemistry data. Workflow automation and web techniques will be covered using EQuIS Enterprise. A site characterization exercise will train users to access data in the ArcView GIS spatial environment.
Additionally, this EQuIS Training Class will have a special emphasis on the EQuIS Sample Planning Module (SPM) and the EQuIS Data Gathering Engine (EDGE). Attendees will learn how to use EQuIS SPM to create tasks for the future, add contracts, methods and labs and also create Sample Analysis Plans that comply with USEPA standards. Students will learn how to check the completeness of scheduled sampling and non-sampling field activities. In addition to SPM, the training instruction will also focus on EDGE for collecting environmental field data, creating standardized Chains of Custody and generating Electronic Data Deliverables to import into EQuIS.
While much of the class will be focused on the implementation and use of EQuIS, discussion will also include critical data management principles such as:
- Developing standard operating procedures for data management
- Creating sampling plans
- Working with analytical labs
- Field procedures and data collection
Location and Requirements
This course will be held at 44 Union Boulevard, Suite 300, Lakewood, Colorado.
Please bring your own laptop for use during this training class. Instructions for downloading and installing EQuIS, visualization and analysis tools, and ArcGIS evaluation software will be provided two weeks prior to the training.
Cost and Registration
The early registration fee of $1,500 ($1,800 for registration after June 1, 2011) includes instruction, and hand-on use of EQuIS, and class notes. To register for the course, please fill out the included Training Registration form and fax to 503-345-0212 or email to training@earthsoft.com.
EQuIS Open Training Agenda
Day 1 – Getting Started with EQuIS, Importing and Viewing Data
AM Session: EQuIS Database Management Basics
- What is EQuIS?
- Basic Concepts and Terminology
- Data Management Workflow and Planning
- EQuIS Workflow
- Database Setup and Administration
- Creating a new project
PM Session 1: EQuIS Professional EDP
- EQuIS Data Processor (EDP)
- Reconciling Field and Laboratory EDDs
- Submitting and Loading Data
- Rolling Back Data
PM Session 2: EQuIS Professional: Tables, Forms, Action Levels and Groups
- Data and Reference Table Inspections
- Using Data Views
- Creating Analyte, Location and Facility Groups
- Action Levels
Day 2 – Data Retrieval with EQuIS Professional and EQuIS Enterprise
AM Session: EQuIS Professional – Reports and Exports
- Fields and Tools Available
- Crosstab Reports
- Trend and Contour Plots
PM Session: EQuIS Enterprise — Loading Data, Reports and Information Agents
- Enterprise EQuIS Data Processor
- Double Closed Loop Data Quality Checking
- Creating and Using EZView Reports
- EQuIS Information Agents (EIA)
- Integration of EQuIS Professional reports with EIA
Day 3 – Mapping, Sample Plans, and Field Data Collection with EQuIS
AM Session: EQuIS for ArcGIS – Data Retrieval with GIS
- EQuIS for ArcGIS Integration
- EQuIS for ArcGIS exports and outputs
- Spider Diagrams
PM Session: EQuIS Sample Planning Model and EDGE
- Create Sample Plans
- Sample Planning Outputs
- Collecting Data in EDGE
Download the pdf agenda and registration form here.
EPA Region 2 Training, by CDM and EarthSoft, on EDP, EQuIS for ArcGIS, and integration with SCRIBE, Forms 2 Lite, and CLP, May 10 & 11, 2011
May 5, 2011
You can view the agenda below or download it here.
Morning Session: 9:00 AM – 12:30 PM or Afternoon Session: 1:00 PM – 4:30 PM
Who Should Attend? – Anyone submitting data to Region 2 EPA
Please see below for instructions on logging into webinar
*If you would like to participate at 290 Broadway New York, NY please respond to bujalski.nicole@epa.gov for more information.
PRESENTERS:
Scott Kirchner (Program Chemist) CDM presentation: A Contractor’s Perspective on Meeting the EPA Region 2 MEDD
- Working with MEDD while planning and executing project work
- Working with laboratories and other subcontractors to aid your process
- MEDD preparation and processing: some “common” challenges and errors you may encounter
Janet Magurn (EarthSoft President) EPA Region 2′s MEDD format and the EQuIS EDP Tool, and other EDDs
What is the EPA Region 2 MEDD?
- Review EPA Region 2 EDDs
- 4 Sections: Field, Lab, Basic and Facility, Vapor Intrusion
What’s new in EPA Region 2 EDD Version 3?
- Vapor Intrusion
- Sample Parameter
- Miscellaneous fields
What is EQuIS Data Processor (EDP) software?
- How do I download EDP?
- Where do I get EDP license keys?
Reference Values
- How do I request new reference values?
- How do I download a new format file or updated reference value file?
Loading Data and Resolving Errors
- Troubleshooting Errors
- Sign and Submit
Location codes
- What do I do with locations without coordinates?
- What about Unique location codes?
Sample codes
- What are unique sample codes?
What is the CLP conversion tool?
- F2Lite, DAT Editor and validated CLP data
How do I submit SCRIBE data?
How do I enter TIC data?
- Naming conventions
Site specific Action Levels – New requirements for submittal
*If you would like to participate at 290 Broadway New York, NY please respond to bujalski.nicole@epa.gov for more information.
Joining the webinar:
1.) Go to the following web address: http://portal.epa.gov/webconference
2.) On the right hand side type in the MORNING WEB CONFERENCE ID: 397798
AFTERNOON WEB CONFERENCE ID: 398000
3.) Enter your name
4.) Leave all other fields BLANK
5.) Click ‘Join Conference’
6.) If prompted agree to installation
7.) There will be no call in number, audio will be streamed through your PC
Additional Information:
1) If this is your first web conference with EPA, run the new user test online at http://hawkeye.epa.gov/imtapp/app/nuf_sys.uix . If you fail any portion of the test, click on the details link to find tips to resolve your problem. If you cannot resolve an issue, contact epacallcenter@epa.gov for further support.
2) Please install the Oracle Web Conference client before joining the event. You may install it at anytime, though it is recommended that you do so at least a few hours before the call to avoid last minute complications. You may download the client from:
http://hawkeye.epa.gov/imtapp/console/cns_download.jsp?file=cnsconf&lang=en_US
3) You can log in from ANY computer with internet access using MS Internet Explorer 5.5 or higher and a recommended screen resolution of 1024×768 or higher. You do NOT need to be at work or have access to the EPA intranet to watch the event. If you see a security pop-up box asking if you wish to proceed, click yes.
4) You may see a message indicating that the Oracle software should be installed. CLICK YES! This is not a harmful program and you should have the rights to install it. It is simply an add-on to allow for the web-conference tools to run properly. If you do not have rights to install the add-on, please contact your local IT support to request help.
5.) Your screen may flicker as the software is installed and the web conference is opened up. This is completely normal.
EQuIS Enterprise – Web Dashboard
May 11, 2011
Morning Session: 9:00 AM – 12:30 PM or Afternoon Session: 1:00 PM – 3:30 PM
290 Broadway – Training Room 23rd Floor – please RSVP to bujalski.nicole@epa.gov
or See below for instructions on logging into webinar
Welcome Speaker (morning only)
Scott Kirchner (Program Chemist) CDM presentation: Complying with the EPA Region 2 MEDD
This presentation identifies some of the challenges that contractors may encounter while meeting the requirements of the EPA Region 2 MEDD. We will also discuss the stages of planning and executing a project to help mitigate the challenges.
Janet Magurn (EarthSoft President) Accessing and Reporting EPA Region 2 data in a web interface
This is a hands-on workshop focusing on reporting data that has been loaded into the EPA Region 2 system. The data will be accessed and reported using the EQuIS Enterprise web based reporting tools.
Discussion Includes:
- Compare results across multiple facilities.
- Easily compare results to site specific and federal MCL standards.
- Receive site reports automatically via email.
- Simplify the 5 year review process.
- Exchange data with Scribe, F2L, WQX, and other common EPA tools.
- Discuss new Vapor Intrusion Data.
(See attached file: EPAR2_trainingFlyer.pdf)
(See attached file: Agenda EDD Training May 11.pdf)
Joining the webinar:
1.) Go to the following web address: http://portal.epa.gov/webconference
2.) On the right hand side type in the MORNING WEB CONFERENCE ID: 399997
AFTERNOON WEB CONFERENCE ID: 399999
3.) Enter your name
4.) Leave all other fields BLANK
5.) Click ‘Join Conference’
6.) If prompted agree to installation
7.) There will be no call in number, audio will be streamed through your PC
Additional Information:
1) If this is your first web conference with EPA, run the new user testonline at http://hawkeye.epa.gov/imtapp/app/nuf_sys.uix . If you fail any portion of the test, click on the details link to find tips to resolve your problem. If you cannot resolve an issue, contact epacallcenter@epa.gov for further support.
2) Please install the Oracle Web Conference client before joining the event. You may install it at anytime, though it is recommended that you do so at least a few hours before the call to avoid last minute complications. You may download the client from:
http://hawkeye.epa.gov/imtapp/console/cns_download.jsp?file=cnsconf&lang=en_US
3) You can log in from ANY computer with internet access using MS Internet Explorer 5.5 or higher and a recommended screen resolution of 1024×768 or higher. You do NOT need to be at work or have access to the EPA intranet to watch the event. If you see a security pop-up box asking if you wish to proceed, click yes.
4) You may see a message indicating that the Oracle software should be installed. CLICK YES! This is not a harmful program and you should have the rights to install it. It is simply an add-on to allow for the web-conference tools to run properly. If you do not have rights to install the add-on, please contact your local IT support to request help.
5.) Your screen may flicker as the software is installed and the web conference is opened up. This is completely normal.
View your data in ArcGIS Application
May 12, 2011
Morning Presentation: 9:30 AM -11:30 AM and Afternoon Hands On Training (290 Broadway only): 1:00 PM – 3:30 PM
290 Broadway – Training Room 23rd Floor – please RSVP to bujalski.nicole@epa.gov
or See below for instructions on logging into webinar (9:30 AM – 11:30 AM only)
9:30 AM-11:30 AM EarthSoft Presentation using MEDD data in ArcGIS
This presentation will demonstrate how the data submitted to EPA Region 2 are being used in ArcGIS. It will include querying data in sites such as Higgins Disposal, Lawrence Aviation, Old Roosevelt.
1:00 PM-3:30 PM ArcGIS Hands-on with Region 2 data
This session will be a hands-on session with ArcGIS and the EPA Region 2 data. We will query data, post results on a map, contour the data, and produce labeled maps.
(See attached file: EPAR2_trainingFlyer.pdf)
Joining the webinar:
1.) Go to the following web address: http://portal.epa.gov/webconference
2.) On the right hand side type in the MORNING WEB CONFERENCE ID: 401397
3.) Enter your name
4.) Leave all other fields BLANK
5.) Click ‘Join Conference’
6.) If prompted agree to installation
7.) There will be no call in number, audio will be streamed through your PC
Additional Information:
1) If this is your first web conference with EPA, run the new user test online at http://hawkeye.epa.gov/imtapp/app/nuf_sys.uix . If you fail any portion of the test, click on the details link to find tips to resolve your problem. If you cannot resolve an issue, contact epacallcenter@epa.gov for further support.
2) Please install the Oracle Web Conference client before joining the event. You may install it at anytime, though it is recommended that you do so at least a few hours before the call to avoid last minute complications. You may download the client from:
http://hawkeye.epa.gov/imtapp/console/cns_download.jsp?file=cnsconf&lang=en_US
3) You can log in from ANY computer with internet access using MS Internet Explorer 5.5 or higher and a recommended screen resolution of 1024×768 or higher. You do NOT need to be at work or have access to the EPA intranet to watch the event. If you see a security pop-up box asking if you wish to proceed, click yes.
4) You may see a message indicating that the Oracle software should be installed. CLICK YES! This is not a harmful program and you should have the rights to install it. It is simply an add-on to allow for the web-conference tools to run properly. If you do not have rights to install the add-on, please contact your local IT support to request help.
5.) Your screen may flicker as the software is installed and the web conference is opened up. This is completely normal.
You can view the agenda below or download it here.
Environmental Data Management Conference Agenda for June 9-10
April 5, 2011
The Second Annual Environmental Data Management Conference provides environmental data management professionals with a two-day opportunity to share ideas; tools and custom applications; brainstorm and collaborate on data workflow; and present data management success stories. The conference is limited to 30 registrants. There is a non-refundable registration fee of $95 per person for both days, which includes snacks and lunch and participant certificate.
The schedule of planned presenters (shown below) is still growing. We want the conference to represent a broad cross-section of data management professionals so please contact Dan Higgins or Jennifer Rea begin_of_the_skype_highlighting end_of_the_skype_highlighting if you have a suggestion for additional activities or presentations.
Dates: June 9-10, 2011
Location: McMenamins Edgefield, 2126 SW Halsey, Troutdale, Oregon 97060
A block of hotel rooms are set aside for conference attendees who want to spend the night. There are no special rates for attendees. The rooms will be held until 5/9/2011.
Registration Info: Use the attached form to register with a credit card or call Dan Higgins or Jennifer Rea at the numbers below to register by phone.
Please call Dan Higgins at (503) 789-4758 begin_of_the_skype_highlighting (503) 789-4758 end_of_the_skype_highlighting or Jennifer Rea of EarthSoft at (541) 686-3276 with questions.
The agenda for the Environmental Data Management Conference on June 9-10 is following:
Day 1 – June 9, 2011
| 9:00 am | Reception & Continental Breakfast | |
| 9:20 am | Welcome and Greeting | (Dan Higgins, Jennifer Rea: EarthSoft) |
| 9:30 am | Case Study: Establishing a “Storm Water Data Clearinghouse” for the City of Tacoma | GeoEngineers imported over 10 years of storm water data into EQuIS, then established a storm water data clearinghouse that collects storm water and climate data logger data as well as extracts, transforms, and loads (ETL) data from the city’s LIMS directly to EQuIS.
(Rob Smith: GeoEngineers) |
| 10:30 am | Data Management Evangelizing | How can we help project managers understand the importance of data management?
(Patrick Gibbons: SAIC) |
| 11:00 am | EQuIS and WQX | A review of how EQuIS works with EPA’s WQX, or Water Quality Exchange (formerly STORET) data. (EarthSoft) |
| 11:30 am | EQuIS SPM and EDGE | Implementation of EQuIS Sample Planning Module (SPM) and Earthsoft Data Gathering Engine (EDGE) at AREVA Canada’s Uranium Mines.
(Mike Urtheil, AquaResources) |
| 12:00 am | LUNCH | Provided by AMEC and EarthSoft |
| 1:30 pm | EQuIS Custom Reports Tutorial | Hands-on introduction to EQuIS custom reports. Requires a laptop with SQL Server Management Studio, EQuIS Professional, and the Springfield Tutorial Database (provided). (Dan Higgins) |
| 3:00 pm | Custom Batch Reporting | Example standard table outputs for multiple sites of varying sizes and matrices.
(Gordon Wilcox: Worley-Parsons) |
| 3:30 pm | EQuIS to Excel report templates | A hands-on demonstration showing how create Excel report templates used to format EQuIS Professional cross-tab reports. Requires Excel, EQuIS Professional and an EQuIS database on your laptop. (Bob Cowell: Earthsoft) |
| 4:30 pm | END OF DAY 1 | |
Day 2 – June 10, 2011
| 9:00 am | Reception & Continental Breakfast | |
| 9:20 am | An Environmental Toolbox: EQuIS with
ArcGIS and MVS/EVS |
Frank Hagar presents a case study and methodology for integrating EQuIS with 3-D visualization and mapping tools. |
| 10:20 am | Streamlining the Union Between Maps and Data | AMEC-Portland’s data management team developed a robust near real-time analytical data loading and map visualization process to guide excavation of 300+ acres of pesticide-impacted soil. During a period of 10 months, AMEC loaded and plotted the analytical results for 2318 soil samples resulting in the successful removal of over 600,000 tons of contaminated soil.
(Danille Jorgenson: AMEC) |
| 11:20 am | EZ View (Functions/Reports) | EarthSoft will highlight the latest reports and features included in Enterprise EZView
(EarthSoft) |
| 12:00 am | LUNCH | Provided by AMEC and EarthSoft |
| 1:30 pm | EQuIS and ArcGIS Server | Demonstration and discussion of an EQuIS for ArcGIS Server application.
(EarthSoft) |
| 2:30 pm | EQuIS Enterprise Customization for casual users (Enterprise Lite) | Presentation of a simplified EQuIS Enterprise interface and custom reports enabling casual users, including the project team and clients, to query and report data with minimal training.
(Dan Higgins) |
| 3:00 pm | Historical data migration discussion | Presentation & Discussion Moderated by EarthSoft |
| 4:25 pm | Closing Remarks | Pass out Participation Certificates |
| 4:30 pm | SESSION END | |
Download a copy of the agenda and the registration form here.
EQuIS Rocky Mountain User Group Conference – April 29, 2011
March 18, 2011
Join us for the EQuIS Rocky Mountain User Group Conference sponsored by EarthSoft and the Colorado Department of Public Health and Environment on April 29th, 2011. Space is limited.
The first Rocky Mountain US Regional EQuIS User Group meeting will be held on Friday April 29, 2011, 9:00 AM – 4:00 PM.
Registration is free, but required, and space is limited. To register, please complete the following Webinar Registration here (this webinar is used for registration purposes only).
After registering you will receive a confirmation email containing information about joining the Webinar.
The meeting will be held at the Colorado Department of Public Health and Environment building:
4300 Cherry Creek Drive, Denver, Colorado 80206
Breakfast and lunch will be provided.
Lodging information will be forwarded to you upon registration
The meeting will highlight CDPHE’s EQuIS implementation, which features the WQX module. Participants will also get a sneak preview of what’s next in EQuIS and have the opportunity to share ideas, tools, and custom applications, as well as data management success stories and challenges.
Title: EQuIS Rocky Mountain User Group Conference – April 29, 2011
Date: Friday, April 29, 2011
Time: 9:00 AM – 4:00 PM MDT
The EQuIS Rocky Mountain User Group Conference agenda is available here.
View the conference parking and check-in map here.
Environmental Data Management Conference (June 9-10)
March 10, 2011
Environmental Data Management Conference provides environmental data management professionals with a two-day opportunity to share ideas; tools and custom applications; brainstorm and collaborate on data workflow; and present data management success stories. The conference is limited to 30 registrants. There is a non-refundable registration fee of $95 per person for both days, which includes snacks and lunch and a participant certificate.
The schedule of planned presenters is still growing. Please contact Dan Higgins or Jennifer Rea if you have a suggestion for additional activities or presentations. We want the conference to represent a broad cross-section of data management professionals and will gladly substitute one of AMEC’s presentations for yours.
Dates: June 9-10, 2011
Location: McMenamins Edgefield, 2126 SW Halsey, Troutdale, Oregon 97060
A block of hotel rooms are set aside for conference attendees who want to spend the night. There are no special rates for attendees.
Registration Info: Use the attached form to register with a credit card or call Dan Higgins or Jennifer Rea at the numbers below to register by phone.
Please call Dan Higgins at (503) 789-4758 (503) 789-4758 or Jennifer Rea of EarthSoft at (541) 686-3276 with questions.
Read more or click the following link to download the pdf registration form.Environmental Data Management Conference (pdf)
EarthSoft Atlanta EQuIS Training February 15-18, 2011
December 21, 2010
EarthSoft is hosting an EQuIS Training in Atlanta February 15-18, 2011. Read more below or download the pdf using the following link.
2011 Advanced User Workshop
December 17, 2010
The March 2011 EQuIS Advanced User Workshop in Helena, Montana is approaching. Read more below or download the pdf to register.
Upcoming Office Hours – EDGE COC/Field Templates and Action Levels – September 16, 2010
September 9, 2010
EDGE is a comprehensive collection of integrated environmental field tools ensuring accurate and complete data collection, using modern software and mobile computing technologies.
In this office hours, EarthSoft’s EDGE Product Manager will demonstrate how to create Field EDD and COC templates, and will pull the wraps off the new version of EDGE, which will deliver better performance, and improved user experience.
This session will be held at 11am EDT (-5 GMT) and 6pm EDT (-5 GMT) on September 16th.
To sign up for a session, please send us an email at officehours@earthsoft.com or register on the Office Hours page and indicate your session of preference. Note that spots will be filled on a first-come, first-served basis.
Northeast Regional EQuIS User Group Meeting – See the Agenda!
August 11, 2010
You are invited to join EarthSoft, NYSDEC, and Walden Associates for the first Northeast US Regional EQuIS User Group Meeting. The meeting will highlight NYSDEC’s EQuIS implementation, which features the WQX and Vapor Intrusion modules. Participants will also get a sneak preview of what’s next in EQuIS and have the opportunity to share ideas, tools, and custom applications, as well as data management success stories and challenges.
Click here to see the User Group Meeting agenda.
Location and Time
New York State Department of Environmental Conservation
Training Room 629
625 Broadway, Albany, New York
Friday, August 20, 2010
9 AM – 4 PM
Registration is required and space is limited.
Registration is Free – Register now to reserve a spot!
Snacks and lunch will be provided.
For EQuIS power users, note that the Northeast US Regional EQuIS User Group Meeting follows another opportunity: the EQuIS 5 Advanced User Workshop, August 17 – 19 at the Hotel Indigo, Albany – Latham.
