fetchNASIS: add summaries of phorizon child tables for bulk density and Ksat - Githubissues

ncss-tech / soilDB

soilDB: Simplified Access to National Cooperative Soil Survey Databases

http://ncss-tech.github.io/soilDB/

GNU General Public License v3.0

81 stars 20 forks source link

fetchNASIS: add summaries of phorizon child tables for bulk density and Ksat #341

Open brownag opened 8 months ago

brownag commented 8 months ago

Currently there is no way to get the following pedon horizon child tables in soilDB without a custom query and aggregation

[ ] phdb Pedon Horizon Bulk Density
[ ] phksatsummary Pedon Horizon Ksat Summary

Aggregation considerations:

phdb
- multiple observations per genetic horizon, top and bottom depth required
- multiple methods (probably don't want to aggregate dissimilar methods)
- field moist/air dry source data/subsamples vs. calculated outputs
phksatsummary
- possible multiple test dates
- multiple methods (amoozemeter, double/single ring, saturo [to be added])
General
- Some source data / values needed for calculations are stored in child tables

Other issues:

Planned updates to data model for DSP may break anything we develop for current model (not sure on timeline for updates)