Name: SoilNames

Display Field: SOILNAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 7a7edcd8ad2649d69c3c151bf9455b35

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 50000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SOIL_ID ( type: esriFieldTypeString, alias: SOIL_ID, length: 9 )
• SOIL_CODE ( type: esriFieldTypeString, alias: SOIL_CODE, length: 3 )
• MODIFIER ( type: esriFieldTypeString, alias: MODIFIER, length: 5 , Coded Values: [aa~~~: aa - Non-modal area] , [aagl~: aagl - Non-modal area and gleyed] , [aapt~: aapt - Non-modal area and peaty surface] , ...78 more... )
• PROFILE ( type: esriFieldTypeString, alias: Profile Type, length: 1 , Coded Values: [A: A - Agricultural] , [N: N - Native] )
• SOILNAME ( type: esriFieldTypeString, alias: Soil Series, length: 24 )
• SCA ( type: esriFieldTypeSmallInteger, alias: Soil Correlation Area )
• DRAINAGE ( type: esriFieldTypeString, alias: Drainage, length: 2 , Coded Values: [VR: VR - Very rapidly] , [R: R - Rapidly] , [W: W - Well] , ...4 more... )
• CALCAR ( type: esriFieldTypeString, alias: Calcareousness, length: 1 , Coded Values: [N: N - Noncalcareous (< 1% CaCO3 equiv.)] , [W: W - Weakly (1-5% CaCO3 equiv.)] , [M: M - Moderately (6-15% CaCO3 equiv.)] , ...3 more... )
• SALINITY ( type: esriFieldTypeString, alias: Salinity, length: 1 , Coded Values: [N: N - Non to very weakly (< 4 dS/m)] , [W: W - Weakly (4-8 dS/m)] , [M: M - Moderately (8-15 dS/m)] , ...1 more... )
• KIND ( type: esriFieldTypeString, alias: Kind of Material, length: 1 , Coded Values: [M: M - Mineral] , [O: O - Organic] , [N: N - True Non-soil] , ...1 more... )
• WATERTBL ( type: esriFieldTypeString, alias: Watertable Characteristics , length: 2 , Coded Values: [YB: YB - Always] , [YG: YG - Growing season] , [YN: YN - Non-growing season] , ...2 more... )
• ROOTRESTRI ( type: esriFieldTypeSmallInteger, alias: Root Restricting Layer )
• RESTR_TYPE ( type: esriFieldTypeString, alias: Root Restriction, length: 2 , Coded Values: [UN: UN - Undifferentiated] , [BN: BN - Solonetzic B horizon] , [SA: SA - Salinity (conductivity > 4dS/m)] , ...7 more... )
• PM1_TEX ( type: esriFieldTypeString, alias: Parent Material Texture (1), length: 4 , Coded Values: [CBCT: CBCT - Cobbly (20 - 50% by volume), 7.5 cm - 25 cm; Coarse Textured Group] , [CBFI: CBFI - Cobbly (20 - 50% by volume), 7.5 cm - 25 cm; Fine textured: clay, silty clay and sandy clay] , [CBFT: CBFT - Cobbly (20 - 50% by volume), 7.5 cm - 25 cm; Fine Textured Group] , ...71 more... )
• PM2_TEX ( type: esriFieldTypeString, alias: Parent Material Texture (2), length: 4 , Coded Values: [CBCT: CBCT - Cobbly (20 - 50% by volume), 7.5 cm - 25 cm; Coarse Textured Group] , [CBFI: CBFI - Cobbly (20 - 50% by volume), 7.5 cm - 25 cm; Fine textured: clay, silty clay and sandy clay] , [CBFT: CBFT - Cobbly (20 - 50% by volume), 7.5 cm - 25 cm; Fine Textured Group] , ...71 more... )
• PM1_TYP ( type: esriFieldTypeString, alias: Parent Material Genesis (1), length: 4 , Coded Values: [BRCG: BRCG - Bedrock, conglomerate (lithic)] , [BRGR: BRGR - Bedrock, granitic (lithic)] , [BRLS: BRLS - Bedrock, limestone (lithic)] , ...27 more... )
• PM2_TYP ( type: esriFieldTypeString, alias: Parent Material Genesis (2), length: 4 , Coded Values: [BRCG: BRCG - Bedrock, conglomerate (lithic)] , [BRGR: BRGR - Bedrock, granitic (lithic)] , [BRLS: BRLS - Bedrock, limestone (lithic)] , ...27 more... )
• MAS_PM ( type: esriFieldTypeString, alias: Parent Material Code, length: 3 , Coded Values: [C0: C0 - Coarse textured (S, LS, SL) material (undifferentiated)] , [C1: C1 - Gravels or gravely (cobbly/stony) coarse textured material] , [C2: C2 - Very coarse (S, LS) sediments deposited by wind or water] , ...44 more... )
• PMTEX1 ( type: esriFieldTypeString, alias: Parent Material Texture (1) - NSDB, length: 2 , Coded Values: [VC: VC - Very Coarse] , [C: C - Coarse] , [MC: MC - Moderately Coarse] , ...14 more... )
• PMTEX2 ( type: esriFieldTypeString, alias: Parent Material Texture (2) - NSDB, length: 2 , Coded Values: [VC: VC - Very Coarse] , [C: C - Coarse] , [MC: MC - Moderately Coarse] , ...14 more... )
• PMTEX3 ( type: esriFieldTypeString, alias: Parent Material Texture (3) - NSDB, length: 2 , Coded Values: [VC: VC - Very Coarse] , [C: C - Coarse] , [MC: MC - Moderately Coarse] , ...14 more... )
• PMCHEM1 ( type: esriFieldTypeString, alias: Parent Material Chemistry (1) - NSDB, length: 2 , Coded Values: [UD: UD - Undifferentiated acidity and/or calcareousness] , [EA: EA - Extremely / Strongly Acidic (pH < 5.6)] , [AN: AN - Medium Acid to Neutral (pH 5.6 - 7.4)] , ...4 more... )
• PMCHEM2 ( type: esriFieldTypeString, alias: Parent Material Chemistry (2) - NSDB, length: 2 , Coded Values: [UD: UD - Undifferentiated acidity and/or calcareousness] , [EA: EA - Extremely / Strongly Acidic (pH < 5.6)] , [AN: AN - Medium Acid to Neutral (pH 5.6 - 7.4)] , ...4 more... )
• PMCHEM3 ( type: esriFieldTypeString, alias: Parent Material Chemistry (3) - NSDB, length: 2 , Coded Values: [UD: UD - Undifferentiated acidity and/or calcareousness] , [EA: EA - Extremely / Strongly Acidic (pH < 5.6)] , [AN: AN - Medium Acid to Neutral (pH 5.6 - 7.4)] , ...4 more... )
• MDEP1 ( type: esriFieldTypeString, alias: Mode of Deposition (1) - NSDB, length: 4 , Coded Values: [ANTH: ANTH - Anthropogenic] , [VOLC: VOLC - Volcanic] , [GLMA: GLMA - Glaciomarine] , ...33 more... )
• MDEP2 ( type: esriFieldTypeString, alias: Mode of Deposition (2) - NSDB, length: 4 , Coded Values: [ANTH: ANTH - Anthropogenic] , [VOLC: VOLC - Volcanic] , [GLMA: GLMA - Glaciomarine] , ...33 more... )
• MDEP3 ( type: esriFieldTypeString, alias: Mode of Deposition (3) - NSDB, length: 4 , Coded Values: [ANTH: ANTH - Anthropogenic] , [VOLC: VOLC - Volcanic] , [GLMA: GLMA - Glaciomarine] , ...33 more... )
• PROVINCE ( type: esriFieldTypeString, alias: Province - NSDB, length: 2 )
• ORDER3 ( type: esriFieldTypeString, alias: Soil Order, length: 2 , Coded Values: [BR: BR - Brunisolic] , [CH: CH - Chernozemic] , [CY: CY - Cryosolic] , ...7 more... )
• G_GROUP3 ( type: esriFieldTypeString, alias: Soil Great Group, length: 3 , Coded Values: [MB: MB - Melanic Brunisol] , [EB: EB - Eutric Brunisol] , [SB: SB - Sombric Brunisol] , ...27 more... )
• S_GROUP3 ( type: esriFieldTypeString, alias: Soil Subgroup, length: 8 , Coded Values: [O.MB: O.MB - Orthic Melanic Brunisol] , [E.MB: E.MB - Eluviated Melanic Brunisol] , [GL.MB: GL.MB - Gleyed Melanic Brunisol] , ...228 more... )
• SG_PHASE ( type: esriFieldTypeString, alias: Soil Subgroup Phase, length: 4 , Coded Values: [NA: NA - Not applicable] , [AC: AC - Acid] , [CA: CA - Calcareous] , ...9 more... )
• REPORT ( type: esriFieldTypeString, alias: Soil Survey Report, length: 50 )
• CORRNOTE ( type: esriFieldTypeString, alias: Soil Correlator Notes, length: 255 )

Relationships:

• SoilLayers (5) -- Related To: SoilLayers (10)
• SoilProfiles (6) -- Related To: SoilProfiles (12)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata