THE GEIGER DATABASE


GEIGER QUERY PROCEDURES
Database JGDB10 Query Set

PROCEDURES 1 - 49

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). Many 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.

QUERY PROCEDURES

Procedure 1: MMTFREC#

The query was designed to report mailing addresses for subscribers to the Journal of the Taliesin Fellows.

Procedure 2: MMTFIDSYMBOLS

The query returns a list of abbreviations and descriptions that categorize personal names or institutional relationships in connection with the Taliesin Fellowship, the Taliesin Fellows and subscribers to the Journal of the Taliesin Fellows (JTF), and other relationships within the extended Frank Lloyd Wright community.

Procedure 3: MMTFWORK CATEGORY

The query returns a list of building types to categorize Frank Lloyd Wright commissions.

Procedure 4: MMTFIDPRINT

The query returns a list of abbreviations and descriptions that categorize personal names or institutional relationships in connection with the Taliesin Fellowship, the Taliesin Fellows and subscribers to the Journal of the Taliesin Fellows (JTF), and other relationships within the extended Frank Lloyd Wright community.

Procedure 5: MMJGINV

The query returns an inventory of personal possessions belonging to John Geiger.

Procedure 6: MMJGBOOKLIBRARY

The query returns an inventory of books, periodicals, and archival materials held by John Geiger in his library.

Procedure 7: MMTFCategoryList

The query returns a list of abbreviations and related descriptors for membership and subscription status, meetings and events, and fundraising initiatives for the Taliesin Fellows.

Procedure 8: JGBookLibrary

The query returns a detailed inventory, including cost and valuation, of books, periodicals, and archival materials held by John Geiger in his library.

Procedure 9: TFList1931

The query returns a list of individuals present in the Taliesin Fellowship during 1931.

Procedure 10: TFList1931AppOnly

The query returns a list of individuals present in the Taliesin Fellowship during 1931.

Procedure 11: TFDrawAuthorByLast

The query returns the authorship of individual drawings for Frank Lloyd Wright commissions, grouping them by principal delineator.

Procedure 12: TFDrawAuthorByClient

The query returns
the authorship of individual drawings for Frank Lloyd Wright commissions, ordered alphabetically by client name.

Procedure 13: TFDrawAuthorByDraft

The query returns
the authorship of individual drawings for Frank Lloyd Wright commissions, grouping them by principal delineator.

Procedure 14: TFCategoryListing

The query returns an abbreviation code and related descriptors for Taliesin Fellows membership, event registrations and donations, as well as subscriptions to the Journal of the Taliesin Fellows.

Procedure 15: 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 16: TFTaliesinMen

The query returns a list of male drafters in the Frank Lloyd Wright studio present from 1925 to 1935.

Procedure 17: TFOriginalApprentice

The query returns a list of Taliesin Fellowship members present from 1932.

Procedure 18: TFLivingOP

The query returns a list of founding Taliesin Fellowship members still living as of the year 2000.

Procedure 19: TFCompleteApprnList

The query returns a list of individuals recorded as having been Apprentices in the Taliesin Fellowship.

Procedure 20: TFLivingApprnList

The query returns a list of individuals still living who had been members of the Taliesin Fellowship.

Procedure 21: TFEntireTFNamesList

The query returns a complete list of all Taliesin Fellowship Apprentices, Taliesin Fellows members, and others recorded in the database as belonging to the Frank Lloyd Wright community.

Procedure 22: FLLWWorkListByArchv#

The query returns a list of Frank Lloyd Wright commissions ordered by Frank Lloyd Wright Archives project number.

Procedure 23: FLLWWorkListByClient

The query returns a list of Frank Lloyd Wright commissions ordered alphabetically by client name.

Procedure 24: JGApprenticeByName

The query returns an alphabetical list of still living Taliesin Apprentices ordered by country.

Procedure 25: TFGurdjieff

The query returns a list of people in the Taliesin Fellowship considered to be adherents of Georgi Ivanovich Gurdjieff through the influence of Olgivanna Lloyd Wright.

Procedure 26: TFClientList

The query returns a list of Frank Lloyd Wright commissions ordered alphabetically by client name.

Procedure 27: TFClientListByFile#

The query was intended to report a list of Frank Lloyd Wright commissions ordered by Frank Lloyd Wright Archives project number.

Procedure 28: TFDrawByAuthor

The query returns
  a list of Frank Lloyd Wright project drawings categorized as preliminary or public (meaning for publication), grouped by name of delineator.

Procedure 29: JGJobBySortDate

The query returns a list of Frank Lloyd Wright commissions ordered chronologically.

Procedure 30: JGJobBySortDateGroup

The query returns a list of Frank Lloyd Wright commissions grouped by year with total annual counts of commissions.

Procedure 31: JGJobBySortCottage

The query returns a list of Frank Lloyd Wright residential projects categorized as cottage or cabin.

Procedure 32: JGJobSortPrototype

The query returns a list of Frank Lloyd Wright residential projects deemed by John Geiger to be prototypes of later works.

Procedure 33: JGRoofTypeSort

The query returns a list of Frank Lloyd Wright commissions sorted according to an assigned roof type.

Procedure 34: JGBookLibNotFllw720+

The query returns a list of books in the Geiger library not related to Frank Lloyd Wright within a range of Dewey Decimal system classifications.

Procedure 35: LJBookLibCode1Code2

The query returns a list of books and periodicalss held by Geiger in his library with Dewey Decimal system classifications in the 720 to 729 range.

Procedure 36: WorkByDate

The query returns a chronologically ordered list of client names for Frank Lloyd Wright project.

Procedure 37: 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 38: GEO????

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

Procedure 39: 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 10 (highest) to 2 (lowest).

Procedure 40: JGJobEvalByEvalRow

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 41: 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 42: JGDrawByAuthPrelim

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

Procedure 43: JGDrawAuthWorkDwg

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

Procedure 44: JGPlanType

The query returns a list of 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 45: JGIconListByJob#

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

Procedure 46: 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 8.5 (lowest) to 10 (highest).

Procedure 47: PubDrawList

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

Procedure 48: QuotePrintFile

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

Procedure 49: TFApprenyOnlyShort

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