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
