THE GEIGER DATABASE
GEIGER QUERY PROCEDURES
DATABASE JGDB10 QUERY SET
PROCEDURE 37: JOHN
The query returns an unordered list of Frank Lloyd Wright Archives project numbers recorded in the database as lacking an assignment for principal types of building materials used in the design.
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 JOHN calls on Table MMTFDRAWINGS FILE with a filter applied on Column [BUILDING TYPE] ("= Blank") to include only projects not assigned a category. Terms for the categorization of principal building materials in Wright projects used in the database can be found as a choice list for Column [BUILDING TYPE]. John Geiger likely composed this query as a means to find projects for which he had not yet assigned a category. The report format produced a simple list of unique numerical identifiers without further information.
The query structure is the same as PROCEDURE 100: JOHN in Database JGDBFULL.
Database Search
Search based on this procedure cannot be executed through the version of the database available on the website.
ORIGINAL DATAEASE PROCEDURE SCREENS
Query Structure
Report Format
Document: Dataease Procedure Definition Printout (PDF)