WQX User Call
August 25, 2022

There were approximately 30 participants on the call.

Agenda:

1.	WQX Project Status Report (10 mins)

•	WQX/WQXWeb performance/updates

•	WQX Tip of the month - Attaching files.

•	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. WQX Project Status Report (15 mins)

The Helpdesk support has been operating at normal status. Contact Us: Weekday hours of 8am
to 6pm EST. Email (wqx@epa.gov) Call 800-424-9067.

Recent WQX development has focused on planned Oracle 19c upgrades and developers have
successfully deployed to the Development area. We are ready and awaiting deployment to
Staging (September 9th , 2022) at the EPA National Computer Center (NCC). Over the next
month, develoeprs will be reconfiguring the WQX Web application to an Azure cloud
environment and associated Oracle 19c upgrade in September 2022. Our focus will then return
to development on WQXWeb performance tuning, slow XML generation, etc.

Retired Characteristics - WQX routinely retires Characteristics and Taxon names when they have
been deprecated by SME or Stewards of the index. Exs: Substance Registry Service for chemicals,
Integrated Taxonomic Information System (ITIS) for biological taxa.

The following Nutrient Characteristics have been recently retired (8/19/2022) in accordance
with the 2017 Guidance: Best Practices for Sharing Nutrient Data.

Characteristic

15609

Hydrolyzable phosphorus plus orthophosphate***retired***use Phosphorus,
hydrolyzable plus orthophosphate

Characteristic

1420

Nitrogen-15/14 ratio ***retired*** use Nitrogen-15/Nitrogen-14 ratio

Characteristic

3715

Nitrogen Delta 15 ***retired*** use Nitrogen-15/Nitrogen-14 ratio

Characteristic

3691

Dissolved Inorganic Nitrogen/Total Phosphorus ratio

Characteristic

2267

Dissolved inorganic nitrogen/soluble reactive phosphorus ratio

Characteristic

4702

Nitrogen/Phosphorus molar ratio

Characteristic

2962

Phosphate-phosphorus ***retired*** use Total Phosphorus, mixed forms

1

WQX User Call Notes - August 25, 2022


-------
Characteristic

1415

Inorganic nitrogen (nitrate and nitrite) ***retired***use Nitrate + Nitrite

Characteristic

4703

Inorganic nitrogen (ammonia, nitrate and nitrite)***retired***use Inorganic
nitrogen (N02, N03, & NH3)

Characteristic

15585

Inorganic nitrogen (nitrate and nitrite and ammonia)***retired***use Inorganic
nitrogen (N02, N03, & NH3)

Characteristic

15586

Inorganic nitrogen***retired***use Inorganic nitrogen (N02, N03, & NH3)

If you submit data with a retired Characteristic (Invalid Domain Value) you will receive an Error
upon Import and will not be able to submit the data.

Dataset Details

Return 1 Delete I Export & Submit to CDX

Dataset Information:

Type:	Results & Activities
Import Configuration: .

Organization ID:	WQXTEST
Status:

Import Completed (with errors)

Step 1 of 3 completed.

The dataset has been imported, but there are errors that need to be resolved (step
2). and then the dataset needs to be submitted to CDX (step 3). If you submit to CDX
before resolving all errors, then only the valid records will be included.

A dataset only becomes permanent after it has been submitted to CDX.

Import Event	

Start Time:	07-24-2022 07:42:58 PM

End Time:	07-24-2022 07:43:23 PM

File Name:	Physical Chemical Template - KGDEMO.xIsx

Event Log:	Visyy_g>l.yg.iAd.g.xlQp. arf"qs

Imported Records:

Entity

Total

Valid

New

Existing

Activity

18

10

17

1

Result

56

48

56

0

Message Type Total

Resolved

Event Log

Resolution

Domain Value Invalid 8

0

View Log

Resolve Online

Warning 1

1

View Log

Optional

Message 8

8

View Log

N/A

Documents:

Name



Import LOQ.xIsx



Phvsical Chemical TemDlate - KGDEMO.xIsx



• Tip - You may click on Resolve Online and this will immediately take you to a Domain Value
Resolution window that wili edit your Import Configuration. There you may search for the
correct Characteristic Name and create a translation for this value in your dataset, allowing you
to keep your original Characteristic Name, while submitting the WQX harmonized version.









• • I •••• 1 >





This a «list of values from ywj» import file thai do noi match a valW domain value. To coned a value, dick its lirrt and select a valid value from the Hit. Then

change the resolution for each row las needed) and save yoor changes





3 >" Characteristic Name Water TemrnHrttuig

Add a translation to auto ¦correct future dauteis

*

•tern I tot







1 Characteristic Name (contains): [
1 Search Cancel

1



You may also edit your existing Import Configurations directly and add a Translation for the retired
Characteristics Names.

2

WQX User Call Notes - August 25, 2022


-------
Translations

Return | Save j Cancel | Add New | Enable Expert ModeH







j



Characteristic Name (contains): Nitrate

	

Search Cancel



f,. Sample Analytical Method ,

Name ,, . SRS10 Fraction Method Speciation .. . Group Name .. , °™'"
Number „ . . „ . . „ . . List Value Status
Required Required Required

(none)

















3.34.4.5.5.66 6-Nonafiuorohexvl nitrate

34839-
44-6

1844206

N

N

N

N

PFAS, Perfluo rinated
Alkyl Substance

Accepted

Ammonium nitrate

6484-52-
2

143297

V

Y

Y

N

Nutrient

Accepted

Ethylene alvcol dinitrate

628-96-6

64527

N

N

N

N

Not Assigned

Accepted

Inoraanic nitroaen (ammonia, nitrate and
nitritel***retired***use inoraanic nitroaen
(N02. N03. & NH3)





Y

Y

»

N

Nutrient

Deprecated

Inoraanic nitroaen (nitrate and nitrite and





N

N

N

N

Not Assigned

Deprecated

When Column P : | Equals »| (no ganjc nitroqen 'nitrate 3rd niiite)

(N02. N03. & NH31

Then: | Use this element value... *|

Inoraanic nitroaen (nitrate and nitrite)
""retired"""use Nitrate + Nitrite



701177

Y

Y

Y

N

Nutrient

Deprecated



1 Molar ratio of nitrate (dIus nitritel and
orthophosphate





N

N

N

N

Not Assigned

Accepted



N N-Dibutvl-2-

94817-
82-0

1989815

N

N

N

N

PFAS, Perfluo rinated
Alkyl Substance

Accepted

1 Nitrate

14797-
55-8

197186

Y

Y

V

N

Nutrient

Accepted



II Nitrate + Nitrite





Y

Y

Y

N

Nutrient

Accepted

Nitrate-reducino bacteria





N

N

N

N

Not Assigned

Accepted

1 Pentaervthritol tetra nitrate

78-11-5

6882

N

N

N

N

Organics. Other

Accepted

1 Peroxvactvl nitrate

2278-22-
0



N

N

N

N

Not Assigned

Accepted

1 Potassium nitrate

7757-79-
1

153312

Y

N

N

N

Not Assigned

Accepted

1 Streotomvcin nitrate

3688-73-

17124298

Y

N

N

N

Not Assigned

Accepted



2. WQP Status Report (10 mins)

The WQP Development team is changing. WQP Staff will be training a new development team,
and as such, we will likely see some slowdown on development as the team comes up to speed.
Once up and running, they will be continuing to develop the new data export profiles.

The WQP Team is also working on setting priorities for the new fiscal year, and EPA and USGS
will be getting together in-person soon for a WQP strategy session.

DEMO - Adam demonstrated new monitoring location pages in How's My Waterway powered
by the WQP csv services. New monitoring location pages feature full results level data from an
individual monitoring location, complete with a time-series scatter chart, filters to control data
of different types, and summary information.

3.	Presentation (20 mins)

The Stanford RegLab presented their latest model developments to infer sources of observed
pollutant spikes. (20 min)

4.	Adjournment

The meeting was adjourned at 12:43 PM.

The next meeting will be September 22nd at 12:00 PM EST.

WQX User Call Notes - August 25, 2022

3


-------