The CSA Propylaea Project
Harrison Eiteljorg, II, 2013. https://doi.org/10.5284/1022574. How to cite using this DOI
Data copyright © Harrison Eiteljorg, II unless otherwise stated
This work is licensed under the ADS Terms of Use and Access.
Primary contact
Harrison
Eiteljorg, II
Center for the Study of Architecture
Box 60
Bryn Mawr
PA 19010
USA
Resource identifiers
- ADS Collection: 1591
- DOI:https://doi.org/10.5284/1022574
- How to cite using this DOI
Final Report, CSA Propylaea Project: Guide to Photographs Database
The FileMaker (version 9) database that was created to record information about the photographs taken in the course of the project was called PropPhots and carried the extension "fp7." There are two tables: PropPhots (474 records) and Photographers (3 records). (Each table is available as a stand-alone, .CSV file for those wishing to import the data: Photos.csv and Photographers.csv. The individual files were both generated with the UTF-8 character set.)
The material in the database includes a number used simply to assist with management, the name of the photographer, the date of the photograph, the film used (or "Digital original"), the original file name, the file name used on the web, a description, and other information as detailed below. Since the names of photographers would be very repetitive if included for each photo, a foreign key is used, and the information about the photographers is in the second table.
The database was organized and created by Mr. Eiteljorg. It was used primarily as an aid for presenting the images on the web.
This database was created in FileMaker Pro 9.0 and has remained in the format of that release of Filemaker from the outset (fp7), though it has been moved to the newer format (fmp12) in the course of final preparations for archival preservation of the materials..
The fields and relationships are as follows:
- In table PropPhots:
- Label — Number — Unique values only, no significance to number, a housekeeping entry
- Date — Text, not date format — the date of the photograph, generally only the month and year
- Photographer — number — the foreign key linking photographers to the individual photographs
- PhotogName — calculated field converted to text — the first and last names of the photographer, as obtained from the related file, Photographers
- BldgPart — text — subject of image: CU (central building, upper portion), CL (central building, lower portion), NW (NW wing), NE (NE wing), and so on. Exceptions: AA view from Areopagus, WW view from west, EE from East.
- Description — Text — serves as caption for the web
- Sequence — Text — used to bind photographs to groups of a given area taken by a single photographer and intended to provide complete coverage of the area
- Film — Text — name of film or "Digital original"
- Digitizing — Text — the name of the company that digitized slides (only Luna Imaging)
- Resolution — Text — resolution of the digital image, in pixels, smaller x larger number
- IntExt — Text — I for interior, E for exterior to indicate whether image is intended to show the interior or exterior of the building
- Position — Text — position of photographer relative to subject: V - View, D distant, F far, N near, C close, E - Extreme close up, W - work related
- OriginalFileName — Text — the name of the file when transmitted to CSA, useful to know original file format (.raw or .NEF files will not be retained in those formats but will be kept in .tiff for archival purposes.)
- NewFileName — calculated field converted to Text — the file name used on the web (exception below, FullNewFileName), meaning either the original name or that name with the JPG extension in place of the original after conversion
- FullNewFileName — Text — the file name used on the web in the case where there are duplicate file names. There were three duplicate names because the originals had different file extensions, and the names were therefore not recognized as yielding identical names when all files were converted to the JPG format. As a result, three image names have had an "a" added to the name so as to make all names unique. This data field contains the altered names, and the field has content only for three photographs that were not JPG format photos originally and had the same names as other images in the JPG format.
- HTML — calculated field converted to text — HTML code used in creating certain web pages for the CSA Propylaea Project website
- Seq.Label — Number — the number or position in a sequence in left-to-right, upper-row to next-row order, with a separate set of numbers for each sequence so that the photographs could be ordered automatically
- Maploc — Number — the number used in the web coding to specify a given point of view for the photographs, with 0 recorded for those images not included in any of the groups defined by point of view (the miscellaneous page) and with 200 for those showing survey work with the 3D scanner, 300 for those showing the use of the man lift to aid surveying with a total station, and 400 for those showing the surveying crew in February of 2003 (each group available from the drop down list on the images page)
- In the table Photographers are the names of the photographers, their birth years, and their relationships to the project. Only three photographers are included, Mr. Eiteljorg, Mr. Kapokakis, and Mr. Tanoulas. Mr. Kanellopoulos should have been recorded here as well, but the only photograph he took was one of Mr. Eiteljorg with Mr. Eiteljorg's camera. As a result, it was described as a photograph of Mr. Eiteljorg's, despite having been taken by Mr. Kanellopoulos! No photographs taken by Mr. Tanoulas have been used in the groups of photos prepared from the CSA Propylaea Project website since the only ones that are part of the project archives are photographs of people on site.
- LastName — Text — last name of the person
- Apepndage — Text — used for Jr., Sr., II, and the like
- YearofBirth — Text — year the person was born
- YearofDeath — Text — year the person died (happily not applicable in any case here)
- RelationtoProject — Text — the relation of the photographer to the project
- ID — Number — the primary key used to link to the foreign key in the PropPhots table
- FirstName — Text — first name of the person
Downloading the Files
Please proceed to the download page to obtain the data files.
- Title: "Final Report, CSA Propylaea Project: Guide to Photographs Database
- Author: Harrison Eiteljorg, II and the staff of CSA, Box 60, Bryn Mawr, PA 19010, (e-mail: user nicke at (@) the domain csanet.org; tel.: 484-612-5862)
- Original file name: PhotoDatabase.html
- Revision history: Since this document is part of the Final Report, changes should not occur. Serious mistakes may be corrected; if so, clear indications of corrections will be included. First posted: 14 September, 2000. Last updated (formatting only): July, 2012. Prepared for ADS archival storage June, 2013.
- Internet access: This document was first prepared for propylaea.csanet.org, operated by the Center for the Study of Architecture and Harrison Eiteljorg, II. It has been turned over to the Archaeology Data Service for archival preservation.
- Long-term availability: This document or its successors will be maintained for electronic access indefinitely.