Difference between revisions of "G2-Group15 Proposal"

From Geospatial Analytics for Urban Planning
Jump to navigation Jump to search
 
(30 intermediate revisions by one other user not shown)
Line 5: Line 5:
 
{| align=center width=74.25%
 
{| align=center width=74.25%
  
−
! style="text-align: center; width:20em; height: 2em; border-top:5px ridge #fe0000; border-bottom: 5px ridge #fe0000; font-weight:bold; font-size:30px; font-family:TW Cen MT !important;; background-color: honeydew; color: gold;" | [[G2-Group15 About|<span style="color:gold;">ABOUT]]
+
! style="text-align: center; width:20em; height: 2em; border-top:5px ridge #fe0000; border-bottom: 5px ridge #fe0000; font-weight:bold; font-size:30px; font-family:TW Cen MT !important;; background-color: MediumSeaGreen; color: gold;" | [[G2-Group15 About|<span style="color:gold;">ABOUT]]
  
 
! style="text-align: center; width:20em; height: 2em; border-top:5px ridge #fe0000; border-bottom: 5px ridge #fe0000; font-weight:bold; font-size:30px; font-family:TW Cen MT !important;; background-color: black; color: gold;" | [[G2-Group15 Proposal |<span style="color:gold;">PROPOSAL]]
 
! style="text-align: center; width:20em; height: 2em; border-top:5px ridge #fe0000; border-bottom: 5px ridge #fe0000; font-weight:bold; font-size:30px; font-family:TW Cen MT !important;; background-color: black; color: gold;" | [[G2-Group15 Proposal |<span style="color:gold;">PROPOSAL]]
  
−
! style="text-align: center; width:20em; height: 2em; border-top:5px ridge #fe0000; border-bottom: 5px ridge #fe0000; font-weight:bold; font-size:30px; font-family:TW Cen MT !important;; background-color: honeydew; color: gold;" | [[G2-Group15 Poster|<span style="color:gold;">POSTER]]
+
! style="text-align: center; width:20em; height: 2em; border-top:5px ridge #fe0000; border-bottom: 5px ridge #fe0000; font-weight:bold; font-size:30px; font-family:TW Cen MT !important;; background-color: MediumSeaGreen; color: gold;" | [[G2-Group15 Poster|<span style="color:gold;">POSTER]]
  
−
! style="text-align: center; width:20em; height: 2em; border-top:5px ridge #fe0000; border-bottom: 5px ridge #fe0000; font-weight:bold; font-size:30px; font-family:TW Cen MT !important;; background-color: honeydew; color: gold;" | [[G2-Group15 WebMaps|<span style="color:gold;">WEB MAPS]]
+
! style="text-align: center; width:20em; height: 2em; border-top:5px ridge #fe0000; border-bottom: 5px ridge #fe0000; font-weight:bold; font-size:30px; font-family:TW Cen MT !important;; background-color: MediumSeaGreen; color: gold;" | [[G2-Group15 WebMaps|<span style="color:gold;">WEB MAPS]]
  
−
! style="text-align: center; width:20em; height: 2em; border-top:5px ridge #fe0000; border-bottom: 5px ridge #fe0000; font-weight:bold; font-size:30px; font-family:TW Cen MT !important;; background-color: honeydew; color: gold;" | [[G2-Group15 Report|<span style="color:gold;">REPORT]]
+
! style="text-align: center; width:20em; height: 2em; border-top:5px ridge #fe0000; border-bottom: 5px ridge #fe0000; font-weight:bold; font-size:30px; font-family:TW Cen MT !important;; background-color: MediumSeaGreen; color: gold;" | [[G2-Group15 Report|<span style="color:gold;">REPORT]]
 
|}
 
|}
 +
  
  
Line 20: Line 21:
 
{| align=center width = 100%
 
{| align=center width = 100%
  
−
! style="text-align: center; width:20em; height: 1em; border:5px ridge black; font-weight:bold; font-size:25px; font-family:Georgia !important;; background-color:gold; color: #fe0000;"| PROJECT MOTIVATION
+
! style="text-align: center; width:20em; height: 1em; border:5px ridge black; font-weight:bold; font-size:25px; font-family:Cambria !important;; background-color:gold; color: #fe0000;"| PROJECT MOTIVATION
 
|}
 
|}
 
<!-- PROJECT MOTIVATION TEXT-->
 
<!-- PROJECT MOTIVATION TEXT-->
 
{| align=center width = 100%
 
{| align=center width = 100%
  
−
| style="text-align:justify; width:20em; height: 1em; font-size:17px; font-family:Georgia !important; background-color:ghostwhite; color: black;"|
+
| style="text-align:justify; width:20em; height: 1em; font-size:17px; font-family:Cambria !important; background-color:ghostwhite; color: black;"|
−
 
−
'''Nothing is 台南''' originates as a Business Profiling Project from the ''SMT201-Geographical Information Systems (GIS) for Urban Planning'' module supported by Professor Kam Tin Seong from the School of Information Systems, Singapore Management University, involving data received from an International Food & Beverage franchise (referred to as the 'Client') present in Taiwan.
 
 
   
 
   
−
Our Client has compiled their trade areas in the form of sketch-maps in PowerPoint format. These sketch-maps display their sub-trading areas, trading routes and competitors existing in that trade area.
+
'''Nothing is 台南''' originates as a Business Profiling Project from the ''SMT201-Geographical Information Systems (GIS) for Urban Planning'' module supported by Professor Kam Tin Seong from the School of Information Systems, Singapore Management University, involving data received from an International Food & Beverage franchise (referred to as the 'Client') present in Taiwan.[[File:Screenshot of SubTradeArea G3 1000.jpg|300px|thumb|right|'''<u>Screenshot of Client's PowerPoint Sketch-Map</u>'''<br>
−
 
+
This shows the ''Sub-Trade Area G3 1000'' from one of the many Trade Areas in the PowerPoint Sketch-Map of our Client.<br>]]
−
[[File:Screenshot of SubTradeArea G3 1000.jpg|border|center|Sub-Trade Area]]
+
Our Client has compiled their trade areas in the form of sketch-maps in PowerPoint format. These sketch-maps display their sub-trading areas, trading routes and competitors existing in that trade area.  
−
 
 
 
However, with these sketch-maps being static in nature of its format, the Client has limitations when using such maps for updates and analysis which are not limited to the following:  
 
However, with these sketch-maps being static in nature of its format, the Client has limitations when using such maps for updates and analysis which are not limited to the following:  
  
Line 39: Line 37:
 
* Inability to Analyse Relationships Within and Between Trade Areas
 
* Inability to Analyse Relationships Within and Between Trade Areas
  
−
Hence, our team saw this not only as an opportunity to assist our client, but also to utilize our skills and knowledge gained from the module to real-world applications to better hone them. Our role involves the transformation of these PowerPoint sketch-maps into proper and purposeful web maps using the GIS Software QGIS, allowing our Client to not only have a complete view of their trade areas and sales territories, bringing the Client new insights on their trade areas. Some of the insights include factors and Points of Interests (POIs) that can be affect its sales in their trade areas.
+
Hence, our team saw this not only as an opportunity to assist our client, but also to utilize our skills and knowledge gained from the module to real-world applications to better hone them. Our role involves the transformation of these PowerPoint sketch-maps into proper and purposeful digitized maps using the GIS Software QGIS, allowing our Client to not only have a complete view of their trade areas and sales territories, bringing the Client new insights on their trade areas. Some of the insights include factors and Points of Interests (POIs) that could affect its sales in their trade areas.
 
|}
 
|}
 +
 +
  
 
<!-- PROJECT OBJECTIVE HEADING -->
 
<!-- PROJECT OBJECTIVE HEADING -->
 
{| align=center width = 100%
 
{| align=center width = 100%
  
−
! style="text-align: center; width:20em; height: 1em; border:5px ridge black; font-weight:bold; font-size:25px; font-family:Georgia !important;; background-color:gold; color: #fe0000;"| PROJECT OBJECTIVE
+
! style="text-align: center; width:20em; height: 1em; border:5px ridge black; font-weight:bold; font-size:25px; font-family:Cambria !important;; background-color:gold; color: #fe0000;"| PROJECT OBJECTIVE
 +
|}
 +
 
 +
<!-- PROJECT OBJECTIVE TEXT-->
 +
{| align=center width = 100%
 +
 
 +
| style="text-align:justify; width:20em; height: 1em; font-size:17px; font-family:Cambria !important; background-color:ghostwhite; color: black;"|
 +
 
 +
'''Nothing is 台南''' aims to fulfill the following project objectives:
 +
 
 +
# Creation of digitized web maps via QGIS which delineates both the operational and theoretical trade areas
 +
# Extraction of targeted POIs within each trade area
 +
# Meaningful compilation of Trade Area-POI web maps
 +
# Analysis of Trade Area characteristics based on compiled POI
 +
# Analysis of Sale data according POIs patterns and population density
 +
# Provide optimize solutions to help our client to improve their sales
 +
# Gain learning experience and project exposure
 
|}
 
|}
  
 
<!-- SCOPE OF WORK HEADING -->
 
<!-- SCOPE OF WORK HEADING -->
 +
 
{| align=center width = 100%
 
{| align=center width = 100%
  
−
! style="text-align: center; width:20em; height: 1em; border:5px ridge black; font-weight:bold; font-size:25px; font-family:Georgia !important;; background-color:gold; color: #fe0000;"| SCOPE OF WORK
+
! style="text-align: center; width:20em; height: 1em; border:5px ridge black; font-weight:bold; font-size:25px; font-family:Cambria !important;; background-color:gold; color: #fe0000;"| SCOPE OF WORK
 +
|}
 +
 
 +
<!-- PROJECT OBJECTIVE TEXT-->
 +
{| align=center width = 100%
 +
 
 +
| style="text-align:justify; width:20em; height: 1em; font-size:17px; font-family:Cambria !important; background-color:ghostwhite; color: black;"|
 +
 
 +
Our team was allocated a total of 16 Client stores based on Taiwan, in which all these stores are based in the Southwest coast of Taiwan, specifically the county of Tainan City.
 +
<div><ul>
 +
<li style="display: inline-block;"> [[File:Store Locations (Taiwan Map).jpg|417px|thumb|left|'''<u>Our Allocated Stores on Taiwan Map</u>'''<br>
 +
Our allocated stores all fall within the Southwest county of Tainan City.<br>]] </li>
 +
<li style="display: inline-block;">[[File:Stores Locations (Tainan Map).jpg|760px|thumb|'''<u>Our Allocated Stores on Tainan Map</u>'''<br>
 +
This shows the distribution of our allocated stores within Tainan City.<br>]] </li>
 +
</ul></div>
 +
{| width=40% border=1 align=center font-family:Cambria
 +
  |+ '''''Allocated Stores'''''
 +
|-
 +
| width=50% style="padding:15px;text-align:center;"|AH || width=50% style="padding:15px;text-align:center;"|AN
 +
|-
 +
| width=50% style="padding:15px;text-align:center;"|AP || width=50% style="padding:15px;text-align:center;"|CM (''Tsing Yi'')
 +
|-
 +
| width=50% style="padding:15px;text-align:center;"|CX || width=50% style="padding:15px;text-align:center;"|DM (''DungMen Delco'')
 +
|-
 +
| width=50% style="padding:15px;text-align:center;"|HI || width=50% style="padding:15px;text-align:center;"|JE
 +
|-
 +
| width=50% style="padding:15px;text-align:center;"|KZ || width=50% style="padding:15px;text-align:center;"|MO (''Tainan Madou'')
 +
|-
 +
| width=50% style="padding:15px;text-align:center;"|NY (''Yong Kag'') || width=50% style="padding:15px;text-align:center;"|SK (''Tainan Nan Ca'')
 +
|-
 +
| width=50% style="padding:15px;text-align:center;"|SW (''Shanhua Township'') || width=50% style="padding:15px;text-align:center;"|TN (''Tainan-Gin Hwa'')
 +
|-
 +
| width=50% style="padding:15px;text-align:center;"|YD  || width=50% style="padding:15px;text-align:center;"|YK (''Yung Kang'')
 +
|}
 +
 
 +
 
 +
With our allocated stores all within the same county and most of it in close proximity, we will be identifying any trends and patterns with regards to the location of the stores and their profit performance. We will also be recommending any changes in the location of the stores to possibly improve the profit performance of a re-located trade area without internal competition among our client's stores for sales. Moreover, if there are trade areas (we will refer to them as '''Blanks''') that do not belong to any of our allocated stores, we would also be recommending on the best possible allocated store that should include these blanks based on the store's profit performance.
 
|}
 
|}
  
 
<!-- DATA HEADING -->
 
<!-- DATA HEADING -->
 +
 
{| align=center width = 100%
 
{| align=center width = 100%
  
−
! style="text-align: center; width:20em; height: 1em; border:5px ridge black; font-weight:bold; font-size:25px; font-family:Georgia !important;; background-color:gold; color: #fe0000;"| DATA
+
! style="text-align: center; width:20em; height: 1em; border:5px ridge black; font-weight:bold; font-size:25px; font-family:Cambria !important;; background-color:gold; color: #fe0000;"| DATA
 +
|}
 +
 
 +
<!-- DATA TABLE CONTENT -->
 +
 
 +
{| width=95% border=1 align=center font-family:Cambria
 +
! style="text-align: center; font-weight:bold; background-color:beige;" | Data Name
 +
! style="text-align: center; font-weight:bold; background-color:beige;" | Data Format
 +
! style="text-align: center; font-weight:bold; background-color:beige;" | Geographic Representation
 +
! style="text-align: center; font-weight:bold; background-color:beige;" | Source
 +
|-
 +
| colspan="4" style="font-style: italic;font-family: Cambria; background-color: thistle;text-align: center;" | Geopackage
 +
|-
 +
| style="background-color:ghostwhite" | Taiwan_Stores
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Professor Kam
 +
|-
 +
| colspan="4" style="font-style: italic;font-family: Cambria; background-color: thistle;text-align: center;" | Administrative Boundaries
 +
|-
 +
| style="background-color:ghostwhite" | COUNTY_MOI_1080726
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Polygon (MultiPolygon)
 +
| style="text-align: center;" | Professor Kam
 +
|-
 +
| style="background-color:ghostwhite" | TOWN_MOI_1080726
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Polygon (MultiPolygon)
 +
| style="text-align: center;" | Professor Kam
 +
|-
 +
| style="background-color:ghostwhite" | VILLAGE_MOI_121_1080726
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Polygon (MultiPolygon)
 +
| style="text-align: center;" | Professor Kam
 +
|-
 +
| style="background-color:ghostwhite" | VILLAGE_MOI_1080726
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Polygon (MultiPolygon)
 +
| style="text-align: center;" | Professor Kam
 +
|-
 +
| colspan="4" style="font-style: italic;font-family: Cambria; background-color: thistle;text-align: center;" | Point of Interest (Facility Description, Type)
 +
|-
 +
| colspan="2" style="background-color:ghostwhite" | Business
 +
| colspan="2" style="background-color:silver;" |
 +
|-
 +
| Business Facility, 5000
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| Industrial Area, 9991
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| colspan="2" style="background-color:ghostwhite" | CommSvc
 +
| colspan="2" style="background-color:silver;" |
 +
|-
 +
| Government Office, 9525
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| colspan="2" style="background-color:ghostwhite" | ParkRec
 +
| colspan="2" style="background-color:silver;"  |
 +
|-
 +
| Bowling Centre, 7933
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| Sports Complex, 7940
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| Sports Centre, 7997
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| colspan="2" style="background-color:ghostwhite"  | EduInsts
 +
| colspan="2" style="background-color:silver;"  |
 +
|-
 +
| Higher Education, 8200
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| School, 8211
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| colspan="2" style="background-color:ghostwhite"  | Entertn
 +
| colspan="2" style="background-color:silver;" |
 +
|-
 +
| Bar or Pub, 9532
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| Cinema, 7832
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| Nightlife, 5813
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| Performing Arts, 7929
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| colspan="2" style="background-color:ghostwhite" | MiscCategory
 +
| colspan="2" style="background-color:silver;" |
 +
|-
 +
| Residential Area/ Building, 9590
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| colspan="2" style="background-color:ghostwhite" | FinInsts
 +
| colspan="2" style="background-color:silver;" |
 +
|-
 +
| ATM, 3578
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| Bank, 6000
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| colspan="2" style="background-color:ghostwhite" | Hospital
 +
| colspan="2" style="background-color:silver;" |
 +
|-
 +
| Hospital, 8060
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| Medical Service, 9583
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| colspan="2" style="background-color:ghostwhite" | Restaurants
 +
| colspan="2" style="background-color:silver;" |
 +
|-
 +
| Coffee Shop, 9996
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| Restaurant, 5800
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| colspan="2" style="background-color:ghostwhite" | TransHubs
 +
| colspan="2" style="background-color:silver;" |
 +
|-
 +
| Bus Station, 4170
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| Commuter Rail Station, 4100
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| Train Station, 4013
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| colspan="2" style="background-color:ghostwhite" | Shopping
 +
| colspan="2" style="background-color:silver;" |
 +
|-
 +
| Bookstore, 9995
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| Clothing Store, 9537
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| Consumer Electronics Store, 9987
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| Convenience Store, 9535
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| Department Store, 9545
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| Grocery Store, 5400
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| Pharmacy, 9565
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| Shopping, 6512
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| Specialty Store, 9567
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| colspan="2" style="background-color:ghostwhite" | Travel Destination
 +
| colspan="2" style="background-color:silver;" |
 +
|-
 +
| Hotel, 7011
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Point
 +
| style="text-align: center;" | Client
 +
|-
 +
| colspan="4" style="font-style: italic;font-family: Cambria; background-color: thistle;text-align: center;" |  LocationMap (Sketch-Maps)
 +
|-
 +
| style="background-color:ghostwhite" | AH-20171209寬71高71(木)
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | AN-20171210寬100高100(木)含框
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | AP-20171210寬99高99(木)含框
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | CM-20170310寬75高100(木)亮面
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | CX-20171210寬110高125(木)含框
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | DM-20171106寬97高128(木)含框
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | HI-20171208寬89高比例(木)亮面
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | JE-20171207寬82高75(木)亮面
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | KZ-20170801寬90高95(木)含框亮面
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | MO-20171207寬78高63(木)含框亮面
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | NY-20181107寬75高比例(木)亮面
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | SK-20171211寬110高110()
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | SW-20171211寬117高77(木)含框
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | TN-20171106寬110高90(木)含框
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | YD-20180920寬80高比例(鋁)含框
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | YK-20181107寬85高95(木)亮面
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 
|}
 
|}
  
 
<!-- PROJECT SCHEDULE HEADING -->
 
<!-- PROJECT SCHEDULE HEADING -->
 +
 +
{| align=center width = 100%
 +
 +
! style="text-align: center; width:20em; height: 1em; border:5px ridge black; font-weight:bold; font-size:25px; font-family:Cambria !important;; background-color:gold; color: #fe0000;"| PROJECT SCHEDULE
 +
|}
 +
[[File:G2Group15 Gantt Chart.png|1250px|thumb|center|'''<u>Nothing is 台南: Overall Business Profiling Project Timeline</u>'''<br>
 +
This shows the Gantt Chart of our intended Project Timeline.<br>]]
 +
 +
<!-- REFERENCES HEADING -->
 +
 
{| align=center width = 100%
 
{| align=center width = 100%
  
−
! style="text-align: center; width:20em; height: 1em; border:5px ridge black; font-weight:bold; font-size:25px; font-family:Georgia !important;; background-color:gold; color: #fe0000;"| PROJECT SCHEDULE
+
! style="text-align: center; width:20em; height: 1em; border:5px ridge black; font-weight:bold; font-size:25px; font-family:Cambria !important;; background-color:gold; color: #fe0000;"| REFERENCES
 
|}
 
|}

Latest revision as of 22:21, 24 November 2019


G2Grp15ProposalCover.png


ABOUT PROPOSAL POSTER WEB MAPS REPORT


PROJECT MOTIVATION
Nothing is 台南 originates as a Business Profiling Project from the SMT201-Geographical Information Systems (GIS) for Urban Planning module supported by Professor Kam Tin Seong from the School of Information Systems, Singapore Management University, involving data received from an International Food & Beverage franchise (referred to as the 'Client') present in Taiwan.
Screenshot of Client's PowerPoint Sketch-Map
This shows the Sub-Trade Area G3 1000 from one of the many Trade Areas in the PowerPoint Sketch-Map of our Client.

Our Client has compiled their trade areas in the form of sketch-maps in PowerPoint format. These sketch-maps display their sub-trading areas, trading routes and competitors existing in that trade area. However, with these sketch-maps being static in nature of its format, the Client has limitations when using such maps for updates and analysis which are not limited to the following:

  • Repetitive and Time-consuming Updates of Sketch-Maps in Updates
  • Unknown Overlapping of Trade Areas
  • Inability to Analyse Relationships Within and Between Trade Areas

Hence, our team saw this not only as an opportunity to assist our client, but also to utilize our skills and knowledge gained from the module to real-world applications to better hone them. Our role involves the transformation of these PowerPoint sketch-maps into proper and purposeful digitized maps using the GIS Software QGIS, allowing our Client to not only have a complete view of their trade areas and sales territories, bringing the Client new insights on their trade areas. Some of the insights include factors and Points of Interests (POIs) that could affect its sales in their trade areas.


PROJECT OBJECTIVE

Nothing is 台南 aims to fulfill the following project objectives:

  1. Creation of digitized web maps via QGIS which delineates both the operational and theoretical trade areas
  2. Extraction of targeted POIs within each trade area
  3. Meaningful compilation of Trade Area-POI web maps
  4. Analysis of Trade Area characteristics based on compiled POI
  5. Analysis of Sale data according POIs patterns and population density
  6. Provide optimize solutions to help our client to improve their sales
  7. Gain learning experience and project exposure


SCOPE OF WORK

Our team was allocated a total of 16 Client stores based on Taiwan, in which all these stores are based in the Southwest coast of Taiwan, specifically the county of Tainan City.

  • Our Allocated Stores on Taiwan Map
    Our allocated stores all fall within the Southwest county of Tainan City.
  • Our Allocated Stores on Tainan Map
    This shows the distribution of our allocated stores within Tainan City.
Allocated Stores
AH AN
AP CM (Tsing Yi)
CX DM (DungMen Delco)
HI JE
KZ MO (Tainan Madou)
NY (Yong Kag) SK (Tainan Nan Ca)
SW (Shanhua Township) TN (Tainan-Gin Hwa)
YD YK (Yung Kang)


With our allocated stores all within the same county and most of it in close proximity, we will be identifying any trends and patterns with regards to the location of the stores and their profit performance. We will also be recommending any changes in the location of the stores to possibly improve the profit performance of a re-located trade area without internal competition among our client's stores for sales. Moreover, if there are trade areas (we will refer to them as Blanks) that do not belong to any of our allocated stores, we would also be recommending on the best possible allocated store that should include these blanks based on the store's profit performance.


DATA


Data Name Data Format Geographic Representation Source
Geopackage
Taiwan_Stores Shapefile Point Professor Kam
Administrative Boundaries
COUNTY_MOI_1080726 Shapefile Polygon (MultiPolygon) Professor Kam
TOWN_MOI_1080726 Shapefile Polygon (MultiPolygon) Professor Kam
VILLAGE_MOI_121_1080726 Shapefile Polygon (MultiPolygon) Professor Kam
VILLAGE_MOI_1080726 Shapefile Polygon (MultiPolygon) Professor Kam
Point of Interest (Facility Description, Type)
Business
Business Facility, 5000 Shapefile Point Client
Industrial Area, 9991 Shapefile Point Client
CommSvc
Government Office, 9525 Shapefile Point Client
ParkRec
Bowling Centre, 7933 Shapefile Point Client
Sports Complex, 7940 Shapefile Point Client
Sports Centre, 7997 Shapefile Point Client
EduInsts
Higher Education, 8200 Shapefile Point Client
School, 8211 Shapefile Point Client
Entertn
Bar or Pub, 9532 Shapefile Point Client
Cinema, 7832 Shapefile Point Client
Nightlife, 5813 Shapefile Point Client
Performing Arts, 7929 Shapefile Point Client
MiscCategory
Residential Area/ Building, 9590 Shapefile Point Client
FinInsts
ATM, 3578 Shapefile Point Client
Bank, 6000 Shapefile Point Client
Hospital
Hospital, 8060 Shapefile Point Client
Medical Service, 9583 Shapefile Point Client
Restaurants
Coffee Shop, 9996 Shapefile Point Client
Restaurant, 5800 Shapefile Point Client
TransHubs
Bus Station, 4170 Shapefile Point Client
Commuter Rail Station, 4100 Shapefile Point Client
Train Station, 4013 Shapefile Point Client
Shopping
Bookstore, 9995 Shapefile Point Client
Clothing Store, 9537 Shapefile Point Client
Consumer Electronics Store, 9987 Shapefile Point Client
Convenience Store, 9535 Shapefile Point Client
Department Store, 9545 Shapefile Point Client
Grocery Store, 5400 Shapefile Point Client
Pharmacy, 9565 Shapefile Point Client
Shopping, 6512 Shapefile Point Client
Specialty Store, 9567 Shapefile Point Client
Travel Destination
Hotel, 7011 Shapefile Point Client
LocationMap (Sketch-Maps)
AH-20171209寬71高71(木) PPTX N.A. Client
AN-20171210寬100高100(木)含框 PPTX N.A. Client
AP-20171210寬99高99(木)含框 PPTX N.A. Client
CM-20170310寬75高100(木)亮面 PPTX N.A. Client
CX-20171210寬110高125(木)含框 PPTX N.A. Client
DM-20171106寬97高128(木)含框 PPTX N.A. Client
HI-20171208寬89高比例(木)亮面 PPTX N.A. Client
JE-20171207寬82高75(木)亮面 PPTX N.A. Client
KZ-20170801寬90高95(木)含框亮面 PPTX N.A. Client
MO-20171207寬78高63(木)含框亮面 PPTX N.A. Client
NY-20181107寬75高比例(木)亮面 PPTX N.A. Client
SK-20171211寬110高110() PPTX N.A. Client
SW-20171211寬117高77(木)含框 PPTX N.A. Client
TN-20171106寬110高90(木)含框 PPTX N.A. Client
YD-20180920寬80高比例(鋁)含框 PPTX N.A. Client
YK-20181107寬85高95(木)亮面 PPTX N.A. Client


PROJECT SCHEDULE
Nothing is 台南: Overall Business Profiling Project Timeline
This shows the Gantt Chart of our intended Project Timeline.


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