COLUMN_NAME	LABEL	LEGAL_VALUES
ACID_COND	"Condition based on ANC, DOC, and sulfate"	Good|Fair|Poor|Not Assessed
AG_ECO3	"NARS 3-level reporting region (2015), based on aggregating AG_ECO9 reporting regions.   No missing or ""blank"" values allowed."	EHIGH|PLNLOW|WMTNS |
AG_ECO9	"NARS 9-level reporting region, based on aggregated Omernik Level III ecoregions.  No missing or ""blank"" values allowed."	CPL|NAP|NPL|SAP|SPL|TPL|UMW|WMT|XER |
ANC_COND	Site condition class based on acidity	None|Episodic|ACID-AMD|ACID-aciddep|ACID-organic|No Data
BEDSED_COND	"Bed sediment condition, based on log relative bed stability (LRBS_use)"	Good|Fair|Poor|Not Assessed
BENT_MMI_COND	Condition class based on benthic MMI score	Good|Fair|Poor|Not Assessed
CYLSPER_DETECT	Cylindrospermopsin Detection	Detected|Not Detected|Not Assessed
CYLSPER_EPA_COND	Cylindrospermopsin condition based on EPA benchmark	Above Benchmark|At or Below Benchmark|Not Assessed
DATE_COL	Date of data collection in field	NA
EPA_REG	"EPA Region.   No missing or ""blank"" values allowed."	Region_01 | Region_02 | Region_03 | Region_04 | Region_05 | Region_06 | Region_07 | Region_08 | Region_09 | Region_10 |
EVAL_CAT	"NRSA site evaluation result. For hand-picked sites evaluation is Target_Sampled.   No missing or ""blank"" values allowed."	NA
FED_NONFED	"Federal or Non-Federal land, based on OWN_NARS. OWN_NARS in FWS, Other Fed, USFS, NPS, NOAA, BLM, DOD, BOR considered Federal and all others Non-Federal."	Federal|Non-Federal
FISH_MMI_COND	"Fish assemblage condition, based on regional Fish MMI."	Good|Fair|Poor|Not Assessed
FS_EW	"Eastern or western US Forest Service land. Not_USFS if not US Forest Service land.  No missing or ""blank"" values allowed."	East | West | Not_USFS |
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
HUC2_NM	"USGS Level 2 Hydrologic Unit Region Name where stream reach is located (based on NHDPlusV2 use of HUCs).  No missing or ""blank"" values allowed."	"Arkansas-Red-White Region |California Region |Great Basin Region |Great Lakes Region |Lower Colorado Region |Lower Mississippi Region |""Lower Missouri Region |Mid-Atlantic Region |New England Region |Ohio Region |Pacific Northwest Region |Rio Grande Region |Souris-Red-Rainy Region |South Atlantic-North Region |South Atlantic-South Region |South Atlantic-West Region |Tennessee Region |Texas Region |Upper Colorado Region |Upper Mississippi Region |Upper Missouri Region |"
INSTRMCVR_COND	"Instream cover condition, based in log natural fish cover (L_XFC_NAT)"	Good|Fair|Poor|Not Assessed
LAT_DD83	"Latitude in decimal degrees (based on NAD83 datum) for stream site  from NHDPlusV2, i.e., ""design latitude."".   No missing or ""blank"" values allowed."	NA
LON_DD83	"Longitude in decimal degrees (based on NAD83 datum) for stream site  from NHDPlusV2, i.e., ""design longitude.""   No missing or ""blank"" values allowed."	NA
MAJ_BAS_NM	"Name of major USGS Hydrologic Basins derived from NHDPlus names.  No missing or ""blank"" values allowed."	Arkansas-White-Red Region | California Region |  Great Basin Region | Great Lakes Region | Lower Colorado Region | Lower Mississippi Region | Mid Atlantic Region | Missouri Region | New England Region | Ohio-Tennessee Region | Pacific Northwest Region | Rio Grande-Texas-Gulf Region | Souris-Red-Rainy Region | South Atlantic Gulf Region | Upper Colorado Region | Upper Mississippi Region |
MICX_DETECT	Microcystin Detection	Detected|Not Detected|Not Assessed
MICX_EPA_COND	Microcystin condition based on EPA benchmark	Above Benchmark|At or Below Benchmark|Not Assessed
MIS_BAS_NM	"The hydrologic basin name for streams in the Mississippi Basin derived from NHDPlus names.  ""Not Miss River Basin"" for streams not in the Mississippi Basin.  No missing values allowed."	Ohio Region|Tennessee Region|Upper Mississippi Region|Lower Mississippi Region|Lower Missouri Region| Upper Missouri Region|Arkansas-Red-White Region|Not Mississippi River Basin
MISS_BASIN	"Within Mississippi Basin or outside, based on MIS_BAS_NM values"	Mississippi_Basin|Not_Mississippi_Basin
NTL_COND	Site condition class based on total nitrogen concentration	Good|Fair|Poor|No Data
OE_COND	Condition class based on O/E score	<0.5|<0.8|<0.9|>=0.9
OWN_NARS	"Land ownership code derived from USGS PADUS (http://gapanalysis.usgs.gov/padus/data/) - pulled May 2016 version of database. Aggregated to categories used by NARS.  Text of 13 land ownership category names. Similar to OWN_TYPE  in USGS PADUS dataset except that Federal_Land is separated into major federal agencies.   No missing or ""blank"" values allowed."	BLM |  DOD | | DOE | USFS | FWS | NOAA | Non Federal | NPS | Tribal Land| USACE | USBR | NRCS| Other Fed
PSTL_CODE	"State two letter postal code for site sampled. 50 state postal codes plus AS, MP, GU, PR, VI for American Samoa, Commonwealth of Northern Marianas, Guam, Puerto Rico and Virgin Islands.  No missing or ""blank"" values allowed."	NA
PTL_COND	Site condition class based on total phosphorus concentration	Good|Fair|Poor|No Data
RIPDIST_COND	"Riparian disturbance condition, based on W1_HALL"	Low|Medium|High|Not Assessed
RIPVEG_COND	"Riparian vegetation condition, based on L_XCMGW"	Good|Fair|Poor|Not Assessed
SAL_COND	Site condition class based on conductivity	Good|Fair|Poor|No Data
SALINITY_CLASS	"Salinity class, based on total salts in sample"	Not Assessed|Freshwater|Slightly Saline|Moderately Saline|Highly Saline
SITE_ID	"Site ID for the study and year sampled.  Preferred form is NRSnn_MM-xxxxx  where  nn is current cycle year (04, 08, 13, 18, etc), MM is two letter state code, and xxxxx is between 10001 and 99999.  No missing or ""blank"" values allowed."	NA
SITESAMP	Was site sampled: Y/N.	|Y|N
STRAH_CAT	"Strahler category used to classify reaches.  SmallStreams – 1st and 2nd order; LargeStreams – 3rd and 4th order; MajorRivers – 5th order and higher that are identified as MajorRiver/Additional in MAJ_RIVER variable;  and OtherRivers – 5th and higher that are not MajorRivers.  No missing or ""blank"" values allowed."	RiversMajor | RiversOther | LargeStreams | SmallStreams |
URBN_NRS18	"Stream  identified as an urban stream based on urban definition used in NRSA 2018-19 design. Urban based on 2010 Census polygons of urban areas. No 3km buffer to ensure census waters included since census polygons now include census waters.  No missing or ""blank"" values allowed."	Urban | Non-Urban |
USFS	"US Forest Service land or other, based on OWN_NARS."	Forest_Service|Not_Forest_Service
VISIT_NO	Number identifying which visit this is	|1|2
WGT_TP	NRSA adjusted weight for site when want estimates to be for the Target Population. Includes weight adjustments to account for sites with unknown status and when site status is known to be target but not sampled. >0 or 0 if site is not to be used for population estimation. Units: miles.	NA
XCOORD	"x-coordinate from US Contiguous Albers Equal Area Conic projection EXCEPT Hawaii sites which are calculated from Hawaii Albers Equal Area Conic projection.   No missing or ""blank"" values allowed. Projection:  clon = -96, clat = 37.5, sp1 = 29.5, sp2 = 45.5"	NA
YCOORD	"y-coordinate from US Contiguous Albers Equal Area Conic projection EXCEPT Hawaii sites which are calculated from Hawaii Albers Equal Area Conic projection.  No missing or ""blank"" values allowed.  Projection: sph = ""GRS80"", clon = -96, clat = 37.5, sp1 = 29.5, sp2 = 45.5"	NA
YEAR	Year of sampling	NA
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.	NA
UID	Unique site visit ID	NA
PUBLICATION_DATE	Date of data file publication	NA
DSGN_CYCLE	NRSA survey design time period 2000-04| 2008-09 | 2013-14 | 2018-19 | etc.  No missing values allowed.	NA
UNIQUE_ID	Unique site ID based on location that does not depend on year sampled or any other factor. Form is NRS_ss_nnnnn  where ss state and nnnnn is number that starts at 10001. No missing values allowed.	NA
