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.