Overall DVD Folder Organization Inland TSD Data 01) Streams All Stream s Analy ses Downstream Protective Values Healthy Biological Condition Based Distribution Analy sis Rapid Periphy

ton Survey

Data 02) Lakes 03) Springs 04) Canals 05) GIS Shapefiles

File Name File Size (bytes) File Type Description

DVD Documentation.xls 59,392 xls This file. A complete listing of files included on the Inland TSD Data DVD, approximate file size, file ty pe and description. 

### Inland TSD Data: File List and Description EPA -HQ-OW-2009-0596-DRA FT-0288
This DVD consists of data used in developing the Florida Inland W aters nutrient criteria technical support document. It is organized by waterbody ty pe. A copy

of these files is available for review in the EPA reading room. Files included are described in the table below.

Inland TSD Data



### Note: File siz e is approximate. Page 1 of 8File Name File Size (bytes) File Type Description

All Stream s Analy sis by EPA Nutrient Region.zip 2,336,768 zip Compressed MS Access file that includes final data sets for computing allstream distributional statistics by EPA nutrient region. The analy ses performed with these data were for 3 Nutrient W atershed Regions (NW Rs - Panhandle, Peninsula, and Bone Valley ). Since that analy sis, U.S. EPA identified a fourth NW R (North Central) and is proposing a regionalization scheme reflecting those 4 NW Rs. A statistical distribution analy sis for the 4 NW Rs would reflect the same approach taken for the 3 NW Rs.

All Stream s Analy sis by FDEP Nutrient Region.zip 8,945,664 zip Compressed MS Access file that includes final data sets for computing allstream distributional statistics by FDEP nutrient region.

All Stream s Input Data for FDEP Nutrient Regions.xlsx 16,252,928 xlsx These data are the "all streams" data used by EPA for computing distributional statistics by FDEP nutrient region. FDEP provided this data set as having been QA reviewed and screened data from which FDEP drew the benchmark dataset. According to the source, "it represents data, primarily

from STORET, of known or defensible quality . It is believed to be data that are very representative of Florida's flowing waters." (Source: Ken W eaver, 15May 09, provided through ftp link at ftp://ftp.dep.state.fl.us/pub/water/everglades/W eaver/Nutrient%20Data) 01) Streams > A ll Streams A nalyses



### Note: File siz e is approximate. Page 2 of 8File Name File Size (bytes) File Type Description

FL_All_Stream s (29Sep09-02Oct09 update).zip 24,938,496 zip This zip file contains the source excel files that update the “All Streams data”. These files were imported into an Access which is also included here. The two excel files are the original files from FDEP. These files are im ported into the MS Access file also in this zip file. To combine the data, use the FL_All_Streams_092909.xlsx, delete the 21FLGW data, and then copy in data from the All_Streams_21FLGW .xlsx file. + All_Stream s_21FLGW .xlsx: an excel file provided by Ken W eaver, FDEP on 29 September 09 to address an error with DO data found in the previous all streams file. This file contains 270,024 records for 8,614 sites. + FL_All_Stream s_092909.xlsx: an excel file provided by Ken W eaver, FDEP on 02 October 09 to address deficiency of above file not having all 21FLGW data. (n=16,971 records) + FL_All_Stream s (29Sep09-02Oct09 update)._db: MS access file that includes the raw import.

FL_IW R_Estuary

_Database.mdb 1,329,037,312 md b GIS and data files derived from IW R Run 34 and used for stream nutrient analy sis and classification. Used for computing statistics for streams in estuarine watersheds and nutrient watershed regions. Includes Access data tables and queries as documented in the corresponding sections of the TSD and TSD appendices.
SAGT_SPARROW .mdb 22,966,272 md b Results from SE Regional SPARROW model predictions for TN including instream loads, y ields, fraction delivered, source load contributions, and annual tim e series of TN loads at river gage stations. 01) Streams > Downstream Protective Values



### Note: File siz e is approximate. Page 3 of 8File Name File Size (bytes) File Type Description

Steward and Lowe 2010 (Em pirical Nutrient Load Lim its).pdf 1,038,090 pdf Lim nology and Oceanography

paper by

Joel Steward and Edgar Lowe of St Johns W ater Management District. Cited in development of protective TN loads for downstream use protection.

WB ID_FracDelTar.xls 338,944 xls This file contains the fraction of TN delivered to the estuary for each WB ID in Florida.

01) Streams > Healthy Biological Condition Based Distribution A nalysis IPV Data Distribution Based (Final Data Used).xls 2,617,344 xls This is the final data used to derive the IPV criteria using distribution based approach of biologically healthy sites.
SCI2004 Data File 09_11_09_final from FDEP (Raw Original Data).xlsx 1,038,336 xlsx This is the first raw data file provided by FDEP that contains water chemistry

and biological data for deriving IPV criteria based on biologically healthy sites.
SCI2007 Data File 09_23_09_final from FDEP (Raw Original Data).xlsx 1,593,344 xlsx This is the second raw data file provided by FDEP that contains water chemistry

and biological data for deriving IPV criteria based on biologically healthy sites.

Station and W BID TP and TN Summary Data.xls 4,372,562 xls These data are the raw site and W BID average data derived from the All Streams data on 10022009 and serve as the basis of the site average and site-y ear average data. They are pulled from the All Streams dataset which is derived from the IW R.

RPS.xlsx 3,479,552 xlsx This is the original rapid periphy ton survey

data provided by

FDEP to EPA. 01) Streams > Rapid Periphyton Survey Data



### Note: File siz e is approximate. Page 4 of 8File Name File Size (bytes) File Type Description

RPS_final.xlsx 122,880 xlsx This is the final rapid periphy ton survey

data used by

EPA to perform the rapid periphy

ton survey

analy sis and was derived from the RPS.xlsx file.

All_Lakes_Ann_Av_N4.xls 251,904 xls Data file developed from FDEP lake data files, principally "Lake_Chla_Analy ses_051209.xlsx" and "Lake Data with Alk.xlsx". Includes annual geometric mean concentrations (as ln) of nutrients, chlorophy ll, conductivity , alkalinity , for all lake-y ear combinations with a mi nim um of 4 chlorophy ll m easurements in the y ear. Basis for analy ses of classification scheme on color, alkalinity , and conductivity

.

Clear Lake Alk-Cond_100109.xlsx 83,763 xlsx Alkalinity and conductivity

measurements for clear lakes only , provided by Ken W eaver, FDEP, 10/01/2009. Superseded by complete alkalinity

data set, "Lake data with alk.xls".

FDEP chl ann av.xls 142,336 xls Annual average chl a and nutrient data copied from FDEP file "Lake_Chla_Analy ses_051209.xlsx" containing annual average data from clear, moderately

colored, and highly

colored lakes, use by

FDEP to develop chl a regressiosn, and by EPA to confirm regression models.

Lake Data with Alk.xlsx 4,800,001 xlsx Download by FDEP, 12/23/2009, including all alkalinity , conductivity
, chlorophy ll, and nutrient data collected from lake sampling. Provided by Ken W eaver, FDEP.
Lake_Chla_Analy ses_051209.xlsx 10,156,010 xlsx Data file provided by Ken W eaver, FDEP, 5/12/2009. Contains all nutrient and chlorophy ll data from Florida lakes, and FDEP's pivot tables and summary

sheets from their chlorophy ll analy ses. 02) Lakes



### Note: File siz e is approximate. Page 5 of 8File Name File Size (bytes) File Type Description

Lakes_AnnualAvg_By StationColorGp.txt 790,642 txt Data file used by EPA to summarize distribution of attributes in all Florida lakes, as described in Appendix A-4 of TSD (January 2010 version). File was developed directly from Run 34 of IW R database, not from data provided by

FDEP.
LVI vs Long Term Data051109A.xlsx 5,150,958 xlsx Data file provided by Ken W eaver, FDEP, 5/11/2009. LVI data and longterm lake averages. Includes FDEP analy ses and pivot tables. Data for pdf file "Clear lake LVI and Chlorophy ll Response.pdf"

TN, TP Models.xls 46,080 xls Regression model TN, TP values predicted to y ield given chlorophy ll levels at 25%, 50% and 75% probability of exceedance (of chla). Developed from regression equations calculated by FDEP and verified by EPA.

DataSourcesSpringCriteria Derivation.doc 31,744 doc This document contains a list of the papers that are the part of the technical basis for the springs criteria. These papers are included in the accompany ing zipped folder.
DataUsedForCriteriaDerivationInSprings.zip 11,424,250 zip This folder contains several papers that are the part of the technical basis for the springs criteria.

Broward County

Canal Data - copy

for EPA 9-9-09.zip 6,149,367 zip FDEP provided the so-called “Broward County Canal Data” via email from Ken W eaver, FDEP on September 9, 2009. The Excel sheet contained 49,056 results associated with 61 stations. These data were collected from 1999 through 2008.

Canal W Q Data Analy sis.zip 1,840,918 zip Compressed MS Access file that includes final data sets for computing canal analy ses in south Florida. 04) Canals 03) Springs



### Note: File siz e is approximate. Page 6 of 8File Name File Size (bytes) File Type Description

Miam i-Dade Data.zip 22,139,067 zip Zip file containing the source excel files provided by Miam i-Dade county on 16Oct09 by

email (via Stephen Blair and Omar Abdelrahman.) The station data is in BBW Q Stations-2.xls. EPA_UplandStations.xlsx and EPA SA 10162009.xlsx contain “inland” data and marine data, respectively . The file also includes graphics and data reports from MiamiDade County

. MIAMIDADE_STORET.zip 36,237,687 zip This zip file contains the source excel file from Ken W eaver, FDEP on 12Oct09.

SFW MD_CANAL-STREAM.zip 31,903,747 zip "SFW MD Canal Stream Data" received via email from Ken W eaver, FDEP on July

15, 2009. Data was initially received to perform fresh water canal data analy sis.

coverages_SAGT.zip 18,935,278 zip GIS coverages of ERF1 stream network and associated watersheds used in SAGT-SPARROW model
Everglades Agricultural and Protection Areas.zip 16,467 zip Everglades Agricultural Area and Everglades Protection Areas (Source: Ken W eaver, FDEP, 27July 2009)
FDEP_Nutrient_Region_051509.zip 899,287 zip Revised FDEP Nutrient Regions (Source: Ken W eaver, FDEP, 15May 09, provided through ftp link at ftp://ftp.dep.state.fl.us/pub/water/everglades/W eaver/Nutrient%20Data/Sh apefiles)
Fl_W ater_Management_Districts.zip 205,062 zip Florida W ater Management District shapefile (Source: Ken W eaver, FDEP, 16Apr09 email attachment) 05) GIS Shapefiles



### Note: File siz e is approximate. Page 7 of 8File Name File Size (bytes) File Type Description

FL_W BIDS.zip 22,467,694 zip Florida W BIDs (Source: Ken W eaver, FDEP, 15May 09, provided through ftp link at ftp://ftp.dep.state.fl.us/pub/water/everglades/W eaver/Nutrient%20Data/Sh apefiles)
SAGT_CAF.ZIP 3,984,150 zip NOAA Coastal Assessment Framework EDAs, CDAs, and FDAs, clipped to include the southeast region, the portion relevant to Florida. Complete information and the full US extent of the NOAA Coastal Assessment Framework is available at http://coastalgeospatial.noaa.gov/welcome.html

SCI_Bioregions.zip 9,263 zip Bioregion Shapefile (Compressed from 22Apr09 files)

SFW MD_Hy dro.zip 135,930 zip South Florida W ater Management District Hy drographic data (Source: Ken W eaver, FDEP 27July 09)
tn_benchmark_wbids.zip 553,950 zip WB ID shapefile for sites that can be used for benchmarks (Requested: 14May 09 by

USEPA/GED, developed by contractor 15May 09)



### Note: File siz e is approximate. Page 8 of 8