<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16735" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=578421016-28102008><FONT face=Arial
color=#0000ff size=2>Pablo,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=578421016-28102008><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=578421016-28102008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=578421016-28102008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=578421016-28102008><FONT face=Arial
color=#0000ff size=2><A
href="http://www.codeplex.com/SharpMap">http://www.codeplex.com/SharpMap</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=578421016-28102008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=578421016-28102008><FONT face=Arial
color=#0000ff size=2>Another one is MapWindow, but I've never used that one and
I think MapWindow is only for desktop development.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=578421016-28102008><FONT face=Arial
color=#0000ff size=2><A
href="http://www.mapwindow.org/">http://www.mapwindow.org/</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=578421016-28102008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=578421016-28102008></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2>Hope that helps,</FONT></FONT></FONT></DIV>
<DIV><FONT><FONT color=#0000ff><FONT size=2><SPAN
class=578421016-28102008></SPAN></FONT></FONT></FONT><SPAN
class=578421016-28102008></SPAN><FONT face=Arial><FONT color=#0000ff><FONT
size=2>R<SPAN
class=578421016-28102008>egina</SPAN></FONT></FONT></FONT><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Pablo
Tutino<BR><B>Sent:</B> Tuesday, October 28, 2008 11:57 AM<BR><B>To:</B> PostGIS
Users Discussion<BR><B>Subject:</B> Re: [postgis-users] PostGis & pgRouting
on Windows<BR></FONT><BR></DIV>
<DIV></DIV>Dear Stephen
<DIV><BR></DIV>
<DIV>Thanks a lot for your help!</DIV>
<DIV>Now let me ask one more question: </DIV>
<DIV>Could you tell me the best .Net 2.0/3.0/3.5 framework for PostGis?</DIV>
<DIV>I have to build a desktop application wich has tointeract with
PostGis.</DIV>
<DIV><BR></DIV>
<DIV>Best Regards</DIV>
<DIV><BR></DIV>
<DIV>Pablo</DIV>
<DIV><BR><BR>
<DIV class=gmail_quote>On Mon, Oct 27, 2008 at 8:44 PM, Stephen Woodbridge <SPAN
dir=ltr><<A
href="mailto:woodbri@swoodbridge.com">woodbri@swoodbridge.com</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<DIV>
<DIV></DIV>
<DIV class=Wj3C7c>Pablo Tutino wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi
there,<BR><BR>I'm Pablo Tutino, from Argentina.<BR>I've imported a
Garmin .img DB files into polish format, then into shapes and finally into
PostGis, using shp2pgsql.exe and QGIS.<BR>Now I have to create the directed
graph up to use the pgRouting Library.<BR><BR>The first error I found is
that the create_graph_tables wrapper function is not included neither in
pgRouting windows binaries nor sources.<BR>I found the wrapper on this link
(<A
href="http://postgis.refractions.net/pipermail/postgis-users/2007-April/015159.html"
target=_blank>http://postgis.refractions.net/pipermail/postgis-users/2007-April/015159.html</A>).<BR><BR>The
problem is the DB's schema I was able to import to PostGis is not like the
one in the example, <A
href="http://www.davidgis.fr/documentation/pgrouting-1.02/"
target=_blank>http://www.davidgis.fr/documentation/pgrouting-1.02/</A>.<BR><BR>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.<BR><BR>How can I solve this?<BR>I mean:
1) How can I create a graph table from a schema containing only these
fields:<BR>{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)<BR><BR>2) how can I use the correct create_schema_tables
function?<BR><BR>Thanks a lot Pablo<BR><BR></BLOCKQUOTE><BR></DIV></DIV>alter
table mytable add column x1 float;<BR>alter table mytable add column y1
float;<BR>alter table mytable add column x2 float;<BR>alter table mytable add
column y2 float;<BR>update mytable set<BR> x1 =
x(st_startpoint(the_geom)),<BR> y1 =
y(st_startpoint(the_geom)),<BR> x2 = x(st_endpoint(the_geom)),<BR>
y2 = y(st_endpoint(the_geom));<BR>vacuum analyze mytable;<BR><BR>Should
probably do it.<BR><BR>-Steve<BR> <A href="http://imaptools.com/"
target=_blank>http://imaptools.com/</A><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR></BLOCKQUOTE></DIV><BR><BR
clear=all><BR>-- <BR>Ing. Pablo Hernán Tutino<BR>DIVENTI - Ingeniería y
Desarrollo<BR><A
href="mailto:pablo.tutino@diventi.com.ar">pablo.tutino@diventi.com.ar</A><BR><A
href="http://www.diventi.com.ar">www.diventi.com.ar</A><BR>TE:
+54-11-1569719001<BR></DIV></BODY></HTML>