Skip to content

raw_registrations

Info

Data contract for ingesting ADA data from the landing zone into raw. - name: Registrations - version: 0.0.4 - status: active

Terms of Use

Purpose

Data contract for ingesting ADA data from the landing zone into raw.

Servers

Name Type Attributes
production databricks No description.
• environment: production
• roles: [{'role': 'Admins', 'description': 'Access to all the data and settings'}]
• catalog: raw_production
• host: dbc-2030845a-6c3b.cloud.databricks.com
• schema_: ada
development databricks No description.
• environment: development
• roles: [{'role': 'Admins', 'description': 'Access to all the data and settings'}]
• catalog: raw_development
• host: dbc-03ed8bbb-c0ec.cloud.databricks.com
• schema_: ada

Schema

registrations

Table storing data from the ADA system in the raw layer of the Biocloud.

Field Type Attributes
Altitude bigint Elevation above sea level (m).
AriseFieldNumber string Internal ARISE field identifier.
Bait string Type of bait used.
BiotopeId bigint Identifier of the biotope type.
Biotope_label string Human label of the biotope.
Collector_Givenname string Given name of collector.
Collector_Lastname string Last name of collector.
Collector_Preposition string Name preposition (e.g. “van”, “de”).
Collector_Serial string Serial number of collector.
ContainerCode string RMNH number of the container.
• required
• examples: ['RMNH.5113630', 'L.93279234']
• quality: [{'description': 'Data Quality Gate Checks:\n - Value can not exist in the Biocloud already. This typically happens when a row is already uploaded by\n a metadata sheet, and afterwards via the ADA tool. This is not allowed.\nIf rows fail on these quality gate checks, they will be written to Quarantine\n', 'type': 'text'}]
Date string Collection date (as provided).
DateCreated string Timestamp the record was created.
DateModified string Timestamp the record was last modified.
DeterminatorSameAsCollector boolean True if determinator = collector.
Determinator_Givenname string Given name of determinator.
Determinator_Lastname string Last name of determinator.
Determinator_Preposition string Preposition in determinator name.
FlowerCode boolean Whether flower observed.
FruitCode boolean Whether fruit observed.
Groupname string Name of the taxonomic group.
Id string Unique registration identifier.
• primaryKey
• primaryKeyPosition: 1
• required
Image string Image URL or file path.
Latitude double Latitude of identification.
LifestageId bigint Life stage code identifier.
Lifestage_label string Label of life stage.
Location string Place name of collection.
LocationRemarks string Extra notes about location.
Longitude double Longitude of identification.
MountId bigint Mounting method identifier.
Mount_label string Label describing mount method.
PreservationId bigint Preservation method identifier.
Preservation_label string Label of preservation method.
PreservedPartId bigint Identifier of preserved body part.
PreservedPart_label string Label for preserved part.
RegistrationStatus bigint Status code of the registration.
RegistrationStatus_label string Label for status.
RegistrationType bigint Type code of registration.
RegistrationType_label string Label for registration type.
Remarks string Free-text comments.
SampleKitNumber string Identifier of the sampling kit.
SexeId bigint Specimen Sex code identifier.
Sexe_label string Specimen given label for sex.
SpeciesRemarks string Remarks on species identification.
Tags string Free-form tags or keywords.
TrapEnd string Date when trap ended.
TrapSet string Date when trap was set.
TrapTypeId bigint Trap type code identifier.
TrapType_label string Label for trap type.
Uncertain boolean True if identification is uncertain.
UserId string Identifier of the user doing entry.
• required
Verbatim_identification string Original identification text.
Verbatim_kingdom string Original kingdom text.
Verbatim_taxon_rank string Original taxonomic rank text.
inserted_ts_utc timestamp Timestamp in UTC showing when a record was inserted in the Delta table in Biocloud.
updated_ts_utc timestamp Timestamp in UTC showing when a record was last updated in the Delta table in Biocloud.

SLA Properties