[postgis-users] PostGis & pgRouting on Windows

Pablo Tutino ptutino at gmail.com
Tue Oct 28 09:38:47 PDT 2008


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 <lr at pcorp.us> 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:* 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.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 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
>
> _______________________________________________
> 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/fb2ac31e/attachment.html>


More information about the postgis-users mailing list