Process:
Top thread:
- Create points for customer location (noting the lat and long as integers)
- Count number of customers (to allow % calculation later)
- Find intersection of customer location with the trade area of each proposed location
- Count number of customers in the trade area of each proposed location
- Append the number of customers in each trade area with the total number of customers
- Calculate % of customer overlaps
- Clean-up
Bottom thread:
- Find overlap of proposed store trade areas with current trade area
- Calculate area of proposed store trade areas
- Calculate area of existing trade area
- Append existing and proposed trade areas
- Calculate % of overlap of areas
- Clean-up