The file is '''colevelsimple.txt'''
In order to see if there are outliers, I get the average coordinates for all cities and find the differences of the firm's coordinates from the city coordinate.
The script for the average city coordinates is in Z:\Hubs\2017\sql scripts and the file name is '''newcolevel.sql'''.
The differences are taken in excel. The file containing the differences is in Z:\Hubs\2017 and the file name is '''new_colevel.txt'''.