< previous | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | a | b | c | next >

APPENDIX C - Photo Database

The Photo Database and its related image files can be accessed directly from the "photos" folder on the companion CD-ROM. The Photo Database files may also be copied from the companion CD-ROM to your computer's hard drive and then accessed from that hard drive. This method may be somewhat faster in terms of response time, depending upon your computer system. The Photo Database files are also available as downloads from the web. The procedures for installing the files are described below:

Steps for Accessing the Photo Database
Directly from the companion CD-ROM:
  • access the directory for the CD-ROM in your CD Drive
  • open the "photos" folder
  • double click on the MS Excel file "photo database.xls".


    • Files copied from the companion CD-ROM to your computer's hard drive:
  • access the directory for the CD-ROM in your CD Drive
  • copy the folder "photos" to an appropriate folder on your hard drive
  • open the copied "photos" folder on your hard drive
  • double click on the Excel file "photo database.xls"


    • Files downloaded from the Web version onto your computer's hard drive:
  • go to the web version of this Handbook at http://www.rcnm.us/handbook
  • on the web version, go to Appendix C and follow the instructions for downloading and installing the Photo Databse zipped file
  • once the photos.zip file has been successfully downloaded and unzipped, open the copied "photos" folder on your hard drive
  • double click on the Excel file "photo database.xls"


    • Using the Photo Database Excel File
    Whichever method is used to access the photo database, MS Excel is required to run the database program.

    The Photo Databse file has 2 tabs along the bottom. The first one is "Photo Data" which contains all related information for each photo. The "Thumbnails" tab contains a thumbnail of all the photos available in the database
    Figure C.1 Excel Photo Database highlighting the "Photo Data" and the "Thumbnails" tabs located in the bottom left corner.


    Photo Data tab
    This spreadsheet page contains the following information for each photo.

      Photo No.
      Abatement
      • Source
      • Path
      • Receiver
      Operation
      • Primary
      • Secondary
      • Multiple
      Equipment
      Location
      Year Taken
      RCNM References
      • Measured Lmax
      • Usage Factor
      Remarks
    Figure C.2 Example of the Excel Photo Database "Photo" tab highlighting the clickable Photo No. and the AutoFilter button.


    Linked Photo No.: double clicking on any of the photo numbers in the far left column, will display the photo in a high resolution format.

    AutoFilter Button: clicking on the AutoFilter button will display a list containing each of the items in the column, in alphabetical order, so that you can quickly find the item you want and click it. AutoFiltering selects just the data you need and hides all the rest. To further refine your search, you can repeat this process for any of the other columns of information. When you click on the AutoFilter arrow, only a list of the remaining items will be displayed for selection. Using the AutoFilter buttons does not change your data in any way. As soon as you select "all" in each of the columns used to define your search, all the data will reappear, exactly the same as it was before. Or, you can use the Excel tool bar "Data" option to return to the originally displayed information by selecting "Filter" and then "AutoFilter"

    Thumbnail tab
    The Thumbnail page contains thumbnail images of all the photos described in the database. Double clicking on any of the thumbnails will display the photo in a high resolution format.
    Figure C.3 Sample of the "Thumbnails" page. Each thumbnail is hyperlinked to a high resolution photo.




    < previous | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | a | b | c | next >