This table is just an example of a generic sample analysis table that could be linked to Data_point. It is assumed that it will have a user defined structure and will relate to spatial entities via StationID. The following is an example of such a table.
| Field Name | Field Alias | Length | Field Type | Field Value | Default | Allow Nulls? | Pick List / Examples | Notes |
|---|---|---|---|---|---|---|---|---|
| StationID | " | 20 | text | variable | undefined | n | ID of station location | |
| LargrFeatr | LargerFeature | 50 | text | variable | [null] | y | related faults, ash beds, marker layers, or other features | plaintext related larger features/geologic units (could apply to other points, lines, or polygons, so the form of a database relate in unclear) |
| Strike | " | 3 | Short Integer | variable | [null] | y | [null], 256 (right hand rule azimuth of strike) | |
| DipDir | DipDirection | 3 | Short Integer | variable | [null] | y | [null], 166 | |
| Dip | " | 2 | Short Integer | variable | [null] | y | [null], 45 | |
| Younging | " | 16 | text | pick list | [null] | y | unspecified, upright, overturned | |
| ThinSect | ThinSection | 1 | text | pick list | [null] | y | [null], Y | Thin section made ? |
| Geochron | " | 1 | text | pick list | [null] | y | [null], Y | Geochron done? |
| Geochem | " | 1 | text | pick list | [null] | y | [null], Y | Geochemistry analysis done? |
| WholeRock | " | 1 | text | pick list | [null] | y | [null], Y | Whole rock chemsitry done? |
| Paleontlgy | Paleontology | 1 | text | pick list | [null] | y | [null], Y | Paleontology done? |
| Pmag | " | 1 | text | pick list | [null] | y | [null], Y | Palemagnetic analysis done? |
| OtherAnlys | OtherAnalysis | 16 | text | variable | [null] | y | other analysis type (e.g. air permeametry, etc.) | |
| DataType | " | 16 | text | variable | [null] | y | extensible data type: e.g. grainsize, clast count | |
| Data | " | 12 | float | variable | [null] | y | [null] | |
| DataSubtyp | DataSubtype | 16 | text | variable | [null] | y | [null], sample depth etc. | |
| SubData | " | 12 | float | variable | [null] | y | [null] | |
| DataAccur | DataAccuracy | 12 | text | pick list / var | [null] | y | good, fair, poor | accuracy of measurement |
| DataPrecis | DataPrecision | 12 | text | pick list / var | [null] | y | ? | precision of measurement |
| DataConfid | DataConfidence | 16 | text | pick list | [null] | y | unspecified, certain, probable, uncertain | confidence of measurement |
| LocAccType | LocAccuracyType | 16 | text | pick list / var | [null] | y | precision gps, handheld gps, good topo, poor topo, planimetric, survey | accuracy of position |
| LocAccMeas | LocAccuracyMeasure | 16 | text | pick list / var | [null] | y | EPE(m), PDOP, Map and compass, triangulation | |
| LocAccVal | LocAccuracyValue | 8 | float | variable | [null] | y | 15 | |
| SourceID | " | 50 | text | variable | [null] | unknown; unspecified; Smith, 2006b [variable] | feature level metadata (who mapped this); related to bibliographic detail | |
| Comments | " | (max) | text | variable | [null] | y |