Dear Stephen Thanks a lot for your help! Now let me ask one more question: Could you tell me the best .Net 2.0/3.0/3.5 framework for PostGis? I have to build a desktop application wich has tointeract with PostGis.
Best Regards Pablo On Mon, Oct 27, 2008 at 8:44 PM, Stephen Woodbridge <[EMAIL PROTECTED] > wrote: > 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 > -- 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
