The data collected for this assessment can be found in two CSV files. The first, PointDef.txt, contains information describing the monitoring points. The second, ChemData.txt, contains the chemical data collected.

Both files are CSV files. This means that all data is separated by a comma. Textual data is enclosed in double quotes. Each row is a record (i.e., CR and LF characters terminate each record).

PointDef definition.

ChemData definition.

PointDef data.

PointDef contains the following fields:

1. Monitoring Point: The textual description used to identify the monitoring point.
2. MP ID: A unique numeric identifier for each monitoring point
3. Latitude: The original latitude recorded.
4. LAT_DEC: The latitude converted to decimal value for points where numeric values were required.
5. Longitude: The original longitude recorded.
6. LON_DEC: The longitude converted to decimal value for points where numeric values were required.
7. Sampling Reason:A name associated with the project for which the data was collected. For permits, the permit # is listed.
8. Associated Name: In some cases, monitoring points coincided with those used for the restoration plan. When these occurred, the data collected at these points was added to the restoration plan samples for analysis.
9. Township
10. County
11. Comments:
12. Times Samples: This displays a count of the number of records in the Chem Data sample with data for this particular monitoring point.

ChemData data.

ChemData contains the following fields:

1. MP ID: A unique numeric identifier for each monitoring point
2. Monitoring Point: The textual description used to identify the monitoring point.
3. DATE: The date sampling occurred.
4. FLOW (GPM): Flow as reported in gallons per minute.
5. FIELD PH (STD UNITS): pH value measured in the field.
6. LAB PH (STD UNITS). pH value measured in the lab.
7. CONDUCTIVITY (UMHOS/CM): Measured conductivity. Source may be either field or lab depending upon the data source. All conductivity collected as part of this assessment is lab data. Historical data may vary.
8. ACIDITY (MG/L): Acidity measured in the lab
9. ACID LOAD (LBS/DAY): Calculated acid load
10. ALKALINITY (MG/L): Alkalinity measured in the lab
11. IRON (MG/L): Iron measured in the lab
12. IRON LOAD (LBS/DAY): Calculated iron load
13. ALUMINUM (MG/L): Aluminum measured in the lab
14. MANGANESE (MG/L): Manganese measured in the lab
15. SULFATE (MG/L): Sulfates measured in the lab.
16. TSS (MG/L): Total Suspended solids measured in the lab.
17. TEMP (C): Temperature of the water in celcius as measured in the field.
18. TDS (MG/L): Total dissolved solids measured in the lab.