ftp://ftp-fc.sc.egov.usda.gov/NSSC/NCCPI/NCCPI_user_guide.pdf<\/SPAN><\/A><\/SPAN><\/P>The map unit average root zone depth values for commodity crops are given in centimeters for major earthy components. Criteria for root-limiting soil depth include: presence of hard bedrock, soft bedrock, a fragipan, a duripan, sulfuric material, a dense layer, a layer having a pH of less than 3.5, or a layer having an electrical conductivity of more than 12 within the component soil profile. If no root-restricting zone is identified, a depth of 150 cm is used to approximate the root zone depth (Dobos et al., 2012). <\/SPAN><\/SPAN><\/P>The map unit average available water storage within the root zone depth for major earthy components value is given in millimeters.<\/SPAN><\/SPAN><\/P>Drought vulnerable soil landscapes comprise those map units that have available water storage within the root zone for commodity crops that is less than or equal to 6 inches (152 mm) expressed as \"1\" for a drought vulnerable soil landscape map unit or \"0\" for a nondroughty soil landscape map unit or NULL for miscellaneous areas (includes water bodies).<\/SPAN><\/SPAN><\/P>The potential wetland soil landscapes (PWSL version 1) information is given as the percentage of the map unit (all components) that meet the criteria for a potential wetland soil landscape. See table column (field) description for criteria details. If water was determined to account for 80 or greater percent of a map unit, a value of 999 was used to indicate a water body. This is not a perfect solution, but is helpful to identifying a general water body class for mapping.<\/SPAN><\/SPAN><\/P>The map unit sum of the component percentage representative values is also provided as useful metadata. For all valu table columns, NULL values are presented where data are incomplete or not available. <\/SPAN><\/SPAN><\/P>How NoData or NULL values and incomplete data were handled during VALU table SOC and AWS calculations:<\/SPAN><\/SPAN><\/P>The gSSURGO calculations for SOC and AWS as reported in the VALU table use the following data checking and summarization rules. The guiding principle was to only use the official data in the SSURGO database, and not to make assumptions in case there were some data entry errors. However, there were a few exceptions to this principle if there was a good reason for a Null value in a critical variable, or to accommodate the data coding conventions used in some soil surveys.<\/SPAN><\/SPAN><\/P>Horizon depths considerations:<\/SPAN><\/P>If the depth to the top of the surface horizon was missing, but otherwise the horizon depths were all okay, then the depth to the top of the surface horizon (hzdept_r) was set to zero.<\/SPAN><\/SPAN><\/P>If the depth to the bottom of the last horizon was missing, and the horizon represented bedrock or had missing bulk density, the depth to the bottom was set to equal to the depth to the top of the same horizon (hzdepb_r = hzdept_r), effectively giving the horizon zero thickness (and thus zero SOC or AWS), but not blocking calculation of other horizons in the profile due to horizon depth errors.<\/SPAN><\/SPAN><\/P>Other types of horizon depth errors were considered uncorrectable, and led to all horizon depths for the component being set to a NoData value, effectively eliminating the component from the analysis. The errors included gaps or overlaps in the horizon depths of the soil profile, other cases of missing data for horizon depths, including missing data for the bottom depth of the last horizon if the soil texture information did not indicate bedrock and a bulk density value was coded. The SOC or AWS values were effectively set to zero for components eliminated in this way, so the values at the map unit level could be an underestimate for some soils.<\/SPAN><\/SPAN><\/P>Horizon rock fragment considerations:<\/SPAN><\/P>Part of the algorithm for calculating the SOC requires finding the volume of soil that is not rock. This requires three SSURGO variables that indicate rock fragments (fraggt10_r, frag3to10_r, and sieveno10_r). If the soil is not organic, and any of these are missing, then the ratio of the volume of soil fines to the total soil volume was set to \u201cNoData\u201d, and the SOC results were coded as \u201cNoData\u201d and effectively set to zero for the horizon. If the soil is organic, then it may be logical that no measurement of rock fragments was made, and default values for the \u201czero rock\u201d situation was assumed for these variables (i.e., fraggt10_r = 0, frag3to10_r = 0, sieveno10_r = 100). Organic soils were identified by an \u201cO\u201d in the horizon designator or the texture code represented \u201cPeat\u201d, \u201cMuck\u201d or \u201cDecomposed Plant Material\u201d. If all three of the fragment variables were present, but indicated more than 100% rock, then 100% rock was assumed (zero volume of soil and thus zero for SOC). The rock fragment variables do not influence the AWS calculation because rock content is already accounted for in the available water capacity (awc_r) variable at the horizon level.<\/SPAN><\/SPAN><\/P>Horizon to component summary:<\/SPAN><\/P>To summarize data from the horizon level to the component level, the evaluation proceeded downward from the surface. If a valid value for AWS could not be calculated for any horizon, then the result for that horizon and all deeper horizons was set to NoData. The same rule was separately applied to the SOC calculation, so it was possible to have results for SOC but not AWS, or vice versa.<\/SPAN><\/SPAN><\/P>Component to mapunit summary:<\/SPAN><\/P>To summarize data from the component level to the map unit level, the component percentages must be valid. There are tests both of the individual component percentage (comppct_r) data, and also of the sum of the component percentages at the map unit level (mu_sum_comppct_r). <\/SPAN><\/SPAN><\/P>For the gSSURGO VALU table, the following rules were applied for the individual components: 1) The comppct_r must be in the range from 0 to 100, inclusive. 2) Individual components with a comppct_r that was Null (nothing coded) were ignored. A zero comppct_r value excludes the component from having an effect on the map unit calculation. No values more than 100% were found in the data for individual comppct_r.<\/SPAN><\/SPAN><\/P>Two additional rules were applied for the sum of the component percentages in a map unit (ignoring NoData for comppct_r): 3) The mu_sum_comppct_r must be in the range from 1 to 100, inclusive, otherwise map unit level output was set to NoData, and 4) The mu_sum_comppct_r were not scaled to equal 100%. With these rules, the results may be an under-estimate of the value for AWS or SOC compared to what would have been calculated if there were complete data and/or no comppct_r errors.<\/SPAN><\/SPAN><\/P>Metadata variables: sums of component percentages:<\/SPAN><\/P>Several metadata variables are provided in the VALU table to help understand when the AWS and SOC values are underestimated because of these component percentage issues. The sum of the component percentages for the map unit are reported in \u201cmu_sum_comppct_r\u201d. If this is greater than 100% or the comppct_r was NoData for all components, then no results will be given for the map unit. If the mu_sum_comppct_r is less than 100%, then the soil scientists likely did not report on all soils in the map unit. The AWS and SOC values will only reflect the reported soils, and therefore would be an underestimate if the unreported soils would have had values for these measures.<\/SPAN><\/SPAN><\/P>The sums of the component percentages that were used in the AWS and SOC calculations are also reported (mu_sum_comppct_aws and mu_sum_comppct_soc, respectively). If these values are less than the mu_sum_comppct_r, it is an indication that there was insufficient data to compute the AWS and/or SOC values for all of the components. These variables essentially represent metadata for each map unit. In some cases, the lack of an AWS or SOC value may be appropriate (for example, for non-soils such as bedrock at the surface, gravel pits, or water).<\/SPAN><\/SPAN><\/P>A full discussion of these rules and their implications, including explicit examples, will be given in a forthcoming publication as Soil Survey Investigations Report No. 53, USDA NRCS, Lincoln, NE.<\/SPAN><\/SPAN><\/P><\/P><\/DIV><\/DIV><\/DIV>",
"geometryType": "esriGeometryPolygon",
"sourceSpatialReference": {
"wkid": 26915,
"latestWkid": 26915,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -5120900,
"falseY": -9998100,
"xyUnits": 10000,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
},
"copyrightText": "Soil Survey Staff, Natural Resources Conservation Service, United States Department of Agriculture. National value added look up (valu) table for Gridded Soil Survey Geographic (SSURGO) Database for the United States of America and the Territories, Commonwealths, and Island Nations served by the USDA NRCS. Available online at http://datagateway.nrcs.usda.gov/ October 15, 2012.",
"parentLayer": null,
"subLayers": [],
"minScale": 0,
"maxScale": 0,
"referenceScale": 0.0,
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [
194,
252,
181,
255
],
"outline": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
110,
110,
110,
255
],
"width": 0.7
}
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": false,
"extent": {
"xmin": 355106.9729000004,
"ymin": 3836352.6315,
"xmax": 609493.2614000002,
"ymax": 4040565.492900001,
"spatialReference": {
"wkid": 26915,
"latestWkid": 26915,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -5120900,
"falseY": -9998100,
"xyUnits": 10000,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"displayField": "muname",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "objectid",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "areasymbol",
"type": "esriFieldTypeString",
"alias": "Area Symbol",
"length": 20,
"domain": null
},
{
"name": "spatverson",
"type": "esriFieldTypeInteger",
"alias": "Spatial Version",
"domain": null
},
{
"name": "musym",
"type": "esriFieldTypeString",
"alias": "Mapunit Symbol",
"length": 6,
"domain": null
},
{
"name": "mukey",
"type": "esriFieldTypeString",
"alias": "Mapunit Key",
"length": 30,
"domain": null
},
{
"name": "natmusym",
"type": "esriFieldTypeString",
"alias": "NatMuSym",
"length": 6,
"domain": null
},
{
"name": "cellvalue",
"type": "esriFieldTypeInteger",
"alias": "CellValue",
"domain": null
},
{
"name": "muname",
"type": "esriFieldTypeString",
"alias": "Mapunit Name",
"length": 175,
"domain": null
},
{
"name": "mukind",
"type": "esriFieldTypeString",
"alias": "Kind",
"length": 254,
"domain": null
},
{
"name": "muacres",
"type": "esriFieldTypeInteger",
"alias": "Total Acres",
"domain": null
},
{
"name": "farmlndcl",
"type": "esriFieldTypeString",
"alias": "Farm Class",
"length": 254,
"domain": null
},
{
"name": "invesinten",
"type": "esriFieldTypeString",
"alias": "Order of Mapping",
"length": 254,
"domain": null
},
{
"name": "lkey",
"type": "esriFieldTypeString",
"alias": "Legend Key",
"length": 30,
"domain": null
},
{
"name": "aws0_5",
"type": "esriFieldTypeDouble",
"alias": "aws0_5",
"domain": null
},
{
"name": "aws5_20",
"type": "esriFieldTypeDouble",
"alias": "aws5_20",
"domain": null
},
{
"name": "aws20_50",
"type": "esriFieldTypeDouble",
"alias": "aws20_50",
"domain": null
},
{
"name": "aws50_100",
"type": "esriFieldTypeDouble",
"alias": "aws50_100",
"domain": null
},
{
"name": "aws100_150",
"type": "esriFieldTypeDouble",
"alias": "aws100_150",
"domain": null
},
{
"name": "aws150_999",
"type": "esriFieldTypeDouble",
"alias": "aws150_999",
"domain": null
},
{
"name": "aws0_20",
"type": "esriFieldTypeDouble",
"alias": "aws0_20",
"domain": null
},
{
"name": "aws0_30",
"type": "esriFieldTypeDouble",
"alias": "aws0_30",
"domain": null
},
{
"name": "aws0_100",
"type": "esriFieldTypeDouble",
"alias": "aws0_100",
"domain": null
},
{
"name": "aws0_150",
"type": "esriFieldTypeDouble",
"alias": "aws0_150",
"domain": null
},
{
"name": "aws0_999",
"type": "esriFieldTypeDouble",
"alias": "aws0_999",
"domain": null
},
{
"name": "tk0_5a",
"type": "esriFieldTypeDouble",
"alias": "tk0_5a",
"domain": null
},
{
"name": "tk5_20a",
"type": "esriFieldTypeDouble",
"alias": "tk5_20a",
"domain": null
},
{
"name": "tk20_50a",
"type": "esriFieldTypeDouble",
"alias": "tk20_50a",
"domain": null
},
{
"name": "tk50_100a",
"type": "esriFieldTypeDouble",
"alias": "tk50_100a",
"domain": null
},
{
"name": "tk100_150a",
"type": "esriFieldTypeDouble",
"alias": "tk100_150a",
"domain": null
},
{
"name": "tk150_999a",
"type": "esriFieldTypeDouble",
"alias": "tk150_999a",
"domain": null
},
{
"name": "tk0_20a",
"type": "esriFieldTypeDouble",
"alias": "tk0_20a",
"domain": null
},
{
"name": "tk0_30a",
"type": "esriFieldTypeDouble",
"alias": "tk0_30a",
"domain": null
},
{
"name": "tk0_100a",
"type": "esriFieldTypeDouble",
"alias": "tk0_100a",
"domain": null
},
{
"name": "tk0_150a",
"type": "esriFieldTypeDouble",
"alias": "tk0_150a",
"domain": null
},
{
"name": "tk0_999a",
"type": "esriFieldTypeDouble",
"alias": "tk0_999a",
"domain": null
},
{
"name": "musumcpcta",
"type": "esriFieldTypeDouble",
"alias": "musumcpcta",
"domain": null
},
{
"name": "soc0_5",
"type": "esriFieldTypeDouble",
"alias": "soc0_5",
"domain": null
},
{
"name": "soc5_20",
"type": "esriFieldTypeDouble",
"alias": "soc5_20",
"domain": null
},
{
"name": "soc20_50",
"type": "esriFieldTypeDouble",
"alias": "soc20_50",
"domain": null
},
{
"name": "soc50_100",
"type": "esriFieldTypeDouble",
"alias": "soc50_100",
"domain": null
},
{
"name": "soc100_150",
"type": "esriFieldTypeDouble",
"alias": "soc100_150",
"domain": null
},
{
"name": "soc150_999",
"type": "esriFieldTypeDouble",
"alias": "soc150_999",
"domain": null
},
{
"name": "soc0_20",
"type": "esriFieldTypeDouble",
"alias": "soc0_20",
"domain": null
},
{
"name": "soc0_30",
"type": "esriFieldTypeDouble",
"alias": "soc0_30",
"domain": null
},
{
"name": "soc0_100",
"type": "esriFieldTypeDouble",
"alias": "soc0_100",
"domain": null
},
{
"name": "soc0_150",
"type": "esriFieldTypeDouble",
"alias": "soc0_150",
"domain": null
},
{
"name": "soc0_999",
"type": "esriFieldTypeDouble",
"alias": "soc0_999",
"domain": null
},
{
"name": "tk0_5s",
"type": "esriFieldTypeDouble",
"alias": "tk0_5s",
"domain": null
},
{
"name": "tk5_20s",
"type": "esriFieldTypeDouble",
"alias": "tk5_20s",
"domain": null
},
{
"name": "tk20_50s",
"type": "esriFieldTypeDouble",
"alias": "tk20_50s",
"domain": null
},
{
"name": "tk50_100s",
"type": "esriFieldTypeDouble",
"alias": "tk50_100s",
"domain": null
},
{
"name": "tk100_150s",
"type": "esriFieldTypeDouble",
"alias": "tk100_150s",
"domain": null
},
{
"name": "tk150_999s",
"type": "esriFieldTypeDouble",
"alias": "tk150_999s",
"domain": null
},
{
"name": "tk0_20s",
"type": "esriFieldTypeDouble",
"alias": "tk0_20s",
"domain": null
},
{
"name": "tk0_30s",
"type": "esriFieldTypeDouble",
"alias": "tk0_30s",
"domain": null
},
{
"name": "tk0_100s",
"type": "esriFieldTypeDouble",
"alias": "tk0_100s",
"domain": null
},
{
"name": "tk0_150s",
"type": "esriFieldTypeDouble",
"alias": "tk0_150s",
"domain": null
},
{
"name": "tk0_999s",
"type": "esriFieldTypeDouble",
"alias": "tk0_999s",
"domain": null
},
{
"name": "musumcpcts",
"type": "esriFieldTypeDouble",
"alias": "musumcpcts",
"domain": null
},
{
"name": "nccpi2cs",
"type": "esriFieldTypeDouble",
"alias": "nccpi2cs",
"domain": null
},
{
"name": "nccpi2sg",
"type": "esriFieldTypeDouble",
"alias": "nccpi2sg",
"domain": null
},
{
"name": "nccpi2co",
"type": "esriFieldTypeDouble",
"alias": "nccpi2co",
"domain": null
},
{
"name": "nccpi2all",
"type": "esriFieldTypeDouble",
"alias": "nccpi2all",
"domain": null
},
{
"name": "pctearthmc",
"type": "esriFieldTypeDouble",
"alias": "pctearthmc",
"domain": null
},
{
"name": "rootznemc",
"type": "esriFieldTypeDouble",
"alias": "rootznemc",
"domain": null
},
{
"name": "rootznaws",
"type": "esriFieldTypeDouble",
"alias": "rootznaws",
"domain": null
},
{
"name": "droughty",
"type": "esriFieldTypeInteger",
"alias": "droughty",
"domain": null
},
{
"name": "pwsl1pomu",
"type": "esriFieldTypeInteger",
"alias": "pwsl1pomu",
"domain": null
},
{
"name": "musumcpct",
"type": "esriFieldTypeSmallInteger",
"alias": "musumcpct",
"domain": null
},
{
"name": "shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape",
"domain": null
},
{
"name": "st_area(shape)",
"type": "esriFieldTypeDouble",
"alias": "st_area(shape)",
"domain": null
},
{
"name": "st_length(shape)",
"type": "esriFieldTypeDouble",
"alias": "st_length(shape)",
"domain": null
}
],
"geometryField": {
"name": "shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape"
},
"indexes": [
{
"name": "r287_sde_rowid_uk",
"fields": "objectid",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "a273_ix1",
"fields": "shape",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"subtypes": [],
"relationships": [],
"canModifyLayer": true,
"canScaleSymbols": false,
"hasLabels": false,
"capabilities": "Map,Query,Data",
"maxRecordCount": 200,
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"isDataVersioned": false,
"ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true},
"useStandardizedQueries": true,
"supportedSpatialRelationships": [
"esriSpatialRelIntersects",
"esriSpatialRelContains",
"esriSpatialRelCrosses",
"esriSpatialRelEnvelopeIntersects",
"esriSpatialRelIndexIntersects",
"esriSpatialRelOverlaps",
"esriSpatialRelTouches",
"esriSpatialRelWithin",
"esriSpatialRelRelation"
],
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsPagination": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsTrueCurve": true,
"supportsQueryWithDatumTransformation": true,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true,
"supportsTimeRelation": true,
"supportsSqlFormat": false,
"supportsQueryAnalytic": true
},
"supportsDatumTransformation": true,
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": false
},
"dateFieldsTimeReference": null,
"preferredTimeReference": null,
"datesInUnknownTimezone": false,
"hasGeometryProperties": true,
"geometryProperties": {
"shapeAreaFieldName": "st_area(shape)",
"shapeLengthFieldName": "st_length(shape)",
"units": "esriMeters"
},
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true
}