Skip to main content

Skip to navigation

The access keys for this page are:

Ministry of Energy Mines and Responsible for Core Review
Appendix L3:

Database Structure of Exported and View Files


Appendix L1: Intrface.dbf, Quickmap.dbf, Quickprj.dbf and Notices.dbf Exports
Appendix L2: Mineral.dbf, Reserve.dbf and Product.dbf Extracts
Appendix L4: Templates for MINFILE Master Reports (View Files)

 

 

A. PROJECT1.DBF (Exploration Project data)
B. PROJECT2.DBF (Notices of Work data)

 

 

The files project1.* and project2.* are for the potential 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 derived from the VIEW5000.DBF and VIEW5010.DBF files which are used as template files for Exploration Master Report generation. The files are listed here with dBASE definitions.

 

A. PROJECT1.DBF

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

Field  Field Name  Type  Width  Description                        Example
    1  PROJ_NO     Char    7    Project number                     0400536
2 PROPERTY Char 30 Property name 1 COTTONBELT
3 PROPERTY_2 Char 30 Property name 2
4 OWNER Char 30 Owner 1 Canquest Resource Corp.
5 OWNER_2 Char 30 Owner 2
6 OPERATOR Char 30 Operator Canquest Resource Corp.
7 DIST_SEQNO Char 3 District sequence number 149
8 DIST_MAPNO Char 3 District map number
9 DATUM_REF Char 6 Datum reference NAD 27
10 LATITUDE Num 9,6 Latitude in decimals 51.433333
11 LAT_HEMI Char 5 Latitude hemisphere NORTH
12 LAT_DEG Num 2 Latitude degree 51
13 LAT_MIN Num 2 Latitude minute 26
14 LAT_SEC Num 2 Latitude second 00
15 LONGITUDE Num 10,6 Longitude in decimals 118.816667
16 LONG_HEMI Char 4 Longitude hemisphere WEST
17 LON_DEG Num 3 Longitude degree 118
18 LON_MIN Num 2 Longitude minute 49
19 LON_SEC Num 2 Longitude second 00
20 LOC_ACC Char 1 Location accuracy code 1
21 LOC_ACC_D Char 20 Location accuracy description Within 500 m
22 CR_DATE Char 8 Coded date 08091994
23 RV_DATE Char 8 Revised date 08181994
24 CHECKED_BY Char 5 Checked by MS
25 NOW_NOS Char 50 Notice of work number 1994-0001 1995-0001
26 MINFILNO Char 9 MINFILE number 082M 086
27 MINFILNO1 Char 9 MINFILE number 1
28 NAME1 Char 30 MINFILE name 1 COTTONBELT
29 MINFILNO2 Char 9 MINFILE number 2
30 NAME2 Char 30 MINFILE name 2
31 MINFILNO3 Char 9 MINFILE number 3
32 NAME3 Char 30 MINFILE name 3
33 MINFILNO4 Char 9 MINFILE number 4
34 NAME4 Char 30 MINFILE name 4
35 PRJTYP_C Char 1 Project type code 1
36 PRJTYP_D Char 20 Project type description Major property
37 MINFILNO5 Char 9 MINFILE number 5
38 MINFILNO6 Char 9 MINFILE number 6
39 MINFILNO7 Char 9 MINFILE number 7
40 MINFILNO8 Char 9 MINFILE number 8
41 MINFILNO9 Char 9 MINFILE number 9
42 MINFILNO10 Char 9 MINFILE number 10
43 MINFILNO11 Char 9 MINFILE number 11
44 MINFILNO12 Char 9 MINFILE number 12
45 MINFILNO13 Char 9 MINFILE number 13
46 MINFILNO14 Char 9 MINFILE number 14
47 MINFILNO15 Char 9 MINFILE number 15
48 MINFILNO16 Char 9 MINFILE number 16
49 MINDIV_C1 Char 4 Mining division code KAML
50 MINDIV_D1 Char 15 Mining division description 1 Kamloops
51 MINDIV_C2 Char 4 Mining division code 2
52 MINDIV_D2 Char 15 Mining division description 2
53 NTSMAP_C1 Char 7 NTS Map 1 082M07W
55 NTSMAP_C2 Char 7 NTS Map 2
55 NTSMAP_C3 Char 7 NTS Map 3
56 NTSMAP_C4 Char 7 NTS Map 4

57 REGION_C1 Char 4 Region code 1 BC
58 REGION_C2 Char 4 Region code 2
59 REGION_C3 Char 4 Region code 3
60 REGION_C4 Char 4 Region code 4
61 REGION_D1 Char 50 Region description 1 British Columbia
62 REGION_D2 Char 50 Region description 2
63 REGION_D3 Char 50 Region description 3
64 REGION_D4 Char 50 Region description 4
** Total **              879                    

B. PROJECT2.DBF

Template for Notices of Work data; it is written to the \MINFILE\WORK directory.

Field  Field Name  Type  Width  Description                        Example
    1  PROJ_NO     Char    7    Project number                     0400536
2 NOW_NO Char 9 Notice of work number 1994-0001
3 NOTIC_TYP Char 1 Notice type code M
4 NOTIC_DESC Char 20 Notice type code Mineral
5 RECVD_DATE Char 8 Received date 06271994
6 APRV_DATE Char 8 Approved date 07311994
7 OPERATOR Char 30 Operator Canquest Resource Corp.
8 MANAGER Char 30 Manager
9 MGR_TEL Char 14 Manager telephone (604) 666-8888
10 DEP_TARGET Char 60 Deposit target Massive sulphides
11 WK_TODO Char 70 Work to do Geophysic,Geological,Linecut,Camp
10 ddh, blast
12 WK_DONE Char 70 Work done
13 WK_START Char 8 Work start 07251994
14 WK_END Char 8 Work end 10311994
15 EXP_BUD Char 13 Exploration budget
16 PROD_BUD Char 13 Production budget
17 COMPLETED Char 1 Completed N
18 DISCUSSED Char 1 Discussed N
19 MDSCREV Char 1 MDSC Review N
20 STAGE_C Char 1 Stage code
21 STAGE_D Char 30 Stage description
   ** Total **              404