Ministry of Energy and Mines
MDBC Views

MDBC Views
Exploration Views
Master Views

 

Database Structure of Exported and View Files
2. Mineral.dbf, Reserve.dbf and Product.dbf Extracts
MINFILE User's Manual: Appendix L2

 

MINFILE User's Manual Appendices Index
MINFILE User's Manual Table of Contents
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

MINFILE User's Manual Appendices Index
MINFILE User's Manual Table of Contents