Land Information Ontario (LIO) Warehouse

Data Class Name: OTN Trailhead

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: OTN Trailhead

Data Class Short Name: OTNTHD

Date
YYYY-MM-DD / Details of Change /
2010 / Lookup Table value altered in OTN_TRAIL_GROUPING_LIST
'Voyager Trail' was changed to 'Voyageur Trail'
2009-08 / Column altered: LENGTH_KMS-
Data type changed from NUMBER(4,1) to NUMBER(6,1)
Fields dropped:
- OTC_TRAIL_CHARACTER removed from Trailhead Table (moved to new table OTC_TRAIL_CHARACTER)
- TRANS_CANADA_TRAIL_IND
Trans Canada Trail Indicator was moved from OTN Trailhead to OTN Trailseg
Fields added:
- OTC_TRAIL_CHARACTER attribute added to new table for OTC trail character (moved from OTN_TRAILHEAD)
- TRAIL_GROUPING-
New attribute added to OTN Trailhead for information on high level trail grouping.
Tables added:
- OTN_TRAIL_ACCESS_POINT new child table added to hold one or many access points for a trail head.
-OTN_OTC_TRAIL_CHARACTER created new child table for one or many trail character values.
New Lookup Table values added to OTN_PERMITTED_USE_LIST:
> Four Wheel Driving
> Geocaching
> Rock Climbing
> Ice Climbing
> In-line Skating
With some existing values changed to replace '/' with 'or'
Lookup Table value added to OTN_TRAIL_GROUPING_LIST: 'Trail Grouping'
2008 / NEW Data Class

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