G2-Group15 Proposal

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: 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

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