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
PointDef contains the following fields:
- Monitoring Point: The textual description used to identify the monitoring point.
- MP ID: A unique numeric identifier for each monitoring point
- LAT: The latitude represented as decimal degrees.
- LON: The longitude represented as decimal degrees.
- samplingPeriod: The frequency with which sampling occurred. "Q" indicates a quarterly data point, "M" indicates a monthly data point.
- Township
- County
ChemData
ChemData contains the following fields:
- Monitoring Point: The textual description used to identify the monitoring point.
- MP ID: A unique numeric identifier for each monitoring point
- DATE: The date sampling occurred.
- FLOW (GPM): Flow as reported in gallons per minute.
- FIELD PH (STD UNITS): pH value measured in the field.
- LAB PH (STD UNITS). pH value measured in the lab.
- 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.
- TEMP (C): Temperature of the water as measured in the field.
- ALKALINITY (MG/L): Alkalinity measured in the lab
- ACIDITY (MG/L): Acidity measured in the lab
- IRON (MG/L): Iron measured in the lab
- MANGANESE (MG/L): Manganese measured in the lab
- ALUMINUM (MG/L): Aluminum measured in the lab
- SULFATE (MG/L): Sulfates measured in the lab.
- TSS (MG/L): Total Suspended solids measured in the lab.
- TDS (MG/L): Total dissolved solids measured in the lab.
