Project

General

Profile

« Previous | Next » 

Revision 5241

schemas/vegbien.sql: taxonconcept: Renamed definer_id to creator_id to allow merging with datasource_id when datasource_id is renamed to creator_id

View differences:

inputs/XAL/Specimen/VegBIEN.csv
40 40
darwin:ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party:[datasource_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
41 41
darwin:ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,
42 42
darwin:Class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/class,
43
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
44
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
45
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
43
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
44
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
45
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
46 46
darwin:Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
47 47
darwin:Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
48 48
darwin:Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/kingdom,
inputs/NY/Specimen/VegBIEN.csv
45 45
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party:[datasource_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
46 46
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,
47 47
Class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/class,
48
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
49
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
50
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
48
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
49
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
50
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
51 51
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
52 52
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
53 53
Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/kingdom,
inputs/NY/Specimen/test.xml.ref
145 145
                                    </canon_taxonconcept_id>
146 146
                                    <author>$ScientificNameAuthor</author>
147 147
                                    <class>$Class</class>
148
                                    <definer_id>
148
                                    <creator_id>
149 149
                                        <_simplifyPath>
150 150
                                            <next>datasource_id</next>
151 151
                                            <path>
......
156 156
                                                </party>
157 157
                                            </path>
158 158
                                        </_simplifyPath>
159
                                    </definer_id>
159
                                    </creator_id>
160 160
                                    <family>$Family</family>
161 161
                                    <genus>$Genus</genus>
162 162
                                    <kingdom>$Kingdom</kingdom>
inputs/Madidi/Organism/VegBIEN.csv
43 43
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party:[datasource_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
44 44
Autor (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party:[datasource_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
45 45
Autor (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,
46
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
47
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
48
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
46
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
47
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
48
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
49 49
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
50 50
Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
51 51
Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
inputs/Madidi/Organism/test.xml.ref
103 103
                                        </taxonconcept>
104 104
                                    </canon_taxonconcept_id>
105 105
                                    <author>$Autor (revised)</author>
106
                                    <definer_id>
106
                                    <creator_id>
107 107
                                        <_simplifyPath>
108 108
                                            <next>datasource_id</next>
109 109
                                            <path>
......
114 114
                                                </party>
115 115
                                            </path>
116 116
                                        </_simplifyPath>
117
                                    </definer_id>
117
                                    </creator_id>
118 118
                                    <family>$Family (revised)</family>
119 119
                                    <genus>$Genera</genus>
120 120
                                    <species>$Specific epithet</species>
inputs/ACAD/Specimen/VegBIEN.csv
43 43
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party:[datasource_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
44 44
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,
45 45
class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/class,
46
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
47
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
48
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
46
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
47
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
48
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
49 49
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
50 50
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
51 51
kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/kingdom,
inputs/ACAD/Specimen/test.xml.ref
115 115
                                    </canon_taxonconcept_id>
116 116
                                    <author>$scientificNameAuthorship</author>
117 117
                                    <class>$class</class>
118
                                    <definer_id>
118
                                    <creator_id>
119 119
                                        <_simplifyPath>
120 120
                                            <next>datasource_id</next>
121 121
                                            <path>
......
126 126
                                                </party>
127 127
                                            </path>
128 128
                                        </_simplifyPath>
129
                                    </definer_id>
129
                                    </creator_id>
130 130
                                    <family>$family</family>
131 131
                                    <genus>$genus</genus>
132 132
                                    <kingdom>$kingdom</kingdom>
inputs/U/Specimen/VegBIEN.csv
20 20
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/then/taxon_id/_forEach:[in:[cultivar,forma,variety,infraspecies,subspecies,species,genus,],do=""taxon[rank=_val]/parent_id""]/taxon[rank=family]/taxonname",
21 21
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party:[datasource_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
22 22
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party:[datasource_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
23
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
24
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
25
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
23
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
24
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
25
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
26 26
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
27 27
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
28 28
Detyy,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
inputs/U/Specimen/test.xml.ref
90 90
                                            </identifyingtaxonomicname>
91 91
                                        </taxonconcept>
92 92
                                    </canon_taxonconcept_id>
93
                                    <definer_id>
93
                                    <creator_id>
94 94
                                        <_simplifyPath>
95 95
                                            <next>datasource_id</next>
96 96
                                            <path>
......
101 101
                                                </party>
102 102
                                            </path>
103 103
                                        </_simplifyPath>
104
                                    </definer_id>
104
                                    </creator_id>
105 105
                                    <family>$Family</family>
106 106
                                    <genus>$Genus</genus>
107 107
                                </taxonconcept>
inputs/ARIZ/Specimen/VegBIEN.csv
47 47
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party:[datasource_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
48 48
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party:[datasource_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
49 49
Class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/class,
50
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
51
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
52
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
50
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
51
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
52
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
53 53
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
54 54
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
55 55
Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/kingdom,
inputs/ARIZ/Specimen/test.xml.ref
144 144
                                        </taxonconcept>
145 145
                                    </canon_taxonconcept_id>
146 146
                                    <class>$Class</class>
147
                                    <definer_id>
147
                                    <creator_id>
148 148
                                        <_simplifyPath>
149 149
                                            <next>datasource_id</next>
150 150
                                            <path>
......
155 155
                                                </party>
156 156
                                            </path>
157 157
                                        </_simplifyPath>
158
                                    </definer_id>
158
                                    </creator_id>
159 159
                                    <family>$Family</family>
160 160
                                    <genus>$Genus</genus>
161 161
                                    <kingdom>$Kingdom</kingdom>
inputs/GBIF/Specimen/VegBIEN.csv
30 30
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party:[datasource_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
31 31
AuthorOfScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party:[datasource_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
32 32
AuthorOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,
33
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
34
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
35
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
33
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
34
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
35
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
36 36
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
37 37
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
38 38
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species,
inputs/GBIF/Specimen/test.xml.ref
84 84
                                        </taxonconcept>
85 85
                                    </canon_taxonconcept_id>
86 86
                                    <author>$AuthorOfScientificName</author>
87
                                    <definer_id>
87
                                    <creator_id>
88 88
                                        <_simplifyPath>
89 89
                                            <next>datasource_id</next>
90 90
                                            <path>
......
95 95
                                                </party>
96 96
                                            </path>
97 97
                                        </_simplifyPath>
98
                                    </definer_id>
98
                                    </creator_id>
99 99
                                    <family>$Family</family>
100 100
                                    <genus>$Genus</genus>
101 101
                                    <species>$SpecificEpithet</species>
inputs/SpeciesLink/Specimen/VegBIEN.csv
157 157
conceptual_darwin_2003_1_0_Class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/class,
158 158
dwc_dwcore_Class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/class,
159 159
dwc_terms_class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/class,
160
conceptual_darwin_2003_1_0_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
161
dwc_curatorial_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
162
dwc_terms_identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
163
conceptual_darwin_2003_1_0_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
164
dwc_curatorial_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
165
dwc_terms_identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
166
conceptual_darwin_2003_1_0_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
167
dwc_curatorial_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
168
dwc_terms_identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
160
conceptual_darwin_2003_1_0_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
161
dwc_curatorial_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
162
dwc_terms_identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
163
conceptual_darwin_2003_1_0_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
164
dwc_curatorial_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
165
dwc_terms_identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
166
conceptual_darwin_2003_1_0_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
167
dwc_curatorial_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
168
dwc_terms_identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
169 169
conceptual_darwin_2003_1_0_Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
170 170
dwc_dwcore_Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
171 171
dwc_terms_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
inputs/SpeciesLink/Specimen/test.xml.ref
332 332
                                            <2>$dwc_terms_class</2>
333 333
                                        </_alt>
334 334
                                    </class>
335
                                    <definer_id>
335
                                    <creator_id>
336 336
                                        <_simplifyPath>
337 337
                                            <next>datasource_id</next>
338 338
                                            <path>
......
373 373
                                                </party>
374 374
                                            </path>
375 375
                                        </_simplifyPath>
376
                                    </definer_id>
376
                                    </creator_id>
377 377
                                    <family>
378 378
                                        <_alt>
379 379
                                            <0>$conceptual_darwin_2003_1_0_Family</0>
inputs/MO/Specimen/VegBIEN.csv
35 35
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party:[datasource_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
36 36
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party:[datasource_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
37 37
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,
38
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
39
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
40
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
38
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
39
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
40
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
41 41
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
42 42
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
43 43
Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/kingdom,
inputs/MO/Specimen/test.xml.ref
116 116
                                        </taxonconcept>
117 117
                                    </canon_taxonconcept_id>
118 118
                                    <author>$ScientificNameAuthor</author>
119
                                    <definer_id>
119
                                    <creator_id>
120 120
                                        <_simplifyPath>
121 121
                                            <next>datasource_id</next>
122 122
                                            <path>
......
127 127
                                                </party>
128 128
                                            </path>
129 129
                                        </_simplifyPath>
130
                                    </definer_id>
130
                                    </creator_id>
131 131
                                    <family>$family</family>
132 132
                                    <genus>$genus</genus>
133 133
                                    <kingdom>$Kingdom</kingdom>
inputs/QMOR/Specimen/VegBIEN.csv
50 50
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[datasource_id/party:[datasource_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
51 51
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,
52 52
class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/class,
53
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
54
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
55
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
53
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
54
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
55
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
56 56
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
57 57
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
58 58
kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/kingdom,
inputs/QMOR/Specimen/test.xml.ref
139 139
                                    </canon_taxonconcept_id>
140 140
                                    <author>$scientificNameAuthorship</author>
141 141
                                    <class>$class</class>
142
                                    <definer_id>
142
                                    <creator_id>
143 143
                                        <_simplifyPath>
144 144
                                            <next>datasource_id</next>
145 145
                                            <path>
......
150 150
                                                </party>
151 151
                                            </path>
152 152
                                        </_simplifyPath>
153
                                    </definer_id>
153
                                    </creator_id>
154 154
                                    <family>$family</family>
155 155
                                    <genus>$genus</genus>
156 156
                                    <kingdom>$kingdom</kingdom>
schemas/vegbien.my.sql
781 781
CREATE TABLE taxonconcept (
782 782
    taxonconcept_id int(11) NOT NULL,
783 783
    datasource_id int(11) NOT NULL,
784
    definer_id int(11),
784
    creator_id int(11),
785 785
    identifyingtaxonomicname text,
786 786
    canon_taxonconcept_id int(11),
787 787
    taxon_id int(11),
......
814 814

  
815 815

  
816 816
--
817
-- Name: COLUMN taxonconcept.definer_id; Type: COMMENT; Schema: public; Owner: -
817
-- Name: COLUMN taxonconcept.creator_id; Type: COMMENT; Schema: public; Owner: -
818 818
--
819 819

  
820 820

  
......
5058 5058

  
5059 5059

  
5060 5060
--
5061
-- Name: taxonconcept_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5061
-- Name: taxonconcept_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5062 5062
--
5063 5063

  
5064 5064

  
5065 5065

  
5066 5066

  
5067 5067
--
5068
-- Name: taxonconcept_definer_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5068
-- Name: taxonconcept_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5069 5069
--
5070 5070

  
5071 5071

  
schemas/vegbien.sql
1114 1114
CREATE TABLE taxonconcept (
1115 1115
    taxonconcept_id integer NOT NULL,
1116 1116
    datasource_id integer NOT NULL,
1117
    definer_id integer,
1117
    creator_id integer,
1118 1118
    identifyingtaxonomicname text,
1119 1119
    canon_taxonconcept_id integer,
1120 1120
    taxon_id integer,
......
1152 1152

  
1153 1153

  
1154 1154
--
1155
-- Name: COLUMN taxonconcept.definer_id; Type: COMMENT; Schema: public; Owner: -
1155
-- Name: COLUMN taxonconcept.creator_id; Type: COMMENT; Schema: public; Owner: -
1156 1156
--
1157 1157

  
1158
COMMENT ON COLUMN taxonconcept.definer_id IS 'The entity that defined the taxon concept.';
1158
COMMENT ON COLUMN taxonconcept.creator_id IS 'The entity that created the taxon concept.';
1159 1159

  
1160 1160

  
1161 1161
--
......
4738 4738
-- Name: taxonconcept_unique_within_datasource_by_name; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4739 4739
--
4740 4740

  
4741
CREATE UNIQUE INDEX taxonconcept_unique_within_datasource_by_name ON taxonconcept USING btree (datasource_id, (COALESCE(definer_id, 2147483647)), (COALESCE(taxonomicname, '\\N'::text)), (COALESCE(author, '\\N'::text)), (COALESCE(taxonomicnamewithauthor, '\\N'::text)), (COALESCE(domain, '\\N'::text)), (COALESCE(kingdom, '\\N'::text)), (COALESCE(phylum, '\\N'::text)), (COALESCE(class, '\\N'::text)), (COALESCE("order", '\\N'::text)), (COALESCE(family, '\\N'::text)), (COALESCE(genus, '\\N'::text)), (COALESCE(species, '\\N'::text)), (COALESCE(subspecies, '\\N'::text)), (COALESCE(variety, '\\N'::text)), (COALESCE(forma, '\\N'::text)), (COALESCE(cultivar, '\\N'::text)), (COALESCE(morphospecies, '\\N'::text)), (COALESCE(otherranks, ARRAY[]::rankedtaxonname[]))) WHERE (identifyingtaxonomicname IS NULL);
4741
CREATE UNIQUE INDEX taxonconcept_unique_within_datasource_by_name ON taxonconcept USING btree (datasource_id, (COALESCE(creator_id, 2147483647)), (COALESCE(taxonomicname, '\\N'::text)), (COALESCE(author, '\\N'::text)), (COALESCE(taxonomicnamewithauthor, '\\N'::text)), (COALESCE(domain, '\\N'::text)), (COALESCE(kingdom, '\\N'::text)), (COALESCE(phylum, '\\N'::text)), (COALESCE(class, '\\N'::text)), (COALESCE("order", '\\N'::text)), (COALESCE(family, '\\N'::text)), (COALESCE(genus, '\\N'::text)), (COALESCE(species, '\\N'::text)), (COALESCE(subspecies, '\\N'::text)), (COALESCE(variety, '\\N'::text)), (COALESCE(forma, '\\N'::text)), (COALESCE(cultivar, '\\N'::text)), (COALESCE(morphospecies, '\\N'::text)), (COALESCE(otherranks, ARRAY[]::rankedtaxonname[]))) WHERE (identifyingtaxonomicname IS NULL);
4742 4742

  
4743 4743

  
4744 4744
--
......
5745 5745

  
5746 5746

  
5747 5747
--
5748
-- Name: taxonconcept_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5748
-- Name: taxonconcept_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5749 5749
--
5750 5750

  
5751 5751
ALTER TABLE ONLY taxonconcept
5752
    ADD CONSTRAINT taxonconcept_datasource_id_fkey FOREIGN KEY (datasource_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5752
    ADD CONSTRAINT taxonconcept_creator_id_fkey FOREIGN KEY (creator_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5753 5753

  
5754 5754

  
5755 5755
--
5756
-- Name: taxonconcept_definer_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5756
-- Name: taxonconcept_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5757 5757
--
5758 5758

  
5759 5759
ALTER TABLE ONLY taxonconcept
5760
    ADD CONSTRAINT taxonconcept_definer_id_fkey FOREIGN KEY (definer_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5760
    ADD CONSTRAINT taxonconcept_datasource_id_fkey FOREIGN KEY (datasource_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5761 5761

  
5762 5762

  
5763 5763
--
mappings/VegCore-VegBIEN.csv
192 192
acceptedVariety,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_set_canon_taxonconcept/canon_taxonconcept_id/taxonconcept/variety,
193 193
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,
194 194
class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/class,
195
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
196
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
197
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
195 198
cultivar,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/cultivar,
196
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/givenname/_namePart/first,
197
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/middlename/_namePart/middle,
198
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/definer_id/_simplifyPath:[next=datasource_id]/path/party/surname/_namePart/last,
199 199
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,
200 200
forma,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/forma,
201 201
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus,
mappings/for_review/VegCore-VegBIEN.csv
192 192
acceptedVariety,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/taxonconcept/variety,
193 193
scientificNameAuthorship,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/author,
194 194
class,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/class,
195
identifiedBy,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/creator_id/party/givenname,
196
identifiedBy,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/creator_id/party/middlename,
197
identifiedBy,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/creator_id/party/surname,
195 198
cultivar,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/cultivar,
196
identifiedBy,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/definer_id/party/givenname,
197
identifiedBy,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/definer_id/party/middlename,
198
identifiedBy,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/definer_id/party/surname,
199 199
family,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/family,
200 200
forma,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/forma,
201 201
genus,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/genus,

Also available in: Unified diff