Home | Uploading | Viewing Data | Search | Making Public | Lists | Sample Attributes | Chemical Analysis Attributes | Image Attributes | XML Output |  To MetPetDB


Back to the Object Model

Chemical Analysis Object

Associated with one subsample (and therefore also to one sample).

More information on chemical analyses can be found here.

Latest chemical analysis database schema.

REQUIRED FIELDS

SAMPLE NUMBER
Must correlate to existing sample in database. (Upload help)
SUBSAMPLE
Must correlate to existing subsample of the given sample number. If a subsample has not yet been created, you may create one here, but you must provide a subsample type (see below).
POINT
The analysis number. It should be unique to the subsample to allow differentiation between different points for a particular subsample. It should be an integer.
MINERAL
This must be in agreement with minerals or mineral modes listed as present for the sample. If the analysis is a bulk/whole rock analysis, this field should read bulk rock.
METHOD
Method of analysis, i.e. EMP, LA-ICPMS, SIMS, etc. You must use an accepted Method Code.
SUBSAMPLE TYPE – required to create subsamples at bulk upload
In order to create a subsample during bulk upload of chemical analysis, you must specify a type for the new subsample. Subsample types accepted: Thin section, Polished thin section, Rock Chip, or Mineral separate. Subsample type only needs to be specified for the first chemical analysis for a particular subsample in a list. For example, if you have 5 garnet analyses on a new polished thin section that you want to upload, you only need to enter “polished thin section” in the subsample type column for the first (topmost) analysis.

OPTIONAL FIELDS

ANALYTICAL FACILITY
The analytical facility where analysis was performed. This can be the name of an institution or department.
ANALYSIS DATE
Must be a date in MM-DD-YYYY, YYYY-MM-DD or any shortened version (i.e. YYYY, or, YYYY-MM). Notes on entering dates for upload to MetPedDB.
ANALYST
The name of the person who analyzed the sample. Preferred format: Lastname, First initial.
REFERENCE IMAGE
The filename (including extension) of image on which the analysis location is referenced. If you do not know it you can find it by navigating to the image itself. The goal here is to allow the user to link to an image showing the context of a chemical analysis, so the reference image must be uploaded prior to chemical analysis upload. Attempting to add a reference image that is not already in the subsample in MetPetDB will give a bulk upload error message, and only the image name will be stored with no direct link to the image itself (NOTE: Currently this functionality is not implemented and the analysis point cannot be uploaded--you must remove any reference images that are not already in the database). If no reference image exists or one cannot be uploaded, leave this column blank and none shall be assigned.
X REFERENCE
The x coordinate location of the analysis on the reference image, measured in percent of total image width (in original orientaion). The origin is assumed to be at bottom left of image.
Y REFERENCE
The y coordinate location of the analysis on the reference image, measured in percent of total image height (in original orientaion). The origin is assumed to be at bottom left of image.
X STAGE
The stage X-coordinate recorded by a microscope or microprobe. These are in microns.
Y STAGE
The stage Y-coordinate recorded by a microscope or microprobe. These are in microns.
ELEMENTS/SPECIES – at least one required
  • Headers should be different elements/species (e.g. CaO, SiO2, Mg).
  • UNITS – must be in second row and in proper format, (e.g. wt%, ppm)
  • Non numerical values can be used to indicate information about an analysis as in the table below:

Values for Elements/Species can be numeric or these abbreviations:

  • n.d. = not determined
  • [blank] = not determined
  • n.a. = not determined (literally not analyzed)
  • - = not determined
  • b.d. = below detection
  • b.d.l. = below detection limit
  • < [a value] = less than the specified value
PRECISION
  • Uncertainty of measurement (relative or absolute).
  • Precision is entered for EACH SPECIFIC ELEMENT/SPECIES VALUE in the column directly to the right of the element/species. PRECISION VALUES WILL NOT APPLY TO ALL ELEMENTS/SPECIES, ONLY PRECEDING COLUMN.
  • UNITS – must be in second row and in proper format, including –abs or -rel for absolute vs. relative.


WEIGHT PERCENT TOTAL
The total weight percent of measured elements/species for this point. This indicates the completeness of the analysis to a user.

COMMENT
There may be any number of comment columns. You can input any type of description of the analytical strategy. RE: Bulk Upload For organization purposes, it is probably best to put separate types of information in separate comment columns, rather than strung together in a single comment. The key to using the comment field is to put in information that will describe the analysis, and will help others find it in a search.

Home | Uploading | Viewing Data | Search | Making Public | Lists | Sample Attributes | Chemical Analysis Attributes | Image Attributes | XML Output |  To MetPetDB