"Description of attributes in the sheet ""predictions_modelB"""
"Note: SPARROW model predictions for river basins in central and northern Florida (the Oklawaha, Crystal, Lower Sante Fe, Lower Suwanee, St. Marks, and Chipola River basins) are presented but are considered less reliable due to unmodeled nitrogen flux to and from the underlying regional aquifer. Accuracy of model predictions for the St. Johns River basin may be affected by inadequate representation of the hydrologic network by the ERF1_2 digital segmented network used in the model."
Attribute name Description
"Reach network attributes (additional information provided in Hoos et al, 2008)"
MRB_ID "Unique reach/catchment identification (integer) for the SAGT ERF1_2 segmented network; this attribute corresponds with the attribute MRB_ID in both the vector coverage of reach segments and the polygon coverage of catchments. Values in the range of 80,000-90,000 indicate shoreline reaches."
wshed_i "Secondary reach/catchment identification (integer) for the SAGT ERF1_2 segmented network; this attribute corresponds with the attribute wshed (or e2rf1##) in both the vector coverage of reach segments and the polygon coverage of catchments. Values in the range of 80,000-90,000 indicate shoreline reaches."
rchtype Reach-type indicator (0=river reach; 1=reservoir reach; 2=reservoir reach outlet)
headflag Headwater reach flag (0=non-headwater reach; 1=headwater reach)
termflag "Terminal reach flag (1=coastal terminus of stream network; 2=reach not connected to the coast: an interior terminus such as a sinking stream or a waterway with no net flow; 3=shoreline reach). Use of the termflag code to summarize loading to estuaries is explained in the sheet ""ListofEstuaries""."
pname RF1 reach name
rr RF1-based reach identifier (8-digit HUC plus 3)
HUC Hydrologic Unit Code - 8 digit
edacode "Code identifying the target estuary that receives drainage from this reach. Code identification and use of these codes to summarize loading to each target estuary is explained in the sheet ""ListofEstuaries""."
rchtot Reach water time of travel (computed as quotient of reach length and reach mean annual stream velocity); used to estimate first-order contaminant decay
meanq Mean annual streamflow; value of -9999.00 indicates no flow (shoreline and a few interior reaches)
DA_Tot_km2 "Area of total upstream drainage basin, in square kilometers"
DA_Inc_km2 "Area of incremental watershed, in square kilometers"
"Monitored load, used to calibrate models (additional station information provided in Hoos et al, 2008)"
ObsLd_kg "Observed (monitored) load, in kilograms (populated only for reaches with associated monitoring station)"
station_id "Identifier for monitoring station assigned by monitoring agency, e.g. downstream order number for USGS stations"
station_name Monitoring station name
"SPARROW model predictions, from nonlinear least squares estimation. A bootstrapping procedure was used to develop the estimates of associated error and confidence intervals (Schwarz and others, 2006)."
"SPARROW model predictions (model B) of instream load, yield, and concentration "
TotLd_kg "Instream load transported past the downstream end of the reach, in kilograms (for monitored reaches, predicted load is adjusted to match observed load)"
TotYld_kgha "Instream load expressed as yield from total upstream area, in kilograms per hectare"
Conc_mg "Concentration in the stream reach, milligrams per liter"
CIHighLd_kg "Upper bound of 90% confidence interval for instream load prediction, in kilograms"
CILowLd_kg "Lower bound of 90% confidence interval for instream load prediction, in kilograms"
StErrLd "Standard error of total instream load prediction, percent (close to zero for monitored reaches) "
CIHighYld_kgha "Upper bound of 90% confidence interval for instream yield prediction, in kilograms per hectare"
CILowYld_kgha "Lower bound of 90% confidence interval for instream yield prediction, in kilograms per hectare"
"SPARROW model predictions (model B) of delivery factor, and of load and yield delivered to the stream reach from the adjacent incremental catchment, termed incremental load and yield"
deliv_factor "Delivery variation factor or DVF represents the model-estimated variation across catchments in landscape delivery ratio, which is the ratio of mass delivered to the stream channel to the measured input to catchment). Landscape delivery ratio is calculated as the product of DVF and source coefficient for each land-applied source. "
IncLd_kg "Load added from the incremental watershed to the stream channel, in kilograms"
IncYld_kg "Yield added from the incrementalwatershed to the stream channel, in kilograms per hectare"
CIHighIncLd_kg "Upper bound of 90% confidence interval for prediction of load added from the incremental watershed, in kilograms"
CILowIncLd_kg "Lower bound of 90% confidence interval for prediction of load added from the incremental watershed, in kilograms"
CIHighIncYld_kgha "Upper bound of 90% confidence interval for prediction of load yield from the incremental watershed, in kilograms per hectare"
CILowIncYld_kgha "Lower bound of 90% confidence interval for prediction of load yield from the incremental watershed, in kilograms per hectare"
SPARROW model predictions (model B) of load delivered to downstream target from the incremental catchment
FracDelTar "Fraction (of 1.0) of the flux at the downstream node of this reach that is transported through the stream network and ultimately delivered to the basin outlet (the coast or, for reaches in the Tennessee River Basin, the confluence with the Ohio River)"
CIHighFracDelTar Upper bound of 90% confidence interval for fraction (of 1.0) of flux delivered to the basin outlet
CILowFracDelTar Lower bound of 90% confidence interval for fraction (of 1.0) of the flux delivered to the basin outlet
IncTarLd_kg "Portion (load, in kilograms) of incremental load from this catchment that is transported through the stream network and ultimately delivered to the basin outlet (coast) "
IncTarYld_kgha "Portion (yield, in kilograms per hectare) of incremental yield from this catchment that is transported through the stream network and ultimately delivered to the basin outlet (coast). "
Instream load source shares: SPARROW model predictions (model B)
Instream load source shares Part 1: For reaches for which total upstream area is greater than 1425 square kilometers.
"Note: Source shares of instream load for reaches for which total upstream area is smaller than 1425 square kilometers, the average size of a county, are not reported in these columns (rather, these are shown in a separate set of columns that follow, for mapping purposes only. See explanation below for why these are reported separately.)"
Sh_l_Point "Share, in kilograms, of total instream load from wastewater"
Sh_l_AtmDep "Share, in kilograms, of total instream load from atmospheric deposition"
Sh_l_Fert "Share, in kilograms, of total instream load from fertilizer"
Sh_l_Manure "Share, in kilograms, of total instream load from livestock manure"
Sh_l_Urban "Share, in kilograms, of total instream load from urban land (represented by impervious surface area)"
Sh_y_Point "Share, in kilograms per hectare, of total instream yield from wastewater"
Sh_y_AtmDep "Share, in kilograms per hectare, of total instream yield from atmospheric deposition"
Sh_y_Fert "Share, in kilograms per hectare, of total instream yield from fertilizer"
Sh_y_Manure "Share, in kilograms per hectare, of total instream yield from livestock manure"
Sh_y_Urban "Share, in kilograms per hectare, of total instream yield from urban land (represented by impervious surface area)"
Sh_p_Point "Share, in percent, of total instream yield from wastewater"
Sh_p_AtmDep "Share, in percent, of total instream yield from atmospheric deposition"
Sh_p_Fert "Share, in percent, of total instream yield from fertilizer"
Sh_p_Manure "Share, in percent, of total instream yield from livestock manure"
Sh_p_Urban "Share, in percent, of total instream yield from urban land (represented by impervious surface area)"
Instream load source shares Part 2: For reaches for which total upstream area is less than or equal to 1425 square kilometers.
"Note: Source shares for instream load for reaches for which total upstream area is smaller than 1425 square kilometers, the average size of a county, are considered less reliable than estimates for larger reaches and should be used with caution. The scale of reporting (county-level) of ancillary data used to estimate certain model inputs does not permit accurate characterization of input distribution at the scale required for small watersheds."
Caution_Sh_l_Point "For reaches with small upstream area and therefore estimate considered less reliable: Share, in kilograms, of total instream load from wastewater"
Caution_Sh_l_AtmDep "For reaches with small upstream area: Share, in kilograms, of total instream load from atmospheric deposition"
Caution_Sh_l_Fert "For reaches with small upstream area: Share, in kilograms, of total instream load from fertilizer"
Caution_Sh_l_Manure "For reaches with small upstream area: Share, in kilograms, of total instream load from livestock manure"
Caution_Sh_l_Urban "For reaches with small upstream area: Share, in kilograms, of total instream load from urban land (represented by impervious surface area)"
Caution_Sh_y_Point "For reaches with small upstream area: Share, in kilograms per hectare, of total instream yield from wastewater"
Caution_Sh_y_AtmDep "For reaches with small upstream area: Share, in kilograms per hectare, of total instream yield from atmospheric deposition"
Caution_Sh_y_Fert "For reaches with small upstream area: Share, in kilograms per hectare, of total instream yield from fertilizer"
Caution_Sh_y_Manure "For reaches with small upstream area: Share, in kilograms per hectare, of total instream yield from livestock manure"
Caution_Sh_y_Urban "For reaches with small upstream area: Share, in kilograms per hectare, of total instream yield from urban land (represented by impervious surface area)"
Caution_Sh_p_Point "For reaches with small upstream area: Share, in percent**, of total instream yield from wastewater"
Caution_Sh_p_AtmDep "For reaches with small upstream area: Share, in percent**, of total instream yield from atmospheric deposition"
Caution_Sh_p_Fert "For reaches with small upstream area: Share, in percent**, of total instream yield from fertilizer"
Caution_Sh_p_Manure "For reaches with small upstream area: Share, in percent**, of total instream yield from livestock manure"
Caution_Sh_p_Urban "For reaches with small upstream area: Share, in percent**, of total instream yield from urban land (represented by impervious surface area)"
**Note: source shares in percent may not sum exactly to 100 due to rounding
Loading (source shares) to stream from adjacent incremental catchment area: SPARROW model predictions (model B)
"Note: Because the scale of reporting (county-level) of ancillary data used to estimate certain model inputs does not permit accurate characterization of input distribution at the scale required for small watersheds, estimates of source shares for incremental catchment areas (smaller than a county) should be used with caution."
Caution_Inc_Sh_y_Point "Share, in kilograms per hectare, of incremental watershed yield from incremental wastewater"
Caution_Inc_Sh_y_AtmDep "Share, in kilograms per hectare, of iincremental watershed yield from incremental atmospheric deposition"
Caution_Inc_Sh_y_Fert "Share, in kilograms per hectare, of incremental watershed yield from incremental fertilizer"
Caution_Inc_Sh_y_Manure "Share, in kilograms per hectare, of incremental watershed yield from incremental livestock manure"
Caution_Inc_Sh_y_Urban "Share, in kilograms per hectare, of incremental watershed yield from incremental urban land (represented by impervious surface area)"
Caution_Inc_Sh_p_Point "Share, in percent**, of incremental watershed yield from incremental wastewater"
Caution_Inc_Sh_p_AtmDep "Share, in percent**, of incremental watershed yield from incremental atmospheric deposition"
Caution_Inc_Sh_p_Fert "Share, in percent**, of incremental watershed yield from incremental fertilizer"
Caution_Inc_Sh_p_Manure "Share, in percent**, of incremental watershed yield from incremental livestock manure"
Caution_Inc_Sh_p_Urban "Share, in percent**, of incremental watershed yield from incremental urban land (represented by impervious surface area)"
**Note: source shares in percent may not sum exactly to 100 due to rounding