Cycle Count Database

The Cycle count database front end is finally ready and can be accessed HERE. It took a while to develop a google sheet database that is not only easier to input the collected cycle count data but also quickly do the analysis an present the data. 

Now all the task are automated after entry of the count data from the from the sample of which is here

The main goal here is to know the average and peak hourly cycle count data. 

 

We have divided the count data into 3 different time blocks based on mobility dynamics. For example peak time is the time when most of the commuting occurs. So we need a separate average and peak data for it. Again in weekends there is no off hours and peak hours but consistent vehicle movement throughout the day. Here there is no or limited commuting, but people travel in weekend for recreational or personal reasons. 

VERSION 1

This here is the first version of the cycle count data.

 

We cannot have a single average cycle count value because average between peak, off and weekend value will depend on length of time of survey for specific block, hence the average cycle count value can be skewed. For example if the no of survey hours for peak hours is higher then this will increase the average significantly. 

 

VERSION 2

But same is not true for gender distribution, cycle type and lane distribution. So in the second version a average count column was added for these value