2007 GSA Denver Annual Meeting (2831 October 2007)
Paper No. 78-8
Presentation Time: 10:00 AM-10:15 AM

METPETDB: THE UNIQUE ASPECTS OF METAMORPHIC GEOCHEMICAL DATA AND THEIR INFLUENCE ON DATA MODEL, USER INTERFACE AND COLLABORATIONS

PYLE, Joseph M.1, SPEAR, Frank S.1, ADALı, Sibel2, SZYMANSKI, Boleslaw2, PEARCE, Shawn O.2, WATERS, Anthony2, LINDER, Zak2, and OZCAGLAR, Cagri2, (1) Earth and Environmental Sciences, Rensselaer Polytechnic Institute, JRSC 1W19, 110 8th St, Troy, NY 12180, pylej@rpi.edu, (2) Computer Sciences, Rensselaer Polytechnic Institute, 110 8th St, Troy, NY 12180

The need for a geochemical database specific to metamorphic petrology derives from an emphasis of single-phase spot analysis over bulk-rock chemical analysis, and paragenetic relationships between zoned metamorphic minerals in specific textural and deformational domains. MetPetDB (MPDB) is a geochemical database for metamorphic rocks designed to emphasize the spatial interrelationships of metamorphic rocks at all scales.

Objects in our data model are classified as samples, or constituent subsamples (e.g., thin sections) possessing attributes (metadata) used to delimit searches and to spatially constrain associated data types, either geochemical data or images.

Sample and subsample metadata is stored in a PostgreSQL database, with the PostGIS extension for storing spatial data. Data is uploaded through the user interface on a single sub-sample basis, or in bulk using data tables with required metadata fields. All database users may access Public data (from published papers); access to Private (unpublished) data is restricted to the data owner and other designated users.

MPDB's web-based user interface is built upon the Java servlet API which is served by Apache Tomcat system and relies on the AJAX technology and Google Web Toolkit framework.

Registered MPDB users can use the web-based user interface to save and download search results. Downloaded data may be ported to the MetPetDB Image Viewer (IV) and Tool Kit (TK). The IV enables image operations on multiple, spatially-referenced image files within a single sub-sample and active links to all spot chemical analyses within the viewable image field. The linked geochemical data can be plotted or  transformed using the TK, a bundled collection of basic plotting and geochemical analysis routines.

Additionally, the interface can be used to create, edit, and track one or more projects - a group of samples designated by the data owner, who assigns different levels of data uploading, viewing and editing privileges to all collaborators invited to join a given project.

We are currently populating MPDB with data and images from the literature (~85 articles to date, 1955-present). We are also exploring issues related to standards for archived data, interfacing with other geochemical databases, and inclusion of other data types associated with metamorphic geochemical data.

2007 GSA Denver Annual Meeting (2831 October 2007)
General Information for this Meeting
Session No. 78
Geoscience Data for Geoinformatics
Colorado Convention Center: 702
8:00 AM-12:00 PM, Monday, 29 October 2007

Geological Society of America Abstracts with Programs, Vol. 39, No. 6, p. 210

© Copyright 2007 The Geological Society of America (GSA), all rights reserved. Permission is hereby granted to the author(s) of this abstract to reproduce and distribute it freely, for noncommercial purposes. Permission is hereby granted to any individual scientist to download a single copy of this electronic file and reproduce up to 20 paper copies for noncommercial purposes advancing science and education, including classroom use, providing all reproductions include the complete content shown here, including the author information. All other forms of reproduction and/or transmittal are prohibited without written permission from GSA Copyright Permissions.