PostGis and OSM data and pgRouting I want to put a route under maintenance

161 views Asked by At

I have osm data network that I make but in the country of the data there are so many routes is maintenance so distance is wrong how can I out something or boolean in column is_maintenance = true and it will only calculate routes from the other routes which is not is_maintenance = true

SELECT path_id, the_geom 
FROM pgr_ksp('
    SELECT gid as id, source, target, cost, reverse_cost
    FROM network
    WHERE is_maintenance = false', 
    ( 
        SELECT source 
        FROM network 
        ORDER BY the_geom <-> ST_SetSRID(St_point (0.0, 0.0), 4326)
        LIMIT 1
    ), 
    ( 
        SELECT target 
        FROM network 
        ORDER BY the_geom <-> ST_SetSRID(st_point (0.0, 0.0), 4326)
        LIMIT 1
    ),
    1, 
    false
) AS di
JOIN network pt ON (di.edge = pt.gid)
ORDER BY path_id, path_seq;
0

There are 0 answers