https://bugzilla.wikimedia.org/show_bug.cgi?id=39891
Maarten Dammers <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |RESOLVED Resolution| |FIXED --- Comment #12 from Maarten Dammers <[email protected]> 2012-09-09 13:50:08 UTC --- I think we have fixed it. * Comune field renamed to comune-id (the one with the number) * New field regione-iso for https://en.wikipedia.org/wiki/ISO_3166-2:IT#Regions (adm1) * New field prov=iso for https://en.wikipedia.org/wiki/ISO_3166-2:IT#Provinces (adm2) * New field comune filled with the name of the comune (adm3) Data looks good: mysql> SELECT DISTINCT(CONCAT(`regione-iso`, ' - ', `prov-iso`, ' - ', `comune`)) FROM `monuments_it_(it)` WHERE NOT `regione-iso`=''lIMIT 10; +--------------------------------------------------------------+ | (CONCAT(`regione-iso`, ' - ', `prov-iso`, ' - ', `comune`)) | +--------------------------------------------------------------+ | IT-25 - IT-PV - [[Pavia]] | +--------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> SELECT DISTINCT(CONCAT(`adm1`, ' - ', `adm2`, ' - ', `adm3`)) FROM `monuments_all` WHERE lang='it' AND country='it' AND adm0='it' AND NOT `adm1`=''lIMIT 10; +-------------------------------------------------+ | (CONCAT(`adm1`, ' - ', `adm2`, ' - ', `adm3`)) | +-------------------------------------------------+ | IT-25 - IT-PV - [[Pavia]] | +-------------------------------------------------+ 1 row in set (0.04 sec) The rest of the entries will be populated this weekend -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
