WQX User Call June 23, 2022

WQX User Call
June 23, 2022

There were approximately 28 participants on the call.

Agenda:

1. WQX Project Status Report (10 mins)

• WQX/WQXWeb performance/updates

• New WQX training videos

• WQX Tip of the month

• WQX questions/comments

2. WQP Status Report (10 mins)

• WQP General Status Report

• WQP download profiles status

• WQP questions/comments

3. Open Discussion

• Other topics/questions

Notes:

1) Welcome and review agenda (Adam G)

2) Water Quality Exchange (WQX) Project Report (Adam G and Kevin C)

i. The Helpdesk support has been operating at normal status. Contact Us: weekday hours of 8am to
6pm EST. Email Cwqx@epa.qov') Call 800-424-9067

ii. Following an Operating System patch EPA's www3 Archive web server was experiencing
intermittent issue publish files for public access. This Data exchange with the Water Quality
Portal Team has been interrupted beginning on May 27.

a. The issue was identified as intermittent. Our IT center is working to resolve.

b. This issue currently requires manual stewardship to an automated process.\

c. A new ETL has been picked up today and should publish within 48 hours.

iii. There is one upcoming event: WQX has a planned WQX Web Azure Cloud migration event on
June 30, 2022. During this event, the WQX Web application will be deployed to a New cloud
application server. SOME user impact expected: User may experience some impact as a
reduction in processing performance compared to the current "on-premise" server
environment. Application will inherit new network latency transferring data from Cloud
application server to the database server (separate location).

iv. On June 16, 2022, WQX migrated the PRODUCTION node's XML parse and load software to a
new server. There was a temporary service disruption for the previous node software
successfully migrated and deployed in the Node TEST environment on May 18, 2022.

v. New WQX Training Videos

Intro to WQX: https://youtu.be/p5HQ aCIHOU

Getting access to WQX: https://voutu.be/hNFHpdengWQ

Searching for data in the WQP: https://voutu.be/cwLgPMuOuel

WQX User Call Notes - June 23, 2022

-------
Preparing your data for submission: https://youtu.be/elsHENWIU5w

vi. WQX Tip of the Month (Detection limits and Non-detects)

For any result where you did not collect an actual measured value, the Result Value field should be left
blank. The appropriate Result Detection Condition should instead be selected from the domain list and
one (or more) Result Detection Limit Types should be provided instead. As seen below, Result Detection
Limit Types may be supplied whether or not a value was recorded, however at least one is required if a
Result Detection Condition is provided.

Result
Detection
Condition

Result
Value

Result
Unit

Result
Measure
Qualifier

Result
Sample
Fraction

Result
Analytical
Method ID

Result
Analytical
Method
Context

Analysis
Start
Date

Result
Detection/
Quantitation
Limit Tvoe

Result
Detection/
Quantitation
Limit
Measure

Result
Detection/
Quantitation
Limit Unit

Not
Detected



mg/L

U



300

USEPA

2021-08-
12

Method
Detection Level

0.1260

mg/L

Not
Detected



ug/L

U



200.7/3010

USEPA

2021-08-
12

Method
Detection Level

1.1900

ug/L

Not
Detected



mg/L

u

Filtered,
lab

365.1

USEPA

2021-08-
25

Method
Detection Level

0.0097

mg/L

Not
Detected



mg/L

u

Filtered,
lab

351.2

USEPA

2021-08-
28

Method
Detection Level

0.1840

mg/L

Not
Detected



mg/L

u



2540D

APHA

2021-08-
16

Method
Detection Level

1.0000

mg/L



22.7

mg/L





300

USEPA

2021-08-
12

Method
Detection Level

0.1260

mg/L

Not
Detected



ug/L

u



200.7/3010

USEPA

2021-08-
12

Method
Detection Level

1.1900

ug/L



0.0886

mg/L



Filtered,
lab

365.1

USEPA

2021-08-
25

Method
Detection Level

0.0097

mg/L



37

mg/L





310.2

USEPA

2021-08-
14

Method
Detection Level

2.4900

mg/L

Result Detection Conditions can also be automatically generated from "< 0.02" style data inside
WQXWeb Import Configurations, under Options.

WQX User Call Notes - June 23, 2022

2

-------
"^1 Options

Expert Mode (for Configuration)

Enable advanced features for those that have read the user guide and are very comfortable
with import configurations. Supports header rows and columns. Provides better support for
crosstab formats, such as a file with multiple results per row.

Expert Mode (for Translations)

Allows more complex comparison options and expressions on the translations page

Generate an Activity ID

An Activity ID will be generated from the values provided for Monitoring Location ID.
Activity Date, Activity Time, Activity Type. Activity Depth, and Activity Sample Collection
Equipment This is onfy guaranteed to produce a unique Activity ID if you provide a unique
Activity Time for each Activity at a particufar Monitoring Location

Generate Detection Condition and Limits from
Result VaSue

Convert Result Values that start with "<" or ">" into an appropriate Detection Condition and
Detection Limit Value, For example: a Result Value of "<0.25" would be converted into a
Detection Condition of 'Present Below Quantification Limit", a Detection Limit Value of
"0.25", and a Detection Limit Type of "Lower Quantitation Limit"

Populate Detection Limit Unit from Result Unit

If the value for Detection/Quantrtation Limit Unit is blank, and it is required, use the ResuH:
Unit

I OK || Cancel 1

2) Water Quality Portal Update (Candace)

i. The WQP is currently processing its most recent ETL picked up from WQX and should have
updated data available in the WQP sometime later this afternoon (June 23,2022). The Portal
typically (currently) takes about 46 hours to complete the parse and load of the WQX ETL

ii. Current development activities - WQP Developers are currently working on implementing the
WQX schema 3.0 upgrades in their database and being able to serve those additional fields. The
first effort is delivering the full Physical/Chemical Profile, which is one of the larger and more
complex profiles. We have a first version of this profile available in DEV/STAGING and are
starting to test the profile. Soon, we will deploy this to Production and announce to users to test
the new profile, if they are interested.

3) Open Discussion/Questions

Question from Arne (CO): Will the Portal ETLS move back to a regular schedule?

Yes, ETLsfrom WQX are currently retrieved 2x a week on Wednesday and Saturday starting
around 8:30 AM Central. Once started, the ETL takes about ~36 hours to complete.

Question from Mary B.: Regarding the WQXWeb server move. Will this affect the WQX Web
Services as well?

Kevin: Yes. When we move to the cloud, services should move back to cdx.cloud.gov address.
We will notify the user community to update addresses.

The next meeting will be held on July 28, 2022.

4) Adjournment

The meeting was adjourned at 12:23 PM.

WQX User Call Notes - June 23, 2022

-------