Revision 3907
Added by Aaron Marcuse-Kubitza over 12 years ago
| import.specimens.xml.ref | ||
|---|---|---|
| 220 | 220 |
</date> |
| 221 | 221 |
</_date> |
| 222 | 222 |
</obsstartdate> |
| 223 |
<specimenreplicate> |
|
| 224 |
<catalognumber_dwc>$CatalogNumberNumeric</catalognumber_dwc> |
|
| 225 |
<collectioncode_dwc>$CollectionCode</collectioncode_dwc> |
|
| 226 |
<collectionnumber> |
|
| 227 |
<_alt> |
|
| 228 |
<1><_alt><1>$CollectorNumber</1></_alt></1> |
|
| 229 |
<3>$FieldNumber</3> |
|
| 230 |
</_alt> |
|
| 231 |
</collectionnumber> |
|
| 232 |
<definedvalue fkey="tablerecord_id"> |
|
| 233 |
<userdefined_id> |
|
| 234 |
<userdefined> |
|
| 235 |
<tablename>specimenreplicate</tablename> |
|
| 236 |
<userdefinedname>sex</userdefinedname> |
|
| 237 |
</userdefined> |
|
| 238 |
</userdefined_id> |
|
| 239 |
<definedvalue>$Sex</definedvalue> |
|
| 240 |
</definedvalue> |
|
| 241 |
<description> |
|
| 242 |
<_merge> |
|
| 243 |
<1>$FieldNotes</1> |
|
| 244 |
<2>$Remarks</2> |
|
| 245 |
</_merge> |
|
| 246 |
</description> |
|
| 247 |
<institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id> |
|
| 248 |
<sourceaccessioncode>$GlobalUniqueIdentifier</sourceaccessioncode> |
|
| 223 |
<taxonoccurrence> |
|
| 224 |
<aggregateoccurrence> |
|
| 225 |
<plantobservation> |
|
| 226 |
<specimenreplicate> |
|
| 227 |
<catalognumber_dwc>$CatalogNumberNumeric</catalognumber_dwc> |
|
| 228 |
<collectioncode_dwc>$CollectionCode</collectioncode_dwc> |
|
| 229 |
<collectionnumber> |
|
| 230 |
<_alt> |
|
| 231 |
<1><_alt><1>$CollectorNumber</1></_alt></1> |
|
| 232 |
<3>$FieldNumber</3> |
|
| 233 |
</_alt> |
|
| 234 |
</collectionnumber> |
|
| 235 |
<definedvalue fkey="tablerecord_id"> |
|
| 236 |
<userdefined_id> |
|
| 237 |
<userdefined> |
|
| 238 |
<tablename>specimenreplicate</tablename> |
|
| 239 |
<userdefinedname>sex</userdefinedname> |
|
| 240 |
</userdefined> |
|
| 241 |
</userdefined_id> |
|
| 242 |
<definedvalue>$Sex</definedvalue> |
|
| 243 |
</definedvalue> |
|
| 244 |
<description> |
|
| 245 |
<_merge> |
|
| 246 |
<1>$FieldNotes</1> |
|
| 247 |
<2>$Remarks</2> |
|
| 248 |
</_merge> |
|
| 249 |
</description> |
|
| 250 |
<institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id> |
|
| 251 |
<sourceaccessioncode>$GlobalUniqueIdentifier</sourceaccessioncode> |
|
| 252 |
<verbatimcollectorname>$Collector</verbatimcollectorname> |
|
| 253 |
</specimenreplicate> |
|
| 254 |
</plantobservation> |
|
| 255 |
</aggregateoccurrence> |
|
| 249 | 256 |
<taxondetermination> |
| 250 | 257 |
<role>identifier</role> |
| 251 | 258 |
<determinationdate> |
| ... | ... | |
| 369 | 376 |
</plantconcept> |
| 370 | 377 |
</plantconcept_id> |
| 371 | 378 |
</taxondetermination> |
| 372 |
<verbatimcollectorname>$Collector</verbatimcollectorname> |
|
| 373 |
</specimenreplicate> |
|
| 379 |
</taxonoccurrence> |
|
| 374 | 380 |
<waterdepth> |
| 375 | 381 |
<_avg> |
| 376 | 382 |
<max> |
| ... | ... | |
| 407 | 413 |
</sourceaccessioncode> |
| 408 | 414 |
</location> |
| 409 | 415 |
</VegBIEN> |
| 410 |
Inserted 32 new rows into database |
|
| 416 |
Inserted 38 new rows into database |
|
Also available in: Unified diff
mappings/DwC2-VegBIEN.specimens.csv: Mapped specimenreplicate via plantobservation for consistency with plots data. (This change is required for VegCSV table merging to work properly.) This is also a more accurate way of representing the data, because a specimen in fact comes from a plant, and it's natural to place the plant-related data (measurements, etc.) in the plantobservation table.