Uploaded August 2026 | Updated September 2026, 2 weeks ago
How do you model and query assets, incidents, and conditions that occur along a route rather than at a fixed latitude and longitude?
In this session, learn how Linear Referencing Systems (LRS) in Oracle AI Database use measured geometries and M-values to represent locations along roads, rivers, pipelines, railways, and utility networks.
The session explains how developers can:
- Model routes using measured geometries
- Locate points and events by distance along a route
- Find the measure value of a point
- Represent point and line events without storing every segment separately
- Use dynamic segmentation to create route sections on demand
- Query route-based assets and incidents with SQL
- Apply Oracle Spatial SDO_LRS functions to real-world data
- Build measured route views for rivers, pipelines, and other networks
The demonstrations cover highway mile markers, a leaking valve beyond a pumping station, river stations, pipeline routes, administrative boundaries, and anomaly segments.
By the end of the session, you will understand when linear referencing is more useful than coordinate-based locations and how to build measured, queryable route assets in Oracle AI Database.
AskTOM:
asktom.oracle.com
Explore Oracle Spatial:
oracle.com/database/spatial
Chapters:
00:00 Introduction to Linear Referencing Systems
02:30 Why locate assets by measure?
06:00 LRS fundamentals: routes, measures, and shape points
12:00 Geometric segments and measure values
18:00 Real-world LRS patterns for assets and events
24:00 Defining a measured route with Oracle SQL
29:00 SDO_LRS functions: locate, project, split, and analyze
34:30 Dynamic segmentation with the Brazos River
40:30 Building a river-stations LRS view
51:00 Defining a pipeline route and populating measures
58:00 Creating anomaly segments and route metadata
01:05:30 Key takeaways and wrap-up
#OracleAIDatabase #OracleSpatial #LinearReferencing #SpatialSQL
How do you model and query assets, incidents, and conditions that occur along a route rather than at a fixed latitude and longitude?
In this session, learn how Linear Referencing Systems (LRS) in Oracle AI Database use measured geometries and M-values to represent locations along roads, rivers, pipelines, railways, and utility networks.
The session explains how developers can:
- Model routes using measured geometries
- Locate points and events by distance along a route
- Find the measure value of a point
- Represent point and line events without storing every segment separately
- Use dynamic segmentation to create route sections on demand
- Query route-based assets and incidents with SQL
- Apply Oracle Spatial SDO_LRS functions to real-world data
- Build measured route views for rivers, pipelines, and other networks
The demonstrations cover highway mile markers, a leaking valve beyond a pumping station, river stations, pipeline routes, administrative boundaries, and anomaly segments.
By the end of the session, you will understand when linear referencing is more useful than coordinate-based locations and how to build measured, queryable route assets in Oracle AI Database.
AskTOM:
asktom.oracle.com
Explore Oracle Spatial:
oracle.com/database/spatial
Chapters:
00:00 Introduction to Linear Referencing Systems
02:30 Why locate assets by measure?
06:00 LRS fundamentals: routes, measures, and shape points
12:00 Geometric segments and measure values
18:00 Real-world LRS patterns for assets and events
24:00 Defining a measured route with Oracle SQL
29:00 SDO_LRS functions: locate, project, split, and analyze
34:30 Dynamic segmentation with the Brazos River
40:30 Building a river-stations LRS view
51:00 Defining a pipeline route and populating measures
58:00 Creating anomaly segments and route metadata
01:05:30 Key takeaways and wrap-up
#OracleAIDatabase #OracleSpatial #LinearReferencing #SpatialSQL
