Changes

Jump to navigation Jump to search
roundleveloutput2.txt is imported into cities as '''roundleveloutput2''', and then left joined with '''populationtablecorrected'''. This is done in last.population.sql, which is in
Z:\Hubs\2017\sql scripts
 
==Population issue==
 
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).

Navigation menu