Difference between revisions of "G2-Group14 Proposal"

From Geospatial Analytics for Urban Planning
Jump to navigation Jump to search
 
(22 intermediate revisions by 2 users not shown)
Line 71: Line 71:
  
 
{| width=99% border=3 align=center font-family:Cambria
 
{| 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(77, 166, 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(77, 166, 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(77, 166, 255);" | Geographic Representation
−
! style="text-align: center; font-weight:bold; font-size:22px; background-color: rgb(204, 229, 255);" | Source
+
! style="text-align: center; font-weight:bold; font-size:22px; background-color: rgb(77, 166, 255);" | Source
 
|-
 
|-
−
| colspan="4" style="font-style: bold;font-family: Cambria; background-color: rgb(51, 153, 255);text-align: center;" | Geopackage
+
| colspan="4" style="font-style: bold; font-size:20px; font-family: Cambria; background-color: rgb(179, 215, 255);text-align: center;" | Stores
 
|-
 
|-
−
| style="background-color:ghostwhite" | Taiwan_Stores
+
| style="background-color:white" | Taiwan_Stores
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Professor Kam Tin Seong
 
| 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
+
| colspan="4" style="font-style: bold; font-size:20px; font-family: Cambria; background-color: rgb(179, 215, 255);text-align: center;" | Land Segregation & Roads
 
|-
 
|-
−
| style="background-color:ghostwhite" | COUNTY_MOI_1080726
+
| style="background-color:white" | streets
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
−
| style="text-align: center;" | Polygon (MultiPolygon)
+
| style="text-align: center;" | Line - MultiLineString
 
| style="text-align: center;" | Professor Kam Tin Seong
 
| style="text-align: center;" | Professor Kam Tin Seong
 
|-
 
|-
−
| style="background-color:ghostwhite" | TOWN_MOI_1080726
+
|-
−
| style="text-align: center;" | Shapefile
+
| style="background-color:white" | VILLAGE_MOI_121_1080726
−
| style="text-align: center;" | Polygon (MultiPolygon)
+
| style="text-align: center;" | .shp
 +
| style="text-align: center;" | Polygon - MultiPolygon
 +
| style="text-align: center;" | Professor Kam Tin Seong
 +
|-
 +
| style="background-color:white" | VILLAGE_MOI_1080726
 +
| style="text-align: center;" | .shp
 +
| style="text-align: center;" | Polygon - MultiPolygon
 
| style="text-align: center;" | Professor Kam Tin Seong
 
| style="text-align: center;" | Professor Kam Tin Seong
 
|-
 
|-
−
| style="background-color:ghostwhite" | VILLAGE_MOI_121_1080726
+
| style="background-color:white" | TOWN_MOI_108072
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
−
| style="text-align: center;" | Polygon (MultiPolygon)
+
| style="text-align: center;" | Polygon - MultiPolygon
 
| style="text-align: center;" | Professor Kam Tin Seong
 
| style="text-align: center;" | Professor Kam Tin Seong
 
|-
 
|-
−
| style="background-color:ghostwhite" | VILLAGE_MOI_1080726
+
| style="background-color:white" | COUNTY_MOI_1080726
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
−
| style="text-align: center;" | Polygon (MultiPolygon)
+
| style="text-align: center;" | Polygon - MultiPolygon
 
| style="text-align: center;" | Professor Kam Tin Seong
 
| 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="4" style="font-style: bold; font-size:20px; font-family: Cambria; background-color: rgb(179, 215, 255);text-align: center;" | Points of Interest
 
|-
 
|-
−
| colspan="2" style="background-color:ghostwhite" | Business
+
| colspan="4" style="background-color:rgb(230, 240, 255); text-align: center;" | Business
−
| colspan="2" style="background-color:silver;" |  
 
 
|-
 
|-
−
| Business Facility, 5000
+
| Business Facility - 5000
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| Industrial Area, 9991
+
| Industrial Area - 9991
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| colspan="2" style="background-color:ghostwhite" | CommSvc
+
| colspan="4" style="background-color:rgb(230, 240, 255); text-align: center;" | Entertn
−
| colspan="2" style="background-color:silver;" |  
 
 
|-
 
|-
−
| Government Office, 9525
+
| Bar or Pub - 9532
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| colspan="2" style="background-color:ghostwhite" | ParkRec
+
| Cinema - 7832
−
| colspan="2" style="background-color:silver;"  |
+
| style="text-align: center;" | .shp
−
|-
 
−
| Bowling Centre, 7933
 
−
| style="text-align: center;" | Shapefile
 
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| Sports Complex, 7940
+
| Nightlife - 5813
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| Sports Centre, 7997
+
| Performing Arts - 7929
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| colspan="2" style="background-color:ghostwhite"  | EduInsts
+
| colspan="4" style="background-color:rgb(230, 240, 255); text-align: center;" | CommSvc
−
| colspan="2" style="background-color:silver;" |  
 
 
|-
 
|-
−
| Higher Education, 8200
+
| Government Office - 9525
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| School, 8211
+
| colspan="4" style="background-color:rgb(230, 240, 255); text-align: center;" | Park Recreational
−
| style="text-align: center;" | Shapefile
+
|-
 +
| Bowling Centre - 7933
 +
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| colspan="2" style="background-color:ghostwhite"  | Entertn
+
| Sports Complex - 7940
−
| colspan="2" style="background-color:silver;" |
+
| style="text-align: center;" | .shp
−
|-
 
−
| Bar or Pub, 9532
 
−
| style="text-align: center;" | Shapefile
 
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| Cinema, 7832
+
| Sports Centre - 7997
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| Nightlife, 5813
+
| colspan="4" style="background-color:rgb(230, 240, 255); text-align: center;" | EduInsts
−
| style="text-align: center;" | Shapefile
 
−
| style="text-align: center;" | Point
 
−
| style="text-align: center;" | Client
 
 
|-
 
|-
−
| Performing Arts, 7929
+
| Higher Education - 8200
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| colspan="2" style="background-color:ghostwhite" | MiscCategory
+
| School - 8211
−
| colspan="2" style="background-color:silver;" |
+
| style="text-align: center;" | .shp
−
|-
 
−
| Residential Area/ Building, 9590
 
−
| style="text-align: center;" | Shapefile
 
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| colspan="2" style="background-color:ghostwhite" | FinInsts
+
| colspan="4" style="background-color:rgb(230, 240, 255); text-align: center;" | FinInsts
−
| colspan="2" style="background-color:silver;" |  
 
 
|-
 
|-
−
| ATM, 3578
+
| ATM - 3578
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| Bank, 6000
+
| Bank - 6000
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| colspan="2" style="background-color:ghostwhite" | Hospital
+
| colspan="4" style="background-color:rgb(230, 240, 255); text-align: center; | Hospital
−
| colspan="2" style="background-color:silver;" |  
 
 
|-
 
|-
−
| Hospital, 8060
+
| Hospital - 8060
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| Medical Service, 9583
+
| Medical Service - 9583
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| colspan="2" style="background-color:ghostwhite" | Restaurants
+
| colspan="4" style="background-color:rgb(230, 240, 255); text-align: center;" | Restrnts
−
| colspan="2" style="background-color:silver;" |  
 
 
|-
 
|-
−
| Coffee Shop, 9996
+
| Coffee Shop - 9996
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| Restaurant, 5800
+
| Restaurant - 5800
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| colspan="2" style="background-color:ghostwhite" | TransHubs
+
| colspan="4" style="background-color:rgb(230, 240, 255); text-align: center;" | TransHubs
−
| colspan="2" style="background-color:silver;" |  
 
 
|-
 
|-
−
| Bus Station, 4170
+
| Bus Station - 4170
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| Commuter Rail Station, 4100
+
| Commuter Rail Station - 4100
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| Train Station, 4013
+
| Train Station - 4013
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| colspan="2" style="background-color:ghostwhite" | Shopping
+
| colspan="4" style="background-color:rgb(230, 240, 255); text-align: center;" | Shopping
−
| colspan="2" style="background-color:silver;" |  
 
 
|-
 
|-
−
| Bookstore, 9995
+
| Bookstore - 9995
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| Clothing Store, 9537
+
| Clothing Store - 9537
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| Consumer Electronics Store, 9987
+
| Electronics Store - 9987
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| Convenience Store, 9535
+
| Convenience Store - 9535
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| Department Store, 9545
+
| Department Store - 9545
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| Grocery Store, 5400
+
| Grocery Store - 5400
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| Pharmacy, 9565
+
| Pharmacy - 9565
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| Shopping, 6512
+
| Shopping - 6512
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| Specialty Store, 9567
+
| Specialty Store - 9567
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| colspan="2" style="background-color:ghostwhite" | Travel Destination
+
| colspan="4" style="background-color:rgb(230, 240, 255); text-align: center;" | Travel Destination
−
| colspan="2" style="background-color:silver;" |  
 
 
|-
 
|-
−
| Hotel, 7011
+
| Hotel - 7011
−
| style="text-align: center;" | Shapefile
+
| style="text-align: center;" | .shp
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| colspan="4" style="font-style: italic;font-family: Cambria; background-color: thistle;text-align: center;" | LocationMap (Sketch-Maps)
+
| colspan="4" style="background-color:rgb(230, 240, 255); text-align: center;" | MiscCategories
 
|-
 
|-
−
| style="background-color:ghostwhite" | CU-20171212寬52高42(鋁)含框
+
| Residential Area or Building - 9590
−
| style="text-align: center;" | PPTX
+
| style="text-align: center;" | .shp
−
| style="text-align: center;" | N.A.
+
| style="text-align: center;" | Point
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| style="background-color:ghostwhite" | LF-20190416寬60高76(鋁)
+
| colspan="4" style="font-style: bold; font-size:20px; font-family: Cambria; background-color: rgb(179, 215, 255);text-align: center;" |  Trade Areas
−
| style="text-align: center;" | PPTX
+
|-
−
| style="text-align: center;" | N.A.
+
| style="background-color:white" | CU-20171212寬52高42(鋁)含框
 +
| style="text-align: center;" | .pptx
 +
| style="text-align: center;" | -
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| style="background-color:ghostwhite" | LU-20190318寬70高90(木)
+
| style="background-color:white" | LF-20190416寬60高76(鋁)
−
| style="text-align: center;" | PPTX
+
| style="text-align: center;" | .pptx
−
| style="text-align: center;" | N.A.
+
| style="text-align: center;" | -
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| style="background-color:ghostwhite" | SC-20171124寬74高90(鋁)含框
+
| style="background-color:white" | LU-20190318寬70高90(木)
−
| style="text-align: center;" | PPTX
+
| style="text-align: center;" | .pptx
−
| style="text-align: center;" | N.A.
+
| style="text-align: center;" | -
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| style="background-color:ghostwhite" | SZ-20190830寬88.5高100(鋁)含框
+
| style="background-color:white" | SC-20171124寬74高90(鋁)含框
−
| style="text-align: center;" | PPTX
+
| style="text-align: center;" | .pptx
−
| style="text-align: center;" | N.A.
+
| style="text-align: center;" | -
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| style="background-color:ghostwhite" | LW-20180109寬110高76.5(木)
+
| style="background-color:white" | SZ-20190830寬88.5高100(鋁)含框
−
| style="text-align: center;" | PPTX
+
| style="text-align: center;" | .pptx
−
| style="text-align: center;" | N.A.
+
| style="text-align: center;" | -
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| style="background-color:ghostwhite" | WG-20150722寬60高比例(鋁)
+
| style="background-color:white" | LW-20180109寬110高76.5(木)
−
| style="text-align: center;" | PPTX
+
| style="text-align: center;" | .pptx
−
| style="text-align: center;" | N.A.
+
| style="text-align: center;" | -
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| style="background-color:ghostwhite" | BL
+
| style="background-color:white" | WG-20150722寬60高比例(鋁)
−
| style="text-align: center;" | PPTX
+
| style="text-align: center;" | .pptx
−
| style="text-align: center;" | N.A.
+
| style="text-align: center;" | -
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| style="background-color:ghostwhite" | DC
+
| style="background-color:white" | BL
−
| style="text-align: center;" | PPTX
+
| style="text-align: center;" | .pptx
−
| style="text-align: center;" | N.A.
+
| style="text-align: center;" | -
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| style="background-color:ghostwhite" | DJ
+
| style="background-color:white" | DC
−
| style="text-align: center;" | PPTX
+
| style="text-align: center;" | .pptx
−
| style="text-align: center;" | N.A.
+
| style="text-align: center;" | -
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| style="background-color:ghostwhite" | DS
+
| style="background-color:white" | DJ
−
| style="text-align: center;" | PPTX
+
| style="text-align: center;" | .pptx
−
| style="text-align: center;" | N.A.
+
| style="text-align: center;" | -
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| style="background-color:ghostwhite" | FW-20171115寬75高80(鋁)含框
+
| style="background-color:white" | DS
−
| style="text-align: center;" | PPTX
+
| style="text-align: center;" | .pptx
−
| style="text-align: center;" | N.A.
+
| style="text-align: center;" | -
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
−
| style="background-color:ghostwhite" | ZT-20190323寬76高等比(鋁)含框
+
| style="background-color:white" | FW-20171115寬75高80(鋁)含框
−
| style="text-align: center;" | PPTX
+
| style="text-align: center;" | .pptx
−
| style="text-align: center;" | N.A.
+
| style="text-align: center;" | -
 
| style="text-align: center;" | Client
 
| style="text-align: center;" | Client
 
|-
 
|-
 +
| style="background-color:white" | ZT-20190323寬76高等比(鋁)含框
 +
| style="text-align: center;" | .pptx
 +
| style="text-align: center;" | -
 +
| style="text-align: center;" | Client
 +
|-
 +
 +
 +
|}
  
 +
<br>
  
 +
{| align=center width = 100%| border = "1" cellpadding = "1"
 +
 +
! style="text-align: center; width:20em; height: 3em; font-size:20px; font-family:Arial !important;; background-color:#132569; color: white;"| FUNCTIONS AND ANALYSIS
 
|}
 
|}
  
 +
<!-- 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(77, 166, 255);" | Functions Employed
 +
! style="text-align: center; font-weight:bold; font-size:22px; background-color: rgb(77, 166, 255);" | Analysis Conducted
 +
 +
|-
 +
| style="background-color:white" | Choropleth Mapping
 +
| style="text-align: left;" |
 +
*Revenue Analysis for each of the allocated stores
 +
*Revenue Analysis for each POD in their trade areas
 +
|-
 +
 +
|-
 +
| style="background-color:white" | Count by Polygon – the generation of the 32 main POI variables
 +
| style="text-align: left;" |
 +
*Generation of the Business Profiles for the stores
 +
*Relationship between the Total Number of POIs and Revenue
 +
|-
 +
 +
|-
 +
| style="background-color:white" | Network OD-Matrix (Layers as Table (M:N)) 
 +
| style="text-align: left;" |
 +
*Relationship between the Average Shortest Distance of the POIs from the stores and Revenue
 +
|-
 +
 +
|-
 +
| style="background-color:white" | Multi-Linear Regression (using SAS Enterprise Guide) 
 +
| style="text-align: left;" |
 +
*Relationship between Important Variables and Revenue
 +
|-
 +
 +
|-
 +
| style="background-color:white" | Linear Regression (using SAS Enterprise Guide)
 +
| style="text-align: left;" |
 +
*Relationship between Area of Trade and Revenue
 +
|-
  
 +
|-
 +
| style="background-color:white" | Hub Lines / Distance 
 +
| style="text-align: left;" |
 +
*Relationship between Competitors and Revenue
 +
|-
  
−
<br>
+
|-
 +
| style="background-color:white" | Buffer Generation for 2.5KM, 3.0KM and 3.5KM
 +
| style="text-align: left;" |
 +
*Analysis of the use of Buffers as a Theoretical Trade Area
 +
|-
  
−
{| align=center width = 100%
+
|-
 +
| style="background-color:white" | Iso-Areas as Contours (from Layer)
 +
| style="text-align: left;" |
 +
*Analysis of the use of Network Service Area as a Theoretical Trade Area
 +
*Comparison between the use of Theoretical Trade Areas and the Actual Digitised Trade Areas
 +
|-
  
−
| style="text-align:justify; width:20em; height: 1em; font-size:15px; font-family:Arial!important; background-color:#BOC4DE; color: black;"|
+
|-
 +
| colspan="4" style="font-style: bold; font-size:20px; font-family: Cambria; background-color: rgb(179, 215, 255);text-align: center;" | Errors
 +
|-
  
−
{| align=center width = 100%| border = "1" cellpadding = "1"
 
  
−
! style="text-align: center; width:20em; height: 3em; font-size:20px; font-family:Arial !important;; background-color:#132569; color: white;"| SCOPE OF WORK
+
|-
 +
| style="background-color:white" |-
 +
| style="text-align: left;" |  
 +
*Data gap discovered for the Population Data
 +
|-
 
|}
 
|}
  
−
<br>
+
 
  
 
{| align=center width = 100%| border = "1" cellpadding = "1"
 
{| align=center width = 100%| border = "1" cellpadding = "1"
  
−
! style="text-align: center; width:20em; height: 3em; font-size:20px; font-family:Arial !important;; background-color:#132569; color: white;"| CHALLENGES AND ERRORS INCURRED
+
 
−
|}
 
  
 
<br>
 
<br>
Line 419: Line 475:
 
! style="text-align: center; width:20em; height: 3em; font-size:20px; font-family:Arial !important;; background-color:#132569; color: white;"| TOOLS USED  
 
! style="text-align: center; width:20em; height: 3em; font-size:20px; font-family:Arial !important;; background-color:#132569; color: white;"| TOOLS USED  
 
|}
 
|}
 +
[[File:qgislogo.PNG|100px|]]
 +
[[File:saslogo.JPG|100px|]]
 +
[[File:Excellogo.png|70px|]]
 +
[[File:Powerpointlogo.png|70px|]]
 +
[[File:Wordlogo.png|70px|]]
 +
[[File:Googdoc.png|100px|]]
 +
[[File:Googleforms.png|100px|]]
 +
<br>
  
−
<br>
+
# QGIS - Our platform to analyze and edit spatial information, in addition to composing and exporting graphical maps
 +
# SAS Enterprise Guide - Our platform to generate and calculate Multi-Regression Lines and Col-linearity between Points of Interests
 +
# Microsoft Excel - Our platform for data cleaning and calculations
 +
# Microsoft PowerPoint - Our platform to construct the Poster and Executive Report
 +
# Microsoft Word - Our platform for Final Report
 +
# Google Docs - Our platform for weekly discussions and report write up
 +
# Google Forms - Our platform for FeedBack during Townhall Presentation
  
−
# QGIS - A Geographic Information System Software
 
−
# Python - A Programming Language
 
−
 
−
<br>
 
  
 
{| align=center width = 100%| border = "1" cellpadding = "1"
 
{| align=center width = 100%| border = "1" cellpadding = "1"

Latest revision as of 01:23, 25 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
Stores
Taiwan_Stores .shp Point Professor Kam Tin Seong
Land Segregation & Roads
streets .shp Line - MultiLineString Professor Kam Tin Seong
VILLAGE_MOI_121_1080726 .shp Polygon - MultiPolygon Professor Kam Tin Seong
VILLAGE_MOI_1080726 .shp Polygon - MultiPolygon Professor Kam Tin Seong
TOWN_MOI_108072 .shp Polygon - MultiPolygon Professor Kam Tin Seong
COUNTY_MOI_1080726 .shp Polygon - MultiPolygon Professor Kam Tin Seong
Points of Interest
Business
Business Facility - 5000 .shp Point Client
Industrial Area - 9991 .shp Point Client
Entertn
Bar or Pub - 9532 .shp Point Client
Cinema - 7832 .shp Point Client
Nightlife - 5813 .shp Point Client
Performing Arts - 7929 .shp Point Client
CommSvc
Government Office - 9525 .shp Point Client
Park Recreational
Bowling Centre - 7933 .shp Point Client
Sports Complex - 7940 .shp Point Client
Sports Centre - 7997 .shp Point Client
EduInsts
Higher Education - 8200 .shp Point Client
School - 8211 .shp Point Client
FinInsts
ATM - 3578 .shp Point Client
Bank - 6000 .shp Point Client
Hospital
Hospital - 8060 .shp Point Client
Medical Service - 9583 .shp Point Client
Restrnts
Coffee Shop - 9996 .shp Point Client
Restaurant - 5800 .shp Point Client
TransHubs
Bus Station - 4170 .shp Point Client
Commuter Rail Station - 4100 .shp Point Client
Train Station - 4013 .shp Point Client
Shopping
Bookstore - 9995 .shp Point Client
Clothing Store - 9537 .shp Point Client
Electronics Store - 9987 .shp Point Client
Convenience Store - 9535 .shp Point Client
Department Store - 9545 .shp Point Client
Grocery Store - 5400 .shp Point Client
Pharmacy - 9565 .shp Point Client
Shopping - 6512 .shp Point Client
Specialty Store - 9567 .shp Point Client
Travel Destination
Hotel - 7011 .shp Point Client
MiscCategories
Residential Area or Building - 9590 .shp Point Client
Trade Areas
CU-20171212寬52高42(鋁)含框 .pptx - Client
LF-20190416寬60高76(鋁) .pptx - Client
LU-20190318寬70高90(木) .pptx - Client
SC-20171124寬74高90(鋁)含框 .pptx - Client
SZ-20190830寬88.5高100(鋁)含框 .pptx - Client
LW-20180109寬110高76.5(木) .pptx - Client
WG-20150722寬60高比例(鋁) .pptx - Client
BL .pptx - Client
DC .pptx - Client
DJ .pptx - Client
DS .pptx - Client
FW-20171115寬75高80(鋁)含框 .pptx - Client
ZT-20190323寬76高等比(鋁)含框 .pptx - Client


FUNCTIONS AND ANALYSIS


Functions Employed Analysis Conducted
Choropleth Mapping
  • Revenue Analysis for each of the allocated stores
  • Revenue Analysis for each POD in their trade areas
Count by Polygon – the generation of the 32 main POI variables
  • Generation of the Business Profiles for the stores
  • Relationship between the Total Number of POIs and Revenue
Network OD-Matrix (Layers as Table (M:N))
  • Relationship between the Average Shortest Distance of the POIs from the stores and Revenue
Multi-Linear Regression (using SAS Enterprise Guide)
  • Relationship between Important Variables and Revenue
Linear Regression (using SAS Enterprise Guide)
  • Relationship between Area of Trade and Revenue
Hub Lines / Distance
  • Relationship between Competitors and Revenue
Buffer Generation for 2.5KM, 3.0KM and 3.5KM
  • Analysis of the use of Buffers as a Theoretical Trade Area
Iso-Areas as Contours (from Layer)
  • Analysis of the use of Network Service Area as a Theoretical Trade Area
  • Comparison between the use of Theoretical Trade Areas and the Actual Digitised Trade Areas
Errors
-
  • Data gap discovered for the Population Data



PROJECT TIMELINE


PROJ SCHEDULE.png


TOOLS USED

Qgislogo.PNG Saslogo.JPG Excellogo.png Powerpointlogo.png Wordlogo.png Googdoc.png Googleforms.png

  1. QGIS - Our platform to analyze and edit spatial information, in addition to composing and exporting graphical maps
  2. SAS Enterprise Guide - Our platform to generate and calculate Multi-Regression Lines and Col-linearity between Points of Interests
  3. Microsoft Excel - Our platform for data cleaning and calculations
  4. Microsoft PowerPoint - Our platform to construct the Poster and Executive Report
  5. Microsoft Word - Our platform for Final Report
  6. Google Docs - Our platform for weekly discussions and report write up
  7. Google Forms - Our platform for FeedBack during Townhall Presentation


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=12754’