fetchNASIS(from='pedons') Columns

This guide identifies source tables and columns for each column in the fetchNASIS(from='pedons') result. Many data elements have a 1:1 relationship with a table and column in NASIS, these are described in order of alphabetical order of their parent NASIS table.

The parent table physical name, column physical name and column description are reported from the NASIS 7 metadata. Any columns that deviate from the NASIS naming, but are 1:1 with a NASIS column, are flagged Alias="Yes" and have a different fetchNASIS() column name from the physical column name. In the future these will be changed to match the NASIS metadata.

The final set of columns reported in this guide are “calculated”: these are derived from data in NASIS and queries of child tables of site/pedon/horizon, but do not have an analog or corresponding metadata description in NASIS. These column entries have custom descriptions and mention the soilDB functions responsible for generating them.

ecologicalsite

The Ecological Site table records the official list of range and forest ecological sites maintained by NRCS and described in the Ecosystem Dynamics Interpretive Tool (EDIT). This table records only the identifier and name of an ecological site. The complete ecological site characterization resides in the EDIT database. The official list of ecological sites is maintained in EDIT.

fetchNASIS() Column	Alias	Physical Name	Column Description
ecositenm	No	ecologicalsite.ecositenm	The name of an ecological site expressed as the concatenation of a number of underlying individual name components. Due to the size and number of name components, the concatenated name field may not be wide enough to contain the full ecological site name. The Ecological Site Name from ESIS.
ecositeid	No	ecologicalsite.ecositeid	The legacy 11 character long unique identifier for a particular ecological site. It is the concatenated form of the five ecological site ID key fields, ecological site type, ecological site MLRA, ecological site LRU, ecological site number and ecological site state FIPS alpha code.

pedon

The Pedon table contains information collected at the time a soil profile description is made. It has data that relates to the profile as a whole.

fetchNASIS() Column	Alias	Physical Name	Column Description
peiid	No	pedon.peiid	An internal ID (integer) that is part (or all) of a key that uniquely identifies a record. Also known as part (or all) of the “primary key”. This value is managed by NASIS and cannot be edited.
describer	Yes	pedon.descname	Name of person(s) that described the soil.
taxonkind	No	pedon.taxonkind	Identifies the kind of taxonomic unit described. Examples are series and miscellaneous areas.
pedontype	No	pedon.pedontype	Identification of what the description represents in relation to a series, component, etc.
pedonpurpose	No	pedon.pedonpurpose	The identification of the intended purpose of the profile description.
erocl	No	pedon.erocl	Class of accelerated erosion. (SSM)
pedlabsampnum	No	pedon.pedlabsampnum	An identifier for the pedon sample that is assigned by the Kellogg Soil Survey Laboratory. This identifier is used to link the morphological pedon description with the associated measured property values from the laboratory.
pedon_id	Yes	pedon.upedonid	A short label to help a user identify a particular pedon.
tsectstopnum	No	pedon.tsectstopnum	The stop number along the specified transect.
tsectinterval	No	pedon.tsectinterval	The distance between the previous point and the current point in a transect.
labdatadescflag	No	pedon.labdatadescflag	An indicator of whether or not this pedon record is the one certified for distribution with analytical lab results from the Soil Survey Laboratory and other National Cooperative Soil Survey Laboratories.
taxonname	No	pedon.taxonname	The name of the taxonomic unit.
taxclname	No	pedon.taxclname	A concatenation of the Soil Taxonomy subgroup and family for a soil (long name).
localphase	No	pedon.localphase	Phase criterion to be used to help uniquely identify soil components or pedons. These are terms such as “drained”, “eroded”, etc.

petaxhistmoistcl

The Pedon Taxonomic History Moisture Class table provides clear identification of the intended taxonomic moisture class, even though moisture class is implied at a higher taxonomic level. The class or classes listed in this table describe the representative situation for the pedon.

fetchNASIS() Column	Alias	Physical Name	Column Description
taxmoistcl	No	petaxhistmoistcl.taxmoistcl	Soil moisture classes are unique to the family classification, though not included specifically in the name, this is a mechanism to provide clear identification of the actual moisture regime.

petaxhistory

This table records the taxonomic classification history of a pedon record from the time it is first described and classified in the field and throughout the life of the data record.

fetchNASIS() Column	Alias	Physical Name	Column Description
soiltaxedition	No	petaxhistory.soiltaxedition	The edition of Keys to Soil Taxonomy used to classify the soil.
taxclname	No	petaxhistory.taxclname	A concatenation of the Soil Taxonomy subgroup and family for a soil (long name).
taxreaction	No	petaxhistory.taxreaction	Indicates the presence or absence of carbonates and the reaction. They are treated together because of their intimate relationship, and are used to indicate family differentiae. (Soil Taxonomy)
taxorder	No	petaxhistory.taxorder	The highest level in Soil Taxonomy.
taxsubgrp	No	petaxhistory.taxsubgrp	The fourth level of Soil Taxonomy. The subgroup is below great group and above family.
taxtempregime	No	petaxhistory.taxtempregime	Soil temperature regime as defined in Soil Taxonomy.
classdate	No	petaxhistory.classdate	The date this particular classification and/or taxon name was assigned.
seriesstatus	No	petaxhistory.seriesstatus	The status assigned to the named series in the Soil Classification database.
classtype	No	petaxhistory.classtype	The location or type of classification and/or taxon name applied.
taxonkind	No	petaxhistory.taxonkind	Identifies the kind of taxonomic unit described. Examples are series and miscellaneous areas.
classifier	No	petaxhistory.classifier	The name of the person who assigned this particular classification.
taxonname	No	petaxhistory.taxonname	The name of the taxonomic unit.
taxpartsize	No	petaxhistory.taxpartsize	Particle-size classes are used as family differentiae. Particle-size refers to grain-size distribution of the whole soil and is not the same as texture. (Soil Taxonomy).
taxgrtgroup	No	petaxhistory.taxgrtgroup	The third level of Soil Taxonomy. The category is below the suborder and above the subgroup.
taxsuborder	No	petaxhistory.taxsuborder	The second level of Soil Taxonomy. The suborder is below the order and above the great group.
osdtypelocflag	No	petaxhistory.osdtypelocflag	An indicator of whether or not this pedon record is/was used as the typical pedon for the named series.
pscbotdepth	No	petaxhistory.pscbotdepth	Depth to the bottom of the taxonomic particle size control section. (Soil Taxonomy)
psctopdepth	No	petaxhistory.psctopdepth	Depth to the top of the taxonomic particle size control section. (Soil Taxonomy)
taxfamhahatmatcl	No	petaxhistory.taxfamhahatmatcl	Human-altered and human-transported material classes are used as family differentiae. They are intended to provide useful information on the behavior and interpretations for use of soils formed in human-altered or human-transported material (Keys to Soil Taxonomy).
localphase	No	petaxhistory.localphase	Phase criterion to be used to help uniquely identify soil components or pedons. These are terms such as “drained”, “eroded”, etc.

petxhistfmother

The Pedon Taxonomic History Family Other Criteria table lists the other taxonomic characteristics, such as classes of coatings or permanent cracks, that apply to the pedon. The characteristics listed in this table, as a group, describe the representative situation for this pedon.

fetchNASIS() Column	Alias	Physical Name	Column Description
taxfamother	No	petxhistfmother.taxfamother	Soil characteristics other than the defined family characteristics of particle-size classes, mineralogy classes, cation-exchange activity classes, calcareous and reaction classes, and soil temperature classes.

phorizon

The Pedon Horizon table lists the horizons for each pedon. If the horizon thickness is greater than zero (low=5, RV=8, high=12), the horizon exists throughout the exposure of the profile. If the horizon thickness includes zero (low=0, RV=1, high=3), the horizon may exist in some places, but may not exist in other places.

Horizons that have two distinct parts, such as E/B or E&Bt, are recorded twice. Once for the characteristics of the first part; and again on another row, using the same depths and thicknesses, for the characteristics of the other part.

fetchNASIS() Column	Alias	Physical Name	Column Description
phiid	No	phorizon.phiid	An internal ID (integer) that is part (or all) of a key that uniquely identifies a record. Also known as part (or all) of the “primary key”. This value is managed by NASIS and cannot be edited.
hzname	No	phorizon.hzname	The concatenation of three kinds of symbols (four data elements) used in various combinations to designate layers within the soil. (SSM)
hzdept	No	phorizon.hzdept	The distance from the top of the soil to the upper boundary of the soil horizon.
hzdepb	No	phorizon.hzdepb	The distance from the top of the soil to the base of the soil horizon.
texture	No	phorizon.texture	Name for the concatenation of TEXTURE_MODIFIER and TEXTURE_CLASS.
clay	Yes	phorizon.claytotest	Mineral particles less than 0.002mm in equivalent diameter as a weight percentage of the less than 2.0mm fraction, estimated at the time of sampling or description.
silt	Yes	phorizon.silttotest	Mineral particles 0.002 to 0.05mm in equivalent diameter as a weight percentage of the less than 2.0mm fraction, estimated at the time of sampling or description.
sand	Yes	phorizon.sandtotest	Mineral particles 0.05mm to 2.0mm in equivalent diameter as a weight percentage of the less than 2 mm fraction, estimated at the time of sampling or description.
rupresblkmst	No	phorizon.rupresblkmst	The rupture resistance of a block-shaped specimen of 25 to 30 mm size and moist water state. (SSM)
rupresblkdry	No	phorizon.rupresblkdry	The rupture resistance of a block-shaped specimen of 25 to 30 mm size and dry water state. (SSM)
rupresblkcem	No	phorizon.rupresblkcem	The rupture resistance of a block-like specimen of 25 to 30 mm size that has been air dried and then submerged in water. (SSM)
plasticity	No	phorizon.plasticity	The degree to which a puddled, wet soil mass is permanently deformed without rupturing by a slow continuous application of force in any direction. (SSM)
stickiness	No	phorizon.stickiness	The maximum capacity of thoroughly puddled soil to adhere to other objects.
effclass	No	phorizon.effclass	General terms used to describe the degree of effervescence of soil material when tested for carbonates in the field.
bounddistinct	No	phorizon.bounddistinct	Thickness of the interface between adjacent soil horizons. (SSM)
boundtopo	No	phorizon.boundtopo	Horizontal shape of the interface between adjacent soil horizons. (SSM)
phfield	No	phorizon.phfield	The negative common logarithm, of the hydrogen ion activity in the soil at field moisture conditions using field test methods. A numerical expression of the relative acidity or alkalinity of a soil sample. (SSM) This is also the initial pH that should be used when performing SSIR51V1-7.1.3 the Hydrogen Peroxide Test, Delta pH for Acid Sulfate Soils.
ksatpedon	No	phorizon.ksatpedon	The calculated average of field measured saturated hydraulic conductivity. Describes the ability of soil (porous media) to transmit water when the soil is saturated.
genhz	Yes	phorizon.dspcomplayerid	An arbitrary alpha and/or numeric label assigned to this horizon to indicate which horizons should be combined for analysis and data aggregation purposes.
fragvoltot	No	phorizon.fragvoltot	The total volume percentage of the horizon occupied by the 2 mm or larger fraction (20 mm or larger for wood fragments), on a whole soil base.

phsample

The Pedon Horizon Sample table describes the relationship between a soil horizon description and other types of data that may be in the database that relate to that specific horizon, i.e. laboratory analysis results.

fetchNASIS() Column	Alias	Physical Name	Column Description
labsampnum	No	phsample.labsampnum	A unique identifier number for the pedon assigned by the laboratory. This number is used to link the morphological pedon description with the associated measured property values from the laboratory.

phtexture

The Horizon Texture table lists the texture, or terms in lieu of texture, for the texture modifier and class shown above in the Pedon Horizon table. Only the unmodified texture term is listed in the Pedon Horizon Texture table; modifiers are listed in the Pedon Horizon Texture Modifier table. For example, a gravelly loamy sand is shown as “GR-LS” in the Pedon Horizon table, “ls” in this table, and “gr” in the Pedon Horizon Texture Modifier table.

fetchNASIS() Column	Alias	Physical Name	Column Description
texcl	No	phtexture.texcl	An expression, based on the USDA system of particle sizes, for the relative portions of the various size groups of individual mineral grains less than 2mm equivalent diameter in a mass of soil.
lieutex	No	phtexture.lieutex	Substitute terms applied to materials that do not fit into a textural class because of organic matter content, size, rupture resistance, solubility, or another reason.

site

The Site table describes the locational information and characteristics of a particular geographic location. A site may be a specific location such as a point where a soil profile description is taken, or it may have some spatial area that is chosen to be treated as a single point. Various kinds of data such as soil profile descriptions, lab data, vegetative data, etc. may be linked to a site in this database.

fetchNASIS() Column	Alias	Physical Name	Column Description
siteiid	No	site.siteiid	An internal ID (integer) that is part (or all) of a key that uniquely identifies a record. Also known as part (or all) of the “primary key”. This value is managed by NASIS and cannot be edited.
climstaid	No	site.climstaid	The station identifier. This is assigned by the responsible agency. This identifier uniquely identifies a climate station.
climstanm	No	site.climstanm	The full descriptive name of the station as recognized by the agency responsible for the station.
climstatype	No	site.climstatype	The type of the weather station, U.S. Official or Other.
ffd	No	site.ffd	The expected number of days between the last freezing temperature (0 degrees Celsius) in spring (Jan-Jul) and the first freezing temperature (0 degrees Celsius) in the fall (Aug-Dec). The number of days is based on the probability that the values for the standard “normal” period of 1961 to 1990 will be exceeded in 5 years out of 10.
map	No	site.map	The arithmetic average of the total annual (liquid) precipitation taken over the standard “normal” period, 1961-1990.
airtempa	No	site.airtempa	The arithmetic average of the daily maximum and minimum temperatures for a calendar year taken over the standard “normal” period, 1961 to 1990.
soiltempa	No	site.soiltempa	The mean annual soil temperature (MAST) at a depth of 50 cm below the soil surface, or at the upper boundary of a root-limiting layer as defined in Soil Taxonomy, whichever is shallower.
airtemps	No	site.airtemps	The mean of the mean June, July and August mean air temperatures in the northern hemisphere. (USDA, 1941, Climate & Man, pg. 690)
soiltemps	No	site.soiltemps	The mean of June, July and August monthly mean soil temperatures (in the northern hemisphere) at a depth of 50 cm below the soil surface, or at the upper boundary of a root-limiting layer as defined in Soil Taxonomy, whichever is shallower.
airtempw	No	site.airtempw	The mean of the mean December, January and February mean air temperatures in the northern hemisphere. (USDA, 1941, Climate & Man, pg. 690)
soiltempw	No	site.soiltempw	The mean of December, January, and February monthly mean soil temperatures (in the northern hemisphere) at a depth of 50 cm below the soil surface, or at the upper boundary of a root-limiting layer as defined in Soil Taxonomy, whichever is shallower.
geomposhill	No	site.geomposhill	A mappable part of the earth’s surface (three dimensional) that represents an episode of landscape development of hills.
geomposmntn	No	site.geomposmntn	A mappable part of the earth’s surface (three dimensional) that represents an episode of landscape development of mountains.
geompostrce	No	site.geompostrce	A mappable part of the earth’s surface (three dimensional) that represents an episode of landscape development of terraces.
geomposflats	No	site.geomposflats	Description of the geomorphic component for flats.
elev_field	Yes	site.elev	The vertical distance from mean sea level to a point on the earth’s surface.
slope_field	Yes	site.slope	The difference in elevation between two points, expressed as a percentage of the distance between those points. (SSM)
aspect_field	Yes	site.aspect	The direction toward which the surface of the soil faces, expressed as an angle between 0 and 360 degrees, inclusive, measured clockwise from true north.
shapeacross	No	site.shapeacross	The geometric, two dimensional profile (shape) of the slope parallel to elevation contours.
shapedown	No	site.shapedown	The geometric, two dimensional profile (shape) of the slope perpendicular to elevation contours.
slopecomplex	No	site.slopecomplex	The identification of whether the landscape surface is simple or complex.
geomslopeseg	No	site.geomslopeseg	Position of the pedon site within the segment of the slope.
hillslopeprof	No	site.hillslopeprof	Two dimensional slope segments of a hillslope that have similar geometric, erosional, or depositional characteristics.
drainagecl	No	site.drainagecl	Identifies the natural drainage conditions of the soil and refers to the frequency and duration of wet periods. An example of a drainage class is well drained.
horizdatnm	No	site.horizdatnm	The identification given to the reference system used for defining the coordinates of points. (Content Standards for Spatial Metadata, FGDC, 3/31/94 draft). This entry applies to both lat/long and UTM coordinates. NO LONGER USED BECAUSE CAN’T DIFFERENTIATE BETWEEN UTM AND DMS.
pmgroupname	No	site.pmgroupname	Name for the concatenation of PARENT_MATERIAL_MODIFIER, PARENT_MATERIAL_KIND, and PARENT_MATERIAL_ORIGIN for each of the parent materials that may occur in a vertical cross section of a soil.
utmeasting	No	site.utmeasting	The distance, in meters, proceeding east for the UTM zone. The UTM zone central meridian is the origin and is designated a value of 500,000 meters creating a “false” easting.
utmnorthing	No	site.utmnorthing	The distance, in meters, north from the UTM zone origin. For “north”, origin is the equator equal zero. For the southern hemisphere it is a false northing with origin, i.e. the equator, equal to 10,000,000 meters.
utmzone	No	site.utmzone	Zones of the Universal Transverse Mercator projection system bounded by meridians, the longitudes are multiples of 6 degrees. Zones are numbered from 1 to 60 proceeding east from the 180th meridian from Greenwich, England.
site_id	Yes	site.usiteid	A short label to help a user identify a particular site.
floddurcl	No	site.floddurcl	Average duration of inundation per flood occurrence and expressed as a class. (NSSH)
flodfreqcl	No	site.flodfreqcl	The annual probability of a flood event (inundation by flowing water), expressed as a class. (SSM).
flodmonthbeg	No	site.flodmonthbeg	The month of the year in which the predicted flooding period of a soil is likely to begin.
ponddurcl	No	site.ponddurcl	The average duration, or length of time, of the ponding occurrence. (NSSH)
pondfreqcl	No	site.pondfreqcl	The annual probability of a ponding event (inundation by standing water), expressed as a class.
pondmonthbeg	No	site.pondmonthbeg	The month of the year in which the predicted flooding period of a soil is likely to begin.
reannualprecip	No	site.reannualprecip	An estimate of the amount of moisture available for plant use and/or soil forming processes at a given site. It may vary, plus or minus, from “actual” precipitation amounts as a function of runon, runoff, temperature, aspect, etc.
y_std	Yes	site.latstddecimaldegrees	Standardized latitude value in decimal degrees, in geographic coordinate system, WGS84 datum. Values are either auto-populated from GPS, or computed from original latitude coordinates using standard conversion algorithms.
x_std	Yes	site.longstddecimaldegrees	Standardized longitude value in decimal degrees, in geographic coordinate system, WGS84 datum. Values are either auto-populated from GPS, or computed from original longitude coordinates using standard conversion algorithms.
gpspositionalerror	No	site.gpspositionalerror	The potential distance in meters between the GPS coordinate location and the “true” location of a point observation. The “true” location of the point observation usually lies within the area covered by a circle centered on the GPS coordinate location with a radius equal to the positional error.

sitebedrock

This table records the kind(s) of bedrock layers observed at the site. Multiple layers of bedrock can be described.

fetchNASIS() Column	Alias	Physical Name	Column Description
bedrckdepth	No	sitebedrock.bedrckdepth	The observed depth to the top of the bedrock layer.
bedrckhardness	No	sitebedrock.bedrckhardness	The degree of hardness of the underlying rock.
bedrckkind	No	sitebedrock.bedrckkind	Lithology (composition) of bedrock. (AGI)

siteecositehistory

This table records the history of ecological site correlation with this Site table record.

fetchNASIS() Column	Alias	Physical Name	Column Description
ecositecorrdate	No	siteecositehistory.ecositecorrdate	The date this particular correlation between a Site and Ecological Site was made.
es_classifier	Yes	siteecositehistory.classifier	The name of the person who assigned this particular classification.

siteobs

The Site Observation table records the date that the various observation or analytical data is collected for the specific site or location. Soil or site properties that may change with time are also recorded here. If a site is revisited at a later date for additional data collection, a new row with the appropriate date is entered in this table. Separate tables exist for properties that may have multiple entries.

fetchNASIS() Column	Alias	Physical Name	Column Description
obs_date	Yes	siteobs.obsdate	The date on which this particular soil was described or sampled, expressed as month, day, year – MM/DD/YYYY.
siteobsiid	No	siteobs.siteobsiid	An internal ID (integer) that is part (or all) of a key that uniquely identifies a record. Also known as part (or all) of the “primary key”. This value is managed by NASIS and cannot be edited.
swaterdepth	No	siteobs.swaterdepth	The observed depth of water on the soil surface.
earthcovkind1	No	siteobs.earthcovkind1	The natural or artificial material that is observed to cover a portion of the earth’s surface. It is determined (at least conceptually) as a vertical projection downward. Level one of a hierarchical system. (1992 NRI Instructions)
ecostatename	No	siteobs.ecostatename	The assigned name of the state within the ecological site on which a site or plot is located.
commphaseid	No	siteobs.commphaseid	The assigned identifier code of the community phase of the ecological site on which a site or plot is located.
commphasename	No	siteobs.commphasename	The assigned name of the community phase of the ecological site on which a site or plot is located.
ecostateid	No	siteobs.ecostateid	The assigned identifier code of the state within the ecological site on which a site or plot is located.
earthcovkind2	No	siteobs.earthcovkind2	The description of ground cover based on a set of vegetal and non-vegetal classes. It is determined (at least conceptually) as a vertical projection downward. Level two of a hierarchical system.
plantassocnm	No	siteobs.plantassocnm	The name assigned to a particular plant community found at a particular location. A plant association is a kind of plant community represented by a high degree of floristic uniformity in all layers. Plant Associations are identified and named for the dominant plant species in a layer. (Nat. Soil-Range Team, 1988, Instr. for Completing the Stand. Site Descrip.)

sitepm

The Site Parent Material table lists the individual parent materials, and their vertical sequence, from which the soil at this site developed. The Parent Material Group Name is shown above in the Site table.

fetchNASIS() Column	Alias	Physical Name	Column Description
pmkind	No	sitepm.pmkind	A term describing the general physical, chemical and mineralogical composition of the material, mineral or organic, from which the soil develops. Mode of deposition and/or weathering may be implied or implicit.
pmorigin	No	sitepm.pmorigin	The type of bedrock from which the parent material was derived.

transect

The Transect table is used to record groupings of pedons that are the stops along transects.

fetchNASIS() Column	Alias	Physical Name	Column Description
utransectid	No	transect.utransectid	An identifier assigned by the user to a particular transect that is intended to aid in the identification of the transect for the user.
tsectkind	No	transect.tsectkind	The kind of transect (geometrically described). Described as one of the following: Straight, zigzag, or random point. If straight or zigzag then the actual interval since the last observation point is a required entry. This is a required entry for a transect.
tsectselmeth	No	transect.tsectselmeth	Describes how the transect location was selected. Described as being one of the following. Randomly selected or selected based on some bias. This is a required entry field for transect data.

Calculated

fetchNASIS_Column	ColumnDescription	RelatedFunction	Deprecated
albic.horizon	Presence/absence. Calculated from Pedon Diagnostic Horizon Table with soilDB:::.diagHzLongtoWide()	get_extended_data_from_NASIS_db()	FALSE
albic.materials	Presence/absence. Calculated from Pedon Diagnostic Horizon Table with soilDB:::.diagHzLongtoWide()	get_extended_data_from_NASIS_db()	FALSE
andic.soil.properties	Presence/absence. Calculated from Pedon Diagnostic Horizon Table with soilDB:::.diagHzLongtoWide()	get_extended_data_from_NASIS_db()	FALSE
aquic.conditions	Presence/absence. Calculated from Pedon Diagnostic Horizon Table with soilDB:::.diagHzLongtoWide()	get_extended_data_from_NASIS_db()	FALSE
argillic.horizon	Presence/absence. Calculated from Pedon Diagnostic Horizon Table with soilDB:::.diagHzLongtoWide()	get_extended_data_from_NASIS_db()	FALSE
art_by	Artifact volume (%) in the >600mm size range	get_hz_data_from_NASIS_db(), simplifyArtifactData()	FALSE
art_cb	Artifact volume (%) in the 75 - 250 mm size range	get_hz_data_from_NASIS_db(), simplifyArtifactData()	FALSE
art_ch	Flat artifact volume (%) in the 2 - 150 mm size range	get_hz_data_from_NASIS_db(), simplifyArtifactData()	FALSE
art_fgr	Artifact volume (%) in 2 - 5 mm size range	get_hz_data_from_NASIS_db(), simplifyArtifactData()	FALSE
art_fl	Flat artifact volume (%) in the >150 mm size range	get_hz_data_from_NASIS_db(), simplifyArtifactData()	FALSE
art_gr	Artifact volume (%) in 2 - 75 mm size range (includes fine_gravel)	get_hz_data_from_NASIS_db(), simplifyArtifactData()	FALSE
art_st	Artifact volume (%) in the 250 - 600 mm size range	get_hz_data_from_NASIS_db(), simplifyArtifactData()	FALSE
art_unspecified	Artifact volume (%) with unspecified/incomplete size specification	get_hz_data_from_NASIS_db(), simplifyArtifactData()	FALSE
boulders	Rock fragment volume (%) in the >600mm size range	get_hz_data_from_NASIS_db(), simplifyFragmentData()	FALSE
cambic.horizon	Presence/absence. Calculated from Pedon Diagnostic Horizon Table with soilDB:::.diagHzLongtoWide()	get_extended_data_from_NASIS_db()	FALSE
channers	Flat rock fragment volume (%) in the 2 - 150 mm size range	get_hz_data_from_NASIS_db(), simplifyFragmentData()	FALSE
cobbles	Rock fragment volume (%) in the 75 - 250 mm size range	get_hz_data_from_NASIS_db(), simplifyFragmentData()	FALSE
d_b	Dry Color B	get_colors_from_NASIS_db()	FALSE
d_chroma	Dry Color Chroma	get_colors_from_NASIS_db()	FALSE
d_g	Dry Color G	get_colors_from_NASIS_db()	FALSE
d_hue	Dry Color Hue	get_colors_from_NASIS_db()	FALSE
d_r	Dry Color R	get_colors_from_NASIS_db()	FALSE
d_sigma	Dry Color Sigma	get_colors_from_NASIS_db()	FALSE
d_value	Dry Color Value	get_colors_from_NASIS_db()	FALSE
densic.materials	Presence/absence. Calculated from Pedon Diagnostic Horizon Table with soilDB:::.diagHzLongtoWide()	get_extended_data_from_NASIS_db()	FALSE
dry_soil_color	Dry Munsell Soil Color	get_colors_from_NASIS_db()	FALSE
es_selection_method	Ecological Site History record selection method from soilDB:::.pickBestEcosite()	get_extended_data_from_NASIS_db()	FALSE
fine_gravel	Rock fragment volume (%) in 2 - 5 mm size range	get_hz_data_from_NASIS_db(), simplifyFragmentData()	FALSE
flagstones	Flat rock fragment volume (%) in the >150 mm size range	get_hz_data_from_NASIS_db(), simplifyFragmentData()	FALSE
geomicrorelief_string	Concatenated microrelief string via soilDB:::.formatLandformString()	get_extended_data_from_NASIS_db()	FALSE
glossic.horizon	Presence/absence. Calculated from Pedon Diagnostic Horizon Table with soilDB:::.diagHzLongtoWide()	get_extended_data_from_NASIS_db()	FALSE
gravel	Rock fragment volume (%) in 2 - 75 mm size range (includes fine_gravel)	get_hz_data_from_NASIS_db(), simplifyFragmentData()	FALSE
huartvol_cohesive	Cohesive artifact volume (%)	get_hz_data_from_NASIS_db(), simplifyArtifactData()	FALSE
huartvol_innocuous	Innocuous artifact volume (%)	get_hz_data_from_NASIS_db(), simplifyArtifactData()	FALSE
huartvol_penetrable	Penetrable artifact volume (%)	get_hz_data_from_NASIS_db(), simplifyArtifactData()	FALSE
huartvol_persistent	Persistent artifact volume (%)	get_hz_data_from_NASIS_db(), simplifyArtifactData()	FALSE
hzID	Internal horizon row ID (unique) calculated in aqp SoilProfileCollection objects	get_hz_data_from_NASIS_db()	FALSE
landform_string	Concatenated landform string via soilDB:::.formatLandformString()	get_extended_data_from_NASIS_db()	FALSE
landscape_string	Concatenated landscape string via soilDB:::.formatLandformString()	get_extended_data_from_NASIS_db()	FALSE
lithic.contact	Presence/absence. Calculated from Pedon Diagnostic Horizon Table with soilDB:::.diagHzLongtoWide()	get_extended_data_from_NASIS_db()	FALSE
lithologic.discontinuity	Presence/absence. Calculated from Pedon Diagnostic Horizon Table with soilDB:::.diagHzLongtoWide()	get_extended_data_from_NASIS_db()	FALSE
m_b	Moist Color B	get_colors_from_NASIS_db()	FALSE
m_chroma	Moist Color Chroma	get_colors_from_NASIS_db()	FALSE
m_g	Moist Color G	get_colors_from_NASIS_db()	FALSE
m_hue	Moist Color Hue	get_colors_from_NASIS_db()	FALSE
m_r	Moist Color R	get_colors_from_NASIS_db()	FALSE
m_sigma	Moist Color Sigma	get_colors_from_NASIS_db()	FALSE
m_value	Moist Color Value	get_colors_from_NASIS_db()	FALSE
microfeature_string	Concatenated microfeature string via soilDB:::.formatLandformString()	get_extended_data_from_NASIS_db()	FALSE
moist_soil_color	Moist Munsell Soil Color	get_colors_from_NASIS_db()	FALSE
mollic.epipedon	Presence/absence. Calculated from Pedon Diagnostic Horizon Table with soilDB:::.diagHzLongtoWide()	get_extended_data_from_NASIS_db()	FALSE
ochric.epipedon	Presence/absence. Calculated from Pedon Diagnostic Horizon Table with soilDB:::.diagHzLongtoWide()	get_extended_data_from_NASIS_db()	FALSE
paraboulders	Pararock fragment volume (%) in the >600mm size range	get_hz_data_from_NASIS_db(), simplifyFragmentData()	FALSE
parachanners	Flat pararock fragment volume (%) in the 2 - 150 mm size range	get_hz_data_from_NASIS_db(), simplifyFragmentData()	FALSE
paracobbles	Pararock fragment volume (%) in the 75 - 250 mm size range	get_hz_data_from_NASIS_db(), simplifyFragmentData()	FALSE
parafine_gravel	Pararock fragment volume (%) in 2 - 5 mm size range	get_hz_data_from_NASIS_db(), simplifyFragmentData()	FALSE
paraflagstones	Flat pararock fragment volume (%) in the >150 mm size range	get_hz_data_from_NASIS_db(), simplifyFragmentData()	FALSE
paragravel	Pararock fragment volume (%) in 2 - 75 mm size range (includes parafine_gravel)	get_hz_data_from_NASIS_db(), simplifyFragmentData()	FALSE
parastones	Pararock fragment volume (%) in the 250 - 600 mm size range	get_hz_data_from_NASIS_db(), simplifyFragmentData()	FALSE
redox.concentrations	Presence/absence. Calculated from Pedon Diagnostic Horizon Table with soilDB:::.diagHzLongtoWide()	get_extended_data_from_NASIS_db()	FALSE
reduced.matrix	Presence/absence. Calculated from Pedon Diagnostic Horizon Table with soilDB:::.diagHzLongtoWide()	get_extended_data_from_NASIS_db()	FALSE
sapric.soil.materials	Presence/absence. Calculated from Pedon Diagnostic Horizon Table with soilDB:::.diagHzLongtoWide()	get_extended_data_from_NASIS_db()	FALSE
secondary.carbonates	Presence/absence. Calculated from Pedon Diagnostic Horizon Table with soilDB:::.diagHzLongtoWide()	get_extended_data_from_NASIS_db()	FALSE
selection_method	Pedon Taxonomic History record selection method from soilDB:::.pickBestTaxHistory()	get_extended_data_from_NASIS_db()	FALSE
slope_shape	Calculated factor where levels are concatenation of site.shapeacross + ” / ” + site.shapedown	get_site_data_from_NASIS_db()	FALSE
soil_color	Default Munsell Soil Color; Moist by default, based on fetchNASIS(soilColorState="moist")	get_colors_from_NASIS_db()	FALSE
spodic.horizon	Presence/absence. Calculated from Pedon Diagnostic Horizon Table with soilDB:::.diagHzLongtoWide()	get_extended_data_from_NASIS_db()	FALSE
spodic.materials	Presence/absence. Calculated from Pedon Diagnostic Horizon Table with soilDB:::.diagHzLongtoWide()	get_extended_data_from_NASIS_db()	FALSE
stones	Rock fragment volume (%) in the 250 - 600 mm size range	get_hz_data_from_NASIS_db(), simplifyFragmentData()	FALSE
surface_boulders	Surface rock fragment volume (%) in the >600mm size range	get_site_data_from_NASIS_db(), simplifyFragmentData()	FALSE
surface_channers	Surface flat rock fragment volume (%) in the 2 - 150 mm size range	get_site_data_from_NASIS_db(), simplifyFragmentData()	FALSE
surface_cobbles	Surface rock fragment volume (%) in the 75 - 250 mm size range	get_site_data_from_NASIS_db(), simplifyFragmentData()	FALSE
surface_fgravel	Deprecated alias of surface_fine_gravel	get_site_data_from_NASIS_db(), simplifyFragmentData()	TRUE
surface_fine_gravel	Surface rock fragment volume (%) in 2 - 5 mm size range	get_site_data_from_NASIS_db(), simplifyFragmentData()	FALSE
surface_flagstones	Surface flat rock fragment volume (%) in the >150 mm size range	get_site_data_from_NASIS_db(), simplifyFragmentData()	FALSE
surface_gravel	Surface rock fragment volume (%) in 2 - 75 mm size range (includes fine_gravel)	get_site_data_from_NASIS_db(), simplifyFragmentData()	FALSE
surface_paraboulders	Surface pararock fragment volume (%) in the >600mm size range	get_site_data_from_NASIS_db(), simplifyFragmentData()	FALSE
surface_parachanners	Surface flat pararock fragment volume (%) in the 2 - 150 mm size range	get_site_data_from_NASIS_db(), simplifyFragmentData()	FALSE
surface_paracobbles	Surface pararock fragment volume (%) in the 75 - 250 mm size range	get_site_data_from_NASIS_db(), simplifyFragmentData()	FALSE
surface_parafine_gravel	Surface pararock fragment volume (%) in 2 - 5 mm size range	get_site_data_from_NASIS_db(), simplifyFragmentData()	FALSE
surface_paraflagstones	Surface flat pararock fragment volume (%) in the >150 mm size range	get_site_data_from_NASIS_db(), simplifyFragmentData()	FALSE
surface_paragravel	Surface pararock fragment volume (%) in 2 - 75 mm size range (includes parafine_gravel)	get_site_data_from_NASIS_db(), simplifyFragmentData()	FALSE
surface_parastones	Surface pararock fragment volume (%) in the 250 - 600 mm size range	get_site_data_from_NASIS_db(), simplifyFragmentData()	FALSE
surface_stones	Surface rock fragment volume (%) in the 250 - 600 mm size range	get_site_data_from_NASIS_db(), simplifyFragmentData()	FALSE
surface_total_frags_pct	Total surface fragment volume (%), including parafragments	get_site_data_from_NASIS_db(), simplifyFragmentData()	FALSE
surface_total_frags_pct_nopf	Total surface fragment volume (%), excluding parafragments	get_site_data_from_NASIS_db(), simplifyFragmentData()	FALSE
surface_unspecified	Surface fragment volume (%) with unspecified/incomplete size specification	get_site_data_from_NASIS_db(), simplifyFragmentData()	FALSE
texture_class	Texture class of fine-earth fraction (phtexture.texcl). If missing, then the in lieu class is used (phtexture.lieutex).	get_hz_data_from_NASIS_db()	FALSE
total_art_pct	Total artifact volume (%)	get_hz_data_from_NASIS_db(), simplifyArtifactData()	FALSE
total_frags_pct	Total rock fragment volume (%), including parafragments	get_hz_data_from_NASIS_db(), simplifyFragmentData()	FALSE
total_frags_pct_nopf	Total rock fragment volume (%), excluding parafragments	get_hz_data_from_NASIS_db(), simplifyFragmentData()	FALSE
umbric.epipedon	Presence/absence. Calculated from Pedon Diagnostic Horizon Table with soilDB:::.diagHzLongtoWide()	get_extended_data_from_NASIS_db()	FALSE
unspecified	Rock fragment volume (%) with unspecified/incomplete fragsize	get_hz_data_from_NASIS_db(), simplifyFragmentData()	FALSE