Conversion of Horizon Designations

Submitted by dylan on Fri, 2007-11-02 17:17.

 
Authoritative Sources

  • Field Book for Describing and Sampling Soils, Section 4. (PDF)

 
get a list of horizon names which are infrequent

SELECT pedon_id, a.* FROM chemical JOIN (SELECT hz_name, count(hz_name) FROM chemical GROUP BY hz_name) AS a ON a.hz_name = chemical.hz_name WHERE a.count = 1;

‹ Soil-Vegetation DatabaseupData Summaries ›