Revision 4043
Added by Aaron Marcuse-Kubitza about 12 years ago
| import.specimens.xml.ref | ||
|---|---|---|
| 9 | 9 |
</_merge> |
| 10 | 10 |
</authorlocationcode> |
| 11 | 11 |
<elevation> |
| 12 |
<_alt> |
|
| 13 |
<2> |
|
| 14 |
<_avg> |
|
| 15 |
<max> |
|
| 16 |
<_units> |
|
| 17 |
<default>m</default> |
|
| 18 |
<to>m</to> |
|
| 19 |
<to></to> |
|
| 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> |
|
| 20 | 33 |
<value> |
| 21 | 34 |
<_replace> |
| 22 | 35 |
<\bca\.?></\bca\.?> |
| 23 |
<value>$MaximumElevation</value>
|
|
| 36 |
<value>$MinimumElevation</value>
|
|
| 24 | 37 |
</_replace> |
| 25 | 38 |
</value> |
| 26 |
</_units> |
|
| 27 |
</max> |
|
| 28 |
<min> |
|
| 29 |
<_units> |
|
| 30 |
<default>m</default> |
|
| 31 |
<to>m</to> |
|
| 32 |
<to></to> |
|
| 33 |
<value> |
|
| 34 |
<_rangeStart> |
|
| 35 |
<value> |
|
| 36 |
<_replace> |
|
| 37 |
<\bca\.?></\bca\.?> |
|
| 38 |
<value>$MinimumElevation</value> |
|
| 39 |
</_replace> |
|
| 40 |
</value> |
|
| 41 |
</_rangeStart> |
|
| 42 |
</value> |
|
| 43 |
</_units> |
|
| 44 |
</min> |
|
| 45 |
</_avg> |
|
| 46 |
</2> |
|
| 47 |
</_alt> |
|
| 39 |
</_rangeStart> |
|
| 40 |
</value> |
|
| 41 |
</_units> |
|
| 42 |
</min> |
|
| 43 |
</_avg> |
|
| 48 | 44 |
</elevation> |
| 49 | 45 |
<elevationrange> |
| 50 | 46 |
<_range> |
| ... | ... | |
| 95 | 91 |
</_range> |
| 96 | 92 |
</elevationrange> |
| 97 | 93 |
<locationdetermination> |
| 98 |
<coordsaccuracy><_noCV><value><_alt><2>$CoordinatePrecision</2></_alt></value></_noCV></coordsaccuracy>
|
|
| 94 |
<coordsaccuracy><_noCV><value>$CoordinatePrecision</value></_noCV></coordsaccuracy>
|
|
| 99 | 95 |
<latitude> |
| 100 |
<_alt> |
|
| 101 |
<2> |
|
| 102 |
<_nullIf> |
|
| 103 |
<null>0</null> |
|
| 104 |
<type>float</type> |
|
| 105 |
<value>$Latitude</value> |
|
| 106 |
</_nullIf> |
|
| 107 |
</2> |
|
| 108 |
</_alt> |
|
| 96 |
<_nullIf> |
|
| 97 |
<null>0</null> |
|
| 98 |
<type>float</type> |
|
| 99 |
<value>$Latitude</value> |
|
| 100 |
</_nullIf> |
|
| 109 | 101 |
</latitude> |
| 110 | 102 |
<longitude> |
| 111 |
<_alt> |
|
| 112 |
<2> |
|
| 113 |
<_nullIf> |
|
| 114 |
<null>0</null> |
|
| 115 |
<type>float</type> |
|
| 116 |
<value>$Longitude</value> |
|
| 117 |
</_nullIf> |
|
| 118 |
</2> |
|
| 119 |
</_alt> |
|
| 103 |
<_nullIf> |
|
| 104 |
<null>0</null> |
|
| 105 |
<type>float</type> |
|
| 106 |
<value>$Longitude</value> |
|
| 107 |
</_nullIf> |
|
| 120 | 108 |
</longitude> |
| 121 | 109 |
<namedplace_id> |
| 122 | 110 |
<_simplifyPath> |
| ... | ... | |
| 156 | 144 |
<date> |
| 157 | 145 |
<_dateRangeEnd> |
| 158 | 146 |
<value> |
| 159 |
<_alt> |
|
| 160 |
<1> |
|
| 161 |
<_date> |
|
| 162 |
<day> |
|
| 163 |
<_nullIf> |
|
| 164 |
<null>0</null> |
|
| 165 |
<type>float</type> |
|
| 166 |
<value>$DayCollected</value> |
|
| 167 |
</_nullIf> |
|
| 168 |
</day> |
|
| 169 |
<month> |
|
| 170 |
<_nullIf> |
|
| 171 |
<null>0</null> |
|
| 172 |
<type>float</type> |
|
| 173 |
<value>$MonthCollected</value> |
|
| 174 |
</_nullIf> |
|
| 175 |
</month> |
|
| 176 |
<year> |
|
| 177 |
<_nullIf> |
|
| 178 |
<null>0</null> |
|
| 179 |
<type>float</type> |
|
| 180 |
<value>$YearCollected</value> |
|
| 181 |
</_nullIf> |
|
| 182 |
</year> |
|
| 183 |
</_date> |
|
| 184 |
</1> |
|
| 185 |
</_alt> |
|
| 147 |
<_date> |
|
| 148 |
<day> |
|
| 149 |
<_nullIf> |
|
| 150 |
<null>0</null> |
|
| 151 |
<type>float</type> |
|
| 152 |
<value>$DayCollected</value> |
|
| 153 |
</_nullIf> |
|
| 154 |
</day> |
|
| 155 |
<month> |
|
| 156 |
<_nullIf> |
|
| 157 |
<null>0</null> |
|
| 158 |
<type>float</type> |
|
| 159 |
<value>$MonthCollected</value> |
|
| 160 |
</_nullIf> |
|
| 161 |
</month> |
|
| 162 |
<year> |
|
| 163 |
<_nullIf> |
|
| 164 |
<null>0</null> |
|
| 165 |
<type>float</type> |
|
| 166 |
<value>$YearCollected</value> |
|
| 167 |
</_nullIf> |
|
| 168 |
</year> |
|
| 169 |
</_date> |
|
| 186 | 170 |
</value> |
| 187 | 171 |
</_dateRangeEnd> |
| 188 | 172 |
</date> |
| ... | ... | |
| 193 | 177 |
<date> |
| 194 | 178 |
<_dateRangeStart> |
| 195 | 179 |
<value> |
| 196 |
<_alt> |
|
| 197 |
<1> |
|
| 198 |
<_date> |
|
| 199 |
<day> |
|
| 200 |
<_nullIf> |
|
| 201 |
<null>0</null> |
|
| 202 |
<type>float</type> |
|
| 203 |
<value>$DayCollected</value> |
|
| 204 |
</_nullIf> |
|
| 205 |
</day> |
|
| 206 |
<month> |
|
| 207 |
<_nullIf> |
|
| 208 |
<null>0</null> |
|
| 209 |
<type>float</type> |
|
| 210 |
<value>$MonthCollected</value> |
|
| 211 |
</_nullIf> |
|
| 212 |
</month> |
|
| 213 |
<year> |
|
| 214 |
<_nullIf> |
|
| 215 |
<null>0</null> |
|
| 216 |
<type>float</type> |
|
| 217 |
<value>$YearCollected</value> |
|
| 218 |
</_nullIf> |
|
| 219 |
</year> |
|
| 220 |
</_date> |
|
| 221 |
</1> |
|
| 222 |
</_alt> |
|
| 180 |
<_date> |
|
| 181 |
<day> |
|
| 182 |
<_nullIf> |
|
| 183 |
<null>0</null> |
|
| 184 |
<type>float</type> |
|
| 185 |
<value>$DayCollected</value> |
|
| 186 |
</_nullIf> |
|
| 187 |
</day> |
|
| 188 |
<month> |
|
| 189 |
<_nullIf> |
|
| 190 |
<null>0</null> |
|
| 191 |
<type>float</type> |
|
| 192 |
<value>$MonthCollected</value> |
|
| 193 |
</_nullIf> |
|
| 194 |
</month> |
|
| 195 |
<year> |
|
| 196 |
<_nullIf> |
|
| 197 |
<null>0</null> |
|
| 198 |
<type>float</type> |
|
| 199 |
<value>$YearCollected</value> |
|
| 200 |
</_nullIf> |
|
| 201 |
</year> |
|
| 202 |
</_date> |
|
| 223 | 203 |
</value> |
| 224 | 204 |
</_dateRangeStart> |
| 225 | 205 |
</date> |
| ... | ... | |
| 230 | 210 |
<collectiondate> |
| 231 | 211 |
<_date> |
| 232 | 212 |
<date> |
| 233 |
<_alt> |
|
| 234 |
<1> |
|
| 235 |
<_date> |
|
| 236 |
<day> |
|
| 237 |
<_nullIf> |
|
| 238 |
<null>0</null> |
|
| 239 |
<type>float</type> |
|
| 240 |
<value>$DayCollected</value> |
|
| 241 |
</_nullIf> |
|
| 242 |
</day> |
|
| 243 |
<month> |
|
| 244 |
<_nullIf> |
|
| 245 |
<null>0</null> |
|
| 246 |
<type>float</type> |
|
| 247 |
<value>$MonthCollected</value> |
|
| 248 |
</_nullIf> |
|
| 249 |
</month> |
|
| 250 |
<year> |
|
| 251 |
<_nullIf> |
|
| 252 |
<null>0</null> |
|
| 253 |
<type>float</type> |
|
| 254 |
<value>$YearCollected</value> |
|
| 255 |
</_nullIf> |
|
| 256 |
</year> |
|
| 257 |
</_date> |
|
| 258 |
</1> |
|
| 259 |
</_alt> |
|
| 213 |
<_date> |
|
| 214 |
<day> |
|
| 215 |
<_nullIf> |
|
| 216 |
<null>0</null> |
|
| 217 |
<type>float</type> |
|
| 218 |
<value>$DayCollected</value> |
|
| 219 |
</_nullIf> |
|
| 220 |
</day> |
|
| 221 |
<month> |
|
| 222 |
<_nullIf> |
|
| 223 |
<null>0</null> |
|
| 224 |
<type>float</type> |
|
| 225 |
<value>$MonthCollected</value> |
|
| 226 |
</_nullIf> |
|
| 227 |
</month> |
|
| 228 |
<year> |
|
| 229 |
<_nullIf> |
|
| 230 |
<null>0</null> |
|
| 231 |
<type>float</type> |
|
| 232 |
<value>$YearCollected</value> |
|
| 233 |
</_nullIf> |
|
| 234 |
</year> |
|
| 235 |
</_date> |
|
| 260 | 236 |
</date> |
| 261 | 237 |
</_date> |
| 262 | 238 |
</collectiondate> |
| 263 | 239 |
<count>$IndividualCount</count> |
| 264 | 240 |
<notes>$Notes</notes> |
| 265 | 241 |
<plantobservation> |
| 266 |
<authorplantcode><_alt><1>$CollectorNumber</1></_alt></authorplantcode>
|
|
| 242 |
<authorplantcode>$CollectorNumber</authorplantcode>
|
|
| 267 | 243 |
<definedvalue fkey="tablerecord_id"> |
| 268 | 244 |
<userdefined_id> |
| 269 | 245 |
<userdefined> |
| ... | ... | |
| 275 | 251 |
</definedvalue> |
| 276 | 252 |
<specimenreplicate> |
| 277 | 253 |
<_if name="if indirect voucher"><else><catalognumber_dwc>$CatalogNumber</catalognumber_dwc></else></_if> |
| 278 |
<collectioncode_dwc><_alt><1>$CollectionCode</1></_alt></collectioncode_dwc>
|
|
| 279 |
<collectionnumber><_alt><1>$CollectorNumber</1></_alt></collectionnumber>
|
|
| 254 |
<collectioncode_dwc>$CollectionCode</collectioncode_dwc>
|
|
| 255 |
<collectionnumber>$CollectorNumber</collectionnumber>
|
|
| 280 | 256 |
<institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id> |
| 281 | 257 |
</specimenreplicate> |
| 282 | 258 |
</plantobservation> |
| 283 | 259 |
</aggregateoccurrence> |
| 284 |
<sourceaccessioncode><_alt><2><_alt><1>$CollectorNumber</1></_alt></2></_alt></sourceaccessioncode>
|
|
| 260 |
<sourceaccessioncode>$CollectorNumber</sourceaccessioncode>
|
|
| 285 | 261 |
<taxondetermination> |
| 286 | 262 |
<isoriginal>true</isoriginal> |
| 287 | 263 |
<role>identifier</role> |
| ... | ... | |
| 367 | 343 |
<date> |
| 368 | 344 |
<_dateRangeStart> |
| 369 | 345 |
<value> |
| 370 |
<_alt> |
|
| 371 |
<1> |
|
| 372 |
<_date> |
|
| 373 |
<day> |
|
| 374 |
<_nullIf> |
|
| 375 |
<null>0</null> |
|
| 376 |
<type>float</type> |
|
| 377 |
<value>$DayIdentified</value> |
|
| 378 |
</_nullIf> |
|
| 379 |
</day> |
|
| 380 |
<month> |
|
| 381 |
<_nullIf> |
|
| 382 |
<null>0</null> |
|
| 383 |
<type>float</type> |
|
| 384 |
<value>$MonthIdentified</value> |
|
| 385 |
</_nullIf> |
|
| 386 |
</month> |
|
| 387 |
<year> |
|
| 388 |
<_nullIf> |
|
| 389 |
<null>0</null> |
|
| 390 |
<type>float</type> |
|
| 391 |
<value>$YearIdentified</value> |
|
| 392 |
</_nullIf> |
|
| 393 |
</year> |
|
| 394 |
</_date> |
|
| 395 |
</1> |
|
| 396 |
</_alt> |
|
| 346 |
<_date> |
|
| 347 |
<day> |
|
| 348 |
<_nullIf> |
|
| 349 |
<null>0</null> |
|
| 350 |
<type>float</type> |
|
| 351 |
<value>$DayIdentified</value> |
|
| 352 |
</_nullIf> |
|
| 353 |
</day> |
|
| 354 |
<month> |
|
| 355 |
<_nullIf> |
|
| 356 |
<null>0</null> |
|
| 357 |
<type>float</type> |
|
| 358 |
<value>$MonthIdentified</value> |
|
| 359 |
</_nullIf> |
|
| 360 |
</month> |
|
| 361 |
<year> |
|
| 362 |
<_nullIf> |
|
| 363 |
<null>0</null> |
|
| 364 |
<type>float</type> |
|
| 365 |
<value>$YearIdentified</value> |
|
| 366 |
</_nullIf> |
|
| 367 |
</year> |
|
| 368 |
</_date> |
|
| 397 | 369 |
</value> |
| 398 | 370 |
</_dateRangeStart> |
| 399 | 371 |
</date> |
| ... | ... | |
| 433 | 405 |
</_avg> |
| 434 | 406 |
</waterdepth> |
| 435 | 407 |
</locationevent> |
| 436 |
<locationnarrative><_merge><1>$Locality</1></_merge></locationnarrative>
|
|
| 408 |
<locationnarrative>$Locality</locationnarrative>
|
|
| 437 | 409 |
</location> |
| 438 | 410 |
</VegBIEN> |
| 439 | 411 |
Inserted 47 new rows into database |
Also available in: Unified diff
mappings/DwC2-VegBIEN.specimens.csv, DwC1-DwC2.specimens.csv: Split eventDate into eventDate and dateCollected, where eventDate refers only to the date of the sampling event, but dateCollected also refers to the date the particular specimen was collected. (This distinction is important in merging with VegCSV, because in plots data, these two fields are distinct.) Remapped datasources with dateCollected-related fields to new dateCollected.