Database explanation


Surface Water Logo

Explanation of the DATABASE Structure and FIELDS used in Fairfax County's Annual Stream Report
(1986 - 2002)

DATABASES:

There are two databases in the zip files:

Chemical results : CHEMXXXX.dbf where XXXX is the year of the results
Coliform results : COLIXXXX.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.

Contact Fairfax County: Phone, Email or Twitter | Main Address: 12000 Government Center Parkway, Fairfax, VA 22035
Technical Questions: Web Administrator

ADA Accessibility | Website Accessibility
Awards | FOIA | Mobile | Using this Site | Web Disclaimer & Privacy Policy | Get Adobe Reader
Official site of the County of Fairfax, Virginia, © Copyright 2013

Website Feedback Website Feedback    Globe with various flags representing Web site language translations   Language Translations

Return to Graphic Version