Hi Pedro, Yeah, sure, pgRouting is connected to PostGIS, PostGIS is connected to PostgreSQL... I'm not talking about making borders. If PostGIS people don't mind about having those questions here - I don't ming either.
I just thought that for users and developers of pgRouting (which is tinny little project) it is not really convenient to refer to a mailing list of such huge project as PostGIS in case of any troubles. I also feel lonely if nobody writes to my mailing list and forum :) Anyway, it is off topic. Anton. On Tue, Nov 11, 2008 at 10:52 AM, Pedro Doria Meunier <[EMAIL PROTECTED]> wrote: > Hey Anton, > > Let me be the devil's advocate here ... > IMHO pgRouting and PostGIS are intimately connected although I recognize the > need for separate themes. > > Were it not the (valuable) help from people as, say, Regina Obe, in the > PostGIS community clarifying many user's question we wouldn't even be at the > point of discussing pgRouting. > > Again, IMHO, this is (thank God) a very open and broad(/bright)-minded > community whose sole purpose is to help each other. Let's not draw hard > borders in a planet that suffers from having them, ok? > > Regards, > Pedro Doria Meunier. > > Anton Patrushev wrote: >> >> Hi Pablo, >> >> Probably by coordinates. It is difficult to tell without knowing your >> data structure. >> By the way, pgRouting has its own mailing list and support forum. I >> don't think it is nice to bug PostGIS people with pgRouting questions. >> >> Anton. >> >> On Tue, Nov 11, 2008 at 4:06 AM, Pablo Tutino <[EMAIL PROTECTED]> wrote: >> >>> >>> 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, 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 >>> >>> >>> >> >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
