land information ontario data description · pdf fileland information ontario data description...

of 18

Unclassified

Land Information Ontario

Data Description

Crown Land – MNR Non-Freehold Dispositions Public

Disclaimer This technical documentation has been prepared by the Ministry of Natural Resources (the “Ministry”), representing Her Majesty the Queen in right of Ontario. Although every effort has been made to verify the information, this document is presented as is, and the Ministry makes no guarantees, representations or warranties with respect to the information contained within this document, either express or implied, arising by law or otherwise, including but not limited to, effectiveness, completeness, accuracy, or fitness for purpose. The Ministry is not liable or responsible for any loss or harm of any kind arising from use of this information. For an accessible version of this document, please contact Land Information Ontario at (705) 755 1878 or [email protected]

mailto:[email protected]

of 18

©Queens Printer for Ontario, 2014

Data Dictionary

CL_DISP_SURVEY_PLAN_PART

Refers to specific Part(s) or Lot(s) on a Survey Plan. Part/Lot numbers assigned by the surveyor.

# Column Name Column Type Mandatory Short Name

1 CL_NON_FREEHOLD_DISPOSITION_ID NUMBER(13) Yes

Foreign key to CL_NON_FREEHOLD_DISPOSITION.

2 SURVEY_PLAN_PART_NUMBER VARCHAR2(100) Yes

The part number of a survey plan.

3 EFFECTIVE_DATETIME DATE Yes

Date/time the record was created or last modified in the source database.

4

SYSTEM_DATETIME DATE Yes

Date/time the record was loaded into or last modified in the LIO database.

DEFAULT: SYSDATE

CL_NON_FREEHOLD_DISPOSITION_FT

Tenanted disposition of Crown land i.e.: Lease, Licence of Occupation, Beach Management Agreement, Land Use Permit, Easement, etc..


1 OGF_ID NUMBER(13) Yes

A unique numeric provincial identifier assigned to each object.

2 CLASS_SUBTYPE VARCHAR2(75) Yes

The data class subtype - Original GEOG_UNIT_TYPE_NAME.

3 CLASS_SUBTYPE_NUM NUMBER(7) Yes

The data class subtype number - Original GEOG_UNIT_TYPE_NUM.

4

PURPOSE_OF_DISPOSITION VARCHAR2(60) No

The purpose for the disposition ( i.e pipeline, cottage lot, access point, recreation camp).

*This field may be dropped as the information exists in LUPs and LIS. If views are used in NRVIS of these databases, they would no longer be requred.*

5

REGISTERED_PLAN_NUMBER VARCHAR2(10) No

Number assigned by the Land Registry Office for land surveys at the time the survey is deposited - i.e. 16R-1234, M-123

6

CROWN_SURVEY_LOCATION_NUMBER VARCHAR2(100) No

The reference number for the survey plan number used in the Crown Disposition. Include survey part and lot number. e.g. CL 12345

of 18


7

SITE_NAME VARCHAR2(125) No

The name of the non-freehold disposition. This should NOT be populated with personal information such as the first and last names of an individual.

8 LOCATION_DESCR VARCHAR2(2000) No

Description of the area or directions on how to get to the site.

9 AREA_IN_HA NUMBER(12,3) No

The calculated extent of a 2-dimensional surface enclosed within a boundary measured in hectares (ha).

10 FIELD_FILE_NUMBER VARCHAR2(35) No

The file number used by MNR Districts for land tenure tracking purposes

11

MNDM_FONT_CODE VARCHAR2(2) No

The font used for cartographic purposes to mimic the appearance of a g-plan. Derived from the Ministry of Northern Development and Mines. A symbol item based on the disposition reservations.

12 DOCUMENT_PREFIX VARCHAR2(7) No

The prefix of the document number, as found in the Land Index System (LIS).

13

DOCUMENT_NUMBER VARCHAR2(15) No

Unique number assigned to each document - i.e.: Crown Lease #, LUP #, Acquired Land Transaction #, etc. - will link to document numbers in LIS and LUPS. e.g.123456

14

PERMIT_NUMBER VARCHAR2(20) No

The Land Use Permit System area number combined with the Land Use Permit System permit number to create a unique ID. e.g 1234-1234567

15

LICENCE_OF_OCCUPATION_TYPE VARCHAR2(40) No

The type of Licence of Occupation issued.

VALID VALUES: IN (Mining Licence of Occupation,Mining Exploration Licence of Occupation, Exploratory Licence of Occupation, Licence of Occupation)

16

LEASE_TYPE VARCHAR2(30) No

The type of crown lease that has been issued, i.e. the document type. E.g. Crown Lease, Waterpower Lease

17

LOCATION_ACCURACY VARCHAR2(25) Yes

The degree of conformity or closeness of a measurement within the database to its true value in the world.

18 VERIFICATION_STATUS_FLG VARCHAR2(10) No

An indication as to whether a qualified employee has verified the existence of the geographic unit.

19 VERIFICATION_STATUS_DATE DATE No

Date that the geographic unit was verified/validated.

20

BUSINESS_EFFECTIVE_DATE DATE No

Date that the record becomes effective in relation to the business i.e. the date MNR became aware of its existence.

21 BUSINESS_EXPIRY_DATE DATE No

of 18


A date indicating when the record was determined to be invalid.

22 SYSTEM_CALCULATED_AREA NUMBER(16,3) No

The area of a polygon measured in square metres by the system.

23

USER_CALCULATED_METRIC NUMBER(16,3) No

The length, perimeter or area of an object in metres or square metres as measured or provided by the user.

24 GENERAL_COMMENTS VARCHAR2(2000) No

General comments.

25 GEOMETRY_UPDATE_DATETIME DATE No

Date/time the geometry was created or last modified in the source database.

26 EFFECTIVE_DATETIME DATE Yes


27 SYSTEM_DATETIME DATE Yes

Date/time the record was loaded into or last modified in the LIO database.

of 18

Business Area Lookup Tables and Permissible Values

CL_DOCUMENT_PREFIX_LIST

Lookup table for non-freehold document and disposition types.


1 DOCUMENT_PREFIX VARCHAR2(7) Yes

The prefix of the document number, as found in the Land Index System (LIS).

2

DOCUMENT_TYPE VARCHAR2(50) Yes

Identifies the type of document granted e.g.; Crown Lease, Oil Lease, Mining Lease, Crown Easement, Licence of Occupation, Land Use Permit, Lease etc

3

EFFECTIVE_DATETIME DATE Yes


DEFAULT: SYSDATE

4 EXPIRY_DATETIME DATE No

Date/time that the record was expired from use.

CL_DOCUMENT_PREFIX_LIST Permissible Values

DOCUMENT PREFIX DOCUMENT TYPE EXPIRY DATETIME

APL Algonquin Park Lease

BMA Beach Management Agreement

CLBB Crown Lease: Bruce Beach

CRE Crown Easement

CRL Crown Lease

EXLO Exploratory Licence of Occupation

GL Gas Lease

JHL Jordan Harbour Lease

LO Licence of Occupation

MELO Mining Exploration Licence of Occupation

MGL Mining Lease

MLO Mining Licence of Occupation

NRL Lease: New Regulation

OGL Oil and Gas Lease

OIL Oil Lease

of 18

OL Ordnance Lease

ORL Lease: Old Regulations

RPL Rondeau Park Lease

SL Storage Lease

SRL Summer Resort Lease

TIL Temagami Island Lease

UML University Mining Lease

WPL Waterpower Lease

WPLA Waterpower Lease Agreement

CL_LEASE_TYPE_LIST

*** DESCRIPTION NEEDED! ***


1 LEASE_TYPE VARCHAR2(30) Yes

*** DESCRIPTION NEEDED! ***

2



DEFAULT: SYSDATE



CL_LEASE_TYPE_LIST Permissible Values

LEASE TYPE EXPIRY DATETIME

Algonquin Park Lease

Crown Lease

Crown Lease:Bruce Beach

Gas Lease

Jordan Harbour Lease

Lease: Old Regulations

Lease:New Regulation

of 18

Mining Lease

Oil Lease

Oil and Gas Lease

Ordnance Lease

Rondeau Park Lease

Storage Lease

Summer Resort Lease

Temagami Island Lease

University Mining Lease

Waterpower Lease Agreement

Waterpower Lease

CL_MNDM_FONT_LIST

Lookup table for MNDM Font types.


1

MNDM_FONT_CODE VARCHAR2(2) Yes

The font used for cartographic purposes to mimic the appearance of a g-plan. Derived from the Ministry of Northern Development and Mines. A symbol item based on the disposition reservations.

2 MNDM_FONT_NAME VARCHAR2(30) Yes

Description of the MNDM Font code, e.g. Surface Patent, Mining Patent.

3



DEFAULT: SYSDATE



CL_MNDM_FONT_LIST Permissible Values

MNDM FONT CODE MNDM FONT NAME EXPIRY DATETIME

b Waterpower Lease Agreement

e Mining Patent

i Land Use Permit

m Mining Licence

of 18

n Surface Licence

o Full Patent

p Unknown/Pending

q Order-in-Council

r Full Lease

t Surface Lease

u Licence of Occupation

w Surface Patent

y Mining Lease

CL_PURPOSE_OF_DISPOSITION_LIST

Lookup Table for disposition purpose. Table was constructed using the LIS Land/Use Purpose lookup table concatenated with the LUPS Purpose/Sub Purpose lookup table to be able to accomodate a complete list of purpose types related to dispositions.


1

PURPOSE_OF_DISPOSITION VARCHAR2(60) Yes

The purpose for the disposition ( i.e pipeline, cottage lot, access point, recreation camp).

*This field may be dropped as the information exists in LUPs and LIS. If views are used in NRVIS of these databases, they would no longer be requred.*

2



DEFAULT: SYSDATE



CL_PURPOSE_OF_DISPOSITION_LIST Permissible Values

PURPOSE OF DISPOSITION EXPIRY DATETIME

Access Point - Boat Launch Only (no parking)

Access Point - Boat Launch and Parking

Access Point - Camping

Access Point - Camping/Accommodating

Access Point - Day Use Only

Access Point - Other

of 18

Advertising Sign - County Road

Advertising Sign - Forest Road

Advertising Sign - Other

Advertising Sign - Primary Highway

Advertising Sign - Secondary Highway

Advertising Sign - Tertiary Highway

Agriculture - Animal Rearing

Agriculture - Bird Rearing

Agriculture - Crop Production

Agriculture - Hay Production

Aircraft Hangar

Airport - Flying

Airport - Gliding

Airport - Other

Airstrip - Flying

Airstrip - Other

Airstrip - Parking/Storage

Anchorage - Boat

Anchorage - Boom

Anchorage - Other

Anchors and Guy Wires

Animal Husbandry No Buildings - Bird Rearing

Animal Husbandry No Buildings - Corral

Animal Husbandry No Buildings - Grazing

Animal Husbandry No Buildings - Horseback Riding

Animal Husbandry No Buildings - Other

Aquaculture

Arena

Armoury

of 18

Art Gallery

Asphalt Plant

Beach - Association

Beach - Municipal

Beach - Other

Beacon - Aircraft

Beacon - Boating

Beacon - Other

Boat Cache - Commercial

Boat Cache - Other

Boat Cache - Private

Boat Cache - Resource Harvester

Boat Landing

Boat Launch - Commercial

Boat Launch - Other

Boat Launch - Private

Boat Lift

Boathouse One Storey - Accommodation

Boathouse One Storey - Recreation

Boathouse Two Storey - Accommodation

Boathouse Two Storey - Recreation

Breakwall

Bridge - ATV

Bridge - Access to Private Property

Bridge - On Private Land Spanning Crown Water Body

Bridge - Snowmobile

Building (non-accommodation) - Commercial

Building (non-accommodation) - Industrial - Non-Mining

Building (non-accommodation) - Institutional

of 18

Building (non-accommodation) - Mining

Building (non-accommodation) - Other

Building (non-accommodation) - Private

Building (non-accommodation) - Recreational

Building (non-accommodation) - Sugar Shack

Building - Apartment

Building - Office

Bunkhouse

Bus Station

CO2 Sequestration

Cabin

Camp - Construction

Camp - Other

Camp - Resource Harvesting/Use

Camp - Snowmobiling

Campground - Seasonal

Campground - Year Round

Canoe Route

Carnival

Carport

Carwash

Cathodic Protection

Causeway

Cemetery

Cenotaph

Church

Cinema

Clubhouse - Accommodation (other than snowmobiling)

Clubhouse - Non-Accommodation

of 18

Commercial Outpost Camp - Restricted

Commercial Outpost Camp

Communication Tower - Broadcasting

Communication Tower - Commercial Retail

Communication Tower - Company Communication

Communication Tower - Municipal

Communication Tower - Other

Company Guest Camp

Condominium

Construction Camp

Corral

Cottage - One Storey Over Water

Cottage

Crib

Dam

Detention Centre

Ditch

Dock

Dormitory

Extraction

Factory

Fair Grounds

Farm (buildings) - Animal Rearing

Farm (buildings) - Crop Production

Fence - Other

Fence - Resource Protection

Fence - Security

Fibre Optic Cable - Communication

Fibre Optic Cable - Other

of 18

Field

Filming

Fire Hall

First Nation Reserve

Flooding - Hydro Electric Generation

Flooding

Garage

Garbage Dump

Garden

Gas Bar - Retail

Gas Bar - Storage

Gate - Logging

Gate - Other

Gate - Security

Gatehouse

Generator

Go Kart Track

Golf Course

Grain Elevator

Grandstand

Grave

Greenhouse

Groyne

Hall - Commercial

Hall - Municipal

Hall - Other

Hall - Private

Hangar - Boat

Hangar - Hangar

of 18

Hangar - Other

Hopper

Hospital

Hotel

House Boat Mooring

House

Intake Pipe Water - Commercial

Intake Pipe Water - Industrial

Intake Pipe Water - Institutional

Intake Pipe Water - Municipal

Intake Pipe Water - Other

Intake Pipe Water - Private

Kennel

Laboratory

Landing - Logging

Landing - Other

Lawn - Commercial

Lawn - Other

Lawn - Recreational

Lawn - Residence

Line - Electrical Distribution

Line - Electrical Transmission

Line - Fibre Optic

Line - Hydro

Line - Sewage

Line - Telecommunication

Line - Water

Load Aligner

Lodge - Other

of 18

Lodge - Seasonal

Lodge - Tourist

Lodge - Winter Only

Lodge - Year Round

Lookout

Mail Boxes

Mall

Maple Sugar Shack

Marina - Other

Marina - Upland

Marina - Water Lot

Marine Railway

Mausoleum

Military Base

Mill - Other

Mill - Sawmill

Mine Head Frame

Mine Shaft

Mine Tailings

Mine

Mining Exploration Camp

Mobile Home

Motel

Multi-Residence

Museum

Navigational Beacon

Navigational Buoy

Office - No Accommodation

Office - Other

of 18

Office - With Accommodation

Ontario Power Generation Line - Distribution

Ontario Power Generation Line - Other

Ontario Power Generation Line - Transmission

Outfall Pipe

Park - Camping

Park - Day Use

Park - Fairground

Park - Playground

Parking Lot - Other

Parking Lot - Private

Parking Lot - Public

Peat Exploration

Peat Extraction

Picnic Area

Pier

Pipeline - Natural Gas

Pipeline - Oil

Pipeline - Water

Pit - Aggregate

Pit - Other

Pit - Stockpiling

Playground

Police Station

Pond

Pool

Power Generation Plant - Bio Mass

Power Generation Plant - Coal

Power Generation Plant - Gas

of 18

Power Generation Plant - Hydro

Power Generation Plant - Nuclear

Power Generation Plant - Oil

Power Generation Plant - Solar

Private Recreation Camp

Privy

Pump House - Commercial

Pump House - Industrial

Pump House - Municipal

Pump House - Other

Pump House - Private

Quarry

Race Course

Race Track

Radar Station

Railway Line

Railway Platform

Railway Station

* Not a complete list.

LOCATION_ACCURACY_LIST

List of valid location accuracies associated to a mapped feature.


1

LOCATION_ACCURACY VARCHAR2(25) Yes

The degree of conformity or closeness of a measurement within the database to its true value in the world.

2


For subscription: Date/time that the record was created in the LIO database. For publication: Date/time that the record was created in the source database.

3

EXPIRY_DATETIME DATE No

For subscription: Date/time that the record was expired in the LIO database. For publication: Date/time that the record was expired in the source database.

of 18

LOCATION_ACCURACY_LIST Permissible Values

LOCATION ACCURACY EXPIRY DATETIME

Not Applicable

Over 10,000 metres

Within 1 metre

Within 10 metres

Within 10,000 metres

Within 100 metres

Within 1000 metres

Within 2 metres

Within 20 metres

Within 200 metres

Within 2000 metres

Within 5 metres

Within 50 metres

Within 500 metres

Within 5000 metres

AC Accurate (to 10m) 2007-01-12

AP Approximate (to 500m) 2007-01-12

GE General (to 10,000m) 2007-01-12

MO Moderate (to 1000m) 2007-01-12

RE Reliable (to 100m) 2007-01-12

VA Very Accurate (to 2m) 2007-01-12

VG Vague (to 100,000m) 2007-01-12

^ Data Load 2007-01-12

land information ontario data description · pdf fileland information ontario data description...

Documents