Skip to content

raw_lookup_parentage

Info

Data contract for ingesting NBA taxonomic classifications from the landing zone into raw. - name: Lookup_parentage - version: 0.0.2 - status: active

Terms of Use

Purpose

Data contract for ingesting NBA taxonomic classifications 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_: nba
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_: nba

Schema

lookup_parentage

Table storing the taxonomic parentage information from NBA in the raw layer of the Biocloud. It is a lookup table for finding higher-level taxonomy for a taxon.

Field Type Attributes
verbatim_identification string Taxonomic identification name determined by the collector. Used for lookup.
primaryKey
primaryKeyPosition: 1
required
verbatim_identification_rank string Taxonomic rank the specimen was identified at by the collector. Used for lookup.
primaryKey
primaryKeyPosition: 2
required
verbatim_kingdom string Taxonomic kingdom determined by the collector. Used for lookup.
primaryKey
primaryKeyPosition: 3
required
kingdom string Taxonomic kingdom name as resolved by the NBA.
phylum string Taxonomic phylum name as resolved by the NBA.
class_name string Taxonomic class name as resolved by the NBA.
order string Taxonomic order name as resolved by the NBA.
super_family string Taxonomic superfamily name as resolved by the NBA.
family string Taxonomic family name as resolved by the NBA.
genus string Taxonomic genus name as resolved by the NBA.
subgenus string Taxonomic subgenus name as resolved by the NBA.
specific_epithet string Second part of the taxonomic species name, following the genus name. Resolved by the NBA.
infraspecific_epithet string Optional third part of the taxonomic species name, following the specific epithet. Resolved by the NBA.
inserted_ts_utc timestamp UTC timestamp when record was inserted.
updated_ts_utc timestamp UTC timestamp when record was last updated.

SLA Properties