[postgis-users] calculate distance between points

[searchelite]

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
>>postgis-users at postgis.refractions.net
>>http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> 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.