Fieldlog is a database
developed by Boyan Brodaric of the Geological Survey of Canada for the
digital storage of geological data of any kind pertaining to a specific
locality - usually an outcrop in the case of a mapping database. It is
a relational database (similar to dBASE) which
stores attribute data in the form of Tables, Records,
and Fields. A Table is similar to a
spreadsheet composed of records (rows) and fields (columns) containing
information of different classes - there might be a table for structural
data, one for geochemical data, one for data referring to the collection
locality, etc. The tables are linked (related)
by having each of them contain a common item of information, usually an
outcrop number or STATION NUMBER (STATIONUM).
This item or 'field' appears in all the tables.
Records contain information about specific samples or measurements (from
the same or different outcrops), and the fields of the record contain a
single item of information about the sample, e.g. its name, or lithology,
or thin section # or angle of dip, etc.
The number of tables and their contents (fields) are project dependant. Fieldlog will accept up to 15 tables and 27 fields in each table. A typical geological project might contain tables for STATIon information, STRUCtural observations, SAMPLe and PHOTOgraph recordings. Each of these tables, in turn, will contain fields to store the data within the tables; eg. the STRUCtural table might contain the following fields: type of structural reading, strike, dip. Each field occupies a fixed space measured in number of characters, and a data type such as numeric or text. A project definition is created by providing these parameters to Fieldlog through filling the definition form which appears as the initial screen. Each row in the form contains the information for a specific field, including the table in which it resides, its size and type, and some plotting characteristics.
Table and field structure of a Fieldlog database Table Fieldname Type Digits Decimal Enter as Aut. Perm. N S Layer Places Default Pmpt Val. STATI STATIONUM TEXT 11 0 N Statnum N Y STNO LOCATION PNT 8 0 N Location Outcrop N N LOCATN LOCODE TEXT 1 0 Y Locode x * + - o Y N OUTCRP WHERE MEMO 80 0 N Where Y N WHEN DATE 80 0 Y When Y N AIRPHOTO TEXT 15 0 Y Airphoto Y N NTS TEXT 6 0 Y NTS Y N UNIT TEXT 10 0 N Unit A B C D Y Y ECHO COMMENT MEMO 80 0 N Comt STRUC READING SYM 6 0 N Reading BED FOL Y Y STRUC AZIMUTH INT 3 0 N Azimuth Y N STRUC DIPLUNGE INT 2 0 N Diplunge Y Y STRUC GROUP TEXT 1 0 N Group a b c d SAMPL SAMPLNUM TEXT 6 0 N Samnum Y N SAMPL LITHCODE TEXT 1 0 N Lithcode Y N SAMPL MISCNUM REAL 6 2 N Miscnum Y N SAMPL POLNUM TEXT 8 0 N Polnum Y N SAMPL THINNUM TEXT 8 0 N Thinnum Y N SAMPL ROCKTYPE TEXT 20 0 N Rocktyp SSTNE ETC Y N SAMPL METALS TEXT 11 0 N Metals AU AG ETC Y N SAMPL THINSECT ISTR 20 0 N Thinsect PLAG ETC Y N SAMPL REMARKS MEMO 80 0 N Remarks PHOTO ROLL TEXT 6 0 Y Roll FRAME INT 2 0 N Frame REASON TEXT 20 0 N Reason MIN SAMPLNUM TEXT 6 0 N Samnum Y N MIN PLAG RSTR 10 0 N Plag SIO2 TIO2 ETC Y N MIN ETC RSTR 10 0 N MAJ SAMPLNUM TEXT 6 0 N Samnum Y N MAJ SIO2 REAL 5 2 N SiO2 Y N MAJ ETC REAL 5 2 N TRA SAMPLENUM TEXT 8 0 N Samnum Y N TRA CR REAL 6 2 N Cr Y N TRA ETCNOTES: INT - integer; REAL - number with decimal places; ISTR - string of integers or X, Y, and N.; RSTR - string of reals (to 99.99) or X, Y, and N; SYM - names plotted as symbols contained in a symbol library, e.g. NATMAP; MEMO - text field of flexible length; PNT - an XYZ coordinate NTS - National Topographic Survey map sheet reference.
Location coordinates can be entered as UTM (Universal Transverse Mercator; 7 characters; default is the 1927 North American Datum), or Lat-Longs (10 characters, five decimals) or a user defined grid (8 characters). The length of a real field involving decimals must include space for the decimal point.
When 'ECHO' is entered in the layer column, the contents of the field are entered on a layer with the same name as the keyword used in the field. For example, all samples whose lithology is entered as the keyword granite will be plotted on a 'granite' layer.
The 'GROUP' field in the STRUC table allows structural data such as coeval foliations and lineations to be treated as a group. For example a foliation and lineation developed during F1 deformation may be grouped as group A related data; foliation and lineation developed during F2 as group B, etc.
(The 'Prompt', 'N (Null Entry)', S (Display)', and 'Layer' refer to functions available when entering data in Autocad and will not be used in this course. The 'Prompt' function is presently not available. If the 'Null Entry' function is designated as 'Y', it indicates that a field may remain empty during data entry from within Autocad. If the 'Display' function is indicated as 'Y', the data being entered into the field will be displayed on the map generated during interactive data entry within Autocad.)
In the lab demonstration of a GIS system, we will assume that data has already been collected and stored electronically as a computer text file. The data will then be imported into Fieldlog, sorted and selected, and re-exported as a dxf file. The latter file will then be used to generate a point vector map showing the distribution of various rock types. The student will then interpret the data to generate a geological map using the drawing program CorelDraw.
Structural Provinces of North America.
Click here to return to beginning.
Click here to return
to course outline.