Attributes

Attributes are descriptive, categorical, or quantitative characteristics of cataloged items such as measurements, weight, age, and sex. Like other determinations in Arctos, Attributes have a determiner, a determination date, and a determination method. Because they are treated as determinations, a record may have any number of similar and even contradictory Attributes.

Attributes, many of which use controlled vocabularies with many values and many individual definitions, are largely documented within tables within Arctos, as opposed to being documented here.

Attribute Type

attribute_type is the name of an Attribute. These must be unambiguous and well-defined.

These values are controlled by a complex code table, ctattribute_type table, defined below.

Attribute Value

Attributes . Attribute_Value VARCHAR2(4000) not null

Attributes have attribute_value, and those values are of three types:

Some examples:

Attribute Name Value Units
Total Length “123.4” millimeters
Age Class “adult” (controlled text) null
Colors “reddish feet” (uncontrolled text) null

The appropriate units for particular numeric Attributes, and the appropriate vocabulary for controlled vocabulary are set by ctattribute_type table.

Attribute Units

Numeric Attributes have values expressed in units, given in attribute_units.

Method

determination_method is how the Attribute was determined.

Remark

attribute_remark is a place for comments about the Attribute. For example:

Determiner

determined_by_agent_id is the agent that determined the Value of the Attribute. Many Attributes are determined by either the collector or preparator of the specimen, but often Attributes are determined at a later time by an investigator using the specimen.

Determined Date

determined_date is the ISO8601 date that the determination was made.

Attribute Type Control

Code table ctattribute_type table controlls the structure and usage of Attributes.

attribute_type

attribute_type is a unique value which controls and provides attribute type.

description

Description defines attribute type. This must be an exhaustive, functional definition capable of disambiguating the type from all other types.

collections

Collections may choose to use an attribute type; such selection is recorded (as an array item) here.

recommend_for_collection_type

This nonfuntional column facilitates easy collection setup (sort by this, shift-select recommended items).

search_terms

Provides a way to locate synonyms, inclusions, similarities, etc.

issue_url

List of relevant Issues. Will be NULL for legacy terms, should contain one item for most terms, and may contain multiple values for terms which have been refined after creation.

documentation_url

Any URI which might support or clarify the term.

value_code_table

Controls acceptable values by referencing a code table. A value here results in a categorical attribute. Categorical attributes may not have units.

unit_code_table

Controls acceptable units by referencing a code table. A value here results in a numerical attribute. Numerical attributes must have a value which may be cast to numeric.

Usage Notes

Usage notes.

Conversion of fractional values

Numeric values are sometimes reported in the numerator/denominator format. For example, total length = 7 3/16 inches. Such values must be converted to decimal fractions in order to be represented as a numeric data type. In making such conversions, avoid adding unwarranted precision to the value of an observation. For example, simply converting 7 3/16 to 7.1875, a value indicating observation to within a few ten-thousandths of an inch implies an improbable degree of precision. Because the measurement was probably made with a ruler (and not a micrometer) graduated, at best, in 32ths of an inch, the last digits of the value are a spurious artifact of the calculation and should be rounded off to reflect actual precision. Both the 16ths and 32ths on our assumed ruler are smaller (more precise) than tenths, but larger (less precise) than 100ths, so there can be no precision beyond the 100ths place. Therefore we should round off to 7.19 inches. Whenever the value of an attribute is converted (or in any way modified or assumed), the verbatim value should be given in the Attribute Remark.

How To

Instructions for doing specifc tasks related to Attributes in Arctos

Edit this Documentation

If you see something that needs to be edited in this document, you can create an issue using the link under the search widget at the top left side of this page, or you can edit directly here.