With CollectionSpace 1.0, the schema have changed, and therefore so will the data mapping and customizations we are employing in the UCJEPS deployment of CollectionSpace 1.0. This is not a final data mapping for the University and Jepson Herbaria. This is just a next iteration. Changes from the previous mapping are in blue.
Data
This iteration will focus on object cataloging data, loans out, and relationships.
If time permits, we will load a 10,000 object record data set. Otherwise, we will stick with the data set loaded into the 0.7 instance (approx 1300 specimens, plus all loans, all persons, all organizations from SMaSCH)
Object cataloging data
See the CollectionSpace catalog schema for 0.7
SMaSCH | CollectionSpace object schema | CS User Interface Title (** = different from UI) | Note |
accession.accession_id | object_number | Accession Number ** | Change field title |
institution.inst_name | collection | Collection Was "responsible department" | Dropdown (Collection values) |
accession.coll_num_prefix + coll_number + coll_num_suffix | other_number | Number Calculation | Moved to Field Collection Number. |
"collector number" | other_number_type | Number Type Fixed text | Not needed if we move this to Field Collection Number. |
accession.notes | comments | Notes Comments | |
objkind.kind | form (Object Description Information) | Form Was "brief_description" | Dropdown (Form values) |
taxon_fullname.fullname | title | Taxon ** | Field Change field title will change |
accession.phenology (decoded) | phase (Object Description Information) | Phenology ** | Was a custom fieldChange field title. Dropdown (Phenology values) |
accession.early_jdate (calc) | field_collection_date_earliest | Field Collection Date Earliest | Custom, temporary Custom |
accession.late_jdate (calc) | field_collection_date_latest | Field Collection Date Latest | Custom , temporary |
accession.datestring | field_collection_date | Field Collection Date Custom, temporary, verbatim | Was a custom field but now exists in the 1.0 schema |
committee.committee_abbr | field_collection_collector (?) | Field Collection Collector | Custom, temporary Was a custom field in 0.7 map. Field_collection_collector now exists, and is tied to Org and Person authorities. |
accession.loc_lat_decimal | field_loc_lat_decimal | Field Location Latitude Decimal | Custom , temporary |
accession.loc_long_decimal | field_loc_long_decimal | Field Location Longitude Decimal | Custom , temporary |
accession.loc_place (calc) | field_loccollection_place (?) | Field Location Verbatim Custom, temporary, calculation ** | Was a custom field in 0.7 map, but now exists in 1.0 map |
accession.loc_county | field_loc_county | Field Location County | Custom , temporary |
accession.loc_state | field_loc_state | Field Location State | Custom , temporary |
accession.loc_country | field_loc_country (temp custom) | Field Location Country | Custom , temporary |
accession.loc_elevation | field_loc_elevation (temp custom) | Field Location Country | Custom , temporary |
accession.coll_num_prefix + coll_number + coll_num_suffix | ? | Field collection number | Now available in 1.0 (was in Other Number in 0.7 map) |
committee.committee_abbr | ? | Field collection collector | Now available in 1.0 (was a custom field) and is tied to person and org authorities. |
"catalog date" | date_association | Date Association | Fixed text. Do not load into 1.0. May end up in Associated Date information eventually, or create date/modify date. |
accession.catalog_date | catalog_date | Date Text | Fixed text. Do not load into 1.0. May end up in Associated Date information eventually, or create date/modify date. |
Notes
- loc_county, loc_state, and loc_country will not be supported by dropdowns for now
- field_collector will not be controlled by an authority in this iteration.
- Collecting event information is being added as custom temporary fields. CollectionSpace will have a separate authority system for collecting events and collectors, so these mappings will change in the future.
...
SMaSCH | CollectionSpace loans out schema | CS User Interface Title (** = different from UI) | Note | ||
loan_event.uc_loan_num + loan_event.jeps_loan_num | Loan out number |
| smasch has two types of loan identifiers. | ||
loan_event.curr_inst | Borrower |
| Probably should keep this as borrowing institution (organization authority) | ||
loan_event: | Borrower's contact |
| Probably should keep this as borrowing agent (person authority) |
|
|
loan_event.inhouse_notes + loan_event.noteworthy_inclusions | Loan out note |
|
| ||
loan_event.loan_status + | Loaned object status |
| It looks like this field is not currently active. smasch keeps track of two status types: | ||
Loan date? |
| Loan Out Date | Does SMaSCH have a loan date? |
Relationships
- Loan Out to Object
...
- Collection values:
- Jepson Herbarium
- University of California Herbarium, UC Berkeley
- University of California
- Form values:
- Illustration
- Mounted on Paper
- Photocopy
- Photograph
- Stored in a Box or Bag
- Phase (Phenology) values:
- Cone
- Flowering
- Flowering/Fruiting
- Fruiting
- Spores/Sporangia
- Vegetative (non-reproductive)
- Loaned Object Status values:
- Active (Unknown)
- Active (All Out)
- Active (All In)
- Active (Partial)
- Active (Discrepancy)
- Cancelled (Unknown)
- Cancelled (All Out)
- Cancelled (All In)
- Cancelled (Partial)
- Cancelled (Discrepancy)
- Other Number Type values:
- Other herbaria accession number
- Copied from accession number
- Exsiccatae number
- Project number
- Genbank number
- Destructive sampling number
- Internal cross reference
- Miscellaneous
Name Authority: Person
SMASCH | cSpace Person Schema | CS User Interface Title (** = different from UI) | Note |
---|---|---|---|
person.person_id | Legacy ID |
| borrower is not part of smasch; newly created to generate pk id for borrowers in loan_event table. |
person.first_name + | Display Name |
|
|
person.first_name | Forename |
|
|
person.other_name | Middle Name |
|
|
person.last_name | Surname |
|
|
person.bio_notes | Biographical Note |
|
|
person.birth_year | Birth Date |
|
|
person.death_year | Death Date |
|
|
loan_event.curr_for_position | Occupation |
|
|
loan_event.curr_inst | Group |
|
|
'collector' + '; name source: ' + data_source.data_src_name | Name Note |
|
|
...