TABLE_NAME SAMPLE_TYPE COLUMN_NAME LABEL LEGAL_VALUES RANGE_HIGH RANGE_LOW VAR_TYPE tblASSEWQ ASSEWQ CLARITY_CLEAR Water is clear |CLEAR tblASSEWQ ASSEWQ CLARITY_MILKY Water is milky |MILKY tblASSEWQ ASSEWQ CLARITY_OTHER Other clarity condition(s) defined tblASSEWQ ASSEWQ CLARITY_STAINED Water is stained |STAINED tblASSEWQ ASSEWQ CLARITY_TURBID Water is turbid |TURBID tblASSEWQ ASSEWQ COLOR_BLACK Substrate color is black |BLACK tblASSEWQ ASSEWQ COLOR_BROWN Substrate color is brown |BROWN tblASSEWQ ASSEWQ COLOR_GRAY Substrate color is gray |GRAY tblASSEWQ ASSEWQ COLOR_OTHER Other substrate color(s) defined |OTHER.+ tblASSEWQ ASSEWQ CONDUCTIVITY Conductivity by surface water field probe 15000 1 COND_COMMENT Comments associated with conductivity measurement in AA tblPOINTVERIFICATION PTVER DATE_COL Date site was visited CHARACTER tblASSEWQ ASSEWQ DO Dissolved oxygen by surface water field probe 98.3 0.1 DO_COMMENT Comments associated with dissolved oxygen measurement in AA tblSAMPLES CHEM NOT_COLLECTED No CHEM sample collected |Y|N tblASSEWQ ASSEWQ PH pH by surface water field probe 10 3.7 tblSITETRUTH DESIGN 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.""" CHARACTER PUBLICATION_DATE Date of data file publication SAMPLE_TYPE Code identifying sample type tblPOINTVERIFICATION PTVER SITE_ID "Unique Site ID for the study and design cycle sampled. Preferred form is NWCnn_MM-xxxxx where nn is current cycle year (11, 16, 21), MM is two letter state code, and xxxxx is between 10001 and 99999. No missing or \blank\"" values allowed.""" CHARACTER tblASSEWQ ASSEWQ SMELL_ALGAE Water smells like algae |ALGAE tblASSEWQ ASSEWQ SMELL_CHEMICAL Water has chemical odor |CHEMICAL tblASSEWQ ASSEWQ SMELL_FISHY Water smells fishy |FISHY tblASSEWQ ASSEWQ SMELL_NONE Water has no odor |NONE tblASSEWQ ASSEWQ SMELL_OTHER Other water odor(s) defined |OTHER.+ tblASSEWQ ASSEWQ SMELL_ROTTEN Water smells like rotten vegetation |ROTTEN tblASSEWQ ASSEWQ SMELL_SULPHUR Water smells like sulfur |SULPHUR tblSAMPLES CHEM STREAM_WIDTH Channel or stream width where water sample collected for water chemistry tblASSEWQ ASSEWQ SUB_COBBLE Substrate is cobble |COBBLE tblASSEWQ ASSEWQ SUB_GRAVEL Substrate is gravel |GRAVEL tblASSEWQ ASSEWQ SUB_MINERAL Sustrate is mineral soil |MINERAL tblASSEWQ ASSEWQ SUB_MUCK Substrate is muck |MUCK tblASSEWQ ASSEWQ SUB_ORGANIC Substrate is organic |ORGANIC tblASSEWQ ASSEWQ SUB_OTHER Other substrate type(s) defined |OTHER.+ tblASSEWQ ASSEWQ SUB_SAND Substrate is sand |SAND tblASSEWQ ASSEWQ SUB_SHELLHASH Substrate is shellhash |SHELLHASH tblASSEWQ ASSEWQ SURFACE_ALGAE Algal bloom on water surface |ALGAE_BLOOM tblASSEWQ ASSEWQ SURFACE_FILM Film on water surface |FILM tblASSEWQ ASSEWQ SURFACE_FLOC Floc on water surface |FLOC tblSAMPLES CHEM SURFACE_FLOW Surface flow type at time of water sample collection (Flowing/Still) tblASSEWQ ASSEWQ SURFACE_OTHER Other water surface(s) defined |OTHER.+ tblASSEWQ ASSEWQ SURFACE_SHEEN Sheen on water surface |SHEEN tblASSEWQ ASSEWQ SURFACE_VEGETATION Floating aquatic vegetation on water surface |VEGETATION 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 tblASSEWQ ASSEWQ SW_DEPTH_MAX Maximum Depth of surface water 99 0 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 tblASSEWQ ASSEWQ TIDAL Water is tidal or non-tidal |TIDAL|NON_TIDAL UID Unique site visit ID tblSITEDATA DESIGN UNIQUE_ID "Unique site location identifier, if sampled previously" tblASSEWQ ASSEWQ VEG_PRESENT Vegetation is present in water |Y|N tblPOINTVERIFICATION PTVER VISIT_NO Visit Number |R|1|2 CHARACTER tblSAMPLES CHEM WATERBODY_EXTENT Waterbody extent at water collection: entirely within AA or extends outside AA tblSAMPLES CHEM WATERSAMP_DEPTH Depth of CHEM sample tblSAMPLES CHEM WATER_LAT Latitude of CHEM sample 99.2 24.5 tblSAMPLES CHEM WATER_LON Longitude of CHEM sample -67.6 -161.07 tblASSEWQ ASSEWQ WATER_PRESENCE Surface water |Y|N tblASSEWQ ASSEWQ WATER_SOURCE "Salinity of water: freshwater, brackish, saline" |FRESH|BRACKISH|SALINE tblSAMPLES CHEM WATER_TIME Time of CHEM sample 2100 500 tblASSEWQ ASSEWQ WATER_TYPE Predominant water feature type |CHANNEL_STREAM|BACKWATER|LAKE|STANDING|ESTUARINE_TIDAL|OTHER