Skip to main content

Skip to navigation

The access keys for this page are:

Ministry of Energy Mines and Responsible for Core Review

Appendix L2:

 Database Structure of Exported and View Files

 

Appendix L1: Intrface.dbf, Quickmap.dbf, Quickprj.dbf and Notices.dbf Exports
Appendix L3: Project1.dbf and Project2.dbf Extracts
Appendix L4: Templates for MINFILE Master Reports (View Files)

 

 

A: MINERAL.DBF (Mineral occurrence data)
B: RESERVE.DBF (Inventory data)
C: PRODUCT.DBF (Total production data)

 

The files mineral.*, reserve.* and product.* are for the use of Mineral Data BC and general Geographical Information Systems (GIS). The files can also be used for custom reports with database management software, such as dBASE or Excel. The Extracts are available in three formats: comma delimited (.MBC), dBASE (.DBF) and spreadsheet (.WKS). They are written to the \MINFILE\WORK directory. The files are listed here with dBASE definitions.

A. MINERAL.DBF

Template for mineral occurrence data; it is written to the \MINFILE\WORK directory.

Field Field Name Type Width Description                      Example
   1  MINFILNO   Char   9   MINFILE number                   082FNW071
2 NAME1 Char 30 MINFILE name 1 WILLA (L.1529)
3 NAME2 Char 30 MINFILE name 2 ROCKLAND GROUP
4 STATUS_C Char 4 Deposit status code PAPR
5 STATUS_D Char 20 Deposit status description Past Producer
6 LATITUDE Num 9,6 Latitude in decimals 49.883333
7 LAT_DEG Num 2 Latitude degrees 49
8 LAT_MIN Num 2 Latitude minutes 53
9 LAT_SEC Num 2 Latitude seconds 00
10 LAT_HEMI Char 1 Latitude hemisphere N
11 LONGITUDE Num 10,6 Longitude in decimals -117.367778
12 LONG_DEG Num 3 Longitude degrees 117
13 LONG_MIN Num 2 Longitude minutes 22
14 LONG_SEC Num 2 Longitude seconds 04
15 LONG_HEMI Char 1 Longitude hemisphere W
16 UTM_ZONE Num 2 UTM zone 11
17 UTM_EAST Num 6 UTM easting 473579
18 UTM_NORT Num 8 UTM northing 5525724
19 ELEV Num 4 Elevation 1220
20 COMMOD_C1 Char 2 Commodity code 1 AU
21 COMMOD_C2 Char 2 Commodity code 2 CU
22 COMMOD_C3 Char 2 Commodity code 3 AG
23 COMMOD_C4 Char 2 Commodity code 4 ZN
24 COMMOD_C5 Char 2 Commodity code 5 PB
25 COMMOD_C6 Char 2 Commodity code 6 MO
26 COMMOD_D1 Char 30 Commodity description 1 Gold
27 COMMOD_D2 Char 30 Commodity description 2 Copper
28 COMMOD_D3 Char 30 Commodity description 3 Silver
29 COMMOD_D4 Char 30 Commodity description 4 Zinc
30 COMMOD_D5 Char 30 Commodity description 5 Lead
31 COMMOD_D6 Char 30 Commodity description 6 Molybdenum
32 DEPTYP_C1 Char 5 Deposit type code 1 L01
33 DEPTYP_C2 Char 5 Deposit type code 2 K04
34 DEPTYP_D1 Char 50 Deposit type description 1 Subvolcanic Cu-Ag-Au (As-Sb)
35 DEPTYP_D2 Char 50 Deposit type description 2 Au skarn
36 DEPCHR_C1 Char 2 Deposit character code 1 03
37 DEPCHR_C2 Char 2 Deposit character code 2 04
38 DEPCHR_D1 Char 20 Deposit character description 1 Breccia
39 DEPCHR_D2 Char 20 Deposit character description 2 Pipe
40 DEPCLA_C1 Char 2 Deposit classification code 1 16
41 DEPCLA_C2 Char 2 Deposit classification code 2 07
42 DEPCLA_D1 Char 15 Deposit classification desc. 1 Diatreme
43 DEPCLA_D2 Char 15 Deposit classification desc. 2 Hydrothermal
44 TECBLT_C Char 2 Tectonic belt code OM
45 TECBLT_D Char 18 Tectonic belt description Omineca
46 TERRAN_C Char 3 Terrane code QN
47 TERRAN_D Char 30 Terrane decription Quesnel
48 NTSMAP_C1 Char 7 NTS Map 1 082F14W
49 NTSMAP_C2 Char 7 NTS Map 2
50 NTSMAP_C3 Char 7 NTS Map 3
51 NTSMAP_C4 Char 7 NTS Map 4
52 PRODUCTN Char 1 Does production exist? Y
53 RESERVES Char 1 Does inventory exist? Y
54 REGION_C1 Char 4 Region code 1 BC
55 REGION_D1 Char 50 Region description 1 British Columbia
56 REGION_C2 Char 4 Region code 2
57 REGION_D2 Char 50 Region description 2
58 DATUM_REF Char 6 Datum reference NAD 83
** Total **           725

B. RESERVE.DBF

Template for inventory data; it is written to the \MINFILE\WORK directory.

Field Field Name Type Width Description                     Example
   1  MINFILNO   Char   9   MINFILE number                  082FNW071
2 NAME Char 30 MINFILE name WILLA (L.1529)
3 OREZON_C Char 5 Ore zone code 96314
4 OREZON_D Char 30 Ore zone description MAIN AND EAST
5 YEAR Char 4 Year 1988
6 RESCAT_C Char 2 Inventory category code CB
7 RESCAT_D Char 30 Inventory category description Combined
8 A_OR_B Char 1 A or B calculation A
9 GRADE1 Num 9,4 Grade 1 6.0300
10 GRADE2 Num 9,4 Grade 2 0.9200
11 GRADE3 Num 9,4 Grade 3
12 GRADE4 Num 9,4 Grade 4
13 GRADE5 Num 9,4 Grade 5
14 GRADE6 Num 9,4 Grade 6
15 QUANTITY Num 12 Quantity 219518
16 RESERV_T Char 140 Reserve comment Probable and possible at grades
similar to the West zone.
17 RESREF_T Char 70 Reserve reference George Cross News Letter October 24, 1988.
18 COMMOD_C1 Char 2 Commodity code 1 AU
19 COMMOD_C2 Char 2 Commodity code 2 CU
20 COMMOD_C3 Char 2 Commodity code 3
21 COMMOD_C4 Char 2 Commodity code 4
22 COMMOD_C5 Char 2 Commodity code 5
23 COMMOD_C6 Char 2 Commodity code 6
24 COMMOD_D1 Char 30 Commodity description 1 Gold
25 COMMOD_D2 Char 30 Commodity description 2 Copper
26 COMMOD_D3 Char 30 Commodity description 3
27 COMMOD_D4 Char 30 Commodity description 4
28 COMMOD_D5 Char 30 Commodity description 5
29 COMMOD_D6 Char 30 Commodity description 6
30 REPORT_ON Char 1 Report on Y
** Total **           581

C. PRODUCT.DBF

Template for total production data; it is written to the \MINFILE\WORK directory.

Field Field Name Type Width Description                    Example
   1  MINFILNO   Char   9   MINFILE number                 082FNW071
2 NAME Char 30 MINFILE name WILLA (L.1529)
3 MINED Num 12 Tonnes mined 795
4 MILLED Num 12 Tonnes milled 495
5 QUANTITY1 Num 12 Quantity 1 7883
6 QUANTITY2 Num 12 Quantity 2 63
7 QUANTITY3 Num 12 Quantity 3 4154
8 QUANTITY4 Num 12 Quantity 4 2873
9 QUANTITY5 Num 12 Quantity 5 4418
10 QUANTITY6 Num 12 Quantity 6
11 QUANTITY7 Num 12 Quantity 7
12 QUANTITY8 Num 12 Quantity 8
13 COMMOD_C1 Char 2 Commodity code 1 AG
14 COMMOD_C2 Char 2 Commodity code 2 PB
15 COMMOD_C3 Char 2 Commodity code 3 ZN
16 COMMOD_C4 Char 2 Commodity code 4 AU
17 COMMOD_C5 Char 2 Commodity code 5 CU
18 COMMOD_C6 Char 2 Commodity code 6
19 COMMOD_C7 Char 2 Commodity code 7
20 COMMOD_C8 Char 2 Commodity code 8
21 COMMOD_D1 Char 30 Commodity description 1 Silver
22 COMMOD_D2 Char 30 Commodity description 2 Lead
23 COMMOD_D3 Char 30 Commodity description 3 Zinc
24 COMMOD_D4 Char 30 Commodity description 4 Gold
25 COMMOD_D5 Char 30 Commodity description 5 Copper
26 COMMOD_D6 Char 30 Commodity description 6
27 COMMOD_D7 Char 30 Commodity description 7
28 COMMOD_D8 Char 30 Commodity description 8
29 F_YEAR Char 4 First year mined 1899
30 L_YEAR Char 4 Last year mined 1988
** Total **           424