Creating Isochrones - pgr_drivingDistance 2.6 SQL error

Question

Im trying to create a matrix of driving distances from an osm2pgrouting parsed dataset.

Following many blogs I have the below incorrect SQL:

SELECT * from ways join (
SELECT
*
FROM
pgr_drivingDistance(
    'SELECT gid as id
        , source
        , target
        , length_m as cost FROM "ways"
        '
    ,274738,500,FALSE)
) as route on ways.gid = route.id

I get the error " ROUTE.ID" does not exist. This seems sensible since the pgRouting docs for 2.62 show no field returned in the examples called ID.

If I replace route.ID with say route.seq (a column PG driving distance does return) i get a very dodgy result with points random scattered over the map.

What is the equivalent of ID or what do i need to change to get a proper matric returned of points with 500m?

Answer 1

so after some manual checking here is a workin answer for people using OSM with the latest versions of the tools (OSM2pgsql and routing 2.62)

bascially way.target = route.node

    SELECT * from ways join (
SELECT * from pgr_drivingDistance(
        'SELECT gid as id
        , source
        , target
        , length_m as cost FROM "ways"      '
        ,274738,500,FALSE)
) as route on ways.target = route.node