Database structure

Table Description
datadxny Data dictionary, explaining tables and fields
main Sample location, characteristics, and general methods of collection and analysis
chemistry All chemical analyses recorded for the sample, with analytical method, measured values, and qualifiers to indicate where a measured value was outside the reliable determination limits of the method
bestvalue Best analytic value for each element obtained by selecting the most reliable analytic methods from among those that were performed on the sample

Database field categories

Sample identification 4
Processing information 11
Geographic location 9
Site characteristics 6
Sample characteristics 4
Chemical analysis 7
Metadata 23