320 likes | 477 Vues
Iowa DOT LRS. Steve Kadolph Research & Technology Bureau Highway Division. Discussion Topics. What is the LRS Data collection status How is the DOT using it. LRS Team Recommendations. Need to improve spatial representation Use NCHRP (20-27) project model
E N D
Iowa DOT LRS Steve Kadolph Research & Technology Bureau Highway Division
Discussion Topics • What is the LRS • Data collection status • How is the DOT using it
LRS Team Recommendations • Need to improve spatial representation • Use NCHRP (20-27) project model • Need ability to integrate variety of data • Mile post referenced data (US 30 @ 135.23) • Coordinate referenced data (Lat, Long, I35) • Literal description data (2.51 mi past 1st St) • Road address data (247 E. Main St) • Need to provide a navigable network • Establish maintenance processes and partnerships
LRS - Linear Referencing Systema set of procedures and methods for specifying a location as a distance, or offset, along a linear feature, from a point with known locationLRM - Linear Referencing MethodDifferent methods of measuring linear locations; (i.e. milepoint, literal description, address range, etc.)
Base Record Inventory Project Data Program Crash PMIS Coordinate Route Reference Post Coordinate Route Milepoint Stationing Literal Description LRS Components Address Range Centerline Representation 1 Centerline Representation 2 Centerline Representation 3 LRS Model
Transform Transform Transform Linear ModelingIntegration Between Different LRMs Integration of data stored in different LRMs creates a need for many transforms or cross-reference tables. LRM LRM LRM LRM LRM LRM
LRS Components • Roadway Shape – Cartographies • Datum - Anchor Points/Anchor Sections • Network - Transport Nodes/Transport Links • Routes – E911, State, County, Municipal, Private, Institutional, Unofficial, Ramps • LRM Components – Reference Posts, etc.
What the LRS Looks Like Cartography Road Network
What the LRS Looks Like Cartography Road Network Anchor Point Anchor Section
What the LRS Looks Like Cartography Road Network Anchor Point Anchor Section Transport Node Transport Link IA 507
What the LRS Looks Like Cartography Road Network Anchor Point Elm St Anchor Section Transport Node Transport Link Route IA 507
What the LRS Looks Like Cartography Road Network Anchor Point Anchor Section Transport Node Transport Link 5 Route Reference Post ? IA 507 4
LRS Features Created • Anchor Points (139,829) • Anchor Sections (80,163) • Transport Nodes (215,764) • Transport Links (313,117) • Routes (113,380) • Reference Posts (11,701)
Applying the LRS Decision Support Conceptual Model Business Data Pavement Bridge Road Inv Crashes Rail . . . Safety Inv GeoData Library Data LRS Op Comp LRM Environmental Design Cadastral Aerial Photos Satellite Images Pavement Bridge Road Inv Crashes Rail Safety Inv Linear Referencing System Operational Components Datum Network Routes Projects Metadata LRMs Ref Post Coor Rte Lit Desc Milepoint Stationing Segmental Linear/ Spatial Relationships Linear/ Spatial Relationships LRS Staging Business Data Staging
Partnering Benefits • Provides a centralized data storage facility and data source for most road transportation information systems • Minimizes redundancy • City Government (Utilities, Engineering) • County Government (Engineering, Assessor) • State Government (DOT, Emergency Mgmt) • Federal Government (Census, FHWA)
What Is Required to Use the LRS • Reference Post LRM (MilePost) • Route System (Interstate, US, Iowa) • Route Number (29, 65, 151, etc.) • Reference Post (1, 2, 3, 3A, etc.) • Offset (+/- distance from observed Post) • Coordinate Route (GPS) • Coordinates (Latitude, Longitude) • Route System and Number (ensures correct route selected in dense road networks) • Temporal Component (mm/dd/yy)
Technical Infrastructure • Production Oracle database with Spatial • Dual Processor 4GB RAM • Oracle workspace manager • Bentley LDMx • GTM • Test Oracle database with Spatial • Shared VM Server • Oracle Workspace manager • Bentley LDMx • GTM
Technical Infrastructure • Over 650 Tables and 4000 views • Ability to use GIS Software or custom SQL queries to view data. • select anchor_section_id, utility.GET_CONFLATION_GEOMETRY(CONFLATION_GA_TW), geometry_ga_tw from ANCHOR_SECTION where anchor_section_id = 58515