revised: 05-Feb-2015

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.

• Overview
• Points
• Lines
• Polygons
• Attributes
• Related Tables
• Symbology
• Topology
• Cross Sections
• Key

---

• Discussion
• Geodatabase Objects
• Relationship Classes

We have set up geodatabase relationship classes between features and stand-alone tables. For instance Lith_poly units are in a relationship class with the Lithology table. Relationship classes have the advantage over standard database joins or relates in that the relationship is stored in the geodatabase itself and not in the ArcMap MXD file.

Name	Origin	Destination	Attributed	Composite	Rules
Geochron_Data	Data_point	Geochronology	No	Yes	No
GT_BHT_Data	Well_Samples	GT_BHT	No	Yes	Yes
GT_ConductivityData	WS_Interval	GT_Conductvty	No	Yes	Yes
GT_HeatFlowData	WS_Interval	GT_HeatFlow	No	Yes	Yes
GT_TempDepthData	Well_Samples	GT_TempDepth	No	Yes	Yes
Images_at_Data_points	Data_point	Images	No	No	No
Images_of_Features	Feature_point	Images	No	No	No
Lith_Detail	Lithology	Lith_poly	No	No	No
LithPick_LithologyDetail	Lithology	Well_LthStrat	No	No	No
Samples_ExtendedAttributes	Data_point	Samples	No	Yes	No
Surface_Detail	Surfaces	Surface_poly	No	No	No
Well_BoreData	Well_Records	Well_Bore	No	Yes	Yes
Well_BoreLineData	Well_point	Well_BoreLine	No	Yes	Yes
Well_CasingData	Well_Records	Well_Casing	No	Yes	Yes
Well_DataSources	Sources	Well_Records	No	No	Yes
Well_HeaderData	Well_point	Well_Header	No	Yes	Yes
Well_HeatflowSummary	Well_Records	GT_SumHeatFlow	No	Yes	Yes
Well_HistoryData	Well_Records	Well_History	No	Yes	Yes
Well_LinerData	Well_Records	Well_Liner	No	Yes	Yes
Well_LithLogData	Well_Records	Well_LithLog	No	Yes	Yes
Well_LithStratData	Well_Records	Well_LthStrat	No	Yes	Yes
Well_LocationData	Well_Header	Well_Location	No	Yes	Yes
Well_LogMetadata	Well_Records	Well_LogData	No	Yes	Yes
Well_PetroleumData	Well_Records	Well_PetroDat	No	Yes	Yes
Well_ProdInterval_PerfData	Well_PetroDat	Well_PerfIntv	No	Yes	No
Well_ProductionData	Well_Records	Well_Productn	No	Yes	Yes
Well_RecordIDs	Well_Header	Well_Records	No	Yes	Yes
Well_SamplesData	Well_Records	Well_Samples	No	Yes	Yes
Well_TreatmentData	Well_Records	Well_Treatmnt	No	Yes	No
Well_TubingData	Well_Records	Well_Tubing	No	Yes	Yes
Well_XY_DatumData	Well_Records	Well_XY_Datum	No	Yes	Yes
Well_XZYdata	Well_Records	Well_XYZ	No	Yes	Yes
Well_Z_DatumData	Well_Records	Well_Z_Datum	No	Yes	Yes
WS_Description	WS_Interval	WS_Descrp	No	Yes	Yes
WS_IntervalData	Well_Samples	WS_Interval	No	Yes	Yes
WS_PoreSpaceData	WS_Interval	WS_PoreSpace	No	Yes	Yes
WS_WaterTableData	Well_Samples	WS_WaterTable	No	Yes	Yes

---

Geochron_Data

Composite	Yes
Cardinality	One To One
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Data_point	Geochronology
Key	SampleID (Origin Primary Key)	SampleID (Origin Foreign Key)
Labels	Data_point	Geochronology

Back to Top

GT_BHT_Data

Composite	Yes
Cardinality	One To Many
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_Samples	GT_BHT
Key	SamplSetID (Origin Primary Key)	SamplSetID (Origin Foreign Key)
Labels	Well_Samples	BHT

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Well_Samples	1..1	GT_BHT	M

Back to Top

GT_ConductivityData

Composite	Yes
Cardinality	One To One
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	WS_Interval	GT_Conductvty
Key	IntrvlGUID (Origin Primary Key)	IntrvlGUID (Origin Foreign Key)
Labels	WS_Interval	GT_Conductvty

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	WS_Interval	1..1	GT_Conductvty	0..1

Back to Top

GT_HeatFlowData

Composite	Yes
Cardinality	One To One
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	WS_Interval	GT_HeatFlow
Key	IntrvlGUID (Origin Primary Key)	IntrvlGUID (Origin Foreign Key)
Labels	WS_Interval	GT_HeatFlow

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	WS_Interval	1..1	GT_HeatFlow	0..1

Back to Top

GT_TempDepthData

Composite	Yes
Cardinality	One To Many
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_Samples	GT_TempDepth
Key	SamplSetID (Origin Primary Key)	SamplSetID (Origin Foreign Key)
Labels	Well_Samples	Temp/Depth

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Well_Samples	1..1	GT_TempDepth	M

Back to Top

Images_at_Data_points

Composite	No
Cardinality	One To Many
Notification	None
Attributed	No
	Origin	Destination
ObjectClass	Data_point	Images
Key	StationID (Origin Primary Key)	StationID (Origin Foreign Key)
Labels	Data_point	Images

Back to Top

Images_of_Features

Composite	No
Cardinality	One To Many
Notification	None
Attributed	No
	Origin	Destination
ObjectClass	Feature_point	Images
Key	Feature_ID (Origin Primary Key)	Feature_ID (Origin Foreign Key)
Labels	Feature_point	Images

Back to Top

Lith_Detail

Composite	No
Cardinality	One To Many
Notification	None
Attributed	No
	Origin	Destination
ObjectClass	Lithology	Lith_poly
Key	GeoID (Origin Primary Key)	GeoID (Origin Foreign Key)
Labels	Lithology Details	Lith_poly

Back to Top

LithPick_LithologyDetail

Composite	No
Cardinality	One To Many
Notification	None
Attributed	No
	Origin	Destination
ObjectClass	Lithology	Well_LthStrat
Key	GeoID (Origin Primary Key)	GeoID (Origin Foreign Key)
Labels	Lithologic Unit Detail	Well_LthStrat

Back to Top

Samples_ExtendedAttributes

Composite	Yes
Cardinality	One To One
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Data_point	Samples
Key	SampleID (Origin Primary Key)	SampleID (Origin Foreign Key)
Labels	Data_point	Samples

Back to Top

Surface_Detail

Composite	No
Cardinality	One To Many
Notification	None
Attributed	No
	Origin	Destination
ObjectClass	Surfaces	Surface_poly
Key	SurfaceID (Origin Primary Key)	SurfaceID (Origin Foreign Key)
Labels	Surfaces	Surface_poly

Back to Top

Well_BoreData

Composite	Yes
Cardinality	One To Many
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_Records	Well_Bore
Key	RecrdSetID (Origin Primary Key)	RecrdsetID (Origin Foreign Key)
Labels	Well_Records	Well bore / drilling

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Well_Records	1..1	Well_Bore	M

Back to Top

Well_BoreLineData

Composite	Yes
Cardinality	One To One
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_point	Well_BoreLine
Key	WellDataID (Origin Primary Key)	WellDataID (Origin Foreign Key)
Labels	Well_point	Well bore 3D-line

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Well_point	1..1	Well_BoreLine	0..1

Back to Top

Well_CasingData

Composite	Yes
Cardinality	One To Many
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_Records	Well_Casing
Key	RecrdSetID (Origin Primary Key)	RecrdsetID (Origin Foreign Key)
Labels	Well_Records	Well Casing

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Well_Records	1..1	Well_Casing	M

Back to Top

Well_DataSources

Composite	No
Cardinality	One To Many
Notification	None
Attributed	No
	Origin	Destination
ObjectClass	Sources	Well_Records
Key	SourceID (Origin Primary Key)	SourceID (Origin Foreign Key)
Labels	Sources	Well Records

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Sources	1..1	Well_Records	M

Back to Top

Well_HeaderData

Composite	Yes
Cardinality	One To One
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_point	Well_Header
Key	WellPtGUID (Origin Primary Key)	WellPtGUID (Origin Foreign Key)
Labels	Well_point	Well Header

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Well_point	1..1	Well_Header	0..1

Back to Top

Well_HeatflowSummary

Composite	Yes
Cardinality	One To Many
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_Records	GT_SumHeatFlow
Key	RecrdSetID (Origin Primary Key)	RecrdSetID (Origin Foreign Key)
Labels	Well_Records	Heat Flow Summary

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Well_Records	1..1	GT_SumHeatFlow	M

Back to Top

Well_HistoryData

Composite	Yes
Cardinality	One To One
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_Records	Well_History
Key	RecrdSetID (Origin Primary Key)	RecrdsetID (Origin Foreign Key)
Labels	Well_Records	Well History

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Well_Records	1..1	Well_History	0..1

Back to Top

Well_LinerData

Composite	Yes
Cardinality	One To Many
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_Records	Well_Liner
Key	RecrdSetID (Origin Primary Key)	RecrdsetID (Origin Foreign Key)
Labels	Well_Records	Well Liner

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Well_Records	1..1	Well_Liner	M

Back to Top

Well_LithLogData

Composite	Yes
Cardinality	One To Many
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_Records	Well_LithLog
Key	RecrdSetID (Origin Primary Key)	RecrdSetID (Origin Foreign Key)
Labels	Well_Records	Lithology Log

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Well_Records	1..1	Well_LithLog	M

Back to Top

Well_LithStratData

Composite	Yes
Cardinality	One To Many
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_Records	Well_LthStrat
Key	RecrdSetID (Origin Primary Key)	RecrdsetID (Origin Foreign Key)
Labels	Well_Records	Lith / Strat picks

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Well_Records	1..1	Well_LthStrat	M

Back to Top

Well_LocationData

Composite	Yes
Cardinality	One To One
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_Header	Well_Location
Key	WellDataID (Origin Primary Key)	WellDataID (Origin Foreign Key)
Labels	Well_Header	Well Location

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Well_Header	1..1	Well_Location	1

Back to Top

Well_LogMetadata

Composite	Yes
Cardinality	One To One
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_Records	Well_LogData
Key	RecrdSetID (Origin Primary Key)	RecrdsetID (Origin Foreign Key)
Labels	Well_Records	Well Logs Available

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Well_Records	1..1	Well_LogData	1

Back to Top

Well_PetroleumData

Composite	Yes
Cardinality	One To Many
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_Records	Well_PetroDat
Key	RecrdSetID (Origin Primary Key)	RecrdsetID (Origin Foreign Key)
Labels	Well_Records	Petroleum data

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Well_Records	1..1	Well_PetroDat	M

Back to Top

Well_ProdInterval_PerfData

Composite	Yes
Cardinality	One To Many
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_PetroDat	Well_PerfIntv
Key	PrdIntvlID (Origin Primary Key)	PrdIntvlID (Origin Foreign Key)
Labels	Well_PetroDat	Well_PerfIntv

Back to Top

Well_ProductionData

Composite	Yes
Cardinality	One To Many
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_Records	Well_Productn
Key	RecrdSetID (Origin Primary Key)	RecrdsetID (Origin Foreign Key)
Labels	Well_Records	Production data

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Well_Records	1..1	Well_Productn	M

Back to Top

Well_RecordIDs

Composite	Yes
Cardinality	One To Many
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_Header	Well_Records
Key	WellDataID (Origin Primary Key)	WellDataID (Origin Foreign Key)
Labels	Well_Header	Well Records

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Well_Header	1..1	Well_Records	M

Back to Top

Well_SamplesData

Composite	Yes
Cardinality	One To Many
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_Records	Well_Samples
Key	RecrdSetID (Origin Primary Key)	RecrdsetID (Origin Foreign Key)
Labels	Well_Records	Well Samples

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Well_Records	1..1	Well_Samples	M

Back to Top

Well_TreatmentData

Composite	Yes
Cardinality	One To Many
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_Records	Well_Treatmnt
Key	RecrdSetID (Origin Primary Key)	RecrdsetID (Origin Foreign Key)
Labels	Well_Records	Well_Treatment

Back to Top

Well_TubingData

Composite	Yes
Cardinality	One To Many
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_Records	Well_Tubing
Key	RecrdSetID (Origin Primary Key)	RecrdsetID (Origin Foreign Key)
Labels	Well_Records	Well Tubing

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Well_Records	1..1	Well_Tubing	M

Back to Top

Well_XY_DatumData

Composite	Yes
Cardinality	One To One
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_Records	Well_XY_Datum
Key	RecrdSetID (Origin Primary Key)	RecrdsetID (Origin Foreign Key)
Labels	Well_Records	Horizontal Datum

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Well_Records	1..1	Well_XY_Datum	0..1

Back to Top

Well_XZYdata

Composite	Yes
Cardinality	One To Many
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_Records	Well_XYZ
Key	RecrdSetID (Origin Primary Key)	RecrdsetID (Origin Foreign Key)
Labels	Well_Records	Well_XYZ data

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Well_Records	1..1	Well_XYZ	M

Back to Top

Well_Z_DatumData

Composite	Yes
Cardinality	One To One
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_Records	Well_Z_Datum
Key	RecrdSetID (Origin Primary Key)	RecrdsetID (Origin Foreign Key)
Labels	Well_Records	Elev / Depth Datums

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Well_Records	1..1	Well_Z_Datum	0..1

Back to Top

WS_Description

Composite	Yes
Cardinality	One To One
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	WS_Interval	WS_Descrp
Key	IntrvlGUID (Origin Primary Key)	IntrvlGUID (Origin Foreign Key)
Labels	WS_Interval	WS_Descrp

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	WS_Interval	1..1	WS_Descrp	0..1

Back to Top

WS_IntervalData

Composite	Yes
Cardinality	One To Many
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_Samples	WS_Interval
Key	SamplSetID (Origin Primary Key)	SamplSetID (Origin Foreign Key)
Labels	Well_Samples	WS_Interval

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Well_Samples	1..1	WS_Interval	M

Back to Top

WS_PoreSpaceData

Composite	Yes
Cardinality	One To One
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	WS_Interval	WS_PoreSpace
Key	IntrvlGUID (Origin Primary Key)	IntrvlGUID (Origin Foreign Key)
Labels	WS_Interval	WS_PoreSpace

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	WS_Interval	1..1	WS_PoreSpace	0..1

Back to Top

WS_WaterTableData

Composite	Yes
Cardinality	One To Many
Notification	Forward
Attributed	No
	Origin	Destination
ObjectClass	Well_Samples	WS_WaterTable
Key	SamplSetID (Origin Primary Key)	SamplSetID (Origin Foreign Key)
Labels	Well_Samples	Water Table

Rules	Subtype	Origin Cardinality	Subtype	Destination Cardinality
	Well_Samples	1..1	WS_WaterTable	M

Back to Top

[return to top]