Page MenuHomePhabricator

Import from the Monuments database – Denmark, buildings
Open, In Progress, Needs TriagePublic

Description

SELECT COUNT(*) FROM `monuments_dk-bygninger_(da)`;

→ 7055 rows

Danish listed buildings case ID has ca 1,400 items.

Meaning the missed ID's have to be added to existing items, and possibly some items (how many?) need to be created from scratch.

Event Timeline

Sebastian_Berlin-WMSE changed the task status from Open to In Progress.Sep 30 2021, 1:44 PM

There are 4011 unique ids in the database (out of 7055) and 1433 unique ids on WD (out of 1471). The intersection is 1415, just comparing what ids exist, not if they belong to the same items. 2596 ids exist in the database and not on WD. 18 on WD and not in the database.

I've managed to match 131 items from the database to WD items with no id.

Update: I now have 371 new items and 7344 items to update. What remains is to figure out what to do with the ids that have multiple items in the database, sometimes with multiple buildings.