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