gis
.road_graph
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
get_spatial_road(_road_code text)
Description
Build the road geometry for the given road id. It can then be used with ST_LocateAlong.
Parameters
Name
Type
Mode
_road_code
text
IN
Definition
DECLARE road_geom geometry(multilinestringM, 2154); BEGIN -- Get ordered edges for the road, then build the road geometry WITH ordered_ids AS ( SELECT * FROM road_graph.get_ordered_edges(_road_code, -1, 'downstream') ), build_geom AS ( SELECT ST_Collect(e.geom ORDER BY o.edge_order, e.start_cumulative) AS geom FROM road_graph.edges AS e INNER JOIN ordered_ids AS o ON e.id = o.id WHERE e.road_code = o.road_code ) SELECT INTO road_geom ST_AddMeasure(ST_Multi(r.geom), 0, ST_Length(r.geom)) AS geom FROM build_geom AS r ; RETURN road_geom; END;