So i have the following data for over a month ( an app that registers all i do)
- On ( DateTime )
Now i am interested in creating a history on plotting the points on Google Maps, similar to this blog post
How would i do this? I thought to group the queries andadding a weight per radius every 5 minutes ( eg. within the 50 meter). So for every 5 minutes, the weight gets +1 in weight. The weight has no max.
- Then i would map it with Polylines on Google Maps so i have a pretty good overview.
- Add a circle with a width depending the radius on every "still point", eg. at work or swimming. The weight is on its largest at 5.
Any thoughts? How would you create the SQL Query to calculate the distance ( if anyone has experience with his)