<div dir="ltr">Hi Raghavan,<div><br></div><div>Your GPS data contains a timestamp for each point, right?</div><div>So you could first import your points into a table and then make a LineString from your points, ordered by time.</div>
<div><br></div><div><font face="courier new, monospace">SELECT ST_MakeLine(pnt_geom) AS geom </font></div><div><font face="courier new, monospace"> FROM gpstrack ORDER BY timestamp;</font><br></div><div><br></div><div>
And then you could simplify your Linestring to make it look more straight.</div><div>That's also a PostGIS function: <a href="http://postgis.net/docs/ST_Simplify.html">http://postgis.net/docs/ST_Simplify.html</a></div>
<div><br></div><div>Daniel</div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Apr 9, 2014 at 12:46 PM, Raghavan Krishnasamylakshmanaperumal <span dir="ltr"><<a href="mailto:rkrish20@uic.edu" target="_blank">rkrish20@uic.edu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">I have Runkeeper.com raw GPS traces . I used pgr_nodeNetwork and pgr_createTopology to create graph out of this data.<div>
<br></div><div>If I want to match an activity(a user's running record) which has raw GPS traces with the edge formed out of it, is there any function in PGRouting which can help me to figure out this edge? If there are some edges missing due to threshold limits I am fine with it.</div>
<div><br></div><div>To make it more clear let me also explain my question with a picture attached in this email, the black dots are gps traces of my running activity, then I used PGRouting to form a graph with this data(just an assumption). The green line is the edge corresponding to the black dotted gps traces. Now I need to find this green edge matching these black dots programmatically.</div>
<div><br></div><div>So is there any library available in PGRouting which can help me to match these raw GPS traces to find its corresponding edge?<span class="HOEnZb"><font color="#888888"><br></font></span></div><span class="HOEnZb"><font color="#888888"><div>
<br></div><div><br clear="all"><div><br></div>-- <br>Thanks and Regards,<div>
Raghavan KL</div>
</div></font></span></div>
<br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr">
<span style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse">Georepublic UG & Georepublic Japan<br>eMail: <a href="mailto:daniel.kastl@georepublic.de" style="color:rgb(66,99,171)" target="_blank">daniel.kastl@georepublic.de</a><br>
Web: <a href="http://georepublic.info" style="color:rgb(66,99,171)" target="_blank">http://georepublic.info</a></span></div>
</div>