[postgis-users] PostGis & pgRouting on Windows

[Anton Patrushev]

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
>
>