Skip to contents

Get map unit properties from Soil Data Access

Usage

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

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

WHERE

character containing SQL WHERE clause specified in terms of fields in legend or mapunit tables, used in lieu of mukeys or areasymbols. With aggregation method "NONE" the WHERE clause may additionally contain logic for columns from the component and chorizon table.

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? Default: TRUE

miscellaneous_areas

Include miscellaneous areas (non-soil components) in results? Default: FALSE. Now works with all method types)

query_string

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

dsn

Path to local SQLite database or a DBIConnection object. If NULL (default) use Soil Data Access API 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{

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