enriched_identification_morphology¶
Info¶
Data contract for the Identification Morphology table of the dna domain of the Biocloud. Contains taxonomic identifications based on morphological examination of specimens. - name: Identification Morphology - version: 0.0.1 - status: active
Terms of Use¶
Purpose¶
Data contract for the Identification Morphology table of the dna domain of the Biocloud. Contains taxonomic identifications based on morphological examination of specimens.
Servers¶
| Name | Type | Attributes |
|---|---|---|
| production | databricks | No description. • environment: production • roles: [{'role': 'Admins', 'description': 'Access to all the data and settings'}] • catalog: dna_production • host: dbc-2030845a-6c3b.cloud.databricks.com • schema_: enriched |
| development | databricks | No description. • environment: development • roles: [{'role': 'Admins', 'description': 'Access to all the data and settings'}] • catalog: dna_development • host: dbc-03ed8bbb-c0ec.cloud.databricks.com • schema_: enriched |
Schema¶
identification_morphology¶
The Identification Morphology table contains taxonomic identifications based on morphological examination. These are traditional specimen identifications made by taxonomic experts examining physical characteristics.
| Field | Type | Attributes |
|---|---|---|
| identification_morphology_id | bigint | Biocloud generated identifier for the morphological identification. • primaryKey• primaryKeyPosition: 1 • required |
| material_entity_id | bigint | Foreign key to the material entity table, linking this identification to a specimen. |
| catalog_number | string | Catalog number of the specimen that was identified. • examples: ['RMNH.5143366', 'RMNH.INS.123456'] |
| identification_method | string | Method used for identification. • examples: ['Morphology'] |
| verbatim_identification | string | The scientific name as identified, without interpretation. • examples: ['Apis mellifera Linnaeus, 1758', 'Bombus cf. terrestris'] |
| verbatim_identification_rank | string | Taxonomic rank of the verbatim identification. • examples: ['species', 'genus', 'family', 'subspecies'] |
| verbatim_kingdom | string | Kingdom-level classification of the identification. • examples: ['Animalia', 'Fungi', 'Plantae'] |
| identified_by | string | Name of the person who made the identification. • examples: ['Smith, John', 'Doe, Jane A.'] |
| identified_by_id | string | Identifier of the person who made the identification. |
| date_identified | string | Date when the identification was made (as string). |
| date_identified_ts_utc | timestamp | UTC timestamp when the identification was made. |
| identification_certainty | string | Level of certainty of the identification. • examples: ['certain', 'uncertain', 'probable'] |
| identification_qualifier | string | Qualifier indicating uncertainty or special status (e.g., cf., aff., sp.). • examples: ['cf.', 'aff.', 'sp.', '?'] |
| identification_qualifier_entire_name | string | Qualifier applying to the entire name. |
| identification_qualifier_species_name | string | Qualifier applying specifically to the species name. |
| identification_qualifier_subspecies_name | string | Qualifier applying specifically to the subspecies name. |
| identification_remarks | string | Additional remarks or notes about the identification. |
| identification_verification_status | string | Verification status of the identification. • examples: ['verified', 'unverified', 'requires verification'] |
| type_status | string | Nomenclatural type status if this is a type specimen. • examples: ['holotype', 'paratype', 'syntype', 'lectotype'] |
| source_id | string | The ID of this record in the source system. • required |
| source | string | The name of the source system used to create this record in the table. • required• examples: ['ada', 'sampling-sheet'] |
| inserted_ts_utc | timestamp | UTC timestamp when record was inserted. |
| updated_ts_utc | timestamp | UTC timestamp when record was last updated. |