revised: 05-Feb-2015

NMBGMR Draft Geologic Data Model - v. 1.0.4
Points: Well Spots

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.

Feature Class: Well_point

This feature class represents wells of all types. This feature class is suitable for storing the location, name, symbology, and TD of a well that will appear on a geologic map. For more detailed well data, use our Well Data Model instead.

Field Name Field Alias Length
(text fields)
Field Type Field Value Default Allow Nulls? Attributes / Examples Description / Notes
Well_ID " 50 String variable [null] TRUE 30-035-00013, EB-34 Well identifier: Use API (if exists) or well name & number. To be used only for display, not for joins/relates.
API " 12 String variable [null] TRUE 30-035-00013 Well API number (unique ID)
(does not include suffix for multiple completions). Format is: statecode-countycode-well#). Field may contain multiple NULLs for wells without API.
FGDC_code " 16 String variable [null] TRUE 30.3.12 FGDC geologic symbol reference number for well-spot symbol.
WellClass " 16 String CVD [null] TRUE unspecified, petroleum, mineral, water, geothermal, coal, strat-test, other Current class of well
WellType " 16 String CVD [null] TRUE oil, gas, injection, disposal, monitoring, domestic, municipal, supply, multi-use, scientific, mining, storage, other Current Type of well of specified class.
TotalDepth "   Single variable [null] TRUE 1000 Most current total depth of well
Well_TVD "   Single variable [null] TRUE 1000 Total Vertical Depth of well at TD.
SourceID " 128 String variable [null] TRUE unknown; unspecified; Smith, 2006b [variable] Source ID for bibliographic information about this record. PK for basis or relationship with bibligraphic citation.
DsplyScale DisplayScale   Long Integer CVD 24000 TRUE see: DisplayScale Denominator of display scale: display feature at scales larger than number specified (=< denominator). Zero indicates data that should never be displayed.
Comments " 255 String variable [null] TRUE