gis.road_graph

Parameters

Name	Type	Mode
_geometry_type	text	IN
_table_cols	text[]	IN
_geometry_column	text	IN

Definition

DECLARE
    start_marker_field text;
    start_abscissa_field text;
    end_marker_field text;
    end_abscissa_field text;
    has_cumulative boolean;
BEGIN
    IF lower(_geometry_type) = 'point' THEN
        start_marker_field = 'mo.marker_code';
        start_abscissa_field = 'mo.abscissa';
        end_marker_field = 'mo.marker_code';
        end_abscissa_field = 'mo.abscissa';
        has_cumulative = 'cumulative' = ANY(_table_cols);
    ELSE
        start_marker_field = 'mo.start_marker_code';
        start_abscissa_field = 'mo.start_abscissa';
        end_marker_field = 'mo.end_marker_code';
        end_abscissa_field = 'mo.end_abscissa';
        has_cumulative = _table_cols && ARRAY['start_cumulative', 'end_cumulative']::text[];
    END IF;

-- The objects which may be impacted are:
    -- * the objects without references,
    -- * the objects located near the modified edges,
    -- * if the geometry of the road has changed, the objects located downstream of the first modified point:
    --   up to the end of the road if the table has a cumulative field,
    --   or else up to the last marker of the modified edges, since the abscissas are measured from the markers
    -- * the objects between the previous marker and a modified marker
    RETURN format(
        $SQL$
        EXISTS (
            SELECT 1
            FROM jsonb_to_recordset($1) AS i (
                road_code text, whole_road boolean, geometry_changed boolean,
                start_marker_code integer, start_abscissa real, end_marker_code integer,
                near_geom text, marker_ranges jsonb
            )
            WHERE i.road_code = trim(mo.road_code)::text
            AND (
                i.whole_road
                OR %1$s IS NULL OR %2$s IS NULL OR %3$s IS NULL OR %4$s IS NULL
                OR ST_DWithin(mo.%5$I, ST_GeomFromEWKB(decode(i.near_geom, 'hex')), 50)
                OR (
                    i.geometry_changed
                    AND (%3$s, %4$s) >= (i.start_marker_code, i.start_abscissa)
                    AND (%6$s OR %1$s <= i.end_marker_code)
                )
                OR EXISTS (
                    SELECT 1
                    FROM jsonb_array_elements(i.marker_ranges) AS r
                    WHERE %1$s <= (r->>1)::integer AND %3$s >= (r->>0)::integer
                )
            )
        )
        $SQL$,
        start_marker_field,
        start_abscissa_field,
        end_marker_field,
        end_abscissa_field,
        _geometry_column,
        CASE WHEN has_cumulative THEN 'TRUE' ELSE 'FALSE' END
    );
END;

get_managed_objects_impacts_filter(_geometry_type text, _table_cols text[], _geometry_column text)

Description

Parameters

Definition