FLORIDA GEOGRAPHIC DATA LIBRARY DOCUMENTATION
VERSION 2006

TITLE: FDEP WATERSHED PLANNING AND COORDINATION WATER QUALITY DATA

Geodataset Name: 	WTRWPC
Geodataset Type: 	SHAPE
Geodataset Feature: 	POLYGON

GENERAL DESCRIPTION:

This dataset contains 1998 statewide surface water qualityconditions and trends as described in the Florida Department of Environmental Protection's 305(b) report.

DATA SOURCE(S):  			Florida Department of 
                                        Environmental Protection
SCALE OF ORIGINAL SOURCE MAPS:    	1:24,000
DATE OF AUTOMATION OR SOURCE: 		11/16/99
GEODATASET EXTENT:  			State of Florida

FEATURE ATTRIBUTE TABLES:

Datafile Name:	WTRWPC.DBF
ITEM NAME           WIDTH     TYPE      PRECISION       
AREA                  18     DECIMAL        5                        
PERIMETER             18     DECIMAL        5                        
WTRWPC_                5     DECIMAL        -                        
WTRWPC_ID              5     DECIMAL        -                        
WBID                   5     CHARACTER      -                        
CHEMISTRY              7     CHARACTER      -                        
FISH                   7     CHARACTER      -                        
STANDARDS              7     CHARACTER      -                        
METALS                 7     CHARACTER      -                        
STATUS                 7     CHARACTER      -                        
BIOLOGY                7     CHARACTER      -                        
BASIN                 22     CHARACTER      -                        
HUC                    8     CHARACTER      -                        
TREND                  1     CHARACTER      -                        
TRENDNAME             12     CHARACTER      -                        
BODY                  10     CHARACTER      -                        
DISTRICT               2     CHARACTER      -                        
FILTER                11     CHARACTER      -                        
TMDL                   3     CHARACTER      -                        
EPA_USE                7     CHARACTER      -                        
WQI                   11     DECIMAL        0                        
WQB                   11     DECIMAL        0                        
WQS                   11     DECIMAL        0                        
TSI                   11     DECIMAL        0                        
WQCHEM                10     CHARACTER      -                        
YR9397                11     DECIMAL        0                        
CONFIDENCE             6     CHARACTER      -                        
BESTWORST             11     DECIMAL        0                        
BESTWORDER            11     DECIMAL        0                        
COMMENTS              50     CHARACTER      -                        
STREAMAV              14     DECIMAL        6                        
LAKEAV                14     DECIMAL        6                        
BLACKAV               14     DECIMAL        6                        
WDO                   11     DECIMAL        0                        
WBOD                  11     DECIMAL        0                        
WTN                   11     DECIMAL        0                        
WNO3                  11     DECIMAL        0                        
WTP                   11     DECIMAL        0                        
WTURB                 11     DECIMAL        0                        
WTSS                  11     DECIMAL        0                        
WBOD1                 11     DECIMAL        0                        
WCOD                  11     DECIMAL        0                        
WTOC                  11     DECIMAL        0                        
WTCOLI                11     DECIMAL        0                        
WFCOLI                11     DECIMAL        0                        
TSITN                 11     DECIMAL        0                                      
TSITP                 11     DECIMAL        0                        
TSICHLA               11     DECIMAL        0                        
DO                     1     CHARACTER      -                        
TC                     1     CHARACTER      -                        
FC                     1     CHARACTER      -                        
CH                     1     CHARACTER      -                        
AM                     1     CHARACTER      -                        
FL                     1     CHARACTER      -                        
RC                     1     CHARACTER      -                        
CY                     1     CHARACTER      -                        
AL                     1     CHARACTER      -                        
CD                     1     CHARACTER      -                        
CR6                    1     CHARACTER      -                        
CR3                    1     CHARACTER      -                        
CU                     1     CHARACTER      -                        
FE                     1     CHARACTER      -                        
PB                     1     CHARACTER      -                        
HG                     1     CHARACTER      -                        
NI                     1     CHARACTER      -                        
SE                     1     CHARACTER      -                        
AG                     1     CHARACTER      -                        
TL                     1     CHARACTER      -                        
ZN                     1     CHARACTER      -                        
TCOLI1                 6     DECIMAL        -                        
FCOLI1                 6     DECIMAL        -                        
TURB1                  6     DECIMAL        -                        
TSS1                   6     DECIMAL        -                        
BOD1                   6     DECIMAL        -                        
DO1                    6     DECIMAL        -                        
TOC1                   6     DECIMAL        -                        
CHLA1                  6     DECIMAL        -                        
SD1                    6     DECIMAL        -                        
TN1                    6     DECIMAL        -                        
NO31                   6     DECIMAL        -                        
TP1                    6     DECIMAL        -                        
WQI1                   6     DECIMAL        -                        
WQB1                   6     DECIMAL        -                        
WQS1                   6     DECIMAL        -                        
TSI1                   6     DECIMAL        -                        
DIST_LINE              4     CHARACTER      -                        
DESCRIPT              22     CHARACTER      -                        

FEATURE ATTRIBUTE TABLES CODES AND VALUES:

item	    item description
WBID        WBID is the unique watershed identifier number
CHEMISTRY   results of WQI or TSI chemistry sample (based on 5 or 3 categories)
FISH        mercury in fish tissue
STANDARDS   standards violations during 1995-97 for conventionals
METALS      standards violations during 1995-97 for metals
STATUS      average of chemistry, fish, standards, metals, biology
BIOLOGY     stream condition index (SCI) for biology samples
BASIN       Name of WBID
HUC         USGS hydrologic unit code
TREND       10 year trend (+ = improved, x = degraded, 0 = remains the same)
TRENDNAME   trend based on streamav, etc "much better" =>3 improvements
BODY        Waterbody type
DISTRICT    FDEP district based on HUC
FILTER      Enough chemistry samples to pass tmdl  confidence filters
TMDL        Fair/poor epa_use and passed tmdl confidence filter	 
EPA_USE     EPA use designation call (subset of status, based on confidence filters)
WQI         Water quality index for streams
WQB         water quality index for Blackwater streams
WQS         Water quality index for springs
TSI         trophic state index for lakes and estuaries
WQCHEM      5 categories of water quality based on chemistry (excellent, very poor)
YR9397      Number of samples passing confidence filter for 1993-97
CONFIDENCE  low=0 samples for yr9397, medium=1-2, high =>3 samples
BESTWORST   is the wqi/tsi based on waterbody type for excellent and very poor
BESTWORDER  is order from 1 to 555 of bestworst waterbodies (used to sort)
COMMENTS    Sometimes status/epause was changed based on best professional judgment
STREAMAV    number of parameters showing improvement(+), degradation(-) for streams
LAKEAV      number of parameters showing improvement(+), degradation(-) for lakes
BLACKAV     number of parameters showing improvement(+), degradation(-) for blackwater
WDO         dissolved oxygen (do) index value (1-100) 
WBOD        biological oxygen demand (bod) index value (1-100) 
WTN         total nitrogen (tn) index value (1-100)   
WNO3        nitrate (no3) index value (1-100)  
WTP         total phosphorus (tp) index value (1-100)   
WTURB       turbidity (turb) index value (1-100)    
WTSS        total suspended solids (tss) index value (1-100)  
WBOD1       bod index value (1-100)   
WCOD        chemical oxygen demand (cod) index value (1-100)   
WTOC        total organic carbon (toc) index value (1-100)   
WTCOLI      total colifrom (tcoli) index value (1-100)  
WFCOLI      fecal colifrom (fcoli) index value (1-100)   
TSITN       tsi tn index value (1-100)   
TSITP       tsi tp index value (1-100)   
TSICHLA     tsi chla index value (1-100)   
DO          do violation (n=not meeting  p=partially meeting f=fully meeting)   
TC          total coliform violation (n=not meeting  p=partially meeting f=fully meeting
FC          fecal violation (n=not meeting  p=partially meeting f=fully meeting)     
CH          chloride violation (n=not meeting  p=partially meeting f=fully meeting)     
AM          ammonium violation (n=not meeting  p=partially meeting f=fully meeting)     
FL          flouride violation (n=not meeting  p=partially meeting f=fully meeting)     
RC          residual ch violation (n=not meeting  p=partially meeting f=fully meeting)
CY          cyanide violation (n=not meeting  p=partially meeting f=fully meeting)     
ARS         arsenic violation (n=not meeting  p=partially meeting f=fully meeting)     
AL          aluminum violation (n=not meeting  p=partially meeting f=fully meeting)     
CD          cadmium violation (n=not meeting  p=partially meeting f=fully meeting)     
CR6         chromium 6 violation (n=not meeting  p=partially meeting f=fully meeting)     
CR3         chromium 3 violation (n=not meeting  p=partially meeting f=fully meeting)     
CU          copper violation (n=not meeting  p=partially meeting f=fully meeting)      
FE          iron violation (n=not meeting  p=partially meeting f=fully meeting)      
PB          lead violation (n=not meeting  p=partially meeting f=fully meeting)     
HG          mercury violation (n=not meeting  p=partially meeting f=fully meeting)     
NI          nickel violation (n=not meeting  p=partially meeting f=fully meeting)      
SE          selenium violation (n=not meeting  p=partially meeting f=fully meeting)      
AG          silver violation (n=not meeting  p=partially meeting f=fully meeting)     
TL          thallium violation (n=not meeting  p=partially meeting f=fully meeting)     
ZN          zinc violation (n=not meeting  p=partially meeting f=fully meeting)      
TCOLI1      t coli trend (1=improve  2=stable  3=degrade)   
FCOLI1      f coli trend (1=improve  2=stable  3=degrade)   
TURB1       turbidity trend (1=improve  2=stable  3=degrade)      
TSS1        t. suspended solids trend (1=improve  2=stable  3=degrade)     
BOD1        bod trend (1=improve  2=stable  3=degrade)      
DO1         do trend (1=improve  2=stable  3=degrade)      
TOC1        toc trend (1=improve  2=stable  3=degrade)      
CHLA1       chla trend (1=improve  2=stable  3=degrade)      
SD1         secchi disc trend (1=improve  2=stable  3=degrade)     
TN1         tn trend (1=improve  2=stable  3=degrade)      
NO31        no3 trend (1=improve  2=stable  3=degrade)      
TP1         tp trend (1=improve  2=stable  3=degrade)      
WQI1        wqi trend (1=improve  2=stable  3=degrade)     
WQB1        wqi blackwater trend (1=improve  2=stable  3=degrade)      
WQS1        wqi spring trend (1=improve  2=stable  3=degrade)     
TSI1        tsi trend (1=improve  2=stable  3=degrade)
DESCRIPT    based on basin

USER NOTES: Section 305(b) of the Clean Water Act requires each state to conduct water quality surveys to determine whether or not its waterways are healthy enough and of sufficient quality to meet their designated uses. This information is compiled into a report called the 305(b) report. The state prepares this report every two years for the United States Environmental Protection Agency (USEPA). USEPA then uses this report to prepare a report to Congress, the National Water Quality Inventory, which describes the condition of the waters of the United States. The data used for the 305(b) report comes from the USEPA STORET database, the State's biological database (SBIO) and fish consumption advisories. This GIS coverage displays the how well each waterbody evaluated in the 305(b) report meets its designated use. There are 3 levels: meets designated use, partially meets designated use and does not meet its designated use. The uses of most waters of the State fall into three classes: Class I-potable water supply, Class II-shellfish harvesting, Class III-recreation and propagation of fish and wildlife. For more information on Designated Uses refer to the State of Florida's rule 62-302 (Florida's Water Quality Standards).

FGDL QUALITY ASSURANCE STATUS:

-Tolerances set to geoplan standards
-DESCRIPT item added based on BASINS item
-Shapearc, clean and regionpoly commands performed to transform original shapefile into a 
coverage.  This resulted in the creation of polygons without attributes.  These were not a 
part of the original shapefile obtained from FDEP and are merely an artefact of the arcview
shapefile to ARC/INFO coverage conversion process.

REFERENCES:

For more information on the 305(b) dataset and report, visit FDEP's website http://www.dep.state.fl.us/water/division/monitoring/pubs.htm

DATA LINEAGE SUMMARY:

Statewide basins coverage was converted into a shapefile and subdivided into 8 smaller units by Joe Hand. Additional basins were created in ARCVIEW (For information on the procedures and rationale used to subdivide the statewide coverage and create these new basins, contact Joe Hand). The eight shapefiles were used as a source for making an updated statewide 305b coverage. Each shapefile was converted into an ARC/INFO REGIONS coverage using SHAPEARC command with the subclass option. Coverages were projected from Decimal Degrees NAD27 to Albers-Hpgn. Topology was rebuilt using the CLEAN command. A tolerance of 1 was used for fuzzy and dangle length. The regions coverages were converted to ARC polygon coverages using the REGIONPOLY command. The eight polygon coverages were mapjoined using the MAPJOIN command. Sliver polygons (coverage-id = 0) were eliminated with the ELIMINATE command. As a final check, the linework of the coverage was checked using each of the individual eight coverages as a backcover in ARCEDIT. Some additional small slivers were deleted manually in ARCEDIT. To assure that each polygon has a unique WBID (water body id), a summary statistics on item WBID was performed in ARCVIEW. There were 18 duplicated WBID'S. They were reassigned unique WBID'S following the guidelines supplied by Joe Hand. A shapefile was made of this coverage. DBASE tables (containing summaries of chemical and biological data) from the 305b report were joined to the attribute table of the shapefile in ARCVIEW. WBID was used as the joinitem. For a full description of the attribute table contact Joe Hand. The shapefile with the joined attribute table was converted into an ARC/INFO polygon coverage using SHAPEARC (with regions option), CLEAN (fuzzy and dangle length 1) and REGIONPOLY commands. This resulted in the 1996 version of the 305b data. The original datset was updated for 1998 using ArcView 3.1 by updating database information and by adding new polygons to accomodate new stations. The 305(b) dataset was received at the geoplan center as a shapefile. This shapefile was converted to an ARC/INFO coverage using the shapearc command. Many "empty" polygons were created in this process. These empty polygons are necessary for maintaining topology.

MAP PROJECTION PARAMETERS

PROJECTION 				ALBERS
DATUM 					HPGN
UNITS 					METERS
SPHEROID 				GRS1980
1st standard parallel			24  0  0.000
2nd standard parallel			31 30  0.000
central meridian			-84 00  0.000
latitude of projection's origin		24  0  0.000
false easting (meters)			400000.00000
false northing (meters)			0.00000

DATA SOURCES CONTACT(S):

Name: 			Florida Department of Environmental Protection		 
Abbr.name: 		FDEP	
Address: 							
Phone: 			850/921-9441
Web site: 	        http://www.dep.state.fl.us
Contact Person:		
         Phone: 	850/921-9441

FGDL CONTACT:

Name:			Florida Geographic Data Library
Abbr. Name:		FGDL
Address:		Florida Geographic Data Library
                        431 Architecture Building
                        PO Box 115706
                        Gainesville, FL  32611-5706
Fax:                    (352) 846-3124
Web site:		http://www.fgdl.org
Contact FGDL:
      Technical Support:	        http://www.fgdl.org/fgdlfeed.html
      FGDL Frequently Asked Questions:  http://www.fgdl.org/fgdlfaq.html
      FGDL Mailing Lists:		http://www.fgdl.org/fgdl-l.html
      For FGDL Software:                http://www.fgdl.org/software.html