Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

byFeature argument to SDA_spatialQuery() #222

Closed
dylanbeaudette opened this issue Nov 22, 2021 · 1 comment · Fixed by #225
Closed

byFeature argument to SDA_spatialQuery() #222

dylanbeaudette opened this issue Nov 22, 2021 · 1 comment · Fixed by #225

Comments

@dylanbeaudette
Copy link
Member

If x is a collection of spatial feature, it would be handy to have SDA_spatialQuery(..., what = 'mukey') return a data.frame or list for each feature. This would support "I want those map unit keys that intersect / overlap with the following features, in row-order please" style questions, without a secondary spatial overlay of the polygons.

This would come at a cost: byFeature iteration would be a little slower due to the extra overhead.

@brownag brownag linked a pull request Dec 14, 2021 that will close this issue
@brownag
Copy link
Member

brownag commented Dec 14, 2021

Implemented byFeature and idcol in 8fd02d0

When byFeature is TRUE individual feature queries are run and then rbind-ed into a single data.frame. Unique feature ID column name is specified with idcol default value is "gid"

image

library(sf)
#> Linking to GEOS 3.9.1, GDAL 3.2.1, PROJ 7.2.1
library(soilDB)
set.seed(123)
x <- st_as_sf(data.frame(x = runif(10, -93.6, -93.5), y = runif(10, 41.5, 41.6)),
              coords = c("x","y"), crs=4326)
x$FeatureID <- 1:nrow(x)

# get mukeys intersecting point geometries
res1 <- SDA_spatialQuery(x, idcol = "FeatureID", byFeature = TRUE)
x2 <- merge(x, res1, by = "FeatureID")
x2
#> Simple feature collection with 10 features and 3 fields
#> Geometry type: POINT
#> Dimension:     XY
#> Bounding box:  xmin: -93.59544 ymin: 41.50421 xmax: -93.50595 ymax: 41.59568
#> Geodetic CRS:  WGS 84
#>    FeatureID  mukey
#> 1          1 412934
#> 2          2 412869
#> 3          3 412871
#> 4          4 412871
#> 5          5 412932
#> 6          6 412908
#> 7          7 412892
#> 8          8 411907
#> 9          9 412892
#> 10        10 412895
#>                                                                    muname
#> 1                        Wadena-Urban land complex, 0 to 2 percent slopes
#> 2       Klum fine sandy loam, 0 to 2 percent slopes, occasionally flooded
#> 3  Dockery-Quiver silt loams, 0 to 2 percent slopes, occasionally flooded
#> 4  Dockery-Quiver silt loams, 0 to 2 percent slopes, occasionally flooded
#> 5           Bremer silty clay loam, 0 to 2 percent slopes, rarely flooded
#> 6                       Clarion-Urban land complex, 2 to 5 percent slopes
#> 7               Sharpsburg silty clay loam, 5 to 9 percent slopes, eroded
#> 8  Dockery-Quiver silt loams, 0 to 2 percent slopes, occasionally flooded
#> 9               Sharpsburg silty clay loam, 5 to 9 percent slopes, eroded
#> 10                                                             Urban land
#>                      geometry
#> 1  POINT (-93.57124 41.59568)
#> 2  POINT (-93.52117 41.54533)
#> 3   POINT (-93.5591 41.56776)
#> 4   POINT (-93.5117 41.55726)
#> 5  POINT (-93.50595 41.51029)
#> 6  POINT (-93.59544 41.58998)
#> 7  POINT (-93.54719 41.52461)
#> 8  POINT (-93.51076 41.50421)
#> 9  POINT (-93.54486 41.53279)
#> 10 POINT (-93.55434 41.59545)

# get full extent of each polygon intersecting point geometries
res2 <- SDA_spatialQuery(x, what="mupolygon", byFeature = TRUE)
res2
#> Simple feature collection with 10 features and 2 fields
#> Geometry type: POLYGON
#> Dimension:     XY
#> Bounding box:  xmin: -93.61793 ymin: 41.50111 xmax: -93.48347 ymax: 41.61362
#> Geodetic CRS:  WGS 84
#>     mukey gid                           geom
#> 1  412934   1 POLYGON ((-93.58151 41.5978...
#> 2  412869   2 POLYGON ((-93.52215 41.5463...
#> 3  412871   3 POLYGON ((-93.61193 41.5786...
#> 4  412871   4 POLYGON ((-93.61193 41.5786...
#> 5  412932   5 POLYGON ((-93.50737 41.5097...
#> 6  412908   6 POLYGON ((-93.5907 41.59183...
#> 7  412892   7 POLYGON ((-93.58797 41.5187...
#> 8  411907   8 POLYGON ((-93.51993 41.5031...
#> 9  412892   9 POLYGON ((-93.58797 41.5187...
#> 10 412895  10 POLYGON ((-93.61634 41.5952...

# buffer polygons by 0.01 degrees, and query mukeys within buffer (~adjacent mapunits to point polygon)
res3 <- SDA_spatialQuery(sf::st_buffer(res2, 100), idcol = "FeatureID", byFeature = TRUE)
res3
#>       mukey
#> 1    412871
#> 2    412895
#> 3    412899
#> 4    412934
#> 5    412953
#> 6    412869
#> 7    412871
#> 8    412953
#> 9    412819
#> 10   412822
#> 11   412828
#> 12   412830
#> 13   412831
#> 14   412850
#> 15   412863
#> 16   412868
#> 17   412869
#> 18   412871
#> 19   412895
#> 20   412904
#> 21   412925
#> 22   412931
#> 23   412932
#> 24   412944
#> 25   412945
#> 26   412947
#> 27   412948
#> 28   412950
#> 29   412953
#> 30   412954
#> 31   412955
#> 32   412958
#> 33   412968
#> 34   412969
#> 35   412970
#> 36   412971
#> 37   412972
#> 38   412973
#> 39   412977
#> 40   412978
#> 41   412986
#> 42   412990
#> 43   412992
#> 44   695404
#> 45  3046432
#> 46   412819
#> 47   412822
#> 48   412828
#> 49   412830
#> 50   412831
#> 51   412850
#> 52   412863
#> 53   412868
#> 54   412869
#> 55   412871
#> 56   412895
#> 57   412904
#> 58   412925
#> 59   412931
#> 60   412932
#> 61   412944
#> 62   412945
#> 63   412947
#> 64   412948
#> 65   412950
#> 66   412953
#> 67   412954
#> 68   412955
#> 69   412958
#> 70   412968
#> 71   412969
#> 72   412970
#> 73   412971
#> 74   412972
#> 75   412973
#> 76   412977
#> 77   412978
#> 78   412986
#> 79   412990
#> 80   412992
#> 81   695404
#> 82  3046432
#> 83   411907
#> 84   411938
#> 85   411946
#> 86   411961
#> 87   411968
#> 88   411975
#> 89   412830
#> 90   412871
#> 91   412932
#> 92   412970
#> 93   412895
#> 94   412899
#> 95   412908
#> 96   412909
#> 97   412950
#> 98  2916770
#> 99   411925
#> 100  411929
#> 101  411930
#> 102  411931
#> 103  411962
#> 104  411963
#> 105  411965
#> 106  411972
#> 107  412822
#> 108  412863
#> 109  412878
#> 110  412879
#> 111  412889
#> 112  412890
#> 113  412892
#> 114  412893
#> 115  412895
#> 116  412923
#> 117  412946
#> 118  412971
#> 119  412972
#> 120  412973
#> 121  412992
#> 122  411889
#> 123  411890
#> 124  411907
#> 125  411913
#> 126  411938
#> 127  411946
#> 128  411975
#> 129  411985
#> 130 1697395
#> 131 1697400
#> 132 1697401
#> 133 2996520
#> 134  411925
#> 135  411929
#> 136  411930
#> 137  411931
#> 138  411962
#> 139  411963
#> 140  411965
#> 141  411972
#> 142  412822
#> 143  412863
#> 144  412878
#> 145  412879
#> 146  412889
#> 147  412890
#> 148  412892
#> 149  412893
#> 150  412895
#> 151  412923
#> 152  412946
#> 153  412971
#> 154  412972
#> 155  412973
#> 156  412992
#> 157  412819
#> 158  412828
#> 159  412831
#> 160  412853
#> 161  412857
#> 162  412871
#> 163  412895
#> 164  412899
#> 165  412905
#> 166  412907
#> 167  412908
#> 168  412909
#> 169  412910
#> 170  412931
#> 171  412934
#> 172  412946
#> 173  412947
#> 174  412950
#> 175  412953
#> 176  412958
#> 177  412992
#> 178 2916770
#>                                                                            muname
#> 1          Dockery-Quiver silt loams, 0 to 2 percent slopes, occasionally flooded
#> 2                                                                      Urban land
#> 3                              Nicollet-Urban land complex, 1 to 3 percent slopes
#> 4                                Wadena-Urban land complex, 0 to 2 percent slopes
#> 5                                           Aquents, ponded, occasionally flooded
#> 6               Klum fine sandy loam, 0 to 2 percent slopes, occasionally flooded
#> 7          Dockery-Quiver silt loams, 0 to 2 percent slopes, occasionally flooded
#> 8                                           Aquents, ponded, occasionally flooded
#> 9                                              Wadena loam, 0 to 2 percent slopes
#> 10      Colo-Judson silty clay loams, 0 to 5 percent slopes, occasionally flooded
#> 11  Colo silty clay loam, deep loess, 0 to 2 percent slopes, occasionally flooded
#> 12              Zook silty clay loam, 0 to 2 percent slopes, occasionally flooded
#> 13                  Coland clay loam, 0 to 2 percent slopes, occasionally flooded
#> 14           Fayette silty clay loam, till plain, 14 to 18 percent slopes, eroded
#> 15                      Gara clay loam, 9 to 14 percent slopes, moderately eroded
#> 16                                           Cylinder loam, 0 to 2 percent slopes
#> 17              Klum fine sandy loam, 0 to 2 percent slopes, occasionally flooded
#> 18         Dockery-Quiver silt loams, 0 to 2 percent slopes, occasionally flooded
#> 19                                                                     Urban land
#> 20                                  Sparta loamy fine sand, 0 to 2 percent slopes
#> 21                                    Vanmeter silt loam, 18 to 25 percent slopes
#> 22        Nodaway, occasionally flooded-Urban land complex, 0 to 2 percent slopes
#> 23                  Bremer silty clay loam, 0 to 2 percent slopes, rarely flooded
#> 24                  Lawson silt loam, 0 to 2 percent slopes, occasionally flooded
#> 25                   Spillville loam, 0 to 2 percent slopes, occasionally flooded
#> 26                                                          Pits, sand and gravel
#> 27                                                                    Dumps, mine
#> 28                                                                Orthents, loamy
#> 29                                          Aquents, ponded, occasionally flooded
#> 30                                               Psammaquents, frequently flooded
#> 31                                                                     Pits, clay
#> 32                                                    Orthents, sanitary landfill
#> 33                                          Lindley loam, 14 to 18 percent slopes
#> 34                                          Lindley loam, 18 to 25 percent slopes
#> 35                                   Wiota silty clay loam, 0 to 2 percent slopes
#> 36                                        Ladoga silt loam, 2 to 5 percent slopes
#> 37    Ladoga silty clay loam, dissected till plain, 5 to 9 percent slopes, eroded
#> 38                         Ladoga silty clay loam, 9 to 14 percent slopes, eroded
#> 39                         Clinton silty clay loam, 5 to 9 percent slopes, eroded
#> 40                        Clinton silty clay loam, 9 to 14 percent slopes, eroded
#> 41            Judson silty clay loam, dissected till plain, 2 to 5 percent slopes
#> 42                       Turlin loam, 0 to 2 percent slopes, occasionally flooded
#> 43                                                                          Water
#> 44                                                                  Sewage lagoon
#> 45                   Nevin silty clay loam, 0 to 2 percent slopes, rarely flooded
#> 46                                             Wadena loam, 0 to 2 percent slopes
#> 47      Colo-Judson silty clay loams, 0 to 5 percent slopes, occasionally flooded
#> 48  Colo silty clay loam, deep loess, 0 to 2 percent slopes, occasionally flooded
#> 49              Zook silty clay loam, 0 to 2 percent slopes, occasionally flooded
#> 50                  Coland clay loam, 0 to 2 percent slopes, occasionally flooded
#> 51           Fayette silty clay loam, till plain, 14 to 18 percent slopes, eroded
#> 52                      Gara clay loam, 9 to 14 percent slopes, moderately eroded
#> 53                                           Cylinder loam, 0 to 2 percent slopes
#> 54              Klum fine sandy loam, 0 to 2 percent slopes, occasionally flooded
#> 55         Dockery-Quiver silt loams, 0 to 2 percent slopes, occasionally flooded
#> 56                                                                     Urban land
#> 57                                  Sparta loamy fine sand, 0 to 2 percent slopes
#> 58                                    Vanmeter silt loam, 18 to 25 percent slopes
#> 59        Nodaway, occasionally flooded-Urban land complex, 0 to 2 percent slopes
#> 60                  Bremer silty clay loam, 0 to 2 percent slopes, rarely flooded
#> 61                  Lawson silt loam, 0 to 2 percent slopes, occasionally flooded
#> 62                   Spillville loam, 0 to 2 percent slopes, occasionally flooded
#> 63                                                          Pits, sand and gravel
#> 64                                                                    Dumps, mine
#> 65                                                                Orthents, loamy
#> 66                                          Aquents, ponded, occasionally flooded
#> 67                                               Psammaquents, frequently flooded
#> 68                                                                     Pits, clay
#> 69                                                    Orthents, sanitary landfill
#> 70                                          Lindley loam, 14 to 18 percent slopes
#> 71                                          Lindley loam, 18 to 25 percent slopes
#> 72                                   Wiota silty clay loam, 0 to 2 percent slopes
#> 73                                        Ladoga silt loam, 2 to 5 percent slopes
#> 74    Ladoga silty clay loam, dissected till plain, 5 to 9 percent slopes, eroded
#> 75                         Ladoga silty clay loam, 9 to 14 percent slopes, eroded
#> 76                         Clinton silty clay loam, 5 to 9 percent slopes, eroded
#> 77                        Clinton silty clay loam, 9 to 14 percent slopes, eroded
#> 78            Judson silty clay loam, dissected till plain, 2 to 5 percent slopes
#> 79                       Turlin loam, 0 to 2 percent slopes, occasionally flooded
#> 80                                                                          Water
#> 81                                                                  Sewage lagoon
#> 82                   Nevin silty clay loam, 0 to 2 percent slopes, rarely flooded
#> 83         Dockery-Quiver silt loams, 0 to 2 percent slopes, occasionally flooded
#> 84            Bremer silty clay loam, 0 to 2 percent slopes, occasionally flooded
#> 85              Zook silty clay loam, 0 to 2 percent slopes, occasionally flooded
#> 86                                         Wiota silt loam, 0 to 2 percent slopes
#> 87                                         Wiota silt loam, 2 to 5 percent slopes
#> 88                   Nevin silty clay loam, 0 to 2 percent slopes, rarely flooded
#> 89              Zook silty clay loam, 0 to 2 percent slopes, occasionally flooded
#> 90         Dockery-Quiver silt loams, 0 to 2 percent slopes, occasionally flooded
#> 91                  Bremer silty clay loam, 0 to 2 percent slopes, rarely flooded
#> 92                                   Wiota silty clay loam, 0 to 2 percent slopes
#> 93                                                                     Urban land
#> 94                             Nicollet-Urban land complex, 1 to 3 percent slopes
#> 95                              Clarion-Urban land complex, 2 to 5 percent slopes
#> 96                              Clarion-Urban land complex, 5 to 9 percent slopes
#> 97                                                                Orthents, loamy
#> 98                           Belview loam, Bemis moraine, 16 to 30 percent slopes
#> 99                               Macksburg silty clay loam, 0 to 2 percent slopes
#> 100                             Sharpsburg silty clay loam, 2 to 5 percent slopes
#> 101                             Sharpsburg silty clay loam, 5 to 9 percent slopes
#> 102                     Sharpsburg silty clay loam, 5 to 9 percent slopes, eroded
#> 103                                        Givin silt loam, 0 to 2 percent slopes
#> 104                                       Ladoga silt loam, 2 to 5 percent slopes
#> 105         Ladoga silt loam, dissected till plain, 5 to 9 percent slopes, eroded
#> 106                        Lamoni silty clay loam, 9 to 14 percent slopes, eroded
#> 107     Colo-Judson silty clay loams, 0 to 5 percent slopes, occasionally flooded
#> 108                     Gara clay loam, 9 to 14 percent slopes, moderately eroded
#> 109                   Shelby clay loam, 9 to 14 percent slopes, moderately eroded
#> 110                                     Shelby clay loam, 14 to 18 percent slopes
#> 111                              Macksburg silty clay loam, 0 to 2 percent slopes
#> 112                             Sharpsburg silty clay loam, 2 to 5 percent slopes
#> 113                     Sharpsburg silty clay loam, 5 to 9 percent slopes, eroded
#> 114                    Sharpsburg silty clay loam, 9 to 14 percent slopes, eroded
#> 115                                                                    Urban land
#> 116                                    Vanmeter silt loam, 9 to 14 percent slopes
#> 117                            Orthents-urban land complex, 0 to 5 percent slopes
#> 118                                       Ladoga silt loam, 2 to 5 percent slopes
#> 119   Ladoga silty clay loam, dissected till plain, 5 to 9 percent slopes, eroded
#> 120                        Ladoga silty clay loam, 9 to 14 percent slopes, eroded
#> 121                                                                         Water
#> 122                            Downs silt loam, till plain, 2 to 5 percent slopes
#> 123                    Downs silt loam, till plain, 5 to 9 percent slopes, eroded
#> 124        Dockery-Quiver silt loams, 0 to 2 percent slopes, occasionally flooded
#> 125                                 Wabash silty clay loam, 0 to 2 percent slopes
#> 126           Bremer silty clay loam, 0 to 2 percent slopes, occasionally flooded
#> 127             Zook silty clay loam, 0 to 2 percent slopes, occasionally flooded
#> 128                  Nevin silty clay loam, 0 to 2 percent slopes, rarely flooded
#> 129              Armstrong-Gara loams, 14 to 18 percent slopes, moderately eroded
#> 130                                                                         Water
#> 131                                                             Udorthents, loamy
#> 132                                                         Pits, sand and gravel
#> 133               Kennebec silt loam, 0 to 2 percent slopes, occasionally flooded
#> 134                              Macksburg silty clay loam, 0 to 2 percent slopes
#> 135                             Sharpsburg silty clay loam, 2 to 5 percent slopes
#> 136                             Sharpsburg silty clay loam, 5 to 9 percent slopes
#> 137                     Sharpsburg silty clay loam, 5 to 9 percent slopes, eroded
#> 138                                        Givin silt loam, 0 to 2 percent slopes
#> 139                                       Ladoga silt loam, 2 to 5 percent slopes
#> 140         Ladoga silt loam, dissected till plain, 5 to 9 percent slopes, eroded
#> 141                        Lamoni silty clay loam, 9 to 14 percent slopes, eroded
#> 142     Colo-Judson silty clay loams, 0 to 5 percent slopes, occasionally flooded
#> 143                     Gara clay loam, 9 to 14 percent slopes, moderately eroded
#> 144                   Shelby clay loam, 9 to 14 percent slopes, moderately eroded
#> 145                                     Shelby clay loam, 14 to 18 percent slopes
#> 146                              Macksburg silty clay loam, 0 to 2 percent slopes
#> 147                             Sharpsburg silty clay loam, 2 to 5 percent slopes
#> 148                     Sharpsburg silty clay loam, 5 to 9 percent slopes, eroded
#> 149                    Sharpsburg silty clay loam, 9 to 14 percent slopes, eroded
#> 150                                                                    Urban land
#> 151                                    Vanmeter silt loam, 9 to 14 percent slopes
#> 152                            Orthents-urban land complex, 0 to 5 percent slopes
#> 153                                       Ladoga silt loam, 2 to 5 percent slopes
#> 154   Ladoga silty clay loam, dissected till plain, 5 to 9 percent slopes, eroded
#> 155                        Ladoga silty clay loam, 9 to 14 percent slopes, eroded
#> 156                                                                         Water
#> 157                                            Wadena loam, 0 to 2 percent slopes
#> 158 Colo silty clay loam, deep loess, 0 to 2 percent slopes, occasionally flooded
#> 159                 Coland clay loam, 0 to 2 percent slopes, occasionally flooded
#> 160                            Hayden loam, Bemis moraine, 6 to 10 percent slopes
#> 161                           Hayden loam, Bemis moraine, 22 to 40 percent slopes
#> 162        Dockery-Quiver silt loams, 0 to 2 percent slopes, occasionally flooded
#> 163                                                                    Urban land
#> 164                            Nicollet-Urban land complex, 1 to 3 percent slopes
#> 165                             Webster-Urban land complex, 0 to 2 percent slopes
#> 166        Coland, occasionally flooded-Urban land complex, 0 to 2 percent slopes
#> 167                             Clarion-Urban land complex, 2 to 5 percent slopes
#> 168                             Clarion-Urban land complex, 5 to 9 percent slopes
#> 169                            Clarion-Urban land complex, 9 to 14 percent slopes
#> 170       Nodaway, occasionally flooded-Urban land complex, 0 to 2 percent slopes
#> 171                              Wadena-Urban land complex, 0 to 2 percent slopes
#> 172                            Orthents-urban land complex, 0 to 5 percent slopes
#> 173                                                         Pits, sand and gravel
#> 174                                                               Orthents, loamy
#> 175                                         Aquents, ponded, occasionally flooded
#> 176                                                   Orthents, sanitary landfill
#> 177                                                                         Water
#> 178                          Belview loam, Bemis moraine, 16 to 30 percent slopes
#>     FeatureID
#> 1           1
#> 2           1
#> 3           1
#> 4           1
#> 5           1
#> 6           2
#> 7           2
#> 8           2
#> 9           3
#> 10          3
#> 11          3
#> 12          3
#> 13          3
#> 14          3
#> 15          3
#> 16          3
#> 17          3
#> 18          3
#> 19          3
#> 20          3
#> 21          3
#> 22          3
#> 23          3
#> 24          3
#> 25          3
#> 26          3
#> 27          3
#> 28          3
#> 29          3
#> 30          3
#> 31          3
#> 32          3
#> 33          3
#> 34          3
#> 35          3
#> 36          3
#> 37          3
#> 38          3
#> 39          3
#> 40          3
#> 41          3
#> 42          3
#> 43          3
#> 44          3
#> 45          3
#> 46          4
#> 47          4
#> 48          4
#> 49          4
#> 50          4
#> 51          4
#> 52          4
#> 53          4
#> 54          4
#> 55          4
#> 56          4
#> 57          4
#> 58          4
#> 59          4
#> 60          4
#> 61          4
#> 62          4
#> 63          4
#> 64          4
#> 65          4
#> 66          4
#> 67          4
#> 68          4
#> 69          4
#> 70          4
#> 71          4
#> 72          4
#> 73          4
#> 74          4
#> 75          4
#> 76          4
#> 77          4
#> 78          4
#> 79          4
#> 80          4
#> 81          4
#> 82          4
#> 83          5
#> 84          5
#> 85          5
#> 86          5
#> 87          5
#> 88          5
#> 89          5
#> 90          5
#> 91          5
#> 92          5
#> 93          6
#> 94          6
#> 95          6
#> 96          6
#> 97          6
#> 98          6
#> 99          7
#> 100         7
#> 101         7
#> 102         7
#> 103         7
#> 104         7
#> 105         7
#> 106         7
#> 107         7
#> 108         7
#> 109         7
#> 110         7
#> 111         7
#> 112         7
#> 113         7
#> 114         7
#> 115         7
#> 116         7
#> 117         7
#> 118         7
#> 119         7
#> 120         7
#> 121         7
#> 122         8
#> 123         8
#> 124         8
#> 125         8
#> 126         8
#> 127         8
#> 128         8
#> 129         8
#> 130         8
#> 131         8
#> 132         8
#> 133         8
#> 134         9
#> 135         9
#> 136         9
#> 137         9
#> 138         9
#> 139         9
#> 140         9
#> 141         9
#> 142         9
#> 143         9
#> 144         9
#> 145         9
#> 146         9
#> 147         9
#> 148         9
#> 149         9
#> 150         9
#> 151         9
#> 152         9
#> 153         9
#> 154         9
#> 155         9
#> 156         9
#> 157        10
#> 158        10
#> 159        10
#> 160        10
#> 161        10
#> 162        10
#> 163        10
#> 164        10
#> 165        10
#> 166        10
#> 167        10
#> 168        10
#> 169        10
#> 170        10
#> 171        10
#> 172        10
#> 173        10
#> 174        10
#> 175        10
#> 176        10
#> 177        10
#> 178        10

merge(x, res3, by = "FeatureID", all.y=TRUE)
#> Simple feature collection with 178 features and 3 fields
#> Geometry type: POINT
#> Dimension:     XY
#> Bounding box:  xmin: -93.59544 ymin: 41.50421 xmax: -93.50595 ymax: 41.59568
#> Geodetic CRS:  WGS 84
#> First 10 features:
#>    FeatureID  mukey
#> 1          1 412871
#> 2          1 412895
#> 3          1 412899
#> 4          1 412934
#> 5          1 412953
#> 6          2 412869
#> 7          2 412871
#> 8          2 412953
#> 9          3 412819
#> 10         3 412822
#>                                                                       muname
#> 1     Dockery-Quiver silt loams, 0 to 2 percent slopes, occasionally flooded
#> 2                                                                 Urban land
#> 3                         Nicollet-Urban land complex, 1 to 3 percent slopes
#> 4                           Wadena-Urban land complex, 0 to 2 percent slopes
#> 5                                      Aquents, ponded, occasionally flooded
#> 6          Klum fine sandy loam, 0 to 2 percent slopes, occasionally flooded
#> 7     Dockery-Quiver silt loams, 0 to 2 percent slopes, occasionally flooded
#> 8                                      Aquents, ponded, occasionally flooded
#> 9                                         Wadena loam, 0 to 2 percent slopes
#> 10 Colo-Judson silty clay loams, 0 to 5 percent slopes, occasionally flooded
#>                      geometry
#> 1  POINT (-93.57124 41.59568)
#> 2  POINT (-93.57124 41.59568)
#> 3  POINT (-93.57124 41.59568)
#> 4  POINT (-93.57124 41.59568)
#> 5  POINT (-93.57124 41.59568)
#> 6  POINT (-93.52117 41.54533)
#> 7  POINT (-93.52117 41.54533)
#> 8  POINT (-93.52117 41.54533)
#> 9   POINT (-93.5591 41.56776)
#> 10  POINT (-93.5591 41.56776)

brownag added a commit that referenced this issue Dec 14, 2021
* SDA_spatialQuery/processSDA_WKT: Use sf (with sp support)

* SDA_spatialQuery: Add `byFeature` argument #222

* get_SDA_coecoclass: simplify results

* Update NEWS
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants