Gibraltar Frontier Queue Stats
The border to drive out of Gibraltar into Spain can sometimes get inconveniencingly busy. While a live queue time report exists, I wanted to visualise historical data so I could plan travel accordingly. (i.e. avoid the periods of greatest traffic)
Data is scraped from the @gibraltarborder Twitter account. The text is parsed and normalised into a number of minutes at the tweet timestamp and is stored into Google's Big Query Database. Running costs are less than $1/m. Currently have 18,000 data points.
The output is a simple React app, using Charts.js pulling data from Google App Engine hosted Server API. The server side queries and aggregates all the random time points to average out queue times per hour. Query results are then cached to avoid recalculation each request.
With enough data, I intend to provide a live time based future forecast of what the queue is likely to be in the next coming hours, using hour/day/week/month based seasonality.