Appendix 3-1. Description of the data in Appendix 3.

Appendix 3 contains the data described in the report Spatially-Pooled Depth-Dependent Water-Quality Data for Selected Reservoirs in Texas, January 1965 - January 2010 by
Burley, T.E., Asquith, W.H., and Brooks, D.L. (2010). 

This folder contains three descriptive files (including this file) and many
data files of water quality data from Texas Commission on Environmental
Quality sites described in the report. The files have all been saved
in the Windows carriage-return, line-feed line ending convention. The files 
are all saved in the Unicode UTF-8 encoding scheme. Each data file is a 
one-or-more space delimited and should be readily imported into conventional 
spreadsheet and statistical software. Missing entries are encoded with the 
string "NA".

FILE: Appendix_3-2_TCEQ_QW_PARAMETERS.txt

    This text file lists the water-quality parameter numbers, description, 
    and units found in associated data files within this folder. For example,
    the parameter 00010 is water temperature in degrees Celsius. These data
    can be found in file TCEQ_P00010.txt. Other parameters are similarly 
    provided.

FILE: Appendix_3-3_TCEQ_RESERVOIR_SITE_NAMES.txt
  
    This text file lists the SHORTNAME used for unique identification of each 
    reservoir considered in the report. Associated with one or more shortnames 
    are the specific Texas Commission on Environmental
	Quality station ID(s) associated with the Texas Commission on Environmental
	Quality data compiled for each reservoir. The RESERVOIR_NAME is generalized name and 
    TCEQ_STATION_ID contains the site number. Finally, the file is pipe ("|") 
    delimited.
    
DATA FILES:
	Appendix_3-4_TCEQ_P00010.txt     Appendix_3-13_TCEQ_P00900.txt     Appendix_3-22_TCEQ_P00945.txt
	Appendix_3-5_TCEQ_P00095.txt     Appendix_3-14_TCEQ_P00915.txt     Appendix_3-23_TCEQ_P00950.txt
	Appendix_3-6_TCEQ_P00300.txt     Appendix_3-15_TCEQ_P00925.txt     Appendix_3-24_TCEQ_P00951.txt
	Appendix_3-7_TCEQ_P00400.txt     Appendix_3-16_TCEQ_P00927.txt
	Appendix_3-8_TCEQ_P00480.txt     Appendix_3-17_TCEQ_P00929.txt
	Appendix_3-9_TCEQ_P00600.txt     Appendix_3-18_TCEQ_P00930.txt
	Appendix_3-10_TCEQ_P00630.txt    Appendix_3-19_TCEQ_P00935.txt
	Appendix_3-11_TCEQ_P00665.txt    Appendix_3-20_TCEQ_P00937.txt
	Appendix_3-12_TCEQ_P00666.txt    Appendix_3-21_TCEQ_P00940.txt
	
    Each data file has column headings as follows and for the example, "P00010"
    represents the parameter number for water temperature in Celsius. The 
    leading "P" is purposefully implaced to avoid numeric confusion as real 
    data. The column entries are:

    SHORTNAME   is the unique name for the reservoir used in the report.
	
    EPOCH       is the day count since the reference date January 1, 1900.
	
    JULIAN      number of complete days into the year for the corresponding date.
	
    DATE        is the day of the data with dropping of hours and minutes as
                  described in the report.
				  
    DEPTH       is the sampling depth in feet (parameter code 00003). 
	
    PARAMETER   is a repeating of the parameter number.
	
    P00010MEAN  is the mean of the numerical (data) values for P00010 found on
                  the DATE and at the sampling DEPTH.
				  
    P00010STDEV is the standard deviation of values for P00010 found on the
                  DATE and at the sampling DEPTH.
				  
    P00010COUNT is the count of the samples used in computation of the mean
                  and standard deviation.
                  
    Here follows the example header line for the data file TCEQ_P00010.txt for example:
	SHORTNAME EPOCH JULIAN DATE DEPTH PARAMETER P00010MEAN P00010STDEV P00010COUNT