RESULTS Spatial Views & Business Overview

1. RESULTS Spatial Views& Business Overview Presented by Mei-Ching Tsoimtsoi@shaw.ca November 2009

2. RESULTS – Provincial Coverage THLB1 23 million hectares As of November 2009: Number of Openings: 223,900 Represented area: 9.2 million hectares (40% THLB) Annual additions: 7,800 openings per year 220,000 hectares per year 1 Timber Harvesting Land Base - Just the Facts

3. RESULTS Scope • Area harvested under tenure – basic obligations • Major licensee • BCTS • Woodlots, Community Forest Agreements • Areas harvested with no silviculture obligations but reported due to specific reporting policies (eg. small scale salvage) • Free growing stands if managed under silviculture obligation or managed by the Ministry • Natural disturbance areas managed by the Ministry • Backlog areas (pre-1987 areas) • Shell openings where there are requirement to report to RESULTS (eg. Aerial fertilization, MSMA treated areas)

4. RESULTShttp://www.for.gov.bc.ca/his/results/ Business documentation Technical documentation Spatial Views Training materials Application support

5. RESULTS Business guidance • RESULTS Information Submission Specifications – Licensee Submissions • Silviculture Information Submission Specifications – Government Funded Silviculture Activities • Woodlot Licence Guide to Submission of Silviculture Reporting Requirements to RESULTS via ESF • Post Harvest Reporting Requirement for Small Scale Salvage Licences to Cut

6. RESULTShttp://www.for.gov.bc.ca/his/results/spatialviews.htm

7. RESULTShttp://www.for.gov.bc.ca/his/results/spatialviews.htm Overview provides RESULTS business context, description of views, historical context of spatial information availability, assumptions and limitations in business view usage.

8. RESULTS – Four Core Layers of Spatial Coverage in LRDW Raw

9. RESULTS – Current Old Views * These views are not optimized and will be replaced with new business views

10. RESULTS – Raw Normalized Tables Note all Tables/Layers are represented. Illustration of how all the bits and pieces are stored and previous requirement for end-users Identify data in which table and understand how to link.

11. RESULTS - New Business Views RESULTS Business Views released in December 2008 “Flattened” datasets to simplify data access to minimize post-processing reduces complex table joins (improves ease, access and performance) Limitation in column widths requires still some joins Geometry Exist Indicator will make assessment of spatial data availability during analysis & reporting more obvious.

12. RESULTS – Efficiencies Gained through New Business Views - Examples RSLT_OPENING_SVW CONTAINS INFORMATION FROM OPENING CUT_BLOCK_OPEN_ADMIN PROV_FOREST_USE FOREST_MGMT_UNIT ACTIVITY_TREATMENT_UNIT STOCKING_ECOLOGY ORG_UNIT CLIENT OPENING_POLY RSLT_FOREST_COVER_INV_SVW CONTAINS INFORMATION FROM FOREST_COVER FOREST_COVER_LAYER FOREST_COVER_LAYER_SPECIES STOCKING_STANDARD STOCKING_ECOLOGY FOREST_COVER_POLY

13. RESULTS – Efficiencies Gained through New Business Views - Examples RSLT_STANDARDS_UNIT_SVW CONTAINS INFORMATION FROM STOCKING_STANDARD_UNIT STOCKING_LAYER STOCKING_LAYER_SPECIES STOCKING_ECOLOGY STOCKING_MILESTONE STOCKING_STD_UNIT_POLY

14. RESULTS - New Business Views

15. RESULTS - New Business Views

16. RESULTS - New Business Views

17. RESULTS - New Business Views

18. RESULTS – Spatial Genesis Pre-RESULTS (ISIS) • Attribute only database. • No spatial in system. • All mapping done through inventory. RESULTS • November 2003 created capability for ESF spatial data capture • Attempt to mine inventory maps to recreate spatial information - use mapsheet & opening number if matched - merged forest cover inventory polygons to create opening boundary - successful conversion populated OPENING_POLY with meta-data as RESULTS Opening Spatial Conversion Entry Userid: “ROSC-AGENT” - limited TFL spatial data to convert

19. RESULTS – Spatial Genesis • RESULTS – Inventory Conversion created 111,000 spatial records in OPENING_POLY (out of 186,000 openings in 2004) • Linework originated from MOFR inventory mapping based on digitizing off of paper maps. • Must be careful about data origin if concern about data quality – need to review meta-data on Update Userid – ROSC vs. licensee submission? Should not ask licensee to correct ROSC spatial linework as this was done by MOFR.

20. RESULTS – Spatial Completeness Opening & Forest Cover Scenarios: • No Opening and no Forest Cover spatial; attribute only • Opening only, no Forest Cover spatial • No Opening, Forest Cover spatial only • Both Opening and Forest Cover spatial

21. RESULTS – Spatial Completeness Activity Treatment Unit (optional) • Some form of generalization will need to occur to infer where an activity took place using some other spatial information

22. RESULTS – Legislative Reporting

23. RESULTS - Data Quality & CompletenessScenario 1: Missing RESULTS Spatial • There are approximately 36,000 Openings in RESULTS that do not have ANY spatial represented • Depending on type of analysis, there may be requirement to quantify records missing in spatial component. Example Opening ID’s: -52170000, -499850000

24. RESULTS - Data Quality & CompletenessScenario 2: ESF Opening & Submitted FC Opening Spatial (red) and Forest Cover Spatial (grey) matches. ESF submission of both spatial. Meta Data Entry User ID = “idir” or “bceid” Example Opening ID’s: 71586, 83174, 97500

25. RESULTS - Data Quality & CompletenessScenario 3: SP – ROSC Spatial Only (outline) ROSC is based on matches with inventory spatial based on matches of mapsheet and opening numbers. If opening number matched, all associated forest cover polygon for the opening was merged to create outer opening boundary. No internal linework for Standards Units available. Example Opening ID’s: 26625, 49707, 89152, 92973

26. RESULTS - Data Quality & CompletenessScenario 4: No Opening Spatial & Submitted FC No Opening Spatial ROSC conversion was not successful or Opening spatial not required yet. All Forest Cover Spatial submitted by ESF Meta Data Entry User ID = “idir” or “bceid” Mapview search is uses Opening spatial and therefore would not locate this opening. Example Opening ID’s: 1249, 4371, 27077, 32719

27. RESULTS - Data Quality & CompletenessScenario 5: ROSC Converted Opening & Submitted FC Opening spatial (red) – RESULTS Opening Spatial Conversion (ROSC) derived linework based on vegetation inventory based on Mapsheet & Opening number match. Meta Data Entry User ID = “ROSC_AGENT” --------------------------------------------------------- Forest Cover boundary (grey) – submitted By ESF Licensee, contractor working on behalf of Licensee, MOF staff, or MOF contractor. Meta Data Entry User ID = “idir” or “bceid” ---------------------------------------------------------- Must check on meta data where data quality is questioned. Cannot request to fix ROSC linework! Example Opening ID’s: 27419, 95607, 102089

28. RESULTS – Spatial data completeness • Wide range of spatial completeness (by org unit, by management, by time period) • Mandatory opening definition and forest cover submissions with map for most forest tenure openings as of April 2007. • Best coverage is to use combined OPENING_SVW & FOREST_COVER_INV/SILV_SVW – but there are trade offs in terms of level of resolution and “generalizations”. • Must verify against attribute only to determine % of spatial coverage available to inform level of spatial data completeness. • GEOMETRY_EXISTS_IND helps with qualifying of spatial information in analysis

29. RESULTS – Moving Forward • RESULTS Strategic Data Clean up Project is locating missing Forest Cover attribute reporting for not free growing stands. • Assumption is that missing forest cover attribute indicates that inventory does not have any information regarding these openings (no depletions and potential over-estimation of volume in current inventory) • If opening is missing forest cover spatial, if not yet free growing, we will get this through normal reporting cycle (at regeneration or at free growing. • If opening is missing spatial and is free growing, there is new expanded scope to locate – but limited to what is achievable in two month period.

30. RESULTS – Moving Forward • Licensee can submit and update their spatial information at any time. • New openings: Licensee must supply Opening/Standards Unit & Forest Cover map for any new harvesting. • Not free growing openings: Licensee do not have to supply any spatial for any older components (eg. Opening/Standards unit boundaries) but must meet mandatory requirements for any s.86 reporting requirements or RG/FG forest cover updates with map. • Combination of Opening/Standards Unit Poly and Forest Cover Poly will give the most complete coverage.

31. RESULTS - Verify Analysis Outcomes Against Data Source LRDW has no checks on your outcomes Your responsibility will be to review outcome against RESULTS to check correct methodology and assumptions.

32. RESULTS - Spatial Data Quality • Spatial Data Quality is specified in submission requirements document within Mapping Standards section. • Geomatics staff are front-line people working with RESULTS Spatial Data and would potentially identify issues with spatial data quality. • Any obvious errors beyond mapping standards tolerances should be tracked. Remember that ROSC - is based on Ministry’s old inventory data - therefore no authority to ask licensees to correct.

33. RESULTS – Quality Assurancehttp://www.for.gov.bc.ca/his/results/business.htm#Quality_Assurance Protocol provides direction to MOF staff how to resolve any attribute or spatial errors.

34. RESULTS - Spatial Data Evolution • RESULTS Spatial Data: • RESULTS LRDW Business Views will be available to any users who can accesses the LRDW • RESULTS Forest Cover information being leveraged by Vegetation Resource Information Management System (VRIMS). More timely data to support inventory update process & Timber Supply Review. • Most up-to-date information on forest management on Crown land accessible for wider audience – “on demand” reporting

35. RESULTS - Cleaning House • There will be a plan to retire old layers on the LRDW. • Immediate: Retire old ISIS tables. No one should be using these as these has not been updated since 2003! • Gradual: Schedule to be determine for tables/layers that is now replaced by new views. Custodians are mindful that current work is hooked up to these layers and must give an adequate period to switch over. No timeline set yet – can provide reasonable transitional period since internal MOF/Geomatics are primarily users. Transitional strategy will be communicated.

36. RESULTS - Spatial Analysis – Special Cases – Overlapping Openings Overlapping allowed as response to MPB and Catastrophic Fires over pre-existing openings Presents challenges for spatial analysis

37. RESULTS - Spatial Analysis – Special Cases – Aerial Fertilization Vast Areas Activity Areas RESULTS openings used as shells to track aerial fertilization application reporting. Coded as: Base = FE Technique = CA Irregular line work is due to GPS of the swaths during aerial application. Objective is to track these stands as they should not be logged until volume gains have been realized otherwise investment is not optimized. For new shell openings – there will not be any Opening or Forest Cover Spatial. Example Opening ID’s: 1097310 ,1091836, 1113376

38. RESULTS - Spatial Analysis – Special Cases – MSMA* “Crop Circles” – Odd Shape Activity Maps reported into RESULTS for MSMA* Tracking. Based on Policy Requirement that trees treated with MSMA must not be harvested. Used by ILRR. Coded as: Base = PC Technique = CG Method = MSM *Monosodium Methanearsenate Treatments Example Opening ID’s: 1186282, 1162950, 88644

39. RESULTS - Spatial Analysis – Special Cases – Retired Openings • Retirement of old openings Opening Status Code – RMD Linework remains but considered to no longer be applicable but kept for historical reference purposes/ • There are 41 openings (very few)

40. RESULTS – Business View Model OPENING_SVW OPENING_VW join via Opening ID FOREST_COVER_ RESERVE_SVW (2) FOREST_COVER_INV_SVW FOREST_COVER_SILV_SVW STANDARDS_ UNIT_SVW ACTIVITY_ TREATMENT_SVW PLANTING_SVW join via stocking_standard_unit_id(1) join via Forest_Cover_ID Forest_Cover_Layer_ID FOREST_COVER_ SPECIES_VW Key • Not all forest cover polygons have SU link, only use if required, must create an outer join/link • If require additional forest cover information, must connect through OPENING_VW & FOREST_COVER_INV_SVW Attribute View Spatial View Join/Key/Link

41. Overview of Spatial Layers-Opening/Standards Units SU 1 SU 1 Opening 123 SU 2 SU 2 Standards Units represents a part of the opening for one or parts where there is similar soil disturbance, regeneration and free growing dates, stocking standards and free growing height that contributes to establishing free growing stand on the opening. Standards Units cannot overlap within the same opening.

42. Overview of Spatial Layers-Disturbance & Silv Activities Site Preparation Planting Opening 123 Planting Brushing Activities can be harvesting and silviculture activities. Different activities may overlap each other within the same opening. Note that activity spatial are optional.

43. Overview of Spatial Layers-Forest Cover Poly 1 Poly 1 Poly 1 Poly 5 Poly2 Opening 123 Poly 5 Poly 3 Poly 3 Poly 4 Poly 4 Forest cover polygons cannot overlap each other within the same opening. Complete forest cover must be submitted for entire opening. Forest Cover polygons are separated due to differences in forest stand conditions. Forest cover polygon cannot straddle/overlap standard unit boundaries. More than one forest cover polygon can exist within the same standard unit boundary. Forest cover polygon boundaries exists for openings updated after Nov 2003.

44. RESULTS – Generalization Activities OPENING_SVW & OPENING_VW Actual Opening SU 1 Net Area to be Reforested = 15.0 ESSF dc1 01 SU 2 Net Area to be Reforested = 20.0 ESSF dc1 04 SU 1 Opening 123 SU 2 Opening SVW/VW Generalization Largest NAR BEC, or if NAR is the same, take first BEC and apply to entire opening Opening 123 Generalized BEC = ESSF dc1 04 in OPENING_SVW & OPENING_VW

45. RESULTS – Generalization Activities OPENING_SVW & OPENING_VW Planting1 Opening 123 Planting3 Opening SVW/VW Generalizations BEC - largest Disturbance – 1st and 2nd Site Preparation - 1st and 2nd Planting – 1st and 2nd Brushing – 1st Spacing – 1st Fertilization – 1st Pruning – 1st Count of activities provided if require more details Planting2 Opening 123 Views provides 1st and 2nd planting only with count of planting activity in OPENING_SVW & OPENING_VW

46. RESULTS – Generalization Activities OPENING_SVW & OPENING_VW Actual Opening Planting1 = 10ha Planting2 = 15ha Planting3 = 30ha Planting1 Opening 123 Planting3 Planting2 Opening SVW/VW Generalization Provides only the 1st and 2nd planting activities With Count indicating if there are more then go to ACTIVITY_TREATMENT_SVW if more details required Opening 123 Views provides 1st and 2nd planting only with count of planting activity in OPENING_SVW & OPENING_VW

47. RESULTS - Future • Managing spatial data is a new challenge for the Project Team. • Process will be evolving – will get feedback on new business views. • Increasing interest in the data usage – sharing business understanding, training and communication. • New Business Views simplifies data access but does not take away requirement for baseline business knowledge on how to relate the data, data context and data limitations when performing analysis.

48. RESULTS - Spatial Views & Business Overview Thank You Contact Information: Caroline MacLeod - RESULTS Lead: Caroline.MacLeod@gov.bc.ca Mei-Ching Tsoi – consultant: mtsoi@shaw.ca

49. RSLT_OPENING_SVW & VW • Merged tenure information if exists • VW – to be used to join to access general information to other SVW • Generalized Biogeoclimatic information based on the Largest Standards Unit (or first where net area is zero) • 1st and 2nd disturbance (silv system, date, disturbance code) • 1st and 2nd completed site preparation and planting (technique, date, area, count of SP & PL activities) • 1st brushing, 1st spacing,1st fertilization,1st pruning • With technique, date, area, count of activities • Geometry Exists Indicator – ability to analysis attribute only records when performing spatial analysis • If required more detailed or accuracy of Biogeoclimatic and Disturb/Silv – go to Standards Units & Activity Treatment Unit tables.

50. RSLT_STANDARDS_UNITS_SVW • Will need to combine with OPENING_VW to get identification information • One row represents in standards unit (SU) and milestone information • Opening may have one or more standards unit • Even-age (“I”) and Uneven-Age (“I1*”,”I2*”,”I3*”,”I4*” stocking standards are shown in separate sets of columns • Standards Unit Type – derived data to allow sorting by “Even” or “Uneven” stocking standards. • Geometry Exists Indicator – ability to analysis attribute only records when performing spatial analysis • All opening with reforestation obligations must have SU. • Declarations are OPTIONAL. • Only those openings created since November 2003 will have detailed SU spatial.