Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: chaashto

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Horizon AASHTO

Physical

Data Type

1 aashtocl AASHTO Choice Varchar No 254 aashto_group_classification

2 rvindicator RV? Boolean Varchar Yes 3

3 chkey Chorizon Key String Varchar Yes 30

4 chaashtokey Chorizon AASHTO Key String Varchar Yes 30

The Horizon AASHTO table contains the American Association of State Highway Transportation Officials classification(s) for the referenced horizon. One row in this table is marked as the 

representative AASHTO classification for the horizon.

2/4/2014 Page 1
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: chconsistence

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Horizon Consistence

Physical

Data Type

1 rupresblkmst Rupture Moist Choice Varchar No 254 rupture_resist_block_moist

2 rupresblkdry Rupture Dry Choice Varchar No 254 rupture_resist_block_dry

3 rupresblkcem Rupture Cement Choice Varchar No 254 rupture_resist_block_cem

4 rupresplate Rupture Plate Choice Varchar No 254 rupture_resist_plate

5 mannerfailure Manner of Failure Choice Varchar No 254 manner_of_failure

6 stickiness Stickiness Choice Varchar No 254 stickiness

7 plasticity Plasticity Choice Varchar No 254 plasticity

8 rvindicator RV? Boolean Varchar Yes 3

9 chkey Chorizon Key String Varchar Yes 30

10 chconsistkey Chorizon Consistence Key String Varchar Yes 30

The Horizon Consistence table contains descriptive terms of soil consistence -- rupture resistance, plasticity, and stickiness -- for the referenced horizon. One row in this table is marked as having the 

representative characteristics for the horizon.

2/4/2014 Page 2
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: chdesgnsuffix

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Horizon Designation Suffix

Physical

Data Type

1 desgnsuffix Suffix Choice Varchar No 254 horz_desgn_letter_suffix

2 chkey Chorizon Key String Varchar Yes 30

3 chdesgnsfxkey Chorizon Designation Suffix Key String Varchar Yes 30

The Horizon Designation Suffix table contains the designation suffix(es), one per row, for the referenced horizon. For example, the "h" and "s" of a Bhs horizon appear as two rows in this table.

2/4/2014 Page 3
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: chfrags

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Horizon Fragments

Physical

Data Type

1 fragvol_l Low Integer Smallint No 0 100 percent

2 fragvol_r RV Integer Smallint No 0 100 percent

3 fragvol_h High Integer Smallint No 0 100 percent

4 fragkind Kind Choice Varchar No 254 fragment_kind

5 fragsize_l Low Integer Smallint No 2 3000 mm

6 fragsize_r RV Integer Smallint No 2 3000 mm

7 fragsize_h High Integer Smallint No 2 3000 mm

8 fragshp Shape Choice Varchar No 254 fragment_shape

9 fraground Roundness Choice Varchar No 254 fragment_roundness

10 fraghard Hardness Choice Varchar No 254 rupture_resist_block_cem

11 chkey Chorizon Key String Varchar Yes 30

12 chfragskey Chorizon Fragments Key String Varchar Yes 30

The Horizon Fragments table lists the mineral and organic fragments that generally occur in the referenced horizon. If the Volume % is greater than zero (low=5, RV=10, high=15) in a row, the kind and 

size of fragment in that row exists everywhere this horizon and component occur in the map unit. If the Volume % includes zero (low=0, RV=5, high=10), the kind and size of fragment may exist in 

some places, but not in others.

2/4/2014 Page 4
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: chorizon

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Horizon

Physical

Data Type

1 hzname Designation String Varchar No 12

2 desgndisc Disc Integer Smallint No 2 99

3 desgnmaster Master Choice Varchar No 254 horz_desgn_master

4 desgnmasterprime Prime Choice Varchar No 254 horz_desgn_master_prime

5 desgnvert Sub Integer Smallint No 1

6 hzdept_l Low Integer Smallint No 0 9999 cm

7 hzdept_r RV Integer Smallint No 0 9999 cm

8 hzdept_h High Integer Smallint No 0 9999 cm

9 hzdepb_l Low Integer Smallint No 0 9999 cm

10 hzdepb_r RV Integer Smallint No 0 9999 cm

11 hzdepb_h High Integer Smallint No 0 9999 cm

12 hzthk_l Low Integer Smallint No 0 9999 cm

13 hzthk_r RV Integer Smallint No 0 9999 cm

14 hzthk_h High Integer Smallint No 0 9999 cm

15 fraggt10_l Low Integer Smallint No 0 100 percent

16 fraggt10_r RV Integer Smallint No 0 100 percent

17 fraggt10_h High Integer Smallint No 0 100 percent

18 frag3to10_l Low Integer Smallint No 0 100 percent

19 frag3to10_r RV Integer Smallint No 0 100 percent

20 frag3to10_h High Integer Smallint No 0 100 percent

21 sieveno4_l Low Float Real No 1 0 100 percent

22 sieveno4_r RV Float Real No 1 0 100 percent

23 sieveno4_h High Float Real No 1 0 100 percent

24 sieveno10_l Low Float Real No 1 0 100 percent

25 sieveno10_r RV Float Real No 1 0 100 percent

26 sieveno10_h High Float Real No 1 0 100 percent

27 sieveno40_l Low Float Real No 1 0 100 percent

28 sieveno40_r RV Float Real No 1 0 100 percent

29 sieveno40_h High Float Real No 1 0 100 percent

30 sieveno200_l Low Float Real No 1 0 100 percent

31 sieveno200_r RV Float Real No 1 0 100 percent

32 sieveno200_h High Float Real No 1 0 100 percent

2/4/2014 Page 5
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: chorizon

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Horizon

Physical

Data Type

33 sandtotal_l Low Float Real No 1 0 100 percent

34 sandtotal_r RV Float Real No 1 0 100 percent

35 sandtotal_h High Float Real No 1 0 100 percent

36 sandvc_l Low Float Real No 1 0 100 percent

37 sandvc_r RV Float Real No 1 0 100 percent

38 sandvc_h High Float Real No 1 0 100 percent

39 sandco_l Low Float Real No 1 0 100 percent

40 sandco_r RV Float Real No 1 0 100 percent

41 sandco_h High Float Real No 1 0 100 percent

42 sandmed_l Low Float Real No 1 0 100 percent

43 sandmed_r RV Float Real No 1 0 100 percent

44 sandmed_h High Float Real No 1 0 100 percent

45 sandfine_l Low Float Real No 1 0 100 percent

46 sandfine_r RV Float Real No 1 0 100 percent

47 sandfine_h High Float Real No 1 0 100 percent

48 sandvf_l Low Float Real No 1 0 100 percent

49 sandvf_r RV Float Real No 1 0 100 percent

50 sandvf_h High Float Real No 1 0 100 percent

51 silttotal_l Low Float Real No 1 0 100 percent

52 silttotal_r RV Float Real No 1 0 100 percent

53 silttotal_h High Float Real No 1 0 100 percent

54 siltco_l Low Float Real No 1 0 100 percent

55 siltco_r RV Float Real No 1 0 100 percent

56 siltco_h High Float Real No 1 0 100 percent

57 siltfine_l Low Float Real No 1 0 100 percent

58 siltfine_r RV Float Real No 1 0 100 percent

59 siltfine_h High Float Real No 1 0 100 percent

60 claytotal_l Low Float Real No 1 0 100 percent

61 claytotal_r RV Float Real No 1 0 100 percent

62 claytotal_h High Float Real No 1 0 100 percent

63 claysizedcarb_l Low Float Real No 1 0 100 percent

64 claysizedcarb_r RV Float Real No 1 0 100 percent

2/4/2014 Page 6
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: chorizon

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Horizon

Physical

Data Type

65 claysizedcarb_h High Float Real No 1 0 100 percent

66 om_l Low Float Real No 2 0 100 percent

67 om_r RV Float Real No 2 0 100 percent

68 om_h High Float Real No 2 0 100 percent

69 dbtenthbar_l Low Float Real No 2 0.02 2.6 g/cm3

70 dbtenthbar_r RV Float Real No 2 0.02 2.6 g/cm3

71 dbtenthbar_h High Float Real No 2 0.02 2.6 g/cm3

72 dbthirdbar_l Low Float Real No 2 0.02 2.6 g/cm3

73 dbthirdbar_r RV Float Real No 2 0.02 2.6 g/cm3

74 dbthirdbar_h High Float Real No 2 0.02 2.6 g/cm3

75 dbfifteenbar_l Low Float Real No 2 0.02 2.6 g/cm3

76 dbfifteenbar_r RV Float Real No 2 0.02 2.6 g/cm3

77 dbfifteenbar_h High Float Real No 2 0.02 2.6 g/cm3

78 dbovendry_l Low Float Float No 2 0.02 2.6 g/cm3

79 dbovendry_r RV Float Float No 2 0.02 2.6 g/cm3

80 dbovendry_h High Float Float No 2 0.02 2.6 g/cm3

81 partdensity Dp Float Real No 2 0.01 5 g/cm3

82 ksat_l Low Float Real No 4 0 705 um/s

83 ksat_r RV Float Real No 4 0 705 um/s

84 ksat_h High Float Real No 4 0 705 um/s

85 awc_l Low Float Real No 2 0 0.7 cm/cm

86 awc_r RV Float Real No 2 0 0.7 cm/cm

87 awc_h High Float Real No 2 0 0.7 cm/cm

88 wtenthbar_l Low Float Real No 1 0 2000 percent

89 wtenthbar_r RV Float Real No 1 0 2000 percent

90 wtenthbar_h High Float Real No 1 0 2000 percent

91 wthirdbar_l Low Float Real No 1 0 2000 percent

92 wthirdbar_r RV Float Real No 1 0 2000 percent

93 wthirdbar_h High Float Real No 1 0 2000 percent

94 wfifteenbar_l Low Float Real No 1 0 400 percent

95 wfifteenbar_r RV Float Real No 1 0 400 percent

96 wfifteenbar_h High Float Real No 1 0 400 percent

2/4/2014 Page 7
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: chorizon

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Horizon

Physical

Data Type

97 wsatiated_l Low Integer Smallint No 10 70 percent

98 wsatiated_r RV Integer Smallint No 10 70 percent

99 wsatiated_h High Integer Smallint No 10 70 percent

100 lep_l Low Float Real No 1 0 30 percent

101 lep_r RV Float Real No 1 0 30 percent

102 lep_h High Float Real No 1 0 30 percent

103 ll_l Low Float Real No 1 0 400 percent

104 ll_r RV Float Real No 1 0 400 percent

105 ll_h High Float Real No 1 0 400 percent

106 pi_l Low Float Real No 1 0 130 percent

107 pi_r RV Float Real No 1 0 130 percent

108 pi_h High Float Real No 1 0 130 percent

109 aashind_l Low Integer Smallint No 0 120

110 aashind_r RV Integer Smallint No 0 120

111 aashind_h High Integer Smallint No 0 120

112 kwfact Kw Choice Varchar No 254 soil_erodibility_factor

113 kffact Kf Choice Varchar No 254 soil_erodibility_factor

114 caco3_l Low Integer Smallint No 0 110 percent

115 caco3_r RV Integer Smallint No 0 110 percent

116 caco3_h High Integer Smallint No 0 110 percent

117 gypsum_l Low Integer Smallint No 0 120 percent

118 gypsum_r RV Integer Smallint No 0 120 percent

119 gypsum_h High Integer Smallint No 0 120 percent

120 sar_l Low Float Real No 1 0 9999

121 sar_r RV Float Real No 1 0 9999

122 sar_h High Float Real No 1 0 9999

123 ec_l Low Float Real No 1 0 15000 dS/m

124 ec_r RV Float Real No 1 0 15000 dS/m

125 ec_h High Float Real No 1 0 15000 dS/m

126 cec7_l Low Float Real No 1 0 400 meq/100g

127 cec7_r RV Float Real No 1 0 400 meq/100g

128 cec7_h High Float Real No 1 0 400 meq/100g

2/4/2014 Page 8
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: chorizon

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Horizon

Physical

Data Type

129 ecec_l Low Float Real No 1 0 400 meq/100g

130 ecec_r RV Float Real No 1 0 400 meq/100g

131 ecec_h High Float Real No 1 0 400 meq/100g

132 sumbases_l Low Float Float No 1 0 300 meq/100g

133 sumbases_r RV Float Float No 1 0 300 meq/100g

134 sumbases_h High Float Float No 1 0 300 meq/100g

135 ph1to1h2o_l Low Float Real No 1 1.8 11

136 ph1to1h2o_r RV Float Real No 1 1.8 11

137 ph1to1h2o_h High Float Real No 1 1.8 11

138 ph01mcacl2_l Low Float Real No 1 1.8 11

139 ph01mcacl2_r RV Float Real No 1 1.8 11

140 ph01mcacl2_h High Float Real No 1 1.8 11

141 freeiron_l Low Float Real No 2 0 100 percent

142 freeiron_r RV Float Real No 2 0 100 percent

143 freeiron_h High Float Real No 2 0 100 percent

144 feoxalate_l Low Float Real No 2 0 150000 mg/kg

145 feoxalate_r RV Float Real No 2 0 150000 mg/kg

146 feoxalate_h High Float Real No 2 0 150000 mg/kg

147 extracid_l Low Float Real No 1 0 250 meq/100g

148 extracid_r RV Float Real No 1 0 250 meq/100g

149 extracid_h High Float Real No 1 0 250 meq/100g

150 extral_l Low Float Real No 2 0 150 meq/100g

151 extral_r RV Float Real No 2 0 150 meq/100g

152 extral_h High Float Real No 2 0 150 meq/100g

153 aloxalate_l Low Float Real No 1 0 170000 mg/kg

154 aloxalate_r RV Float Real No 1 0 170000 mg/kg

155 aloxalate_h High Float Real No 1 0 170000 mg/kg

156 pbray1_l Low Float Real No 1 0 500 mg/kg

157 pbray1_r RV Float Real No 1 0 500 mg/kg

158 pbray1_h High Float Real No 1 0 500 mg/kg

159 poxalate_l Low Float Real No 1 0 mg/kg

160 poxalate_r RV Float Real No 1 0 mg/kg

2/4/2014 Page 9
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: chorizon

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Horizon

Physical

Data Type

161 poxalate_h High Float Real No 1 0 mg/kg

162 ph2osoluble_l Low Float Real No 1 0 5000 mg/kg

163 ph2osoluble_r RV Float Real No 1 0 5000 mg/kg

164 ph2osoluble_h High Float Real No 1 0 5000 mg/kg

165 ptotal_l Low Float Real No 2 0 percent

166 ptotal_r RV Float Real No 2 0 percent

167 ptotal_h High Float Real No 2 0 percent

168 excavdifcl Excav Diff Choice Varchar No 254 excavation_difficulty_class

169 excavdifms Excav Diff Moisture Choice No 254 observed_soil_moisture_stat

us

Varchar

170 cokey Component Key String Varchar Yes 30

171 chkey Chorizon Key String Varchar Yes 30

The Horizon table lists the horizon(s) and related data for the referenced map unit component. If the horizon thickness is greater than zero (low=5, RV=8, high=12), the horizon exists everywhere this 

component occurs. If the horizon thickness includes zero (low=0, RV=1, high=3), the horizon may exist in some places, but not in other places.

Horizons that have two distinct parts, such as E/B or E&Bt horizons, are recorded twice. Once for the characteristics of the first part; and again on another row, using the same depths and thicknesses, 

for the characteristics of the other part.

2/4/2014 Page 10
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: chpores

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Horizon Pores

Physical

Data Type

1 poreqty_l Low Float Real No 1 0 99 pores/area

2 poreqty_r RV Float Real No 1 0 99 pores/area

3 poreqty_h High Float Real No 1 0 99 pores/area

4 poresize Size Choice Varchar No 254 pore_root_size

5 porecont Continuity Choice Varchar No 254 pore_continuity_vertical

6 poreshp Shape Choice Varchar No 254 pore_shape

7 rvindicator RV? Boolean Varchar Yes 3

8 chkey Chorizon Key String Varchar Yes 30

9 chporeskey Chorizon Pores Key String Varchar Yes 30

The Horizon Pores table lists the voids for the referenced horizon. If the Quantity is greater than zero (low=2, RV=5, high=10) in a row, the voids in that row exist everywhere the horizon and 

component occur in the map unit. If the Quantity includes zero (low=0, RV=2, high=5), the voids may exist in some places, but not in others. More than one row can be marked as an RV row because 

a horizon may have more than one size or shape of void.

2/4/2014 Page 11
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: chstruct

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Horizon Structure

Physical

Data Type

1 structgrade Grade Choice Varchar No 254 structure_grade

2 structsize Size Choice Varchar No 254 structure_size

3 structtype Type Choice Varchar No 254 structure_type

4 structid Structure ID Integer Smallint No 1

5 structpartsto Parts to Structure ID Integer Smallint No

6 chstructgrpkey Chorizon Structure Group Key String Varchar Yes 30

7 chstructkey Chorizon Structure Key String Varchar Yes 30

The Horizon Structure table lists the individual soil structure size, grade, and shape terms for the referenced horizon. Terms in this table are assembled into a structure group string which is recorded in 

the Horizon Structure Group table.

2/4/2014 Page 12
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: chstructgrp

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Horizon Structure Group

Physical

Data Type

1 structgrpname Structure String Varchar No 100

2 rvindicator RV? Boolean Varchar Yes 3

3 chkey Chorizon Key String Varchar Yes 30

4 chstructgrpkey Chorizon Structure Group Key String Varchar Yes 30

The Horizon Structure Group table lists the ranges of soil structure for the referenced horizon. The row with the typically occurring structure is marked as being representative. The entry in this table is 

based on grouping of entries in the Horizon Structure table.

2/4/2014 Page 13
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: chtext

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Horizon Text

Physical

Data Type

1 recdate Date Date/Time Datetime No

2 chorizontextkind Kind Choice Varchar No 254 chorizon_text_kind

3 textcat Category String Varchar No 20

4 textsubcat Subcategory String Varchar No 20

5 text Text Narrative 

Text

Text No

6 chkey Chorizon Key String Varchar Yes 30

7 chtextkey Chorizon Text Key String Varchar Yes 30

The Horizon Text table contains notes and narrative descriptions related to the referenced horizon. Some notes may provide additional information about the horizon for which there is no explicit 

column for such data. In many cases, the table is empty for a particular horizon.

2/4/2014 Page 14
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: chtexture

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Horizon Texture

Physical

Data Type

1 texcl Texture Choice Varchar No 254 texture_class

2 lieutex In Lieu Choice No 254 terms_used_in_lieu_of_textur

e

Varchar

3 chtgkey Chorizon Texture Group Key String Varchar Yes 30

4 chtkey Chorizon Texture Key String Varchar Yes 30

The Horizon Texture table lists the individual texture(s), or term(s) used in lieu of texture, for the referenced horizon. Only the unmodified texture terms are listed in the Horizon Texture table; modifiers 

are listed in the Horizon Texture Modifier table. For example, a gravelly loamy sand is shown as "GR-LS" in the Horizon Texture Group table, "ls" in the Horizon Texture table, and "gr" in the Horizon 

Texture Modifier table.

2/4/2014 Page 15
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: chtexturegrp

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Horizon Texture Group

Physical

Data Type

1 texture Tex Mod & Class String Varchar No 30

2 stratextsflag Stratified? Boolean Varchar Yes 3

3 rvindicator RV? Boolean Varchar Yes 3

4 texdesc Texture Description Narrative 

Text

Text No

5 chkey Chorizon Key String Varchar Yes 30

6 chtgkey Chorizon Texture Group Key String Varchar Yes 30

The Horizon Texture Group table lists the range of textures for the referenced horizon as a concatenation of horizon texture and texture modifier(s). For example, a horizon that is gravelly loamy sand 

in some places and gravelly loamy coarse sand in other places is shown as GR-LS on one row and GR-LCOS on another row in this table. The row with the typically occurring texture is identified as 

the RV row. Stratified textures are shown in one row. For example, a horizon that is stratified gravelly loamy fine sand and cobbly coarse sand is shown as SR- GR-LFS CB-COS on one row and the 

Stratified? column for that row is marked "yes". If two or more textures always occur together but are not stratified, all of the textures are listed on one row and the Stratified? column for that row is 

marked "no".

2/4/2014 Page 16
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: chtexturemod

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Horizon Texture Modifier

Physical

Data Type

1 texmod Modifier Choice Varchar No 254 texture_modifier

2 chtkey Chorizon Texture Key String Varchar Yes 30

3 chtexmodkey Chorizon Texture Modifier Key String Varchar Yes 30

The Horizon Texture Modifier table lists the texture modifier(s) for the referenced texture. For example, a gravelly loamy sand is shown as "GR-LS" in the Horizon Texture Group table, "ls" in the 

Horizon Texture table, and "gr" in this table.

2/4/2014 Page 17
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: chunified

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Horizon Unified

Physical

Data Type

1 unifiedcl Unified Choice Varchar No 254 unified_soil_classification

2 rvindicator RV? Boolean Varchar Yes 3

3 chkey Chorizon Key String Varchar Yes 30

4 chunifiedkey Chorizon Unified Key String Varchar Yes 30

The Horizon Unified table contains the Unified Soil Classification(s) for the referenced horizon. One row in the Horizon Unified table is marked as the representative Unified classification for the horizon.

2/4/2014 Page 18
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: cocanopycover

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Canopy Cover

Physical

Data Type

1 plantcov Canopy Cover % Integer Smallint No 0 100 percent

2 plantsym Plant Symbol String Varchar Yes 8

3 plantsciname Scientific Name String Varchar No 127

4 plantcomname Common Name String Varchar No 60

5 cokey Component Key String Varchar Yes 30

6 cocanopycovkey Component Canopy Cover Key String Varchar Yes 30

The Component Canopy Cover table lists the overstory plants that typically occur on the referenced map unit component.

2/4/2014 Page 19
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: cocropyld

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Crop Yield

Physical

Data Type

1 cropname Crop Name Choice Varchar No 254 crop_name

2 yldunits Units Choice Varchar No 254 crop_yield_units

3 nonirryield_l Low Float Real No 2 0 9999.99

4 nonirryield_r RV Float Real No 2 0 9999.99

5 nonirryield_h High Float Real No 2 0 9999.99

6 irryield_l Low Float Real No 2 0 9999.99

7 irryield_r RV Float Real No 2 0 9999.99

8 irryield_h High Float Real No 2 0 9999.99

9 cropprodindex Prod Index Integer Smallint No 0 100

10 vasoiprdgrp VA Soil Prod Grp Choice Varchar No 254 va_soil_productivity_group

11 cokey Component Key String Varchar Yes 30

12 cocropyldkey Component Crop Yield Key String Varchar Yes 30

The Component Crop Yield table lists commonly grown crops and their expected range in yields when grown on the referenced map unit component. Yields for the map unit as a whole are given in the 

Mapunit Crop Yield table.

2/4/2014 Page 20
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: codiagfeatures

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Diagnostic Features

Physical

Data Type

1 featkind Kind Choice Varchar No 254 diag_horz_feat_kind

2 featdept_l Low Integer Smallint No 0 9999 cm

3 featdept_r RV Integer Smallint No 0 9999 cm

4 featdept_h High Integer Smallint No 0 9999 cm

5 featdepb_l Low Integer Smallint No 0 9999 cm

6 featdepb_r RV Integer Smallint No 0 9999 cm

7 featdepb_h High Integer Smallint No 0 9999 cm

8 featthick_l Low Integer Smallint No 0 9999 cm

9 featthick_r RV Integer Smallint No 0 9999 cm

10 featthick_h High Integer Smallint No 0 9999 cm

11 cokey Component Key String Varchar Yes 30

12 codiagfeatkey Component Diagnostic Features 

Key

String Varchar Yes 30

The Component Diagnostic Features table lists the typical soil features, such as ochric epipedon or cambic horizon, for the referenced map unit component.

2/4/2014 Page 21
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: coecoclass

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Ecological Classification

Physical

Data Type

1 ecoclasstypename Ecological Classification Type 

Name

String Varchar Yes 60

2 ecoclassref Ecological Classification 

Reference

String Varchar No 254

3 ecoclassid Ecological Classification ID String Varchar Yes 30

4 ecoclassname Ecological Classification Name Narrative 

Text

Text No

5 cokey Component Key String Varchar Yes 30

6 coecoclasskey Component Ecological 

Classification Key

String Varchar Yes 30

The Component Ecological Classification table identifies the ecological sites typically associated with the referenced map unit component. These may include the official NRCS forestland and rangland 

ecological sites, as well as those of other classification systems, such as the USFS Habitat Types.

2/4/2014 Page 22
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: coeplants

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Existing Plants

Physical

Data Type

1 plantsym Plant Symbol String Varchar Yes 8

2 plantsciname Scientific Name String Varchar No 127

3 plantcomname Common Name String Varchar No 60

4 forestunprod Understory Prod % Integer Smallint No 0 100 percent

5 rangeprod Range Prod % Integer Smallint No 0 100 percent

6 cokey Component Key String Varchar Yes 30

7 coeplantskey Component Existing Plants Key String Varchar Yes 30

The Component Existing Plants table lists the plants, either rangeland or forestland plants, that typically occur on the referenced map unit component.

2/4/2014 Page 23
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: coerosionacc

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Erosion Accelerated

Physical

Data Type

1 erokind Kind Choice Varchar No 254 erosion_accelerated_kind

2 rvindicator RV? Boolean Varchar Yes 3

3 cokey Component Key String Varchar Yes 30

4 coeroacckey Component Erosion Accelerated 

Key

String Varchar Yes 30

The Component Erosion Accelerated table lists the kinds of accelerated erosion that occur on the referenced map unit component. One row in this table is marked as the representative kind of 

accelerated erosion for that component.

2/4/2014 Page 24
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: coforprod

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Forest Productivity

Physical

Data Type

1 plantsym Plant Symbol String Varchar Yes 8

2 plantsciname Scientific Name String Varchar No 127

3 plantcomname Common Name String Varchar No 60

4 siteindexbase Site Index Base Choice Varchar No 254 site_index_curves

5 siteindex_l Low Integer Smallint No 1 300

6 siteindex_r RV Integer Smallint No 1 300

7 siteindex_h High Integer Smallint No 1 300

8 fprod_l Low Float Real No 2 0 9999

9 fprod_r RV Float Real No 2 0 9999

10 fprod_h High Float Real No 2 0 9999

11 cokey Component Key String Varchar Yes 30

12 cofprodkey Component Forest Productivity 

Key

String Varchar Yes 30

The Component Forest Productivity table lists the site index and the annual productivity in cubic feet per acre per year (CAMI) of forest overstory tree species that typically occur on the referenced map 

unit component.

2/4/2014 Page 25
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: coforprodo

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Forest Productivity - Other

Physical

Data Type

1 siteindexbase Site Index Base Choice Varchar No 254 site_index_curves

2 siteindex_l Low Integer Smallint No 1 300

3 siteindex_r RV Integer Smallint No 1 300

4 siteindex_h High Integer Smallint No 1 300

5 fprod_l Low Float Real No 2 0 9999

6 fprod_r RV Float Real No 2 0 9999

7 fprod_h High Float Real No 2 0 9999

8 fprodunits Units Choice Varchar No 254 forest_productivity_units

9 cofprodkey Component Forest Productivity 

Key

String Varchar Yes 30

10 cofprodokey Component Forest Productivity 

Other Key

String Varchar Yes 30

The Component Forest Productivity - Other table lists the site index and annual productivity of forest overstory tree species in units other than cubic feet per acre per year for trees that typically occur 

on the referenced map unit component.

2/4/2014 Page 26
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: cogeomordesc

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Geomorphic Description

Physical

Data Type

1 geomftname Feature Type String Varchar Yes 30

2 geomfname Feature Name String Varchar Yes 50

3 geomfmod Feature Modifier String Varchar No 60

4 geomfeatid Feature ID Integer Smallint No

5 existsonfeat Exists On Feature ID Integer Smallint No

6 rvindicator RV? Boolean Varchar Yes 3

7 cokey Component Key String Varchar Yes 30

8 cogeomdkey Component Geomorphic 

Description Key

String Varchar Yes 30

The Component Geomorphic Description table lists the geomorphic features on which the referenced map unit component typically occurs.

2/4/2014 Page 27
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: cohydriccriteria

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Hydric Criteria

Physical

Data Type

1 hydriccriterion Hydric Criterion Choice Varchar No 254 hydric_criteria

2 cokey Component Key String Varchar Yes 30

3 cohydcritkey Component Hydric Criteria Key String Varchar Yes 30

The Component Hydric Criteria table lists the hydric soil criteria met for those referenced map unit components that are classified as a "hydric soil."

2/4/2014 Page 28
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: cointerp

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Interpretation

Physical

Data Type

1 cokey Component Key String Varchar Yes 30

2 mrulekey Main Rule Key String Varchar Yes 30

3 mrulename Main Rule Name String Varchar Yes 60

4 seqnum Seq Integer Smallint Yes 1

5 rulekey Rule Key String Varchar Yes 30

6 rulename Rule Name String Varchar Yes 60

7 ruledepth Rule Depth Integer Smallint Yes

8 interpll Interp Low Low Float Float No 2

9 interpllc Interp Low Low Class String Varchar No 254

10 interplr Interp Low Representative Value Float Float No 2

11 interplrc Interp Low Representative Value 

Class

String Varchar No 254

12 interphr Interp High Representative Value Float Float No 2

13 interphrc Interp High Representative Value 

Class

String Varchar No 254

14 interphh Interp High High Float Float No 2

15 interphhc Interp High High Class String Varchar No 254

16 nullpropdatabool Null Property Data Boolean Boolean Varchar No 3

17 defpropdatabool Default Property Data Boolean Boolean Varchar No 3

18 incpropdatabool Inconsistent Property Data 

Boolean

Boolean Varchar No 3

19 cointerpkey Component Interpretation Key String Varchar Yes 30

The Component Interpretation table lists the predictions of behavior and limiting features for specified uses made for the referenced map unit component.

2/4/2014 Page 29
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: comonth

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Month

Physical

Data Type

1 monthseq Month Sequence Integer Smallint No 1 12

2 month Month Choice Varchar No 254 flooding_ponding_month

3 flodfreqcl Flooding Frequency Choice Varchar No 254 flooding_frequency_class

4 floddurcl Flooding Duration Choice Varchar No 254 flooding_duration_class

5 pondfreqcl Ponding Frequency Choice Varchar No 254 ponding_frequency_class

6 ponddurcl Ponding Duration Choice Varchar No 254 ponding_duration_class

7 ponddep_l Low Integer Smallint No 0 185 cm

8 ponddep_r RV Integer Smallint No 0 185 cm

9 ponddep_h High Integer Smallint No 0 185 cm

10 dlyavgprecip_l Low Integer Smallint No 0 750 mm

11 dlyavgprecip_r RV Integer Smallint No 0 750 mm

12 dlyavgprecip_h High Integer Smallint No 0 750 mm

13 dlyavgpotet_l Low Integer Smallint No 0 300 mm

14 dlyavgpotet_r RV Integer Smallint No 0 300 mm

15 dlyavgpotet_h High Integer Smallint No 0 300 mm

16 cokey Component Key String Varchar Yes 30

17 comonthkey Component Month Key String Varchar Yes 30

The Component Month table lists the monthly flooding and ponding characteristics for the referenced map unit component. This table has one row for each month of the year.

2/4/2014 Page 30
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: component

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component

Physical

Data Type

1 comppct_l Low Integer Smallint No 0 100 percent

2 comppct_r RV Integer Smallint No 0 100 percent

3 comppct_h High Integer Smallint No 0 100 percent

4 compname Component Name String Varchar No 60

5 compkind Kind Choice Varchar No 254 component_kind

6 majcompflag Major Component Boolean Varchar No 3

7 otherph SIR phase String Varchar No 40

8 localphase Local Phase String Varchar No 40

9 slope_l Low Float Real No 1 0 999 percent

10 slope_r RV Float Real No 1 0 999 percent

11 slope_h High Float Real No 1 0 999 percent

12 slopelenusle_l Low Integer Smallint No 0 4000 meters

13 slopelenusle_r RV Integer Smallint No 0 4000 meters

14 slopelenusle_h High Integer Smallint No 0 4000 meters

15 runoff Runoff Class Choice Varchar No 254 runoff

16 tfact T Integer Smallint No 1 5 tons/acre/yr

17 wei WEI Choice Varchar No 254 tons/acre/yr wind_erodibility_index

18 weg WEG Choice Varchar No 254 wind_erodibility_group

19 erocl Erosion Class Choice Varchar No 254 erosion_class

20 earthcovkind1 Cover Kind 1 Choice Varchar No 254 earth_cover_kind_level_one

21 earthcovkind2 Cover Kind 2 Choice Varchar No 254 earth_cover_kind_level_two

22 hydricon Hydric Condition Choice Varchar No 254 hydric_condition

23 hydricrating Hydric Rating Choice Varchar No 254 hydric_rating

24 drainagecl Drainage Class Choice Varchar No 254 drainage_class

25 elev_l Low Float Real No 1 -300 8550 meters

26 elev_r RV Float Real No 1 -300 8550 meters

27 elev_h High Float Real No 1 -300 8550 meters

28 aspectccwise Aspect Counter Clockwise Integer Smallint No 0 360 degrees

29 aspectrep Aspect Representative Integer Smallint No 0 360 degrees

30 aspectcwise Aspect Clockwise Integer Smallint No 0 360 degrees

31 geomdesc Geomorphic Description Narrative 

Text

Text No

2/4/2014 Page 31
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: component

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component

Physical

Data Type

32 albedodry_l Low Float Real No 2 0 1

33 albedodry_r RV Float Real No 2 0 1

34 albedodry_h High Float Real No 2 0 1

35 airtempa_l Low Float Real No 1 -50 50 degrees c

36 airtempa_r RV Float Real No 1 -50 50 degrees c

37 airtempa_h High Float Real No 1 -50 50 degrees c

38 map_l Low Integer Smallint No 0 11500 mm

39 map_r RV Integer Smallint No 0 11500 mm

40 map_h High Integer Smallint No 0 11500 mm

41 reannualprecip_l Low Integer Smallint No 0 11500 mm

42 reannualprecip_r RV Integer Smallint No 0 11500 mm

43 reannualprecip_h High Integer Smallint No 0 11500 mm

44 ffd_l Low Integer Smallint No 0 365 days

45 ffd_r RV Integer Smallint No 0 365 days

46 ffd_h High Integer Smallint No 0 365 days

47 nirrcapcl Nirr LCC Choice Varchar No 254 capability_class

48 nirrcapscl Nirr Subcl Choice Varchar No 254 capability_subclass

49 nirrcapunit Nirr LCU Integer Smallint No 1 99

50 irrcapcl Irr LCC Choice Varchar No 254 capability_class

51 irrcapscl Irr Subcl Choice Varchar No 254 capability_subclass

52 irrcapunit Irr LCU Integer Smallint No 1 99

53 cropprodindex Prod Index Integer Smallint No 0 100

54 constreeshrubgrp Cons Tree Shrub Group Choice No 254 conservation_tree_shrub_gro

up

Varchar

55 wndbrksuitgrp Windbreak Suitability (Obsolete) Choice Varchar No 254 windbreak_suitability_group

56 rsprod_l Low Integer Int No 0 20000 lbs/acre/yr

57 rsprod_r RV Integer Int No 0 20000 lbs/acre/yr

58 rsprod_h High Integer Int No 0 20000 lbs/acre/yr

59 foragesuitgrpid Forage Suitability Group ID String Varchar No 11

60 wlgrain Grain Habitat Choice Varchar No 254 wildlife_rating

61 wlgrass Grass Habitat Choice Varchar No 254 wildlife_rating

62 wlherbaceous Herbaceous Habitat Choice Varchar No 254 wildlife_rating

2/4/2014 Page 32
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: component

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component

Physical

Data Type

63 wlshrub Shrub Habitat Choice Varchar No 254 wildlife_rating

64 wlconiferous Conifer Habitat Choice Varchar No 254 wildlife_rating

65 wlhardwood Hardwood Habitat Choice Varchar No 254 wildlife_rating

66 wlwetplant Wetland Habitat Choice Varchar No 254 wildlife_rating

67 wlshallowwat Water Habitat Choice Varchar No 254 wildlife_rating

68 wlrangeland Rangeland Wildlife Choice Varchar No 254 wildlife_rating

69 wlopenland Openland Wildlife Choice Varchar No 254 wildlife_rating

70 wlwoodland Woodland Wildlife Choice Varchar No 254 wildlife_rating

71 wlwetland Wetland Wildlife Choice Varchar No 254 wildlife_rating

72 soilslippot Soil Slip Pot Choice Varchar No 254 soil_slippage_potential

73 frostact Frost Action Choice Varchar No 254 potential_frost_action

74 initsub_l Low Integer Smallint No 0 999 cm

75 initsub_r RV Integer Smallint No 0 999 cm

76 initsub_h High Integer Smallint No 0 999 cm

77 totalsub_l Low Integer Smallint No 0 999 cm

78 totalsub_r RV Integer Smallint No 0 999 cm

79 totalsub_h High Integer Smallint No 0 999 cm

80 hydgrp Hydrologic Group Choice Varchar No 254 hydrologic_group

81 corcon Corrosion Concrete Choice Varchar No 254 corrosion_concrete

82 corsteel Corrosion Steel Choice Varchar No 254 corrosion_uncoated_steel

83 taxclname Taxonomic Class String Varchar No 120

84 taxorder Order Choice Varchar No 254 taxonomic_order

85 taxsuborder Suborder Choice Varchar No 254 taxonomic_suborder

86 taxgrtgroup Great Group Choice Varchar No 254 taxonomic_great_group

87 taxsubgrp Subgroup Choice Varchar No 254 taxonomic_subgroup

88 taxpartsize Particle Size Choice No 254 taxonomic_family_particle_si

ze

Varchar

89 taxpartsizemod Particle Size Mod Choice No 254 taxonomic_family_part_size_

mod

Varchar

90 taxceactcl CEC Activity Cl Choice No 254 taxonomic_family_c_e_act_cl

ass

Varchar

91 taxreaction Reaction Choice Varchar No 254 taxonomic_family_reaction

2/4/2014 Page 33
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: component

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component

Physical

Data Type

92 taxtempcl Temp Class Choice No 254 taxonomic_family_temp_clas

s

Varchar

93 taxmoistscl Moist Subclass Choice No 254 taxonomic_moisture_subclas

s

Varchar

94 taxtempregime Temp Regime Choice Varchar No 254 taxonomic_temp_regime

95 soiltaxedition Keys to Taxonomy Edition Used Choice Varchar No 254 soil_taxonomy_edition

96 castorieindex CA Storie Index Integer Smallint No 0 100

97 flecolcomnum FL Ecol Comm # String Varchar No 5

98 flhe FL HE Choice Varchar No 3 yes_no_n.a.

99 flphe FL PHE Choice Varchar No 3 yes_no_n.a.

100 flsoilleachpot FL Leach Pot Choice Varchar No 254 fl_soil_leaching_potential

101 flsoirunoffpot FL Runoff Pot Choice Varchar No 254 fl_soil_runoff_potential

102 fltemik2use FL Temik Choice Varchar No 3 yes_no_n.a.

103 fltriumph2use FL Triumph Choice Varchar No 3 yes_no_n.a.

104 indraingrp IN Drainage Grp String Varchar No 3

105 innitrateleachi IN NO3 Leach Index Integer Smallint No 0 99

106 misoimgmtgrp MI Soil Mgmt Grp Choice Varchar No 254 mi_soil_management_group

107 vasoimgtgrp VA Soil Mgmt Grp Choice Varchar No 254 va_soil_management_group

108 mukey Mapunit Key String Varchar Yes 30

109 cokey Component Key String Varchar Yes 30

The Component table lists the map unit components identified in the referenced map unit, and selected properties of each component. If the Component % is greater than zero (low=65, RV=75, 

high=90) for a component, that component exists in every delineation of that mapunit. If the Component % includes zero (low=0, RV=50, high=90), the component may exist in some delineations, but 

not in others.

2/4/2014 Page 34
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: copm

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Parent Material

Physical

Data Type

1 pmorder Vertical Order Integer Smallint No 1

2 pmmodifier Textural Modifier Choice Varchar No 254 parent_material_modifier

3 pmgenmod General Modifier String Varchar No 60

4 pmkind Kind Choice Varchar No 254 parent_material_kind

5 pmorigin Origin Choice Varchar No 254 parent_material_origin

6 copmgrpkey Component Parent Material 

Group Key

String Varchar Yes 30

7 copmkey Component Parent Material Key String Varchar Yes 30

The Component Parent Material table lists the individual parent material(s) for the referenced map unit component. In some cases where soils developed in multiple materials in a vertical sequence, 

that sequence will be noted. In other cases multiple entries with no vertical sequence noted indicates the soil may have formed in one of the materials listed.

2/4/2014 Page 35
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: copmgrp

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Parent Material Group

Physical

Data Type

1 pmgroupname Group Name String Varchar No 252

2 rvindicator RV? Boolean Varchar Yes 3

3 cokey Component Key String Varchar Yes 30

4 copmgrpkey Component Parent Material 

Group Key

String Varchar Yes 30

The Component Parent Material Group table lists the concatenated string of parent material(s) in which the referenced map unit component formed based on entries in the Component Parent Material 

table. For example, a component formed in one parent material, such as loess, or one vertical sequence of parent materials, such as loamy glacial drift over silty residuum weathered from shale, has 

one row in this table. A component formed in one parent material in some locations, but another parent material (or sequence of parent materials) in other locations has two rows in this table, one for 

each parent material (or sequence of parent materials). One row is identified as the representative parent material.

2/4/2014 Page 36
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: copwindbreak

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Potential Windbreak

Physical

Data Type

1 wndbrkht_l Low Float Real No 1 0.1 35 meters

2 wndbrkht_r RV Float Real No 1 0.1 35 meters

3 wndbrkht_h High Float Real No 1 0.1 35 meters

4 plantsym Plant Symbol String Varchar Yes 8

5 plantsciname Scientific Name String Varchar No 127

6 plantcomname Common Name String Varchar No 60

7 cokey Component Key String Varchar Yes 30

8 copwindbreakkey Component Potential Windbreak 

Key

String Varchar Yes 30

The Component Potential Windbreak table lists the windbreak plant species commonly recommended for the referenced map unit component. A windbreak plant listed in this table may be used alone 

or in combination with other plants.

2/4/2014 Page 37
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: corestrictions

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Restrictions

Physical

Data Type

1 reskind Kind Choice Varchar No 254 restriction_kind

2 reshard Hardness Choice Varchar No 254 rupture_resist_block_cem

3 resdept_l Low Integer Smallint No 0 9999 cm

4 resdept_r RV Integer Smallint No 0 9999 cm

5 resdept_h High Integer Smallint No 0 9999 cm

6 resdepb_l Low Integer Smallint No 0 9999 cm

7 resdepb_r RV Integer Smallint No 0 9999 cm

8 resdepb_h High Integer Smallint No 0 9999 cm

9 resthk_l Low Integer Smallint No 0 999 cm

10 resthk_r RV Integer Smallint No 0 999 cm

11 resthk_h High Integer Smallint No 0 999 cm

12 cokey Component Key String Varchar Yes 30

13 corestrictkey Component Restrictions Key String Varchar Yes 30

The Component Restrictions table lists the root restrictive feature(s) or layer(s) for the referenced map unit component. If the thickness of the restrictive layer is greater than zero (low=5, RV=8, 

high=10), the restrictive layer exists in all delineations of the map unit where the component occurs. If the thickness of the restrictive layer includes zero (low=0, RV=2, high=5), the restrictive layer may 

exist in some delineations, but not in others. This table will be empty if the component does not have restrictive features, but could have several rows if several restrictive features occur in the soil.

2/4/2014 Page 38
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: cosoilmoist

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Soil Moisture

Physical

Data Type

1 soimoistdept_l Low Integer Smallint No 0 9999 cm

2 soimoistdept_r RV Integer Smallint No 0 9999 cm

3 soimoistdept_h High Integer Smallint No 0 9999 cm

4 soimoistdepb_l Low Integer Smallint No 0 9999 cm

5 soimoistdepb_r RV Integer Smallint No 0 9999 cm

6 soimoistdepb_h High Integer Smallint No 0 9999 cm

7 soimoiststat Moisture Status Choice Varchar No 254 soil_moisture_status

8 comonthkey Component Month Key String Varchar Yes 30

9 cosoilmoistkey Component Soil Moisture Key String Varchar Yes 30

The Component Soil Moisture table describes the typical soil moisture profile for the referenced map unit component during the month referenced in the Component Month table. The soil moisture 

profiles for each month, taken as a group of twelve months, describe the representative situation for the component throughout the year.

2/4/2014 Page 39
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: cosoiltemp

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Soil Temperature

Physical

Data Type

1 soitempmm Monthly Temp Integer Smallint No -25 50 degrees c

2 soitempdept_l Low Integer Smallint No 0 9999 cm

3 soitempdept_r RV Integer Smallint No 0 9999 cm

4 soitempdept_h High Integer Smallint No 0 9999 cm

5 soitempdepb_l Low Integer Smallint No 0 9999 cm

6 soitempdepb_r RV Integer Smallint No 0 9999 cm

7 soitempdepb_h High Integer Smallint No 0 9999 cm

8 comonthkey Component Month Key String Varchar Yes 30

9 cosoiltempkey Component Soil Temperature Key String Varchar Yes 30

The Component Soil Temperature table describes the typical soil temperature profile for the referenced map unit component during the month referenced in the Component Month table. The soil 

temperature profiles for each month, taken as a group of twelve months, describe the representative situation for the component throughout the year.

2/4/2014 Page 40
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: cosurffrags

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Surface Fragments

Physical

Data Type

1 sfragcov_l Low Float Real No 2 0 100 percent

2 sfragcov_r RV Float Real No 2 0 100 percent

3 sfragcov_h High Float Real No 2 0 100 percent

4 distrocks_l Low Float Real No 2 0 50 meters

5 distrocks_r RV Float Real No 2 0 50 meters

6 distrocks_h High Float Real No 2 0 50 meters

7 sfragkind Kind Choice Varchar No 254 fragment_kind

8 sfragsize_l Low Integer Smallint No 2 3000 mm

9 sfragsize_r RV Integer Smallint No 2 3000 mm

10 sfragsize_h High Integer Smallint No 2 3000 mm

11 sfragshp Shape Choice Varchar No 254 fragment_shape

12 sfraground Roundness Choice Varchar No 254 fragment_roundness

13 sfraghard Hardness Choice Varchar No 254 rupture_resist_block_cem

14 cokey Component Key String Varchar Yes 30

15 cosurffragskey Component Surface Fragments 

Key

String Varchar Yes 30

The Component Surface Fragments table lists the organic or mineral fragments that generally occur on the surface of the referenced map unit component. If the cover percent is greater than zero 

(low=0.1, RV=1, high=3) for a row in this table, the fragment is in every delineation of the map unit where the referenced component occurs. If the Cover % includes zero (low=0, RV=0.01, high=1) for 

a row in this table, the fragment may exist in some delineations and not in others.

2/4/2014 Page 41
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: cosurfmorphgc

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Three Dimensional Surface Morphometry

Physical

Data Type

1 geomposmntn Geomorphic Component - 

Mountains

Choice Varchar No 254 geomor_pos_mountain

2 geomposhill Geomorphic Component - Hills Choice Varchar No 254 geomor_pos_hill

3 geompostrce Geomorphic Component - 

Terraces

Choice Varchar No 254 geomor_pos_terrace

4 geomposflats Geomorphic Component - Flats Choice Varchar No 254 geomor_pos_flat

5 cogeomdkey Component Geomorphic 

Description Key

String Varchar Yes 30

6 cosurfmorgckey Component Surface 

Morphometry - Geomorphic 

Component Key

String Varchar Yes 30

The Component Three Dimensional Surface Morphometry table lists the typical geomorphic position (s) of the referenced map unit component, in three dimension terms. The geomorphic position(s) 

listed in this table apply to the geomorphic feature referenced in the Component Geomorphic Description table.

2/4/2014 Page 42
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: cosurfmorphhpp

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Two Dimensional Surface Morphometry

Physical

Data Type

1 hillslopeprof Hillslope Profile Choice Varchar No 254 hillslope_profile

2 cogeomdkey Component Geomorphic 

Description Key

String Varchar Yes 30

3 cosurfmorhppkey Component Surface 

Morphometry - Hillslope Profile 

Position

String Varchar Yes 30

The Component Two Dimensional Surface Morphometry table lists the geomorphic position(s) of the referenced map unit component, in two dimensional hillslope profile terms. The geomorphic 

position(s) listed in this table apply to the geomorphic feature referenced in the Component Geomorphic Description table.

2/4/2014 Page 43
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: cosurfmorphmr

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Microrelief Surface Morphometry

Physical

Data Type

1 geomicrorelief Microrelief Kind Choice Varchar No 254 microrelief_kind

2 cogeomdkey Component Geomorphic 

Description Key

String Varchar Yes 30

3 cosurfmormrkey Component Surface 

Morphometry - Micro Relief Key

String Varchar Yes 30

The Component Microrelief Surface Morphometry table lists microrelief features associated with the referenced geomorphic (microfeature) feature shown in the Component Geomorphic Description 

table.

2/4/2014 Page 44
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: cosurfmorphss

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Slope Shape Surface Morphometry

Physical

Data Type

1 shapeacross Slope Shape Across Choice Varchar No 254 slope_shape

2 shapedown Slope Shape Up/Down Choice Varchar No 254 slope_shape

3 cogeomdkey Component Geomorphic 

Description Key

String Varchar Yes 30

4 cosurfmorsskey Component Surface 

Morphometry - Slope Shape Key

String Varchar Yes 30

The Component Slope Shape Surface Morphometry table lists the geomorphic shape(s) of the referenced map unit component, in slope shape terms. The slope shape terms listed in this table apply to 

the referenced geomorphic feature shown in the Component Geomorphic Description table.

2/4/2014 Page 45
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: cotaxfmmin

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Taxonomic Family Mineralogy

Physical

Data Type

1 taxminalogy Mineralogy Choice No 254 taxonomic_family_mineralog

y

Varchar

2 cokey Component Key String Varchar Yes 30

3 cotaxfmminkey Component Taxonomic Family 

Mineralogy Key

String Varchar Yes 30

The Component Taxonomic Family Mineralogy table lists the mineralogy characteristics, as defined in Soil Taxonomy, that apply to the referenced map unit component.

2/4/2014 Page 46
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: cotaxmoistcl

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Taxonomic Moisture Class

Physical

Data Type

1 taxmoistcl Moisture Class Choice Varchar No 254 taxonomic_moisture_class

2 cokey Component Key String Varchar Yes 30

3 cotaxmckey Component Taxonomic Family 

Moisture Class Key

String Varchar Yes 30

The Component Taxonomic Moisture Class table provides clear identification of the intended taxonomic moisture class, as defined in Soil Taxonomy, that apply to the referenced map unit component, 

even though moisture class is implied at a higher taxonomic level. The class or classes listed in this table describe the representative situation for the component.

2/4/2014 Page 47
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: cotext

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Text

Physical

Data Type

1 recdate Date Date/Time Datetime No

2 comptextkind Kind Choice Varchar No 254 component_text_kind

3 textcat Category String Varchar No 20

4 textsubcat Subcategory String Varchar No 20

5 text Text Narrative 

Text

Text No

6 cokey Component Key String Varchar Yes 30

7 cotextkey Component Text Key String Varchar Yes 30

The Component Text table contains notes and narrative descriptions for the referenced map unit component. In many cases, the table will be empty for a particular component.

2/4/2014 Page 48
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: cotreestomng

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Trees To Manage

Physical

Data Type

1 plantsym Plant Symbol String Varchar Yes 8

2 plantsciname Scientific Name String Varchar No 127

3 plantcomname Common Name String Varchar No 60

4 cokey Component Key String Varchar Yes 30

5 cotreestomngkey Component Trees to Manage Key String Varchar Yes 30

The Component Trees To Manage table lists the trees commonly recommended for managing on the referenced map unit component.

2/4/2014 Page 49
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: cotxfmother

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Component Taxonomic Family Other Criteria

Physical

Data Type

1 taxfamother Family Other Choice Varchar No 254 taxonomic_family_other

2 cokey Component Key String Varchar Yes 30

3 cotaxfokey Component Taxonomic Family 

Other Key

String Varchar Yes 30

The Component Taxonomic Family Other Criteria table lists the other taxonomic characteristics, such as classes of coatings or permanent cracks, as defined in Soil Taxonomy, that apply to the 

referenced map unit component. The characteristics listed in this table describe the representative situation for the component.

2/4/2014 Page 50
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: distinterpmd

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Distribution Interp Metadata

Physical

Data Type

1 rulename Rule Name String Varchar No 60

2 ruledesign Rule Design Choice Varchar Yes 254 rule_design

3 ruledesc Description Narrative 

Text

Text No

4 dataafuse Ready to use? Boolean Varchar No 3

5 mrecentrulecwlu Most Recent Rule Component 

When Last Updated

Date/Time Datetime No

6 rulekey Rule Key String Varchar Yes 30

7 distmdkey Distribution Metadata Key String Varchar Yes 30

8 distinterpmdkey Distribution Interpretation 

Metadata Key

String Varchar Yes 30

The Distribution Interp Metadata table records the set of NASIS fuzzy logic interpretations which were generated for the map unit components included in a set of distribution data.

2/4/2014 Page 51
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: distlegendmd

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Distribution Legend Metadata

Physical

Data Type

1 areatypename Area Type Name String Varchar No 45

2 areasymbol Area Symbol String Varchar No 20

3 areaname Area Name String Varchar No 135

4 ssastatus Survey Status Choice Varchar No 254 soil_survey_area_status

5 cordate Correlation Date Date/Time Datetime No

6 exportcertstatus Export Certification Status Choice Varchar No 254 export_certification_status

7 exportcertdate Export Certification Date Date/Time Datetime No

8 exportmetadata Export Metadata Narrative 

Text

Text No

9 lkey Legend Key String Varchar Yes 30

10 distmdkey Distribution Metadata Key String Varchar Yes 30

11 distlegendmdkey Distribution Legend Metadata Key String Varchar Yes 30

The Distribution Legend Metadata table records information about the legends or soil survey areas selected for inclusion in a set of distributed data. The presence of a legend in this table does not 

imply that all of the available data for that legend was included in the set of data that was distributed. Only certain map units and components for that legend may have been selected. The record of 

the criteria used for selecting map units and components may be found in the Distribution Metadata table.

2/4/2014 Page 52
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: distmd

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Distribution Metadata

Physical

Data Type

1 distgendate Distribution Generation Date Date/Time Datetime No

2 diststatus Distribution Status Choice Varchar Yes 254 distribution_status

3 interpmaxreasons Interpretation Maximum Reasons Integer Smallint No 0

4 distmdkey Distribution Metadata Key String Varchar Yes 30

The Distribution Metadata table records information associated with the selection of a set of data for distribution to some entity or information system external to NASIS. A set of distribution data may 

include only selected map units from a legend or legends, and only selected components of those map units. This table records the criteria used for selecting map units and components for inclusion 

in the set of distributed data. Other recorded information includes the name of the NASIS user who initiated a distribution request, and the times when that request was made, and when that request 

was ultimately processed.

2/4/2014 Page 53
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: featdesc

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Feature Description

Physical

Data Type

1 areasymbol Area Symbol String Varchar Yes 20

2 spatialversion Spatial Version Integer Int Yes

3 featsym Feature Symbol String Varchar Yes 3

4 featname Feature Name String Varchar Yes 80

5 featdesc Feature Description Narrative 

Text

Text Yes

6 featkey Feature Key String Varchar Yes 30

This table records the description of all spot features that occur in a soil survey area.

2/4/2014 Page 54
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: featline

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Feature Line

Physical

Data Type

1 areasymbol Area Symbol String Varchar Yes 20

2 spatialversion Spatial Version Integer Int Yes

3 featsym Feature Symbol String Varchar Yes 3

4 featkey Feature Key String Varchar Yes 30

This table records all of the spot features of a soil survey area that are represented as one or more lines. This table is not like other tabular data tables that are delivered as ASCII delimited files. How 

the information is delivered depends on the spatial format that was requested at the time the corresponding soil survey area was exported. Spatial information is typically delivered in GIS vendor 

specific format, and more than one output file may be produced when the information for this spatial entity is exported. Consequently, no spatially oriented columns are shown, because the name and 

number of columns necessary to portray spatial characteristics vary depending on spatial format.

This table is documented in order to show attributes that will always be available when working with the corresponding spatial entity in a GIS. These attributes have two purposes. One purpose is to 

identify each instance of the corresponding spatial entity. The other purpose is to identify each instance of the corresponding tabular entity. The tabular entity corresponding to a spot feature line is 

represented by a record in the Feature Description table.

2/4/2014 Page 55
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: featpoint

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Feature Point

Physical

Data Type

1 areasymbol Area Symbol String Varchar Yes 20

2 spatialversion Spatial Version Integer Int Yes

3 featsym Feature Symbol String Varchar Yes 3

4 featkey Feature Key String Varchar Yes 30

This table records all of the spot features of a soil survey area that are represented as one or more points. This table is not like other tabular data tables that are delivered as ASCII delimited files. 

How the information is delivered depends on the spatial format that was requested at the time the corresponding soil survey area was exported. Spatial information is typically delivered in GIS vendor 

specific format, and more than one output file may be produced when the information for this spatial entity is exported. Consequently, no spatially oriented columns are shown, because the name and 

number of columns necessary to portray spatial characteristics vary depending on spatial format.

This table is documented in order to show attributes that will always be available when working with the corresponding spatial entity in a GIS. These attributes have two purposes. One purpose is to 

identify each instance of the corresponding spatial entity. The other purpose is to identify each instance of the corresponding tabular entity. The tabular entity corresponding to a spot feature point is 

represented by a record in the Feature Description table.

2/4/2014 Page 56
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: laoverlap

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Legend Area Overlap

Physical

Data Type

1 areatypename Area Type Name String Varchar Yes 45

2 areasymbol Area Symbol String Varchar Yes 20

3 areaname Area Name String Varchar No 135

4 areaovacres Overlap Acres Integer Int No 0 acres

5 lkey Legend Key String Varchar Yes 30

6 lareaovkey Legend Area Overlap Key String Varchar Yes 30

The Legend Area Overlap table lists the geographic areas that are coincident with the soil survey area identified in the Legend table. For example, a survey area that covers two counties would have 

two rows in this table, one for each county. Other types of geographic areas listed might include state, MLRA, rainfall (R) factor area, climate (C) factor area, etc.

2/4/2014 Page 57
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: legend

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Legend

Physical

Data Type

1 areatypename Area Type Name String Varchar Yes 45

2 areasymbol Area Symbol String Varchar Yes 20

3 areaname Area Name String Varchar No 135

4 areaacres Area Acres Integer Int No 0 acres

5 mlraoffice MLRA Office Choice Varchar No 254 mlra_office

6 legenddesc Legend Description String Varchar No 60

7 ssastatus Survey Status Choice Varchar No 254 soil_survey_area_status

8 mouagncyresp MOU Agency Responsible Choice Varchar No 254 mou_agency_responsible

9 projectscale Project Scale Integer Int No

10 cordate Correlation Date Date/Time Datetime No

11 ssurgoarchived SSURGO Archived Date/Time Datetime No

12 legendsuituse Geographic Applicability Choice Varchar No 254 legend_suitability_for_use

13 legendcertstat Legend Certification Status Choice Varchar No 254 legend_certification_status

14 lkey Legend Key String Varchar Yes 30

The Legend table identifies the soil survey area that the legend is related to, and related information about that legend.

2/4/2014 Page 58
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: legendtext

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Legend Text

Physical

Data Type

1 recdate Date Date/Time Datetime No

2 legendtextkind Kind Choice Varchar No 254 legend_text_kind

3 textcat Category String Varchar No 20

4 textsubcat Subcategory String Varchar No 20

5 text Text Narrative 

Text

Text No

6 lkey Legend Key String Varchar Yes 30

7 legtextkey Legend Text Key String Varchar Yes 30

The Legend Text table contains notes and narrative descriptions related to the referenced legend. Legend text is optional. In many cases, this table is empty.

2/4/2014 Page 59
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: mapunit

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Mapunit

Physical

Data Type

1 musym Mapunit Symbol String Varchar Yes 6

2 muname Mapunit Name String Varchar No 175

3 mukind Kind Choice Varchar No 254 mapunit_kind

4 mustatus Status Choice Varchar No 254 mapunit_status

5 muacres Total Acres Integer Int No 0 acres

6 mapunitlfw_l Low Integer Smallint No meters

7 mapunitlfw_r RV Integer Smallint No meters

8 mapunitlfw_h High Integer Smallint No meters

9 mapunitpfa_l Low Float Real No 1 0.1 10 acres

10 mapunitpfa_r RV Float Real No 1 0.1 10 acres

11 mapunitpfa_h High Float Real No 1 0.1 10 acres

12 farmlndcl Farm Class Choice Varchar No 254 farmland_classification

13 muhelcl HEL Choice Varchar No 254 mapunit_hel_class

14 muwathelcl HEL Water Choice Varchar No 254 mapunit_hel_class

15 muwndhelcl HEL Wind Choice Varchar No 254 mapunit_hel_class

16 interpfocus Interpretive Focus String Varchar No 30

17 invesintens Order of Mapping Choice Varchar No 254 investigation_intensity

18 iacornsr IA CSR Integer Smallint No 5 100

19 nhiforsoigrp NH Forest Soil Grp Choice No 254 nh_important_forest_soil_gro

up

Varchar

20 nhspiagr NH SPI Agr Float Float No 1 0 100

21 vtsepticsyscl VT Septic System Choice No 254 vt_septic_system_class_200

7

Varchar

22 mucertstat Map Unit Certification Status Choice Varchar No 254 mapunit_certification_status

23 lkey Legend Key String Varchar Yes 30

24 mukey Mapunit Key String Varchar Yes 30

The Mapunit table identifies the map units included in the referenced legend. Data related the map unit as a whole are also given.

2/4/2014 Page 60
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: mdstatdomdet

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Domain Detail Static Metadata

Physical

Data Type

1 domainname Domain Name String Varchar Yes 40

2 choicesequence Choice Sequence Integer Smallint Yes

3 choice Choice String Varchar Yes 254

4 choicedesc Choice Description Narrative 

Text

Text No

5 choiceobsolete Obsolete Choice? Boolean Varchar Yes 3

The Domain Detail Static Metadata table records the individual domain members for all domains associated with the tabular data set. Each record in this table represents one member of a particular 

domain.

2/4/2014 Page 61
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: mdstatdommas

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Domain Master Static Metadata

Physical

Data Type

1 domainname Domain Name String Varchar Yes 40

2 domainmaxlen Domain Maximum Length Integer Smallint Yes 1 254

The Domain Master Static Metadata table records the metadata that pertains to a domain as a whole, for all domains associated with the tabular data set. A domain is a fixed set of choices to which a 

column's value is restricted. Each column in the Table Column Static Metadata table whose logical data type is "choice", has a corresponding domain. Each record in this table represents a particular 

domain. A particular domain may serve as the domain for more than one column. Information about the members that make up a particular domain is found in the Domain Detail Static Metadata table.

2/4/2014 Page 62
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: mdstatidxdet

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Index Detail Static Metadata

Physical

Data Type

1 tabphyname Table Physical Name String Varchar Yes 30

2 idxphyname Index Physical Name String Varchar Yes 30

3 idxcolsequence Index Column Sequence Integer Smallint Yes

4 colphyname Column Physical Name String Varchar Yes 30

The Index Detail Static Metadata table records what columns of a table make up a particular index. Each record in this table represents one column of a particular index.

2/4/2014 Page 63
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: mdstatidxmas

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Index Master Static Metadata

Physical

Data Type

1 tabphyname Table Physical Name String Varchar Yes 30

2 idxphyname Index Physical Name String Varchar Yes 30

3 uniqueindex Unique Index? Boolean Varchar Yes 3

The Index Master Static Metadata table records the metadata that pertains to an index, as a whole, for all indexes defined for the tabular data set. Each record in this table represents one index for a 

particular table. An index is based on one or more columns from a particular table. Information about the columns that make up an index is found in the Index Detail Static Metadata table.

2/4/2014 Page 64
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: mdstatrshipdet

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Relationship Detail Static Metadata

Physical

Data Type

1 ltabphyname Left Table Physical Name String Varchar Yes 30

2 rtabphyname Right Table Physical Name String Varchar Yes 30

3 relationshipname Relationship Name String Varchar Yes 30

4 ltabcolphyname Left Table Column Physical Name String Varchar Yes 30

5 rtabcolphyname Right Table Column Physical 

Name

String Varchar Yes 30

The Relationship Detail Static Metadata table records the pairs of join columns that define a particular relationship. Each record in this table represents one pair of join columns for a particular 

relationship.

2/4/2014 Page 65
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: mdstatrshipmas

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Relationship Master Static Metadata

Physical

Data Type

1 ltabphyname Left Table Physical Name String Varchar Yes 30

2 rtabphyname Right Table Physical Name String Varchar Yes 30

3 relationshipname Relationship Name String Varchar Yes 30

4 cardinality Cardinality Choice Varchar Yes 254 cardinality

5 mandatory Mandatory? Boolean Varchar Yes 3

The Relationship Master Static Metadata table records the metadata that pertains to a relationship, as a whole, for all relationships defined for the tabular data set. Each record in this table represents 

one particular relationship between two related tables. A relationship involves one or more pairs of join columns, and more than one relationship may exist between the same two tables. Information 

about the join columns involved in a relationship is found in the Relationship Detail Static Metadata table.

2/4/2014 Page 66
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: mdstattabcols

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Table Column Static Metadata

Physical

Data Type

1 tabphyname Table Physical Name String Varchar Yes 30

2 colsequence Column Sequence Integer Smallint Yes

3 colphyname Column Physical Name String Varchar Yes 30

4 collogname Column Logical Name String Varchar Yes 30

5 collabel Column Label String Varchar Yes 80

6 logicaldatatype Logical Data Type Choice Varchar Yes 254 logical_data_type_ssurgo

7 notnull Not Null? Boolean Varchar Yes 3

8 fieldsize Field Size Integer Smallint No

9 precision Precision Integer Smallint No

10 minimum Minimum Float Float No 2

11 maximum Maximum Float Float No 2

12 uom Unit of Measure String Varchar No 60

13 domainname Domain Name String Varchar No 40

14 coldesc Column Description Narrative 

Text

Text Yes

The Table Column Static Metadata table records the metadata for all columns of all tables that make up the tabular data set. Each record in this table represents one column of a particular table.

2/4/2014 Page 67
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: mdstattabs

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Table Static Metadata

Physical

Data Type

1 tabphyname Table Physical Name String Varchar Yes 30

2 tablogname Table Logical Name String Varchar Yes 30

3 tablabel Table Label String Varchar Yes 80

4 tabdesc Table Description Narrative 

Text

Text Yes

5 iefilename Import/Export File Name String Varchar Yes 30

The Table Static Metadata table records metadata about the tables that make up the tabular data set. Each record in this table represents one table.

2/4/2014 Page 68
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: month

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Month

Physical

Data Type

1 monthseq Month Sequence Integer Smallint Yes 1 12

2 monthname Month Name String Varchar Yes 9 flooding_ponding_month

This is a lookup table for months of the year.

2/4/2014 Page 69
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: muaggatt

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Mapunit Aggregated Attribute

Physical

Data Type

1 musym Mapunit Symbol String Varchar Yes 6

2 muname Mapunit Name String Varchar No 175

3 mustatus Status Choice Varchar No 254 mapunit_status

4 slopegraddcp Slope Gradient - Dominant 

Component

Float Real No 1 percent

5 slopegradwta Slope Gradient - Weighted 

Average

Float Real No 1 percent

6 brockdepmin Bedrock Depth - Minimum Integer Smallint No cm

7 wtdepannmin Water Table Depth - Annual - 

Minimum

Integer Smallint No cm

8 wtdepaprjunmin Water Table Depth - April - June - 

Minimum

Integer Smallint No cm

9 flodfreqdcd Flooding Frequency - Dominant 

Condition

Choice Varchar No 254 flooding_frequency_class

10 flodfreqmax Flooding Frequency - Maximum Choice Varchar No 254 flooding_frequency_class

11 pondfreqprs Ponding Frequency - Presence Choice No 254 ponding_frequency_map_leg

end

Varchar

12 aws025wta Available Water Storage 0-25 

cm - Weighted Average

Float Real No 2 cm

13 aws050wta Available Water Storage 0-50 

cm - Weighted Average

Float Real No 2 cm

14 aws0100wta Available Water Storage 0-100 

cm - Weighted Average

Float Real No 2 cm

15 aws0150wta Available Water Storage 0-150 

cm - Weighted Average

Float Real No 2 cm

16 drclassdcd Drainage Class - Dominant 

Condition

Choice Varchar No 254 drainage_class

17 drclasswettest Drainage Class - Wettest Choice Varchar No 254 drainage_class

18 hydgrpdcd Hydrologic Group - Dominant 

Conditions

Choice Varchar No 254 hydrologic_group

19 iccdcd Irrigated Capability Class - 

Dominant Condition

Choice Varchar No 254 capability_class

20 iccdcdpct Irrigated Capability Class - 

Dominant Condition Aggregate 

Percent

Integer Smallint No 0 100

21 niccdcd Non-Irrigated Capability Class - 

Dominant Condition

Choice Varchar No 254 capability_class

2/4/2014 Page 70
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: muaggatt

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Mapunit Aggregated Attribute

Physical

Data Type

22 niccdcdpct Non-Irrigated Capability Class - 

Dominant Condition Aggregate 

Percent

Integer Smallint No 0 100

23 engdwobdcd ENG - Dwellings W/O 

Basements - Dominant Condition

String Varchar No 254

24 engdwbdcd ENG - Dwellings with 

Basements - Dominant Condition

String Varchar No 254

25 engdwbll ENG - Dwellings with 

Basements - Least Limiting

String Varchar No 254

26 engdwbml ENG - Dwellings with 

Basements - Most Limiting

String Varchar No 254

27 engstafdcd ENG - Septic Tank Absorption 

Fields - Dominant Condition

String Varchar No 254

28 engstafll ENG - Septic Tank Absorption 

Fields - Least Limiting

String Varchar No 254

29 engstafml ENG - Septic Tank Absorption 

Fields - Most Limiting

String Varchar No 254

30 engsldcd ENG - Sewage Lagoons - 

Dominant Condition

String Varchar No 254

31 engsldcp ENG - Sewage Lagoons - 

Dominant Component

String Varchar No 254

32 englrsdcd ENG - Local Roads and Streets - 

Dominant Condition

String Varchar No 254

33 engcmssdcd ENG - Construction Materials; 

Sand Source - Dominant 

Condition

String Varchar No 254

34 engcmssmp ENG - Construction Materials; 

Sand Source - Most Probable

String Varchar No 254

35 urbrecptdcd URB/REC - Paths and Trails - 

Dominant Condition

String Varchar No 254

36 urbrecptwta URB/REC - Paths and Trails - 

Weighted Average

Float Real No 2

37 forpehrtdcp FOR - Potential Erosion Hazard 

(Road/Trail) - Dominant 

Component

String Varchar No 254

38 hydclprs Hydric Classification - Presence Choice No 254 hydric_classification_map_le

gend

Varchar

2/4/2014 Page 71
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: muaggatt

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Mapunit Aggregated Attribute

Physical

Data Type

39 awmmfpwwta AWM - Manure and Food 

Processing Waste - Weighted 

Average

Float Real No 2

40 mukey Mapunit Key String Varchar Yes 30

The Mapunit Aggregated Attribute table records a variety of soil attributes and interpretations that have been aggregated from the component level to a single value at the map unit level. They have 

been aggregated by one or more appropriate means in order to express a consolidated value or interpretation for the map unit as a whole.

2/4/2014 Page 72
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: muaoverlap

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Mapunit Area Overlap

Physical

Data Type

1 areaovacres Overlap Acres Integer Int No 0 acres

2 lareaovkey Legend Area Overlap Key String Varchar Yes 30

3 mukey Mapunit Key String Varchar Yes 30

4 muareaovkey Mapunit Area Overlap Key String Varchar Yes 30

The Mapunit Area Overlap table lists the map units that exist in the overlap between the entire soil survey area and the referenced geographic area in the Legend Area Overlap table.

2/4/2014 Page 73
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: mucropyld

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Mapunit Crop Yield

Physical

Data Type

1 cropname Crop Name Choice Varchar No 254 crop_name

2 yldunits Units Choice Varchar No 254 crop_yield_units

3 nonirryield_l Low Float Real No 2 0 9999.99

4 nonirryield_r RV Float Real No 2 0 9999.99

5 nonirryield_h High Float Real No 2 0 9999.99

6 irryield_l Low Float Real No 2 0 9999.99

7 irryield_r RV Float Real No 2 0 9999.99

8 irryield_h High Float Real No 2 0 9999.99

9 mukey Mapunit Key String Varchar Yes 30

10 mucrpyldkey Mapunit Crop Yield Key String Varchar Yes 30

The Mapunit Crop Yield table lists commonly grown crops and their expected yields for the referenced map unit as a whole. Yields for individual map unit components are given in the Component Crop 

Yield table.

2/4/2014 Page 74
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: muline

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Mapunit Line

Physical

Data Type

1 areasymbol Area Symbol String Varchar Yes 20

2 spatialversion Spatial Version Integer Int Yes

3 musym Mapunit Symbol String Varchar Yes 6

4 mukey Mapunit Key String Varchar Yes 30

This table records all of the soil map units of a soil survey area that are represented as one or more lines. This table is not like other tabular data tables that are delivered as ASCII delimited files. How 

the information is delivered depends on the spatial format that was requested at the time the corresponding soil survey area was exported. Spatial information is typically delivered in GIS vendor 

specific format, and more than one output file may be produced when the information for this spatial entity is exported. Consequently, no spatially oriented columns are shown, because the name and 

number of columns necessary to portray spatial characteristics vary depending on spatial format.

This table is documented in order to show attributes that will always be available when working with the corresponding spatial entity in a GIS. These attributes have two purposes. One purpose is to 

identify each instance of the corresponding spatial entity. The other purpose is to identify each instance of the corresponding tabular entity. The tabular entity corresponding to a map unit line is 

represented by a record in the Map Unit table.

2/4/2014 Page 75
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: mupoint

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Mapunit Point

Physical

Data Type

1 areasymbol Area Symbol String Varchar Yes 20

2 spatialversion Spatial Version Integer Int Yes

3 musym Mapunit Symbol String Varchar Yes 6

4 mukey Mapunit Key String Varchar Yes 30

This table records all of the soil map units of a soil survey area that are represented as one or more points. This table is not like other tabular data tables that are delivered as ASCII delimited files. 

How the information is delivered depends on the spatial format that was requested at the time the corresponding soil survey area was exported. Spatial information is typically delivered in GIS vendor 

specific format, and more than one output file may be produced when the information for this spatial entity is exported. Consequently, no spatially oriented columns are shown, because the name and 

number of columns necessary to portray spatial characteristics vary depending on spatial format.

This table is documented in order to show attributes that will always be available when working with the corresponding spatial entity in a GIS. These attributes have two purposes. One purpose is to 

identify each instance of the corresponding spatial entity. The other purpose is to identify each instance of the corresponding tabular entity. The tabular entity corresponding to a map unit point is 

represented by a record in the Map Unit table.

2/4/2014 Page 76
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: mupolygon

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Mapunit Polygon

Physical

Data Type

1 areasymbol Area Symbol String Varchar Yes 20

2 spatialversion Spatial Version Integer Int Yes

3 musym Mapunit Symbol String Varchar Yes 6

4 mukey Mapunit Key String Varchar No 30

This table records all of the soil map units of a soil survey area that are represented as one or more polygons. This table is not like other tabular data tables that are delivered as ASCII delimited files. 

How the information is delivered depends on the spatial format that was requested at the time the corresponding soil survey area was exported. Spatial information is typically delivered in GIS vendor 

specific format, and more than one output file may be produced when the information for this spatial entity is exported. Consequently, no spatially oriented columns are shown, because the name and 

number of columns necessary to portray spatial characteristics vary depending on spatial format.

This table is documented in order to show attributes that will always be available when working with the corresponding spatial entity in a GIS. These attributes have two purposes. One purpose is to 

identify each instance of the corresponding spatial entity. The other purpose is to identify each instance of the corresponding tabular entity. The tabular entity corresponding to a map unit polygon is 

represented by a record in the Map Unit table.

2/4/2014 Page 77
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: mutext

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Mapunit Text

Physical

Data Type

1 recdate Date Date/Time Datetime No

2 mapunittextkind Kind Choice Varchar No 254 mapunit_text_kind

3 textcat Category String Varchar No 20

4 textsubcat Subcategory String Varchar No 20

5 text Text Narrative 

Text

Text No

6 mukey Mapunit Key String Varchar Yes 30

7 mutextkey Mapunit Text Key String Varchar Yes 30

The Mapunit Text table contains notes and narrative descriptions related to the referenced map unit.

2/4/2014 Page 78
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: sacatalog

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Survey Area Catalog

Physical

Data Type

1 areasymbol Area Symbol String Varchar Yes 20

2 areaname Area Name String Varchar Yes 135

3 saversion Survey Area Version Integer Int Yes

4 saverest Survey Area Version Established Date/Time Datetime Yes

5 tabularversion Tabular Version Integer Int Yes

6 tabularverest Tabular Version Established Date/Time Datetime Yes

7 tabnasisexportdate Tabular NASIS Export Date Date/Time Datetime Yes

8 tabcertstatus Tabular Certification Status Choice Varchar No 254 export_certification_status

9 tabcertstatusdesc Tabular Certification Status 

Description

Narrative 

Text

Text No

10 fgdcmetadata FGDC Metadata Narrative 

Text

Text Yes

11 sacatalogkey Survey Area Catalog Key String Varchar Yes 30

This table records the primary dynamic cetadata associated with a soil survey area. This includes such things as survey area version, tabular data version, etc. The remaining dynamic metadata, 

which soil interpretations were generated for the corresponding soil survey area, is recorded in the Survey Area Interpretation table.

2/4/2014 Page 79
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: sainterp

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Survey Area Interpretation

Physical

Data Type

1 areasymbol Area Symbol String Varchar Yes 20

2 interpname Interpretation Name String Varchar Yes 60

3 interptype Interpretation Type Choice Varchar Yes 254 rule_design

4 interpdesc Interpretation Description Narrative 

Text

Text No

5 interpdesigndate Interpretation Design Date Date/Time Datetime Yes

6 interpgendate Interpretation Generation Date Date/Time Datetime Yes

7 interpmaxreasons Interpretation Maximum Reasons Integer Smallint No 0

8 sacatalogkey Survey Area Catalog Key String Varchar Yes 30

9 sainterpkey Survey Area Interpretation Key String Varchar Yes 30

This table records information about the soil interpretations that were generated for a soil survey area.

2/4/2014 Page 80
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: sapolygon

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: Survey Area Polygon

Physical

Data Type

1 areasymbol Area Symbol String Varchar Yes 20

2 spatialversion Spatial Version Integer Int Yes

3 lkey Legend Key String Varchar Yes 30

This table records the set of polygons that make up a soil survey area boundary. The table is not like other tabular data tables that are delivered as ASCII delimited files. How the information in this 

table is delivered depends of the spatial format that was requested at the time the corresponding soil survey area data was exported. Spatial information is typically delivered in GIS vendor specific 

format, and more than one output file may be produced when the information for this spatial entity is exported. Consequently, no spatially oriented columns are shown, because the name and number 

of columns necessary to portray spatial characteristics vary depending on spatial format.

This table is documented in order to show attributes that will always be available when working with the corresponding spatial entity in a GIS. These attributes have two purposes. One purpose is to 

identify each instance of the corresponding spatial entity. The other purpose is to identify each instance of the corresponding tabular entity. The tabular entity corresponding to the survey area 

boundary is represented by a record in the Legend table.

2/4/2014 Page 81
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: sdvalgorithm

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: SDV Algorithm

Physical

Data Type

1 algorithmsequence Algorithm Sequence Integer Smallint Yes

2 algorithmname Algorithm Name String Varchar Yes 50 algorithm

3 algorithminitials Algorithm Initials String Varchar Yes 3

4 algorithmdescription Algorithm Description Narrative 

Text

Text Yes

This lookup table records the valid algorithms for aggregating soil property values or soil interpretation results to the map unit level.

2/4/2014 Page 82
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: sdvattribute

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: SDV Attribute

Physical

Data Type

1 attributekey Attribute Key Integer Int Yes 1

2 attributename Attribute Name String Varchar Yes 60

3 attributetablename Attribute Table Name String Varchar Yes 30

4 attributecolumnname Attribute Column Name String Varchar Yes 30

5 attributelogicaldatatype Attribute Logical Data Type String Yes 20 sdv_attribute_logical_data_ty

pe

Varchar

6 attributefieldsize Attribute Field Size Integer Smallint No 1 255

7 attributeprecision Attribute Precision Integer Smallint No 1 6

8 attributedescription Attribute Description Narrative 

Text

Text Yes

9 attributeuom Attribute Units of Measure String Varchar No 60

10 attributeuomabbrev Attribute Units of Measure 

Abbreviation

String Varchar No 30

11 attributetype Attribute Type String Varchar Yes 20 attributetype

12 nasisrulename NASIS Rule Name String Varchar No 60

13 ruledesign Rule Design Integer Smallint No rule_design

14 notratedphrase Not Rated Phrase String Varchar No 254

15 mapunitlevelattribflag Map Unit Level Attribute Flag Boolean Smallint Yes

16 complevelattribflag Component Level Attribute Flag Boolean Smallint Yes

17 cmonthlevelattribflag Component Month Level Attribute 

Flag

Boolean Smallint Yes

18 horzlevelattribflag Horizon Level Attribute Flag Boolean Smallint Yes

19 tiebreakdomainname Tie Break Domain Name String Varchar No 40

20 tiebreakruleoptionflag Tie Break Rule Option Flag Boolean Smallint Yes

21 tiebreaklowlabel Tie Break Low Label String Varchar No 20

22 tiebreakhighlabel Tie Break High Label String Varchar No 20

23 tiebreakrule Tie Break Rule Integer Smallint Yes tiebreakrule

24 resultcolumnname Result Column Name String Varchar Yes 10

25 sqlwhereclause SQL Where Clause String Varchar No 255

26 primaryconcolname Primary Constraint Column Name String Varchar No 30

27 pcclogicaldatatype Primary Constraint Column 

Logical Data Type

String No 20 sdv_attribute_logical_data_ty

pe

Varchar

28 primaryconstraintlabel Primary Constraint Label String Varchar No 30

2/4/2014 Page 83
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: sdvattribute

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: SDV Attribute

Physical

Data Type

29 secondaryconcolname Secondary Constraint Column 

Name

String Varchar No 30

30 scclogicaldatatype Secondary Constraint Column 

Logical Data Type

String No 20 sdv_attribute_logical_data_ty

pe

Varchar

31 secondaryconstraintlabe

l

Secondary Constraint Label String Varchar No 30

32 dqmodeoptionflag Depth Qualifier Mode Option Flag Boolean Smallint Yes

33 depthqualifiermode Depth Qualifier Mode String Varchar No 20 depthqualmode

34 layerdepthtotop Layer Depth to Top Float Real No 1 0 9999

35 layerdepthtobottom Layer Depth to Bottom Float Real No 1 0 9999

36 layerdepthuom Layer Depth UOM String Varchar No 20 depthuom

37 monthrangeoptionflag Month Range Option Flag Boolean Smallint Yes

38 beginningmonth Beginning Month String Varchar No 9 flooding_ponding_month

39 endingmonth Ending Month String Varchar No 9 flooding_ponding_month

40 horzaggmeth Horizon Aggregation Method Choice Varchar Yes 30 horizon_aggregation_method

41 interpnullsaszerooptionfl

ag

Interpret Nulls as Zero Option Flag Boolean Smallint Yes

42 interpnullsaszeroflag Interpret Nulls as Zero Flag Boolean Smallint Yes

43 nullratingreplacementval

ue

Null Rating Replacement Value String Varchar No 254

44 basicmodeflag Basic Mode Flag Boolean Smallint Yes

45 maplegendkey Map Legend Key Integer Int Yes 1

46 maplegendclasses Map Legend Classes Integer Smallint No 2 100

47 maplegendxml Map Legend XML Narrative 

Text

Text Yes

48 nasissiteid NASIS Site ID Integer Int Yes

49 wlupdated Last Updated Date/Time Datetime Yes

50 algorithmname Algorithm Name String Varchar Yes 50 algorithm

51 componentpercentcutoff Component Percent Cutoff Integer Smallint No 0 100

52 readytodistribute Ready to Distribute Boolean Smallint Yes

53 effectivelogicaldatatype Effective Logical Data Type Choice Yes 20 sdv_attribute_logical_data_ty

pe

Varchar

2/4/2014 Page 84
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: sdvattribute

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: SDV Attribute

Physical

Data Type

Each record in this table corresponds to either an intrinsic soil property or a soil interpretation that is available in the Soil Data Viewer application. A record in this table is also referred to as an "SDV 

rule". A rule provides most of the information necessary for the Soil Data Viewer application to be able to create a thematic map for the corresponding soil attribute. Some additional information 

needed in order to be able to create a thematic map may be collected at run time.

2/4/2014 Page 85
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: sdvfolder

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: SDV Folder

Physical

Data Type

1 foldersequence Folder Sequence Integer Smallint Yes 1

2 foldername Folder Name String Varchar Yes 80

3 folderdescription Folder Description Narrative 

Text

Text Yes

4 folderkey Folder Key Integer Int Yes 1

5 parentfolderkey Parent Folder Key Integer Int No

6 wlupdated Last Updated Date/Time Datetime Yes

The records in this table represent the folders and subfolders by which soil attributes (SDV rules) are grouped and displayed in the Soil Data Viewer application. One record in this table may be related 

to another record in this table, i.e. a subfolder must identify its corresponding parent folder.

2/4/2014 Page 86
Text13: Tables and Columns

Text13: SSURGO 2.3.2

Table Physical Name: sdvfolderattribute

Seq

Column 

Physical Name Column Label

Logical 

Data Type Not Null? Size Precision Minimum Maximum

Units of 

Measure Domain Name

Table Label: SDV Folder Attribute

Physical

Data Type

1 folderkey Folder Key Integer Int Yes 1

2 attributekey Attribute Key Integer Int Yes 1

This associative table resolves the many to many relationship between Soil Data Viewer folders and soil attributes (SDV rules).

2/4/2014 Page 87