Appendix 1

AGRASID41 soil landscape polygons classified by Land Systems GIS coverage

AGRASID land systems classification are associated with AGRASID soil landscape polygons by joining to the table that describes the many to one relationship between an AGRASID soil landscape polygons and a corresponding AGRASID land system using the primary / foreign key called POLY_ID.

Table 1. AGRASID_SoilLandscapes, relevant portions of the table structure

Field Name Type Width Allowable values Explanation of Field Name
OBJECT ID Objectid Numeric   Internal identifier
SHAPE Geometry Na   Geographic shape object
POLY_ID Numeric Long   Soil polygon number, assigned by a soil analyst (PK)

The AGRASID soil landscapes to AGRASID land system; relationship table (ag41sl2ag41lslg) describes the relationship between one or more soil landscapes and a land system.

AGRASID_41_SoilLandscape polygons link to ag41sl2ag41lslg attribute table through the POLY_ID primary \ foreign key field.

Table 2. The structure of the ag41sl2ag41lslg attribute table

Field Name Type Width Explanation of Field Name
OBJECT ID Objectid Numeric Internal identifier
POLY_ID Numeric Long Soil polygon number, assigned by soil analyst. (FK)
MUNAME TEXT 18 Generated soil symbol based upon the soil data collected and documented by the soil mapper. For explanation of the concepts and symbol refer to Section 2.0 of the CAESA-SIP Manual.
ECODIST Text 6 This variable is a unique identifier for each eco-district area within the national ecological stratification of Canada. The code concatenates ECO_REG&”.”&ECO_DIST ECODIST describe ecological areas on municipal district and county scale.
ECO_REG Text 2 Ecoregion code (Table 2.1 in the CAESA-SIP Manual).
ECO_DIST Text 3 Ecodistrict code (Table 4.1 in the CAESA-SIP Manual).
LSYS_NO Text 2 Land system number. Unique number identifying each separate land system within an Ecodistrict.
LS_COMP Text 2 A code to differentiate between two or more parts of a land system that are not physically adjacent to each other and share the same land system characteristics.
LS_SYM Text 10 Land System Symbol is a unique identifier for each land system. This symbol concatenates ECO_REG&”.”&ECO_DIST&”.”&LSYS_NO. LS_SYM.
LSLGDSYM Text 10 Land System legend symbol uniquely identifies each part of a multiple part land system. This is the field for dissolving AGRASID_SoilLandscapes polygons into AGRASID_LandSystems polygons.
NAME Text 23 Land System name, which associates a prominent locality name with the land system’s predominant landform expression.
MORPHOL Text 11 Morphological descriptor (Table 4.2 in the CAESA-SIP Manual).
SCA Numeric Double Soil correlation area number – organizational unit for Alberta Soil Names.
SOIL_ZONE Text 14 Soil Zones based on Soil Correlation Areas of Alberta (SCAs) and the crosswalk table in Appendix 3, Table 2 of this document.
AG_CLIMATE Text 12 Agricultural climate rating from the Ecodistricts legend and as defined by the Land Suitability Rating System for Agricultural Crops(Table 4.1, CAESA-SIP Manual) and as defined by Chapter 3 of the Land Suitability Rating System for Agricultural Crops:1. Spring-seeded small grains (Agronomic Interpretations Working Group 1995).
ORD1 Text 6 Soil order of 1st representative soil Land System Manual, Table 3, Appendix 3 of this document.
ORD2 Text 6 Soil order of 2nd representative soil. Land System Manual, Table 3, Appendix 3 of this document.
MAJOR1 Text 8 1st major representative soil (greater than 20% of land system) see “NEW SYMBOL” values in Alberta Soil Names File and SOIL_ID values in AGRASID “SoilNames” table for context.
MAJOR2 Text 8 2nd major representative soil (greater than 20% of land system) see “NEW SYMBOL” values in Alberta Soil Names File and SOIL_ID values in AGRASID “SoilNames” table for context.
MAJOR3 Text 8 3rd major representative soil (greater than 20% of land system) see “NEW SYMBOL” values in Alberta Soil Names File and SOIL_ID values in AGRASID “SoilNames” table for context.
MINOR1 Text 8 1st minor representative soil (between 5 and 20% of land system) see “NEW SYMBOL” values in Alberta Soil Names File and SOIL_ID values in AGRASID “SoilNames” table for context.
MINOR2 Text 8 2nd minor representative soil (between 5 and 20% of land system) see “NEW SYMBOL” values in Alberta Soil Names File and SOIL_ID values in AGRASID “SoilNames” table for context.
SURFORM1 Text 11 1st representative landscape model (surface form and relief) Land System Manual, Table 1, Appendix 3 of this document.
SURFORM2 Text 11 2nd representative landscape model (surface form and relief) Land System Manual, Table 3, Appendix 3 of this document.
SURFORM3 Text 11 3rd representative landscape model (surface form and relief) Land System Manual, Table 3, Appendix 3 of this document.
ORD2 Text 6 Soil order of 2nd representative soil. Land System Manual, Table 3, Appendix 3 of this document.

Appendix 2

AGRASID41 LandSystem polygons

This is information about AGRASID land system spatial data and the associated legend table.

The AGRASID41 land system polygons and legend table (AGRASID41_LandSystemLegend) table contain data that describe land system features.

Previous versions of AGRASID did not contain a distinct land system spatial data set. Rather AGRASID soil landscapes each belonged to a land system. Users of AGRASID looking for a spatial representation of land systems generated there own land system spatial data by DISSOLVING AGRASID soil landscapes themselves based on the “LSLGDSYM” field. Appendix 1, table 2 of this document, contains the structure AGRASID soil landscapes to land system legend relationship table (ag41sl2ag41lslg).

Table 3. The structure of the AGRASID41_LandSystems spatial data

Field Name Type Width Explanation of Field Name
OBJECT ID Objectid Numeric Internal identifier
LSLGDSYM Text 10 Land System legend symbol uniquely identifies each part of a multiple part land system. This is the primary and foreign key permanently joins AGRASID_LandSystems polygons to AGRASID_LandSystemLegend attributes table (PK).

Table 4. The structure of the AGRASID41_LandSystemLegend attribute data

Field Name Type Width Explanation of Field Name
OBJECT ID Objectid Numeric Internal identifier
LSLGDSYM Text 10 Land System legend symbol uniquely identifies each part of a multiple part land system. This is the primary and foreign key permanently joins AGRASID_LandSystems polygons to AGRASID_LandSystemLegend attributes table (FK).
NAME Character 35 A unique geographic name given to each land system.
MORPHOL Character 20 Morphological descriptor (Table 4.2 in the CAESA-SIP Manual).
SCA Numeric 2 Soil correlation area number – organizational unit for Alberta Soil Names.
SOIL_ZONE Character 25 Soil Zones based on Soil Correlation Areas of Alberta (SCAs) and the crosswalk table in Appendix 3, Table 2 of this document.
AG_CLIMATE Character 5 Agricultural climate rating from the Ecodistricts legend and as defined by the Land Suitability Rating System for Agricultural Crops(Table 4.1, CAESA-SIP Manual) and as defined by Chapter 3 of the Land Suitability Rating System for Agricultural Crops:1. Spring-seeded small grains (Agronomic Interpretations Working Group 1995).
ORD1 Character 2 Soil order of 1st representative soil Land System Manual, Table 3, Appendix 3 of this document.
ORD2 Character 2 Soil order of 2nd representative soil Land System Manual, Table 3, Appendix 3 of this document.
MAJOR1 Character 6 1st major representative soil (greater than 20% of land system) see “NEW SYMBOL” values in Alberta Soil Names File and SOIL_ID values in AGRASID “SoilNames” table for context.
MAJOR2 Character 6 2nd major representative soil (greater than 20% of land system) see “NEW SYMBOL” values in Alberta Soil Names File and SOIL_ID values in AGRASID “SoilNames” table for context.
MAJOR3 Character 6 3rd major representative soil (greater than 20% of land system) see “NEW SYMBOL” values in Alberta Soil Names File and SOIL_ID values in AGRASID “SoilNames” table for context.
MINOR1 Character 6 1st minor representative soil (between 5 and 20% of land system) see “NEW SYMBOL” values in Alberta Soil Names File and SOIL_ID values in AGRASID “SoilNames” table for context.
MINOR2 Character 6 2nd minor representative soil (between 5 and 20% of land system) see “NEW SYMBOL” values in Alberta Soil Names File and SOIL_ID values in AGRASID “SoilNames” table for context.
SURFORM1 Character 5 1st representative landscape model (surface form and relief) Land System Manual, Table 1, Appendix 3 of this document.
SURFORM2 Character 5 2nd representative landscape model (surface form and relief) Land System Manual, Table 1, Appendix 3 of this document.
SURFORM3 Character 5 3rd representative landscape model (surface form and relief) Land System Manual, Table 1, Appendix 3 of this document.

Table 5. The structure of the AGRASID41_LandSystemGeneral tabular data

Field Name Type Width Explanation of Field Name
OBJECT ID Objectid Numeric Internal identifier
ECOREGION Numeric   Eco Region Number
ECOREGION_NAME Text 50 Eco Region Name
LSLGDSYM Text 10 Land System legend symbol uniquely identifies each part of a multiple part land system. This is the primary and foreign key permanently joins AGRASID_LandSystems polygons to AGRASID_LandSystemLegend attributes table (FK).
GENERALDESCRIPTION Text 1000 Land System General text Description.
REPRESENTATIVESOILSANDLANDSCAPES Text 1000 A text description of rRepresentative Soils and Landscapes contained within a Land System.

Appendix 3

Domain Tables describing coded data content in Appendices 1 and 2

Table 6. Landscape descriptions for Land System Legend generalized from AGRASID surface form codes

Landscape description for Land System Legend Surface Form Code for Soil Landscapes (Table 4.4 and 4.11, CAESA-SIP Procedures Manual)
Disturbed land DL, RR
Duned D1h, D1m, D1l, D2h, D2m, D2l
Floodplain FP1, FP2, FP3
Hummocky H1h, H1m, H1l, H2h, H2m, H2l, H3h,H3m,H3l,H4h,H4m,H4l
Hummocky (bedrock controlled) H5
Hummocky and plateau HP1
Hummocky and ridged HR1,HR2, HR2h
Inclined <10% exposed bedrock I3h,I3m, I3l
Inclined >10% exposed bedrock I4h, I4m, I4l
Inclined bedrock I1l
Level L1, L2, L3
Linear arranged water bodies (coolies) W1
Numerous water bodies W2, W3
Peatlands O1, O2, O3, O4, O5
Ridged R1h, R1m, R1l, R3h, R3m, R3l
Ridged (bedrock controlled) R2h, R2m, R2l
Rolling M1h, M1m
Sub-glacial channel features SC4
Undulating U1h, U1l
Undulating and inclined IUh, IUl
V-shaped valley SC3
Valley bottom SC2
Valley with confined floodplain SC1, SC1h

Table 7. Soil Zones based on Soil Correlation Area (SCA) descriptions

SCA Code Soil Zone Description
1 Brown
2 Dark brown
3 Dark brown
4 Dark brown
5 Thin black
6 Thin black
7 Thin black
8 Black
9 Black
10 Black-dark gray
12 Black-dary gray
13 Gray
16 Gray
17 Gray
18 Dark gray-black
20 Gray
21 Gray
22 Gray-dark gray

Table 8. Soil order code adapted from (Correlation Table ORDER located in appendix B: Code Descriptions for Alberta Soil Names File (Generation 4) , page 149

Soil Order Code Soil Order Description
BR Brunisols
CH Chernozems
GL Gleysols
LU Luvisols
OR Organic
RG Regosols
SZ Solonetz
VE Vertisols

Table 9. Parent material texture

AGRASID SoilNames Parent Material Code (Table 4.7, CAESA-SIP Procedures Manual) Parent Material Texture Description
C0 coarse textured material
C1 gravelly coarse textured material
C2 coarse textured sediments
C3 coarse textured sediments
C4 coarse textured till
C5 coarse textured till
C6 coarse textured softrock
C7 coarse grained bedrock
F0 fine textured material
F1 fine textured water-laid sediments
F2 very fine textured water-laid sediments
F3 fine textured water-laid sediments
F4 fine textured till
F5 fine textured softrock
F6 fine grained bedrock
L1 gravels over medium textured till
L2 coarse textured material over medium textured till
L3 medium textured material over medium textured till
L4 coarse over gravelly material
L5 medium textured over gravelly material
L6 till over softrock
L7 coarse textured material over softrock
L8 medium textured material over softrock
L9 coarse over fine textured material
L10 medium textured over fine textured material
L11 peat over coarse textured material
L12 peat over medium textured material
L13 peat over fine textured material
L14 gravelly medium textured material over medium textured till
L15 medium over coarse textured material
L16 gravelly coarse textured material over softrock
L18 medium textured over coarse textured material
L19 gravelly material over softrock
L20 coarse textured over medium textured material
M0 medium textured material
M1 medium textured water-laid sediments
M2 medium textured water-laid sediments
M3 medium textured water-laid sediments
M4 medium textured till
M5 medium textured softrock
M6 gravelly and stony medium textured till
P1 sphagnum peat
P2 fen peat
P3 forest peat
U0 undifferentiated material
UP undifferentiated (peat)

Table 10. Soil series codes to be described as “eroded soils”

Soil Series Code Soil Series Subgroup
ALT ALTARIO R.DB
BKE BROCKET R.DB
BPW BEARSPAW R.BL
BUR BURMIS R.BL
CLR CLARINDA R.B
DIM DIAMOND R.DB
EBO EAST BOW R.BL
EDG EDBURG GLR.BL
EORer ELNORA-ER R.BL
FLUer FALUN-ER R.DG
HCH HOUCHER R.DB
HIW HIGHWOOD R.BL
HMS HELMSDALE R.B
HPV HAPPY VALLEY R.BL
ISF INNISFAIL R.BL
MTR MONITOR R.DB
NSK NOSE.CREEK R.BL
NUT NEUTRAL R.DB
ODM OLDMAN R.BL
PME PLUME R.DB
PSO PARSONS R.BL
VEB VERBURG R.DB
VST VENDISANT R.B
WCR WOOLCHESTER R.DB
WID WILDA R.DB
WLG WELLING R.DB
WOL WOLLIM R.DB
ZER MISC.ERODED R.BL