"TABLE_NAME" "SAMPLE_TYPE" "COLUMN_NAME" "LABEL" "LEGAL_VALUES" "RANGE_HIGH" "RANGE_LOW" "VAR_TYPE" "tblSOILPROFILE" "SOIL_PROF" "A1" "A1- Histosol (A-U)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "A10" "A10 - 2 cm Muck (M, N)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "A11" "A11 - Depleted Below Dark Surface (A-U)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "A12" "A12 - Thick Dark Surface (A-U)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "A16" "A16 - Coast Prairie Redox (T)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "A2" "A2 - Histic Epipedon (A-U)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "A3" "A3 - Black Histic (A-U)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "A4" "A4 - Hydrogen Sulfide (A-U)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "A5" "A5 - Stratified Layers (C, F, K-U)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "A6" "A6 - Organic Bodies (P, T, U)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "A7" "A7 - 5 cm Mucky Mineral (P, T, U)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "A8" "A8 - Muck presence (U)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "A9" "A9 - 1 cm Muck (D, F, G, H, P, T)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "ALTERNATE_CORNER" "The Veg Plot corner to which the alternate Soil Plot location is nearest" "|NW|NE|SW|SE" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "ALTERNATE_VEG_PLOT" "The Veg Plot to which the alternate Soil Plot location is nearest" "|1|2|3|4|5" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "BEARING" "Magnetic N bearing to nearest Veg Plot from Alternate Soil Plot location" "" "360" "0" "NUMERIC" "tblSOILPROFILE" "SOIL_PROF" "COLOR_CHANGE" "Soil color for the soil changed after exposure to air at the depth at which the initial reading was made" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "COLOR_DEPTH" "Depth at which initial color reading was made" "" "100" "0" "NUMERIC" "tblPOINTVERIFICATION" "PTVER" "DATE_COL" "Date site was visited" "" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "DISTANCE" "Distance of Soil Plot from nearest Veg Plot corner" "" "30" "0" "NUMERIC" "tblSITEDATA" "DESIGN" "EVAL_CAT" "Site evaluation category from crew" "tblSOILPROFILE" "SOIL_PROF" "F1" "F1 - Loamy Mucky Mineral (A-M, O)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "F10" "F10 - Marl (U)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "F11" "F11 - Depleted Ochric (T)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "F12" "F12 - Iron-Maganese (N, P, T)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "F13" "F13 - Umbric Surface (N, P, T)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "F16" "F16 - High Plains Depressions (H)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "F17" "F17 - Delta Ochric (T)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "F19" "F19 - Piedmont Flood Plain Soils (S)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "F2" "F2 - Loamy Gleyed Matrix (A-U)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "F20" "F20 - Anomalus Bright Loamy Soils (S, T)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "F3" "F3 - Depleted Matrix (A-U)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "F6" "F6 - Redox Dark Surface (A-U)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "F7" "F7 - Depleted Dark Surface (A-U)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "F8" "F8 - Redox Depression (A-U)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "FIPS_CODE" "County FIPS code" "" "CHARACTER" "tblCOMMENTS" "SOIL_PROF" "HYDRIC_COMMENT" "Flag/comment for Hydric Soil Field Indicator" "tblSOILPROFILE" "SOIL_PROF" "IMPENETRABLE_BEDROCK" "Impenetrable layer (Bedrock) encountered while digging and which prevents sampling to 100 cm" "|BEDROCK" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "IMPENETRABLE_BOULDER" "Impenetrable layer (Boulder) encountered while digging and which prevents sampling to 100 cm" "|BOULDER" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "IMPENETRABLE_CEMENT" "Impenetrable layer (Cemented layer) encountered while digging and which prevents sampling to 100 cm" "tblSOILPROFILE" "SOIL_PROF" "IMPENETRABLE_CLAY" "Impenetrable layer (Clay) encountered while digging and which prevents sampling to 100 cm" "|CLAY" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "IMPENETRABLE_OTHER" "Impenetrable layer encountered (Other) while digging and which prevents sampling to 100 cm" "OTHER:.+" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "INITIAL_CHROMA" "For inundated or saturated soil, initial color of soil - CHROMA" "|0|1|2|3|4|6|8" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "INITIAL_HUE" "For inundated or saturated soil, initial color of soil - HUE" "|5R|7.5R|10R|2.5YR|5YR|7.5YR|10YR|2.5Y|5Y|10Y|5GY|10GY|5G|5BG|10BG|5B|10B|5PB|N" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "INITIAL_VALUE" "For inundated or saturated soil, initial color of soil - VALUE" "|2|2.5|3|4|5|6|7|8" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "INUNDATED_SOIL" "Presence of inundated or saturated soil in pit immediately after soil pit is excavated" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "LIGHTING" "Lighting conditions while soil profile was being described" "|BRIGHT|DAPPLED|OVERCAST|SHADED" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "LRR" "Land Resource Region" "tblSOILPROFILE" "SOIL_PROF" "MAP_UNIT_KEY" "Soil Map Unit Key; unique identifier of soil map unit in SSURGO" "" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "NO_HYDRIC_OBSERVED" "No Hydric Soil Field Indicator observed" "|Y" "tblSOILPROFILE" "SOIL_PROF" "NRCS_INTENSIFICATION_STUDY" "Sample location NCRS sampled as part of NCRS Intensification study" "|NWCA_SOIL_PIT|AA" "CHARACTER" "tblSITEDATA" "DESIGN" "NWCA_ECO5" "NWCA 2016 aggregated Omernik ecoregions" "tblSOILPROFILE" "SOIL_PROF" "OXIDIZED_CHROMA" "For inundated or saturated soil, color of soil after oxidation - CHROMA" "|0|1|2|3|4|6|8" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "OXIDIZED_HUE" "For inundated or saturated soil, color of soil after oxidation - HUE" "|5R|7.5R|10R|2.5YR|5YR|7.5YR|10YR|2.5Y|5Y|10Y|5GY|10GY|5G|5BG|10BG|5B|10B|5PB|N" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "OXIDIZED_VALUE" "For inundated or saturated soil, color of soil after oxidation - VALUE" "|2|2.5|3|4|5|6|7|8" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "PIT_DEPTH" "Soil pit depth (depth of profile description)" "" "100" "0" "NUMERIC" "tblSOILPROFILE" "SOIL_PROF" "PIT_LESS_1M" "Reason soil pit is less the 100 cm" "|SATURATED|IMPENETRABLE|OTHER" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "PLOT_LOCATION" "Placement of soil plot" "|STANDARD|ALTERNATE" "CHARACTER" "PUBLICATION_DATE" "Date the dataset was published to the NARS site" "tblSOILPROFILE" "SOIL_PROF" "REVIEW_OF_SOIL_PROFILE" "Review of soil profile and designation of horizon names" "|NRCS_SOIL_SCIENTIST|OTHER_SOIL_SCIENTIST|REVIEW_LATER" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "S1" "S1 - Sandy Mucky Mineral (A-O, R, S)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "S2" "S2 - 2.5 cm Mucky Peat or Peat (G, H)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "S4" "S4 - Sandy Gleyed Matrix (A-U)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "S5" "S5 - Sandy Redox (A-U)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "S6" "S6 - Stripped Matrix (A-U)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "S7" "S7 - Dark Surface (N, P, R-U)" "|Y" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "S9" "S9 - Thick Dark Surface (R-U)" "|Y" "CHARACTER" "tblPOINTVERIFICATION" "PTVER" "SITE_ID" "NWCA Site ID" "" "CHARACTER" "tblPOINTVERIFICATION" "PTVER" "SITESAMP" "Original site is sampleable" "|Y|N" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "SOIL_LAT" "Soil plot latitude" "" "99.2" "24.5" "NUMERIC" "tblSOILPROFILE" "SOIL_PROF" "SOIL_LON" "Soil plot longitude" "" "-67.6" "-161.07" "NUMERIC" "tblSOILPROFILE" "SOIL_PROF" "STANDARD_CORNER" "The Veg Plot corner to which the Soil Plot is nearest" "|NW|NE|SW|SE" "CHARACTER" "tblSOILPROFILE" "SOIL_PROF" "STANDARD_VEG_PLOT" "The Veg Plot to which the Soil Plot is nearest" "|1|2|3|4|5" "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" "tblSOILPROFILE" "SOIL_PROF" "SULFIDE_ODOR" "Detection of hydrogen sulfide odor upon excavation" "|Y" "" "tblSOILPROFILE" "SOIL_PROF" "SURFACE_WATER_DEPTH" "Water table depth below surface (negative) or height above surface (positive)" "" "+100" "-125" "NUMERIC" "tblSOILPROFILE" "SOIL_PROF" "TIME_EXCAVATION" "Time on 24 clock when soil pit was excavated" "" "2100" "500" "NUMERIC" "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" "tblPOINTVERIFICATION" "PTVER" "VISIT_NO" "Visit Number" "|R|1|2" "CHARACTER" "tblCOMMENTS" "SOIL_PROF" "WATER_COMMENT" "Comment associated with depth to water table" "tblSOILPROFILE" "SOIL_PROF" "WATER_LEVEL" "Water table level determination method" "|STANDING_WATER|SATURATION|NO_WATER" "NUMERIC"