revised: 05-Feb-2015

NMBGMR Draft Geologic Data Model - v. 1.0.4
JOINED & RELATED TABLES: Sample Data

In the interests of standardization and interoperability, we are migrating our geologic maps into the USGS NCGMP09 data model. However, our well data model is still actively being used. Documentation for the NMBGMR geology data model is being provided for users with legacy data in this model. We also hope that it will provoke discussion in the ongoing effort to improve NCGMP09 and other models.

Table Name: Samples

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.