ORN Road Net Element User Guide - Premier of Ontario



User GuideforORN Road Net ElementLIO Data ClassProvincial Mapping UnitMapping and Information Resources BranchCorporate Management and Information DivisionMinistry of Natural Resources and Forestry DATE \@ "yyyy-MM-dd" 2019-03-22DisclaimerThis technical documentation has been prepared by Her Majesty the Queen in right of Ontario as represented by the Ministry of Natural Resources and Forestry (the “Ministry”). No warranties or representations, express or implied, statutory or otherwise shall apply or are being made by the Ministry with respect to the documentation, its accuracy or its completeness. In no event will the Ministry be liable or responsible for any lost profits, loss of revenue or earnings, claims by third parties or for any economic, indirect, special, incidental, consequential or exemplary damage resulting from any errors, inaccuracies or omissions in this documentation; and in no event will the Ministry’s liability for any such errors, inaccuracies or omissions on any particular claim, proceeding or action, exceed the actual consideration paid by the claimant involved to the Ministry for the materials to which this instructional documentation relates. Save and except for the liability expressly provided for above, the Ministry shall have no obligation, duty or liability whatsoever in contract, tort or otherwise, including any liability or negligence. The limitations, exclusions and disclaimers expressed above shall apply irrespective of the nature of any cause of action, demand or action, including but not limited to breach of contract, negligence, strict liability, tort or any other legal theory, and shall survive any fundamental breach or breaches.Cette publication spécialisée n’est disponible qu’en anglais.Additional InformationThis document does not comply with all the applicable guidelines for accessible digital documents. For an alternative format please contact Land Information Ontario at lio@ontario.ca.For more information about this document, please contact Land Information Ontario at lio@ontario.ca.Executive SummaryKey WordsOntario Road Network, ORN, Linear Referencing System AbstractThis user guide details the specifications for the ORN Road Net Element (ORNELEM) Land Information Ontario (LIO) Data Class. With a positional accuracy of 10 metres or better the ORN is the authoritative source of roads data for Ontario. ORNELEM is a Linear Reference System (LRS) and is suitable for creating products and services including mapping, analysis and geocoding applications.The ORN is a Government of Ontario Information Technology Standard (GO-ITS 29). Refer to Links to Additional Information for more information.Table of Contents TOC \o "1-3" \h \z \u Disclaimer PAGEREF _Toc463509247 \h 2Additional Information PAGEREF _Toc463509248 \h 2Executive Summary PAGEREF _Toc463509249 \h 3Key Words PAGEREF _Toc463509250 \h 3Abstract PAGEREF _Toc463509251 \h 3Table of Contents PAGEREF _Toc463509252 \h 4List of Figures PAGEREF _Toc463509253 \h 7List of Acronyms PAGEREF _Toc463509254 \h 81. Introduction PAGEREF _Toc463509255 \h 92. Objectives PAGEREF _Toc463509256 \h 93. Data Class: ORN Road Net Element (ORNELEM) PAGEREF _Toc463509257 \h 94. Model Diagram: ORN Road Net Element PAGEREF _Toc463509258 \h 115. Data Description PAGEREF _Toc463509259 \h 13ORN_ROAD_NET_ELEMENT_FT PAGEREF _Toc463509260 \h 13ORN_ADDRESS_INFO PAGEREF _Toc463509261 \h 15ORN_ALTERNATE_STREET_NAME PAGEREF _Toc463509262 \h 16ORN_BLOCKED_PASSAGE PAGEREF _Toc463509263 \h 17ORN_JUNCTION PAGEREF _Toc463509264 \h 18ORN_JURISDICTION PAGEREF _Toc463509265 \h 18ORN_NUMBER_OF_LANES PAGEREF _Toc463509266 \h 19ORN_OFFICIAL_STREET_NAME PAGEREF _Toc463509267 \h 20ORN_ROAD_CLASS PAGEREF _Toc463509268 \h 21ORN_ROAD_NET_ELEMENT_SOURCE PAGEREF _Toc463509269 \h 21ORN_ROAD_SURFACE PAGEREF _Toc463509270 \h 22ORN_ROUTE_NAME PAGEREF _Toc463509271 \h 23ORN_ROUTE_NUMBER PAGEREF _Toc463509272 \h 24ORN_SPEED_LIMIT PAGEREF _Toc463509273 \h 25ORN_STREET_NAME_PARSED PAGEREF _Toc463509274 \h 26ORN_STRUCTURE PAGEREF _Toc463509275 \h 27ORN_TOLL_POINT PAGEREF _Toc463509276 \h 28ORN_UNDERPASS PAGEREF _Toc463509277 \h 296. Links to Additional Information PAGEREF _Toc463509278 \h 30APPENDIX A: LIO Lookup Tables and Values PAGEREF _Toc463509279 \h 31ORN_ACQUISITION_TECHNIQUE_LIST PAGEREF _Toc463509280 \h 31ORN_AGENCY_NAME_LIST PAGEREF _Toc463509281 \h 32ORN_AGENCY_TYPE_LIST PAGEREF _Toc463509282 \h 46ORN_BLOCKED_PASSAGE_TYPE_LIST PAGEREF _Toc463509283 \h 47ORN_DIR_OF_TRAFFIC_FLOW_LIST PAGEREF _Toc463509284 \h 48ORN_HOUSE_NUM_STRUCTURE_LIST PAGEREF _Toc463509285 \h 48ORN_JUNCTION_TYPE_LIST PAGEREF _Toc463509286 \h 50ORN_JURISDICTION_LIST PAGEREF _Toc463509287 \h 51ORN_OFFICIAL_LANGUAGE_LIST PAGEREF _Toc463509288 \h 64ORN_PAVEMENT_STATUS_LIST PAGEREF _Toc463509289 \h 64ORN_ROAD_CLASS_LIST PAGEREF _Toc463509290 \h 65ORN_ROAD_ELEMENT_TYPE_LIST PAGEREF _Toc463509291 \h 66ORN_SHIELD_TYPE_LIST PAGEREF _Toc463509292 \h 67ORN_STANDARD_MUNICIPALITY_LIST PAGEREF _Toc463509293 \h 68ORN_STREET_DIRECTION_LIST PAGEREF _Toc463509294 \h 84ORN_STREET_SIDE_LIST PAGEREF _Toc463509295 \h 85ORN_STREET_TYPE_LIST PAGEREF _Toc463509296 \h 85ORN_STRUCTURE_TYPE_LIST PAGEREF _Toc463509297 \h 92ORN_SURFACE_TYPE_LIST PAGEREF _Toc463509298 \h 93ORN_TOLL_POINT_TYPE_LIST PAGEREF _Toc463509299 \h 93ORN_UNDERPASS_LIST PAGEREF _Toc463509300 \h 94APPENDIX B: Table Key Dependency and Relationship Index PAGEREF _Toc463509301 \h 96Main Business Area Tables PAGEREF _Toc463509302 \h 98Lookup Table Indexes PAGEREF _Toc463509303 \h 102APPENDIX C: Frequently Asked Questions PAGEREF _Toc463509304 \h 107What is the difference between ORN Road Net Element (ORNELEM) and ORN Segment with Address (ORNSEGAD)? PAGEREF _Toc463509305 \h 107What is a Linear Reference System (LRS)? PAGEREF _Toc463509306 \h 108Where are the attribute tables for the ORN_ROAD_NET_ELEMENT data class? PAGEREF _Toc463509307 \h 108Why can’t I see ORN attributes like Speed Limit or Road Class in ArcMap? PAGEREF _Toc463509308 \h 110How do I display ORN Route Events in ArcMap? PAGEREF _Toc463509309 \h 110How do I display the ORN_JUNCTION table in ArcMap? PAGEREF _Toc463509310 \h 112How do I join ORN tables or event layers? PAGEREF _Toc463509311 \h 113How do I access ORN attributes for analysis? PAGEREF _Toc463509312 \h 114Where do I find 911 addresses? PAGEREF _Toc463509313 \h 114What is the difference between 911 and civic addresses? PAGEREF _Toc463509314 \h 114What is the difference between shield type and road class? PAGEREF _Toc463509315 \h 114What is the difference between the Jurisdiction, Agency Name, and Road Net Element Source tables? PAGEREF _Toc463509316 \h 115What projection is used to calculate LENGTH in ORN? PAGEREF _Toc463509317 \h 115I found a road with an offensive or rescinded name in the ORN. Are you able to rename the road or remove the name? PAGEREF _Toc463509318 \h 115I still need help! PAGEREF _Toc463509319 \h 116List of Figures TOC \h \z \c "Figure" Figure 1: ORNELEM segment with line events PAGEREF _Toc463509320 \h 10Figure 2: Primary Key example PAGEREF _Toc463509321 \h 96Figure 3: Foreign Key example PAGEREF _Toc463509322 \h 96Figure 4: Alternate Key example PAGEREF _Toc463509323 \h 96Figure 5: Example of an Identifying Relationship PAGEREF _Toc463509324 \h 97Figure 6: Example of a Non-identifying Relationship PAGEREF _Toc463509325 \h 97Figure 7: Model Diagram Relationship Symbology Table PAGEREF _Toc463509326 \h 97Figure 8: Attribute tables included through LIO Metadata Management Tool PAGEREF _Toc463509327 \h 109Figure 9: Check 'Include Related Tables' when ordering LIO data PAGEREF _Toc463509328 \h 109Figure 10: ArcMap's Display Route Events PAGEREF _Toc463509329 \h 111Figure 11: ArcMap's Display XY Data PAGEREF _Toc463509330 \h 112Figure 12: ArcMap's Join Data PAGEREF _Toc463509331 \h 113List of AcronymsCPC: Canada Post CorporationGO-ITS: Government of Ontario Information Technology StandardLIO: Land Information OntarioLRS: Linear Reference SystemLUT: Lookup TableMMAH: Ontario Ministry of Municipal Affairs and Housing MNRF: Ontario Ministry of Natural Resources and ForestryMTO: Ontario Ministry of TransportationNRN: National Road NetworkOGF: Ontario Geospatial FeatureORN: Ontario Road NetworkORNELEM: Short Name for Ontario Road Network Road Net Element Data ClassORNSEGAD: Short Name for Ontario Road Network Segment with Address Data ClassUUID: Universal Unique IdentifierWMS: Web Map Service1. IntroductionThe Ontario Road Network (ORN) is a province-wide geographic database of over 275,000 kilometres of municipal roads, provincial highways and resource and recreational roads. With a positional accuracy of 10 metres or better the ORN is the authoritative source of roads data for Ontario.The ORN is a national, provincial and municipal initiative that supports the creation, maintenance and sharing of a standard road database. Land Information Ontario (LIO) maintains the ORN using data from the road authorities with legislative responsibility: Ontario Municipalities, Ontario Ministry of Transportation (MTO) and Ontario Ministry of Natural Resources and Forestry (MNRF). Roads data and information is collected, standardized and integrated into a seamless road mapping product.Users can access current ORN data through a Web Map Service (WMS) or an open data license to create products and services including mapping, analysis and geocoding applications. Up-to-date data is available at no cost to public and private organizations, saving time, resources and money.For more information on the ORN contact Land Information Ontario at lio@ontario.ca.2. ObjectivesThis LIO Data Class user guide is intended for users of the ORN Road Net Element (ORNELEM). The document describes the extent and context of the information collected for ORN Road Net Element.3. Data Class: ORN Road Net Element (ORNELEM)ORNELEM is a Linear Reference System (LRS) in which point and line events are located along a linear segment at specific (x, y) co-ordinates called measures.Line events occur between From and To Measures and include Road Surface, Number of Lanes, Road Class, Street Name, Address Info, Jurisdiction, Speed Limit and Structure. Point events occur at At Measures along segments and include Junction, Toll Point and Blocked Passage.Figure 1: ORNELEM segment with line eventsORNELEM geometry is represented by single line segments and contains three types of geometry: road elements, ferry connections, and virtual roads. Road Elements are segmented at real-world intersections represented by junctions. Segments are bound by a junction at each end, except for cul-de-sacs (loops) where there is only one junction. Ferry Connections are an approximation of the route a ferry travels to transport vehicles across water and are linked to a road element by a junction. Virtual Roads represent address information collected for islands or shorelines that are not accessible by road and may not be connected to the main road network.A derived product from ORNELEM called ORN Segment with Address (ORNSEGAD) is a data class containing five attributes: Address Information, Route Identification, Road Classification, and Direction of Traffic Flow. For more information refer to the ORN Segment with Address (ORNSEGAD) metadata record ().For more detailed information refer to the ORNELEM data model diagram and Appendix B: Table Key Dependency and Relationship Index.4. Model Diagram: ORN Road Net ElementPhysical Model Diagram for ORN Road Net ElementModel Effective Date: 2012-JUN-14Note: Where applicable to this model:Tables with a “_LIST” extension (shaded yellow) = Lookup Table (LUT)Model includes Non-Spatial Classes: ORN Junction (ORNJUNCT) and ORN Street Name Parsed (ORNNAME)5. Data DescriptionThe main business area table(s) for this model can be found below. Associated lookup tables will be listed in Appendix A of this document and are hyperlinked where referenced in this section.ORN_ROAD_NET_ELEMENT_FTThe basic centreline of road network features, which forms the spatial network of roads, composed of three types of road net elements, road element, ferry connection and virtual road. The ORN is segmented at real-world intersections or junctions on the ground and road net elements are bound by a junction on each end, except for cul-de-sacs where there is only one junction. Where there are grade-separated crossings, the bisecting road elements do not share a junction. If a junction is present at the location of the grade separation, it is either connected to the lower set of road elements or to the higher but never to both. Proposed roads and roads under construction are not represented in the ORN. Turning lanes separated by a median longer than 10 metres in length are represented in the ORN.Column NameColumn TypeMandatoryShort NameDescriptionOGF_IDNUMBER(13)YesOGF_IDOntario Geospatial Feature Identifier: A unique numeric provincial identifier assigned to each object.FROM_JUNCTION_IDNUMBER(13)YesFROM_JUNCTThe beginning junction for a road element or ferry connection.TO_JUNCTION_IDNUMBER(13)YesTO_JUNCTThe end junction for a road element or ferry connection.ROAD_ABSOLUTE_ACCURACYNUMBER(7,2)YesACCURACYA statement that identifies the positional accuracy of the ORN road geometry, in metres.NATIONAL_UUIDVARCHAR2(32)YesNIDA unique national identifier assigned to a road net element, junction and selected event data such as Toll Point, Blocked Passage and Structure which are required to support the National Road Network (NRN).LENGTHNUMBER(9,3)YesLENGTHThe measured planimetric length of a road net element in metres.DIRECTION_OF_TRAFFIC_FLOWVARCHAR2(8)YesDIRECTIONThe direction(s) of vehicular or motor traffic flow. All road elements must have a direction of traffic flow assigned. Permissible Values: (See ORN_DIR_OF_TRAFFIC_FLOW_LIST lookup table in appendix)EXIT_NUMBERVARCHAR2(10)NoEXIT_NUMThe number of an exit on or off a freeway, expressway or highway, assigned by an administrating body and is represented by a valid number or character.ROAD_ELEMENT_TYPEVARCHAR2(20)YesELEM_TYPEAn attribute describing the type of road net element. Permissible Values: (See ORN_ROAD_ELEMENT_TYPE_LIST lookup table in appendix)TOLL_ROAD_INDVARCHAR2(3)YesTOLL_ROADIndicates if the road net element is a toll road.Permissible Values:YesNoACQUISITION_TECHNIQUEVARCHAR2(25)YesACQTECHThe type of data source or technique used to create or revise the road net element.Permissible Values: (See ORN_ACQUISITION_TECHNIQUE_LIST lookup table in appendix)CREATION_DATEDATEYesCREDATEThe date the road net element was originally created.REVISION_DATEDATENoREVDATEThe date the road net element was last revised or updated.GEOMETRY_UPDATE_DATETIMEDATENoGEO_UPD_DTDate/time the geometry was created or last modified in the source database.EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.SHAPESDO_GEOMETRYNoSHAPEGeometry attribute.ORN_ADDRESS_INFOThe essential components of a street address. Address information is collected and stored relating to left or right side of the street or road element. Addressing is collected and maintained by an authoritative source such as the municipality, county or region for the purposes of assisting in the delivery of "911" services. Addresses are typically directly related to road names, but there are cases where an address does not directly link to a road and the address information is linked to a road net element attribute called road element type - virtual road, i.e. cottage or country roads where access is across water bodies (islands) or along shorelines not accessed by road.Column NameColumn TypeMandatoryShort NameDescriptionEVENT_IDNUMBER(13,0)YesEVENT_IDSystem generated identifier, unique at the application level.ORN_ROAD_NET_ELEMENT_IDNUMBER(13,0)YesELEMENT_IDForeign Key (FK) OGF_ID reference to parent ORN_ROAD_NET_ELEMENT_FT feature table record.FROM_MEASURENUMBER(9,3)NoFROM_MEASThe location of the beginning of the event measured in metres from the beginning of the road element.TO_MEASURENUMBER(9,3)YesTO_MEASUREThe location of the end of the event measured in metres from the beginning of the road element. This measure is related to planimetric distance, not actual driven distance.ELEMENT_ORDER_NUMBERNUMBER(5,0)YesORDER_NUMThis is a sequential number starting at 1 for each event, which determines the order in which the event records combine to form the address range.FIRST_HOUSE_NUMBERNUMBER(7,0)YesFIRST_NUMThe first house number of the address range.LAST_HOUSE_NUMBERNUMBER(7,0)NoLAST_NUMThe last house number of the address range.HOUSE_NUMBER_STRUCTUREVARCHAR2(10)NoNUM_STRUCTThe type of house or property numbering system that is applied to the address range. Permissible Values: (See ORN_HOUSE_NUMBER STRUCTURE_LIST lookup table in appendixSTREET_SIDEVARCHAR2(10)NoST_SIDEThe side of the street for which the addressing applies. The street side is determined by the traversal from the "From Measure" to the "To Measure" of the road element. Permissible Values: (See table ORN_STREET_SIDE_LIST lookup table in appendix)FULL_STREET_NAMEVARCHAR2(100)YesFULL_NAMEThis attribute is derived from the individual street name components where present, namely directional prefix, street type prefix, street name body, street type suffix and directional suffix and is stored in upper case text.ORIGINAL_STREET_NAMEVARCHAR2(100)NoORIG_STThe street name provided by source agencies, which is stored as is regardless of spelling or abbreviations.STANDARD_MUNICIPALITYVARCHAR2(100)YesSTD_MUNICStandardized municipality names as maintained by the Ministry of Municipal Affairs and Housing (MMAH), and Official Indian Reserve Names as maintained by the Federal Government.Permissible Values: (See ORN_STANDARD_MUNICIPALITY_LIST lookup table in appendix)ORIGINAL_MUNICIPALITYVARCHAR2(100)YesORIG_MUNICThe municipality name provided by source agencies, which is stored as is, regardless of spelling or abbreviations. It may contain former municipality names or may contain local municipal names such towns or village names.AGENCY_NAMEVARCHAR2(100)NoAGENCYThe name of the agency.Permissible Values: (See ORN_AGENCY_NAME_LIST lookup table in appendix)EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.ORN_ALTERNATE_STREET_NAMEAn event identifying an alternate street name and may be associated with a bilingual name. A language code shall be used to specify the applied language which resides in the Street_Name_Parsed Table.Column NameColumn TypeMandatoryShort NameDescriptionEVENT_IDNUMBER(13,0)YesEVENT_IDSystem generated identifier, unique at the application level.ORN_ROAD_NET_ELEMENT_IDNUMBER(13,0)YesELEMENT_IDForeign Key (FK) OGF_ID reference to parent ORN_ROAD_NET_ELEMENT_FT feature table record.FROM_MEASURENUMBER(9,3)NoFROM_MEASThe location of the beginning of the event measured in metres from the beginning of the road element. This measure is related to planimetric distance, not actual driven distance.TO_MEASURENUMBER(9,3)YesTO_MEASUREThe location of the end of the event measured in metres from the beginning of the road element. This measure is related to planimetric distance, not actual driven distance.FULL_STREET_NAMEVARCHAR2(100)YesFULL_NAMEThis attribute is derived from the individual street name components where present, namely directional prefix, street type prefix, street name body, street type suffix and directional suffix and is stored in upper case text.AGENCY_NAMEVARCHAR2(100)YesAGENCYThe name of the agency.Permissible Values: (See ORN_AGENCY_NAME_LIST lookup table in appendix)EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.ORN_BLOCKED_PASSAGEA point event on a road element identifying the existence of an access barrier or an obstruction, either man-made or natural, which controls or limits access to a road element.Column NameColumn TypeMandatoryShort NameDescriptionEVENT_IDNUMBER(13,0)YesEVENT_IDSystem generated identifier, unique at the application level.ORN_ROAD_NET_ELEMENT_IDNUMBER(13,0)YesELEMENT_IDForeign Key (FK) OGF_ID reference to parent ORN_ROAD_NET_ELEMENT_FT feature table record.AT_MEASURENUMBER(9,3)YesAT_MEASUREAt measure represents a location or point of interest along a linear feature. At measure is expressed as a distance in metres from the beginning of the road net element. This measure is related to planimetric distance not actual driven distance.BLOCKED_PASSAGE_TYPEVARCHAR2(10)YesBLOCKED_TA man-made or natural barrier or access restriction placed on a road net element to control or limit access to a road net element. Permissible Values: (See ORN_BLOCKED_PASSAGE_TYPE_LIST lookup table in appendix)AGENCY_NAMEVARCHAR2(100)YesAGENCYThe name of the agency.Permissible Values: (See ORN_AGENCY_NAME_LIST lookup table in appendix)NATIONAL_UUIDVARCHAR2(32)YesNIDA unique national identifier assigned to a road net element, junction and selected event data such as Toll Point, Blocked Passage and Structure which are required to support the National Road Network (NRN).EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.ORN_JUNCTIONA junction identifies the connectivity of road elements. All ORN Road Elements begin and end at a junction. Note: ORN_JUNCTION has been defined as a Non-Spatial class to support data loading for the ORN Road Net Element spatial Data Class.Column NameColumn TypeMandatoryShort NameDescriptionJUNCTION_IDNUMBER(13,0)YesJCT_IDSystem generated identifier, unique at the application level.LATITUDE_DECIMAL_DEGREESNUMBER(10,7)YesLATITUDEThe latitude in decimal degrees.LONGITUDE_DECIMAL_DEGREESNUMBER(10,7)YesLONGITUDEThe longitude in negative decimal degrees.JUNCTION_TYPEVARCHAR2(15)YesJCT_TYPEThe classification of a junction is based on the valency of the junction. The number of road elements or ferry connections joining at a junction is termed the valency of a junction.Permissible Values: (See ORN_JUNCTION_TYPE_LIST lookup table in appendix)EXIT_NUMBERVARCHAR2(10)NoEXIT_NUMThe number of an exit on or off a freeway, expressway or highway, assigned by an administrating body and is represented by a valid number or character.NATIONAL_UUIDVARCHAR2(32)YesNIDA unique national identifier assigned to a road net element, junction and selected event data such as Toll Point, Blocked Passage and Structure which are required to support the National Road Network (NRN).EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.ORN_JURISDICTIONIdentifies jurisdictional, or custodianship responsibility of the road.Column NameColumn TypeMandatoryShort NameDescriptionEVENT_IDNUMBER(13,0)YesEVENT_IDSystem generated identifier, unique at the application level.ORN_ROAD_NET_ELEMENT_IDNUMBER(13,0)YesELEMENT_IDForeign Key (FK) OGF_ID reference to parent ORN_ROAD_NET_ELEMENT_FT feature table record.FROM_MEASURENUMBER(9,3)NoFROM_MEASThe location of the beginning of the event measured in metres from the beginning of the road element. This measure is related to planimetric distance, not actual driven distance.TO_MEASURENUMBER(9,3)YesTO_MEASUREThe location of the end of the event measured in metres from the beginning of the road element. This measure is related to planimetric distance, not actual driven distance.STREET_SIDEVARCHAR2(10)YesST_SIDEThe side of the street for which the addressing applies. The street side is determined by the direction of the traversal from the "From Measure" to the "To Measure" of the road element. Permissible Values: (See ORN_STREET_SIDE_LIST lookup table in appendix)JURISDICTIONVARCHAR2(80)YesJURISAn indication of who has the jurisdictional, or custodianship responsibility for a road net element. The custodian would have the responsibility to ensure maintenance occurs, but is not necessarily the one who undertakes the maintenance directly.Permissible Values: (See ORN_JURISDICTION_LIST lookup table in appendix)AGENCY_NAMEVARCHAR2(100)NoAGENCYThe name of the agency.Permissible Values: (See ORN_AGENCY_NAME_LIST lookup table in appendix)EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.ORN_NUMBER_OF_LANESA linear event indicating the number of lanes.Column NameColumn TypeMandatoryShort NameDescriptionEVENT_IDNUMBER(13,0)YesEVENT_IDSystem generated identifier, unique at the application level.ORN_ROAD_NET_ELEMENT_IDNUMBER(13,0)YesELEMENT_IDForeign Key (FK) OGF_ID reference to parent ORN_ROAD_NET_ELEMENT_FT feature table record.FROM_MEASURENUMBER(9,3)YesFROM_MEASThe location of the beginning of the event measured in metres from the beginning of the road element. This measure is related to planimetric distance, not actual driven distance.TO_MEASURENUMBER(9,3)YesTO_MEASUREThe location of the end of the event measured in metres from the beginning of the road element. This measure is related to planimetric distance, not actual driven distance.NUMBER_OF_LANESNUMBER(2,0)YesNUM_LANESThe number of lanes of a road.AGENCY_NAMEVARCHAR2(100)NoAGENCYThe name of the agency.Permissible Values: (See ORN_AGENCY_NAME_LIST lookup table in appendix)EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.ORN_OFFICIAL_STREET_NAMEAn event identifying an official street name and may be associated with a bilingual name. A language code shall be used to specify the applied language which resides in the STREET_NAME_PARSED Table.Column NameColumn TypeMandatoryShort NameDescriptionEVENT_IDNUMBER(13,0)YesEVENT_IDSystem generated identifier, unique at the application level.ORN_ROAD_NET_ELEMENT_IDNUMBER(13,0)YesELEMENT_IDForeign Key (FK) OGF_ID reference to parent ORN_ROAD_NET_ELEMENT_FT feature table record.FROM_MEASURENUMBER(9,3)YesFROM_MEASThe location of the beginning of the event measured in metres from the beginning of the road element. This measure is related to planimetric distance, not actual driven distance.TO_MEASURENUMBER(9,3)YesTO_MEASUREThe location of the end of the event measured in metres from the beginning of the road element. This measure is related to planimetric distance, not actual driven distance.FULL_STREET_NAMEVARCHAR2(100)YesFULL_NAMEThis attribute is derived from the individual street name components where present, namely directional prefix, street type prefix, street name body, street type suffix and directional suffix and is stored in upper case text.AGENCY_NAMEVARCHAR2(100)YesAGENCYThe name of the agency.Permissible Values: (See ORN_AGENCY_NAME_LIST lookup table in appendix)EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.ORN_ROAD_CLASSA linear event identifying the class of road based on a functional classification schema.Column NameColumn TypeMandatoryShort NameDescriptionEVENT_IDNUMBER(13,0)YesEVENT_IDSystem generated identifier, unique at the application level.ORN_ROAD_NET_ELEMENT_IDNUMBER(13,0)YesELEMENT_IDForeign Key (FK) OGF_ID reference to parent ORN_ROAD_NET_ELEMENT_FT feature table record.FROM_MEASURENUMBER(9,3)YesFROM_MEASThe location of the beginning of the event measured in metres from the beginning of the road element. This measure is related to planimetric distance, not actual driven distance.TO_MEASURENUMBER(9,3)YesTO_MEASUREThe location of the end of the event measured in metres from the beginning of the road element. This measure is related to planimetric distance, not actual driven distance.ROAD_CLASSVARCHAR2(25)YesROAD_CLASSThe classification of a road.Permissible Values: (See ORN_ROAD_CLASS_LIST lookup table in appendix)AGENCY_NAMEVARCHAR2(100)YesAGENCYThe name of the agency.Permissible Values: (See ORN_AGENCY_NAME_LIST lookup table in appendix)EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.ORN_ROAD_NET_ELEMENT_SOURCEThe source agency, Municipality, Provincial Ministry, Federal Agency or other organization that provided the road net element.Column NameColumn TypeMandatoryShort NameDescriptionEVENT_IDNUMBER(13,0)YesEVENT_IDSystem generated identifier, unique at the application level.ORN_ROAD_NET_ELEMENT_IDNUMBER(13,0)YesELEMENT_IDForeign Key (FK) OGF_ID reference to parent ORN_ROAD_NET_ELEMENT_FT feature table record.FROM_MEASURENUMBER(9,3)YesFROM_MEASThe location of the beginning of the event measured in metres from the beginning of the road element. This measure is related to planimetric distance, not actual driven distance.TO_MEASURENUMBER(9,3)YesTO_MEASUREThe location of the end of the event measured in metres from the beginning of the road element. This measure is related to planimetric distance, not actual driven distance.AGENCY_NAMEVARCHAR2(100)NoAGENCYThe name of the agency.Permissible Values: (See ORN_AGENCY_NAME_LIST lookup table in appendix)EXTERNAL_IDENTVARCHAR2(32)NoEXT_IDENTA unique identifier assigned to the source agency.EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.ORN_ROAD_SURFACEThe surface type of a road element.Column NameColumn TypeMandatoryShort NameDescriptionEVENT_IDNUMBER(13,0)YesEVENT_IDSystem generated identifier, unique at the application level.ORN_ROAD_NET_ELEMENT_IDNUMBER(13,0)YesELEMENT_IDForeign Key (FK) OGF_ID reference to parent ORN_ROAD_NET_ELEMENT_FT feature table record.FROM_MEASURENUMBER(9,3)YesFROM_MEASThe location of the beginning of the event measured in metres from the beginning of the road element. This measure is related to planimetric distance, not actual driven distance.TO_MEASURENUMBER(9,3)YesTO_MEASUREThe location of the end of the event measured in metres from the beginning of the road element. This measure is related to planimetric distance, not actual driven distance.PAVEMENT_STATUSVARCHAR2(10)YesPAVEMENT_SThe surface type of a road element.Permissible Values: (See ORN_PAVEMENT_STATUS_LIST lookup table in appendix)SURFACE_TYPEVARCHAR2(10)YesSURFACE_TA linear event indicating the surface type of a road element.Permissible Values: (See ORN_SURFACE_TYPE_LIST lookup table in appendix)AGENCY_NAMEVARCHAR2(100)NoAGENCYThe name of the agency.Permissible Values: (See ORN_AGENCY_NAME_LIST lookup table in appendix)EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.ORN_ROUTE_NAMEThe name attached to a road net element as defined by a Municipality, Provincial Ministry, or Federal Agency and is associated to an established and/or maintained route.Column NameColumn TypeMandatoryShort NameDescriptionEVENT_IDNUMBER(13,0)YesEVENT_IDSystem generated identifier, unique at the application level.ORN_ROAD_NET_ELEMENT_IDNUMBER(13,0)YesELEMENT_IDForeign Key (FK) OGF_ID reference to parent ORN_ROAD_NET_ELEMENT_FT feature table record.FROM_MEASURENUMBER(9,3)YesFROM_MEASThe location of the beginning of the event measured in metres from the beginning of the road element. This measure is related to planimetric distance, not actual driven distance.TO_MEASURENUMBER(9,3)YesTO_MEASUREThe location of the end of the event measured in metres from the beginning of the road element. This measure is related to planimetric distance, not actual driven distance.ROUTE_NAME_ENGLISHVARCHAR2(75)NoNAME_ENGThe English name that is attached to a road net element as defined by a Municipality, Provincial Ministry, or Federal Agency and is associated to an established and/or maintained route.ROUTE_NAME_FRENCHVARCHAR2(75)NoNAME_FREThe French name that is attached to a road net element as defined by a Municipality, Provincial Ministry, or Federal Agency and is associated to an established and/or maintained route.AGENCY_NAMEVARCHAR2(100)NoAGENCYThe name of the agency.Permissible Values: (See ORN_AGENCY_NAME_LIST lookup table in appendix)EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.ORN_ROUTE_NUMBERThe route number attached to a road net element as defined by a Municipality, Provincial Ministry, or Federal Agency and is typically associated with provincial highways, secondary highways, county roads and regional roads.Column NameColumn TypeMandatoryShort NameDescriptionEVENT_IDNUMBER(13,0)YesEVENT_IDSystem generated identifier, unique at the application level.ORN_ROAD_NET_ELEMENT_IDNUMBER(13,0)YesELEMENT_IDForeign Key (FK) OGF_ID reference to parent ORN_ROAD_NET_ELEMENT_FT feature table record.FROM_MEASURENUMBER(9,3)YesFROM_MEASThe location of the beginning of the event measured in metres from the beginning of the road element. This measure is related to planimetric distance, not actual driven distance.TO_MEASURENUMBER(9,3)YesTO_MEASUREThe location of the end of the event measured in metres from the beginning of the road element. This measure is related to planimetric distance, not actual driven distance.ROUTE_NUMBERVARCHAR2(5)YesROUTE_NUMThe route number assigned to a road typically associated with provincial highways, secondary highways, county roads and regional roads and is represented by a numeric and/or an alpha-numeric character. A road can be assigned multiple route numbers.SHIELD_TYPEVARCHAR2(60)NoSHIELD_TThe shield type assigned to a route by a road authority.Permissible Values: (See ORN_SHIELD_TYPE_LIST lookup table in appendix)AGENCY_NAMEVARCHAR2(100)NoAGENCYThe name of the agency.Permissible Values: (See ORN_AGENCY_NAME_LIST lookup table in appendix)EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.ORN_SPEED_LIMITThe maximum speed limit assigned to a road element in kilometres per hour in accordance with Municipal By-Laws or Provincial Law. In cases where a road element has more than one speed limit value, the speed limit of the longest portion of the road element is supplied. Column NameColumn TypeMandatoryShort NameDescriptionEVENT_IDNUMBER(13,0)YesEVENT_IDSystem generated identifier, unique at the application level.ORN_ROAD_NET_ELEMENT_IDNUMBER(13,0)YesELEMENT_IDForeign Key (FK) OGF_ID reference to parent ORN_ROAD_NET_ELEMENT_FT feature table record.FROM_MEASURENUMBER(9,3)YesFROM_MEASThe location of the beginning of the event measured in metres from the beginning of the road element. This measure is related to planimetric distance, not actual driven distance.TO_MEASURENUMBER(9,3)YesTO_MEASUREThe location of the end of the event measured in metres from the beginning of the road element. This measure is related to planimetric distance, not actual driven distance.SPEED_LIMITNUMBER(3,0)YesLIMITThe maximum speed limit assigned to a road element in kilometres per hour in accordance with Municipal By-Laws or Provincial Law.AGENCY_NAMEVARCHAR2(100)NoAGENCYThe name of the agency.Permissible Values: (See ORN_AGENCY_NAME_LIST lookup table in appendix)EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.ORN_STREET_NAME_PARSEDA lookup table containing standardized and abbreviated official and alternate street names. This table also contains the official and alternate parsed components of the street name and must have a street name body, but may or may not have a directional prefix/suffix or street type prefix/suffix. Note: ORN_STREET_NAME_PARSED has been defined as a Non-Spatial class to support data loading for the ORN Road Net Element spatial Data Class.Column NameColumn TypeMandatoryShort NameDescriptionFULL_STREET_NAMEVARCHAR2(100)YesFULL_NAMEThis attribute is derived from the individual street name components where present, namely directional prefix, street type prefix, street name body, street type suffix and directional suffix and is stored in upper case text.DIRECTIONAL_PREFIXVARCHAR2(10)NoDIR_PREFIXA geographic direction, which is part of the official or alternate street name which precedes the street name body and, if appropriate, the street type prefix.Permissible Values: (See ORN_STREET_DIRECTION_LIST lookup table in appendix)STREET_TYPE_PREFIXVARCHAR2(20)NoST_TYPE_PA geographic direction, which is part of the official or alternate street name which precedes the street name body and, if appropriate, the street type prefix.Permissible Values: (See ORN_STREET_TYPE_LIST lookup table in appendix)STREET_NAME_BODYVARCHAR2(50)YesNAME_BODYThe identifying named component of an official or alternate street name. A street name must have a street name body and street name body can never be abbreviated.STREET_TYPE_SUFFIXVARCHAR2(20)NoST_TYPE_SA part of the official or alternate street name identifying the street type which follows the street name body.Permissible Values: (See ORN_STREET_TYPE_LIST lookup table in appendix)DIRECTIONAL_SUFFIXVARCHAR2(10)NoDIR_SUFFIXA geographic direction, which is part of the official or alternate street name which follows the street name body and, if appropriate, the street type suffix.Permissible Values: (See ORN_STREET_DIRECTION_LIST lookup table in appendix)OFFICIAL_LANGUAGEVARCHAR2(3)YesOFF_LANGA code identifying the official language.Permissible Values: (See ORN_OFFICIAL_LANGUAGE_LIST lookup table in appendix)ABBREVIATED_STREET_NAMEVARCHAR2(100)YesABBR_NAMEThis attribute is composed of the individual street name components, where present, including directional prefix, street type prefix, street name body, street type suffix and directional suffix. Street name components are abbreviated with the exception of street name body.EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.EXPIRY_DATETIMEDATENoEXP_DATEDate/time that the record was expired from use.ORN_STRUCTUREThe classification of a structure, that exists on a road element and is managed as a linear event. The types are mutually exclusive.Column NameColumn TypeMandatoryShort NameDescriptionEVENT_IDNUMBER(13,0)YesEVENT_IDSystem generated identifier, unique at the application level.ORN_ROAD_NET_ELEMENT_IDNUMBER(13,0)YesELEMENT_IDForeign Key (FK) OGF_ID reference to parent ORN_ROAD_NET_ELEMENT_FT feature table record.FROM_MEASURENUMBER(9,3)YesFROM_MEASThe location of the beginning of the event measured in metres from the beginning of the road element. This measure is related to planimetric distance, not actual driven distance.TO_MEASURENUMBER(9,3)YesTO_MEASUREThe location of the end of the event measured in metres from the beginning of the road element. This measure is related to planimetric distance, not actual driven distance.STRUCTURE_TYPEVARCHAR2(30)YesSTRUCT_TThe classification of a structure, that exists on a road element and is managed as a linear event.Permissible Values: See ORN_STRUCTURE_TYPE_LIST lookup table in appendix)STRUCTURE_NAME_ENGLISHVARCHAR2(50)NoNAME_ENGThe English name provided by a Municipality, Provincial Ministry or Federal Agency. A structure has only one English name.STRUCTURE_NAME_FRENCHVARCHAR2(50)NoNAME_FREThe French name provided by a Municipality, Provincial Ministry or Federal Agency. A structure has only one French name.AGENCY_NAMEVARCHAR2(100)NoAGENCYThe name of the agency.Permissible Values: (See ORN_AGENCY_NAME_LIST lookup table in appendix)NATIONAL_UUIDVARCHAR2(32)YesNIDA unique national identifier assigned to a road net element, junction and selected event data such as Toll Point, Blocked Passage and Structure which are required to support the National Road Network (NRN).EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.ORN_TOLL_POINTA point event along a road element indicating the presence of a toll point.Column NameColumn TypeMandatoryShort NameDescriptionEVENT_IDNUMBER(13,0)YesEVENT_IDSystem generated identifier, unique at the application level.ORN_ROAD_NET_ELEMENT_IDNUMBER(13,0)YesELEMENT_IDForeign Key (FK) OGF_ID reference to parent ORN_ROAD_NET_ELEMENT_FT feature table record.AT_MEASURENUMBER(9,3)YesAT_MEASUREAt measure represents a location or point of interest along a linear feature. At measure is expressed as a distance in metres from the beginning of the road net element. This measure is related to planimetric distance not actual driven distance.TOLL_POINT_TYPEVARCHAR2(10)YesTOLL_PT_TA point event indicating the type of a toll point that may exist along a road element. Permissible Values: (See ORN_TOLL_POINT_TYPE_LIST lookup table in appendix)AGENCY_NAMEVARCHAR2(100)NoAGENCYThe name of the agency.Permissible Values: (See ORN_AGENCY_NAME_LIST lookup table in appendix)NATIONAL_UUIDVARCHAR2(32)YesNIDA unique national identifier assigned to a road net element, junction and selected event data such as Toll Point, Blocked Passage and Structure which are required to support the National Road Network (NRN).EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.ORN_UNDERPASSA point event on a road element identifying the existence of an underpass. An underpass occurs where the road element runs underneath a passage accommodating the movement of water, a building, road, rail, pedestrian or wildlife.Column NameColumn TypeMandatoryShort NameDescriptionEVENT_IDNUMBER(13,0)YesEVENT_IDSystem generated identifier, unique at the application level.ORN_ROAD_NET_ELEMENT_IDNUMBER(13,0)YesELEMENT_IDForeign Key (FK) OGF_ID reference to parent ORN_ROAD_NET_ELEMENT_FT feature table record.AT_MEASURENUMBER(9,3)YesAT_MEASUREAt measure represents a location or point of interest along a linear feature. At measure is expressed as a distance in metres from the beginning of the road net element. This measure is related to planimetric distance not actual driven distance.UNDERPASS_TYPEVARCHAR2(10)YesTOLL_PT_TIdentifies the type of underpass present at this road location. Permissible Values: (See ORN_UNDERPASS_LIST lookup table in appendix)AGENCY_NAMEVARCHAR2(100)NoAGENCYThe name of the agency.Permissible Values: (See ORN_AGENCY_NAME_LIST lookup table in appendix)EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.6. Links to Additional InformationOfficial LIO Metadata Record for ORN Road Net Element ()Land Information Ontario (LIO) ()Canadian Federal Government’s GeoGratis: National Road Network ()GO-ITS 29 Ontario Road Network ()APPENDIX A: LIO Lookup Tables and ValuesORN_ACQUISITION_TECHNIQUE_LISTList of valid acquisition techniques.Column NameColumn TypeMandatoryShort NameDescriptionACQUISITION_TECHNIQUEVARCHAR2(25)YesACQTECHThe data source or technique used to create or revise the road net element.ACQUISITION_TECHNIQUE_DESCRVARCHAR2(100)YesACQTECH_DA description of the acquisition technique.NRN_ACQUISITIONTECHNIQUENUMBER(3,0)NoNRN_CODEAcquisition technique assigned to support the National Road Network (NRN).EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.EXPIRY_DATETIMEDATENoEXP_DATEDate/time that the record was expired from use.ORN_ACQUISITION_TECHNIQUE_LIST Permissible ValuesACQUISITION TECHNIQUEACQUISITION TECHNIQUE DESCRNRN ACQUISITION TECHNIQUEEXPIRYDATETIMEAERIAL PHOTOAerial photography not ortho-rectified10Not applicableCOMPUTEDGeometric information that has been computed (not captured)12Not applicableDIGITAL ELEVATION MODELData coming from a Digital Elevation Model (DEM)9Not applicableFIELD COMPLETIONInformation gathered from people directly in the field7Not applicableGPSData collected using a GPS device2Not applicableNONENo value applies0Not applicableORTHOIMAGESatellite imagery ortho-rectified3Not applicableORTHOPHOTOAerial photo ortho-rectified4Not applicableOTHERAll possible values not explicitly mentioned in the domain1Not applicablePAPER MAPConventional sources of information like maps or plans6Not applicableRASTER DATAData resulting from a scanning process8Not applicableRAW IMAGERY DATASatellite imagery not ortho-rectified11Not applicableUNKNOWNImpossible to determine-1Not applicableVECTOR DATAVector digital data5Not applicableORN_AGENCY_NAME_LISTThe name of the source agency providing geometry or attribute information. This is represented by either a Municipal Name, a Provincial Ministry (i.e. Ministry of Health, Ministry of Transport or the Ministry of Natural Resources) or a Federal Agency (i.e. Natural Resources Canada or Statistics and Elections Canada) and is subject to change.Column NameColumn TypeMandatoryShort NameDescriptionAGENCY_NAMEVARCHAR2(100)YesAGENCYThe name of the agency.AGENCY_TYPEVARCHAR2(10)YesAGENCY_TThe type of agency. Valid value: See table ORN_AGENCY_TYPE_LIST in Appendix for list of valid values.AGENCY_DESCRVARCHAR2(250)YesAGENCY_DA description of the type of agency.EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.EXPIRY_DATETIMEDATENoEXP_DATEDate/time that the record was expired from use.ORN_AGENCY_NAME_LIST Permissible ValuesAGENCY NAMEAGENCY TYPEAGENCY DESCREXPIRYDATETIMEELECTIONS AND STATISTICS CANADAFEDERALNGDNot applicableNRCANFEDERALNatural Resources CanadaNot applicableCITY OF BARRIEMUNICIPALBARRIENot applicableCITY OF BELLEVILLEMUNICIPALBELLEVILLENot applicableCITY OF BRAMPTONMUNICIPALBRAMPTONNot applicableCITY OF BRANTFORDMUNICIPALBRANTFORDNot applicableCITY OF BROCKVILLEMUNICIPALBROCKVILLENot applicableCITY OF BURLINGTONMUNICIPALBURLINGTONNot applicableCITY OF CAMBRIDGEMUNICIPALCAMBRIDGENot applicableCITY OF CLARENCE-ROCKLANDMUNICIPALCLARENCE-ROCKLANDNot applicableCITY OF CORNWALLMUNICIPALCORNWALLNot applicableCITY OF DRYDENMUNICIPALDRYDENNot applicableCITY OF ELLIOT LAKEMUNICIPALELLIOT LAKENot applicableCITY OF GREATER SUDBURYMUNICIPALGREATER SUDBURYNot applicableCITY OF GUELPHMUNICIPALGUELPHNot applicableCITY OF HAMILTONMUNICIPALHAMILTONNot applicableCITY OF KAWARTHA LAKESMUNICIPALKAWARTHA LAKESNot applicableCITY OF KENORAMUNICIPALKENORANot applicableCITY OF KINGSTONMUNICIPALKINGSTONNot applicableCITY OF KITCHENERMUNICIPALKITCHENERNot applicableCITY OF LONDONMUNICIPALLONDONNot applicableCITY OF MARKHAMMUNICIPALMARKHAMNot applicableCITY OF MISSISSAUGAMUNICIPALMISSISSAUGANot applicableCITY OF NIAGARA FALLSMUNICIPALNIAGARA FALLSNot applicableCITY OF NORTH BAYMUNICIPALNORTH BAYNot applicableCITY OF ORILLIAMUNICIPALORILLIANot applicableCITY OF OSHAWAMUNICIPALOSHAWANot applicableCITY OF OTTAWAMUNICIPALOTTAWANot applicableCITY OF OWEN SOUNDMUNICIPALOWEN SOUNDNot applicableCITY OF PEMBROKEMUNICIPALPEMBROKENot applicableCITY OF PETERBOROUGHMUNICIPALPETERBOROUGHNot applicableCITY OF PICKERINGMUNICIPALPICKERINGNot applicableCITY OF PORT COLBORNEMUNICIPALPORT COLBORNENot applicableCITY OF QUINTE WESTMUNICIPALQUINTE WESTNot applicableCITY OF SARNIAMUNICIPALSARNIANot applicableCITY OF SAULT STE. MARIEMUNICIPALSAULT STE. MARIENot applicableCITY OF ST. CATHARINESMUNICIPALST. CATHARINESNot applicableCITY OF ST. THOMASMUNICIPALST. THOMASNot applicableCITY OF STRATFORDMUNICIPALSTRATFORDNot applicableCITY OF TEMISKAMING SHORESMUNICIPALTEMISKAMING SHORESNot applicableCITY OF THOROLDMUNICIPALTHOROLDNot applicableCITY OF THUNDER BAYMUNICIPALTHUNDER BAYNot applicableCITY OF TIMMINSMUNICIPALTIMMINSNot applicableCITY OF TORONTOMUNICIPALTORONTONot applicableCITY OF VAUGHANMUNICIPALVAUGHANNot applicableCITY OF WATERLOOMUNICIPALWATERLOONot applicableCITY OF WELLANDMUNICIPALWELLANDNot applicableCITY OF WINDSORMUNICIPALWINDSORNot applicableCITY OF WOODSTOCKMUNICIPALWOODSTOCKNot applicableCOUNTY OF BRANTMUNICIPALBRANTNot applicableCOUNTY OF BRUCEMUNICIPALBRUCENot applicableCOUNTY OF DUFFERINMUNICIPALDUFFERINNot applicableCOUNTY OF ELGINMUNICIPALELGINNot applicableCOUNTY OF ESSEXMUNICIPALESSEXNot applicableCOUNTY OF FRONTENACMUNICIPALFRONTENACNot applicableCOUNTY OF GREYMUNICIPALGREYNot applicableCOUNTY OF HALIBURTONMUNICIPALHALIBURTONNot applicableCOUNTY OF HASTINGSMUNICIPALHASTINGSNot applicableCOUNTY OF HURONMUNICIPALHURONNot applicableCOUNTY OF LAMBTONMUNICIPALLAMBTONNot applicableCOUNTY OF LANARKMUNICIPALLANARKNot applicableCOUNTY OF LENNOX AND ADDINGTONMUNICIPALLENNOX AND ADDINGTONNot applicableCOUNTY OF MIDDLESEXMUNICIPALMIDDLESEXNot applicableCOUNTY OF NORTHUMBERLANDMUNICIPALNORTHUMBERLANDNot applicableCOUNTY OF OXFORDMUNICIPALOXFORDNot applicableCOUNTY OF PERTHMUNICIPALPERTHNot applicableCOUNTY OF PETERBOROUGHMUNICIPALPETERBOROUGHNot applicableCOUNTY OF PRINCE EDWARD COUNTYMUNICIPALPRINCE EDWARD COUNTYNot applicableCOUNTY OF RENFREWMUNICIPALRENFREWNot applicableCOUNTY OF SIMCOEMUNICIPALSIMCOENot applicableCOUNTY OF WELLINGTONMUNICIPALWELLINGTONNot applicableDISTRICT MUNICIPALITY OF MUSKOKAMUNICIPALMUSKOKANot applicableDISTRICT OF PARRY SOUNDMUNICIPALPARRY SOUNDNot applicableDISTRICT OF NIPISSINGMUNICIPALNIPISSINGNot applicableDISTRICT OF SUDBURYMUNICIPALSUDBURYNot applicableHALDIMAND COUNTYMUNICIPALHALDIMANDNot applicableMUNICIPALITY OF ARRAN-ELDERSLIEMUNICIPALARRAN-ELDERSLIENot applicableMUNICIPALITY OF BAYHAMMUNICIPALBAYHAMNot applicableMUNICIPALITY OF BLUEWATERMUNICIPALBLUEWATERNot applicableMUNICIPALITY OF BRIGHTONMUNICIPALBRIGHTONNot applicableMUNICIPALITY OF BROCKTONMUNICIPALBROCKTONNot applicableMUNICIPALITY OF BROOKE-ALVINSTONMUNICIPALBROOKE-ALVINSTONNot applicableMUNICIPALITY OF CALLANDERMUNICIPALCALLANDERNot applicableMUNICIPALITY OF CENTRAL ELGINMUNICIPALCENTRAL ELGINNot applicableMUNICIPALITY OF CENTRAL HURONMUNICIPALCENTRAL HURONNot applicableMUNICIPALITY OF CENTRE HASTINGSMUNICIPALCENTRE HASTINGSNot applicableMUNICIPALITY OF CHARLTON AND DACKMUNICIPALCHARLTON AND DACKNot applicableMUNICIPALITY OF CHATHAM-KENTMUNICIPALCHATHAM-KENTNot applicableMUNICIPALITY OF CLARINGTONMUNICIPALCLARINGTONNot applicableMUNICIPALITY OF DUTTON/DUNWICHMUNICIPALDUTTON-DUNWICHNot applicableMUNICIPALITY OF FRENCH RIVERMUNICIPALFRENCH RIVERNot applicableMUNICIPALITY OF GORDON / BARRIE ISLANDMUNICIPALGORDONNot applicableMUNICIPALITY OF GREENSTONEMUNICIPALGREENSTONENot applicableMUNICIPALITY OF GREY HIGHLANDSMUNICIPALGREY HIGHLANDSNot applicableMUNICIPALITY OF HASTINGS HIGHLANDSMUNICIPALHASTINGS HIGHLANDSNot applicableMUNICIPALITY OF HIGHLANDS EASTMUNICIPALHIGHLANDS EASTNot applicableMUNICIPALITY OF HURON EASTMUNICIPALHURON EASTNot applicableMUNICIPALITY OF HURON SHORESMUNICIPALHURON SHORESNot applicableMUNICIPALITY OF KILLARNEYMUNICIPALKILLARNEYNot applicableMUNICIPALITY OF KINCARDINEMUNICIPALKINCARDINENot applicableMUNICIPALITY OF LAMBTON SHORESMUNICIPALLAMBTON SHORESNot applicableMUNICIPALITY OF LEAMINGTONMUNICIPALLEAMINGTONNot applicableMUNICIPALITY OF MAGNETAWANMUNICIPALMAGNETAWANNot applicableMUNICIPALITY OF MARKSTAY-WARRENMUNICIPALMARKSTAY-WARRENNot applicableMUNICIPALITY OF MARMORA AND LAKEMUNICIPALMARMORA AND LAKENot applicableMUNICIPALITY OF MCDOUGALLMUNICIPALMCDOUGALLNot applicableMUNICIPALITY OF MEAFORDMUNICIPALMEAFORDNot applicableMUNICIPALITY OF MIDDLESEX CENTREMUNICIPALMIDDLESEX CENTRENot applicableMUNICIPALITY OF MORRIS-TURNBERRYMUNICIPALMORRIS-TURNBERRYNot applicableMUNICIPALITY OF NEEBINGMUNICIPALNEEBINGNot applicableMUNICIPALITY OF NORTH GRENVILLEMUNICIPALNORTH GRENVILLENot applicableMUNICIPALITY OF NORTH MIDDLESEXMUNICIPALNORTH MIDDLESEXNot applicableMUNICIPALITY OF NORTH PERTHMUNICIPALNORTH PERTHNot applicableMUNICIPALITY OF NORTHERN BRUCE PENINSULAMUNICIPALNORTHERN BRUCE PENINSULANot applicableMUNICIPALITY OF OLIVER PAIPOONGEMUNICIPALOLIVER PAIPOONGENot applicableMUNICIPALITY OF PORT HOPEMUNICIPALPORT HOPENot applicableMUNICIPALITY OF POWASSANMUNICIPALPOWASSANNot applicableMUNICIPALITY OF RED LAKEMUNICIPALRED LAKENot applicableMUNICIPALITY OF SHUNIAHMUNICIPALSHUNIAHNot applicableMUNICIPALITY OF SIOUX LOOKOUTMUNICIPALSIOUX LOOKOUTNot applicableMUNICIPALITY OF SOUTH BRUCEMUNICIPALSOUTH BRUCENot applicableMUNICIPALITY OF SOUTH DUNDASMUNICIPALSOUTH DUNDASNot applicableMUNICIPALITY OF SOUTH HURONMUNICIPALSOUTH HURONNot applicableMUNICIPALITY OF SOUTHWEST MIDDLESEXMUNICIPALSOUTHWEST MIDDLESEXNot applicableMUNICIPALITY OF ST.-CHARLESMUNICIPALST.-CHARLESNot applicableMUNICIPALITY OF TEMAGAMIMUNICIPALTEMAGAMINot applicableMUNICIPALITY OF THAMES CENTREMUNICIPALTHAMES CENTRENot applicableMUNICIPALITY OF THE NATIONMUNICIPALTHE NATIONNot applicableMUNICIPALITY OF TRENT HILLSMUNICIPALTRENT HILLSNot applicableMUNICIPALITY OF TRENT LAKESMUNICIPALGALWAY-CAVENDISH AND HARVEYNot applicableMUNICIPALITY OF TWEEDMUNICIPALTWEEDNot applicableMUNICIPALITY OF WAWAMUNICIPALMICHIPICOTENNot applicableMUNICIPALITY OF WEST ELGINMUNICIPALWEST ELGINNot applicableMUNICIPALITY OF WEST GREYMUNICIPALWEST GREYNot applicableMUNICIPALITY OF WEST NIPISSINGMUNICIPALWEST NIPISSINGNot applicableMUNICIPALITY OF WEST PERTHMUNICIPALWEST PERTHNot applicableMUNICIPALITY OF WHITESTONEMUNICIPALWHITESTONENot applicableNORFOLK COUNTYMUNICIPALNORFOLKNot applicableREGIONAL MUNICIPALITY OF DURHAMMUNICIPALDURHAMNot applicableREGIONAL MUNICIPALITY OF HALTONMUNICIPALHALTONNot applicableREGIONAL MUNICIPALITY OF NIAGARAMUNICIPALNIAGARANot applicableREGIONAL MUNICIPALITY OF PEELMUNICIPALPEELNot applicableREGIONAL MUNICIPALITY OF WATERLOOMUNICIPALWATERLOONot applicableREGIONAL MUNICIPALITY OF YORKMUNICIPALYORKNot applicableTHE CORPORATION OF THE MUNICIPALITY OF EAST FERRISMUNICIPALEAST FERRISNot applicableTOWN OF AJAXMUNICIPALAJAXNot applicableTOWN OF AMHERSTBURGMUNICIPALAMHERSTBURGNot applicableTOWN OF ARNPRIORMUNICIPALARNPRIORNot applicableTOWN OF AURORAMUNICIPALAURORANot applicableTOWN OF AYLMERMUNICIPALAYLMERNot applicableTOWN OF BANCROFTMUNICIPALBANCROFTNot applicableTOWN OF BLIND RIVERMUNICIPALBLIND RIVERNot applicableTOWN OF BRACEBRIDGEMUNICIPALBRACEBRIDGENot applicableTOWN OF BRADFORD WEST GWILLIMBURYMUNICIPALBRADFORD-WEST GWILLIMBURYNot applicableTOWN OF BRUCE MINESMUNICIPALBRUCE MINESNot applicableTOWN OF CALEDONMUNICIPALCALEDONNot applicableTOWN OF CARLETON PLACEMUNICIPALCARLETON PLACENot applicableTOWN OF COBALTMUNICIPALCOBALTNot applicableTOWN OF COBOURGMUNICIPALCOBOURGNot applicableTOWN OF COCHRANEMUNICIPALCOCHRANENot applicableTOWN OF COLLINGWOODMUNICIPALCOLLINGWOODNot applicableTOWN OF DEEP RIVERMUNICIPALDEEP RIVERNot applicableTOWN OF DESERONTOMUNICIPALDESERONTONot applicableTOWN OF EAST GWILLIMBURYMUNICIPALEAST GWILLIMBURYNot applicableTOWN OF ENGLEHARTMUNICIPALENGLEHARTNot applicableTOWN OF ERINMUNICIPALERINNot applicableTOWN OF ESPANOLAMUNICIPALESPANOLANot applicableTOWN OF ESSEXMUNICIPALESSEXNot applicableTOWN OF FORT ERIEMUNICIPALFORT ERIENot applicableTOWN OF FORT FRANCESMUNICIPALFORT FRANCESNot applicableTOWN OF GANANOQUEMUNICIPALGANANOQUENot applicableTOWN OF GEORGINAMUNICIPALGEORGINANot applicableTOWN OF GODERICHMUNICIPALGODERICHNot applicableTOWN OF GORE BAYMUNICIPALGORE BAYNot applicableTOWN OF GRAND VALLEYMUNICIPALEAST LUTHER GRAND VALLEYNot applicableTOWN OF GRAVENHURSTMUNICIPALGRAVENHURSTNot applicableTOWN OF GREATER NAPANEEMUNICIPALGREATER NAPANEENot applicableTOWN OF GRIMSBYMUNICIPALGRIMSBYNot applicableTOWN OF HALTON HILLSMUNICIPALHALTON HILLSNot applicableTOWN OF HANOVERMUNICIPALHANOVERNot applicableTOWN OF HAWKESBURYMUNICIPALHAWKESBURYNot applicableTOWN OF HEARSTMUNICIPALHEARSTNot applicableTOWN OF HUNTSVILLEMUNICIPALHUNTSVILLENot applicableTOWN OF INGERSOLLMUNICIPALINGERSOLLNot applicableTOWN OF INNISFILMUNICIPALINNISFILNot applicableTOWN OF IROQUOIS FALLSMUNICIPALIROQUOIS FALLSNot applicableTOWN OF KAPUSKASINGMUNICIPALKAPUSKASINGNot applicableTOWN OF KEARNEYMUNICIPALKEARNEYNot applicableTOWN OF KINGSVILLEMUNICIPALKINGSVILLENot applicableTOWN OF KIRKLAND LAKEMUNICIPALKIRKLAND LAKENot applicableTOWN OF LAKESHOREMUNICIPALLAKESHORENot applicableTOWN OF LASALLEMUNICIPALLASALLENot applicableTOWN OF LATCHFORDMUNICIPALLATCHFORDNot applicableTOWN OF LAURENTIAN HILLSMUNICIPALLAURENTIAN HILLSNot applicableTOWN OF LINCOLNMUNICIPALLINCOLNNot applicableTOWN OF MARATHONMUNICIPALMARATHONNot applicableTOWN OF MATTAWAMUNICIPALMATTAWANot applicableTOWN OF MIDLANDMUNICIPALMIDLANDNot applicableTOWN OF MILTONMUNICIPALMILTONNot applicableTOWN OF MINTOMUNICIPALMINTONot applicableTOWN OF MONOMUNICIPALMONONot applicableTOWN OF MOOSONEEMUNICIPALMOOSONEENot applicableTOWN OF NEW TECUMSETHMUNICIPALNEW TECUMSETHNot applicableTOWN OF NEWMARKETMUNICIPALNEWMARKETNot applicableTOWN OF NIAGARA-ON-THE-LAKEMUNICIPALNIAGARA-ON-THE-LAKENot applicableTOWN OF NORTHEASTERN MANITOULIN AND THE ISLANDSMUNICIPALNORTHEASTERN MANITOULIN AND THE ISLANDSNot applicableTOWN OF OAKVILLEMUNICIPALOAKVILLENot applicableTOWN OF ORANGEVILLEMUNICIPALORANGEVILLENot applicableTOWN OF PARRY SOUNDMUNICIPALPARRY SOUNDNot applicableTOWN OF PELHAMMUNICIPALPELHAMNot applicableTOWN OF PENETANGUISHENEMUNICIPALPENETANGUISHENENot applicableTOWN OF PERTHMUNICIPALPERTHNot applicableTOWN OF PETAWAWAMUNICIPALPETAWAWANot applicableTOWN OF PETROLIAMUNICIPALPETROLIANot applicableTOWN OF PLYMPTON-WYOMINGMUNICIPALPLYMPTON-WYOMINGNot applicableTOWN OF PRESCOTTMUNICIPALPRESCOTTNot applicableTOWN OF RAINY RIVERMUNICIPALRAINY RIVERNot applicableTOWN OF RENFREWMUNICIPALRENFREWNot applicableTOWN OF RICHMOND HILLMUNICIPALRICHMOND HILLNot applicableTOWN OF SAUGEEN SHORESMUNICIPALSAUGEEN SHORESNot applicableTOWN OF SHELBURNEMUNICIPALSHELBURNENot applicableTOWN OF SMITHS FALLSMUNICIPALSMITHS FALLSNot applicableTOWN OF SMOOTH ROCK FALLSMUNICIPALSMOOTH ROCK FALLSNot applicableTOWN OF SOUTH BRUCE PENINSULAMUNICIPALSOUTH BRUCE PENINSULANot applicableTOWN OF SPANISHMUNICIPALSPANISHNot applicableTOWN OF ST. MARYSMUNICIPALST. MARYSNot applicableTOWN OF TECUMSEHMUNICIPALTECUMSEHNot applicableTOWN OF THE BLUE MOUNTAINSMUNICIPALTHE BLUE MOUNTAINSNot applicableTOWN OF THESSALONMUNICIPALTHESSALONNot applicableTOWN OF TILLSONBURGMUNICIPALTILLSONBURGNot applicableTOWN OF WASAGA BEACHMUNICIPALWASAGA BEACHNot applicableTOWN OF WHITBYMUNICIPALWHITBYNot applicableTOWN OF WHITCHURCH-STOUFFVILLEMUNICIPALWHITCHURCH-STOUFFVILLENot applicableTOWNSHIP OF ADDINGTON HIGHLANDSMUNICIPALADDINGTON HIGHLANDSNot applicableTOWNSHIP OF ADELAIDE-METCALFEMUNICIPALADELAIDE-METCALFENot applicableTOWNSHIP OF ADJALA-TOSORONTIOMUNICIPALADJALA-TOSORONTIONot applicableTOWNSHIP OF ADMASTON/BROMLEYMUNICIPALADMASTON/BROMLEYNot applicableTOWNSHIP OF ALBERTONMUNICIPALALBERTONNot applicableTOWNSHIP OF ALFRED AND PLANTAGENETMUNICIPALALFRED AND PLANTAGENETNot applicableTOWNSHIP OF ALGONQUIN HIGHLANDSMUNICIPALALGONQUIN HIGHLANDSNot applicableTOWNSHIP OF ALNWICK/HALDIMANDMUNICIPALALNWICK-HALDIMANDNot applicableTOWNSHIP OF AMARANTHMUNICIPALAMARANTHNot applicableTOWNSHIP OF ARMOURMUNICIPALARMOURNot applicableTOWNSHIP OF ARMSTRONGMUNICIPALARMSTRONGNot applicableTOWNSHIP OF ASHFIELD-COLBORNE-WAWANOSHMUNICIPALASHFIELD-COLBORNE-WAWANOSHNot applicableTOWNSHIP OF ASPHODEL-NORWOODMUNICIPALASPHODEL-NORWOODNot applicableTOWNSHIP OF ASSIGINACKMUNICIPALASSIGINACKNot applicableTOWNSHIP OF ATHENSMUNICIPALATHENSNot applicableTOWNSHIP OF ATIKOKANMUNICIPALATIKOKANNot applicableTOWNSHIP OF AUGUSTAMUNICIPALAUGUSTANot applicableTOWNSHIP OF BALDWINMUNICIPALBALDWINNot applicableTOWNSHIP OF BARRIE ISLANDMUNICIPALBARRIE ISLANDNot applicableTOWNSHIP OF BECKWITHMUNICIPALBECKWITHNot applicableTOWNSHIP OF BILLINGSMUNICIPALBILLINGSNot applicableTOWNSHIP OF BLACK RIVER-MATHESONMUNICIPALBLACK RIVER-MATHESONNot applicableTOWNSHIP OF BLANDFORD-BLENHEIMMUNICIPALBLANDFORD-BLENHEIMNot applicableTOWNSHIP OF BONFIELDMUNICIPALBONFIELDNot applicableTOWNSHIP OF BONNECHERE VALLEYMUNICIPALBONNECHERE VALLEYNot applicableTOWNSHIP OF BRETHOURMUNICIPALBRETHOURNot applicableTOWNSHIP OF BROCKMUNICIPALBROCKNot applicableTOWNSHIP OF BRUDENELL, LYNDOCH AND RAGLANMUNICIPALBRUDENELL LYNOCH AND RAGLANNot applicableTOWNSHIP OF BURPEE AND MILLSMUNICIPALBURPEE AND MILLSNot applicableTOWNSHIP OF CALVINMUNICIPALCALVINNot applicableTOWNSHIP OF CARLINGMUNICIPALCARLINGNot applicableTOWNSHIP OF CARLOW/MAYOMUNICIPALCARLOW/MAYONot applicableTOWNSHIP OF CASEYMUNICIPALCASEYNot applicableTOWNSHIP OF CAVAN MONAGHANMUNICIPALCAVAN-MILLBROOK-NORTH MONAGHANNot applicableTOWNSHIP OF CENTRAL FRONTENACMUNICIPALCENTRAL FRONTENACNot applicableTOWNSHIP OF CENTRAL MANITOULINMUNICIPALCENTRAL MANITOULINNot applicableTOWNSHIP OF CENTRE WELLINGTONMUNICIPALCENTRE WELLINGTONNot applicableTOWNSHIP OF CHAMBERLAINMUNICIPALCHAMBERLAINNot applicableTOWNSHIP OF CHAMPLAINMUNICIPALCHAMPLAINNot applicableTOWNSHIP OF CHAPLEAUMUNICIPALCHAPLEAUNot applicableTOWNSHIP OF CHAPPLEMUNICIPALCHAPPLENot applicableTOWNSHIP OF CHATSWORTHMUNICIPALCHATSWORTHNot applicableTOWNSHIP OF CHISHOLMMUNICIPALCHISHOLMNot applicableTOWNSHIP OF CLEARVIEWMUNICIPALCLEARVIEWNot applicableTOWNSHIP OF COCKBURN ISLANDMUNICIPALCOCKBURN ISLANDNot applicableTOWNSHIP OF COLEMANMUNICIPALCOLEMANNot applicableTOWNSHIP OF CONMEEMUNICIPALCONMEENot applicableTOWNSHIP OF CRAMAHEMUNICIPALCRAMAHENot applicableTOWNSHIP OF DAWN-EUPHEMIAMUNICIPALDAWN-EUPHEMIANot applicableTOWNSHIP OF DAWSONMUNICIPALDAWSONNot applicableTOWNSHIP OF DORIONMUNICIPALDORIONNot applicableTOWNSHIP OF DOURO-DUMMERMUNICIPALDOURO-DUMMERNot applicableTOWNSHIP OF DRUMMOND/NORTH ELMSLEYMUNICIPALDRUMMOND-NORTH ELMSLEYNot applicableTOWNSHIP OF DUBREUILVILLEMUNICIPALDUBREUILVILLENot applicableTOWNSHIP OF EAR FALLSMUNICIPALEAR FALLSNot applicableTOWNSHIP OF EAST GARAFRAXAMUNICIPALEAST GARAFRAXANot applicableTOWNSHIP OF EAST HAWKESBURYMUNICIPALEAST HAWKESBURYNot applicableTOWNSHIP OF EAST ZORRA-TAVISTOCKMUNICIPALEAST ZORRA-TAVISTOCKNot applicableTOWNSHIP OF EDWARDSBURGH/CARDINALMUNICIPALEDWARDSBURGH/CARDINALNot applicableTOWNSHIP OF ELIZABETHTOWN-KITLEYMUNICIPALELIZABETHTOWN-KITLEYNot applicableTOWNSHIP OF EMOMUNICIPALEMONot applicableTOWNSHIP OF ENNISKILLENMUNICIPALENNISKILLENNot applicableTOWNSHIP OF ESSAMUNICIPALESSANot applicableTOWNSHIP OF EVANTURELMUNICIPALEVANTURELNot applicableTOWNSHIP OF FARADAYMUNICIPALFARADAYNot applicableTOWNSHIP OF FAUQUIER-STRICKLANDMUNICIPALFAUQUIER-STRICKLANDNot applicableTOWNSHIP OF FRONT OF YONGEMUNICIPALFRONT OF YONGENot applicableTOWNSHIP OF FRONTENAC ISLANDSMUNICIPALFRONTENAC ISLANDSNot applicableTOWNSHIP OF GAUTHIERMUNICIPALGAUTHIERNot applicableTOWNSHIP OF GEORGIAN BAYMUNICIPALGEORGIAN BAYNot applicableTOWNSHIP OF GEORGIAN BLUFFSMUNICIPALGEORGIAN BLUFFSNot applicableTOWNSHIP OF GILLIESMUNICIPALGILLIESNot applicableTOWNSHIP OF GREATER MADAWASKAMUNICIPALGREATER MADAWASKANot applicableTOWNSHIP OF GUELPH/ERAMOSAMUNICIPALGUELPH/ERAMOSANot applicableTOWNSHIP OF HAMILTONMUNICIPALHAMILTONNot applicableTOWNSHIP OF HARLEYMUNICIPALHARLEYNot applicableTOWNSHIP OF HARRISMUNICIPALHARRISNot applicableTOWNSHIP OF HAVELOCK-BELMONT-METHUENMUNICIPALHAVELOCK-BELMONT-METHUENNot applicableTOWNSHIP OF HEAD, CLARA AND MARIAMUNICIPALHEAD CLARA AND MARIANot applicableTOWNSHIP OF HILLIARDMUNICIPALHILLIARDNot applicableTOWNSHIP OF HILTONMUNICIPALHILTONNot applicableTOWNSHIP OF HORNEPAYNEMUNICIPALHORNEPAYNENot applicableTOWNSHIP OF HORTONMUNICIPALHORTONNot applicableTOWNSHIP OF HOWICKMUNICIPALHOWICKNot applicableTOWNSHIP OF HUDSONMUNICIPALHUDSONNot applicableTOWNSHIP OF HURON-KINLOSSMUNICIPALHURON-KINLOSSNot applicableTOWNSHIP OF IGNACEMUNICIPALIGNACENot applicableTOWNSHIP OF JAMESMUNICIPALJAMESNot applicableTOWNSHIP OF JOCELYNMUNICIPALJOCELYNNot applicableTOWNSHIP OF JOHNSONMUNICIPALJOHNSONNot applicableTOWNSHIP OF JOLYMUNICIPALJOLYNot applicableTOWNSHIP OF KERNSMUNICIPALKERNSNot applicableTOWNSHIP OF KILLALOE, HAGARTY AND RICHARDSMUNICIPALKILLALOE HAGARTY AND RICHARDSNot applicableTOWNSHIP OF KINGMUNICIPALKINGNot applicableTOWNSHIP OF LA VALLEEMUNICIPALLA VALLEENot applicableTOWNSHIP OF LAIRDMUNICIPALLAIRDNot applicableTOWNSHIP OF LAKE OF BAYSMUNICIPALLAKE OF BAYSNot applicableTOWNSHIP OF LAKE OF THE WOODSMUNICIPALLAKE OF THE WOODSNot applicableTOWNSHIP OF LANARK HIGHLANDSMUNICIPALLANARK HIGHLANDSNot applicableTOWNSHIP OF LARDER LAKEMUNICIPALLARDER LAKENot applicableTOWNSHIP OF LAURENTIAN VALLEYMUNICIPALLAURENTIAN VALLEYNot applicableTOWNSHIP OF LEEDS AND THE THOUSAND ISLANDSMUNICIPALLEEDS AND THE THOUSAND ISLANDSNot applicableTOWNSHIP OF LIMERICKMUNICIPALLIMERICKNot applicableTOWNSHIP OF LOYALISTMUNICIPALLOYALISTNot applicableTOWNSHIP OF LUCAN BIDDULPHMUNICIPALLUCAN BIDDULPHNot applicableTOWNSHIP OF MACDONALD, MEREDITH AND ABERDEEN ADDITIONALMUNICIPALMACDONALD MEREDITH AND ABERDEEN ADDITIONALNot applicableTOWNSHIP OF MACHARMUNICIPALMACHARNot applicableTOWNSHIP OF MACHINMUNICIPALMACHINNot applicableTOWNSHIP OF MADAWASKA VALLEYMUNICIPALMADAWASKA VALLEYNot applicableTOWNSHIP OF MADOCMUNICIPALMADOCNot applicableTOWNSHIP OF MALAHIDEMUNICIPALMALAHIDENot applicableTOWNSHIP OF MANITOUWADGEMUNICIPALMANITOUWADGENot applicableTOWNSHIP OF MAPLETONMUNICIPALMAPLETONNot applicableTOWNSHIP OF MATACHEWANMUNICIPALMATACHEWANNot applicableTOWNSHIP OF MATTAWANMUNICIPALMATTAWANNot applicableTOWNSHIP OF MATTICE-VAL C?T?MUNICIPALMATTICE-VAL C?T?Not applicableTOWNSHIP OF MCGARRYMUNICIPALMCGARRYNot applicableTOWNSHIP OF MCKELLARMUNICIPALMCKELLARNot applicableTOWNSHIP OF MCMURRICH/MONTEITHMUNICIPALMCMURRICH-MONTEITHNot applicableTOWNSHIP OF MCNAB/BRAESIDEMUNICIPALMCNAB-BRAESIDENot applicableTOWNSHIP OF MELANCTHONMUNICIPALMELANCTHONNot applicableTOWNSHIP OF MINDEN HILLSMUNICIPALMINDEN HILLSNot applicableTOWNSHIP OF MONTAGUEMUNICIPALMONTAGUENot applicableTOWNSHIP OF MOONBEAMMUNICIPALMOONBEAMNot applicableTOWNSHIP OF MORLEYMUNICIPALMORLEYNot applicableTOWNSHIP OF MULMURMUNICIPALMULMURNot applicableTOWNSHIP OF MUSKOKA LAKESMUNICIPALMUSKOKA LAKESNot applicableTOWNSHIP OF NAIRN AND HYMANMUNICIPALNAIRN AND HYMANNot applicableTOWNSHIP OF NIPIGONMUNICIPALNIPIGONNot applicableTOWNSHIP OF NIPISSINGMUNICIPALNIPISSINGNot applicableTOWNSHIP OF NORTH ALGONA WILBERFORCEMUNICIPALNORTH ALGONA-WILBERFORCENot applicableTOWNSHIP OF NORTH DUMFRIESMUNICIPALNORTH DUMFRIESNot applicableTOWNSHIP OF NORTH DUNDASMUNICIPALNORTH DUNDASNot applicableTOWNSHIP OF NORTH FRONTENACMUNICIPALNORTH FRONTENACNot applicableTOWNSHIP OF NORTH GLENGARRYMUNICIPALNORTH GLENGARRYNot applicableTOWNSHIP OF NORTH HURONMUNICIPALNORTH HURONNot applicableTOWNSHIP OF NORTH KAWARTHAMUNICIPALNORTH KAWARTHANot applicableTOWNSHIP OF NORTH STORMONTMUNICIPALNORTH STORMONTNot applicableTOWNSHIP OF NORWICHMUNICIPALNORWICHNot applicableTOWNSHIP OF O'CONNORMUNICIPALO'CONNORNot applicableTOWNSHIP OF OPASATIKAMUNICIPALOPASATIKANot applicableTOWNSHIP OF ORO-MEDONTEMUNICIPALORO-MEDONTENot applicableTOWNSHIP OF OTONABEE-SOUTH MONAGHANMUNICIPALOTONABEE-SOUTH MONAGHANNot applicableTOWNSHIP OF PAPINEAU-CAMERONMUNICIPALPAPINEAU-CAMERONNot applicableTOWNSHIP OF PELEEMUNICIPALPELEENot applicableTOWNSHIP OF PERRYMUNICIPALPERRYNot applicableTOWNSHIP OF PERTH EASTMUNICIPALPERTH EASTNot applicableTOWNSHIP OF PERTH SOUTHMUNICIPALPERTH SOUTHNot applicableTOWNSHIP OF PICKLE LAKEMUNICIPALPICKLE LAKENot applicableTOWNSHIP OF PLUMMER ADDITIONALMUNICIPALPLUMMER ADDITIONALNot applicableTOWNSHIP OF PRINCEMUNICIPALPRINCENot applicableTOWNSHIP OF PUSLINCHMUNICIPALPUSLINCHNot applicableTOWNSHIP OF RAMARAMUNICIPALRAMARANot applicableTOWNSHIP OF RED ROCKMUNICIPALRED ROCKNot applicableTOWNSHIP OF RIDEAU LAKESMUNICIPALRIDEAU LAKESNot applicableTOWNSHIP OF RUSSELLMUNICIPALRUSSELLNot applicableTOWNSHIP OF RYERSONMUNICIPALRYERSONNot applicableTOWNSHIP OF SABLES-SPANISH RIVERSMUNICIPALSABLES-SPANISH RIVERSNot applicableTOWNSHIP OF SCHREIBERMUNICIPALSCHREIBERNot applicableTOWNSHIP OF SCUGOGMUNICIPALSCUGOGNot applicableTOWNSHIP OF SEGUINMUNICIPALSEGUINNot applicableTOWNSHIP OF SELWYNMUNICIPALSMITH-ENNISMORE-LAKEFIELDNot applicableTOWNSHIP OF SEVERNMUNICIPALSEVERNNot applicableTOWNSHIP OF SIOUX NARROWS-NESTOR FALLSMUNICIPALSIOUX NARROWS-NESTOR FALLSNot applicableTOWNSHIP OF SOUTH ALGONQUINMUNICIPALSOUTH ALGONQUINNot applicableTOWNSHIP OF SOUTH FRONTENACMUNICIPALSOUTH FRONTENACNot applicableTOWNSHIP OF SOUTH GLENGARRYMUNICIPALSOUTH GLENGARRYNot applicableTOWNSHIP OF SOUTH STORMONTMUNICIPALSOUTH STORMONTNot applicableTOWNSHIP OF SOUTHGATEMUNICIPALSOUTHGATENot applicableTOWNSHIP OF SOUTH-WEST OXFORDMUNICIPALSOUTH-WEST OXFORDNot applicableTOWNSHIP OF SOUTHWOLDMUNICIPALSOUTHWOLDNot applicableTOWNSHIP OF SPRINGWATERMUNICIPALSPRINGWATERNot applicableTOWNSHIP OF ST. CLAIRMUNICIPALST. CLAIRNot applicableTOWNSHIP OF ST. JOSEPHMUNICIPALST. JOSEPHNot applicableTOWNSHIP OF STIRLING-RAWDONMUNICIPALSTIRLING-RAWDONNot applicableTOWNSHIP OF STONE MILLSMUNICIPALSTONE MILLSNot applicableTOWNSHIP OF STRATHROY-CARADOCMUNICIPALSTRATHROY-CARADOCNot applicableTOWNSHIP OF STRONGMUNICIPALSTRONGNot applicableTOWNSHIP OF TARBUTT AND TARBUTT ADDITIONALMUNICIPALTARBUTT AND TARBUTT ADDITIONALNot applicableTOWNSHIP OF TAYMUNICIPALTAYNot applicableTOWNSHIP OF TAY VALLEYMUNICIPALTAY VALLEYNot applicableTOWNSHIP OF TEHKUMMAHMUNICIPALTEHKUMMAHNot applicableTOWNSHIP OF TERRACE BAYMUNICIPALTERRACE BAYNot applicableTOWNSHIP OF THE ARCHIPELAGOMUNICIPALTHE ARCHIPELAGONot applicableTOWNSHIP OF THE NORTH SHOREMUNICIPALTHE NORTH SHORENot applicableTOWNSHIP OF TINYMUNICIPALTINYNot applicableTOWNSHIP OF TUDOR AND CASHELMUNICIPALTUDOR AND CASHELNot applicableTOWNSHIP OF TYENDINAGAMUNICIPALTYENDINAGANot applicableTOWNSHIP OF UXBRIDGEMUNICIPALUXBRIDGENot applicableTOWNSHIP OF VAL RITA-HARTYMUNICIPALVAL RITA-HARTYNot applicableTOWNSHIP OF WAINFLEETMUNICIPALWAINFLEETNot applicableTOWNSHIP OF WARWICKMUNICIPALWARWICKNot applicableTOWNSHIP OF WELLESLEYMUNICIPALWELLESLEYNot applicableTOWNSHIP OF WELLINGTON NORTHMUNICIPALWELLINGTON NORTHNot applicableTOWNSHIP OF WEST LINCOLNMUNICIPALWEST LINCOLNNot applicableTOWNSHIP OF WHITE RIVERMUNICIPALWHITE RIVERNot applicableTOWNSHIP OF WHITEWATER REGIONMUNICIPALWHITEWATER REGIONNot applicableTOWNSHIP OF WILMOTMUNICIPALWILMOTNot applicableTOWNSHIP OF WOLLASTONMUNICIPALWOLLASTONNot applicableTOWNSHIP OF WOOLWICHMUNICIPALWOOLWICHNot applicableTOWNSHIP OF ZORRAMUNICIPALZORRANot applicableUNITED COUNTIES OF LEEDS AND GRENVILLEMUNICIPALLEEDS AND GRENVILLENot applicableUNITED COUNTIES OF PRESCOTT AND RUSSELLMUNICIPALPRESCOTT AND RUSSELLNot applicableUNITED COUNTIES OF STORMONT, DUNDAS AND GLENGARRYMUNICIPALSTORMONT, DUNDAS AND GLENGARRYNot applicableUNITED TOWNSHIPS OF DYSART, DUDLEY, HARCOURT, GUILFORD, HARBURN, BRUTON, HAVELOCK, EYRE AND CLYDEMUNICIPALDYSART DUDLEY HARCOURT GUILFORD HARBURN BRUTON HAVELOCK EYRE AND CLYDENot applicableVILLAGE OF BURK'S FALLSMUNICIPALBURK'S FALLSNot applicableVILLAGE OF CASSELMANMUNICIPALCASSELMANNot applicableVILLAGE OF HILTON BEACHMUNICIPALHILTON BEACHNot applicableVILLAGE OF MERRICKVILLE-WOLFORDMUNICIPALMERRICKVILLE-WOLFORDNot applicableVILLAGE OF NEWBURYMUNICIPALNEWBURYNot applicableVILLAGE OF OIL SPRINGSMUNICIPALOIL SPRINGSNot applicableVILLAGE OF POINT EDWARDMUNICIPALPOINT EDWARDNot applicableVILLAGE OF SOUTH RIVERMUNICIPALSOUTH RIVERNot applicableVILLAGE OF SUNDRIDGEMUNICIPALSUNDRIDGENot applicableVILLAGE OF THORNLOEMUNICIPALTHORNLOENot applicableVILLAGE OF WESTPORTMUNICIPALWESTPORTNot applicableMINISTRY OF NATURAL RESOURCESPROVINCIALMNRNot applicableMINISTRY OF TRANSPORTATIONPROVINCIALMTONot applicableONTARIO MINISTRY OF HEALTHPROVINCIALSLRNNot applicableONTARIO PROVINCIAL POLICEPROVINCIALJRNNot applicableORN_AGENCY_TYPE_LISTList of valid agency types.Column NameColumn TypeMandatoryShort NameDescriptionAGENCY_TYPEVARCHAR2(10)YesAGENCY_TThe name of the agency.AGENCY_TYPE_DESCRVARCHAR2(35)YesAGENCY_TA description of the type of agency.NRN_ACQUISITIONPROVIDERNUMBER(3,0)NoNRN_CODEAcquisition provider assigned to support the National Road Network (NRN).EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.EXPIRY_DATETIMEDATENoEXP_DATEDate/time that the record was expired from use.ORN_AGENCY_TYPE_LIST Permissible ValuesAGENCY TYPEAGENCY TYPE DESCRNRN ACQUISITION PROVIDEREXPIRY DATETIMEFEDERALFEDERAL2Not applicableMUNICIPALMUNICIPAL4Not applicableOTHEROTHER1Not applicablePROVINCIALPROVINCIAL3Not applicableORN_BLOCKED_PASSAGE_TYPE_LISTList of valid blocked passage types.Column NameColumn TypeMandatoryShort NameDescriptionBLOCKED_PASSAGE_TYPEVARCHAR2(10)YesBLOCKED_TThe type of man-made or natural barrier or access restriction placed on a road element to control or limit access to a road net element.BLOCKED_PASSAGE_TYPE_DESCRVARCHAR2(750)YesBLOCKED_DA description of the blocked passage type.NRN_BLOCKEDPASSAGETYPENUMBER(3,0)NoNRN_CODEBlocked passage type assigned to support the National Road Network (NRN).EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.EXPIRY_DATETIMEDATENoEXP_DATEDate/time that the record was expired from use.ORN_BLOCKED_PASSAGE_TYPE_LIST Permissible ValuesBLOCKED PASSAGE TYPEBLOCKED PASSAGE TYPE DESCRNRN BLOCKED PASSAGE TYPEEXPIRYDATETIMEPermanentAn obstacle placed across a road element that has to be removed or destroyed to free the entrance to the other side of the road that it is blocking. Examples include: concrete blocks, mound of earth or culvert or bridge removed.1Not applicableRemovableA man-made barrier designed to block the entrance to the other side of the road element. An example is a locked gate.2Not applicableORN_DIR_OF_TRAFFIC_FLOW_LISTList of valid direction of traffic flows.Column NameColumn TypeMandatoryShort NameDescriptionDIRECTION_OF_TRAFFIC_FLOWVARCHAR2(8)YesDIRECTION_The direction(s) of vehicular or motor traffic flow. All road elements must have a direction of traffic flow assigned.DIR_OF_TRAFFIC_FLOW_DESCRVARCHAR2(100)YesDESCRA description of the direction of traffic flow.NRN_DIRECTIONOFTRAFFICFLOWNUMBER(3,0)NoNRN_CODEDirection of traffic flow assigned to support the National Road Network (NRN).EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.EXPIRY_DATETIMEDATENoEXP_DATEDate/time that the record was expired from use.ORN_DIR_OF_TRAFFIC_FLOW_LIST Permissible ValuesDIRECTION OF TRAFFIC FLOWDIR OF TRAFFIC FLOW DESCRNRN DIRECTIONOFTRAFFICFLOWEXPIRYDATETIMEBothTraffic is allowed in both directions.1Not applicableNegativeTraffic is opposite to the direction of the geometry.3Not applicablePositiveTraffic is in the same direction as the geometry.2Not applicableORN_HOUSE_NUM_STRUCTURE_LISTList of valid house number structures.Column NameColumn TypeMandatoryShort NameDescriptionHOUSE_NUMBER_STRUCTUREVARCHAR2(10)YesNUM_STRUCTThe type of house or property numbering system that is applied to the address range.HOUSE_NUMBER_STRUCTURE_DESCRVARCHAR2(500)YesNUM_STR_DA description of the house number structure.NRN_HOUSENUMBERSTRUCTURENUMBER(3,0)NoNRN_CODEHouse number structure assigned to support the National Road Network (NRN).EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.EXPIRY_DATETIMEDATENoEXP_DATEDate/time that the record was expired from use.ORN_HOUSE_NUM_STRUCTURE_LIST Permissible ValuesHOUSE NUMBER STRUCTUREHOUSE NUMBER STRUCTURE DESCRNRN HOUSE NUMBER STRUCTUREEXPIRYDATETIMEEvenThe house numbers appear as even numbers in a sequential sorted order (ascending or descending) when moving from one end of an address information event to the other. Numeric completeness of the series is not a requirement.1Not applicableIrregularThe house numbers do not occur in any sorted order.4Not applicableMixedThe house numbers are odd and even on the same side of an address information event in sequential order (asc or desc) when moving from one end of the address information event to the other. Numeric completeness of the series is not a requirement.3Not applicableNoneNo house numbers at all. There are no houses (or addressed dwellings) along a particular side of an address information event.0Not applicableOddThe house numbers appear as odd numbers in a sequential sorted order (ascending or descending) when moving from one end of the address information event to the other. Numeric completeness of the series is not a requirement.2Not applicableORN_JUNCTION_TYPE_LISTList of valid junction types.Column NameColumn TypeMandatoryShort NameDescriptionJUNCTION_TYPEVARCHAR2(15)YesJCT_TYPEThe classification of a junction is based on the valency of the junction. The number of road elements or ferry connections joining at a junction is termed the valency of a junction. For example a junction that connects a total of two road elements is called a two valent junction.JUNCTION_TYPE_DESCRVARCHAR2(100)YesJCT_TYPE_DA description of the junction type.NRN_JUNCTIONTYPENUMBER(3,0)NoNRN_CODEJunction type assigned to support the National Road Network (NRN).EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.EXPIRY_DATETIMEDATENoEXP_DATEDate/time that the record was expired from use.ORN_JUNCTION_TYPE_LIST Permissible ValuesJUNCTION TYPEJUNCTION TYPE DESCRNRN JUNCTION TYPEEXPIRYDATETIMEBoundaryIntersection of a road element or a ferry connection with a provincial or international boundary.4Not applicableDead EndAt the end of a dead-end road element.2Not applicableFerryIntersection of a road element and a ferry connection.3Not applicableIntersectionIntersection of three or more road elements at the same grade level.1Not applicableORN_JURISDICTION_LISTList of valid road jurisdictions as maintained by the Municipality, Provincial Ministries, and Federal Agencies and is subject to change. Jurisdiction may be based on street side.Column NameColumn TypeMandatoryShort NameDescriptionJURISDICTIONVARCHAR2(80)YesJURISAn indication of who has the jurisdictional, or custodianship responsibility for a road net element. The custodian would have the responsibility to ensure maintenance occurs, but is not necessarily the one who undertakes the maintenance directly.EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.EXPIRY_DATETIMEDATENoEXP_DATEDate/time that the record was expired from use.ORN_JURISDICTION_LIST Permissible ValuesJURISDICTIONEXPIRY DATETIME407 EtrNot applicableAbitibi 70Not applicableAgency 1Not applicableAkwesasne 59Not applicableAlderville First NationNot applicableBig Grassy River 35gNot applicableCfb BordenNot applicableChapleau Cree Fox LakeNot applicableChief's Point 28Not applicableChippewas of Georgina Island First NationNot applicableChippewas of the Thames First Nation 42Not applicableChristian Island 30Not applicableChristian Island 30aNot applicableCity of BarrieNot applicableCity of BellevilleNot applicableCity of BramptonNot applicableCity of Brant CountyNot applicableCity of BrantfordNot applicableCity of BrockvilleNot applicableCity of BurlingtonNot applicableCity of CambridgeNot applicableCity of Clarence-RocklandNot applicableCity of CornwallNot applicableCity of DrydenNot applicableCity of Elliot LakeNot applicableCity of Greater SudburyNot applicableCity of GuelphNot applicableCity of HamiltonNot applicableCity of Kawartha LakesNot applicableCity of KenoraNot applicableCity of KingstonNot applicableCity of KitchenerNot applicableCity of LondonNot applicableCity of MarkhamNot applicableCity of MississaugaNot applicableCity of Niagara FallsNot applicableCity of North BayNot applicableCity of OrilliaNot applicableCity of OshawaNot applicableCity of OttawaNot applicableCity of Owen SoundNot applicableCity of PembrokeNot applicableCity of PeterboroughNot applicableCity of PickeringNot applicableCity of Port ColborneNot applicableCity of Quinte WestNot applicableCity of SarniaNot applicableCity of Sault Ste. MarieNot applicableCity of St. CatharinesNot applicableCity of St. ThomasNot applicableCity of StratfordNot applicableCity of Temiskaming ShoresNot applicableCity of ThoroldNot applicableCity of Thunder BayNot applicableCity of TimminsNot applicableCity of TorontoNot applicableCity of VaughanNot applicableCity of WaterlooNot applicableCity of WellandNot applicableCity of WindsorNot applicableCity of WoodstockNot applicableConstance Lake 92Not applicableCorporation of the Municipality of Mississippi MillsNot applicableCouchiching 16aNot applicableCounty of BrantNot applicableCounty of HaliburtonNot applicableCounty of OxfordNot applicableCounty of PeterboroughNot applicableCounty of Prince Edward CountyNot applicableDistrict Municipality of MuskokaNot applicableDistrict of AlgomaNot applicableDistrict of CochraneNot applicableDistrict of KenoraNot applicableDistrict of ManitoulinNot applicableDistrict of NipissingNot applicableDistrict of Parry SoundNot applicableDistrict of Rainy RiverNot applicableDistrict of SudburyNot applicableDistrict of Thunder BayNot applicableDistrict of TimiskamingNot applicableDokis 9Not applicableDuck Lake 76bNot applicableEagle Lake 27Not applicableEast Luther Grand ValleyNot applicableEnglish River 21Not applicableFederalNot applicableFort William 52Not applicableFrench River 13Not applicableGarden River 14Not applicableGinoogaming First NationNot applicableGoulais Bay 15aNot applicableGreater Toronto Airport AuthorityNot applicableGros Cap 49Not applicableGull River 55Not applicableHaldimand CountyNot applicableHenvey Inlet 2Not applicableHiawatha First Nation 36Not applicableKenora 38bNot applicableKettle Point 44Not applicableLac Seul 28Not applicableLake Helen 53aNot applicableMagnetawan 1Not applicableManitou Rapids 11Not applicableMatachewan 72Not applicableMattagami 71Not applicableM'Chigeeng 22Not applicableMinistry of Natural ResourcesNot applicableMinistry of TransportationNot applicableMississagi River 8Not applicableMississauga's of Scugog IslandNot applicableMnjikaning First Nation 32Not applicableMoravian 47Not applicableMountbatten 76aNot applicableMunicipality of Arran-ElderslieNot applicableMunicipality of BayhamNot applicableMunicipality of BluewaterNot applicableMunicipality of BrightonNot applicableMunicipality of BrocktonNot applicableMunicipality of Brooke-AlvinstonNot applicableMunicipality of CallanderNot applicableMunicipality of Central ElginNot applicableMunicipality of Central HuronNot applicableMunicipality of Centre HastingsNot applicableMunicipality of Charlton and DackNot applicableMunicipality of Chatham-KentNot applicableMunicipality of ClaringtonNot applicableMunicipality of Dutton/DunwichNot applicableMunicipality of French RiverNot applicableMunicipality of Gordon / Barrie IslandNot applicableMunicipality of GreenstoneNot applicableMunicipality of Grey HighlandsNot applicableMunicipality of Hastings HighlandsNot applicableMunicipality of Highlands EastNot applicableMunicipality of Huron EastNot applicableMunicipality of Huron ShoresNot applicableMunicipality of KillarneyNot applicableMunicipality of KincardineNot applicableMunicipality of Lambton ShoresNot applicableMunicipality of LeamingtonNot applicableMunicipality of MagnetawanNot applicableMunicipality of Markstay-WarrenNot applicableMunicipality of Marmora and LakeNot applicableMunicipality of McDougallNot applicableMunicipality of MeafordNot applicableMunicipality of Middlesex CentreNot applicableMunicipality of Morris-TurnberryNot applicableMunicipality of NeebingNot applicableMunicipality of North GrenvilleNot applicableMunicipality of North MiddlesexNot applicableMunicipality of North PerthNot applicableMunicipality of Northern Bruce PeninsulaNot applicableMunicipality of Oliver PaipoongeNot applicableMunicipality of Port HopeNot applicableMunicipality of PowassanNot applicableMunicipality of Red LakeNot applicableMunicipality of ShuniahNot applicableMunicipality of Sioux LookoutNot applicableMunicipality of South BruceNot applicableMunicipality of South DundasNot applicableMunicipality of South HuronNot applicableMunicipality of Southwest MiddlesexNot applicableMunicipality of St.-CharlesNot applicableMunicipality of TemagamiNot applicableMunicipality of Thames CentreNot applicableMunicipality of the NationNot applicableMunicipality of Trent HillsNot applicableMunicipality of Trent LakesNot applicableMunicipality of TweedNot applicableMunicipality of WawaNot applicableMunicipality of West ElginNot applicableMunicipality of West GreyNot applicableMunicipality of West NipissingNot applicableMunicipality of West PerthNot applicableMunicipality of WhitestoneNot applicableMunsee-Delaware Nation 1Not applicableNaiscoutaing 17aNot applicableNeguaguon Lake 25dNot applicableNew Credit 40aNot applicableNew Post 69aNot applicableNeyaashiinigmiingNot applicableNipissing 10Not applicableNorfolk CountyNot applicableOneida 41Not applicableOsnaburgh 63bNot applicableParry Island First NationNot applicablePays Plat 51Not applicablePic Mobert Reserve SouthNot applicablePic River 50Not applicablePikwakanaganNot applicablePrivateNot applicableProvincialNot applicableRainy Lake 17aNot applicableRainy Lake 18cNot applicableRainy Lake 26aNot applicableRankin Location 15dNot applicableRat Portage 38aNot applicableRegional Municipality of DurhamNot applicableRegional Municipality of HaltonNot applicableRegional Municipality of NiagaraNot applicableRegional Municipality of PeelNot applicableRegional Municipality of WaterlooNot applicableRegional Municipality of YorkNot applicableSabaskong Bay 35dNot applicableSagamokNot applicableSarnia 45Not applicableSaug-A-Gaw-Sing 1Not applicableSaugeen 29Not applicableSeine River 23aNot applicableSerpent River 7Not applicableShawanaga 17Not applicableSheshegwaning 20Not applicableShoal Lake 34b2Not applicableShoal Lake 39aNot applicableShoal Lake 40Not applicableSix Nations 40Not applicableSturgeon Falls 23Not applicableSucker Creek 23Not applicableThe Corporation of the Municipality of East FerrisNot applicableThe Dalles 38cNot applicableThessalon 12Not applicableTown of AjaxNot applicableTown of AmherstburgNot applicableTown of ArnpriorNot applicableTown of AuroraNot applicableTown of AylmerNot applicableTown of BancroftNot applicableTown of Blind RiverNot applicableTown of BracebridgeNot applicableTown of Bradford West GwillimburyNot applicableTown of Bruce MinesNot applicableTown of CaledonNot applicableTown of Carleton PlaceNot applicableTown of CobaltNot applicableTown of CobourgNot applicableTown of CochraneNot applicableTown of CollingwoodNot applicableTown of Deep RiverNot applicableTown of DeserontoNot applicableTown of East GwillimburyNot applicableTown of EnglehartNot applicableTown of ErinNot applicableTown of EspanolaNot applicableTown of EssexNot applicableTown of Fort ErieNot applicableTown of Fort FrancesNot applicableTown of GananoqueNot applicableTown of GeorginaNot applicableTown of GoderichNot applicableTown of Gore BayNot applicableTown of Grand ValleyNot applicableTown of GravenhurstNot applicableTown of Greater NapaneeNot applicableTown of GrimsbyNot applicableTown of Halton HillsNot applicableTown of HanoverNot applicableTown of HawkesburyNot applicableTown of HearstNot applicableTown of HuntsvilleNot applicableTown of IngersollNot applicableTown of InnisfilNot applicableTown of Iroquois FallsNot applicableTown of KapuskasingNot applicableTown of KearneyNot applicableTown of KingsvilleNot applicableTown of Kirkland LakeNot applicableTown of LakeshoreNot applicableTown of LasalleNot applicableTown of LatchfordNot applicableTown of Laurentian HillsNot applicableTown of LincolnNot applicableTown of MarathonNot applicableTown of MattawaNot applicableTown of MidlandNot applicableTown of MiltonNot applicableTown of MintoNot applicableTown of MonoNot applicableTown of New TecumsethNot applicableTown of NewmarketNot applicableTown of Niagara-On-The-LakeNot applicableTown of Northeastern Manitoulin and the IslandsNot applicableTown of OakvilleNot applicableTown of OrangevilleNot applicableTown of Parry SoundNot applicableTown of PelhamNot applicableTown of PenetanguisheneNot applicableTown of PerthNot applicableTown of PetawawaNot applicableTown of PetroliaNot applicableTown of Plympton-WyomingNot applicableTown of PrescottNot applicableTown of Rainy RiverNot applicableTown of RenfrewNot applicableTown of Richmond HillNot applicableTown of Saugeen ShoresNot applicableTown of ShelburneNot applicableTown of Smiths FallsNot applicableTown of Smooth Rock FallsNot applicableTown of South Bruce PeninsulaNot applicableTown of SpanishNot applicableTown of St. MarysNot applicableTown of TecumsehNot applicableTown of the Blue MountainsNot applicableTown of ThessalonNot applicableTown of TillsonburgNot applicableTown of Wasaga BeachNot applicableTown of WhitbyNot applicableTown of Whitchurch-StouffvilleNot applicableTownship of Addington HighlandsNot applicableTownship of Adelaide-MetcalfeNot applicableTownship of Adjala-TosorontioNot applicableTownship of Admaston/BromleyNot applicableTownship of AlbertonNot applicableTownship of Alfred and PlantagenetNot applicableTownship of Algonquin HighlandsNot applicableTownship of Alnwick/HaldimandNot applicableTownship of AmaranthNot applicableTownship of ArmourNot applicableTownship of ArmstrongNot applicableTownship of Ashfield-Colborne-WawanoshNot applicableTownship of Asphodel-NorwoodNot applicableTownship of AssiginackNot applicableTownship of AthensNot applicableTownship of AtikokanNot applicableTownship of AugustaNot applicableTownship of BaldwinNot applicableTownship of Barrie IslandNot applicableTownship of BeckwithNot applicableTownship of BillingsNot applicableTownship of Black River-MathesonNot applicableTownship of Blandford-BlenheimNot applicableTownship of BonfieldNot applicableTownship of Bonnechere ValleyNot applicableTownship of BrethourNot applicableTownship of BrockNot applicableTownship of Brudenell, Lyndoch and RaglanNot applicableTownship of Burpee and MillsNot applicableTownship of CalvinNot applicableTownship of CarlingNot applicableTownship of Carlow/MayoNot applicableTownship of CaseyNot applicableTownship of Cavan MonaghanNot applicableTownship of Central FrontenacNot applicableTownship of Central ManitoulinNot applicableTownship of Centre WellingtonNot applicableTownship of ChamberlainNot applicableTownship of ChamplainNot applicableTownship of ChapleauNot applicableTownship of ChappleNot applicableTownship of ChatsworthNot applicableTownship of ChisholmNot applicableTownship of ClearviewNot applicableTownship of ColemanNot applicableTownship of ConmeeNot applicableTownship of CramaheNot applicableTownship of Dawn-EuphemiaNot applicableTownship of DawsonNot applicableTownship of DorionNot applicableTownship of Douro-DummerNot applicableTownship of Drummond/North ElmsleyNot applicableTownship of DubreuilvilleNot applicableTownship of Ear FallsNot applicableTownship of East GarafraxaNot applicableTownship of East HawkesburyNot applicableTownship of East Zorra-TavistockNot applicableTownship of Edwardsburgh/CardinalNot applicableTownship of Elizabethtown-KitleyNot applicableTownship of EmoNot applicableTownship of EnniskillenNot applicableTownship of EssaNot applicableTownship of EvanturelNot applicableTownship of FaradayNot applicableTownship of Fauquier-StricklandNot applicableTownship of Front of YongeNot applicableTownship of Frontenac IslandsNot applicableTownship of GauthierNot applicableTownship of Georgian BayNot applicableTownship of Georgian BluffsNot applicableTownship of GilliesNot applicableTownship of Greater MadawaskaNot applicableTownship of Guelph/EramosaNot applicableTownship of HamiltonNot applicableTownship of HarleyNot applicableTownship of HarrisNot applicableTownship of Havelock-Belmont-MethuenNot applicableTownship of Head, Clara and MariaNot applicableTownship of HilliardNot applicableTownship of HiltonNot applicableTownship of HornepayneNot applicableTownship of HortonNot applicableTownship of HowickNot applicableTownship of HudsonNot applicableTownship of Huron-KinlossNot applicableTownship of IgnaceNot applicableTownship of JamesNot applicableTownship of JocelynNot applicableTownship of JohnsonNot applicableTownship of JolyNot applicableTownship of KernsNot applicableTownship of Killaloe, Hagarty and RichardsNot applicableTownship of KingNot applicableTownship of La ValleeNot applicableTownship of LairdNot applicableTownship of Lake of BaysNot applicableTownship of Lake of the WoodsNot applicableTownship of Lanark HighlandsNot applicableTownship of Larder LakeNot applicableTownship of Laurentian ValleyNot applicableTownship of Leeds and the Thousand IslandsNot applicableTownship of LimerickNot applicableTownship of LoyalistNot applicableTownship of Lucan BiddulphNot applicableTownship of MacDonald, Meredith and Aberdeen AdditionalNot applicableTownship of MacharNot applicableTownship of MachinNot applicableTownship of Madawaska ValleyNot applicableTownship of MadocNot applicableTownship of MalahideNot applicableTownship of ManitouwadgeNot applicableTownship of MapletonNot applicableTownship of MatachewanNot applicableTownship of MattawanNot applicableTownship of Mattice-Val C?téNot applicableTownship of McGarryNot applicableTownship of McKellarNot applicableTownship of McMurrich/MonteithNot applicableTownship of McNab/BraesideNot applicableTownship of MelancthonNot applicableTownship of Minden HillsNot applicableTownship of MontagueNot applicableTownship of MoonbeamNot applicableTownship of MorleyNot applicableTownship of MulmurNot applicableTownship of Muskoka LakesNot applicableTownship of Nairn and HymanNot applicableTownship of NipigonNot applicableTownship of NipissingNot applicableTownship of North Algona WilberforceNot applicableTownship of North DumfriesNot applicableTownship of North DundasNot applicableTownship of North FrontenacNot applicableTownship of North GlengarryNot applicableTownship of North HuronNot applicableTownship of North KawarthaNot applicableTownship of North StormontNot applicableTownship of NorwichNot applicableTownship of O'ConnorNot applicableTownship of OpasatikaNot applicableTownship of Oro-MedonteNot applicableTownship of Otonabee-South MonaghanNot applicableTownship of Papineau-CameronNot applicableTownship of PeleeNot applicableTownship of PerryNot applicableTownship of Perth EastNot applicableTownship of Perth SouthNot applicableTownship of Pickle LakeNot applicableTownship of Plummer AdditionalNot applicableTownship of PrinceNot applicableTownship of PuslinchNot applicableTownship of RamaraNot applicableTownship of Red RockNot applicableTownship of Rideau LakesNot applicableTownship of RussellNot applicableTownship of RyersonNot applicableTownship of Sables-Spanish RiversNot applicableTownship of SchreiberNot applicableTownship of ScugogNot applicableTownship of SeguinNot applicableTownship of SelwynNot applicableTownship of SevernNot applicableTownship of Sioux Narrows-Nestor FallsNot applicableTownship of South AlgonquinNot applicableTownship of South FrontenacNot applicableTownship of South GlengarryNot applicableTownship of South StormontNot applicableTownship of SouthgateNot applicableTownship of South-West OxfordNot applicableTownship of SouthwoldNot applicableTownship of SpringwaterNot applicableTownship of St. ClairNot applicableTownship of St. JosephNot applicableTownship of Stirling-RawdonNot applicableTownship of Stone MillsNot applicableTownship of Strathroy-CaradocNot applicableTownship of StrongNot applicableTownship of Tarbutt and Tarbutt AdditionalNot applicableTownship of TayNot applicableTownship of Tay ValleyNot applicableTownship of TehkummahNot applicableTownship of Terrace BayNot applicableTownship of the ArchipelagoNot applicableTownship of the North ShoreNot applicableTownship of TinyNot applicableTownship of Tudor and CashelNot applicableTownship of TyendinagaNot applicableTownship of UxbridgeNot applicableTownship of Val Rita-HartyNot applicableTownship of WainfleetNot applicableTownship of WarwickNot applicableTownship of WellesleyNot applicableTownship of Wellington NorthNot applicableTownship of West LincolnNot applicableTownship of White RiverNot applicableTownship of Whitewater RegionNot applicableTownship of WilmotNot applicableTownship of WollastonNot applicableTownship of WoolwichNot applicableTownship of ZorraNot applicableTyendinaga Mohawk TerritoryNot applicableUnited Townships of DysartNot applicableVillage of Burk's FallsNot applicableVillage of CasselmanNot applicableVillage of Hilton BeachNot applicableVillage of Merrickville-WolfordNot applicableVillage of NewburyNot applicableVillage of Oil SpringsNot applicableVillage of Point EdwardNot applicableVillage of South RiverNot applicableVillage of SundridgeNot applicableVillage of ThornloeNot applicableVillage of WestportNot applicableWabaseemoongNot applicableWabauskang 21Not applicableWabigoon Lake 27Not applicableWahnapitei 11Not applicableWahta Mohawk TerritoryNot applicableWalpole Island 46Not applicableWhitefish Bay 33aNot applicableWhitefish Bay 34aNot applicableWhitefish Lake 6Not applicableWhitefish River 4Not applicableWhitesandNot applicableWikwemikong Unceded 26Not applicableZhiibaahaasing 19aNot applicableORN_OFFICIAL_LANGUAGE_LISTList of valid Official Languages – official language code.Column NameColumn TypeMandatoryShort NameDescriptionOFFICIAL_LANGUAGEVARCHAR2(3)YesOFF_LANGA code identifying the official language.OFFICIAL_LANGUAGE _DESCRVARCHAR2(10)YesOFF_LANG_DA description of the surface type.NRN_OFFICIALLANGUAGENUMBER(3,0)NoNRN_CODEOfficial language assigned to support the National Road Network (NRN).EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.EXPIRY_DATETIMEDATENoEXP_DATEDate/time that the record was expired from use.ORN_OFFICIAL_LANGUAGE_LIST Permissible ValuesOFFICIAL LANGUAGEOFFICIAL LANGUAGE DESCRNRN OFFICIAL LANGUAGEEXPIRYDATETIMEENGEnglish2Not applicableFRE French1Not applicableORN_PAVEMENT_STATUS_LISTList of valid road surface types.Column NameColumn TypeMandatoryShort NameDescriptionPAVEMENT_STATUSVARCHAR2(10)YesPAVEMENT_SThe surface type of a road element.PAVEMENT_STATUS_DESCRVARCHAR2(100)YesPAVEMENT_DA description of the surface type.NRN_PAVEMENTSTATUSNUMBER(3,0)NoNRN_CODEPavement status assigned to support the National Road Network (NRN).EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.EXPIRY_DATETIMEDATENoEXP_DATEDate/time that the record was expired from use.ORN_PAVEMENT_STATUS_LIST Permissible ValuesPAVEMENT STATUSPAVEMENT STATUS DESCRNRN PAVEMENT STATUSEXPIRYDATETIMEPavedA road element which is paved.1Not applicableUnpavedA road element which is not paved.2Not applicableORN_ROAD_CLASS_LISTList of valid road classes.Column NameColumn TypeMandatoryShort NameDescriptionROAD_CLASSVARCHAR2(25)YesROAD_CLASSThe classification of a road.ROAD_CLASS_DESCRVARCHAR2(250)YesROAD_CLASSA description of the road class.NRN_ROADCLASSNUMBER(3,0)NoNRN_CODERoad class assigned to support the National Road Network (NRN).EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.EXPIRY_DATETIMEDATENoEXP_DATEDate/time that the record was expired from use.ORN_ROAD_CLASS_LIST Permissible ValuesROAD CLASSROAD CLASS DESCRNRN ROADCLASSEXPIRYDATETIMEAlleyway / LanewayA low speed thoroughfare dedicated to provide access to the rear of properties.8Not applicableArterialA major thoroughfare with medium to large traffic capacity3Not applicableCollectorA minor thoroughfare mainly used to access properties and to feed traffic with right of way.4Not applicableExpressway / HighwayA high-speed thoroughfare with a combination of controlled access and intersections at grade level.2Not applicableFreewayAn unimpeded, high speed controlled access thoroughfare for through traffic with typically no at grade intersections, usually with no property access or direct access and which is accessed by a ramp. Pedestrians prohibited.1Not applicableLocal / StrataA low speed thoroughfare dedicated to provide access to properties with potential public restriction, trailer parks, First Nations, strata or private estates.6Not applicableLocal / StreetA low speed thoroughfare dedicated to provide full access to the front of properties.5Not applicableLocal / UnknownA low speed thoroughfare dedicated to provide access to the front of properties but for which the access regulations are unknown.7Not applicableRampA system of interconnecting roadways providing for the controlled movement between two or more roadways.9Not applicableRapid TransitA thoroughfare restricted 24 hours a day, for the sole use of public transportation buses.11Not applicableResource / RecreationA narrow passage which has as a primary function access for resources extraction and also may have a role in providing an access for the public to back country.10Not applicableServiceA stretch of road permitting vehicles to come to a stop along a Freeway or Highway. These include weigh scales, emergency lanes, lookouts and rest areas.12Not applicableWinterA road that is only useable during the winter months when conditions allow for passage over lakes, rivers and wetlands.13Not applicableORN_ROAD_ELEMENT_TYPE_LISTList of valid road element types.Column NameColumn TypeMandatoryShort NameDescriptionROAD_ELEMENT_TYPEVARCHAR2(20)YesELEM_TYPEAn attribute describing the type of road net element.ROAD_ELEMENT_TYPE_DESCRVARCHAR2(750)YesELEM_TYP_DA description of the road element type.EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.EXPIRY_DATETIMEDATENoEXP_DATEDate/time that the record was expired from use.ROAD ELEMENT TYPEROAD ELEMENT TYPE DESCREXPIRY DATETIMEFERRY CONNECTIONThe approximate route a ferry travels to transport vehicles across water and is linked to a road element by a junction.Not applicableROAD ELEMENTThe basic centreline road feature spanning from intersection to intersection, or intersection to end where there is no subsequent intersection with another road.Not applicableVIRTUAL ROADA linear feature that is used as an address anchor for Bell 911 address information that is collected for dwellings (i.e. cottages) on islands or shorelines that are not accessible by road. These features are not actual roads and may or may not be connected to the main road network. They may be represented as straight line segments which bisect an island or follow the approximate shoreline of an island. They may also be represented as extensions of the road network crossing over land and water.Not applicableORN_SHIELD_TYPE_LISTThe shield types that may be assigned to a route by a road authority and is used for cartographic purposes.Column NameColumn TypeMandatoryShort NameDescriptionSHIELD_TYPEVARCHAR2(60)YesSHIELD_TThe shield type assigned to a route by a road authority.SHIELD_TYPE_DESCRVARCHAR2(750)YesSHIELD_T_DA description of the shield type.EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.EXPIRY_DATETIMEDATENoEXP_DATEDate/time that the record was expired from use.ORN_SHIELD_TYPE_LIST Permissible ValuesSHIELD TYPESHIELD TYPE DESCREXPIRY DATETIMEDISTRICT, COUNTY, REGIONAL OR MUNICIPAL ROAD SHIELDUpper Tier, Lower Tier or Single Tier Municipal RoadsNot applicablePRIMARY, KINGS OR 400 SERIES HIGHWAY SHIELDA network of highways that represents the oldest provincial highways (numbered from 2 to 148) and which are designed to connect urban centres of 2000 people or more by the shortest possible route. Also includes controlled access 400 series highways (CAH), including the Queen Elizabeth Way (QEW) that have imposed stricter access and adjacent land use controls (numbered 400 - 427).Not applicableSECONDARY HIGHWAY SHIELDA network of highways (numbered from 502 - 673) which connect smaller urban centres to each other and to the Kings Highway system. These highways often connect major traffic generators like airports, mines, quarries, saw mills, resort areas etc to the Kings Highway network. They became part of the provincial highway system in the 1950's and 1960's. The Secondary Highway System takes the place of the County or Regional Road systems in those areas of the province without incorporated municipalities or where the tax base was too low to afford a County Road system.Not applicableTERTIARY HIGHWAY SHIELDHighways which connect remote communities in Northern Ontario to the Secondary or Kings Highway network. Tertiary Highways have provincial highway numbers in the 800 series and were generally established in the 1950's and 1960's. The Ministry of Transportation (MTO) is not obligated to maintain Tertiary Highways in the winter nor is MTO liable if winter maintenance is not provided. The Lieutenant Governor in Council (LGIC) can also designate a Tertiary Highway as a Resource Road. A number of the provisions of the Highway Traffic Act that apply to Kings and Secondary Highways do not apply to Tertiary Highways.Not applicableTOLL HIGHWAY SHIELDA controlled access highway which involves the payment of a fee to travel upon. Currently, Ontario only has one toll highway, the 407ETR or Electronic Toll Route, located in the golden horseshoe.Not applicableORN_STANDARD_MUNICIPALITY_LISTList of valid standard municipalities.Column NameColumn TypeMandatoryShort NameDescriptionSTANDARD_MUNICIPALITYVARCHAR2(100)YesSTD_MUNICStandardized municipality names as maintained by the Ministry of Municipal Affairs and Housing (MMAH), and Official Indian Reserve Names as maintained by the Federal Government.EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.EXPIRY_DATETIMEDATENoEXP_DATEDate/time that the record was expired from use.ORN_STANDARD_MUNICIPALITY_LIST Permissible ValuesSTANDARD MUNICIPALITYEXPIRY DATETIMEAbitibi 70Not applicableAgency 1Not applicableAgency 30Not applicableAkwesasne 59Not applicableAlderville First NationNot applicableAssabaskaNot applicableAttawapiskat 91Not applicableAttawapiskat 91aNot applicableBear Island 1Not applicableBearskin LakeNot applicableBig Grassy River 35gNot applicableBig Island 31dNot applicableBig Island 31eNot applicableBig Island 31fNot applicableBig Island 37Not applicableBig Island Mainland 93Not applicableCape Croker Hunting Grounds 60bNot applicableCat Lake 63cNot applicableCfb BordenNot applicableChapleau 61Not applicableChapleau 61aNot applicableChapleau 74Not applicableChapleau 74aNot applicableChapleau 75Not applicableChapleau Cree Fox LakeNot applicableChief's Point 28Not applicableChippewa IslandNot applicableChippewas of Georgina Island First NationNot applicableChippewas of Georgina Island First Nation 33aNot applicableChippewas of the Thames First Nation 42Not applicableChristian Island 30Not applicableChristian Island 30aNot applicableCity of BarrieNot applicableCity of BellevilleNot applicableCity of BramptonNot applicableCity of BrantfordNot applicableCity of BrockvilleNot applicableCity of BurlingtonNot applicableCity of CambridgeNot applicableCity of Clarence-RocklandNot applicableCity of CornwallNot applicableCity of DrydenNot applicableCity of Elliot LakeNot applicableCity of Greater SudburyNot applicableCity of GuelphNot applicableCity of HamiltonNot applicableCity of Kawartha LakesNot applicableCity of KenoraNot applicableCity of KingstonNot applicableCity of KitchenerNot applicableCity of LondonNot applicableCity of MarkhamNot applicableCity of MississaugaNot applicableCity of Niagara FallsNot applicableCity of North BayNot applicableCity of OrilliaNot applicableCity of OshawaNot applicableCity of OttawaNot applicableCity of Owen SoundNot applicableCity of PembrokeNot applicableCity of PeterboroughNot applicableCity of PickeringNot applicableCity of Port ColborneNot applicableCity of Quinte WestNot applicableCity of SarniaNot applicableCity of Sault Ste. MarieNot applicableCity of St. CatharinesNot applicableCity of St. ThomasNot applicableCity of StratfordNot applicableCity of Temiskaming ShoresNot applicableCity of ThoroldNot applicableCity of Thunder BayNot applicableCity of TimminsNot applicableCity of TorontoNot applicableCity of VaughanNot applicableCity of WaterlooNot applicableCity of WellandNot applicableCity of WindsorNot applicableCity of WoodstockNot applicableConstance Lake 92Not applicableCorporation of the Municipality of Mississippi MillsNot applicableCouchiching 16aNot applicableCounty of BrantNot applicableCounty of Prince Edward CountyNot applicableCurve Lake 35aNot applicableCurve Lake First Nation 35Not applicableDeer LakeNot applicableDistrict of AlgomaNot applicableDistrict of CochraneNot applicableDistrict of KenoraNot applicableDistrict of ManitoulinNot applicableDistrict of NipissingNot applicableDistrict of Parry SoundNot applicableDistrict of Rainy RiverNot applicableDistrict of SudburyNot applicableDistrict of Thunder BayNot applicableDistrict of TimiskamingNot applicableDokis 9Not applicableDuck Lake 76bNot applicableEagle Lake 27Not applicableEnglish River 21Not applicableEnglish River 66Not applicableFactory Island 1Not applicableFlying Post 73Not applicableFort Albany 67Not applicableFort Hope 64Not applicableFort Severn 89Not applicableFort William 52Not applicableFrench River 13Not applicableGarden River 14Not applicableGinoogaming First NationNot applicableGlebe Farm 40bNot applicableGoulais Bay 15aNot applicableGros Cap 49Not applicableGros Cap Indian Village 49aNot applicableGull River 55Not applicableHaldimand CountyNot applicableHenvey Inlet 2Not applicableHiawatha First Nation 36Not applicableIndian River 1Not applicableIslands In the Trent Waters 36aNot applicableKasabonika LakeNot applicableKeewaywinNot applicableKenora 38bNot applicableKettle Point 44Not applicableKingfisher 2aNot applicableKingfisher 3aNot applicableKingfisher Lake 1Not applicableKitchenuhmaykoosib Aaki 84Not applicableLac Des Mille Lacs 22a1Not applicableLac des Mille Lacs 22a2Not applicableLac Seul 28Not applicableLake Helen 53aNot applicableLake Nipigon ReserveNot applicableLake of the Woods 31bNot applicableLake of the Woods 31cNot applicableLake of the Woods 31gNot applicableLake of the Woods 31hNot applicableLake of the Woods 34Not applicableLake of the Woods 35jNot applicableLake of the Woods 37Not applicableLake of the Woods 37bNot applicableLong Lake 58Not applicableLong Sault 12Not applicableMagnetawan 1Not applicableManitou Rapids 11Not applicableMarten Falls 65Not applicableMatachewan 72Not applicableMattagami 71Not applicableM'Chigeeng 22Not applicableMissanabie 62Not applicableMississagi River 8Not applicableMississauga's of Scugog IslandNot applicableMnjikaning First Nation 32Not applicableMoose Factory 68Not applicableMoose Point 79Not applicableMoravian 47Not applicableMountbatten 76aNot applicableMunicipality of Arran-ElderslieNot applicableMunicipality of BayhamNot applicableMunicipality of BluewaterNot applicableMunicipality of BrightonNot applicableMunicipality of BrocktonNot applicableMunicipality of Brooke-AlvinstonNot applicableMunicipality of CallanderNot applicableMunicipality of Central ElginNot applicableMunicipality of Central HuronNot applicableMunicipality of Centre HastingsNot applicableMunicipality of Charlton and DackNot applicableMunicipality of Chatham-KentNot applicableMunicipality of ClaringtonNot applicableMunicipality of Dutton/DunwichNot applicableMunicipality of French RiverNot applicableMunicipality of Gordon / Barrie IslandNot applicableMunicipality of GreenstoneNot applicableMunicipality of Grey HighlandsNot applicableMunicipality of Hastings HighlandsNot applicableMunicipality of Highlands EastNot applicableMunicipality of Huron EastNot applicableMunicipality of Huron ShoresNot applicableMunicipality of KillarneyNot applicableMunicipality of KincardineNot applicableMunicipality of Lambton ShoresNot applicableMunicipality of LeamingtonNot applicableMunicipality of MagnetawanNot applicableMunicipality of Markstay-WarrenNot applicableMunicipality of Marmora and LakeNot applicableMunicipality of McDougallNot applicableMunicipality of MeafordNot applicableMunicipality of Middlesex CentreNot applicableMunicipality of Morris-TurnberryNot applicableMunicipality of NeebingNot applicableMunicipality of North GrenvilleNot applicableMunicipality of North MiddlesexNot applicableMunicipality of North PerthNot applicableMunicipality of Northern Bruce PeninsulaNot applicableMunicipality of Oliver PaipoongeNot applicableMunicipality of Port HopeNot applicableMunicipality of PowassanNot applicableMunicipality of Red LakeNot applicableMunicipality of ShuniahNot applicableMunicipality of Sioux LookoutNot applicableMunicipality of South BruceNot applicableMunicipality of South DundasNot applicableMunicipality of South HuronNot applicableMunicipality of Southwest MiddlesexNot applicableMunicipality of St.-CharlesNot applicableMunicipality of TemagamiNot applicableMunicipality of Thames CentreNot applicableMunicipality of the NationNot applicableMunicipality of Trent HillsNot applicableMunicipality of Trent LakesNot applicableMunicipality of TweedNot applicableMunicipality of WawaNot applicableMunicipality of West ElginNot applicableMunicipality of West GreyNot applicableMunicipality of West NipissingNot applicableMunicipality of West PerthNot applicableMunicipality of WhitestoneNot applicableMunsee-Delaware Nation 1Not applicableMuskrat Dam LakeNot applicableNaiscoutaing 17aNot applicableNaongashing 31a & 35aNot applicableNeguaguon Lake 25dNot applicableNeskantagaNot applicableNew Credit 40aNot applicableNew Post 69Not applicableNew Post 69aNot applicableNeyaashiinigmiingNot applicableNipissing 10Not applicableNorfolk CountyNot applicableNorth Spirit LakeNot applicableNorthwest Angle 33bNot applicableNorthwest Angle 34c & 37bNot applicableObabikong 35bNot applicableObadjiwan 15eNot applicableOjibway Nation of SaugeenNot applicableOne Man Lake 29Not applicableOneida 41Not applicableOsnaburgh 63aNot applicableOsnaburgh 63bNot applicableParry Island First NationNot applicablePays Plat 51Not applicablePic Mobert Reserve NorthNot applicablePic Mobert Reserve SouthNot applicablePic River 50Not applicablePikangikum 14Not applicablePikwakanaganNot applicablePoint Grondine 3Not applicablePoplar HillNot applicableRainy Lake 17aNot applicableRainy Lake 17bNot applicableRainy Lake 18cNot applicableRainy Lake 26aNot applicableRainy Lake 26bNot applicableRainy Lake 26cNot applicableRankin Location 15dNot applicableRat Portage 38aNot applicableRed Rock 53Not applicableRocky Bay 1Not applicableSabaskong Bay 32cNot applicableSabaskong Bay 35cNot applicableSabaskong Bay 35dNot applicableSabaskong Bay 35fNot applicableSabaskong Bay 35hNot applicableSachigo Lake 1Not applicableSachigo Lake 2Not applicableSachigo Lake 3Not applicableSagamokNot applicableSand Point First Nation ReserveNot applicableSandy Lake 88Not applicableSarnia 45Not applicableSaug-A-Gaw-Sing 1Not applicableSaugeen 29Not applicableSaugeen and Cape Croker Fishing Islands 1Not applicableSaugeen Hunting Grounds 60aNot applicableSeine River 23aNot applicableSeine River 23bNot applicableSerpent River 7Not applicableShawanaga 17Not applicableShawanaga 17bNot applicableSheguiandah 24Not applicableSheshegwaning 20Not applicableShoal Lake 31jNot applicableShoal Lake 34b1Not applicableShoal Lake 34b2Not applicableShoal Lake 37aNot applicableShoal Lake 39Not applicableShoal Lake 39aNot applicableShoal Lake 40Not applicableSix Nations 40Not applicableSturgeon Falls 23Not applicableSucker Creek 23Not applicableSugar Island 37aNot applicableSwan Lake 29Not applicableThe Corporation of the Municipality of East FerrisNot applicableThe Dalles 38cNot applicableThessalon 12Not applicableTown of AjaxNot applicableTown of AmherstburgNot applicableTown of ArnpriorNot applicableTown of AuroraNot applicableTown of AylmerNot applicableTown of BancroftNot applicableTown of Blind RiverNot applicableTown of BracebridgeNot applicableTown of Bradford West GwillimburyNot applicableTown of Bruce MinesNot applicableTown of CaledonNot applicableTown of Carleton PlaceNot applicableTown of CobaltNot applicableTown of CobourgNot applicableTown of CochraneNot applicableTown of CollingwoodNot applicableTown of Deep RiverNot applicableTown of DeserontoNot applicableTown of East GwillimburyNot applicableTown of EnglehartNot applicableTown of ErinNot applicableTown of EspanolaNot applicableTown of EssexNot applicableTown of Fort ErieNot applicableTown of Fort FrancesNot applicableTown of GananoqueNot applicableTown of GeorginaNot applicableTown of GoderichNot applicableTown of Gore BayNot applicableTown of Grand ValleyNot applicableTown of GravenhurstNot applicableTown of Greater NapaneeNot applicableTown of GrimsbyNot applicableTown of Halton HillsNot applicableTown of HanoverNot applicableTown of HawkesburyNot applicableTown of HearstNot applicableTown of HuntsvilleNot applicableTown of IngersollNot applicableTown of InnisfilNot applicableTown of Iroquois FallsNot applicableTown of KapuskasingNot applicableTown of KearneyNot applicableTown of KingsvilleNot applicableTown of Kirkland LakeNot applicableTown of LakeshoreNot applicableTown of LasalleNot applicableTown of LatchfordNot applicableTown of Laurentian HillsNot applicableTown of LincolnNot applicableTown of MarathonNot applicableTown of MattawaNot applicableTown of MidlandNot applicableTown of MiltonNot applicableTown of MintoNot applicableTown of MonoNot applicableTown of MoosoneeNot applicableTown of New TecumsethNot applicableTown of NewmarketNot applicableTown of Niagara-On-The-LakeNot applicableTown of Northeastern Manitoulin and the IslandsNot applicableTown of OakvilleNot applicableTown of OrangevilleNot applicableTown of Parry SoundNot applicableTown of PelhamNot applicableTown of PenetanguisheneNot applicableTown of PerthNot applicableTown of PetawawaNot applicableTown of PetroliaNot applicableTown of Plympton-WyomingNot applicableTown of PrescottNot applicableTown of Rainy RiverNot applicableTown of RenfrewNot applicableTown of Richmond HillNot applicableTown of Saugeen ShoresNot applicableTown of ShelburneNot applicableTown of Smiths FallsNot applicableTown of Smooth Rock FallsNot applicableTown of South Bruce PeninsulaNot applicableTown of SpanishNot applicableTown of St. MarysNot applicableTown of TecumsehNot applicableTown of the Blue MountainsNot applicableTown of ThessalonNot applicableTown of TillsonburgNot applicableTown of Wasaga BeachNot applicableTown of WhitbyNot applicableTown of Whitchurch-StouffvilleNot applicableTownship of Addington HighlandsNot applicableTownship of Adelaide-MetcalfeNot applicableTownship of Adjala-TosorontioNot applicableTownship of Admaston/BromleyNot applicableTownship of AlbertonNot applicableTownship of Alfred and PlantagenetNot applicableTownship of Algonquin HighlandsNot applicableTownship of Alnwick/HaldimandNot applicableTownship of AmaranthNot applicableTownship of ArmourNot applicableTownship of ArmstrongNot applicableTownship of Ashfield-Colborne-WawanoshNot applicableTownship of Asphodel-NorwoodNot applicableTownship of AssiginackNot applicableTownship of AthensNot applicableTownship of AtikokanNot applicableTownship of AugustaNot applicableTownship of BaldwinNot applicableTownship of BeckwithNot applicableTownship of BillingsNot applicableTownship of Black River-MathesonNot applicableTownship of Blandford-BlenheimNot applicableTownship of BonfieldNot applicableTownship of Bonnechere ValleyNot applicableTownship of BrethourNot applicableTownship of BrockNot applicableTownship of Brudenell, Lyndoch and RaglanNot applicableTownship of Burpee and MillsNot applicableTownship of CalvinNot applicableTownship of CarlingNot applicableTownship of Carlow/MayoNot applicableTownship of CaseyNot applicableTownship of Cavan MonaghanNot applicableTownship of Central FrontenacNot applicableTownship of Central ManitoulinNot applicableTownship of Centre WellingtonNot applicableTownship of ChamberlainNot applicableTownship of ChamplainNot applicableTownship of ChapleauNot applicableTownship of ChappleNot applicableTownship of ChatsworthNot applicableTownship of ChisholmNot applicableTownship of ClearviewNot applicableTownship of Cockburn IslandNot applicableTownship of ColemanNot applicableTownship of ConmeeNot applicableTownship of CramaheNot applicableTownship of Dawn-EuphemiaNot applicableTownship of DawsonNot applicableTownship of DorionNot applicableTownship of Douro-DummerNot applicableTownship of Drummond/North ElmsleyNot applicableTownship of DubreuilvilleNot applicableTownship of Ear FallsNot applicableTownship of East GarafraxaNot applicableTownship of East HawkesburyNot applicableTownship of East Zorra-TavistockNot applicableTownship of Edwardsburgh/CardinalNot applicableTownship of Elizabethtown-KitleyNot applicableTownship of EmoNot applicableTownship of EnniskillenNot applicableTownship of EssaNot applicableTownship of EvanturelNot applicableTownship of FaradayNot applicableTownship of Fauquier-StricklandNot applicableTownship of Front of YongeNot applicableTownship of Frontenac IslandsNot applicableTownship of GauthierNot applicableTownship of Georgian BayNot applicableTownship of Georgian BluffsNot applicableTownship of GilliesNot applicableTownship of Greater MadawaskaNot applicableTownship of Guelph/EramosaNot applicableTownship of HamiltonNot applicableTownship of HarleyNot applicableTownship of HarrisNot applicableTownship of Havelock-Belmont-MethuenNot applicableTownship of Head, Clara and MariaNot applicableTownship of HilliardNot applicableTownship of HiltonNot applicableTownship of HornepayneNot applicableTownship of HortonNot applicableTownship of HowickNot applicableTownship of HudsonNot applicableTownship of Huron-KinlossNot applicableTownship of IgnaceNot applicableTownship of JamesNot applicableTownship of JocelynNot applicableTownship of JohnsonNot applicableTownship of JolyNot applicableTownship of KernsNot applicableTownship of Killaloe, Hagarty and RichardsNot applicableTownship of KingNot applicableTownship of La ValleeNot applicableTownship of LairdNot applicableTownship of Lake of BaysNot applicableTownship of Lake of the WoodsNot applicableTownship of Lanark HighlandsNot applicableTownship of Larder LakeNot applicableTownship of Laurentian ValleyNot applicableTownship of Leeds and the Thousand IslandsNot applicableTownship of LimerickNot applicableTownship of LoyalistNot applicableTownship of Lucan BiddulphNot applicableTownship of MacDonald, Meredith and Aberdeen AdditionalNot applicableTownship of MacharNot applicableTownship of MachinNot applicableTownship of Madawaska ValleyNot applicableTownship of MadocNot applicableTownship of MalahideNot applicableTownship of ManitouwadgeNot applicableTownship of MapletonNot applicableTownship of MatachewanNot applicableTownship of MattawanNot applicableTownship of Mattice-Val C?téNot applicableTownship of McGarryNot applicableTownship of McKellarNot applicableTownship of McMurrich/MonteithNot applicableTownship of McNab/BraesideNot applicableTownship of MelancthonNot applicableTownship of Minden HillsNot applicableTownship of MontagueNot applicableTownship of MoonbeamNot applicableTownship of MorleyNot applicableTownship of MulmurNot applicableTownship of Muskoka LakesNot applicableTownship of Nairn and HymanNot applicableTownship of NipigonNot applicableTownship of NipissingNot applicableTownship of North Algona WilberforceNot applicableTownship of North DumfriesNot applicableTownship of North DundasNot applicableTownship of North FrontenacNot applicableTownship of North GlengarryNot applicableTownship of North HuronNot applicableTownship of North KawarthaNot applicableTownship of North StormontNot applicableTownship of NorwichNot applicableTownship of O'ConnorNot applicableTownship of OpasatikaNot applicableTownship of Oro-MedonteNot applicableTownship of Otonabee-South MonaghanNot applicableTownship of Papineau-CameronNot applicableTownship of PeleeNot applicableTownship of PerryNot applicableTownship of Perth EastNot applicableTownship of Perth SouthNot applicableTownship of Pickle LakeNot applicableTownship of Plummer AdditionalNot applicableTownship of PrinceNot applicableTownship of PuslinchNot applicableTownship of RamaraNot applicableTownship of Red RockNot applicableTownship of Rideau LakesNot applicableTownship of RussellNot applicableTownship of RyersonNot applicableTownship of Sables-Spanish RiversNot applicableTownship of SchreiberNot applicableTownship of ScugogNot applicableTownship of SeguinNot applicableTownship of SelwynNot applicableTownship of SevernNot applicableTownship of Sioux Narrows-Nestor FallsNot applicableTownship of South AlgonquinNot applicableTownship of South FrontenacNot applicableTownship of South GlengarryNot applicableTownship of South StormontNot applicableTownship of SouthgateNot applicableTownship of South-West OxfordNot applicableTownship of SouthwoldNot applicableTownship of SpringwaterNot applicableTownship of St. ClairNot applicableTownship of St. JosephNot applicableTownship of Stirling-RawdonNot applicableTownship of Stone MillsNot applicableTownship of Strathroy-CaradocNot applicableTownship of StrongNot applicableTownship of Tarbutt and Tarbutt AdditionalNot applicableTownship of TayNot applicableTownship of Tay ValleyNot applicableTownship of TehkummahNot applicableTownship of Terrace BayNot applicableTownship of the ArchipelagoNot applicableTownship of the North ShoreNot applicableTownship of TinyNot applicableTownship of Tudor and CashelNot applicableTownship of TyendinagaNot applicableTownship of UxbridgeNot applicableTownship of Val Rita-HartyNot applicableTownship of WainfleetNot applicableTownship of WarwickNot applicableTownship of WellesleyNot applicableTownship of Wellington NorthNot applicableTownship of West LincolnNot applicableTownship of White RiverNot applicableTownship of Whitewater RegionNot applicableTownship of WilmotNot applicableTownship of WollastonNot applicableTownship of WoolwichNot applicableTownship of ZorraNot applicableTyendinaga Mohawk TerritoryNot applicableUnited Townships of Dysart, Dudley, Harcourt, Guilford, Harburn, Bruton, Havelock, Eyre and ClydeNot applicableVillage of Burk's FallsNot applicableVillage of CasselmanNot applicableVillage of Hilton BeachNot applicableVillage of Merrickville-WolfordNot applicableVillage of NewburyNot applicableVillage of Oil SpringsNot applicableVillage of Point EdwardNot applicableVillage of South RiverNot applicableVillage of SundridgeNot applicableVillage of ThornloeNot applicableVillage of WestportNot applicableWabaseemoongNot applicableWabauskang 21Not applicableWabigoon Lake 27Not applicableWahnapitei 11Not applicableWahta Mohawk TerritoryNot applicableWalpole Island 46Not applicableWapekeka Reserve 1Not applicableWapekeka Reserve 2Not applicableWawakapewinNot applicableWeagamow Lake 87Not applicableWebequieNot applicableWhitefish Bay 32aNot applicableWhitefish Bay 33aNot applicableWhitefish Bay 34aNot applicableWhitefish IslandNot applicableWhitefish Lake 6Not applicableWhitefish River 4Not applicableWhitesandNot applicableWikwemikong Unceded 26Not applicableWinisk 90Not applicableWunnumin 1Not applicableWunnumin 2Not applicableYellow Girl Bay 32bNot applicableZhiibaahaasing 19Not applicableZhiibaahaasing 19aNot applicableORN_STREET_DIRECTION_LISTList of valid street directions.Column NameColumn TypeMandatoryShort NameDescriptionSTREET_DIRECTIONSVARCHAR2(10)YesSTREET_DIRThe direction of the street.OFFICIAL_LANGUAGEVARCHAR2(3)YesOFF_LANGA code identifying the official language.CPC_DIRECTION_CODEVARCHAR2(2)YesCPC_DIRECTThe short form of the street direction as defined by Canada Post Corporation (CPC).NRN_DIRECTIONNUMBER(3,0)NoNRN_DIRECTDirection assigned to support the National Road Network (NRN).EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.EXPIRY_DATETIMEDATENoEXP_DATEDate/time that the record was expired from use.ORN_STREET_DIRECTION_LIST Permissible ValuesSTREET DIRECTIONOFFICIAL LANGUAGECPC DIRECTION CODENRN DIRECTIONEXPIRYDATETIMEEastENGE5Not applicableEstFREE6Not applicableNord EstFRENE12Not applicableNord OuestFRENO10Not applicableNordFREN2Not applicableNorth EastENGNE11Not applicableNorth WestENGNW9Not applicableNorthENGN1Not applicableOuestFREO8?Not applicableSouth EastENGSE15Not applicableSouth WestENGSW13Not applicableSouthENGS3Not applicableSud EstFRESE16Not applicableSud OuestFRESO14Not applicableSudFRES4Not applicableWestENGW7Not applicableORN_STREET_SIDE_LISTList of valid street sides.Column NameColumn TypeMandatoryShort NameDescriptionSTREET_SIDEVARCHAR2(10)YesST_SIDEThe side of the street for which the addressing applies. The street side is determined by the traversal from the "From Measure" to the "To Measure" of the road element.STREET_SIDE_DESCRVARCHAR2(10)YesST_SIDE_DA description of the street side.NRN_STREETSIDENUMBER(3,0)NoNRN_CODEStreet side assigned to support the National Road Network (NRN).EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.EXPIRY_DATETIMEDATENoEXP_DATEDate/time that the record was expired from use.ORN_STREET_SIDE_LIST Permissible ValuesSTREET SIDESTREET SIDE DESCRNRN STREETSIDEEXPIRY DATETIMEBothBoth Sides3Not applicableLeftLeft Side1Not applicableRightRight Side2Not applicableORN_STREET_TYPE_LISTList of valid street types.Column NameColumn TypeMandatoryShort NameDescriptionSTREET_TYPEVARCHAR2(25)YesSTREET_TYPA description of the street type.STREET_TYPE_SHORT_FORM_ENGLISHVARCHAR2(15)NoST_TYPE_ENA short form of the street type in English.STREET_TYPE_SHORT_FORM_FRENCHVARCHAR2(15)NoST_TYPE_FRA short form of the street type in French.NRN_STREETTYPENUMBER(3,0)NoNRN_STREETStreet type assigned to support the National Road Network (NRN).EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.EXPIRY_DATETIMEDATENoEXP_DATEDate/time that the record was expired from use.ORN_STREET_TYPE_LIST Permissible ValuesSTREET TYPESTREET TYPE SHORT FORM ENGLISHSTREET TYPE SHORT FORM FRENCHNRN STREETTYPEEXPIRY DATETIMEAbbeyABBEYNot applicableNot applicableNot applicableAccessACCESSNot applicableNot applicableNot applicableAcresACRESNot applicableNot applicableNot applicableAireAIRENot applicableNot applicableNot applicableAlleyALLEYNot applicableNot applicableNot applicableAlléeNot applicableALL?ENot applicableNot applicableArmARMNot applicableNot applicableNot applicableAutorouteAUTNot applicableNot applicableNot applicableAvenueAVEAVNot applicableNot applicableBankBKNot applicableNot applicableNot applicableBarrageNot applicableBRGENot applicableNot applicableBaselineBASELINENot applicableNot applicableNot applicableBayBAYNot applicableNot applicableNot applicableBeachBEACHNot applicableNot applicableNot applicableBendBENDNot applicableNot applicableNot applicableBlocBLOCNot applicableNot applicableNot applicableBlockBLOCKNot applicableNot applicableNot applicableBluffBLUFFNot applicableNot applicableNot applicableBottomBTMNot applicableNot applicableNot applicableBoulevardBLVDBOULNot applicableNot applicableBourgNot applicableBOURGNot applicableNot applicableBourneBRNENot applicableNot applicableNot applicableBranchBRANCHNot applicableNot applicableNot applicableBridgeBRIDGENot applicableNot applicableNot applicableBrookBROOKNot applicableNot applicableNot applicableBurnBURNNot applicableNot applicableNot applicableBushBUSHNot applicableNot applicableNot applicableBypassBYPASSNot applicableNot applicableNot applicableByroadBYROADNot applicableNot applicableNot applicableBywayBYWAYNot applicableNot applicableNot applicableCampCAMPNot applicableNot applicableNot applicableCampusCAMPUSNot applicableNot applicableNot applicableCapeCAPENot applicableNot applicableNot applicableCarrefourNot applicableCARREFNot applicableNot applicableCarréNot applicableCARNot applicableNot applicableCausewayCSWYNot applicableNot applicableNot applicableCentreCTRCNot applicableNot applicableCercleNot applicableCERCLENot applicableNot applicableChartCHARTNot applicableNot applicableNot applicableChaseCHASENot applicableNot applicableNot applicableCheminNot applicableCHNot applicableNot applicableCircleCIRNot applicableNot applicableNot applicableCircuitCIRCTNot applicableNot applicableNot applicableCliffsCLFSNot applicableNot applicableNot applicableCloseCLOSENot applicableNot applicableNot applicableClubCLUBNot applicableNot applicableNot applicableCommonCOMMONNot applicableNot applicableNot applicableConcession RoadCON RDNot applicableNot applicableNot applicableConcessionCONCNot applicableNot applicableNot applicableCopseCOPSENot applicableNot applicableNot applicableCornerCORNot applicableNot applicableNot applicableCornersCRNRSNot applicableNot applicableNot applicableCounty RoadCOUNTY RDNot applicableNot applicableNot applicableCourNot applicableCOURNot applicableNot applicableCourseCRSENot applicableNot applicableNot applicableCourtCRTNot applicableNot applicableNot applicableCourtsCTSNot applicableNot applicableNot applicableCoveCOVENot applicableNot applicableNot applicableCreekCKNot applicableNot applicableNot applicableCrescentCRESNot applicableNot applicableNot applicableCrestCRESTNot applicableNot applicableNot applicableCroftCROFTNot applicableNot applicableNot applicableCroissantNot applicableCROISNot applicableNot applicableCrossCXNot applicableNot applicableNot applicableCrossingCROSSNot applicableNot applicableNot applicableCrossroadCROSRDNot applicableNot applicableNot applicableCrossroadsCRSSRDNot applicableNot applicableNot applicableCul De SacCDSNot applicableNot applicableNot applicableCurveCURVENot applicableNot applicableNot applicableCutCUTNot applicableNot applicableNot applicableC?teNot applicableC?TENot applicableNot applicableDaleDALENot applicableNot applicableNot applicableDellDELLNot applicableNot applicableNot applicableDesserteNot applicableDESSTENot applicableNot applicableDevelopmentDEVELPNot applicableNot applicableNot applicableDiversionDIVERSNot applicableNot applicableNot applicableDownsDOWNSNot applicableNot applicableNot applicableDriveDRNot applicableNot applicableNot applicableDrivewayDRWYNot applicableNot applicableNot applicableDroit De PassageNot applicableDRPASSNot applicableNot applicableEasementEASEMTNot applicableNot applicableNot applicableEndENDNot applicableNot applicableNot applicableEsplanadeESPLNot applicableNot applicableNot applicableEstatesESTATENot applicableNot applicableNot applicableExpresswayEXPYNot applicableNot applicableNot applicableExtensionEXTENNot applicableNot applicableNot applicableFairwayFAWYNot applicableNot applicableNot applicableFarmFARMNot applicableNot applicableNot applicableFieldFIELDNot applicableNot applicableNot applicableFieldsFIELDSNot applicableNot applicableNot applicableFire RouteFRNot applicableNot applicableNot applicableForestFORESTNot applicableNot applicableNot applicableFreewayFWYNot applicableNot applicableNot applicableFrontFRONTNot applicableNot applicableNot applicableGardenGNNot applicableNot applicableNot applicableGardensGDNSNot applicableNot applicableNot applicableGateGATENot applicableNot applicableNot applicableGatewayGTWYNot applicableNot applicableNot applicableGladeGLADENot applicableNot applicableNot applicableGlenGLENNot applicableNot applicableNot applicableGreenGREENNot applicableNot applicableNot applicableGreenwayGREENWAYNot applicableNot applicableNot applicableGroundsGRNDSNot applicableNot applicableNot applicableGroveGROVENot applicableNot applicableNot applicableHarbourHARBRNot applicableNot applicableNot applicableHavenHAVENNot applicableNot applicableNot applicableHeathHEATHNot applicableNot applicableNot applicableHeightHTNot applicableNot applicableNot applicableHeightsHTSNot applicableNot applicableNot applicableHighlandsHGHLDSNot applicableNot applicableNot applicableHighwayHWYNot applicableNot applicableNot applicableHillHILLNot applicableNot applicableNot applicableHillsHSNot applicableNot applicableNot applicableHollowHOLLOWNot applicableNot applicableNot applicableImpasseNot applicableIMPNot applicableNot applicableInamoINAMONot applicableNot applicableNot applicableInletINLETNot applicableNot applicableNot applicableIntersectionINTERSNNot applicableNot applicableNot applicableIslandISLANDNot applicableNot applicableNot applicableIslandsISSNot applicableNot applicableNot applicableIsleISLENot applicableNot applicableNot applicableJardinNot applicableJARDINNot applicableNot applicableJunctionJNCNot applicableNot applicableNot applicableKeepKEEPNot applicableNot applicableNot applicableKeyKEYNot applicableNot applicableNot applicableKnollKNOLLNot applicableNot applicableNot applicableLakeLKNot applicableNot applicableNot applicableLakesLKSNot applicableNot applicableNot applicableLakewayLKWYNot applicableNot applicableNot applicableLandLANDNot applicableNot applicableNot applicableLandingLANDNGNot applicableNot applicableNot applicableLaneLANENot applicableNot applicableNot applicableLanesLANESNot applicableNot applicableNot applicableLanewayLANEWYNot applicableNot applicableNot applicableLawnLAWNNot applicableNot applicableNot applicableLimitsLMTSNot applicableNot applicableNot applicableLineLINENot applicableNot applicableNot applicableLinkLINKNot applicableNot applicableNot applicableLockLOCKNot applicableNot applicableNot applicableLocksLOCKSNot applicableNot applicableNot applicableLookoutLKOUTNot applicableNot applicableNot applicableLoopLOOPNot applicableNot applicableNot applicableMallMALLNot applicableNot applicableNot applicableManorMANORNot applicableNot applicableNot applicableMarketMKTNot applicableNot applicableNot applicableMazeMAZENot applicableNot applicableNot applicableMeadowMEADOWNot applicableNot applicableNot applicableMewsMEWSNot applicableNot applicableNot applicableMillwayMILLWAYNot applicableNot applicableNot applicableMontéeNot applicableMONT?ENot applicableNot applicableMoorMOORNot applicableNot applicableNot applicableMountMOUNTNot applicableNot applicableNot applicableMountainMTNNot applicableNot applicableNot applicableOrchardORCHNot applicableNot applicableNot applicableOutlookOUTLOOKNot applicableNot applicableNot applicableOvalOVALNot applicableNot applicableNot applicableOverpassOVERPASSNot applicableNot applicableNot applicableParadePARADENot applicableNot applicableNot applicableParcPARCNot applicableNot applicableNot applicableParkPKNot applicableNot applicableNot applicableParkwayPKYNot applicableNot applicableNot applicablePassPSNot applicableNot applicableNot applicablePassagePASSNot applicableNot applicableNot applicablePathPATHNot applicableNot applicableNot applicablePathwayPTWAYNot applicableNot applicableNot applicablePeakPEAKNot applicableNot applicableNot applicablePierPIERNot applicableNot applicableNot applicablePikePIKENot applicableNot applicableNot applicablePinesPINESNot applicableNot applicableNot applicablePlacePLPLACENot applicableNot applicablePlateauPLATNot applicableNot applicableNot applicablePlazaPLAZANot applicableNot applicableNot applicablePointPTNot applicableNot applicableNot applicablePointeNot applicablePOINTENot applicableNot applicablePoolPOOLNot applicableNot applicableNot applicablePortPORTNot applicableNot applicableNot applicablePrivatePVTNot applicableNot applicableNot applicablePromenadePROMNot applicableNot applicableNot applicableQuaiNot applicableQUAINot applicableNot applicableQuayQUAYNot applicableNot applicableNot applicableRampRAMPNot applicableNot applicableNot applicableRangNot applicableRANGNot applicableNot applicableRangeRGNot applicableNot applicableNot applicableReachREACHNot applicableNot applicableNot applicableRegional RoadREG RDNot applicableNot applicableNot applicableRidgeRIDGENot applicableNot applicableNot applicableRight Of WayRTOFWYNot applicableNot applicableNot applicableRiseRISENot applicableNot applicableNot applicableRiverRIVERNot applicableNot applicableNot applicableRoadRDNot applicableNot applicableNot applicableRoadwayRDWYNot applicableNot applicableNot applicableRond PointRDPTNot applicableNot applicableNot applicableRoundaboutRBTNot applicableNot applicableNot applicableRouteROUTERTENot applicableNot applicableRowROWNot applicableNot applicableNot applicableRueNot applicableRUENot applicableNot applicableRuelleNot applicableRUELLENot applicableNot applicableRuisseauNot applicableRUISNot applicableNot applicableRunRUNNot applicableNot applicableNot applicableSectionSECTNNot applicableNot applicableNot applicableSentierNot applicableSENTNot applicableNot applicableServiceSERVNot applicableNot applicableNot applicableShoalSHOALNot applicableNot applicableNot applicableShoreSHORENot applicableNot applicableNot applicableShoresSHORESNot applicableNot applicableNot applicableSideSIDENot applicableNot applicableNot applicableSidelineSLINENot applicableNot applicableNot applicableSideroadSIDERDNot applicableNot applicableNot applicableSkywaySKYWYNot applicableNot applicableNot applicableSpurSPURNot applicableNot applicableNot applicableSquareSQNot applicableNot applicableNot applicableStreetSTNot applicableNot applicableNot applicableStripSTRIPNot applicableNot applicableNot applicableStrollSTROLLNot applicableNot applicableNot applicableSubdivisionSUBDIVNot applicableNot applicableNot applicableSummitSUMNot applicableNot applicableNot applicableSurfSURFNot applicableNot applicableNot applicableTerraceTERRNot applicableNot applicableNot applicableTerrasseNot applicableTSSENot applicableNot applicableThicketTHICKNot applicableNot applicableNot applicableTowersTOWERSNot applicableNot applicableNot applicableTownlineTLINENot applicableNot applicableNot applicableTraceTRACENot applicableNot applicableNot applicableTrackTRACKNot applicableNot applicableNot applicableTrafficwayTRAFFICWAYNot applicableNot applicableNot applicableTrailTRAILNot applicableNot applicableNot applicableTrunkTRUNKNot applicableNot applicableNot applicableTunnelTUNNot applicableNot applicableNot applicableTurnaboutTRNABTNot applicableNot applicableNot applicableTurnpikeTPIKENot applicableNot applicableNot applicableValeVALENot applicableNot applicableNot applicableValleyVALLEYNot applicableNot applicableNot applicableViaVIANot applicableNot applicableNot applicableViewVIEWNot applicableNot applicableNot applicableVillageVILLGENot applicableNot applicableNot applicableVillasVILLASNot applicableNot applicableNot applicableVistaVISTANot applicableNot applicableNot applicableVoieNot applicableVOIENot applicableNot applicableWalkWALKNot applicableNot applicableNot applicableWalkwayWALKWAYNot applicableNot applicableNot applicableWaterwayWATERWAYNot applicableNot applicableNot applicableWayWAYNot applicableNot applicableNot applicableWharfWHARFNot applicableNot applicableNot applicableWoldWOLDNot applicableNot applicableNot applicableWoodWOODNot applicableNot applicableNot applicableWoodsWOODSNot applicableNot applicableNot applicableWyndWYNDNot applicableNot applicableNot applicable?changeurNot applicable?CHNot applicableNot applicable?leNot applicable?LENot applicableNot applicableORN_STRUCTURE_TYPE_LISTList of valid structure types.Column NameColumn TypeMandatoryShort NameDescriptionSTRUCTURE_TYPEVARCHAR2(30)YesSTRUCT_TThe classification of a structure, that exists on a road element and is managed as a linear event.STRUCTURE_TYPE_DESCRVARCHAR2(250)YesSTRUCT_T_DA description of the structure type.NRN_STRUCTURETYPENUMBER(3,0)NoNRN_CODEStructure type assigned to support the National Road Network (NRN).EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.EXPIRY_DATETIMEDATENoEXP_DATEDate/time that the record was expired from use.ORN_STRUCTURE_TYPE_LIST Permissible ValuesSTRUCTURE TYPESTRUCTURE TYPE DESCRNRN STRUCTURE TYPEEXPIRY DATETIMEBridge CoveredPart of a road supporting the travel of motorized vehicles, built on a raised, covered structure and serving to span an obstacle, river, another road or railway, etc.2Not applicableBridge MoveablePart of a road supporting the travel of motorized vehicles, built on a moveable, raised structure and serving to span an obstacle, river, another road or railway, etc. The moveable surface allows for the passage of vessels.3Not applicableBridgePart of a road supporting the travel of motorized vehicles, built on a raised structure and serving to span an obstacle, river, another road or railway, etc., yet does not have a moveable surface or a building-like cover.1Not applicableDamPart of a road supporting the travel of motorized vehicles, built across a waterway or floodway to control the flow of water.7Not applicableTunnel? An enclosed man-made construction built to carry a transportation element through or below a natural feature or other obstruction.? 5Not applicableORN_SURFACE_TYPE_LISTList of valid surface types.Column NameColumn TypeMandatoryShort NameDescriptionSURFACE_TYPEVARCHAR2(10)YesSURFACE_TA linear event indicating the surface type of a road element.SURFACE_TYPE_DESCRVARCHAR2(200)YesSURFACE_DA description of the structure type.EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.EXPIRY_DATETIMEDATENoEXP_DATEDate/time that the record was expired from use.ORN_SURFACE_TYPE_LIST Permissible ValuesSURFACE TYPESURFACE TYPE DESCREXPIRY DATETIMEBlocksA paved road element with a surface made of blocks such as cobblestones or interlocking paversNot applicableDirtAn unpaved road element, which the surface is formed by the removal of vegetation and/or by transportation movements over the road, which inhibit further growth of any vegetationNot applicableFlexibleA paved road element with a flexible surface such as asphalt or tar gravelNot applicableGravelAn unpaved road element, which the surface has been improved by grading with gravelNot applicableRigidA paved road element with a rigid surface such as concreteNot applicableORN_TOLL_POINT_TYPE_LISTList of valid toll point types.Column NameColumn TypeMandatoryShort NameDescriptionTOLL_POINT_TYPEVARCHAR2(10)YesTOLL_PT_TA point event indicating the type of a toll point that may exist along a road element.TOLL_POINT_TYPE_DESCRVARCHAR2(250)YesTOLL_PT_DA description of the toll point type.NRN_TOLLPOINTTYPENUMBER(3,0)NoNRN_CODEToll point type assigned to support the National Road Network (NRN).EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.EXPIRY_DATETIMEDATENoEXP_DATEDate/time that the record was expired from use.ORN_TOLL_POINT_TYPE_LIST Permissible ValuesTOLL POINT TYPETOLL POINT TYPE DESCRNRN TOLL POINT TYPEEXPIRYDATETIMEHybridA tollbooth along a road element, which is both physical and virtual.3Not applicablePhysicalA construction along or across a road element, where toll can be paid to employees of the organization in charge of collecting the toll or to machines involving electronic methods of payment like credit cards or bank cards.1Not applicableVirtualAt a virtual point along a road element, toll will be charged via automatic registration of the passing vehicle by subscription or invoice.2Not applicableORN_UNDERPASS_LISTList of valid underpass types.Column NameColumn TypeMandatoryShort NameDescriptionUNDERPASS_TYPEVARCHAR2(25)YesTYPEIdentifies the type of underpass.UNDERPASS_DESCRVARCHAR2(2000)NoDESCRA description of the underpass type.EFFECTIVE_DATETIMEDATEYesEFF_DATEDate/time the record was created or last modified in the source database.EXPIRY_DATETIMEDATENoEXP_DATEDate/time that the record was expired from use.ORN_UNDERPASS_LIST Permissible ValuesUNDERPASS TYPEUNDERPASS DESCREXPIRY DATETIMEBuildingA point at the intersection of a building and the road element passing underneath.Not applicableIndustrialA point at the intersection of an industrial structure e.g. utilities, and the road element passing underneath.Not applicableRailA point at the intersection of a rail structure and the road element passing underneath.Not applicableRoadA point at the intersection of a road e.g. a bridge structure, and the road element passing underneath.Not applicableWalkwayA point at the intersection of a walkway, e.g. multi-use pathway, skywalk, trail, or bike path, and the road element passing underneath.Not applicableWaterA point at the intersection of a water feature and the road element passing underneath, e.g. a tunnel.Not applicableWildlifeA point at the intersection of a wildlife corridor and the road element passing underneath.Not applicableAPPENDIX B: Table Key Dependency and Relationship IndexKeys are used to link or make relationships between tables through one or more columns. A Parent Table is the source of unique key columns used by a Child Table. The main key types are described below.Primary Key (PK):A Primary Key (PK) is a column that uniquely identifies each record in a table. There can be more than one PK defined for a table when additional rules for record uniqueness are needed. Primary Keys cannot contain null values.Figure 2: Primary Key exampleForeign Key (FK):When a Primary Key from a Parent Table appears as a column in the Child Table it is referred to as a Foreign Key (FK). The FK may retain the same name of the Parent Table column, or it may be renamed.Figure 3: Foreign Key exampleAlternate Key (AK):Alternate Keys (AK) are secondary unique identifiers in a Parent Table. A Child Table can link to a Parent Table AK and use it as a Foreign Key (FK). The FK may retain the same name of the Parent Table column, or it may be renamed. Alternate Keys allow null values.Figure 4: Alternate Key exampleThere are two relationship type options, identifying and non-identifying, which are described below. An Identifying Relationship occurs when a column from the Parent Table is added to the key section of the Child Table. Though technically a Foreign Key (FK) in the child table, it now forms part of the Primary Key (PK). Identifying Relationships are symbolized with a solid line.Figure 5: Example of an Identifying RelationshipA Non-identifying Relationship occurs when a column from the Parent Table is added to the main body of the Child Table where it is treated as a Foreign Key (FK). Non-identifying Relationships are symbolized with a dashed line.Figure 6: Example of a Non-identifying RelationshipThe relationships between tables are set up with cardinality rules describing if the feature record in the Parent Table can relate to zero, one or more records in the associated Child Table and vice versa. These rules are symbolized in the model diagram as follows.Figure 7: Model Diagram Relationship Symbology TableThe following section is an index of parent table primary keys identifying, where applicable, associated child table dependencies that have been implemented for the ORN Road Net Element data class.Main Business Area TablesIndex of main business area table primary and associated foreign keys.Note: Relationship type reference is either Identifying (I) or Non-Identifying (NI).Parent Table: ORN_ROAD_NET_ELEMENT_FTPrimary Key(s): OGF_IDData Type: NUMBER (13)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_ADDRESS_INFOORN_ROAD_NET_ELEMENT_IDNIOptional: 1 to manyMandatory: 1 to1ORN_ALTERNATE_STREET_NAMEORN_ROAD_NET_ELEMENT_IDNIOptional: 1 to manyMandatory: 1 to1ORN_BLOCKED_PASSAGEORN_ROAD_NET_ELEMENT_IDNIOptional: 1 to manyMandatory: 1 to1ORN_JURISDICTIONORN_ROAD_NET_ELEMENT_IDNIOptional: 1 to manyMandatory: 1 to1ORN_NET_ELEMENT_SOURCEORN_ROAD_NET_ELEMENT_IDNIOptional: 1 to manyMandatory: 1 to1ORN_NUMBER_OF_LANESORN_ROAD_NET_ELEMENT_IDNIOptional: 1 to manyMandatory: 1 to1ORN_OFFICIAL_STREET_NAMEORN_ROAD_NET_ELEMENT_IDNIOptional: 1 to manyMandatory: 1 to1ORN_ROAD_CLASSORN_ROAD_NET_ELEMENT_IDNIOptional: 1 to manyMandatory: 1 to1ORN_ROAD_SURFACEORN_ROAD_NET_ELEMENT_IDNIOptional: 1 to manyMandatory: 1 to1ORN_ROUTE_NAMEORN_ROAD_NET_ELEMENT_IDNIOptional: 1 to manyMandatory: 1 to1ORN_ROUTE_NUMBERORN_ROAD_NET_ELEMENT_IDNIOptional: 1 to manyMandatory: 1 to1ORN_SPEED_LIMITORN_ROAD_NET_ELEMENT_IDNIOptional: 1 to manyMandatory: 1 to1ORN_STRUCTUREORN_ROAD_NET_ELEMENT_IDNIOptional: 1 to manyMandatory: 1 to1ORN_TOLL_POINTORN_ROAD_NET_ELEMENT_IDNIOptional: 1 to manyMandatory: 1 to1Parent Table: ORN_ADDRESS_INFOPrimary Key(s): EVENT_IDData Type: NUMBER (13)ELEMENT_ORDER_NUMBERData Type: NUMBER (5)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipNot applicable (N/A)N/AN/AN/AN/AParent Table: ORN_ALTERNATE_STREET_NAMEPrimary Key(s): EVENT_IDData Type: NUMBER (13)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipNot applicable (N/A)N/AN/AN/AN/AParent Table: ORN_BLOCKED_PASSAGEPrimary Key(s): EVENT_IDData Type: NUMBER (13)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipNot applicable (N/A)N/AN/AN/AN/AParent Table: ORN_JUNCTIONPrimary Key(s): JUNCTION_IDData Type: NUMBER (13)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_ROAD_NET_ELEMENT_FTFROM_JUNCTION_IDNIOptional: 1 to manyMandatory: 1 to1ORN_ROAD_NET_ELEMENT_FTTO_JUNCTION_IDNIOptional: 1 to manyMandatory: 1 to1Parent Table: ORN_JURISDICTIONPrimary Key(s): EVENT_IDData Type: NUMBER (13)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipNot applicable (N/A)N/AN/AN/AN/AParent Table: ORN_NUMBER_OF_LANESPrimary Key(s): EVENT_IDData Type: NUMBER (13)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipNot applicable (N/A)N/AN/AN/AN/AParent Table: ORN_OFFICIAL_STREET_NAMEPrimary Key(s): EVENT_IDData Type: NUMBER (13)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipNot applicable (N/A)N/AN/AN/AN/AParent Table: ORN_ROAD_CLASSPrimary Key(s): EVENT_IDData Type: NUMBER (13)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipNot applicable (N/A)N/AN/AN/AN/AParent Table: ORN_ROAD_NET_ELEMENT_SOURCEPrimary Key(s): EVENT_IDData Type: NUMBER (13)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipNot applicable (N/A)N/AN/AN/AN/AParent Table: ORN_ROAD_SURFACEPrimary Key(s): EVENT_IDData Type: NUMBER (13)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipNot applicable (N/A)N/AN/AN/AN/AParent Table: ORN_ROUTE_NAMEPrimary Key(s): EVENT_IDData Type: NUMBER (13)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipNot applicable (N/A)N/AN/AN/AN/AParent Table: ORN_ROUTE_NUMBERPrimary Key(s): EVENT_IDData Type: NUMBER (13)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipNot applicable (N/A)N/AN/AN/AN/AParent Table: ORN_SPEED_LIMITPrimary Key(s): EVENT_IDData Type: NUMBER (13)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipNot applicable (N/A)N/AN/AN/AN/AParent Table: ORN_STREET_NAME_PARSEDPrimary Key(s): FULL_STREET_NAMEData Type: VARCHAR2 (100)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_ADDRESS_INFOFULL_SREET_NAMENIOptional: 1 to manyMandatory: 1 to1ORN_ALTERNATE_STREET_NAMEFULL_SREET_NAMENIOptional: 1 to manyMandatory: 1 to1ORN_OFFICIAL_STREET_NAMEFULL_SREET_NAMENIOptional: 1 to manyMandatory: 1 to1Parent Table: ORN_STRUCTUREPrimary Key(s): EVENT_IDData Type: NUMBER (13)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipNot applicable (N/A)N/AN/AN/AN/AParent Table: ORN_TOLL_POINTPrimary Key(s): EVENT_IDData Type: NUMBER (13)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipNot applicable (N/A)N/AN/AN/AN/AParent Table: ORN_UNDERPASSPrimary Key(s): EVENT_IDData Type: NUMBER (13)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipNot applicable (N/A)N/AN/AN/AN/ALookup Table IndexesWhere a lookup table primary key (PK) is used as a foreign key (FK) in other main business area tables in order to control permissible values.Note: Relationship type reference is either Identifying (I) or Non-Identifying (NI).Parent Table: ORN_ACQUISITION_TECHNIQUE_LISTPrimary Key(s): ACQUISITION_TECHNIQUEData Type: VARCHAR2 (25)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_ROAD_NET_ELEMENT_FTACQUISITION_TECHNIQUENIOptional: 1 to manyMandatory: 1 to1Parent Table: ORN_AGENCY_NAME_LISTPrimary Key(s): AGENCY_NAMEData Type: VARCHAR2 (100)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_STRUCTUREAGENCY_NAMENIOptional: 1 to manyOptional: 1 to1ORN_ROAD_CLASSAGENCY_NAMENIOptional: 1 to manyOptional: 1 to1ORN_TOLL_POINTAGENCY_NAMENIOptional: 1 to manyOptional: 1 to1ORN_BLOCKED_PASSAGEAGENCY_NAMENIOptional: 1 to manyOptional: 1 to1ORN_NUMBER_OF_LANESAGENCY_NAMENIOptional: 1 to manyOptional: 1 to1ORN_ROAD_SURFACEAGENCY_NAMENIOptional: 1 to manyOptional: 1 to1ORN_ROUTE_NAMEAGENCY_NAMENIOptional: 1 to manyOptional: 1 to1ORN_OFFICIAL_STREET_NAMEAGENCY_NAMENIOptional: 1 to manyOptional: 1 to1ORN_ALTERNATE_STREET_NAMEAGENCY_NAMENIOptional: 1 to manyOptional: 1 to1ORN_ROUTE_NUMBERAGENCY_NAMENIOptional: 1 to manyOptional: 1 to1ORN_ROAD_NET_ELEMENT_SOURCEAGENCY_NAMENIOptional: 1 to manyOptional: 1 to1ORN_SPEED_LIMITAGENCY_NAMENIOptional: 1 to manyOptional: 1 to1ORN_JURISDICTIONAGENCY_NAMENIOptional: 1 to manyOptional: 1 to1ORN_ADDRESS_INFOAGENCY_NAMENIOptional: 1 to manyOptional: 1 to1Parent Table: ORN_AGENCY_TYPE_LISTPrimary Key(s): AGENCY_TYPEData Type: VARCHAR2 (10)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_AGENCY_NAME_LISTAGENCY_TYPENIOptional: 1 to manyMandatory: 1 to1Parent Table: ORN_BLOCKED_PASSAGE_TYPE_LISTPrimary Key(s): BLOCKED_PASSAGE_TYPEData Type: VARCHAR2 (10)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_BLOCKED_PASSAGEBLOCKED_PASSAGE_TYPENIOptional: 1 to manyMandatory: 1 to1Parent Table: ORN_DIR_OF_TRAFFIC_FLOW_LISTPrimary Key(s): DIRECTION_OF_TRAFFIC_FLOWData Type: VARCHAR2 (8)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_ROAD_NET_ELEMENT_FTDIRECTION_OF_TRAFFIC_FLOWNIOptional: 1 to manyMandatory: 1 to1Parent Table: ORN_HOUSE_NUM_STRUCTURE_LISTPrimary Key(s): HOUSE_NUMBER_STRUCTUREData Type: VARCHAR2 (10)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_ADDRESS_INFOHOUSE_NUMBER_STRUCTURENIOptional: 1 to manyOptional: 1 to1Parent Table: ORN_JUNCTION_TYPE_LISTPrimary Key(s): JUNCTION_TYPEData Type: VARCHAR2 (80)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_JUNCTIONJUNCTION_TYPENIOptional: 1 to manyMandatory: 1 to1Parent Table: ORN_JURISDICTION_LISTPrimary Key(s): JURISDICTIONData Type: VARCHAR2 (80)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_JURISDICTIONJURISDICTIONNIOptional: 1 to manyMandatory: 1 to1Parent Table: ORN_OFFICIAL_LANGUAGE_LISTPrimary Key(s): OFFICIAL_LANGUAGEData Type: VARCHAR2 (3)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_STREET_NAME_PARSEDOFFICIAL_LANGUAGENIOptional: 1 to manyMandatory: 1 to1Parent Table: ORN_PAVEMENT_STATUS_LISTPrimary Key(s): PAVEMENT_STATUSData Type: VARCHAR2 (10)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_ROAD_SURFACEPAVEMENT_STATUSNIOptional: 1 to manyMandatory: 1 to1Parent Table: ORN_ROAD_CLASS_LISTPrimary Key(s): ROAD_CLASSData Type: VARCHAR2 (25)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_ROAD_CLASSROAD_CLASSNIOptional: 1 to manyMandatory: 1 to1Parent Table: ORN_ROAD_ELEMENT_TYPE_LISTPrimary Key(s): ROAD_ELEMENT_TYPEData Type: VARCHAR2 (20)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_ROAD_NET_ELEMENT_FTROAD_ELEMENT_TYPENIOptional: 1 to manyMandatory: 1 to1Parent Table: ORN_SHIELD_TYPE_LISTPrimary Key(s): SHIELD_TYPEData Type: VARCHAR2 (60)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_ROUTE_NUMBERSHIELD_TYPENIOptional: 1 to manyOptional: 1 to1Parent Table: ORN_STANDARD_MUNICIPALITY_LISTPrimary Key(s): STANDARD_MUNICIPALITYData Type: VARCHAR2 (100)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_ADDRESS_INFOSTANDARD_MUNICIPALITYNIOptional: 1 to manyMandatory: 1 to1Parent Table: ORN_STREET_DIRECTION_LISTPrimary Key(s): STREET_DIRECTIONData Type: VARCHAR2 (10)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_STREET_NAME_PARSEDDIRECTIONAL_PREFIXNIOptional: 1 to manyOptional: 1 to1ORN_STREET_NAME_PARSEDDIRECTIONAL_SUFFIXNIOptional: 1 to manyOptional: 1 to1Parent Table: ORN_STREET_SIDE_LISTPrimary Key(s): STREET_SIDEData Type: VARCHAR2 (10)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_ADDRESS_INFOSTREET_SIDENIOptional: 1 to manyOptional: 1 to1ORN_JURISDICTIONSTREET_SIDENIOptional: 1 to manyMandatory: 1 to1Parent Table: ORN_STREET_TYPE_LISTPrimary Key(s): STREET_TYPEData Type: VARCHAR2 (25)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_STREET_NAME_PARSEDSTREET_TYPE_PREFIXNIOptional: 1 to manyOptional: 1 to1ORN_STREET_NAME_PARSEDSTREET_TYPE_SUFFIXNIOptional: 1 to manyOptional: 1 to1Parent Table: ORN_STRUCTURE_LISTPrimary Key(s): STRUCTURE_TYPEData Type: VARCHAR2 (30)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_STRUCTURESTRUCTURE_TYPENIOptional: 1 to manyMandatory: 1 to1Parent Table: ORN_SURFACE_TYPE_LISTPrimary Key(s): SURFACE_TYPEData Type: VARCHAR2 (10)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_ROAD_SURFACESURFACE_TYPENIOptional: 1 to manyOptional: 1 to1Parent Table: ORN_TOLL_POINT_TYPE_LISTPrimary Key(s): TOLL_POINT_TYPEData Type: VARCHAR2 (10)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_TOLL_POINTTOLL_POINT_TYPENIOptional: 1 to manyMandatory: 1 to1Parent Table: ORN_UNDERPASS_LISTPrimary Key(s): UNDERPASS_TYPEData Type: VARCHAR2 (25)Child TableMigrated Foreign KeyRel. TypeParent to Child RelationshipChild to Parent RelationshipORN_UNDERPASSUNDERPASS_TYPENIOptional: 1 to manyMandatory: 1 to1APPENDIX C: Frequently Asked QuestionsWhat is the difference between ORN Road Net Element (ORNELEM) and ORN Segment with Address (ORNSEGAD)?ORNELEM is a LRS data class that locates point and line events along a linear segment at distance measures. ORNSEGAD is a segmented data class derived from the ORN Road Net Element and includes fewer attributes.Attribute tables included in ORNELEM:ORN_ROAD_NET_ELEMENT_FTADDRESS_INFOALTERNATE_STREET_NAMEBLOCKED PASSAGEJUNCTIONJURISDICTIONNUMBER_OF_LANESOFFICIAL_STREET_NAMEROAD_CLASSROAD_NET_ELEMENT_SOURCEROUTE_NAMEROUTE_NUMBERSPEED_LIMITSTREET_NAME_PARSEDSTRUCTURETOLL_POINTUNDERPASSAttributes included in ORNSEGAD:ADDRESS_INFO (in separate fields)ALTERNATE_STREET_NAMEDIRECTION_OF_TRAFFIC_FLOW (found in ORNELEM in ORN_ROAD_NET_ELEMENT_FT)OFFICIAL_STREET_NAMEROAD_CLASSROAD_NET_ELEMENT_TYPE (found in ORNELEM in ORN_ROAD_NET_ELEMENT_FT)ROUTE_NAMEROUTE NUMBERSTREET_NAME_PARSED (in separate fields)For more information please visit the LIO metadata records for ORN Road Net Element () and ORN Segment with Address ().What is a Linear Reference System (LRS)?A Linear Reference System (LRS) allows attributes to be assigned to specific positions (distance measures) along a linear segment. Attributes are stored in separate tables and linked to the geometry through a unique ID.For additional information on Linear Referencing visit ESRI’s ArcGIS Resources: What is linear referencing? ()Where are the attribute tables for the ORN_ROAD_NET_ELEMENT data class?If downloading data through the LIO Metadata Management Tool (), the attribute tables are provided.Figure 8: Attribute tables included through LIO Metadata Management ToolOntario Geospatial Data Exchange (OGDE) members must select ‘Include Related Tables’ when ordering data from LIO Data Warehouse. When you reach the Select Data tab make sure ‘Include Related Tables’ is checked.Figure 9: Check 'Include Related Tables' when ordering LIO dataWhy can’t I see ORN attributes like Speed Limit or Road Class in ArcMap?Some attributes, like Speed Limit, are only available in ORN Road Net Element (see What is the difference between ORN Road Net Element and ORN Segment with Address?). ORN attribute tables will not draw in ESRI’s ArcMap unless they are displayed as Route Events. Route Events are created from the event (attribute) tables using distance measures. In the ORN the measures are FROM_MEASURE and TO_MEASURE for line events and AT_MEASURE for point events. Measures and an identifier called ROAD_NET_ELEMENT_ID locate the events on the geometry. Once displayed the Route Event is like any other layer and can be symbolized and analyzed. In ORNELEM, most route events can be displayed using Display Route Events. To display ORN_JUNCTION use Display XY Data (explained below).For more information on which attributes are available in each data class, visit the LIO metadata records for ORN Road Net Element () and ORN Segment with Address ().For additional information on Route Events visit ESRI’s ArcGIS Resources: An overview of displaying and querying route events ().How do I display ORN Route Events in ArcMap?To display ORN route events in ArcMap (version 10.1):Add the ORN_ROAD_NET_ELEMENT feature class to the Table of Contents (TOC)Add an event table, e.g. ROAD_CLASSIn the TOC ‘List by Source’ tab, right-click on the ROAD_CLASS event table and select ‘Display Route Events’. A dialog box opens.Route Reference: ORN_ROAD_NET_ELEMENTRoute Identifier: OGF_ID (or FMF_OBJECT_ID, depending on data vintage)Event Table: ROAD_CLASSRoute Identifier: ROAD_NET_ELEMENT_IDChoose Point or Line Events. E.g. ROAD_CLASS is Line; for points select AT_MEASURE From-Measure: FROM_MEASURETo-Measure: TO_MEASURE Offset: <None>Click OK. A new layer appears which can be symbolized, queried, and updated as if it was any other feature class.Figure 10: ArcMap's Display Route EventsHow do I display the ORN_JUNCTION table in ArcMap?The ORN_JUNCTION table uses x and y coordinates instead of distance measures for positions.To display Junctions in ArcMap (version 10.1):Add the ORN_ROAD_NET_ELEMENT feature class to the Table of Contents (TOC)Add the JUNCTION event tableIn the TOC ‘List by Source’ tab, right-click on the JUNCTION event table and select ‘Display XY Data’. A dialog box opens.X Field: LONGITUDE_DECIMAL_DEGREESY Field: LATITUDE_DECIMAL_DEGREESZ Field: <None>Coordinate System Description: Geographic Coordinate System: Name: GCS_North_American_1983Click OK. Junction points will appear at ends of linear segments, suitable for symbolizing and analysis.Figure 11: ArcMap's Display XY DataHow do I join ORN tables or event layers?To create a simple join using ORNELEM event tables or route events in ArcMap (version 10.1):In the Table of Contents (TOC), select the event or feature class to join, e.g. ORN_ROAD_NET_ELEMENT.In the TOC right-click on the ORN_ROAD_NET_ELEMENT and select Joins and Relates, then Join…In the Join Data dialog box:First Join field is the OGF_ID (OBJECT_ID (or FMF_OBJECT_ID, depending on data vintage)Choose the table to join to ORN_ROAD_NET_ELEMENT, e.g. ORN_ADDRESS_INFOSecond Join field is ROAD_NET_ELEMENT_IDChoose either ‘Keep all records’ or ‘Keep only matching records’, depending on need.Click OK. This step can be run multiple times to attach tables and route events.Figure 12: ArcMap's Join DataHow do I access ORN attributes for analysis?In order to query more of the data, you can join tables or route events to each other or the ORN geometry. As an example, a query could be designed to identify Bridges (ORN_STRUCTURE) on Freeways (ORN_ROAD_CLASS).For additional information on joining tables in ArcMap, visit ESRI’s ArcGIS Resources: Joining attributes in one table to another ().Where do I find 911 addresses?The ORN receives data from authoritative sources responsible for 911 address management for the purposes of emergency management. Not all areas of Ontario are covered by a 911 addressing management system but those areas will typically have a system of addressing assigned to roads which are represented in the ORN. Addressing information is available in ORN Road Net Element in the ADDRESS_INFO table, and in the ORN Segment with Address attributes.What is the difference between 911 and civic addresses?A civic address consists of a street number, street name, municipality name, province code and postal code. A 911 address is similar and they combine to uniquely describe a specific location to help emergency services locate properties. In some areas of the province, a 911 address and civic address terms are used interchangeably or a 911 address may only refer to rural properties.What is the difference between shield type and road class?A shield type identifies a route assigned by a road authority, e.g. MTO, and is also used for cartographic purposes. Shield Type is part of ROUTE_NUMBER, found in both ORNELEM and ORNSEGAD. A road class identifies a type of road based on a functional class (e.g. highway, arterial). The ROAD_CLASS table is in both ORN data classes.What is the difference between the Jurisdiction, Agency Name, and Road Net Element Source tables?Jurisdiction indicates the agency has custodianship of a road with responsibility to ensure maintenance occurs but may not undertake it directly. Jurisdiction is not available in ORNSEGAD.An Agency Name identifies the source agency that provided attributes. Agency Name is not available in ORNSEGAD.The Road Net Element Source identifies the source agency that provided road net element geometry. Often Road Net Element Source and Agency Name are the same. Road Net Element Source is not available in ORNSEGAD.What projection is used to calculate LENGTH in ORN?The length of the ORN Road Net Element is calculated in UTM. Each feature determines which UTM projection to use based on the centre of the feature.UTM Zones in Ontario:15 = -96 to -9016 = -90 to -8417 = -84 to -7818 = -78 to -72I found a road with an offensive or rescinded name in the ORN. Are you able to rename the road or remove the name?The ORN relies on partner organizations to provide road data. As we are not the official source of the data we cannot rename or remove the name of a road feature. The quality control processes used to maintain the ORN will identify names that have been rescinded by the Government of Ontario. If a name is identified the ORN team will inform the original source of the data. It is at the discretion of the source data owner to decide if a name is to be rescinded. Users can contact source data owners directly to inquire about road names.I still need help!For more information visit LIO () or email your questions to lio@ontario.ca.Version 1617.1 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download