Fetch commonly used site/horizon data from a version 5.x PedonPC database, return as a SoilProfileCollection object.
The path to a PedonPC version 6.x database
a SoilProfileCollection class object
This function attempts to do most of the boilerplate work when
extracting site/horizon data from a PedonPC or local NASIS database. Pedons
that have errors in their horizonation are excluded from the returned
object, however, their IDs are printed on the console. See
getHzErrorsPedonPC for a simple approach to identifying pedons
with problematic horizonation. Records from the 'taxhistory' table are
selected based on 1) most recent record, or 2) record with the least amount
of missing data.
D. E. Beaudette and J. M. Skovlin