Appendix E

DIGITAL DATABASE

The following data model relates to Figure 8 and Tables 11 and 12 in the Guidelines and Standards for Terrain Mapping in British Columbia (this volume). Minimum terrain data requirements are highlighted with an asterisk in the left column.

TASK FORCE: Earth Sciences, Surficial Geology Task Group

PARENT ENTITY: Surficial Geology

ENTITY GROUP: Terrain Map [TERRMAP]

ENTITY GROUP DEFINITION: A Terrain Map shows the distribution of surficial (Quaternary) deposits on the Earth's surface. It also provides information on the characteristics of the surficial materials, landforms and geological and geomorphological processes. Physical properties and conditions of the land surface can be inferred from these data.

ENTITY NAME: General Terrain Map lnformation [MAPlNFO]

ENTITY DEFINlTION: General Terrain Map lnformation identifies the project, the terrain map and report, and the base map. It provides general information on the mapping and the physical setting.

FIELD/ATTRIBUTE

DATA TYPE

COMMENTS/EXAMPLES/ REFERENCES TO VALUE LISTS

1. Project identification [PROJID]

*	NAME OF SENIOR MAPPER	Text (String)
	NAME OF ASSlSTANT(S)	Text (String)
*	AGENCY ORGANIZATION	Text (String)	of mappers
*	PROJECT NAME	Text (String)
	PROJECT NUMBER	Text (String)	often an alphanumeric mix
	PRIME PURPOSE OF MAPPING	Text (String)	e.g. forestry, urban planning
	CLlENT/AGENCY	Text (String)
*	MONTH/YEAR OF PUBLICATION	Text (Date)
	MONTH/YEAR OF REVISION(S)	Text (Date)
	COMMENTS	Text (String)

2. Terrain Map/Report Identification [TMRID]

*	MAP TITLE	Text (String)
*	MAP LEGEND	Text (String)
*	MAP MARGINAL NOTES	Text (String)	* if no report
	ABSTRACT	Text (String)
	REPORT	Text (String)
	REFERENCES	Text (String)
	ACKNOWLEDGMENTS	Text (String)
	ARCHIVAL LOCATION	Text (String)	of original
	COMMENTS	Text (String)

3. Base Map ldentification [BASEID]

*	NTS MAP NUMBER(S)	Text (String)	NTS or BCGS/TRIM, not both
*	BCGS/TRIM MAP NUMBER	Text (String)
	OTHER BASE MAP	Text (String)	other than NTS or BCGS/TRIM
	MAP NAME	Text (String)
*	MAP SCALE	Numeric (Real)
	MAP DATUM	Text (String)	e.g. NAD 27, NAD 83
	CONTOUR INTERVAL	Numeric (lnteger)

	METRES/FEET	Text (String)
	RANGE OF LATITUDE (D/M/S)	Numeric (Integer)
	RANGE OF LONGITUDE (D/M/S)	Numeric (Integer)
*	MAP NORTH ARROW	Graphic
*	MAP BAR SCALE	Graphic
	BASE MAP SYMBOLS	Graphic
*	INDEX MAP	Graphic	* if no report
	DIGITAL MAP BASE	Text (String)	e.g. ARCINFO, Terrasoft
	ARCHIVAL LOCATION	Text (String)	of Digital Map Base
	COMMENTS	Text (String)

4. General Mapping Information [GENINFO]

*	MONTH/YEAR OF MAPPING	Text (Date)
	RG OF MAPPING (LATS) (D/M/S)	Numeric (Integer)	if different than base map
	RG OF MAPPING (LONGS) (D/M/S)	Numeric (Integer)	if different than base map
	RG OF MAPPING (UTM ZONE)	Numeric (Integer)	lat/long or UTM, not both
	RG OF MAPPING (UTM EAST)	Numeric (Integer)
	RG OF MAPPING (UTM NORTH)	Numeric (Integer)
	AIRPHOTO (FT LINES & NOS.)	Text (String)
	YEAR OF AIRPHOTOS	Text (Date)
	APPROX AIRPHOTO SCALE	Numeric (Real)
*	TERRAIN SURVEY INTENSITY LEVEL	Text (String)	this document Table 7
	POLYGONS FIELD CHECKED %	Numeric (Integer)
	FIELD CHECKS/100 HA	Numeric (Integer)
	COMMENTS	Text (String)

5. General Physical Setting [PHYSET1]

	PHYSIOGRAPHICAL REGION	Text (String)	Holland, 1976; MOE, 1990
	BIOGEOCLIMATIC ZONE	Text (String)	MOF, 1988; MOE, 1990
	COMMENTS	Text (String)

CURRENT SOURCES: Ministry of Energy, Mines and Petroleum Resources, Ministry of Environment, Ministry of Forests, Ministry of Transportation and Highways, Forest Companies, and Regional Districts

CUSTODIAN AGENCY: Ministry of Energy, Mines and Petroleum Resources

COMMENTS: Other Entities associated with General Terrain Map information [MAPINFO] in the Terrain Map Entity Group [TERRMAP] include Polygon [MAPPOLY] and Terrain Unit [MAPUNIT]. Surficial Geology Symbols are also related. The Terrain Map Entity Group [TERRMAP] is also associated with the Observation/Sample Site Entity Group [TERRSITE].