Z:\Hubs\2017\sql scripts
===Population issuedata location=== Z:\Hubs\2017\clean data\Population
One issue is that cities without populations in populationtablecorrected but in roundleveloutput2 get dropped later. For example, roundleveloutput2 contains Brooklyn, NY but populationtablecorrected doesn't (its New York count is therefore suspect too).
'''populationtablecorrected''' is loaded from files 'population1.txt' and 'population2.txt'. Dups are removed with a max.
'population1.txt' and 'population2.txt' are in:
Z:\Hubs\2017\clean data\Population
Their construction notes are on [[Hubs#Population_Data]]