There are two data tables for information explicitly linked to the CAD model. These tables were originally constructed by Eiteljorg as experiments in the use of attached data tables for CAD models. The tables were originally created with MS Access 95 and modified in Access 97. As it became apparent that the attachment system in AutoCAD was not robust and would not withstand migration well, the tables were moved to FileMaker (originally 4.0 then 5.0, the format for which is also used by 6.0) via an export/import process using tab-delimited ASCII files. After the transfer to FileMaker, the linkage made explicit with drawing icons and numbers (shown as text in the CAD model) rather than implicit with direct linkage from model elements to data table entries. The tables were last changed in December of 2003. All work on them was done by Eiteljorg.
The main data table contains information about specific blocks. As a result, the information in any entry will apply to material on one layer. Therefore, the layer used for the icon linking the note to the block is the same as the layer for the block except for the substitution of the M as the first character with a D. (Correspondence to plan layers would not always be exact, since all icons are intended to show the 3D objects referenced in the data table.)
Download a FileMaker file of the main data table : OPattDATA.fp5
Download a text file of the main data table : OpattDATA.txt
Metadata for Main Data Tables is below.
Field, type, and content:
ID_NUMBER: - number - auto-entered - unique
DESCR.: text - free entry but generally limited to short descriptions of the particular block that should be clear in light of the layer-naming system
QUANTITY: text - may be a number or a term such as several (n.a. for not applicable)
MATERIAL: text - Pentelic marble, poros, trimmed Acropolis limestone, limestone
BEG_DATE: text - free entry
END_DATE: text - free entry
SURFACE: text - free entry description of the surface of the block
IN_SITU: text - in situ, as trimmed
USE: text - primary, secondary, revetment foundation
POSITION: text - free entry, observations about movement of blocks subsequent to installation
JUSTIFY: text - free entry to explain other observations
Layer: text - layer containing the block
NoteLayer: text - the name of the layer containing the note icon
The following table is the comments data table. This table contains information of a more general nature, information that may explain conditions or otherwise apply to an area rather than a particular block.
Download a FileMaker version : Opcomments.fp5
Download a text file version : Opcomments.txt
Metadata for Data Comments table is below.
Data Fields:
SOURCE: text - scholar responsible for the observation - Eiteljorg, W.B. Dinsmoor, Jr.
DATE: text - date of the observation
NOTE1: text - free entry of the observation
RECNO: number - auto-entered, unique
EnteredBy: text - Eiteljorg
NoteLayer: text - name of layer where icon to show link exists
RefLayer: text - the name of the CAD layer on which the referenced material exists (more than one layer name permitted - separated by commas)
DATA TABLES LINKED TO CAD MODEL