Spam:******, Re: [postgis-users] PostGis & pgRouting on Windows

[Pedro Doria Meunier]

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 <ptutino at gmail.com> 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 <ptutino at gmail.com> 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 <lr at pcorp.us> 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: postgis-users-bounces at postgis.refractions.net
>>>> [mailto:postgis-users-bounces at postgis.refractions.net] 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
>>>> <woodbri at swoodbridge.com> 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
>>>>> postgis-users at postgis.refractions.net
>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>>           
>>>>
>>>> --
>>>> Ing. Pablo Hernán Tutino
>>>> DIVENTI - Ingeniería y Desarrollo
>>>> pablo.tutino at diventi.com.ar
>>>> www.diventi.com.ar
>>>> TE: +54-11-1569719001
>>>>
>>>> _______________________________________________
>>>> postgis-users mailing list
>>>> postgis-users at postgis.refractions.net
>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>
>>>>         
>>>
>>> --
>>> Ing. Pablo Hernán Tutino
>>> DIVENTI - Ingeniería y Desarrollo
>>> pablo.tutino at diventi.com.ar
>>> www.diventi.com.ar
>>> TE: +54-11-1569719001
>>>       
>>
>> --
>> Ing. Pablo Hernán Tutino
>> DIVENTI - Ingeniería y Desarrollo
>> pablo.tutino at diventi.com.ar
>> www.diventi.com.ar
>> TE: +54-11-1569719001
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>>     
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>