Due to same town.name some town.ids have same population

[alexeyknyshev]

Looks like we need some sort of manual processing. Please determine which one is real (by coords for example) and set population to NULL for others.

SELECT name, population, COUNT(*) count FROM towns
WHERE population IS NOT NULL GROUP BY name HAVING count > 1 ORDER BY population DESC;

We are interested to do manual processing for towns with population > 50k.