Get map unit properties from Soil Data Access

get_SDA_property(
  property,
  method = c("Dominant Component (Category)", "Weighted Average", "Min/Max",
    "Dominant Component (Numeric)", "Dominant Condition", "None"),
  areasymbols = NULL,
  mukeys = NULL,
  top_depth = 0,
  bottom_depth = 200,
  FUN = NULL,
  include_minors = FALSE,
  miscellaneous_areas = FALSE,
  query_string = FALSE
)

Arguments

property

character vector of labels from property dictionary tables (see details) OR physical column names from component or chorizon table.

method

one of: "Dominant Component (Category)", "Dominant Component (Numeric)", "Weighted Average", "MIN", "MAX", "Dominant Condition", or "None". If "None" is selected, the number of rows returned will depend on whether a component or horizon level property was selected, otherwise the result will be 1:1 with the number of map units.

areasymbols

vector of soil survey area symbols

mukeys

vector of map unit keys

top_depth

Default: 0 (centimeters); a numeric value for upper boundary (top depth) used only for method="Weighted Average", "Dominant Component (Numeric)", and "MIN/MAX"

bottom_depth

Default: 200 (centimeters); a numeric value for lower boundary (bottom depth) used only for method="Weighted Average", "Dominant Component (Numeric)", and "MIN/MAX"

FUN

Optional: character representing SQL aggregation function either "MIN" or "MAX" used only for method="min/max"; this argument is calculated internally if you specify method="MIN" or method="MAX"

include_minors

Include minor components in "Weighted Average" or "MIN/MAX" results?

miscellaneous_areas

Include miscellaneous areas (non-soil components) in "Weighted Average", "MIN" or "MAX" results?

query_string

Default: FALSE; if TRUE return a character string containing query that would be sent to SDA via SDA_query

Value

a data.frame with result

Details

The property argument refers to one of the property names or columns specified in the tables below. Note that property can be specified as either a character vector of labeled properties, such as "Bulk Density 0.33 bar H2O - Rep Value", OR physical column names such as "dbthirdbar_r". To get "low" and "high" values for a particular property, replace the _r with _l or _h in the physical column name; for example property = c("dbthirdbar_l","dbthirdbar_r","dbthirdbar_h"). You can view exhaustive lists of component and component horizon level properties in the Soil Data Access "Tables and Columns Report".

Selected Component-level Properties

Property (Component)Column
Range Production - Favorable Yearrsprod_h
Range Production - Normal Yearrsprod_r
Range Production - Unfavorable Yearrsprod_l
Corrosion of Steelcorsteel
Corrosion of Concretecorcon
Drainage Classdrainagecl
Hydrologic Grouphydgrp
Taxonomic Class Nametaxclname
Taxonomic Ordertaxorder
Taxonomic Subordertaxsuborder
Taxonomic Temperature Regimetaxtempregime
Wind Erodibility Groupweg
Wind Erodibility Indexwei
t Factortfact

Selected Horizon-level Properties

Property (Horizon)Column
0.1 bar H2O - Rep Valuewtenthbar_r
0.33 bar H2O - Rep Valuewthirdbar_r
15 bar H2O - Rep Valuewfifteenbar_r
Available Water Capacity - Rep Valueawc_r
Bray 1 Phosphate - Rep Valuepbray1_r
Bulk Density 0.1 bar H2O - Rep Valuedbtenthbar_r
Bulk Density 0.33 bar H2O - Rep Valuedbthirdbar_r
Bulk Density 15 bar H2O - Rep Valuedbfifteenbar_r
Bulk Density oven dry - Rep Valuedbovendry_r
CaCO3 Clay - Rep Valueclaysizedcarb_r
Calcium Carbonate - Rep Valuecaco3_r
Cation Exchange Capacity - Rep Valuecec7_r
Coarse Sand - Rep Valuesandco_r
Coarse Silt - Rep Valuesiltco_r
Effective Cation Exchange Capacity - Rep Valueecec_r
Electrial Conductivity 1:5 by volume - Rep Valueec15_r
Electrical Conductivity - Rep Valueec_r
Exchangeable Sodium Percentage - Rep Valueesp_r
Extract Aluminum - Rep Valueextral_r
Extractable Acidity - Rep Valueextracid_r
Fine Sand - Rep Valuesandfine_r
Fine Silt - Rep Valuesiltfine_r
Free Iron - Rep Valuefreeiron_r
Gypsum - Rep Valuegypsum_r
Kfkffact
Kikifact
Krkrfact
Kwkwfact
LEP - Rep Valuelep_r
Liquid Limit - Rep Valuell_r
Medium Sand - Rep Valuesandmed_r
Organic Matter - Rep Valueom_r
Oxalate Aluminum - Rep Valuealoxalate_r
Oxalate Iron - Rep Valuefeoxalate_r
Oxalate Phosphate - Rep Valuepoxalate_r
Plasticity Index - Rep Valuepi_r
Rock Fragments 3 - 10 inches - Rep Valuefrag3to10_r
Rock Fragments > 10 inches - Rep Valuefraggt10_r
Rubbed Fiber % - Rep Valuefiberrubbedpct_r
Satiated H2O - Rep Valuewsatiated_r
Saturated Hydraulic Conductivity - Rep Valueksat_r
Sodium Adsorption Ratio - Rep Valuesar_r
Sum of Bases - Rep Valuesumbases_r
Total Clay - Rep Valueclaytotal_r
Total Phosphate - Rep Valueptotal_r
Total Sand - Rep Valuesandtotal_r
Total Silt - Rep Valuesilttotal_r
Unrubbed Fiber % - Rep Valuefiberunrubbedpct_r
Very Coarse Sand - Rep Valuesandvc_r
Very Fine Sand - Rep Valuesandvf_r
Water Soluble Phosphate - Rep Valueph2osoluble_r
no. 10 sieve - Rep Valuesieveno10_r
no. 200 sieve - Rep Valuesieveno200_r
no. 4 sieve - Rep Valuesieveno4_r
no. 40 sieve - Rep Valuesieveno40_r
pH .01M CaCl2 - Rep Valueph01mcacl2_r
pH 1:1 water - Rep Valueph1to1h2o_r
pH Oxidized - Rep Valuephoxidized_r

Author

Jason Nemecek, Chad Ferguson, Andrew Brown

Examples


# \donttest{
if(requireNamespace("curl") &
    curl::has_internet()) {

 # get 1/3 bar bulk density [0,25] centimeter depth weighted average from dominant component
 get_SDA_property(property = c("dbthirdbar_l","dbthirdbar_r","dbthirdbar_h"),
                  method = "Dominant Component (Numeric)",
                  areasymbols = "CA630",
                  top_depth = 0,
                  bottom_depth = 25)
}
#>     areasymbol musym
#> 1        CA630  1012
#> 2        CA630  1013
#> 3        CA630  1090
#> 4        CA630  1091
#> 5        CA630   128
#> 6        CA630   206
#> 7        CA630   207
#> 8        CA630   208
#> 9        CA630   209
#> 10       CA630   212
#> 11       CA630   220
#> 12       CA630   301
#> 13       CA630  3020
#> 14       CA630  3021
#> 15       CA630  3033
#> 16       CA630  3038
#> 17       CA630  3046
#> 18       CA630  3058
#> 19       CA630   401
#> 20       CA630  4040
#> 21       CA630  4046
#> 22       CA630  4048
#> 23       CA630  4136
#> 24       CA630  4200
#> 25       CA630  4201
#> 26       CA630  4202
#> 27       CA630   451
#> 28       CA630   475
#> 29       CA630  5012
#> 30       CA630  5013
#> 31       CA630  5015
#> 32       CA630  5016
#> 33       CA630  5051
#> 34       CA630  5053
#> 35       CA630  5057
#> 36       CA630  5100
#> 37       CA630  5101
#> 38       CA630  5201
#> 39       CA630  5202
#> 40       CA630  6029
#> 41       CA630  6033
#> 42       CA630  6034
#> 43       CA630  6036
#> 44       CA630  6037
#> 45       CA630  6038
#> 46       CA630  6039
#> 47       CA630  6041
#> 48       CA630  6043
#> 49       CA630  6054
#> 50       CA630  6055
#> 51       CA630  6070
#> 52       CA630  6071
#> 53       CA630  6072
#> 54       CA630  6074
#> 55       CA630  6075
#> 56       CA630  6076
#> 57       CA630  6078
#> 58       CA630  6079
#> 59       CA630  6202
#> 60       CA630  6205
#> 61       CA630  6206
#> 62       CA630  6207
#> 63       CA630  7065
#> 64       CA630  7066
#> 65       CA630  7074
#> 66       CA630  7076
#> 67       CA630  7078
#> 68       CA630  7079
#> 69       CA630  7083
#> 70       CA630  7085
#> 71       CA630  7086
#> 72       CA630  7087
#> 73       CA630  7088
#> 74       CA630  7089
#> 75       CA630  7091
#> 76       CA630  7092
#> 77       CA630  7096
#> 78       CA630  7155
#> 79       CA630  7156
#> 80       CA630  7159
#> 81       CA630  7165
#> 82       CA630  7166
#> 83       CA630  7207
#> 84       CA630  7210
#> 85       CA630  7211
#> 86       CA630  7212
#> 87       CA630  8026
#> 88       CA630  8033
#> 89       CA630  8034
#> 90       CA630  8036
#> 91       CA630  8110
#> 92       CA630  8111
#> 93       CA630  8115
#> 94       CA630  8120
#> 95       CA630  8160
#> 96       CA630  8161
#> 97       CA630  8162
#> 98       CA630  8171
#> 99       CA630  8172
#> 100      CA630  8173
#> 101      CA630  8175
#> 102      CA630  8176
#> 103      CA630  8177
#> 104      CA630  8178
#> 105      CA630  8190
#> 106      CA630  8194
#> 107      CA630  8286
#> 108      CA630  8287
#> 109      CA630  8289
#> 110      CA630  8302
#> 111      CA630  8307
#> 112      CA630  8312
#> 113      CA630  8314
#> 114      CA630  8317
#> 115      CA630  8318
#> 116      CA630  8319
#> 117      CA630   851
#> 118      CA630  9010
#> 119      CA630  9011
#> 120      CA630  9012
#> 121      CA630  9013
#> 122      CA630  9014
#> 123      CA630  9015
#> 124      CA630  9016
#> 125      CA630  9017
#> 126      CA630  9018
#> 127      CA630   DAM
#> 128      CA630     W
#>                                                                                               muname
#> 1                                                                                         Mined Land
#> 2                                  Mined Land-Anthraltic Xerorthents complex, 1 to 15 percent slopes
#> 3                             Ultic Haploxeralfs-Mollic Haploxeralfs complex, 3 to 30 percent slopes
#> 4                              Ultic Haploxeralfs-Aquic Dystroxerepts complex, 2 to 8 percent slopes
#> 5                                                        Cogna loam, 0 to 2 percent slopes, overwash
#> 6                                                           Pentz sandy loam, 2 to 15 percent slopes
#> 7                                                          Pentz sandy loam, 15 to 50 percent slopes
#> 8                                                     Pentz cobbly sandy loam, 2 to 8 percent slopes
#> 9                                                      Pentz-Bellota complex, 2 to 15 percent slopes
#> 10                                                                Peters clay, 2 to 8 percent slopes
#> 11                                                 Redding gravelly loam, 0 to 8 percent slopes, dry
#> 12                                          Archerdale-Hicksville association, 0 to 2 percent slopes
#> 13                                        Iron Mountain-Rock outcrop complex, 3 to 15 percent slopes
#> 14                               Iron Mountain-Crozier-Rock outcrop complex, 15 to 60 percent slopes
#> 15                              Redapple-Lilygap complex, 15 to 30 percent slopes, low precipitation
#> 16                            Devilsnose-Lilygap complex, 30 to 60 percent slopes, low precipitation
#> 17                                       Goldwall-Toomes-Rock outcrop complex, 1 to 8 percent slopes
#> 18                                            Shawsflat-Angelscreek complex, 25 to 60 percent slopes
#> 19                                                   Peters-Pentz association, 2 to 8 percent slopes
#> 20                                 Iron Mountain-Redapple-Devilsnose complex, 3 to 15 percent slopes
#> 21                                                 Redapple-Lilygap complex, 15 to 30 percent slopes
#> 22                                               Devilsnose-Lilygap complex, 30 to 60 percent slopes
#> 23  Ultic Haploxeralfs, shallow-Ultic Haploxeralfs, moderately deep complex, 10 to 35 percent slopes
#> 24                                                  Inks-Angelscreek complex, 3 to 15 percent slopes
#> 25                                                Angelscreek-Pentz complex, 15 to 30 percent slopes
#> 26                                                Angelscreek-Pentz complex, 30 to 60 percent slopes
#> 27                                                  Pentz-Peters association, 2 to 15 percent slopes
#> 28                                                  Pentz-Peters association, 2 to 50 percent slopes
#> 29                                                         Amador sandy loam, 2 to 15 percent slopes
#> 30                                               Miltonhills-Amador complex, 15 to 45 percent slopes
#> 31                                                 Ospital-Jennylind complex, 2 to 15 percent slopes
#> 32                                           Jennylind-Rock outcrop complex, 10 to 45 percent slopes
#> 33                                         Fuches-Lithic Xerorthents complex, 3 to 15 percent slopes
#> 34                                        Fuches-Lithic Xerorthents complex, 15 to 50 percent slopes
#> 35                                                                Supan loam, 5 to 30 percent slopes
#> 36        Ultic Haploxeralfs-Typic Palexerults-Aquultic haploxeralfs complex, 1 to 12 percent slopes
#> 37                   Hornitos-Red Bluff-Ultic Haploxeralfs, shallow, complex, 3 to 25 percent slopes
#> 38                                                        Pardee cobbly loam, 2 to 15 percent slopes
#> 39                                                    Pardee-Amador complex, 15 to 40 percent slopes
#> 40                                  Holland-Chawanakee-Rock outcrop complex, 45 to 90 percent slopes
#> 41                                Musick-Wukusick complex, 3 to 15 percent slopes, low precipitation
#> 42                                                   Musick-Wukusick complex, 3 to 15 percent slopes
#> 43                               Musick-Wukusick complex, 15 to 30 percent slopes, low precipitation
#> 44                                                  Musick-Wukusick complex, 15 to 30 percent slopes
#> 45                               Musick-Wukusick complex, 30 to 60 percent slopes, low precipitation
#> 46                                         Holland-Wukusick-Mantree complex, 30 to 60 percent slopes
#> 47                                                   Mantree ashy sandy loam, 3 to 15 percent slopes
#> 48                                                  Mantree ashy sandy loam, 15 to 30 percent slopes
#> 49                                         Shaver-Holland-Chawanakee complex, 8 to 30 percent slopes
#> 50                                Shaver-Lithic Humixerepts-Holland complex, 30 to 60 percent slopes
#> 51                                 Sierra-Verjeles-Aquic Haploxeralfs complex, 0 to 8 percent slopes
#> 52                                                     Sierra-Flanly complex, 3 to 15 percent slopes
#> 53                                                    Flanly-Verjeles complex, 0 to 8 percent slopes
#> 54                                                      Sierra-Orose complex, 8 to 30 percent slopes
#> 55                                                    Sierra-Flanly complex, 30 to 60 percent slopes
#> 56                                    Auberry-Hurleton-Rock outcrop complex, 20 to 60 percent slopes
#> 57                                                    Sierra-Flanly complex, 15 to 65 percent slopes
#> 58                                                               Flanly loam, 8 to 30 percent slopes
#> 59                Musick-Ultic Haploxeralfs, moderately well drained, complex, 1 to 8 percent slopes
#> 60                                                     Musick fine sandy loam, 3 to 8 percent slopes
#> 61                                                      Musick-Hotaw complex, 8 to 30 percent slopes
#> 62                                          Musick-Hotaw-Chawanakee complex, 30 to 60 percent slopes
#> 63                            Bonanza-Loafercreek complex, 3 to 15 percent slopes, low precipitation
#> 64                                   Bonanza-Loafercreek-Jasperpeak complex, 15 to 30 percent slopes
#> 65                                               Loafercreek-Bonanza complex, 3 to 15 percent slopes
#> 66                                   Bonanza-Loafercreek-Gopheridge complex, 15 to 30 percent slopes
#> 67                                            Jasperpeak-Gopheridge complex, 30 to 60 percent slopes
#> 68                                           Gopheridge-Loafercreek complex, 30 to 60 percent slopes
#> 69                           Aquic Haploxeralfs-Loafercreek-Dunstone complex, 1 to 12 percent slopes
#> 70                                               Bonanza-Loafercreek complex, 3 to 15 percent slopes
#> 71                                           Loafercreek-Gopheridge complex, 15 to 30 percent slopes
#> 72                                     Loafercreek-Gopheridge complex, cool, 15 to 30 percent slopes
#> 73                                           Loafercreek-Gopheridge complex, 30 to 60 percent slopes
#> 74                                Gardellones-Gopheridge-Motherlode complex, 30 to 60 percent slopes
#> 75                                   Trabuco-Jasperpeak-Rock outcrop complex, 8 to 30 percent slopes
#> 76                               Gopheridge-Jasperpeak-Rock outcrop complex, 30 to 60 percent slopes
#> 77                                            Gopheridge-Jasperpeak complex, 50 to 90 percent slopes
#> 78                                                Crimeahouse-Sixbit complex, 3 to 15 percent slopes
#> 79                                               Crimeahouse-Sixbit complex, 15 to 30 percent slopes
#> 80                                               Crimeahouse-Sixbit complex, 30 to 70 percent slopes
#> 81                                                Sixbit-Crimeahouse complex, 5 to 20 percent slopes
#> 82                                              Sixbit-Rock outcrop complex, 20 to 45 percent slopes
#> 83                                    Millvilla-Copperopolis-Hetchy complex, 30 to 60 percent slopes
#> 84                                                Deerflat-Millvilla complex, 3 to 15 percent slopes
#> 85                                              Millvilla-Luckymine complex, 15 to 30 percent slopes
#> 86                                             Wardsferry-Millvilla complex, 30 to 60 percent slopes
#> 87                                        Moccasinhill-Copperopolis complex, 30 to 60 percent slopes
#> 88                                      Copperopolis-Whiterock complex, 2 to 8 percent slopes, rocky
#> 89                                     Copperopolis-Whiterock complex, 3 to 15 percent slopes, rocky
#> 90                                    Copperopolis-Whiterock complex, 15 to 30 percent slopes, rocky
#> 91                                      Cumulic Humixerepts-Riverwash complex, 0 to 8 percent slopes
#> 92               Psammentic Haploxerolls-Mollic Fluvaquents-Riverwash-complex, 0 to 8 percent slopes
#> 93                                         Sanguinetti-Copperopolis complex, 30 to 60 percent slopes
#> 94                       Fluventic Haploxerepts-Oxyaquic Xerofluvents complex, 0 to 8 percent slopes
#> 95                                                   Nedsgulch-Sites complex, 3 to 15 percent slopes
#> 96                                                  Nedsgulch-Sites complex, 15 to 30 percent slopes
#> 97                                               Nedsgulch-Arpatutu complex, 30 to 60 percent slopes
#> 98                                               Nedsgulch-Wallyhill complex, 3 to 15 percent slopes
#> 99                                     Nedsgulch-Wallyhill-Arpatutu complex, 15 to 30 percent slopes
#> 100                                    Nedsgulch-Wallyhill-Arpatutu complex, 30 to 60 percent slopes
#> 101                                              Copperopolis-Hetchy complex, 8 to 30 percent slopes
#> 102                         Sanguinetti-Moccasinhill-Deerflat complex, 60 to 90 percent slopes, cool
#> 103                           Moccasinhill-Copperopolis-Sanguinetti complex, 30 to 60 percent slopes
#> 104                                       Moccasinhill-Copperopolis complex, 60 to 90 percent slopes
#> 105                                             Lickinfork-Arpatutu complex, 40 to 90 percent slopes
#> 106                                      Wallyhill, deep-Lickinfork complex, 40 to 90 percent slopes
#> 107                                                 Jocal gravelly silt loam, 8 to 30 percent slopes
#> 108                                                Jocal-Fiddletown complex, 30 to 60 percent slopes
#> 109                                         Fiddletown-Rock outcrop complex, 40 to 90 percent slopes
#> 110                                            Tiger Creek-Nedsgulch complex, 3 to 15 percent slopes
#> 111                                           Tiger Creek-Nedsgulch complex, 15 to 50 percent slopes
#> 112                                           Aquariusmine-Millvilla complex, 3 to 30 percent slopes
#> 113                     Rock outcrop-Tiger Creek-Vertic Haploxerepts complex, 1 to 45 percent slopes
#> 114                                              Beybek-Rock outcrop complex, 3 to 30 percent slopes
#> 115                                Aquariusmine-Hetchy-Rock outcrop complex, 30 to 60 percent slopes
#> 116             Mollic Haploxeralfs-Pachic Argixerolls-Rock Outcrop complex, 50 to 90 percent slopes
#> 117                                                         Mckeonhills clay, 5 to 15 percent slopes
#> 118                                                                                       Urban land
#> 119                                         Urban land-Sierra-Flanly complex, 3 to 25 percent slopes
#> 120                                          Urban land-Copperopolis complex, 0 to 15 percent slopes
#> 121                                             Urban land-Millvilla complex, 1 to 25 percent slopes
#> 122                                          Urban land-Musick-Hotaw complex, 3 to 30 percent slopes
#> 123                                  Urban land-Loafercreek-Dunstone complex, 3 to 15 percent slopes
#> 124                                  Urban land-Nedsgulch-Wallyhill complex, 15 to 30 percent slopes
#> 125                                                Urban land-Amador complex, 2 to 15 percent slopes
#> 126                                Urban land-Copperopolis-Whiterock complex, 8 to 30 percent slopes
#> 127                                                                                             Dams
#> 128                                                                                            Water
#>       mukey dbthirdbar_l dbthirdbar_r dbthirdbar_h
#> 1   2403709           NA           NA           NA
#> 2   2924914           NA           NA           NA
#> 3   2924833         1.33         1.45         1.57
#> 4   2924834         1.45         1.52         1.60
#> 5   2924907         1.43         1.48         1.54
#> 6   2924879         1.38         1.48         1.58
#> 7   2924880         1.38         1.48         1.58
#> 8   2924881         1.40         1.48         1.57
#> 9   2924882         1.35         1.43         1.50
#> 10  2924883         1.19         1.28         1.38
#> 11  2924913         1.27         1.42         1.54
#> 12  2924908         1.37         1.38         1.39
#> 13  1913607         1.30         1.41         1.52
#> 14  2425107         1.28         1.39         1.50
#> 15  2480973         0.57         0.75         0.79
#> 16  2220266         0.39         0.48         0.66
#> 17  1865918         1.36         1.42         1.49
#> 18  2450845         1.15         1.31         1.47
#> 19  2924884         1.33         1.38         1.43
#> 20  2600460         1.33         1.46         1.58
#> 21  2220270         0.57         0.75         0.79
#> 22  2220269         0.39         0.48         0.66
#> 23  2374651         1.42         1.49         1.57
#> 24  2600527         1.32         1.42         1.52
#> 25  2600528         1.11         1.36         1.50
#> 26  2600538         1.12         1.40         1.50
#> 27  2924885         1.38         1.42         1.46
#> 28  2924886         1.38         1.42         1.46
#> 29  2766838         1.50         1.56         1.62
#> 30  2600529         1.42         1.47         1.52
#> 31  2766850         1.42         1.47         1.51
#> 32  2924887         1.45         1.49         1.53
#> 33  2600465         1.36         1.47         1.57
#> 34  2600467         1.35         1.46         1.58
#> 35  2600469         0.98         1.12         1.25
#> 36  2403696         1.51         1.74         1.74
#> 37  2450478         1.40         1.47         1.53
#> 38  2766836         1.37         1.42         1.47
#> 39  2766837         1.37         1.46         1.56
#> 40  1913590         1.14         1.26         1.39
#> 41  2924832         1.10         1.17         1.24
#> 42  1913591         1.10         1.17         1.24
#> 43  2924831         1.22         1.32         1.42
#> 44  1913592         1.22         1.32         1.42
#> 45  1900697         1.37         1.45         1.53
#> 46  2482710         0.79         0.87         0.94
#> 47  2220273         0.82         0.82         1.05
#> 48  2220271         0.82         0.82         1.05
#> 49  2924756         1.21         1.28         1.36
#> 50  2924755         1.47         1.50         1.53
#> 51  2399766         1.37         1.45         1.52
#> 52  2441253         1.31         1.40         1.49
#> 53  2924738         1.40         1.50         1.60
#> 54  2399769         1.34         1.47         1.59
#> 55  2399770         1.34         1.43         1.52
#> 56  2399771         1.33         1.41         1.48
#> 57  2924701         1.38         1.46         1.54
#> 58  2924739         1.31         1.41         1.51
#> 59  2403747         1.24         1.36         1.48
#> 60  2399773         1.15         1.26         1.38
#> 61  2399774         1.33         1.43         1.53
#> 62  2399775         1.29         1.42         1.55
#> 63  3225132         1.37         1.45         1.48
#> 64  3225133         1.38         1.48         1.52
#> 65  2924751         1.28         1.40         1.52
#> 66  2924752         1.33         1.43         1.54
#> 67  2924753         1.37         1.46         1.55
#> 68  2924754         1.33         1.41         1.49
#> 69  2450844         1.24         1.37         1.51
#> 70  2441798         1.33         1.45         1.57
#> 71  2440240         1.39         1.46         1.53
#> 72  2440242         1.17         1.25         1.33
#> 73  1865926         1.31         1.38         1.46
#> 74  2450843         1.26         1.37         1.48
#> 75  3225134         1.30         1.40         1.49
#> 76  3225135         1.33         1.44         1.50
#> 77  2426483         1.38         1.44         1.50
#> 78  1865927         1.29         1.40         1.51
#> 79  1865928         1.37         1.41         1.45
#> 80  1906347         1.32         1.42         1.53
#> 81  2600534         1.36         1.45         1.54
#> 82  2766830         1.36         1.43         1.50
#> 83  1913600         1.32         1.41         1.50
#> 84  2600456         1.30         1.47         1.55
#> 85  2600457         1.32         1.44         1.56
#> 86  2600458         1.30         1.39         1.48
#> 87  2426355         1.30         1.35         1.39
#> 88  1865929         1.36         1.43         1.50
#> 89  1865930         1.36         1.43         1.50
#> 90  1865931         1.36         1.43         1.50
#> 91  2399780         1.20         1.30         1.41
#> 92  2924955         1.46         1.52         1.58
#> 93  2399783         1.24         1.36         1.46
#> 94  2924909         1.39         1.46         1.54
#> 95  1913602         1.07         1.14         1.21
#> 96  2220301         1.02         1.10         1.17
#> 97  2452459         1.05         1.16         1.27
#> 98  2383083         1.30         1.30         1.43
#> 99  2383084         1.31         1.38         1.46
#> 100 1913601         1.26         1.35         1.45
#> 101 2424962         1.31         1.38         1.45
#> 102 2424963         1.18         1.29         1.39
#> 103 1913605         1.33         1.40         1.47
#> 104 1913606         1.32         1.41         1.50
#> 105 2455490         1.29         1.37         1.46
#> 106 2483494         0.98         1.09         1.20
#> 107 2455492         1.01         1.08         1.16
#> 108 2455495         0.79         0.86         1.02
#> 109 2455494         0.82         0.92         1.02
#> 110 2436792         1.24         1.34         1.44
#> 111 2436790         1.11         1.27         1.42
#> 112 2403711         1.33         1.44         1.55
#> 113 2403710           NA           NA           NA
#> 114 2424959         1.13         1.37         1.48
#> 115 2424960         1.23         1.35         1.47
#> 116 2424961         1.34         1.44         1.54
#> 117 2924890         1.06         1.11         1.30
#> 118 2403722           NA           NA           NA
#> 119 2403721           NA           NA           NA
#> 120 2403720           NA           NA           NA
#> 121 2403719           NA           NA           NA
#> 122 2424975           NA           NA           NA
#> 123 2600480           NA           NA           NA
#> 124 2600481           NA           NA           NA
#> 125 2600537           NA           NA           NA
#> 126 2924835           NA           NA           NA
#> 127 2924912           NA           NA           NA
#> 128 2462630           NA           NA           NA
# }