Difference between revisions of "Two Eyes One Pizza Data"

From Geospatial Analytics for Urban Planning
Jump to navigation Jump to search
Line 34: Line 34:
 
<What data we have here>
 
<What data we have here>
  
<br/><br/>
+
<br/>
 
Steps:
 
Steps:
 
# Align to Geometry and Coordinate Reference System for all files: EPSG:3828
 
# Align to Geometry and Coordinate Reference System for all files: EPSG:3828
 
# Extracting each POI from the different shp files
 
# Extracting each POI from the different shp files
 
# Formation of polygons for each branch to align to ppt slides' trade area
 
# Formation of polygons for each branch to align to ppt slides' trade area
#
+
# Creation of competitors' POI
 +
# Aggregation of count of each POI to each trade area
 +
# Data pre-processing for Sales Data
 +
# Aggregating Sales Data with each branch
 +
# Regression Analysis
  
 
==<div style="background: #8b1209; padding: 15px; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:Helvetica"><font color= #FFFFFF>Extracting Competitor's Data Points</font></div>==
 
==<div style="background: #8b1209; padding: 15px; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:Helvetica"><font color= #FFFFFF>Extracting Competitor's Data Points</font></div>==

Revision as of 10:34, 21 October 2019

2e1p.png

Back to Project Home

 

PROPOSAL

 

DATA TRANSFORMATION

 

POSTER

 

APPLICATION

 

RESEARCH PAPER


Preliminary Data Observations

<What data we have here>


Steps:

  1. Align to Geometry and Coordinate Reference System for all files: EPSG:3828
  2. Extracting each POI from the different shp files
  3. Formation of polygons for each branch to align to ppt slides' trade area
  4. Creation of competitors' POI
  5. Aggregation of count of each POI to each trade area
  6. Data pre-processing for Sales Data
  7. Aggregating Sales Data with each branch
  8. Regression Analysis

Extracting Competitor's Data Points

5 Competitors are identified and they are Dominos Pizza, Napolean Pizza, Mcdonalds, KFC and MosBurger. These data points are crucial in our analysis as they may have a correlation with the sales data. Hence, these competitors branches location have to be extracted from "Restaurant 5800".

After extraction, they are exported as layers in the geopackage to be used for aggregation.

Mac.png

Aggregating POIs into each trade area (Script)

It is an exhausting task to aggregating each of the POIs into each trade area using the "Count Points in Polygon" tool.

The batch processing tool was tried but it is unable to append each newly created POI into an existing geopackage. Hence, a python script was written and it ran under QGIS's Python Console. It utilised "processing.run('qgis:countpointsinpolygon', parameters)" function, an inbuilt function by QGIS.

Learn more about the function here: https://docs.qgis.org/2.8/en/docs/user_manual/processing_algs/qgis/vector_analysis_tools/countpointsinpolygon.html

Py.png

After the aggregation of POIs into each trade area, below is the screenshot of the columns for a particular trade area.

Ta.png

Polygon

Do.png


Comments

Feel free to leave comments / suggestions!