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. |