ORN Segment with Address User Guide



User GuideforORN Segment with AddressLIO 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 email 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, ORNAbstractThis user guide details the specifications for the ORN Segment with Address (ORNSEGAD) 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. ORNSEGAD is derived from the ORN Road Net Element (ORNELEM) data class 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 _Toc2337784 \h 2Additional Information PAGEREF _Toc2337785 \h 2Executive Summary PAGEREF _Toc2337786 \h 3Key Words PAGEREF _Toc2337787 \h 3Abstract PAGEREF _Toc2337788 \h 3Table of Contents PAGEREF _Toc2337789 \h 4List of Figures PAGEREF _Toc2337790 \h 6List of Tables PAGEREF _Toc2337791 \h 7List of Acronyms PAGEREF _Toc2337792 \h 81. Introduction PAGEREF _Toc2337793 \h 92. Objectives PAGEREF _Toc2337794 \h 93. Data Class: ORN Segment with Address (ORNSEGAD) PAGEREF _Toc2337795 \h 94. Model Diagram: ORN Segment with Address (ORNSEGAD) PAGEREF _Toc2337796 \h 105. Data Description PAGEREF _Toc2337797 \h 12ORN_SEGMENT_WITH_ADDRESS_FT PAGEREF _Toc2337798 \h 126. Best Practices and Product Limitations PAGEREF _Toc2337799 \h 16ORN Segment with Address (ORNSEGAD) contains fewer attributes than ORN Road Net Element (ORNELEM) PAGEREF _Toc2337800 \h 167. Links to Additional Information PAGEREF _Toc2337801 \h 17APPENDIX A: LIO Lookup Tables and Values PAGEREF _Toc2337802 \h 18ORN_DIR_OF_TRAFFIC_FLOW_LIST PAGEREF _Toc2337803 \h 18ORN_HOUSE_NUM_STRUCTURE_LIST PAGEREF _Toc2337804 \h 18ORN_ROAD_CLASS_LIST PAGEREF _Toc2337805 \h 20ORN_ROAD_ELEMENT_TYPE_LIST PAGEREF _Toc2337806 \h 21ORN_SHIELD_TYPE_LIST PAGEREF _Toc2337807 \h 22ORN_STANDARD_MUNICIPALITY_LIST PAGEREF _Toc2337808 \h 23ORN_STREET_DIRECTION_LIST PAGEREF _Toc2337809 \h 39ORN_STREET_TYPE_LIST PAGEREF _Toc2337810 \h 40APPENDIX B: Table Key Dependency and Relationship Index PAGEREF _Toc2337811 \h 47Main Business Area Tables PAGEREF _Toc2337812 \h 49Lookup Table Indexes PAGEREF _Toc2337813 \h 49APPENDIX C: Frequently Asked Questions PAGEREF _Toc2337814 \h 52What is the difference between ORN Road Net Element (ORNELEM) and ORN Segment with Address (ORNSEGAD)? PAGEREF _Toc2337815 \h 52What is a Linear Reference System (LRS)? PAGEREF _Toc2337816 \h 53Where are the attribute tables for the ORN_ROAD_NET_ELEMENT data class? PAGEREF _Toc2337817 \h 53Why can’t I see ORN attributes like Speed Limit or Road Class in ArcMap? PAGEREF _Toc2337818 \h 55How do I display ORN Route Events in ArcMap? PAGEREF _Toc2337819 \h 55How do I display the ORN_JUNCTION table in ArcMap? PAGEREF _Toc2337820 \h 57How do I join ORN tables or event layers? PAGEREF _Toc2337821 \h 58How do I access ORN attributes for analysis? PAGEREF _Toc2337822 \h 59Where do I find 911 addresses? PAGEREF _Toc2337823 \h 59What is the difference between 911 and civic addresses? PAGEREF _Toc2337824 \h 59What is the difference between shield type and road class? PAGEREF _Toc2337825 \h 59What is the difference between the Jurisdiction, Agency Name, and Road Net Element Source tables? PAGEREF _Toc2337826 \h 60What projection is used to calculate LENGTH in ORN? PAGEREF _Toc2337827 \h 60I found a road with an offensive or rescinded name in the ORN. Are you able to rename the road or remove the name? PAGEREF _Toc2337828 \h 60I still need help! PAGEREF _Toc2337829 \h 61APPENDIX D: Creating a Network with ORN Segment with Address (ORNSEGAD) PAGEREF _Toc2337830 \h 621. Introduction PAGEREF _Toc2337831 \h 622. Creating the Network PAGEREF _Toc2337832 \h 622.1. Steps for Preparing the ORNSEGAD PAGEREF _Toc2337833 \h 622.2. Steps to Create the Network Dataset PAGEREF _Toc2337834 \h 642.3. Steps to Define the Network Attributes PAGEREF _Toc2337835 \h 682.4. Steps to Establish Driving Directions PAGEREF _Toc2337836 \h 792.5. Steps to Finish Building the Network Dataset PAGEREF _Toc2337837 \h 82List of Figures TOC \h \z \c "Figure" Figure 1: Primary Key example PAGEREF _Toc2337838 \h 47Figure 2: Foreign Key example PAGEREF _Toc2337839 \h 47Figure 3: Alternate Key example PAGEREF _Toc2337840 \h 47Figure 4: Example of an Identifying Relationship PAGEREF _Toc2337841 \h 48Figure 5: Example of a Non-identifying Relationship PAGEREF _Toc2337842 \h 48Figure 6: Model Diagram Relationship Symbology Table PAGEREF _Toc2337843 \h 48Figure 7: Attribute tables included through LIO Metadata Management Tool PAGEREF _Toc2337844 \h 54Figure 8: Check 'Include Related Tables' when ordering LIO data PAGEREF _Toc2337845 \h 54Figure 9: ArcMap's Display Route Events PAGEREF _Toc2337846 \h 56Figure 10: ArcMap's Display XY Data PAGEREF _Toc2337847 \h 57Figure 11: ArcMap's Join Data PAGEREF _Toc2337848 \h 58Figure 12 – Add a new field for speed values PAGEREF _Toc2337849 \h 63Figure 13 – Select features by road class PAGEREF _Toc2337850 \h 64Figure 14 – Calculate the desired speed PAGEREF _Toc2337851 \h 64Figure 15 – Enable the “Network Analyst” extension PAGEREF _Toc2337852 \h 65Figure 16 – Create a new network dataset PAGEREF _Toc2337853 \h 66Figure 17 – Enter a name for the new network dataset. PAGEREF _Toc2337854 \h 66Figure 18 – Select the “Yes” radio button to model turns in the network. PAGEREF _Toc2337855 \h 67Figure 19 – Accept the default connectivity settings PAGEREF _Toc2337856 \h 67Figure 20 – Do not select an elevation model for the network. PAGEREF _Toc2337857 \h 68Figure 21 – Add the network attributes PAGEREF _Toc2337858 \h 69Figure 22 – Select the OneWay attribute PAGEREF _Toc2337859 \h 70Figure 23 – Set OneWay evaluators PAGEREF _Toc2337860 \h 71Figure 24 – Calculate the OneWay expression value PAGEREF _Toc2337861 \h 72Figure 25 – Select the Rd_Class attribute PAGEREF _Toc2337862 \h 73Figure 26 – Set the Rd_Class evaluators PAGEREF _Toc2337863 \h 74Figure 27 – Calculate the road class value PAGEREF _Toc2337864 \h 75Figure 28 – Select the speed attribute PAGEREF _Toc2337865 \h 76Figure 29 – Set the speed evaluators PAGEREF _Toc2337866 \h 77Figure 30 – Select the time attribute PAGEREF _Toc2337867 \h 77Figure 31 – Set the time evaluators PAGEREF _Toc2337868 \h 78Figure 32 – Calculate the time evaluators PAGEREF _Toc2337869 \h 78Figure 33 – The travel mode window PAGEREF _Toc2337870 \h 79Figure 34 – The driving directions window PAGEREF _Toc2337871 \h 80Figure 35 – Set the network direction properties PAGEREF _Toc2337872 \h 81Figure 36 – Set the shield values PAGEREF _Toc2337873 \h 82Figure 37 – The network dataset summary PAGEREF _Toc2337874 \h 83Figure 38 – Build the network dataset PAGEREF _Toc2337875 \h 83Figure 39 –The network dataset PAGEREF _Toc2337876 \h 84Figure 40 – The Network Analyst tools. PAGEREF _Toc2337877 \h 84 List of Tables TOC \h \z \c "Table" Table 1 – Possible speed limits for ORN road classes PAGEREF _Toc2337878 \h 62Table 2 – Add these attributes to the Network Dataset PAGEREF _Toc2337879 \h 68Table 3 – Possible values in the “DIRECTION” field PAGEREF _Toc2337880 \h 69Table 4 – Expressions for enforcing traffic flow directions PAGEREF _Toc2337881 \h 71Table 5 – Network direction field values PAGEREF _Toc2337882 \h 81List of AcronymsCPC: Canada Post CorporationGO-ITS: Government of Ontario Information Technology StandardLIO: Land Information Ontario LUT: 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 NetworkWMS: 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 lio@ontario.ca.2. ObjectivesThis guide is intended for users with a general interest in the ORN Segment with Address LIO Data Class. The remainder of this document describes the extent and context of the information collected for the data class.3. Data Class: ORN Segment with Address (ORNSEGAD)ORNSEGAD is derived from the ORN Road Net Element (ORNELEM) data class and combines three types of geometry from ORNELEM: road elements, ferry connections, and virtual roads. Address ranges span intersection to intersection or may be interpolated across intersections.ORNSEGAD contains five attributes: Street Name, Address Information, Route Identification, Road Classification, and Direction of Traffic Flow. For additional road attribution, see ORN Road Net Element (ORNELEM).For more detailed information refer to the ORNSEGAD data model diagram and Appendix B: Table Key Dependency and Relationship Index.4. Model Diagram: ORN Segment with Address (ORNSEGAD)Physical Model Diagram for: ORN Segment with Address (ORNSEGAD)Model Effective Date: 2012-JUN-14Note: Where applicable to this model:Tables with a “_LIST” extension (shaded yellow) = Lookup Table (LUT)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_SEGMENT_WITH_ADDRESS_FTA road segment that represents a centreline network representing roads and their associated addresses.Column NameColumn TypeMandatoryShort NameDescriptionOGF_IDNUMBER(13)YesOGF_IDOntario Geospatial Feature Identifier: A unique numeric provincial identifier assigned to each object.OFFICIAL_STREET_NAMEVARCHAR2(100)NoFULL_NAMEStreet name composed of individual street name components where present, including directional prefix, street type prefix, street name body, street type suffix and directional suffix.ABBREVIATED_STREET_NAMEVARCHAR2(100)NoABBR_NAMEAbbreviated street name 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.ALTERNATE_STREET_NAMEVARCHAR2(100)NoALT_NAMEAlternate name attached to a road segment not associated to an established route.DIRECTIONAL_PREFIXVARCHAR2(10)NoDIR_PREFIXA geographic direction preceding either the street type prefix or the street name body.Permissible Values: (See ORN_STREET_DIRECTION_LIST lookup table in appendix)STREET_TYPE_PREFIXVARCHAR2(25)NoST_TYPE_PA street type preceding the street name body.Permissible Values: (See ORN_STREET_TYPE_LIST lookup table in appendix)STREET_NAME_BODYVARCHAR2(50)YesNAME_BODYThe identifying named component of a street name. Street segment must have a street name body and can never be abbreviated.STREET_TYPE_SUFFIXVARCHAR2(25)NoST_TYPE_SA street type following the street name body.Permissible Values: (See ORN_STREET_TYPE_LIST lookup table in appendix)DIRECTIONAL_SUFFIXVARCHAR2(10)NoDIR_SUFFIXA geographic direction following either the street name body or the street type suffix.Permissible Values: (See ORN_STREET_DIRECTION_LIST lookup table in appendix)ROAD_CLASSVARCHAR2(25)NoROAD_CLASSThe functional classification of the road segment.Permissible Values: (see ORN_ROAD_CLASS_LIST lookup table in appendix)ROAD_ELEMENT_TYPEVARCHAR2(20)YesELEM_TYPEAn attribute describing the type of road segment. Valid values:Permissible Values: (See ORN_ROAD_ELEMENT_TYPE_LIST lookup table in appendix)L_FIRST_HOUSE_NUMBERNUMBER(7,0)NoL_FIRSTThe first house number of the address range on the left side of a road segment.L_LAST_HOUSE_NUMBERNUMBER(7,0)NoL_LASTThe last house number of the address range on the left side of a road segment.L_HOUSE_NUMBER_STRUCTUREVARCHAR2(10)NoL_STRUCTThe type of addressing method applied to the left side of a road segment.Permissible Values: (See ORN_HOUSE_NUM_STRUCTURE_LIST lookup table in appendix)L_ORIGINAL_MUNICIPALITYVARCHAR2(100)NoL_ORIG_MUNThe municipality name applied to the left side of a road segment as provided.L_STANDARD_MUNICIPALITYVARCHAR2(100)NoL_STD_MUNThe standardized municipality applied to the left side of the road segment as provided by the Ministry of Municipal Affairs and Housing (MMAH) and Indian Reserves.Permissible Values: (See ORN_STANDARD_MUNICIPALITY_LIST lookup table in appendix)R_FIRST_HOUSE_NUMBERNUMBER(7,0)NoR_FIRSTThe first house number of the address range on the right side of a road segment.R_LAST_HOUSE_NUMBERNUMBER(7,0)NoR_LASTThe last house number of the address range.R_HOUSE_NUMBER_STRUCTUREVARCHAR2(10)NoR_STRUCTThe type of addressing method applied to the right side of a road segment.Permissible Values: (See ORN_HOUSE_NUM_STRUCTURE_LIST lookup table in appendix)R_ORIGINAL_MUNICIPALITYVARCHAR2(100)NoR_ORIG_MUNThe municipality name applied to the right side of a road segment as provided.R_STANDARD_MUNICIPALITYVARCHAR2(100)NoR_STD_MUNThe standardized municipality applied to the right side of the road segment as provided by the Ministry of Municipal Affairs and Housing (MMAH) and Indian Reserves.Permissible Values: (See ORN_STANDARD_MUNICIPALITY_LIST lookup table in appendix)DIRECTION_OF_TRAFFIC_FLOWVARCHAR2(8)YesDIRECTIONThe direction of traffic flow applied to the road segment.Permissible Values: (See ORN_DIR_OF_TRAFFIC_FLOW_LIST lookup table in appendix)ROUTE_NAME_1VARCHAR2(50)NoRTE_NAME_1The name of an established route.ROUTE_NAME_2VARCHAR2(50)NoRTE_NAME_2The name of an established route.ROUTE_NAME_3VARCHAR2(50)NoRTE_NAME_3The name of an established route.ROUTE_NAME_4VARCHAR2(50)NoRTE_NAME_4The name of an established route.ROUTE_NUMBER_1VARCHAR2(5)NoRTE_NUM_1The route number represented by a numeric and/or an alphanumeric character associated with a provincial highway, secondary highway, county road or regional road.ROUTE_NUMBER_2VARCHAR2(5)NoRTE_NUM_2The route number represented by a numeric and/or an alphanumeric character associated with a provincial highway, secondary highway, county road or regional road.ROUTE_NUMBER_3VARCHAR2(5)NoRTE_NUM_3The route number represented by a numeric and/or an alphanumeric character associated with a provincial highway, secondary highway, county road or regional road.SHIELD_TYPEVARCHAR2(60)NoSHIELD_TThe shield type classified by a route and used for cartographic purposes.Permissible Values: (See ORN_SHIELD_TYPE_LIST lookup table in appendix)LENGTHNUMBER(9,3)YesLENGTHThe length of the segment in metres.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.6. Best Practices and Product LimitationsORN Segment with Address (ORNSEGAD) contains fewer attributes than ORN Road Net Element (ORNELEM)ORNSEGAD is a segmented data class derived from ORNELEM and includes fewer attributes. This may create issues when using ORNSEGAD for network analysis or routing purposes. For example, speed limits and blocked passages are not included in ORNSEGAD. If these attributes are required, one could derive them from the ORNELEM data class or create their own as in Appendix D.7. Links to Additional InformationOfficial LIO Metadata Record for ORN Segment with Address ()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_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_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.ORN_ROAD_ELEMENT_TYPE_LIST Permissible ValuesROAD 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_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 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 SEQ Figure \* ARABIC 1: 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 SEQ Figure \* ARABIC 2: 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 SEQ Figure \* ARABIC 3: 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 SEQ Figure \* ARABIC 4: 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 SEQ Figure \* ARABIC 5: 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 SEQ Figure \* ARABIC 6: 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 Segment with Address 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_SEGMENT_WITH_ADDRESS_FTPrimary Key(s): OGF_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_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_SEGMENT_WITH_ADDRESS_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_SEGMENT_WITH_ADDRESS_FTL_HOUSE_NUMBER_STRUCTURENIOptional: 1 to manyOptional: 1 to1ORN_SEGMENT_WITH_ADDRESS_FTR_HOUSE_NUMBER_STRUCTURENIOptional: 1 to manyOptional: 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_SEGMENT_WITH_ADDRESS_FTROAD_CLASSNIOptional: 1 to manyOptional: 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_SEGMENT_WITH_ADDRESS_FTROAD_ELEMENT_TYPENIOptional: 1 to manyOptional: 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_SEGMENT_WITH_ADDRESS_FTSHIELD_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_SEGMENT_WITH_ADDRESS_FTL_STANDARD_MUNICIPALITYNIOptional: 1 to manyOptional: 1 to1ORN_SEGMENT_WITH_ADDRESS_FTR_STANDARD_MUNICIPALITYNIOptional: 1 to manyOptional: 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_SEGMENT_WITH_ADDRESS_FTDIRECTIONAL_PREFIXNIOptional: 1 to manyOptional: 1 to1ORN_SEGMENT_WITH_ADDRESS_FTDIRECTIONAL_SUFFIXNIOptional: 1 to manyOptional: 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_SEGMENT_WITH_ADDRESS_FTSTREET_TYPE_PREFIXNIOptional: 1 to manyOptional: 1 to1ORN_SEGMENT_WITH_ADDRESS_FTSTREET_TYPE_SUFFIXNIOptional: 1 to manyOptional: 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 SEQ Figure \* ARABIC 7: 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 SEQ Figure \* ARABIC 8: 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 SEQ Figure \* ARABIC 9: 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 SEQ Figure \* ARABIC 10: 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 SEQ Figure \* ARABIC 11: 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.APPENDIX D: Creating a Network with ORN Segment with Address (ORNSEGAD)1. IntroductionThe ORNSEGAD data class can be used to create a network for analysis and routing. The following appendix demonstrates one method for creating a network dataset using ArcGIS and the Network Analyst extension. However, there are many different ways to build a network using various software packages.2. Creating the Network2.1. Steps for Preparing the ORNSEGADNetwork datasets often include travel time as a cost attribute to be used in their networking algorithms. However, ORNSEGAD does not contain the speed limit attribute information necessary for calculating travel time. One potential solution is to estimate speed limits based on road class. Possible example values are showing in Table 1. Table SEQ Table \* ARABIC 1 – Possible speed limits for ORN road classesORN Road ClassSpeed LimitFreeway100Highway / Expressway80Arterial60Collector50Local / Street50Local / Strata50Resource / Rec50Service 50Alleyway / Laneway 40Add a new “Short Integer” field called “Speed” to the “ORN_SEGMENT_WITH_ADDRESS” shapefile (Figure 12).Open the “Select By Attributes…” window and select features within the “ORN_SEGMENT_WITH_ADDRESS” shapefile based on the “ROAD_CLASS” field (Figure 13).Open the “Field Calculator” on the “Speed” field to calculate the desired speed limit (Figure 14).Figure SEQ Figure \* ARABIC 12 – Add a new field for speed valuesFigure SEQ Figure \* ARABIC 13 – Select features by road classFigure SEQ Figure \* ARABIC 14 – Calculate the desired speed2.2. Steps to Create the Network DatasetOpen the “Extensions…” window and enable the “Network Analyst” extension (Figure 15).Right click the “ORN_SEGMENT_WITH_ADDRESS” shapefile and select “New Network Dataset…” (Figure 16).Enter a name for the new network dataset (Figure 17).Select the “Yes” radio button to model turns in the network (Figure 18).The default connectivity settings establish connectivity at coincident endpoints only. This is the ideal setting when working with the ORN. Note that junctions will not be created where roads overlap but do not intersect (ex. overpasses). Click next (Figure 19).The ORN does not contain elevation data. Select the “None” radio button and click next (Figure 20).Figure SEQ Figure \* ARABIC 15 – Enable the “Network Analyst” extensionFigure SEQ Figure \* ARABIC 16 – Create a new network datasetFigure SEQ Figure \* ARABIC 17 – Enter a name for the new network dataset.Figure SEQ Figure \* ARABIC 18 – Select the “Yes” radio button to model turns in the network.Figure SEQ Figure \* ARABIC 19 – Accept the default connectivity settingsFigure SEQ Figure \* ARABIC 20 – Do not select an elevation model for the network.2.3. Steps to Define the Network AttributesAdd new attributes to the network dataset as shown in Table 2 and Figure 21.Table SEQ Table \* ARABIC 2 – Add these attributes to the Network Dataset NameUsageUnitsData TypeLengthCostMetersDoubleOneWayRestrictionUnknownBooleanRd_ClassHierarchyUnknownIntegerSpeedDescriptorKPHIntegerTimeCostMinutesDoubleFigure SEQ Figure \* ARABIC 21 – Add the network attributes2.3.1. Steps to Enforce One Way RestrictionsIt is important to enforce traffic flow restrictions to ensure that rules along one way roads are followed and that network analyses behave as expected. The ORN_SEGMENT_WITH_ADDRESS dataset contains traffic flow direction information in the “DIRECTION” field. Possible values are described in Table 3.Table SEQ Table \* ARABIC 3 – Possible values in the “DIRECTION” fieldDIRECTIONDescriptionBothTraffic can travel in both directions along the given segmentPositiveTraffic can only travel in the same direction as the segment’s geometry. NegativeTraffic can only travel in the opposite direction as the segment’s geometry. Highlight the “OneWay” attribute and select the “Evaluators…” button on the right (Figure 22).Set the “Type” column to “Field” for both edge elements. Highlight each edge element and click the “Evaluator Properties” button on the right (Figure 23).Set the value equal to the appropriate expression listed in Table 4 and click OK (Figure 24).Figure SEQ Figure \* ARABIC 22 – Select the OneWay attributeFigure SEQ Figure \* ARABIC 23 – Set OneWay evaluatorsTable SEQ Table \* ARABIC 4 – Expressions for enforcing traffic flow directionsDirectionValue ExpressionFrom-ToNOT ([DIRECTION] = "Both" OR [DIRECTION] = "Positive")To-FromNOT ([DIRECTION] = "Both" OR [DIRECTION] = "Negative")Figure SEQ Figure \* ARABIC 24 – Calculate the OneWay expression value2.3.2. Steps to Build a Road Class HierarchyA hierarchy can be built using road classifications to help reduce network analysis computation time. The hierarchy classifies the roads into a number of levels which are then used by the networking algorithms to primarily search the higher levels of the hierarchy (ex. Travel over highways will be preferred over local roads). It is important to consider that enforcing a road hierarchy will often result in solutions with a higher cost (ex. total distances and travel times may be greater when using a hierarchy). It will be necessary to experiment with hierarchy settings if one decides to use it. On the Attributes window, highlight “Rd_Class” and click the “Evaluators…” button on the right (Figure 25).Set the “Type” column to “Field” for both edge elements. Highlight each edge element and click the “Evaluator Properties” button on the right (Figure 26).Write an expression to calculate an integer value for each road classification (Figure 27). An example Python script is shown below.Rd_Class = 4if 'Freeway' in !ROAD_CLASS!:Rd_Class = 1elif 'Ramp' in !ROAD_CLASS!:Rd_Class = 1elif 'Highway' in !ROAD_CLASS!:Rd_Class = 2elif 'Arterial' in !ROAD_CLASS!:Rd_Class = 2elif 'Collector' in !ROAD_CLASS!:Rd_Class = 3elif 'Street' in !ROAD_CLASS!:Rd_Class = 3Figure SEQ Figure \* ARABIC 25 – Select the Rd_Class attributeFigure SEQ Figure \* ARABIC 26 – Set the Rd_Class evaluatorsFigure SEQ Figure \* ARABIC 27 – Calculate the road class value2.3.3. Steps to Estimate Travel TimeOn the “Attributes” window, highlight the “Speed” attribute and click the “Evaluators…” button (Figure 28).Set the Type column to “Field” and the Value column to “Speed” (Figure 29).On the “Attributes” window, highlight the “Time” attribute and click “Evaluators…” (Figure 30).Set the “Type” column to “Field” for both edge elements. Highlight each edge element and click the “Evaluator Properties” button on the right (Figure 31).Write an expression to calculate the time needed to travel each edge segment based on its length and speed limit (Figure 32). An example Python script is shown below.time = ((!LENGTH! / 1000) / !Speed!) * 60Figure SEQ Figure \* ARABIC 28 – Select the speed attributeFigure SEQ Figure \* ARABIC 29 – Set the speed evaluatorsFigure SEQ Figure \* ARABIC 30 – Select the time attributeFigure SEQ Figure \* ARABIC 31 – Set the time evaluatorsFigure SEQ Figure \* ARABIC 32 – Calculate the time evaluators2.4. Steps to Establish Driving DirectionsCreate a travel mode if desired. Otherwise, click “Next” (Figure 33).Select the “Yes” radio button to establish driving directions and click the “Directions…” button (Figure 34).Select the “General” tab and populate the street name columns with the field names as shown in Table 5 and Figure 35.Select the “Shields” tab and the “Pair of Fields” radio button. Set the type field to “SHEILD_T” and the number field to RTE_NUM_1. Click OK (Figure 36).Figure SEQ Figure \* ARABIC 33 – The travel mode windowFigure SEQ Figure \* ARABIC 34 – The driving directions windowFigure SEQ Figure \* ARABIC 35 – Set the network direction propertiesTable SEQ Table \* ARABIC 5 – Network direction field valuesPrefixNameSuffixFull NameDIR_PREFIXNAME_BODYDIR_DUFFIXFULL_NAMEFigure SEQ Figure \* ARABIC 36 – Set the shield values2.5. Steps to Finish Building the Network DatasetReview the Network Dataset summary and click the “Finish” button (Figure 37).Click the “Yes” button to build the dataset. Note that it may take a long time to build the dataset (Figure 38).View the completed network dataset (Figure 39).Begin exploring the different Network Analyst tools (Figure 40).Figure SEQ Figure \* ARABIC 37 – The network dataset summaryFigure SEQ Figure \* ARABIC 38 – Build the network datasetFigure SEQ Figure \* ARABIC 39 –The network datasetFigure SEQ Figure \* ARABIC 40 – The Network Analyst tools.Version 1617.1 ................
................

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

Google Online Preview   Download