The third step was to define commercial industries that were very likely to be affected by the COVID-19 lockdown. In response to the previous step which examined the economically impacted individuals from the disease, the most at-risk industries we took into consideration included restaurants, accomodations, retails, as well as tow recreation sectors — cinemas and ski centres (City of Vancouver, 2020).
Point data was provided by CanMap for all of the above variables except for restaurants, which was obtained from Statistic Canada and the data format was CSV.
We joined the spread sheet of restaurant to an existing layer, then intersected all 5 layers with the DA layer. Each output layer shows the location for a particular sector in Vancouver. These layers were merged into one single layer, the total number of all 5 factors in each DA were then counted by using a spatial join.
Finally, a hotspot Getis-Ord Gi* analysis was conducted to show the “hot” areas where DAs contain commercial industries that were more at-risk.