Anton,
I didn't even know PgRouting had a list. I'll have to join that one.
Personally I don't mind getting PgRouting questions on PostGIS list, mostly
because
the traffic on PostGIS is not that high enough yet and its kind of educational
to learn about
related projects that you don't know much about.
However if the traffic on PostGIS were higher - I would be a bit irritated.
For example
I find it irritating to get PostGIS questions on OpenLayers lists or PostGIS
questions on PostgreSQL lists which are already too hard to keep up with as it
is with just their stuff.
With that said - I guess people if they have obvious PgRouting questions should
target the PgRouting list and if they feel there is a marginal overlap also cc
the PostGIS list. Heck I personally don't care if you cc the PostGIS list on
PgRouting questions :).
Thanks,
Regina
-----Original Message-----
From: [EMAIL PROTECTED] on behalf of Anton Patrushev
Sent: Mon 11/10/2008 9:15 PM
To: PostGIS Users Discussion
Subject: Re: Spam:******, Re: [postgis-users] PostGis & pgRouting on Windows
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
>>>>>> postgis-users@postgis.refractions.net
>>>>>> 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
>>>>> postgis-users@postgis.refractions.net
>>>>> 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
>>> postgis-users@postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>>
>>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users@postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer._______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
