Difference between revisions of "ParcFinder Proposal"
Khching.2014 (talk | contribs) |
Khching.2014 (talk | contribs) |
||
Line 159: | Line 159: | ||
=== Project Task Allocation === | === Project Task Allocation === | ||
<br> | <br> | ||
+ | <table style="border:1px solid #547ba8; width: 100%"> | ||
+ | <tr style="background-color:#547ba8"> | ||
+ | <td style="border-right:1px solid #547ba8;color: white;text-align:center;font-weight:bold;width:10%">S/N</td> | ||
+ | <td style="border-right:1px solid #547ba8;color: white;text-align:center;font-weight:bold;width:25%">Task</td> | ||
+ | <td style="border-right:1px solid #547ba8;color: white;text-align:center;font-weight:bold;width:15%">Done by</td> | ||
+ | <td style="border-right:1px solid #547ba8;color: white;text-align:center;font-weight:bold;width:15%">Week</td> | ||
+ | <td style="border-right:1px solid #547ba8;color: white;text-align:center;font-weight:bold;width:25%">Dates</td> | ||
+ | <td style="text-align:center;color: white;font-weight:bold;width:10%">Status</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:10%">1</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">Topic Brainstorming</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">All</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">6</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">6 February - 10 February</td> | ||
+ | <td style="text-align:center;width:10%">Completed ✔</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:10%">2</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">Topic Refining & Finding Related data sources</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">All</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">7 & 8</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">13 February - 22 February</td> | ||
+ | <td style="text-align:center;width:10%">Completed ✔</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:10%">3</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">Consultation with Prof on Project Topic</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">All</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">8</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">23 February</td> | ||
+ | <td style="text-align:center;width:10%">Completed ✔</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:10%">4</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">Final decision on topic & Data collection</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">All</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">8 & 9</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">23 February - 3 March</td> | ||
+ | <td style="text-align:center;width:10%">Completed ✔</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:10%">5</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">Learn R Shiny</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">All</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">10</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">3 March - 10 March</td> | ||
+ | <td style="text-align:center;width:10%">Completed ✔</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:10%">6</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">Explore R Shiny and packages</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">All</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">11 - 13</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">10 March - 31 March</td> | ||
+ | <td style="text-align:center;width:10%">Completed ✔</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:10%">7</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">Get started on Application (base)</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">Brendon & Jason</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">14</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">1 April - 2 April</td> | ||
+ | <td style="text-align:center;width:10%">Completed ✔</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:10%">8</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">Code basic UI (sliders and tabs)</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">Brendon & Jason</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">14</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">2 April</td> | ||
+ | <td style="text-align:center;width:10%">Completed ✔</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:10%">9</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">Clean & Filter Data</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">Brendon & Zack</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">14</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">2 April - 4 April</td> | ||
+ | <td style="text-align:center;width:10%">Completed ✔</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:10%">10</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">Plotting & Markers</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">Brendon & Jason</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">14</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">5 April - 6 April</td> | ||
+ | <td style="text-align:center;width:10%">Completed ✔</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:10%">11</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">Implementation of Kernel Density Estimation (KDE) on Map</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">Jason</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">14</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">6 April - 8 April</td> | ||
+ | <td style="text-align:center;width:10%">Completed ✔</td> | ||
+ | </tr> | ||
+ | |||
+ | <tr> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:10%">12</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">Implementation of Quadrat Count Analysis (QC) on Map</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">Jason</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">14</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">8 April - 10 April</td> | ||
+ | <td style="text-align:center;width:10%">Completed ✔</td> | ||
+ | </tr> | ||
+ | |||
+ | <tr> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:10%">13</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">Processing of walking distances</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">Zack</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">14</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">6 April - 9 April</td> | ||
+ | <td style="text-align:center;width:10%">Completed ✔</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:10%">14</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">Implementation of Nearest Neighbor Index (NNI)</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">Brendon & Zack</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">15</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">10 April - 12 April</td> | ||
+ | <td style="text-align:center;width:10%">Completed ✔</td> | ||
+ | </tr> | ||
+ | |||
+ | <tr> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:10%">15</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">Implementation of Distance by Residential</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">All</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">15</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">10 April - 12 April</td> | ||
+ | <td style="text-align:center;width:10%">Completed ✔</td> | ||
+ | </tr> | ||
+ | |||
+ | <tr> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:10%">16</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">Implementation of Dynamic Choropleth Maps (Demographics Density)</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">Jason</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">15</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">10 April - 11 April</td> | ||
+ | <td style="text-align:center;width:10%">Completed ✔</td> | ||
+ | </tr> | ||
+ | |||
+ | <tr> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:10%">17</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">Implementation of Upload Dataset function</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">Jason</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">15</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">11 April - 12 April</td> | ||
+ | <td style="text-align:center;width:10%">Completed ✔</td> | ||
+ | </tr> | ||
+ | |||
+ | <tr> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:10%">18</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">Implementation of KDE, QC and NNI on map for new uploaded dataset</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">Jason</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">15</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">12 April - 13 April</td> | ||
+ | <td style="text-align:center;width:10%">Completed ✔</td> | ||
+ | </tr> | ||
+ | |||
+ | <tr> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:10%">19</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">Poster</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">All</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">15</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">11 April - 12 April</td> | ||
+ | <td style="text-align:center;width:10%">Completed ✔</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:10%">20</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">Testing, Debugging & Deployment</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">All</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">15</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">12 April - 15 April</td> | ||
+ | <td style="text-align:center;width:10%">Completed ✔</td> | ||
+ | </tr> | ||
+ | |||
+ | <tr> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:10%">21</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">Revamp application into Shiny Dashboard</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">Jason</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">15</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">15 April - 16 April</td> | ||
+ | <td style="text-align:center;width:10%">Completed ✔</td> | ||
+ | </tr> | ||
+ | |||
+ | <tr> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:10%">22</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">Townhall Poster showcase & presentation</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">All</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">16</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">17 April - 17 April</td> | ||
+ | <td style="text-align:center;width:10%">Completed ✔</td> | ||
+ | </tr> | ||
+ | |||
+ | <tr> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:10%">23</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">Finalizing Wiki & Research Paper</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">All</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:15%">15 & 16</td> | ||
+ | <td style="border-right:1px solid #547ba8;text-align:center;width:25%">14 April - 20 April</td> | ||
+ | <td style="text-align:center;width:10%">Completed ✔</td> | ||
+ | </tr> | ||
+ | </table> | ||
=== Case Study=== | === Case Study=== |
Revision as of 03:22, 11 April 2018
Contents
Project Background
Issues and Problems
With the expansion of E-Commerce in Singapore, there is a growing demand for the provision of effective logistical services to facilitate the delivery and receiving of goods and services to consumers.
As we analysed the entire customer experience journey in the e-commerce industry, we realised that there is a gap in the service delivery process in the event of a missed delivery. A study by the NUS Logistics Institute - Asia Pacific shows that as of 2017, the delivery failure rates in Singapore hover at more than 15%.
Traditionally, customers who missed a delivery from their logistics providers are redirected either to the post office to collect their parcels. They could also be required to make a call to their logistics providers and rescheduling for a redelivery, and at times required to pay an additional fee for the services. As for the logistics providers, carrying out redeliveries incurs additional operational costs in terms of man-hours and resources.
Motivation
Project Aim
Our team has explored the Self-Collection Points as a viable solution in addressing the issue of missed deliveries. We recognise the importance for Logistic Companies to be able to determine the location of their self-collection points, in order to maximise coverage as well as improving their last-mile delivery service experience for their customers.
Proposed Solution
Through the conceptualisation of our application - ParcFinder, we provide users with the tools to visualise the geographical accessibility and generate spatial analysis reports of their existing self-collection points. We hope to provide the necessary insights for our users in their decision-making process in the location of their self-collection points.
Our project will provide an application that will present to users the following insights and analyses:
Approach - GIS and Accessibility Models Used
ParcFinder is an application that uses various GIS and Accessibility Models and give the user different levels of understanding the geographical accessibility of the self-collection points. These models are as follows, based on the level of analysis and insights each method brings:
Level 1: Catchment Area Buffer Analysis
Level 2: Hansen Potential Accessibility Model
Level 3: Kernel Density Estimation
Level 4: Two-Step Floating Catchment Area Method (For Future Works)
Data Source
S/N |
Title |
Format |
Website Link / Sources |
1 |
Master Plan 2014 Planning Area |
SHP |
https://data.gov.sg/dataset/master-plan-2014-planning-area-boundary-web |
2 |
SingPost Post Office |
Unformatted |
|
3 |
SingPost POPStation |
Unformatted |
|
4 |
EzBuy |
Unformatted |
|
6 |
Residential Location |
csv |
Public Housing: https://www.ema.gov.sg/statistic.aspx?sta_sid=20150617kEhn53Jk6sDQ |
Project Proposal
Project Milestones
Project Storyboard
Project Task Allocation
S/N | Task | Done by | Week | Dates | Status |
1 | Topic Brainstorming | All | 6 | 6 February - 10 February | Completed ✔ |
2 | Topic Refining & Finding Related data sources | All | 7 & 8 | 13 February - 22 February | Completed ✔ |
3 | Consultation with Prof on Project Topic | All | 8 | 23 February | Completed ✔ |
4 | Final decision on topic & Data collection | All | 8 & 9 | 23 February - 3 March | Completed ✔ |
5 | Learn R Shiny | All | 10 | 3 March - 10 March | Completed ✔ |
6 | Explore R Shiny and packages | All | 11 - 13 | 10 March - 31 March | Completed ✔ |
7 | Get started on Application (base) | Brendon & Jason | 14 | 1 April - 2 April | Completed ✔ |
8 | Code basic UI (sliders and tabs) | Brendon & Jason | 14 | 2 April | Completed ✔ |
9 | Clean & Filter Data | Brendon & Zack | 14 | 2 April - 4 April | Completed ✔ |
10 | Plotting & Markers | Brendon & Jason | 14 | 5 April - 6 April | Completed ✔ |
11 | Implementation of Kernel Density Estimation (KDE) on Map | Jason | 14 | 6 April - 8 April | Completed ✔ |
12 | Implementation of Quadrat Count Analysis (QC) on Map | Jason | 14 | 8 April - 10 April | Completed ✔ |
13 | Processing of walking distances | Zack | 14 | 6 April - 9 April | Completed ✔ |
14 | Implementation of Nearest Neighbor Index (NNI) | Brendon & Zack | 15 | 10 April - 12 April | Completed ✔ |
15 | Implementation of Distance by Residential | All | 15 | 10 April - 12 April | Completed ✔ |
16 | Implementation of Dynamic Choropleth Maps (Demographics Density) | Jason | 15 | 10 April - 11 April | Completed ✔ |
17 | Implementation of Upload Dataset function | Jason | 15 | 11 April - 12 April | Completed ✔ |
18 | Implementation of KDE, QC and NNI on map for new uploaded dataset | Jason | 15 | 12 April - 13 April | Completed ✔ |
19 | Poster | All | 15 | 11 April - 12 April | Completed ✔ |
20 | Testing, Debugging & Deployment | All | 15 | 12 April - 15 April | Completed ✔ |
21 | Revamp application into Shiny Dashboard | Jason | 15 | 15 April - 16 April | Completed ✔ |
22 | Townhall Poster showcase & presentation | All | 16 | 17 April - 17 April | Completed ✔ |
23 | Finalizing Wiki & Research Paper | All | 15 & 16 | 14 April - 20 April | Completed ✔ |
Case Study
Case Study 1: Singapore Post POPStation
Case Study 2: EzBuy, bluPort and NinjaCollect
ParcFinder Application
Application Architecture
Application Overview
Application Guide
Results and Findings
Challenges and Limitations
Data Cleaning and Transformation
- Data retrieved not available in KML/SHP/XML format
- Team effort to convert to SHP format
- Documentation to keep track of changes.
- Data (longitude and latitude) not provided
- Write script to transform postal codes
- For postal codes that wasn't able to transform using the script, manually retrieve longitude and latitude from Google Map
Future Work
Meet the ParcFinder Team
|
|
|
Comments
Please insert your comments here:
No. |
Name |
Date |
Comments |
1. |
Insert your Name here |
Insert Date here |
Insert Comment here |
2. |
Insert your Name here |
Insert Date here |
Insert Comment here |
3. |
Insert your Name here |
Insert Date here |
Insert Comment here |