soilDB

soilDB copied to clipboard

`fetchSoilGrids` -- can we automate download of arbitrary extent grids?

2

Toy example based on https://git.wur.nl/isric/soilgrids/soilgrids.notebooks/-/blob/master/markdown/wcs_from_R.md to follow up on: ``` r library(XML) library(lazyraster) library(magrittr) voi

brownag

Add an option to each of these functions for *simple* NA-filling by methods from the `zoo` (or similar) package. Other ideas: * https://cran.rstudio.com/web/packages/timetk/vignettes/TK00_Time_Series_Coercion.html

dylanbeaudette

extract multiple textures / horizon from NASIS data

5

See `get_hz_data_from_NASIS_db()`. Specifically: ```sql SELECT peiid, phiid, upedonid as pedon_id, hzname, dspcomplayerid as genhz, hzdept, hzdepb, claytotest AS clay, CASE WHEN silttotest IS NULL THEN 100 - (claytotest + sandtotest)...

dylanbeaudette

INNER or LEFT joins for component parent material and geomorph data

2

Functions affected: * `get_component_cogeomorph_data_from_NASIS_db()` -- commit 8cb1201dacb063935bae3d43a07322a1915d5d7a * `get_component_copm_data_from_NASIS_db()` -- commit 94aa357602c1f266db1486c473bb623f89ab3e79 INNER JOINS implicitly filter NULL records, LEFT JOINS retain them. For example, `before` is based on the LEFT...

dylanbeaudette

[Draft documentation here.](https://ncss-tech.github.io/AQP/soilDB/siblings.html) Improvements: * joint area in addition to cross-tabulation (n)

dylanbeaudette

add unique constraint to fetchKSSL

3

Vectorization within `fetchKSSL` can lead to duplication. Add unique constraints to : - [ ] composition of SPC - [ ] morphologic data - [ ] geochemical data.

dylanbeaudette

There are three distinct functions for *flattening* the incredibly complex parent material and geomorphic records: * local NASIS pedons `.formatLandformString` * local NASIS components `.formatcoLandformString` * SDA components `.cogmd_prep` Details...

dylanbeaudette

Noticed today that I had inadvertently checked two texture groups as RV for one of my component horizons. The component wouldn't load via `fetchNASIS_component_data()` due to failing `test_hz_logic()`. The reason...

brownag

multiple RV parent material groups results in duplicate coiids via fetchNASIS_components

1

Multiple parent material groups marked as RV results in a duplication of component records when joining to the pmgroup view. Currently, the many:one flattening assumes that the component's RV PM...

brownag

get_hz_data_from_NASIS_db - issues with join to phsample

8

The LEFT OUTER JOIN to phsample used in the main NASIS horizon data query has the potential to duplicate horizon records in the event of a many:one relationship. There are...

brownag