SAMPLE_TYPE PARAMETER LABEL LEGAL_VALUES RANGE_LOW RANGE_HIGH BERW BENT_MMI_COND Condition class based on benthic MMI score Good|Fair|Poor|Not Assessed BERW MMI_BENT Benthic MMI score Good|Fair|Poor|Not Assessed 0 100 BERW OE_COND Condition class based on O/E score <0.5|<0.8|<0.9|>=0.9 BERW OE_SCORE O/E score for benthic sample 0 BETB BENT_MMI_COND Condition class based on benthic MMI score Good|Fair|Poor|Not Assessed BETB MMI_BENT Benthic MMI score Good|Fair|Poor|Not Assessed 0 100 BETB OE_COND Condition class based on O/E score <0.5|<0.8|<0.9|>=0.9 BETB OE_SCORE O/E score for benthic sample 0 FISH FISH_MMI_COND "Fish assemblage condition, based on regional Fish MMI." Good|Fair|Poor|Not Assessed|Insufficient Sampling|No Data MICX MICX_COND Microcystin condition class <= 8 ug/L|> 8 ug/L|Not Detected PHAB BEDSED_COND "Bed sediment condition, based on log relative bed stability (LRBS_use)" Good|Fair|Poor|Not Assessed PHAB INSTRMCVR_COND "Instream cover condition, based in log natural fish cover (L_XFC_NAT)" Good|Fair|Poor|Not Assessed PHAB RIPDIST_COND "Riparian disturbance condition, based on W1_HALL" Low|Medium|High|Not Assessed PHAB RIPVEG_COND "Riparian vegetation condition, based on L_XCMGW" Good|Fair|Poor|Not Assessed FISH MMI_FISH Traditional MMI watershed adjusted value for MMI_FISH ENTE ENT_1X_CCE_100ML "Estimated enterococci CCE / 100 mL of water sample volume from ORD analysis of undiluted DNA extracts and CCE / extract calculations from EPA Method 1609 calculation spreadsheet. CCE are based on 15:1 calibrator target sequence equivalent (CSE) to CCE ratio established for RWQC guideline values. CCE / extract was multiplied by 100 ÷ filtered sample volume to obtain final estimate /100 ml. \QC fail\"" denotes analysis results that did not meet Method 1609 control assay acceptance criteria.""" ENTE ENT_1X_STV_COND Estimated enterococci CCE / 100 mL of water sample volume from ORD analyses of undiluted DNA extract and calculations from EPA Method 1609 calculation spreadsheet exceeds (1) or is less than (0) RWQC STV value of 1280 CCE/100 mL. PHAB L_XCMGW Log10(XCMGW + 0.01 PHAB L_XFC_NAT Log10(XFC_NAT + 0.01) DESIGN AG_ECO3_NM NARS 3-level reporting region Name Text names DESIGN AG_ECO9_NM NARS 9-level reporting region Name Text names DESIGN EPA_REG EPA Region Region_1 | Region_2 | Region_3 | Region_4 | Region_5 | Region_6 | Region_7 | Region_8 | Region_9 | Region_10 DESIGN FS_EW Eastern or western US Forest Service land East | West | blank if not US Forest Service land DESIGN LAT_DD83 Latitude (based on NAD83 datum) for stream site from NHD-based sample frame. Numeric DESIGN LON_DD83 Longitude (based on NAD83 datum) for stream site from NHD-based sample frame. Numeric DESIGN MAJ_BAS_NM Major USGS Hydrologic Basins derived from NHDPlus Names Text of 16 basin names DESIGN MISS_BASIN_NM Mississippi basin name Ohio Region|Tennessee Region|Upper Mississippi Region|Lower Mississippi Region|Lower Missouri Region|Upper Missouri Region|Arkansas-White-Red Region DESIGN NARS_OWN Land ownership category used by NARS Text of 13 land ownership category names DESIGN NRS13_EVAL NRSA 2013/14 site evaluation result. Text DESIGN NRS13_MDC Multi-density categories used in NRSA 2013/14 survey design within a stratum Text DESIGN NRS13_PNL NRSA 2013/14 Panel Assignment "Text that has form NRSnn_mmXXXn_YYYY, where nn is current cycle year (07, 12, 17, etc), mm is cycle year stream site was first selected for sampling, XXXn denotes revisit status, and YYYY denotes base or over sample status. XXXN equals either RVT2 (if site should be visited twice in current cycle year) or RVT (if site should be visited once in current cycle and was previously visited in a prior cycle year) and is blank otherwise. YYYY is either blank (if the stream site is a base site) or equals OverSamp (if the stream site is an over sample site). Note: For state specific designs, state two letter code is added." DESIGN NRS13_SF Lake included/excluded from NRSA 2013/14 survey design Exclude|Include | Not Present Blank values are not allowed or NA for missing DESIGN NRS13_STRA Strata used in NRSA 2013/14 survey design Text DESIGN NRS13_TNT NRS 2013/14 target status assigned based on stream site evaluation for use in national assessments. Target | Target_Presumed |Uncertain | Non_Target | Not_Needed | blank DESIGN NRS13_URBN Stream site identified as an urban or non-urban stream. Source: https://www.census.gov/geo/maps-data/data/cbf/cbf_ua.html. Used 2015 Urban Areas cartographic boundaries shapefile NonUrban|Urban DESIGN NRS13_VST Number of times NRSA 2013/14 site was actually sampled in 2013/14 Zero | One | Two Blank is site not evaluated DESIGN STRAH_CAT Strahler category used to classify reaches. RiversMajor (5th and higher) RiversOther (5th and higher) LargeStreams (3rd and 4th) SmallStreams (1st and 2nd) RiversMajor | RiversOther | LargeStreams | SmallStreams DESIGN XCOORD x-coordinate from US Contiguous Albers Equal Area Conic projection EXCEPT Hawaii sites which are calculated from Hawaii Albers Equal Area Conic projection Numeric DESIGN YCOORD y-coordinate from US Contiguous Albers Equal Area Conic projection EXCEPT Hawaii sites which are calculated from Hawaii Albers Equal Area Conic projection Numeric FIELDMEAS PH PH 1 14 LANDSCAPE LAT_DD83 Latitude in decimal degrees NAD83 LANDSCAPE LON_DD83 Longitude in decimal degrees NAD83 LANDSCAPE SITE_ID Unique Site ID assigned for NRSA13-14 PERI SITE_ID NRSA site id as used on sample label VERIF DATE_COL Date of data collection in field VERIF SITE_ID Site ID VERIF VISIT_NO Number identifying which visit this is |1|2 VERIF YEAR Year of site visit. 2015 2013 UID Unique site visit ID DATE_COL Date of data collection in field SITE_ID Site ID VISIT_NO Number identifying which visit this is PUBLICATION_DATE Date of data file publication MERCURY_FLAG NARS flag for analyte Mercury MICX_FLAG NARS flag for analyte Microcystin CHEM ANC_COND Site condition class based on acidity None|Episodic|ACID-AMD|ACID-aciddep|ACID-organic|No Data CHEM NTL_COND Site condition class based on total nitrogen concentration Good|Fair|Poor|No Data CHEM PTL_COND Site condition class based on total phosphorus concentration Good|Fair|Poor|No Data CHEM SAL_COND Site condition class based on conductivity Good|Fair|Poor|No Data FPLG HG_COND Site condition class based on mercury concentration in fish tissue Does Not Exceed 300 mg Hg/g ww|Exceeds 300 mg Hg/g ww|No Data|Not Assessed|No Sample Collected PHAB LRBS_USE "Log relative bed stability to use in assessing BEDSED_COND, filled in from other variables as needed" PHAB W1_HALL Human Disturbance Index(distance-wtd tally of types and presence used for condition PHab boatable: human disturbance W1_HALL Human Disturbance Index(distance-wtd tally of types and presence PHab wadeable: human disturbance W1_HALL Human Disturbance Index(distance-wtd tally of types and presence FPLG MERCURY_MDL Minimum Detection Limit for Mercury in Fish Tissue - NG/G FPLG MERCURY_RESULT Result for Mercury in Fish Tissue - NG/G FPLG MERCURY_RL Reporting Limit for Mercury in Fish Tissue - NG/G MICX MICX_MDL Minimum Detection Limit for Microcystin - UG/L MICX MICX_RESULT Result for Microcystin - UG/L MICX MICX_RL Reporting Limit for Microcystin - UG/L CHEM ANC Acid Neutralizing Capacity - MG N/L CHEM COND Conductivity - US/CM AT 25 C CHEM PH pH - STD. UNITS CHEM NTL_UG_L Total Nitrogen - UG N/L CHEM PTL Total Phosphorus - UG/L CHEM DOC Dissolved Organic Carbon - MG/L FPLL MERCURY_DATA_FLAG Laboratory or OW flag of result for Mercury FPLG MERCURY_DATA_FLAG Laboratory or OW flag of result for Mercury FPLL MERCURY_COMMENT Comment to indicate reason mercury data not used in assessment FPLG MERCURY_COMMENT Comment to indicate reason mercury data not used in assessment DESIGN WGT_EXT_SP Length of sampled streams represented by site in km