Florida Phase II Data Docket User Guide

1

The following data are used to support U.S. EPA’s Proposed Rule for Numeric Nutrient Criteria for Florida’s Estuaries, Coastal Waters, and Southern Inland Flowing Waters. These data are included as supplemental material to EPA’s Technical Support Document for U.S. EPA’s Proposed Rule for Numeric Nutrient Criteria for Florida’s Estuaries, Coastal Waters, and Southern Inland Flowing Waters. For detailed descriptions and a full listing of files please refer to the ‘Data Docket Master File Log’.

The data files in the data docket are organized into four main folders. The first three folders, 1) Estuaries, 2) Coastal, and 3) South Florida, correspond to the three volumes of the TSD. The last folder, 4) Economic Analysis, corresponds to the economic analysis.

1) Estuaries. Details on the methodology EPA used to derive numeric nutrient criteria for estuaries outside of south Florida are provided in TSD Volume 1: Estuaries. Here, subfolders are organized into the data used for the empirical analyses (Estuary Empirical Data), the mechanistic watershed and estuary models (Estuary Modeling Data), GIS data including seagrass coverages used to set seagrass depth targets (GIS), marine lake analyses (Marine Lakes), and ancillary supporting data for the estuary descriptions (System Descriptions). The paths below show how to access these data on the data docket:

1) Estuaries > Estuary Empirical Data - Data sources and empirical data.

1) Estuaries > Estuary Modeling Data

a. LSPC Watersheds Folder - This folder contains the following subfolders in support of Volume I Appendix C: i. 1) Watershed Models. This folder provides the files needed to simulate current conditions and scenarios for LSPC models and their associated outputs files. a) The model executable, model database file, and weather files are needed to run the model. b) To open and execute the model, open model executable. c) To open the model database, click File|Get From Database and toggle to folder on computer than contains database and click Open. Option Selection window will open, click OK. d) When prompted to select weather files, toggle to folder on computer that contains weather files and click OK. e) Click on the Output folder in left hand window in model executable. In the right hand window, change Model Results Location to desired folder where outputs will be written. f) To run the model, click File|Run the Model. ii. 2) Terminal Tributaries - This folder provides daily flows, water quality concentrations, and water quality loads from the LSPC watershed tributaries that were used in the estuary model development. iii. 3) Shapefiles - This folder provides GIS shapefiles that provide general support for all of the other folders. iv. 4) Data - This folder provides raw data used in development and calibration of the models.Florida Phase II Data Docket User Guide

2

b. Estuaries Folder - The EFDC and WASP Estuary Model files include complete installation, setup and documentation files, input files, and associated GIS files as follows:i. EFDC calibrated model files for each of the modeled estuary systems

(Perdido, Pensacola, Choctawhatchee, St. Andrews, Big Bend, Lake Worth, Loxahatchee, St. Lucie, and St. Marys):

a. Input files (inp) b. Executable files (exe and dll)

c. Output hydrodynamic linkage file for WASP (hyd) ii. WASP model files for each scenario for each estuary system (Calibrated/existing cond., Non-Anthropogenic Scenario, Reduction Scenarios):

a. Wasp input file (wif)

b. WASP model output BMD for each estuary scenario iii. GIS shapefiles for each estuary with EFDC model i and j designations and WASP model segment numbers for use in MOVEM. Includes projection file (*.prj) with map projection information. iv. WASP model executable files including MOVEM post processor.

v. Post processor tool that reads BMD and computes estuary segment averages needed for criteria development. vi. Comma separated value files (CSV) for Chl-a, light attenuation (kd), DO, TN, and TP that were used to evaluate model targets and calculate criteria. vii. Database/Spreadsheet for each modeled terminal tributary, flows and concentrations used in DPV calculations. viii. Appendix D Supplemental Figures and Tables – Include calibration and validation plots for each of the estuaries as well as corresponding tables.

1) Estuaries > GIS - Assorted GIS files used in analyses supporting the estuary criteria development.

1) Estuaries > Marine Lakes - This folder contains a report, as well as the data used to create the report, which summarizes an analysis to identify and review water quality data for marine lakes in Florida.

1) Estuaries > System Descriptions - Water quality monitoring data and other empirical data related to particular estuary systems in Florida.

2) Coastal. Details on the methodology EPA used to derive numeric nutrient criteria for coastal waters are provided in TSD Volume 2: Coastal Waters. Here, subfolders are organized into the data downloaded from the three satellites (SeaWiFS, MODIS, and MERIS), field data used to validate the remote sensing data (Coastal_Satellite_Validation), and GIS files used for segmenting the coastal waters (Coastal Segments). The paths below show how to access these data on the data docket:

2) Coastal > Coastal Segments – GIS files and WBID segments and associated files defining the areal extent of coastal segments with associated criteria.Florida Phase II Data Docket User Guide

3

2) Coastal > Coastal_Satellite_Validation –Files supporting remote sensing satellite calibration and satellite processing notes.

2) Coastal > MERIS –MERIS satellite remote sensing data.

2) Coastal > MODIS –MODIS satellite remote sensing data.

2) Coastal > SeaWiFS – SeaWiFS satellite remote sensing data.

3) South Florida. Details on the methodology EPA used to derive numeric nutrient criteria for South Florida are provided in TSD Volume 3: South Florida Inland Flowing Waters. Here, information is organized into four subfolders. The "0) Data Sources" subfolder provides primary data sources used in the South Florida analyses: IWR Run 40 and DBHydro. The "1) GIS" subfolder contains assorted GIS files used in analyses supporting the South Florida Inland criteria development. The "2) DPV" subfolder provides additional information supporting EPA's development of DPVs in South Florida. The "3) Inland" subfolder provides additional information supporting EPA's analysis of Inland flowing waters in South Florida. The paths below show how to access these data on the data docket:

3) South Florida > 0) Data Sources - This folder provides primary data sources used in the South Florida analyses: IWR Run 40 and DBHydro.

3) South Florida > 1) GIS –Assorted GIS files used in analyses supporting the South Florida Inland criteria development.

3) South Florida > 2) DPV - This folder provides additional information supporting EPA's development of DPVs in South Florida. Files with a prefix of "Ref_Cond" are related to EPA'sapplication of the reference condition approach and those with "South Florida DPV NutrientSalinity Regression" are related to developing a nutrient-salinity regression model.

3) South Florida > 3) Inland - This folder provides additional information supporting EPA's analysis of Inland flowing waters in South Florida. It includes data files combined from SFWMD's DBHydro and IWR Run 40, information supporting site validation (e.g., making sure site is on a Class III water), and data selection for various analyses including the bloom frequency.

4) Economic Analysis. The data files in the Economic Analysis section consist of GIS shapefiles used in the development of the economic analysis. The paths below show how to access these data on the data docket:

4) Economic Analysis – This folder contains three subfolders with five shapefiles reflecting the HUC and WBID GIS files for incremental and baseline impaired waters and the land use data used in the economic analysis.