Difference between revisions of "G2-Group08 Proposal"

From Geospatial Analytics for Urban Planning
Jump to navigation Jump to search
 
(65 intermediate revisions by 2 users not shown)
Line 6: Line 6:
 
<!-- Header Start -->
 
<!-- Header Start -->
 
{|style="background-color:#ffffff; color:#000000; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" |
 
{|style="background-color:#ffffff; color:#000000; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" |
−
| style="padding:0.3em; font-size:100%; background-color:#ffffff;  border-bottom:0px solid #000000; text-align:center; color:#000000" width="11%" |  
+
| style="padding:0.3em; font-size:100%; background-color:#ffffff;  border-bottom:0px solid #000000; text-align:center; color:#000000" width="15%" |  
 
[[G2-Group08 Homepage|<font color="#000000" size=2><b>HOME</b></font>]]
 
[[G2-Group08 Homepage|<font color="#000000" size=2><b>HOME</b></font>]]
  
 
| style="border-bottom:0px solid #ffffff; background:none;" width="1%" |
 
| style="border-bottom:0px solid #ffffff; background:none;" width="1%" |
−
| style="padding:0.3em; font-size:100%;  background-color:#EDCDC0;  border-bottom:0px solid #000000; text-align:center; color:#ffffff" width="12%" |  
+
| style="padding:0.3em; font-size:100%;  background-color:#EDCDC0;  border-bottom:0px solid #000000; text-align:center; color:#ffffff" width="15%" |  
 
[[G2-Group08 Proposal|<font color="#ffffff" size=2><b>PROPOSAL</b></font>]]
 
[[G2-Group08 Proposal|<font color="#ffffff" size=2><b>PROPOSAL</b></font>]]
  
 
| style="border-bottom:0px solid #ffffff; background:none;" width="1%" |
 
| style="border-bottom:0px solid #ffffff; background:none;" width="1%" |
−
| style="padding:0.3em; font-size:100%; background-color:#ffffff;  border-bottom:0px solid #000000; text-align:center; color:#000000" width="14%" |  
+
| style="padding:0.3em; font-size:100%; background-color:#ffffff;  border-bottom:0px solid #000000; text-align:center; color:#000000" width="15%" |  
 
[[G2-Group08 Poster |<font color="#000000" size=2><b>POSTER</b></font>]]
 
[[G2-Group08 Poster |<font color="#000000" size=2><b>POSTER</b></font>]]
  
Line 34: Line 34:
 
<br>
 
<br>
 
<div style="background: #EDCDC0; padding: 20px; line-height: 0em; text-indent: 0px;letter-spacing:0.0em;font-size:18px; text-align: left"><font color=#ffffff face="Roboto">'''Project Motivation'''</font></div>
 
<div style="background: #EDCDC0; padding: 20px; line-height: 0em; text-indent: 0px;letter-spacing:0.0em;font-size:18px; text-align: left"><font color=#ffffff face="Roboto">'''Project Motivation'''</font></div>
−
{| style="background-color:#FFFFFF;" width="100%"
+
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 
|-
 
|-
 
|
 
|
−
As part of our module, Geographic Information Systems for Urban Planning, we are collaborating with an international food chain to analyse 15 trade areas located in Taiwan's Kaohsiung and Ping Tung region. The international food chain currently uses manual methods of delineating their trade area which is largely time consuming. Therefore we aim to propose new and faster methods using QGIS to delineate the trade area. We will also be analysing the points of interest (POI) within each trade area to determine correlation between the POIs and sales revenue. The results of this project will provide the international food chain with the necessary geographic data analysis to make an informed decision regarding their sales and marketing strategy.
+
 
 +
[[File:Kaohsiung Stores.jpg|400px|frameless|left]]
 +
As part of our module, Geographic Information Systems for Urban Planning, we are collaborating with an international food chain to analyse 15 trade areas located in Taiwan's Kaohsiung and Ping Tung region as shown in the image below. The international food chain currently uses manual methods of delineating their trade area which is largely time consuming. Therefore we aim to propose new and faster methods using QGIS to delineate the trade area. <br>
 +
 
 +
 
 +
We will also be analysing the points of interest (POI) within each trade area to determine the correlation between the POIs and sales revenue. To do so, we will be using simple and multiple linear regression analysis. The results of this project will provide the international food chain with the necessary geographic data analysis to make an informed decision regarding their sales and marketing strategy.
 
|-
 
|-
 
|}
 
|}
  
 
<!-- END OF PROJECT MOTIVATION --->
 
<!-- END OF PROJECT MOTIVATION --->
 +
 +
<div style="background: #EDCDC0; padding: 20px; line-height: 0em; text-indent: 0px;letter-spacing:0.0em;font-size:18px; text-align: left"><font color=#ffffff face="Roboto">'''About Kaohsiung and Ping Tung'''</font></div>
 +
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 +
|-
 +
|
 +
Kaohsiung is a port city located in Southern Taiwan. It has a population of 2,770,000 people. Sitting between Cijin Island and downtown, Port of Kaohsiung is a world-class port in Taiwan as well as a hub for international trade. The ceaseless ships and containers from around the world represent the energy and vitality of the business in Kaohsiung.
 +
 +
Ping Tung county is a county also located in Southern Taiwan. It is the fifth-largest county in Taiwan. It is well known for its top attractions such as Kenting National Park and Ngoluanpi Park. Ping Tung also has some of Taiwan's best natural attractions such as amazing beaches, mountains and farmlands.
 +
 +
|-
 +
|}
  
 
<!-- Body -->
 
<!-- Body -->
Line 49: Line 65:
 
<div style="background: #EDCDC0; padding: 20px; line-height: 0em; text-indent: 0px;letter-spacing:0.0em;font-size:18px; text-align: left"><font color=#ffffff face="Roboto">'''Project Objectives'''</font></div>
 
<div style="background: #EDCDC0; padding: 20px; line-height: 0em; text-indent: 0px;letter-spacing:0.0em;font-size:18px; text-align: left"><font color=#ffffff face="Roboto">'''Project Objectives'''</font></div>
  
−
{| style="background-color:#FFFFFF;" width="100%"
+
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 
|-
 
|-
 
|
 
|
−
There are two main objectives of this project:<br>
+
'''There are two main objectives of this project:'''<br>
 
1. To find the most suitable and efficient trade area delineation method<br>
 
1. To find the most suitable and efficient trade area delineation method<br>
 
2. To analyse and generate insights into the current trade areas with respect to the selected points of interest and sales revenue
 
2. To analyse and generate insights into the current trade areas with respect to the selected points of interest and sales revenue
 +
 
|}
 
|}
  
Line 65: Line 82:
 
<div style="background: #EDCDC0; padding: 20px; line-height: 0em; text-indent: 0px;letter-spacing:0.0em;font-size:18px; text-align: left"><font color=#ffffff face="Roboto">'''Data'''</font></div>
 
<div style="background: #EDCDC0; padding: 20px; line-height: 0em; text-indent: 0px;letter-spacing:0.0em;font-size:18px; text-align: left"><font color=#ffffff face="Roboto">'''Data'''</font></div>
  
 +
===Geospatial Data===
 
{| style="background-color:#ffffff;" width="100%"
 
{| style="background-color:#ffffff;" width="100%"
 
|-
 
|-
Line 70: Line 88:
 
{| class="wikitable"
 
{| class="wikitable"
 
|-
 
|-
−
!style= "background-color: #EDCDC0"| Name !!style= "background-color: #EDCDC0"| Description !!style= "background-color: #EDCDC0"| Data Format !!style= "background-color: #EDCDC0"| Geographic Representation !!style= "background-color: #EDCDC0"| Source !!style= "background-color: #EDCDC0"| Used in
+
!style= "background-color: #EDCDC0"| Name !!style= "background-color: #EDCDC0"| Description !!style= "background-color: #EDCDC0"| Geographic Representation !!style= "background-color: #EDCDC0"| Data Format !!style= "background-color: #EDCDC0"| Source !!style= "background-color: #EDCDC0"| Used in
 +
|-
 +
| Taiwan Stores || Contains store locations allocated to each group || Point || Geopackage || Professor Kam, Client || Allocation of Stores, Trade area delineation methods
 +
|-
 +
|-style= "background-color:#EDCDC0"
 +
!scope="row" colspan="6"|<b>''Administrative Boundaries''</b>
 +
|-
 +
| County MOI || Contains boundaries by county || Polygon || ESRI Shapefile || Client || Trade area Digitisation
 +
|-
 +
| Town MOI || Contains boundaries by town || Polygon || ESRI Shapefile || Client || Trade area Digitisation
 +
|-
 +
| Village MOI || Contains boundaries by village || Polygon || ESRI Shapefile || Client || Trade area Digitisation
 +
|-
 +
|-style= "background-color:#EDCDC0"
 +
!scope="row" colspan="6"|<b>''Points of Interest''</b>
 +
|-
 +
| Business || Businesses in South Taiwan || Point || ESRI Shapefile || Client || Sales Revenue Analysis
 +
|-
 +
| CommSvc || Community Service Facilities in South Taiwan || Point || ESRI Shapefile || Client || Sales Revenue Analysis
 +
|-
 +
| EduInsts || Educational Institutions in South Taiwan || Point || ESRI Shapefile || Client || Sales Revenue Analysis
 +
|-
 +
| Entertn || Entertainment places in South Taiwan || Point || ESRI Shapefile || Client || Sales Revenue Analysis
 +
|-
 +
| FinInsts || Financial Institutions in South Taiwan || Point || ESRI Shapefile || Client || Sales Revenue Analysis
 +
|-
 +
| Hospital || Hospitals in South Taiwan || Point || ESRI Shapefile || Client || Sales Revenue Analysis
 +
|-
 +
| MiscCategories || Miscellaneous facilities in South Taiwan || Point || ESRI Shapefile || Client || Sales Revenue Analysis
 +
|-
 +
| ParkRec || Parks and Recreational areas in South Taiwan || Point || ESRI Shapefile || Client || Sales Revenue Analysis
 +
|-
 +
| Restrnts|| Restaurants in South Taiwan || Point || ESRI Shapefile || Client || Sales Revenue Analysis
 +
|-
 +
| Shopping|| Shopping centres in South Taiwan || Point || ESRI Shapefile || Client || Sales Revenue Analysis
 
|-
 
|-
−
| Taiwan Stores || ESRI Shapefile || Point || Professor Kam, Client || Allocation of Stores, Trade area delineation
+
| TransHub|| Transporation hubs in South Taiwan || Point || ESRI Shapefile || Client || Sales Revenue Analysis
 
|-
 
|-
−
| County MOI || ESRI Shapefile || Polygon || ||
+
| TravDest|| Travel Destinations in South Taiwan || Point || ESRI Shapefile || Client || Sales Revenue Analysis
 
|-
 
|-
−
| Town MOI || ESRI Shapefile || Polygon || ||
+
|-style= "background-color:#EDCDC0"
 +
!scope="row" colspan="6"|<b>''Store Sales''</b>
 
|-
 
|-
−
| Village MOI || ESRI Shapefile || Polygon || ||
+
| Store Sales Data || Revenue from sales by POD Code || NIL || CSV || Client || Sales Revenue Analysis
 
|}
 
|}
 
|-
 
|-
 +
|}
 +
 +
===Location Maps===
 +
''The location maps were used as a reference when digitising the operational trade area.''
 +
 +
{| class="wikitable"
 +
|-
 +
!style= "background-color: #EDCDC0"| Name !!style= "background-color: #EDCDC0"| Description !!style= "background-color: #EDCDC0"| Data Format !!style= "background-color: #EDCDC0"| Source !!style= "background-color: #EDCDC0"| Used in
 +
|-
 +
| CK-20190624寬109cm長130 || Location Map for trade area Shih Chuan, Kaohsiung County || Powerpoint ||  Client || Trade area Digitisation
 +
|-
 +
| JK-20190314寬83高72(木)含框 || Location Map for trade area Jiangong, Sanmin District, Kaohsiung City || Powerpoint || Client || Trade area Digitisation
 +
|-
 +
| KS20190823(外送範圍) || Location Map for Kang Shan Town, Kaohsiung County 820 || Powerpoint || Client || Trade area Digitisation
 +
|-
 +
| LJ-20171030寬89高120(木)含框 || Location Map for Lujhu District, Kaohsiung City || Powerpoint || Client || Trade area Digitisation
 +
|-
 +
| NZ地圖.jpg || Location Map for Nan Zi, Kaohsiung || Powerpoint || Client || Trade area Digitisation
 +
|-
 +
| NJ-20150902寬100高90(木) || Location Map for Nanzih District, Kaohsiung City || Powerpoint || Client || Trade area Digitisation
 +
|-
 +
| PM-20171124寬84高76(鋁) || Location Map for Ming Shan Road, Pintong || Powerpoint || Client || Trade area Digitisation
 +
|-
 +
| PZ-20171215寬82高76(鋁) || Location Map for Ping Tung Zhong Zheng || Powerpoint || Client || Trade area Digitisation
 +
|-
 +
| QD-20180913寬80高100(木) || Location Map for Qie Ding District, Kaohsiung City || Powerpoint || Client || Trade area Digitisation
 +
|-
 +
| RM-20190107寬110高110(木)含框 || Location Map for Renwu District, Kaohsiung City || Powerpoint || Client || Trade area Digitisation
 +
|-
 +
| RZ-20190314寬90高119.7(木)含框 || Location Map for Zuoying District, Kaohsiung City || Powerpoint || Client || Trade area Digitisation
 +
|-
 +
| TS-20190624-鋁-寬65高80 || Location Map for Tso Ying Delco, Kaohsiung || Powerpoint || Client || Trade area Digitisation
 +
|-
 +
| UC-20171226寬70高90(鋁) || Location Map for Yen Cheng District, Kaohsiung City || Powerpoint || Client || Trade area Digitisation
 +
|-
 +
| ZH-20190527寬90高88.8(鋁)含框 || Location Map for Gushan District, Kaohsiung City || Powerpoint || Client || Trade area Digitisation
 +
|-
 +
| ZY || Location Map for Tsoying Zi Yo, Kaohsiung || Powerpoint || Client || Trade area Digitisation
 
|}
 
|}
  
Line 95: Line 186:
 
|-
 
|-
 
|
 
|
−
As part of our module, Geographic Information Systems for Urban Planning, our group will be taking on a business profiling project in collaboration with an international F&B chain. For our project, we will be focusing on the company's outlets in Taiwan, in particular the west region and most of which are located in Kaohsiung city. Hence, we are covering a total of 15 outlets in which each outlet is surrounded by a trade area.
+
1. Digitising the existing Trade Area<br>
 +
We would need to digitise the existing hand-drawn trade area by referring to the location maps given
 +
 
 +
2. Extracting Points of Interest<br>
 +
We would need to extract the points of interest from the shapefiles given.
 +
 
 +
3. Trade Area Delineation method (Buffer)<br>
 +
We would need to delineate 2.5km, 3km and 3.5km buffers and analyse whether it would be a suitable replacement method.
 +
 
 +
4. Trade Area Delineation method (Drive Time)<br>
 +
We would need to delineate 15 minutes drive time boundary using QGIS' QNEAT function.
  
−
Our main objective is to extract the total number of Point of Interests (POIs) within each trade area. This would allow us to determine the likelihood of customers dining at a particular outlet. The results of this project will provide the F&B chain with the necessary geographic data analysis to make an informed decision regarding their sales and marketing strategy.
+
5. Sales revenue analysis<br>
 +
We would need to analyse the sales revenue namely bills, total revenue and average bills to find the correlation between sales and points of interest or other factors such as population.
 +
 
 +
[[File:Timeline G2G8.png|700px|frameless|center]]
 
|-
 
|-
 
|}
 
|}
Line 108: Line 212:
 
<!-- End Body --->
 
<!-- End Body --->
 
<br>
 
<br>
−
<div style="background: #EDCDC0; padding: 20px; line-height: 0em; text-indent: 0px;letter-spacing:0.0em;font-size:18px; text-align: left"><font color=#ffffff face="Roboto">'''Project Schedule'''</font></div>
+
<div style="background: #EDCDC0; padding: 20px; line-height: 0em; text-indent: 0px;letter-spacing:0.0em;font-size:18px; text-align: left"><font color=#ffffff face="Roboto">'''References'''</font></div>
−
 
 
 
{| style="background-color:#FFFFFF;" width="100%"
 
{| style="background-color:#FFFFFF;" width="100%"
 
|-
 
|-
 
|
 
|
−
As part of our module, Geographic Information Systems for Urban Planning, our group will be taking on a business profiling project in collaboration with an international F&B chain. For our project, we will be focusing on the company's outlets in Taiwan, in particular the west region and most of which are located in Kaohsiung city. Hence, we are covering a total of 15 outlets in which each outlet is surrounded by a trade area.
+
[https://www.kcg.gov.tw/EN/cp.aspx?n=E5AA72D4F35F91D0 Kaohsiung City Government]<br>
 +
 
 +
[https://en.wikipedia.org/wiki/Pingtung_County Ping Tung County]
 +
 
 +
[https://www.lonelyplanet.com/taiwan/pingtung-county Pingtung County Travel]
  
−
Our main objective is to extract the total number of Point of Interests (POIs) within each trade area. This would allow us to determine the likelihood of customers dining at a particular outlet. The results of this project will provide the F&B chain with the necessary geographic data analysis to make an informed decision regarding their sales and marketing strategy.
+
[https://www.taiwannews.com.tw/en/news/3416395 Seven must-see attractions in Pingtung]
 
|-
 
|-
 
|}
 
|}
  
 
<!-- END OF PROJECT SCHEDULE --->
 
<!-- END OF PROJECT SCHEDULE --->

Latest revision as of 23:59, 24 November 2019

Kaohsiung .png


HOME

PROPOSAL

POSTER

WEBMAPS

PROJECT REPORT




Project Motivation
Kaohsiung Stores.jpg

As part of our module, Geographic Information Systems for Urban Planning, we are collaborating with an international food chain to analyse 15 trade areas located in Taiwan's Kaohsiung and Ping Tung region as shown in the image below. The international food chain currently uses manual methods of delineating their trade area which is largely time consuming. Therefore we aim to propose new and faster methods using QGIS to delineate the trade area.


We will also be analysing the points of interest (POI) within each trade area to determine the correlation between the POIs and sales revenue. To do so, we will be using simple and multiple linear regression analysis. The results of this project will provide the international food chain with the necessary geographic data analysis to make an informed decision regarding their sales and marketing strategy.


About Kaohsiung and Ping Tung

Kaohsiung is a port city located in Southern Taiwan. It has a population of 2,770,000 people. Sitting between Cijin Island and downtown, Port of Kaohsiung is a world-class port in Taiwan as well as a hub for international trade. The ceaseless ships and containers from around the world represent the energy and vitality of the business in Kaohsiung.

Ping Tung county is a county also located in Southern Taiwan. It is the fifth-largest county in Taiwan. It is well known for its top attractions such as Kenting National Park and Ngoluanpi Park. Ping Tung also has some of Taiwan's best natural attractions such as amazing beaches, mountains and farmlands.



Project Objectives

There are two main objectives of this project:
1. To find the most suitable and efficient trade area delineation method
2. To analyse and generate insights into the current trade areas with respect to the selected points of interest and sales revenue




Data

Geospatial Data

Name Description Geographic Representation Data Format Source Used in
Taiwan Stores Contains store locations allocated to each group Point Geopackage Professor Kam, Client Allocation of Stores, Trade area delineation methods
Administrative Boundaries
County MOI Contains boundaries by county Polygon ESRI Shapefile Client Trade area Digitisation
Town MOI Contains boundaries by town Polygon ESRI Shapefile Client Trade area Digitisation
Village MOI Contains boundaries by village Polygon ESRI Shapefile Client Trade area Digitisation
Points of Interest
Business Businesses in South Taiwan Point ESRI Shapefile Client Sales Revenue Analysis
CommSvc Community Service Facilities in South Taiwan Point ESRI Shapefile Client Sales Revenue Analysis
EduInsts Educational Institutions in South Taiwan Point ESRI Shapefile Client Sales Revenue Analysis
Entertn Entertainment places in South Taiwan Point ESRI Shapefile Client Sales Revenue Analysis
FinInsts Financial Institutions in South Taiwan Point ESRI Shapefile Client Sales Revenue Analysis
Hospital Hospitals in South Taiwan Point ESRI Shapefile Client Sales Revenue Analysis
MiscCategories Miscellaneous facilities in South Taiwan Point ESRI Shapefile Client Sales Revenue Analysis
ParkRec Parks and Recreational areas in South Taiwan Point ESRI Shapefile Client Sales Revenue Analysis
Restrnts Restaurants in South Taiwan Point ESRI Shapefile Client Sales Revenue Analysis
Shopping Shopping centres in South Taiwan Point ESRI Shapefile Client Sales Revenue Analysis
TransHub Transporation hubs in South Taiwan Point ESRI Shapefile Client Sales Revenue Analysis
TravDest Travel Destinations in South Taiwan Point ESRI Shapefile Client Sales Revenue Analysis
Store Sales
Store Sales Data Revenue from sales by POD Code NIL CSV Client Sales Revenue Analysis

Location Maps

The location maps were used as a reference when digitising the operational trade area.

Name Description Data Format Source Used in
CK-20190624寬109cm長130 Location Map for trade area Shih Chuan, Kaohsiung County Powerpoint Client Trade area Digitisation
JK-20190314寬83高72(木)含框 Location Map for trade area Jiangong, Sanmin District, Kaohsiung City Powerpoint Client Trade area Digitisation
KS20190823(外送範圍) Location Map for Kang Shan Town, Kaohsiung County 820 Powerpoint Client Trade area Digitisation
LJ-20171030寬89高120(木)含框 Location Map for Lujhu District, Kaohsiung City Powerpoint Client Trade area Digitisation
NZ地圖.jpg Location Map for Nan Zi, Kaohsiung Powerpoint Client Trade area Digitisation
NJ-20150902寬100高90(木) Location Map for Nanzih District, Kaohsiung City Powerpoint Client Trade area Digitisation
PM-20171124寬84高76(鋁) Location Map for Ming Shan Road, Pintong Powerpoint Client Trade area Digitisation
PZ-20171215寬82高76(鋁) Location Map for Ping Tung Zhong Zheng Powerpoint Client Trade area Digitisation
QD-20180913寬80高100(木) Location Map for Qie Ding District, Kaohsiung City Powerpoint Client Trade area Digitisation
RM-20190107寬110高110(木)含框 Location Map for Renwu District, Kaohsiung City Powerpoint Client Trade area Digitisation
RZ-20190314寬90高119.7(木)含框 Location Map for Zuoying District, Kaohsiung City Powerpoint Client Trade area Digitisation
TS-20190624-鋁-寬65高80 Location Map for Tso Ying Delco, Kaohsiung Powerpoint Client Trade area Digitisation
UC-20171226寬70高90(鋁) Location Map for Yen Cheng District, Kaohsiung City Powerpoint Client Trade area Digitisation
ZH-20190527寬90高88.8(鋁)含框 Location Map for Gushan District, Kaohsiung City Powerpoint Client Trade area Digitisation
ZY Location Map for Tsoying Zi Yo, Kaohsiung Powerpoint Client Trade area Digitisation




Scope of Work

1. Digitising the existing Trade Area
We would need to digitise the existing hand-drawn trade area by referring to the location maps given

2. Extracting Points of Interest
We would need to extract the points of interest from the shapefiles given.

3. Trade Area Delineation method (Buffer)
We would need to delineate 2.5km, 3km and 3.5km buffers and analyse whether it would be a suitable replacement method.

4. Trade Area Delineation method (Drive Time)
We would need to delineate 15 minutes drive time boundary using QGIS' QNEAT function.

5. Sales revenue analysis
We would need to analyse the sales revenue namely bills, total revenue and average bills to find the correlation between sales and points of interest or other factors such as population.

Timeline G2G8.png




References

Kaohsiung City Government

Ping Tung County

Pingtung County Travel

Seven must-see attractions in Pingtung


Retrieved from ‘https://wiki.smu.edu.sg/1920t1smt201/index.php?title=G2-Group08_Proposal&oldid=12717’