THE GEIGER DATABASE
GEIGER QUERY PROCEDURES
Database JGDB10 Query Set
PROCEDURES 50 - 99
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 50: TFResidentShort
The query returns a list of individuals recorded in the database as having been involved with the Frank Lloyd Wright studio and Taliesin Fellowship, including Apprentices, Wright family members, summer musicians, etc., but excluding students of Gurdjieff.
Procedure 51: TFLiving<60
The query returns a list of mailing addresses for Taliesin Fellowship members resident at Taliesin during the life of Frank Lloyd Wright who were still alive as of November 19, 2002.
Procedure 52: TFMasterListIn Progr
The query returns a list of all individuals recorded in the database as being members of the Taliesin Fellowship.
Procedure 53: TFMasterComplete
The query returns a list of all individuals recorded in the database as being members of the Taliesin Fellowship.
Procedure 54: TFTFIn=Blank
The query returns a list of Taliesin Fellowship members whose date of arrival at Taliesin was not recorded in the database.
Procedure 55: JGQuarterlyList
The query returns a list of issues of the Frank Lloyd Wright Quarterly magazine held by John Geiger in his library.
Procedure 56: JGSAHList
The query returns a list of issues of the Journal of the Society of Architectural Historians held by John Geiger in his library.
Procedure 57: JGFLLWBookLibrary
The query returns a list of books and perodicals, and other materials related to Frank Lloyd Wright found in the library of John Geiger, grouped by type.
Procedure 58: JGJobEval>8List
The query returns a list of Frank Lloyd Wright commissions with an evaluation of importance by John Geiger using an assignment of 8 (lowest) to 10 (highest).
Procedure 59: JGJobEval>6List
The query returns a list of Frank Lloyd Wright commissions with an evaluation of importance by John Geiger using an assignment of 6 (lowest) to 10 (highest).
Procedure 60: JGJobToPublish?
The query returns a chonologically sorted list of Frank Lloyd Wright commissions whose purpose in being selected is unknown.
Procedure 61: DrawListPubAuth
The query returns a list of drawings for a selected Frank Lloyd Wright project with bibliographic citations and the name of the person recorded as primary creator.
Procedure 62: PubDrawListByDate
The query returns a chronologically ordered list of drawings for selected Frank Lloyd Wright commissions with bibliographic citations.
Procedure 63: JGBookSwNumber
The query returns a list of books and other materials found in the Geiger library related to citations found in Frank Lloyd Wright: An Annotated Bibliography, by Robert L. Sweeney.
Procedure 64: JGBookSw#Form
The query returns a list of books and other materials found in the Geiger library related to citations found in Frank Lloyd Wright: An Annotated Bibliography, by Robert L. Sweeney.
Procedure 65: JGFLLWbookLibFormVw
The query returns a detailed report for all Frank Lloyd Wright related books and other materials found in the Geiger library.
Procedure 66: JGBkLbFormView
The query returns a list of inventory information concerning the Geiger library.
Procedure 67: JGBooksFLLWOnly
The query returns a list of books and other materials in the Geiger library whose subject heading is Frank Lloyd Wright.
Procedure 68: JGBooksNotFllw
The query returns a list of books and other materials found in the Geiger library whose subject heading is not Frank Lloyd Wright.
Procedure 69: JGJobByBldgType
The query returns a list of Frank Lloyd Wright commissions categorized by primary building material.
Procedure 70: JGSortRoofType
The query returns a list of Frank Lloyd Wright commissions categorized according to roof type or form.
Procedure 71: JGSortRoofPattern
The query returns a list of Frank Lloyd Wright commissions categorized by roof pattern type assigned by John Geiger.
Procedure 72: TFResidentShortTFIn
The query returns a list of all individuals records in the database as being resident at Taliesin.
Procedure 73: TFResidntShortNoMarr
The query returns a list of residents at Taliesin without duplication for married name.
Procedure 74: TF<06/61/32
The query returns a list of individuals recorded in the database as working in the Frank Lloyd Wright studio or being resident at Taliesin prior to May 31, 1932, including Wright family members. The date range indicated by the procedure title is at variance with the query structure.
Procedure 75: TF<05/31/32NoFamily
The query returns a list of individuals recorded in the database as working in the Frank Lloyd Wright studio prior to May 31, 1932.
Procedure 76: TF<05/31/32/FormView
The query returns a list of individuals recorded in the database as working in the Frank Lloyd Wright studio prior to May 31, 1932, with biographical and source information.
Procedure 77: Comments
The query returns a list of comments by John Geiger related to sources of information, cross references, or other notes concerning individuals recorded in the database.
Procedure 78: QuotePrintFile2
The query returns a list of quotations related to Frank Lloyd Wright and his work selected by John Geiger.
Procedure 79: QuoteLineItems
The query returns a list of bibliographic citations and additional information concerning quotations selected by John Geiger related to the life and work of Frank Lloyd Wright.
Procedure 80: QuotePrintFile
The query returns a list of bibliographic citations and additional information concerning quotations selected by John Geiger related to the life and work of Frank Lloyd Wright.
Procedure 81: DrwOwnerNotFLLW
The query returns a list of Frank Lloyd Wright drawings not held by the Frank Lloyd Wright Archives.
Procedure 82: JGArtInventory
The query returns a list of fine art objects owned by John Geiger.
Procedure 83: JGNonArtInventory
The query returns a list of personal possession belonging to John Geiger, excluding objects he considered part of his art collection.
Procedure 84: JGBookLIbFLLW
The query returns a list of Frank Lloyd Wright books and other materials found in the Geiger library with comments concerning bookstore or gallery dealers.
Procedure 85: JGBookLibX2
The query returns a list of books and periodicals not related to Frank Lloyd Wright found in the library of John Geiger.
Procedure 86: JGBookLibFLLW<1990
The query returns a list of Frank Lloyd Wright books and other materials found in the Geiger library that were published in 1990 or earlier.
Procedure 87: JGBookLibNotFLLW>90
The query returns a list of Frank Lloyd Wright books and other materials found in the Geiger library that were published in 1990.
Procedure 88: JGBookLib700to800
The query returns a list of books and other materials found in the library of John Geiger with a Dewey Decimal system classification between 700 and 800 that were published after 1990.
Procedure 89: JGBookLibAdditions
The query returns a list of Frank Lloyd Wright books and other materials found in the Geiger library that were published after 1990.
Procedure 90: JGBookLibFLLW>1990
The query returns a list of Frank Lloyd Wright books and other materials found in the Geiger library that were published after 1990.
Procedure 91: TFDrawAuthorByArkv#
The query returns a list of drawings for Frank Lloyd Wright commissions showing the name of the person recorded in the database as being principal creator.
Procedure 92: TFResidentShortAlpha
The query returns a list of individuals recorded in the database as having been involved with the Frank Lloyd Wright studio and Taliesin Fellowship, including Apprentices, Wright family members, summer musicians, etc., but excluding students of Georgi Ivanovich Gurdjieff.
Procedure 93: TF05/31/32to04/10/1959
The query returns a list of residents at Taliesin, including Wright family members, from May 31, 1932, to April 10, 1959.
Procedure 94: TF>04/09/59
The query returns a list of residents at Taliesin after April 9, 1959.
Procedure 95: TFFullListFormView
The query returns a list of contact and biographical information for individuals recorded in the database as belonging to the Taliesin Fellowship.
Procedure 96: JGJobSortDateDecAss
The query returns a list of Frank Lloyd Wright commissions with an assigned category of decorative accessories.
Procedure 97: JGDrawByAuthorWorkDw
The query returns a list of working drawings for Frank Lloyd Wright commissions, grouped by name of the person deemed principal creator.
Procedure 98: JGBuildingOwners
The query returns an alphabetical list of clients, owners, or other relationships with Frank Lloyd Wright buildings.
Procedure 99: TF<06/31/32/SortDate
The query returns a list of individuals associated with the studio of Frank Lloyd Wright between 1888 and 1932.