distance

Shawn is always worried about turning our little unit off when he gets near his house.

Since we need the ability to set a perimiter around a point - I thought it was a good time to learn Functions within SQL Server, and to implement the Haversine formula for distance between two points.

Read up on Functions - and got to work.

we now have one for the derivation of distance between two points.

from there we have one for all points within a specified proximity

and from that one - deletion of points within another point and some distance.

The latter is mostly for house keeping.


Now - problem is it takes quite a little bit of time [several seconds] to process a few thousand rows - which is a little slow.

So I might just have to re-write it with CLR.

----

I also drove to Gerringong after uni and from there to Sydney. Will be quite interesting to see the playback of the trip.

And as Shawn's post already states - this was the first drive that was 'visible' live. Now we just have to work out the quirks.

I will have a look now at the performance of getNextPoint vs getLastPoint, see if I can somehow improve it.