Department of Water Resources Home
IEP Banner

Data File Format


Format File for USBR Continuous Monitoring (AFMT)

The following describes the file structure for continuous monitoring data files of U.S.
Bureau of Reclamation, Mid-Pacific Region, Environmental Affairs Division.

Data are collected at 22 sites.  Data collection started in 1950.  TDS (Total dissolved
residue) and EC (conductivity) are collected as daily minima, maxima, and averages. 
TDS was collected from 1950 through 1964; EC from 1964 through present.  Since
1994, both bottom and surface EC were collected at some sites.

There are five different formats for the file structures:
A. 1950-54: TDS with remark codes
B. 1955-63: TDS without remarks
C. 1964: TDS and EC
D. 1965-93: EC
E. 1994-present: EC surface and bottom

1.  List of individual file naming convention: 
BRCNTnnx, where nnx is the monitoring year (1950-94) with possible qualifier for
subyear files, up to four (a, b, c, d)
Total number of files: 115.

2. Date of creation of data files (last update):
Oct-31-95, Sep-26-96

3. Size of file(s):
see below for each file.

4. Maximum record length (maximum width of file),
Files 1950-54: 51
Files 1955-63: 47
Files 1964: 53
Files 1965-93: 47
Files 1994-pr: 56 

5. Structure of each file (format/legend/header) starting with the required five IEP fields
(see below):
a.) number of variables: 
     Files 1950-54: 8
     Files 1955-63: 7
     Files 1964: 8
     Files 1965-93: 7 
     Files 1994-pr: 8
b.) number of records:
     see below. 
c.) variable names, variable format, and maximum variable length:
RKI - River Kilometer Index, alphanumeric (8), 
Station ID - internal USBR number, alpahanumeric (4), 
Date - yyyymmdd (8),
Time - numeric (not recorded), 
Depth - numeric (in feet) (2), 
EC -  specific electric conductance, numeric (5), 
TDS - residue, total filtrable, numeric (5), 
Remark codes - alpha (1)
     J - estimated value; value is based on less than 24 hours database
     L - actual value is known to be greater than value given; calibration maximum
     M - presence
of material verified but not quantified
     @ - no remark code present (only 1950-54) 
Composite statistics indicator - alpha ('AVE, MAX, MIN') (3), 
Depth indicator - alpha (6)
     BOTTOM - bottom EC, 
     WATER - surface EC.

6. Reference to AREF tables:
AREFSTA - station table with ID, lat/longitude, county, HUC code, narrative description,
river reach file (RF3) code, etc.  This station reference file was generated in the U.S.
Environmental Protection Agency's STORET system, a database of sampling sites and
their associated water quality data.
AREFPAR - table with information on EC/TDS parameters (units).  This parameter
reference file was generated in the U.S. EPA STORET system.


File structure for files from 1950 through 1954:
 -------------------------------------------------------------------------------
Variables: 8, maximum record length: 51.
RKI,station ID,date,time,depth,TDS,remark code,composite statistics,
Example:
"ROLD14","D21",19500928," "," ",279,"J","AVE",
"ROLD14","D21",19500928," "," ",282,"@","MAX", 
...

 BRCNT50 - 2785 records    
 BRCNT51 - 4687 records 
 BRCNT52 - 6336 records 
 BRCNT53 - 6041 records 
 BRCNT54 - 6621 records

File structure for files from 1955 through 1963:
 -------------------------------------------------------------------------------
Variables: 7, maximum record length: 47.
RKI,station ID,date,time,depth,TDS,composite statistics,
Example:
"ROLD14","D21",19551028," "," ",379,"AVE",
"ROLD14","D21",19551028," "," ",482,"MAX",
...

 BRCNT55A - 3999 records    
 BRCNT55B - 4030 records    
 BRCNT56 - 7552 records 
 BRCNT57A - 4252 records 
 BRCNT57B - 4467 records 
 BRCNT58A - 5288 records 
 BRCNT58B - 4171 records 
 BRCNT59A - 6621 records 
 BRCNT59B - 5654 records 
 BRCNT60A - 5126 records  
 BRCNT60B - 4859 records
 BRCNT61A - 5680 records 
 BRCNT61B - 6465 records 
 BRCNT62A - 6424 records 
 BRCNT62A - 5621 records 
 BRCNT63A - 5929 records 
 BRCNT63B - 5437 records 
 
File structure for files for 1964:
 -------------------------------------------------------------------------------
Variables: 8, maximum record length: 53.
RKI,station ID,date,time,depth,EC,TDS,composite statistics,
Example:
"ROLD14","D21",19641028," "," "," ",379,"AVE",
"ROLD14","D21",19641028," "," "," ",482,"MAX",
...
 RCNT64A - 5654 records  
 BRCNT64B - 5249 records 

File structure for files from 1965 through 1993:
 -------------------------------------------------------------------------------
Variables: 7, maximum record length: 47.
RKI, station ID, date,time,depth,EC,composite statistics,
Example:
"CHCCC06","C5",19650101," "," ",317,"AVE",
"CHCCC06","C5",19650101," "," ",324,"MAX",
"CHCCC06","C5",19650101," "," ",309,"MIN",    
...

 
 BRCNT65A - 4901 records
 BRCNT65B - 5153 records
 BRCNT65C - 360 records
 BRCNT66A - 6263 records
 BRCNT66B - 5984 records
 BRCNT66C - 457 records
 BRCNT67A - 5254 records
 BRCNT67B - 7445 records
 BRCNT67C - 4305 records
 BRCNT67D - 582 records 
 BRCNT68A - 7474 records
 BRCNT68B - 5453 records
 BRCNT68C - 5862 records
 BRCNT68D - 1092 records
 BRCNT69A - 5283 records
 BRCNT69B - 5340 records
 BRCNT69C - 5391 records
 BRCNT69D - 4313 records
 BRCNT69E - 1440 records

BRCNT70A - 7539 records  
BRCNT70B - 5370 records
BRCNT70C - 6479 records
BRCNT70D - 2175 records
BRCNT71A - 7530 records  
BRCNT71B - 5415 records  
BRCNT71C - 6400 records  
BRCNT71D - 2115 records
BRCNT72A - 7378 records  
BRCNT72B - 5342 records  
BRCNT72C - 7084 records  
BRCNT72D - 2188 records
BRCNT73A - 7093 records  
BRCNT73B - 5909 records  
BRCNT73C - 5907 records 
BRCNT73D - 1970 records 
BRCNT74A - 7682 records  
BRCNT74B - 4959 records
BRCNT74C - 5859 records  
BRCNT74D - 2028 records  
BRCNT75A - 7132 records  
BRCNT75B - 5274 records  
BRCNT75C - 7321 records 
BRCNT75D - 2096 records   
BRCNT76A - 7152 records  
BRCNT76B - 5223 records  
BRCNT76C - 7052 records
BRCNT76D - 2113 records    
BRCNT77A - 7442 records  
BRCNT77B - 5361 records  
BRCNT77C - 7426 records
BRCNT77D - 1877 records    
BRCNT78A - 6993 records  
BRCNT78B - 5583 records  
BRCNT78C - 6104 records
BRCNT78D - 1209 records    
BRCNT79A - 7010 records  
BRCNT79B - 4881 records  
BRCNT79C - 7357 records  
BRCNT79D - 1890 records  

BRCNT80A - 7361 records  
BRCNT80B - 5115 records  
BRCNT80C - 6213 records
BRCNT80D - 380 records    
BRCNT81A - 6967 records  
BRCNT81B - 5118 records  
BRCNT81C - 7153 records 
BRCNT81D - 1050 records     
BRCNT82A - 7143 records
BRCNT82B - 5222 records 
BRCNT82C - 7101 records
BRCNT82D - 1017 records    
BRCNT83A - 7484 records
BRCNT83B - 5381 records
BRCNT83C - 6219 records
BRCNT83D - 1041 records     
BRCNT84A - 5904 records
BRCNT84B - 5055 records 
BRCNT84C - 7028 records
BRCNT84D - 959 records    
BRCNT85A - 7217 records 
BRCNT85B - 5065 records
BRCNT85C - 6341 records
BRCNT85D - 1016 records    
BRCNT86A - 7021 records  
BRCNT86B - 5994 records  
BRCNT86C - 5114 records
BRCNT86D - 1026 records      
BRCNT87A - 7188 records  
BRCNT87B - 5299 records  
BRCNT87C - 6280 records
BRCNT87D - 1059 records      
BRCNT88A - 7072 records  
BRCNT88B - 5391 records  
BRCNT88C - 6455 records
BRCNT88D - 982 records      
BRCNT89A - 7146 records  
BRCNT89B - 5187 records  
BRCNT89C - 6188 records
BRCNT89D - 1017 records      
The following files have "J" remark codes: 86B, 86C, 87B, 87C, 88A, 88B, 88C.
The following files have "L" remark codes: 88A, 88B.

BRCNT90A - 7164 records
BRCNT90B - 5270 records
BRCNT90C - 6193 records
BRCNT90D - 1032 records    
BRCNT91A - 7161 records
BRCNT91B - 5227 records
BRCNT91C - 6307 records
BRCNT91D - 1002 records    
BRCNT92A - 7011 records
BRCNT92B - 5436 records
BRCNT92C - 6379 records
BRCNT93A - 7315 records
BRCNT93B - 5184 records
BRCNT93C - 5319 records

File structure for files from 1994 through present:
 -------------------------------------------------------------------------------
Variables: 8, maximum record length: 56.
RKI, station ID, date,time,depth,EC,composite statistics, depth indicator,
Example:
"RSAC077","C1",19940401," ",3,3175,"AVE","WATER",
"RSAC077","C1",19940401," ",17,3600,"AVE","BOTTOM",
"RSAC077","C1",19940401," ",3,7194,"MAX","WATER", 
...

 BRCNT94A - 6474 records
 BRCNT94B - 5659 records
 BRCNT94C - 7399 records
 BRCNT95A - 7117 records
 BRCNT95B - 6267 records     
The following file has "M" remark codes: 94A.