THE GEIGER DATABASE


GEIGER QUERY PROCEDURES
Database JGDBFULL Query Set

PROCEDURE 100: 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] 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 37: JOHN in Database JGDB10.

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

JGDBFULL Procedure 100 query image

Report Format

JGDBFULL Procedure 100 report image 

Document: Dataease Procedure Definition Printout (PDF)