<html>
<head>
<title></title>
<meta name="GENERATOR" content="MSHTML 8.00.6001.18854"></meta>
</head>
<body>Hallo
<div align="left"> </div>
<div align="left"> </div>
<div align="left">To just get the distance between the points you could do with something like</div>
<div align="left"> </div>
<div align="left">select ST_Distance(a.the_geom, b.the_geom) as dist from pointtable a inner join pointtable b on a.gid = b.gid+1</div>
<div align="left"> </div>
<div align="left">if your gid value is in integer and ordered chronlogically<br />
</div>
<div align="left">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.</div>
<div align="left"> </div>
<div align="left">/Nicklas</div>
<div align="left"><br />
2010-01-14 searchelite wrote:<br />
<br />
<br />
>Hi All..<br />
><br />
>I have two tables which are street and update_points. Assuming that the<br />
>update interval is every one minute, how to calculate the distance between<br />
>two update point in the street segments (the points are already interpolated<br />
>into the segments)<br />
><br />
>Thanks in advance<br />
>-- <br />
>View this message in context: http://old.nabble.com/calculate-distance-between-points-tp27161415p27161415.html<br />
>Sent from the PostGIS - User mailing list archive at Nabble.com.<br />
><br />
>_______________________________________________<br />
>postgis-users mailing list<br />
>postgis-users@postgis.refractions.net<br />
>http://postgis.refractions.net/mailman/listinfo/postgis-users<br />
><br />
></div>
</body>
</html>