revised: 05-Feb-2015

NMBGMR Draft Geologic Data Model - v. 1.0.4
JOINED & RELATED TABLES: Geomorphic Surface Detail

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: Surfaces

This table is used to store detailed data about geomorphic surfaces and is linked to suface_poly via SurfaceID. The attributes of soil development still need work.

Field Name Field Alias Length
(text fields)
Field Type Field Value Default Allow Nulls? Attributes / Examples Description / Notes
SurfaceID " 16 String variable undefined TRUE Qtrp3 basis of relate to Surface_poly
Name " 50 String variable [null] TRUE Borrego Surface Name of surface
DrainageNm DrainageName 25 String variable [null] TRUE Drainage basin name: e.g. Rio Puerco Name of drainage associated with surface
RelAge "   Single variable [null] TRUE 1, 2, 3 etc. or 1.1, 1.2, etc. where finer subdivisions are necessary Numerical ranking of relative age within drainage, 1=oldest
SurfClass SurfaceClass 20 String CVD [null] TRUE erosional, constructional, composite Class of surface
SurfType SurfaceType 20 String CVD [null] TRUE strath, pediment, fill, fill-cut, tread, aggradational top Type of surface of specified class
SoilType " 20 String CVD [null] TRUE argillic, calcic, petrocalcic, entisols, alfisol, aridisol, etc. Type of soil developed on surface
SoilStage " 20 String CVD [null] TRUE stage: I, I+,II, II+, III, III+, IV, IV+, V, V+, VI, VI+ Degree of soil development
SurfVegTyp " 30 String CVD [null] TRUE grass, cholla, pinon-juniper, etc Dominant vegetation type
Age " 20 String variable [null] TRUE e.g. Pliocene Age of surface
AgeBasis " 50 String CVD [null] TRUE soils, geochron, etc Basis of age
IsoDateID " 50 String variable [null] TRUE sample info/link to best date data Isotopic date ID, links to Date Detail
UnitDesc UnitDescription 255 String variable [null] TRUE Unit description Description of the unit throughout the map area.