THE GEIGER DATABASE
GEIGER QUERY PROCEDURES
DATABASE JGDB10 QUERY SET
PROCEDURE 153: DEKE3
The query returns a list of drawings for Frank Lloyd Wright commissions that used brick with board-and-batten or concrete blocks and plywood as primary building materials.
Note: The column labels shown within the query structures are historical references only, and do not reflect the definitions used within the version of the database being served through the website.
PROCEDURE NOTES
Procedure DEKE3 calls on Tables Published Line Items, MMTFDRAWINGS FILE, and Published/Drawings with filters applied on Column [BUILDING TYPE] to select rows with those values. The building material categories used in the database can be found as a choice list for Column [BUILDING TYPE] ("MAS/Brick, board & batten" or "MAS/Conc block, plywood") to select rows with those values. The report format produced a block layout list of drawings showing Frank Lloyd Wright Archives drawing inventory numbers, client name, project title, location, drawing description, and bibliographic information on where the drawing was published. The last generation of the report contained 436 entries.
Database Search
Search based on this procedure can be executed through the version of the database available on the website. The results are redacted to omit personal contact information.
ORIGINAL DATAEASE PROCEDURE SCREENS
Query Structure
Report Format
Document: Dataease Procedure Definition Printout (PDF)