ChicagoAcademyofSciences / data-cleaning

Documentation, scripts, and look-ups related to cleaning inventory specimen data in preparation to migrate to Arctos.
1 stars 1 forks source link

clean up multiple part locations #4

Closed ekrimmel closed 6 years ago

ekrimmel commented 7 years ago

Some specimen parts have multiple storage location because one or more are historical. We do not need this information. Find all specimen parts with multiple locations, filter out those that are on loan or on exhibit, and discard unnecessary remaining locations.

ekrimmel commented 6 years ago

see SQL; this is done as far as initial legacy data cleaning