Database structure

Table Description
tblRockGeoData Main Table containing a single record for each rock sample with fields describing the sample, the IDs, the submitter, the location, and the site. Every record is identified by a unique LAB_ID value.
xtbMajorChem Analytical data by LAB_ID for major element oxide analyses plus forms-of-carbon, forms-of-sulfur, chlorine, and fluorine data.
xtbXrfChem Analytical data by LAB_ID for minor and trace elements determined by X-ray fluorescence spectrometry.
xtbNaaChem Analytical data by LAB_ID for major, minor, and trace elements determined by instrumental neutron activation analysis or delayed neutron activation analysis.
xtbIcpaesChem Analytical data by LAB_ID for major, minor, and trace elements determined by inductively coupled plasma-atomic emission spectrometry with separate fields for total and partial digestion analyses.
xtbIcpmsChem Analytical data by LAB_ID for major, minor, and trace elements determined by inductively coupled-mass spectrometry with separate fields for total and partial digestion analyses.
xtbEsChem Analytical data by LAB_ID for major, minor, and trace elements determined by emission spectroscopy.
xtbOtherChem Analytical data by LAB_ID for major, minor, and trace elements determined by atomic absorption spectrometry, colorimetry, ion selective electrode (except Cl & F), fluorometry, or fire assay with separate fields for total and partial digestion analyses.
xtbUnknownChem Analytical data by LAB_ID for major, minor, and trace elements determined by analytical methods currently unspecified in the database.
datadxny Data dictionary, explaining tables and fields

Database field categories

Sample identification 10
Processing information 4
Geographic location 7
Site characteristics 6
Sample characteristics 12
Analyses for major elements 190
Analyses by XRF 82
Analyses by NAA 129
Analyses by DNA 6
Miscellaneous analyses 12
Analyses by ICP-AES 118
Analyses by ICP-AES Partial Chem 78
Analyses by ICP-MS 128
Analyses by Emission Spectroscopy 138
Analyses by AA 83
Analyses by AA Partial Chem 32
Analyses by Colorimetry 34
Analyses by Colorimetry Partial Chem 16
Analyses by Fluorometry 4
Analyses by Fire Assay Methods 15
Analyses by Unspecified Methods 196
Analyses by Unspecified Partial Chem Methods 10
Metadata 16