TABLE_NAME SAMPLE_TYPE COLUMN_NAME LABEL LEGAL_VALUES RANGE_HIGH RANGE_LOW VAR_TYPE tblASSESSMENT ASSEESTAB AA_AREA Area of the AA (ha) 0.5 0.1 NUMERIC tblASSESSMENT ASSEESTAB AA_CENTER Location of the POINT relative to the Assessment Area |POINT_AACENTER|POINT_NOT_AACENTER CHARACTER AA_EST_COMMENT AA establishment comments AA_GEN_COM_COMMENT General assessment area comments tblASSESSMENT ASSEESTAB AA_LAT "Location of AA center coordinates, latitude dd" 89.272382 24.593419 NUMERIC tblASSESSMENT ASSEESTAB AA_LAT_SHIFTED "Location of shifted POINT coordinates, latitude dd" 99.2 24.5 NUMERIC tblASSESSMENT ASSEESTAB AA_LAYOUT Layout used for the Assessment Area |STANDARD_CIRCULAR|STANDARD_CIRCULAR_SHIFTED|POLYGON|WETLAND_BOUNDARY|POINT_AA_CENTER|POINT_NOT_AA_CENTER CHARACTER tblASSESSMENT ASSEESTAB AA_LON "Location of AA center coordinates, longitude dd" -67.62811 -161.07402 NUMERIC tblASSESSMENT ASSEESTAB AA_LON_SHIFTED "Location of shifted POINT coordinates, longitude dd" -67.6 -161.07 NUMERIC tblASSESSMENT ASSEESTAB AA_POINT Indication that an AA containing the initial design POINT can be established |Y|N CHARACTER tblASSESSMENT ASSEESTAB AA_POINT_SHIFTED Indication that an AA can be established by shifting the initial design POINT (up to 60m) |Y|N CHARACTER tblASSESSMENT ASSEESTAB ACTUAL_DATE Actual date of AA visit tblPOINTVERIFICATION PTVER DATE_COL Date site was visited CHARACTER tblASSESSMENT ASSECHAR HGM_CLASS Hydrogeomorphic class from field visit |DEPRESSION|FLATS|LACUSTRINE|RIVERINE|SLOPE|TIDAL CHARACTER tblASSESSMENT ASSECHAR HGM_SUBCLASS "HGM subclass, based on value of HGM class selected" ARTIFICIAL|BEAVER_IMPOUND|CLOSED|CLOSED_BEAVER_IMPOUND|CLOSED_HUMAN_EXC|CLOSED_HUMAN_EXCIMP|CLOSED_HUMAN_IMPOUND|COMPLEX|HUMAN_ALTERED|LOWER_PERENNIAL|MINERAL|NATURAL|OPEN|OPEN_BEAVER_IMPOUND|OPEN_HUMAN_EXC|OPEN_HUMAN_EXCIMP|OPEN_HUMAN_IMPOUND|ORGANIC|STRATOGRAPHIC|TIDAL|TOPOGRAPHIC|UPPER_PERENNIAL 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 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 UID Unique site visit ID tblSITEDATA DESIGN UNIQUE_ID "Unique site location identifier, if sampled previously" tblPOINTVERIFICATION PTVER VISIT_NO Visit Number |R|1|2 CHARACTER