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:
Structural Provinces of North America.
RETURN TO: