{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "HorizonSuffixes", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "HorizonSuffixID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "Object identifier", "domain": null }, { "name": "HorizonSuffixID", "type": "esriFieldTypeString", "alias": "Unique horizon suffix identifier", "length": 12, "domain": null }, { "name": "LAYER_ID", "type": "esriFieldTypeString", "alias": "Layer identifier", "length": 11, "domain": null }, { "name": "SuffixNumber", "type": "esriFieldTypeSmallInteger", "alias": "Suffix order within horizon suffix string", "domain": null }, { "name": "Suffix", "type": "esriFieldTypeString", "alias": "Individual suffix for soil horizon", "length": 2, "domain": { "type": "codedValue", "name": "HorizonSuffix", "description": "Individual suffix for soil horizon", "codedValues": [ { "name": "b - A buried soil Horizon", "code": "b" }, { "name": "c - A cemented (irreversible) pedogenic horizon.", "code": "c" }, { "name": "ca - A horizon of secondary carbonate enrichment in which the concentration of lime exceeds that in the unenriched parent material.", "code": "ca" }, { "name": "cc - Cemented (irreversible) pedogenic concretions", "code": "cc" }, { "name": "e - A horizon characterized by the eluviation of clay, Fe, Al, or organic matter alone or in combination.", "code": "e" }, { "name": "f - A horizon enriched with amorphous material, principally Al and Fe combined with organic matter.", "code": "f" }, { "name": "g - A horizon characterized by gray colors, or prominent mottling, or both, indicating permanent or periodic intense reduction.", "code": "g" }, { "name": "h - A horizon enriched with organic matter.", "code": "h" }, { "name": "j - A modifier of suffixes for juvenile expression of e, f, g, n, t and v.", "code": "j" }, { "name": "k - Denotes the presence of carbonate as indicated by visible effervescence when dilute HCI is added.", "code": "k" }, { "name": "m - A horizon slightly altered by hydrolysis, oxidation, or solution, or all three to give a change in color or structure, or both.", "code": "m" }, { "name": "n - A horizon in which the ratio of exchangeable Ca to exchangeable Na is 10 or less.", "code": "n" }, { "name": "p - A horizon disturbed by man's activities such as cultivation, logging, and habitation.", "code": "p" }, { "name": "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.", "code": "s" }, { "name": "sa - A horizon with secondary enrichment of salts more soluble than Ca and Mg carbonates; the concentration of salts exceeds that in the unenriched parent material.", "code": "sa" }, { "name": "ss - Denotes the presence of several (more than two) slickensides.", "code": "ss" }, { "name": "t - An illuvial horizon enriched with silicate clay.", "code": "t" }, { "name": "u - A horizon that is markedly disrupted by physical or faunal processes other than cryoturbation or argillipedoturbation caused by Vertisolic processes.", "code": "u" }, { "name": "v - A horizon affected by argillipedoturbation, as manifested by disruption and mixing caused by shrinking and swelling of the soil mass.", "code": "v" }, { "name": "x - A horizon of fragipan character.", "code": "x" }, { "name": "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.", "code": "y" }, { "name": "z - A frozen layer.", "code": "z" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R220_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G804LAYER_ID", "fields": "LAYER_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "SoilLayers", "relatedTableId": 10, "role": "esriRelRoleDestination", "keyField": "LAYER_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8E7CC9B8-2238-4DAD-9F74-8BF226C978F4}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 50000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "7a7edcd8ad2649d69c3c151bf9455b35" }