I am attempting to follow Anita Grazer's post on creating alpha shapes in pgRouting.
The article was written several years ago, so some of the functions have been updated and names have changed. I have updated the code and it all appears to work fine apart from the last step. I am getting the following error for the last three lines of code:
"ERROR: missing FROM-clause entry for table "home_catchment10km""
CREATE TABLE "os_m2".home_catchment10km ASSELECT * FROM "os_m2"."m2_roads_vertices_pgr" JOIN (SELECT * FROM pgr_drivingdistance(' SELECT gid AS id, source, target, cost_time AS cost FROM "os_m2"."m2_roads"', 674062, 600, false, false)) AS route ON "m2_roads_vertices_pgr".id = route.id1 CREATE TABLE "os_m2".home_isodist (id serial, max_cost double precision); SELECT addgeometrycolumn('os_m2','home_isodist','the_geom2',27700,'POLYGON',2);INSERT INTO "os_m2".home_isodist (max_cost,the_geom2)SELECT 600, pgr_alphashape( 'SELECT id, ST_X("home_catchment10km".the_geom) AS x, ST_Y("home_catchment10km".the_geom) AS y FROM "os_m2".home_catchment10km where cost < 600');INSERT INTO "os_m2".home_isodist (max_cost, the_geom2) (SELECT 600, ST_SetSRID("home_catchment10km"."the_geom",27700)
The article was written several years ago, so some of the functions have been updated and names have changed. I have updated the code and it all appears to work fine apart from the last step. I am getting the following error for the last three lines of code:
"ERROR: missing FROM-clause entry for table "home_catchment10km""
CREATE TABLE "os_m2".home_catchment10km ASSELECT * FROM "os_m2"."m2_roads_vertices_pgr" JOIN (SELECT * FROM pgr_drivingdistance(' SELECT gid AS id, source, target, cost_time AS cost FROM "os_m2"."m2_roads"', 674062, 600, false, false)) AS route ON "m2_roads_vertices_pgr".id = route.id1 CREATE TABLE "os_m2".home_isodist (id serial, max_cost double precision); SELECT addgeometrycolumn('os_m2','home_isodist','the_geom2',27700,'POLYGON',2);INSERT INTO "os_m2".home_isodist (max_cost,the_geom2)SELECT 600, pgr_alphashape( 'SELECT id, ST_X("home_catchment10km".the_geom) AS x, ST_Y("home_catchment10km".the_geom) AS y FROM "os_m2".home_catchment10km where cost < 600');INSERT INTO "os_m2".home_isodist (max_cost, the_geom2) (SELECT 600, ST_SetSRID("home_catchment10km"."the_geom",27700)