Difference between revisions of "Car Park Overspill Study PROJECT DOCUMENTATION"

From Analytics Practicum
Jump to navigation Jump to search
Line 38: Line 38:
 
# Conclusion
 
# Conclusion
 
“Executive Summary” gives a brief overview of the report and its conclusion. “Site Background”, “Site Characteristics” and “Site Assessment” provides the basic information of the site, such as the nature, the size, the transportation availability of the site and etc. Our focus is on “Survey Findings” which uses the data collected on both weekday and weekend at the site to generate some insights. The generated insights elaborate on the vehicles traffic pattern, the human traffic during different period of the day and most importantly whether there is overspill, this helps LTA understands the utilization rate of the car park and make certain adjustments in the future.
 
“Executive Summary” gives a brief overview of the report and its conclusion. “Site Background”, “Site Characteristics” and “Site Assessment” provides the basic information of the site, such as the nature, the size, the transportation availability of the site and etc. Our focus is on “Survey Findings” which uses the data collected on both weekday and weekend at the site to generate some insights. The generated insights elaborate on the vehicles traffic pattern, the human traffic during different period of the day and most importantly whether there is overspill, this helps LTA understands the utilization rate of the car park and make certain adjustments in the future.
 +
=== Actual Deliverables ===
 +
By the end of the preliminary phase, our group has finished 5 final reports as planned at the beginning of the project. These 5 final reports are:
 +
* Final Report - Greenwood Ave & Hillcrest Rd
 +
* Final Report - Vivocity
 +
* Final Report - Frankel Ave
 +
* Final Report - Jalan Mata Ayer
 +
* Final Report - Yuhua Market & Hawker Centre
 +
== Preprocessing Data ==
 +
=== Data Exploration ===
 +
There are 55 sites in total, each site has a dataset containing development human headcount data and the development car park (if any) vehicle count data during survey period. A typical car park dataset contains the following information: No. of cars parked in season lots, No. of cars in the car park, No. of Overspills. Survey time spans from 7am to 10am. Data is collected in 15 minutes interval during the survey time. Same data collecting frequency applied to human count, human count dataset rather contains the following information: human count in and human count out within each time interval. We had following findings:
 +
* Difficulty in counting the real headcount in surveyed development
 +
A primary problem of the collected data is that we cannot assure the real headcount in the development, as in most cases, there is no record of current human count in the development. Therefore, human count in and out data record just provide us the human traffic information. Besides, we found in many datasets, there is one or more record gap(s) between two time intervals with the human traffic recorded. This further increases the difficulty of finding real headcount in a development building.
 +
* Insufficiency of collected raw data
 +
We also realised that for each surveyed site, there are only two days of records.one set is for weekday and the other is for weekend. Having insufficient data would lower the confidence of collected data in representing the ordinary situation happens in the surveyed site everyday.

Revision as of 18:01, 28 February 2016


HOME

TEAM

PROJECT OVERVIEW

PROJECT MANAGEMENT

Click-here.png DETAILS & DOCUMENTATION


Preliminary Phase

Scope

Our sponsor requires us to finish 5 final reports of different development sites during the preliminary phase of our project. The necessary data and infographics are prepared by the sponsor and his tea, our job scope is to compile the report using the sample template and interpret the data to generate some insights which can be helpful for LTA future planning. A typical final report contains the following components:

  1. Executive Summary
  2. Site Background
  3. Site Characteristics
  4. Site Assessment
  5. Survey Findings
  6. Conclusion

“Executive Summary” gives a brief overview of the report and its conclusion. “Site Background”, “Site Characteristics” and “Site Assessment” provides the basic information of the site, such as the nature, the size, the transportation availability of the site and etc. Our focus is on “Survey Findings” which uses the data collected on both weekday and weekend at the site to generate some insights. The generated insights elaborate on the vehicles traffic pattern, the human traffic during different period of the day and most importantly whether there is overspill, this helps LTA understands the utilization rate of the car park and make certain adjustments in the future.

Actual Deliverables

By the end of the preliminary phase, our group has finished 5 final reports as planned at the beginning of the project. These 5 final reports are:

  • Final Report - Greenwood Ave & Hillcrest Rd
  • Final Report - Vivocity
  • Final Report - Frankel Ave
  • Final Report - Jalan Mata Ayer
  • Final Report - Yuhua Market & Hawker Centre

Preprocessing Data

Data Exploration

There are 55 sites in total, each site has a dataset containing development human headcount data and the development car park (if any) vehicle count data during survey period. A typical car park dataset contains the following information: No. of cars parked in season lots, No. of cars in the car park, No. of Overspills. Survey time spans from 7am to 10am. Data is collected in 15 minutes interval during the survey time. Same data collecting frequency applied to human count, human count dataset rather contains the following information: human count in and human count out within each time interval. We had following findings:

  • Difficulty in counting the real headcount in surveyed development

A primary problem of the collected data is that we cannot assure the real headcount in the development, as in most cases, there is no record of current human count in the development. Therefore, human count in and out data record just provide us the human traffic information. Besides, we found in many datasets, there is one or more record gap(s) between two time intervals with the human traffic recorded. This further increases the difficulty of finding real headcount in a development building.

  • Insufficiency of collected raw data

We also realised that for each surveyed site, there are only two days of records.one set is for weekday and the other is for weekend. Having insufficient data would lower the confidence of collected data in representing the ordinary situation happens in the surveyed site everyday.