Botanischer Garten und Botanisches Museum, Berlin-Dahlem Botanischer Garten und Botanisches Museum, Berlin-Dahlem

Berlin Taxonomic Information Model

The Berlin Taxonomic Information Model

Core view

Tables containing infomation categories or catalogue data

FactCategory
A list of factual data types
FactCategoryId FactCategory

NameFact
A list of name fact data types
NameFactCategoryId NameFactCategory

NomStatus
List of nomenclatural status value categories
NomStatusId NomStatus
1 nom. inval.
2 nom. illeg.
3 nom. nud.
4 nom. rej.
5 nom. rej. prop.
6 nom. utique rej.
7 nom. utique rej. prop.
8 nom. cons.
9 nom. cons. prop.
10 orth. cons.
11 orth. cons. prop.

Rank
Rank linked to every name within the Name and NameHistory tables. Aggregate and species group have been included although they arent taxonomic  ranks but  cirumscriptions because on the one hand they are necessary for the concatenation of the fullname and on the other hand they are necessary for distinguishing the aggregate or species group from the microspecies
RankId Rank
1 reg.
3 subreg.
5 phyl.
7 subphyl.
8 div.
9 subdiv.
10 cl.
13 subcl.
16 superor.
18 ordo
19 subor.
20 fam.
25 subfam.
30 trib.
35 subtrib.
40 gen.
42 subgen.
45 sect.
47 subsect.
50 ser.
52 subser.
58 aggr.
59 group
60 sp.
65 subsp.
68 convar.
70 var.
73 subvar.
80 f.
82 subf.
84 f.spec.
98 t.infgen.
99 t.infr.

RefCategory
List of reference categories
RefCategoryId RefCategory
1 article in periodical
2 part of other title
3 book
4 database
5 informal reference
6 not applicable
7 website
8 published CD
9 journal
10 unresolved

RelAuthorQualifier
List of relation categories qualifying relations between authors within the RelAuthor table
RelAuthorQualifierId RelAuthorQualifier
1 equals
2 orthographic variant of
3 old standard for

RelName
List of relation categories qualifying relations between names within the RelName table
RelNameQualifierID RelNameQualifier

RelPTQualifier
List of relation categories as used in the RelPTaxon table
RelPTQualifierId RelPTQualifier
-99 inactivated --> is taxonomically included in
1 is taxonomically included in
2 is synonym of
3 is misapplied name for
4 is pro parte synonym of
5 is partial synonym of
6 is heterotypic synonym of
7 is homotypic synonym of
10 is contradiction
11 is congruent to
12 is included in
13 is congruent to,is included in
14 includes
15 is congruent to,includes
16 is included in,includes
17 is congruent to,is included in,includes
18 overlaps
19 is congruent to,overlaps
20 is included in,overlaps
21 is congruent to,is included in,overlaps
22 includes,overlaps
23 is congruent to,includes,overlaps
24 is included in,includes,overlaps
25 have common elements
26 excludes
27 is congruent to,excludes
28 is included in,excludes
29 is congruent to,is included in,excludes
30 includes,excludes
31 is congruent to,includes,excludes
32 is included in,includes,excludes
33 does not overlap
34 overlaps,excludes
35 is congruent to,overlaps,excludes
36 is included in,overlaps,excludes
37 does not include
38 includes,overlaps,excludes
39 is not included in
40 is not congruent to
41 all relationships
42 doubtful
43 ? congruent to
44 ? included in
45 is congruent to,is included in,doubtful
46 ? includes
47 is congruent to,includes,doubtful
48 is included in,includes,doubtful
49 is congruent to,is included in,includes,doubtful
50 ? overlaps
51 is congruent to,overlaps,doubtful
52 is included in,overlaps,doubtful
53 is congruent to,is included in,overlaps,doubtful
54 includes,overlaps,doubtful
55 is congruent to,includes,overlaps,doubtful
56 is included in,includes,overlaps,doubtful
57 ? have common elements
58 ? excludes
59 is congruent to,excludes,doubtful
60 is included in,excludes,doubtful
61 is congruent to,is included in,excludes,doubtful
62 includes,excludes,doubtful
63 is congruent to,includes,excludes,doubtful
64 is included in,includes,excludes,doubtful
65 ? does not overlap
66 overlaps,excludes,doubtful
67 is congruent to,overlaps,excludes,doubtful
68 is included in,overlaps,excludes,doubtful
69 ? does not include
70 includes,overlaps,excludes,doubtful
71 ? is not included in
72 ? is not congruent to
73 all relationships,doubtful

RelReferenceQualifier
List of categories qualifying relationship given in the RelReference table
RelReferenceQualifierId RelReferenceQualifier
1 equals
2 orthographical variant of

Status
List of potential taxon status values used for the PTaxon.StatusFk attribute (neither a nomenclatural status nor a type status)
StatusID Status
1 accepted
2 synonym
3 partial synonym
4 pro parte synonym
5 unresolved

Print Page