Diversity Taxon Names

Scope of DiversityTaxonNames within the Diversity Workbench

DiversityTaxonNames provides taxonomic names, their synonyms and hierarchical position for other modules, e.g. DiversityCollection and DiversityDescriptions and on the other hand uses services provided by the modules like DiversityReferences and DiversityProjects.

  The modules communicate with each other to provide their services for the other modules.

May 3, 2024

Subsections of Taxon names

Diversity Taxon Names

Download

Upcoming version

SQL Server 2016

For this version you need SQL Server 2016 or higher

  • New table JsonCache containing the data related to an agent as JSON. In the menu accessible via Administration → Json cache … or in the header click on the Show JsonCache button to see the json cache for the current agent.

Current version

4.2.2 (2025-02-11)

Download

  • Show Images for analysis value in case the value is a link to an image
  • Bugfix in init for reference objects

Database updates

02.05.39
  • Hierarchy
    • TaxonOrder: Adding additional levels of hierarchy
    • TaxonFamily: Adding additional levels of hierarchy
02.05.40 (Repeat 2.5.38 in case of missing updates)
  • Project
    • ProjectUser: Adding ReadOnly for locking a project
    • New function ProjectDataLastChanges
    • ProjectProxy: Adding missing columns for archive
  • Missing descriptions
  • TaxonNameListAnalysisCategory: Adding parent relation

Previous versions

4.2.1 (2023-08-21)

Download

  • Adaptions for IPM
  • Analysis:
    • Additional query column Hierarchy in administration
    • Display of whole hierarchy in tree in main form
  • Hierarchy
    • Bugfix setting hierarchy cache in administration - using database timeout
    • Bugfix setting hierarchy
    • Expanding new parent node after Drag & Drop changes in hierarchy and ensure visibilty of edited node
    • Unified icons for ranks
    • Showing rank or synonymy and name of current taxon in the header
    • Refreshing the hierarchy: Warning when changing the root of the displayed hierarchy
  • Bugfix for external identifiers
  • Bugfix not optimized query
  • Bugfixes creating and restoring archive

Database updates

02.05.38
  • Project
    • ProjectUser: Adding ReadOnly for locking a project
    • New function ProjectDataLastChanges
    • ProjectProxy: Adding missing columns for archive
  • Missing descriptions
  • TaxonNameListAnalysisCategory: Adding parent relation

 

4.2 (2023-05-11)

  • Bugfix setting module connections
  • Database documentation: Enumeration tables with specific title and generic table definition

 

4.1.28 (2023-03-28)

  • New button for filling table SynonymyListCache Video starten
  • New menu for filling table SynonymyListCache
  • Many order columns enabled
  • Several additional order columns
  • Several bugfixes in query using many order columns
  • Bugfix in generation of database documentation
  • Database tools: Adding option to add existence check for description generation
  • Database tools: Adding option to insert deprecated for description
  • Bugfixes for query with many order columns
  • Bugfixes for list view
  • List view with setting for file handling, button to open file etc. Video starten

Database updates

  • 02.05.37: Missing descriptions; TaxonOrder: Adding column IgnoreButKeepForReference for query; TaxonFamily: Adding column IgnoreButKeepForReference for query; New table SynonymyListCache to store results of function SynonymyList; New procedure [procFillSynonymyListCache] to fill table SynonymyListCache; SynonymyList - Try to get data from cache;

4.1.27 (2022-11-29)

  • Update for linked data Video starten
  • Selection of database involved in update of linked data
  • Several bugfixes

Database updates

  • 02.05.35: New view AcceptedNameChanges; Grants for TaxonNameReference;
  • 02.05.36: New function TaxonChildNodes including FamiliyCache, OrderCache, HierarchyCache;

Subsections of Download

Diversity Taxon Names

Installation

Resources

To run a module of the Diversity Workbench framework, you need access to a database and an installation of the respective client. The following instructions explain how to install the DiversityCollection client. All other modules are installed in the same way.

If you do not yet have an account for your institutional DWB platform, please contact your institution’s DWB administrator. If you wish to set up and use your own personal, institutional, domain-specific, or research-group-internal database environment, see Installation of a database for more information.

A German-language video demonstrates the installation using the DC client as an example. Please note that the initial steps in the video are outdated, as the downloads are now available via this manual, as described below. .

Download

All DiversityWorkbench modules can be downloaded free of charge. Within each module in the manual, you will find a Download menu item. There, you can download the latest version in the Current version section.

Installation of the client

The client is currently based on the .Net framework version 4.8 from Microsoft. If not already present, the software will prompt you to install it.

After downloading the client, unzip the .zip folder. The extracted setup folder contains two files: an .msi and a .bat file.

If you want to install the client on your computer, start the installation by double-clicking the .msi file.

If necessary, you can adjust the installation location in the next step.

Once the installation is complete, the software will be added to the program menu (see below) and a shortcut will be created on the desktop.

In the next chapter Database Login the login process is explained.

Troubleshooting

If you don’t have sufficient permissions on your computer to install anything, you can use the client by following the instructions Run the program without an installer. If you receive a warning from Windows that this computer is protected, follow the instructions Windows protection warning.

Run program without installer

There are several reasons why you might prefer to run DiversityCollection without installation. E.g. if you lack administrative permissions on your computer or if you want to use several different versions of DiversityCollection in parallel.

Therefore, the downloaded .zip file contains a .bat file. With this .bat file, a folder DiversityCollection_x_x_x is created on your desktop containing all relevant files to run the client DiversityCollection.

You have to unzip the downloaded .zip file to a local folder. The unzipped folder contains the .msi file and the .bat file. Within this unzipped! folder start the .bat file with a double-click. You might get a security warning, as shown in the section Windows protection warning.

The batch file unpacks the program files to a folder on your desktop named DiversityCollection_x_x_x, where "x_x_x" stands for the program version.

To start the DiversityCollection program, go to the folder and double-click on the file DiversityCollection.exe.

The login process is explained in the next chapter Database Login.

Technical notes and additional information

The software will be placed in the programs directory, as shown below.

Additionally, a folder is created in the user directory. This folder contains files and templates, for example, for label printing. It also contains hidden folders, such as Query. User input is saved there so that it can be loaded again the next time the program is started.

Windows protection warning

If you receive the following warning from Windows

please click on Weitere Informationen. A button Trotzdem ausführen will appear.

Please click on Trotzdem ausführen to install the software.

 

Apr 16, 2025

Diversity Taxon Names

Menu

Overview of the menu in DiversityTaxonNames

Connection

  • Database …: Choose one of the databases available on the server. Only those databases will be listed to which the user has access permission
  • Module connections …: Edit the connections to the other modules within the Diversity Workbench.
  • Timeout for database …: Set the timeout for database queries.
  • Transfer previous settings: Transfer the settings for IP-Address and port of the server, name of the database, login etc. of a previous version of the client to the current version.
  • Quit: Quit the application and stop all processes started by the application

Query

  • Show query: Show resp. hide the query area
  • Show ignored data: If data that were set on ignore should be visible
  • Predefined queries: This dialog will only appear if predefined queries are available. The submenu then lists the names for the predefined queries

Table views

  • View taxa in table …: Show the taxa in a spreadsheet
  • Edit taxa in table …: Edit the taxa in a spreadsheet
  • Spreadsheets: Edit data in configurable tables.
    • Taxon sheet…: Edit taxon and dependent data.
  • Table editors: Edit data direct in tables.
    • Taxon name…: Edit data in table TaxonName.
    • Common name…: Edit data in table TaxonCommonName.
    • Typification…: Edit data in table TaxonNameTypification.
    • Geography…: Edit data in table TaxonGeography.
    • External source…: Edit data in table TaxonNameExternalID.
    • Project: Edit data in tables depending on project.
    • Accepted name…: Edit data in table TaxonAcceptedName.
    • Synonymy…: Edit data in table TaxonSynonymy.
    • Hierarchy…: Edit data in table TaxonHierarchy.
    • Resource…: Edit data in table TaxonNameResource.
    • List: Edit data in tables depending on list.
      • Specimen…: Edit data in table TaxonNameListCollectionSpecimen.
      • Reference…: Edit data in table TaxonNameListReference.
      • Distribution…: Edit data in table TaxonNameListDistribution.
      • Analysis…: Edit data in table TaxonNameListAnalysis.

Data

  • Import
    • Import taxonomic names …: Import taxonomic names from text files
    • Import wizard: Import data from tab-separated text files
      • Import Taxa…: Import taxa from tab-separated text files
      • Import Synonyms…: Import synonyms from tab-separated text files
      • Import Hierarchy…: Import hierarchy from tab-separated text files
      • Import Analysis…: Import analysis from tab-separated text files
      • Webservices: Import taxonomic names from webservices
      • MYCOBANK…: Import taxa from MYCOBANK
  • Export
    • Export hierarchy and synonymy …: Export the taxonomic names with their hierachy and synonoymy
    • Export taxon lists …: Export the taxon lists as XML / HTML files
    • Export wizard …: Export tab-separated text files
      • Export taxa…: Export taxa as tab-separated text file
      • Export as CSV (bcp): Export data of the whole database as csv files
  • Replication …: Synchronise the content of 2 databases.
    • Add publisher …: Add a replication publisher for the replication.
    • Replication publisher: Database and server publishing data for replication.
    • Download …: Download data from the data provider in your local database.
    • Merge …: Merge contents between your local database and the replication provider.
    • Upload …: Upload data from your local database to the replication provider.
    • Remove: Remove the replication provider.
    • Clean database …: Clean your local database.
  • Archive: Archives of projects.
    • Administrate archives…: Administrate the projects that should be included in a schedule based archiving.
    • Create archive…: Create and archive of project data.
    • Reset database…: Reset the database, i.e. remove all user data.
    • Restore archive…: Restore project data from an archive.
  • Backup database …: Backup of the whole database
  • Remove taxa…: Remove all taxa selected in the query
  • Remove from project…: Remove all taxa selected in the query from a project

Administration

  • Analysis categories…: Administration of the analysis categories used within the taxon lists
  • Data sources …: Administration of the data sources of the taxonomic names
  • Database
    • Documentation…: Documentation functions for the database
    • Logins …: Administration of the logins and user
    • Maintenance…: Maintenace functions within the DiversityTaxonNames
    • Rename database: Rename the current database
    • Set published address: Setting the address published for links by other modules
    • Database tools: Tools to create and change objects in the database

    Help

  • Manual: Opens the online manual
  • Feedback…: Opens a window for sending feedback
  • Feedback history…: Opens a window for browsing former feedback
  • Statistics: Show the statistics within a project
  • Info: Show the version and corresponding information
  • Errorlog: Show the error log of the application

Test

  • Chart: Opens a chart query

 

Apr 10, 2025

Diversity Taxon Names

Query

Once you are connected to your database, you can search across all data. You have a wide range of options for this search.

Everything related to the query can be found on the left-hand side of the main window.

The upper part of the query section contains the list of all results “Query results”.

Below this you will find a section with all the buttons that are relevant for the search.

Under the query buttons you will find the “Query conditions”. You can enter all possible search criteria here.

Perform a query

Display the entire data set

To display the entire data set, start a search without specifying any criteria in the “Query conditions” section:

  1. In the middle of the query section on the left side of the main window, click on the “filter” button.

  2. A list of the results is displayed in the “Query results” section. The number of results is displayed above the list next to the “Query results” label.

Unter the query buttons, at the bottom of the query section, you will find the “Query conditions”.

  1. Enter the filter criteria for your search. E.g. you can select a project from the dropdown list.
  2. You can combine as many criteria as you want to limit your results.
  3. Start the query by clicking on the filter button .
  4. A list of the results is displayed in the “Query results” section. The number of results is displayed above the list next to the “Query results” label. If no result matches the query, the list is empty and the label “No match” is displayed.

Edit and customize query conditions

You can choose which query conditions are displayed in the main window. You can change this at any time.

  1. At the top left above the query results list, click on the “checkbox” button .

  1. Select any query conditions you want to use for your searches by selecting the respective checkboxes in the treeview.

Customize the interface

Hide/show the entire query section

In the main window go to the menu item QueryShow Query.

Hide the “Query conditions” section

On the left side of the “query buttons” in the middle of the query section, click on the “arrow” button .

Switch vertical/horizontal arrangement

You can change the arrangement of the query elements from vertical to horizontal and vice versa. To do this, click on the button below the main menu bar:

Edit the result list

Add results to the existing list

You can add new results with different query conditions to your current result list.

  1. Enter the new filter criteria for your additional search.
  2. Start and add these query results to the existing result list by clicking on the button .
  3. The new results are appended to the existing list.

Remove result items from the list

You can remove entries from your current result list.

  1. Select the entries you want to delete.
  2. Click on the button .

Important This will not delete the data from the database. It only affects the current display in the results list.

Many result columns

The option to provide a result list with many columns is described in chapter Many result columns.

Query conditions

Remember the last query

By default the values you entered for the query will be remembered. Your query criteria will be pre-filled when the program starts. To change this behaviour, click on the button .

Query annotation

The query for annotations deviates from the standard query (see below). Additionally, you may specify a type of the annotation (Annotation , Problem , Reference ) and the linked table (see Annotation).

Duplicates

Certain query condition fields provide the option to add up to 3 duplicates of themselves. For adding a ‘duplicate’ search criteria, click on the green “Plus” button . Remove a ‘duplicate’ search condition with a click on the red “Minus” button . The restrictions can be combined with AND + and OR |. To change between the modes click on the + resp. | icon.

Query modules

In the “Query conditions” section, some values might be linked to other modules. E.g. within the “Identification” group the fields “Taxa” and “Terms” are linked to the “DiversityTaxonNames” and “DiversityScientificTerms” modules. You can also add “linked” values to your query condition.

  1. Select the operator that determines how the entries are integrated into the search. See an explanation of all available operators in the table below.
  2. To connect to the linked module, click on the “Ammonite” button at the right of the respective query field.

  1. A query window for the linked module will open.
  2. Search for values within the linked module and click ok.
  3. If you want to see a list of the selected items, click on the magnifying glass button .

Info: There is also a detailed Video available, which explains all possible operators and how to use them.

Operator Meaning Example
Search for entries with a list Rosa | Rosa caninia \
Search for entries not within a list Rosa | Rosa caninia | ...
+H search for entry including lower hierarchy Picea | Picea abies | ...
+S search for entry including synonyms Picea abies | Pinus abies | ...
+HS search for entry including lower hierarchy and synonyms Picea | Picea abies | Pinus abies | ...
Change filter mode between link and text http://tnt.diversityworkbench.de/TaxonNames_Plants/4269 <> Picea abies L.

Query any fields

The query for any fields will search in several fields, e.g. withholding reasons in specimen, images etc. There are two versions: The first version (e.g. Notes) will search in all tables but not in collection event tables while the second version (e.g. Any notes) will search in any table (see image below).

Videos

  • Introduction how to use the query conditions: Video starten
  • How to use special query conditions: Video starten
  • Tutorial on how to query modules: Video starten
  • Tutorial on how to save a query: .

Wildcards in SQL

There are 4 different possibilities for wildcards in SQL:

Operator Description Example Result
%   any string consisting of no, one or many characters Pinus % will find anything like Pinus, Pinus sylvestris, Pinus strobus etc.
*  same effect as % (see above)
_  a single character Pinus s_lvestris will find Pinus sylvestris and Pinus silvestris etc.
[…] any character out of a given range like [abcde] or [a-e] Pinus s[iy]lvestris will find Pinus sylvestris and Pinus silvestris
[^…]   any character not in a given range like [^abcde] or [^a-e] Pinus s[^i]lvestris will find Pinus sylvestris but not Pinus silvestris

Many colunns

The option to include several columns in the result list is only available for optimized queries . To display several columns in the result list, click on the button next to the order by column (see below). A window will open where you can select the next column for the sorting. Underneath the order by column the second column for the sorting will be added. To remove this sorting column you can click on the    button. By default the width for the columns is set to 10. You can change this according to content. To set the width to the maximal length of the current content, click on the button. To change the sorting of the added order column click on the button. The colums are separated via " | " as shown in the image below.

For an introduction see the videos:

  • Mehrspaltige Suche: Video starten
  • Sortierung: Video starten

 

Apr 16, 2025

Diversity Taxon Names

Editing the data

The header of the main form allways shows you, with which database you are working, the version of the client, the database server and your login. The area for the data entry is devided into 2 main parts. In the upper part you enter nomenclatural information and facts, in the lower part taxonomic opinions of the editors (see topic database for further informations).

 

To see the descriptions for the fields of the database, simply move your mouse over it. A tooltip will appear with an explanation as shown in the example below.

Where you have to choose names from lists, type the beginning of the name in the field and then click on the drop down button . This will start a query in the database and list the result in the combobox.

If a field is to small for reading its content double-click on it. A form will open, where you can edit the text.

 

Apr 16, 2025

Subsections of Editing

Diversity Taxon Names

External databases

Most names in DiversityTaxonNames were imported from external sources. These sources are documented in the area External data sources.

 

To enter or delete an external datasource, use the and button button respectively. With the button you will get a detailed information about the external database. For a valid URI you can use the button to open the corresponding website in a separate window.

To edit the datasources themselve, choose TaxonNameExternalID and TaxonNameExternalDatabase

Apr 9, 2025

Diversity Taxon Names

Hierarchy

The taxonomy for the choosen name is depicted in the area Hierarchy. If the taxonomy has not been specified a button set hierarchy will be visible

click on it to insert a dataset for the hierarchy of this taxon.

To choose a higher taxon you first have to specify the taxonomic rank of the choosen name

and type at least 2 characters of the higher taxon in the ‘Superior taxon:’ field.

Click on the drop down button to get the list of taxa above the rank of the name for which you want to set the hierarchy. The hierarchy will then be shown in the tree view (see below). The taxa below the current taxon will be displayed in gray.

The first line shows the taxon or taxonomic group superior to the choosen taxon. To directly access the database entry of a higher taxon, choose this taxon in the hierarchy tree and click on . The button  will delete this entry. As an alternative to delete the entry for the hierarchy, you may set it on Ignore to keep the information but exclude it from the creation of a hierarchical tree (see chapter Ignoreddata for further details). To get an overview of the whole hierarchy click on the button . You get an overview for the whole taxonomy including the current taxon as shown below. The line above the hierarchy tree shows the cached value for the hierarchy. After changes in the hierarchy this cached value may differ from the actual hierarchy. To refresh it, click on the button.

 

In the taxon tree the main taxonomic groups are indicated with icons (S = species, G = Genus, F = Family, O = Order, C = Class, K = Kingdom). To change the position of a taxon within the hierarchy, use the drag & drop function of the tree.

To enable a search within the hierarchy, please use the maintenace function to update the hierachy cache. The hierarchy is stored in one string, so to search for e.g. all members of e.g. a certain familiy e.g. Rosaceae, please use the ~ operator and a leading wildcard in your search string e.g. “% Rosaceae” or “* Rosaceae”.

The information about the hierarchy is related to opinions of the editors and are allways restricted to a certain project. The data of the hierarchy are stored in table TaxonHierarchy.

Apr 9, 2025

Diversity Taxon Names

List view

To see the data in a spreadsheet, choose View → List view … from the menu. A window will open where all names from the query will be listed.

Customize visibility of fields

To change the selection of the visible fields, click on the Column visibility button. A window as shown below will open, where you can change the visibility of the columns.

 

Customize sequence

To change the sequence of the columns, just use your mouse to drag the columns to the position of your choice.

Sorting of the data

To sort the data in the grid just click in the header of the column which you want to use as sorting column. The sorting sequence will be kept even if you change values in this column. That means that if you change a value in the sorting column the changed dataset will be placed at the new position according to its new value. The sorting of a column will be indicated with an arrow for the direction of the sorting (up or down).   

Change to data in main form

To change to a name in the main form, click on the , use the button. 

Formatting the grid

To adapt the width of the columns or the height of the rows either drag the border with the mouse, double click the border to get the optimal size for one column or respectively or click on the button for an optimal height of the rows or the button for an optimal width of the columns.

Exporting data

For an introduction see the video: Video starten

After setting the form according to your preferences, you can export the data with a click on the button. If the data should be appended in an existing file, change the option for the file handling from (= New file) to (= Append). The botton opens the folder containing the exported file.

 

 

Apr 9, 2025

Diversity Taxon Names

Projects

Projects with the DiversityWorkbench are located in the database DiversityProjects. The access to the data is organized via projects. The projects a user has access to can be selected in the query options.

 

To edit the project list use the project area. Use the  and  buttons to add or delete projects from the list.

If there are projects, to which you have no access, an additional list will appear, showing these projects (see below).

The information related to opinions of the editors are allways restricted to a certain project (see Database.).

Mar 20, 2025

Diversity Taxon Names

References

References related to a taxon can be added in the area “References”. Use the (add) and the (remove) buttons to handle the references.

The data of the references are stored in table TaxonNameReference.

Apr 9, 2025

Diversity Taxon Names

Relations

Relations between a taxa can be added in the area Relation. Use the (add) and the (remove) buttons to handle the relations.

The data of the relations are stored in table TaxonNameRelation.

Feb 11, 2025

Diversity Taxon Names

Synonymy

Basionym

The name on which the choosen name is based on should be entered in the “Based on:” field.

 

A name can be either an accepted name or a synonym to an accepted name. If nothing was specified so far, two buttons are visible:

choose one of these to make the choosen name to either an accepted name or a synonym.

Synonym

If the name is a synonym, the area for the synonymy will appear as shown in the images<

A name in most cases is synonym to one name but may sometimes be synonym to several names (e.g. pro parte). If you want to keep information of the synonymy you can set it to ignore (see chapter Ignored data for further details).

Delete a synonym

To delete a synonym, choose it in the list and click on the delete button .

Accepted Name

If the name is accepted, the form will show data related to accepted names

You can indicate accepted names in the search result list (in the menu choose View, indicate accepted names)

Conflict (Name declared a synonym and a basionym)

If by any chance (e.g. after import of synonymy relations from a foreign source) a name happens to be a synonym and an accepted name at the same time this is regarded as an error and will be shown as in the image below.

The data for the synonym are shown on the right side with blue labels, while the data for the accepted name are shown on the left with green labels. To correct this error you can either remove or ignore (see chapter Ignoreddata for further details) the assignement as a synonym or an accepted name.

Overview

In the area Synonymy overview you see the accepted name for the name you chose and a list of all the synonyms to this name. The sign   in front of a name following the accepted name means that this and the following names are homotypic synonyms to the accepted name. Groups of hetereotypic names start with a = in front of the first entry. If present, the first entry in each group is the basionym of this group. Names with unclear relation to the accepted name are preceeded by a “-”. To change to one of the names in the list, choose it in the list and click on the search button . The overview can be shown either as a list, corresponding to lists in publications or as a tree view. Use the  and  button to change between these views. In the tree view the current name is marked with a yellow background as shown below. The scrutiny of the search can be adapted by changing the number in the tool bar 3. As standard it is set on 3, but can be changed to values between 0 (just the current name) to 9. The higher the scrutiny the more thoroughly the search for synonyms will be performed and the longer it will take. To speed up the retrieval of the synonymy the results can be stored in a cache table as explained in the tutorial Video starten. Use the button next to the basionym to update the synonymy in the cache table for the current name or choose Administation - Refresh SynonymyListCache from the menu to update the content for all taxa in the database.

Explanation of the example above:

Type Example
accepted name Ceratiomyxa fruticulosa (O.F.Müll) T.Macbr.
basionym  ≡ Byssus fruticulosa O.F.Müll.
homotypic synonym Famintzinia fruticulosa (O.F.Müll.) Lado
heterotypic synonym and basionym  = Tremella hydnoidea Jacq.
heterotypic synonym Ceratium hydnoideum (Jacq.) Alb.& Schwein.

Editor

For a direct editing of synonymy list click on the button  . The list with the selected names and the synonymy overview will get a yellow background (see image).

Now you can add synonyms to the synonymy list by simply dragging them from the selected names list on a name in the synonymy tree view. If you drag the name on the accepted name, it will become a homotypic synonym of the accepted name. If you drag it on a heterotypic synonym, it will become a heterotypic synonym of the accepted name and get the same basionym as the name you dragged it upon. If this name has no basionym, the dragged name will become a homotypic name of the name you dragged it upon. If you want to create a new heterotypic synonym or a synonym with unknown relation to the accepted name, drag the name in the empty space of the tree view.

If you want to correct the synonymy you can drag the names within the synonymy overview either on another name to create a homotypic synonym or into the free space underneath the names to create a heterotypic synonym to the accepted name.

To remove a name from the lists of synonyms, choose it in the tree view and click on the button.

Isonyms, duplicates and orthographic variants

Some names are a variant spelled exactly as another name but with deviating citation of the author(s). These might be a name with wrong citation of the publishing or recombining author(s) or an isonym sensu ICBN. To change the type of the synonymy to an isonym choose the taxon and change the syn. type e.g. to “isonym”. In the synonymy overview list the isonyms, duplicates etc. are indicated by square brackets “[duplicate: … ]”.

Ignored datasets

If it should happen, that a dataset that is ignored is included in a synonymy in the form that another name is referring to this ignored name, the system will not be able to generate the synonymy properly. To detect ignored datasets in the synonymy choose “Query → Show ignored data” from the menu (see chapter Ignored data for further details). Ignored dataset will than be shown with red letters in the synonymy as shown below.

The information about the synonymy is related to opinions of the editors and are allways restricted to a certain project. The data of the synonymy are stored in table TaxonSynonymy. The data of the accepted names are stored in table TaxonAcceptedName.

Apr 9, 2025

Diversity Taxon Names

Lists for taxonomic names

With DiversityTaxonNames you can document list for taxonomic names like e.g. checklists. The taxon lists may refers to a project defined in DiversityProjects (see Administration - User … in the menu). To edit the taxon lists choose Administration → Taxon lists … from the menu. A window as shown below will open, where you can enter, edit or delete taxon lists. The administrative functions are only available for administrators. 

 

For the detailed documentation of the Taxon lists please use DiversityProjects. To load projects into the list, click on the Download projects from DiversityProjects button (see above). A window as shown below will open. If several Databases for DiversityProjects are available on your server you have to choose one of these. The projects available in the DiversityProjects database will be listed as shown below where those already present are checked and green, while missing projects are red. Check those projects you need as lists and click the Start download button.  

For access to the related data choose the tab Taxon lists (see below).  

 

To enter a new list, click on the button. This will open a window where you can choose from the available taxon lists. Choose the list in which you want to include your name and click OK.

Area

The geographical area can be definded for a single name (via Distribution) or for the whole taxon list. The entries refer to the World geographical scheme for recoding plantdistributions. To enter the geographic area for the whole list, click on the button. A form will open where you can choose geographical places from the module DiversityGazetteer. To open the link to the module, click on the button and search for the region as described in the chapter Module related entry.

If you need a certain region not provided in the list, just type the name of the region and click OK. The new region will be listed directly underneath the list (see below).

 

 

References

For every name in a taxon list, you can enter the references where the informations for the list are derived from. To add a reference, select the list for which you want to add a reference and click on the button. The entry for the reference will appear underneath the taxon as shown below. To edit this entry, select it in the hierarchy and use the contols underneath the tree. You may link the reference to an external source like DiversityReferences or one of the provided webservices.

If you want to transfer the informations of a reference together with depending analysis and distribution entries to another name, select the reference in the tree und click on the button. As a result you can use the button to insert these informations at a different place.

 

Analysis

For a name within a list, you can enter an analysis either directly for the name or a reference linked to this name. Select the name or the reference in the tree and click on the  button to enter a new analysis. Depending on the definition of the analysis To edit the analysis used within the database, select it in the tree and use the area below the the tree. Depending on the definition of the analysis (see above) the values are either typed or selected from a list.

To prevent a analysis from publication e.g. via the cache database in DiversityCollection, enter a withholding reason in the corresponding field . The sorting in an interface is set via the sorting. To check the current sorting click on the button.

 

Distribution

For every entry in a taxon list, you can document the distribution of a taxon (see below). This information may be linked to the taxon or a reference (see below).

 

Choose either the list taxon or the reference in the tree and click on the  button to insert a new distribution. The entries refer to the World geographical scheme for recoding plantdistributions. A form will open where you can choose geographical places from the module DiversityGazetteer. To open the link to the module, click on the button and search for the region as described in the chapter Module related entry.

If you need a certain region not provided in the list, just type the name of the region and click OK.

 

Specimen

For every entry in a taxon list, you can document the collection specimen linked to this taxonomic name (see below). The entries may be linked to the module DiversityCollection. To enter a distribution for the specimen, use the button. A window will open (see above), where you can select a geographic region as defined in the  World geographical scheme for recoding plant distributions

 

Export

To export the taxon lists resp. checklist, choose Data → Export taxon list … from the menu. A window as shown below will open. By default the data will be exported as XML (see below). Choose a schema file of your choice to convert the XML-output in a HTML document. You have several options for the export in regard of the names as shown in the window below. The export may be based on the names in the list and can be restricted to the accepted names among these (see below - left). In the second option (see below - right), the accepted names for all names in the list will be selected and the taxon list will contain only these names and optionally their synonyms. Regarding the synonyms, if you want to suppress the export of isonyms and duplicates, use the according checkbox. For long lists, the second method will be rather time consuming, as the synonymy must be checked for every single name. The synonymy for the exort may be derived from any available project. The path of the exported file (either *.xml or *.html) is shown in the field Export file at the bottom of the form. The names in the list may be sorted according to the names or the synonymy where synonyms will be inserted after their assigned accepted names. The format the XML-export with a schema file of your choice, choose the schema file and click on the button.

 

The tables involved in the storage for the taxon list are documented in the taxon list tables part.

Apr 9, 2025

Subsections of Taxon List

Diversity Taxon Names

Analysis in taxonomic lists

To administrate the analysis categories within the taxon lists choose Administration - Analysis … in the menu.

 

The button will open a table editor window where you can edit certain parts of the data.

To export the selected analysis use the button.

To check the sorting of the analysis click on the button. A window will open listing all analysis categories sorted according to the IDs.

The tables involved in the storage for the taxon list are documented in the taxon list tables.

Feb 11, 2025

Diversity Taxon Names

Access restriction to taxonomic lists

If the access of a user should be restricted to names within a taxonomic list, choose Administration - List user … in the menu. A windows as shown below will open, where you can add and remove lists thats should be accessible by a user. The users with no restriction are listed in the left. To restrict a user to a certain list, choose the user in the  list, the list the user should be restricted to and click on the button. The lists a restricted user has access to are listed in the list. To add or remove lists, use the < and > buttons.  

 

The tables involved in the storage for the taxon list are documented in the taxon list tables part.

Jul 19, 2024

Diversity Taxon Names

Edit Taxa In List

To edit the taxa in a spreadsheet, choose View → Edit taxa in list … from the menu. A window will open where all names from the query will be listed.

Customize visibility of fields

To change the selection of the visible fields, click on the Column visibility button. A window as shown below will open, where you can change the visibility of the columns.

 

Customize sequence

To change the sequence of the columns, just use your mouse to drag the columns to the position of your choice.

Sorting of the data

To sort the data in the grid just click in the header of the column which you want to use as sorting column. The sorting sequence will be kept even if you change values in this column. That means that if you change a value in the sorting column the changed dataset will be placed at the new position according to its new value. The sorting of a column will be indicated with an arrow for the direction of the sorting (up or down).   

Change to data in main form

To change to a name in the main form, click on the , use the button. 

Formatting the grid

To adapt the width of the columns or the height of the rows either drag the border with the mouse, double click the border to get the optimal size for one column or respectively or click on the button for an optimal height of the rows or the button for an optimal width of the columns.

 

Apr 9, 2025

Diversity Taxon Names

Data

To save the changes in a dataset click on the button.

To undo the changes in a dataset click the button. This will recover the original data unless the changes had been saved or changes were done in the synonymy.

To create a new entry in the database, click on the  button above the search result listbox. A window will open where you can add additional projects to the list in which the new name shoul be included (see below). By default only your current project will be selected.

 

Leave only those projects the new name is related to. Click OK to create a entry with the name “New Taxon”.

To copy a taxon, choose it from the list and click on the button . As with the creation of a new dataset you can insert the copy of a name into other projects (see above).

To delete a dataset click on the button .

Jul 19, 2024

Diversity Taxon Names

Taxonomic Name

The header shows the name, the ID and the version of the name - these data can not be edited. If a dataset should be ignored, check the checkbox “Ignore”. In the last field you can enter a revision level for the dataset. If you want to inspect the history of a dataset click on the  button.

 

Data concering the taxonomic name including the authors are entered in the corresponding area (see image below).

 

Depending on the taxonomic rank, the form will show only the fields available for this rank.

If the genus is linked to an entry in the database, the field for the genus will change as shown here and the program will not allow you to edit the name. To edit the genus of the name, click the button to release the link to the genus. The list of genera is restricted to the project you selected. If a hierarchy is availble for the selected genus the hierarchy will be automatically inserted for the current name.

If the name is a hybrid , check the checkbox “Is hybrid” to get access to the fields for hybridization.

Apr 9, 2025

Diversity Taxon Names

Authors

For names according to an official code (ICBN) the authors of the name should be given.

To edit the authors using standard abbreviation list click on the Button. This will open the form for editing the authors.

here you add (click on the button) and remove (click on the button) authors according to the standard list. You can choose the standards for the abbreviation from the provided lists.

For names not following an official code authors should not be given. Instead, include a descriptive phrase in the field Non nomenclatural name suffix.

To edit the selected list of the authors click on the Edit author list button.

Jul 19, 2024

Diversity Taxon Names

Nomenclature

DiversityTaxonNames was developed to follow, for the most part, the International Code of Botanical Names (ICBN). Other codes like the code for names in zoology have not yet been taken into account. Information corresponding the nomenclature are entered in the provided fields as shown below.

Jul 19, 2024

Diversity Taxon Names

Taxonomic reference and protologue

Details about the protologue are entered in the area Taxonomic reference / Protologue

 

To enter a website for the protologue either enter the link in the field or click on the button to start a query. This will open simple browser where you can search the URL for the protologue as shown below.

 

Apr 9, 2025

Diversity Taxon Names

Typification

Details about the type can be entered in the area “Typification”.

 

The navigate through the data use the , , and button. To add a new typification use the button, to delete the current dataset, use the button.

Jul 19, 2024

Diversity Taxon Names

Hybrids

As for the time being a definite rule for the creation of a valid taxonomic name on the basis of the parent names is not available. Therefore the name is build from the genus and all the rest placed in the field for the epithet. Some examples for hybrids are: 

  • Asplenium x alternifolium Wulfen.
  • Coeloglossum x Dactylorhiza Coeloglossum viride x Dactylorhiza majalis subsp. praetermissa
  • Ononis repens subsp. procurrens x spinosa subsp. spinosa
  • Salix (caprea x viminalis) x (purpurea x viminalis)
  • Salix alba var. vitellina x babylonica x matsudana
  • Symphoricarpos albus var. laevigatus x microphyllus x orbiculatus

As soon as a rule is available the name can be generated from the parent names that are entered as described below.

If a taxon is a hybrid, check the checkbox to open the part for the entry for the parents of the hybrid. You can determine up to 4 parents for a hybrid as shown in the figure below

 

Jul 19, 2024

Diversity Taxon Names

Common names

A name can have several common names. These are entered in the section Common names. To add or delete a common name use the  and  buttons.

The data of the common names are stored in table TaxonCommonName.

Apr 9, 2025

Diversity Taxon Names

Ignored Data

To remove data from the creation of the hierarchy, the synonymy etc. on one hand and not to delete them but to keep the information, use the Ignore option. All data set to Ignore are no longer involved in the normal queries, but kept to ensure e.g. links from other modules. To display ignored data, select Query - Show ignored data in the menu.

Synonyms

In the example below, a synonym was set on ignore.

 

If it should happen, that a ignored name is included in a synonymy and a name within the synonymy is referring to this ignored name, the system will not be able to generate the synonymy properly. Ignored names will than be shown with red letters in the synonymy overview as shown below.

Accepted names

In the example below, the entry for an accepted name was set to ignore, now showing this information side by side with the current setting of the name as a synonym.

If several entries for an accepted name exist, a list will appear at the left side as shown below where to top entry (0) is the valid entry, while all other entries (> 0) are set to ignore (see below).

Hierarchy

As with the accepted names, ignored data will be listed as shown below in a list where to top entry (0) is the valid entry, while all other entries (> 0) are set to ignore. 

 

 

Jul 19, 2024

Diversity Taxon Names

Geography

Details about the type can be entered in the area “Geography”.

The geographical distribution of the type specimen according to the protologue can be typed in the field Locality of the area Typification. In the area Geography names according to a standard can be entered as a list as shown above. To remove an entry from the list click on the button. To add an entry click on the button. A form will open where you can choose geographical places from the module DiversityGazetteer. To open the link to the module, click on the  button and search for the region as described in the chapter Module relatedentry.

 

The data of the geography are stored in table TaxonGeography.

Apr 9, 2025

Diversity Taxon Names

Resources

Resources related to a taxon can be added in the area “Resources”. Use the (add), (remove) and (save) buttons to handle the resources.

Resources are sorted by their order which can be set in the field shown below. If a resource should not be published, enter any text in the field. The title will be shown e.g. in a chart query in the tooltip of the image.

The data of the resources are stored in table TaxonNameResource.

Mar 20, 2025

Diversity Taxon Names

Import Export

  • Export

    Exporting data to text files

  • Import

    Importing data from text files

Apr 16, 2025

Subsections of Import Export

Diversity Taxon Names

Import

To import taxonomic names you have two options. Either use an import taxonomic names including evaluation of names according to codes like ICBN and automatic splitting of the names or a generic import wizard providing the additional possibilty to import synonyms and hierarchies.

Apr 16, 2025

Subsections of Import

Diversity Taxon Names

Import List

To import taxonomic names, choose Data → Import taxonomic names … from the menu. A window as shown below will open. Choose the encoding of your datasource, that means if your datasource was encoded with ASCII or a unicode format. To ensure a correct import of special signs please provide resp. convert your data in one of the available formats. You must choose a Project, in which your data should be imported. You may choose a Taxon list and a Datasource and if the names should be imported as accepted.

If there are additional columns in the source file (separated by tab) you may add these unsing the Add column button (see below) in the sequence as found in the source file. The additional columns will be included in the analysis of the data as shown below. To remove a column use the button.

To start the analysis of the data, just click on the button to open the source file. If you want to re-analyse a file with new settings, click on the   button. To send a feedback, use the button. If the names should be linked to higher taxa, check the Link taxa to genera if present option. The names can be compared with existing names within the current project or the whole database. If you compare the names with the whole database, you can insert a link for the current project for identical names that are missing in the project.

 

Your names will be listed as shown in the image above. If an error (e.g. special signs converted with the wrong encoding)

 

or a similar name

 

or an identical name

 

is found these will be marked as shown above and the names of your list will not be imported unless you check the according field (second column - Import name). If you changed one of the options, click on the Requery button to see the result.

To start the import, click on the according button Start import.

 

Apr 9, 2025

Diversity Taxon Names

Wizard

Import wizard for tab separated lists

With this import routine, you can import data from text files (as tab-separated lists) into the database. Choose Data → ImportWizard and then the type of data that should be imported, e.g. Import Taxa … from the menu. A window as shown below will open that will lead you through the import of the data. The window is separated in 3 areas. On the left side, you see a list of possible data related import steps according to the type of data you choosed for the import. On the right side you see the list of currently selected import steps. In the middle part the details of the selected import steps are shown.

Choosing the File

As a first step, choose the File from where the data should be imported. The currently supported format is tab-separated text. Then choose the Encoding of the file, e.g. Unicode. The Start line and End line will automatically be set according to your data. You may change these to restrict the data lines that should be imported. The not imported parts in the file are indicated as shown below with a gray background. If the First line contains the column definition this line will not be imported as well. If your data contains e.g. date information where notations differ between countries (e.g. 31.4.2013 - 4.31.2013), choose the Language / Country to ensure a correct interpretation of your data. Finally you can select a prepared Schema (see chapter Schema below) for the import.

 

Choosing the data ranges

In the selection list on the left side of the window (see below) all possible import steps for the data are listed according to the type of data you want to import.

The import of certain tables can be paralleled. To add parallels click on the button (see below). To remove parallels, use the button. Only selected ranges will appear in the list of the steps on the right (see below).

To import informations of logging columns like who created and changed the data, click on button in the header line. This will include a additional substeps for every step containing the logging columns (see below). If you do not import these data, they will be automatically filled by default values like the current time and user.

Attaching data

You can either import your data as new data or Attach them to data in the database. Select the import step Attachment from the list. All tables that are selected and contain columns at which you can attach data are listed (see below). Either choose the first option Import as new data or one of the columns the attachment columns offered like SeriesCode in the table Series in the example below.

If you select a column for attachment, this column will be marked with a blue background (see below and chapter Table data).

 

Merging data

You can either import your data as new data or Merge them with data in the database. Select the import step Merge from the list. For every table you can choose between Insert, Merge, Update and Attach (see below).

The Insert option will import the data from the file independent of existing data in the database.

The Merge option will compare the data from the file with those in the database according to the Key columns (see below). If no matching data are found in the database, the data from the file will be imported, otherwise the data will be updated..

The Update option will compare the data from the file with those in the database according to the Key columns. Only matching data found in the database will be updated.

The Attach option will compare the data from the file with those in the database according to the Key columns. The found data will not be changed, but used as a reference data in depending tables. 

 

Table data

To set the source for the columns in the file, select the step of a table listed underneath the Merge step. All columns available for importing data will be listed in the central part of the window. In the example shown below, the first column is used to attach the new data to data in the database.

A reminder in the header line will show you what actions are still needed to import the data into the table:

  • Please select at least one column   = No column has been selected so far.
  • Please select at least one decisive column   = If data will be imported depends on the content of decisive colums, so at least one must be selected.
  • Please select the position in the file   = The position in the file must be given if the data for a column should be taken from the file.
  • Please select at least one column for comparision   = For all merge types other than insert columns for comparision with data in the database are needed.
  • From file or For all   = For every you have to decide whether the data are taken from the file or a value is entered for all
  • Please select a value from the list   = You have to select a value from the provided list
  • Please enter a value   = You have to enter a value used for all datasets

The handling of the columns in described in the chapter columns.

 

Testing

To test if all requirements for the import are met use the Testing step. You can use a certain line in the file for you test and then click on the Test data in line: button. If there are still unmet requirements, these will be listed in a window as shown below.

If finally all requirements are met, the testing function will try to write the data into the database and display any errors that occurred as shown below. All datasets marked with a red background, produced some error.  

To see the list of all errors, double click in the error list window in the header line (see below).

If finally no errors are left, your data are ready for import. The colors in the table nodes in the tree indicate the handling of the datasets: INSERT, MERGE, UPDATE, No difference. Attach, No data. The colors of the table colums indicate whether a colum is decisive , a key column or an attachment column .  

If you suspect, that the import file contains data allready present in the database, you may test this an extract only the missing lines in a new file. Choose the attachment column (see chapter Attaching data) and click on the button Check for allready present data. The data allready present in the database will be marked red (see below). Click on the button Save missing data a text file to store the data not present in the database in a new file for the import. Please keep in mind, that this comparision will be performed without any transformations of the data, that means the data in the file must match exactly those in the database. 

 

Import

With the last step you can finally start to import the data into the database. If you want to repeat the import with the same settings and data of the same structure, you can save a schema of the current settings (see below).

Schedule for import of tab-separated text files into DiversityTaxonNames
Target within DiversityTaxonNames: TaxonName
Schedule version: 1 Database version: 02.05.14
Lines: 3 - 5 First line contains column definition: ?
Encoding: ANSI Language: US

Tables

TaxonName (TaxonName)
Merge handling: Merge

Column in table ? Key Copy Pre Post File pos. Transformations Value Source Table
NameID 2027929 Interface
TaxonomicRank fam. Interface
GenusOrSupragenericName ? ? 0 File
NomenclaturalCode 3 Interface

TaxonNameProject (TaxonNameProject)
Parent: Merge

Column in table ? Key Copy Pre Post File pos. Transformations Value Source Table
NameID ParentTable
ProjectID ? ? 58 Interface

TaxonAcceptedName_1 (TaxonAcceptedName)
Parent: TaxonNameProject
Merge handling: Insert

Column in table ? Key Copy Pre Post File pos. Transformations Value Source Table
ProjectID ParentTable
NameID ParentTable

 Lines that could not be imported will be marked with a red background while imported lines are marked green (see below).

If you want to save lines that produce errors during the import in a separate file, use the Save failed lines option. The protocol of the import will contain all settings acording to the used schema and an overview containing the number of inserted, updated, unchanged and failed lines (see below).

 

 

Apr 9, 2025

Subsections of Wizard

Diversity Taxon Names

Import Wizard Tutorial

This tutorial demostrates the import of a small file into the database. The example file is included in the software.  At the end of this tutorial you will have imported several datasets and practiced most of the possibilities provided by the import wizard. The import is done in several steps to demonstrate the functionality of the wizard. Please keep in mind, that this tutorial will only work as shown, if the names contained in the file are not already present in the database.

 

 Step1 - Import of the taxa

Choose Data → Import Wizard → import Taxa … from the menu. A window as shown here below will open. Click on the button to open the file ImportTutorial.txt shipped with this application. In addition to the preselected steps, select the step Common names to import the common name contained in the file. In the Merging step leave all tables as Insert (see below). 

In the Taxon step, set the first column NameID to Generate new value. Then select the additional columns as shown below. For the column TaxonomicRank choose For all and select species from the list. For the column NomenclaturalCode choose For all and select Botany (incl. Mycology) from the list. All columns besides NameID, NomenclaturalCode and TaxonomicRank are set on From file and the colums are set as shown in the image below.

The column CombiningAuthors needs a transformation. To add this, click on the button. Enter a translation as shown below where the value NULL is translated to nothing.

Select a translation transformation (click on the button) and press the button to enter a translation (see below).

Press Test the transformation to visualize how the data would be imported (see below).

To allow the import of this table, choose the 2 columns GenusOrSupragenericName and SpeciesEpithet as Decisive columns (see below). 

In the step Common name choose the column CommonName as Decisive column and From file (column 6) for and For all for the other 3 columns as shown in the image below.

In the step Project select For all and the project DiversityWorkbench from the list and select this column as Decisive column. 

In the step Accepted name no further action is needed. 

In the step Testing check if you missed any settings described above. A test should return a result as shown below. 

Finally   Import the taxa. If no errors occur, the import should return a result as shown below. 

 Proceeded with Steps 2 & 3 - Import of the higher taxa

Apr 9, 2025

Subsections of Tutorial

Diversity Taxon Names

Import Wizard Tutorial

Hierarchy

 Step2 - Import of the higher taxa - family

To import the hierarchy, the higher taxa must be imported first. Choose the same file as in the first step for the import. The data for the higher taxa are not unique in the file. Therefore in the Merging step, choose Merge for all tables (see below).

In the Taxon step, set the first column NameID to Generate new value. Then select the column
TaxonomicRank and choose For all and select family from the list. Finally select the column GenusOrSupragenericName, set it as Decisive columns, set it on From file and the column 1 as source (see below).

In the step Project select For all and the project DiversityWorkbench from the list and select this column as Decisive column. 

In the step Accepted name no futher action is needed. 

Finally Import the taxa. If no errors occur, the import should return a result as shown below. Only the green lines are imported. The yellow lines are found identical to the already imported data and are therefore not imported. 

 

 Step3 - Import of the higher taxa - order

Next we Import the order. Follow the steps as described for the family above with the difference that now for TaxonomicRank we select order from the list and choose column 0 as source for the column GenusOrSupragenericName taxa. If no errors occur, the import should return a result as shown below. Only the green lines are imported. The yellow lines are found identical to the already imported data and are therefore not imported (see below). 

 

 

 Proceeded with Step 4 - Import of the hierachycal relation between families and the order

 

 

Apr 9, 2025

Diversity Taxon Names

Import Wizard Tutorial

Species & Family

 Step 4 - Import of the hierachycal relation between species and families

To import the hierarchical relation between the taxa choose Data → Import Wizard → Import Hierarchy … from the menu. For every hierarchical rank, you have to import the relations between the taxa. We start with the relations from the species to the family (the genus as intermediate rank between species and family is omitted in this example).

As described in the previous steps, open the file ImportTutorial.txt shipped with this application. In the Merging step leave the table on Insert (see below).

In the Hierachy step, select the columns  Taxon (Name or ID) and Higher taxon (Name or ID) as Decisive columns (see below).

For the column ProjectID, select For all as shown below and select the project of your choice from the list (e.g. DiversityWorkbench if available).

As the file does not contain the IDs of the name, we let the program determine the ID on basis of the name. To enable the program to detect the ID we need to provide the whole name from the data in the file. We start with the column Taxon (Name or ID). As first step, click on the button to set the source for the genus, the first part of the taxonomic name. A window as shown below will open. Mark the column as shown below an click on the OK button.

Next we need the species epithet as second part of the names. Click on the button to add another column. A window as shown below will open where where the previous selected column for the Genus is marked with 1. We select the column containing the species epithet (see below) and click OK.

Now we need the authors as last part of the names. Again click on the button to add a column and select the source as shown below.

As shown below, enter a space in the Postfix for the first 2 columns.

If combining authors do exist for a name, the authors of the basionym are set in brackets. To ensure the correct build-up of the name, we need to add a transformation. Click on the button to enter the a filter as shown below where an opening bracket ( is inserted in dependence of the content of the column of the combining authors.

To set the column for the filter, click on the button and choose the column containing the combining authors as shown below.

The final Transformation should look like shown below.

After adding the optional opening bracket we add the authors of the basionym. Click on the button and select the column as shown below.

As final step for the authors of the basionym we need the optional closing bracket. Click on the button and select the column as shown above. For the new colum enter another filter transformation as shown below. To set the column for the filter, click on the button as described for the opening bracket.

Finally we need the combining authors, provided they do exist. Click on the button and select the column containing the combining authors. As these are missing for some names we have to add a transformation where the content NULL is translated into nothing. Click on the button to add a transformation and in the window that will open, click on the button to add a  translation (see below).

To add a value that should be translated, click on the button and type NULL into the window as shown below.

The final transformation should look like shown in the image below.

The final build-up for the Taxon should look like in the image below.

Now we enter the higher taxon, in this example the family. Click on the button and choose the column containing the family as shown below.

Now the Hierarchy step is finished and should look like shown below.

In the Testing steps use the test for a check if you missed any settings described above. The result of the test should appear like shown below.

Finally Import the data according to your settings. The result of the import should appear like shown below.

 

 Proceeded with Step 5 - Import of the hierachycal relation between families and the order

 

Apr 9, 2025

Diversity Taxon Names

Import Wizard Tutorial

Family & Order

 Step 5 - Import of the hierachycal relation between families and the order

After the relations between the species and the families are imported we proceed with the hierarchical relation between families and the order. Choose Data → Import Wizard → Import Hierarchy … from the menu. 

As described in the previous steps, open the file ImportTutorial.txt shipped with this application. In the Merging step set the table on Merge (see below).

As described in the previous step, select the project of your choice and set the columns Taxon and Higher Taxon to From file. 

Click on the button to select the source for the family (see below).

… and the orders as shown below.

Additionally you must select these columns as Key columns, used to compare the data from the file with the content in the database (see below).

A final test before importing the data turns positive (see below).

Now we are ready to import the relation into the database. For every family this relation will be imported only once (see below).

As a last step, search for the highest taxon “Russulales” in the hierarchy in the main from and click on the button set hierarchy (see below) .

After the hierarchy for the Russulales is set, all imported name will show the complete hierarchy as shown in the example below.

 

 

 Proceeded with Step 6 - Import of the synonyms

 

Apr 9, 2025

Diversity Taxon Names

Import Wizard Tutorial

Synonyms

 Step 6 - Import of the synonyms

To import the synonyms, choose Data → Import Wizard → import Synonyms … from the menu. A window as shown below will open. 

In the Taxon step choose From file for the Genus and select the colums
Synonym1 as shown below.

To get only the genus from the name in the source, add a transformation for the column. Click on the button and in the window as shown below add a cutting transformation. Enter a space as Splitter. A Test of the transformation should produce the result as shown below.

Next select the SpeciesEpithet and again From file (see below).

Select the same column as for the genus (see below).

… and as for the genus add a cutting transformation with a space as splitter but this time set the Position to 2 (see below).

Choose the columns for the genus and the epithet as Decisive columns (see below). Next we turn to the authors of the synonym. Select the From file for BasionymAuthors …

And choose the SynonymAut1 Column as shown below.

To cut out the basionym authors we add a cut transformation as shown below. Enter ) as splitter.

Next we add a  Replace transformation to get rid of the leeding bracket (see below).

Now we turn to the combining authors …

Again we add a cut transformation with ) as Splitter, but 2 as Position (see below). 

The window now should look like below. 

As a last entry in the taxon step we choose Botany for the Nomenclatural Code (see below).

In the Project step select For all, choose the project where you want to import the data and set this column as Decisive column.

In the Synonymy step select From file for the accepted name. Now we must combine the accepted name from the entries in the file to match the entry in the database.

Select the Genus column for the first part of the accepted name (see below).

Click on the button to add another column and choose the Species column as shown below as source.

For both columns enter a space into the Postfix (see below).

Next we add the authors. For the basionym authors we need to add brackets if combining authors do exist. Select the Author column …  

… and add a filter transformation (see below). Here we choose Import fixed value and enter ( as a value. As condition we choose that the colum of the combining autors should not contain the string NULL. 

To complete this transformation click on the button and select the column containing the combining authors (see below).

To add the basionym authors themselves, click on the  button and choose the corresponding source as shown below.

Next we need the closing bracket for the basionym authors. As before we click on the button and for the new entered columns we add a filter transformation as shown below. Enter ) as fixed value and as before select that the source for the combining authors should be unequal to NULL.

Finally we get the values for the combining authors. Add another column and select the corresponding column in the source (see below).

To remove the NULL value, we add a  translation transformation. As only string that should be translated, we click on the  button and enter NULL (see below).

Now the translation should look like below.

As final action in the Synonym step we choose the column for the Acc.name as Decisive column (see below).

A final Testing will detect any missed settings.

After the final test is passed, we can Import the data as shown below. The schema will automatically be created and is available for subsequent imports. 

Apr 9, 2025

Subsections of Export

Diversity Taxon Names

Export hierarchy and synonymy

To export the taxonomy, including the hierarchy and the synonymy, select the corresponding taxon, choose Data → Export → Export hierarchy and synonymy… from the menu.

To see the whole hierarchy, select the desired node in the hierarchy tree and click on the button besides the hierarchy.

A window as shown below will open

 

The data you in the export will depend upon the taxon you selected in the main form. So if e.g. you want to export the names within a genus, select the genus in the main form.

If you want to include the synonyms, check Restrict to accepted names and Show synonyms and click on the button (see below).

 If you start the export without any schema file, you will get the data strutured as xml (see below).

To format the data, specify the schema file containing your preferred format as shown below. 

You can export the data including all higher taxa (see above) or starting with the taxon for which you selected the export (see below). mao format the data, specify the schema file containing your preferred format as shown below.

To export only the higher taxa, you can restrict the lowest rank to e.g. the genus as shown below.

If you choose the option Summary, the numbers of the differnet hierarchical levels will be listed at the bottom of the report (see image below)

Apr 9, 2025

Diversity Taxon Names

Export List

To export lists, including information about the distribution or the synonymy, choose Data → Export → Export taxon list … from the menu. A window as shown below will open, where you can choose the taxonomic list and the project where the synonomy of the taxa is documented.

 

Choose a Schema file and the options for your export. Than click on the Create the taxon list to start the export. The resulting html file (see below) will be named according to the choosen schema file.

If you miss to choose a schema file, the original XML file will be shown (see below). To convert this into a html file, choose a schema file and click the button.

Apr 9, 2025

Diversity Taxon Names

Fequently Asked Questions

Editing

  • Modules
    • How does DTN interact with other modules in the DWB
      • see chapter Verbindung anderer Module auf DiversityTaxonNames
      • and the video Video starten.
        Aufbau der Workbench, Position der Darstellung im Client, Start mit leeren Listen, Verbinden zu Quelldatenbanken Anzeige von Übersicht im Client, Setzen des Pfads zu DD-Client, Öffnen eines Datensatzes mit DD, Beispiel mit DC, Einschränkung auf Typusbelege, Öffnen eines Datensatzes mit DC
    • How to propagate changes to linked data
      • see chapter Aktualisierung verknüpfter Datensätze
      • and the video Video starten.
        Vorstellung der Beispieldaten in DTN und DC, keine Aktualisierung bei Änderung irrelevanter Inhalte, Aktualisierung bei Änderung relevanter Inhalte, Einbindung von Datenbanken in Aktualisierung, kein Einschluss von Datenbanken die über LinkedServer einschlossen sind, Demonstration der Aktualisierung an 2 Beispielen (Art, Familie)

Export

  • How to export data from a list
    • see chapter Aus Liste
    • and the video Video starten.
      Vorstellung der Exportoptionen. Optionen in der Taxonliste, Auswahl von exportierten Spalten, Anpassung von Spaltenbreite und Höhe, Art der Erzeugung der Exportdatei (neu oder Anhängen), Sortieren der Daten, Exportieren der Daten und Ansicht der Datei.

Maintenance

  • How to clear self referencing synonyms
    • see chapter Bereinigung selbstbezogener Synonyme
    • and the video Video starten.
      Aufbau in Datenbank, Aufruf von Maintenance - Synonyms, 2 Optionen: Ignore und Remove, Ansicht von Datensätzen aus der Liste in der Datenbank, Demonstration - Löschen eines Datensatzes, Demonstration - Ignorieren eines Datensatzes
  • How to update the cache for the synonyms
    • see chapter Aktualisierung des Zwischenspeichers der Synonymie
    • and the video Video starten.
      Ermittlung der Synonymy für einzelne Namen, Funktion für Ermittlung der Synonymy, Cachetabelle mit Inhalt, Button für Aktualisierung eines Namens und Menüpunkt zur Aktualisierung der gesamten Liste

Diversity Taxon Names

General

General aspects of the software

  • Feedback

    Sending feedback for the software

Apr 16, 2025

Subsections of General

Diversity Taxon Names

Feedback

If you have suggestions for improvement, need any changes in the programm or encouter an error you can give a feedback to the administrator. Click on the ALT and PRINT buttons to get a screen shot of your current form. After creating the screen shot choose Help - Feedback from the menu to open the feedback form as shown below.

 

Click on the Insert image button to insert the screen shot and give a comment about your problem. In the field Topic enter the topic of your feedback (will appear in response e-mail). The Priority can either be empty or set to 3 levels:

  • urgent
  • as soon as possible
  • nice to have

If necessary, enter a date in the field ToDo until when you would like to have the task described in you feedback be solved. Then click on the  Send feedback button to send your feedback to the administrator. If you would like to receive a message when the problem you described is solved, please enter you e-mail address in the field below the description.

To inspect your former feedbacks choose Feedback history from the menu. A window will open where you can browse your past feedback together with the state of progress.

Apr 16, 2025

Diversity Taxon Names

Internals

For users that need more detailed information about the software including database design etc.

Jul 19, 2024

Subsections of Internals

Diversity Taxon Names

Database

The database for DiversityTaxonNames is based on Microsoft SQL-Server 2008 or higher. The names of the taxa were separated for practical reasons in several databases, each comprising a certain range of taxa. There is one master version, DiversityTaxonNames, containing the names of all databases and several databases containing the complete datasets including synonymy, hierarchy etc. for the following groups:

Database Taxa Source
DiversityTaxonNames_Fungi higher fungi including lichens LIAS
DiversityTaxonNames_Myxomycetes slime moulds NomenMyx
DiversityTaxonNames_Plants higher plants Species 2000, Tropicos, IPNI, Precis, …
DiversityTaxonNames_Vertebrates vertebrates SAPM, …

To access any database, you must specify the server where the database is located. For the configuration of this connection click on the button or choose Connection, Database… from the menu. If you got a new version of the client you can transfer the settings for the previous version: Choose Connetion → Transfer previous settings from the menu. (see Database access for details)

Organisation of the data

The data are organised in several groups, data connected with the  name , data based on the opinion of an editor within a projects , the source of the data and the lists .

TaxonName, TaxonCommonName, TaxonNameTypification and TaxonGeography  are containing the nomenclatural information. Most items are expected to be undisputed nomenclatural facts. Some data items include editorial opinion (nomenclatural status, but also the accepted spelling which may involve orthographical or grammatical corrections as required by ICBN). However, it is expected that within a project agreement can be achieved on the information contained in TaxonName, i.e. collaborators can “correct” information without consultation.

TaxonNameProject document the projects of the names. The access for the users is determined by the projects.

Editor opinion

The tables TaxonHierarchy, TaxonNameResource, TaxonAcceptedName and TaxonSynonymy - represent a higher level of taxonomic opinion, where different editors and different digitized data sources need to be kept separate. This is achieved by making a “Project” attribute part of the primary key. Editors that wish to collaborate and form agreement may work in a single project, editors that desire to define separate opinions work in separate projects. Furthermore, if the opinion is based on published information, the reference and page number may be recorded (in …RefText, …RefID, …RefDetail). The duality of representing editorial opinion and remaining true to a digitized sources causes some problems. For example, a species accepted in a referenced source may not longer be accepted by the project editors. To avoid a further complication of the model, the “IgnoreButKeepForReference” attribute (default “false”) may be set to “true”, indicating that the statement is true from the perspective of the referenced source, but should be ignored when representing editorial opinion.

  • TaxonHierarchy contains information about the hierarchical position of the taxa. For each project, a name may be referred to a single parent taxon. The attribute “NameParentID” may, however, be Null, in which case “HierarchyPositionIsUncertain” should be true.
  • TaxonNameResource contains links to resources, e.g. images of the taxa.
  • TaxonAcceptedName contains the accepted names (“valid or preferred taxon names”). For each project, a name in “TaxonName” may either be accepted (a corresponding record in “TaxonAcceptedName” exists) or not. Examples for not accepted names are synonyms of accepted names and nomenclaturally rejected names.
  • TaxonSynonymy contains names, which are synonym to other names. Here a single name may be a synonym of multiple accepted names (“pro parte synonym”). The “pro parte” or corresponding sensu information is captured in the “ConceptSuffix” attribute, which is part of the primary key.

External sources

TaxonNameExternalID and TaxonNameExternalDatabase document the sources of the names.

Lists

The tables TaxonNameList… contain informations connected to e.g. checklists. In addition to the restriction to projects the access of users may be restricted to certain lists.

 

Overview of the main tables of the database

 

For details about the tables see Data tables and Enumeration tables.

Apr 9, 2025

Subsections of Database

Diversity TaxonNames

TABLES, VIEWS, FUNCTIONS, PROCEDURES, ROLES

The following objects are not included:

  • Logging tables
  • Enumeration tables
  • System objects
  • Objects marked as obsolete
  • Previous versions of objects

TABLES


Table ProjectUser

User with access to a project

Column Data type Description Nullable Relation
LoginName nvarchar (50) ID of the User as stored in table UserProxy NO -
ProjectID int ID of the project. Foreign key, relates to PK of table ProjectProxy NO Refers to table ProjectProxy
RowGUID uniqueidentifier -Default value: newsequentialid() YES -

Depending on:

  • ProjectProxy

Table ReplicationPublisher

Source providing data for replication

Column Data type Description Nullable Relation
DatabaseName varchar (255) The name of the publishing database NO -
Server varchar (255) The name or address of the server where the publishing database is located NO -
Port smallint The port used by the server YES -
LogCreatedWhen datetime Point in time when this data set was createdDefault value: getdate() YES -
LogCreatedBy nvarchar (50) Name of the creator of this data setDefault value: user_name() YES -
LogUpdatedWhen datetime Point in time when this data set was updated lastDefault value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of the person to update this data set lastDefault value: user_name() YES -

Table SynonymyListCache

Storing results of function SynonymyList

Column Data type Description Nullable Relation
ID int NameID of the selected taxon NO -
ProjectID int ProjectID of the synonymy NO -
NameID int ID of the synonymized name. Refers to the NameID of TaxonName (= foreign key). NO -
DisplayText nvarchar (900) A preformatet textstring for display in a synoymlist YES -
TaxonName nvarchar (500) The name of the taxon including the genus and the species epithet YES -
TaxonomicRank nvarchar (50) Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank) YES -
InfraspecificEpithet nvarchar (200) The epithet of the infraspecific entity YES -
Authors nvarchar (500) The combined authors of this name YES -
SynonymText nvarchar (500) The text string containing the citation of the synonymisation YES -
Prefix nvarchar (5) The prefix as used in synonym lists YES -
Ord int The preferred sequence of the synonyms. The numbers in Ord correspond to the different kinds of the synonyms:
-20 = Accepted name
-10 = Basionym
0 = Homotypic Synonym

0 = Heterotypic Synoyms
x + 1 = Isonym resp. Assigned to like ‘duplicate’, ‘isonym’, ‘orthographic variant’ (will be display after the name it is a variant of)| YES| -| | YearOfPubl| int| The year when the name was published| YES| -| | TaxonNameCache| nvarchar (255)| A full unique version of the name. Generated by the database, not entered by the user (candidate key)| YES| -| | ConceptSuffix| nvarchar (200)| Empty for default and primary concept; else ’s. lat.’, ’s. str.’, ‘sec.’, ‘sensu Muell.’, ’emend.’ , ‘(Auct.)’ etc.| YES| -| | ConceptNotes| nvarchar (500)| Notes on the concept of the name, e.g. incl. forms with black apothecia| YES| -| | BasedOnNameID| int| The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID.| YES| -| | SynType| nvarchar (50)| Type of the synonymization, e.g. ‘heterotypic’, ‘homotypic’| YES| -| | SynNameID| int| The ID of the synonym to which this name has been assigned to. Refers to the NameID of TaxonName (= foreign key).| NO| -| | NameParentID| int| The NameID of the parent within the synonymy| YES| -|


Table TaxonAcceptedName

TaxonAcceptedName contains the accepted names (“valid or preferred taxon names”). For each project, a name in “TaxonName” may either be accepted (a corresponding record in “TaxonAcceptedName” exists) or not. Examples for not accepted names are synonyms of accepted names and nomenclaturally rejected names.

Column Data type Description Nullable Relation
ProjectID int Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module.Default value: 0 NO Refers to table ProjectProxy and table TaxonNameProject
NameID int ID of the accepted name. Refers to the NameID of TaxonName (= foreign key). NO Refers to table TaxonNameProject
IgnoreButKeepForReference tinyint If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead.Default value: 0 NO -
ConceptSuffix nvarchar (200) Empty for default and primary concept; else ’s. lat.’, ’s. str.’, ‘sec.’, ‘sensu Muell.’, ’emend.’ , ‘(Auct.)’ etc.Default value: '’ YES -
ConceptNotes nvarchar (500) Notes on the concept of the name, e.g. incl. forms with black apothecia YES -
RefURI varchar (255) ReferenceURI: Source publication where synonymization is published (not publication of name!) YES -
RefText nvarchar (255) Free text, esp. where a RefURI is missing. Source publication where synonymization is published (not publication of name!) YES -
RefDetail nvarchar (255) Esp. page number on which the synonymization is published YES -
TypistsNotes nvarchar (255) An internal note of the responsible person concerning this synonymization. This information is NOT included in any report. YES -
LogInsertedBy nvarchar (50) Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: user_name() YES -
LogInsertedWhen smalldatetime Date and time when record was first entered (typed or imported) into this system.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: user_name() YES -
LogUpdatedWhen smalldatetime Date and time when record was last updated.Default value: getdate() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() YES -

Depending on:

  • ProjectProxy
  • TaxonNameProject

trgInsTaxonAcceptedName

Setting version of taxon


Table TaxonCommonName

TaxonCommonName contains the common names that are assigned to a scientific name.

Column Data type Description Nullable Relation
NameID int ID taxonomic name. Refers to the column NameID of the table TaxonName (= foreign key). NO Refers to table TaxonName
CommonName nvarchar (220) A common name of the taxonomic name NO -
LanguageCode varchar (2) The 2-letter code of the language of the common name according to ISO NO Refers to table LanguageCode_Enum
CountryCode varchar (2) The 2-letter code of the country where the common name is used according to ISO ISO 3166-1 NO Refers to table CountryCode_Enum
ReferenceTitle nvarchar (220) The title of the reference where the common name was published NO -
ReferenceURI varchar (255) The URI of the reference e.g. as provided by the module DiversityReferences YES -
ReferenceDetails nvarchar (500) Esp. page number on which the common name is published YES -
SubjectContext nvarchar (500) The context in which the common name is used, e.g. pharmacy, food YES -
Transliteration nvarchar (255) Transliteration of the original name YES -
Notes nvarchar (MAX) Notes about the common name YES -
LogInsertedBy nvarchar (50) Who inserted this datasetDefault value: user_name() YES -
LogInsertedWhen smalldatetime The time when this dataset was insertedDefault value: getdate() YES -
LogUpdatedBy nvarchar (50) Who was the last to update this datasetDefault value: user_name() YES -
LogUpdatedWhen smalldatetime The last time when this dataset was updatedDefault value: getdate() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() YES -

Depending on:

  • CountryCode_Enum
  • LanguageCode_Enum
  • TaxonName

trgInsTaxonCommonName

Setting version of taxon


Table TaxonGeography

TaxonGeography is containing the information about the geographic distribution according to the protologue.

Column Data type Description Nullable Relation
NameID int ID of the name. Refers to the NameID of TaxonName (= foreign key). NO Refers to table TaxonName
PlaceURI varchar (255) URI (e.g. LSID) within e.g. the DiversityGazetteer for a place (which may have several names) as found in the protologue NO -
PlaceNameCache nvarchar (100) The name of the place NO -
LogInsertedBy nvarchar (50) Name of user who first entered (typed or imported) the data.Default value: user_name() YES -
LogInsertedWhen smalldatetime Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data.Default value: user_name() YES -
LogUpdatedWhen smalldatetime Date and time when the data were last updated.Default value: getdate() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() YES -

Depending on:

  • TaxonName

trgInsTaxonGeography

Setting version of taxon


Table TaxonHierarchy

TaxonHierarchy contains information about the hierarchical position of the taxa. For each project, a name may be referred to a single parent taxon. The attribute “NameParentID” may, however, be Null, in which case “HierarchyPositionIsUncertain” should be true.

Column Data type Description Nullable Relation
ProjectID int Each project can implement a different taxonomic hierarchy. Refers to the common project definition in the DiversityProjects module.Default value: 0 NO Refers to table ProjectProxy and table TaxonNameProject
NameID int Unique NameID code of the higher taxon. Refers to the NameID code of LichenName (= foreign key). NO Refers to table TaxonNameProject
IgnoreButKeepForReference tinyint If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead.Default value: 0 NO -
NameParentID int Next higher taxon (e.g. the family or subfamily if this taxon is a genus) YES -
HierarchyRefURI varchar (255) Reference URI: Source publication where the hierarchy is published (not publication of name!) as stored e.g. in DiversityReferences YES -
HierarchyRefText nvarchar (255) Free citation, esp. where a HierarchyRefURI is missing. Source publication where the hierarchy is published (not publication of name!) YES -
HierarchyRefDetail nvarchar (255) Esp. page number on which the hierarchy is published YES -
HierarchyPositionIsUncertain bit If the position of this taxon within this taxonomic group is uncertain.Default value: 0 YES -
HierarchyTypistsNotes nvarchar (255) An internal note of the responsible person concerning this hierarchy. This information is NOT included in any report. YES -
HierarchyListCache nvarchar (1000) CALCULATED FIELD: List of higher taxa for faster access: “div.; class; ord.; fam.” YES -
LogInsertedBy nvarchar (50) Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: user_name() YES -
LogInsertedWhen smalldatetime Date and time when record was first entered (typed or imported) into this system.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: user_name() YES -
LogUpdatedWhen smalldatetime Date and time when record was last updated.Default value: getdate() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() YES -

Depending on:

  • ProjectProxy
  • TaxonNameProject

trgInsTaxonHierarchy

Setting version of taxon and HierarchyListCache


Table TaxonName

TaxonName is the nomenclatural information. Most items are expected to be undisputed nomenclatural facts. Some data items include editorial opinion (nomenclatural status, but also the accepted spelling which may involve orthographical or grammatical corrections as required by ICBN). However, it is expected that within a project agreement can be achieved on the information contained in TaxonName, i.e. collaborators can “correct” information without consultation.

Column Data type Description Nullable Relation
NameID int The ID of a name in DiversityTaxonNames_Fungi (primary key) NO -
TaxonNameCache nvarchar (255) A full unique version of the name. Generated by the database, not entered by the user (candidate key) YES -
Version smallint The version of a name record (revision number, internally filled by system)Default value: (1) YES -
BasedOnNameID int The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID. YES Refers to table TaxonName
CreationType nvarchar (50) E.g.: taxon based on new type, combination based on a previously publ. name (‘comb. nov.’), new name (’nom.nov.’) introduced to replace a homonym (may occur for genera!), validation of previously invalidly publ. taxon name (’ex’), or unknown. YES Refers to table TaxonNameCreationType_Enum
TaxonomicRank nvarchar (50) Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank)Default value: N’sp.’ NO Refers to table TaxonNameTaxonomicRank_Enum
GenusOrSupragenericName nvarchar (200) If rank is above species: Name of taxon above species level (currently accepted spelling). Includes infrageneric taxon names, genera, families, etc. NO -
SpeciesGenusNameID int If rank is species or below: NameID of the Genus name. Refers to same table with TaxonomicRank = genus. YES Refers to table TaxonName
InfragenericEpithet nvarchar (200) If rank below genus and above species: Name of infrageneric taxon above species level (currently accepted spelling). Includes subgenus, series, etc. YES -
SpeciesEpithet nvarchar (100) The species name part of the species name, for example ‘alba’ in ‘Abies alba’. YES -
InfraspecificEpithet nvarchar (100) The epithet of the infraspecific entity YES -
BasionymAuthors nvarchar (100) The authors of a newly created name. For all taxonomic ranks, only for ‘comb. nov.’ or ’nom. nov.’: Author(s) of the basionym (will be displayed in ‘()’, do not enter the parentheses), abbreviated according to authors standard YES -
CombiningAuthors nvarchar (255) The names of the combining authors if the name is base on another older name (e.g. combined into a different genus) YES -
PublishingAuthors nvarchar (255) If the authors of the taxon differ from the authors of the publication: the latter (…‘in ’ Publishing authors … ) YES -
SanctioningAuthor nvarchar (100) Sanctioning is a special instrument available for fungi to allow the starting date of taxonomy to be identical with higher plants, but preserve names used by Fries (Fr.) and Person (Pers.) YES -
NonNomenclaturalNameSuffix nvarchar (200) A suffix for concept names not included in any nomenclatural code. If present fields for authors and typification must be empty and NomenclaturalCode set to ’not under code’. YES -
IsRecombination bit True if the name is a recombinationDefault value: (0) NO -
IsHybrid bit If checked (or ‘True’), the new taxon is a hybrid with or without a hybrid epithet.Default value: (0) YES -
HybridNameID1 int If IsHybrid is checked (or ‘True’): Name of hybrid species 1. Refers to NomID code of publ. TaxonomyName (= foreign key). YES Refers to table TaxonName
HybridNameID2 int If IsHybrid is checked (or ‘True’): Name of hybrid species 2. Refers to NomID code of publ. TaxonomyName (= foreign key). YES Refers to table TaxonName
HybridNameID3 int If IsHybrid is checked (or ‘True’): Name of hybrid species 3. Refers to NomID code of publ. TaxonomyName (= foreign key). YES Refers to table TaxonName
HybridNameID4 int If IsHybrid is checked (or ‘True’): Name of hybrid species 4. Refers to NomID code of publ. TaxonomyName (= foreign key). YES Refers to table TaxonName
ReferenceTitle nvarchar (600) The title of the publication where the name was published. Note this is only a cached value where ReferenceURI is present YES -
ReferenceURI varchar (255) URI (e.g. LSID) of Reference, referes to table ReferenceTitle in Database DiversityReferences: Source publication where name is published YES -
Volume nvarchar (20) The volume of the journal YES -
Issue nvarchar (255) The issue of the literature YES -
Pages nvarchar (50) The pages within the literature YES -
DetailLocation nvarchar (200) Additional information like plates etc. YES -
DayOfPubl tinyint The day when the name was published YES -
MonthOfPubl tinyint The month when the name was published YES -
YearOfPubl smallint The year when the name was published YES -
DateOfPublSupplement nvarchar (200) Verbal or additional date information, e.g. ’end of summer 1985’, ‘first quarter’, ‘1888-1892’ YES -
YearOnPubl smallint The year cited on the original paper as year of publication YES -
DateOnPublSupplement nvarchar (200) Verbal or additional date information, e.g. ’end of summer 1985’, ‘first quarter’, ‘1888-1892’ YES -
Protologue nvarchar (MAX) Full text of the protologue. If protologue is provided in Latin and in another language
languages, both only the Latin or several languages may be stored together. YES -
ProtologueURI varchar (255) URI of externally available Protologue information (scanned image, full text from external provider, etc.) YES -
ProtologueResourceURI varchar (255) The ResourceID of an image of the protologue as stored in the module DiversityResources. Primary key of table Resource in the database DiversityResources.(= Foreign key) YES -
NameUsageReferences nvarchar (255) Indexing volumes like Index of Fungi or any Name usage that caused this name to be added to the database
YES -
OriginalOrthography nvarchar (255) The original spelling of the name YES -
NomenclaturalCode nvarchar (50) Code of Nomenclature under which this taxon was created: ‘Bacteriology’, ‘Botany’ (incl. Mycology), ‘Zoology’, ‘Biocode’ (for future use), ‘Non nomenclatural name’. Default value: ‘Botany’ YES Refers to table TaxonNameNomenclaturalCode_Enum
NomenclaturalStatus nvarchar (50) Categories for effective/valid/legitimate… esp. ’nom. illeg.’, ’nom. inval.’, ’nom. nudum’, etc. YES Refers to table TaxonNameNomenclaturalStatus_Enum
NomenclaturalComment nvarchar (MAX) Comments on the nomenclature. e.g. ‘according to ICBN Art. 39.1’ YES -
Typification nvarchar (50) The status of the type specimen(s) as written in the protologue, e.g. holotype YES -
TypificationDetails nvarchar (255) Details concerning the typification as written in the protologue, e.g. if just parts of a specimen were accepted as the type YES -
TypificationReferenceTitle nvarchar (255) The title of the publication where the typification was published. Note this is only a cached value where Typification-LiteratureLink is present YES -
TypificationReferenceURI varchar (255) URI (e.g. LSID) of Reference, refers to e.g DiversityReferences: Source publication where the typification is published YES -
TypificationNotes nvarchar (200) Notes concerning the typification YES -
TypeSubstrate nvarchar (255) The substrate the type was growing on as written in the protologue YES -
TypeLocality nvarchar (255) The locality where the type was found as written in the protologue YES -
TypeSpecimenNotes nvarchar (200) Notes about the type specimen, e.g. the herbarium where a type specimen is located, Collector, collection date/number, etc. YES -
AnamorphTeleomorph nvarchar (255) If the name is related to a anamorph or a teleomorph as written in the protologue YES -
TypistNotes nvarchar (200) Additional notes and problems YES -
RevisionLevel nvarchar (50) The level of the revision of the taxonomic name, e.g. ‘unchecked’, ‘fully checked’ YES Refers to table TaxonNameRevisionLevel_Enum
IgnoreButKeepForReference bit If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead.Default value: (0) YES -
DataWithholdingReason nvarchar (255) If the dataset is withhold, the reason for withholding the data, otherwise null YES -
LogInsertedBy nvarchar (50) Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: user_name() YES -
LogInsertedWhen smalldatetime Date and time when record was first entered (typed or imported) into this system.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: user_name() YES -
LogUpdatedWhen smalldatetime Date and time when record was last updated.Default value: getdate() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() YES -
BasionymAuthorsYear int The year when the name was published by the authors of the Basionym YES -

Depending on:

  • TaxonNameCreationType_Enum
  • TaxonNameNomenclaturalCode_Enum
  • TaxonNameNomenclaturalStatus_Enum
  • TaxonNameRevisionLevel_Enum
  • TaxonNameTaxonomicRank_Enum

trgInsTaxonName

Setting TaxonNameCache


Table TaxonNameExternalDatabase

TaxonNameExternalDatabase document the sources of the names.

Column Data type Description Nullable Relation
ExternalDatabaseID int An ID to identify an external data collection of plant names (primary key, the ID has no meaning outside of the DiversityWorkbench system) NO -
ExternalDatabaseName nvarchar (800) The name of the data collection that has been integrated or can be linked to for further analysis NO -
ExternalDatabaseVersion nvarchar (255) The version of this data collection (either official version number, or dates when the collection was integrated) YES -
Rights nvarchar (500) A description of copyright agreements or permission to use data from the external database YES -
ExternalDatabaseAuthors nvarchar (200) The persons or institutions responsible for the external database YES -
ExternalDatabaseURI nvarchar (300) The URI of the database provider resp. the external database YES -
ExternalDatabaseInstitution nvarchar (300) The institution responsible for the external database YES -
InternalNotes nvarchar (1500) Additional notes concerning this data collection YES -
ExternalAttribute_NameID nvarchar (255) The table and field name in the external data collection to which TaxonNameExternalID refers YES -
PreferredSequence tinyint For selection in e.g. picklists: of several equal names only the name from the source with the lowest preferred sequence will be provided. YES -
Disabled bit If this source should be disabled for selection of names e.g. in picklists YES -
LogCreatedBy nvarchar (50) Name of user who first entered (typed or imported) the data.Default value: user_name() YES -
LogCreatedWhen datetime Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data.Default value: user_name() YES -
LogUpdatedWhen datetime Date and time when the data were last updated.Default value: getdate() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() YES -

Table TaxonNameExternalID

TaxonNameExternalID document the source of a name together with the ID of the source.

Column Data type Description Nullable Relation
NameID int The ID of a name in DiversityTaxonNames (foreign key + part of primary key: the name string associated with NameID may occur in multiple external databases) NO Refers to table TaxonName
ExternalDatabaseID int The ID of an external taxonomic data collection as defined in TaxontNameExternalDatabase (foreign key + part of primary key) NO Refers to table TaxonNameExternalDatabase
ExternalNameURI varchar (255) The URI (e.g. a LSID) of the external name as defined in the external database YES -
LogCreatedBy nvarchar (50) Name of user who first entered (typed or imported) the data.Default value: user_name() YES -
LogCreatedWhen datetime Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data.Default value: user_name() YES -
LogUpdatedWhen datetime Date and time when the data were last updated.Default value: getdate() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() YES -

Depending on:

  • TaxonName
  • TaxonNameExternalDatabase

Table TaxonNameList

The table is containing the names listed in e.g. a checklist corresponding to the project.

Column Data type Description Nullable Relation
NameID int ID of the name. Refers to the NameID of TaxonName (= foreign key). NO Refers to table TaxonName
ProjectID int Each project can may contain one taxon list. Refers to the common project definition in the DiversityProjects module. NO Refers to table TaxonNameListProjectProxy
Notes nvarchar (MAX) An note concerning this entry. YES -
LogInsertedBy nvarchar (50) Name of user who first entered (typed or imported) the data.Default value: user_name() YES -
LogInsertedWhen smalldatetime Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data.Default value: user_name() YES -
LogUpdatedWhen smalldatetime Date and time when the data were last updated.Default value: getdate() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() YES -

Depending on:

  • TaxonName
  • TaxonNameListProjectProxy

Table TaxonNameListAnalysis

Analysis values for list entries in the database, “Red list category: R”, “Time of observation: Sept. - Nov.”

Column Data type Description Nullable Relation
NameID int ID of the name. Refers to the NameID of TaxonName (= foreign key). NO Refers to table TaxonNameList and table TaxonNameListReference
ProjectID int Each project can may contain one taxon list. Refers to the common project definition in the DiversityProjects module. NO Refers to table TaxonNameList and table TaxonNameListReference
TaxonNameListRefID int Unique ID of the reference within the list, refers to table TaxonNameListReference, part of primary keyDefault value: (-1) NO Refers to table TaxonNameListReference
AnalysisID int ID of the analysis (= foreign key) NO Refers to table TaxonNameListAnalysisCategory
AnalysisValue nvarchar (MAX) The result of the analysis YES -
Notes nvarchar (MAX) Notes concerning this analysis YES -
LogInsertedBy nvarchar (50) Name of user who first entered (typed or imported) the data.Default value: user_name() YES -
LogInsertedWhen smalldatetime Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data.Default value: user_name() YES -
LogUpdatedWhen smalldatetime Date and time when the data were last updated.Default value: getdate() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() YES -

Depending on:

  • TaxonNameList
  • TaxonNameListAnalysisCategory
  • TaxonNameListReference

Table TaxonNameListAnalysisCategory

Analysis types used within the database, e.g. “Red list category”, “Frequency”

Column Data type Description Nullable Relation
AnalysisID int ID of the analysis (Primary key) NO -
AnalysisParentID int Analysis ID of the parent analysis if it belongs to a certain type documented in this table YES -
DisplayText nvarchar (50) Name of the analysis as e.g. shown in user interface YES -
Description nvarchar (MAX) Description of the analysis YES -
AnalysisURI varchar (255) URI referring to an external documentation of the analysis YES -
Notes nvarchar (MAX) Notes concerning this analysis YES -
LogCreatedWhen datetime The time when this dataset was createdDefault value: getdate() YES -
LogCreatedBy nvarchar (50) Who created this datasetDefault value: user_name() YES -
LogUpdatedWhen datetime The last time when this dataset was updatedDefault value: getdate() YES -
LogUpdatedBy nvarchar (50) Who was the last to update this datasetDefault value: user_name() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() YES -
ReferenceTitle nvarchar (800) The title of the publication where details about the analysis are published. Note this is only a cached value where ReferenceURI is present YES -
ReferenceURI varchar (400) URI (e.g. LSID) of Reference, referes to table ReferenceTitle in module DiversityReferences: Source publication where details about the analysis are published YES -
DataWithholdingReason nvarchar (255) If the data set is withhold, the reason for withholding the data, otherwise null YES -
SortingID int An ID for sorting the data YES -

Table TaxonNameListAnalysisCategoryValue

Value lists for analysis types with predefined values, e.g. “0, 1, 2, 3, …” for Red list category. Includes description etc. for the values in the list.

Column Data type Description Nullable Relation
AnalysisID int ID of the analysis (Primary key) NO Refers to table TaxonNameListAnalysisCategory
AnalysisValue nvarchar (255) The categorized value of the analysis NO -
Description nvarchar (500) Description of enumerated object, displayed in the user interface YES -
DisplayText nvarchar (50) Short abbreviated description of the object, displayed in the user interface YES -
DisplayOrder smallint The order in which the entries are displayed. The order may be changed at any time, but all values must be unique. YES -
Notes nvarchar (500) Internal development notes about usage, definition, etc. of an enumerated object YES -
LogInsertedBy nvarchar (50) Name of user who first entered (typed or imported) the data.Default value: user_name() YES -
LogInsertedWhen smalldatetime Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data.Default value: user_name() YES -
LogUpdatedWhen smalldatetime Date and time when the data were last updated.Default value: getdate() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() YES -

Depending on:

  • TaxonNameListAnalysisCategory

Table TaxonNameListArea

The area defined for the whole taxon list

Column Data type Description Nullable Relation
ProjectID int Each project can have a different opinion regarding the parameters defined for a list. Refers to the common project definition in the DiversityProjects module. NO Refers to table TaxonNameListProjectProxy
PlaceURI varchar (255) URI or identifier for a place (which may have several names) derived from e.g. TDWG NO -
PlaceNameCache nvarchar (255) The name of the place YES -
Notes nvarchar (MAX) An note concerning this entry. YES -
LogInsertedBy nvarchar (50) Name of user who first entered (typed or imported) the data.Default value: user_name() YES -
LogInsertedWhen smalldatetime Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data.Default value: user_name() YES -
LogUpdatedWhen smalldatetime Date and time when the data were last updated.Default value: getdate() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() YES -

Depending on:

  • TaxonNameListProjectProxy

Table TaxonNameListCollectionSpecimen

The collection specimens on which the taxon list is based

Column Data type Description Nullable Relation
NameID int ID of the name. Refers to the NameID of TaxonName (= foreign key). NO Refers to table TaxonNameList
ProjectID int ProjectID of the taxon list. Foreign key and part of primary key. NO Refers to table TaxonNameList
DisplayText varchar (255) The name of the collection specimen as shown e.g. in a user interface. Part of the primary key NO -
CollectionSpecimenURI varchar (255) URI of the collection specimen. May refer to the module CollectionSpecimen YES -
Role nvarchar (50) The role of the specimen in relation to the taxon list (= foreign key, see table TaxonNameListSpecimenRole_Enum) YES Refers to table TaxonNameListSpecimenRole_Enum
Description nvarchar (MAX) Description of the collection specimen YES -
PlaceURI varchar (255) URI or identifier for a place (which may have several names) derived from e.g. TDWG YES -
PlaceNameCache nvarchar (255) The name of the place YES -
Notes nvarchar (MAX) Notes about the collection specimen YES -
LogInsertedBy nvarchar (50) Name of user who first entered (typed or imported) the data.Default value: user_name() YES -
LogInsertedWhen smalldatetime Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data.Default value: user_name() YES -
LogUpdatedWhen smalldatetime Date and time when the data were last updated.Default value: getdate() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() YES -

Depending on:

  • TaxonNameList
  • TaxonNameListSpecimenRole_Enum

Table TaxonNameListDistribution

The geographical distrbution for the organisms within the taxon list.

Column Data type Description Nullable Relation
NameID int ID of the name. Refers to the NameID of TaxonName (= foreign key). NO Refers to table TaxonNameList and table TaxonNameListReference
ProjectID int Each project can may contain one taxon list. Refers to the common project definition in the DiversityProjects module. NO Refers to table TaxonNameList and table TaxonNameListReference
TaxonNameListRefID int Unique ID of the reference within the list, refers to table TaxonNameListReference, part of primary keyDefault value: (-1) NO Refers to table TaxonNameListReference
PlaceURI varchar (255) URI or identifier for a place (which may have several names) derived from e.g. TDWGDefault value: '’ NO -
PlaceNameCache nvarchar (255) The name of the placeDefault value: '’ NO -
Notes nvarchar (MAX) Notes concerning this analysis YES -
LogInsertedBy nvarchar (50) Name of user who first entered (typed or imported) the data.Default value: user_name() YES -
LogInsertedWhen smalldatetime Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data.Default value: user_name() YES -
LogUpdatedWhen smalldatetime Date and time when the data were last updated.Default value: getdate() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() YES -

Depending on:

  • TaxonNameList
  • TaxonNameListReference

Table TaxonNameListImage

Media, e.g. images of the organisms within the taxon list

Column Data type Description Nullable Relation
NameID int ID of the accepted name. Refers to the NameID of TaxonName (= foreign key). NO Refers to table TaxonNameList
ProjectID int Each project can may contain one taxon list. Refers to the common project definition in the DiversityProjects module. NO Refers to table TaxonNameList
URI varchar (255) The complete URI address of the image. NO -
Description xml (MAX) Description of the image YES -
Notes nvarchar (MAX) Notes concerning this analysis YES -
LogInsertedBy nvarchar (50) Name of user who first entered (typed or imported) the data.Default value: user_name() YES -
LogInsertedWhen smalldatetime Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data.Default value: user_name() YES -
LogUpdatedWhen smalldatetime Date and time when the data were last updated.Default value: getdate() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() YES -

Depending on:

  • TaxonNameList

Table TaxonNameListReference

The reference where the taxon list resp. the name is published

Column Data type Description Nullable Relation
NameID int ID of the name. Refers to the NameID of TaxonName (= foreign key). NO Refers to table TaxonNameList
ProjectID int Each project can may contain one taxon list. Refers to the common project definition in the DiversityProjects module. NO Refers to table TaxonNameList
TaxonNameListRefID int Unique ID of the reference within the list, part of primary key NO -
TaxonNameListRefText nvarchar (800) Free text, esp. where a TaxonNameListRefURI is missing. Source publication where distribution is published (not publication of name!) NO -
TaxonNameListRefURI varchar (255) Reference URI: Source publication where the distribution is published (not publication of name!) as stored e.g. in DiversityReferences YES -
TaxonNameListRefDetail nvarchar (255) Esp. page number on which the distribution is published YES -
ReferenceType nvarchar (50) The type of the reference, e.g. a webpage YES Refers to table TaxonNameListReferenceType_Enum
TaxonUsageContext nvarchar (50) The context of the usage of the taxonomic name within the reference, e.g. ecology YES -
Notes nvarchar (MAX) An note concerning this entry. YES -
LogInsertedBy nvarchar (50) Name of user who first entered (typed or imported) the data.Default value: user_name() YES -
LogInsertedWhen smalldatetime Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data.Default value: user_name() YES -
LogUpdatedWhen smalldatetime Date and time when the data were last updated.Default value: getdate() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() YES -

Depending on:

  • TaxonNameList
  • TaxonNameListReferenceType_Enum

Table TaxonNameListUser

The table is containing the lists accessible for a user.

Column Data type Description Nullable Relation
LoginName nvarchar (50) Login of a user. NO -
ProjectID int Project accessible for a user. Refers to ProjectID in table TaxonNameList (= foreign key). NO Refers to table TaxonNameListProjectProxy

Depending on:

  • TaxonNameListProjectProxy

Table TaxonNameProject

TaxonNameProject documents the projects of the names and provides access to the data.

Column Data type Description Nullable Relation
NameID int The ID of a name in DiversityTaxonNames (foreign key + part of primary key: the name may occur in multiple projects) NO Refers to table TaxonName
ProjectID int ID of the project. Refers to the common project definition in the DiversityProjects module.Default value: 0 NO Refers to table ProjectProxy
LogInsertedWhen datetime The time when this dataset was insertedDefault value: getdate() YES -
LogInsertedBy nvarchar (50) Who inserted this datasetDefault value: user_name() YES -
LogUpdatedWhen datetime The last time when this dataset was updatedDefault value: getdate() YES -
LogUpdatedBy nvarchar (50) Who was the last to update this datasetDefault value: user_name() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() YES -

Depending on:

  • ProjectProxy
  • TaxonName

Table TaxonNameReference

References related to a taxonomic name

Column Data type Description Nullable Relation
NameID int ID of the name. Refers to the NameID of TaxonName (= foreign key). NO Refers to table TaxonName
TaxonNameRefID int Unique ID of the reference, part of primary key NO -
TaxonNameRefText nvarchar (800) The citation text of the reference NO -
TaxonNameRefURI varchar (500) Reference URI: Link to the source where the publication as stored e.g. DiversityReferences YES -
TaxonNameRefDetail nvarchar (255) Esp. page number on which the distribution is published YES -
ReferenceType nvarchar (50) The type of the reference, e.g. a webpage YES Refers to table TaxonNameListReferenceType_Enum
Notes nvarchar (MAX) An note concerning this entry. YES -
LogInsertedBy nvarchar (50) Name of user who first entered (typed or imported) the data.Default value: user_name() YES -
LogInsertedWhen smalldatetime Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data.Default value: user_name() YES -
LogUpdatedWhen smalldatetime Date and time when the data were last updated.Default value: getdate() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() YES -

Depending on:

  • TaxonName
  • TaxonNameListReferenceType_Enum

Table TaxonNameResource

Resouces related to the taxonomic name

Column Data type Description Nullable Relation
NameID int ID of the name. Refers to the NameID of TaxonName (= foreign key). NO Refers to table TaxonNameProject
ProjectID int ID of the project. Refers to the common project definition in the DiversityProjects module. NO Refers to table TaxonNameProject
URI varchar (255) The complete URI address of the resource. NO -
Description xml (MAX) Description of the resource YES -
Notes nvarchar (MAX) A note concerning this entry. YES -
LogInsertedBy nvarchar (50) Name of user who first entered (typed or imported) the data.Default value: user_name() YES -
LogInsertedWhen smalldatetime Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data.Default value: user_name() YES -
LogUpdatedWhen smalldatetime Date and time when the data were last updated.Default value: getdate() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() YES -
Title nvarchar (500) Title of the resource YES -
IPR nvarchar (500) Intellectual Property Rights; the rights given to persons for their intellectual property YES -
Creator nvarchar (500) Person or organization originally creating the resource YES -
CreatorAgentURI varchar (500) Link to the module DiversityAgents YES -
CopyrightStatement nvarchar (500) Notice on rights held in and for the resource YES -
LicenseType nvarchar (500) Type of an official or legal permission to do or own a specified thing, e. g. Creative Common Licenses YES -
LicenseHolder nvarchar (500) The person or institution holding the license YES -
LicenseHolderAgentURI varchar (500) The link to a module containing further information on the person or institution holding the license YES -
LicenseYear nvarchar (50) The year of license declaration YES -
DisplayOrder int The sequence in which the resource should be displayed in a user interfaceDefault value: (1) YES -
DataWithholdingReason nvarchar (255) If the data set is withhold, the reason for withholding the data, otherwise nullDefault value: '’ YES -
ResourceType nvarchar (50) Type of the resource as defined in table TaxonNameResourceType_Enum YES Refers to table TaxonNameResourceType_Enum

Depending on:

  • TaxonNameProject
  • TaxonNameResourceType_Enum

Table TaxonNameTypification

The typification of a taxonomic name, e.g. where the type information of the name was published

Column Data type Description Nullable Relation
NameID int The ID of a name in DiversityTaxonNames_Fungi (primary key) NO Refers to table TaxonName
TypificationReferenceTitle nvarchar (255) The title of the publication where the typification was published. Note this is only a cached value where Typification-LiteratureLink is present NO -
TypificationReferenceURI varchar (255) URI (e.g. LSID) of Reference, refers to e.g DiversityReferences: Source publication where the typification is published YES -
Typification nvarchar (500) The status of the type specimen(s) as written in the protologue, e.g. holotype YES -
TypificationDetails nvarchar (255) Details concerning the typification as written in the protologue, e.g. if just parts of a specimen were accepted as the type YES -
TypificationNotes nvarchar (200) Notes concerning the typification YES -
TypeSubstrate nvarchar (255) The substrate the type was growing on as written in the protologue YES -
TypeLocality nvarchar (255) The locality where the type was found as written in the protologue YES -
TypeSpecimenNotes nvarchar (500) Notes about the type specimen, e.g. the herbarium where a type specimen is located, Collector, collection date/number, etc. YES -
LogInsertedBy nvarchar (50) Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: user_name() YES -
LogInsertedWhen smalldatetime Date and time when record was first entered (typed or imported) into this system.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: user_name() YES -
LogUpdatedWhen smalldatetime Date and time when record was last updated.Default value: getdate() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() YES -

Depending on:

  • TaxonName

Table TaxonSynonymy

TaxonSynonymy contains names, which are synonym to other names. Here a single name may be a synonym of multiple accepted names (“pro parte synonym”). The “pro parte” or corresponding sensu information is captured in the “ConceptSuffix” attribute, which is part of the primary key.

Column Data type Description Nullable Relation
ProjectID int Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module.Default value: (0) NO Refers to table ProjectProxy and table TaxonNameProject
NameID int ID of the synonymized name. Refers to the NameID of TaxonName (= foreign key). NO Refers to table TaxonNameProject
SynNameID int The ID of the synonym to which this name has been assigned to. Refers to the NameID of TaxonName (= foreign key). NO Refers to table TaxonNameProject
IgnoreButKeepForReference tinyint If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead.Default value: (0) NO -
ConceptSuffix nvarchar (200) Empty for default and primary concept; else ’s. lat.’, ’s. str.’, ‘sec.’, ‘sensu Muell.’, ’emend.’ , ‘(Auct.)’ etc.Default value: '’ YES -
ConceptNotes nvarchar (500) Notes on the concept of the name, e.g. incl. forms with black apothecia YES -
SynRefURI varchar (255) Reference URI: Source publication where synonymization is published (not publication of name!) as stored e.g. in DiversityReferences YES -
SynRefText nvarchar (255) Free text, esp. where a SynRefURI is missing. Source publication where synonymization is published (not publication of name!) YES -
SynRefDetail nvarchar (255) Esp. page number on which the synonymization is published YES -
SynTypistsNotes nvarchar (255) An internal note of the responsible person concerning this synonymization. This information is NOT included in any report. YES -
SynType nvarchar (50) Type of the synonymization, e.g. ‘heterotypic’, ‘homotypic’Default value: ‘unknown’ NO Refers to table TaxonNameSynonymisationType_Enum
SynIsUncertain bit If the synoymization is uncertain. Corresponding to =? for heterotypic synonyms and ? if the type of the synonymisation is unknown. Homotypic synonyms can not be uncertain.Default value: (0) YES -
LogInsertedBy nvarchar (50) Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: user_name() YES -
LogInsertedWhen smalldatetime Date and time when record was first entered (typed or imported) into this system.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: user_name() YES -
LogUpdatedWhen smalldatetime Date and time when record was last updated.Default value: getdate() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() YES -

Depending on:

  • ProjectProxy
  • TaxonNameProject
  • TaxonNameSynonymisationType_Enum

trgInsTaxonSynonymy

Setting version of taxon


VIEWS


View AcceptedNameChanges

Listing NameID of previous accepted names and the NameID of the current accepted name

Column Data type Description Nullable
ProjectID int Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module. YES
NameID int ID of the accepted name. Refers to the NameID of TaxonName (= foreign key). YES
IgnoreButKeepForReference tinyint If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead. YES
LogDate datetime Date of the changes according to the log table NO
LogID int ID of the changes in the log table NO
CurrentAcceptedNameID int NameID of the accepted name YES

Depending on:

  • TaxonAcceptedName
  • TaxonAcceptedName_log
  • TaxonSynonymy

View GenusList

All Taxa with rank genus

Column Data type Description Nullable
NameID int The ID of a name in DiversityTaxonNames_Fungi (primary key) NO
TaxonNameCache nvarchar (200) A full unique version of the name. Generated by the database, not entered by the user (candidate key) YES

Depending on:

  • TaxonName

View NameID_UserAvailable

List of NameIDs accessible for the current user

Column Data type Description Nullable
NameID int The ID of a name in DiversityTaxonNames (foreign key + part of primary key: the name may occur in multiple projects) NO

Depending on:

  • ProjectUser
  • TaxonNameProject

View ProjectList

List of projects accessible for the current user

Column Data type Description Nullable
Project nvarchar (50) The name of the project NO
ProjectID int ID of the project NO
ProjectURI varchar (255) The URI of the project, e.g. as provided by the module DiversityProjects. YES

Depending on:

  • ProjectProxy
  • ProjectUser

View TaxonAcceptedName_Core

Content of TaxonAcceptedName restricted to datasets accessible for a user

Column Data type Description Nullable
ProjectID int Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module. NO
NameID int ID of the accepted name. Refers to the NameID of TaxonName (= foreign key). NO
IgnoreButKeepForReference tinyint If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead. NO
ConceptSuffix nvarchar (200) Empty for default and primary concept; else ’s. lat.’, ’s. str.’, ‘sec.’, ‘sensu Muell.’, ’emend.’ , ‘(Auct.)’ etc. YES
ConceptNotes nvarchar (500) Notes on the concept of the name, e.g. incl. forms with black apothecia YES
RefURI varchar (255) ReferenceURI: Source publication where synonymization is published (not publication of name!) YES
RefText nvarchar (255) Free text, esp. where a RefURI is missing. Source publication where synonymization is published (not publication of name!) YES
RefDetail nvarchar (255) Esp. page number on which the synonymization is published YES
TypistsNotes nvarchar (255) An internal note of the responsible person concerning this synonymization. This information is NOT included in any report. YES

Depending on:

  • NameID_UserAvailable
  • TaxonAcceptedName

View TaxonAcceptedName_Indicated

List of IDs of accepted names

Column Data type Description Nullable
ProjectID int Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module. NO
NameID int ID of the accepted name. Refers to the NameID of TaxonName (= foreign key). NO
IgnoreButKeepForReference tinyint If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead. NO
ConceptSuffix nvarchar (200) Empty for default and primary concept; else ’s. lat.’, ’s. str.’, ‘sec.’, ‘sensu Muell.’, ’emend.’ , ‘(Auct.)’ etc. YES
ConceptNotes nvarchar (500) Notes on the concept of the name, e.g. incl. forms with black apothecia YES
RefURI varchar (255) ReferenceURI: Source publication where synonymization is published (not publication of name!) YES
RefText nvarchar (255) Free text, esp. where a RefURI is missing. Source publication where synonymization is published (not publication of name!) YES
RefDetail nvarchar (255) Esp. page number on which the synonymization is published YES
TypistsNotes nvarchar (255) An internal note of the responsible person concerning this synonymization. This information is NOT included in any report. YES

Depending on:

  • TaxonAcceptedName

View TaxonAcceptedNameList

List of accepted names excluding ignored names

Column Data type Description Nullable
NameID int ID of the accepted name. Refers to the NameID of TaxonName (= foreign key). NO
DisplayText nvarchar (4000) Combining taxon, publication and nomenclatural information YES
TaxonName nvarchar (301) Combining taxon information excluding authors YES
TaxonomicRank nvarchar (52) Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank) NO
InfraspecificEpithet nvarchar (101) The epithet of the infraspecific entity YES
Authors nvarchar (719) Combining all author information of the taxon YES
SynonymText nvarchar (1683) Combining publication and nomenclatural information YES
YearOfPubl smallint The year when the name was published YES
TaxonNameCache nvarchar (255) A full unique version of the name. Generated by the database, not entered by the user (candidate key) YES
ConceptSuffix nvarchar (200) Empty for default and primary concept; else ’s. lat.’, ’s. str.’, ‘sec.’, ‘sensu Muell.’, ’emend.’ , ‘(Auct.)’ etc. YES
ConceptNotes nvarchar (500) Notes on the concept of the name, e.g. incl. forms with black apothecia YES
BasedOnNameID int The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID. YES
ProjectID int Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module. NO
NomenclaturalStatus nvarchar (50) Categories for effective/valid/legitimate… esp. ’nom. illeg.’, ’nom. inval.’, ’nom. nudum’, etc. YES

Depending on:

  • TaxonAcceptedName
  • TaxonName

View TaxonAcceptedNameListIncludeIgnored

List of accepted names including ignored names

Column Data type Description Nullable
NameID int ID of the accepted name. Refers to the NameID of TaxonName (= foreign key). NO
DisplayText nvarchar (2609) Combining taxon, publication and nomenclatural information YES
TaxonName nvarchar (301) Combining taxon information excluding authors YES
TaxonomicRank nvarchar (52) Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank) NO
InfraspecificEpithet nvarchar (101) The epithet of the infraspecific entity YES
Authors nvarchar (719) Combining all author information of the taxon YES
SynonymText nvarchar (1338) Combining publication and nomenclatural information YES
YearOfPubl smallint The year when the name was published YES
TaxonNameCache nvarchar (255) A full unique version of the name. Generated by the database, not entered by the user (candidate key) YES
ConceptSuffix nvarchar (200) Empty for default and primary concept; else ’s. lat.’, ’s. str.’, ‘sec.’, ‘sensu Muell.’, ’emend.’ , ‘(Auct.)’ etc. YES
ConceptNotes nvarchar (500) Notes on the concept of the name, e.g. incl. forms with black apothecia YES
BasedOnNameID int The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID. YES
ProjectID int Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module. NO
NomenclaturalStatus nvarchar (50) Categories for effective/valid/legitimate… esp. ’nom. illeg.’, ’nom. inval.’, ’nom. nudum’, etc. YES
IgnoreButKeepForReference bit If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead. YES

Depending on:

  • TaxonAcceptedName
  • TaxonName

View TaxonFamily

Family information for taxa

Column Data type Description Nullable
NameID int Unique NameID code of the higher taxon. Refers to the NameID code of LichenName (= foreign key). NO
TaxonNameCache nvarchar (255) A full unique version of the name. Generated by the database, not entered by the user (candidate key) YES
FamilyNameID int NameID for the family YES
Family nvarchar (200) The name of the family YES
IgnoreButKeepForReference int If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead. NO

Depending on:

  • TaxonHierarchy
  • TaxonName
  • TaxonNameTaxonomicRank_Enum

View TaxonGeography_Core

User available information of the geography

Column Data type Description Nullable
NameID int ID of the name. Refers to the NameID of TaxonName (= foreign key). NO
PlaceURI varchar (255) URI (e.g. LSID) within e.g. the DiversityGazetteer for a place (which may have several names) as found in the protologue NO
PlaceNameCache nvarchar (100) The name of the place YES

Depending on:

  • NameID_UserAvailable
  • TaxonGeography

View TaxonHierarchy_Core

User available information of the hierarchy

Column Data type Description Nullable
ProjectID int Each project can implement a different taxonomic hierarchy. Refers to the common project definition in the DiversityProjects module. NO
NameID int Unique NameID code of the higher taxon. Refers to the NameID code of LichenName (= foreign key). NO
IgnoreButKeepForReference tinyint If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead. NO
NameParentID int Next higher taxon (e.g. the family or subfamily if this taxon is a genus) YES
HierarchyRefURI varchar (255) Reference URI: Source publication where the hierarchy is published (not publication of name!) as stored e.g. in DiversityReferences YES
HierarchyRefText nvarchar (255) Free citation, esp. where a HierarchyRefURI is missing. Source publication where the hierarchy is published (not publication of name!) YES
HierarchyRefDetail nvarchar (255) Esp. page number on which the hierarchy is published YES
HierarchyPositionIsUncertain bit If the position of this taxon within this taxonomic group is uncertain. YES
HierarchyTypistsNotes nvarchar (255) An internal note of the responsible person concerning this hierarchy. This information is NOT included in any report. YES
HierarchyListCache nvarchar (1000) CALCULATED FIELD: List of higher taxa for faster access: “div.; class; ord.; fam.” YES

Depending on:

  • NameID_UserAvailable
  • TaxonHierarchy

View TaxonListSynType

Public available information for taxa including synonymy

Column Data type Description Nullable
NameID int ID of the accepted name. Refers to the NameID of TaxonName (= foreign key). NO
TaxonNameCache nvarchar (255) A full unique version of the name. Generated by the database, not entered by the user (candidate key) YES
BasedOnNameID int The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID. YES
CreationType nvarchar (50) E.g.: taxon based on new type, combination based on a previously publ. name (‘comb. nov.’), new name (’nom.nov.’) introduced to replace a homonym (may occur for genera!), validation of previously invalidly publ. taxon name (’ex’), or unknown. YES
TaxonomicRank nvarchar (50) Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank) NO
GenusOrSupragenericName nvarchar (200) If rank is above species: Name of taxon above species level (currently accepted spelling). Includes infrageneric taxon names, genera, families, etc. NO
SpeciesGenusNameID int If rank is species or below: NameID of the Genus name. Refers to same table with TaxonomicRank = genus. YES
InfragenericEpithet nvarchar (200) If rank below genus and above species: Name of infrageneric taxon above species level (currently accepted spelling). Includes subgenus, series, etc. YES
SpeciesEpithet nvarchar (100) The species name part of the species name, for example ‘alba’ in ‘Abies alba’. YES
InfraspecificEpithet nvarchar (100) The epithet of the infraspecific entity YES
BasionymAuthors nvarchar (100) The authors of a newly created name. For all taxonomic ranks, only for ‘comb. nov.’ or ’nom. nov.’: Author(s) of the basionym (will be displayed in ‘()’, do not enter the parentheses), abbreviated according to authors standard YES
CombiningAuthors nvarchar (255) The names of the combining authors if the name is base on another older name (e.g. combined into a different genus) YES
PublishingAuthors nvarchar (255) If the authors of the taxon differ from the authors of the publication: the latter (…‘in ’ Publishing authors … ) YES
SanctioningAuthor nvarchar (100) Sanctioning is a special instrument available for fungi to allow the starting date of taxonomy to be identical with higher plants, but preserve names used by Fries (Fr.) and Person (Pers.) YES
NonNomenclaturalNameSuffix nvarchar (200) A suffix for concept names not included in any nomenclatural code. If present fields for authors and typification must be empty and NomenclaturalCode set to ’not under code’. YES
IsHybrid bit If checked (or ‘True’), the new taxon is a hybrid with or without a hybrid epithet. YES
HybridNameID1 int If IsHybrid is checked (or ‘True’): Name of hybrid species 1. Refers to NomID code of publ. TaxonomyName (= foreign key). YES
HybridNameID2 int If IsHybrid is checked (or ‘True’): Name of hybrid species 2. Refers to NomID code of publ. TaxonomyName (= foreign key). YES
HybridNameID3 int If IsHybrid is checked (or ‘True’): Name of hybrid species 3. Refers to NomID code of publ. TaxonomyName (= foreign key). YES
HybridNameID4 int If IsHybrid is checked (or ‘True’): Name of hybrid species 4. Refers to NomID code of publ. TaxonomyName (= foreign key). YES
ReferenceTitle nvarchar (600) The title of the publication where the name was published. Note this is only a cached value where ReferenceURI is present YES
ReferenceURI varchar (255) URI (e.g. LSID) of Reference, referes to table ReferenceTitle in Database DiversityReferences: Source publication where name is published YES
Volume nvarchar (20) The volume of the journal YES
Issue nvarchar (255) The issue of the literature YES
Pages nvarchar (50) The pages within the literature YES
YearOfPubl smallint The year when the name was published YES
YearOnPubl smallint The year cited on the original paper as year of publication YES
NameUsageReferences nvarchar (255) Indexing volumes like Index of Fungi or any Name usage that caused this name to be added to the database
YES
OriginalOrthography nvarchar (255) The original spelling of the name YES
NomenclaturalCode nvarchar (50) Code of Nomenclature under which this taxon was created: ‘Bacteriology’, ‘Botany’ (incl. Mycology), ‘Zoology’, ‘Biocode’ (for future use), ‘Non nomenclatural name’. Default value: ‘Botany’ YES
NomenclaturalStatus nvarchar (50) Categories for effective/valid/legitimate… esp. ’nom. illeg.’, ’nom. inval.’, ’nom. nudum’, etc. YES
NomenclaturalComment nvarchar (MAX) Comments on the nomenclature. e.g. ‘according to ICBN Art. 39.1’ YES
Typification nvarchar (50) The status of the type specimen(s) as written in the protologue, e.g. holotype YES
TypificationDetails nvarchar (255) Details concerning the typification as written in the protologue, e.g. if just parts of a specimen were accepted as the type YES
TypeSubstrate nvarchar (255) The substrate the type was growing on as written in the protologue YES
TypeLocality nvarchar (255) The locality where the type was found as written in the protologue YES
TypificationReferenceTitle nvarchar (255) The title of the publication where the typification was published. Note this is only a cached value where Typification-LiteratureLink is present YES
TypificationReferenceURI varchar (255) URI (e.g. LSID) of Reference, refers to e.g DiversityReferences: Source publication where the typification is published YES
TypificationNotes nvarchar (200) Notes concerning the typification YES
AnamorphTeleomorph nvarchar (255) If the name is related to a anamorph or a teleomorph as written in the protologue YES
TypistNotes nvarchar (200) Additional notes and problems YES
SynType nvarchar (50) Type of the synonymization, e.g. ‘heterotypic’, ‘homotypic’ YES
ValidSynType nvarchar (50) “accepted name” or type of the synonymy YES
IgnoreAcceptedName int If accepted name is ignored (1 = ignored, 0 = not ignored) NO
IgnoreSynonymy int If synonymy is ignored (1 = ignored, 0 = not ignored) NO

Depending on:

  • TaxonAcceptedName
  • TaxonName
  • TaxonSynonymy

View TaxonName_Core

User available taxa

Column Data type Description Nullable
NameID int The ID of a name in DiversityTaxonNames_Fungi (primary key) NO
Display nvarchar (255) Corresponds to TaxonNameCache YES
DisplayEpithet nvarchar (358) SpeciesEpithet including information for whole taxon for query YES
TaxonNameCache nvarchar (255) A full unique version of the name. Generated by the database, not entered by the user (candidate key) YES
Version smallint The version of a name record (revision number, internally filled by system) YES
BasedOnNameID int The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID. YES
CreationType nvarchar (50) E.g.: taxon based on new type, combination based on a previously publ. name (‘comb. nov.’), new name (’nom.nov.’) introduced to replace a homonym (may occur for genera!), validation of previously invalidly publ. taxon name (’ex’), or unknown. YES
TaxonomicRank nvarchar (50) Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank) NO
GenusOrSupragenericName nvarchar (200) If rank is above species: Name of taxon above species level (currently accepted spelling). Includes infrageneric taxon names, genera, families, etc. NO
SpeciesGenusNameID int If rank is species or below: NameID of the Genus name. Refers to same table with TaxonomicRank = genus. YES
InfragenericEpithet nvarchar (200) If rank below genus and above species: Name of infrageneric taxon above species level (currently accepted spelling). Includes subgenus, series, etc. YES
SpeciesEpithet nvarchar (100) The species name part of the species name, for example ‘alba’ in ‘Abies alba’. YES
InfraspecificEpithet nvarchar (100) The epithet of the infraspecific entity YES
BasionymAuthors nvarchar (100) The authors of a newly created name. For all taxonomic ranks, only for ‘comb. nov.’ or ’nom. nov.’: Author(s) of the basionym (will be displayed in ‘()’, do not enter the parentheses), abbreviated according to authors standard YES
CombiningAuthors nvarchar (255) The names of the combining authors if the name is base on another older name (e.g. combined into a different genus) YES
PublishingAuthors nvarchar (255) If the authors of the taxon differ from the authors of the publication: the latter (…‘in ’ Publishing authors … ) YES
SanctioningAuthor nvarchar (100) Sanctioning is a special instrument available for fungi to allow the starting date of taxonomy to be identical with higher plants, but preserve names used by Fries (Fr.) and Person (Pers.) YES
NonNomenclaturalNameSuffix nvarchar (200) A suffix for concept names not included in any nomenclatural code. If present fields for authors and typification must be empty and NomenclaturalCode set to ’not under code’. YES
IsHybrid bit If checked (or ‘True’), the new taxon is a hybrid with or without a hybrid epithet. YES
HybridNameID1 int If IsHybrid is checked (or ‘True’): Name of hybrid species 1. Refers to NomID code of publ. TaxonomyName (= foreign key). YES
HybridNameID2 int If IsHybrid is checked (or ‘True’): Name of hybrid species 2. Refers to NomID code of publ. TaxonomyName (= foreign key). YES
HybridNameID3 int If IsHybrid is checked (or ‘True’): Name of hybrid species 3. Refers to NomID code of publ. TaxonomyName (= foreign key). YES
HybridNameID4 int If IsHybrid is checked (or ‘True’): Name of hybrid species 4. Refers to NomID code of publ. TaxonomyName (= foreign key). YES
ReferenceTitle nvarchar (600) The title of the publication where the name was published. Note this is only a cached value where ReferenceURI is present YES
ReferenceURI varchar (255) URI (e.g. LSID) of Reference, referes to table ReferenceTitle in Database DiversityReferences: Source publication where name is published YES
Volume nvarchar (20) The volume of the journal YES
Issue nvarchar (255) The issue of the literature YES
Pages nvarchar (50) The pages within the literature YES
DetailLocation nvarchar (200) Additional information like plates etc. YES
DayOfPubl tinyint The day when the name was published YES
MonthOfPubl tinyint The month when the name was published YES
YearOfPubl smallint The year when the name was published YES
DateOfPublSupplement nvarchar (200) Verbal or additional date information, e.g. ’end of summer 1985’, ‘first quarter’, ‘1888-1892’ YES
YearOnPubl smallint The year cited on the original paper as year of publication YES
DateOnPublSupplement nvarchar (200) Verbal or additional date information, e.g. ’end of summer 1985’, ‘first quarter’, ‘1888-1892’ YES
Protologue nvarchar (MAX) Full text of the protologue. If protologue is provided in Latin and in another language
languages, both only the Latin or several languages may be stored together. YES
ProtologueURI varchar (255) URI of externally available Protologue information (scanned image, full text from external provider, etc.) YES
ProtologueResourceURI varchar (255) The ResourceID of an image of the protologue as stored in the module DiversityResources. Primary key of table Resource in the database DiversityResources.(= Foreign key) YES
NameUsageReferences nvarchar (255) Indexing volumes like Index of Fungi or any Name usage that caused this name to be added to the database
YES
OriginalOrthography nvarchar (255) The original spelling of the name YES
NomenclaturalCode nvarchar (50) Code of Nomenclature under which this taxon was created: ‘Bacteriology’, ‘Botany’ (incl. Mycology), ‘Zoology’, ‘Biocode’ (for future use), ‘Non nomenclatural name’. Default value: ‘Botany’ YES
NomenclaturalStatus nvarchar (50) Categories for effective/valid/legitimate… esp. ’nom. illeg.’, ’nom. inval.’, ’nom. nudum’, etc. YES
NomenclaturalComment nvarchar (MAX) Comments on the nomenclature. e.g. ‘according to ICBN Art. 39.1’ YES
Typification nvarchar (50) The status of the type specimen(s) as written in the protologue, e.g. holotype YES
TypificationDetails nvarchar (255) Details concerning the typification as written in the protologue, e.g. if just parts of a specimen were accepted as the type YES
TypificationReferenceTitle nvarchar (255) The title of the publication where the typification was published. Note this is only a cached value where Typification-LiteratureLink is present YES
TypificationReferenceURI varchar (255) URI (e.g. LSID) of Reference, refers to e.g DiversityReferences: Source publication where the typification is published YES
TypificationNotes nvarchar (200) Notes concerning the typification YES
TypeSubstrate nvarchar (255) The substrate the type was growing on as written in the protologue YES
TypeLocality nvarchar (255) The locality where the type was found as written in the protologue YES
TypeSpecimenNotes nvarchar (200) Notes about the type specimen, e.g. the herbarium where a type specimen is located, Collector, collection date/number, etc. YES
AnamorphTeleomorph nvarchar (255) If the name is related to a anamorph or a teleomorph as written in the protologue YES
TypistNotes nvarchar (200) Additional notes and problems YES
RevisionLevel nvarchar (50) The level of the revision of the taxonomic name, e.g. ‘unchecked’, ‘fully checked’ YES
IgnoreButKeepForReference bit If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead. YES

Depending on:

  • NameID_UserAvailable
  • TaxonName

View TaxonName_Indicated

Content of table TaxonName including synonymy information

Column Data type Description Nullable
ProjectID int ID of the project. Refers to the common project definition in the DiversityProjects module. NO
Display nvarchar (263) Content of column TaxonNameCache with synonymy prefix YES
DisplayEpithet nvarchar (366) Content of column SpeciesEpithet with synonymy prefix and trailed by TaxonNameCache YES
NameID int The ID of a name in DiversityTaxonNames_Fungi (primary key) NO
TaxonNameCache nvarchar (255) A full unique version of the name. Generated by the database, not entered by the user (candidate key) YES
Version smallint The version of a name record (revision number, internally filled by system) YES
BasedOnNameID int The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID. YES
CreationType nvarchar (50) E.g.: taxon based on new type, combination based on a previously publ. name (‘comb. nov.’), new name (’nom.nov.’) introduced to replace a homonym (may occur for genera!), validation of previously invalidly publ. taxon name (’ex’), or unknown. YES
TaxonomicRank nvarchar (50) Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank) NO
GenusOrSupragenericName nvarchar (200) If rank is above species: Name of taxon above species level (currently accepted spelling). Includes infrageneric taxon names, genera, families, etc. NO
SpeciesGenusNameID int If rank is species or below: NameID of the Genus name. Refers to same table with TaxonomicRank = genus. YES
InfragenericEpithet nvarchar (200) If rank below genus and above species: Name of infrageneric taxon above species level (currently accepted spelling). Includes subgenus, series, etc. YES
SpeciesEpithet nvarchar (100) The species name part of the species name, for example ‘alba’ in ‘Abies alba’. YES
InfraspecificEpithet nvarchar (100) The epithet of the infraspecific entity YES
BasionymAuthors nvarchar (100) The authors of a newly created name. For all taxonomic ranks, only for ‘comb. nov.’ or ’nom. nov.’: Author(s) of the basionym (will be displayed in ‘()’, do not enter the parentheses), abbreviated according to authors standard YES
CombiningAuthors nvarchar (255) The names of the combining authors if the name is base on another older name (e.g. combined into a different genus) YES
PublishingAuthors nvarchar (255) If the authors of the taxon differ from the authors of the publication: the latter (…‘in ’ Publishing authors … ) YES
SanctioningAuthor nvarchar (100) Sanctioning is a special instrument available for fungi to allow the starting date of taxonomy to be identical with higher plants, but preserve names used by Fries (Fr.) and Person (Pers.) YES
NonNomenclaturalNameSuffix nvarchar (200) A suffix for concept names not included in any nomenclatural code. If present fields for authors and typification must be empty and NomenclaturalCode set to ’not under code’. YES
IsHybrid bit If checked (or ‘True’), the new taxon is a hybrid with or without a hybrid epithet. YES
HybridNameID1 int If IsHybrid is checked (or ‘True’): Name of hybrid species 1. Refers to NomID code of publ. TaxonomyName (= foreign key). YES
HybridNameID2 int If IsHybrid is checked (or ‘True’): Name of hybrid species 2. Refers to NomID code of publ. TaxonomyName (= foreign key). YES
HybridNameID3 int If IsHybrid is checked (or ‘True’): Name of hybrid species 3. Refers to NomID code of publ. TaxonomyName (= foreign key). YES
HybridNameID4 int If IsHybrid is checked (or ‘True’): Name of hybrid species 4. Refers to NomID code of publ. TaxonomyName (= foreign key). YES
ReferenceTitle nvarchar (600) The title of the publication where the name was published. Note this is only a cached value where ReferenceURI is present YES
ReferenceURI varchar (255) URI (e.g. LSID) of Reference, referes to table ReferenceTitle in Database DiversityReferences: Source publication where name is published YES
Volume nvarchar (20) The volume of the journal YES
Issue nvarchar (255) The issue of the literature YES
Pages nvarchar (50) The pages within the literature YES
DetailLocation nvarchar (200) Additional information like plates etc. YES
DayOfPubl tinyint The day when the name was published YES
MonthOfPubl tinyint The month when the name was published YES
YearOfPubl smallint The year when the name was published YES
DateOfPublSupplement nvarchar (200) Verbal or additional date information, e.g. ’end of summer 1985’, ‘first quarter’, ‘1888-1892’ YES
YearOnPubl smallint The year cited on the original paper as year of publication YES
DateOnPublSupplement nvarchar (200) Verbal or additional date information, e.g. ’end of summer 1985’, ‘first quarter’, ‘1888-1892’ YES
Protologue nvarchar (MAX) Full text of the protologue. If protologue is provided in Latin and in another language
languages, both only the Latin or several languages may be stored together. YES
ProtologueURI varchar (255) URI of externally available Protologue information (scanned image, full text from external provider, etc.) YES
ProtologueResourceURI varchar (255) The ResourceID of an image of the protologue as stored in the module DiversityResources. Primary key of table Resource in the database DiversityResources.(= Foreign key) YES
NameUsageReferences nvarchar (255) Indexing volumes like Index of Fungi or any Name usage that caused this name to be added to the database
YES
OriginalOrthography nvarchar (255) The original spelling of the name YES
NomenclaturalCode nvarchar (50) Code of Nomenclature under which this taxon was created: ‘Bacteriology’, ‘Botany’ (incl. Mycology), ‘Zoology’, ‘Biocode’ (for future use), ‘Non nomenclatural name’. Default value: ‘Botany’ YES
NomenclaturalStatus nvarchar (50) Categories for effective/valid/legitimate… esp. ’nom. illeg.’, ’nom. inval.’, ’nom. nudum’, etc. YES
NomenclaturalComment nvarchar (MAX) Comments on the nomenclature. e.g. ‘according to ICBN Art. 39.1’ YES
Typification nvarchar (50) The status of the type specimen(s) as written in the protologue, e.g. holotype YES
TypificationDetails nvarchar (255) Details concerning the typification as written in the protologue, e.g. if just parts of a specimen were accepted as the type YES
TypificationReferenceTitle nvarchar (255) The title of the publication where the typification was published. Note this is only a cached value where Typification-LiteratureLink is present YES
TypificationReferenceURI varchar (255) URI (e.g. LSID) of Reference, refers to e.g DiversityReferences: Source publication where the typification is published YES
TypificationNotes nvarchar (200) Notes concerning the typification YES
TypeSubstrate nvarchar (255) The substrate the type was growing on as written in the protologue YES
TypeLocality nvarchar (255) The locality where the type was found as written in the protologue YES
TypeSpecimenNotes nvarchar (200) Notes about the type specimen, e.g. the herbarium where a type specimen is located, Collector, collection date/number, etc. YES
AnamorphTeleomorph nvarchar (255) If the name is related to a anamorph or a teleomorph as written in the protologue YES
TypistNotes nvarchar (200) Additional notes and problems YES
RevisionLevel nvarchar (50) The level of the revision of the taxonomic name, e.g. ‘unchecked’, ‘fully checked’ YES
IgnoreButKeepForReference bit If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead. YES

Depending on:

  • ProjectList
  • TaxonAcceptedName_Indicated
  • TaxonName
  • TaxonNameProject
  • TaxonSynonymy_Indicated

View TaxonNameExternalID_Core

User available content of table TaxonNameExternalID

Column Data type Description Nullable
NameID int The ID of a name in DiversityTaxonNames (foreign key + part of primary key: the name string associated with NameID may occur in multiple external databases) NO
ExternalDatabaseID int The ID of an external taxonomic data collection as defined in TaxontNameExternalDatabase (foreign key + part of primary key) NO
ExternalNameURI varchar (255) The URI (e.g. a LSID) of the external name as defined in the external database YES

Depending on:

  • NameID_UserAvailable
  • TaxonNameExternalID

View TaxonOrder

Not ignored Order for taxa

Column Data type Description Nullable
NameID int Unique NameID code of the higher taxon. Refers to the NameID code of LichenName (= foreign key). NO
TaxonNameCache nvarchar (255) A full unique version of the name. Generated by the database, not entered by the user (candidate key) YES
OrderNameID int The NameID of the Order YES
Order nvarchar (200) The Name of the Order YES
IgnoreButKeepForReference int If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead. NO

Depending on:

  • TaxonHierarchy
  • TaxonName

View TaxonSynonymy_Core

User available content of table TaxonSynonymy

Column Data type Description Nullable
ProjectID int Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module. NO
NameID int ID of the synonymized name. Refers to the NameID of TaxonName (= foreign key). NO
SynNameID int The ID of the synonym to which this name has been assigned to. Refers to the NameID of TaxonName (= foreign key). NO
IgnoreButKeepForReference tinyint If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead. NO
ConceptSuffix nvarchar (200) Empty for default and primary concept; else ’s. lat.’, ’s. str.’, ‘sec.’, ‘sensu Muell.’, ’emend.’ , ‘(Auct.)’ etc. NO
ConceptNotes nvarchar (500) Notes on the concept of the name, e.g. incl. forms with black apothecia YES
SynRefURI varchar (255) Reference URI: Source publication where synonymization is published (not publication of name!) as stored e.g. in DiversityReferences YES
SynRefText nvarchar (255) Free text, esp. where a SynRefURI is missing. Source publication where synonymization is published (not publication of name!) YES
SynRefDetail nvarchar (255) Esp. page number on which the synonymization is published YES
SynTypistsNotes nvarchar (255) An internal note of the responsible person concerning this synonymization. This information is NOT included in any report. YES
SynType nvarchar (50) Type of the synonymization, e.g. ‘heterotypic’, ‘homotypic’ YES
SynIsUncertain bit If the synoymization is uncertain. Corresponding to =? for heterotypic synonyms and ? if the type of the synonymisation is unknown. Homotypic synonyms can not be uncertain. YES

Depending on:

  • NameID_UserAvailable
  • TaxonSynonymy

View TaxonSynonymy_Indicated

Prefix information for Synonyms

Column Data type Description Nullable
ProjectID int Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module. NO
NameID int ID of the synonymized name. Refers to the NameID of TaxonName (= foreign key). NO
SynType nvarchar (50) Type of the synonymization, e.g. ‘heterotypic’, ‘homotypic’ YES
Prefix nvarchar (4) Prefix for Synonyms as displayed in query YES
Indent varchar (4) Indent for Synonyms as displayed in query YES

Depending on:

  • TaxonSynonymy

View TaxonSynonymyAcceptedNameID

Accepted names for synonyms

Column Data type Description Nullable
ProjectID int Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module. NO
NameID int ID of the accepted name. Refers to the NameID of TaxonName (= foreign key). NO
AcceptedNameID int ID of the accepted name YES

Depending on:

  • TaxonAcceptedName
  • TaxonSynonymy

View TaxonSynonymyList

Taxon information including synonymy for not ignored data

Column Data type Description Nullable
NameID int The ID of a name in DiversityTaxonNames_Fungi (primary key) NO
DisplayText nvarchar (4000) Taxon name including publication and nomenclatural information YES
TaxonName nvarchar (301) Taxonomic name excluding authors YES
TaxonomicRank nvarchar (52) Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank) NO
InfraspecificEpithet nvarchar (101) The epithet of the infraspecific entity YES
Authors nvarchar (922) Combining all author information of the taxon YES
SynonymText nvarchar (1683) Combining publication and nomenclatural information YES
TaxonNameCache nvarchar (255) A full unique version of the name. Generated by the database, not entered by the user (candidate key) YES
YearOfPubl smallint The year when the name was published YES
SynIsUncertain bit If the synoymization is uncertain. Corresponding to =? for heterotypic synonyms and ? if the type of the synonymisation is unknown. Homotypic synonyms can not be uncertain. YES
BasedOnNameID int The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID. YES
ConceptSuffix nvarchar (200) Empty for default and primary concept; else ’s. lat.’, ’s. str.’, ‘sec.’, ‘sensu Muell.’, ’emend.’ , ‘(Auct.)’ etc. YES
ConceptNotes nvarchar (500) Notes on the concept of the name, e.g. incl. forms with black apothecia YES
SynType nvarchar (50) Type of the synonymization, e.g. ‘heterotypic’, ‘homotypic’ NO
SynNameID int The ID of the synonym to which this name has been assigned to. Refers to the NameID of TaxonName (= foreign key). NO
ProjectID int Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module. NO
NomenclaturalStatus nvarchar (50) Categories for effective/valid/legitimate… esp. ’nom. illeg.’, ’nom. inval.’, ’nom. nudum’, etc. YES

Depending on:

  • TaxonName
  • TaxonSynonymy

View TaxonSynonymyListIncludeIgnored

Taxon information including synonymy and including ignored data

Column Data type Description Nullable
NameID int The ID of a name in DiversityTaxonNames_Fungi (primary key) NO
DisplayText nvarchar (2613) Taxon name including publication and nomenclatural information YES
TaxonName nvarchar (301) Taxonomic name excluding authors YES
TaxonomicRank nvarchar (52) Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank) NO
InfraspecificEpithet nvarchar (101) The epithet of the infraspecific entity YES
Authors nvarchar (922) Combining all author information of the taxon YES
SynonymText nvarchar (1338) Combining publication and nomenclatural information YES
TaxonNameCache nvarchar (255) A full unique version of the name. Generated by the database, not entered by the user (candidate key) YES
YearOfPubl smallint The year when the name was published YES
SynIsUncertain bit If the synoymization is uncertain. Corresponding to =? for heterotypic synonyms and ? if the type of the synonymisation is unknown. Homotypic synonyms can not be uncertain. YES
BasedOnNameID int The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID. YES
ConceptSuffix nvarchar (200) Empty for default and primary concept; else ’s. lat.’, ’s. str.’, ‘sec.’, ‘sensu Muell.’, ’emend.’ , ‘(Auct.)’ etc. YES
ConceptNotes nvarchar (500) Notes on the concept of the name, e.g. incl. forms with black apothecia YES
SynType nvarchar (50) Type of the synonymization, e.g. ‘heterotypic’, ‘homotypic’ NO
SynNameID int The ID of the synonym to which this name has been assigned to. Refers to the NameID of TaxonName (= foreign key). NO
ProjectID int Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module. NO
NomenclaturalStatus nvarchar (50) Categories for effective/valid/legitimate… esp. ’nom. illeg.’, ’nom. inval.’, ’nom. nudum’, etc. YES
IgnoreButKeepForReference bit If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead. YES

Depending on:

  • TaxonName
  • TaxonSynonymy

View ViewBaseURL

Result of function dbo.BaseURL() for linked servers

Column Data type Description Nullable
BaseURL varchar (255) The BaseURL of the database YES

Depending on:

  • BaseURL

View ViewDefaultProjectID

Result of function dbo.DefaultProjectID() for linked servers

Column Data type Description Nullable
ProjectID int ID of the project. Foreign key, relates to PK of table ProjectProxy YES

Depending on:

  • DefaultProjectID

View ViewDiversityWorkbenchModule

Result of function dbo.DiversityWorkbenchModule() for linked servers

Column Data type Description Nullable
DiversityWorkbenchModule nvarchar (50) The DiversityWorkbenchModule of the database = DiversityTaxonNames YES

Depending on:

  • DiversityWorkbenchModule

View ViewTaxonNameResource

A View for TaxonNameResource excluding XML columns

Column Data type Description Nullable
NameID int ID of the name. Refers to the NameID of TaxonName (= foreign key). NO
ProjectID int ID of the project. Refers to the common project definition in the DiversityProjects module. NO
URI varchar (255) The complete URI address of the resource. NO
Notes nvarchar (MAX) A note concerning this entry. YES
Title nvarchar (500) Title of the resource YES
IPR nvarchar (500) Intellectual Property Rights; the rights given to persons for their intellectual property YES
Creator nvarchar (500) Person or organization originally creating the resource YES
CreatorAgentURI varchar (500) Link to the module DiversityAgents YES
CopyrightStatement nvarchar (500) Notice on rights held in and for the resource YES
LicenseType nvarchar (500) Type of an official or legal permission to do or own a specified thing, e. g. Creative Common Licenses YES
LicenseHolder nvarchar (500) The person or institution holding the license YES
LicenseHolderAgentURI varchar (500) The link to a module containing further information on the person or institution holding the license YES
LicenseYear nvarchar (50) The year of license declaration YES
DisplayOrder int The sequence in which the resource should be displayed in a user interface YES
DataWithholdingReason nvarchar (255) If the data set is withhold, the reason for withholding the data, otherwise null YES
ResourceType nvarchar (50) Type of the resource as defined in table TaxonNameResourceType_Enum YES

Depending on:

  • TaxonNameResource

FUNCTIONS


Function AcceptedNameID

Returns ID of accepted name if any is found, otherwise NULL

DataType: int

Parameter DataType Description
@NameID int ID of the accepted name. Refers to the NameID of TaxonName (= foreign key).
@ProjectID int Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module.

Depending on:

  • DefaultProjectID
  • TaxonAcceptedName
  • TaxonName
  • TaxonSynonymy

Function AnalysisCategoryHierarchyAll

Returns a table that lists all the analysis categorys.

Column DataType Description
AnalysisID int ID of the analysis (Primary key)
AnalysisParentID int Analysis ID of the parent analysis if it belongs to a certain type documented in this table
DisplayText nvarchar (50) Name of the analysis as e.g. shown in user interface
Description nvarchar (MAX) Description of the analysis
Notes nvarchar (MAX) Notes concerning this analysis
AnalysisURI varchar (255) URI referring to an external documentation of the analysis
OnlyHierarchy bit Reserved for future application
DataWithholdingReason nvarchar (255) If the data set is withhold, the reason for withholding the data, otherwise null
SortingID int An ID for sorting the data
HierarchyDisplayText varchar (900) DisplayTexts of the hierarchy separated by "

Depending on:

  • TaxonNameListAnalysisCategory

Function BaseURL

Returns BaseURL for the database

DataType: varchar (255)


Function DefaultProjectID

ID of the current project selected by the user

DataType: int

Depending on:

  • ProjectUser
  • UserProxy

Function DiversityMobile_TaxonList

Returns a result set that lists all taxa in a given project resp. list

Parameter DataType Description
@ProjectID int Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module.
@ListID int The ID of the List corresponding to column ProjectID in table TaxonNameList
Column DataType Description
NameURI varchar (255) Combines content of dbo.BaseURL() and NameID of the taxon
TaxonNameCache nvarchar (255) A full unique version of the name. Generated by the database, not entered by the user (candidate key)
TaxonNameSinAuthors nvarchar (255) Taxonomic name excluding authors
GenusOrSupragenericName nvarchar (255) If rank is above species: Name of taxon above species level (currently accepted spelling). Includes infrageneric taxon names, genera, families, etc.
SpeciesEpithet nvarchar (255) The species name part of the species name, for example ‘alba’ in ‘Abies alba’.
InfraspecificEpithet nvarchar (255) The epithet of the infraspecific entity
Synonymy varchar (50) Simple synonymy information for the taxon as either “Accepted” or “Synonym”
Family nvarchar (255) Family of the taxon
Order nvarchar (255) Order of the taxon

Depending on:

  • BaseURL
  • TaxonAcceptedName
  • TaxonHierarchy
  • TaxonName
  • TaxonNameList
  • TaxonNameProject
  • TaxonSynonymy

Function DiversityWorkbenchModule

Returns the DiversityWorkbenchModule = “DiversityTaxonNames”

DataType: nvarchar (50)


Function HierarchyCache

Returns a string of all the taxa superior to a given taxon separated with the value of parameter @Separator

DataType: nvarchar (-1)

Parameter DataType Description
@NameID int Unique NameID code of the higher taxon. Refers to the NameID code of LichenName (= foreign key).
@DiversityProjectID int ID of the project
@Separator char (1) Separator for the hierarchy levels

Depending on:

  • ProjectList
  • TaxonHierarchy
  • TaxonHierarchy_Core
  • TaxonName
  • TaxonNameProject

Function HierarchyFamilyList

Returns a result set that lists all families of the taxa in a given project

Parameter DataType Description
@ProjectID int Each project can implement a different taxonomic hierarchy. Refers to the common project definition in the DiversityProjects module.
Column DataType Description
NameID int Unique NameID code of the higher taxon. Refers to the NameID code of LichenName (= foreign key).
TaxonNameCache nvarchar (500) A full unique version of the name. Generated by the database, not entered by the user (candidate key)
FamilyNameID int NameID of the family
Family nvarchar (500) The name of the family

Depending on:

  • TaxonHierarchy
  • TaxonName

Function HierarchyList

Returns a result set that lists hierarchy of the taxa in a given project

Parameter DataType Description
@ProjectID int Each project can implement a different taxonomic hierarchy. Refers to the common project definition in the DiversityProjects module.
Column DataType Description
NameID int Unique NameID code of the higher taxon. Refers to the NameID code of LichenName (= foreign key).
TaxonNameCache nvarchar (500) A full unique version of the name. Generated by the database, not entered by the user (candidate key)
Hierarchy nvarchar (2000) Hierarchy above the taxon separated by "

Depending on:

  • TaxonHierarchy
  • TaxonName
  • TaxonNameTaxonomicRank_Enum

Function HierarchyOrderList

Returns a result set that lists all orders of the taxa in a given project.

Parameter DataType Description
@ProjectID int Each project can implement a different taxonomic hierarchy. Refers to the common project definition in the DiversityProjects module.
Column DataType Description
NameID int Unique NameID code of the higher taxon. Refers to the NameID code of LichenName (= foreign key).
TaxonNameCache nvarchar (500) A full unique version of the name. Generated by the database, not entered by the user (candidate key)
OrderNameID int NameID of the order
Order nvarchar (500) Name of the order

Depending on:

  • TaxonHierarchy
  • TaxonName

Function HierarchySuperiorList

Returns a result set that lists all the taxa superior to a given taxon

Parameter DataType Description
@NameID int Unique NameID code of the higher taxon. Refers to the NameID code of LichenName (= foreign key).
@ProjectID int Each project can implement a different taxonomic hierarchy. Refers to the common project definition in the DiversityProjects module.
Column DataType Description
NameID int Unique NameID code of the higher taxon. Refers to the NameID code of LichenName (= foreign key).
NameParentID int Next higher taxon (e.g. the family or subfamily if this taxon is a genus)
Seq int The sequence for the hierarchy starting with 1 for the Taxon corresponding to the given NameID
TaxonNameCache nchar (500) A full unique version of the name. Generated by the database, not entered by the user (candidate key)
Taxon nvarchar (500) Taxon excluding authors
TaxonomicRank nvarchar (50) Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank)
TaxonomicRankDisplayText nvarchar (50) The taxonomic rank in the case of a infraspecific taxon

Depending on:

  • TaxonHierarchy
  • TaxonHierarchy_Core
  • TaxonName
  • TaxonNameTaxonomicRank_Enum

Function NameList

Returns a result set that lists all the taxa starting with a string corresponding to @NameStart and including the taxon corresponding to @NameID

Parameter DataType Description
@NameID int The ID of a name in DiversityTaxonNames_Fungi (primary key)
@NameStart nvarchar (255) Initial string of the taxon (TaxonNameCache)
Column DataType Description
NameID int The ID of a name in DiversityTaxonNames_Fungi (primary key)
TaxonName nvarchar (200) Content of column TaxonNameCache

Depending on:

  • TaxonName

Function NextNameID

Returns the next free NameID in the table TaxonName for the taxonomic group

DataType: int

Parameter DataType Description
@InitialNameID int ID of the name where the query should start
@TaxonomicGroup nvarchar (50) TaxonomicGroup of the name. Ranges for the groups:
Biota: 0
Myxomycetes: 1 - 99 999
Plants: 100 000 - 999 999
Lichens: 1 000 000 - 1 999 999
Fungi: 2 000 000 - 2 999 999
Vertebrata: 3 000 000 - 3 999 999

Depending on:

  • TaxonName

Function PrivacyConsentInfo

Website with information about the privacy consent. Default = http://diversityworkbench.net/Portal/Default_Agreement_on_Processing_of_Personal_Data_in_DWB_Software

DataType: varchar (900)


Function SynonymyList

Returns a result set that lists all the Synonyms for a given name

Parameter DataType Description
@NameID int ID of the synonymized name. Refers to the NameID of TaxonName (= foreign key).
@ProjectID int ProjectID of the synonymy
@Level int the depth of the synonymy that should be requested. 0 = only linked via the basionym. Default = 3
Column DataType Description
NameID int ID of the synonymized name. Refers to the NameID of TaxonName (= foreign key).
DisplayText nvarchar (900) A preformatet textstring for display in a synoymlist
TaxonName nvarchar (500) The name of the taxon including the genus and the species epithet
TaxonomicRank nvarchar (50) Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank)
InfraspecificEpithet nvarchar (200) The epithet of the infraspecific entity
Authors nvarchar (500) The combined authors of this name
SynonymText nvarchar (500) The text string containing the citation of the synonymisation
Prefix nvarchar (5) The prefix as used in synonym lists
Ord int The preferred sequence of the synonyms. The numbers in Ord correspond to the different kinds of the synonyms:
-20 = Accepted name
-10 = Basionym
0 = Homotypic Synonym

0 = Heterotypic Synoyms
x + 1 = Isonym resp. Assigned to like ‘duplicate’, ‘isonym’, ‘orthographic variant’ (will be display after the name it is a variant of) | | YearOfPubl | int | The year when the name was published | | TaxonNameCache | nvarchar (255) | A full unique version of the name. Generated by the database, not entered by the user (candidate key) | | ConceptSuffix | nvarchar (200) | Empty for default and primary concept; else ’s. lat.’, ’s. str.’, ‘sec.’, ‘sensu Muell.’, ’emend.’ , ‘(Auct.)’ etc. | | ConceptNotes | nvarchar (500) | Notes on the concept of the name, e.g. incl. forms with black apothecia | | BasedOnNameID | int | The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID. | | SynType | nvarchar (50) | Type of the synonymization, e.g. ‘heterotypic’, ‘homotypic’ | | SynNameID | int | The ID of the synonym to which this name has been assigned to. Refers to the NameID of TaxonName (= foreign key). | | NameParentID | int | The NameID of the parent within the synonymy |

Depending on:

  • DefaultProjectID
  • SynonymyListCache
  • TaxonAcceptedName
  • TaxonAcceptedNameList
  • TaxonName
  • TaxonSynonymy
  • TaxonSynonymyList

Function SynonymyListIncludeIgnored

Returns a result set that lists all the Synonyms for a given name

Parameter DataType Description
@NameID int ID of the accepted name. Refers to the NameID of TaxonName (= foreign key).
@ProjectID int Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module.
@Level int the depth of the synonymy that should be requested. 0 = only linked via the basionym. Default = 3
Column DataType Description
NameID int ID of the accepted name. Refers to the NameID of TaxonName (= foreign key).
DisplayText nvarchar (900) A preformatet textstring for display in a synoymlist
TaxonName nvarchar (500) The name of the taxon including the genus and the species epithet
TaxonomicRank nvarchar (50) Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank)
InfraspecificEpithet nvarchar (200) The epithet of the infraspecific entity
Authors nvarchar (500) The combined authors of this name
SynonymText nvarchar (500) The text string containing the citation of the synonymisation
Prefix nvarchar (5) The prefix as used in synonym lists
Ord int The preferred sequence of the synonyms. The numbers in Ord correspond to the different kinds of the synonyms:
-20 = Accepted name
-10 = Basionym
0 = Homotypic Synonym

0 = Heterotypic Synoyms
x + 1 = Isonym resp. Assigned to like ‘duplicate’, ‘isonym’, ‘orthographic variant’ (will be display after the name it is a variant of) | | YearOfPubl | int | The year when the name was published | | TaxonNameCache | nvarchar (255) | A full unique version of the name. Generated by the database, not entered by the user (candidate key) | | ConceptSuffix | nvarchar (200) | Empty for default and primary concept; else ’s. lat.’, ’s. str.’, ‘sec.’, ‘sensu Muell.’, ’emend.’ , ‘(Auct.)’ etc. | | ConceptNotes | nvarchar (500) | Notes on the concept of the name, e.g. incl. forms with black apothecia | | BasedOnNameID | int | The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID. | | SynType | nvarchar (50) | Type of the synonymization, e.g. ‘heterotypic’, ‘homotypic’ | | SynNameID | int | The ID of the synonym to which this name has been assigned to. Refers to the NameID of TaxonName (= foreign key). | | NameParentID | int | - | | IgnoreButKeepForReference | bit | If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead. |

Depending on:

  • DefaultProjectID
  • TaxonAcceptedName
  • TaxonAcceptedNameListIncludeIgnored
  • TaxonName
  • TaxonSynonymy
  • TaxonSynonymyListIncludeIgnored

Function TaxonChildNodes

Returns the list of taxa within the hierarchy underneath the taxon with the given NameID

Parameter DataType Description
@NameID int The NameID of the taxon for which the hierarchy should be retrieved
@ProjectID int The ProjectID of the taxon for which the hierarchy should be retrieved
Column DataType Description
NameID int Unique NameID code of the higher taxon. Refers to the NameID code of LichenName (= foreign key).
TaxonNameCache nvarchar (255) A full unique version of the name. Generated by the database, not entered by the user (candidate key)
Version smallint The version of a name record (revision number, internally filled by system)
BasedOnNameID int The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID.
CreationType nvarchar (50) E.g.: taxon based on new type, combination based on a previously publ. name (‘comb. nov.’), new name (’nom.nov.’) introduced to replace a homonym (may occur for genera!), validation of previously invalidly publ. taxon name (’ex’), or unknown.
TaxonomicRank nvarchar (50) Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank)
GenusOrSupragenericName nvarchar (200) If rank is above species: Name of taxon above species level (currently accepted spelling). Includes infrageneric taxon names, genera, families, etc.
SpeciesGenusNameID int If rank is species or below: NameID of the Genus name. Refers to same table with TaxonomicRank = genus.
InfragenericEpithet nvarchar (200) If rank below genus and above species: Name of infrageneric taxon above species level (currently accepted spelling). Includes subgenus, series, etc.
SpeciesEpithet nvarchar (100) The species name part of the species name, for example ‘alba’ in ‘Abies alba’.
InfraspecificEpithet nvarchar (100) The epithet of the infraspecific entity
BasionymAuthors nvarchar (100) The authors of a newly created name. For all taxonomic ranks, only for ‘comb. nov.’ or ’nom. nov.’: Author(s) of the basionym (will be displayed in ‘()’, do not enter the parentheses), abbreviated according to authors standard
CombiningAuthors nvarchar (255) The names of the combining authors if the name is base on another older name (e.g. combined into a different genus)
PublishingAuthors nvarchar (255) If the authors of the taxon differ from the authors of the publication: the latter (…‘in ’ Publishing authors … )
SanctioningAuthor nvarchar (100) Sanctioning is a special instrument available for fungi to allow the starting date of taxonomy to be identical with higher plants, but preserve names used by Fries (Fr.) and Person (Pers.)
NonNomenclaturalNameSuffix nvarchar (200) A suffix for concept names not included in any nomenclatural code. If present fields for authors and typification must be empty and NomenclaturalCode set to ’not under code’.
IsRecombination bit True if the name is a recombination
IsHybrid bit If checked (or ‘True’), the new taxon is a hybrid with or without a hybrid epithet.
HybridNameID1 int If IsHybrid is checked (or ‘True’): Name of hybrid species 1. Refers to NomID code of publ. TaxonomyName (= foreign key).
HybridNameID2 int If IsHybrid is checked (or ‘True’): Name of hybrid species 2. Refers to NomID code of publ. TaxonomyName (= foreign key).
HybridNameID3 int If IsHybrid is checked (or ‘True’): Name of hybrid species 3. Refers to NomID code of publ. TaxonomyName (= foreign key).
HybridNameID4 int If IsHybrid is checked (or ‘True’): Name of hybrid species 4. Refers to NomID code of publ. TaxonomyName (= foreign key).
ReferenceTitle nvarchar (600) The title of the publication where the name was published. Note this is only a cached value where ReferenceURI is present
ReferenceURI varchar (255) URI (e.g. LSID) of Reference, referes to table ReferenceTitle in Database DiversityReferences: Source publication where name is published
Volume nvarchar (20) The volume of the journal
Issue nvarchar (255) The issue of the literature
Pages nvarchar (50) The pages within the literature
DetailLocation nvarchar (200) Additional information like plates etc.
DayOfPubl tinyint The day when the name was published
MonthOfPubl tinyint The month when the name was published
YearOfPubl smallint The year when the name was published
DateOfPublSupplement nvarchar (200) Verbal or additional date information, e.g. ’end of summer 1985’, ‘first quarter’, ‘1888-1892’
YearOnPubl smallint The year cited on the original paper as year of publication
DateOnPublSupplement nvarchar (200) Verbal or additional date information, e.g. ’end of summer 1985’, ‘first quarter’, ‘1888-1892’
Protologue nvarchar (MAX) Full text of the protologue. If protologue is provided in Latin and in another language
languages, both only the Latin or several languages may be stored together.
ProtologueURI varchar (255) URI of externally available Protologue information (scanned image, full text from external provider, etc.)
ProtologueResourceURI varchar (255) The ResourceID of an image of the protologue as stored in the module DiversityResources. Primary key of table Resource in the database DiversityResources.(= Foreign key)
NameUsageReferences nvarchar (255) Indexing volumes like Index of Fungi or any Name usage that caused this name to be added to the database
OriginalOrthography nvarchar (255) The original spelling of the name
NomenclaturalCode nvarchar (50) Code of Nomenclature under which this taxon was created: ‘Bacteriology’, ‘Botany’ (incl. Mycology), ‘Zoology’, ‘Biocode’ (for future use), ‘Non nomenclatural name’. Default value: ‘Botany’
NomenclaturalStatus nvarchar (50) Categories for effective/valid/legitimate… esp. ’nom. illeg.’, ’nom. inval.’, ’nom. nudum’, etc.
NomenclaturalComment nvarchar (MAX) Comments on the nomenclature. e.g. ‘according to ICBN Art. 39.1’
Typification nvarchar (50) The status of the type specimen(s) as written in the protologue, e.g. holotype
TypificationDetails nvarchar (255) Details concerning the typification as written in the protologue, e.g. if just parts of a specimen were accepted as the type
TypificationReferenceTitle nvarchar (255) The title of the publication where the typification was published. Note this is only a cached value where Typification-LiteratureLink is present
TypificationReferenceURI varchar (255) URI (e.g. LSID) of Reference, refers to e.g DiversityReferences: Source publication where the typification is published
TypificationNotes nvarchar (200) Notes concerning the typification
TypeSubstrate nvarchar (255) The substrate the type was growing on as written in the protologue
TypeLocality nvarchar (255) The locality where the type was found as written in the protologue
TypeSpecimenNotes nvarchar (200) Notes about the type specimen, e.g. the herbarium where a type specimen is located, Collector, collection date/number, etc.
AnamorphTeleomorph nvarchar (255) If the name is related to a anamorph or a teleomorph as written in the protologue
TypistNotes nvarchar (200) Additional notes and problems
RevisionLevel nvarchar (50) The level of the revision of the taxonomic name, e.g. ‘unchecked’, ‘fully checked’
IgnoreButKeepForReference bit If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead.
DataWithholdingReason nvarchar (255) If the dataset is withhold, the reason for withholding the data, otherwise null
BasionymAuthorsYear int The year when the name was published by the authors of the Basionym
FamiliyCache nvarchar (50) Name of the family
OrderCache nvarchar (50) Name of the order
HierarchyCache nvarchar (MAX) Hierarchy above the current taxon starting at top level and separated via "

Depending on:

  • TaxonHierarchy
  • TaxonName

Function TaxonListLastUpdate

Returns the last date when any list related data were updated

DataType: datetime

Parameter DataType Description
@ListID int ProjectID as defined in table TaxonNameListProjectProxy

Depending on:

  • TaxonNameList
  • TaxonNameListAnalysis
  • TaxonNameListArea
  • TaxonNameListCollectionSpecimen
  • TaxonNameListDistribution
  • TaxonNameListReference

Function TaxonListsForUser

Returns the taxon lists for a user as defined in table TaxonNameListUser

Parameter DataType Description
@Login nvarchar (50) Login of the user as stored in table TaxonNameListUser
Column DataType Description
ProjectID int ID of the Project, Primary key. May be related to module DiversityProjects
DataSource nvarchar (50) The project as defined in table TaxonNameListProjectProxy
DisplayText nvarchar (50) The text as shown in a user interface. Corresponds to ProjectTitle in DiversityProjects.Project
TaxonomicGroup nvarchar (50) The taxonomic group as used in DiversityCollection resp. DiversityMobile
DefaultProjectID int The ID of the default project where informations about e.g. the synonymy are taken from

Depending on:

  • TaxonNameListProjectProxy
  • TaxonNameListUser

Function TaxonListsLastUpdate

Function providing informations needed by the webservice: Returns a result set that lists all the taxon lists and the date of their last change

Column DataType Description
maxlog smalldatetime Date of the last change of a TaxonList
projectid int Each project can may contain one taxon list. Refers to the common project definition in the DiversityProjects module.

Depending on:

  • TaxonName
  • TaxonName_Log
  • TaxonNameList

Function TaxonNameCache

Returns the TaxonNameCache for a taxon

DataType: nvarchar (255)

Parameter DataType Description
@NameID int The ID of a name in DiversityTaxonNames_Fungi (primary key)

Depending on:

  • TaxonName

Function TaxonNameCacheSinAut

returns the TaxonName for a taxon excluding authors

DataType: nvarchar (255)

Parameter DataType Description
@NameID int The ID of a name in DiversityTaxonNames_Fungi (primary key)

Depending on:

  • TaxonName

Function TaxonNameListAnalysisCategoryChildNodes

Returns a result set that lists all analysis items within a hierarchy starting at the topmost item related to the given item

Parameter DataType Description
@ID int AnalysisID of the analysis for which the child nodes should be returned
Column DataType Description
AnalysisID int ID of the analysis (Primary key)
AnalysisParentID int Analysis ID of the parent analysis if it belongs to a certain type documented in this table
DisplayText nvarchar (50) Name of the analysis as e.g. shown in user interface
Description nvarchar (500) Description of the analysis
Notes nvarchar (1000) Notes concerning this analysis
AnalysisURI varchar (255) URI referring to an external documentation of the analysis
ReferenceTitle nvarchar (800) The title of the publication where details about the analysis are published. Note this is only a cached value where ReferenceURI is present
ReferenceURI varchar (400) URI (e.g. LSID) of Reference, referes to table ReferenceTitle in module DiversityReferences: Source publication where details about the analysis are published
DataWithholdingReason nvarchar (255) If the data set is withhold, the reason for withholding the data, otherwise null
SortingID int An ID for sorting the data

Depending on:

  • TaxonNameListAnalysisCategory

Function TaxonNameListAnalysisCategoryHierarchy

Returns a table that lists all the analysis items related to the given analysis

Parameter DataType Description
@AnalysisID int ID of the analysis (Primary key)
Column DataType Description
AnalysisID int ID of the analysis (Primary key)
AnalysisParentID int Analysis ID of the parent analysis if it belongs to a certain type documented in this table
DisplayText nvarchar (50) Name of the analysis as e.g. shown in user interface
Description nvarchar (500) Description of the analysis
Notes nvarchar (1000) Notes concerning this analysis
AnalysisURI varchar (255) URI referring to an external documentation of the analysis
ReferenceTitle nvarchar (800) The title of the publication where details about the analysis are published. Note this is only a cached value where ReferenceURI is present
ReferenceURI varchar (400) URI (e.g. LSID) of Reference, referes to table ReferenceTitle in module DiversityReferences: Source publication where details about the analysis are published
DataWithholdingReason nvarchar (255) If the data set is withhold, the reason for withholding the data, otherwise null
SortingID int An ID for sorting the data

Depending on:

  • TaxonNameListAnalysisCategory
  • TaxonNameListAnalysisCategoryChildNodes

Function TaxonNameListUserNameID

Returns a result set that lists all the NameIDs for a user related to the taxon lists

Column DataType Description
NameID int The ID of a name in DiversityTaxonNames_Fungi (primary key)

Depending on:

  • TaxonName
  • TaxonNameList
  • TaxonNameListUser

Function UserID

ID of the User as stored in table UserProxy

DataType: int

Depending on:

  • UserProxy

Function Version

Version of the database

DataType: nvarchar (8)


Function VersionClient

Version of the client compatible with the database

DataType: nvarchar (11)


PROCEDURES


Procedure procFillSynonymyListCache

Fills table SynonymyListCache for the given NameID or any if missing and ProjectID or any if missing

Parameter DataType Description
@ProjectID int The ProjectID of the taxon for which the hierarchy should be retrieved
@NameID int The NameID of the taxon for which the hierarchy should be retrieved
@Level int The level how deep the hierarchy should extracted

Depending on:

  • ProjectProxy
  • SynonymyList
  • SynonymyListCache
  • TaxonName

Procedure procHierarchyCache

Update of the hierarchy cache for all entries with disabled triggers to avoid increase of logfile entries

Depending on:

  • HierarchyList
  • TaxonHierarchy

Procedure procSetVersionTaxonName

Setting the value for column Version in table TaxonName

Parameter DataType Description
@ID int The NameID of the taxon

Depending on:

  • TaxonName

Procedure procTaxonNameInsertCopy

Copy all entries of a name into a new dataset

Parameter DataType Description
@NameID int The ID of a name in DiversityTaxonNames (foreign key + part of primary key: the name may occur in multiple projects)
@OriginalNameID int The NameID of the dataset that should be copied
@Projects varchar (8000) List of comma separated ProjectIDs that should be copied

Depending on:

  • DefaultProjectID
  • NextNameID
  • ProjectList
  • TaxonHierarchy_Core
  • TaxonName_Core
  • TaxonNameProject

Procedure procTaxonNameInsertNew_3

Inserts a new dataset in the table TaxonName

Parameter DataType Description
@NameID int The ID of a name in DiversityTaxonNames_Fungi (primary key)
@Projects varchar (8000) Comma separated list of the project IDs for which the new taxon should be inserted
@NomenclaturalCode int Code of Nomenclature under which this taxon was created: ‘Bacteriology’, ‘Botany’ (incl. Mycology), ‘Zoology’, ‘Biocode’ (for future use), ‘Non nomenclatural name’. Default value: ‘Botany’

Depending on:

  • TaxonName
  • TaxonNameProject

Procedure procTaxonNameListInsertCopy

Copy all list entries of a name into the list of the current name

Parameter DataType Description
@NameID int ID of the name. Refers to the NameID of TaxonName (= foreign key).
@OriginalNameID int The NameID of the dataset that should be copied
@ProjectID int Each project can may contain one taxon list. Refers to the common project definition in the DiversityProjects module.

Depending on:

  • TaxonNameList
  • TaxonNameListAnalysis
  • TaxonNameListCollectionSpecimen
  • TaxonNameListDistribution
  • TaxonNameListReference

Procedure procTaxonNameListInsertReferenceCopy

Copy all list entries of a name into the list of the current name

Parameter DataType Description
@NameID int ID of the name. Refers to the NameID of TaxonName (= foreign key).
@O_TaxonNameListRefID int The PK of the reference that should be copied
@ProjectID int Each project can may contain one taxon list. Refers to the common project definition in the DiversityProjects module.

Depending on:

  • TaxonNameList
  • TaxonNameListAnalysis
  • TaxonNameListDistribution
  • TaxonNameListReference

Procedure SetUserProjects

Create database user and assign training projects

Parameter DataType Description
@User varchar (50) Login of the user

Depending on:

  • UserProxy

ROLES

Content of cell Permission
Not granted
Name of other role Inherited from other role
Granted

Role DiversityWorkbenchAdministrator

Role for administration of the database content

Permissions SELECT INSERT UPDATE DELETE EXECUTE Type
CountryCode_Enum Diversity Workbench User TABLE
LanguageCode_Enum Diversity Workbench User TABLE
ProjectUser TABLE
ReplicationPublisher TABLE
SynonymyListCache Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonAcceptedName Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonAcceptedName_log Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonCommonName Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonCommonName_log TABLE
TaxonGeography Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonGeography_log Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonHierarchy Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonHierarchy_log Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonName Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonName_log Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonNameCreationType_Enum Diversity Workbench User TABLE
TaxonNameExternalDatabase Diversity Workbench User TABLE
TaxonNameExternalDatabase_log TABLE
TaxonNameExternalID Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonNameExternalID_log TABLE
TaxonNameList Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonNameList_log Diversity Workbench User Diversity Workbench Editor TABLE
TaxonNameListAnalysis Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonNameListAnalysis_log Diversity Workbench User Diversity Workbench Editor TABLE
TaxonNameListAnalysisCategory Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonNameListAnalysisCategory_log Diversity Workbench User Diversity Workbench Editor TABLE
TaxonNameListAnalysisCategoryValue Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonNameListAnalysisCategoryValue_log Diversity Workbench User Diversity Workbench Editor TABLE
TaxonNameListArea Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonNameListArea_log Diversity Workbench User Diversity Workbench Editor TABLE
TaxonNameListCollectionSpecimen Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonNameListCollectionSpecimen_log TABLE
TaxonNameListDistribution Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonNameListDistribution_log Diversity Workbench User Diversity Workbench Editor TABLE
TaxonNameListImage TABLE
TaxonNameListImage_log TABLE
TaxonNameListReference Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonNameListReference_log Diversity Workbench User Diversity Workbench Editor TABLE
TaxonNameListReferenceType_Enum Diversity Workbench User TABLE
TaxonNameListSpecimenRole_Enum Diversity Workbench User TABLE
TaxonNameListUser Diversity Workbench User TABLE
TaxonNameNomenclaturalCode_Enum Diversity Workbench User TABLE
TaxonNameNomenclaturalStatus_Enum Diversity Workbench User TABLE
TaxonNameProject Diversity Workbench User Diversity Workbench Editor TABLE
TaxonNameProject_log Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonNameReference Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonNameReference_log Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonNameResource Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonNameResource_log Diversity Workbench User Diversity Workbench Editor TABLE
TaxonNameResourceType_Enum Diversity Workbench User TABLE
TaxonNameRevisionLevel_Enum Diversity Workbench User TABLE
TaxonNameSynonymisationType_Enum Diversity Workbench User TABLE
TaxonNameTaxonomicRank_Enum Diversity Workbench User TABLE
TaxonNameTypification Diversity Workbench Editor Diversity Workbench Editor Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonNameTypification_log Diversity Workbench User Diversity Workbench Editor TABLE
TaxonSynonymy Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor Diversity Workbench Editor TABLE
TaxonSynonymy_log Diversity Workbench Editor Diversity Workbench Editor TABLE
AcceptedNameChanges Diversity Workbench User VIEW
GenusList VIEW
NameID_UserAvailable Diversity Workbench User VIEW
ProjectList Diversity Workbench User VIEW
TaxonAcceptedName_Core Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor Diversity Workbench Editor VIEW
TaxonAcceptedName_Indicated Diversity Workbench User VIEW
TaxonAcceptedNameList Diversity Workbench User VIEW
TaxonAcceptedNameListIncludeIgnored Diversity Workbench User VIEW
TaxonFamily Diversity Workbench User VIEW
TaxonGeography_Core Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor Diversity Workbench Editor VIEW
TaxonHierarchy_Core Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor Diversity Workbench Editor VIEW
TaxonListSynType Diversity Workbench User VIEW
TaxonName_Core Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor VIEW
TaxonName_Indicated Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor VIEW
TaxonNameExternalID_Core Diversity Workbench User VIEW
TaxonOrder Diversity Workbench User VIEW
TaxonSynonymy_Core Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor Diversity Workbench Editor VIEW
TaxonSynonymy_Indicated Diversity Workbench User VIEW
TaxonSynonymyAcceptedNameID Diversity Workbench User VIEW
TaxonSynonymyList Diversity Workbench User VIEW
TaxonSynonymyListIncludeIgnored Diversity Workbench User VIEW
ViewBaseURL Diversity Workbench User VIEW
ViewDefaultProjectID Diversity Workbench User VIEW
ViewDiversityWorkbenchModule Diversity Workbench User VIEW
ViewTaxonNameResource Diversity Workbench User Diversity Workbench Editor Diversity Workbench Editor Diversity Workbench Editor VIEW
AcceptedNameID Diversity Workbench User FUNCTION
AnalysisCategoryHierarchyAll Diversity Workbench User FUNCTION
BaseURL Diversity Workbench User FUNCTION
DefaultProjectID Diversity Workbench User FUNCTION
DiversityMobile_TaxonList Diversity Workbench User FUNCTION
DiversityWorkbenchModule Diversity Workbench User FUNCTION
HierarchyCache Diversity Workbench Editor FUNCTION
HierarchyFamilyList Diversity Workbench User FUNCTION
HierarchyList Diversity Workbench User FUNCTION
HierarchyOrderList Diversity Workbench User FUNCTION
HierarchySuperiorList Diversity Workbench User FUNCTION
NameList Diversity Workbench User FUNCTION
NextNameID Diversity Workbench Editor FUNCTION
PrivacyConsentInfo Diversity Workbench User FUNCTION
SynonymyList Diversity Workbench User FUNCTION
SynonymyListIncludeIgnored Diversity Workbench User FUNCTION
TaxonChildNodes Diversity Workbench User FUNCTION
TaxonListLastUpdate Diversity Workbench User FUNCTION
TaxonListsForUser Diversity Workbench User FUNCTION
TaxonListsLastUpdate Diversity Workbench User FUNCTION
TaxonNameCache Diversity Workbench User FUNCTION
TaxonNameCacheSinAut Diversity Workbench User FUNCTION
TaxonNameListAnalysisCategoryChildNodes Diversity Workbench User FUNCTION
TaxonNameListAnalysisCategoryHierarchy Diversity Workbench User FUNCTION
TaxonNameListUserNameID Diversity Workbench User FUNCTION
UserID Diversity Workbench User FUNCTION
Version Diversity Workbench User FUNCTION
VersionClient Diversity Workbench User FUNCTION
procFillSynonymyListCache Diversity Workbench Editor PROCEDURE
procHierarchyCache Diversity Workbench Editor PROCEDURE
procSetVersionTaxonName PROCEDURE
procTaxonNameInsertCopy Diversity Workbench Editor PROCEDURE
procTaxonNameInsertNew_3 Diversity Workbench Editor PROCEDURE
procTaxonNameListInsertCopy Diversity Workbench Editor PROCEDURE
procTaxonNameListInsertReferenceCopy Diversity Workbench Editor PROCEDURE
SetUserProjects PROCEDURE
Inheriting from roles:
  • DiversityWorkbenchEditor

Role DiversityWorkbenchEditor

Role for editing the user dependent content of the database

Permissions SELECT INSERT UPDATE DELETE EXECUTE Type
CountryCode_Enum Diversity Workbench User TABLE
LanguageCode_Enum Diversity Workbench User TABLE
ProjectUser Diversity Workbench User TABLE
ReplicationPublisher TABLE
SynonymyListCache Diversity Workbench User TABLE
TaxonAcceptedName Diversity Workbench User TABLE
TaxonAcceptedName_log TABLE
TaxonCommonName Diversity Workbench User TABLE
TaxonCommonName_log TABLE
TaxonGeography Diversity Workbench User TABLE
TaxonGeography_log TABLE
TaxonHierarchy Diversity Workbench User TABLE
TaxonHierarchy_log TABLE
TaxonName Diversity Workbench User TABLE
TaxonName_log TABLE
TaxonNameCreationType_Enum Diversity Workbench User TABLE
TaxonNameExternalDatabase Diversity Workbench User TABLE
TaxonNameExternalDatabase_log TABLE
TaxonNameExternalID Diversity Workbench User TABLE
TaxonNameExternalID_log TABLE
TaxonNameList Diversity Workbench User TABLE
TaxonNameList_log Diversity Workbench User TABLE
TaxonNameListAnalysis Diversity Workbench User TABLE
TaxonNameListAnalysis_log Diversity Workbench User TABLE
TaxonNameListAnalysisCategory Diversity Workbench User TABLE
TaxonNameListAnalysisCategory_log Diversity Workbench User TABLE
TaxonNameListAnalysisCategoryValue Diversity Workbench User TABLE
TaxonNameListAnalysisCategoryValue_log Diversity Workbench User TABLE
TaxonNameListArea Diversity Workbench User TABLE
TaxonNameListArea_log Diversity Workbench User TABLE
TaxonNameListCollectionSpecimen Diversity Workbench User TABLE
TaxonNameListCollectionSpecimen_log TABLE
TaxonNameListDistribution Diversity Workbench User TABLE
TaxonNameListDistribution_log Diversity Workbench User TABLE
TaxonNameListImage TABLE
TaxonNameListImage_log TABLE
TaxonNameListReference Diversity Workbench User TABLE
TaxonNameListReference_log Diversity Workbench User TABLE
TaxonNameListReferenceType_Enum Diversity Workbench User TABLE
TaxonNameListSpecimenRole_Enum Diversity Workbench User TABLE
TaxonNameListUser Diversity Workbench User TABLE
TaxonNameNomenclaturalCode_Enum Diversity Workbench User TABLE
TaxonNameNomenclaturalStatus_Enum Diversity Workbench User TABLE
TaxonNameProject Diversity Workbench User TABLE
TaxonNameProject_log TABLE
TaxonNameReference Diversity Workbench User TABLE
TaxonNameReference_log TABLE
TaxonNameResource Diversity Workbench User TABLE
TaxonNameResource_log Diversity Workbench User TABLE
TaxonNameResourceType_Enum Diversity Workbench User TABLE
TaxonNameRevisionLevel_Enum Diversity Workbench User TABLE
TaxonNameSynonymisationType_Enum Diversity Workbench User TABLE
TaxonNameTaxonomicRank_Enum Diversity Workbench User TABLE
TaxonNameTypification TABLE
TaxonNameTypification_log Diversity Workbench User TABLE
TaxonSynonymy Diversity Workbench User TABLE
TaxonSynonymy_log TABLE
AcceptedNameChanges Diversity Workbench User VIEW
GenusList VIEW
NameID_UserAvailable Diversity Workbench User VIEW
ProjectList Diversity Workbench User VIEW
TaxonAcceptedName_Core Diversity Workbench User VIEW
TaxonAcceptedName_Indicated Diversity Workbench User VIEW
TaxonAcceptedNameList Diversity Workbench User VIEW
TaxonAcceptedNameListIncludeIgnored Diversity Workbench User VIEW
TaxonFamily Diversity Workbench User VIEW
TaxonGeography_Core Diversity Workbench User VIEW
TaxonHierarchy_Core Diversity Workbench User VIEW
TaxonListSynType Diversity Workbench User VIEW
TaxonName_Core Diversity Workbench User VIEW
TaxonName_Indicated Diversity Workbench User VIEW
TaxonNameExternalID_Core Diversity Workbench User VIEW
TaxonOrder Diversity Workbench User VIEW
TaxonSynonymy_Core Diversity Workbench User VIEW
TaxonSynonymy_Indicated Diversity Workbench User VIEW
TaxonSynonymyAcceptedNameID Diversity Workbench User VIEW
TaxonSynonymyList Diversity Workbench User VIEW
TaxonSynonymyListIncludeIgnored Diversity Workbench User VIEW
ViewBaseURL Diversity Workbench User VIEW
ViewDefaultProjectID Diversity Workbench User VIEW
ViewDiversityWorkbenchModule Diversity Workbench User VIEW
ViewTaxonNameResource Diversity Workbench User VIEW
AcceptedNameID Diversity Workbench User FUNCTION
AnalysisCategoryHierarchyAll Diversity Workbench User FUNCTION
BaseURL Diversity Workbench User FUNCTION
DefaultProjectID Diversity Workbench User FUNCTION
DiversityMobile_TaxonList Diversity Workbench User FUNCTION
DiversityWorkbenchModule Diversity Workbench User FUNCTION
HierarchyCache FUNCTION
HierarchyFamilyList Diversity Workbench User FUNCTION
HierarchyList Diversity Workbench User FUNCTION
HierarchyOrderList Diversity Workbench User FUNCTION
HierarchySuperiorList Diversity Workbench User FUNCTION
NameList Diversity Workbench User FUNCTION
NextNameID FUNCTION
PrivacyConsentInfo Diversity Workbench User FUNCTION
SynonymyList Diversity Workbench User FUNCTION
SynonymyListIncludeIgnored Diversity Workbench User FUNCTION
TaxonChildNodes Diversity Workbench User FUNCTION
TaxonListLastUpdate Diversity Workbench User FUNCTION
TaxonListsForUser Diversity Workbench User FUNCTION
TaxonListsLastUpdate Diversity Workbench User FUNCTION
TaxonNameCache Diversity Workbench User FUNCTION
TaxonNameCacheSinAut Diversity Workbench User FUNCTION
TaxonNameListAnalysisCategoryChildNodes Diversity Workbench User FUNCTION
TaxonNameListAnalysisCategoryHierarchy Diversity Workbench User FUNCTION
TaxonNameListUserNameID Diversity Workbench User FUNCTION
UserID Diversity Workbench User FUNCTION
Version Diversity Workbench User FUNCTION
VersionClient Diversity Workbench User FUNCTION
procFillSynonymyListCache PROCEDURE
procHierarchyCache PROCEDURE
procSetVersionTaxonName PROCEDURE
procTaxonNameInsertCopy PROCEDURE
procTaxonNameInsertNew_3 PROCEDURE
procTaxonNameListInsertCopy PROCEDURE
procTaxonNameListInsertReferenceCopy PROCEDURE
SetUserProjects PROCEDURE
Inheriting from roles:
  • DiversityWorkbenchUser

Role DiversityWorkbenchReplicator

Role involved in the replication of data

Permissions SELECT INSERT UPDATE DELETE EXECUTE Type
CountryCode_Enum TABLE
LanguageCode_Enum TABLE
ProjectUser TABLE
ReplicationPublisher TABLE
SynonymyListCache TABLE
TaxonAcceptedName TABLE
TaxonAcceptedName_log TABLE
TaxonCommonName TABLE
TaxonCommonName_log TABLE
TaxonGeography TABLE
TaxonGeography_log TABLE
TaxonHierarchy TABLE
TaxonHierarchy_log TABLE
TaxonName TABLE
TaxonName_log TABLE
TaxonNameCreationType_Enum TABLE
TaxonNameExternalDatabase TABLE
TaxonNameExternalDatabase_log TABLE
TaxonNameExternalID TABLE
TaxonNameExternalID_log TABLE
TaxonNameList TABLE
TaxonNameList_log TABLE
TaxonNameListAnalysis TABLE
TaxonNameListAnalysis_log TABLE
TaxonNameListAnalysisCategory TABLE
TaxonNameListAnalysisCategory_log TABLE
TaxonNameListAnalysisCategoryValue TABLE
TaxonNameListAnalysisCategoryValue_log TABLE
TaxonNameListArea TABLE
TaxonNameListArea_log TABLE
TaxonNameListCollectionSpecimen TABLE
TaxonNameListCollectionSpecimen_log TABLE
TaxonNameListDistribution TABLE
TaxonNameListDistribution_log TABLE
TaxonNameListImage TABLE
TaxonNameListImage_log TABLE
TaxonNameListReference TABLE
TaxonNameListReference_log TABLE
TaxonNameListReferenceType_Enum TABLE
TaxonNameListSpecimenRole_Enum TABLE
TaxonNameListUser TABLE
TaxonNameNomenclaturalCode_Enum TABLE
TaxonNameNomenclaturalStatus_Enum TABLE
TaxonNameProject TABLE
TaxonNameProject_log TABLE
TaxonNameReference TABLE
TaxonNameReference_log TABLE
TaxonNameResource TABLE
TaxonNameResource_log TABLE
TaxonNameResourceType_Enum TABLE
TaxonNameRevisionLevel_Enum TABLE
TaxonNameSynonymisationType_Enum TABLE
TaxonNameTaxonomicRank_Enum TABLE
TaxonNameTypification TABLE
TaxonNameTypification_log TABLE
TaxonSynonymy TABLE
TaxonSynonymy_log TABLE
AcceptedNameChanges VIEW
GenusList VIEW
NameID_UserAvailable VIEW
ProjectList VIEW
TaxonAcceptedName_Core VIEW
TaxonAcceptedName_Indicated VIEW
TaxonAcceptedNameList VIEW
TaxonAcceptedNameListIncludeIgnored VIEW
TaxonFamily VIEW
TaxonGeography_Core VIEW
TaxonHierarchy_Core VIEW
TaxonListSynType VIEW
TaxonName_Core VIEW
TaxonName_Indicated VIEW
TaxonNameExternalID_Core VIEW
TaxonOrder VIEW
TaxonSynonymy_Core VIEW
TaxonSynonymy_Indicated VIEW
TaxonSynonymyAcceptedNameID VIEW
TaxonSynonymyList VIEW
TaxonSynonymyListIncludeIgnored VIEW
ViewBaseURL VIEW
ViewDefaultProjectID VIEW
ViewDiversityWorkbenchModule VIEW
ViewTaxonNameResource VIEW
AcceptedNameID FUNCTION
AnalysisCategoryHierarchyAll FUNCTION
BaseURL FUNCTION
DefaultProjectID FUNCTION
DiversityMobile_TaxonList FUNCTION
DiversityWorkbenchModule FUNCTION
HierarchyCache FUNCTION
HierarchyFamilyList FUNCTION
HierarchyList FUNCTION
HierarchyOrderList FUNCTION
HierarchySuperiorList FUNCTION
NameList FUNCTION
NextNameID FUNCTION
PrivacyConsentInfo FUNCTION
SynonymyList FUNCTION
SynonymyListIncludeIgnored FUNCTION
TaxonChildNodes FUNCTION
TaxonListLastUpdate FUNCTION
TaxonListsForUser FUNCTION
TaxonListsLastUpdate FUNCTION
TaxonNameCache FUNCTION
TaxonNameCacheSinAut FUNCTION
TaxonNameListAnalysisCategoryChildNodes FUNCTION
TaxonNameListAnalysisCategoryHierarchy FUNCTION
TaxonNameListUserNameID FUNCTION
UserID FUNCTION
Version FUNCTION
VersionClient FUNCTION
procFillSynonymyListCache PROCEDURE
procHierarchyCache PROCEDURE
procSetVersionTaxonName PROCEDURE
procTaxonNameInsertCopy PROCEDURE
procTaxonNameInsertNew_3 PROCEDURE
procTaxonNameListInsertCopy PROCEDURE
procTaxonNameListInsertReferenceCopy PROCEDURE
SetUserProjects PROCEDURE

Role DiversityWorkbenchUser

Role with read only access to the data

Permissions SELECT INSERT UPDATE DELETE EXECUTE Type
CountryCode_Enum TABLE
LanguageCode_Enum TABLE
ProjectUser TABLE
ReplicationPublisher TABLE
SynonymyListCache TABLE
TaxonAcceptedName TABLE
TaxonAcceptedName_log TABLE
TaxonCommonName TABLE
TaxonCommonName_log TABLE
TaxonGeography TABLE
TaxonGeography_log TABLE
TaxonHierarchy TABLE
TaxonHierarchy_log TABLE
TaxonName TABLE
TaxonName_log TABLE
TaxonNameCreationType_Enum TABLE
TaxonNameExternalDatabase TABLE
TaxonNameExternalDatabase_log TABLE
TaxonNameExternalID TABLE
TaxonNameExternalID_log TABLE
TaxonNameList TABLE
TaxonNameList_log TABLE
TaxonNameListAnalysis TABLE
TaxonNameListAnalysis_log TABLE
TaxonNameListAnalysisCategory TABLE
TaxonNameListAnalysisCategory_log TABLE
TaxonNameListAnalysisCategoryValue TABLE
TaxonNameListAnalysisCategoryValue_log TABLE
TaxonNameListArea TABLE
TaxonNameListArea_log TABLE
TaxonNameListCollectionSpecimen TABLE
TaxonNameListCollectionSpecimen_log TABLE
TaxonNameListDistribution TABLE
TaxonNameListDistribution_log TABLE
TaxonNameListImage TABLE
TaxonNameListImage_log TABLE
TaxonNameListReference TABLE
TaxonNameListReference_log TABLE
TaxonNameListReferenceType_Enum TABLE
TaxonNameListSpecimenRole_Enum TABLE
TaxonNameListUser TABLE
TaxonNameNomenclaturalCode_Enum TABLE
TaxonNameNomenclaturalStatus_Enum TABLE
TaxonNameProject TABLE
TaxonNameProject_log TABLE
TaxonNameReference TABLE
TaxonNameReference_log TABLE
TaxonNameResource TABLE
TaxonNameResource_log TABLE
TaxonNameResourceType_Enum TABLE
TaxonNameRevisionLevel_Enum TABLE
TaxonNameSynonymisationType_Enum TABLE
TaxonNameTaxonomicRank_Enum TABLE
TaxonNameTypification TABLE
TaxonNameTypification_log TABLE
TaxonSynonymy TABLE
TaxonSynonymy_log TABLE
AcceptedNameChanges VIEW
GenusList VIEW
NameID_UserAvailable VIEW
ProjectList VIEW
TaxonAcceptedName_Core VIEW
TaxonAcceptedName_Indicated VIEW
TaxonAcceptedNameList VIEW
TaxonAcceptedNameListIncludeIgnored VIEW
TaxonFamily VIEW
TaxonGeography_Core VIEW
TaxonHierarchy_Core VIEW
TaxonListSynType VIEW
TaxonName_Core VIEW
TaxonName_Indicated VIEW
TaxonNameExternalID_Core VIEW
TaxonOrder VIEW
TaxonSynonymy_Core VIEW
TaxonSynonymy_Indicated VIEW
TaxonSynonymyAcceptedNameID VIEW
TaxonSynonymyList VIEW
TaxonSynonymyListIncludeIgnored VIEW
ViewBaseURL VIEW
ViewDefaultProjectID VIEW
ViewDiversityWorkbenchModule VIEW
ViewTaxonNameResource VIEW
AcceptedNameID FUNCTION
AnalysisCategoryHierarchyAll FUNCTION
BaseURL FUNCTION
DefaultProjectID FUNCTION
DiversityMobile_TaxonList FUNCTION
DiversityWorkbenchModule FUNCTION
HierarchyCache FUNCTION
HierarchyFamilyList FUNCTION
HierarchyList FUNCTION
HierarchyOrderList FUNCTION
HierarchySuperiorList FUNCTION
NameList FUNCTION
NextNameID FUNCTION
PrivacyConsentInfo FUNCTION
SynonymyList FUNCTION
SynonymyListIncludeIgnored FUNCTION
TaxonChildNodes FUNCTION
TaxonListLastUpdate FUNCTION
TaxonListsForUser FUNCTION
TaxonListsLastUpdate FUNCTION
TaxonNameCache FUNCTION
TaxonNameCacheSinAut FUNCTION
TaxonNameListAnalysisCategoryChildNodes FUNCTION
TaxonNameListAnalysisCategoryHierarchy FUNCTION
TaxonNameListUserNameID FUNCTION
UserID FUNCTION
Version FUNCTION
VersionClient FUNCTION
procFillSynonymyListCache PROCEDURE
procHierarchyCache PROCEDURE
procSetVersionTaxonName PROCEDURE
procTaxonNameInsertCopy PROCEDURE
procTaxonNameInsertNew_3 PROCEDURE
procTaxonNameListInsertCopy PROCEDURE
procTaxonNameListInsertReferenceCopy PROCEDURE
SetUserProjects PROCEDURE
Mar 5, 2025

Diversity TaxonNames

Enumeration tables

The following objects are not included:

  • Logging tables
  • System objects
  • Objects marked as obsolete
  • Previous versions of objects

Table

Column Data type Description
Code nvarchar (50) A text code that uniquely identifies each object in the enumeration (primary key). This value may not be changed, because the application may depend upon it.
Description nvarchar (800) Description of enumerated object, displayed in the user interface
DisplayText nvarchar (50) Short abbreviated description of the object, displayed in the user interface
DisplayOrder smallint The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.
DisplayEnable bit Enumerated objects can be hidden from the user interface if this attribute is set to false (= unchecked check box)
InternalNotes nvarchar (500) Internal development notes about usage, definition, etc. of an enumerated object
ParentCode nvarchar (50) The code of the superior entry, if a hierarchy within the entries is necessary
RowGUID uniqueidentifier -Default value: newsequentialid()

Content

Code Description DisplayText
1 Bacteriology Bacteriology
2 Botany (incl. Mycology) Botany (incl. Mycology)
3 Zoology Zoology
4 Biocode (for future use) Biocode (for future use)

Table CountryCode_Enum

2 letter codes for countries according to ISO 3166-1 alpha-2

Dependent tables:

  • TaxonCommonName

Content

Code Description DisplayText
AD Andorra Andorra
AE United Arab Emirates United Arab Emirates
AF Afghanistan Afghanistan
AG Antigua and Barbuda Antigua and Barbuda
AI Anguilla Anguilla
AL Albania Albania
AM Armenia Armenia
AO Angola Angola
AR Argentinia Argentinia
AS American Samoa American Samoa
AT Austria Austria
AU Australia Australia
AW Aruba Aruba
AZ Azerbaijan Azerbaijan
BA Bosnia and Herzegovina Bosnia and Herzegovina
BB Barbados Barbados
BD Bangladesh Bangladesh
BE Belgium Belgium
BF Burkina Faso Burkina Faso
BG Bulgaria Bulgaria
BH Bahrain Bahrain
BI Burundi Burundi
BJ Benin Benin
BM Bermuda Bermuda
BN Brunei Darussalam Brunei Darussalam
BO Bolivia Bolivia
BR Brazil Brazil
BS Bahamas Bahamas
BT Bhutan Bhutan
BW Botswana Botswana
BY Belarus Belarus
BZ Belize Belize
CA Canada Canada
CD congo The democratic republic of the congo The democratic republic of the
CF Central African Republic Central African Republic
CG Congo Congo
CH Switzerland Switzerland
CI Ivory Coast Ivory Coast
CK Cook Islands Cook Islands
CL Chile Chile
CM Cameroon Cameroon
CN China China
CO Colombia Colombia
CR Costa Rica Costa Rica
CU Cuba Cuba
CV Cape Verde Cape Verde
CX Christmas Island Christmas Island
CY Cyprus Cyprus
CZ Czech Republic Czech Republic
DE Germany Germany
DJ Djibouti Djibouti
DK Denmark Denmark
DM Dominica Dominica
DO Dominican Republic Dominican Republic
DZ Algeria Algeria
EC Ecuador Ecuador
EE Estonia Estonia
EG Egypt Egypt
ER Eritrea Eritrea
ES Spain Spain
ET Ethiopia Ethiopia
FI Finland Finland
FJ Fiji Fiji
FK Falkland Islands Falkland Islands
FO Faroe Islands Faroe Islands
FR France France
GA Gabon Gabon
GB United Kingdom United Kingdom
GD Grenada Grenada
GE Georgia Georgia
GF French Guiana French Guiana
GG Guernsey Guernsey
GH Ghana Ghana
GI Gibraltar Gibraltar
GL Greenland Greenland
GM Gambia Gambia
GN Guinea Guinea
GP Guadeloupe Guadeloupe
GR Greece Greece
GT Guatemala Guatemala
GU Guam Guam
GW Guinea-Bissau Guinea-Bissau
GY Guyana Guyana
HN Honduras Honduras
HR Croatia Croatia
HT Haiti Haiti
HU Hungary Hungary
ID Indonesia Indonesia
IE Ireland Ireland
IL Israel Israel
IM Isle of Man Isle of Man
IN India India
IQ Iraq Iraq
IR Iran Iran
IS Iceland Iceland
IT Italy Italy
JE Jersey Jersey
JM Jamaica Jamaica
JP Japan Japan
KE Kenya Kenya
KG Kyrgyzstan Kyrgyzstan
KH Cambodia Cambodia
KI Kiribati Kiribati
KM Comoros Comoros
KN Saint Kitts and Nevis Saint Kitts and Nevis
KY Cayman Islands Cayman Islands
KZ Kazakhstan Kazakhstan
LA Laos Laos
LB Lebanon Lebanon
LC Saint Lucia Saint Lucia
LI Liechtenstein Liechtenstein
LK Sri Lanka Sri Lanka
LR Liberia Liberia
LS Lesotho Lesotho
LT Lithuania Lithuania
LU Luxembourg Luxembourg
LV Latvia Latvia
LY Libya Libya
MA Morocco Morocco
MC Monaco Monaco
MD Moldova Moldova
MG Madagascar Madagascar
MH Marshall Islands Marshall Islands
MK Macedonia Macedonia
ML Mali Mali
MM Myanmar (Burma) Myanmar (Burma)
MN Mongolia Mongolia
MO Macao Macao
MP Northern Mariana Islands Northern Mariana Islands
MQ Martinique Martinique
MR Mauritania Mauritania
MS Montserrat Montserrat
MT Malta Malta
MU Mauritius Mauritius
MV Maldives Maldives
MW Malawi Malawi
MX Mexico Mexico
MY Malaysia Malaysia
MZ Mozambique Mozambique
NA Namibia Namibia
NC New Caledonia New Caledonia
NE Niger Niger
NF Norfolk Island Norfolk Island
NG Nigeria Nigeria
NI Nicaragua Nicaragua
NL Netherlands Netherlands
NO Norway Norway
NP Nepal Nepal
NR Nauru Nauru
NU Niue Niue
NZ New Zealand New Zealand
OM Oman Oman
PA Panama Panama
PE Peru Peru
PF French Polynesia French Polynesia
PG Papua New Guinea Papua New Guinea
PH Philippines Philippines
PK Pakistan Pakistan
PL Poland Poland
PN Pitcairn Pitcairn
PR Puerto Rico Puerto Rico
PT Portugal Portugal
PW Palau Palau
PY Paraguay Paraguay
QA Qatar Qatar
RE Reunion Reunion
RO Romania Romania
RU Russia Russia
RW Rwanda Rwanda
SA Saudi Arabia Saudi Arabia
SB Solomon Islands Solomon Islands
SC Seychelles Seychelles
SD Sudan Sudan
SE Sweden Sweden
SG Singapore Singapore
SH Saint Helena Saint Helena
SI Slovenia Slovenia
SK Slovak Republic Slovak Republic
SL Sierra Leone Sierra Leone
SM San Marino San Marino
SN Senegal Senegal
SO Somalia Somalia
SR Suriname Suriname
ST Sao Tome and Principe Sao Tome and Principe
SV El Salvador El Salvador
SZ Swaziland Swaziland
TC Turks and Caicos Islands Turks and Caicos Islands
TD Chad Chad
TG Togo Togo
TH Thailand Thailand
TJ Tajikistan Tajikistan
TK Tokelau Tokelau
TM Turkmenistan Turkmenistan
TN Tunisia Tunisia
TO Tonga Tonga
TR Turkey Turkey
TT Trinidad and Tobago Trinidad and Tobago
TV Tuvalu Tuvalu
TW Taiwan Taiwan
TZ Tanzania Tanzania
UA Ukrayina Ukrayina
UG Uganda Uganda
US United States United States
UY Uruguay Uruguay
UZ Uzbekistan Uzbekistan
VC Saint Vincent and the Grenadines Saint Vincent and the Grenadines
VE Venezuela Venezuela
VN Vietnam Vietnam
VU Vanuatu Vanuatu
WF Wallis and Futuna Wallis and Futuna
WS Samoa Samoa
YE Yemen Yemen
YT Mayotte Mayotte
ZA South Africa South Africa
ZM Zambia Zambia
ZW Zimbabwe Zimbabwe

Table LanguageCode_Enum

2 letter language codes according to ISO 639-1

Dependent tables:

  • TaxonCommonName

Content

Code Description DisplayText
af Afrikaans Afrikaans
ar Arabic Arabic
az Azerbaijani Azerbaijani
be Byelorussian Byelorussian
bg Bulgarian Bulgarian
ca Catalan Catalan
cs Czech Czech
da Danish Danish
de German German
el Greek Greek
en English English
es Spanish Spanish
et Estonian Estonian
eu Basque Basque
fa Persian Persian
fi Finnish Finnish
fo Faeroese Faeroese
fr French French
gl Galician Galician
gu Gujarati Gujarati
he Hebräisch Hebräisch
hi Hindi Hindi
hr Croatian Croatian
hu Hungarian Hungarian
hy Armenian Armenian
id Indonesisch Indonesisch
is Icelandic Icelandic
it Italian Italian
ja Japanese Japanese
ka Georgian Georgian
kk Kazakh Kazakh
kn Kannada Kannada
ko Korean Korean
ky Kirghiz Kirghiz
lt Lithuanian Lithuanian
lv Latvian Latvian
mk Macedonian Macedonian
mn Mongolian Mongolian
mr Marathi Marathi
ms Malay Malay
nl Dutch Dutch
no Norwegian Norwegian
pa Punjabi Punjabi
pl Polish Polish
pt Portuguese Portuguese
ro Romanian Romanian
ru Russian Russian
sa Sanskrit Sanskrit
sk Slovak Slovak
sl Slovenian Slovenian
sq Albanian Albanian
sv Swedish Swedish
sw Swahili Swahili
ta Tamil Tamil
te Tegulu Tegulu
th Thai Thai
tr Turkish Turkish
tt Tatar Tatar
uk Ukrainian Ukrainian
ur Urdu Urdu
uz Uzbek Uzbek
vi Vietnamese Vietnamese

Table TaxonNameCreationType_Enum

Types of the creation of a taxonomic name

Dependent tables:

  • TaxonName

Content

Code Description DisplayText
auto The name is an autonym, implicitly created through the creation of another taxon name – For example, if for “Poa alpina L.” a new subspecies “Poa alpina ssp. stefanovii Fiserova” is described, the autonym “Poa alpina L. ssp. alpina” is implicitly created as well. It is not published anywhere, and has no author on the subspecies (and neither author nor publication of Fiserova are given). auto
comb A new combination of a name into a different parent taxon that causes a name change. comb
combstat A new combination with a different name and change in rank of a taxon in a single nomenclatural action – For example, a subspecies in genus “Aus” is combined with genus “Bus” and the rank elevated to species at the same time. combstat
nom The name is a nomen novum (= replacement name, = avowed substitute). nom. nov.
sanct (Applicable only to Fungi:) The name is based on a prestarting-point name and sanctioned by the ICBN because is has been used in specific publications by Fries or Persoon. sanct
stat Change in rank of a taxon name, like a subspecies elevated to species rank, or a series to section. stat
tax Creation of a name at any rank, intended to represent a taxon that is new to science and based on an newly designated type. tax
validation The name is a validation of invalidly published names (sometimes expressed by “ex” in the author citation string). validation

Table TaxonNameListReferenceType_Enum

The types of the reference of the taxon list

Dependent tables:

  • TaxonNameListReference
  • TaxonNameReference

Table TaxonNameListSpecimenRole_Enum

Roles of collection specimen within a taxon list

Dependent tables:

  • TaxonNameListCollectionSpecimen

Table TaxonNameNomenclaturalCode_Enum

Codes of Nomenclature under which this taxa are created, e.g. Zoology

Dependent tables:

  • TaxonName

Content

Code Description DisplayText
1 Bacteriology Bacteriology
2 Botany (incl. Mycology) Botany (incl. Mycology)
3 Zoology Zoology
4 Biocode (for future use) Biocode (for future use)

Table TaxonNameNomenclaturalStatus_Enum

Nomenclatural stati for taxonomic names

Dependent tables:

  • TaxonName

Content

Code Description DisplayText
ad interim in the meantime ad interim
comb. combinatio = combination comb.
comb. ined. combinatio inedita = unpublished combination comb. ined.
comb. invalid. comb. invalid. comb. invalid.
comb. superfl. combinatio superflua = superfluous combination (if a combining author has missed on the pre-existence of the same combination, therefore creating an isonym) comb. superfl.
ined. indeditum = unpublished (name) ined.
nom. confus. nomen confusum = confused name nom. confus.
nom. cons. If a name of a family, genus, or species is accepted as a nomen conservandum the abbreviation “nom. cons.” should be added in a formal citation nom. cons.
nom. dub. nom. dub. nom. dub.
nom. excl. nom. excl. nom. excl.
nom. herb. nomen in herbario = name given on herbarium labels nom. herb.
nom. illeg. nomen illegitimum = illegitimate name (ICBN: 6.4, 52-54, App. VII) nom. illeg.
nom. inval. nom. invalid. nom. invalid.
nom. nov. nomen novum = new name, replacement name (ICBN: 45A.1, App. VII) nom. nov.
nom. nud. nom. nudum nom. nud.
nom. provis. nomen provisorium = provisional name nom. provis.
nom. rej. nomen rejiciendum = name, to be rejected (ICBN: 50E.2, 56, App.V, VII) nom. rej.
nom. superfl. nomen superfluum = superfluous name (ICBN: 52.1+3) nom. superfl.
pro syn. In the citation of a name that is not validly published because it was merely cited as a synonym, the words “as synonym” or “pro syn.” should be added pro syn.

Table TaxonNameResourceType_Enum

The type of an resource of a taxon, e.g. preview

Dependent tables:

  • TaxonNameResource

Content

Code Description DisplayText
audio E.g. audio file related to a taxon sound
drawing Original line or color drawing and painting of a taxon drawing, painting
image Still image of any raster or vector format without any further information regarding the content type, e. g. graphic designs, plans and maps, vector graphics 2D, 3D models image
information Any resource provided for the taxon, e.g. websites containing further information information
preview A small version of an image used as preview for an image preview
supporting files text-xml or text-WKT encoded files, assigned to multimedia objects supporting files
video E. g. video file related to a taxon video

Table TaxonNameRevisionLevel_Enum

States of revision for the taxa

Dependent tables:

  • TaxonName

Content

Code Description DisplayText
effectively published effectively published (ICBN Art. 29-31) effectively published (ICBN Art. 29-31)
final revision final revision final revision
review required review required review required
validly published validly published (ICBN Art. 32-45) validly published (ICBN Art. 32-45)

Table TaxonNameSynonymisationType_Enum

Types of the synonyms

Dependent tables:

  • TaxonSynonymy

Content

Code Description DisplayText
duplicate name is a duplicate of an other name, e.g. for imports of the same name from different sources duplicate
heterotypic heterotypic, the names have different basionyms heterotypic
homotypic homotypic, the names have the same basionym homotypic
isonym variant spelled exactly as another name but with deviating citation of the author(s), might be a name with wrong citation of the publishing or recombining author(s) or a even a isonym sensu ICBN isonym
orthographic variant variant spelled different as another name orthographic variant
unknown unknown if synonym is heterotypic or homotypic unknown

Table TaxonNameTaxonomicRank_Enum

Taxonomic ranks of the taxa

Dependent tables:

  • TaxonName

Content

Code Description DisplayText
agg. species aggregate species aggregate
aggr. species aggregate species aggregate
biovar. bio-variety bio-variety
cand. candidate candidate
cl. class class
convar. convar convar
cult. cultivar cultivar
cultivar. group cultivar-group cultivar-group
dom. domain (= empire) domain (= empire)
f. form form
f. sp. special form special form
fam. family family
gen. genus genus
graft-chimaera graft-chimaera graft-chimaera
grex infraspecific aggregate grex
infracl. infraclass infraclass
infrafam. infrafamily infrafamily
infragen. infragenus infragenus
infraord. infraorder infraorder
infraphyl./div. infraphylum (= infradivision) infraphylum (= infradivision)
infrareg. infrakingdom infrakingdom
infrasp. infraspecies infraspecies
infratrib. infratribe infratribe
ord. order order
pathovar. patho-variety patho-variety
phyl./div. phylum (= division) phylum (= division)
reg. kingdom kingdom
sect. section section
ser. series series
sp. species species
sp. group species group species group
subcl. subclass subclass
subfam. subfamily subfamily
subfm. subform subform
subgen. subgenus subgenus
subord. suborder suborder
subphyl./div. subphylum (= subdivision) subphylum (= subdivision)
subreg. subkingdom subkingdom
subsect. subsection subsection
subser. subseries subseries
subsp. subspecies subspecies
subsubfm. subsubform subsubform
subtrib. subtribe subtribe
subvar. sub-variety sub-variety
supercl. superclass superclass
superfam. superfamily superfamily
superord. superorder superorder
superphyl./div. superphylum (= superdivision) superphylum (= superdivision)
superreg. super kingdom super kingdom
supertrib. supertribe supertribe
tax. infragen. infrageneric tax. of undefined rank infrageneric tax. of undefined rank
tax. infrasp. infraspecific tax. of undefined rank infraspecific tax. of undefined rank
tax. supragen. suprageneric tax. of undefined rank suprageneric tax. of undefined rank
trib. tribe tribe
var. variety variety
May 3, 2024

Diversity TaxonNames

No-SQL Interface

JSON Cache

Databases of the modules provid a No-SQL interface where the data of the main table and the depending tables are merged as JSON.

Table JsonCache

Content of table JsonCache restricted to public available data

Column Data type Description Nullable Relation
ID int Unique ID for the Dataset, Primary key NO ID of the source
URI varchar (500) The URL as combination of BaseURL and ID NO BaseURL and ID of the source
DisplayText nvarchar (500) Representation in the interface NO Main table of the source
LogUpdatedWhen datetime Date and time when the data were last updated NO -
Data json Data related to the current dataset NO -

procFillJsonCache is started by an update trigger trgUpd… of the main table in the database

Interface in clients

All modules provide data via a cache table. In the header of the clients you can inspect the content of the JsonCache with a click on the button. For modules with a difference between local and public data, you can inspect the content of the public data with a click of the right mouse button.

Update

Apart of the update via the Trigger (see below) you can update the JsonCache via the update button underneath the button.

To update the JsonCache for the whole database select Administration - JsonCache… from the menu. a window as shown below will open where you can update the JsonCache for single datasets or the whole database.

Summary

graph TD;
    TaxonName[Main table in database] 
    trgUpdTaxonName[trgUpd.. of main table in database]
    TaxonName --> |Update in table| trgUpdTaxonName
    proc[Procedure procFillJsonCache setting the content in table JsonCache]
    trgUpdTaxonName --> proc
graph TD;    
    Mainform[Main form]
    ButtonShow[Button show JsonCache of current dataset]
    Mainform --> ButtonShow
    Left[Show Data]
    ButtonShow --> |Left click| Left
graph TD;    
    Mainform[Main form]
    Admin[Administration menu]
    Mainform --> Admin
    Cache[JsonCache...]
    Admin --> Cache
    Adminform[Administration form]
    Cache --> Adminform
    AdminUpdateSingle[Update single dataset]
    Adminform --> AdminUpdateSingle
    AdminUpdateDB[Update for whole database] 
    Adminform --> AdminUpdateDB

Example

The JsonCache of the current dataset will be shown as in the example below:

[
    {
        "Type": "Taxon",
        "ID": 4403792,
        "Attributes": {
            "FullName": "Arachnida Cuvier, 1812",
            "Rank": "cl.",
            "GenusOrSupragenericName": "Arachnida",
            "Authors": "Cuvier",
            "Publication": ". 1812",
            "Project": [
                {
                    "Project": "SNSBnames"
                }
            ],
            "Checklist": {
                "Analysis": [
                    {
                        "Checklist": "TaxRef_SNSB_NHC-Pests",
                        "Analysis": "IPM | Group",
                        "Value": "70"
                    },
                    {
                        "Checklist": "TaxRef_SNSB_NHC-Beneficials",
                        "Analysis": "IPM | Group",
                        "Value": "70"
                    },
                    {
                        "Checklist": "TaxRef_SNSB_NHC-Bycatchs",
                        "Analysis": "IPM | Group",
                        "Value": "70"
                    }
                ]
            },
            "Synonymy": [
                {
                    "ID": 4403792,
                    "FullName": "Arachnida Cuvier, 1812",
                    "Name": "Arachnida",
                    "Type": "accepted name"
                }
            ],
            "HierarchyListCache": [
                {
                    "HierarchyListCache": "Animalia | Arthropoda | Arachnida"
                }
            ],
            "Hierarchy": [
                {
                    "ID": 4403792,
                    "FullName": "Arachnida Cuvier, 1812",
                    "Name": "Arachnida",
                    "Rank": "cl."
                },
                {
                    "ID": 4403934,
                    "FullName": "Arthropoda Gravenhorst, 1843",
                    "Name": "Arthropoda",
                    "Rank": "phyl./div."
                },
                {
                    "ID": 4403805,
                    "FullName": "Animalia Linnaeus, 1758",
                    "Name": "Animalia",
                    "Rank": "reg."
                }
            ],
            "CommonNames": [
                {
                    "CommonName": "spider",
                    "LanguageCode": "en",
                    "CountryCode": "GB",
                    "Context": "IPM"
                },
                {
                    "CommonName": "Spinnentier",
                    "LanguageCode": "de",
                    "CountryCode": "DE",
                    "Context": "IPM"
                }
            ],
            "Resource": [
                {
                    "URI": "https://museumsschaedlinge.de/gaeste/",
                    "Title": "diverse animals that migrate or are introduced into buildings seasonally, generally don't casue any damage to objects",
                    "Type": "information"
                }
            ]
        }
    }
]
Aug 6, 2024

Diversity Taxon Names

Workbench

The Diversity Workbench is composed of components for building and managing biodiversity information, each of which focuses on a particular domain. Each component can provide services to the other components. DiversityTaxonNames can link data to the modules DiversityProjects, DiversityGazetteer, DiversityAgents, DiversityCollection and DiversityReferences as illustrated in the image below. DiversityTaxonNames itself is a source for other modules like DiversityCollection and DiversityDescriptions.

 

The modules communicate with each other to provide their services for the other modules.

Jul 19, 2024

Subsections of Workbench

Diversity Taxon Names

Modules

The Diversity Workbench is a set of components for building and managing biodiversity information, each of which focuses on a particular domain. To see the open connections to other modules, choose Connection - Module connections …. from the menu. Each component can provide services to the other components. The optional links to other modules within the Diversity Workbench are shown in the image below.

  • Links to DiversityGazetteer
  • Links to DiversityReferences
  • Links to DiversityProjects
  • Links to DiversityCollection

 

Apr 9, 2025

Diversity Taxon Names

Descriptions

If you are connected to a DiversityDescriptions database (see menu Connection - Module connections … ), and you select the option Scan module DiversityDescriptions the program will search in all available databases for descriptions linked to the current name. If you select an entry from the list the basic data as provided by the module DiversityDescriptions are shown. To see the details of the data you have to set the link to the software DiversityDescriptions.exe with a click on the  botton (see below).

After this link is set, you can click on the  botton to open the software with the details of the selected dataset (see below). For an introduction see a short tutorial.

Apr 9, 2025

Diversity Taxon Names

Specimen

If you are connected to a DiversityCollection database (see menu Connection → Module connections … ), and you select the option Scan module DiversityCollection the program will search in all available databases for specimen linked to the current name. With the option Restrict to type specimen you can restrict this search to type specimen. If you select an entry from the list the basic data as provided by the module DiversityCollection are shown. To see the details of the data you have to set the link to the software DiversityCollection.exe with a click on the  botton (see below).

All DiversityCollection databases listed in the connections will be scanned for links to the selected name (see above). To see the details select the entry in the tree (see below).

A click on the button will open the client of DiversityCollection with the respective dataset (see below. In case the installation path of DiversityCollection is not detected by default, you will be asked to enter it. If the option Restrict to type specimen is selected, only type specimen will be listed. For an introduction see  a short tutorial.

To forward changes in DiversityTaxonNames to databases containing data linked to data in e.g. DiversityCollection you must include the corresponding databases as described here. After changes in the data the
button will be marked with a pink background       indicating the option to update the linked data. Click on the
button to perform the update as described here Video starten.

Apr 9, 2025

Diversity Taxon Names

Settings

The settings for the software are stored in a directory created by the application, e.g. C:\Users\[LoginName]\AppData\Local\DiversityWorkbench\[DiversityWorkbenchModule].exe_Url_0he1anjeninqrrxpdywiwnwxaqvlezn3\4.4.13.0 where [LoginName] is the name of the user and [DiversityWorkbenchModule] the name of the Diversity Workbench module e.g. DiversityCollection. This directory contains the file user.config where all settings are stored in xml format. An example for the content in the module DiversityCollection is shown below:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
    <configSections>
        <sectionGroup name="userSettings">
            <section name="DiversityWorkbench.WorkbenchSettings" type="System.Configuration.ClientSettingsSection, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false" />
        </sectionGroup>
    </configSections>
    <userSettings>
        <DiversityWorkbench.WorkbenchSettings>
            <setting name="ModuleName" serializeAs="String">
                <value>DiversityCollection</value>
            </setting>
            <setting name="GenerateTraceFile" serializeAs="String">
                <value>False</value>
            </setting>
            <setting name="DatabaseServer" serializeAs="String">
                <value>zsm.diversityworkbench.de</value>
            </setting>
            <setting name="IsTrustedConnection" serializeAs="String">
                <value>True</value>
            </setting>
            <setting name="DatabaseName" serializeAs="String">
                <value>DiversityCollection</value>
            </setting>
            <setting name="QueryMaxResults" serializeAs="String">
                <value>100</value>
            </setting>
            <setting name="DatabasePort" serializeAs="String">
                <value>5432</value>
            </setting>
            <setting name="DatabaseUser" serializeAs="String">
                <value>User</value>
            </setting>
            <setting name="ResourcesDirectory" serializeAs="String">
                <value>Home</value>
            </setting>
            <setting name="HowToCopyAppToUserDirectory" serializeAs="String">
                <value>Missing</value>
            </setting>
        </DiversityWorkbench.WorkbenchSettings>
        <DiversityCollection.Forms.FormCollectionSpecimenSettings>
            <setting name="SplitContainerData_SplitterDistance" serializeAs="String">
                <value>270</value>
            </setting>
            <setting name="QueryConditionVisibility" serializeAs="String">
                <value>10000100011000010000000000001000000001100000000000000000000000000001110000110110000000000000000000000000000000000000000000000000000000000000000000000000011100001000000000000000010000000000000000001000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000</value>
            </setting>
            <setting name="ImageDisplay" serializeAs="String">
                <value>Hidden</value>
            </setting>
            <setting name="AskOnExit" serializeAs="String">
                <value>True</value>
            </setting>
        </DiversityCollection.Forms.FormCollectionSpecimenSettings>
    </userSettings>
</configuration>