Hi List, I have a cities table and a roads table. I've already assign vertex id's and created graph tables. Now, how can I match the cities and the edges up to choose a city as source and another city as target and run shortest_path_dijsktra over those points?
Thanks a lot Pablo On Tue, Oct 28, 2008 at 2:38 PM, Pablo Tutino <[EMAIL PROTECTED]> wrote: > Dear Regina > Thank you for your help. > Right now I'm devolping using SharpMap. So I think I'm in the right way. > > > Pablo > > > On Tue, Oct 28, 2008 at 2:13 PM, Paragon Corporation <[EMAIL PROTECTED]> > wrote: > >> Pablo, >> You can try SharpMap. I haven't used it in a while, but it has a good >> PostGIS driver last time I used it as I recall, though I was using it in >> ASP.NET <http://asp.net/>, but I think it works in a desktop environment >> too. >> >> >> http://www.codeplex.com/SharpMap >> >> Another one is MapWindow, but I've never used that one and I think >> MapWindow is only for desktop development. >> http://www.mapwindow.org/ >> >> Hope that helps, >> Regina >> ------------------------------ >> *From:* [EMAIL PROTECTED] [mailto: >> [EMAIL PROTECTED] *On Behalf Of *Pablo >> Tutino >> *Sent:* Tuesday, October 28, 2008 11:57 AM >> *To:* PostGIS Users Discussion >> *Subject:* Re: [postgis-users] PostGis & pgRouting on Windows >> >> 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 >> >> > > > -- > Ing. Pablo Hernán Tutino > DIVENTI - Ingeniería y Desarrollo > [EMAIL PROTECTED] > www.diventi.com.ar > TE: +54-11-1569719001 > -- 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
