We have a customer in San Francisco who wanted to be able to reconcile the # of trips they make across the Bay Bridge (since they pay a toll when coming into the city).
Here is a picture of the landmark they defined (along with a nice 3D representation in Google Earth):
We added a “Passing Through” option to our standard landmark report to help with this requirement. Before this, the landmark visit would have required the vehicle to either stop or idle for a minute to register. If you click the “Passing Through” checkbox, it will count any activity through that “zone.”
Now when running the report (which took less than 3 seconds), you get each time a vehicle went through that area (I’ve blurred out the vehicle names for customer privacy).
This makes it easy to see that 7 vehicles went a total of 23 times across the Bay Bridge.
But how many tolls is that?
You only get charged on the way INTO the city. Exporting that report to Excel gives us some additional information such as heading (what direction the trip took through the landmark). So only Southwest trips should incur a toll. That shows 8 of them according to this Excel Screenshot:
We added Heading as well to the exported version of the report. Since space isn’t at a premium in Excel, we usually put all columns into the exported versions of the reports there.
This helps our customer, & I thought it would be worth detailing here in case other customers can think of a good use for this.
Thanks,
Rob.




