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. Description: A description of the monitoring point.
4. Latitude: The original latitude recorded.
5. LAT_DEC: The latitude converted to decimal value for points where numeric values were required.
6. Longitude: The original longitude recorded.
7. LON_DEC: The longitude converted to decimal value for points where numeric values were required.
8. Operator: The sampling organization.
9. Permit Number: The permit number, when appropriate. Alternately, a description was sometimes entered here.
10. Job Name:A name associated with the project for which the data was collected.
11. Township
12. County
13. Set: A description of the aggregate group to which this point belongs. That is, the reason that this point was sampled.
14. 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. ACID LOAD (TONS/YEAR): Calculated acid load
11. ALKALINITY (MG/L): Alkalinity measured in the lab
12. IRON (MG/L): Iron measured in the lab
13. IRON LOAD (LBS/DAY): Calculated iron load
14. IRON LOAD (TONS/YEAR): Calculated iron load
15. ALUMINUM (MG/L): Aluminum measured in the lab
16. ALUMINUM LOAD (LBS/DAY) Calculated aluminum load
17. ALUMINUM LOAD (TONS/YEAR) Calculated aluminum load
18. MANGANESE (MG/L): Manganese measured in the lab
19. MANGANESE (LBS/DAY): Calculated Manganese load.
20. MANGANESE (TONS/YEAR): Calculated Manganese load.
21. SULFATE (MG/L): Sulfates measured in the lab.
22. TSS (MG/L): Total Suspended solids measured in the lab.
23. TEMP (C): Temperature of the water in celcius as measured in the field.
24. TDS (MG/L): Total dissolved solids measured in the lab.