Data Class Name: Forest Insect Damage Event

Land Information Ontario (LIO) Warehouse

Documentation

Produced by: Information Access and Information Management Policy Unit

Ministry of Natural Resources and Forestry

Date: July 27, 2015

Purpose

This document provides additional information to support the use of geospatial data. The Physical Model Diagram provides a visual representation of the relationships in the data class. The Data Change History lists all the modelling and access changes that have occurred during the lifecycle of the data class. A data description identifying table and field names is available upon request.

Need Assistance?

Please contact LIO Support at or 705-755-1878 if you require help.

Data Class Change History

Data Class Name: Forest Insect Damage Event

Data Class Short Name: INSCTDAM

Date
YYYY-MM-DD / Details of Change /
2014-04-08 / Add new Lookup Table value to: FOREST_INSECT_NAME_LIST
FOREST_INSECT_NAME = Satin Moth
SCIENTIFIC_NAME = Leucoma salicis
BIOTICS_ID = 199235
2013-09-11 / 1) Add new Lookup Table value to: FOREST_INSECT_NAME_LIST
FOREST_INSECT_NAME = Birch Casebearer
SCIENTIFIC_NAME = Coleophora serratella
BIOTICS_ID = 198492
2) Change existing value in: FOREST_INSECT_NAME_LIST.FOREST_INSECT_NAME
Replace value Pinkstriped Oakworm with Pink-striped Oakworm

3) Data Correction: FOREST_INSECT_DAMAGE_EVENT_FT.FOREST_INSECT_NAME

Replace value Pinkstriped Oakworm with Pink-striped Oakworm
2009 / Data Class remodeled and simplified. Includes renaming data class from 'Insect Damage Area' to 'Forest Insect Damage Event'. Short name remains the same (INSCTDAM). GUTS also converted to Lookup Table values with the name of the insect e.g. 'Gypsy Moth Damage' will now be entered as 'Gypsy Moth'.
New values added to FOREST_INSECT_NAME_LIST:
· Forest_Insect_Name: Bronze Birch Borer
Scientific Name: Agrilus anxius (Gory)
Biotics_ID: 194457
· Forest_Insect_Name: Cherry Scallop Shell Moth
Scientific Name: Hydria prunivorata (Ferguson)
Biotics_ID: 199102
Lookup table Changes: FOREST_INSECT_NAME_LIST
· Pink-striped Oakworm moth corrected to Pinkstriped Oakworm
Data Correction: FOREST_INSECT_DAMAGE_EVENT_FT.FOREST_INSECT_NAME
Convert any Column value of 'Pink-striped Oakworm moth' to the correct value: 'Pinkstriped Oakworm'
2008 / GUT split/renaming with new value added:
- Elm Spanworm and Lesser Maple Spanworm Damage’ renamed to 'Elm Spanworm Damage'.
New GUT:
- Lesser Maple Spanworm Damage
2007-10-15 / New GUTS added
· Willow Leafminer Damage
· Unknown Aspen Leafroller Damage
· Oak Defoliators Complex Damage
New domain value added for damage rank: 'Light-Moderate'.
2007 / New GUTS added:
· Bronze Poplar Borer Damage
· Oak Leaf Roller Damage
· Maple Leaf Roller Damage
· Misc Beetle Damage to Jack Pine
· Hickory Leaf Roller Damage
2005 / New GUT added:
· Elm Spanworm and Lesser Maple Spanworm Damage (GUT#6).
2000 / New GUTS added:
· Pine Engraver Beetle Damage
· White-Spotted Sawyer Damage
· Agrilus sp. Damage to Balsam Poplar
· Lesser Maple Spanworm Damage
· Maple Leaf Cutter Damage
· Redhumped Oakworm Damage
1999 / All Geographic Unit Types (GUTS) have been renamed for consistency and to make them shorter e.g. 'Insect Damage Area, Gypsy Moth' renamed to 'Gypsy Moth Damage'.
1998 / NEW Data Class – Insect Damage Area (INSCTDAM)

Data Description
Please refer to the metadata record for the data description..