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

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

Open
2 tasks
brownag opened this issue Jan 31, 2024 · 0 comments
Open
2 tasks

Comments

@brownag
Copy link
Member

brownag commented Jan 31, 2024

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)
@brownag brownag changed the title fetchNASIS: add new summaries of phorizon child tables fetchNASIS: add summaries of phorizon child tables for bulk density and Ksat Apr 18, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant