Click here to go to 'Figures/Overheads' section.

Click here to return to course outline.

Click here to return to W.R. Church's home page.

Click here to return to Earth Science course list.

 
IMPORTING AN ASCI COMMA-DELIMITED STATI AND LITHO DATA SET INTO FIELDLOG V. 3/ACAD R12 C3/DOS (W95).

	The object of the exercise is to setup an empty Snowlake database, modify the STATI 
and LITHO tables of the database by adding and rearranging fields in these tables, create a USER 
to UTM transformation algorithm, and input two ASCII comma delimited data files into the 
STATI and LITHO tables.

COPY AN EMPTY FIELDLOG DATABASE FILE AND THE "STATI" AND "LITHO" 
DATA FILES TO YOUR FIELDLOG SUBDIRECTORY.
	In following these instructions do not enter the quotes symbol (") unless explicitly told 
to do so.

	Make a subdirectory "c:\flyourinitials" by typing "md flyourinitials", where 
"yourinitials" really means the initials of your name, not "yourinitials", e.g. "md flwrc".
	Change to "c:\flyourinitials" with the command "cd flyourinitials", e.g. "cd flwrc".
	Copy the sample Fieldlog file  to this directory with the command "copy 
c:\snowemp\snowemp.exe".
	Type "snowemp" and press the ENTER key to expand the "snowemp" files.
	Delete "snowemp.exe" from the "flyourinitials" directory with the command "del 
snowemp.exe".
 	Copy the files "c:\flog3\200av3.dat" and "c:\flog3\200bv3.dat" to the 
"c:\flyourinitials" directory withe the command "copy c:\flog3\200*.dat" where:
       200av3.dat contains the comma delimited fields: XCOORD, YCOORD, STATNUM, 
STATYPE, TRAVNUM e.g. 12,47,1,outcrop,1.
       and 200bv3.dat the fields:STATNUM,LITHCODE, ROCKTYPE, METALS, e.g. 1,"s", 
"sandstone", "Au".

	ENTER THE RELEVANT SET STATEMENTS IN THE "AUTOEXEC.BAT" 
AND THE "C:\ACAD\SUPPORT\FIELDLOG.PRJ" FILES.
	THE FOLLOWING IS IMPORTANT - BE CAREFUL

	Use the DOS Edit command to place the statement "set 
flyourinitials=c:\flyourinitials" (e.g. set flwrc=c:\flwrc) in the Autocad 2 (and Autocad 1 if it 
exists) menu sections of the "autoexec.bat" file using the command "edit c:\autoexec.bat") [If 
you don't know how to use `EDIT', request help from the instructor.].

	Use the DOS Edit command to place the statement 
"flyourinitials=c:\flyourinitials,dBase3" (e.g. flwrc=c:\flwrc,dBase3) in the 
c:\acad\support\fieldlog.prj" file with the command "edit c:\acad\support\fieldlog.prj").

	REBOOT THE COMPUTER TO REGISTER THE CHANGES IN THE 
AUTOEXEC.BAT FILE.

	LOAD FIELDLOG
	Run Autocad by typing `acadtb' `ENTER', load Fieldlog, and choose "fl-logon" in 
the Fieldlog menu. In the "Connect to Database" dialogue box select "flyourinitials."
	Once Fieldlog and the database have been loaded, it will be necessary to carry out the 
following procedures to 1) "setup" the map projections, 2) add fields and/or modify the existing 
fields in the Tables, and set the field parameters, and 3) import the ASCII formatted data.

	1) - SETUP THE DATABASE
	Select "fl-Setup" followed by "Map Setup". In the "Map Setup" dialogue box select 
"USER" as the Map Projection. (It is important that the Map Projection chosen correspond 
to the projection of the map to be or that is already drawn on the monitor screen; that is, if 
the map on the screen is a UTM NAD27 map, the projection should be cited as such. If the 
Projection is a particular `user' projection then it will be necessary to carry out a `user' 
projection setup as described below. Note also that many of the selection boxes will already have 
inserted what appears to be a default value. However, in the case that you are using the DOS 
version of FLOG3, it will be necessary to select (confirm) the entry in the box by clicking on 
it.) Enter values of "1" for the Symbol: and Text Height:, "90" for the North Angle:, and "Y" for 
the Clockwise angle: Click the OK button.

	THE PROJECTION SETUP
	Again select "fl-Setup", click "Projection Setup" and in the name box scroll to and 
click on `Snowlake' to load this projection as a template for your projection. Change the name 
"Snowlake"  in the NAME box to `flyourinitials' and click the INSERT button to create a 
Projection named "flyourinitials". Since you will be adding data to a User grid map rather than 
an UTM map, return to "Map Setup" and scroll and select "flyourinitials" as the projection.
	Select "Transformation Setup", and in the Transformation Setup menu click NEW, 
and type "flyourinitials to Utm Zone 17 NAD27" in the "Name" box. In the "From 
Projection" and "To Projection" boxes scroll and select "flyourinitials" and "Utm Zone 17 
NAD27", respectively. Click the INSERT button. Click the POINTS box and in the 
Transformation Points Setup menu box enter  0 and 0 in the "flyourinitials" X and Y boxes  
and 147863 and 1477863 in the "Utm Zone 17 NAD27" X and Y boxes, and click INSERT. 
Click "NEW" and repeat the operation entering values of 200 and 200 as the 
"flyourinitials" X and Y values, and 148063 and 1478063 as the "Utm Zone 17 NAD27" X 
and Y values. Click INSERT and then EXIT the Transformation Points Setup menu.
	Again click the "New" box in the Transformation Setup menu and repeat the exact 
reverse operation for a "Utm Zone 17 NAD27 to flyourinitials" transformation. In both cases 
the transformation will be orthogonal to orthogonal. (In other circumstances the Transformation 
may be from orthogonal UTM to rotated orthogonal USER, or even UTM to rotated and distorted 
orthogonal USER.) Exit the Transformation Setup menu, and click the Save Fieldlog setup 
option.

	Select "Table Setup" and the Project "flyourinitials", click "Table" and then 
"STATI". To record which fields are to be used as coordinate fields [VERY IMPORTANT], 
click the "Points" box to retrieve the POINT SETUP menu. Delete any selections already made 
by clicking on them and then clicking the delete button. Select "flyourinitials" in the 
"Projection" box, "STATYPE" in the "Symbol" box, and "GRIDX", "GRIDY", and "GRIDZ" 
in the X, Y, and Z boxes, respectively. Click insert such that:
	 GRIDX   GRIDY   GRIDZ   FLYOURINITIALS   STATYPE appear in the upper 
box.
	Repeat this operation, selecting "UTM 17 NAD27" in the "Projection" box, 
"STATYPE" in the "Symbol" box, and "UTMX", "UTMY", and "UTMZ" in the X, Y, and Z 
boxes, respectively. Click insert such that:
	 UTMX   UTMY   UTMZ   UTM 17 NAD27   STATYPE appear in the upper box. 
Exit and click the Save Fieldlog setup option.
	[If you have already placed a LATITUDE, LONGITUDE, and ELEVATION field in 
the STATI Table, add a Lat-Long option to POINTS by selecting "GEOGRAPHIC NAD27" in 
the "Projection" box, "STATYPE" in the "Symbol" box, and "LATITUDE", "LONGITUDE", 
and "ELEVATION" in the X, Y, and Z boxes, respectively.]

	2) - TO ADD AND/OR MODIFY FIELDS
	In the "Table Setup" menu click the "Table" button and LITHO, and then the 
"Column" button. Click NEW, type "LITHCODE" in the field entry box, and click the box 
containing the field names. Click the MOVE button and move the "LITHCODE" field above 
the "ROCKTYPE" field. Click the SETUP button to verify that the field has been registered as a 
CHARACTER field.
	With the "LITHCODE" field selected, click the save button, and then click the 
PALETTE button. In the PALETTE menu, set the LAYER on which the field is to reside as 
"LITHCODE", as well as the SIZE (1) and OFFSET of the LITHCODE text symbol (offset Y 
-1; that is 1 unit to the left of the outcrop symbol STATYPE).
	 Repeat this operation and ADD a "METALS" field, and MOVE the "METALS" 
field above the "CLRWEATH" field, SAVE the change, and use "PALETTE" to modify the 
parameters of the METALS (size 1; offset x 1, y 1)
	Similarly, in the STATI table use "MOVE" to rearrange the fields in the relative 
order: GRIDX, GRIDY, GRIDZ, STATNUM, STATYPE, TRAVNUM. Save the changes and 
use "PALETTE" to modify the parameters of the STATYPE field (change from `shape' to 
`block'; LAYER = statype, SIZE = 0.2; all OFFSETS = 0), the STATNUM field (LAYER = 
statnum, SIZE 1, offset x 1; y 1), and the TRAVNUM field (LAYER = travnum, SIZE 1, offset 
x -1. [If you wish to have an entry for the coordinates as Lat-Longs, as well as USER and UTM, 
add LATITUDE, LONGITUDE, and ELEVATION fields before the STATNUM field, and in 
the SETUP menu, retrieved by clicking the SETUP button in the Table Setup menu, set the 
LATITUDE and LONGITUDE to NUMERIC with a field length of 10 and number of decimal 
places 6. Then return to the POINTS SETUP menu (click the POINTS box) to enter the 
conversion parameters, as described above.]
	Exit the "Table Setup" menu, Save the changes to the Fieldlog Tables, and exit the fl-
Setup menu.

	TEST THE DATABASE
	Choose fl-add to test the addition of a data point into the STATI table (stationnum - 
me1; traverse - 1), and plot the point to the screen using fl-query. Using QUERY, create a 
STATI query, and delete the "me1" record from the STATI table.

FIGURES

Figure 1. Plate Tectonics.

RETURN TO:

Click here to return to beginning.

Click here to return to course outline.

Click here to return to W.R. Church's page.

Click here to return to course list.