Skip to main content

Skip to navigation

The access keys for this page are:

Ministry of Energy Mines and Responsible for Core Review

Appendix L1: Database Structure of Exported and View Files


 

Appendix L2: Mineral.dbf, Reserve.dbf and Product.dbf Extracts
Appendix L3: Project1.dbf and Project2.dbf Extracts
Appendix L4: Templates for MINFILE Master Reports (View Files)

 

 

A: INTRFACE.DBF (Template for MINFILE Standard Data File)
B: QUICKMAP.DBF (Template for plotting MINFILE data in QUIKMap)
C: QUICKPRJ.DBF (Template for plotting Project data in QUIKMap)
D: NOTICES.DBF (Template for transferring Notices of Work data)

 

 

A. INTRFACE.DBF

Template for MINFILE Standard Data File (.SDF, .DBF, .WKS formats).

Field Field Name Type Width Description         Example   
1  MINFILNO   Char   9   MINFILE number         104B  008   
2 NAME1 Char 30 MINFILE name ESKAY CREEK
3 COMMOD_C1 Char 2 Commodity 1 AU
4 COMMOD_C2 Char 2 Commodity 2 AG
5 COMMOD_C3 Char 2 Commodity 3 ZN
6 COMMOD_C4 Char 2 Commodity 4 ZN
7 COMMOD_C5 Char 2 Commodity 5 PB
8 COMMOD_C6 Char 2 Commodity 6
9 COMMOD_C7 Char 2 Commodity 7
10 COMMOD_C8 Char 2 Commodity 8(* if more)
11 MINDIV_C1 Char 4 Mining division code SKEE
12 MINDIV_D1 Char 15 Mining division desc. Skeena
13 STATUS_C1 Char 4 Deposit status code PROD
14 STATUS_D1 Char 20 Deposit status desc. Producer
15 DEPTYP_C1 Char 5 Deposit type code G07
16 DATUM_REF Char 6 Datum reference NAD 27
17 UTM_ZONE1 Num 2 UTM zone 09
18 UTM_EAST1 Num 6 UTM easting 411052
19 UTM_NORT1 Num 8 UTM northing 6277299
20 NTSMAP_C1 Char 7 NTS map 104B09W

21 LATITUDE Num 9,6 Latitude in decimals 56.633333

22 LAT_DEG1 Num 2 Latitude degrees 56
23 LAT_MIN1 Num 2 Latitude minutes 38
24 LAT_SEC1 Num 2 Latitude seconds 0
25 LAT_HEMI Char 5 Latitude hemisphere NORTH

26 LONGITUDE Num 10,6 Longitude in decimals 130.450000
27 LONG_DEG1 Num 3 Longitude degrees 130
28 LONG_MIN1 Num 2 Longitude minutes 27
29 LONG_SEC1 Num 2 Longitude seconds 0
30 LONG_HEMI Char 4 Longitude hemisphere WEST
31 ELEV
Num
4 Elevation in metres 1600
32 REGION_C1 Char 4 Region code 1 BC
33 REGION_C2 Char 4 Region code 2
34 REGION_C3 Char 4 Region code 3
35 REGION_C4 Char 4 Region code 4
36 REGION_D1 Char 50 Region description 1 British Columbia
37 REGION_D2 Char 50 Region description 2
38 REGION_D3 Char 50 Region description 3
39 REGION_D4 Char 50 Region description 4
** Total **           394
new to Version 4.5

B. QUICKMAP.DBF             

Template for plotting MINFILE data in QUIKMap.

Field Field Name Type Width Description         Example   
1  DATA_TYPE  Char   1   Data type              S   
2 KEY Char 10 Relational key 104B 008

3 DATUM_REF Char 6 Datum reference NAD 27

4 MN_ZONE Num 2 UTM zone 9
5 MN_NORTH Num 8 UTM northing 6277299
6 MN_EAST Num 6 UTM easting 411052
7 MN_LAT_DEG Num 2 Latitude degrees 56
8 MN_LAT_MIN Num 2 Latitude minutes 38
9 MN_LAT_SEC Num 2 Latitude seconds 0

10 LAT_HEMI Char 1 Latitude hemisphere N

11 MN_LON_DEG Num 3 Longitude degrees 130
12 MN_LON_MIN Num 2 Longitude minutes 27
13 MN_LON_SEC Num 2 Longitude seconds 0

14 LONG_HEMI Char 1 Longitude hemisphere W
15 ELEV Num 4 Elevation in metres 1600

16 SYM_LN_TYP Num 2 Symbol type 57
17 SIZE_THICK Num 3 Symbol size 5
18 DATA_COLOR Num 3 Symbol colour 15
19 HATCH_PATT Num 2 Fill pattern 0
20 LBL_TEXT Char 30 Label text ESKAY CREEK
21 LBL_SIZE Num 3 Label size 5
22 LBL_COLOR Num 3 Label colour 15
23 LBL_FONT Char 8 Label font
24 LBL_ANGLE Num 5,1 Label rotation 0.0
25 OPERATION Char 5 Operation field
26 MAP_INDEX Char 6 NTS map 104B
27 STATION Char 3 Map number 008
28 STATUS Char 4 Deposit status code PROD
29 NAME Char 30 MINFILE name ESKAY CREEK
30 COMMODITYS Char 30 Commodities AU,AG,ZN,CU,PB
31 DEP_TYPE Char 5 Deposit type code G07
32 NTS_MAPNO Char 7 NTS map 104B09W
** Total **           202          

C. QUICKPRJ.DBF   

Template for plotting Project data in QUIKMap.

Field Field Name Type Width Description        Example   
1  DATA_TYPE  Char   1   Data type              S   
2 KEY Char 7 Relational key 0100073

3 DATUM_REF Char 6 Datum reference NAD 27

4 MN_LAT_DEG Num 2 Latitude degrees 56
5 MN_LAT_MIN Num 2 Latitude minutes 38
6 MN_LAT_SEC Num 2 Latitude seconds 0

7 LAT_HEMI Char 1 Latitude hemisphere N

8 MN_LON_DEG Num 3 Longitude degrees 130
9 MN_LON_MIN Num 2 Longitude minutes 27
10 MN_LON_SEC Num 2 Longitude seconds 0

11 LONG_HEMI Char 1 Longitude hemisphere W
12 ELEV Num 4 Elevation in metres 1600

13 SYM_LN_TYP Num 2 Symbol type 3
14 SIZE_THICK Num 3 Symbol size 5
15 DATA_COLOR Num 3 Symbol colour 15
16 HATCH_PATT Num 2 Fill pattern 1
17 LBL_TEXT Char 30 Label text ESKAY CREEK
18 LBL_SIZE Num 3 Label size 5
19 LBL_FONT Char 8 Label font
20 LBL_ANGLE Num 5,1 Label rotation 0.0
21 LBL_COLOR Num 3 Label colour 15
22 OPERATION Char 5 Operation field
23 PROPERTY Char 30 Project name ESKAY CREEK
24 OWNER Char 30 Property owner Prime Resources Group Inc.
25 OPERATOR Char 30 Property operator Prime Resources Group Inc.
26 PROJTYPE_C Char 1 Project type code 1
27 PROJTYPE_D Char 20 Project type desc. Major property
28 DIST_SEQNO Char 3 Sequence number 40
29 DIST_MAPNO Char 3 Map number 122
30 MINDIV_C Char 4 Mining Division SKEE
31 NTSMAP_C Char 7 NTS map 104B09W
32 NOW_NO Char 9 Notice of Work number 1995-0001
33 DEP_TARGET Char 60 Deposit target Gold, Silver; VMS
34 STAGE_C Char 1 MDAP stage code 5
35 STAGE_D Char 15 MDAP stage description Completed
36 MINFILENO Char 9 MINFILE number 104B 008
37 NAME Char 30 MINFILE name ESKAY CREEK
38 COMMODITYS Char 30 Commodities AU,AG,ZN,CU,PB
39 DEP_TYPE Char 5 Deposit type I02
40 STATUS Char 4 Deposit status PROD
** Total **           389          

D. NOTICES.DBF     

Template for transferring Notices of Work data from MIS into the  Exploration Database. MIS exports the file as MISDATA.DBF, which  is copied to NOTICES.DBF in the \MINFILE\TEMP directory.

Field Field Name Type Width Description         Example   
1  NOW_NO     Char  17   Notice of Work number  1995-0100073-0001   
2 XMIT_IND Char 1 Transmission id.
3 NOTIC_TYP Char 1 Notice of Work type M
4 RECVD_DATE Char 8 Date received 19950526
5 APRV_DATE Char 8 Date approved 19950529
6 PROPERTY Char 30 Property name ESKAY CREEK
7 OWNER Char 30 Property owner Prime Resources
8 OPERATOR Char 30 Property operator Prime Resources
9 MANAGER Char 30 Property manager
10 MGR_TEL Char 14 Manager's phone number
11 NTSMAP Char 7 NTS map 104B09W
12 MINDIV Char 4 Mining Division Skee
13 LAT_DEG Char 2 Latitude degrees 56
14 LAT_MIN Char 2 Latitude minutes 38
15 LAT_SEC Char 2 Latitude seconds 0
16 LON_DEG Char 3 Longitude degrees 130
17 LON_MIN Char 2 Longitude minutes 27
18 LON_SEC Char 2 Longitude seconds 0
19 WK_TODO Char 70 Work to do Blasting,Geochemic,Geological
20 WK_START Char 8 Work start date 19950630
21 WK_END Char 8 Work end date 19951130
** Total **           280