using utah's linear referencing gis layer: sgid93.transportation.udotroutes_lrs
DESCRIPTION
Slides from UGIC 2011 conference in Logan (April 2011). First half of slides (Bert Granberg AGRC) discuss what, why and how of the LRS dataset created by AGRC and UDOT to represent state and federal routes in Utah in a polylineM format.Second half (Thomas McMurtry, Interplan) shows use cases where tabular data on traffic volume, accidents, projects, etc was linked to the GIS representation of the LRS for map display and queryTRANSCRIPT
![Page 1: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/1.jpg)
4/7/2011 Thomas McMurtry
UsingUtah’s LRS
Thomas McMurtry
InterPlan
Bert Granberg
AGRC
![Page 2: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/2.jpg)
What is an LRS
Linear Referencing System Route Definition
System Standards Route Names, IDs Ordered Road Segments Calibration Points {Start, Intermediate(s), End}
Physical monuments (mileposts, exit nbrs)
Linear Diagrams (1D)
Digital Geographic Base Reference (2D & 3D)
PolylineM Feature Class (x,y,m(easure) coordinates)
![Page 3: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/3.jpg)
Why LRS?• Provides a Common Geometric Base• Simple geometry maintained in one place Events (as table rows, but references RT_ID + MP)
Point: Overhead sign 0015P 306.381
Line: Asphalt pavement overlay, 0210P 7.982 to 12.119 (lane 1)
– Think about lanes on I-15
• Analytical Advantages– Many ‘spatial’ operations are done in 1
dimension
![Page 4: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/4.jpg)
Statewide Centerline Goals:
Accessible, Valued Public Resource
Currency:– Statewide roads published update every 2 months
Functionality:•Cartographic Base Map Support•Inventory (funding, jurisdiction, surface, etc)•Address Matching
– Street Address & Route/Milepost
•Routing Solutions
![Page 5: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/5.jpg)
Statewide Centerline Goals:
Accessible, Valued Public Resource
Currency:– Statewide roads published update every 2 months
Functionality:•Cartographic Base Map Support•Inventory (funding, jurisdiction, surface, etc)•Address Matching
– Street Address & Route/Milepost
•Routing Solutions•Linear Referencing Base
– Adds Complexity but makes Enterprise Sense!!!
![Page 6: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/6.jpg)
Linear Referencing System
• How it gets built– Statewide road, ramp & collector features:
• Connectivity, Alignment, Geometric Depiction
• DOT_RTNAME Route ID
• DOT_RTPART Part Number, for multipart routes
– Merge road features route features
– Calibration points• All part end points
• Intermediate points, about every 5-10 miles
![Page 7: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/7.jpg)
Building Utah State Route 137
![Page 8: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/8.jpg)
1. SELECT Participating Centerlines
![Page 9: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/9.jpg)
2. ATTRIBUTE Road Features w/ RtName & RtPart_Nbr
0137PPart 1
0137PPart 2
0137PPart 3
![Page 10: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/10.jpg)
3. MERGE Road Features Into Route Parts
0137PPart 1
0137PPart 2
0137PPart 3
![Page 11: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/11.jpg)
4. CALIBRATE Route M Coordinates at Endpoints
![Page 12: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/12.jpg)
2.3148.801
5. ADD INTERMEDIATE CALIBRATION Where Needed
![Page 13: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/13.jpg)
6. MERGE Parts Into Single PolylineM Feature
![Page 14: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/14.jpg)
6. MERGE Parts Into Single PolylineM Feature
7. QA
8. DERIVE Additional Products:
• Milepost Points (events!)
• Milepost Ranges on Road Features
![Page 15: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/15.jpg)
•Integrated Highway & Local Data•Mileposts,•Exit Numbers,•Ramp IDS (not shown)
Happier Response Community
![Page 16: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/16.jpg)
4/7/2011 Thomas McMurtry
“P”
Nor
thbo
und
Mile
post
s 0
- 400“N
” S
outh
boun
d
Mile
post
s 0
- 400
“X”
So
uth
bo
un
d
Mil
epo
sts
400
- 0P, N, & X
• ‘P’ositive direction routes exist for all highways, measures increase in northbound or eastbound direction.
• ‘N’egative exist only for divided highway sections and depict the southbound or westbound directions
– Measures for Interstate N routes are in DRIVEN, not mileposted direction, as this is how UDOT inventories features on these routes
– For interstates, X route measures are according to physical mileposts in the negative direction (this is how they are common referenced outside of UDOT)
![Page 17: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/17.jpg)
4/7/2011 Thomas McMurtry
Agenda
– Tools– Points
• Making a point route event• Locating features along a route
– Segments• Making a segment route event• Overlay multiple route events
![Page 18: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/18.jpg)
4/7/2011 Thomas McMurtry
Tools
• Utah State Routes created by UDOT and AGRC
• ArcToolbox includes LRS tools as defalt
• Make sure that the routes functions are available
• P, N, & X
![Page 19: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/19.jpg)
4/7/2011 Thomas McMurtry
![Page 20: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/20.jpg)
4/7/2011 Thomas McMurtry
![Page 21: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/21.jpg)
4/7/2011 Thomas McMurtry
Point Data
• Make Route Event Layer– Working with tables
– Adding Crash Locations
![Page 22: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/22.jpg)
4/7/2011 Thomas McMurtry
LRS Table
• Remember Route Identifier is the LABEL column
![Page 23: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/23.jpg)
4/7/2011 Thomas McMurtry
Crash Table
• Use “=concatenate” in excel to create a label columnCRASH_ID Route Dir Label MILEPOINT CRASH_DATE CITY FIRST_HARM
10292727.000000 0023 P 0023P 5.900 7/13/2008 2510292435.000000 0023 P 0023P 1.200 7/21/2008 2510296580.000000 0023 P 0023P 5.920 4/10/2008 710112327.000000 0023 P 0023P 16.300 2/24/2008 CACHE JUNCTION 8810291643.000000 0023 P 0023P 11.200 1/30/2008 8810296647.000000 0023 P 0023P 2.300 4/9/2008 5710292252.000000 0023 P 0023P 5.920 7/27/2008 2510295504.000000 0023 P 0023P 2.600 5/3/2008 3110295687.000000 0023 P 0023P 2.400 4/29/2008 3910285663.000000 0023 P 0023P 15.600 12/19/2008 2510287125.000000 0023 P 0023P 5.040 11/28/2008 2510289947.000000 0023 P 0023P 6.100 9/23/2008 2510287713.000000 0023 P 0023P 3.100 11/13/2008 2510287673.000000 0023 P 0023P 19.170 11/14/2008 2510293079.000000 0023 P 0023P 5.920 7/4/2008 20
![Page 24: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/24.jpg)
4/7/2011 Thomas McMurtry
Example
![Page 25: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/25.jpg)
4/7/2011 Thomas McMurtry
![Page 26: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/26.jpg)
4/7/2011 Thomas McMurtry
Point Data
• Locate Features along a route– USTM Nodes– Intersection MPs
![Page 27: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/27.jpg)
4/7/2011 Thomas McMurtry
Example
![Page 28: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/28.jpg)
4/7/2011 Thomas McMurtry
Example
• Output Table
• MEAS is the measure of the milepost along the route
![Page 29: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/29.jpg)
4/7/2011 Thomas McMurtry
Example
![Page 30: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/30.jpg)
4/7/2011 Thomas McMurtry
Final Product
![Page 31: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/31.jpg)
4/7/2011 Thomas McMurtry
Segment Data
• Make Route Event Layer
• Must have begin and end MP
• UDOT segments– Crash Segments– Traffic Volume Segments– Travel Model Segments– Maintenance Segments
![Page 32: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/32.jpg)
4/7/2011 Thomas McMurtry
Example
![Page 33: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/33.jpg)
4/7/2011 Thomas McMurtry
Example
• Used to calculated expected crash rates
• Used for identifying top 5 %• Used for prioritization
![Page 34: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/34.jpg)
4/7/2011 Thomas McMurtry
Segment Data
• Overlay Route Events – Combine multiple
segment breaks
![Page 35: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/35.jpg)
4/7/2011 Thomas McMurtry
Example
![Page 36: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/36.jpg)
4/7/2011 Thomas McMurtry
Example
• Creates a table with segments broken by all possible breaks
![Page 37: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/37.jpg)
4/7/2011 Thomas McMurtry
Example
• Creates a table
![Page 38: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/38.jpg)
4/7/2011 Thomas McMurtry
Value of LRS Tools
• Save Time• Accurately map referenced data• Accurately reference mapped data• Link data from multiple sources to one
data point• Create new valuable products
• Only State Routes
![Page 39: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/39.jpg)
4/7/2011 Thomas McMurtry
Value of LRS Tools
![Page 40: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/40.jpg)
4/7/2011 Thomas McMurtry
Lessons Learned
• There are some work arounds– Requires database work
• I typically don’t get the results I want on the first try
• Some need to verify Mileposts
• Break large data sets up
![Page 41: Using Utah's Linear Referencing GIS Layer: SGID93.Transportation.UDOTRoutes_LRS](https://reader038.vdocuments.us/reader038/viewer/2022103015/54bd9b824a7959337d8b4637/html5/thumbnails/41.jpg)
4/7/2011 Thomas McMurtry
Questions?
• Bert Granberg – [email protected]• Thomas McMurtry – [email protected]
Thank You