Fetch commonly used site/horizon data from a version 5.x PedonPC database, return as a SoilProfileCollection object.

fetchPedonPC(dsn)

## Arguments

dsn The path to a PedonPC version 6.x database

## Value

a SoilProfileCollection class object

## Note

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.

get_hz_data_from_pedon_db