Revision 4244
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/SALVIAS-CSV/1.organisms/VegBIEN.csv | ||
|---|---|---|
| 54 | 54 |
coll_number,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then/_alt/1",Brad: Map instead as for voucher_string |
| 55 | 55 |
voucher_string,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then/_alt/2","Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below." |
| 56 | 56 |
plot_code,/location/parent_id/location/authorlocationcode, |
| 57 |
subplot,"/location/parent_id/location/authorlocationcode/_if[@name=""if subplot""]/cond", |
|
| 57 |
subplot,"/location/parent_id/location/authorlocationcode/_if[@name=""if subplot""]/cond/_exists",
|
|
| 58 | 58 |
PLOT_ID,/location/parent_id/location/sourceaccessioncode, |
| 59 |
subplot,"/location/parent_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond", |
|
| 60 |
subplot,"/location/sourceaccessioncode/_if[@name=""if subplot""]/cond", |
|
| 59 |
subplot,"/location/parent_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_exists", |
|
| 60 |
subplot,"/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_exists", |
|
| inputs/SALVIAS/1.organisms/VegBIEN.csv | ||
|---|---|---|
| 58 | 58 |
coll_number,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then/_alt/1",Brad: Map instead as for voucher_string |
| 59 | 59 |
SourceVoucher,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then/_alt/2","Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below." |
| 60 | 60 |
PlotCode,/location/parent_id/location/authorlocationcode, |
| 61 |
Line,"/location/parent_id/location/authorlocationcode/_if[@name=""if subplot""]/cond", |
|
| 61 |
Line,"/location/parent_id/location/authorlocationcode/_if[@name=""if subplot""]/cond/_exists",
|
|
| 62 | 62 |
PlotID,/location/parent_id/location/sourceaccessioncode, |
| 63 |
Line,"/location/parent_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond", |
|
| 64 |
Line,"/location/sourceaccessioncode/_if[@name=""if subplot""]/cond", |
|
| 63 |
Line,"/location/parent_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_exists", |
|
| 64 |
Line,"/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_exists", |
|
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 134 | 134 |
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?" |
| 135 | 135 |
plotNotes,/location/notespublic, |
| 136 | 136 |
parentPlotName,/location/parent_id/location/authorlocationcode, |
| 137 |
subplot,"/location/parent_id/location/authorlocationcode/_if[@name=""if subplot""]/cond", |
|
| 137 |
subplot,"/location/parent_id/location/authorlocationcode/_if[@name=""if subplot""]/cond/_exists",
|
|
| 138 | 138 |
plotName,"/location/parent_id/location/authorlocationcode/_if[@name=""if subplot""]/then", |
| 139 | 139 |
parentLocationID,/location/parent_id/location/sourceaccessioncode, |
| 140 |
subplot,"/location/parent_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond", |
|
| 140 |
subplot,"/location/parent_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_exists",
|
|
| 141 | 141 |
locationID,"/location/parent_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then", |
| 142 | 142 |
slopeAspect,/location/slopeaspect/_compass/value, |
| 143 | 143 |
slopeGradient,/location/slopegradient, |
| 144 |
subplot,"/location/sourceaccessioncode/_if[@name=""if subplot""]/cond", |
|
| 144 |
subplot,"/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_exists",
|
|
| 145 | 145 |
locationID,"/location/sourceaccessioncode/_if[@name=""if subplot""]/else", |
| 146 | 146 |
acceptedNameUsage,, |
| 147 | 147 |
acceptedNameUsageID,, |
| mappings/Veg+-VegBIEN.csv | ||
|---|---|---|
| 383 | 383 |
plotNotes,/location/notespublic, |
| 384 | 384 |
ParentPlotName,/location/parent_id/location/authorlocationcode, |
| 385 | 385 |
parentPlotName,/location/parent_id/location/authorlocationcode, |
| 386 |
Subplot,"/location/parent_id/location/authorlocationcode/_if[@name=""if subplot""]/cond", |
|
| 387 |
subplot,"/location/parent_id/location/authorlocationcode/_if[@name=""if subplot""]/cond", |
|
| 386 |
Subplot,"/location/parent_id/location/authorlocationcode/_if[@name=""if subplot""]/cond/_exists",
|
|
| 387 |
subplot,"/location/parent_id/location/authorlocationcode/_if[@name=""if subplot""]/cond/_exists",
|
|
| 388 | 388 |
PlotName,"/location/parent_id/location/authorlocationcode/_if[@name=""if subplot""]/then", |
| 389 | 389 |
plotName,"/location/parent_id/location/authorlocationcode/_if[@name=""if subplot""]/then", |
| 390 | 390 |
ParentLocationID,/location/parent_id/location/sourceaccessioncode, |
| 391 | 391 |
ParentPlotID,/location/parent_id/location/sourceaccessioncode, |
| 392 | 392 |
parentLocationID,/location/parent_id/location/sourceaccessioncode, |
| 393 | 393 |
parentPlotID,/location/parent_id/location/sourceaccessioncode, |
| 394 |
Subplot,"/location/parent_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond", |
|
| 395 |
subplot,"/location/parent_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond", |
|
| 394 |
Subplot,"/location/parent_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_exists",
|
|
| 395 |
subplot,"/location/parent_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_exists",
|
|
| 396 | 396 |
LocationID,"/location/parent_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then", |
| 397 | 397 |
PlotID,"/location/parent_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then", |
| 398 | 398 |
locationID,"/location/parent_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then", |
| ... | ... | |
| 401 | 401 |
slopeAspect,/location/slopeaspect/_compass/value, |
| 402 | 402 |
SlopeGradient,/location/slopegradient, |
| 403 | 403 |
slopeGradient,/location/slopegradient, |
| 404 |
Subplot,"/location/sourceaccessioncode/_if[@name=""if subplot""]/cond", |
|
| 405 |
subplot,"/location/sourceaccessioncode/_if[@name=""if subplot""]/cond", |
|
| 404 |
Subplot,"/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_exists",
|
|
| 405 |
subplot,"/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_exists",
|
|
| 406 | 406 |
LocationID,"/location/sourceaccessioncode/_if[@name=""if subplot""]/else", |
| 407 | 407 |
PlotID,"/location/sourceaccessioncode/_if[@name=""if subplot""]/else", |
| 408 | 408 |
locationID,"/location/sourceaccessioncode/_if[@name=""if subplot""]/else", |
| mappings/Veg+.cs-VegBIEN.csv | ||
|---|---|---|
| 191 | 191 |
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?" |
| 192 | 192 |
plotNotes,/location/notespublic, |
| 193 | 193 |
parentPlotName,/location/parent_id/location/authorlocationcode, |
| 194 |
subplot,"/location/parent_id/location/authorlocationcode/_if[@name=""if subplot""]/cond", |
|
| 194 |
subplot,"/location/parent_id/location/authorlocationcode/_if[@name=""if subplot""]/cond/_exists",
|
|
| 195 | 195 |
plotName,"/location/parent_id/location/authorlocationcode/_if[@name=""if subplot""]/then", |
| 196 | 196 |
parentLocationID,/location/parent_id/location/sourceaccessioncode, |
| 197 | 197 |
parentPlotID,/location/parent_id/location/sourceaccessioncode, |
| 198 |
subplot,"/location/parent_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond", |
|
| 198 |
subplot,"/location/parent_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_exists",
|
|
| 199 | 199 |
locationID,"/location/parent_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then", |
| 200 | 200 |
plotID,"/location/parent_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then", |
| 201 | 201 |
slopeAspect,/location/slopeaspect/_compass/value, |
| 202 | 202 |
slopeGradient,/location/slopegradient, |
| 203 |
subplot,"/location/sourceaccessioncode/_if[@name=""if subplot""]/cond", |
|
| 203 |
subplot,"/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_exists",
|
|
| 204 | 204 |
locationID,"/location/sourceaccessioncode/_if[@name=""if subplot""]/else", |
| 205 | 205 |
plotID,"/location/sourceaccessioncode/_if[@name=""if subplot""]/else", |
| mappings/for_review/VegCore-VegBIEN.csv | ||
|---|---|---|
| 134 | 134 |
habitat,"//location/locationnarrative/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?" |
| 135 | 135 |
plotNotes,//location/notespublic, |
| 136 | 136 |
parentPlotName,//location/authorlocationcode, |
| 137 |
subplot,"//location/authorlocationcode/_if[@name=""if subplot""]/cond", |
|
| 137 |
subplot,"//location/authorlocationcode/_if[@name=""if subplot""]/cond/_exists",
|
|
| 138 | 138 |
plotName,"//location/authorlocationcode/_if[@name=""if subplot""]/then", |
| 139 | 139 |
parentLocationID,//location/sourceaccessioncode, |
| 140 |
subplot,"//location/sourceaccessioncode/_if[@name=""if subplot""]/cond", |
|
| 140 |
subplot,"//location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_exists",
|
|
| 141 | 141 |
locationID,"//location/sourceaccessioncode/_if[@name=""if subplot""]/then", |
| 142 | 142 |
slopeAspect,//location/slopeaspect, |
| 143 | 143 |
slopeGradient,//location/slopegradient, |
| 144 |
subplot,"//location/sourceaccessioncode/_if[@name=""if subplot""]/cond", |
|
| 144 |
subplot,"//location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_exists",
|
|
| 145 | 145 |
locationID,"//location/sourceaccessioncode/_if[@name=""if subplot""]/else", |
| 146 | 146 |
acceptedNameUsage,, |
| 147 | 147 |
acceptedNameUsageID,, |
Also available in: Unified diff
mappings/VegCore-VegBIEN.csv: Fixed bug where "if subplot" conditions would evaluate to true only if the subplot was NOT NULL, when they should actually evaluate to true if the datasource specified any subplot column, nullable or not