 
	3) - IMPORT
	To import the data set "c:\flyourinitials\200av3.dat" into the STATI table, select fl-
import in the Fieldlog menu. Click in order: PROJECT, TEXTFILE, FILE, and FILENAME 
(200av3.dat) to be imported.
	Click IMPORT, click the Table name STATI, the APPEND button, enter a comma (,) 
into the Column Delineation box, a quote symbol (") in the Text Delineation box, and select 
"flyourinitials" in the Projection box - if you are using the DOS version of FLOG, it is 
IMPORTANT to click this latter item even although "flyourinitials" may be shown as the 
default selection; if it is not selected FLOG will not prompt you to do so.
	Finally (BE CAREFULL!), select the fields to be imported in the Import Fields box, 
i.e. only those fields GRIDX, GRIDY, STATNUM, STATYPE, TRAVNUM in "200av3.dat". 
Click the import button to initiate the import. Repeat this procedure to import the data in 
"c:\flyourinitials\200bv3.dat" into the LITHO table, selecting the fields - STATNUM, 
LITHCODE, ROCKTYPE, and METALS in the Import fields box. 
	
	4) - QUERY and PLOT
	Save SetUp and return to the Fieldlog menu. Select fl-Query and create a Query macro 
(e.g. name it PLOTT) to plot the contents of the LITHCODE AND METALS fields in LITHO, 
and the STATYPE, STATNUM, TRAVNUM (+GRIDX, GRIDY) fields in STATI, to the 
screen. HOWEVER, after having set up the PLOTT macro, run Query to register the PLOTT 
macro but do NOT procede with the plot option. Rather, quit Query, return to SETUP and save 
the setup (i.e. the Query macro PLOTT), and re-run the PLOTT macro in Query, including the 
plot option.

	5) - UTM to LAT-LONG conversion
	Should you wish to do a UTM to LAT-LONG conversion, make sure the coordinates in 
your file to import are in the order Statnum, `Easting x' `Northing y' `OUTCROP', and that 1) in 
the STATI table the fields are organized as STATNUM, LAT, LONG, ELEV, UTMX, UTMY, 
UTMZ, and STATYPE; 2) add a Lat-Long option to POINTS by selecting "GEOGRAPHIC 
NAD27" in the "Projection" box, "STATYPE" in the "Symbol" box, and "LAT", "LONG", 
and "ELEV" in the X, Y, and Z boxes, respectively. Once the data has been imported, Query the 
data and Plot as TXT, selecting the output fields as STATNUM, LAT, LONG. Note that the 
UTMX and UTMY fields cannot be output by this method without rearranging the field order so 
that UTMX and UTMY are the first coordinate fields in the STATI table; nor can you output to 
text both the UTM and the LAT-LONG fields (We do not know why!! You may have to plot 
them seperately, after having rearranged the coordinate fields, and combine them in a 
spreadsheet.) 

Note: to set a condition involving several criterion, e.g. stati.statnum => 010 and <= 020, or 
stati.statnum => 010 and lith.metals = Au, set the first condition and click the MODIFY button; 
click the DOWN button; select `AND' in the connection box, set the second criterion, and click 
the MODIFY button again.
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.