Hi there, I'm Pablo Tutino, from Argentina. I've imported a Garmin .img DB files into polish format, then into shapes and finally into PostGis, using shp2pgsql.exe and QGIS. Now I have to create the directed graph up to use the pgRouting Library.
The first error I found is that the create_graph_tables wrapper function is not included neither in pgRouting windows binaries nor sources. I found the wrapper on this link ( http://postgis.refractions.net/pipermail/postgis-users/2007-April/015159.html ). The problem is the DB's schema I was able to import to PostGis is not like the one in the example, http://www.davidgis.fr/documentation/pgrouting-1.02/ . That schema includes id,source,target,x1,y1,x2,y2,cost,reverse_cost,oneway,length,rule,to_cost, but mine doesn't have x1,y1,x2,y2. How can I solve this? I mean: 1) How can I create a graph table from a schema containing only these fields: {gid integer NOT NULL,"LABEL" character varying(50),"TYPE" character varying(10),"LEVEL" character varying(9),the_geom geometry }? (the source, target and edge were created using assing_vertex_id function) 2) how can I use the correct create_schema_tables function? Thanks a lot Pablo -- Ing. Pablo Hernán Tutino DIVENTI - Ingeniería y Desarrollo [EMAIL PROTECTED] www.diventi.com.ar TE: +54-11-1569719001
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
