Using the service area produced in #9 to calculate a count of retailers within 1/2 mile of each school (networked).
Create a spatial join (one-to-many) of the retailers to the service areas
P:\proj_p_s\Stanford_PRC\BOE_2017\data\NetworkAnalysis\School_HalfMileServiceAreas_RetailersBOE2017.shp
Query out the LicenseNum = 0 - Those with a LicenseNum of 0 are those with no stores
(this removes 4,220)
Run a summary of CDS_uniq to return the count of retailers
P:\proj_p_s\Stanford_PRC\BOE_2017\data\NetworkAnalysis\RetailersPerHalfMileNetworked.dbf
Join the count table to the service areas (by CDS_uniq)
Using the service area produced in #9 to calculate a count of retailers within 1/2 mile of each school (networked).
LicenseNum= 0 - Those with a LicenseNum of 0 are those with no stores (this removes 4,220)CDS_uniqto return the count of retailers P:\proj_p_s\Stanford_PRC\BOE_2017\data\NetworkAnalysis\RetailersPerHalfMileNetworked.dbfCDS_uniq)