Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Im using TRSP routing algo. I want to skip partially start and end segment part for point to point routing. Percent along start edge 0.6, percent along end edge 0.4. Route generated but start and end segment is not partially skipped.

Please help me. My query is as below.

select * from turn_restrict_shortest_path(
    'select gid as id, source::integer, target::integer,cost_fastest as cost, reverse_cost 
    from centre_line',
    17271,     -- edge_id for start
    0.6,   -- midpoint of edge
    14345,     -- edge_id of route end
    0.4,   -- midpoint of edge
    false,  -- directed graph?
    true,  -- has_reverse_cost?
    null)  -- no turn restrictions
share|improve this question
Can you post query results both with and without skipping in the beginning? (The first few lines should be enough.) – underdark Jun 11 '12 at 6:44

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.