Revision 7873
Added by Aaron Marcuse-Kubitza almost 12 years ago
| inputs/UNCC/Specimen/map.csv | ||
|---|---|---|
| 44 | 44 |
sheetno,associatedMedia,,? |
| 45 | 45 |
cultivated,cultivated,/_alt/1/_map:[*=true]/value,"For our purposes, anything non-NULL should be assumed to be cultivated" |
| 46 | 46 |
filler,*filler,,"Where used, same as family" |
| 47 |
:UNCC,specimenHolderInstitutions,, |
|
| inputs/UNCC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 8 | 8 |
GROUP BY herbarium, accession |
| 9 | 9 |
HAVING count(*) > 1 |
| 10 | 10 |
-----" |
| 11 |
:UNCC,"/_if[@name=""if specimen""]/else/source/shortname/_first/1", |
|
| 11 | 12 |
accession,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists","Globally unique, although occasionally duplicated. [1] |
| 12 | 13 |
|
| 13 | 14 |
[1] Using the following query: |
| ... | ... | |
| 26 | 27 |
GROUP BY herbarium, accession |
| 27 | 28 |
HAVING count(*) > 1 |
| 28 | 29 |
-----" |
| 30 |
:UNCC,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then/_first/2", |
|
| 29 | 31 |
accession,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else","Globally unique, although occasionally duplicated. [1] |
| 30 | 32 |
|
| 31 | 33 |
[1] Using the following query: |
| ... | ... | |
| 71 | 73 |
GROUP BY herbarium, accession |
| 72 | 74 |
HAVING count(*) > 1 |
| 73 | 75 |
-----" |
| 76 |
:UNCC,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name/_first/2", |
|
| 77 |
:UNCC,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_first/2/_split:[separator=""[,;] *""]/value", |
|
| 74 | 78 |
collectno,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3", |
| 75 | 79 |
SciName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3", |
| 76 | 80 |
collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join/1, |
| inputs/UNCC/Specimen/test.xml.ref | ||
|---|---|---|
| 7 | 7 |
<next>parent_id</next> |
| 8 | 8 |
<path> |
| 9 | 9 |
<location> |
| 10 |
<authorlocationcode>$accession</authorlocationcode> |
|
| 10 |
<authorlocationcode> |
|
| 11 |
<_join> |
|
| 12 |
<1>UNCC</1> |
|
| 13 |
<3>$accession</3> |
|
| 14 |
</_join> |
|
| 15 |
</authorlocationcode> |
|
| 11 | 16 |
<iscultivated> |
| 12 | 17 |
<_locationnarrative_is_cultivated> |
| 13 | 18 |
<locationnarrative> |
| ... | ... | |
| 91 | 96 |
<specimenreplicate> |
| 92 | 97 |
<catalognumber_dwc>$accession</catalognumber_dwc> |
| 93 | 98 |
<collectionnumber>$collectno</collectionnumber> |
| 99 |
<institution_id> |
|
| 100 |
<sourcelist> |
|
| 101 |
<name>UNCC</name> |
|
| 102 |
<sourcename> |
|
| 103 |
<name> |
|
| 104 |
<_split> |
|
| 105 |
<separator>[,;] *</separator> |
|
| 106 |
<value>UNCC</value> |
|
| 107 |
</_split> |
|
| 108 |
</name> |
|
| 109 |
</sourcename> |
|
| 110 |
</sourcelist> |
|
| 111 |
</institution_id> |
|
| 94 | 112 |
</specimenreplicate> |
| 95 | 113 |
</plantobservation> |
| 96 | 114 |
</aggregateoccurrence> |
| ... | ... | |
| 271 | 289 |
</path> |
| 272 | 290 |
</_setDefault> |
| 273 | 291 |
</VegBIEN> |
| 274 |
Inserted 24 new rows into database |
|
| 292 |
Inserted 26 new rows into database |
|
Also available in: Unified diff
inputs/UNCC/Specimen/map.csv: Populated specimenHolderInstitutions