Forest Investment Account (FIA) - Land Base Investment Program - Innovative
FIA Project 4371001

    Sustainable Forest Management Strategy (SFMS) Project: March 2005 [2005 Project Description Only]
 
Imprint: Merritt, B.C. : Nicola Similkameen Innovative Forestry Society, 2005
Subject: Forest Investment Account (FIA), Sustainable Forestry, British Columbia, Biological Diversity
Series: Forest Investment Account (FIA) - Land Base Investment Program - Innovative
Description:
The project goal was to develop a process that aided in the management of protecting and enhancing forest practices, along with voicing First Nation’s community interests regarding natural resources. The Merritt Timber Supply Area (TSA) covers 1.16 million hectares in the southern interior of British Columbia. There are 12 landscape units within the Merritt TSA. The ratings tables for the 20 plant and wildlife species were used in conjunction with the Ecosystem-Based Resource Mapping Ratings Table Tool (ERM – tool) to create an amalgamated functional spatial (shape file) and aspatial (database) GIS layer. Each species included in this project had at least three associated shape files, a result of the three predictive models that had been used. A four-coloured rating scheme was developed that represented the ratings for each PEM polygon based on the respective model they were run through (suitability/ capability). Colours do not indicate a priority for management or an importance of the species; they only represent the suitability or capability of that site. The incorporation of the 20 species and multiple suitability/capability models in the SFMS project has resulted in a 30 Gigabyte (Gb) dataset that was compressed to about a 6 Gb final product. Analysis of the database started in Microsoft Access 2000 but Microsoft Access 2000 had some limitations regarding large file sizes and complex queries that complicated this process. Subsequently, primary queries of the data were transferred to Postgres (SQL), which was then re-queried to provide the results. A four-coloured rating scheme was developed that represented the ratings for each PEM polygon based on the respective model they were run through (suitability/ capability). Colours do not indicate a priority for management or an importance of the species; they only represent the suitability or capability of that site. The incorporation of the 20 species and multiple suitability/capability models in the SFMS project has resulted in a 30 Gigabyte (Gb) dataset that was compressed to about a 6 Gb final product. Analysis of the database started in Microsoft Access 2000 but Microsoft Access 2000 had some limitations regarding large file sizes and complex queries that complicated this process. Subsequently, primary queries of the data were transferred to Postgres (SQL), which was then re-queried to provide the results.
Nicola Similkameen Innovative Forestry Society.
Contact: Aird, Stuart, (250) 374-7112, saird@shaw.ca

Updated August 16, 2010 

Search for other  FIA reports or other Ministry of Forests and Range publications.

Please direct questions or comments regarding publications to For.Prodres@gov.bc.ca