Boomsnub-Airco (BOC Gases) Site, Vancouver, WA - Groundwater Sampling Data
Revision History
Revisions made 02/25/05: attached zip file received by EPA Region 10 on 2/21/05; contains full Access database as submitted by BOC Gases.
Revisions made 03/03/04: attached a zip file submitted 2/4/04 containing Access database as submitted by BOC Gases. It contain results data for Well AMW-8A.
Revisions made during week ending 10/15/99:- Replaced Area-Wide Site Map with new updated map file (PDF format).
Added new coordinate information to well information files for four wells (MW-11A, MW-11B, GWSW1, GWSW2).
Revisions made during week ending 10/08/99:- Added updated monitoring well location and description information.
Revisions made during week ending 09/24/99:- Added all groundwater monitoring data collected through and including Spring 1999 sampling.
- Replaced 14+MB plain text version of comprehensive sampling data file with zipped (compressed) version (must be downloaded and unzipped for viewing.)
Revisions made during week ending 04/09/99:- Revised monitoring well information files.
- Revised area-wide site map with monitoring well locations - added locations for four monitoring wells (MW-4bShed, AMW-27, MW-36,MW-37).
- Removed ARC/INFO Export file version of monitoring well file, due to absence of demand.
Revisions made during week ending 03/19/99:- Added all groundwater monitoring data collected through end of calendar year 1998.
Revisions made during week ending 10/23/98:- Corrected spelling of parameter name Methacrylonitrile (301 values).
Revisions made during week ending 8/21/98:- Added all groundwater monitoring data for 1998 to date.
Revisions made during week ending 3/13/98:- Added data for 1997 and for 1987-1995 sampling.
Updated database to reflect re-naming of well MW-4Bd to MW-4BShed and well MW-4Bs to MW-4B.
Area-wide Site Map with Monitoring Well Locations (Adobe Acrobat PDF format, size 32X20 inches, 166KB file size)
Data Available
Table 1, below, contains a description of data types available for the Boomsnub site, and also contains direct links to the data files described. Comprehensive groundwater data is available in two different formats - plain text, compressed (Option 1), or a standard Xbase format (.DBF) data file, also compressed (Option 2). The text file format data must be downloaded and uncompressed on the user's computer before it can be viewed directly. Similarly, the DBF-format data file must be downloaded and uncompressed, and then can be manipulated with most data management software packages, for the purpose, for example, of performing statistical analyses or generating custom reports of subsets of data.
Files containing information on monitoring well construction and locations are also referenced in Table 1. Option 3 links to a viewable plain text format file with well names and location coordinates; Option 4 links to a more comprehensive DBF-format data file containing identification, location, and additional well construction information. This data file is downloadable and can be utilized with appropriate data management software. Table 1: Data Available
| Data Type | Option | Format | Data File | Size (bytes) |
| Comprehensive Groundwater Sample Analysis, 4/15/87-5/25/99 (76,340 values) |
1 | Plain text | boomtxt.zip | 863,774
| 2 | DBF (Xbase) format, PKZIPed** | boomsnub.zip | 655,588
| Monitoring Well Description and Location Data (254 wells or other sampled locations, 321 wells total) | 3 | Plain text | boomwell.txt | 55,843
| 4 | DBF (Xbase) format, PKZIPed*** | boomwell.zip | 33,274
| | | |
|---|
*File boomtxt.zip expands to boomsnub.txt, size 14,581,558 bytes.
**File boomsnub.zip expands to boomsnub.dbf, size 13,436,584 bytes.
***File boomwell.zip expands to boomwell.dbf, size 781,628 bytes.
The groundwater sampling data files, accessible via Table 1, Options 1 or 2 above, each contain data presented as a single analytical value or observation per record or row. They constitute a complete set of analytical chemistry and other sampling parameters associated with the Boomsnub Site, Vancouver, Washington, for the period from 4/15/87 through 5/25/99. The files represent samples collected from 254 different monitoring locations, on 194 different dates, for 266 separate analytes, and each file contains 76,340 records.
Table 2: Summary of groundwater sampling data
| Sample earliest date: | 04/15/87 |
| Sample latest date: | 5/25/99 |
| Number of dates: | 194 |
| Number of locations: | 254 |
| Number of parameters: | 266 |
| Number of observations: | 76,340 |
Description and Structure of File BOOMSNUB.DBF
Data available via Table 1, Option 2 (above) is structured as as follows:
Structure for table: boomsnub.dbf
Number of data records: 76,340
Date of last update: 09/20/99
File size uncompressed: 11,454,583 bytes
File created with: Visual Foxpro version 6.0
Table 3: File Structure of BOOMSNUB.DBF
Field | Field Name | Type | Width | Description |
1 | PRI_STA | Character | 15 | EPA Region 10 Primary Station Code* |
2 | STA_ID | Character | 13 | Sampling Station Identifier |
3 | DESCRIP | Character | 10 | Sample Description |
4 | DATE | Date | 8 | Sampling Date |
5 | TIME | Character | 4 | Sampling Time |
6 | SMK | Character | 4 | System Multipurpose Key (SMK) Code (see below)* |
7 | SAMP_NUM | Character | 25 | Sample Number |
8 | CAS_NUM | Numeric | 10 | Chemical Abstracts System Number |
9 | P_NUM | Numeric | 5 | EPA STORET Parameter Number* |
10 | ANALYTE | Character | 50 | Parameter analysed or observed |
11 | RESULT | Character | 10 | Analytical Result or Observation |
12 | QUAL | Character | 5 | Qualifier as reported (see below) |
13 | UNITS | Character | 8 | Units of Result |
15 | UMK | Character | 8 | Users Multipurpose Key (See below)* |
 | Total | | 176 | |
*An asterisk denotes values or codes assigned by EPA Region 10.
Data Qualifiers
Table 4 lists the various qualifiers with each analytical result and their definitions.
Table 4: Data Qualifiers
| Qualifier | Definition |
| Inorganic Analyses | |
B | Analyte is found in the analytical blank as well as the sample indicating possible/probable blank contamination. If analytes are found in any of the associated procedural blanks the concentration in the samples must be at least ten times the quantity observed in the blank. If the sample result fails these criteria the sample result is qualified (B). |
J | Sample result is an estimate. |
N | Spiked sample recovery not within control limits. |
P | The analyte was detected above the instrument Detection Limit, but not quantified within expected limits of precision. The laboratory has established minimum quantitation limits having a relative standard deviation of no more than 10% (Note: not used after September 1996). |
U | Element was analyzed but not detected. The associated numerical value is the instrument detection limit/method detection limit. |
| Organic Analyses | |
J | The analyte was positively identified. The associated numerical result is an estimate. |
NJ | There is evidence that the analyte is present. The associated numerical result is an estimate. |
U | The analyte was not detected at or above the reported result. |
UJ | The analyte was not detected at or above the reported estimated result. The associated numerical value is an estimate of the quantitation limit of the analyte in the sample. |
| All Analyses | |
E | The analyte detected exceeded the calibration range of the instrument. |
D | The sample was diluted. |
F | The result was acquired by field screening methods. |
System Mulipurpose Key (SMK) Codes - Check this link for a description of SMK codes.
Users Multipurpose Key (UMK) Code
The UMK is an optional code that can be added to the storage to denote more information about the analysis or sampling. For this particular data set, we have used the UMK to distinguish between two different analyses of the same sample for the same analyte, a situation which is not readily described by SMK or other types of coding. For this data set of 76,340 values, there are 126 pairs of results for the same analyte, one derived from a base-neutral extractible analysis and the other from a volatile organics analysis.