B08_Appendix_B_-__EDD_Example.xlsx
XLSX spreadsheet 28 KB Posted
- Attached to
- GENERAL CHEMICAL ANALYTICAL SERVICES Federal contract opportunity
- Solicitation number
- 140G0224R0001
About this file
This document contains an example electronic data deliverable (EDD) template for submitting water quality sample and analytical results data to the United States Geological Survey (USGS). The template provides column explanations and codes for Sample ID, station ID, date/time, medium, project code, analyte results, analytical methods, and other data fields. It appears to be an appendix to a federal contract or cooperative agreement, but does not specify any required products or services.
A related federal contract opportunity is also provided. Solicitation number 140G0224R0001 seeks chemical and geotechnical analytical services. The opportunity was issued by the Department of the Interior USGS Office of Acquisitions and Grants for an unspecified contract value and period of performance. No further details are given on response dates, pricing terms, set-asides, incumbent contractors, or agencies involved beyond the USGS.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Sol_140G0224R0001.pdf | ||
| B08_Appendix_A_-_Pricing_Schedule.xlsx | XLSX spreadsheet | |
| B08_Appendix_C_Daily_Sample_Receipt_-_Example.xlsx | XLSX spreadsheet | |
| B08_Appendix_D_-_Methods_with_Reporting_Requirements.xlsx | XLSX spreadsheet | |
| B08_Appendix_E_-_ASR.pdf |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Example_qwsample
| Sample Integer | User Code | Agency Code | StationID | Begin Date and Time | End Date and Time | Medium Code | Lab ID number | Project Code | Aquifer code | Sample Type | Analysis Status | Analysis Source | Hydrologic Condition | Hydrologic event | Tissue Sample Identifier | Body Part Code | Lab Sample Comment | Field Sample Comment | Time-Zone code | Time-Datum reliability Code | Collecting agency code | Sample ID | Sample ID number |
| 1 | MA | USGS | 4117590714134901 | 202312110545 | 202312110548 | WS | 00LYYLB00 | H | U | A | J | ||||||||||||
| 2 | MA | USGS | 411759071134901 | 202312110549 | 202312110549 | WSQ | 00LYYLB00 | 7 | U | X | J | ||||||||||||
| 3 | MA | USGS | 411500017043801 | 202312112257 | 202312112257 | WS | 00LYYLB00 | H | U | A | J | ||||||||||||
| 4 | MA | USGS | 411642017025801 | 20212110903 | 202312110903 | WS | 00LYYLB00 | H | U | A | J |
| NOTE: The top line on this file is just for an explaination of the column info. Do not insert column headers in actual file. | ||
| Sample Integer | matches the smp.txt sample info with the res.txt individual results - (Usually reference sample #1, 2, 3, etc.). [EX: Sample Integer 1 on qwsample references results in Sample Integer 1 in qwresult EDDs.] | |
| User Code | from the ASR User Code box | |
| Agency Code | Default = USGS; There have been some instances where it is "USEPA" for EPA owned wells. - (Usually not on Contract Lab ASRs; If customer adds this field to ASR, enter the Agency Code they have entered.) | |
| StaID | From the ASR Station ID box - (make sure leading zeroes are not dropped) | |
| Begin Date and Time | From ASR | |
| End Date and Time | From ASR if missing leave blank | |
| Medium Code | From ASR | |
| Lab ID number | Your lab identifier, Char (7) - Remove, not approved as part of Contract Lab ASRs. Per NWQL IT, do not use this field because it is overwritten by the last upload. Use Sample_id and Sidno_party_cd fields for Lab IDs instead) | |
| Project Code | From ASR - Project Account box - Last 9-digits of Project Account Number; Do not drop leading zeroes. | |
| Aquifer code | From ASR if missing leave blank - (not on Contract Lab ASRs) | |
| Sample Type | from the ASR Sample Type box | |
| Analysis Status | Default is "U" = Environmental. Can also be "I" = Internal Use Only, or "P" = Propieatary; per the ASR. | |
| Analysis Source | From ASR. If missing leave blank | |
| Hydrologic Condition | From ASR. If missing, enter default "X" | |
| Hydrologic event | From ASR. If missing, enter default "X" | |
| tissue Sample Identifier | Not currently on contract lab ASRs; if missing leave blank | (Required for ALL Tissue samples with ASR Medium Codes: BA, BAQ, BP, BPQ, WP, or WPQ) |
| Body Part Code | Not currently on contract lab ASRs; if missing leave blank | (Required for ALL Tissue samples with ASR Medium Codes: BA, BAQ, BP, BPQ, WP, or WPQ) |
| Lab Sample Comment | Any comment from RTI - Leave blank; any RTI comments are in the Lab Comments section of the qwresult EDD. | |
| Field Sample Comment | Leave Blank - (not on Contract Lab ASRs) | |
| Time-Zone code | Leave Blank - (not on Contract Lab ASRs) | |
| Time-Datum reliability Code | REMOVE, not on or part of Contract Lab ASRs. Column Name = Tm_datum_rlblty_cd; NWIS format = Char (1): (Per NWQL IT, ok to use this field, BUT DON't; set to default "K"). | |
| Collecting agency code | Leave Blank - (not on Contract Lab ASRs) | |
| Sample ID | REMOVE, not approved as part of Contract Lab ASRs. Column Name = Sample_id; NWIS format = Bigint: Per NWQL IT, this field is better to be used for Lab Sample ID (Bigint): ex: 2112289). | |
| Sample ID Number | REMOVE, not approved as part of Contract Lab ASRs. Column Name = Sidno_party_cd; NWIS format = (Char 3): Per NWQL IT this field is better to be used for Lab Sample ID number (ex: 001). |
Example_qwresult
| Sample Integer | Parameter Code | result Value | Remark Code | QA Code | Method Code | Rounding Code | Value Qualifiers | Report level | Report Level Type | Data Quality Indicator | Null-Value Qualifier | Prep Set number | Analytical Set Number | Analysis Date | Prep Date | Lab result Comment | Field Result Comment | Lab Standard Deviation | Analyzing entity code |
| 1 | 53962 | 1.85 | LM111 | cn | 1.85 | LRL | S | HXX3157 | XLC2061 | 20210209 | 20210209 |
| NOTE: The top line on this file is just for an explaination of the column info. Do not insert column headers in actual file. | |
| EXPLANATIONS | |
| Sample Integer | matches the smp.txt sample info with the res.txt individual results - (Usually reference sample #1, 2, 3, etc.). [EX: Sample Integer 1 on qwsample references results in Sample Integer 1 in qwresults.] |
| parameter Code | 5 digit code similar to STORET code; see parameter code library in USGS NWIS |
| result Value | Sample result from Analytical Report. |
| Remark Code | See Result-level codes for USGS NWQL (non-rad) file for translation from analytical report results. |
| QA Code | Leave Blank |
| Method Code | 5 character code to describe analytical method; see method code library or contact the NWQL Contract Lab Serivces (QAS). Must upload pcode with mcode pair. Need COR approval to upload a pcode without an mcode! |
| Rounding Code | Leave Blank |
| Value Qualifiers | up to 3 qualifiers allowed (ex: cnd); additional qualifiers are added to the Lab Result Comment in column Q; (Must have a "c" value qualifier at the very least.); See Value-Qualifier Codes section of Result-level codes for USGS NWQL (non-rad) file for translation from analytical report results. |
| Report level | From Analytical Report |
| Report Level Type | From Analytical Report |
| Data Quality Indicator | S = immediate release to NWIS; I = WSC needs to check then release |
| Null-Value Qualifier | Leave Blank |
| Prep Set number | From Analytical Report |
| Analytical Set Number | From Analytical Report |
| Analysis Date | From Analytical Report |
| Prep Date | From Analytical Report |
| Lab result Comment | Must contain clause regarding additional qualifier codes "Added qualifier codes: none.", and will contain Contract Lab and Sub-Contract Lab sample ID numbers, and other sample site information. |
| Field Result Comment | Leave Blank |
| Lab Standard Deviation | Leave Blank |
| Analyzing entity code | Analyzing Laboratory Code |
| Value | |
| Codes used in USGS National Water Information Systems can be found at https://nwis.usgs.gov/nwisdocs5_2/qw/QW-AppxA.pdf |
File details come from the government source that posted it. Updated .