COLUMN_NAME LABEL LEGAL_VALUES ACID_COND Acidity condition class Good|Fair|Poor|Not Assessed AG_ECO3 "NARS 3-level reporting region (2015), based on aggregating AGGR_ECO9_2015 reporting regions. No missing values allowed." EHIGH|PLNLOW|WMTNS| AG_ECO3_NM NARS 3-level reporting region Name. No missing values allowed. Eastern Highlands|Plains and Lowlands|West| AG_ECO9 "NARS 9-level reporting region (2015), based on aggregated Omernik Level III ecoregions. No missing values allowed." CPL|NAP|NPL|SAP|SPL|TPL|UMW|WMT|XER| AG_ECO9_NM NARS 9-level reporting region Name. No missing values allowed. Coastal Plains|Northern Appalachians|Northern Plains|Southern Appalachians|Southern Plains|Temperate Plains|Upper Midwest|Western Mountains|Xeric| ANC_MDL Method detection limit of Acid Neutralizing Capacity (ueq/L) NA ANC_NARS_FLAG "Flag assigned by NARS for Acid Neutralizing Capacity. ND = Non-detect, L = Estimated, Q = Quality-related issue, S = Shipping time exceedence, H = Holding time exceedence , NR = No lab result for analyte" NA ANC_RESULT Analyte value: acid neutralizing capacity NA AREA_CAT6 Lake area categories (6) used in most NLA survey designs. HAND sites also assigned area category. Based on AREA_HA. No missing values allowed. "(0,1]| (1,4]| (4,10]|(10,20]| (20,50]| >50|" ATRAZINE_MDL Method detection limit NA ATRAZINE_NARS_FLAG "Flag assigned by NARS: ND = Non-detect, L = Estimated, Q = Quality-related issue, S = Shipping time exceedence, H = Holding time exceedence, NR = No lab result for analyte" NA ATRAZINE_RESULT Value of associated parameter NA ATZ_DETECT Atrazine Detection Detected|Not Detected|Not Assessed ATZ_EPA_COND_3.4 Condition based on Atrazine concentration and 3.4 ppb benchmark At or Below Benchmark|Above Benchmark|Not Assessed BENT_MMI_COND_2017 Condition class based on 2017 updated benthic MMI scores Good|Fair|Poor|Not Assessed BFXHORIZDIST_DD horizontal distance to drawdown zone using horiz_dist_dd (mean(horiz_dist_dd)) NA BFXVERTHEIGHT_DD vertical height to drawdown zone using vert_height_dd (mean(vert_height_dd)) NA CHLA_COND "Condition for Chlorophyll a indicator, based on CHLX" NA CHLA_MDL Method detection limit of chlorophyll-a NA CHLA_NARS_FLAG "Flag assigned by NARS for Chlorophyll a. ND = Non-detect, L = Estimated, Q = Quality-related issue, S = Shipping time exceedence, H = Holding time exceedence , NR = No lab result for analyte" NA CHLA_RESULT Analyte value: chlorophyll-a NA COND_MDL Minimum detection limit of analyte for Conductivity NA COND_NARS_FLAG "NARS FLAG. ND = Nondetect; H = holding time issue; S = shipping issue; L = Less than reporting limit but above MDL; Q = other quality issue. See NARS_COMMENT, NR = No lab result for analyte for Conductivity" NA COND_RESULT Analyte value: conductivity NA 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 CYLSPER_MDL Method detection limit for Cylindrospermopsin (ug/L) NA CYLSPER_NARS_FLAG "Flag assigned by NARS for Cylindrospermopsin. ND = Non-detect, L = Estimated, Q = Quality-related issue, S = Shipping time exceedence, H = Holding time exceedence , NR = No lab result for analyte" NA CYLSPER_RESULT Result for Cylindrospermopsin (ug/L) NA DIS_O2_CLS Dissolved oxygen condition class High (>=5 Ppm)|Moderate (>3-<5 Ppm)|Low (<=3 Ppm)|Not Assessed DOC_MDL Method detection limit of dissolved organic carbon NA DOC_NARS_FLAG "Flag assigned by NARS for Dissolved Organic Carbon. ND = Non-detect, L = Estimated, Q = Quality-related issue, S = Shipping time exceedence, H = Holding time exceedence , NR = No lab result for analyte" NA DOC_RESULT Analyte value: dissolved organic carbon NA DO_SURF Dissolved oxygen in top 2 m (mg/L) NA DRAWDOWN_COND Lake level drawdown exposure condition Small|Medium|Large|Not Assessed DRAWDOWN_COND_2CAT_2017 "Drawdown condition, specifially for 2017 survey" Not Large|Large|Not Assessed DSGN_CYCLE NLA survey design time period 2007 | 2012 | 2017 | etc. 2007|2012|2017 ENTEROCOCCI_NARS_FLAG "Flag assigned by NARS: ND = Non-detect, L = Estimated, Q = Quality-related issue, S = Shipping time exceedence, H = Holding time exceedence, NR = No lab result for analyte" NA ENTEROCOCCI_RESULT Value of associated parameter NA ENT_1X_STV_COND "Enterococci condition category, based on comparison of the RESULT to the NARS benchmark of 1280 CCE/100-mL statistical threshold value (STV) from the EPA 2012 Recreational Water Quality Criteria (EPA-820-F-12-058)." Above Benchmark|At or Below Benchmark|Not Assessed EPA_REG EPA Region. No missing values allowed. Region_01|Region_02|Region_03|Region_04|Region_05|Region_06|Region_07|Region_08|Region_09|Region_10| FED_NONFED "Ownership divided into federal and non-federal land, based on OWN_NARS variable" FEDERAL|NON_FEDERAL FRAME07 Lake is included or excluded from sample frame for the NLA 2007 survey design. Blank values are not allowed or NA for missing Exclude|Include| Not Present| FRAME12 Lake is included or excluded from sample frame for the NLA 2012 survey design. Blank values are not allowed or NA for missing. Exclude|Include| Not Present| FRAME17 Lake is included or excluded from sample frame for the NLA 2017 survey design. Blank values are not allowed or NA for missing. Exclude|Include|Not Present IND_DOMAIN "Name of the indicator group or Domain within a study. Standard indicator groups are: EXTENT - which includes all lakes evaluated for a study and BASE - which includes all the lakes that are sampled for the main (""core"") indicators." EXTENT|CORE |HAND|NONE LAKE_ORGN "Lake origin, based on evaluation on map or in field" MAN_MADE|NATURAL|UNCERTAIN|UNKNOWN LAT_DD83 "Latitude (based on NAD83 datum) assigned to lake during site selection from NHD-based sample frame. Generally, but not always, represents centriod of lake polygon in NHD. No missing values allowed." NA LITCVR_COND Shallow water habitat condition class Good|Fair|Poor|Not Assessed LITRIPCVR_COND Lake habitat complexity condition class Good|Fair|Poor|Not Assessed LON_DD83 "Longitude (based on NAD83 datum) assigned to lake during site selection from NHD-based sample frame. Generally, but not always represents centriod of lake polygon in NHD. No missing values allowed." NA LitCvrQc3OE NLA 2012 Shallow water habitat condition indicator NA LitRipCvrQc3OE NLA 2012 Lake habitat complexity condition indicator NA MAJ_BASIN Major USGS Hydrologic Basins derived from NHDPlus codes Text of 16 basin codes from 01 to 18 with 05_06 and 12_13 combined preceeded by letter H H01|H02|H03|H04|H05_06|H07|H08|H09|H10|H11|H12_13|H14|H15|H16|H17|H18 MAJ_BAS_NM Major USGS Hydrologic Basins derived from NHDPlus names Text of 16 basin names 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 MICX_MDL Method detection limit for Microcystin (ug/L) NA MICX_NARS_FLAG "Flag assigned by NARS for Microcystin. ND = Non-detect, L = Estimated, Q = Quality-related issue, S = Shipping time exceedence, H = Holding time exceedence , NR = No lab result for analyte" NA MICX_RESULT Result for Microcystin (ug/L) NA MISS_BASIN "Within Mississippi Basin or outside, based on MAJ_BAS_NM values" MISSISSIPPI_BASIN|NOT_MISSISSIPPI_BASIN MIS_BASIN The hydrologic basin code for lakes in the Mississippi Basin derived from NHDPlus codes or blank for lakes not in the Mississippi Basin Text of 7 basin codes with H10 split into H10L and H10U or blank NA MIS_BAS_NM "The hydrologic basin name for lakes in the Mississippi Basin derived from NHDPlus names, or blank for lakes not in the Mississippi Basin Text of 7 basin names or blank" NA MMI_BENT Benthic MMI score NA MMI_ZOOP_2017 Zooplankton MMI score based on 2017 revision and tow volume corrections. NA NTL_COND Condition class based on total nitrogen Good|Fair|Poor|Not Assessed NTL_MDL Method detection limit for Total Nitrogen (mg N/L) NA NTL_NARS_FLAG "Flag assigned by NARS for Total Nitrogen. ND = Non-detect, L = Estimated, Q = Quality-related issue, S = Shipping time exceedence, H = Holding time exceedence , NR = No lab result for analyte" NA NTL_RESULT Result for Total Nitrogen (mg N/L) NA OWN_NARS Land ownership category 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 values allowed. BLM|DOD|USFS|FWS|Jointly Owned|Local Government|Native American|Non-Governmental Organization| NPS|Other Fed|Private|Regional Agency|State| 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 values allowed." NA PTL_COND Condition class based on total phosphorus Good|Fair|Poor|Not Assessed PTL_MDL Method detection limit for Total Phosphorus (ug/L) NA PTL_NARS_FLAG "Flag assigned by NARS for Total Phosphorus. ND = Non-detect, L = Estimated, Q = Quality-related issue, S = Shipping time exceedence, H = Holding time exceedence , NR = No lab result for analyte" NA PTL_RESULT Result for Total Phosphorus (ug/L) NA PUBLICATION_DATE Date the dataset was published to the NARS site 0 RDIS_COND Lakeshore disturbance condition class Low|Medium|High|Not Assessed RDis_IX NLA 2012 Lakeshore disturbance condition indicator NA RVEG_COND Riparian vegetation condition class Good|Fair|Poor|Not Assessed RVegQc3OE NLA 2012 Riparian vegetation condition indicator NA SITE_ID "The NLA Site ID for the study and year sampled. Preferred form is NLAnn_MM-xxxxx where nn is current cycle year (07, 12, 17, etc), MM is two letter state code, and xxxxx is between 10001 and 99999. No missing values allowed." NA SULFATE_MDL Method detection limit of sulfate NA SULFATE_NARS_FLAG "Flag assigned by NARS for Sulfate. ND = Non-detect, L = Estimated, Q = Quality-related issue, S = Shipping time exceedence, H = Holding time exceedence , NR = No lab result for analyte" NA SULFATE_RESULT Analyte value: sulfate NA TNT_CAT NLA target status assigned based on lake evaluation for use in national assessments Target|Non_Target|None TROPHIC_STATE Trophic state (Oligotrophic/Mesotrophic/Eutrophic/Hypereutrophic) |OLIGOTROPHIC|MESOTROPHIC|EUTROPHIC|HYPEREUTROPHIC UID Unique identifier for the site/visit UNIQUE_ID "Unique site ID based on location that does not depend on year sampled or any other factor. Form is NLA_ss_nnnnn where ss state and nnnnn is number that starts at 10001. No missing or ""blank"" values allowed." NA URBN_NLA07 Lake identified as an urban lake using 2007 definition of Urban. No missing or blank values allowed Urban|Non-Urban| URBN_NLA17 Lake identified as an urban lake using 2017 definition of Urban. No missing or blank values allowed Urban|Non-Urban| URBN_NLA22 "Lake identified as an urban lake using 2022 definition of Urban (HUC12 intersecting Census UAC from 2019). No missing or ""blank"" values allowed." Urban | Non-Urban | WGT_TP NLA adjusted weight for lake when want estimates to be for the Target Population. Includes weight adjustments to account for sites with unknow status and when lake status is known to be target but not sampled. Note: >0 or 0 if site is not to be used for target population estimation NA XCOORD x-coordinate from US Contiguous Albers Equal Area Conic projection EXCEPT Hawaii or Alaska lakes which are calculated from Hawaii or Alaska Albers Equal Area Conic projectionNo missing values allowed. NA YCOORD y-coordinate from US Contiguous Albers Equal Area Conic projection EXCEPT Hawaii or Alaska lakes which are calculated from Hawaii or Alaska Albers Equal Area Conic projection. No missing values allowed. NA ZOOP_MMI_COND_2017 Condition class based on 2017 updated zooplankton MMI scores (following tow volume corrections) Good|Fair|Poor|Not Assessed VISIT_NO Sequential number of visit to site |1|2