4.4-Tetra Tech Clarification Request - BPM003500_080221.pdf
PDF 466 KB Posted
- Attached to
- Master Agreement AZ|CTR056545
- Contract number
- CTR056545
- Issued by
- Arizona
About this file
This document is a clarification letter dated August 2, 2021, from Tetra Tech, Inc. to Mrs. Patricia Lorenzen, Senior Procurement Specialist at the Arizona Department of Environmental Quality (ADEQ), regarding Solicitation Number BPM003500 for "Water Quality Sampling and Monitoring". The letter responds to a specific inquiry about Tetra Tech's capabilities in water quality data management and reporting.
Tetra Tech demonstrates its ability to directly load water quality data to EPA's Water Quality Exchange (WQX), bypassing ADEQ's Water Quality Database. The company has an existing WQX account and expertise in uploading data to the Water Quality Portal, with experience handling complex metadata requirements, domain values, and data validation. They can work with various types of water data, including water chemistry and biological sampling data (such as benthic macroinvertebrates and fish), and have proven capability in resolving data issues during the upload process. The letter includes screenshots showing successful data submissions and retrieval methods, highlighting Tetra Tech's technical proficiency in environmental data management.
View the file
Other files
Show all 37
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Tetra Tech, Inc.
3822 East University Drive, Suite 3, Phoenix, AZ 85034
Tel 602.603.7360 tetratech.com
August 2, 2021
Mrs. Patricia Lorenzen Senior Procurement Specialist Arizona Department of Environmental Quality 1110 West Washington Street Phoenix, Arizona 85007
Via email:
Subject: Clarification Request - Solicitation Number: BPM003500 “Water Quality Sampling and Monitoring”
Dear Mrs. Lorenzen:
Tetra Tech, Inc. is submitting this letter at the request of the Arizona Department of Environmental Quality in response to the following clarification request:
Item # 1: Does your company have the ability to directly load water quality data to EPA's Water Quality Exchange (rather than through ADEQ's Water Quality Database)? Can you provide an example of data you loaded to the water quality exchange that is available on the water quality portal at www.waterqualitydata.us.
Tetra Tech, Inc. currently has a Water Quality Exchange (WQX) account and has directly loaded data to EPA’s WQX that is available through the Water Quality Data Portal. This task requires general knowledge of the data being uploaded and what metadata is required, known as “Domain Values” (figure 1). The domain values provided must match (validate) and be availble in WQX or that particula record will not load. We have experience resolving these issues. We are experienced with devloping relational databases therefore we have a good understanding of how WQX and CDX works.
Tel 602.603.7360 tetratech.com
Figure 1 Valid Values that submitted data must include.
Import configuration templates are also created for Projects, Monitoring locations, Results and Activities (Figure 2).
Figure 2 User create templates to aid in uploading data.
Tel 602.603.7360 tetratech.com
Below is a screen shot of successfully loading data to CDX (Figure 3). Data are first loaded to a staging database where the user can resolve data issues. Once all the data issues are resolved data are loaded to CDX and will become publicly available.
Figure 3 Screen shot of data successful submitted to CDX that can be downloaded from the portal.
Data loaded by Tetra Tech can be retrieved from the Water Quality Portal by entering “TETRATECH” in the Organization ID field (Figure 4 -5). This is data loaded for EPA Region IV.
Tel 602.603.7360 tetratech.com
Figure 4 User message from the water quality portal saying data available for download.
Figure 5 Query builder form Water Quality Portal for selecting downloading data.
Tel 602.603.7360 tetratech.com
Level of effort for loading data can vary and is determined by the completeness of the data.
Data submission requires all fields with meta-data be complete with valid domain values (dependent on the type of data). Examples would include analytical methods and data qualifiers. We have experience with both water chemistry data and biological sampling data (e.g., benthic macroinvertebrates and fish).
If you have any questions, please feel free to contact us at your convenience.
Sincerely, Tetra Tech, Inc.
Mekaela M. Bennett Program Manager
MEKAELA.BENNETT
Stamp
File details come from the government source that posted it. Updated .