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 in point feature classes via StationID.
| Field Name | Field Alias | Length (text fields) |
Field Type | Field Value | Default | Allow Nulls? | Attributes / Examples | Description / Notes |
|---|---|---|---|---|---|---|---|---|
| SampleID | " | 50 | String | variable | undefined | TRUE | ASR 09-123 | Sample ID (links to Data_point) |
| LargerFtr | LargerFeature | 50 | String | variable | [null] | TRUE | 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) |
| ThinSect | ThinSection | Short Integer | boolean | 0 (no) | FALSE | 1=yes/TRUE, 0=no/FALSE | Thin section made ? | |
| Geochron | " | Short Integer | boolean | 0 (no) | FALSE | 1=yes/TRUE, 0=no/FALSE | Geochron done? | |
| Geochem | " | Short Integer | boolean | 0 (no) | FALSE | 1=yes/TRUE, 0=no/FALSE | Geochemistry analysis done? | |
| WholeRock | " | Short Integer | boolean | 0 (no) | FALSE | 1=yes/TRUE, 0=no/FALSE | Whole rock chemsitry done? | |
| Paleontlgy | Paleontology | Short Integer | boolean | 0 (no) | FALSE | 1=yes/TRUE, 0=no/FALSE | Paleontology done? | |
| Pmag | " | Short Integer | boolean | 0 (no) | FALSE | 1=yes/TRUE, 0=no/FALSE | Palemagnetic analysis done? | |
| OtherAnlys | OtherAnalysis | 16 | String | variable | [null] | TRUE | other analysis type (e.g. air permeametry, etc.) | Other analysis done |
| DataType | " | 16 | String | variable | [null] | TRUE | extensible data type: e.g. grainsize, clast count | |
| Data | " | 10.6 | Double | variable | [null] | TRUE | [null] | |
| DataSubtyp | DataSubtype | 16 | String | variable | [null] | TRUE | [null], sample depth etc. | |
| SubData | " | 12 | Single | variable | [null] | TRUE | [null] | |
| DataAccur | DataAccuracy | 12 | String | variable | [null] | TRUE | good, fair, poor | accuracy of measurement |
| DataPrecis | DataPrecision | 12 | String | variable | [null] | TRUE | ? | precision of measurement |
| DataConfid | DataConfidence | 16 | String | variable | [null] | TRUE | unspecified, certain, probable, uncertain | confidence of measurement |
| LocAccType | LocAccuracyType | 50 | String | variable | [null] | TRUE | precision gps, handheld gps, good topo, poor topo, planimetric, survey | accuracy of position |
| LocAccMeas | LocAccuracyMeasure | 16 | String | variable | [null] | TRUE | EPE(m), PDOP, Map and compass, triangulation | |
| LocAccVal | LocAccuracyValue | 8 | Single | variable | [null] | TRUE | 15 | |
| SourceID | " | 128 | String | variable | [null] | unknown; unspecified; Smith, 2006b [variable] | Feature level metadata (who mapped this); related to bibliographic detail | |
| Comments | " | 255 | String | variable | [null] | TRUE | Comments about this particular feature. |