Difference between revisions of "G1-Group15"

From Geospatial Analytics for Urban Planning
Jump to navigation Jump to search
 
(26 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
[[File:NewTaipeiLogo2(G1Group15).png|280px|frameless|center]]
 +
</br>
 
<div id="mw-content-text" lang="en-GB" dir="ltr" class="mw-content-ltr"><div class="mw-parser-output"><center>
 
<div id="mw-content-text" lang="en-GB" dir="ltr" class="mw-content-ltr"><div class="mw-parser-output"><center>
 
<table style="&quot;background-color:white;" width="&quot;80%&quot;&#124;">
 
<table style="&quot;background-color:white;" width="&quot;80%&quot;&#124;">
  
 
<tr>
 
<tr>
<td style="font-family:Roboto, Arial, sans-serif; font-size:16px; text-align: center; border-top:solid #4FD989; border-bottom:solid #4FD989" width="200px">
+
<td style="font-family:Roboto, Arial, sans-serif; font-size:16px; text-align: center; border-top:solid #B41E3B; border-bottom:solid #B41E3B;" width="200px">
<p><strong>[[G1-Group15_Home|Home]]</strong>
+
<p><strong>[[G1-Group15_Home|<font color=#B41E3B>Home</font>]]</strong>
 
</p>
 
</p>
 
</td>
 
</td>
Line 11: Line 13:
 
</p>
 
</p>
 
</td>
 
</td>
<td style="font-family:Roboto, Arial, sans-serif; font-size:16px; text-align: center; border-top:solid #4FD989; border-bottom:solid #4FD989" width="200px">
+
<td style="font-family:Roboto, Arial, sans-serif; font-size:16px; text-align: center; border-top:solid #B41E3B; border-bottom:solid #B41E3B" width="200px">
<p><strong>[[G1-Group15_Poster|Poster]]</strong>
+
<p><strong>[[G1-Group15_Poster|<font color=#B41E3B>Poster</font>]]</strong>
 
</p>
 
</p>
 
</td>
 
</td>
<td style="font-family:Roboto, Arial, sans-serif; font-size:16px; text-align: center; border-top:solid #4FD989; border-bottom:solid #4FD989" width="200px">
+
<td style="font-family:Roboto, Arial, sans-serif; font-size:16px; text-align: center; border-top:solid #B41E3B; border-bottom:solid #B41E3B" width="200px">
<p><strong>[[G1-Group15_Web_Maps|Web Maps]]</strong>
+
<p><strong>[[G1-Group15_Web_Maps|<font color=#B41E3B>Web Maps</font>]]</strong>
 
</p>
 
</p>
 
</td>
 
</td>
<td style="font-family:Roboto, Arial, sans-serif; font-size:16px; text-align: center; border-top:solid #4FD989; border-bottom:solid #4FD989" width="200px">
+
<td style="font-family:Roboto, Arial, sans-serif; font-size:16px; text-align: center; border-top:solid #B41E3B; border-bottom:solid #B41E3B" width="200px">
<p><strong>[[G1-Group15_Project_Report|Project Report]]</strong>
+
<p><strong>[[G1-Group15_Project_Report|<font color=#B41E3B>Project Report</font>]]</strong>
 
</p>
 
</p>
 
</td></tr>
 
</td></tr>
Line 29: Line 31:
 
<div style="text-align: left;>
 
<div style="text-align: left;>
 
<br />
 
<br />
Our client is a global brand in the Food and Beverage industry. As the number of its stores grows bigger, it urgently needs a way to analyze the performance of its stores in different trade areas. Therefore, our team aims to perform in-depth analysis on each trade area of its stores and uncover the relationship between its stores' performance and the Point of Interest around each stores.
+
Organizations today are collecting data at every level of their business and in volumes that in the past were unimaginable, and 80% of all data collected has a spatial component. Therefore, the ability to generate insights using geospatial information system in the business world become utmost important. In this project, we are required to utilize the sales and geospatial data provided by our client to generate insights and provide recommendations to improve the performance of its stores in different trade areas.
 +
 
 +
Our client is a global brand in the Food and Beverage industry. It provides both dine-in and food delivery service to its customers. As the number of its stores grows bigger, it urgently needs a way to analyse the performance of its stores in different trade areas. The company provided us with data such as the boundaries and sales of their trade area, and the location of different commercial facilities to conduct our geospatial analysis. Therefore, our team aims to perform in-depth analyses of their geospatial data and uncover the relationship between its stores' location and sales.
 +
 
  
 
</div>
 
</div>
Line 35: Line 40:
 
<div style="background: #4FD989; padding: 20px; line-height: 0.3em; text-indent: 0px;letter-spacing:0.01em;font-size:26px"><font color=#000000 face="Arial"><b>Project Objectives</b></font></div>
 
<div style="background: #4FD989; padding: 20px; line-height: 0.3em; text-indent: 0px;letter-spacing:0.01em;font-size:26px"><font color=#000000 face="Arial"><b>Project Objectives</b></font></div>
 
<div style="text-align: left;>
 
<div style="text-align: left;>
<br />
+
 
Our objective is to conduct trade area analysis on 13 stores located in New Taipei city by using QGIS and discover insights that can be used in designing business strategies, optimizing the performance of the stores and planning the location of new stores in the future. In our analysis, we aim to uncover any correlation between the sales of each store with POIs within their trade areas. We will also allocate a POI score to each POI to find out which trade area has more potential customers, this insight will be used to plan the location of new stores and reallocation of the boundary of trade areas. Base
+
 
 +
{| align=center width = 100%
 +
 
 +
| style="text-align:justify; width:22em; height: 1.1em; font-size:15px; font-family:Cambria !important; color: black;"|
 +
 
 +
'''Meme Lovers''' aims to achieve the following project objectives:
 +
 
 +
# Delineation of trade areas using QGIS
 +
# Extraction of targeted POIs from data files
 +
# Meaningful compilation of Trade Area-POI web maps
 +
# Perform in-depth analyses of our client's geospatial data and uncover the relationship between their stores' location and sales
 +
|}
 +
 
 
<br />
 
<br />
 
</div>
 
</div>
Line 44: Line 61:
 
{| class="wikitable" style="color:black; background-color:#FCF9F9;"  
 
{| class="wikitable" style="color:black; background-color:#FCF9F9;"  
 
|-
 
|-
!style= "text-align:left; background-color: #49D525"| Data File !! style= "text-align:left;background-color: #49D525"| Description !! style= "text-align:left;background-color: #49D525"| Data Format !! style= "text-align:left;background-color: #49D525"| Purpose
+
!style= "text-align:left; background-color: #CAFF94"| Data File !! style= "text-align:left;background-color: #CAFF94"| Description !! style= "text-align:left;background-color: #CAFF94"| Data Format !! style= "text-align:left;background-color: #CAFF94"| Purpose
 
|-
 
|-
 
|-style= "background-color: #FFFFF0"
 
|-style= "background-color: #FFFFF0"
!scope="row" colspan="4" style= "background-color: #49D525"|<b>''GeoPackage''</b>
+
!scope="row" colspan="4" style= "background-color: #CAFF94"|<b>''GeoPackage''</b>
 
|-  
 
|-  
 
| Taiwan_stores || Contains geo-coded stores || .gpkg || Allocation of Stores
 
| Taiwan_stores || Contains geo-coded stores || .gpkg || Allocation of Stores
 
|-
 
|-
 
|-style= "background-color: #FFFACD"
 
|-style= "background-color: #FFFACD"
!scope="row" colspan="4" style= "background-color: #49D525"|<b>''Administrative Boundaries''</b>
+
!scope="row" colspan="4" style= "background-color: #CAFF94"|<b>''Administrative Boundaries''</b>
 
|-
 
|-
 
|-
 
|-
Line 60: Line 77:
 
| Town MOI || Contains town area || .shp || Show boundary
 
| Town MOI || Contains town area || .shp || Show boundary
 
|-
 
|-
 +
| Street || Contains vector of street and roads || .shp || Show street and road
 
|-
 
|-
 
|-
 
|-
|-style= "background-color: #49D525""
+
|-style= "background-color: #CAFF94""
!scope="row" colspan="4" style= "background-color: #49D525"|<b>''Location Maps''</b>
+
!scope="row" colspan="4" style= "background-color: #CAFF94"|<b>''Location Maps''</b>
 
|-  
 
|-  
 
| AE-20190313寬100高等比(鋁)含框參觀版|| Trade area of store || .pptx || Reference Layer for Digitising
 
| AE-20190313寬100高等比(鋁)含框參觀版|| Trade area of store || .pptx || Reference Layer for Digitising
Line 92: Line 110:
 
|-
 
|-
 
|-style= "background-color: #FFFACD"
 
|-style= "background-color: #FFFACD"
!scope="row" colspan="4" style= "background-color: #49D525"|<b>''Points of Interest ''</b>
+
!scope="row" colspan="4" style= "background-color: #CAFF94"|<b>''Points of Interest ''</b>
 
|-
 
|-
 
| Business || Contains locations of businesses  || .shp || Type of facility that will be used for analysis  
 
| Business || Contains locations of businesses  || .shp || Type of facility that will be used for analysis  
Line 122: Line 140:
  
 
<div style="background: #4FD989; padding: 20px; line-height: 0.3em; text-indent: 0px;letter-spacing:0.01em;font-size:26px"><font color=#000000 face="Arial"><b>Scope Of Work</b></font></div>
 
<div style="background: #4FD989; padding: 20px; line-height: 0.3em; text-indent: 0px;letter-spacing:0.01em;font-size:26px"><font color=#000000 face="Arial"><b>Scope Of Work</b></font></div>
Our team has been allocated 13 Stores in New Taipei City
+
Our team has been allocated 13 Stores in New Taipei City (shown in the map below)
shown in the map below.
 
 
[[File:Wiki scope final.jpg|760px|center]]
 
[[File:Wiki scope final.jpg|760px|center]]
 +
 +
<div padding: 20px; line-height: 0.3em; text-indent: 0px;letter-spacing:0.01em;font-size:26px"></div>
 +
 +
The table below shows the relevant facility types extracted from POI files
 +
{| class="wikitable" style="color:black; background-color:#FCF9F9;"
 +
|-
 +
!scope="row" colspan="4" style= "background-color: #CAFF94"| Relevant Facility Type from POIs
 +
|-
 +
| ATM, 3578|| GOVERNMENT OFFICE, 9525
 +
|-
 +
| BANK, 6000|| GROCERY STORE, 5400
 +
|-
 +
| BAR OR PUB, 9532|| HIGHER EDUCATION, 8200
 +
|-
 +
| BOOKSTORE, 9995 || HOSPITAL, 8060
 +
|-
 +
| BOWLING CENTRE, 7933|| HOTEL, 7011
 +
|-
 +
| BUS STATION, 4170|| MEDICAL SERVICE, 9583
 +
|-
 +
| BUSINESS FACILITY, 5000|| PHARMACY, 9565
 +
|-
 +
| CINEMA, 7832|| RESIDENTIAL AREA/BUILDING, 9590
 +
|-
 +
| CLOTHING STORE, 9537|| RESTAURANT, 5800
 +
|-
 +
| COFFEE SHOP, 9996|| SCHOOL, 8211
 +
|-
 +
| COMMUTER RAIL STATION, 4100|| SHOPPING, 6512
 +
|-
 +
| CONSUMER ELECTRONICS STORE, 9987|| SPORTS CENTRE, 7997
 +
|-
 +
| CONVENIENCE STORE, 9535|| SPORTS COMPLEX, 7940
 +
|-
 +
| DEPARTMENT STORE, 9545|| TRAIN STATION, 4013
 +
|-
 +
| INDUSTRIAL ZONE, 9991||
 +
|-
 +
|}
 +
  
  

Latest revision as of 17:10, 24 November 2019

NewTaipeiLogo2(G1Group15).png


Home

Proposal

Poster

Web Maps

Project Report


Project Motivation


Organizations today are collecting data at every level of their business and in volumes that in the past were unimaginable, and 80% of all data collected has a spatial component. Therefore, the ability to generate insights using geospatial information system in the business world become utmost important. In this project, we are required to utilize the sales and geospatial data provided by our client to generate insights and provide recommendations to improve the performance of its stores in different trade areas.

Our client is a global brand in the Food and Beverage industry. It provides both dine-in and food delivery service to its customers. As the number of its stores grows bigger, it urgently needs a way to analyse the performance of its stores in different trade areas. The company provided us with data such as the boundaries and sales of their trade area, and the location of different commercial facilities to conduct our geospatial analysis. Therefore, our team aims to perform in-depth analyses of their geospatial data and uncover the relationship between its stores' location and sales.



Project Objectives


Meme Lovers aims to achieve the following project objectives:

  1. Delineation of trade areas using QGIS
  2. Extraction of targeted POIs from data files
  3. Meaningful compilation of Trade Area-POI web maps
  4. Perform in-depth analyses of our client's geospatial data and uncover the relationship between their stores' location and sales



Data Collection
Data File Description Data Format Purpose
GeoPackage
Taiwan_stores Contains geo-coded stores .gpkg Allocation of Stores
Administrative Boundaries
County MOI Contains county area .shp Show boundary
Town MOI Contains town area .shp Show boundary
Street Contains vector of street and roads .shp Show street and road
Location Maps
AE-20190313寬100高等比(鋁)含框參觀版 Trade area of store .pptx Reference Layer for Digitising
PF-20171122寬62高103(鋁) Trade area of store .pptx Reference Layer for Digitizing
TU-20171128寬83高53(鋁) Trade area of store .pptx Reference Layer for Digitizing
UM-20171212寬80高67.2(木)含框 Trade area of store .pptx Reference Layer for Digitizing
AK-20190402寬90高等比(鋁)實際版 Trade area of store .pptx Reference Layer for Digitizing
GH-20171121寬90高70(鋁) Trade area of store .pptx Reference Layer for Digitizing
HT-20150407寬90高115(木) Trade area of store .pptx Reference Layer for Digitizing
MQ-20171120寬70高70(鋁)含框 Trade area of store .pptx Reference Layer for Digitizing
SH-20171128寬84高76(鋁)含框 Trade area of store .pptx Reference Layer for Digitizing
TC-20171129寬121高92(木)含框 Trade area of store .pptx Reference Layer for Digitizing
TR-20171128寬70高70(鋁) Trade area of store .pptx Reference Layer for Digitizing
XS-20171129寬63高93(木) Trade area of store .pptx Reference Layer for Digitizing
YG-20171128寬92高92(鋁) Trade area of store .pptx Reference Layer for Digitizing
Points of Interest
Business Contains locations of businesses .shp Type of facility that will be used for analysis
CommSvc Contains locations of community service facilities .shp Type of facility that will be used for analysis
EduInsts Contains locations of education institutions .shp Type of facility that will be used for analysis
Entertn Contains locations of entertainment facilities .shp Type of facility that will be used for analysis
FinInsts Contains locations of financial institutions .shp Type of facility that will be used for analysis
Hospital Contains locations of medical facilities .shp Type of facility that will be used for analysis
MiscCategories Contains locations of miscellaneous amenities .shp Type of facility that will be used for analysis
ParkRec Contains locations of parks and recreational areas .shp Type of facility that will be used for analysis
Restrnts Contains locations of restaurants .shp Type of facility that will be used for analysis
Shopping Contains locations of shopping malls .shp Type of facility that will be used for analysis
TransHub Contains locations of transport hubs .shp Type of facility that will be used for analysis
TravDest Contains locations of travel destinations .shp Type of facility that will be used for analysis


Scope Of Work
Our team has been allocated 13 Stores in New Taipei City (shown in the map below)
Wiki scope final.jpg
The table below shows the relevant facility types extracted from POI files
Relevant Facility Type from POIs
ATM, 3578 GOVERNMENT OFFICE, 9525
BANK, 6000 GROCERY STORE, 5400
BAR OR PUB, 9532 HIGHER EDUCATION, 8200
BOOKSTORE, 9995 HOSPITAL, 8060
BOWLING CENTRE, 7933 HOTEL, 7011
BUS STATION, 4170 MEDICAL SERVICE, 9583
BUSINESS FACILITY, 5000 PHARMACY, 9565
CINEMA, 7832 RESIDENTIAL AREA/BUILDING, 9590
CLOTHING STORE, 9537 RESTAURANT, 5800
COFFEE SHOP, 9996 SCHOOL, 8211
COMMUTER RAIL STATION, 4100 SHOPPING, 6512
CONSUMER ELECTRONICS STORE, 9987 SPORTS CENTRE, 7997
CONVENIENCE STORE, 9535 SPORTS COMPLEX, 7940
DEPARTMENT STORE, 9545 TRAIN STATION, 4013
INDUSTRIAL ZONE, 9991


Project Schedule


ProjectSchedule.png