[postgis-users] PostGis & pgRouting on Windows

[Pablo Tutino]

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 <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:* 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081110/7a9b93f5/attachment.html>