[postgis-users] PostGis & pgRouting on Windows

[Pablo Tutino]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081028/1bbaa47f/attachment.html>