"TABLE_NAME"	"SAMPLE_TYPE"	"COLUMN_NAME"	"LABEL"	"LEGAL_VALUES"	"RANGE_HIGH"	"RANGE_LOW"	"VAR_TYPE"
"tblASSEWQ"	"ASSEWQ"	"CLARITY_CLEAR"	"Water is clear"	"|CLEAR"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"CLARITY_MILKY"	"Water is milky"	"|MILKY"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"CLARITY_OTHER"	"Other clarity condition(s) defined"	""			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"CLARITY_STAINED"	"Water is stained"	"|STAINED"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"CLARITY_TURBID"	"Water is turbid"	"|TURBID"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"COLOR_BLACK"	"Substrate color is black"	"|BLACK"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"COLOR_BROWN"	"Substrate color is brown"	"|BROWN"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"COLOR_GRAY"	"Substrate color is gray"	"|GRAY"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"COLOR_OTHER"	"Other substrate color(s) defined"	"|OTHER.+"			"CHARACTER"
		"COND_COMMENT"	"Comments associated with conductivity measurement in AA"				
"tblASSEWQ"	"ASSEWQ"	"CONDUCTIVITY"	"Conductivity by surface water field probe"	""	"15000"	"1"	"NUMERIC"
"tblPOINTVERIFICATION"	"PTVER"	"DATE_COL"	"Date site was visited"	""			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"DO"	"Dissolved oxygen by surface water field probe"	""	"98.3"	"0.1"	"NUMERIC"
		"DO_COMMENT"	"Comments associated with dissolved oxygen measurement in AA"				
"tblSITEDATA"	"DESIGN"	"NWCA_ECO5"	"NWCA 2016 aggregated Omernik ecoregions"				
"tblASSEWQ"	"ASSEWQ"	"PH"	"pH by surface water field probe"	""	"10"	"3.7"	"NUMERIC"
		"PH_COMMENT"	"Comments associated with pH measurement in AA"				
		"PUBLICATION_DATE"	"Date the dataset was published to the NARS site"				
		"SAMPLE_TYPE"	"Code identifying sample type"				
"tblPOINTVERIFICATION"	"PTVER"	"SITE_ID"	"NWCA Site ID"	""			"CHARACTER"
"tblPOINTVERIFICATION"	"PTVER"	"SITESAMP"	"Original site is sampleable"	"|Y|N"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"SMELL_ALGAE"	"Water smells like algae"	"|ALGAE"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"SMELL_CHEMICAL"	"Water has chemical odor"	"|CHEMICAL"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"SMELL_FISHY"	"Water smells fishy"	"|FISHY"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"SMELL_NONE"	"Water has no odor"	"|NONE"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"SMELL_OTHER"	"Other water odor(s) defined"	""			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"SMELL_ROTTEN"	"Water smells like rotten vegetation"	"|ROTTEN"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"SMELL_SULPHUR"	"Water smells like sulfur"	"|SULPHUR"			"CHARACTER"
"tblPOINTVERIFICATION"	"PTVER"	"STATE"	"State in which site is located"	"AK|AL|AR|AZ|CA|CO|CT|DC|DE|FL|GA|HI|IA|ID|IL|IN|KS|KY|LA|MA|MD|ME|MI|MN|MO|MS|MT|NC|ND|NE|NH|NJ|NM|NV|NY|OH|OK|OR|PA|RI|SC|SD|TN|TX|UT|VA|VT|WA|WI|WV|WY"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"SUB_COBBLE"	"Substrate is cobble"	"|COBBLE"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"SUB_GRAVEL"	"Substrate is gravel"	"|GRAVEL"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"SUB_MINERAL"	"Sustrate is mineral soil"	"|MINERAL"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"SUB_MUCK"	"Substrate is muck"	"|MUCK"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"SUB_ORGANIC"	"Substrate is organic"	"|ORGANIC"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"SUB_OTHER"	"Other substrate type(s) defined"	""			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"SUB_SAND"	"Substrate is sand"	"|SAND"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"SUB_SHELLHASH"	"Substrate is shellhash"	"|SHELLHASH"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"SURFACE_ALGAE"	"Algal bloom on water surface"	"|ALGAE_BLOOM"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"SURFACE_FILM"	"Film on water surface"	"|FILM"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"SURFACE_FLOC"	"Floc on water surface"	"|FLOC"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"SURFACE_OTHER"	"Other water surface(s) defined"	""			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"SURFACE_SHEEN"	"Sheen on water surface"	"|SHEEN"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"SURFACE_VEGETATION"	"Floating aquatic vegetation on water surface"	"|VEGETATION"			"CHARACTER"
		"SW_AA_COMMENT"	"Comments associated with surface water measurements of AA"				
		"SW_CHAR_COMMENT"	"Comments associated with characteristics of AA surface water"				
"tblASSEWQ"	"ASSEWQ"	"SW_COVERAGE"	"Percent of AA covered with surface water"	""	"100"	"0"	"NUMERIC"
"tblASSEWQ"	"ASSEWQ"	"SW_DEPTH_MAX"	"Maximum Depth of surface water"	""	"99"	"0"	"NUMERIC"
"tblASSEWQ"	"ASSEWQ"	"SW_GREATER_1M"	"Surface water > 100cm"	"|Y|N"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"SW_SAMPLEABLE"	"Sampleable water"	"|Y|N"			"CHARACTER"
		"SW_TYPE_COMMENT"	"Comments associated with type of surface water in AA"				
"tblASSEWQ"	"ASSEWQ"	"TEMP"	"Water temperature by surface water field probe"	""	"37.1"	"0.3"	"NUMERIC"
		"TEMP_COMMENT"	"Comments associated with temperature measurement in AA"				
"tblASSESSMENT"	"ASSECHAR"	"TIDAL"	"Hydrogeomorphic Type - Subclass of TIDAL"	"|HUMAN_ALTERED|NATURAL"			"CHARACTER"
		"UID"	"Unique identifier for the site/visit"				
"tblPOINTVERIFICATION"	"PTVER"	"VALXSITE"	"The categorical value representing site conditions for the one XSTATUS category applicable to the site"	"|EW|EH|PRLEM|PRLSS|PRLFO|PRLUBAB|PRLF|TEMP_NONSAMP|INACCESS_TEMP|DENIED|INACCESS_PERM|AREA|SIZE|HGM|NONWETLAND|NONTARGET|ACTIVE_CROP|AG_AQUA|INUNDATED|OTHER_NONSAMP"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"VEG_PRESENT"	"Vegetation is present in water"	"|Y|N"			"CHARACTER"
"tblPOINTVERIFICATION"	"PTVER"	"VISIT_NO"	"Visit Number"	"|R|1|2"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"WATER_PRESENCE"	"Surface water"	"|Y|N"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"WATER_SOURCE"	"Salinity of water: freshwater, brackish, saline"	"|FRESH|BRACKISH|SALINE"			"CHARACTER"
"tblASSEWQ"	"ASSEWQ"	"WATER_TYPE"	"Predominant water feature type"	"PONDED|LAKE|CHANNEL|BACKWATER|OTHER"			"CHARACTER"
"ASSEWQ"	"ASSEWQ"	"WATER_TYPE_OTHER"	"Description of predominant water feature if OTHER selected."