As I am pondering this problem...
It is multi-step. I do not think it can be accomplished in a single pass. WAY beyond what I have ever tried to accomplish... but here I go...
After all, it's only math and MUCH logic. Hopefully you smart folks can help contribute to this logic...
Otherwise, if not, it helps ME conceptualize and lay it out - as best I can - hoping to gain (get) insight.
Currently:
I have created and use Geo-Zones in my app for real time processing on the device. It will determine if speed is above set param while in this geo-zone (see pic above) - and create a record if it is... (reports speed violations - this zone is
30 MPH).
I am thinking, if I geo-zone the entire road (all 52 miles), in, let's say, 2 mile zones (26 in all)... I can then build a result set (for a 24 hour period - or whatever) that would tell me what vehicles were in each zone at every hour of the given day. Now I have a result set that tells me vehicles A,B,C were in Zone 1 between 8 - 9 am.
From this, were any of these vehicles AT the SAME lat/lon during this 1 hour time frame (give or take x seconds)? And, during this "meeting" was either vehicles speed > than "x"?
Why I ponder this at 11:55 pm (5 mins before 2017 - BC, Canada time) - is beyond me...
Anyway - HAPPY NEW YEAR!