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?