Appendix 7: Spatial Processing for Habitat Indicators
| Dataset Name | Filter | Processing | Source | Indicator | Region(s) |
|---|---|---|---|---|---|
| Surface Disturbance - Areal Features | TYPE_INDUSTRY = ‘Agricultural’ –> se type 6 | 1. Apply filters 2. Assign se_type codes to each filter 3. Union inputs 4. Calculate max_type_code 5. Dissolve on max_type_code 6. Reclassify max_type_code to populate datasource and type (Unknown, Unknown (clearing), Rangeland, Cropland, Agriculture (Farms, Ranches, or Other Agricultural Activities) ) 7. Intersect with watersheds to calculate % watershed affected by agriculture = agricultural area/total watershed area |
GeoYukon | Agriculture | Yukon |
| Baseline Thematic Mapping | PLU_LABEL = ‘Agriculture’ –> se type 5 PLU_LABEL = ‘Range Lands’ –> se type 4 |
Same as above | DataBC | Agriculture | BC |
| VRI | NON_PRODUCTIVE_DESCRIPTOR_CD = ‘OR’ –> se type 3 NON_PRODUCTIVE_DESCRIPTOR_CD = ‘C’ –> se type 1 |
Same as above | DataBC | Agriculture | BC |
| Historical Fire Polygons | FIRE_YEAR >= 1965 (last 60 years) | 1. Apply filters 2. Calculate YEARS_SINCE 3. Merge inputs 4. Union with burn severity polygons 5. Identity with Forest Inventory Zones to identify coastal vs interior 6. Calculate PF_FACTOR_TIME 7. Calculate PF_FACTOR_SEVERITY based on coastal vs interior 8. Calculate PF_FACTOR = PF_FACTOR_TIME * PF_FACTOR_SEVERITY 9. Dissolve on PF_FACTOR 10. Split by PF_FACTOR 11. Union the split feature classes 12. Calculate MAX_PF_FACTOR 13. Dissolve on MAX_PF_FACTOR 14. Intersect with watersheds to calculate % watershed affected by fire = (affected area * pf_factor)/total watershed area |
DataBC | Fire | BC |
| Current Fire Polygons | N/A | Same as above | DataBC | Fire | BC |
| Fire History | FIRE_YEAR >= 1965 AND FIRE_YEAR < 9900 (last 60 years) | Same as above | GeoYukon | Fire | Yukon |
| Burn Severity Polygons | N/A | Same as above | DataBC | Fire | BC |
| Forest Inventory Zones | FRST_NVNTE IN (‘A’, ‘B’, ‘C’) (coastal zones) | Same as above | DataBC | Fire | BC |
| Harvested Areas in BC (Consolidated Cutblocks) | HARVEST_YEAR >= 1965 (last 60 years) | 1. Apply filters 2. Calculate YEARS_SINCE_HARVEST 3. Merge inputs 4. Calculate PF_FACTOR 5. Erase reserves 6. Dissolve on PF_FACTOR 7. Split by PF_FACTOR 8. Union 9. Calculate MAX_PF_FACTOR 10. Dissolve on MAX_PF_FACTOR 11. Intersect with watersheds to calculate % watershed affected by forest harvest = (affected area * pf_factor)/total watershed area |
DataBC | Harvest | BC |
| Forest Openings | OPENING_TYPE <> ‘Delete’ | Same as above | GeoYukon | Harvest | Yukon |
| Forest Openings Pre-1990 | ACTIVITY1 = ‘Logging’ AND START_YEAR .= 1965 (last 60 years) |
Same as above | GeoYukon | Harvest | Yukon |
| Historic Silviculture Inventory 50K | HARVEST_START >= timestamp ‘1965-01-01 00:00:00’ (last 60 years) | Same as above | GeoYukon | Harvest | Yukon |
| Surface Disturbance - Areal Features | TYPE_INDUSTRY = ‘Forestry’ | ||||
| Logging History on Haida Gwaii 1962 to 2021 | First_Harvest_Year >= 1965 OR Second_Harvest_Year >= 1965 (last 60 years) | Same as above | Gowgaia Institute | Harvest | Haida Gwaii |
| Results Inventory (for reserves) | ((RES_CD IN (‘G’) and STK_ST_CD = ‘MAT’ and UPDATE_YR >= 2012) OR (RES_CD IN (‘G’) and STK_ST_CD = ‘MAT’ and RES_OBJ_CD = ‘WTR’) OR (RES_CD IN (‘G’) and STK_ST_CD in (‘NP’, ‘MAT’,‘IMM’,‘RES’) and STK_TP_CD in (‘NAT’, ‘FOR’, ‘BR’)) OR STK_ST_CD in (‘L’, ‘M’, ‘R’, ‘S’)) AND GEOM_YN = ‘Y’ | 1. Apply filters 2. Dissolve |
DataBC | Harvest | BC |
| Pest Infestation Polygons | PEST_SEVERITY_CODE IN (‘V’, ‘S’, ‘M’) AND PEST_SPECIES_CODE NOT LIKE ‘A%’ AND PEST_SPECIES_CODE NOT LIKE ‘N%’ AND PEST_SPECIES_CODE NOT LIKE ‘T%’ AND PEST_SPECIES_CODE NOT LIKE ‘V%’ AND CAPTURE_YEAR >= 1965 (last 60 years) | 1. Apply filters 2. Union with VRI dead layer 3. Calculate YEARS_SINCE_PEST 4. Calculate PF_FACTOR_TIME 5. Calculate PF_STAND_PCT_DEAD (either from the midpoint of the severity mortality range or VRI stand_percentage_dead, whichever is greater) 6. Calculate PF_FACTOR_SEVERITY (if severity is moderate = 0.5; if severity is severe or very severe = 1) 8. Calculate PF_FACTOR = PF_FACTOR_TIME * PF_FACTOR_SEVERITY * PF_STAND_PCT_DEAD/100 9. Count overlapping features 10. Join overlapping features 11. Summarize MAX_PF_FACTOR 12. Join MAX_PF_FACTOR back to planarized features 13. Intersect with watersheds |
DataBC | Insects | BC |
| Forest Health Overview | SEVERITY_CODE IN (‘V’, ‘VS’) AND DISTURBANCE_CODE NOT LIKE ‘A%’ AND DISTURBANCE_CODE NOT LIKE ‘N%’ AND DISTURBANCE_CODE NOT LIKE ‘T%’ AND DISTURBANCE_CODE NOT LIKE ‘V%’ AND SURVEY_YEAR >= 1965 (last 60 years) | Same as above | GeoYukon | Insects | Yukon |
| VRI Dead Layer | EARLIEST_NONLOGGING_DIST_TYPE LIKE ‘I%’ AND EARLIEST_NONLOGGING_DIST_DATE IS NOT NULL | Stand percentage dead used where greater than the midpoint of the severity rating range (from pest infestation polygons layer) | DataBC | Insects | BC |
| Minfile Inventory Database | STATUS_DS IN (‘Producer’, ‘Past Producer’) | 1. Apply filters 2. Add and calculate standardized fields: se_source, se_type, commodity_d, names, status_d 3. Append BC points into one feature class 4. Convert Yukon polygons to points (inside = true) 5. Append Yukon gravel points with step 3 output 6. Append BC points (step 3) with Yukon points (step 5) 7. Intersect with watersheds to calculate number of mines per km2 |
DataBC | Mines | BC |
| Minfile Production Database | Spatial selection – features that do not intersect selected features from inventory dataset (row above) | Same as above | DataBC | Mines | BC |
| BC Aggregate Inventory Private Pits (2004) | N/A | Same as above | British Columbia Geological Survey MapPlace | Mines | BC |
| Minfile - Mineral Occurrences | STATUS_DS IN (‘Producer’, ‘Past Producer’) | Same as above | GeoYukon | Mines | Yukon |
| Historic Mineral Claims | DRAFTING_TENURE_TYPE = ‘Prospecting Placer Licenses’ AND TENURE_STATUS = ‘Expired’ | Same as above | GeoYukon | Mines | Yukon |
| Surface Disturbance - Areal Features | TYPE_INDUSTRY = ‘Mining’ AND TYPE_DISTURBANCE = ‘Placer Mining - Significant’ OR TYPE_DISTURBANCE = ‘Mining’ | Same as above | GeoYukon | Mines | Yukon |
| Gravel Pits 25K | N/A | 1. Filter by points within 1km of Minfile points to remove duplicates. 2. Same as above |
GeoYukon | Mines | Yukon |
| BC CEF Integrated Roads | N/A | 1. Pairwise dissolve BC roads 2. Buffer resource roads, Yukon Roads, Network, Trails, Vegetation Inventory Roads, and Surface Disturbance by 30m 3. Erase each roads layer that are within the 30m of buffers of all other roads layers 4. Merge Yukon Surface Disturbance output with outputs of step 3 5. Erase BC from step 4 (some Yukon roads overlap with BC) 6. Pairwise dissolve step 5 7. Merge YT (step 6) with BC dissolved roads (step 1) 8. Intersect with watersheds to calculate length (km) of roads per km2 |
DataBC | Roads | BC |
| Yukon Road Network | N/A | 1. Apply Filters 2. Same as above |
GeoYukon | Roads | Yukon |
| Forestry Resource Roads 50K | N/A | 1. Apply Filters 2. Same as above |
GeoYukon | Roads | Yukon |
| Trails CanVec 50K | 1. Apply Filters 2. Same as above |
GeoYukon | Roads | Yukon | |
| Vegetation Inventory Roads 40K | 1. Apply Filters 2. Same as above |
GeoYukon | Roads | Yukon | |
| Surface Disturbance - Linear Features | TYPE_INDUSTRY = ‘Transportation’ | 1. Apply Filters 2. Same as above |
GeoYukon | Roads | Yukon |
| BC CEF Human Disturbance OGC_Geophysical_1_SLU_raw | N/A | Add and calculate standardized fields: DISTRB_CD, DISTRB_GRP | DataBC | Urban & Industrial | BC |
| BC CEF Human Disturbance OGC_Infrastructure_1_SLU_raw | N/A | Same as above | DataBC | Urban & Industrial | BC |
| BC CEF Human Disturbance Power_1_Dams_raw | N/A | Same as above | DataBC | Urban & Industrial | BC |
| BC CEF Human Disturbance Power_2_Transmission_Lines_GBA_raw | N/A | Same as above | DataBC | Urban & Industrial | BC |
| BC CEF Human Disturbance Rail_and_Infrastructure_1_Railways_GBA_raw | N/A | Same as above | DataBC | Urban & Industrial | BC |
| BC CEF Human Disturbance Rail_and_Infrastructure_2_Railways_GBA_NEBC_raw | N/A | Same as above | DataBC | Urban & Industrial | BC |
| BC CEF Human Disturbance Rail_and_Infrastructure_3_VRI_Airports_raw | N/A | Same as above | DataBC | Urban & Industrial | BC |
| BC CEF Human Disturbance ROW_1_Surveyed_raw | N/A | Same as above | DataBC | Urban & Industrial | BC |
| BC CEF Human Disturbance ROW_2_Crown_raw | N/A | Same as above | DataBC | Urban & Industrial | BC |
| BC CEF Human Disturbance Urban_1_BTM_raw | N/A | Same as above | DataBC | Urban & Industrial | BC |
| BC CEF Human Disturbance Urban_2_VRI_raw | N/A | Same as above | DataBC | Urban & Industrial | BC |
| Landcover circa 2000 | COVTYPE = 34 Urban | 1. Apply filters 2. Merge YEC_Power_Lines, YEC_Power_Distribution_Lines, Utilities_Line_50k (Transmission line), Surface Disturbance (electric utility corridor) 3. Buffer step 2 power lines by 12.5m then dissolve -> power lines 4. Merge pipeline_1 and Utilities_Line_50K (pipeline), Surface Disturbance (pipeline) 5. Buffer step 4 pipelines by 25m then dissolve -> oil and gas infrastructure 6. Buffer track_segment_1 and Surface Disturbance (railway) by 10m then merge with runways_25k and dissolve -> rail and airport 7. Buffer Surface disturbance (survey cutlines, seismic lines, and trenches) by width field, then merge and dissolve 8. Buffer YEC_Power_Generating_Stations and YEC_Power_Substations points by 20m 9. Merge power stations (step 8), survey, seismic and trenches (step 7), rail and airport (step 6), oil and gas infrastructure (step 5), power lines (step 3) with urban (LCC landcover), YEC_Power_Generating_Stations, YEC_Power_Substations, Surface Disturbance (urban, oil and gas, mining, utility) 10. Add and calculate standardized fields: DISTRB_CD, DISTRB_GRP |
Government of Canada | Urban & Industrial | Yukon |
| Utilities_Line_50k | “FEATURE” = ‘Transmission line’ “FEATURE” = ‘pipeline’ |
Same as above | GeoYukon | Urban & Industrial | Yukon |
| YEC_Power_Lines | N/A | Same as above | GeoYukon | Urban & Industrial | Yukon |
| YEC_Power_Distribution_Lines | N/A | Same as above | GeoYukon | Urban & Industrial | Yukon |
| YEC_Power_Generating_Stations | N/A | Same as above | GeoYukon | Urban & Industrial | Yukon |
| YEC_Power_Substations | N/A | Same as above | GeoYukon | Urban & Industrial | Yukon |
| Railroads_50K_Canvec canvec_50K_YT_Transport.gdb_segment_1 | N/A | Same as above | GeoYukon | Urban & Industrial | Yukon |
| Runways_25k | N/A | Same as above | GeoYukon | Urban & Industrial | Yukon |
| Canvec Pipelines 50K canvec_50K_YT_Res_MGT.gdb_1 | N/A | Same as above | Natural Resources Canada | Urban & Industrial | Yukon |
| Surface Disturbance - Linear Features | TYPE_DISTURBANCE = ‘Railway’ OR TYPE_DISTURBANCE = ‘Electric Utility Corridor’ OR TYP_DISTUBANCE = ‘Survey Cutline’ OR TYPE_DISTURBANCE = ‘Pipeline’ OR TYPE_DISTURBANCE = ‘Trench’ | Same as above | GeoYukon | Urban & Industrial | Yukon |
| Surface Disturbance - Areal Features | TYPE_INDUSTRY = ‘Utility’ OR TYPE_INDUSTRY = ‘Mining’ OR TYPE_INDUSTRY = ‘Oil and Gas’ OR TYPE_INDUSTRY = ‘Urban’ | Same as above | GeoYukon | Urban & Industrial | Yukon |