Revision 3907
Added by Aaron Marcuse-Kubitza over 12 years ago
| import.specimens.xml.ref | ||
|---|---|---|
| 223 | 223 |
</date> |
| 224 | 224 |
</_date> |
| 225 | 225 |
</obsstartdate> |
| 226 |
<specimenreplicate> |
|
| 227 |
<catalognumber_dwc>$CatalogNumber</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> |
|
| 247 |
<_merge> |
|
| 248 |
<1>$Notes</1> |
|
| 249 |
<2> |
|
| 250 |
<_label> |
|
| 251 |
<label>plant fungus</label> |
|
| 252 |
<value>$PlantFungusDescription</value> |
|
| 253 |
</_label> |
|
| 254 |
</2> |
|
| 255 |
</_merge> |
|
| 256 |
</1> |
|
| 257 |
</_merge> |
|
| 258 |
</description> |
|
| 259 |
<institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id> |
|
| 260 |
<sourceaccessioncode>$UniqueNYInternalRecordNumber</sourceaccessioncode> |
|
| 226 |
<taxonoccurrence> |
|
| 227 |
<aggregateoccurrence> |
|
| 228 |
<plantobservation> |
|
| 229 |
<specimenreplicate> |
|
| 230 |
<catalognumber_dwc>$CatalogNumber</catalognumber_dwc> |
|
| 231 |
<collectioncode_dwc>$CollectionCode</collectioncode_dwc> |
|
| 232 |
<collectionnumber> |
|
| 233 |
<_alt> |
|
| 234 |
<1><_alt><1>$CollectorNumber</1></_alt></1> |
|
| 235 |
<3>$FieldNumber</3> |
|
| 236 |
</_alt> |
|
| 237 |
</collectionnumber> |
|
| 238 |
<definedvalue fkey="tablerecord_id"> |
|
| 239 |
<userdefined_id> |
|
| 240 |
<userdefined> |
|
| 241 |
<tablename>specimenreplicate</tablename> |
|
| 242 |
<userdefinedname>sex</userdefinedname> |
|
| 243 |
</userdefined> |
|
| 244 |
</userdefined_id> |
|
| 245 |
<definedvalue>$Sex</definedvalue> |
|
| 246 |
</definedvalue> |
|
| 247 |
<description> |
|
| 248 |
<_merge> |
|
| 249 |
<1> |
|
| 250 |
<_merge> |
|
| 251 |
<1>$Notes</1> |
|
| 252 |
<2> |
|
| 253 |
<_label> |
|
| 254 |
<label>plant fungus</label> |
|
| 255 |
<value>$PlantFungusDescription</value> |
|
| 256 |
</_label> |
|
| 257 |
</2> |
|
| 258 |
</_merge> |
|
| 259 |
</1> |
|
| 260 |
</_merge> |
|
| 261 |
</description> |
|
| 262 |
<institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id> |
|
| 263 |
<sourceaccessioncode>$UniqueNYInternalRecordNumber</sourceaccessioncode> |
|
| 264 |
<verbatimcollectorname>$Collector</verbatimcollectorname> |
|
| 265 |
</specimenreplicate> |
|
| 266 |
</plantobservation> |
|
| 267 |
</aggregateoccurrence> |
|
| 261 | 268 |
<taxondetermination> |
| 262 | 269 |
<role>identifier</role> |
| 263 | 270 |
<determinationdate> |
| ... | ... | |
| 377 | 384 |
</plantconcept> |
| 378 | 385 |
</plantconcept_id> |
| 379 | 386 |
</taxondetermination> |
| 380 |
<verbatimcollectorname>$Collector</verbatimcollectorname> |
|
| 381 |
</specimenreplicate> |
|
| 387 |
</taxonoccurrence> |
|
| 382 | 388 |
<waterdepth> |
| 383 | 389 |
<_avg> |
| 384 | 390 |
<max> |
| ... | ... | |
| 441 | 447 |
</sourceaccessioncode> |
| 442 | 448 |
</location> |
| 443 | 449 |
</VegBIEN> |
| 444 |
Inserted 33 new rows into database |
|
| 450 |
Inserted 39 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.