Project

General

Profile

« Previous | Next » 

Revision 1111

Added by Aaron Marcuse-Kubitza almost 13 years ago

VegBIEN: Moved plantstatus.plantlevel to plantname.rank because the taxonomic rank is a property of the name itself

View differences:

inputs/NYBG/test/import.specimens.out.ref
1 
Inserted 78 new rows into database
1 
Inserted 69 new rows into database
inputs/NYBG/test/VegBIEN.specimens.xml.ref
48 48 
                </locationevent_id>
49 49 
                <taxondetermination>
50 50 
                    <role_id><role><rolecode>identifier</rolecode></role></role_id>
51 
                    <plantconcept_id>
52 
                        <plantconcept>
53 
                            <plantname_id>
54 
                                <plantname>
55 
                                    <rank>Authority</rank>
56 
                                    <plantname>(Raddi) Kuntze</plantname>
57 
                                </plantname>
58 
                            </plantname_id>
59 
                        </plantconcept>
60 
                    </plantconcept_id>
51 61 
                    <determinationtype>Author</determinationtype>
52 62 
                    <isoriginal>true</isoriginal>
53 63 
                    <iscurrent>true</iscurrent>
54 
                    <plantconcept_id><plantconcept><plantname_id><plantname><plantname>Cariniana estrellensis (Raddi) Kuntze</plantname></plantname></plantname_id></plantconcept></plantconcept_id>
55 64 
                </taxondetermination>
56 65 
                <taxondetermination>
57 66 
                    <role_id><role><rolecode>identifier</rolecode></role></role_id>
58 67 
                    <plantconcept_id>
59 68 
                        <plantconcept>
60 
                            <plantstatus><plantlevel>Authority</plantlevel></plantstatus>
61 
                            <plantname_id><plantname><plantname>(Raddi) Kuntze</plantname></plantname></plantname_id>
69 
                            <plantname_id>
70 
                                <plantname>
71 
                                    <rank>Binomial</rank>
72 
                                    <plantname>Cariniana estrellensis (Raddi) Kuntze</plantname>
73 
                                </plantname>
74 
                            </plantname_id>
62 75 
                        </plantconcept>
63 76 
                    </plantconcept_id>
64 77 
                    <determinationtype>Author</determinationtype>
......
69 82 
                    <role_id><role><rolecode>identifier</rolecode></role></role_id>
70 83 
                    <plantconcept_id>
71 84 
                        <plantconcept>
72 
                            <plantstatus><plantlevel>Family</plantlevel></plantstatus>
73 
                            <plantname_id><plantname><plantname>Lecythidaceae</plantname></plantname></plantname_id>
85 
                            <plantname_id>
86 
                                <plantname>
87 
                                    <rank>Family</rank>
88 
                                    <plantname>Lecythidaceae</plantname>
89 
                                </plantname>
90 
                            </plantname_id>
74 91 
                        </plantconcept>
75 92 
                    </plantconcept_id>
76 93 
                    <determinationtype>Author</determinationtype>
......
81 98 
                    <role_id><role><rolecode>identifier</rolecode></role></role_id>
82 99 
                    <plantconcept_id>
83 100 
                        <plantconcept>
84 
                            <plantstatus><plantlevel>Genus</plantlevel></plantstatus>
85 
                            <plantname_id><plantname><plantname>Cariniana</plantname></plantname></plantname_id>
101 
                            <plantname_id>
102 
                                <plantname>
103 
                                    <rank>Genus</rank>
104 
                                    <plantname>Cariniana</plantname>
105 
                                </plantname>
106 
                            </plantname_id>
86 107 
                        </plantconcept>
87 108 
                    </plantconcept_id>
88 109 
                    <determinationtype>Author</determinationtype>
......
93 114 
                    <role_id><role><rolecode>identifier</rolecode></role></role_id>
94 115 
                    <plantconcept_id>
95 116 
                        <plantconcept>
96 
                            <plantstatus><plantlevel>Kingdom</plantlevel></plantstatus>
97 
                            <plantname_id><plantname><plantname>Plantae</plantname></plantname></plantname_id>
117 
                            <plantname_id>
118 
                                <plantname>
119 
                                    <rank>Kingdom</rank>
120 
                                    <plantname>Plantae</plantname>
121 
                                </plantname>
122 
                            </plantname_id>
98 123 
                        </plantconcept>
99 124 
                    </plantconcept_id>
100 125 
                    <determinationtype>Author</determinationtype>
......
105 130 
                    <role_id><role><rolecode>identifier</rolecode></role></role_id>
106 131 
                    <plantconcept_id>
107 132 
                        <plantconcept>
108 
                            <plantstatus><plantlevel>Species</plantlevel></plantstatus>
109 
                            <plantname_id><plantname><plantname>estrellensis</plantname></plantname></plantname_id>
133 
                            <plantname_id>
134 
                                <plantname>
135 
                                    <rank>Species</rank>
136 
                                    <plantname>estrellensis</plantname>
137 
                                </plantname>
138 
                            </plantname_id>
110 139 
                        </plantconcept>
111 140 
                    </plantconcept_id>
112 141 
                    <determinationtype>Author</determinationtype>
......
117 146 
                    <role_id><role><rolecode>identifier</rolecode></role></role_id>
118 147 
                    <plantconcept_id>
119 148 
                        <plantconcept>
120 
                            <plantstatus><plantlevel>Subkingdom</plantlevel></plantstatus>
121 
                            <plantname_id><plantname><plantname>Magnoliophyta (flowering plants)</plantname></plantname></plantname_id>
149 
                            <plantname_id>
150 
                                <plantname>
151 
                                    <rank>Subkingdom</rank>
152 
                                    <plantname>Magnoliophyta (flowering plants)</plantname>
153 
                                </plantname>
154 
                            </plantname_id>
122 155 
                        </plantconcept>
123 156 
                    </plantconcept_id>
124 157 
                    <determinationtype>Author</determinationtype>
......
174 207 
                </locationevent_id>
175 208 
                <taxondetermination>
176 209 
                    <role_id><role><rolecode>identifier</rolecode></role></role_id>
210 
                    <plantconcept_id>
211 
                        <plantconcept>
212 
                            <plantname_id>
213 
                                <plantname>
214 
                                    <rank>Binomial</rank>
215 
                                    <plantname>Scrophulariaceae</plantname>
216 
                                </plantname>
217 
                            </plantname_id>
218 
                        </plantconcept>
219 
                    </plantconcept_id>
177 220 
                    <determinationtype>Author</determinationtype>
178 221 
                    <isoriginal>true</isoriginal>
179 222 
                    <iscurrent>true</iscurrent>
180 
                    <plantconcept_id><plantconcept><plantname_id><plantname><plantname>Scrophulariaceae</plantname></plantname></plantname_id></plantconcept></plantconcept_id>
181 223 
                </taxondetermination>
182 224 
                <taxondetermination>
183 225 
                    <role_id><role><rolecode>identifier</rolecode></role></role_id>
184 226 
                    <plantconcept_id>
185 227 
                        <plantconcept>
186 
                            <plantstatus><plantlevel>Family</plantlevel></plantstatus>
187 
                            <plantname_id><plantname><plantname>Scrophulariaceae</plantname></plantname></plantname_id>
228 
                            <plantname_id>
229 
                                <plantname>
230 
                                    <rank>Family</rank>
231 
                                    <plantname>Scrophulariaceae</plantname>
232 
                                </plantname>
233 
                            </plantname_id>
188 234 
                        </plantconcept>
189 235 
                    </plantconcept_id>
190 236 
                    <determinationtype>Author</determinationtype>
......
195 241 
                    <role_id><role><rolecode>identifier</rolecode></role></role_id>
196 242 
                    <plantconcept_id>
197 243 
                        <plantconcept>
198 
                            <plantstatus><plantlevel>Kingdom</plantlevel></plantstatus>
199 
                            <plantname_id><plantname><plantname>Plantae</plantname></plantname></plantname_id>
244 
                            <plantname_id>
245 
                                <plantname>
246 
                                    <rank>Kingdom</rank>
247 
                                    <plantname>Plantae</plantname>
248 
                                </plantname>
249 
                            </plantname_id>
200 250 
                        </plantconcept>
201 251 
                    </plantconcept_id>
202 252 
                    <determinationtype>Author</determinationtype>
......
207 257 
                    <role_id><role><rolecode>identifier</rolecode></role></role_id>
208 258 
                    <plantconcept_id>
209 259 
                        <plantconcept>
210 
                            <plantstatus><plantlevel>Subkingdom</plantlevel></plantstatus>
211 
                            <plantname_id><plantname><plantname>Magnoliophyta (flowering plants)</plantname></plantname></plantname_id>
260 
                            <plantname_id>
261 
                                <plantname>
262 
                                    <rank>Subkingdom</rank>
263 
                                    <plantname>Magnoliophyta (flowering plants)</plantname>
264 
                                </plantname>
265 
                            </plantname_id>
212 266 
                        </plantconcept>
213 267 
                    </plantconcept_id>
214 268 
                    <determinationtype>Author</determinationtype>
inputs/NYBG/maps/VegBIEN.specimens.csv
18 18 
YearCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/2/_date/year,,44
19 19 
MaximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/max,,75
20 20 
MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/min,,74
21 
Sex,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]]:[@fkey=tableRecord_ID]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26
22 
IdentifiedDate,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_alt/1/_*/date",,120
23 
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_alt/2/_date/day",,120
24 
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_alt/2/_date/month",,120
25 
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_alt/2/_date/year",,120
26 
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
27 
ScientificName,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_alt/1","Brad: Bob, Nick, please is this mapping OK?",134
28 
ScientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
29 
Class,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,144
30 
Family,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,146
31 
Genus,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,147
32 
Kingdom,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,142
33 
Order,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,145
34 
Species,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
35 
Phylum,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143
36 
Subspecies,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
21 
ScientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
22 
Sex,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]]:[@fkey=tableRecord_ID]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26
23 
IdentifiedDate,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/1/_*/date",,120
24 
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/2/_date/day",,120
25 
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/2/_date/month",,120
26 
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/2/_date/year",,120
27 
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
28 
ScientificName,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Bob, Nick, please is this mapping OK?",134
29 
Class,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,144
30 
Family,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,146
31 
Genus,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,147
32 
Kingdom,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,142
33 
Order,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,145
34 
Species,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
35 
Phylum,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143
36 
Subspecies,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
37 37 
Collector,/*_id/taxonoccurrence/verbatimcollectorname,,23
38 38 
CollectionCode,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12
39 39 
Notes,/description/_merge/1,,
inputs/SALVIAS/test/VegBIEN.organisms.xml.ref
62 62 
            <role_id><role><rolecode>computer</rolecode></role></role_id>
63 63 
            <plantconcept_id>
64 64 
                <plantconcept>
65 
                    <plantstatus><plantlevel>Authority</plantlevel></plantstatus>
66 
                    <plantname_id><plantname><plantname>Burret</plantname></plantname></plantname_id>
65 
                    <plantname_id>
66 
                        <plantname>
67 
                            <rank>Authority</rank>
68 
                            <plantname>Burret</plantname>
69 
                        </plantname>
70 
                    </plantname_id>
67 71 
                </plantconcept>
68 72 
            </plantconcept_id>
69 73 
            <determinationtype>Computer (automated)</determinationtype>
......
73 77 
            <role_id><role><rolecode>computer</rolecode></role></role_id>
74 78 
            <plantconcept_id>
75 79 
                <plantconcept>
76 
                    <plantstatus><plantlevel>Family</plantlevel></plantstatus>
77 
                    <plantname_id><plantname><plantname>Arecaceae</plantname></plantname></plantname_id>
80 
                    <plantname_id>
81 
                        <plantname>
82 
                            <rank>Family</rank>
83 
                            <plantname>Arecaceae</plantname>
84 
                        </plantname>
85 
                    </plantname_id>
78 86 
                </plantconcept>
79 87 
            </plantconcept_id>
80 88 
            <determinationtype>Computer (automated)</determinationtype>
......
84 92 
            <role_id><role><rolecode>computer</rolecode></role></role_id>
85 93 
            <plantconcept_id>
86 94 
                <plantconcept>
87 
                    <plantstatus><plantlevel>Genus</plantlevel></plantstatus>
88 
                    <plantname_id><plantname><plantname>Geonoma</plantname></plantname></plantname_id>
95 
                    <plantname_id>
96 
                        <plantname>
97 
                            <rank>Genus</rank>
98 
                            <plantname>Geonoma</plantname>
99 
                        </plantname>
100 
                    </plantname_id>
89 101 
                </plantconcept>
90 102 
            </plantconcept_id>
91 103 
            <determinationtype>Computer (automated)</determinationtype>
......
95 107 
            <role_id><role><rolecode>computer</rolecode></role></role_id>
96 108 
            <plantconcept_id>
97 109 
                <plantconcept>
98 
                    <plantstatus><plantlevel>Species</plantlevel></plantstatus>
99 
                    <plantname_id><plantname><plantname>seleri</plantname></plantname></plantname_id>
110 
                    <plantname_id>
111 
                        <plantname>
112 
                            <rank>Species</rank>
113 
                            <plantname>seleri</plantname>
114 
                        </plantname>
115 
                    </plantname_id>
100 116 
                </plantconcept>
101 117 
            </plantconcept_id>
102 118 
            <determinationtype>Computer (automated)</determinationtype>
......
106 122 
            <role_id><role><rolecode>identifier</rolecode></role></role_id>
107 123 
            <plantconcept_id>
108 124 
                <plantconcept>
109 
                    <plantstatus><plantlevel>Binomial</plantlevel></plantstatus>
110 
                    <plantname_id><plantname><plantname>Geonoma seleri</plantname></plantname></plantname_id>
125 
                    <plantname_id>
126 
                        <plantname>
127 
                            <rank>Binomial</rank>
128 
                            <plantname>Geonoma seleri</plantname>
129 
                        </plantname>
130 
                    </plantname_id>
111 131 
                </plantconcept>
112 132 
            </plantconcept_id>
113 133 
            <determinationtype>Author</determinationtype>
......
118 138 
            <role_id><role><rolecode>identifier</rolecode></role></role_id>
119 139 
            <plantconcept_id>
120 140 
                <plantconcept>
121 
                    <plantstatus><plantlevel>Family</plantlevel></plantstatus>
122 
                    <plantname_id><plantname><plantname>Arecaceae</plantname></plantname></plantname_id>
141 
                    <plantname_id>
142 
                        <plantname>
143 
                            <rank>Family</rank>
144 
                            <plantname>Arecaceae</plantname>
145 
                        </plantname>
146 
                    </plantname_id>
123 147 
                </plantconcept>
124 148 
            </plantconcept_id>
125 149 
            <determinationtype>Author</determinationtype>
......
189 213 
            <role_id><role><rolecode>computer</rolecode></role></role_id>
190 214 
            <plantconcept_id>
191 215 
                <plantconcept>
192 
                    <plantstatus><plantlevel>Authority</plantlevel></plantstatus>
193 
                    <plantname_id><plantname><plantname>Maguire</plantname></plantname></plantname_id>
216 
                    <plantname_id>
217 
                        <plantname>
218 
                            <rank>Authority</rank>
219 
                            <plantname>Maguire</plantname>
220 
                        </plantname>
221 
                    </plantname_id>
194 222 
                </plantconcept>
195 223 
            </plantconcept_id>
196 224 
            <determinationtype>Computer (automated)</determinationtype>
......
200 228 
            <role_id><role><rolecode>computer</rolecode></role></role_id>
201 229 
            <plantconcept_id>
202 230 
                <plantconcept>
203 
                    <plantstatus><plantlevel>Family</plantlevel></plantstatus>
204 
                    <plantname_id><plantname><plantname>Clusiaceae</plantname></plantname></plantname_id>
231 
                    <plantname_id>
232 
                        <plantname>
233 
                            <rank>Family</rank>
234 
                            <plantname>Clusiaceae</plantname>
235 
                        </plantname>
236 
                    </plantname_id>
205 237 
                </plantconcept>
206 238 
            </plantconcept_id>
207 239 
            <determinationtype>Computer (automated)</determinationtype>
......
211 243 
            <role_id><role><rolecode>computer</rolecode></role></role_id>
212 244 
            <plantconcept_id>
213 245 
                <plantconcept>
214 
                    <plantstatus><plantlevel>Genus</plantlevel></plantstatus>
215 
                    <plantname_id><plantname><plantname>Tovomitopsis</plantname></plantname></plantname_id>
246 
                    <plantname_id>
247 
                        <plantname>
248 
                            <rank>Genus</rank>
249 
                            <plantname>Tovomitopsis</plantname>
250 
                        </plantname>
251 
                    </plantname_id>
216 252 
                </plantconcept>
217 253 
            </plantconcept_id>
218 254 
            <determinationtype>Computer (automated)</determinationtype>
......
222 258 
            <role_id><role><rolecode>computer</rolecode></role></role_id>
223 259 
            <plantconcept_id>
224 260 
                <plantconcept>
225 
                    <plantstatus><plantlevel>Species</plantlevel></plantstatus>
226 
                    <plantname_id><plantname><plantname>allenii</plantname></plantname></plantname_id>
261 
                    <plantname_id>
262 
                        <plantname>
263 
                            <rank>Species</rank>
264 
                            <plantname>allenii</plantname>
265 
                        </plantname>
266 
                    </plantname_id>
227 267 
                </plantconcept>
228 268 
            </plantconcept_id>
229 269 
            <determinationtype>Computer (automated)</determinationtype>
......
233 273 
            <role_id><role><rolecode>identifier</rolecode></role></role_id>
234 274 
            <plantconcept_id>
235 275 
                <plantconcept>
236 
                    <plantstatus><plantlevel>Binomial</plantlevel></plantstatus>
237 
                    <plantname_id><plantname><plantname>Tovomitopsis allenii</plantname></plantname></plantname_id>
276 
                    <plantname_id>
277 
                        <plantname>
278 
                            <rank>Binomial</rank>
279 
                            <plantname>Tovomitopsis allenii</plantname>
280 
                        </plantname>
281 
                    </plantname_id>
238 282 
                </plantconcept>
239 283 
            </plantconcept_id>
240 284 
            <determinationtype>Author</determinationtype>
......
245 289 
            <role_id><role><rolecode>identifier</rolecode></role></role_id>
246 290 
            <plantconcept_id>
247 291 
                <plantconcept>
248 
                    <plantstatus><plantlevel>Family</plantlevel></plantstatus>
249 
                    <plantname_id><plantname><plantname>Clusiaceae</plantname></plantname></plantname_id>
292 
                    <plantname_id>
293 
                        <plantname>
294 
                            <rank>Family</rank>
295 
                            <plantname>Clusiaceae</plantname>
296 
                        </plantname>
297 
                    </plantname_id>
250 298 
                </plantconcept>
251 299 
            </plantconcept_id>
252 300 
            <determinationtype>Author</determinationtype>
inputs/SALVIAS/test/import.organisms.out.ref
1 
Inserted 87 new rows into database
1 
Inserted 75 new rows into database
inputs/SALVIAS/maps/VegBIEN.organisms.csv
24 24 
coll_number,/specimenreplicate:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc/_alt/1,Brad: Incorrect. Map instead as for voucher_string
25 25 
SourceVoucher,/specimenreplicate:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
26 26 
census_date,/specimenreplicate:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectiondate/_*/date,
27 
auth,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
28 
Family,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
29 
Genus,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
30 
Species,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
31 
infra_rank_1,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname/_name/first",
32 
infra_ep_1,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/last",
33 
cfaff,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Binomial]/{taxonFit,*_id/plantconcept/*_id/*/plantname/_name/middle}","Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank."
34 
OrigGenus,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/first",
35 
OrigSpecies,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/last",Brad: OMIT
36 
OrigFamily,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
27 
auth,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=Authority]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
28 
Family,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=Family]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
29 
Genus,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=Genus]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
30 
Species,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=Species]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
31 
infra_rank_1,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=Subspecies]/*_id/plantconcept/*_id/*/plantname/_name/first",
32 
infra_ep_1,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=Subspecies]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/last",
33 
cfaff,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/{taxonFit,*_id/plantconcept/*_id/*/plantname/_name/middle}","Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank."
34 
OrigGenus,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/first",
35 
OrigSpecies,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/last",Brad: OMIT
36 
OrigFamily,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
37 37 
coll_firstname,/verbatimcollectorname/_name/first,Brad: See comment above
38 38 
coll_lastname,/verbatimcollectorname/_name/last,"Brad: Correct for VegBank. This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
39 39 
GenAuth,,
inputs/NYBG-CSV/test/import.specimens.out.ref
1 
Inserted 78 new rows into database
1 
Inserted 69 new rows into database
inputs/NYBG-CSV/test/VegBIEN.specimens.xml.ref
48 48 
                </locationevent_id>
49 49 
                <taxondetermination>
50 50 
                    <role_id><role><rolecode>identifier</rolecode></role></role_id>
51 
                    <plantconcept_id>
52 
                        <plantconcept>
53 
                            <plantname_id>
54 
                                <plantname>
55 
                                    <rank>Authority</rank>
56 
                                    <plantname>(Raddi) Kuntze</plantname>
57 
                                </plantname>
58 
                            </plantname_id>
59 
                        </plantconcept>
60 
                    </plantconcept_id>
51 61 
                    <determinationtype>Author</determinationtype>
52 62 
                    <isoriginal>true</isoriginal>
53 63 
                    <iscurrent>true</iscurrent>
54 
                    <plantconcept_id><plantconcept><plantname_id><plantname><plantname>Cariniana estrellensis (Raddi) Kuntze</plantname></plantname></plantname_id></plantconcept></plantconcept_id>
55 64 
                </taxondetermination>
56 65 
                <taxondetermination>
57 66 
                    <role_id><role><rolecode>identifier</rolecode></role></role_id>
58 67 
                    <plantconcept_id>
59 68 
                        <plantconcept>
60 
                            <plantstatus><plantlevel>Authority</plantlevel></plantstatus>
61 
                            <plantname_id><plantname><plantname>(Raddi) Kuntze</plantname></plantname></plantname_id>
69 
                            <plantname_id>
70 
                                <plantname>
71 
                                    <rank>Binomial</rank>
72 
                                    <plantname>Cariniana estrellensis (Raddi) Kuntze</plantname>
73 
                                </plantname>
74 
                            </plantname_id>
62 75 
                        </plantconcept>
63 76 
                    </plantconcept_id>
64 77 
                    <determinationtype>Author</determinationtype>
......
69 82 
                    <role_id><role><rolecode>identifier</rolecode></role></role_id>
70 83 
                    <plantconcept_id>
71 84 
                        <plantconcept>
72 
                            <plantstatus><plantlevel>Family</plantlevel></plantstatus>
73 
                            <plantname_id><plantname><plantname>Lecythidaceae</plantname></plantname></plantname_id>
85 
                            <plantname_id>
86 
                                <plantname>
87 
                                    <rank>Family</rank>
88 
                                    <plantname>Lecythidaceae</plantname>
89 
                                </plantname>
90 
                            </plantname_id>
74 91 
                        </plantconcept>
75 92 
                    </plantconcept_id>
76 93 
                    <determinationtype>Author</determinationtype>
......
81 98 
                    <role_id><role><rolecode>identifier</rolecode></role></role_id>
82 99 
                    <plantconcept_id>
83 100 
                        <plantconcept>
84 
                            <plantstatus><plantlevel>Genus</plantlevel></plantstatus>
85 
                            <plantname_id><plantname><plantname>Cariniana</plantname></plantname></plantname_id>
101 
                            <plantname_id>
102 
                                <plantname>
103 
                                    <rank>Genus</rank>
104 
                                    <plantname>Cariniana</plantname>
105 
                                </plantname>
106 
                            </plantname_id>
86 107 
                        </plantconcept>
87 108 
                    </plantconcept_id>
88 109 
                    <determinationtype>Author</determinationtype>
......
93 114 
                    <role_id><role><rolecode>identifier</rolecode></role></role_id>
94 115 
                    <plantconcept_id>
95 116 
                        <plantconcept>
96 
                            <plantstatus><plantlevel>Kingdom</plantlevel></plantstatus>
97 
                            <plantname_id><plantname><plantname>Plantae</plantname></plantname></plantname_id>
117 
                            <plantname_id>
118 
                                <plantname>
119 
                                    <rank>Kingdom</rank>
120 
                                    <plantname>Plantae</plantname>
121 
                                </plantname>
122 
                            </plantname_id>
98 123 
                        </plantconcept>
99 124 
                    </plantconcept_id>
100 125 
                    <determinationtype>Author</determinationtype>
......
105 130 
                    <role_id><role><rolecode>identifier</rolecode></role></role_id>
106 131 
                    <plantconcept_id>
107 132 
                        <plantconcept>
108 
                            <plantstatus><plantlevel>Species</plantlevel></plantstatus>
109 
                            <plantname_id><plantname><plantname>estrellensis</plantname></plantname></plantname_id>
133 
                            <plantname_id>
134 
                                <plantname>
135 
                                    <rank>Species</rank>
136 
                                    <plantname>estrellensis</plantname>
137 
                                </plantname>
138 
                            </plantname_id>
110 139 
                        </plantconcept>
111 140 
                    </plantconcept_id>
112 141 
                    <determinationtype>Author</determinationtype>
......
117 146 
                    <role_id><role><rolecode>identifier</rolecode></role></role_id>
118 147 
                    <plantconcept_id>
119 148 
                        <plantconcept>
120 
                            <plantstatus><plantlevel>Subkingdom</plantlevel></plantstatus>
121 
                            <plantname_id><plantname><plantname>Magnoliophyta (flowering plants)</plantname></plantname></plantname_id>
149 
                            <plantname_id>
150 
                                <plantname>
151 
                                    <rank>Subkingdom</rank>
152 
                                    <plantname>Magnoliophyta (flowering plants)</plantname>
153 
                                </plantname>
154 
                            </plantname_id>
122 155 
                        </plantconcept>
123 156 
                    </plantconcept_id>
124 157 
                    <determinationtype>Author</determinationtype>
......
174 207 
                </locationevent_id>
175 208 
                <taxondetermination>
176 209 
                    <role_id><role><rolecode>identifier</rolecode></role></role_id>
210 
                    <plantconcept_id>
211 
                        <plantconcept>
212 
                            <plantname_id>
213 
                                <plantname>
214 
                                    <rank>Binomial</rank>
215 
                                    <plantname>Scrophulariaceae</plantname>
216 
                                </plantname>
217 
                            </plantname_id>
218 
                        </plantconcept>
219 
                    </plantconcept_id>
177 220 
                    <determinationtype>Author</determinationtype>
178 221 
                    <isoriginal>true</isoriginal>
179 222 
                    <iscurrent>true</iscurrent>
180 
                    <plantconcept_id><plantconcept><plantname_id><plantname><plantname>Scrophulariaceae</plantname></plantname></plantname_id></plantconcept></plantconcept_id>
181 223 
                </taxondetermination>
182 224 
                <taxondetermination>
183 225 
                    <role_id><role><rolecode>identifier</rolecode></role></role_id>
184 226 
                    <plantconcept_id>
185 227 
                        <plantconcept>
186 
                            <plantstatus><plantlevel>Family</plantlevel></plantstatus>
187 
                            <plantname_id><plantname><plantname>Scrophulariaceae</plantname></plantname></plantname_id>
228 
                            <plantname_id>
229 
                                <plantname>
230 
                                    <rank>Family</rank>
231 
                                    <plantname>Scrophulariaceae</plantname>
232 
                                </plantname>
233 
                            </plantname_id>
188 234 
                        </plantconcept>
189 235 
                    </plantconcept_id>
190 236 
                    <determinationtype>Author</determinationtype>
......
195 241 
                    <role_id><role><rolecode>identifier</rolecode></role></role_id>
196 242 
                    <plantconcept_id>
197 243 
                        <plantconcept>
198 
                            <plantstatus><plantlevel>Kingdom</plantlevel></plantstatus>
199 
                            <plantname_id><plantname><plantname>Plantae</plantname></plantname></plantname_id>
244 
                            <plantname_id>
245 
                                <plantname>
246 
                                    <rank>Kingdom</rank>
247 
                                    <plantname>Plantae</plantname>
248 
                                </plantname>
249 
                            </plantname_id>
200 250 
                        </plantconcept>
201 251 
                    </plantconcept_id>
202 252 
                    <determinationtype>Author</determinationtype>
......
207 257 
                    <role_id><role><rolecode>identifier</rolecode></role></role_id>
208 258 
                    <plantconcept_id>
209 259 
                        <plantconcept>
210 
                            <plantstatus><plantlevel>Subkingdom</plantlevel></plantstatus>
211 
                            <plantname_id><plantname><plantname>Magnoliophyta (flowering plants)</plantname></plantname></plantname_id>
260 
                            <plantname_id>
261 
                                <plantname>
262 
                                    <rank>Subkingdom</rank>
263 
                                    <plantname>Magnoliophyta (flowering plants)</plantname>
264 
                                </plantname>
265 
                            </plantname_id>
212 266 
                        </plantconcept>
213 267 
                    </plantconcept_id>
214 268 
                    <determinationtype>Author</determinationtype>
inputs/NYBG-CSV/maps/VegBIEN.specimens.csv
17 17 
YearCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/2/_date/year,,44
18 18 
MaximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/max,,75
19 19 
MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/min,,74
20 
Sex,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]]:[@fkey=tableRecord_ID]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26
21 
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_alt/2/_date/day",,120
22 
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_alt/2/_date/month",,120
23 
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_alt/2/_date/year",,120
24 
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
25 
ScientificName,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_alt/1","Brad: Bob, Nick, please is this mapping OK?",134
26 
ScientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
27 
Class,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,144
28 
Family,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,146
29 
Genus,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,147
30 
Kingdom,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,142
31 
Order,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,145
32 
Species,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
33 
Phylum,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143
34 
Subspecies,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
20 
ScientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
21 
Sex,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]]:[@fkey=tableRecord_ID]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26
22 
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/2/_date/day",,120
23 
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/2/_date/month",,120
24 
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/2/_date/year",,120
25 
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
26 
ScientificName,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Bob, Nick, please is this mapping OK?",134
27 
Class,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,144
28 
Family,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,146
29 
Genus,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,147
30 
Kingdom,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,142
31 
Order,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,145
32 
Species,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
33 
Phylum,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143
34 
Subspecies,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
35 35 
Collector,/*_id/taxonoccurrence/verbatimcollectorname,,23
36 36 
CollectionCode,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12
37 37 
Notes,/description/_merge/1,,
inputs/SALVIAS-CSV/test/VegBIEN.organisms.xml.ref
69 69 
            <role_id><role><rolecode>computer</rolecode></role></role_id>
70 70 
            <plantconcept_id>
71 71 
                <plantconcept>
72 
                    <plantstatus><plantlevel>Family</plantlevel></plantstatus>
73 
                    <plantname_id><plantname><plantname>Fabaceae</plantname></plantname></plantname_id>
72 
                    <plantname_id>
73 
                        <plantname>
74 
                            <rank>Family</rank>
75 
                            <plantname>Fabaceae</plantname>
76 
                        </plantname>
77 
                    </plantname_id>
74 78 
                </plantconcept>
75 79 
            </plantconcept_id>
76 80 
            <determinationtype>Computer (automated)</determinationtype>
......
80 84 
            <role_id><role><rolecode>computer</rolecode></role></role_id>
81 85 
            <plantconcept_id>
82 86 
                <plantconcept>
83 
                    <plantstatus><plantlevel>Genus</plantlevel></plantstatus>
84 
                    <plantname_id><plantname><plantname>Inga</plantname></plantname></plantname_id>
87 
                    <plantname_id>
88 
                        <plantname>
89 
                            <rank>Genus</rank>
90 
                            <plantname>Inga</plantname>
91 
                        </plantname>
92 
                    </plantname_id>
85 93 
                </plantconcept>
86 94 
            </plantconcept_id>
87 95 
            <determinationtype>Computer (automated)</determinationtype>
......
91 99 
            <role_id><role><rolecode>computer</rolecode></role></role_id>
92 100 
            <plantconcept_id>
93 101 
                <plantconcept>
94 
                    <plantstatus><plantlevel>Species</plantlevel></plantstatus>
95 
                    <plantname_id><plantname><plantname>indet</plantname></plantname></plantname_id>
102 
                    <plantname_id>
103 
                        <plantname>
104 
                            <rank>Species</rank>
105 
                            <plantname>indet</plantname>
106 
                        </plantname>
107 
                    </plantname_id>
96 108 
                </plantconcept>
97 109 
            </plantconcept_id>
98 110 
            <determinationtype>Computer (automated)</determinationtype>
......
102 114 
            <role_id><role><rolecode>identifier</rolecode></role></role_id>
103 115 
            <plantconcept_id>
104 116 
                <plantconcept>
105 
                    <plantstatus><plantlevel>Binomial</plantlevel></plantstatus>
106 
                    <plantname_id><plantname><plantname>Inga indet</plantname></plantname></plantname_id>
117 
                    <plantname_id>
118 
                        <plantname>
119 
                            <rank>Binomial</rank>
120 
                            <plantname>Inga indet</plantname>
121 
                        </plantname>
122 
                    </plantname_id>
107 123 
                </plantconcept>
108 124 
            </plantconcept_id>
109 125 
            <determinationtype>Author</determinationtype>
......
114 130 
            <role_id><role><rolecode>identifier</rolecode></role></role_id>
115 131 
            <plantconcept_id>
116 132 
                <plantconcept>
117 
                    <plantstatus><plantlevel>Family</plantlevel></plantstatus>
118 
                    <plantname_id><plantname><plantname>Fabaceae</plantname></plantname></plantname_id>
133 
                    <plantname_id>
134 
                        <plantname>
135 
                            <rank>Family</rank>
136 
                            <plantname>Fabaceae</plantname>
137 
                        </plantname>
138 
                    </plantname_id>
119 139 
                </plantconcept>
120 140 
            </plantconcept_id>
121 141 
            <determinationtype>Author</determinationtype>
......
193 213 
            <role_id><role><rolecode>computer</rolecode></role></role_id>
194 214 
            <plantconcept_id>
195 215 
                <plantconcept>
196 
                    <plantstatus><plantlevel>Family</plantlevel></plantstatus>
197 
                    <plantname_id><plantname><plantname>Myristicaceae</plantname></plantname></plantname_id>
216 
                    <plantname_id>
217 
                        <plantname>
218 
                            <rank>Family</rank>
219 
                            <plantname>Myristicaceae</plantname>
220 
                        </plantname>
221 
                    </plantname_id>
198 222 
                </plantconcept>
199 223 
            </plantconcept_id>
200 224 
            <determinationtype>Computer (automated)</determinationtype>
......
204 228 
            <role_id><role><rolecode>computer</rolecode></role></role_id>
205 229 
            <plantconcept_id>
206 230 
                <plantconcept>
207 
                    <plantstatus><plantlevel>Genus</plantlevel></plantstatus>
208 
                    <plantname_id><plantname><plantname>Virola</plantname></plantname></plantname_id>
231 
                    <plantname_id>
232 
                        <plantname>
233 
                            <rank>Genus</rank>
234 
                            <plantname>Virola</plantname>
235 
                        </plantname>
236 
                    </plantname_id>
209 237 
                </plantconcept>
210 238 
            </plantconcept_id>
211 239 
            <determinationtype>Computer (automated)</determinationtype>
......
215 243 
            <role_id><role><rolecode>computer</rolecode></role></role_id>
216 244 
            <plantconcept_id>
217 245 
                <plantconcept>
218 
                    <plantstatus><plantlevel>Species</plantlevel></plantstatus>
219 
                    <plantname_id><plantname><plantname>pavonis</plantname></plantname></plantname_id>
246 
                    <plantname_id>
247 
                        <plantname>
248 
                            <rank>Species</rank>
249 
                            <plantname>pavonis</plantname>
250 
                        </plantname>
251 
                    </plantname_id>
220 252 
                </plantconcept>
221 253 
            </plantconcept_id>
222 254 
            <determinationtype>Computer (automated)</determinationtype>
......
226 258 
            <role_id><role><rolecode>identifier</rolecode></role></role_id>
227 259 
            <plantconcept_id>
228 260 
                <plantconcept>
229 
                    <plantstatus><plantlevel>Binomial</plantlevel></plantstatus>
230 
                    <plantname_id><plantname><plantname>Virola pavonis</plantname></plantname></plantname_id>
261 
                    <plantname_id>
262 
                        <plantname>
263 
                            <rank>Binomial</rank>
264 
                            <plantname>Virola pavonis</plantname>
265 
                        </plantname>
266 
                    </plantname_id>
231 267 
                </plantconcept>
232 268 
            </plantconcept_id>
233 269 
            <determinationtype>Author</determinationtype>
......
238 274 
            <role_id><role><rolecode>identifier</rolecode></role></role_id>
239 275 
            <plantconcept_id>
240 276 
                <plantconcept>
241 
                    <plantstatus><plantlevel>Family</plantlevel></plantstatus>
242 
                    <plantname_id><plantname><plantname>Myristicaceae</plantname></plantname></plantname_id>
277 
                    <plantname_id>
278 
                        <plantname>
279 
                            <rank>Family</rank>
280 
                            <plantname>Myristicaceae</plantname>
281 
                        </plantname>
282 
                    </plantname_id>
243 283 
                </plantconcept>
244 284 
            </plantconcept_id>
245 285 
            <determinationtype>Author</determinationtype>
inputs/SALVIAS-CSV/test/import.organisms.out.ref
1 
Inserted 80 new rows into database
1 
Inserted 70 new rows into database
inputs/SALVIAS-CSV/maps/VegBIEN.organisms.csv
29 29 
det_type,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=voucherType]]:[@fkey=tableRecord_ID]/definedvalue","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
30 30 
coll_number,/specimenreplicate:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc/_alt/1,Brad: Incorrect. Map instead as for voucher_string
31 31 
voucher_string,/specimenreplicate:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
32 
specific_authority,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
33 
family,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
34 
genus,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
35 
specific_epithet,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
36 
infra_rank_1,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname/_name/first",
37 
infra_ep_1,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/last",
38 
cf_aff,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Binomial]/{taxonFit,*_id/plantconcept/*_id/*/plantname/_name/middle}","Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank."
39 
orig_species,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/last",Brad: OMIT
40 
orig_family,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
32 
specific_authority,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=Authority]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
33 
family,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=Family]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
34 
genus,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=Genus]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
35 
specific_epithet,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=Species]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
36 
infra_rank_1,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=Subspecies]/*_id/plantconcept/*_id/*/plantname/_name/first",
37 
infra_ep_1,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=Subspecies]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/last",
38 
cf_aff,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/{taxonFit,*_id/plantconcept/*_id/*/plantname/_name/middle}","Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank."
39 
orig_species,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/last",Brad: OMIT
40 
orig_family,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
41 41 
coll_firstname,/verbatimcollectorname/_name/first,Brad: See comment above
42 42 
coll_lastname,/verbatimcollectorname/_name/last,"Brad: Correct for VegBank. This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
43 43 
collector_code,,Brad: OMIT
schemas/vegbien.my.sql
25 25 

  		




  26
  26
  
    

  		




  27
  27
  
    
--


  		




  
  28
  
    
-- Name: taxonrank; Type: TYPE; Schema: public; Owner: -


  		




  
  29
  
    
--


  		




  
  30
  
    

  		




  
  31
  
    

  		




  
  32
  
    

  		




  
  33
  
    

  		




  
  34
  
    
--


  		




  28
  35
  
    
-- Name: aggregateoccurrence_plantobs_count_1(); Type: FUNCTION; Schema: public; Owner: -


  		




  29
  36
  
    
--


  		




  30
  37
  
    

  		




  ......




  1522
  1529
  
    
    plantname_id int(11) NOT NULL,


  		




  1523
  1530
  
    
    plantname text NOT NULL,


  		




  1524
  1531
  
    
    reference_id int(11),


  		




  1525
  
  
    
    dateentered timestamp NULL 


  		




  
  1532
  
    
    dateentered timestamp NULL ,


  		




  
  1533
  
    
    rank text NOT NULL


  		




  1526
  1534
  
    
);


  		




  1527
  1535
  
    

  		




  1528
  1536
  
    

  		




  ......




  1586
  1594
  
    
    plantstatus_id int(11) NOT NULL,


  		




  1587
  1595
  
    
    plantconcept_id int(11) NOT NULL,


  		




  1588
  1596
  
    
    party_id int(11),


  		




  1589
  
  
    
    plantlevel text,


  		




  1590
  1597
  
    
    plantparent_id int(11),


  		




  1591
  1598
  
    
    plantconceptstatus text DEFAULT 'undetermined',


  		




  1592
  1599
  
    
    reference_id int(11),


  		




  ......




  4471
  4478
  
    

  		




  4472
  4479
  
    

  		




  4473
  4480
  
    
--


  		




  4474
  
  
    
-- Name: plantstatus_plantlevel_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 


  		




  4475
  
  
    
--


  		




  4476
  
  
    

  		




  4477
  
  
    
CREATE INDEX plantstatus_plantlevel_x ON plantstatus  (plantlevel);


  		




  4478
  
  
    

  		




  4479
  
  
    

  		




  4480
  
  
    
--


  		




  4481
  4481
  
    
-- Name: plantstatus_plantparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 


  		




  4482
  4482
  
    
--


  		




  4483
  4483
  
    

  		












  

    
      schemas/vegbien.sql
    
  





  32
  32
  
    

  		




  33
  33
  
    

  		




  34
  34
  
    
--


  		




  
  35
  
    
-- Name: taxonrank; Type: TYPE; Schema: public; Owner: -


  		




  
  36
  
    
--


  		




  
  37
  
    

  		




  
  38
  
    
CREATE TYPE taxonrank AS ENUM (


  		




  
  39
  
    
    'Binomial',


  		




  
  40
  
    
    'Kingdom',


  		




  
  41
  
    
    'Subkingdom',


  		




  
  42
  
    
    'Superdivision',


  		




  
  43
  
    
    'Division',


  		




  
  44
  
    
    'Class',


  		




  
  45
  
    
    'Subclass',


  		




  
  46
  
    
    'Order',


  		




  
  47
  
    
    'Suborder',


  		




  
  48
  
    
    'Family',


  		




  
  49
  
    
    'Subfamily',


  		




  
  50
  
    
    'Tribe',


  		




  
  51
  
    
    'Subtribe',


  		




  
  52
  
    
    'Genus',


  		




  
  53
  
    
    'Subgenus',


  		




  
  54
  
    
    'Section',


  		




  
  55
  
    
    'Species Aggregate',


  		




  
  56
  
    
    'Species',


  		




  
  57
  
    
    'Subspecies',


  		




  
  58
  
    
    'Authority',


  		




  
  59
  
    
    'Variety',


  		




  
  60
  
    
    'Cultivar/Forma'


  		




  
  61
  
    
);


  		




  
  62
  
    

  		




  
  63
  
    

  		




  
  64
  
    
--


  		




  35
  65
  
    
-- Name: aggregateoccurrence_plantobs_count_1(); Type: FUNCTION; Schema: public; Owner: -


  		




  36
  66
  
    
--


  		




  37
  67
  
    

  		




  ......




  1756
  1786
  
    
    plantname_id integer NOT NULL,


  		




  1757
  1787
  
    
    plantname text NOT NULL,


  		




  1758
  1788
  
    
    reference_id integer,


  		




  1759
  
  
    
    dateentered timestamp with time zone DEFAULT now()


  		




  
  1789
  
    
    dateentered timestamp with time zone DEFAULT now(),


  		




  
  1790
  
    
    rank taxonrank NOT NULL


  		




  1760
  1791
  
    
);


  		




  1761
  1792
  
    

  		




  1762
  1793
  
    

  		




  ......




  1830
  1861
  
    
    plantstatus_id integer NOT NULL,


  		




  1831
  1862
  
    
    plantconcept_id integer NOT NULL,


  		




  1832
  1863
  
    
    party_id integer,


  		




  1833
  
  
    
    plantlevel text,


  		




  1834
  1864
  
    
    plantparent_id integer,


  		




  1835
  1865
  
    
    plantconceptstatus text DEFAULT 'undetermined'::text NOT NULL,


  		




  1836
  1866
  
    
    reference_id integer,


  		




  ......




  4840
  4870
  
    

  		




  4841
  4871
  
    

  		




  4842
  4872
  
    
--


  		




  4843
  
  
    
-- Name: plantstatus_plantlevel_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 


  		




  4844
  
  
    
--


  		




  4845
  
  
    

  		




  4846
  
  
    
CREATE INDEX plantstatus_plantlevel_x ON plantstatus USING btree (plantlevel);


  		




  4847
  
  
    

  		




  4848
  
  
    

  		




  4849
  
  
    
--


  		




  4850
  4873
  
    
-- Name: plantstatus_plantparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 


  		




  4851
  4874
  
    
--


  		




  4852
  4875
  
    

  		












  

    
      mappings/VegX-VegBIEN.organisms.csv
    
  





  97
  97
  
    
/simpleUserdefined[name=collectionDate]/value,/specimenreplicate:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectiondate,


  		




  98
  98
  
    
/simpleUserdefined[name=collectionDate]/value/_*/date,/specimenreplicate:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectiondate/_*/date,


  		




  99
  99
  
    
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName,/specimenreplicate:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,


  		




  100
  
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=auth])/Name","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  101
  
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  102
  
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  103
  
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  104
  
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Rank","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname/_name/first",


  		




  105
  
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Name","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/last",


  		




  106
  
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=auth])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  107
  
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=binom])/fit","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Binomial]/taxonFit",


  		




  108
  
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=binom])/{fit,Name/_name/middle}","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Binomial]/{taxonFit,*_id/plantconcept/*_id/*/plantname/_name/middle}",


  		




  109
  
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=binom])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  110
  
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=binom])/Name/_name/first","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/first",


  		




  111
  
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=binom])/Name/_name/last","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/last",


  		




  112
  
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=binom])/Name/_name/middle","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/middle",


  		




  113
  
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  114
  
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  115
  
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  116
  
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  117
  
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  118
  
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  119
  
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname",


  		




  
  100
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=auth])/Name","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=Authority]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  
  101
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=Family]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  
  102
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=Genus]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  
  103
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=Species]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  
  104
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Rank","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=Subspecies]/*_id/plantconcept/*_id/*/plantname/_name/first",


  		




  
  105
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Name","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/*_id/plantname/rank=Subspecies]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/last",


  		




  
  106
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=auth])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  
  107
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=binom])/fit","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/taxonFit",


  		




  
  108
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=binom])/{fit,Name/_name/middle}","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/{taxonFit,*_id/plantconcept/*_id/*/plantname/_name/middle}",


  		




  
  109
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=binom])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  
  110
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=binom])/Name/_name/first","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/first",


  		




  
  111
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=binom])/Name/_name/last","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/last",


  		




  
  112
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=binom])/Name/_name/middle","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_name/middle",


  		




  
  113
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  
  114
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  
  115
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  
  116
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  
  117
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  
  118
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",


  		




  
  119
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Subspecies]/*_id/plantconcept/*_id/*/plantname",


  		




  120
  120
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName",/verbatimcollectorname/_name/first,


  		




  121
  121
  
    
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/surName",/verbatimcollectorname/_name/last,


  		












  

    
      mappings/for_review/VegX-VegBIEN.organisms.csv
    
  





  97
  97
  
    
/simpleUserdefined[name=collectionDate]/value,//specimenreplicate/collectiondate,


  		




  98
  98
  
    
/simpleUserdefined[name=collectionDate]/value/_*/date,//specimenreplicate/collectiondate/_*/date,


  		




  99
  99
  
    
//party/organizationName,//party/organizationname/_alt/1,


  		




  100
  
  
    
//*s/taxonConcept[@code=auth]/Name,"/taxondetermination[rolecode=computer,plantlevel=Authority]/*_id/plantconcept/*_id/*/plantname",


  		




  101
  
  
    
//*s/taxonConcept[@code=fam]/Name,"/taxondetermination[rolecode=computer,plantlevel=Family]/*_id/plantconcept/*_id/*/plantname",


  		




  102
  
  
    
//*s/taxonConcept[@code=gen]/Name,"/taxondetermination[rolecode=computer,plantlevel=Genus]/*_id/plantconcept/*_id/*/plantname",


  		




  103
  
  
    
//*s/taxonConcept[@code=sp]/Name,"/taxondetermination[rolecode=computer,plantlevel=Species]/*_id/plantconcept/*_id/*/plantname",


  		




  104
  
  
    
//*s/taxonConcept[@code=TaxonomicRankBelowSubspeciesEnum]/Rank,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname/_name/first",


  		




  105
  
  
    
//*s/taxonConcept[@code=TaxonomicRankBelowSubspeciesEnum]/Name,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname/_name/last",


  		




  106
  
  
    
//*s/taxonConcept[@code=auth]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Authority]/*_id/plantconcept/*_id/*/plantname",


  		




  107
  
  
    
//*s/taxonConcept[@code=binom]/fit,"/taxondetermination[rolecode=identifier,plantlevel=Binomial]/taxonFit",


  		




  108
  
  
    
"//*s/taxonConcept[@code=binom]/{fit,Name/_name/middle}","/taxondetermination[rolecode=identifier,plantlevel=Binomial]/{taxonFit,*_id/plantconcept/*_id/*/plantname/_name/middle}",


  		




  109
  
  
    
//*s/taxonConcept[@code=binom]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Binomial]/*_id/plantconcept/*_id/*/plantname",


  		




  110
  
  
    
//*s/taxonConcept[@code=binom]/Name/_name/first,"/taxondetermination[rolecode=identifier,plantlevel=Binomial]/*_id/plantconcept/*_id/*/plantname/_name/first",


  		




  111
  
  
    
//*s/taxonConcept[@code=binom]/Name/_name/last,"/taxondetermination[rolecode=identifier,plantlevel=Binomial]/*_id/plantconcept/*_id/*/plantname/_name/last",


  		




  112
  
  
    
//*s/taxonConcept[@code=binom]/Name/_name/middle,"/taxondetermination[rolecode=identifier,plantlevel=Binomial]/*_id/plantconcept/*_id/*/plantname/_name/middle",


  		




  113
  
  
    
//*s/taxonConcept[@code=cl]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Class]/*_id/plantconcept/*_id/*/plantname",


  		




  114
  
  
    
//*s/taxonConcept[@code=fam]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Family]/*_id/plantconcept/*_id/*/plantname",


  		




  115
  
  
    
//*s/taxonConcept[@code=gen]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Genus]/*_id/plantconcept/*_id/*/plantname",


  		




  116
  
  
    
//*s/taxonConcept[@code=reg]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Kingdom]/*_id/plantconcept/*_id/*/plantname",


  		




  117
  
  
    
//*s/taxonConcept[@code=ord]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Order]/*_id/plantconcept/*_id/*/plantname",


  		




  118
  
  
    
//*s/taxonConcept[@code=phyl_div]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Subkingdom]/*_id/plantconcept/*_id/*/plantname",


  		




  119
  
  
    
//*s/taxonConcept[@code=ssp]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname",


  		




  
  100
  
    
//*s/taxonConcept[@code=auth]/Name,"/taxondetermination[rolecode=computer,rank=Authority]/*_id/plantconcept/*_id/*/plantname",


  		




  
  101
  
    
//*s/taxonConcept[@code=fam]/Name,"/taxondetermination[rolecode=computer,rank=Family]/*_id/plantconcept/*_id/*/plantname",


  		




  
  102
  
    
//*s/taxonConcept[@code=gen]/Name,"/taxondetermination[rolecode=computer,rank=Genus]/*_id/plantconcept/*_id/*/plantname",


  		




  
  103
  
    
//*s/taxonConcept[@code=sp]/Name,"/taxondetermination[rolecode=computer,rank=Species]/*_id/plantconcept/*_id/*/plantname",


  		




  
  104
  
    
//*s/taxonConcept[@code=TaxonomicRankBelowSubspeciesEnum]/Rank,"/taxondetermination[rolecode=computer,rank=Subspecies]/*_id/plantconcept/*_id/*/plantname/_name/first",


  		




  
  105
  
    
//*s/taxonConcept[@code=TaxonomicRankBelowSubspeciesEnum]/Name,"/taxondetermination[rolecode=computer,rank=Subspecies]/*_id/plantconcept/*_id/*/plantname/_name/last",


  		




  
  106
  
    
//*s/taxonConcept[@code=auth]/Name,"/taxondetermination[rolecode=identifier,rank=Authority]/*_id/plantconcept/*_id/*/plantname",


  		




  
  107
  
    
//*s/taxonConcept[@code=binom]/fit,"/taxondetermination[rolecode=identifier,rank=Binomial]/taxonFit",


  		




  
  108
  
    
"//*s/taxonConcept[@code=binom]/{fit,Name/_name/middle}","/taxondetermination[rolecode=identifier,rank=Binomial]/{taxonFit,*_id/plantconcept/*_id/*/plantname/_name/middle}",


  		




  
  109
  
    
//*s/taxonConcept[@code=binom]/Name,"/taxondetermination[rolecode=identifier,rank=Binomial]/*_id/plantconcept/*_id/*/plantname",


  		




  
  110
  
    
//*s/taxonConcept[@code=binom]/Name/_name/first,"/taxondetermination[rolecode=identifier,rank=Binomial]/*_id/plantconcept/*_id/*/plantname/_name/first",


  		




  
  111
  
    
//*s/taxonConcept[@code=binom]/Name/_name/last,"/taxondetermination[rolecode=identifier,rank=Binomial]/*_id/plantconcept/*_id/*/plantname/_name/last",


  		




  
  112
  
    
//*s/taxonConcept[@code=binom]/Name/_name/middle,"/taxondetermination[rolecode=identifier,rank=Binomial]/*_id/plantconcept/*_id/*/plantname/_name/middle",


  		




  
  113
  
    
//*s/taxonConcept[@code=cl]/Name,"/taxondetermination[rolecode=identifier,rank=Class]/*_id/plantconcept/*_id/*/plantname",


  		




  
  114
  
    
//*s/taxonConcept[@code=fam]/Name,"/taxondetermination[rolecode=identifier,rank=Family]/*_id/plantconcept/*_id/*/plantname",


  		




  
  115
  
    
//*s/taxonConcept[@code=gen]/Name,"/taxondetermination[rolecode=identifier,rank=Genus]/*_id/plantconcept/*_id/*/plantname",


  		




  
  116
  
    
//*s/taxonConcept[@code=reg]/Name,"/taxondetermination[rolecode=identifier,rank=Kingdom]/*_id/plantconcept/*_id/*/plantname",


  		




  
  117
  
    
//*s/taxonConcept[@code=ord]/Name,"/taxondetermination[rolecode=identifier,rank=Order]/*_id/plantconcept/*_id/*/plantname",


  		




  
  118
  
    
//*s/taxonConcept[@code=phyl_div]/Name,"/taxondetermination[rolecode=identifier,rank=Subkingdom]/*_id/plantconcept/*_id/*/plantname",


  		




  
  119
  
    
//*s/taxonConcept[@code=ssp]/Name,"/taxondetermination[rolecode=identifier,rank=Subspecies]/*_id/plantconcept/*_id/*/plantname",


  		




  120
  120
  
    
//individualName/givenName,/verbatimcollectorname/_name/first,


  		




  121
  121
  
    
//individualName/surName,/verbatimcollectorname/_name/last,


  		












  

    
      mappings/for_review/DwC-VegBIEN.specimens.csv
    
  





  24
  24
  
    
eventDate/_alt/2/_date/year,//locationevent/obsstartdate/_alt/2/_date/year,,44


  		




  25
  25
  
    
maximumDepthInMeters,//waterdepth/max,,75


  		




  26
  26
  
    
minimumDepthInMeters,//waterdepth/min,,74


  		




  27
  
  
    
sex,"//taxonoccurrence/taxondetermination[rolecode=identifier]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26


  		




  28
  
  
    
dateIdentified,//taxonoccurrence/taxondetermination[rolecode=identifier]/determinationdate,,120


  		




  29
  
  
    
dateIdentified/_alt/1/_*/date,//taxonoccurrence/taxondetermination[rolecode=identifier]/determinationdate/_alt/1/_*/date,,120


  		




  30
  
  
    
dateIdentified/_alt/2/_date/day,//taxonoccurrence/taxondetermination[rolecode=identifier]/determinationdate/_alt/2/_date/day,,120


  		




  31
  
  
    
dateIdentified/_alt/2/_date/month,//taxonoccurrence/taxondetermination[rolecode=identifier]/determinationdate/_alt/2/_date/month,,120


  		




  32
  
  
    
dateIdentified/_alt/2/_date/year,//taxonoccurrence/taxondetermination[rolecode=identifier]/determinationdate/_alt/2/_date/year,,120


  		




  33
  
  
    
identifiedBy,"//taxonoccurrence/taxondetermination[rolecode=identifier]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119


  		




  34
  
  
    
scientificName,//taxonoccurrence/taxondetermination[rolecode=identifier]/*_id/plantconcept/*_id/*/plantname/_alt/1,"Brad: Bob, Nick, please is this mapping OK?",134


  		




  35
  
  
    
scientificNameAuthorship,"//taxonoccurrence/taxondetermination[rolecode=identifier,plantlevel=Authority]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153


  		




  36
  
  
    
class,"//taxonoccurrence/taxondetermination[rolecode=identifier,plantlevel=Class]/*_id/plantconcept/*_id/*/plantname",,144


  		




  37
  
  
    
family,"//taxonoccurrence/taxondetermination[rolecode=identifier,plantlevel=Family]/*_id/plantconcept/*_id/*/plantname",,146


  		




  38
  
  
    
genus,"//taxonoccurrence/taxondetermination[rolecode=identifier,plantlevel=Genus]/*_id/plantconcept/*_id/*/plantname",,147


  		




  39
  
  
    
kingdom,"//taxonoccurrence/taxondetermination[rolecode=identifier,plantlevel=Kingdom]/*_id/plantconcept/*_id/*/plantname",,142


  		




  40
  
  
    
order,"//taxonoccurrence/taxondetermination[rolecode=identifier,plantlevel=Order]/*_id/plantconcept/*_id/*/plantname",,145


  		




  41
  
  
    
specificEpithet,"//taxonoccurrence/taxondetermination[rolecode=identifier,plantlevel=Species]/*_id/plantconcept/*_id/*/plantname",,149


  		




  42
  
  
    
phylum,"//taxonoccurrence/taxondetermination[rolecode=identifier,plantlevel=Subkingdom]/*_id/plantconcept/*_id/*/plantname",,143


  		




  43
  
  
    
infraspecificEpithet,"//taxonoccurrence/taxondetermination[rolecode=identifier,plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname",,150


  		




  
  27
  
    
scientificNameAuthorship,"//taxonoccurrence/taxondetermination[rolecode=identifier,rank=Authority]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153


  		




  
  28
  
    
sex,"//taxonoccurrence/taxondetermination[rolecode=identifier,rank=Binomial]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26


  		




  
  29
  
    
dateIdentified,"//taxonoccurrence/taxondetermination[rolecode=identifier,rank=Binomial]/determinationdate",,120


  		




  
  30
  
    
dateIdentified/_alt/1/_*/date,"//taxonoccurrence/taxondetermination[rolecode=identifier,rank=Binomial]/determinationdate/_alt/1/_*/date",,120


  		




  
  31
  
    
dateIdentified/_alt/2/_date/day,"//taxonoccurrence/taxondetermination[rolecode=identifier,rank=Binomial]/determinationdate/_alt/2/_date/day",,120


  		




  
  32
  
    
dateIdentified/_alt/2/_date/month,"//taxonoccurrence/taxondetermination[rolecode=identifier,rank=Binomial]/determinationdate/_alt/2/_date/month",,120


  		




  
  33
  
    
dateIdentified/_alt/2/_date/year,"//taxonoccurrence/taxondetermination[rolecode=identifier,rank=Binomial]/determinationdate/_alt/2/_date/year",,120


  		




  
  34
  
    
identifiedBy,"//taxonoccurrence/taxondetermination[rolecode=identifier,rank=Binomial]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119


  		




  
  35
  
    
scientificName,"//taxonoccurrence/taxondetermination[rolecode=identifier,rank=Binomial]/*_id/plantconcept/*_id/*/plantname","Brad: Bob, Nick, please is this mapping OK?",134


  		




  
  36
  
    
class,"//taxonoccurrence/taxondetermination[rolecode=identifier,rank=Class]/*_id/plantconcept/*_id/*/plantname",,144


  		




  
  37
  
    
family,"//taxonoccurrence/taxondetermination[rolecode=identifier,rank=Family]/*_id/plantconcept/*_id/*/plantname",,146


  		




  
  38
  
    
genus,"//taxonoccurrence/taxondetermination[rolecode=identifier,rank=Genus]/*_id/plantconcept/*_id/*/plantname",,147


  		




  
  39
  
    
kingdom,"//taxonoccurrence/taxondetermination[rolecode=identifier,rank=Kingdom]/*_id/plantconcept/*_id/*/plantname",,142


  		




  
  40
  
    
order,"//taxonoccurrence/taxondetermination[rolecode=identifier,rank=Order]/*_id/plantconcept/*_id/*/plantname",,145


  		




  
  41
  
    
specificEpithet,"//taxonoccurrence/taxondetermination[rolecode=identifier,rank=Species]/*_id/plantconcept/*_id/*/plantname",,149


  		




  
  42
  
    
phylum,"//taxonoccurrence/taxondetermination[rolecode=identifier,rank=Subkingdom]/*_id/plantconcept/*_id/*/plantname",,143


  		




  
  43
  
    
infraspecificEpithet,"//taxonoccurrence/taxondetermination[rolecode=identifier,rank=Subspecies]/*_id/plantconcept/*_id/*/plantname",,150


  		




  44
  44
  
    
recordedBy,//taxonoccurrence/verbatimcollectorname,,23


  		




  45
  45
  
    
collectionCode,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12


  		




  46
  46
  
    
fieldNotes,/description,,


  		












  

    
      mappings/DwC-VegBIEN.specimens.csv
    
  





  24
  24
  
    
eventDate/_alt/2/_date/year,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/2/_date/year,,44


  		




  25
  25
  
    
maximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/max,,75


  		




  26
  26
  
    
minimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/min,,74


  		




  27
  
  
    
sex,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]]:[@fkey=tableRecord_ID]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26


  		




  28
  
  
    
dateIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate",,120


  		




  29
  
  
    
dateIdentified/_alt/1/_*/date,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_alt/1/_*/date",,120


  		




  30
  
  
    
dateIdentified/_alt/2/_date/day,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_alt/2/_date/day",,120


  		




  31
  
  
    
dateIdentified/_alt/2/_date/month,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_alt/2/_date/month",,120


  		




  32
  
  
    
dateIdentified/_alt/2/_date/year,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_alt/2/_date/year",,120


  		




  33
  
  
    
identifiedBy,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119


  		




  34
  
  
    
scientificName,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_alt/1","Brad: Bob, Nick, please is this mapping OK?",134


  		




  35
  
  
    
scientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153


  		




  36
  
  
    
class,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,144


  		




  37
  
  
    
family,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,146


  		




  38
  
  
    
genus,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,147


  		




  39
  
  
    
kingdom,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,142


  		




  40
  
  
    
order,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,145


  		




  41
  
  
    
specificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149


  		




  42
  
  
    
phylum,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143


  		




  43
  
  
    
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150


  		




  
  27
  
    
scientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153


  		




  
  28
  
    
sex,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]]:[@fkey=tableRecord_ID]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26


  		




  
  29
  
    
dateIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate",,120


  		




  
  30
  
    
dateIdentified/_alt/1/_*/date,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/1/_*/date",,120


  		




  
  31
  
    
dateIdentified/_alt/2/_date/day,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/2/_date/day",,120


  		




  
  32
  
    
dateIdentified/_alt/2/_date/month,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/2/_date/month",,120


  		




  
  33
  
    
dateIdentified/_alt/2/_date/year,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/2/_date/year",,120


  		




  
  34
  
    
identifiedBy,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119


  		




  
  35
  
    
scientificName,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Bob, Nick, please is this mapping OK?",134


  		




  
  36
  
    
class,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,144


  		




  
  37
  
    
family,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,146


  		




  
  38
  
    
genus,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,147


  		




  
  39
  
    
kingdom,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,142


  		




  
  40
  
    
order,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,145


  		




  
  41
  
    
specificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149


  		




  
  42
  
    
phylum,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143


  		




  
  43
  
    
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150


  		




  44
  44
  
    
recordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23


  		




  45
  45
  
    
collectionCode,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12


  		




  46
  46
  
    
fieldNotes,/description,,


  		












Also available in:  Unified diff