________________________________________________________________________________________

                                 Coastal Resource Mapping Ltd
                       104.5070 Uplands Drive, Nanaimo, BC, V9T 6N1 Canada
                              Office 250.758.4323     Fax 250.758.4326  
________________________________________________________________________________________

   Project:            Kingcome / Midcoast Cedar Summary
                       with First Nations Land Claims

   Principle Contact:  Scott Mitchell, Tenure Officer (Zone A)
                       North Island - Central Coast Forest District
                       Phone: (250) 956-5044 Fax:  (250) 956-5079
                       scott.mitchell@gems2.gov.bc.ca

   ===================================================================================



   CONTENTS
      DIRECTORY LISTING
      FILE DESCRIPTION
      NOTES


   DIRECTORY LISTING
			184,355,196 CEDAR_ONLY_PDF_PLOTS.zip
			558,560,564 PROJECT_AREA_RTL_PLOTS.zip
     			 36,563 CEDAR_ONLY_TABLE_GENERATOR.zip
    			181,173 CEDAR_ONLY_XLS_TABLES.zip
 			 50,193,837 MASTERDB_DBF.zip
 			511,408,478 MASTERDB_E00.zip
      			  6,675 Readme1st.txt


   FILE DESCRIPTION
     CEDAR_ONLY_XLS_TABLES.zip      Winzip File containing Excel97 Worksheets of Cedar
                                    summaries by Management unit
     CEDAR_ONLY_TABLE_GENERATOR.zip Winzip File containing an EXE for the Graphic User 
                                    Interface Program
     MASTER_DBF.zip                 Winzip File of the Midcoast/Kingcome Database containing:
                                    TSA, PARK, THLB, VEG information in .DBF format
     MASTERDB_E00.zip               Winzip File of the Midcoast/Kingcome ArcInfo GIS Coverage in
                                    ArcInfo Interchange format .E00
     CEDAR_ONLY_PDF_PLOTS.zip       Winzip File containing Adobe PDF files of the native land claims
                                    and Cedar by 50K Index Mapsheet.
     PROJECT_AREA_RTL_PLOTS.zip     Winzip File containing RTL plot files of the native land claims
                                    and Cedar by 50K Index Mapsheet.


   NOTES
    
   1 Excel Table Formula Derivitives
     Below is a listing on how the values are calculated in each field:
 
     Management Unit                     MNG_NM   Field in DB
        Available Attributes:
		   TSA 19
	       TSA 33
           Parks
           FN Land Claims

     Age Class                           REDUX_AC Field in DB
        Available Attributes:
           1-3
           4-6
           7-9
     Height Class                        REDUX_HC Field in DB
        Available Attributes:
           1-4
           5+
     Contributing / Non-Contributing     CONT_CLS Field in DB
     Total Area                          AREA / 10,000
     Total Volume                        ((VOL_11 + VOL_12 + VOL_13 + VOL_14 + VOL_15 + 
                                           VOL_16) * (AREA / 10,000))
     Species Volume (m3/ha)              SPECIES_VOLUME * (AREA / 10,000)
     Species Area                        SPECIES_PERCENT * (AREA / 10,000)
     Species Percentage                  Species Volume / Total Volume	
		
     **SPECIES_PERCENT** refers to either PERCENT_1 OR PERCENT_2 OR PERCENT_x...
     **SPECIES_VOLUME** refers to either VOL_11 OR VOL_12 OR VOL_1x...
     **Where Total Volume equals to 0.00, Volume data was not provided for, by the
       respective companies.
     **Where Species %'s are 0, since species percent is calculated based on species species
       volume divided by total volume, if no volume was provided, species % = 0
     **Real values may exceed number of decimal places as formatted in Excel (2). "0.00"
       Values may look absolute but can be "0.00000012345." The real values are input into
       the cells then formatted. Real values remain. 

   2 Plots
     Native & Cedar Plots files are identified by a number:
      

   3 Methodology
     Take existing TSA VEG coverage and remove all information where Donuts exist. Add 
     Park FC and THLB information into the voided areas of the TSA. 
     Native claims are then added to the coverage.

   4 Directions on using the Summary Table Generator
     This is an Executable Program. Once intialized, Click on Open, and select the masterdb.dbf provided.
     Ensure that MS OFFICE 97 or greater is installed on the computer.
     The program will open the DBF. Depending on the Speed of the CPU on the computer this process
     of opening the file may take upwards to 30 minutes due to number of records in dbf.
     Once opened, select the destination directory for the Excel Output.
     Select the Management Unit by which to generate tables for. Multiple-selects allowed.
     Click on the affirmative to start generating tables.