| Literature DB >> 28534869 |
Toni H Veikkolainen1, Andrew J Biggin2, Lauri J Pesonen1, David A Evans3, Nicholas A Jarboe4.
Abstract
State-of-the-art measurements of the direction and intensity of Earth's ancient magnetic field have made important contributions to our understanding of the geology and palaeogeography of Precambrian Earth. The PALEOMAGIA and PINT(QPI) databases provide thorough public collections of important palaeomagnetic data of this kind. They comprise more than 4,100 observations in total and have been essential in supporting our international collaborative efforts to understand Earth's magnetic history on a timescale far longer than that of the present Phanerozoic Eon. Here, we provide an overview of the technical structure and applications of both databases, paying particular attention to recent improvements and discoveries.Entities:
Year: 2017 PMID: 28534869 PMCID: PMC5441291 DOI: 10.1038/sdata.2017.68
Source DB: PubMed Journal: Sci Data ISSN: 2052-4463 Impact factor: 6.444
QPI quality criteria used in PINT(QPI) database (see also ref. 9).
| Each criterion can have two values (1=yes, 0=no) and the total QPI value is the sum of individual criteria. | ||
|---|---|---|
| 1 | AGE | A reliable (if approximate) age exists and palaeomagnetic behaviour is consistent with a palaeointensity derived from a primary component of remanent magnetization. |
| 2 | STAT | The site mean is derived from a minimum of 5 individual sample estimates and these have low dispersion (true standard deviation /mean≤25%). |
| 3 | TRM | There exists reasonable independent (e.g., microscopic) evidence that the component of remanence in the bulk of samples is likely a thermoremanent magnetization (TRM). |
| 4 | ALT | There exists reasonable evidence that the estimate was not significantly biased by alteration occurring during the experiment. |
| 5 | MD | There exists reasonable evidence that the estimate was not significantly biased by multidomain behaviour during the experiment. |
| 6 | ACN | There exists reasonable evidence that the estimate was not significantly biased by anisotropy of TRM, cooling rate effects, and nonlinear TRM effects. |
| 7 | TECH | The estimate comprises a mean of results derived using more than one palaeointensity technique. |
| 8 | LITH | The estimate comprises results from more than one lithology or from samples from the same lithology showing significantly different unblocking behaviour of magnetization. |
| 9 | MAG | The raw measurement data are freely available in a public database or repository. |
Figure 1PALEOMAGIA sampling locations on a world map.
Symbols are semi-transparent and a darker colour therefore indicates a greater number of data at a given site. Red symbols refer to Archaean (N=191), blue symbols to Palaeoproterozoic (N=438), green symbols to Mesoproterozoic (N=1,953) and yellow symbols to Neoproterozoic (N=912) data. Miller projection.
Tables and relations in PALEOMAGIA database. In the main data table, RES# (result number) is unique to each row, but not a key because it is not related to properties in other tables.
| Numbers of rows and columns refer to version 2.03 of the database, as of March 9, 2017. | ||
|---|---|---|
| 608/8 | ||
| 56/2 | ||
| 3,494/37 | ||
| 1,013/9 | ||
| 104/2 |
Column structure in the main data table (data) of PALEOMAGIA and associated MySQL data types
| The result number (RES) is unique to each entry and serves as the primary key of the database. Note that the appearance of the online database query result table, including but not limited to column names, is different from the actual table structure shown here. Information generated by PHP scripts (e.g., AV as a sum of columns 1…6) to appear at the PALEOMAGIA website is not included here, but is thoroughly explained in the online documentation. For column structures of other PALEOMAGIA tables, see | ||
|---|---|---|
| RES# | varchar | Unique result number. |
| ROCK | varchar | Type of rock (igneous, sedimentary or metamorphic). |
| ROCKUNIT | varchar | Name of rock. |
| CNTRY | varchar | Country name abbreviation. See table |
| COMP | varchar | Component of magnetization vector. |
| CRAT | varchar | Terrane (craton, orogen, inlier, etc.). See table |
| SLAT | decimal | Latitude of the sampling site in degrees. |
| SLON | decimal | Longitude of the sampling site in degrees. |
| LMA | int | Estimated lower limit of the age of magnetization in million years. |
| HMA | int | Estimated upper limit of the age of magnetization in million years. |
| ISOAGE | varchar | Isotopic age, if available. |
| AGEREF | varchar | The age reference most relevant to the palaeomagnetic entry. See table |
| AGEREF2 | varchar | A possible second age reference for the palaeomagnetic entry. |
| MET | varchar | Method of the age determination. |
| AGE | int | Estimated age of magnetization, by definition between LMA and HMA. |
| B | varchar | Number of sampling sites. |
| N | varchar | Number of samples. This is succeeded by an asterisk (*) if sample mean statistics have been used (otherwise site mean statistics are assumed) |
| P | varchar | Magnetic polarity (normal; N, reversed; R, mixed; M or combination of distinct normal and reversed polarity entries in polarity pairs; C). |
| R% | varchar | Percentage of reversed magnetic polarity in sample-level data. |
| D | decimal | Declination in degrees. |
| I | decimal | Inclination in degrees. |
| alfa95 | decimal | Radius of 95% cone of confidence for direction in degrees. |
| k | decimal | Concentration parameter of directions. |
| PLAT | decimal | Latitude of paleomagnetic pole, or antipole, depending on APWP consideration. |
| PLON | decimal | Longitude of paleomagnetic pole, or antipole, depending on APWP consideration. |
| DP | decimal | Angular length of the semi-axis of the 95% confidence for pole, along the site-to-pole great circle in degrees. |
| DM | decimal | Angular length of the semi-axis of the 95% confidence for pole, perpendicular to the site-to-pole great circle in degrees. |
| 1 | int | Truncated Van der Voo grading (QVoo) 1: the rock age is well-determined and the magnetization is presumably of the same age. |
| 2 | int | Truncated Van der Voo grading (QVoo) 2: number of samples is sufficient (N>24), concentration parameter is large (k≥10) and 95% confidence circle for the mean direction is small (α95≤16.0°). |
| 3 | int | Truncated Van der Voo grading (QVoo) 3: demagnetization is adequate and demonstrably includes vector subtraction. |
| 4 | int | Truncated Van der Voo grading (QVoo) 4: field tests constrain the age of magnetization. |
| 5 | int | Truncated Van der Voo grading (QVoo) 5: structural control and tectonic coherence with terrane involved. |
| 6 | int | Truncated Van der Voo grading (QVoo) 6: geomagnetic field reversals are present. |
| PMAGREF | varchar | Palaeomagnetic reference, i.e., where the palaeomagnetic data have been originally published. See table |
| COMMENT | varchar | Possible comments about the entry. These may be subjective and unless otherwise noted, reflect only the viewpoint of PALEOMAGIA administrators. |
| RECALC | int | Whether any reasonable recalculations have been done (i.e., for some specific reason, the data are not shown exactly as published). This is a dichotomic field (1=yes, 0=no). |
Column structure in tables other than the main data table (agerefs, countries, pmagrefs, terranes) of PALEOMAGIA and associated MySQL data types.
| For column structure of the main data table, see | ||
|---|---|---|
| SHORTREF | varchar | Author-year reference in short form. |
| AU | varchar | Author names, including surnames and initials of first names. |
| TITLE | varchar | Name of the paper or other type of document where the results have been published. |
| REF | varchar | Name of the journal or book, if applicable. For journals and proceedings with long names, abbreviations have been used as noted in the online documentation. |
| YR | int | Year of publication. |
| V | varchar | Volume of publication. |
| PP | decimal | Pages. |
| DOI | decimal | Digital Object Identifier, see |
| Table name: | ||
| CNTRY | varchar | Abbreviation of the name of the country, e.g., FI for Finland. |
| CNTRYLONG | varchar | Full name of the country. In the online documentation, these are printed along with abbreviations. |
| Table name: | ||
| PMAGREF | varchar | Equal to SHORTREF in table |
| AU | varchar | Author names, including surnames and initials of first names. |
| TITLE | varchar | Name of the paper or other type of document where the results have been published. |
| REF | varchar | Name of the journal or book, if applicable. For journals and proceedings with long names, abbreviations have been used as noted in the online documentation. |
| YR | int | Year of publication. |
| V | varchar | Volume. |
| PP | varchar | Pages. |
| REV | int | Whether the data have undergone peer-review. This is a dichotomic field (1=yes, 0=no) |
| DOI | varchar | Digital Object Identifier, see http://dx.doi.org |
| Table name: | ||
| CRATON | varchar | Precambrian terrane (in most cases craton) name, e.g., Karelia. |
| CONT | varchar | Present-day continent where the craton is located. e.g., Europe for the Karelia craton. |
Figure 2PALEOMAGIA data grouped by geological age and the sum of QVoo criteria (Table 3 (available online only)) in each group, excluding the seventh criterion as explained in the text.
PINT(QPI) database structure.
| 64/9 | ||
| 642/39 | ||
| 25/2 | ||
| 39/2 | All records match uniquely the field codes of table |
Figure 3Assignment of QPI criteria and overall values within PINT(QPI).All data are shown in (a) and (d), Precambrian only in (b) and (e) and Phanerozoic only in (c) and (f).
Although the current edition of PINT(QPI) incorporates only 642 out of 4,293 data entries in PINT, progress is being made to extend the Phanerozoic part of PINT(QPI).