Difference between revisions of "G2-Group15 Proposal"

From Geospatial Analytics for Urban Planning
Jump to navigation Jump to search
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: Brown; 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: Maroon; 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: Chocolate; 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: Sienna; color: gold;" | [[G2-Group15 Report|<span style="color:gold;">REPORT]]
 
|}
 
|}
  
Line 21: 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.[[File:Screenshot of SubTradeArea G3 1000.jpg|300px|thumb|right|'''<u>Screenshot of Client's PowerPoint Sketch-Map</u>'''<br>
 
'''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>
Line 45: Line 45:
 
{| 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
 
|}
 
|}
  
Line 51: Line 51:
 
{| 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 台南''' aims to fulfill the following project objectives:
 
'''Nothing is 台南''' aims to fulfill the following project objectives:
Line 66: Line 66:
 
{| 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
 
|}
 
|}
  
Line 72: Line 72:
 
{| 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;"|
  
 
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 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.
Line 81: Line 81:
 
This shows the distribution of our allocated stores within Tainan City.<br>]] </li>
 
This shows the distribution of our allocated stores within Tainan City.<br>]] </li>
 
</ul></div>
 
</ul></div>
−
{| width=40% border=1 align=center font-family:Georgia
+
{| width=40% border=1 align=center font-family:Cambria
 
   |+ '''''Allocated Stores'''''
 
   |+ '''''Allocated Stores'''''
 
|-
 
|-
Line 109: Line 109:
 
{| 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 -->
 
<!-- DATA TABLE CONTENT -->
  
−
{| width=95% border=1 align=center font-family:Georgia
+
{| 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 Name
 
! style="text-align: center; font-weight:bold; background-color:beige;" | Data Format
 
! style="text-align: center; font-weight:bold; background-color:beige;" | Data Format
Line 120: Line 120:
 
! style="text-align: center; font-weight:bold; background-color:beige;" | Source
 
! style="text-align: center; font-weight:bold; background-color:beige;" | Source
 
|-
 
|-
−
| colspan="4" style="font-style: italic;font-family: Georgia; background-color: thistle;text-align: center;" | Geopackage
+
| colspan="4" style="font-style: italic;font-family: Cambria; background-color: thistle;text-align: center;" | Geopackage
 
|-
 
|-
 
| style="background-color:ghostwhite" | Taiwan_Stores
 
| style="background-color:ghostwhite" | Taiwan_Stores
Line 127: Line 127:
 
| style="text-align: center;" | Professor Kam
 
| style="text-align: center;" | Professor Kam
 
|-
 
|-
−
| colspan="4" style="font-style: italic;font-family: Georgia; background-color: thistle;text-align: center;" | Administrative Boundaries
+
| 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="background-color:ghostwhite" | COUNTY_MOI_1080726
Line 149: Line 149:
 
| style="text-align: center;" | Professor Kam
 
| style="text-align: center;" | Professor Kam
 
|-
 
|-
−
| colspan="4" style="font-style: italic;font-family: Georgia; background-color: thistle;text-align: center;" | Point of Interest (Facility Description, Type)
+
| 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:ghostwhite" | Business
Line 327: Line 327:
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| colspan="4" style="font-style: italic;font-family: Georgia; background-color: thistle;text-align: center;" |  LocationMap (Sketch-Maps)
+
| 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="background-color:ghostwhite" | AH-20171209寬71高71(木)
Line 414: Line 414:
 
{| 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;"| PROJECT SCHEDULE
 
|}
 
|}
 
[[File:G2Group15 Gantt Chart.png|1250px|thumb|center|'''<u>Nothing is 台南: Overall Business Profiling Project Timeline</u>'''<br>
 
[[File:G2Group15 Gantt Chart.png|1250px|thumb|center|'''<u>Nothing is 台南: Overall Business Profiling Project Timeline</u>'''<br>
Line 423: Line 423:
 
{| 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;"| REFERENCES
+
! 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
 
|}
 
|}

Revision as of 16:24, 31 October 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 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.


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. Presentation of analysis via project report


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
CX DM (DungMen Delco)
HI JE
KZ MO (Tainan Madou)
NY (Tsing Yi) 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
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
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
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=6145’