BOREAS TE-20 NSA Soil Lab Data 7.3 Data Characteristics 7.3.1 Parameter/Variable The parameters contained in the data files on the CD-ROM are: Column Name ------------------------------ SITE_NAME SUB_SITE MEASUREMENT_YEAR PIT HORIZON START_DEPTH END_DEPTH BULK_DENSITY TOTAL_SOIL_C_CONTENT SOIL_ORG_C_CONTENT SOIL_INORG_C_CONTENT CATION_EX_CAPACITY EXCHANGE_SODIUM EXCHANGE_POTASSIUM EXCHANGE_CALCIUM EXCHANGE_MAGNESIUM WATER_CONTENT_10KPA WATER_CONTENT_33KPA WATER_CONTENT_1500KPA SOIL_NITROGEN_CONTENT SOIL_PHOSPHORUS_CONTENT VERY_COARSE_SAND COARSE_SAND MEDIUM_SAND FINE_SAND VERY_FINE_SAND TOTAL_SAND TOTAL_SILT TOTAL_CLAY SOIL_TEXTURE HORIZON_NUM MINRL_SOIL_AND_CACL2_PH ORG_SOIL_AND_CACL2_PH MINRL_SOIL_AND_H2O_PH ORG_SOIL_AND_H2O_PH SOIL_EXTRACT_ACIDITY SOIL_SULFUR_CONTENT CRTFCN_CODE REVISION_DATE 7.3.2 Variable Description/Definition The descriptions of the parameters contained in the data files on the CD-ROM are: Column Name Description ------------------------------ ------------------------------------------------ SITE_NAME The identifier assigned to the site by BOREAS, in the format SSS-TTT-CCCCC, where SSS identifies the portion of the study area: NSA, SSA, REG, TRN, and TTT identifies the cover type for the site, 999 if unknown, and CCCCC is the identifier for site, exactly what it means will vary with site type. SUB_SITE The identifier assigned to the sub-site by BOREAS, in the format GGGGG-IIIII, where GGGGG is the group associated with the sub-site instrument, e.g. HYD06 or STAFF, and IIIII is the identifier for sub-site, often this will refer to an instrument. MEASUREMENT_YEAR The year in which the data were collected. PIT The pit identifier from which the sample was taken. HORIZON The soil horizon from which the sample was taken. The following information may help in describing the soil horizon codes: Organic Horizons O This is an organic horizon developed mainly from mosses, rushes, and woody materials. Of The fibric horizon is the least decomposed of all the organic soil materials. It has large amounts of well-preserved fiber that are readily identifiable as to botanical origin. A fibric horizon has 40% or more of rubbed fiber by volume and a pyrophosphate index of 5 or more. If the rubbed fiber volume is 75% or more, the pyrophosphate criterion does not apply. Om The mesic horizon is the intermediate stage of decomposition with intermediate amounts of fiber, bulk density and water-holding capacity. The material is partly altered both physically and biochemically. A mesic horizon is one that fails to meet the requirements of fibric or humic. Oh The humic horizon is the most highly decomposed of the organic soil materials. It has the least amount of fiber, the highest bulk density, and the lowest saturated water-holding capacity. It is very stable and changes very little physically or chemically with time unless it is drained. The humic horizon has less than 10% rubbed fiber by volume and a pyrophosphate index of 3 or less. LFH These organic horizons developed primarily from leaves, twigs, woody materials, and a minor component of mosses under imperfectly to well- drained forest conditions. L This is an organic horizon characterized by an accumulation of organic matter in which the original structures are easily discernible. F This is an organic horizon characterized by an accumulation of partly decomposed organic matter. The original structures in part are difficult to recognize. The horizon may be partly comminuted by soil fauna as in moder, or it may be a partly decomposed mat permeated by fungal hyphae as in mor. H This is an organic horizon characterized by an accumulation of decomposed organic matter in which the original structures are indiscernible. This material differs from the F horizon by its greater humification chiefly through the action of organisms. It is frequently intermixed with mineral grains, especially near the junction with the mineral horizon. Mineral Horizons Mineral horizons are those that contain less than 30% organic matter by weight as specified for organic horizon. A This is a mineral horizon or horizons formed at or near the surface in the zone of leaching or removal of materials in solution and suspension or of maximum in situ accumulation of organic matter, or both. Included are: 1. horizons in which organic matter has accumulated as a result of biological activity (Ah); 2. horizons that have been eluviated of clay, iron, aluminum, or organic matter, or all of them (Ae); 3. horizons having characteristics of 1) and 2) above but transitional to underlying B or C (AB or A and B); 4. horizons markedly disturbed by cultivation or pasture (Ap). B This is a mineral horizon or horizons characterized by one or more of the following: 1. an enrichment in silicate clay, iron, aluminum, or humus, alone or in combination (Bt, Bf, Bfh, Bhf, and Bh); 2. a prismatic or columnar structure that exhibits pronounced coatings or stainings and significant amount of exchangeable Na (Bn); 3. an alteration by hydrolysis, reduction, or oxidation to give a change in color or structure from horizons above or below, or both, and does not meet the requirements of 1) and 2) above (Bm, Bg). C This is a mineral horizon or horizons comparatively unaffected by the pedogenic processes operative in A and B, excepting (i) the process of gleying, and (ii) the accumulation of calcium and magnesium carbonates and more soluble salts (Cca, Csa, Cg, and C). Marl and diatomaceous earth are considered to be C horizons. R This is consolidated bedrock that is too hard to break with the hands or to dig with a spade when moist and that does not meet the requirement of a C horizon. The boundary between the R layer and overlying unconsolidated material is called a lithic contact. W This is a layer of water in Gleysolic, Organic, or Cryosolic soils. It is called a hydric layer in Organic soils. Lower-Case Suffixes b Buried soil horizon. c A cemented (irreversible) pedogenic horizon. The ortstein of a Podzol, and a layer cemented by calcium carbonate and a duripan are examples. ca A horizon with secondary carbonate enrichment where the concentration of lime exceeds that present in the unenriched parent material. It is more than 10 cm thick, and if it has a CaCO3 equivalent of less than 15 percent it should have at least 5 percent more CaCO3 equivalent than the parent material (IC). If it has more than 15 percent CaCO3 equivalent it should have 1/3 more CaCO3 equivalent than the IC. If no IC is present, this horizon is more than 10 cm thick and contains more than 5 percent by volume of secondary carbonates in concretions or soft, powdery forms. cc Cemented (irreversible) pedogenic concretions. e A horizon characterized by the eluviation of clay, iron, aluminum, or organic matter alone or in combination. When dry, it is usually higher in color value by 1 or more units than an underlying B horizon. It is used with A (Ae). f A horizon enriched with amorphous material, principally Al and Fe combined with organic matter. It usually has a hue of 7.5YR or redder or its hue is 10YR near the upper boundary and becomes yellower with depth. When moist, the chroma is higher than 3 or the value is 3 or less. It contains 0.6% or more pyrophosphate-extractable Al+Fe in textures finer than sand and 0.4% or more in sands (coarse sand, sand, fine sand, and very fine sand). The ratio of pyrophosphate-extractable Al+Fe to clay (less than 0.002 mm) is more than 0.05 and OC exceeds 0.5%. Pyrophosphate-extractable Fe is at least 0.3%, or the ratio of OC to pyrophosphate-extractable Fe is less than 20, or both are true. It is used with B alone (Bf), with B and h (Bhf), with B and g (Bfg), and with other suffixes. The criteria for "f" do not apply to Bgf horizons. The following horizons are differentiated on the basis of OC content: Bf - 0.5% to 5% OC. Bhf - more than 5% OC. g A horizon characterized by gray colors, or prominent mottling, or both, indicative of permanent or periodic intense reduction. Chromas of the matrix are generally 1 or less. It is used with A and e (Aeg); with B alone (Bg); with B and f (Bfg); with B, h, and f (Bhfg); with B and t (Btg); with C alone (Cg); with C and k (Ckg); and several others. In some reddish parent materials, matrix colors of reddish hues and high chromas may persist, despite long periods of reduction. In these soils, horizons are designated as g if there is gray mottling or if there is marked bleaching on ped faces or along cracks. Aeg This horizon must meet the definitions of A, e, and g. Bg These horizons are analogous to Bm horizons but they have colors indicative of poor drainage and periodic reduction. They include horizons occurring between A and C horizons in which the main features are: (i) colors of low chroma, that is: chromas of 1 or less, without mottles on ped surfaces or in the matrix if peds are lacking; or chromas of 2 or less in hues of 10YR or redder, on ped surfaces or in the matrix if peds are lacking, accompanied by more prominent mottles than those in the C horizon; or hues bluer than 10Y, with or without mottles on ped surfaces or in the matrix if peds are lacking. (ii) colors indicated in (i) and a change in structure from that of the C horizons. (iii) color indicated in (i) and illuviation of clay too slight to meet the requirements of Bt; or accumulation or iron oxide too slight to meet the limits of Bgf. (iv) colors indicated in (i) and removal of carbonates. Bg horizons occur in some Orthic Humic Gleysols and some Orthic Gleysols. Bfg, Bhfg, Btg, and others. When used in any of these combinations the limits set for f, hf, t, and others must be met. Bgf The dithionite-extractable Fe of this horizon exceeds that of the IC by 1% or more. Pyrophosphate-extractable Al + Fe is less than the minimum limit specified for 'f' horizons. This horizon occurs in Fera Gleysols and Fera Humic Gleysols, and possibly below the Bfg of gleyed Podzols. It is distinguished from the Bfg of gleyed Podzols on the basis of the extractability of the Fe and Al. The Fe in the Bgf horizon is thought to have accumulated as a result of the oxidation of ferrous iron. The iron oxide formed is not associated intimately with organic matter or with Al, and it is sometimes crystalline. The Bgf horizons are usually prominently mottled, with more than half of the soil material occurring as mottles of high chroma. Cg, Ckg, Ccag, Csg, Csag. When g is used with C alone, or with C and one of the lowercase suffixes k, ca, s, or sa, it must meet the definition for C and for the particular suffix. h A horizon enriched with organic matter. It is used with A alone (Ah); or with A and e (Ahe); or with B alone (Bh); or with B and f (Bhf). Ah A horizon enriched with organic matter that either has a color value at least one unit lower than the underlying horizon or contains 0.5% more OC than the IC, or both. It contains less than 17% OC by weight. Ahe An Ah horizon that has undergone eluviation as evidenced, under natural conditions, by streaks and splotches of differing shades of gray and often by platy structure. It may be overlain by a darker-colored Ah and underlain by a lighter colored Ae. Bh This horizon contains more than 1% organic carbon, less than 0.3% pyrophosphate-extractable Fe, and has a ratio of OC to pyrophosphate- extractable of 20 or more. Generally the color value and chroma are less than 3 when moist. Bhf Defined under 'f'. j Used as a modifier of the suffixes e, f, g, n, and t to denote an expression of, but failure to meet, the specified limits of the suffix it modifies. It must be placed to the right of and adjacent to the suffix it modifies. For example, Bfgj means a Bf horizon with weak expression of gleying; Bfjgj means a B horizon with weak expression of both 'f' and 'g' features. Aej An eluvial horizon that is thin, discontinuous, or slightly discernible. Btj A horizon with some illuviation of clay, but not enough to meet the limits of Bt. Btgj, Bmgj Horizons that are mottled but do not meet the criteria of Bg. Bfj A horizon with some accumulation of pyrophosphate-extractable Al and Fe but not enough to meet the limits of Bf. Bntj or Bnj Horizons in which development of solonetzic B properties is evident but insufficient to meet the limits for Bn or Bnt. k Denotes the presence of carbonate, as indicated by visible effervescence when dilute HCl is added. Most often it is used with B and m (Bmk) or C (Ck), and occasionally with Ah or Ap (Ahk, Apk), or organic horizons (Ofk, Omk). m A horizon slightly altered by hydrolysis, oxidation, or solution, or all three, to give a change in color or structure, or both. It has: 1. Evidence of alteration in one of the following forms: a) Higher chromas and redder hues than the underlying horizons. b) Removal of carbonates, either partially (Bmk) or completely (Bm). 2. Illuviation, if evident, too slight to meet the requirements of a Bt or a podzolic B. 3. Some weatherable minerals. 4. No cementation or induration and lacks a brittle consistence when moist. This suffix can be used as Bm, Bmgj, Bmk, and Bms. n A horizon in which the ratio of exchangeable Ca to exchangeable Na is 10 or less. It must also have the following distinctive morphological characteristics: prismatic or columnar structure, dark coatings on ped surfaces, and hard to very hard consistence when dry. It is used with B, as Bn or Bnt. p A horizon disturbed by man's activities, such as cultivation, logging, habitation, etc. It is used with A and O. s A horizon with salts, including gypsum, which may be detected as crystals or veins, as surface crusts of salt crystals, by depressed crop growth, or by the presence of salt-tolerant plants. It is commonly used with C and k (Csk), but can be used with any horizon or combination of horizon and lowercase suffix. sa A horizon with secondary enrichment of salts more soluble than calcium and magnesium carbonates, in which the concentration of salts exceeds that present in the unenriched parent material. The horizon is 10 cm or more thick. The conductivity of the saturation extract must be at least 4 ms/cm and must exceed that of the C horizon by at least one-third. t An illuvial horizon enriched with silicate clay. It is used with B alone (Bt), with B and g (Btg), with B and n (Bnt), etc. Bt A Bt horizon is one that contains illuvial layer lattice clays. It forms below an eluvial horizon, but may occur at the surface of a soil that has been partially truncated. It usually has a higher ratio of fine clay to total clay than IC. It has the following properties: 1. If any part of an eluvial horizon remains and there is no lithologic discontinuity between it and the Bt horizon, the Bt horizon contains more total and fine clay than the eluvial horizons, as follows: a) If any part of the eluvial horizon has less than 15% total clay in the fine earth fraction (2 mm), the Bt horizon must contain at least 3% more clay, e.g., Ae 10% clay, Bt minimum 13% clay. b) If the eluvial horizon has more than 15% and less than 40% total clay in the fine earth fraction, the ratio of the clay in the Bt horizon to that in the eluvial horizon must be 1.2 or more, e.g., 20% clay increase in the Bt over Ae. c) If the eluvial horizon has more than 40% total clay in the fine earth fraction, the Bt horizon must contain at least 8% more clay than the eluvial horizon, e.g., Ae 50% clay, Bt at least 58% clay. 2. A Bt horizon must be at least 5 cm thick. In some sandy soils where clay accumulation occurs in the lamellae, the total thickness of the lamellae should be more than 10 cm in the upper 150 cm of the profile. 3. In massive soils the Bt horizon should have oriented clays in some pores and also as bridges between the sand grains. 4. If peds are present, a Bt horizon shows clay skins on some of the vertical and horizontal ped surfaces and in the fine pores, or shows oriented clays in 1% or more of the cross section, as viewed in thin section. 5. If a soil shows a lithologic discontinuity between the eluvial horizon and the Bt horizon, or if only a plow layer overlies the Bt horizon, the Bt horizon need show only clay skins in some part, either in some fine pores or on some vertical and horizontal ped surfaces. Thin sections should show that some part of the horizon has about 1% or more of oriented clay bodies. Btj Btj and Btg are defined under j and g. u A horizon that is markedly disrupted by physical or faunal processes other than cryoturbation. Evidence of marked disruption such as the inclusion of material from other horizons, absence of the horizon, etc., must be evident in at least half of the cross section of the pedon. Such turbation can result from blowdown of trees, mass movement of soil on slopes, and burrowing animals. It can be used with any horizon or subhorizon with the exception of A or B alone; e.g., Aeu, Bfu, BCu. x A horizon of fragipan character. A fragipan is a loamy subsurface horizon of high bulk density and very low organic matter content. When dry, it has a hard consistence and seems to be cemented. When moist, it has moderate to weak brittleness. It frequently has bleached fracture planes and is overlain by a friable B horizon. Air dry clods of fragic horizons slake in water. y A horizon affected by cryoturbation as manifested by disrupted and broken horizons, incorporation of materials from other horizons, and mechanical sorting in at least half of the cross section of the pedon. It is used with A, B, and C alone or in combination with other subscripts, e.g., Ahy, Ahgy, Bmy, Cy, Cgy, Cygj, etc. z A frozen layer. It may be used with any horizon or layer, e.g., Ohz, Bmz, Cz, Wz. START_DEPTH The start depth from the surface where the sample was collected. END_DEPTH The end depth from the surface where the sample was collected. BULK_DENSITY Bulk density of the soil sample. TOTAL_SOIL_C_CONTENT The percent total carbon in the soil sample. SOIL_ORG_C_CONTENT The percent organic carbon in the soil sample. SOIL_INORG_C_CONTENT The percent inorganic carbon in the soil sample. CATION_EX_CAPACITY The cation exchange capacity in the soil sample. EXCHANGE_SODIUM The exchangeable sodium in the soil sample. EXCHANGE_POTASSIUM The exchangeable potassium in the soil sample. EXCHANGE_CALCIUM The exchangeable calcium in the soil sample. EXCHANGE_MAGNESIUM The exchangeable magnesium in the soil sample. WATER_CONTENT_10KPA The water content of the soil in percent by weight of water held at 0.01 MegaPascals. WATER_CONTENT_33KPA The water content of the soil in percent by weight of water held at 0.033 MegaPascals. WATER_CONTENT_1500KPA The water content of the soil in percent by weight of water held at 1.5 MegaPascals. SOIL_NITROGEN_CONTENT The nitrogen content of the soil sample. SOIL_PHOSPHORUS_CONTENT The phosphorus content of the soil sample. VERY_COARSE_SAND The amount of very coarse sand in the soil sample. COARSE_SAND The amount of coarse sand in the soil sample. MEDIUM_SAND The amount of medium sand in the soil sample. FINE_SAND The amount of fine sand in the soil sample. VERY_FINE_SAND The amount of very fine sand in the soil sample. TOTAL_SAND The total amount of sand in the soil sample. TOTAL_SILT The total amount of silt in the soil sample. TOTAL_CLAY The total amount of total clay in the soil sample. SOIL_TEXTURE The texture of the soil sample. HORIZON_NUM The number of the horizon. MINRL_SOIL_AND_CACL2_PH The pH of a 1:2 soil to CaCl2 mixture using mineral soil. ORG_SOIL_AND_CACL2_PH The pH of a 1:10 soil to CaCl2 mixture using organic soil. MINRL_SOIL_AND_H2O_PH The pH of a 1:2 soil to H2O mixture using mineral soil. ORG_SOIL_AND_H2O_PH The pH of a 1:10 soil to H2O mixture using organic soil. SOIL_EXTRACT_ACIDITY The extractable acidity in the soil sample. SOIL_SULFUR_CONTENT The sulfur content in the soil sample. CRTFCN_CODE The BOREAS certification level of the data. Examples are CPI (Checked by PI), CGR (Certified by Group), PRE (Preliminary), and CPI-??? (CPI but questionable). REVISION_DATE The most recent date when the information in the referenced data base table record was revised. 7.3.3 Unit of Measurement The measurement units for the parameters contained in the data files on the CD-ROM are: Column Name Units ------------------------------ ------------------------------------------------ SITE_NAME [none] SUB_SITE [none] MEASUREMENT_YEAR [unitless] PIT [none] HORIZON [none] START_DEPTH [meters] END_DEPTH [meters] BULK_DENSITY [kilograms][meter^-3] TOTAL_SOIL_C_CONTENT [percent] SOIL_ORG_C_CONTENT [percent] SOIL_INORG_C_CONTENT [percent] CATION_EX_CAPACITY [millimoles +ve charge][kilograms^-1 of soil] EXCHANGE_SODIUM [millimoles +ve charge][kilograms^-1 of soil] EXCHANGE_POTASSIUM [millimoles +ve charge][kilograms^-1 of soil] EXCHANGE_CALCIUM [millimoles +ve charge][kilograms^-1 of soil] EXCHANGE_MAGNESIUM [millimoles +ve charge][kilograms^-1 of soil] WATER_CONTENT_10KPA [percent] WATER_CONTENT_33KPA [percent] WATER_CONTENT_1500KPA [percent] SOIL_NITROGEN_CONTENT [percent by weight] SOIL_PHOSPHORUS_CONTENT [percent by weight] VERY_COARSE_SAND [percent] COARSE_SAND [percent] MEDIUM_SAND [percent] FINE_SAND [percent] VERY_FINE_SAND [percent] TOTAL_SAND [percent] TOTAL_SILT [percent] TOTAL_CLAY [percent] SOIL_TEXTURE [none] HORIZON_NUM [unitless] MINRL_SOIL_AND_CACL2_PH [pH] ORG_SOIL_AND_CACL2_PH [pH] MINRL_SOIL_AND_H2O_PH [pH] ORG_SOIL_AND_H2O_PH [pH] SOIL_EXTRACT_ACIDITY [millimoles][kilogram^-1] SOIL_SULFUR_CONTENT [percent by weight] CRTFCN_CODE [none] REVISION_DATE [DD-MON-YYYY] 7.3.4 Data Source The source of the parameter values contained in the data files on the CD-ROM are: Column Name Data Source ------------------------------ ------------------------------------------------ SITE_NAME [Assigned by BORIS] SUB_SITE [Assigned by BORIS] MEASUREMENT_YEAR [Supplied by Investigator] PIT [Supplied by Investigator] HORIZON [Supplied by Investigator] START_DEPTH [Supplied by Investigator] END_DEPTH [Supplied by Investigator] BULK_DENSITY [Supplied by Investigator] TOTAL_SOIL_C_CONTENT [Supplied by Investigator] SOIL_ORG_C_CONTENT [Supplied by Investigator] SOIL_INORG_C_CONTENT [Supplied by Investigator] CATION_EX_CAPACITY [Supplied by Investigator] EXCHANGE_SODIUM [Supplied by Investigator] EXCHANGE_POTASSIUM [Supplied by Investigator] EXCHANGE_CALCIUM [Supplied by Investigator] EXCHANGE_MAGNESIUM [Supplied by Investigator] WATER_CONTENT_10KPA [Supplied by Investigator] WATER_CONTENT_33KPA [Supplied by Investigator] WATER_CONTENT_1500KPA [Supplied by Investigator] SOIL_NITROGEN_CONTENT [Supplied by Investigator] SOIL_PHOSPHORUS_CONTENT [Supplied by Investigator] VERY_COARSE_SAND [Supplied by Investigator] COARSE_SAND [Supplied by Investigator] MEDIUM_SAND [Supplied by Investigator] FINE_SAND [Supplied by Investigator] VERY_FINE_SAND [Supplied by Investigator] TOTAL_SAND [Supplied by Investigator] TOTAL_SILT [Supplied by Investigator] TOTAL_CLAY [Supplied by Investigator] SOIL_TEXTURE [Supplied by Investigator] HORIZON_NUM [Supplied by Investigator] MINRL_SOIL_AND_CACL2_PH [Supplied by Investigator] ORG_SOIL_AND_CACL2_PH [Supplied by Investigator] MINRL_SOIL_AND_H2O_PH [Supplied by Investigator] ORG_SOIL_AND_H2O_PH [Supplied by Investigator] SOIL_EXTRACT_ACIDITY [Supplied by Investigator] SOIL_SULFUR_CONTENT [Supplied by Investigator] CRTFCN_CODE [Assigned by BORIS] REVISION_DATE [Assigned by BORIS] 7.3.5 Data Range The following table gives information about the parameter values found in the data files on the CD-ROM. Minimum Maximum Missng Unrel Below Data Data Data Data Data Detect Not Column Name Value Value Value Value Limit Cllctd -------------------------------------------------------------------------------- SITE_NAME NSA-9BS-9TETR NSA-YJP-FLXTR None None None None SUB_SITE 9TE20-SOL01 9TE20-SOL09 None None None None MEASUREMENT_YEAR 1994 1994 None None None None PIT 1 9 None None None None HORIZON 2AE OMZ4 None None None None START_DEPTH -65 495 None None None Blank END_DEPTH -34 495 -999 None None Blank BULK_DENSITY 0 1640 -999 None None None TOTAL_SOIL_C_CONTENT .03 50.46 None None None None SOIL_ORG_C_CONTENT 0 50.46 None None None None SOIL_INORG_C_CONTENT 0 29.96 None None None None CATION_EX_CAPACITY .5 193.5 -999 None None None EXCHANGE_SODIUM 0 .4 -999 None None None EXCHANGE_POTASSIUM 0 2.8 -999 None None None EXCHANGE_CALCIUM 0 160.9 -999 None None None EXCHANGE_MAGNESIUM 0 25.6 -999 None None None WATER_CONTENT_10KPA 0 763.3 None None None None WATER_CONTENT_33KPA 0 289.3 -999 None None None WATER_CONTENT_ 0 222.4 -999 None None None 1500KPA SOIL_NITROGEN_ .001 2.523 None None None None CONTENT SOIL_PHOSPHORUS_ 0 0 None None None None CONTENT VERY_COARSE_SAND -.2 55.3 -999 None None Blank COARSE_SAND 0 71.4 -999 None None None MEDIUM_SAND 0 45.5 -999 None None None FINE_SAND 0 79.8 -999 None None None VERY_FINE_SAND 0 12.8 -999 None None None TOTAL_SAND 0 99.7 -999 None None None TOTAL_SILT 0 70.9 -999 None None None TOTAL_CLAY 0 97.7 -999 None None None SOIL_TEXTURE N/A N/A None None None Blank HORIZON_NUM 01 13 None None None None MINRL_SOIL_AND_CACL2_ 0 7.7 None None None None PH ORG_SOIL_AND_CACL2_ 0 6.6 None None None None PH MINRL_SOIL_AND_H2O_ 0 8.3 None None None None PH ORG_SOIL_AND_H2O_PH 0 7.1 None None None None SOIL_EXTRACT_ACIDITY 0 137.2 -999 None None None SOIL_SULFUR_CONTENT 0 0 None None None None CRTFCN_CODE CPI CPI None None None None REVISION_DATE 19-NOV-1996 19-NOV-1996 None None None None -------------------------------------------------------------------------------- Minimum Data Value -- The minimum value found in the column. Maximum Data Value -- The maximum value found in the column. Missng Data Value -- The value that indicates missing data. This is used to indicate that an attempt was made to determine the parameter value, but the attempt was unsuccessful. Unrel Data Value -- The value that indicates unreliable data. This is used to indicate an attempt was made to determine the parameter value, but the value was deemed to be unreliable by the analysis personnel. Below Detect Limit -- The value that indicates parameter values below the instruments detection limits. This is used to indicate that an attempt was made to determine the parameter value, but the analysis personnel determined that the parameter value was below the detection limit of the instrumentation. Data Not Cllctd -- This value indicates that no attempt was made to determine the parameter value. This usually indicates that BORIS combined several similar but not identical data sets into the same data base table but this particular science team did not measure that parameter. Blank -- Indicates that blank spaces are used to denote that type of value. N/A -- Indicates that the value is not applicable to the respective column. None -- Indicates that no values of that sort were found in the column. -------------------------------------------------------------------------------- 7.4 Sample Data Record SITE_NAME,SUB_SITE,MEASUREMENT_YEAR,PIT,HORIZON,START_DEPTH,END_DEPTH, BULK_DENSITY,TOTAL_SOIL_C_CONTENT,SOIL_ORG_C_CONTENT,SOIL_INORG_C_CONTENT, CATION_EX_CAPACITY,EXCHANGE_SODIUM,EXCHANGE_POTASSIUM,EXCHANGE_CALCIUM, EXCHANGE_MAGNESIUM,WATER_CONTENT_10KPA,WATER_CONTENT_33KPA, WATER_CONTENT_1500KPA,SOIL_NITROGEN_CONTENT,SOIL_PHOSPHORUS_CONTENT, VERY_COARSE_SAND,COARSE_SAND,MEDIUM_SAND,FINE_SAND,VERY_FINE_SAND,TOTAL_SAND, TOTAL_SILT,TOTAL_CLAY,SOIL_TEXTURE,HORIZON_NUM,MINRL_SOIL_AND_CACL2_PH, ORG_SOIL_AND_CACL2_PH,MINRL_SOIL_AND_H2O_PH,ORG_SOIL_AND_H2O_PH, SOIL_EXTRACT_ACIDITY,SOIL_SULFUR_CONTENT,CRTFCN_CODE,REVISION_DATE 'NSA-9BS-9TETR','9TE20-SOL01','1994','1','CK',62.0,100.0,-999,22.73,.47,22.26, 19.4,.2,.4,19.4,3.1,41.9,35.9,21.4,.035,0.0,-999.0,-999.0,-999.0,-999.0,-999.0, .6,34.4,65.0,'HC','08',7.6,0.0,8.3,0.0,0.0,0.0,'CPI',19-NOV-1996 'NSA-9BS-9TETR','9TE20-SOL01','1994','1','L',-9.0,-7.0,50,32.16,32.16,0.0, -999.0,-999.0,-999.0,-999.0,-999.0,0.0,-999.0,-999.0,.879,0.0,0.0,0.0,0.0,0.0, 0.0,0.0,0.0,0.0,'','01',0.0,6.0,0.0,6.5,-999.0,0.0,'CPI',19-NOV-1996 --=====================_911856160==_--