Difference between revisions of "G1-Group15"
Jump to navigation
Jump to search
| Line 49: | Line 49: | ||
!scope="row" colspan="4" style= "background-color: #49D525"|<b>''GeoPackage''</b> | !scope="row" colspan="4" style= "background-color: #49D525"|<b>''GeoPackage''</b> | ||
|- | |- | ||
| − | | Taiwan_stores || Contains geo-coded stores || .gpkg || | + | | Taiwan_stores || Contains geo-coded stores || .gpkg || Allocation of Stores |
|- | |- | ||
|-style= "background-color: #FFFACD" | |-style= "background-color: #FFFACD" | ||
| Line 65: | Line 65: | ||
!scope="row" colspan="4" style= "background-color: #49D525"|<b>''Location Maps''</b> | !scope="row" colspan="4" style= "background-color: #49D525"|<b>''Location Maps''</b> | ||
|- | |- | ||
| − | | AE-20190313寬100高等比(鋁)含框參觀版|| Trade area of store || .pptx || | + | | AE-20190313寬100高等比(鋁)含框參觀版|| Trade area of store || .pptx || Reference Layer for Digitising |
|- | |- | ||
| − | | PF-20171122寬62高103(鋁) || Trade area of store || .pptx || | + | | PF-20171122寬62高103(鋁) || Trade area of store || .pptx || Reference Layer for Digitizing |
|- | |- | ||
| − | | TU-20171128寬83高53(鋁) || Trade area of store || .pptx || | + | | TU-20171128寬83高53(鋁) || Trade area of store || .pptx || Reference Layer for Digitizing |
|- | |- | ||
| − | | UM-20171212寬80高67.2(木)含框 || Trade area of store || .pptx || | + | | UM-20171212寬80高67.2(木)含框 || Trade area of store || .pptx || Reference Layer for Digitizing |
|- | |- | ||
| − | | AK-20190402寬90高等比(鋁)實際版 || Trade area of store || .pptx || | + | | AK-20190402寬90高等比(鋁)實際版 || Trade area of store || .pptx || Reference Layer for Digitizing |
|- | |- | ||
| − | | GH-20171121寬90高70(鋁)|| Trade area of store || .pptx || | + | | GH-20171121寬90高70(鋁)|| Trade area of store || .pptx || Reference Layer for Digitizing |
|- | |- | ||
| − | | HT-20150407寬90高115(木) || Trade area of store || .pptx || | + | | HT-20150407寬90高115(木) || Trade area of store || .pptx || Reference Layer for Digitizing |
|- | |- | ||
| − | | MQ-20171120寬70高70(鋁)含框 || Trade area of store || .pptx || | + | | MQ-20171120寬70高70(鋁)含框 || Trade area of store || .pptx || Reference Layer for Digitizing |
|- | |- | ||
| − | | SH-20171128寬84高76(鋁)含框 || Trade area of store || .pptx || | + | | SH-20171128寬84高76(鋁)含框 || Trade area of store || .pptx || Reference Layer for Digitizing |
|- | |- | ||
| − | | TC-20171129寬121高92(木)含框 || Trade area of store || .pptx || | + | | TC-20171129寬121高92(木)含框 || Trade area of store || .pptx || Reference Layer for Digitizing |
|- | |- | ||
| − | | TR-20171128寬70高70(鋁) || Trade area of store || .pptx || | + | | TR-20171128寬70高70(鋁) || Trade area of store || .pptx || Reference Layer for Digitizing |
|- | |- | ||
| − | | XS-20171129寬63高93(木) || Trade area of store || .pptx || | + | | XS-20171129寬63高93(木) || Trade area of store || .pptx || Reference Layer for Digitizing |
|- | |- | ||
| − | | YG-20171128寬92高92(鋁) || Trade area of store || .pptx || | + | | YG-20171128寬92高92(鋁) || Trade area of store || .pptx || Reference Layer for Digitizing |
|- | |- | ||
|-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: #49D525"|<b>''Points of Interest ''</b> | ||
|- | |- | ||
| − | | Business || Contains locations of businesses || .shp || | + | | Business || Contains locations of businesses || .shp || Type of facility that will be used for analysis |
|- | |- | ||
| − | | CommSvc || Contains locations of community service facilities || .shp || | + | | CommSvc || Contains locations of community service facilities || .shp || Type of facility that will be used for analysis |
|- | |- | ||
| − | | EduInsts || Contains locations of education institutions|| .shp || | + | | EduInsts || Contains locations of education institutions|| .shp || Type of facility that will be used for analysis |
|- | |- | ||
| − | | Entertn || Contains locations of entertainment facilities || .shp || | + | | Entertn || Contains locations of entertainment facilities || .shp || Type of facility that will be used for analysis |
|- | |- | ||
| − | | FinInsts || Contains locations of financial institutions || .shp || | + | | FinInsts || Contains locations of financial institutions || .shp || Type of facility that will be used for analysis |
|- | |- | ||
| − | | Hospital || Contains locations of medical facilities || .shp || | + | | Hospital || Contains locations of medical facilities || .shp || Type of facility that will be used for analysis |
|- | |- | ||
| − | | MiscCategories || Contains locations of miscellaneous amenities || .shp || | + | | 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 || | + | | ParkRec || Contains locations of parks and recreational areas || .shp || Type of facility that will be used for analysis |
|- | |- | ||
| − | | Restrnts || Contains locations of restaurants || .shp || | + | | Restrnts || Contains locations of restaurants || .shp || Type of facility that will be used for analysis |
|- | |- | ||
| − | | Shopping || Contains locations of shopping malls || .shp || | + | | Shopping || Contains locations of shopping malls || .shp || Type of facility that will be used for analysis |
|- | |- | ||
| − | | TransHub || Contains locations of transport hubs || .shp || | + | | TransHub || Contains locations of transport hubs || .shp || Type of facility that will be used for analysis |
|- | |- | ||
| − | | TravDest || Contains locations of travel destinations || .shp || | + | | TravDest || Contains locations of travel destinations || .shp || Type of facility that will be used for analysis |
|- | |- | ||
|} | |} | ||
Revision as of 10:39, 21 October 2019
Project Motivation
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.
Project Objectives
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
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 |
| 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.
Project Schedule
