yes, i want to calculate the linesegmens between the two points. What if i have the predefined route so that the update points will be located along the route. can i solve it without dealing with routing?
Nicklas Av� wrote: > > Hallo To just get the distance between the points you could do with > something like select ST_Distance(a.the_geom, b.the_geom) as dist from > pointtable a inner join pointtable b on a.gid = b.gid+1 if your gid value > is in integer and ordered chronlogically > But I guess that what you want is the length of the linesegments between > two points. That can be more tricky because if you have passed two > crossings during that minute you might have alternative paths. So then you > are dealing with routing. /Nicklas > 2010-01-14 searchelite wrote: > > >>Hi All.. >> >>I have two tables which are street and update_points. Assuming that the >>update interval is every one minute, how to calculate the distance between >>two update point in the street segments (the points are already interpolated >>into the segments) >> >>Thanks in advance >>-- >>View this message in context: http://old.nabble.com/calculate-distance-between-points-tp27161415p27161415.html >>Sent from the PostGIS - User mailing list archive at Nabble.com. >> >>_______________________________________________ >>postgis-users mailing list >>[email protected] >>http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- View this message in context: http://old.nabble.com/calculate-distance-between-points-tp27161415p27162975.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
