Herp part disposition missing but location exists

[anna-chinn]

There are specimens that are listed in inventory spreadsheet as missing from 2008-2012 inventory, but John Archer appears to have found them since and marked them with a part location. These should be checked again to make sure that they are actually in the collection.

SELECT ATTRIBUTE_VALUE, CAT_NUM, COLL_OBJ_DISPOSITION

from SPECIMEN_PART_ATTRIBUTE

FULL JOIN SPECIMEN_PART on SPECIMEN_PART_ATTRIBUTE.COLLECTION_OBJECT_ID = SPECIMEN_PART.COLLECTION_OBJECT_ID
FULL JOIN CATALOGED_ITEM on SPECIMEN_PART.DERIVED_FROM_CAT_ITEM = CATALOGED_ITEM.COLLECTION_OBJECT_ID
FULL JOIN COLL_OBJECT on SPECIMEN_PART.COLLECTION_OBJECT_ID = COLL_OBJECT.COLLECTION_OBJECT_ID

WHERE collection_cde = 'Herp' and
SPECIMEN_PART_ATTRIBUTE.ATTRIBUTE_VALUE is not null and
SPECIMEN_PART_ATTRIBUTE.ATTRIBUTE_TYPE = 'location' and
COLL_OBJ_DISPOSITION != 'in collection'

[anna-chinn]

12 Dec 2019 .CSV from SQL above.

[anna-chinn]

Same issues in reptiles as in amphibian data. I believe this problem comes from having recorded specimen locations from jar labels rather than from jar contents.