Skip to content

using google sheets to manage assemblages #42

Description

@bwprice

A possible mechanism to tag / manage sub-groups of the whole UKSI which fall into specific assemblages, need regular updates, and may have overlapping taxa such as:

  • UK Freshwater Fish
  • PANTHEON assemblage X/Y/Z
  • Invasive species
  • Priority species (identified through stakeholder consultation)
  • Lichen SSSI list

Proposed mechanism:

  1. UKBOL site pulls in entire UKSI and trims it based on rules to remove subspecies etc
  2. UKBOL loads subgroups and their associated tags from the g-sheet(s) - sheet(s) have columns such as:

TVK | Taxon name | tag 1 | tag 2 | etc

  1. UKBOL site has a filter/view mechanism based on tags to show / download only species in the focal assemblage

"show me all freshwater fish / dung associated inverts in Pantheon"

As the link between UKSI and tag is managed in g-sheets the website only needs to load tags using the google API on a schedule

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions