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.

  • Search Database

ORIGINAL DATAEASE PROCEDURE SCREENS

Query Structure

JGDB10 Procedure 153 query image

Report Format

JGDB10 Procedure 153 report form

Document: Dataease Procedure Definition Printout (PDF)