american-art / npg

National Portrait Gallery
Creative Commons Zero v1.0 Universal
1 stars 6 forks source link

NPGObjConXrefs:ObjectID #32

Closed steads closed 7 years ago

steads commented 8 years ago

ObjectID: This is a temporary system identifier used to tie records together between files and as such there is no need to map it. A lot of the entries point to ObjectIDs that do not exist in NPGObjects. It would seem rather pointless to export this data as it does not tie back to any objects currently in the collection catalogue. Is this as a result of backlog or disposals?

VladimirAlexiev commented 8 years ago

Right! NPGObjConXrefs refers to 120879 ObjectID while NPGObjects has only 16562.

I would guess that NPGObjects was filtered by some criteria (eg publicly viewable, or sampling of a certain kind of objects), but the same filtering was not applied to NPGObjConXrefs.

NPGObjConXrefs must be filtered to only ObjectID existing in NPGObjects.