[pgrouting-users] problem with query results

[Valeria Muñoz]

Hi Daniel

yo agrege el campo ID a la consulta pero el orden en que me entrega los
resultados es el mismo.

query:
SELECT id,gid, the_geom FROM dijkstra_sp_delta( 'calle', 3414, 3406, 3000)

result:
"id";"gid";"the_geom"
2;4414;"0105000020B30F000001000000010200000002000000F9E3B4109BCC51C065E35F65B5973EC0656B43BC8ECC51C02D2D6B65B0973EC0"
3;4415;"0105000020B30F000001000000010200000002000000656B43BC8ECC51C02D2D6B65B0973EC018E60A2187CC51C007069A16AD973EC0"
1;*4416*
;"0105000020B30F00000100000001020000000200000018E60A2187CC51C007069A16AD973EC0AA2CA7847ECC51C0EB933A5AA9973EC0"
4;4417;"0105000020B30F000001000000010200000002000000AA2CA7847ECC51C0EB933A5AA9973EC04DFDF22B7ACC51C0FD7FB373A7973EC0"
 should be:

"id";"gid";"the_geom"

2;4414;"0105000020B30F000001000000010200000002000000F9E3B4109BCC51C065E35F65B5973EC0656B43BC8ECC51C02D2D6B65B0973EC0"
3;4415;"0105000020B30F000001000000010200000002000000656B43BC8ECC51C02D2D6B65B0973EC018E60A2187CC51C007069A16AD973EC0"
1;4416;"0105000020B30F00000100000001020000000200000018E60A2187CC51C007069A16AD973EC0AA2CA7847ECC51C0EB933A5AA9973EC0"
4;4417;"0105000020B30F000001000000010200000002000000AA2CA7847ECC51C0EB933A5AA9973EC04DFDF22B7ACC51C0FD7FB373A7973EC0

 I think I have problems with the data from the shapefile...

RG
2009/2/4 Daniel Kastl <kastl at orkney.co.jp>

> Hi Valeria,
>
> I never had the case of wrong ordered result, but you could add the "id"
> attribute to the select and order by it.
>
> For example:
> SELECT id, gid, AsText(the_geom) AS the_geom FROM astar_sp_delta('ways',
> 10, 20, 0.1);
>
> ... should return something like:
>
>  id  |  gid |         the_geom
>
> -----+-------+----------------------------------------------------------------------------------------------------------------
>   1 |     9 | MULTILINESTRING((18.421891 -33.9154821,18.4216313
> -33.9151594))
>   2 |     8 | MULTILINESTRING((18.4220472 -33.9156916,18.421891
> -33.9154821))
>   3 |     7 | MULTILINESTRING((18.4223323 -33.9159963,18.4220472
> -33.9156916))
>   4 |  2983 | MULTILINESTRING((...))
>   5 |  2982 | MULTILINESTRING((...))
>
> Also you might want to try to JOIN two tables this way if you need more
> than the standard returned attributes:
> http://pgrouting.postlbs.org/wiki/SQLTipsAndTricks
>
> Daniel
>
>
> Valeria Muñoz schrieb:
>  > Hi
> >
> > I have problems with the query results, The results are not sorted.
> >
> > my Query:
> >
> > SELECT rt.gid,rt.the_geom AS tg, 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', 3429, 3406, 3000) ) as rt
> > WHERE calle.gid=rt.gid;
> >
> > result:
> > "gid";"tg";"wkt";"length";"gid"
> >
> *4416*;"0105000020B30F00000100000001020000000200000018E60A2187CC51C007069A16AD973EC0AA2CA7847ECC51C0EB933A5AA9973EC0";"MULTILINESTRING((-71.1957476240572
> > -30.5924848676714,-71.1952220566333
> > -30.5924278634083))";0.000528649792432027;4416
> >
> *4414*;"0105000020B30F000001000000010200000002000000F9E3B4109BCC51C065E35F65B5973EC0656B43BC8ECC51C02D2D6B65B0973EC0";"MULTILINESTRING((-71.1969644323834
> > -30.5926116332152,-71.1962118776697
> > -30.5925353418981))";0.000756411899864822;4414
> >
> *4415*;"0105000020B30F000001000000010200000002000000656B43BC8ECC51C02D2D6B65B0973EC018E60A2187CC51C007069A16AD973EC0";"MULTILINESTRING((-71.1962118776697
> > -30.5925353418981,-71.1957476240572
> > -30.5924848676714))";0.00046698936208239;4415
> >
> *4417*;"0105000020B30F000001000000010200000002000000AA2CA7847ECC51C0EB933A5AA9973EC04DFDF22B7ACC51C0FD7FB373A7973EC0";"MULTILINESTRING((-71.1952220566333
> > -30.5924278634083,-71.194956767363
> > -30.5923988641007))";0.000266869550146504;4417
> > should be given A, B and C gave me B, A and C, then I can not generate
> > a guide of how to get from point A to B properly..
> >
> > Can sort the results?..please help..
> > RG
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > Pgrouting-users mailing list
> > Pgrouting-users at lists.postlbs.org
> > http://lists.postlbs.org/mailman/listinfo/pgrouting-users
> >
>
> _______________________________________________
> 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/20090205/5d0f9254/attachment.html