[postgis-users] PostGis & pgRouting on Windows

[Stephen Woodbridge]

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/