[pgrouting-users] problem with pgrouting.

Valeria Muñoz valemunoz at gmail.com
Wed Feb 4 14:07:42 EST 2009


  how can i get the distance,time, if you have to turn right o to turn
left??

RG


2009/2/4 Valeria Muñoz <valemunoz at gmail.com>

> Stephen you are right i change to :
>
>
> SELECT assign_vertex_id('edges', 0.000001, 'the_geom', 'gid');
>  and works!!! thanks!!
>
>
>
> 2009/2/4 Stephen Woodbridge <woodbri at swoodbridge.com>
>
> 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
>>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20090204/b9c071f6/attachment.html


More information about the Pgrouting-users mailing list