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;