Project

General

Profile

« Previous | Next » 

Revision 4182

View differences:

inputs/MT/src/specimens/src.csv
1
MT[Veg+],Veg+,Comments
2
id,,
3
establishmentMeans,,
4
locality,,
5
language,,
6
collectionID,,
7
occurrenceRemarks,,
8
type,,
9
institutionCode,,
10
rights,,
11
family,,
12
continent,,
13
collectionCode,,
14
datasetName,,
15
rightsHolder,,
16
genus,,
17
basisOfRecord,,
18
individualCount,,
19
countryCode,,
inputs/MT/src/specimens/map.csv
1
MT[Veg+],Veg+,Comments
inputs/MT/src/specimens/map.full.csv
1
MT[Veg+],Veg+,Comments
2
basisOfRecord,basisOfRecord
3
collectionCode,collectionCode
4
collectionID,collectionID
5
continent,continent
6
countryCode,countryCode
7
datasetName,datasetName
8
establishmentMeans,establishmentMeans
9
family,family
10
genus,genus
11
id,id
12
individualCount,individualCount
13
institutionCode,institutionCode
14
language,language
15
locality,locality
16
occurrenceRemarks,occurrenceRemarks
17
rights,rights
18
rightsHolder,rightsHolder
19
type,type
inputs/MT/src/specimens/test.xml.ref
1
Put template:
2
<VegBIEN>
3
    <location id="-1">
4
        <authorlocationcode>
5
            <_alt>
6
                <3>$id</3>
7
                <4>
8
                    <_merge>
9
                        <1>$institutionCode</1>
10
                        <2>
11
                            <_merge>
12
                                <1>$collectionCode</1>
13
                                <2>$collectionID</2>
14
                            </_merge>
15
                        </2>
16
                    </_merge>
17
                </4>
18
            </_alt>
19
        </authorlocationcode>
20
        <locationdetermination>
21
            <namedplace_id>
22
                <_simplifyPath>
23
                    <next>parent_id/namedplace</next>
24
                    <require>placename</require>
25
                    <path>
26
                        <namedplace>
27
                            <rank>county</rank>
28
                            <parent_id>
29
                                <namedplace>
30
                                    <rank>stateProvince</rank>
31
                                    <parent_id>
32
                                        <namedplace>
33
                                            <rank>country</rank>
34
                                            <parent_id>
35
                                                <namedplace>
36
                                                    <rank>continent</rank>
37
                                                    <placename>$continent</placename>
38
                                                </namedplace>
39
                                            </parent_id>
40
                                        </namedplace>
41
                                    </parent_id>
42
                                </namedplace>
43
                            </parent_id>
44
                        </namedplace>
45
                    </path>
46
                </_simplifyPath>
47
            </namedplace_id>
48
        </locationdetermination>
49
        <locationevent>
50
            <taxonoccurrence>
51
                <aggregateoccurrence>
52
                    <count>$individualCount</count>
53
                    <plantobservation>
54
                        <specimenreplicate>
55
                            <collectioncode_dwc>
56
                                <_merge>
57
                                    <1>$collectionCode</1>
58
                                    <2>$collectionID</2>
59
                                </_merge>
60
                            </collectioncode_dwc>
61
                            <institution_id><party><organizationname>$institutionCode</organizationname></party></institution_id>
62
                            <sourceaccessioncode>$id</sourceaccessioncode>
63
                        </specimenreplicate>
64
                    </plantobservation>
65
                </aggregateoccurrence>
66
                <iscultivated>
67
                    <_map>
68
                        <cultivated>t</cultivated>
69
                        <wild>f</wild>
70
                        <*></*>
71
                        <value>$establishmentMeans</value>
72
                    </_map>
73
                </iscultivated>
74
                <isnative>
75
                    <_map>
76
                        <native>t</native>
77
                        <exotic>f</exotic>
78
                        <*></*>
79
                        <value>$establishmentMeans</value>
80
                    </_map>
81
                </isnative>
82
                <taxondetermination>
83
                    <isoriginal>true</isoriginal>
84
                    <role>identifier</role>
85
                    <plantconcept_id>
86
                        <plantconcept>
87
                            <plantname_id>
88
                                <_simplifyPath>
89
                                    <next>parent_id/plantname</next>
90
                                    <require>plantname</require>
91
                                    <path>
92
                                        <plantname>
93
                                            <rank>binomial</rank>
94
                                            <parent_id>
95
                                                <plantname>
96
                                                    <rank>authority</rank>
97
                                                    <parent_id>
98
                                                        <plantname>
99
                                                            <rank>subspecies</rank>
100
                                                            <parent_id>
101
                                                                <plantname>
102
                                                                    <rank>species</rank>
103
                                                                    <parent_id>
104
                                                                        <plantname>
105
                                                                            <rank>genus</rank>
106
                                                                            <plantname>$genus</plantname>
107
                                                                            <parent_id>
108
                                                                                <plantname>
109
                                                                                    <rank>family</rank>
110
                                                                                    <plantname>$family</plantname>
111
                                                                                </plantname>
112
                                                                            </parent_id>
113
                                                                        </plantname>
114
                                                                    </parent_id>
115
                                                                </plantname>
116
                                                            </parent_id>
117
                                                        </plantname>
118
                                                    </parent_id>
119
                                                </plantname>
120
                                            </parent_id>
121
                                        </plantname>
122
                                    </path>
123
                                </_simplifyPath>
124
                            </plantname_id>
125
                        </plantconcept>
126
                    </plantconcept_id>
127
                </taxondetermination>
128
            </taxonoccurrence>
129
        </locationevent>
130
        <locationnarrative>$locality</locationnarrative>
131
    </location>
132
</VegBIEN>
133
Inserted 22 new rows into database
inputs/MT/src/specimens/VegBIEN.csv
1
MT[Veg+],VegBIEN:,Comments
2
id,/location/authorlocationcode/_alt/3,
3
institutionCode,/location/authorlocationcode/_alt/4/_merge/1,
4
collectionCode,/location/authorlocationcode/_alt/4/_merge/2/_merge/1,
5
collectionID,/location/authorlocationcode/_alt/4/_merge/2/_merge/2,
6
continent,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
7
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
8
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_merge/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
9
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_merge/2,
10
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
11
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
12
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value",
13
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value",
14
genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
15
family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
16
locality,/location/locationnarrative/_merge/1,
17
basisOfRecord,,** No join mapping for basisOfRecord ** 
18
countryCode,,** No join mapping for countryCode ** 
19
datasetName,,** No join mapping for datasetName ** 
20
language,,** No join mapping for language ** 
21
occurrenceRemarks,,** No join mapping for occurrenceRemarks ** 
22
rights,,** No join mapping for rights ** 
23
rightsHolder,,** No join mapping for rightsHolder ** 
24
type,,** No join mapping for type ** 
inputs/XAL/src/digir.specimens.xml.make
1
#!/bin/sh
2
# Downloads XAL data using DiGIR
3
# Usage: env [start=...] [n=...] self >out.xml 2>>log
4

  
5
selfDir="$(dirname -- "$0")"
6

  
7
export \
8
url=http://remib.ecologia.edu.mx/digir/DiGIR.php \
9
resource=IE-XAL-HERBARIO \
10
chunk_size=200
11
    # the server often drops the connection if too much data is requested
12

  
13
"$selfDir/../../../bin/digir_client"
14 0

  
inputs/XAL/src/specimens/src.csv
1
"XAL[Veg+,darwin:]:/content/record/",Original name
2
DateLastModified,darwin:DateLastModified
3
InstitutionCode,darwin:InstitutionCode
4
CollectionCode,darwin:CollectionCode
5
CatalogNumber,darwin:CatalogNumber
6
ScientificName,darwin:ScientificName
7
BasisOfRecord,darwin:BasisOfRecord
8
Kingdom,darwin:Kingdom
9
Phylum,darwin:Phylum
10
Class,darwin:Class
11
Order,darwin:Order
12
Family,darwin:Family
13
Genus,darwin:Genus
14
Species,darwin:Species
15
Subspecies,darwin:Subspecies
16
ScientificNameAuthor,darwin:ScientificNameAuthor
17
IdentifiedBy,darwin:IdentifiedBy
18
YearIdentified,darwin:YearIdentified
19
MonthIdentified,darwin:MonthIdentified
20
DayIdentified,darwin:DayIdentified
21
TypeStatus,darwin:TypeStatus
22
CollectorNumber,darwin:CollectorNumber
23
FieldNumber,darwin:FieldNumber
24
Collector,darwin:Collector
25
YearCollected,darwin:YearCollected
26
MonthCollected,darwin:MonthCollected
27
DayCollected,darwin:DayCollected
28
JulianDay,darwin:JulianDay
29
TimeOfDay,darwin:TimeOfDay
30
ContinentOcean,darwin:ContinentOcean
31
Country,darwin:Country
32
StateProvince,darwin:StateProvince
33
County,darwin:County
34
Locality,darwin:Locality
35
Longitude,darwin:Longitude
36
Latitude,darwin:Latitude
37
CoordinatePrecision,darwin:CoordinatePrecision
38
MinimumElevation,darwin:MinimumElevation
39
MaximumElevation,darwin:MaximumElevation
40
MinimumDepth,darwin:MinimumDepth
41
MaximumDepth,darwin:MaximumDepth
42
Sex,darwin:Sex
43
PreparationType,darwin:PreparationType
44
IndividualCount,darwin:IndividualCount
45
PreviousCatalogNumber,darwin:PreviousCatalogNumber
46
RelationshipType,darwin:RelationshipType
47
RelatedCatalogItem,darwin:RelatedCatalogItem
48
Notes,darwin:Notes
inputs/XAL/src/specimens/map.csv
1
"XAL[Veg+,darwin:]:/content/record/",Veg+,Comments
2
CollectorNumber,recordNumber/_alt/1,
3
FieldNumber,recordNumber/_alt/2,"This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber). It is also unused: `grep -F ""<darwin:FieldNumber>"" inputs/XAL/src/digir.specimens.xml` returns no lines."
inputs/XAL/src/specimens/map.full.csv
1
"XAL[Veg+,darwin:]:/content/record/",Veg+,Comments
2
BasisOfRecord,BasisOfRecord
3
CatalogNumber,CatalogNumber
4
Class,Class
5
CollectionCode,CollectionCode
6
Collector,Collector
7
ContinentOcean,ContinentOcean
8
CoordinatePrecision,CoordinatePrecision
9
Country,Country
10
County,County
11
DateLastModified,DateLastModified
12
DayCollected,DayCollected
13
DayIdentified,DayIdentified
14
Family,Family
15
Genus,Genus
16
IdentifiedBy,IdentifiedBy
17
IndividualCount,IndividualCount
18
InstitutionCode,InstitutionCode
19
JulianDay,JulianDay
20
Kingdom,Kingdom
21
Latitude,Latitude
22
Locality,Locality
23
Longitude,Longitude
24
MaximumDepth,MaximumDepth
25
MaximumElevation,MaximumElevation
26
MinimumDepth,MinimumDepth
27
MinimumElevation,MinimumElevation
28
MonthCollected,MonthCollected
29
MonthIdentified,MonthIdentified
30
Notes,Notes
31
Order,Order
32
Phylum,Phylum
33
PreparationType,PreparationType
34
PreviousCatalogNumber,PreviousCatalogNumber
35
RelatedCatalogItem,RelatedCatalogItem
36
RelationshipType,RelationshipType
37
ScientificName,ScientificName
38
ScientificNameAuthor,ScientificNameAuthor
39
Sex,Sex
40
Species,Species
41
StateProvince,StateProvince
42
Subspecies,Subspecies
43
TimeOfDay,TimeOfDay
44
TypeStatus,TypeStatus
45
YearCollected,YearCollected
46
YearIdentified,YearIdentified
47
CollectorNumber,recordNumber/_alt/1,
48
FieldNumber,recordNumber/_alt/2,"This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber). It is also unused: `grep -F ""<darwin:FieldNumber>"" inputs/XAL/src/digir.specimens.xml` returns no lines."
inputs/XAL/src/specimens/test.xml.ref
1
Put template:
2
<VegBIEN>
3
    <location id="-1">
4
        <authorlocationcode>
5
            <_merge>
6
                <1>$InstitutionCode</1>
7
                <2>$CollectionCode</2>
8
                <3>$CatalogNumber</3>
9
            </_merge>
10
        </authorlocationcode>
11
        <elevation>
12
            <_avg>
13
                <max>
14
                    <_units>
15
                        <default>m</default>
16
                        <to>m</to>
17
                        <to></to>
18
                        <value>
19
                            <_replace>
20
                                <\bca\.?></\bca\.?>
21
                                <value>$MaximumElevation</value>
22
                            </_replace>
23
                        </value>
24
                    </_units>
25
                </max>
26
                <min>
27
                    <_units>
28
                        <default>m</default>
29
                        <to>m</to>
30
                        <to></to>
31
                        <value>
32
                            <_rangeStart>
33
                                <value>
34
                                    <_replace>
35
                                        <\bca\.?></\bca\.?>
36
                                        <value>$MinimumElevation</value>
37
                                    </_replace>
38
                                </value>
39
                            </_rangeStart>
40
                        </value>
41
                    </_units>
42
                </min>
43
            </_avg>
44
        </elevation>
45
        <elevationrange>
46
            <_range>
47
                <from>
48
                    <_units>
49
                        <default>m</default>
50
                        <to>m</to>
51
                        <to></to>
52
                        <value>
53
                            <_rangeStart>
54
                                <value>
55
                                    <_replace>
56
                                        <\bca\.?></\bca\.?>
57
                                        <value>$MinimumElevation</value>
58
                                    </_replace>
59
                                </value>
60
                            </_rangeStart>
61
                        </value>
62
                    </_units>
63
                </from>
64
                <to>
65
                    <_units>
66
                        <default>m</default>
67
                        <to>m</to>
68
                        <to></to>
69
                        <value>
70
                            <_alt>
71
                                <1>
72
                                    <_replace>
73
                                        <\bca\.?></\bca\.?>
74
                                        <value>$MaximumElevation</value>
75
                                    </_replace>
76
                                </1>
77
                                <2>
78
                                    <_rangeEnd>
79
                                        <value>
80
                                            <_replace>
81
                                                <\bca\.?></\bca\.?>
82
                                                <value>$MinimumElevation</value>
83
                                            </_replace>
84
                                        </value>
85
                                    </_rangeEnd>
86
                                </2>
87
                            </_alt>
88
                        </value>
89
                    </_units>
90
                </to>
91
            </_range>
92
        </elevationrange>
93
        <locationdetermination>
94
            <coordsaccuracy><_noCV><value>$CoordinatePrecision</value></_noCV></coordsaccuracy>
95
            <latitude>
96
                <_nullIf>
97
                    <null>0</null>
98
                    <type>float</type>
99
                    <value>$Latitude</value>
100
                </_nullIf>
101
            </latitude>
102
            <longitude>
103
                <_nullIf>
104
                    <null>0</null>
105
                    <type>float</type>
106
                    <value>$Longitude</value>
107
                </_nullIf>
108
            </longitude>
109
            <namedplace_id>
110
                <_simplifyPath>
111
                    <next>parent_id/namedplace</next>
112
                    <require>placename</require>
113
                    <path>
114
                        <namedplace>
115
                            <rank>county</rank>
116
                            <placename>$County</placename>
117
                            <parent_id>
118
                                <namedplace>
119
                                    <rank>stateProvince</rank>
120
                                    <placename>$StateProvince</placename>
121
                                    <parent_id>
122
                                        <namedplace>
123
                                            <rank>country</rank>
124
                                            <placename>$Country</placename>
125
                                            <parent_id>
126
                                                <namedplace>
127
                                                    <rank>continent</rank>
128
                                                    <placename>$ContinentOcean</placename>
129
                                                </namedplace>
130
                                            </parent_id>
131
                                        </namedplace>
132
                                    </parent_id>
133
                                </namedplace>
134
                            </parent_id>
135
                        </namedplace>
136
                    </path>
137
                </_simplifyPath>
138
            </namedplace_id>
139
        </locationdetermination>
140
        <locationevent>
141
            <obsenddate>
142
                <_date>
143
                    <date>
144
                        <_dateRangeEnd>
145
                            <value>
146
                                <_date>
147
                                    <day>
148
                                        <_nullIf>
149
                                            <null>0</null>
150
                                            <type>float</type>
151
                                            <value>$DayCollected</value>
152
                                        </_nullIf>
153
                                    </day>
154
                                    <month>
155
                                        <_nullIf>
156
                                            <null>0</null>
157
                                            <type>float</type>
158
                                            <value>$MonthCollected</value>
159
                                        </_nullIf>
160
                                    </month>
161
                                    <year>
162
                                        <_nullIf>
163
                                            <null>0</null>
164
                                            <type>float</type>
165
                                            <value>$YearCollected</value>
166
                                        </_nullIf>
167
                                    </year>
168
                                </_date>
169
                            </value>
170
                        </_dateRangeEnd>
171
                    </date>
172
                </_date>
173
            </obsenddate>
174
            <obsstartdate>
175
                <_date>
176
                    <date>
177
                        <_dateRangeStart>
178
                            <value>
179
                                <_date>
180
                                    <day>
181
                                        <_nullIf>
182
                                            <null>0</null>
183
                                            <type>float</type>
184
                                            <value>$DayCollected</value>
185
                                        </_nullIf>
186
                                    </day>
187
                                    <month>
188
                                        <_nullIf>
189
                                            <null>0</null>
190
                                            <type>float</type>
191
                                            <value>$MonthCollected</value>
192
                                        </_nullIf>
193
                                    </month>
194
                                    <year>
195
                                        <_nullIf>
196
                                            <null>0</null>
197
                                            <type>float</type>
198
                                            <value>$YearCollected</value>
199
                                        </_nullIf>
200
                                    </year>
201
                                </_date>
202
                            </value>
203
                        </_dateRangeStart>
204
                    </date>
205
                </_date>
206
            </obsstartdate>
207
            <taxonoccurrence>
208
                <aggregateoccurrence>
209
                    <collectiondate>
210
                        <_date>
211
                            <date>
212
                                <_date>
213
                                    <day>
214
                                        <_nullIf>
215
                                            <null>0</null>
216
                                            <type>float</type>
217
                                            <value>$DayCollected</value>
218
                                        </_nullIf>
219
                                    </day>
220
                                    <month>
221
                                        <_nullIf>
222
                                            <null>0</null>
223
                                            <type>float</type>
224
                                            <value>$MonthCollected</value>
225
                                        </_nullIf>
226
                                    </month>
227
                                    <year>
228
                                        <_nullIf>
229
                                            <null>0</null>
230
                                            <type>float</type>
231
                                            <value>$YearCollected</value>
232
                                        </_nullIf>
233
                                    </year>
234
                                </_date>
235
                            </date>
236
                        </_date>
237
                    </collectiondate>
238
                    <count>$IndividualCount</count>
239
                    <notes>$Notes</notes>
240
                    <plantobservation>
241
                        <collectionnumber>
242
                            <_alt>
243
                                <1>$CollectorNumber</1>
244
                                <2>$FieldNumber</2>
245
                            </_alt>
246
                        </collectionnumber>
247
                        <definedvalue fkey="tablerecord_id">
248
                            <userdefined_id>
249
                                <userdefined>
250
                                    <tablename>plantobservation</tablename>
251
                                    <userdefinedname>sex</userdefinedname>
252
                                </userdefined>
253
                            </userdefined_id>
254
                            <definedvalue>$Sex</definedvalue>
255
                        </definedvalue>
256
                        <specimenreplicate>
257
                            <catalognumber_dwc>$CatalogNumber</catalognumber_dwc>
258
                            <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
259
                            <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
260
                        </specimenreplicate>
261
                    </plantobservation>
262
                </aggregateoccurrence>
263
                <authortaxoncode>
264
                    <_alt>
265
                        <1>
266
                            <_alt>
267
                                <1>$CollectorNumber</1>
268
                                <2>$FieldNumber</2>
269
                            </_alt>
270
                        </1>
271
                        <2>$ScientificName</2>
272
                    </_alt>
273
                </authortaxoncode>
274
                <taxondetermination>
275
                    <isoriginal>true</isoriginal>
276
                    <role>identifier</role>
277
                    <party_id>
278
                        <party>
279
                            <givenname><_namePart><first>$IdentifiedBy</first></_namePart></givenname>
280
                            <middlename><_namePart><middle>$IdentifiedBy</middle></_namePart></middlename>
281
                            <surname><_namePart><last>$IdentifiedBy</last></_namePart></surname>
282
                        </party>
283
                    </party_id>
284
                    <plantconcept_id>
285
                        <plantconcept>
286
                            <plantname_id>
287
                                <_simplifyPath>
288
                                    <next>parent_id/plantname</next>
289
                                    <require>plantname</require>
290
                                    <path>
291
                                        <plantname>
292
                                            <rank>binomial</rank>
293
                                            <plantname>$ScientificName</plantname>
294
                                            <parent_id>
295
                                                <plantname>
296
                                                    <rank>authority</rank>
297
                                                    <plantname>$ScientificNameAuthor</plantname>
298
                                                    <parent_id>
299
                                                        <plantname>
300
                                                            <rank>subspecies</rank>
301
                                                            <plantname>$Subspecies</plantname>
302
                                                            <parent_id>
303
                                                                <plantname>
304
                                                                    <rank>species</rank>
305
                                                                    <plantname>$Species</plantname>
306
                                                                    <parent_id>
307
                                                                        <plantname>
308
                                                                            <rank>genus</rank>
309
                                                                            <plantname>$Genus</plantname>
310
                                                                            <parent_id>
311
                                                                                <plantname>
312
                                                                                    <rank>family</rank>
313
                                                                                    <plantname>$Family</plantname>
314
                                                                                    <parent_id>
315
                                                                                        <plantname>
316
                                                                                            <rank>order</rank>
317
                                                                                            <plantname>$Order</plantname>
318
                                                                                            <parent_id>
319
                                                                                                <plantname>
320
                                                                                                    <rank>class</rank>
321
                                                                                                    <plantname>$Class</plantname>
322
                                                                                                    <parent_id>
323
                                                                                                        <plantname>
324
                                                                                                            <rank>subkingdom</rank>
325
                                                                                                            <plantname>$Phylum</plantname>
326
                                                                                                            <parent_id>
327
                                                                                                                <plantname>
328
                                                                                                                    <rank>kingdom</rank>
329
                                                                                                                    <plantname>$Kingdom</plantname>
330
                                                                                                                </plantname>
331
                                                                                                            </parent_id>
332
                                                                                                        </plantname>
333
                                                                                                    </parent_id>
334
                                                                                                </plantname>
335
                                                                                            </parent_id>
336
                                                                                        </plantname>
337
                                                                                    </parent_id>
338
                                                                                </plantname>
339
                                                                            </parent_id>
340
                                                                        </plantname>
341
                                                                    </parent_id>
342
                                                                </plantname>
343
                                                            </parent_id>
344
                                                        </plantname>
345
                                                    </parent_id>
346
                                                </plantname>
347
                                            </parent_id>
348
                                        </plantname>
349
                                    </path>
350
                                </_simplifyPath>
351
                            </plantname_id>
352
                        </plantconcept>
353
                    </plantconcept_id>
354
                    <determinationdate>
355
                        <_date>
356
                            <date>
357
                                <_dateRangeStart>
358
                                    <value>
359
                                        <_date>
360
                                            <day>
361
                                                <_nullIf>
362
                                                    <null>0</null>
363
                                                    <type>float</type>
364
                                                    <value>$DayIdentified</value>
365
                                                </_nullIf>
366
                                            </day>
367
                                            <month>
368
                                                <_nullIf>
369
                                                    <null>0</null>
370
                                                    <type>float</type>
371
                                                    <value>$MonthIdentified</value>
372
                                                </_nullIf>
373
                                            </month>
374
                                            <year>
375
                                                <_nullIf>
376
                                                    <null>0</null>
377
                                                    <type>float</type>
378
                                                    <value>$YearIdentified</value>
379
                                                </_nullIf>
380
                                            </year>
381
                                        </_date>
382
                                    </value>
383
                                </_dateRangeStart>
384
                            </date>
385
                        </_date>
386
                    </determinationdate>
387
                </taxondetermination>
388
                <verbatimcollectorname>$Collector</verbatimcollectorname>
389
                <voucher><specimenreplicate_id><specimenreplicate><catalognumber_dwc/></specimenreplicate></specimenreplicate_id></voucher>
390
            </taxonoccurrence>
391
            <waterdepth>
392
                <_avg>
393
                    <max>
394
                        <_units>
395
                            <default>m</default>
396
                            <to>m</to>
397
                            <to></to>
398
                            <value>
399
                                <_replace>
400
                                    <\bca\.?></\bca\.?>
401
                                    <value>$MaximumDepth</value>
402
                                </_replace>
403
                            </value>
404
                        </_units>
405
                    </max>
406
                    <min>
407
                        <_units>
408
                            <default>m</default>
409
                            <to>m</to>
410
                            <to></to>
411
                            <value>
412
                                <_replace>
413
                                    <\bca\.?></\bca\.?>
414
                                    <value>$MinimumDepth</value>
415
                                </_replace>
416
                            </value>
417
                        </_units>
418
                    </min>
419
                </_avg>
420
            </waterdepth>
421
        </locationevent>
422
        <locationnarrative>$Locality</locationnarrative>
423
    </location>
424
</VegBIEN>
425
Inserted 47 new rows into database
inputs/XAL/src/specimens/VegBIEN.csv
1
"XAL[Veg+,darwin:]:/content/record/",VegBIEN:,Comments
2
InstitutionCode,/location/authorlocationcode/_alt/4/_merge/1,
3
CollectionCode,/location/authorlocationcode/_alt/4/_merge/2/_merge/1,
4
CatalogNumber,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
5
MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
6
MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
7
MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
8
MaximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
9
MinimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
10
CoordinatePrecision,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,
11
Latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
12
Longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
13
County,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
14
StateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
15
Country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
16
ContinentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
17
DayCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
18
MonthCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
19
YearCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
20
DayCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
21
MonthCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
22
YearCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
23
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
24
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
25
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
26
IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
27
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
28
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
29
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,"This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber). It is also unused: `grep -F ""<darwin:FieldNumber>"" inputs/XAL/src/digir.specimens.xml` returns no lines."
30
Sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,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"
31
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
32
CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_merge/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
33
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
34
CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
35
FieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,"This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber). It is also unused: `grep -F ""<darwin:FieldNumber>"" inputs/XAL/src/digir.specimens.xml` returns no lines."
36
ScientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2,
37
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
38
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
39
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
40
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
41
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname/_alt/2",
42
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",
43
Species,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
44
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
45
Family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
46
Order,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",
47
Class,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",
48
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",
49
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
50
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
51
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
52
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
53
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
54
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
55
MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
56
MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
57
Locality,/location/locationnarrative/_merge/1,
58
BasisOfRecord,,** No join mapping for BasisOfRecord ** 
59
DateLastModified,,** No join mapping for DateLastModified ** 
60
JulianDay,,** No join mapping for JulianDay ** 
61
PreparationType,,** No join mapping for PreparationType ** 
62
PreviousCatalogNumber,,** No join mapping for PreviousCatalogNumber ** 
63
RelatedCatalogItem,,** No join mapping for RelatedCatalogItem ** 
64
RelationshipType,,** No join mapping for RelationshipType ** 
65
TimeOfDay,,** No join mapping for TimeOfDay ** 
66
TypeStatus,,** No join mapping for TypeStatus ** 
inputs/NY/src/specimens/src.csv
1
NY[Veg+],Veg+,Comments
2
key,,
3
DateLastModified,,
4
InstitutionCode,,
5
CollectionCode,,
6
CatalogNumber,,
7
ScientificName,,
8
BasisOfRecord,,
9
Kingdom,,
10
Phylum,,
11
Class,,
12
Order,,
13
Family,,
14
Genus,,
15
Species,,
16
Subspecies,,
17
ScientificNameAuthor,,
18
IdentifiedBy,,
19
YearIdentified,,
20
MonthIdentified,,
21
DayIdentified,,
22
TypeStatus,,
23
CollectorNumber,,
24
FieldNumber,,
25
Collector,,
26
YearCollected,,
27
MonthCollected,,
28
DayCollected,,
29
JulianDay,,
30
TimeOfDay,,
31
ContinentOcean,,
32
Country,,
33
StateProvince,,
34
County,,
35
Locality,,
36
Longitude,,
37
Latitude,,
38
CoordinatePrecision,,
39
BoundingBox,,
40
MinimumElevation,,
41
MaximumElevation,,
42
MinimumDepth,,
43
MaximumDepth,,
44
Sex,,
45
PreparationType,,
46
IndividualCount,,
47
PreviousCatalogNumber,,
48
RelationshipType,,
49
RelatedCatalogItem,,
50
Notes,,
51
Habitat,,
52
PlantFungusDescription,,
53
Substrate,,
54
Vegetation,,
55
UniqueNYInternalRecordNumber,,
inputs/NY/src/specimens/map.csv
1
NY[Veg+],Veg+,Comments
2
key,,Not used because UniqueNYInternalRecordNumber is a better pkey
3
FieldNumber,recordNumber,Usage inconsistent with DwC definition
4
Locality,Locality/_merge/1,
5
MinimumElevation,MinimumElevation/_nullIf:[null=.]/value,
6
Notes,Notes/_merge/1,
7
PlantFungusDescription,"Notes/_merge/2/_label[label=""plant fungus""]/value",
8
Substrate,"Locality/_merge/2/_label[label=""substrate""]/value",
9
Vegetation,"Locality/_merge/3/_label[label=""vegetation""]/value",
10
UniqueNYInternalRecordNumber,occurrenceID,
inputs/NY/src/specimens/map.full.csv
1
NY[Veg+],Veg+,Comments
2
BasisOfRecord,BasisOfRecord
3
BoundingBox,BoundingBox
4
CatalogNumber,CatalogNumber
5
Class,Class
6
CollectionCode,CollectionCode
7
Collector,Collector
8
CollectorNumber,CollectorNumber
9
ContinentOcean,ContinentOcean
10
CoordinatePrecision,CoordinatePrecision
11
Country,Country
12
County,County
13
DateLastModified,DateLastModified
14
DayCollected,DayCollected
15
DayIdentified,DayIdentified
16
Family,Family
17
Genus,Genus
18
Habitat,Habitat
19
IdentifiedBy,IdentifiedBy
20
IndividualCount,IndividualCount
21
InstitutionCode,InstitutionCode
22
JulianDay,JulianDay
23
Kingdom,Kingdom
24
Latitude,Latitude
25
Locality,Locality/_merge/1,
26
Substrate,"Locality/_merge/2/_label[label=""substrate""]/value",
27
Vegetation,"Locality/_merge/3/_label[label=""vegetation""]/value",
28
Longitude,Longitude
29
MaximumDepth,MaximumDepth
30
MaximumElevation,MaximumElevation
31
MinimumDepth,MinimumDepth
32
MinimumElevation,MinimumElevation/_nullIf:[null=.]/value,
33
MonthCollected,MonthCollected
34
MonthIdentified,MonthIdentified
35
Notes,Notes/_merge/1,
36
PlantFungusDescription,"Notes/_merge/2/_label[label=""plant fungus""]/value",
37
Order,Order
38
Phylum,Phylum
39
PreparationType,PreparationType
40
PreviousCatalogNumber,PreviousCatalogNumber
41
RelatedCatalogItem,RelatedCatalogItem
42
RelationshipType,RelationshipType
43
ScientificName,ScientificName
44
ScientificNameAuthor,ScientificNameAuthor
45
Sex,Sex
46
Species,Species
47
StateProvince,StateProvince
48
Subspecies,Subspecies
49
TimeOfDay,TimeOfDay
50
TypeStatus,TypeStatus
51
YearCollected,YearCollected
52
YearIdentified,YearIdentified
53
UniqueNYInternalRecordNumber,occurrenceID,
54
FieldNumber,recordNumber,Usage inconsistent with DwC definition
55
key,,Not used because UniqueNYInternalRecordNumber is a better pkey
inputs/NY/src/specimens/test.xml.ref
1
Put template:
2
<VegBIEN>
3
    <location id="-1">
4
        <authorlocationcode>
5
            <_alt>
6
                <3>$UniqueNYInternalRecordNumber</3>
7
                <4>
8
                    <_merge>
9
                        <1>$InstitutionCode</1>
10
                        <2>$CollectionCode</2>
11
                        <3>$CatalogNumber</3>
12
                    </_merge>
13
                </4>
14
            </_alt>
15
        </authorlocationcode>
16
        <elevation>
17
            <_avg>
18
                <max>
19
                    <_units>
20
                        <default>m</default>
21
                        <to>m</to>
22
                        <to></to>
23
                        <value>
24
                            <_replace>
25
                                <\bca\.?></\bca\.?>
26
                                <value>$MaximumElevation</value>
27
                            </_replace>
28
                        </value>
29
                    </_units>
30
                </max>
31
                <min>
32
                    <_units>
33
                        <default>m</default>
34
                        <to>m</to>
35
                        <to></to>
36
                        <value>
37
                            <_rangeStart>
38
                                <value>
39
                                    <_replace>
40
                                        <\bca\.?></\bca\.?>
41
                                        <value>
42
                                            <_nullIf>
43
                                                <null>.</null>
44
                                                <value>$MinimumElevation</value>
45
                                            </_nullIf>
46
                                        </value>
47
                                    </_replace>
48
                                </value>
49
                            </_rangeStart>
50
                        </value>
51
                    </_units>
52
                </min>
53
            </_avg>
54
        </elevation>
55
        <elevationrange>
56
            <_range>
57
                <from>
58
                    <_units>
59
                        <default>m</default>
60
                        <to>m</to>
61
                        <to></to>
62
                        <value>
63
                            <_rangeStart>
64
                                <value>
65
                                    <_replace>
66
                                        <\bca\.?></\bca\.?>
67
                                        <value>
68
                                            <_nullIf>
69
                                                <null>.</null>
70
                                                <value>$MinimumElevation</value>
71
                                            </_nullIf>
72
                                        </value>
73
                                    </_replace>
74
                                </value>
75
                            </_rangeStart>
76
                        </value>
77
                    </_units>
78
                </from>
79
                <to>
80
                    <_units>
81
                        <default>m</default>
82
                        <to>m</to>
83
                        <to></to>
84
                        <value>
85
                            <_alt>
86
                                <1>
87
                                    <_replace>
88
                                        <\bca\.?></\bca\.?>
89
                                        <value>$MaximumElevation</value>
90
                                    </_replace>
91
                                </1>
92
                                <2>
93
                                    <_rangeEnd>
94
                                        <value>
95
                                            <_replace>
96
                                                <\bca\.?></\bca\.?>
97
                                                <value>
98
                                                    <_nullIf>
99
                                                        <null>.</null>
100
                                                        <value>$MinimumElevation</value>
101
                                                    </_nullIf>
102
                                                </value>
103
                                            </_replace>
104
                                        </value>
105
                                    </_rangeEnd>
106
                                </2>
107
                            </_alt>
108
                        </value>
109
                    </_units>
110
                </to>
111
            </_range>
112
        </elevationrange>
113
        <locationdetermination>
114
            <coordsaccuracy><_noCV><value>$CoordinatePrecision</value></_noCV></coordsaccuracy>
115
            <footprintgeometry_dwc>$BoundingBox</footprintgeometry_dwc>
116
            <latitude>
117
                <_nullIf>
118
                    <null>0</null>
119
                    <type>float</type>
120
                    <value>$Latitude</value>
121
                </_nullIf>
122
            </latitude>
123
            <longitude>
124
                <_nullIf>
125
                    <null>0</null>
126
                    <type>float</type>
127
                    <value>$Longitude</value>
128
                </_nullIf>
129
            </longitude>
130
            <namedplace_id>
131
                <_simplifyPath>
132
                    <next>parent_id/namedplace</next>
133
                    <require>placename</require>
134
                    <path>
135
                        <namedplace>
136
                            <rank>county</rank>
137
                            <placename>$County</placename>
138
                            <parent_id>
139
                                <namedplace>
140
                                    <rank>stateProvince</rank>
141
                                    <placename>$StateProvince</placename>
142
                                    <parent_id>
143
                                        <namedplace>
144
                                            <rank>country</rank>
145
                                            <placename>$Country</placename>
146
                                            <parent_id>
147
                                                <namedplace>
148
                                                    <rank>continent</rank>
149
                                                    <placename>$ContinentOcean</placename>
150
                                                </namedplace>
151
                                            </parent_id>
152
                                        </namedplace>
153
                                    </parent_id>
154
                                </namedplace>
155
                            </parent_id>
156
                        </namedplace>
157
                    </path>
158
                </_simplifyPath>
159
            </namedplace_id>
160
        </locationdetermination>
161
        <locationevent>
162
            <obsenddate>
163
                <_date>
164
                    <date>
165
                        <_dateRangeEnd>
166
                            <value>
167
                                <_date>
168
                                    <day>
169
                                        <_nullIf>
170
                                            <null>0</null>
171
                                            <type>float</type>
172
                                            <value>$DayCollected</value>
173
                                        </_nullIf>
174
                                    </day>
175
                                    <month>
176
                                        <_nullIf>
177
                                            <null>0</null>
178
                                            <type>float</type>
179
                                            <value>$MonthCollected</value>
180
                                        </_nullIf>
181
                                    </month>
182
                                    <year>
183
                                        <_nullIf>
184
                                            <null>0</null>
185
                                            <type>float</type>
186
                                            <value>$YearCollected</value>
187
                                        </_nullIf>
188
                                    </year>
189
                                </_date>
190
                            </value>
191
                        </_dateRangeEnd>
192
                    </date>
193
                </_date>
194
            </obsenddate>
195
            <obsstartdate>
196
                <_date>
197
                    <date>
198
                        <_dateRangeStart>
199
                            <value>
200
                                <_date>
201
                                    <day>
202
                                        <_nullIf>
203
                                            <null>0</null>
204
                                            <type>float</type>
205
                                            <value>$DayCollected</value>
206
                                        </_nullIf>
207
                                    </day>
208
                                    <month>
209
                                        <_nullIf>
210
                                            <null>0</null>
211
                                            <type>float</type>
212
                                            <value>$MonthCollected</value>
213
                                        </_nullIf>
214
                                    </month>
215
                                    <year>
216
                                        <_nullIf>
217
                                            <null>0</null>
218
                                            <type>float</type>
219
                                            <value>$YearCollected</value>
220
                                        </_nullIf>
221
                                    </year>
222
                                </_date>
223
                            </value>
224
                        </_dateRangeStart>
225
                    </date>
226
                </_date>
227
            </obsstartdate>
228
            <taxonoccurrence>
229
                <aggregateoccurrence>
230
                    <collectiondate>
231
                        <_date>
232
                            <date>
233
                                <_date>
234
                                    <day>
235
                                        <_nullIf>
236
                                            <null>0</null>
237
                                            <type>float</type>
238
                                            <value>$DayCollected</value>
239
                                        </_nullIf>
240
                                    </day>
241
                                    <month>
242
                                        <_nullIf>
243
                                            <null>0</null>
244
                                            <type>float</type>
245
                                            <value>$MonthCollected</value>
246
                                        </_nullIf>
247
                                    </month>
248
                                    <year>
249
                                        <_nullIf>
250
                                            <null>0</null>
251
                                            <type>float</type>
252
                                            <value>$YearCollected</value>
253
                                        </_nullIf>
254
                                    </year>
255
                                </_date>
256
                            </date>
257
                        </_date>
258
                    </collectiondate>
259
                    <count>$IndividualCount</count>
260
                    <notes>
261
                        <_merge>
262
                            <1>$Notes</1>
263
                            <2>
264
                                <_label>
265
                                    <label>plant fungus</label>
266
                                    <value>$PlantFungusDescription</value>
267
                                </_label>
268
                            </2>
269
                        </_merge>
270
                    </notes>
271
                    <plantobservation>
272
                        <collectionnumber>
273
                            <_alt>
274
                                <1>$CollectorNumber</1>
275
                                <2>$FieldNumber</2>
276
                            </_alt>
277
                        </collectionnumber>
278
                        <definedvalue fkey="tablerecord_id">
279
                            <userdefined_id>
280
                                <userdefined>
281
                                    <tablename>plantobservation</tablename>
282
                                    <userdefinedname>sex</userdefinedname>
283
                                </userdefined>
284
                            </userdefined_id>
285
                            <definedvalue>$Sex</definedvalue>
286
                        </definedvalue>
287
                        <specimenreplicate>
288
                            <catalognumber_dwc>$CatalogNumber</catalognumber_dwc>
289
                            <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
290
                            <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
291
                            <sourceaccessioncode>$UniqueNYInternalRecordNumber</sourceaccessioncode>
292
                        </specimenreplicate>
293
                    </plantobservation>
294
                </aggregateoccurrence>
295
                <authortaxoncode>
296
                    <_alt>
297
                        <1>
298
                            <_alt>
299
                                <1>$CollectorNumber</1>
300
                                <2>$FieldNumber</2>
301
                            </_alt>
302
                        </1>
303
                        <2>$ScientificName</2>
304
                    </_alt>
305
                </authortaxoncode>
306
                <taxondetermination>
307
                    <isoriginal>true</isoriginal>
308
                    <role>identifier</role>
309
                    <party_id>
310
                        <party>
311
                            <givenname><_namePart><first>$IdentifiedBy</first></_namePart></givenname>
312
                            <middlename><_namePart><middle>$IdentifiedBy</middle></_namePart></middlename>
313
                            <surname><_namePart><last>$IdentifiedBy</last></_namePart></surname>
314
                        </party>
315
                    </party_id>
316
                    <plantconcept_id>
317
                        <plantconcept>
318
                            <plantname_id>
319
                                <_simplifyPath>
320
                                    <next>parent_id/plantname</next>
321
                                    <require>plantname</require>
322
                                    <path>
323
                                        <plantname>
324
                                            <rank>binomial</rank>
325
                                            <plantname>$ScientificName</plantname>
326
                                            <parent_id>
327
                                                <plantname>
328
                                                    <rank>authority</rank>
329
                                                    <plantname>$ScientificNameAuthor</plantname>
330
                                                    <parent_id>
331
                                                        <plantname>
332
                                                            <rank>subspecies</rank>
333
                                                            <plantname>$Subspecies</plantname>
334
                                                            <parent_id>
335
                                                                <plantname>
336
                                                                    <rank>species</rank>
337
                                                                    <plantname>$Species</plantname>
338
                                                                    <parent_id>
339
                                                                        <plantname>
340
                                                                            <rank>genus</rank>
341
                                                                            <plantname>$Genus</plantname>
342
                                                                            <parent_id>
343
                                                                                <plantname>
344
                                                                                    <rank>family</rank>
345
                                                                                    <plantname>$Family</plantname>
346
                                                                                    <parent_id>
347
                                                                                        <plantname>
348
                                                                                            <rank>order</rank>
349
                                                                                            <plantname>$Order</plantname>
350
                                                                                            <parent_id>
351
                                                                                                <plantname>
352
                                                                                                    <rank>class</rank>
353
                                                                                                    <plantname>$Class</plantname>
354
                                                                                                    <parent_id>
355
                                                                                                        <plantname>
356
                                                                                                            <rank>subkingdom</rank>
357
                                                                                                            <plantname>$Phylum</plantname>
358
                                                                                                            <parent_id>
359
                                                                                                                <plantname>
360
                                                                                                                    <rank>kingdom</rank>
361
                                                                                                                    <plantname>$Kingdom</plantname>
362
                                                                                                                </plantname>
363
                                                                                                            </parent_id>
364
                                                                                                        </plantname>
365
                                                                                                    </parent_id>
366
                                                                                                </plantname>
367
                                                                                            </parent_id>
368
                                                                                        </plantname>
369
                                                                                    </parent_id>
370
                                                                                </plantname>
371
                                                                            </parent_id>
372
                                                                        </plantname>
373
                                                                    </parent_id>
374
                                                                </plantname>
375
                                                            </parent_id>
376
                                                        </plantname>
377
                                                    </parent_id>
378
                                                </plantname>
379
                                            </parent_id>
380
                                        </plantname>
381
                                    </path>
382
                                </_simplifyPath>
383
                            </plantname_id>
384
                        </plantconcept>
385
                    </plantconcept_id>
386
                    <determinationdate>
387
                        <_date>
388
                            <date>
389
                                <_dateRangeStart>
390
                                    <value>
391
                                        <_date>
392
                                            <day>
393
                                                <_nullIf>
394
                                                    <null>0</null>
395
                                                    <type>float</type>
396
                                                    <value>$DayIdentified</value>
397
                                                </_nullIf>
398
                                            </day>
399
                                            <month>
400
                                                <_nullIf>
401
                                                    <null>0</null>
402
                                                    <type>float</type>
403
                                                    <value>$MonthIdentified</value>
404
                                                </_nullIf>
405
                                            </month>
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff