Difference between revisions of "G2-Group04 Proposal"

From Geospatial Analytics for Urban Planning
Jump to navigation Jump to search
 
(22 intermediate revisions by 2 users not shown)
Line 32: Line 32:
 
<br>
 
<br>
 
<br>
 
<br>
−
Using the various functions available on QGIS, we are able to help the FNB business to conduct analysis on the correlation between various factors, such as the Point-Of-Interests (POIs) and Population Density, and the Sales Revenue of the 13 trade areas where this FNB business operates in. At the same time, we are able to advise the FNB business on how to delineate trade areas more efficiently and less tediously.  
+
Using the various functions available on QGIS, we are able to help the FNB business to conduct analysis on the correlation between various factors, such as the Point-Of-Interests (POIs) and Competitors, and the Sales Revenue of the 13 trade areas where this FNB business operates in. At the same time, we are able to advise the FNB business on how to delineate trade areas more efficiently and less tediously.  
 
<br>
 
<br>
 
<br>
 
<br>
−
By doing so, we aim to optimise the performance of each store located in these trade areas and we hope to highlight the benefits of adopting the QGIS method so that the FNB business can make more informed business decisions in the future based on the insights they have gathered from QGIS.   
+
Also, we aim to optimise the performance of each store located in these trade areas and we hope to highlight the benefits of adopting the QGIS method so that the FNB business can make more informed business decisions in the future based on the insights they have gathered from QGIS and SAS analysis.   
 
<br>
 
<br>
  
−
== <font face="Lato Black">Project Motivation</font> ==
 
 
<br>
 
<br>
−
As the FNB business expands, it gets increasingly difficult to accurately keep track of the various factors that affects the business performance. Various factors such as the number of POIs and population density can affect the human traffic in each of the trade area and should be considered with utmost importance. Hence, using QGIS and SAS Enterprise Guide will be able to provide a much more precise analysis for the outlets in the trade areas.  
+
<!--PROJECT MOTIVATION-->
 +
{|style="background-color:#000000; color:#FBE46C;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"  |
 +
| style="padding:0.3em; font-size:100%; background-color:#000000; border-bottom:0px solid #000000; border-top:0px solid #000000; text-align:center; color:#FBE46C" width="10%" |
 +
<font color="#FBE46C" size=3 font face = "Lato Black"><b>PROJECT MOTIVATION</b></font>
 +
<!--/PROJECT MOTIVATION-->
 +
|}
 +
<!--PROJECT MOTIVATION TEXT-->
 +
<br>
 +
As the FNB business expands, it gets increasingly difficult to accurately keep track of the various factors that affects the business performance. Various factors such as the number of POIs and competitors can affect the human traffic in each of the trade area and should be considered with utmost importance. Hence, using QGIS and SAS Enterprise Guide will be able to provide a much more precise analysis for the outlets in the trade areas.  
 
<br>
 
<br>
 
<br>
 
<br>
Line 46: Line 53:
 
<br>
 
<br>
 
<br>
 
<br>
−
This provides the FNB business with a more realistic & better representation of their stores’ environment through the analysis of the data provided by the food chain business and generated by QGIS and SAS Enterprise Guide. This will allow the business to make plans on how to optimise performance for its stores.  
+
This provides the FNB business with a more realistic & better representation of their stores’ environment through the analysis of the data provided by the food chain business and generated by QGIS and SAS Enterprise Guide. This will allow the business to make plans on how to optimise performance for its stores.  
 +
<br>
 +
 
 +
<br>
 +
<!--PROJECT DATA-->
 +
{|style="background-color:#000000; color:#FBE46C;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"  |
 +
| style="padding:0.3em; font-size:100%; background-color:#000000; border-bottom:0px solid #000000; border-top:0px solid #000000; text-align:center; color:#FBE46C" width="10%" |
 +
<font color="#FBE46C" size=3 font face = "Lato Black"><b>PROJECT DATA</b></font>
 +
<!--/PROJECT DATA-->
 +
|}
 +
<!--PROJECT DATA TEXT-->
 +
<br>
 +
{| class="wikitable" style="background: #FCFAD3; text-align: center; width: 1000px; border-width: 3px;"
 +
|-
 +
! <font color="#000000" size=2 font face = "Lato Black">DATA FILE NAME</font> !! <font color="#000000" size=2 font face = "Lato Black">DESCRIPTION</font> !! <font color="#000000" size=2 font face = "Lato Black">DATA FORMAT</font> !! <font color="#000000" size=2 font face = "Lato Black">SOURCE</font> !! <font color="#000000" size=2 font face = "Lato Black">USAGE</font>
 +
|-
 +
!scope="row" colspan="5"|<font color="#000000" size=2 font face = "Lato Black"><b>GeoPackage</b></font>
 +
|-
 +
| Taiwan_stores.gpkg || Contains properties of all 240 Taiwan_stores || GPKG || SMT201_Busines Profiling Project OneDrive Folder<br>(Client) || Allocation of Stores
 +
|-
 +
!scope="row" colspan="5"|<font color="#000000" size=2 font face = "Lato Black"><b>Location Map</b></font>
 +
|-
 +
| CC-20171113<br>寬65高43(鋁) || Contains Drive-Time Map of Trade Area CC || PPTX || SMT201_Busines Profiling Project OneDrive Folder (Client) || Reference to transfer and digitize Trade Area CC onto QGIS
 +
|-
 +
| CL-20171113<br>寬74高75(木)含框 || Contains Drive-Time Map of Trade Area CL || PPTX || SMT201_Busines Profiling Project OneDrive Folder (Client) || Reference to transfer and digitize Trade Area CL onto QGIS 
 +
|-
 +
| GM-20171112<br>寬70高70(鋁) || Contains Drive-Time Map of Trade Area GM || PPTX || SMT201_Busines Profiling Project OneDrive Folder (Client) || Reference to transfer and digitize Trade Area GM onto QGIS
 +
|-
 +
| HL-20171112<br>寬90高60(鋁) || Contains Drive-Time Map of Trade Area HL || PPTX || SMT201_Busines Profiling Project OneDrive Folder (Client) || Reference to transfer and digitize Trade Area HL onto QGIS
 +
|-
 +
| JI-20190102<br>寬72高100(鋁)含框 || Contains Drive-Time Map of Trade Area JI || PPTX || SMT201_Busines Profiling Project OneDrive Folder (Client) || Reference to transfer and digitize Trade Area JI onto QGIS
 +
|-
 +
| KC-20180112<br>寬93高102(鋁)含框 || Contains Drive-Time Map of Trade Area KC || PPTX || SMT201_Busines Profiling Project OneDrive Folder (Client) || Reference to transfer and digitize Trade Area KC onto QGIS
 +
|-
 +
| MD-20170606<br>寬85高60(鋁) || Contains Drive-Time Map of Trade Area MD || PPTX || SMT201_Busines Profiling Project OneDrive Folder (Client) || Reference to transfer and digitize Trade Area MD onto QGIS
 +
|-
 +
| MH-20171110<br>寬80高90(鋁) || Contains Drive-Time Map of Trade Area MH || PPTX || SMT201_Busines Profiling Project OneDrive Folder (Client) || Reference to transfer and digitize Trade Area MH onto QGIS
 +
|-
 +
| MJ-20171031<br>寬74.5高60(鋁)含框 || Contains Drive-Time Map of Trade Area MJ || PPTX || SMT201_Busines Profiling Project OneDrive Folder (Client) || Reference to transfer and digitize Trade Area MJ onto QGIS
 +
|-
 +
| RS-20171128<br>寬74高74(鋁)含框 || Contains Drive-Time Map of Trade Area RS || PPTX || SMT201_Busines Profiling Project OneDrive Folder (Client) || Reference to transfer and digitize Trade Area RS onto QGIS
 +
|-
 +
| YH-20171112<br>寬80高55(鋁) || Contains Drive-Time Map of Trade Area YH || PPTX || SMT201_Busines Profiling Project OneDrive Folder (Client) || Reference to transfer and digitize Trade Area YH onto QGIS
 +
|-
 +
| YJ-20171214<br>寬62高87(鋁) || Contains Drive-Time Map of Trade Area YJ || PPTX || SMT201_Busines Profiling Project OneDrive Folder (Client) || Reference to transfer and digitize Trade Area YJ onto QGIS
 +
|-
 +
| YN-20171016<br>寬60高65(鋁) || Contains Drive-Time Map of Trade Area YN || PPTX || SMT201_Busines Profiling Project OneDrive Folder (Client) || Reference to transfer and digitize Trade Area YN onto QGIS
 +
|-
 +
!scope="row" colspan="5"|<font color="#000000" size=2 font face = "Lato Black"><b>Point-Of-Interests (POIs)</b></font>
 +
|-
 +
| V7AM181F0WV7000AACV0 || Contains all 37 POIs || CPG, CSV, DBF, MXD, PRJ, '''SHP''', SHX, Text Document || SMT201_Busines Profiling Project OneDrive Folder (Client) || Imported onto QGIS to conduct POI Analysis
 +
|-
 +
!scope="row" colspan="5"|<font color="#000000" size=2 font face = "Lato Black"><b>Relevant Point-Of-Interests (POIs)</b></font>
 +
|-
 +
| metadata || Contains a list of 32 relevant POIs  || XLSX || Prof. Kam || Choosing the appropriate POIs for analysis on QGIS
 +
|-
 +
!scope="row" colspan="5"|<font color="#000000" size=2 font face = "Lato Black"><b>Admin Boundary</b></font>
 +
|-
 +
| COUNTY_MOI_1080726 || Contains 22 County in Taiwan || SHP || SMT201_Busines Profiling Project OneDrive Folder (Client) || Reference layer on QGIS
 +
|-
 +
| TOWN_MOI_1080726 || Contains 368 Town in Taiwan || SHP || SMT201_Busines Profiling Project OneDrive Folder (Client) || Reference layer on QGIS
 +
|-
 +
| VILLAGE_MOI_121_1080726 || Contains 7679 Village in Taiwan || SHP || SMT201_Busines Profiling Project OneDrive Folder (Client) || Reference layer to digitize onto QGIS
 +
|-
 +
| VILLAGE_MOI_1080726 || Contains 7965 Village in Taiwan || SHP || SMT201_Busines Profiling Project OneDrive Folder (Client) || Reference layer on QGIS
 +
|-
 +
!scope="row" colspan="5"|<font color="#000000" size=2 font face = "Lato Black"><b>Store Sales Data</b></font>
 +
|-
 +
| Store_sales_data || Contains Store Sales Data for all 240 stores || CSV || SMT201_Busines Profiling Project OneDrive Folder (Client) || Used for further analysis for each store in each POD and Trade Area 
 +
|-
 +
!scope="row" colspan="5"|<font color="#000000" size=2 font face = "Lato Black"><b>Map Release</b></font>
 +
|-
 +
| Map Releases - Taiwan (TWN) v181G0 Release Notes || Provides details about version 181G0 of the Map Releases - Taiwan (TWN) Baseline and Feature Introduction Map Products || PDF || SMT201_Busines Profiling Project OneDrive Folder (Client) || Matches each POI Facility Description to their POI Facility Type
 +
|}
 +
<br>
 +
[[File:POI-LEGEND.jpg|600px|frameless|center]]
 +
<center> Higher Resolution: https://tinyurl.com/G2Group4POI
 +
<br>
 +
<!--PROJECT SCOPE-->
 +
{|style="background-color:#000000; color:#FBE46C;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"  |
 +
| style="padding:0.3em; font-size:100%; background-color:#000000; border-bottom:0px solid #000000; border-top:0px solid #000000; text-align:center; color:#FBE46C" width="10%" |
 +
<font color="#FBE46C" size=3 font face = "Lato Black"><b>PROJECT SCOPE</b></font>
 +
<!--/PROJECT SCOPE-->
 +
|}
 +
<!--PROJECT SCOPE TEXT-->
 +
<br>
 +
 
 +
[[File:G2G4 Project Scope.png|800px|frameless|center|Project Timeline]]
  
 
<br>
 
<br>
−
== <font face="Lato Black">Project Timeline</font> ==
+
<!--PROJECT TIMELINE-->
 +
{|style="background-color:#000000; color:#FBE46C;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"  |
 +
| style="padding:0.3em; font-size:100%; background-color:#000000; border-bottom:0px solid #000000; border-top:0px solid #000000; text-align:center; color:#FBE46C" width="10%" |
 +
<font color="#FBE46C" size=3 font face = "Lato Black"><b>PROJECT TIMELINE</b></font>
 +
<!--/PROJECT TIMELINE-->
 +
|}
 
<br>
 
<br>
−
[[File:Updated project timeline.png|800px|frameless|center|Project Timeline]]
+
[[File:G2G4 timeline.png|800px|frameless|center|Project Timeline]]

Latest revision as of 12:46, 24 November 2019

G2G4 LOGO.png

HOME

PROPOSAL

POSTER

WEB MAPS


PROJECT DESCRIPTION


A Food and Nutrition Board (FNB) International Food Chain is interested in improving their current methods of delineation and analysis.

Using the various functions available on QGIS, we are able to help the FNB business to conduct analysis on the correlation between various factors, such as the Point-Of-Interests (POIs) and Competitors, and the Sales Revenue of the 13 trade areas where this FNB business operates in. At the same time, we are able to advise the FNB business on how to delineate trade areas more efficiently and less tediously.

Also, we aim to optimise the performance of each store located in these trade areas and we hope to highlight the benefits of adopting the QGIS method so that the FNB business can make more informed business decisions in the future based on the insights they have gathered from QGIS and SAS analysis.


PROJECT MOTIVATION


As the FNB business expands, it gets increasingly difficult to accurately keep track of the various factors that affects the business performance. Various factors such as the number of POIs and competitors can affect the human traffic in each of the trade area and should be considered with utmost importance. Hence, using QGIS and SAS Enterprise Guide will be able to provide a much more precise analysis for the outlets in the trade areas.

Also, the current method that has been adopted by the FNB business to delineate the trade areas is Microsoft PowerPoint. This is a less effective approach as compared to using QGIS. Hence, we believe that by utilizing QGIS to digitize and delineate the different trade areas, the analysis process will be less tedious and less time-consuming as the data is being integrated into a single platform and allows for an easier integration for future usage.

This provides the FNB business with a more realistic & better representation of their stores’ environment through the analysis of the data provided by the food chain business and generated by QGIS and SAS Enterprise Guide. This will allow the business to make plans on how to optimise performance for its stores.


PROJECT DATA


DATA FILE NAME DESCRIPTION DATA FORMAT SOURCE USAGE
GeoPackage
Taiwan_stores.gpkg Contains properties of all 240 Taiwan_stores GPKG SMT201_Busines Profiling Project OneDrive Folder
(Client)		 Allocation of Stores
Location Map
CC-20171113
寬65高43(鋁)		 Contains Drive-Time Map of Trade Area CC PPTX SMT201_Busines Profiling Project OneDrive Folder (Client) Reference to transfer and digitize Trade Area CC onto QGIS
CL-20171113
寬74高75(木)含框		 Contains Drive-Time Map of Trade Area CL PPTX SMT201_Busines Profiling Project OneDrive Folder (Client) Reference to transfer and digitize Trade Area CL onto QGIS
GM-20171112
寬70高70(鋁)		 Contains Drive-Time Map of Trade Area GM PPTX SMT201_Busines Profiling Project OneDrive Folder (Client) Reference to transfer and digitize Trade Area GM onto QGIS
HL-20171112
寬90高60(鋁)		 Contains Drive-Time Map of Trade Area HL PPTX SMT201_Busines Profiling Project OneDrive Folder (Client) Reference to transfer and digitize Trade Area HL onto QGIS
JI-20190102
寬72高100(鋁)含框		 Contains Drive-Time Map of Trade Area JI PPTX SMT201_Busines Profiling Project OneDrive Folder (Client) Reference to transfer and digitize Trade Area JI onto QGIS
KC-20180112
寬93高102(鋁)含框		 Contains Drive-Time Map of Trade Area KC PPTX SMT201_Busines Profiling Project OneDrive Folder (Client) Reference to transfer and digitize Trade Area KC onto QGIS
MD-20170606
寬85高60(鋁)		 Contains Drive-Time Map of Trade Area MD PPTX SMT201_Busines Profiling Project OneDrive Folder (Client) Reference to transfer and digitize Trade Area MD onto QGIS
MH-20171110
寬80高90(鋁)		 Contains Drive-Time Map of Trade Area MH PPTX SMT201_Busines Profiling Project OneDrive Folder (Client) Reference to transfer and digitize Trade Area MH onto QGIS
MJ-20171031
寬74.5高60(鋁)含框		 Contains Drive-Time Map of Trade Area MJ PPTX SMT201_Busines Profiling Project OneDrive Folder (Client) Reference to transfer and digitize Trade Area MJ onto QGIS
RS-20171128
寬74高74(鋁)含框		 Contains Drive-Time Map of Trade Area RS PPTX SMT201_Busines Profiling Project OneDrive Folder (Client) Reference to transfer and digitize Trade Area RS onto QGIS
YH-20171112
寬80高55(鋁)		 Contains Drive-Time Map of Trade Area YH PPTX SMT201_Busines Profiling Project OneDrive Folder (Client) Reference to transfer and digitize Trade Area YH onto QGIS
YJ-20171214
寬62高87(鋁)		 Contains Drive-Time Map of Trade Area YJ PPTX SMT201_Busines Profiling Project OneDrive Folder (Client) Reference to transfer and digitize Trade Area YJ onto QGIS
YN-20171016
寬60高65(鋁)		 Contains Drive-Time Map of Trade Area YN PPTX SMT201_Busines Profiling Project OneDrive Folder (Client) Reference to transfer and digitize Trade Area YN onto QGIS
Point-Of-Interests (POIs)
V7AM181F0WV7000AACV0 Contains all 37 POIs CPG, CSV, DBF, MXD, PRJ, SHP, SHX, Text Document SMT201_Busines Profiling Project OneDrive Folder (Client) Imported onto QGIS to conduct POI Analysis
Relevant Point-Of-Interests (POIs)
metadata Contains a list of 32 relevant POIs XLSX Prof. Kam Choosing the appropriate POIs for analysis on QGIS
Admin Boundary
COUNTY_MOI_1080726 Contains 22 County in Taiwan SHP SMT201_Busines Profiling Project OneDrive Folder (Client) Reference layer on QGIS
TOWN_MOI_1080726 Contains 368 Town in Taiwan SHP SMT201_Busines Profiling Project OneDrive Folder (Client) Reference layer on QGIS
VILLAGE_MOI_121_1080726 Contains 7679 Village in Taiwan SHP SMT201_Busines Profiling Project OneDrive Folder (Client) Reference layer to digitize onto QGIS
VILLAGE_MOI_1080726 Contains 7965 Village in Taiwan SHP SMT201_Busines Profiling Project OneDrive Folder (Client) Reference layer on QGIS
Store Sales Data
Store_sales_data Contains Store Sales Data for all 240 stores CSV SMT201_Busines Profiling Project OneDrive Folder (Client) Used for further analysis for each store in each POD and Trade Area
Map Release
Map Releases - Taiwan (TWN) v181G0 Release Notes Provides details about version 181G0 of the Map Releases - Taiwan (TWN) Baseline and Feature Introduction Map Products PDF SMT201_Busines Profiling Project OneDrive Folder (Client) Matches each POI Facility Description to their POI Facility Type


POI-LEGEND.jpg
Higher Resolution: https://tinyurl.com/G2Group4POI


PROJECT SCOPE


Project Timeline


PROJECT TIMELINE


Project Timeline
Retrieved from ‘https://wiki.smu.edu.sg/1920t1smt201/index.php?title=G2-Group04_Proposal&oldid=12221’