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 ------- |