EarthRef.org Reference Database (ERR)
Development and Maintenance by the EarthRef.org Database Team
Detailed Reference Information
Lehnert et al. 2000
Lehnert, K., Su, Y., Langmuir, C.H., Sarbas, B. and Nohl, U. (2000).
A global geochemical database structure for rocks.
Geochemistry Geophysics Geosystems 1: doi: 10.1029/1999GC000026. issn: 1525-2027.
This technical brief describes a geochemical and petrological database structure based on the relational model that has broad applicability to chemical analyses of geological materials. Notable features of the database structure are its comprehensiveness and flexibility. The structure consists of 34 interrelated tables, which can accommodate any type of analytical values for all different materials of rock samples (volcanic glasses, minerals, inclusions, etc.) and for samples from any tectonic setting. A broad spectrum of supplementary information (metadata) is included that describes the quality of the analytical data and sample characteristics, such as petrography, geographical location, and sampling process, and that can be used to evaluate, filter, and sort the chemical data. All data in the database are linked to their original reference. The database structure can be implemented in any relational database management system (RDBMS). It is currently applied in two different rock database projects (RidgePetDB and GEOROC).
BACKGROUND DATA FILES
Entire Document PDF
Geochemistry, Geochemistry, Instruments and techniques
Geochemistry Geophysics Geosystems
American Geophysical Union
2000 Florida Avenue N.W.
Washington, D.C. 20009-1277
Google Site Search
Browsers and Plugins
Webservices and Database Support by the
San Diego Supercomputer Center
Scripps Institution of Oceanography
College of Earth, Ocean and Atmospheric Sciences