Database Manual
Export to Excel   |   Print Version (Wide Table Format)
| Table | Table Comments |
|---|---|
| BIOSTRAT | Biostratigraphic age picks derived from reports done by or done for the oil industry. Biostrat reports generated by the Geological Survey of Canada are another major source of data. |
Export to Excel   |   Print Version (Wide Table Format)
| Table | Column | Column Comments |
|---|---|---|
| BIOSTRAT | LOC_NO | A three digit number, preceded by the letter "D" (for Dartmouth) that is used by GSCA and CNSOPB staff as a shorthand means of referring to a well. Each well is assigned a location number when the well samples arrive at CNSOPB for curation. |
| BIOSTRAT | AUTHOR | The author (oil company or individual) of the document/report from which the biostratigraphic data are taken. |
| BIOSTRAT | YEAR | The year in which the document/report was published/produced. |
| BIOSTRAT | JOURNAL | The title of the document/report from which the biostratigraphic data is taken. |
| BIOSTRAT | DIVISION | The division (Epoch) of the geological age (Period); values can be "LATE", "MIDDLE" or "EARLY". |
| BIOSTRAT | AGE | The geological age, such as "MAASTRICHTIAN". |
| BIOSTRAT | METHOD | The method (specific biostratigraphic discipline) used to determine age, such as "PALYNOLOGY". |
| BIOSTRAT | ZONE | The name of the biostratigraphic zone (if applicable), such as "AREOLIGERA SENONENSIS ZONE". |
| BIOSTRAT | PALEOENVIRONMENT | The paleoenvironment of the interval, usually inferred from the microfossil assemblage, such as "OPEN MARINE". |
| BIOSTRAT | TOP | Depth in the well (from the rotary table) to the top of the age/division/zone. |
| BIOSTRAT | BOTTOM | Depth in the well (from the rotary table) to the bottom of the age/division/zone. |
| BIOSTRAT | UNITS | Units of depth measure, "M" or "FT". |
| BIOSTRAT | CITEID | Citation ID number (bibliographic reference number). |
Choose a Table