Database explanation

DATABASES :

There are two databases in the zip files:

Chemical results : CHEM XXXX .dbf where XXXX is the year of the results
Coliform results : COLI XXXX .dbf where XXXX is the year of the results.

FIELDS in the databases are outlined below according to database. See the Annual Stream Reports for explanation of tested parameters.

• CHEMICAL DATABASES- Fields
  WATERSHED - The watershed ID number as assigned by the Health Department. Watershed KEY.
  STANUM - The Station Number of the sampling site within the watershed.
  DATE - Date sample collected.
  SAMPLENUM - Id number from the laboratory for tracking purposes.
  TEMP - Water temperature of the sample at the time of collection in Fahrenheit.
  DO -Dissolved Oxygen.
  NO - Nitrate Nitrogen
  PH - pH value of sample.
  PO - Total Phosphorus
  COLBY - sampling technician’s initials.
  STRFLOW - Site evaluation of the stream flow by sampling technician.
  BN= Below normal flow NM=Normal flow AN=Above Normal Flow. Note: this was discontinued in 1998.
  WEATHER - O= Overcast C= Clear
  AIRTEMP - Temperature of air in Fahrenheit
  TRANSFER- no data
• COLIFORM - Fields
  WATERSHED - The watershed ID number as assigned by the Health Department. Watershed KEY.
  STANUM - The Station Number of the sampling site within the watershed.
  DATE - Date sample collected.
  FCOLI - Fecal Coliform value range 99 - 6,000 f.c./100ml
  TRANSFER- no data
  SAMPLENUM - Id number from the laboratory for tracking purposes.