THE NORMIN DATABASE-CHURCHILL PROVINCE
    This file is located at http://publish.uwo.ca/~wrchurch/505/normin.htm
 
 
    NORMIN.DB - NWT Geology Division, Northern Minerals Database at www.inacnt.internorth.ca
    Username: inacwebuser
    Password: inacwebuser
    Email: normindb@inac.gc.ca
    Database on 3.5 disk is in HA5

    The original A:diskette (NORMIN-X.exe; readme.txt, NORMIN.rtf) is in HOME HA5. Read the NORMIN.rtf file on this diskette for the file descriptions.
    The unzipped Excel files basic75m.xls, basic76.xls, and basic_md.xls, are  located in three folders c:\aacrse\505\gscmap\normin\075m,076,deposits. The NMI ID data for Kennedy Lake 075MSE0039 (row 28) in basic75m.xls.,csv, etc, in folder 075m was misplaced, and has been corrected.   All single quotes, e.g. 1950's in 075MSE0019 record 13, and double quotes (") around words were also removed.  These corrections were also applied to the .csv (comma delimited) files. The dbf files are version 4; they have not been corrected.
    An unzipped copy of the corrected files in folders '075M', '076G', and 'Deposits' has been archived on CHURCH1 and PONTY  in c:\aacrse\505\gscmap\normin, in //EarthSci/Public/505/normin (Departmental Server), and http://instruct.uwo.ca/earth-sci/wrchurch/505/normin (University server).
 
    The fields in basic75m.xls, basic76.xls, and basic_md.xls files were then modified to comply with the field arrangement in Fieldlog.  The field arrangement in the original file basic75m.xls is:

    NTS
    ID
    Name
    Latitude
    Longitude
    Province
    Commodities
    Development Stage(s)
    CANMINDEX ID
    NMI ID
    Date Record Created
    Location
    Location Accuracy
    General Comment
    Access
    Regional Defm/Metm
    Lithotectonic Setting

    which in comma delimited form would be:

NTS,ID,Name,Latitude,Longitude,Province,Commodities,Development Stage(s),CANMINDEX ID,NMI ID,Date Record Created,Location,Location Accuracy,General Comment,Access,Regional Defm/Metm,Lithotectonic Setting

    For importation into Fieldlog, a Statype and Elevation field were added, and the new and old fields were ordered as follows:

    Latitude
    Longitude
    Elevation (new field, 0)
    ID (moved)
    Statype (new field, outcrop)
    Name (moved)
    NTS (moved)
    Province
    Commodities
    Development Stage(s)
    CANMINDEX ID
    NMI ID
    Date Record Created
    Location
    Location Accuracy
    General Comment
    Access
    Regional Defm/Metm
    Lithotectonic Setting

        A record (row 63) for the city of Yellowknife was also added to basic75m.xls, and the modified files were saved as  bsc75md.xls, txt; bsc76md.xls, txt; and bscmdmd.xls,txt, in c:\fieldlog\normin, (Public)i:\fieldlog\normin g:\normin and http://instruct.uwo.ca/earth-sci/wrchurch/505/fieldlog/normin. Note: when EXCEL saves the files as comma delimited .csv or tab delimited files, any text fields containing a comma in the text will be enclosed in quotes, but not otherwise.  The quotes are not evident in the EXCEL file itself however. After saving, rename the .csv files with a .txt extension.

        IMPORTING THE TEXT FILES INTO FIELDLOG

    Number of records that Fieldlog reports importing:
    basic_md = 183; bsc75md = 62; basic76g - 122; geol_md = 244; geol75m = 72; geol76g = 243
    Number of records in Excel file:
    basic_md = 183; bsc75md = 62; basic76g - 122; geol_md = 244; geol75m = 72; geol76g = 243

     Any single quotes in any field to be imported into Fieldlog  e.g. " 1950's ", must be removed  before importation.
     The first two fields must be in the order lat, long. When imported into Fieldlog they will be automatically converted into the order long, lat, because longitude = X and latitude = Y. Consequently,  the first two fields in Fieldlog should be listed in the order (long, lat).  On the other hand UTM coordinates in Fieldlog should be in the order  UTMX and UTMY.
    To convert the lat, longs to Lambert Conformal conical coordinates (parallels 49 and 77N; origin 95W, 49N; metres;clarke 1866) setup  lamblong, lamblat, lambz numeric fields (12, 2 decimals), create a lambert conformal projection (gsclamb), and make a 'gsclamb' projection set in STATI  'Points', in Fieldlog, before importing the data. To confirm that the conversion is correct check that the record for Yellowknife at -114.527, 62.491 plots correctly on the digital map (see below).
    Make sure there are a sufficient number of characters for each field; if ID is a character string, query with NOT= 0.  If any of the fields are extended text fields, set the field length to 254 characters,  make the field into which the text is to be imported a MEMO field, and re-register the table containing the field.  Note: the maximum number of characters that can be imported in any field is 254 (this is also true of Access files), and there can only be one memo field in any given table.

        Deriving the Churchill Map from the Digital Geological Map of Canada

   On the digital Geological Map of Canada, the Slave Province is incorporated into the Churchill Province .SHP files. The ArcView source files for the Churchill and Grenville provinces have been copied to c:\aacrse\505\gscmap\gscmap\shp\chu and to iomegaGISdiskette\gscmap\shp\chu.
    The Churchill .DWG files created in  Autocad map from the source files are in c:\aacrse\505\gscmap\churdwg\dwg, (public) i:\505\gscmap\churdwg\dwg\,and church1cd:\chur\dwg (rivshore.dwg, lakschur.dwg, gscunits.dwg, faultschur.dwg, boundchur.dwg, archvolcchur.dwg, archsedchur.dwg, archmetchur.dwg, archintchur.ndchur) for the Lambert conformal conical projection, and  faultschurltlg.dwg, topochurltlg., unitschurchltlg in c:\aacrse\505\gscmap\churlatlong\  for the lat-long projection.
     The gscunits.dwg file in folder c:\fieldlog\normin, (Public)i:\fieldlog\normin contains the data from the roxchuun.asx, rivchu..., lakeschu...faultchur  source files as individual layers, as well as  solid fill layers for archvolcchur, archsedchur., archmetchur., archintchur, and the stati and statype layers created by Fieldlog.  Several combinations of layers have been created using the Layer Manager in BONUS, e.g. topoall+stati contains the lakes, rivers, boundaries, faults, stati.. and the arch..chur layers.


     To setup the Excel ODBC and access an Excel file from Autocad Map see AskSam key[ Excel Autocad_Map].

     To import a layer from an external .DXF file, attach the file (Map -> Drawings -> Define/Modify Drawing set, etc) and query the layer via Map -> Query -> Define Query -> Property -> Layer -> Values -> select the layer(s) to import. Note that once a layer has been added to the current drawing, it cannot be deleted from layer list.

     Access
     To open a .dbf file or Excel in Access; either click the Blank database button in the Microsoft Access box following by OK or open a new file with File -> New Database. A NEW window will appear with a 'Blank Database' icon in the General folder. Double click the icon to fetch the 'File New Database' window. Click the 'Create button to get the db2:Database window. Import the DBF file with File -> Get External Database -> Import. In the Import window select dBASE 4 or EXCEL in the 'Files of Type' scroll down, and select the folder containing the dbf or xls file to import. Double click the file name. A report will appear saying the import was successful, and the file name and icon will appear in the db2:Database window. Close the Import window and double click the icon to reveal the data

     Comments (cut and paste this into an email to normindb@inac.gc.ca, if you like, or
mail: Geology Division, Box 1500, Yellowknife, NT, x1a 2r3 or
phone: 867 669 2646 or 2645 or
fax: 867 669 2725):

The file format I used (out of csv, xls, dbf, dif) was:

The spreadsheet or database program I used it with was:

I wish you had this file format:

I couldn't use any of your formats:

I couldn't decompress your zipfile because:

The most important data fields you had (besides lat-long and commodities) were:

I want you to include these important data fields next time:

Problems I had:
 

FIGURES:

   Structural Provinces of North America.

   Geological map.

   Gold linears.

   RETURN TO:

   Click here to return to beginning.

   Click here to return to course outline.