THE GEIGER DATABASE


GEIGER QUERY PROCEDURES
Database JGDBFULL Query Set

QUERY PROCEDURES 100 - 133

The 133 query procedures derived from Database JGDBFULL 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; alternately, sometimes procedure results may be downloaded as a PDF.

JGDBFULL QUERY PROCEDURES 100 - 133

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.

Procedure 101: GEO????

The query returns a list a comments by John Geiger about Frank Lloyd Wright commissions, ordered Frank Lloyd Wright Archives project number.

Procedure 102:JGJobEval

The query returns a list of Frank Lloyd Wright commissions grouped by year with an evaluation of importance by John Geiger using an assignment of 2 (lowest) to 10 (highest).

Procedure 103: JGJobEvalByEvalREV

The query returns a list of Frank Lloyd Wright commissions in descending order of importance according to an evaulation system devised John Geiger using an assignment of 2 (lowest) to 10 (highest).

Procedure 104: JGDrawAuthEval

The query returns a list of drawings for Frank Lloyd Wright commissions grouped by the name of the person deemed principal creator, together with an evaluation of importance of the design by John Geiger using an assignment of 2 (lowest) to 10 (highest).

Procedure 105: JGDrawByAuthPrelim

The query returns a list of preliminary presentation drawings for Frank Lloyd Wright commissions, grouped by name of the person deemed principal creator.

Procedure 106: JGDrawAuthWorkDwg

The query returns a list of working drawings for Frank Lloyd Wright commissions, grouped by name of the person deemed principal creator.

Procedure 107: JGPlanType

The query returns a list Frank Lloyd Wright commissions grouped by type of floor plan with an evaluation of importance by John Geiger using an assignment of 2 (lowest) to 10 (highest).

Procedure 108: JGIconListByJob#

The query returns a list of images related to Frank Lloyd Wright commissions regarded by John Geiger as iconographic.

Procedure 109: JGJobEval>8.5

The query returns a list of Frank Lloyd Wright commissions with an evaluation of importance by John Geiger using an assignment of 7.5 (lowest) to 10 (highest). The search value of 8.5 indicated by the query title is at variance with the query structure.

Procedure 110: PubDrawList

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

Procedure 111: QuoteFilePrint

The query returns a list of quotations related to Frank Lloyd Wright and his work selected by John Geiger.

Procedure 112: TFApprenyOnlyShort

The query returns a list of all Taliesin Fellowship Apprentices recorded in the database, including changes in married name.

Procedure 113: TFResidentShort

The query returns a list of individuals recorded as being resident at Taliesin.

Procedure 114: 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 115: TFMasterListIn Prog

The query returns a list of all individuals recorded in the database as being members of the Taliesin Fellowship.

Procedure 116: TFMasterComplete

The query returns a list of all individuals recorded in the database as being members of the Taliesin Fellowship.

Procedure 117: TFTFIn=Blank

The query returns a list of Taliesin Fellowship members whose date of arrival at Taliesin was not recorded in the database.

Procedure 118: JGQuarterlyList

The query returns a list of issues of the Frank Lloyd Wright Quarterly magazine held by John Geiger in his library.

Procedure 119: 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 120: JGFLLWBookLibrary

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.

Procedure 121: JGJobEval>8List

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). The search value of 8 indicated by the query title is at variance with the query structure.

Procedure 122: 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 123: JGJobToPublish?

The query returns a chonologically sorted list of Frank Lloyd Wright commissions whose purpose in being selected is unknown.

Procedure 124: DrawListPubAuthor

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 125: PubDrawListByDate

The query returns a chronologically ordered list of drawings for a selected Frank Lloyd Wright project with bibliographic citations.

Procedure 126: blankLibrary

The query returns a list of inventory numbers for books and other materials held by John Geiger in his library.

Procedure 127: 2301

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

Procedure 128: PUBDRAWExport

The query returns a list of correlations between Frank Lloyd Wright Archives project numbers and the unique numerical identifiers assigned to related drawings in a table.

Procedure 129: PubDraw

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

Procedure 130: LBSubscribers

The query returns a list of institutional and public libraries that subscribed to the Journal of the Taliesin Fellows (JTF).

Procedure 131: vendors

The query returns a list of numbers related to house museums and bookstores that sold the Journal of the Taliesin Fellows (JTF).

Procedure 132: MHFLLWLibrary

The query was intended to report fundraising donations solicited from the Taliesin Fellows for the creation of the William Wesley Peters Library at the Frank Lloyd Wright School of Architecture.

Procedure 133: MHTest2

The query was intended to report fundraising donations solicited from the Taliesin Fellows for the creation of the William Wesley Peters Library at the Frank Lloyd Wright School of Architecture.