Latest sample database schema (line 54).
- SAMPLE NUMBER
- Each sample name must be unique to the sample owner. That is, there may be more than one sample with a specific number (e.g. 93-24) but only one sample with a particular owner can have this number. Note that there is no case sensetivity, so v-10=V-10.
- ROCK TYPE
- This is not an exercise in taxonomy. However, every rock in the database must have a name. The "Rock Type" must be from list of rock types (see Appendix A). Additionally, multiple rock names are not only permitted, but encouraged (simply add an additional rock names as "Comments" – see below). However, a single rock type is required. The list of rock types is largely from the British Geological Survey's recommendations.
- Must be between -90 and 90 (negative for south). Units are decimal degrees (DD.DDDDD). Note that five (5) decimal places corresponds to roughly 1 meter spatial resolution.
- Must be between -180 and 180 (negative for west). Units are decimal degrees (DD.DDDDD).
- LOCATION ERROR
- Units are in meters
- Latitude/longitude errors are an optional field for samples that are not well located. Errors are assumed to be the same in all directions.
- IGSN (International Geological Sample Numbers) are unique identifiers that are created by SESAR (System for Earth SAmple Registration http://www.geosamples.org/). You must register your samples to obtain an IGSN. If you have an IGSN you can enter it here. We plan to have a tool for automatic sample registration through MetPetDB in the future.
- This is the region from which the sample was collected. It can be any text you choose and there can be any number of regions. Regions can be geographic (e.g. Alps, Valhalla Complex, Raging River Valley, Pine Island) or political (e.g. Vermont, Cooke County).
- When specifying multiple regions, put each distinct region in a separate spreadsheet column. Each column should be headed by the word "Region".
- Also: you may want to look through the database to see if your region already exists. Please conform to existing spellings for your region. Suggestions can be made to MetPetDB administrators.
- Where sample was collected. Pretty obvious, except where countries change names or the boundaries change. For consistency, input the country of collection at the time the sample was collected.
- ALIAS (alternate sample number)
- In some cases the same rock sample has been referred to by different sample numbers. These are sample aliases. There can be any number of aliases.
- The name of the person who collected the sample. Preferred format: Lastname, First name middle initial.
- DATE OF COLLECTION
- Must be a date in MM-DD-YYYY, YYYY-MM-DD or a shortened version (i.e. YYYY, or, YYYY-MM). Notes on entering dates for upload to MetPedDB.
- PRESENT SAMPLE LOCATION
- Institution, department, or lab where the sample currently resides (in case someone wishes to find the sample).
- METAMORPHIC GRADE
- This is the grade of metamorphism. The grade must be from the list of metamorphic grades. A sample may have zero or more metamorphic grades. Alternate descriptions of the metamorphic grade are encouraged, and should included as "Comments".
- MetPetDB uses the year and the GeoRef accession number (the same as NAVDAT), which can be found from a GeoRef search. For example, “1983-018415”. Data that are published require a reference to the publication. References in non-publication data may be included to direct a user to a publication that includes a reference to this sample or another version of it.
- There may be any number of comment columns. You can input alternate rock names or alternate descriptions of the metamorphic grade (or anything else) as comments. 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 sample, and will help others find it in a search.
- MINERALS PRESENT and MINERAL MODES
- A list of minerals present in the sample and, if available, the modes of the minerals are very useful information. For an individual spreadsheet, the format is to
- (1) Put the name of a specific mineral as the column header. Headers must be from LIST OF MINERALS.
- (2) If the mineral is present but the mode is unknown, put "x" in the field
- (3) If the mineral is present and the mode is known, put the mode in the field (note: modes typically sum to 100%).
- (4) If the mineral is not present, leave the field blank.
For example, for a suite of schists, this part of the spreadsheet might look like this:
Quartz Plagioclase Muscovite Biotite Garnet Chlorite Ilmenite Zircon Staurolite Kyanite x x x x x x x 30 5 30 20 10 1 x x x 20 x <1 ? x x x x x x x x x
Any text or number field is permissible and signifies a mineral is present.
Common usage includes:
- [A number] = mode
- < or > [a number]
- x = present
- ? = may be present
- t = present in trace amounts