About this Dataset

Ecological Site Identification, Soil Observations, And Geomorphology Data Collected By The Assessment, Inventory, And Monitoring (AIM) Terrestrial Program Between 2012 And 2021 In The Western United States

This metadata is the documentation for the field soil observations, ecological site identification, and geomorphology characteristics collected by the Assessment, Inventory, and Monitoring (AIM) terrestrial program between 2012 and 2021 in 14 states of the western United States. The AIM program is conducted by the Bureau of Land Management (BLM)’s and provides information to guide site-specific management of ecosystem functions and services. There are 31,267 monitoring plots (79% of plots) with identified ecological sites and 29,228 plots (74% of plots) containing soil morphology descriptions of soil horizons examined in excavated pits. While soil texture class is observed in most soil horizons (98%), rock fragment volume is the soil property with the least data availability (75%). The consistency of soil data (e.g., clay content observations within the ranges of texture classes) increases as a function of time following guidance in soil profile description training for AIM data collectors. Nearly 47% of AIM plots are found on gentle slopes of 0-5% steepness and on Flat/Plain and Hill/Mountain landscape types. The AIM database is a source of georeferenced soil and geomorphology information that can be used for land management and research on land potential, soil geography, and assessment of soil health indicators across the western United States.

Resources in this dataset:

Resource title: Plot characteristics File name: PlotCharacteristics.csv Resource description: Plot characteristics table contains information on GPS coordinates, ecological site ID, and geomorphological settings, such as slope, aspect, landscape type, etc.
Resource title: Soil horizon File name: SoilHorizon.csv Resource description: The soil horizon table has information on soil morphology attributes, such as color, texture class, effervescence, soil structure, etc.
Resource title: Plot characteristics data dictionary File name: PlotCharacteristicsDataDictionary.csv
Resource title: Soil horizon data dictionary File name: SoilHorizonDataDictionary.csv
Resource title: Methods File name: Methods.txt
Organization: Department of Agriculture
Last updated: 2024-03-30T11:28:58.388689
Tags: ars, data-gov, ecological-site-descriptions-esd, geomorphology, landscape-position, np216, soil-depth, soil-morphology, soil-profiles, soil-texture

Tables

PlotCharacteristics

@usgov.usda_gov_ecological_site_identification_soil_observati_132b75b7.plotcharacteristics

2.61 MB
48225 rows
25 columns


CREATE TABLE plotcharacteristics (
  "primarykey" VARCHAR,
  "dbkey" VARCHAR,
  "establishdate" VARCHAR,
  "state_1" VARCHAR,
  "county" VARCHAR,
  "ecolsite" VARCHAR,
  "parentmaterial" VARCHAR,
  "slope" VARCHAR,
  "aspect" VARCHAR,
  "landscapetype" VARCHAR,
  "landscapetypesecondary" VARCHAR,
  "elevation" VARCHAR,
  "esd_investigators" VARCHAR,
  "hillslopetype" VARCHAR,
  "soilseries" VARCHAR,
  "longitude_nad83" DOUBLE,
  "latitude_nad83" DOUBLE,
  "speciesstate" VARCHAR,
  "slopeshapevertical" VARCHAR,
  "slopeshapehorizontal" VARCHAR,
  "mlra" VARCHAR,
  "source" VARCHAR,
  "datevisited" VARCHAR,
  "yearvisited" VARCHAR,
  "state" VARCHAR
);

PlotCharacteristicsDataDictionary

@usgov.usda_gov_ecological_site_identification_soil_observati_132b75b7.plotcharacteristicsdatadictionary

4.6 KB
22 rows
3 columns


CREATE TABLE plotcharacteristicsdatadictionary (
  "field" VARCHAR,
  "alias" VARCHAR,
  "description" VARCHAR
);

SoilHorizon

@usgov.usda_gov_ecological_site_identification_soil_observati_132b75b7.soilhorizon

2.82 MB
123990 rows
48 columns


CREATE TABLE soilhorizon (
  "primarykey" VARCHAR,
  "dbkey" VARCHAR,
  "horizonkey" VARCHAR,
  "horizondepthupper" VARCHAR,
  "horizondepthlower" VARCHAR,
  "depthuom" VARCHAR,
  "horizonname" VARCHAR,
  "rockfragavai" VARCHAR,
  "rockfragments" VARCHAR,
  "texture" VARCHAR,
  "textureavai" VARCHAR,
  "texturemodifier" VARCHAR,
  "ph" VARCHAR,
  "ec" VARCHAR,
  "effervavai" VARCHAR,
  "effervescence" VARCHAR,
  "claycontentavai" VARCHAR,
  "claypct" VARCHAR,
  "sandpct" VARCHAR,
  "structuregrade" VARCHAR,
  "structuresize" VARCHAR,
  "structuretype" VARCHAR,
  "structureavai" VARCHAR,
  "structuregrade2" VARCHAR,
  "structuresize2" VARCHAR,
  "structuretype2" VARCHAR,
  "structurequality" VARCHAR,
  "petrocalcicrubble" VARCHAR,
  "gypsic" VARCHAR,
  "clayfilm" VARCHAR,
  "hue" VARCHAR,
  "coloravai" VARCHAR,
  "value" VARCHAR,
  "chroma" VARCHAR,
  "colormoistdry" VARCHAR,
  "rootsize" VARCHAR,
  "rootqty" VARCHAR,
  "horizonnotes" VARCHAR,
  "siltpct" VARCHAR,
  "fragvolgravel" VARCHAR,
  "fragvolcobble" VARCHAR,
  "fragvolstone" VARCHAR,
  "fragvolnodule" VARCHAR,
  "fragvoldurinode" VARCHAR,
  "fragvolavai" VARCHAR,
  "horizonnumber" BIGINT,
  "source" VARCHAR,
  "yearvisited" BIGINT
);

SoilHorizonDataDictionary 1

@usgov.usda_gov_ecological_site_identification_soil_observati_132b75b7.soilhorizondatadictionary_1

4.19 KB
28 rows
3 columns


CREATE TABLE soilhorizondatadictionary_1 (
  "field" VARCHAR,
  "alias" VARCHAR,
  "description" VARCHAR
);