[postgis-users] PostGis & pgRouting on Windows

[Paragon Corporation]

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.ht
ml).

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081028/b5e21277/attachment.html>