Difference between revisions of "G2-Group14 Proposal"

From Geospatial Analytics for Urban Planning
Jump to navigation Jump to search
Line 68: Line 68:
 
|}
 
|}
  
 +
<!-- DATA TABLE CONTENT -->
 +
 +
{| width=99% border=3 align=center font-family:Cambria
 +
! style="text-align: center; font-weight:bold; font-size:22px; background-color: rgb(204, 229, 255);" | Name of Data
 +
! style="text-align: center; font-weight:bold; font-size:22px; background-color: rgb(204, 229, 255);" | Format of Data
 +
! style="text-align: center; font-weight:bold; font-size:22px; background-color: rgb(204, 229, 255);" | Geographic Representation
 +
! style="text-align: center; font-weight:bold; font-size:22px; background-color: rgb(204, 229, 255);" | Source
 +
|-
 +
| colspan="4" style="font-style: bold;font-family: Cambria; background-color: rgb(51, 153, 255);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 Tin Seong
 +
|-
 +
| 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 Tin Seong
 +
|-
 +
| style="background-color:ghostwhite" | TOWN_MOI_1080726
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Polygon (MultiPolygon)
 +
| style="text-align: center;" | Professor Kam Tin Seong
 +
|-
 +
| 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 Tin Seong
 +
|-
 +
| style="background-color:ghostwhite" | VILLAGE_MOI_1080726
 +
| style="text-align: center;" | Shapefile
 +
| style="text-align: center;" | Polygon (MultiPolygon)
 +
| style="text-align: center;" | Professor Kam Tin Seong
 +
|-
 +
| 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" | CU-20171212寬52高42(鋁)含框
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | LF-20190416寬60高76(鋁)
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | LU-20190318寬70高90(木)
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | SC-20171124寬74高90(鋁)含框
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | SZ-20190830寬88.5高100(鋁)含框
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | LW-20180109寬110高76.5(木)
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | WG-20150722寬60高比例(鋁)
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | BL
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | DC
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | DJ
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | DS
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | FW-20171115寬75高80(鋁)含框
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
| style="background-color:ghostwhite" | ZT-20190323寬76高等比(鋁)含框
 +
| style="text-align: center;" | PPTX
 +
| style="text-align: center;" | N.A.
 +
| style="text-align: center;" | Client
 +
|-
 +
 +
 +
|}
  
  

Revision as of 01:32, 24 November 2019

Logo


HOME

PROPOSAL

POSTER

WEB MAPS

REPORT


PROJECT MOTIVATION


Big Data, in today’s context, is indispensable. Businesses are realising its importance and how they should utilize data they have captured over the years by applying analytics. Over the years, Big Data analytics has helped organisations process their data; discovering insights, trends and uncovering potential opportunities. This has benefited these organisations by improving their decision-making and problem solving processes.

When the opportunity to work with an international restaurant franchise arose, our team was more than keen to take on the challenge. With the relevant data readily provided by our client, we will then employ skills like delineating and digitizing the trade areas of our allocated stores, then analyse how other relevant factors such as competitions and human traffic can affect their business across Taipei. In this project, we are excited to apply skill sets that we have acquired in our Geospatial classes to help identify potential hotspots and potential problems that might be occurring. We hope that our analysis can provide the client with valuable insights, and that our proposed recommendations can aid them with their business strategies and decisions in the coming years.


PROJECT OBJECTIVE


The project aims to conduct a thorough analysis of the 13 of our client’s restaurant stores located near the Tamsui River in Taiwan to evaluate the success of each individual store based on their location. We will come up with the following:

  1. Digitized maps on the Quantum Geographic Information System (QGIS) software, based on the subzones labelled and provided to us by the international franchise
  2. Business profiles of each store and their relative performance to each other through extracting out relevant POIs within the trade area and subzones
  3. Setting up buffer zones to evaluate the possibility of creating an accurate business profile of each store through the use of such buffer tools, rather than digitizing the actual map areas given to us
  4. Analyze, research and provide recommendations to our client through the creation of an interesting and informational poster filled with QGIS maps for better visualization, as well as a thorough project report.


PROJECT DATA SETS


Name of Data Format of Data Geographic Representation Source
Geopackage
Taiwan_Stores Shapefile Point Professor Kam Tin Seong
Administrative Boundaries
COUNTY_MOI_1080726 Shapefile Polygon (MultiPolygon) Professor Kam Tin Seong
TOWN_MOI_1080726 Shapefile Polygon (MultiPolygon) Professor Kam Tin Seong
VILLAGE_MOI_121_1080726 Shapefile Polygon (MultiPolygon) Professor Kam Tin Seong
VILLAGE_MOI_1080726 Shapefile Polygon (MultiPolygon) Professor Kam Tin Seong
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)
CU-20171212寬52高42(鋁)含框 PPTX N.A. Client
LF-20190416寬60高76(鋁) PPTX N.A. Client
LU-20190318寬70高90(木) PPTX N.A. Client
SC-20171124寬74高90(鋁)含框 PPTX N.A. Client
SZ-20190830寬88.5高100(鋁)含框 PPTX N.A. Client
LW-20180109寬110高76.5(木) PPTX N.A. Client
WG-20150722寬60高比例(鋁) PPTX N.A. Client
BL PPTX N.A. Client
DC PPTX N.A. Client
DJ PPTX N.A. Client
DS PPTX N.A. Client
FW-20171115寬75高80(鋁)含框 PPTX N.A. Client
ZT-20190323寬76高等比(鋁)含框 PPTX N.A. Client



SCOPE OF WORK


CHALLENGES AND ERRORS INCURRED


PROJECT TIMELINE


PROJ SCHEDULE.png


TOOLS USED


  1. QGIS - A Geographic Information System Software
  2. Python - A Programming Language


REFERENCES


About:

  1. https://www.trip.com/travel-guide/taipei/tamsui-river-23866567/
  2. https://guidetotaipei.com/visit/tamsui-fishermans-wharf-%E6%B7%A1%E6%B0%B4%E6%BC%81%E4%BA%BA%E7%A2%BC%E9%A0%AD
Retrieved from ‘https://wiki.smu.edu.sg/1920t1smt201/index.php?title=G2-Group14_Proposal&oldid=12134’