Overall DVD Folder Organization Inland TSD Data

01) Streams

All Streams Analyses

Downstream Protective Values

Healthy Biological Condition Based Distribution Analysis

Rapid Periphyton 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 type and description.

 Inland TSD Data: File List and Description 

EPA-HQ-OW-2009-0596-DRAFT-0288 

This DVD consists of data used in developing the Florida Inland Waters nutrient criteria technical support document. It is organized by waterbody

type. 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 size is approximate. Page 1 of 8
File Name File Size 

(bytes) 

File Type Description

All Streams Analysis 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 analyses 

performed with these data were for 3 Nutrient Watershed Regions (NWRs 

- Panhandle, Peninsula, and Bone Valley). Since that analysis, U.S. EPA 

identified a fourth NWR (North Central) and is proposing a regionalization 

scheme reflecting those 4 NWRs. A statistical distribution analysis for the 

4 NWRs would reflect the same approach taken for the 3 NWRs.

All Streams Analysis 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 Streams 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 Weaver, 15May09, provided through ftp link at 

ftp://ftp.dep.state.fl.us/pub/water/everglades/Weaver/Nutrient%20Data)

01) Streams > All Streams Analyses

Note: File size is approximate. Page 2 of 8
File Name File Size 

(bytes) 

File Type Description

FL_All_Streams (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 

imported 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_Streams_21FLGW.xlsx: an excel file provided by Ken Weaver, 

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_Streams_092909.xlsx: an excel file provided by Ken Weaver, 

FDEP on 02 October 09 to address deficiency of above file not having all 

21FLGW data. (n=16,971 records)

+ FL_All_Streams (29Sep09-02Oct09 update)._db: MS access file that 

includes the raw import.

FL_IWR_Estuary_Database.mdb 1,329,037,312 mdb GIS and data files derived from IWR Run 34 and used for stream nutrient 

analysis 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 mdb Results from SE Regional SPARROW model predictions for TN including 

instream loads, yields, fraction delivered, source load contributions, and 

annual time series of TN loads at river gage stations. 

01) Streams > Downstream Protective Values

Note: File size is approximate. Page 3 of 8
File Name File Size 

(bytes) 

File Type Description

Steward and Lowe 2010 (Empirical Nutrient 

Load Limits).pdf

 1,038,090 pdf Limnology and Oceanography paper by Joel Steward and Edgar Lowe of 

St Johns Water Management District. Cited in development of protective 

TN loads for downstream use protection.

WBID_FracDelTar.xls 338,944 xls This file contains the fraction of TN delivered to the estuary for each 

WBID in Florida.

01) Streams > Healthy Biological Condition Based Distribution Analysis

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 WBID TP and TN Summary

Data.xls

 4,372,562 xls These data are the raw site and WBID average data derived from the All 

Streams data on 10022009 and serve as the basis of the site average 

and site-year average data. They are pulled from the All Streams dataset 

which is derived from the IWR.

RPS.xlsx 3,479,552 xlsx This is the original rapid periphyton survey data provided by FDEP to 

EPA.

01) Streams > Rapid Periphyton Survey Data

Note: File size is approximate. Page 4 of 8
File Name File Size 

(bytes) 

File Type Description

RPS_final.xlsx 122,880 xlsx This is the final rapid periphyton survey data used by EPA to perform the 

rapid periphyton survey analysis 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_Analyses_051209.xlsx" and "Lake Data with Alk.xlsx". 

Includes annual geometric mean concentrations (as ln) of nutrients, 

chlorophyll, conductivity, alkalinity, for all lake-year combinations with a 

minimum of 4 chlorophyll measurements in the year. Basis for analyses 

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 Weaver, 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_Analyses_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, 

chlorophyll, and nutrient data collected from lake sampling. Provided by

Ken Weaver, FDEP.

Lake_Chla_Analyses_051209.xlsx 10,156,010 xlsx Data file provided by Ken Weaver, FDEP, 5/12/2009. Contains all nutrient 

and chlorophyll data from Florida lakes, and FDEP's pivot tables and 

summary sheets from their chlorophyll analyses.

02) Lakes

Note: File size is approximate. Page 5 of 8
File Name File Size 

(bytes) 

File Type Description

Lakes_AnnualAvg_ByStationColorGp.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 IWR database, not from data 

provided by FDEP.

LVI vs Long Term Data051109A.xlsx 5,150,958 xlsx Data file provided by Ken Weaver, FDEP, 5/11/2009. LVI data and longterm lake averages. Includes FDEP analyses and pivot tables. Data for 

pdf file "Clear lake LVI and Chlorophyll Response.pdf"

TN, TP Models.xls 46,080 xls Regression model TN, TP values predicted to yield given chlorophyll 

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 

accompanying 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 Weaver, 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 WQ Data Analysis.zip 1,840,918 zip Compressed MS Access file that includes final data sets for computing 

canal analyses in south Florida.

04) Canals

03) Springs

Note: File size is approximate. Page 6 of 8
File Name File Size 

(bytes) 

File Type Description

Miami-Dade Data.zip 22,139,067 zip Zip file containing the source excel files provided by Miami-Dade county

on 16Oct09 by email (via Stephen Blair and Omar Abdelrahman.) The 

station data is in BBWQ 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 Weaver, FDEP on 

12Oct09. 

SFWMD_CANAL-STREAM.zip 31,903,747 zip "SFWMD Canal Stream Data" received via email from Ken Weaver, 

FDEP on July 15, 2009. Data was initially received to perform fresh water 

canal data analysis.

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 Weaver, FDEP, 27July2009)

FDEP_Nutrient_Region_051509.zip 899,287 zip Revised FDEP Nutrient Regions (Source: Ken Weaver, FDEP, 15May09, 

provided through ftp link at 

ftp://ftp.dep.state.fl.us/pub/water/everglades/Weaver/Nutrient%20Data/Sh

apefiles)

Fl_Water_Management_Districts.zip 205,062 zip Florida Water Management District shapefile (Source: Ken Weaver, 

FDEP, 16Apr09 email attachment)

05) GIS Shapefiles

Note: File size is approximate. Page 7 of 8
File Name File Size 

(bytes) 

File Type Description

FL_WBIDS.zip 22,467,694 zip Florida WBIDs (Source: Ken Weaver, FDEP, 15May09, provided through 

ftp link at 

ftp://ftp.dep.state.fl.us/pub/water/everglades/Weaver/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)

SFWMD_Hydro.zip 135,930 zip South Florida Water Management District Hydrographic data (Source: 

Ken Weaver, FDEP 27July09)

tn_benchmark_wbids.zip 553,950 zip WBID shapefile for sites that can be used for benchmarks (Requested: 

14May09 by USEPA/GED, developed by contractor 15May09)

Note: File size is approximate. Page 8 of 8