Tom White and Eliane Wigzell, July 2019
We analysed ticket data for the two machines in Crickhowell’s Long Stay car park from September 2017 to May 2019.
Our key findings are:
The summary statistics for ticket popularity, and busy times were performed with standard statistical analysis (see appendix). For analysing overcrowding we carried out a more involved analysis described next.
Each ticket sold is one of: 1 hour, 2 hour, 4 hour, all day - for cars. We ignored tickets for other categories of vehicle since the numbers are tiny in comparison with those for cars.
We considered the period from 8am to 6pm, since this is when charges apply. We made the simplifying assumption that each ticket was used for the full amount of time allowed, so for example a 2 hour ticket would be used for the full 2 hours. Of course, this is not a realistic assumption, since it overcounts vehicles that leave before the ticket expires. On the other hand, it undercounts vehicles that overstay, or those with no ticket at all. It’s not possible to estimate the relative importance of these two effects without further information (such as data from spot surveys).
With this assumption we created graphs showing the estimated number of cars in the car park over a day. (The blue lines in the graphs.)
We also looked at the rate of ticket sales over a short period of time (typically 30 minutes) and plotted this on the same graph (as an orange line).
For example, here is the graph for Thursday 4 April:
The blue line shows the number of cars in the car park (left scale). It starts at zero at 8am, and rises to about 80 just before 2pm, then drops off again.
The orange line shows the number of cars arriving (that tickets were bought for) in a 30 minute period (right scale). This is a bit more erratic, but the general pattern is that around 10 tickets per 30 minute period were bought in the morning (so about one every three minutes). Then there was a lunchtime peak of about 25 tickets per 30 minute period, at around 1pm, before dropping off in the afternoon.
Compare this with the graph for the late May Bank Holiday:
It’s clear that the car park was a lot busier on this day, as the peak estimated occupancy was around 140. (There are only 130 spaces, so the modelling assumption that everyone stayed for the full time on their ticket is clearly not true.) Notice the rapid drop in the orange line at midday, from over 40 tickets being sold per 30 minute period, to 10 tickets being sold per 30 minute period. Since the estimated occupancy was around 120 at this time, this rapid drop can be interpreted as the car park being full.
The key insight here is that we can detect when the car park is full by looking for very rapid drops in ticket sales.
From a visual scan of graphs for the data set, this happened on the following days in 2019:
Most are Saturdays, but Fridays are busy too.
Crickhowell had heavy snow on 1 February (a Friday), and it shows in very light car park usage:
And on Sunday 3 March Storm Freya hit, so few people ventured in to town:
A week later the usage was back to normal:
Which tickets are the most popular? 2 hour ones:
Tariff | Description.1 | n |
---|---|---|
105B | £1.30 LS 2 Hour | 45775 |
105A | £0.70 LS 1 Hour | 39089 |
105C | £2.50 LS 4 Hour | 21209 |
105D | £3.20 LS All Day | 14452 |
105E | £1.90 LS Trailer 1&2 Hour | 620 |
105J | £2.20 <3T 1 Hour | 266 |
105K | £2.90 <3T 2 Hour | 128 |
105Q | £2.40 >3T 1 Hour | 90 |
105L | £4.00 <3T All Day | 88 |
105F | £3.80 Trailer All Day | 26 |
105R | £3.40 >3T 2 Hour | 22 |
105DA | £6.40 LS +1 Day | 20 |
105U | £6.30 >3T Overnight | 14 |
105M | £6.30 <3T Overnight | 8 |
105T | £5.30 >3T All Day | 7 |
105G | £6.30 LS Trailer Night | 4 |
105S | £4.40 >3T 4 Hour | 3 |
105V | NA | 3 |
105DB | £9.60 LS +2 Day | 1 |
105W | NA | 1 |
105X | NA | 1 |
Average tickets sold by day:
day | average |
---|---|
Monday | 173.7667 |
Tuesday | 187.6264 |
Wednesday | 176.5275 |
Thursday | 201.7111 |
Friday | 231.0220 |
Saturday | 262.0111 |
Sunday | 115.6404 |
Average number of all day tickets sold per day:
day | average |
---|---|
Monday | 22.33333 |
Tuesday | 19.68132 |
Wednesday | 24.19780 |
Thursday | 24.73333 |
Friday | 23.74725 |
Saturday | 27.92222 |
Sunday | 17.60227 |
Overall:
average |
---|
22.90333 |
Average number of all day tickets sold per day before midday - shows that most are bought in the morning.
day | average |
---|---|
Monday | 20.11111 |
Tuesday | 17.70330 |
Wednesday | 21.51648 |
Thursday | 22.52809 |
Friday | 20.76923 |
Saturday | 21.80000 |
Sunday | 13.81609 |
During which months is the car park most busy? It’s busier in summer than in winter.
Which days of week are the most busy? Saturday is the busiest.
day | n |
---|---|
Saturday | 23581 |
Friday | 21023 |
Thursday | 18154 |
Tuesday | 17074 |
Wednesday | 16064 |
Monday | 15639 |
Sunday | 10292 |
At what time of day do people buy tickets? 12-1pm is the busiest hour.
Broken down by day.
Average number of tickets sold per day in financial year 2017-18:
This compares to 213 penalty charge notices (PCNs) issued over the same period in Crickhowell car park, an average of 0.6 per day, (maximum 5 on one day).