THE GEIGER DATABASE


DATA TABLE STRUCTURES
DATABASE JGDB10 TABLES

TABLE DETAIL: NDX LINE ITEMS

The structure of this table was designed to record description detail for photographs of Frank Lloyd Wright buildings deemed by John Geiger to be relevant to his studies.

Note: The column labels shown within the table structures are historical references only, and do not reflect the definitions used within the version of the database being served through the website.

TABLE NOTES

Table NDX LINE ITEMS contains 189 rows arranged in 16 columns.

Entries record citations and descriptions for photographs, including project title, source, subject, photographer, and other details. Choice lists were built in to the table structure for consistent data entry.

Document: Description by Geiger of his intention in creating this table.

Records from this table are displayed in a subform of Table MMTFFLLWIndexes. This table provides lookup relationships for columns of Tables Inconographics2, and relies on lookup relationships with columns of Tables MMTFFLLWIndexes. There is a possible relationship with Table MMTFNL to identify the source of some photographs as being received by Geiger from individuals within the Taliesin Fellowship; though the table definition does not confirm this, the row values match.

Database Search

The content of this table is accessible through the version of the database available on the website.

ORIGINAL DATAEASE FORM SCREEN

NDX LINE ITEMS form

Document: DataEase table definition printout (PDF)

COLUMN LABELS

Column: [NDX#] records a unique row identifier number through lookup on a row value of Column [NDXREC#] of Table MMTFFLLWINDEX.

Column: [COCOMMENTS] records a project identification number from the Frank Lloyd Wright Archives inventory through lookup on a row value of Column [COCOMMENTS] of Table MMTFFLLWINDEX.

Column: [FLLW ARCHIVE DRAW#] is void of entries in all rows.

Column: [CORRECTED ARCHIVE #] records the last 2 digits of the year for a Frank Lloyd Wright project through lookup on a row value of Column [CORRECTED ARCHIVE #] of Table MMTFFLLWINDEX.

Column: [CORRECTED ARCHIVE #2] records the series number within a year assigned to a Frank Lloyd Wright project by the Frank Lloyd Wright Archives inventory through lookup on Column [CORRECTED ARCHIVE #2] of Table MMTFFLLWINDEX.

Column: [LINE ITEM NUMBER] records a unique row identifier number for each row in this table.

Column: [?] records a term to describe the perspective of a photograph. The choice list contains:

  • INT (Interior)
  • EXT (Exterior)
  • FRN (Furniture)
  • DWG (Drawing)

Column: [PHOTO/AUTHOR] records the name of a photographer. The choice list contains:

  • Ackerman, James
  • Architectural Rec[ord]
  • Blessing, Hedrick
  • Capital Times
  • Fuerman, Henry
  • Futagawa, Yukio
  • Geiger, John W.
  • Guerrero, Pedro
  • Levine, Mel
  • Meehan, Patrick
  • Storrer, William
  • Western Architect
  • St/Hist/Soc/Wisc (State Historical Society of Wisconsin)
  • Vesey, Richard

Column: [SOURCE] records an abbreviation identifying the source where Geiger located a photograph.

Column: [SOURCE2] is void of entries in all rows.

Column: [SOURCE#] records a 4 digit number which may be related to Column [RECORD NUMBER] of Table MMTFNL.

Column: [SOURCE FILE #] records a four digit number or other marking to indicate a page number.

Column: [C] records the character "C" or "1" for an unknown purpose.

Column: [DATE] records a date in month/day/yearY format for a photograph.

Column: [SUBJECT] records a descriptive title for a photograph (e.g., "Living room," "Entrance court," etc.).

Column: [LONG:DESCRIPTION] records a more detailed description of the perspective or contents of a photograph.

Column: [LONG:COMMENTS] records a comment about a photograph. Used in only 1 instance.

Note: The DataEase Table Definition printout, above, differs in the fields assigned for comments, but no data appears to be absent.

RELATED QUERY PROCEDURES

This table is not referenced directly in any of the query procedures devised by Geiger.