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 detection 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 12
Sample characteristics 5
Chemical analysis 7
Metadata 23