[pgrouting-users] problem with pgrouting.

[Stephen Woodbridge]

Valeria,

What projection is your shapefile in? it looks like WGS84 or NAD83 from 
your coordinates below. So when you did:

SELECT assign_vertex_id('edges', 0.001, 'the_geom', 'gid');

you should probably have done:

SELECT assign_vertex_id('edges', 0.000001, 'the_geom', 'gid');

The tolerance needs to be in the units of your data. This will probably 
give better results.

You should probably drop the database and start over with a new load and 
use the statement above when you get to that step.

-Steve


Valeria Muñoz wrote:
> Hi
>  
> I followed a little tutorial works perfectly with the shapefile from the 
> example, but to use mine the result is not expected, generating lines 
> are not continuous, I think I missing some coordinates or something to 
> work with my shapefile.
>  
> tutorial url
> http://www.utdallas.edu/~ama054000/rt_tutorial.html
>  
> query:
>  
> the query is optimal path between 887 y 852. :
> SELECT rt.gid, AsText(rt.the_geom) AS wkt,
>                    length(rt.the_geom) AS length, calle.gid
>                 FROM calle,
>                     (SELECT gid, the_geom
>                         FROM dijkstra_sp_delta(
>                             'calle',
>                             887,
>                             852,
>                             3000)
>                      ) as rt
>                 WHERE calle.gid=rt.gid;
> result:
>  
> "gid";"wkt";"length";"gid"
> 4389;"MULTILINESTRING((-71.1951327440651 
> -30.5911350429583,-71.1957462426904 -30.5912128948402,-71.1957861853043 
> -30.591219747929,-71.1958400125164 
> -30.591211719682))";0.000713367403530106;4389
> 4603;"MULTILINESTRING((-71.1939954028678 
> -30.5921681162637,-71.1939834234752 -30.5922241673576,-71.1938231446269 
> -30.5925509466888))";0.000421286769021393;4603
> 4331;"MULTILINESTRING((-71.1950174992082 
> -30.5919506007811,-71.1950526139385 
> -30.5916919152203))";0.000261057969957178;4331
> 4608;"MULTILINESTRING((-71.1938231446269 
> -30.5925509466888,-71.1937648360013 
> -30.5926358138883))";0.00010296765211197;4608
> RG
> attached image.
>  
> please help!!..
> 
> ------------------------------------------------------------------------
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.postlbs.org
> http://lists.postlbs.org/mailman/listinfo/pgrouting-users