[OSM-dev] Duplicated usernames

Paul Norman penorman at mac.com
Thu Oct 10 13:08:21 UTC 2013


If you consume minutely diffs to keep a local copy of OSM data you can 
end up in a situation where you think two user IDs have the same user 
name. For pgsnapshot these duplicates can be found with 

SELECT COUNT(*), name FROM users GROUP BY name HAVING COUNT(*) > 1

The following command should fix all of the duplicates in a pgsnapshot 
database. Other schemas may require different commands.

UPDATE users SET name = 'Agno-phi' WHERE id = 731498;
UPDATE users SET name = 'GrantHeaslip' WHERE id = 476533;
UPDATE users SET name = 'user_1715095' WHERE id = 1715095;
UPDATE users SET name = 'MartinUpOld' WHERE id = 993945;
UPDATE users SET name = 'Dan Baránek' WHERE id = 307530;
UPDATE users SET name = 'Accelerated Global - Internet Marketing' WHERE id =
1431117;
UPDATE users SET name = '0000000000000' WHERE id = 878213;

If you have a local PBF file, I'm not sure the best way to fix it. 
Probably re-download.




More information about the dev mailing list