Storage locations in SMaSCH
Dick Moe writes:
Storage location is potentially tracked in the SMASCH table Annotation_as_filed in the field collectionkind_id. We currently have the following collectionkinds:
- Main (=default)
- Fruit and Cone
- liquid preserved
- long-term processing
- display
- exsiccatae
- historical
- Moorea
- Types
- Reference
- Horticultural
- Indefinite loan
We have not made much use of the field, nor have we maintained the data in the field consistently. By that I mean, for example, that there has been no effort to update the field if a specimen has been removed from the reference collection (which is supposed to have 6106 specimens according to the table)
I think that collectionkind_id can be directly mapped to CS::storage_location
objkind_id is descriptive, not locational, although certain objkind_ids would never be found associated with certain collectionkind_ids.
With respect to filing name: The current name is always stored in annotation_asfiled::taxon_id. annotation_asfiled::genus_id represents the cabinet location. It is usually the same as the genus part of the current name. That is, the genus_id of specimens with a taxon_id corresponding to Packera cana ordinarily would correspond to Packera. However, to accommodate nomenclatural transfers not accompanied by physical
movement of the specimens, the genus_id can be any taxon_id. So that if half of the species of Packera must be transferred to Senecio
the specimens of the nomenclaturally transferred taxa could remain where they were. Their taxon_id would change, but the genus_id (representing their physical location) could remain the same. We have used this feature sparingly.