4.4-Tetra Tech Clarification Request - BPM003500_080221.pdf
PDF 466 KB Posted
- Attached to
- Master Agreement AZ|CTR056544
- Contract number
- CTR056544
- 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), addressing a clarification request for Solicitation Number BPM003500 for "Water Quality Sampling and Monitoring". The letter is in response to a specific inquiry about Tetra Tech's capabilities in directly loading water quality data to EPA's Water Quality Exchange (WQX).
Tetra Tech demonstrates its technical proficiency by confirming it has an existing WQX account and the ability to directly load water quality data to the EPA Water Quality Data Portal. The company explains its expertise in managing complex data submissions, which requires comprehensive metadata matching specific "Domain Values" and understanding relational database structures. They showcase their experience by providing screenshots of successful data uploads, including templates for Projects, Monitoring Locations, Results, and Activities. Tetra Tech indicates they have worked with various data types, including water chemistry and biological sampling data (such as benthic macroinvertebrates and fish), and can resolve data issues during the submission process. The level of effort for data loading varies depending on the completeness and validity of the submitted data.
View the file
Other files
Show all 41
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 .