THE GEIGER DATABASE
GEIGER QUERY PROCEDURES
Database JGDB10 Query Set
PROCEDURES 100 - 149
The 176 query procedures derived from Database JGDB10 are described. Each procedure is presented with a summary of function, note of special relationships, screen capture 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 100: TF<06/31/32Test
The query returns a list of individuals associated with the studio of Frank Lloyd Wright between 1888 and 1932.
Procedure 101: TFHonoraryFellows
The query returns a list of individuals who worked in the studio of Frank Lloyd Wright prior to the founding of the Taliesin Fellowship in 1932.
Procedure 102: TFDrawAuthorByLast2
The query returns
drawings for Frank Lloyd Wright commissions grouped by the name of the person recorded in the database as being principal delineator.
Procedure 103: DrawLineSfxBlank
The query returns a list of Frank Lloyd Wright drawings recorded in the database as having a descriptive suffix.
Procedure 104: JDDrawByAutPrlm32/59
The query returns a chronolgically ordered list of drawings for Frank Lloyd Wright commissions between 1932 and 1959 according to categories assigned in the database.
Procedure 105: JobDecAssesOnly
The query returns a list of Frank Lloyd Wright commissions for which there are decorative accessory drawings recorded in the database.
Procedure 106: TFListAnyYear
The query returns a list of individuals recorded in the database as being members of the Taliesin Fellowship in 1935.
Procedure 107: TF32to59All
The query returns a list of individuals recorded in the database as being resident at Taliesin between January 1, 1924 and April 10, 1959.
Procedure 108: JGDrawLineItems
The query returns a list of drawings recorded in the database for all Frank Lloyd Wright commissions, grouped by client name and project title.
Procedure 109: JGDrawLineItems2
The query returns a list of drawings recorded in the database for all Frank Lloyd Wright commissions, grouped by client name and project title.
Procedure 110: TFListnyYear2
The query returns a list of individuals recorded in the database as being resident at Taliesin between 1911 and 1924.
Procedure 111: TF32to59AllSortDate
The query returns a list of individuals recorded in the database as associated with the studio of Frank Lloyd Wright and the Taliesin Fellowship from January, 1923 to April 9, 1959.
Procedure 112: TFTFOut=Blank
The query returns a list of individuals whose date of departure from Taliesin is not recorded in the database.
Procedure 113: JGPubDrawSortClient
The query returns
bibliographic citation information for all Frank Lloyd Wright project drawings recorded in the database as having been published, ordered alphabetically by client name.
Procedure 114: JGPubDrawSort1Client
The query returns
bibliographic citation information for all Frank Lloyd Wright project drawings recorded in the database as having been published, ordered alphabetically by client name.
Procedure 115: JGPubDrawSortYrClient
The query returns
bibliographic citation information for all Frank Lloyd Wright project drawings recorded in the database as having been published, ordered chronologically.
Procedure 116: JGPubDrawSortArchv#
The query returns
bibliographic citation information for all Frank Lloyd Wright project drawings recorded in the database as having been published, ordered by Frank Lloyd Wright Archives drawing inventory number.
Procedure 117: JGPhoneList
The query returns a list of contact information for personal acquaintances, vendors, and other people known to John Geiger.
Procedure 118: TFSuperviseApprentcs
The query returns a list of Taliesin Apprentices recorded in the databas as having supervised the construction of Frank Lloyd Wright commissions.
Procedure 119: TF<04/09/59
The query returns a list of individual recorded in the database as being resident at Taliesin prior to April 9, 1959.
Procedure 120: JGFLLWHouseLAMetro
The query returns
a list of Frank Lloyd Wright buildings in Los Angeles, California.
Procedure 121: TFTFOut2=blank
The query returns a list of individuals whose date of departure from Taliesin is not recorded in the database.
Procedure 122: JGDrawByAuthorPrelim
The query returns a list of various types of preliminary drawings for Frank Lloyd Wright commissions.
Procedure 123: JGDrawAuthPrelm32/59
The query returns a list of various types of preliminary drawings for Frank Lloyd Wright commissions dated between 1932 and 1959.
Procedure 124: JGDrawPrelimTot32/59
The query returns a list of various types of preliminary drawings for Frank Lloyd Wright commissions dated between 1932 and 1959.
Procedure 125: JGDrawPresent32/59
The query returns a list of preliminary presentation drawings for Frank Lloyd Wright commissions dated between 1932 and 1959.
Procedure 126: JGQuote
The query returns a list of quotations and related bibliographic citations related to Frank Lloyd Wright and his work selected by John Geiger.
Procedure 127: TFLiving<06NewFormat
The query returns a list of Taliesin Fellowship members who were recorded in the database as still living as of August 7, 2006.
Procedure 128: TFList1947
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1947.
Procedure 129: GEO???1
The query returns a comment by John Geiger concerning drawings for the Point View Residences project for Edgar J. Kaufmann, Jr., designed by Frank Lloyd Wright in 1953.
Procedure 130: Icon2
The query returns a list of images related to Frank Lloyd Wright commissions regarded by John Geiger as iconographic.
Procedure 131: JGJobEval=Blank
The query returns a list of Frank Lloyd Wright commissions to which John Geiger had not assigned an evaluation value on a scale of 2 (lowest) and 10 (highest).
Procedure 132: JGPubDraw
The query returns a list containing bibliographic citations for all published drawings of Frank Lloyd Wright commissions recorded in the database.
Procedure 133: trial
The query returns a list of individuals associated with the studio of Frank Lloyd Wright and the Taliesin Fellowship between 1889 and 1959.
Procedure 134: JGFLLWBooks
The query returns a list of books on Frank Lloyd Wright found in the library of John Geiger.
Procedure 135: JGFLLWNotBooks
The query returns a list of periodicals, essays, ephemera and other materials, books excluded, on Frank Lloyd Wright found in the library of John Geiger.
Procedure 136: JGNotFLLWBut720
The query returns a list of books and other materials having Dewey Decimal system classification 720 to 740, but not relating to Frank Lloyd Wright, found in the library of John Geiger.
Procedure 137: JGFLLWBooksOnly
The query returns a list of books on Frank Lloyd Wright found in the library of John Geiger.
Procedure 138: JGBooksNotFLLWNot720
The query returns a list of books not related to Frank Lloyd Wright or within the Dewey Decimal system classification range of 720 to 740 found in the library of John Geiger.
Procedure 139: TFApprentice2
The query returns a list of Apprentices in the Taliesin Fellowship resident between September, 1928 to April 9, 1959.
Procedure 140: trial2
The query returns a list of individuals associated with the studio of Frank Lloyd Wright and the Taliesin Fellowship between 1889 and 1959.
Procedure 141: 111R1
The query returns a list of individuals recorded in the database as associated with the studio of Frank Lloyd Wright and the Taliesin Fellowship from 1889 to April 9, 1959.
Procedure 142: TFAllAlpha
TThe query returns a list of individuals recorded in the database as associated with the studio of Frank Lloyd Wright and the Taliesin Fellowship from 1889 to April 9, 1959.
Procedure 143: TFNonAppList
The query returns a list of individuals not considered Apprentices who were associated with Frank Lloyd Wright or Taliesin from 1889 to the 1990s.
Procedure 144: TFAppOnlyExport
The query returns a list of individuals recorded in the database as being Apprentices in the Taliesin Fellowship before 1959.
Procedure 145: TFAppBVyYear
The query returns a list of individuals recorded in the database as associated with the studio of Frank Lloyd Wright and the Taliesin Fellowship from January 1, 1924 to December 31, 1959.
Procedure 146: JGPubDrawSortClient2
The query returns a list of drawings related to the Country Home and Studio of Frank Lloyd Wright (Taliesin I).
Procedure 147: JGPubDraw2
The query returns a list containing bibliographic citations for all published drawings of Frank Lloyd Wright commissions recorded in the database.
Procedure 148: Occupancy
The query returns a list of Frank Lloyd Wright commissions categorized according to building type.
Procedure 149: JGBookLibraryFLLWOn1
The query returns a list of books, perodicals, and other materials related to Frank Lloyd Wright, grouped by type, found in the library of John Geiger.