JJJ: Proposal

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search


Proposal


Problem & Motivation

Land scarcity is persistent issue faced by Singapore since its independence, being a country with only the size of a typical city or smaller of a fellow developed nation. As such, one of Singapore’s main challenges is in the area of Urban Planning to optimize land use without compromising on the standards of living for its residents.

One of the ways to assess the effectiveness of urban planning would be to study commuter patterns, understanding how people travel for their work and educational needs. Some who stay near to their workplace enjoy a shorter journey with less commuting time. However, there are also people who stay far from their workplaces and spend long hours on travel, for example an individual who stays at Tampines yet having to travel to Tuas for work. Hence, we would like to create a tool to gain a closer look into commuter patterns in Singapore to find out more on current commuter patterns. We believe that the tool in investigating commuter patterns would be useful for urban planners to be able to identify potential problems and patterns in the current design so as to improve the urban landscape in preparation for population growth.

Objectives:

  • To explore recent commuter data for bus travel in Singapore
  • To visualize commuter patterns during the morning peak hours
  • To explore the impact of current commuter patterns on possible challenges in urban planning
  • To create a visualization for an easy and intuitive understanding of the current situation for the average Singaporean

Background Survey of Related Work

Related Works What We Can Learn Based on Sources

Commuting Patterns of Industrial Workers

% Trips by Industrial Workers - Working Social Document.JPG

Source: http://web.mit.edu/11.521/papers/WorkingSocialDocument_Aug2012_v2.pdf

  • A static chart which is not intuitive prevents users from identifying a single path
  • Colour scheme makes it difficult to differentiate (Green vs Yellow)
  • Too many lines makes it difficult for users to identify the region names
  • Brushing and filtering is needed to focus on area of concern while muting out other points to reduce clutter on visualisation

An analysis of Bus Travelling Time

Bus travel time.png

Source: http://sgtptr.chrissng.net/

  • Lack of clear and uniform intervals on the legend
  • Usage of decimal for values of data presented (mins of travel) is not appropriate in the context of the data. (i.e. Usuall people would round up to an integer when indicating a range)
  • Every origin is a destination which makes it redundant to show origin and destination legends
  • The names of the places are well labelled and clear

Traveller Distances

Traveller distances - Working Social Document.JPG

Source: http://web.mit.edu/11.521/papers/WorkingSocialDocument_Aug2012_v2.pdf

  • Effective visualisation on clustering effect
  • Can be improved for use of multivariate analysis by incorporating shapes or colours to categorise the data

Choice of Dataset

Data Source: https://data.dex.sg/organization/land-transport-authority

  1. Preparation of Data

We downloaded a total of 8 CSV files which consists of commuter and bus data from the data source above. The main dataset provides an extensive number of up to 1,000,000 commuter records and needs careful analysis of what we need. Here is a list of attributes that are of our concern when cleaning the data:

  1. Commuter ID
  2. Ride Start Time
  3. Ride End Time
  4. Boarding Bus Stop
  5. Alighting Bus Stop
  6. Bus Service Number

Other datasets provides us more attributes such as the coordinates of the bus stops

Description of the approach

Type of Visual Why do we think it is useful

Proportional Symbol Map

Photo 2016-10-07 18-12-00.jpg

Source: https://www.e-education.psu.edu/natureofgeoinfo/c3_p17.html

  • To show the proportion of people travelling out/within each region
  • Bar charts will be generated on each region of the map e.g. East
  • Each Bar chart represents the proportion of people travelling Interregion (East-West, East-North, etc) and within region (East-East)
  • Can add in more analysis by binning the journey start time to morning, afternoon and night as filters to show commuter flow by time period of day
  • Interactive visual that can be used with brushing to highlight and narrow down to area of interest
  • To provide for easy and intuitive understanding of existing commuter patterns

References

  1. http://worksingapore.com/articles/live_4.php
  2. https://www.lta.gov.sg/content/dam/ltaweb/corp/PublicationsResearch/files/ReportNewsletter/LTMP2013Report.pdf
  3. https://www.quora.com/In-Singapore-it-takes-more-than-an-hour-to-reach-a-destination-via-the-public-transport-bus-train-but-just-quarter-of-the-time-if-I-were-to-take-the-taxi-Would-we-still-call-the-public-transport-successful
  4. http://web.mit.edu/11.521/papers/WorkingSocialDocument_Aug2012_v2.pdf
  5. http://www.enterpriseinnovation.net/article/singapores-transport-vision-analytics-new-interfaces-autonomous-vehicles-1298824564
  6. http://business.asiaone.com/career/news/3-factors-determine-if-singaporeans-leave-their-jobs
  7. http://community.jobscentral.com.sg/articles/your-daily-work-commute-ruining-your-life
  8. http://blog.moneysmart.sg/lifestyle/cheap-fast-and-painless-commuting-in-singapore-is-it-possible/
  9. http://lkyspp.nus.edu.sg/wp-content/uploads/2014/01/Transport-Planning-for-Singapore.pdf
  10. http://lkyspp.nus.edu.sg/wp-content/uploads/2013/04/Barter-Sg-urban-transport-sustainable-by-design-or-necessity.pdf
  11. https://www.ura.gov.sg/uol/master-plan/view-master-plan/master-plan-2014/Growth-Area
  12. http://www.smartnation.sg/initiatives/Mobility/spearheading-research-in-standards-for-sdvs
  13. https://www.ura.gov.sg/skyline/skyline09/skyline09-02/text/04.htm

Key Technical Challenges

Milestones

Test

Comments

Please feel free to comment on our proposal.