Hi, i'm starting with postgis and i'm looking for a "shortest path" good algorithm... right now i'm looking at pgRouting (http://pgrouting.postlbs.org) and pgRoute (http://www.pgroute.org this one is in spanish)... any other some one can suggest?
AFAIU, in both projects i need a edges table (seems like the roads table)... but for the table to be real it should be a table containing the edge between one intersection and another, right? so the edges table should be generated with a query like: """ select a.via_codigo, b.via_codigo, st_astext(st_intersection(a.the_geom, b.the_geom)) from gerg_via a, gerg_via b where st_intersects(a.the_geom, b.the_geom) and a.via_codigo <> b.via_codigo; """ -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL AsesorÃa y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
