HN - we're looking for some help. We have 500K Street Cleaning tickets from LA. Each ticket has the address of where the ticket was issued, and the date/time of when the ticket was issued.
From the time sequence of these tickets, we'd like to plot on a map the routes that the Street Cleaning Vehicles drive with the approximate start and stop times.
Complications: 1) At any given time, there could be multiple street cleaning vehicles out there. 2) Street Cleaning vehicles follow both daily/weekly/bi-weekly/monthly schedules 3) In general, the tickets are issued at roughly the same time that the street cleaning vehicle passes.... but sometimes it can be 10-15 minutes beforehand.
Okay, that's our problem... give us your best suggested solutions.
Thanks!