R/Class-SoilProfileCollection.R, R/SoilProfileCollection-setters.R
horizons.RdGet horizon data from SoilProfileCollection. Result is returned in the same data.frame class used to initially construct the SoilProfileCollection.
Horizon data in an object inheriting from data.frame can easily be added via merge (LEFT JOIN). There must be one or more same-named columns (with at least some matching data) on the left and right hand side to facilitate the join: horizons(spc) <- newdata
# S4 method for class 'SoilProfileCollection'
horizons(object)
# S4 method for class 'SoilProfileCollection'
horizons(object) <- value
# load test data
data(sp2)
# promote to SPC
depths(sp2) <- id ~ top + bottom
# assign true to surface horizon
newdata <- data.frame(top = 0,
newvalue = TRUE)
# do left join
horizons(sp2) <- newdata
# inspect site table: newvalue TRUE only for horizons
# with top depth equal to zero
horizons(sp2)
#> top id surface bottom bound_distinct bound_topography name
#> 1 0 hon-1 holocene 12 A S A
#> 2 12 hon-1 holocene 16 A S 2A1
#> 3 16 hon-1 holocene 25 C S 2A2
#> 4 25 hon-1 holocene 49 C S 2AC
#> 5 49 hon-1 holocene 85 C S 2C
#> 6 85 hon-1 holocene 95 A S 3C1
#> 7 95 hon-1 holocene 122 <NA> <NA> 3C2
#> 8 122 hon-1 holocene 140 <NA> <NA> 4C1
#> 9 140 hon-1 holocene 170 <NA> <NA> 4C2
#> 10 0 hon-10 lower modesto 22 C W Ap
#> 11 22 hon-10 lower modesto 40 G S BA
#> 12 40 hon-10 lower modesto 86 G S Bt1
#> 13 86 hon-10 lower modesto 132 C S Bt2
#> 14 132 hon-10 lower modesto 150 C S BC
#> 15 150 hon-10 lower modesto 205 A W C
#> 16 205 hon-10 lower modesto 225 <NA> <NA> 2C
#> 17 0 hon-11 lower modesto 18 A W Ap
#> 18 18 hon-11 lower modesto 45 G S BA
#> 19 45 hon-11 lower modesto 94 G S Bt1
#> 20 94 hon-11 lower modesto 125 C W Bt2
#> 21 125 hon-11 lower modesto 145 G W BC
#> 22 145 hon-11 lower modesto 179 A W C
#> 23 179 hon-11 lower modesto 220 <NA> <NA> 2C
#> 24 0 hon-13 upper modesto 24 A S Ap
#> 25 24 hon-13 upper modesto 33 C S BA
#> 26 33 hon-13 upper modesto 50 C S BAt1
#> 27 50 hon-13 upper modesto 62 C S BAt2
#> 28 62 hon-13 upper modesto 86 C S Bt1
#> 29 86 hon-13 upper modesto 102 C S Bt2
#> 30 102 hon-13 upper modesto 123 C S Bt3
#> 31 123 hon-13 upper modesto 157 G W BCt
#> 32 157 hon-13 upper modesto 208 <NA> <NA> 2BCt1
#> 33 208 hon-13 upper modesto 245 G W 2BCt2
#> 34 245 hon-13 upper modesto 266 D W 2BCt3
#> 35 266 hon-13 upper modesto 301 <NA> <NA> 2CB
#> 36 0 hon-14 upper modesto 28 A S Ap
#> 37 28 hon-14 upper modesto 39 C S BA
#> 38 39 hon-14 upper modesto 59 C S BAt1
#> 39 59 hon-14 upper modesto 76 C S BAt2
#> 40 76 hon-14 upper modesto 111 C W Bt1
#> 41 111 hon-14 upper modesto 126 C W Bt2
#> 42 126 hon-14 upper modesto 150 G W 2BCt1
#> 43 150 hon-14 upper modesto 200 G W 2BCt2
#> 44 200 hon-14 upper modesto 260 D W 2BCt3
#> 45 260 hon-14 upper modesto 320 <NA> <NA> 2CB
#> 46 0 hon-17 lower riverbank 18 C W Ap1
#> 47 18 hon-17 lower riverbank 24 A W Ap2
#> 48 24 hon-17 lower riverbank 76 G W BA
#> 49 76 hon-17 lower riverbank 100 G W Bt1
#> 50 100 hon-17 lower riverbank 160 C W Bt2
#> 51 160 hon-17 lower riverbank 201 G W 2BCt
#> 52 201 hon-17 lower riverbank 208 C S 3BCt
#> 53 208 hon-17 lower riverbank 295 <NA> <NA> 4BCt
#> 54 0 hon-18 lower riverbank 19 C W Ap1
#> 55 19 hon-18 lower riverbank 30 A W Ap2
#> 56 30 hon-18 lower riverbank 90 G W BA
#> 57 90 hon-18 lower riverbank 113 C W Bt1
#> 58 113 hon-18 lower riverbank 170 G W Bt2
#> 59 170 hon-18 lower riverbank 190 C W 2BCt
#> 60 190 hon-18 lower riverbank 240 C S 3BCt
#> 61 240 hon-18 lower riverbank 300 <NA> <NA> 4BCt
#> 62 0 hon-19 lower riverbank 7 C W Ap1
#> 63 7 hon-19 lower riverbank 24 A W Ap2
#> 64 24 hon-19 lower riverbank 63 G W BA
#> 65 63 hon-19 lower riverbank 91 C W Bt1
#> 66 91 hon-19 lower riverbank 126 G W Bt2
#> 67 126 hon-19 lower riverbank 176 C W Bt3
#> 68 176 hon-19 lower riverbank 218 C S BCt
#> 69 218 hon-19 lower riverbank 246 G S 2BCt1
#> 70 246 hon-19 lower riverbank 268 G S 2BCt2
#> 71 268 hon-19 lower riverbank 300 <NA> <NA> 2BCt3
#> 72 300 hon-19 lower riverbank 320 <NA> <NA> 3Cox
#> 73 320 hon-19 lower riverbank 410 <NA> <NA> 3Cox
#> 74 0 hon-2 holocene 4 A S A1
#> 75 4 hon-2 holocene 32 A W A2
#> 76 32 hon-2 holocene 61 C S C
#> 77 61 hon-2 holocene 92 C S 2C
#> 78 92 hon-2 holocene 103 <NA> <NA> 3C
#> 79 103 hon-2 holocene 130 <NA> <NA> 4C
#> 80 0 hon-20 lower riverbank 11 C W Ap1
#> 81 11 hon-20 lower riverbank 30 A W Ap2
#> 82 30 hon-20 lower riverbank 60 C W BA
#> 83 60 hon-20 lower riverbank 114 C I Bt1
#> 84 114 hon-20 lower riverbank 191 C W Bt2
#> 85 191 hon-20 lower riverbank 223 G S 2BCt1
#> 86 223 hon-20 lower riverbank 260 G S 2BCt2
#> 87 260 hon-20 lower riverbank 283 <NA> <NA> 2CB
#> 88 0 hon-21 lower laguna 11 C S A
#> 89 11 hon-21 lower laguna 33 C W AB
#> 90 33 hon-21 lower laguna 46 A W BA
#> 91 46 hon-21 lower laguna 71 C W Bt1
#> 92 71 hon-21 lower laguna 93 C W Bt2
#> 93 93 hon-21 lower laguna 119 C W Bt3
#> 94 119 hon-21 lower laguna 148 G W Bt4
#> 95 148 hon-21 lower laguna 197 G W 2Bt1
#> 96 197 hon-21 lower laguna 274 D W 2Bt2
#> 97 274 hon-21 lower laguna 315 D W 2BC
#> 98 315 hon-21 lower laguna 473 A I 3BC
#> 99 473 hon-21 lower laguna 1300 <NA> <NA> C
#> 100 0 hon-22 lower laguna 23 C W A
#> 101 23 hon-22 lower laguna 43 C W AB
#> 102 43 hon-22 lower laguna 59 A W BA
#> 103 59 hon-22 lower laguna 89 C W Bt1
#> 104 89 hon-22 lower laguna 120 C W Bt2
#> 105 120 hon-22 lower laguna 154 G S Bt3
#> 106 154 hon-22 lower laguna 207 G S 2Bt1
#> 107 207 hon-22 lower laguna 270 G W 2Bt2
#> 108 270 hon-22 lower laguna 342 G W 2BCt
#> 109 342 hon-22 lower laguna 455 G W 3BCt1
#> 110 455 hon-22 lower laguna 505 A W 3BCt2
#> 111 505 hon-22 lower laguna 1300 <NA> <NA> C
#> 112 0 hon-3 holocene 4 A S A1
#> 113 4 hon-3 holocene 16 G S A2
#> 114 16 hon-3 holocene 31 A W AC
#> 115 31 hon-3 holocene 54 A W C
#> 116 54 hon-3 holocene 78 <NA> <NA> 2C
#> 117 0 hon-4 holocene 17 A S C
#> 118 17 hon-4 holocene 32 C S 2A
#> 119 32 hon-4 holocene 49 C S 2AC
#> 120 49 hon-4 holocene 86 G S 2C
#> 121 86 hon-4 holocene 113 G S 3C1
#> 122 113 hon-4 holocene 147 <NA> <NA> 3C2
#> 123 0 hon-5 upper modesto 13 A W Ap1
#> 124 13 hon-5 upper modesto 23 C W Ap2
#> 125 23 hon-5 upper modesto 54 C S BA
#> 126 54 hon-5 upper modesto 88 C S Bw1
#> 127 88 hon-5 upper modesto 102 C S Bw2
#> 128 102 hon-5 upper modesto 141 G S BC1
#> 129 141 hon-5 upper modesto 180 <NA> <NA> BC2
#> 130 0 hon-6 upper modesto 10 A W Ap1
#> 131 10 hon-6 upper modesto 22 C W Ap2
#> 132 22 hon-6 upper modesto 43 C S BA
#> 133 43 hon-6 upper modesto 91 C S Bw1
#> 134 91 hon-6 upper modesto 118 C S Bw2
#> 135 118 hon-6 upper modesto 157 G S BC1
#> 136 157 hon-6 upper modesto 184 <NA> <NA> BC2
#> 137 0 hon-7 upper modesto 8 C S Ap1
#> 138 8 hon-7 upper modesto 30 C S Ap2
#> 139 30 hon-7 upper modesto 54 G S BA
#> 140 54 hon-7 upper modesto 88 G S Bw1
#> 141 88 hon-7 upper modesto 118 G S Bw2
#> 142 118 hon-7 upper modesto 180 C S BC
#> 143 180 hon-7 upper modesto 230 <NA> <NA> 2BC
#> 144 230 hon-7 upper modesto 290 <NA> <NA> 3Cox
#> 145 290 hon-7 upper modesto 340 <NA> <NA> 4Cox
#> 146 340 hon-7 upper modesto 370 <NA> <NA> 4Cn
#> 147 0 hon-8 upper modesto 7 A S Ap-1
#> 148 7 hon-8 upper modesto 34 C S Ap-2
#> 149 34 hon-8 upper modesto 57 C S BA
#> 150 57 hon-8 upper modesto 90 C W Bw-1
#> 151 90 hon-8 upper modesto 126 G S Bw-2
#> 152 126 hon-8 upper modesto 191 G S BC1
#> 153 191 hon-8 upper modesto 240 <NA> <NA> BC2
#> 154 240 hon-8 upper modesto 390 <NA> <NA> 2Cox
#> texture prop structure_grade structure_size structure_type stickiness
#> 1 L 16 1 F GR SS
#> 2 sil 17 1 F GR SS
#> 3 L 16 1 F GR SS
#> 4 L 16 0 <NA> MA SS
#> 5 L 13 NA <NA> MA SS
#> 6 sl 11 NA <NA> MA SO
#> 7 sl 12 NA <NA> MA SO
#> 8 <NA> 11 NA <NA> <NA> <NA>
#> 9 <NA> 13 NA <NA> <NA> <NA>
#> 10 sgsl 11 1 CO SBK SS
#> 11 sgsl 12 NA <NA> MA SO
#> 12 sgsl 12 2 <NA> MA SS
#> 13 sgsl 14 2 <NA> MA SS
#> 14 sgsl 11 2 <NA> MA SS
#> 15 sgsl 8 NA <NA> MA SO
#> 16 fsl 8 NA <NA> MA SO
#> 17 sgsl 14 1 M SBK SS
#> 18 sgsl 12 NA <NA> MA SS
#> 19 sgsl 13 2 <NA> MA SS
#> 20 sgsl 15 2 <NA> MA MS
#> 21 sgsl 11 2 <NA> MA SS
#> 22 sgsl 10 NA <NA> MA SO
#> 23 sil 8 NA <NA> MA SS
#> 24 sil 17 NA <NA> CDY SS
#> 25 sil-l 20 NA <NA> MA SS
#> 26 sil-l 23 2 <NA> MA SS
#> 27 l+ 26 2 M PR MS
#> 28 c- 43 3 M PR VS
#> 29 SIC 51 3 <NA> MA VS
#> 30 SIC- 42 3 M ABK MS
#> 31 sicl 34 3 M ABK SS
#> 32 <NA> 26 NA <NA> <NA> <NA>
#> 33 cl 24 NA <NA> MA SS
#> 34 scl- 21 NA <NA> MA SS
#> 35 sl 17 NA <NA> MA SO
#> 36 sil 16 NA <NA> MA SS
#> 37 sil 22 NA <NA> MA SS
#> 38 sil 23 2 M SBK SS
#> 39 cl 30 2 F PR MS
#> 40 SIC 45 3 M PR VS
#> 41 cl 37 3 M ABK MS
#> 42 cl 34 3 M ABK MS
#> 43 cl-sicl 30 2 <NA> MA SS
#> 44 cl- 27 NA <NA> MA SS
#> 45 scl- 23 NA <NA> MA SO
#> 46 l 18 NA <NA> CDY SS
#> 47 l 18 NA <NA> MA SS
#> 48 cl- 27 2 M MA MS
#> 49 cl 30 2 <NA> MA MS
#> 50 cl 33 2 F PR MS
#> 51 scl 25 NA <NA> MA MS
#> 52 cl- 27 NA <NA> MA MS
#> 53 vgscl 21 NA <NA> MA MS
#> 54 l 17 2 M SBK SS
#> 55 l 17 NA <NA> MA <NA>
#> 56 L 26 2 VF <NA> MS
#> 57 cl 29 2 <NA> MA MS
#> 58 sicl 34 3 M PR VS
#> 59 CL 28 NA <NA> MA MS
#> 60 CL 29 NA <NA> MA MS
#> 61 GRVSCL 21 NA <NA> MA SS
#> 62 l 16 NA <NA> CDY SO
#> 63 l 19 NA <NA> MA SO
#> 64 l+ 24 2 M SBK SS
#> 65 l+ 24 2 <NA> MA MS
#> 66 cl 33 3 M PR MS
#> 67 cl 34 3 F MA MS
#> 68 scl- 27 2 M ABK SS
#> 69 sgsl 20 NA <NA> MA SS
#> 70 sgsl 15 NA <NA> MA SS
#> 71 l 14 NA <NA> MA SO
#> 72 <NA> 11 NA <NA> <NA> <NA>
#> 73 <NA> 13 NA <NA> <NA> <NA>
#> 74 sil 20 2 F GR SS
#> 75 sil-1 20 NA <NA> MA SS
#> 76 L 13 NA <NA> MA SO
#> 77 L-sl 13 NA <NA> MA SS
#> 78 L 16 NA <NA> MA SS
#> 79 <NA> 16 NA <NA> <NA> <NA>
#> 80 l 17 NA <NA> CDY SO
#> 81 l 18 NA <NA> MA SO
#> 82 l+ 24 2 VF MA SS
#> 83 l+ 25 2 <NA> MA SS
#> 84 cl 33 3 M PR MS
#> 85 sgscl- 22 2 CO ABK SS
#> 86 sgsl+ 18 NA <NA> SGR SS
#> 87 sl 11 NA <NA> MA SO
#> 88 sl+ 18 2 CO SBK SO
#> 89 scl 25 2 CO SBK SO
#> 90 sgscl-cl 30 2 <NA> MA SS
#> 91 sgc 51 3 <NA> MA MS
#> 92 sgc 55 1 F PR MS
#> 93 sgc 51 1 M PR MS
#> 94 sgc 48 1 M PR MS
#> 95 grc 45 3 <NA> MA SS
#> 96 grcl 35 2 <NA> MA SS
#> 97 grcl 33 2 <NA> MA SS
#> 98 extg l+ 26 2 F <NA> SO
#> 99 sl 12 NA <NA> MA SO
#> 100 scl- 22 2 CO SBK SS
#> 101 sgscl 29 1 M SBK SS
#> 102 sgc 44 2 M SBK MS
#> 103 sgc 55 3 <NA> MA MS
#> 104 sgc 51 3 M <NA> MS
#> 105 sgc 51 3 <NA> MA MS
#> 106 grc 47 3 <NA> MA MS
#> 107 grcl++ 39 3 F ABK SS
#> 108 vgscl 30 2 <NA> MA SS
#> 109 extgcl 23 1 F <NA> SS
#> 110 extg+ 34 1 F <NA> SS
#> 111 sl 18 NA <NA> MA SO
#> 112 sil 24 2 F GR SS
#> 113 sil 22 1 F GR SS
#> 114 sil 21 1 M <NA> SS
#> 115 L 13 NA <NA> MA SO
#> 116 L 14 NA <NA> MA SS
#> 117 sl 9 NA <NA> SGR SO
#> 118 L 16 2 F GR SS
#> 119 sil 17 NA <NA> MA SS
#> 120 L 15 NA <NA> MA SS
#> 121 sl 11 NA <NA> MA SO
#> 122 sl 10 NA <NA> MA SO
#> 123 sil 23 NA <NA> MA SS
#> 124 sil 23 2 F GR SS
#> 125 sil+ 25 NA <NA> MA SS
#> 126 sil 24 2 M <NA> SS
#> 127 sil 23 2 M ABK SS
#> 128 sil-1 22 2 M ABK SS
#> 129 sil-1 22 1 M ABK SS
#> 130 sil 23 NA M CDY SS
#> 131 sil 24 NA <NA> MA SS
#> 132 sil 24 NA <NA> MA SS
#> 133 L 22 2 M ABK SS
#> 134 L 22 2 M ABK SS
#> 135 L 23 2 M ABK SS
#> 136 L 22 1 M ABK SS
#> 137 L 19 NA <NA> CDY SS
#> 138 L 20 NA <NA> MA SS
#> 139 sil-1 21 NA <NA> MA SS
#> 140 L 23 2 <NA> MA SS
#> 141 L 21 2 <NA> MA SS
#> 142 <NA> 22 2 <NA> MA SS
#> 143 sicl- 28 1 F <NA> SS
#> 144 <NA> 17 NA <NA> <NA> <NA>
#> 145 <NA> 8 NA <NA> <NA> <NA>
#> 146 <NA> 6 NA <NA> <NA> <NA>
#> 147 L 19 NA <NA> CDY SO
#> 148 L 20 NA <NA> MA SO
#> 149 L 23 1 M SBK SS
#> 150 L 21 2 <NA> MA SS
#> 151 L 21 1 <NA> SGR SS
#> 152 L 23 2 <NA> MA SS
#> 153 L-sil 19 1 <NA> SGR SS
#> 154 <NA> 5 NA <NA> <NA> <NA>
#> plasticity field_ph hue value chroma r g b
#> 1 PO 6.5 10YR 3.0 3.0 0.3522797 0.2688590 0.17574632
#> 2 PO 6.6 10YR 3.0 2.5 NA NA NA
#> 3 SP 6.5 10YR 3.0 3.0 0.3522797 0.2688590 0.17574632
#> 4 SP 6.6 7.5YR 4.0 3.0 0.4706220 0.3590875 0.27082863
#> 5 PO 6.8 7.5YR 4.0 3.0 0.4706220 0.3590875 0.27082863
#> 6 PO 6.7 7.5YR 4.0 4.0 0.4923909 0.3523340 0.23133285
#> 7 PO 7.0 7.5YR 4.0 4.0 0.4923909 0.3523340 0.23133285
#> 8 <NA> NA <NA> NA NA NA NA NA
#> 9 <NA> NA <NA> NA NA NA NA NA
#> 10 PO 6.8 7.5YR 3.0 2.0 0.3433252 0.2694211 0.21692139
#> 11 PO 6.8 7.5YR 3.0 3.0 0.3644985 0.2628982 0.18559713
#> 12 SP 6.8 7.5YR 4.0 3.0 0.4706220 0.3590875 0.27082863
#> 13 SP 7.2 5-7.5YR 3.0 4.0 NA NA NA
#> 14 PO 7.2 7.5YR 4.0 3.0 0.4706220 0.3590875 0.27082863
#> 15 PO 7.2 7.5YR 4.0 3.0 0.4706220 0.3590875 0.27082863
#> 16 PO 7.2 2.5Y 4.0 3.0 0.4428399 0.3717701 0.24837880
#> 17 PO 6.6 7.5YR 3.0 2.0 0.3433252 0.2694211 0.21692139
#> 18 SP 7.0 7.5YR 3.0 3.0 0.3644985 0.2628982 0.18559713
#> 19 SP 7.0 7.5YR 4.0 3.0 0.4706220 0.3590875 0.27082863
#> 20 MP 7.1 7.5YR 3.0 4.0 0.3827022 0.2567391 0.15069361
#> 21 PO 7.2 7.5YR 4.0 4.0 0.4923909 0.3523340 0.23133285
#> 22 PO 7.3 7.5YR 4.0 4.0 0.4923909 0.3523340 0.23133285
#> 23 PO 7.3 2.5Y 5.0 4.0 0.5620372 0.4702857 0.29727835
#> 24 PO 5.5 7.5YR 6.0 6.0 0.7440717 0.5444687 0.34754585
#> 25 SP 6.3 5YR 4.0 4.0 0.5026314 0.3462401 0.24995558
#> 26 SP 6.5 5YR 4.0 4.0 0.5026314 0.3462401 0.24995558
#> 27 MP 6.8 5YR 4.0 5.0 0.5227043 0.3383386 0.21952529
#> 28 VP 6.8 5YR 4.0 6.0 0.5409717 0.3305930 0.18529327
#> 29 VP 6.6 5YR 4.0 6.0 0.5409717 0.3305930 0.18529327
#> 30 VP 7.1 5YR 4.0 5.0 0.5227043 0.3383386 0.21952529
#> 31 MP 7.1 7.5YR 4.0 6.0 0.5252055 0.3404370 0.15784923
#> 32 <NA> NA <NA> NA NA NA NA NA
#> 33 SP 7.1 5YR 4.0 6.0 0.5409717 0.3305930 0.18529327
#> 34 SP 6.9 5YR 4.0 6.0 0.5409717 0.3305930 0.18529327
#> 35 SP 6.7 5YR 4.0 5.0 0.5227043 0.3383386 0.21952529
#> 36 PO 5.6 7.5YR 4.0 4.0 0.4923909 0.3523340 0.23133285
#> 37 SP 6.1 7.5YR 4.0 4.0 0.4923909 0.3523340 0.23133285
#> 38 MP 6.5 5YR 4.0 5.0 0.5227043 0.3383386 0.21952529
#> 39 MP 6.7 5YR 4.0 5.0 0.5227043 0.3383386 0.21952529
#> 40 VP 6.7 5YR 4.0 6.0 0.5409717 0.3305930 0.18529327
#> 41 VP 7.0 5YR 4.0 6.0 0.5409717 0.3305930 0.18529327
#> 42 MP 7.1 7.5YR 5.0 6.0 0.6373120 0.4408493 0.24846998
#> 43 SP 6.9 7.5YR 5.0 6.0 0.6373120 0.4408493 0.24846998
#> 44 SP 6.8 5YR 4.0 6.0 0.5409717 0.3305930 0.18529327
#> 45 SP 6.8 5YR 4.0 6.0 0.5409717 0.3305930 0.18529327
#> 46 SP 5.7 5YR 3.0 4.0 0.3940324 0.2499977 0.16682669
#> 47 SP 5.7 5YR 3.0 4.0 0.3940324 0.2499977 0.16682669
#> 48 SP 6.1 2.5YR 3.0 4.0 0.4047002 0.2430202 0.18367986
#> 49 SP 6.4 2.5YR 3.0 5.0 0.4268174 0.2319252 0.15787833
#> 50 MP 6.6 2.5YR 3.0 5.0 0.4268174 0.2319252 0.15787833
#> 51 MP 6.8 2.5YR 5.0 6.0 0.6642703 0.4232155 0.31003272
#> 52 SP 6.9 5YR 4.0 5.0 0.5227043 0.3383386 0.21952529
#> 53 SP 6.8 5YR 5.0 6.0 0.6516906 0.4320947 0.27623886
#> 54 SP 5.5 5YR 3.0 4.0 0.3940324 0.2499977 0.16682669
#> 55 <NA> 5.5 5YR 3.0 4.0 0.3940324 0.2499977 0.16682669
#> 56 SP 6.1 2.5YR 3.0 5.0 0.4268174 0.2319252 0.15787833
#> 57 SP 6.6 2.5YR 3.0 5.0 0.4268174 0.2319252 0.15787833
#> 58 MP 6.8 2.5YR 3.0 6.0 0.4468915 0.2206162 0.12794174
#> 59 MP 6.9 2.5YR 3.0 6.0 0.4468915 0.2206162 0.12794174
#> 60 MP 6.8 5YR 4.0 6.0 0.5409717 0.3305930 0.18529327
#> 61 PO 6.8 2.5YR 4.0 6.0 0.5550868 0.3205433 0.21624665
#> 62 PO 6.3 5YR 3.0 4.0 0.3940324 0.2499977 0.16682669
#> 63 SP 6.0 5YR 3.0 4.0 0.3940324 0.2499977 0.16682669
#> 64 SP 6.1 2.5YR 3.0 5.0 0.4268174 0.2319252 0.15787833
#> 65 MP 6.2 2.5YR 3.0 5.0 0.4268174 0.2319252 0.15787833
#> 66 MP 6.6 2.5YR 3.0 6.0 0.4468915 0.2206162 0.12794174
#> 67 MP 7.0 2.5YR 3.0 6.0 0.4468915 0.2206162 0.12794174
#> 68 SP 6.9 5YR 4.0 6.0 0.5409717 0.3305930 0.18529327
#> 69 SP 7.2 5YR 4.0 6.0 0.5409717 0.3305930 0.18529327
#> 70 SP 7.1 5YR 4.0 6.0 0.5409717 0.3305930 0.18529327
#> 71 PO 6.9 5YR 4.0 6.0 0.5409717 0.3305930 0.18529327
#> 72 <NA> NA <NA> NA NA NA NA NA
#> 73 <NA> NA <NA> NA NA NA NA NA
#> 74 SP 5.6 10YR 3.0 2.5 NA NA NA
#> 75 SP 6.2 10YR 3.0 2.5 NA NA NA
#> 76 PO 6.8 10YR 3.0 3.0 0.3522797 0.2688590 0.17574632
#> 77 PO 7.1 10YR 4.0 4.0 0.4765699 0.3603870 0.21438027
#> 78 SP 7.2 10YR 3.0 3.0 0.3522797 0.2688590 0.17574632
#> 79 <NA> NA <NA> NA NA NA NA NA
#> 80 PO 6.2 5YR 3.0 4.0 0.3940324 0.2499977 0.16682669
#> 81 SP 6.2 5YR 3.0 4.0 0.3940324 0.2499977 0.16682669
#> 82 SP 6.3 5YR 3.0 5.0 0.4134797 0.2413405 0.13580495
#> 83 MP 6.8 2.5YR 3.0 5.0 0.4268174 0.2319252 0.15787833
#> 84 MP 7.1 2.5YR 3.0 6.0 0.4468915 0.2206162 0.12794174
#> 85 MP 6.8 5YR 5.0 6.0 0.6516906 0.4320947 0.27623886
#> 86 SP 6.9 5YR 4.0 6.0 0.5409717 0.3305930 0.18529327
#> 87 PO NA 7.5YR 5.0 6.0 0.6373120 0.4408493 0.24846998
#> 88 PO 6.2 2.5YR 3.0 4.0 0.4047002 0.2430202 0.18367986
#> 89 SP 6.2 2.5YR 3.0 4.0 0.4047002 0.2430202 0.18367986
#> 90 SP 6.2 2.5YR 3.0 4.0 0.4047002 0.2430202 0.18367986
#> 91 MP 5.7 10YR 3.0 5.0 0.3814261 0.2600469 0.09577498
#> 92 MP 5.3 10YR 3.0 5.0 0.3814261 0.2600469 0.09577498
#> 93 MP 5.0 10YR 3.0 6.0 0.3934784 0.2558781 0.03398692
#> 94 MP 4.9 10YR 3.0 6.0 0.3934784 0.2558781 0.03398692
#> 95 MP 5.0 10YR 3.0 6.0 0.3934784 0.2558781 0.03398692
#> 96 MP 5.3 2.5YR 3.0 6.0 0.4468915 0.2206162 0.12794174
#> 97 PO 5.7 2.5YR 3.0 6.0 0.4468915 0.2206162 0.12794174
#> 98 PO 6.1 5YR 3.0 4.0 0.3940324 0.2499977 0.16682669
#> 99 PO 6.2 7.5YR 4.0 3.0 0.4706220 0.3590875 0.27082863
#> 100 SP 6.4 2.5YR 3.0 4.0 0.4047002 0.2430202 0.18367986
#> 101 SP 6.7 2.5YR 3.0 5.0 0.4268174 0.2319252 0.15787833
#> 102 MP 6.7 2.5YR 3.0 5.0 0.4268174 0.2319252 0.15787833
#> 103 MP 6.9 10YR 3.0 6.0 0.3934784 0.2558781 0.03398692
#> 104 MP 5.9 10YR 3.0 6.0 0.3934784 0.2558781 0.03398692
#> 105 MP 5.4 10YR 3.0 6.0 0.3934784 0.2558781 0.03398692
#> 106 MP 5.4 10YR 3.0 6.0 0.3934784 0.2558781 0.03398692
#> 107 MP 5.4 10YR 3.0 6.0 0.3934784 0.2558781 0.03398692
#> 108 SP 5.5 2.5YR 3.0 4.0 0.4047002 0.2430202 0.18367986
#> 109 PO 6.1 5YR 3.0 4.0 0.3940324 0.2499977 0.16682669
#> 110 PO 6.0 5YR 4.0 4.0 0.5026314 0.3462401 0.24995558
#> 111 PO 6.9 5YR 4.0 4.0 0.5026314 0.3462401 0.24995558
#> 112 SP 5.9 10YR 3.0 3.0 0.3522797 0.2688590 0.17574632
#> 113 SP 5.8 10YR 3.0 3.0 0.3522797 0.2688590 0.17574632
#> 114 SP 6.1 10YR 3.0 3.0 0.3522797 0.2688590 0.17574632
#> 115 PO 7.1 10YR 4.0 3.0 0.4578366 0.3653270 0.25754623
#> 116 SP 7.0 10YR 4.0 3.0 0.4578366 0.3653270 0.25754623
#> 117 PO 6.5 10YR 4.0 3.0 0.4578366 0.3653270 0.25754623
#> 118 SP 6.9 10YR 3.0 3.0 0.3522797 0.2688590 0.17574632
#> 119 SP 6.6 10YR 3.0 3.0 0.3522797 0.2688590 0.17574632
#> 120 SP 6.7 10YR 3.5 3.0 NA NA NA
#> 121 PO 6.8 10YR 4.0 3.0 0.4578366 0.3653270 0.25754623
#> 122 PO 6.7 10YR 4.0 3.0 0.4578366 0.3653270 0.25754623
#> 123 SP 6.2 7.5YR 3.0 2.0 0.3433252 0.2694211 0.21692139
#> 124 SP 6.3 7.5YR 3.0 3.0 0.3644985 0.2628982 0.18559713
#> 125 SP 6.7 7.5YR 3.0 3.0 0.3644985 0.2628982 0.18559713
#> 126 SP 7.0 7.5YR 3.0 3.0 0.3644985 0.2628982 0.18559713
#> 127 SP 7.1 7.5YR 3.0 4.0 0.3827022 0.2567391 0.15069361
#> 128 SP 7.2 7.5YR 4.0 4.0 0.4923909 0.3523340 0.23133285
#> 129 SP 7.3 7.5YR 4.0 4.0 0.4923909 0.3523340 0.23133285
#> 130 SP 6.2 7.5YR 3.0 2.0 0.3433252 0.2694211 0.21692139
#> 131 SP 6.4 7.5YR 3.0 2.0 0.3433252 0.2694211 0.21692139
#> 132 SP 6.6 7.5YR 3.0 2.0 0.3433252 0.2694211 0.21692139
#> 133 SP 7.0 7.5YR 3.0 3.0 0.3644985 0.2628982 0.18559713
#> 134 PO 7.0 7.5YR 3.0 3.0 0.3644985 0.2628982 0.18559713
#> 135 SP 7.2 7.5YR 4.0 4.0 0.4923909 0.3523340 0.23133285
#> 136 PO 7.4 7.5YR 4.0 4.0 0.4923909 0.3523340 0.23133285
#> 137 SP 5.6 7.5YR 3.0 3.0 0.3644985 0.2628982 0.18559713
#> 138 SP 5.7 7.5YR 3.0 3.0 0.3644985 0.2628982 0.18559713
#> 139 SP 6.6 7.5YR 3.0 2.5 NA NA NA
#> 140 SP 7.0 7.5YR 4.0 6.0 0.5252055 0.3404370 0.15784923
#> 141 SP 7.2 7.5YR 3.0 4.0 0.3827022 0.2567391 0.15069361
#> 142 SP 7.3 7.5YR 4.0 4.0 0.4923909 0.3523340 0.23133285
#> 143 SP 7.2 10YR 4.0 3.0 0.4578366 0.3653270 0.25754623
#> 144 <NA> NA <NA> NA NA NA NA NA
#> 145 <NA> NA <NA> NA NA NA NA NA
#> 146 <NA> NA <NA> NA NA NA NA NA
#> 147 SP 5.6 7.5YR 3.0 3.0 0.3644985 0.2628982 0.18559713
#> 148 MP 5.8 7.5YR 3.0 3.0 0.3644985 0.2628982 0.18559713
#> 149 SP 6.3 7.5YR 3.0 3.0 0.3644985 0.2628982 0.18559713
#> 150 SP 6.8 7.5YR 3.0 4.0 0.3827022 0.2567391 0.15069361
#> 151 SP 7.1 7.5YR 3.0 4.0 0.3827022 0.2567391 0.15069361
#> 152 SP 7.3 7.5YR 4.0 4.0 0.4923909 0.3523340 0.23133285
#> 153 SP 7.3 7.5YR 4.0 3.0 0.4706220 0.3590875 0.27082863
#> 154 <NA> NA <NA> NA NA NA NA NA
#> soil_color hzID newvalue
#> 1 #5A452DFF 1 TRUE
#> 2 <NA> 2 NA
#> 3 #5A452DFF 3 NA
#> 4 #785C45FF 4 NA
#> 5 #785C45FF 5 NA
#> 6 #7E5A3BFF 6 NA
#> 7 #7E5A3BFF 7 NA
#> 8 <NA> 8 NA
#> 9 <NA> 9 NA
#> 10 #584537FF 10 TRUE
#> 11 #5D432FFF 11 NA
#> 12 #785C45FF 12 NA
#> 13 <NA> 13 NA
#> 14 #785C45FF 14 NA
#> 15 #785C45FF 15 NA
#> 16 #715F3FFF 16 NA
#> 17 #584537FF 17 TRUE
#> 18 #5D432FFF 18 NA
#> 19 #785C45FF 19 NA
#> 20 #624126FF 20 NA
#> 21 #7E5A3BFF 21 NA
#> 22 #7E5A3BFF 22 NA
#> 23 #8F784CFF 23 NA
#> 24 #BE8B59FF 24 TRUE
#> 25 #805840FF 25 NA
#> 26 #805840FF 26 NA
#> 27 #855638FF 27 NA
#> 28 #8A542FFF 28 NA
#> 29 #8A542FFF 29 NA
#> 30 #855638FF 30 NA
#> 31 #865728FF 31 NA
#> 32 <NA> 32 NA
#> 33 #8A542FFF 33 NA
#> 34 #8A542FFF 34 NA
#> 35 #855638FF 35 NA
#> 36 #7E5A3BFF 36 TRUE
#> 37 #7E5A3BFF 37 NA
#> 38 #855638FF 38 NA
#> 39 #855638FF 39 NA
#> 40 #8A542FFF 40 NA
#> 41 #8A542FFF 41 NA
#> 42 #A3703FFF 42 NA
#> 43 #A3703FFF 43 NA
#> 44 #8A542FFF 44 NA
#> 45 #8A542FFF 45 NA
#> 46 #64402BFF 46 TRUE
#> 47 #64402BFF 47 NA
#> 48 #673E2FFF 48 NA
#> 49 #6D3B28FF 49 NA
#> 50 #6D3B28FF 50 NA
#> 51 #A96C4FFF 51 NA
#> 52 #855638FF 52 NA
#> 53 #A66E46FF 53 NA
#> 54 #64402BFF 54 TRUE
#> 55 #64402BFF 55 NA
#> 56 #6D3B28FF 56 NA
#> 57 #6D3B28FF 57 NA
#> 58 #723821FF 58 NA
#> 59 #723821FF 59 NA
#> 60 #8A542FFF 60 NA
#> 61 #8E5237FF 61 NA
#> 62 #64402BFF 62 TRUE
#> 63 #64402BFF 63 NA
#> 64 #6D3B28FF 64 NA
#> 65 #6D3B28FF 65 NA
#> 66 #723821FF 66 NA
#> 67 #723821FF 67 NA
#> 68 #8A542FFF 68 NA
#> 69 #8A542FFF 69 NA
#> 70 #8A542FFF 70 NA
#> 71 #8A542FFF 71 NA
#> 72 <NA> 72 NA
#> 73 <NA> 73 NA
#> 74 <NA> 74 TRUE
#> 75 <NA> 75 NA
#> 76 #5A452DFF 76 NA
#> 77 #7A5C37FF 77 NA
#> 78 #5A452DFF 78 NA
#> 79 <NA> 79 NA
#> 80 #64402BFF 80 TRUE
#> 81 #64402BFF 81 NA
#> 82 #693E23FF 82 NA
#> 83 #6D3B28FF 83 NA
#> 84 #723821FF 84 NA
#> 85 #A66E46FF 85 NA
#> 86 #8A542FFF 86 NA
#> 87 #A3703FFF 87 NA
#> 88 #673E2FFF 88 TRUE
#> 89 #673E2FFF 89 NA
#> 90 #673E2FFF 90 NA
#> 91 #614218FF 91 NA
#> 92 #614218FF 92 NA
#> 93 #644109FF 93 NA
#> 94 #644109FF 94 NA
#> 95 #644109FF 95 NA
#> 96 #723821FF 96 NA
#> 97 #723821FF 97 NA
#> 98 #64402BFF 98 NA
#> 99 #785C45FF 99 NA
#> 100 #673E2FFF 100 TRUE
#> 101 #6D3B28FF 101 NA
#> 102 #6D3B28FF 102 NA
#> 103 #644109FF 103 NA
#> 104 #644109FF 104 NA
#> 105 #644109FF 105 NA
#> 106 #644109FF 106 NA
#> 107 #644109FF 107 NA
#> 108 #673E2FFF 108 NA
#> 109 #64402BFF 109 NA
#> 110 #805840FF 110 NA
#> 111 #805840FF 111 NA
#> 112 #5A452DFF 112 TRUE
#> 113 #5A452DFF 113 NA
#> 114 #5A452DFF 114 NA
#> 115 #755D42FF 115 NA
#> 116 #755D42FF 116 NA
#> 117 #755D42FF 117 TRUE
#> 118 #5A452DFF 118 NA
#> 119 #5A452DFF 119 NA
#> 120 <NA> 120 NA
#> 121 #755D42FF 121 NA
#> 122 #755D42FF 122 NA
#> 123 #584537FF 123 TRUE
#> 124 #5D432FFF 124 NA
#> 125 #5D432FFF 125 NA
#> 126 #5D432FFF 126 NA
#> 127 #624126FF 127 NA
#> 128 #7E5A3BFF 128 NA
#> 129 #7E5A3BFF 129 NA
#> 130 #584537FF 130 TRUE
#> 131 #584537FF 131 NA
#> 132 #584537FF 132 NA
#> 133 #5D432FFF 133 NA
#> 134 #5D432FFF 134 NA
#> 135 #7E5A3BFF 135 NA
#> 136 #7E5A3BFF 136 NA
#> 137 #5D432FFF 137 TRUE
#> 138 #5D432FFF 138 NA
#> 139 <NA> 139 NA
#> 140 #865728FF 140 NA
#> 141 #624126FF 141 NA
#> 142 #7E5A3BFF 142 NA
#> 143 #755D42FF 143 NA
#> 144 <NA> 144 NA
#> 145 <NA> 145 NA
#> 146 <NA> 146 NA
#> 147 #5D432FFF 147 TRUE
#> 148 #5D432FFF 148 NA
#> 149 #5D432FFF 149 NA
#> 150 #624126FF 150 NA
#> 151 #624126FF 151 NA
#> 152 #7E5A3BFF 152 NA
#> 153 #785C45FF 153 NA
#> 154 <NA> 154 NA