I'm trying to make a matrix that shows the cost from a node to the rest of the nodes in a network.
The final result I'm looking for is not the cost, but only know if a car can or can not reach each vertex.
So, I've made a test in a small area of my network, and it seems to work perfectly. I get the cost from a node to the rest, and if can't reach it, only leaves the value as NULL, then I can set this value to false.
The problem is where I try to extend this methodology to the rest of the network, I get an error showing that the target vertex was not found.
Why is pgRouting saying this, if I'm doing the same analysis?
The steps I've followed are:
--creating topology ALTER TABLE "3prueba" ADD COLUMN "source" integer; ALTER TABLE "3prueba" ADD COLUMN "target" integer; SELECT pgr_createTopology('3prueba', 0.00001, 'geom', 'id'); --(I already have the cost field) --indexes CREATE INDEX vials3_source_indx ON calles("source"); CREATE INDEX vials3_target_indx ON calles("target"); --and create table "3catchment82" as select id, the_geom, (select sum(cost) from ( SELECT * FROM pgr_dijkstra(' SELECT id AS id, source::int4 AS source, target::int4 AS target, coste::float8 AS cost FROM "3prueba" where mostrar = 1 ', --
The final result I'm looking for is not the cost, but only know if a car can or can not reach each vertex.
So, I've made a test in a small area of my network, and it seems to work perfectly. I get the cost from a node to the rest, and if can't reach it, only leaves the value as NULL, then I can set this value to false.
The problem is where I try to extend this methodology to the rest of the network, I get an error showing that the target vertex was not found.
Why is pgRouting saying this, if I'm doing the same analysis?
The steps I've followed are:
--creating topology ALTER TABLE "3prueba" ADD COLUMN "source" integer; ALTER TABLE "3prueba" ADD COLUMN "target" integer; SELECT pgr_createTopology('3prueba', 0.00001, 'geom', 'id'); --(I already have the cost field) --indexes CREATE INDEX vials3_source_indx ON calles("source"); CREATE INDEX vials3_target_indx ON calles("target"); --and create table "3catchment82" as select id, the_geom, (select sum(cost) from ( SELECT * FROM pgr_dijkstra(' SELECT id AS id, source::int4 AS source, target::int4 AS target, coste::float8 AS cost FROM "3prueba" where mostrar = 1 ', --