Expertise Table

Every camera trap image that has been taken is documented in this table.

• Expertise Table
• Table Set Up
• Functions
  • add
  • delete
  • update
  • get
  • getAll
  • getRange

Table Set Up

Column Name	Content	Type	Unique	Nullable	Custom Constraints	Linked Table
ID	ID for Entry	Integer	True	False
Label	name label of expertise category	String(50)	True	False
Level Rank	tagging quality rating	Integer	False	False	1-5

Functions

Test code for each function of the Images table is shown in Functions_Images.ipynb

In order to use the class functions, an instance of the class needs to be created

import T_Tables as tableClasses

#create class instance
Expertise = tableClasses.T_Expertise()

add

This function adds an expertise label to the database.

Expertise.add(cls, label: str, level: int)

Parameters

• label: unique name of the expertise level
• level: ranking for quality of tags

Returns

The function returns nothing.

delete

This function deletes an expertise level from the database. Note, that an expertise cannot be deleted if it has been assigned to a tagger, without the tagger being removed first.

Expertise.delete(label: str)

Parameters

• label: name of the expertise label you wish to delete

Returns

The function returns nothing.

update

This function allows you to update information of a given column for one entry

Expertise.update(label, colName: str, value)

Parameters

• label: name of the expertise label you wish to update
• colName: name of the column where you wish to update the value
• value: new value of given column. Make sure that the value matched the data type of the column

Returns

The function returns nothing.

get

getAll

getRange