THE GEIGER DATABASE


GEIGER QUERY PROCEDURES
Database JGDB10 Query Set

PROCEDURES 150 - 176

The 176 query procedures derived from Database JGDB10 are described. Each procedure is presented with a summary of function, note of special relationships, images showing the original query composition and printout format as they appeared in the DataEase application, and a definition form exported from DataEase (PDF). Some queries can be executed with results presented in a fashion similar to that composed by John Geiger through the version of the database available on the website.

QUERY PROCEDURES

Procedure 150: 49ex

The query returns a list of Apprentices in the Taliesin Fellowship resident between September, 1928 to April 9, 1959.

Procedure 151: deke

The query returns a list of clients for Frank Lloyd Wright commissions that used brick with board-and-batten as primary building materials.

Procedure 152: deke2

The query returns a list of clients for Frank Lloyd Wright commissions that used brick with board-and-batten or concreate blocks and plywood as primary building materials.

Procedure 153: deke3

The query returns a list of drawings for Frank Lloyd Wright commissions that used brick with board-and-batten or concreate blocks and plywood as primary building materials.

Procedure 154: TFbyDate

The query reports a list of individuals recorded in the database as being resident at Taliesin between 1929 and 1932.

Procedure 155: TF>04/29/59Not=ST

The query returns a list of unique numerical identifiers related to individuals resident at Taliesin prior to April 29, 1959.

Procedure 156: DrawAuthorByArchive#

The query returns a list of Frank Lloyd Wright drawings with the name of the person recorded in the database as being principal delineator.

Procedure 157: PrintLineItems

The query returns a list of bibliographic citations for all published Frank Lloyd Wright project drawings recorded in the database.

Procedure 158:PublishDrawByA#

The query returns a list of all Frank Lloyd Wright project drawings recorded in the database.

Procedure 159: JobComments&CC2

The query returns a list of Frank Lloyd Wright Archives drawing inventory numbers.

Procedure 160: Draw#??1

The query returns a list of Frank Lloyd Wright Archives drawing inventory numbers for a specific project.

Procedure 161: PublishDrawByA#2

The query returns a list of bibliographic citations for published drawings related to a specific Frank Lloyd Wright project.

Procedure 162: DrawPrt=BlankLineNot

The query returns a list of Frank Lloyd Wright project drawings recorded in the database as missing an inventory number for books found in the library of John Geiger.

Procedure 163: PubItemsExport

The query returns a list of Frank Lloyd Wright project drawing inventory numbers.

Procedure 164: PubDrawExport

The query returns a list of Frank Lloyd Wright project drawing inventory numbers.

Procedure 165: DrawPeint

The query returns a list of Frank Lloyd Wright project drawing inventory numbers.

Procedure 166: PDfDuplicates

The query returns a list of unique numerical identifiers related to Frank Lloyd Wright project drawings.

Procedure 167: BookPageFig

The query returns a list of bibliographic information for Frank Lloyd Wright project drawings that appear in a specific book.

Procedure 168: BookPageFig2

The query returns a list of bibliographic information for Frank Lloyd Wright project drawings that appear in a specific book..

Procedure 169: TFNonAppListDateSort

The query reports a list of individuals not considered Apprentices who were associated with Frank Lloyd Wright or Taliesin from 1889 to the 1990s.

Procedure 170: TFSt1959to1998

The query returns a list of Apprentices, students, and others resident at Taliesin after the death of Frank Lloyd Wright, from April 9, 1959 to 1998.

Procedure 171: BooksArchNotFLLW

The query returns a list of architecture books not related to Frank Lloyd Wright found in the library of John Geiger.

Procedure 172: BookArtNotFLLW

The query returns a list of art history books not related to Frank Lloyd Wright found in the library of John Geiger.

Procedure 173: BooksNotArch/ArtFLLw

The query returns a list of books not related to Frank Lloyd Wright or art and architecture in general found in the Geiger library.

 Procedure 174: BookPage

The query returns a list of bibliographic information and archival inventory numbers for Frank Lloyd Wright project drawings published in a specific book found in the libary of John Geiger.

Procedure 175: BookPageRomanNumeral

The query returns a list of bibliographic information and archival inventory numbers for Frank Lloyd Wright project drawings designated by Roman numerals published in a specific book found in the library of John Geiger.

Procedure 176: page

The query returns a list of bibliographic information for Frank Lloyd Wright project drawings published in a specific book found in the library of John Geiger.