Department of Water Resources Home
IEP Banner

Data File Format

File Format for the Municipal Water Quality Investigations Program.


File Names	Description

mindat.dat      Mineral Data
stations.txt    Station Names (cross-reference table)

File  		Last Update    Size (KB)   Record    Variables

mindat.dat	7/19/94		360	    5348       13
stations.txt	7/19/94		80	    1100	7

Structure of files

Variable Name and Format

mindat.dat
Name           Type      Width     Decimal        Units
RKI         Character      2         0            River Km Index (empty)
Station     Character      8         0            Station Name
Date        Date           8         0            MMDDYY
Time        Character      2         0            24 hr clock (PST) (empty)
Depth       Numeric        2         0            Depth Sample Taken (empty)
Alk.        Numeric	   3	     0		  mg/L as CaCO3
B	    Numeric	   2	     1		  mg/L
Ca	    Numeric	   3	     0		  mg/L
Cl	    Numeric	   4         0		  mg/L
TDS	    Numeric	   4	     0		  mg/L
Hardness    Numeric	   4	     0     	  mg/L as CaCO3
Mg	    Numeric  	   3	     0		  mg/L
K	    Numeric	   2	     1		  mg/L
Na	    Numeric	   4	     0		  mg/L
EC	    Numeric	   5	     0		  umhos/cm
SO4	    Numeric	   3	     0		  mg/L


station.txt
Name           Type	      Width   
Stalden     Number(long)	4
Ident	    Number(long)	4
Stano	    	text		30
Staname		text		60
Sname		text		15
StnTYP		text		3
Locks		text		8