Pablo Tutino wrote:
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
alter table mytable add column x1 float;
alter table mytable add column y1 float;
alter table mytable add column x2 float;
alter table mytable add column y2 float;
update mytable set
x1 = x(st_startpoint(the_geom)),
y1 = y(st_startpoint(the_geom)),
x2 = x(st_endpoint(the_geom)),
y2 = y(st_endpoint(the_geom));
vacuum analyze mytable;
Should probably do it.
-Steve
http://imaptools.com/
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
