Revision 3221
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/SALVIAS-CSV/test/import.plots.out.ref | ||
|---|---|---|
| 1 |
Inserted 14 new rows into database |
|
| 1 |
Inserted 16 new rows into database |
|
| inputs/SALVIAS-CSV/maps/VegBIEN.plots.csv | ||
|---|---|---|
| 14 | 14 |
long_decimal,"/*_id/location/{locationdetermination/longitude,centerlongitude}",
|
| 15 | 15 |
plot_methodology,/*_id/method/name, |
| 16 | 16 |
project,/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/projectname, |
| 17 |
holdridge_life_zone,"/_collapse:[require=""commdetermination/*_id/commconcept/*_id/*/commname""]/value/commclass/commdetermination/*_id/commconcept/*_id/*/commname",
|
|
| 18 |
life_zone_code,"/_collapse:[require=""commdetermination/*_id/commconcept/*_id/*/commname""]/value/commclass/commdetermination/*_id/commconcept/commdescription",
|
|
| 17 |
holdridge_life_zone,/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
|
|
| 18 |
life_zone_code,/commclass/commdetermination/*_id/commconcept/commdescription,
|
|
| 19 | 19 |
date_finish,/obsenddate/_*/date, |
| 20 | 20 |
date_start,/obsstartdate/_*/date, |
| 21 | 21 |
precip_mm,/precipitation, |
| inputs/CTFS/maps/VegBIEN.organisms.csv | ||
|---|---|---|
| 17 | 17 |
/*ID->/*s/plotObservation/simpleUserdefined[name=method]/*ID/method/name,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/method/name, |
| 18 | 18 |
/*ID->/*s/plotObservation/*ID->/*s/project/personnel[role=metadataProvider]/organizationName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1, |
| 19 | 19 |
/*ID->/*s/plotObservation/*ID->/*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/projectname, |
| 20 |
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/_collapse:[require=""commdetermination/*_id/commconcept/*_id/*/commname""]/value/commclass/commdetermination/*_id/commconcept/*_id/*/commname",
|
|
| 21 |
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/name,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/_collapse:[require=""commdetermination/*_id/commconcept/*_id/*/commname""]/value/commclass/commdetermination/*_id/commconcept/commdescription",
|
|
| 20 |
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
|
|
| 21 |
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/name,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
|
|
| 22 | 22 |
/*ID->/*s/plotObservation/obsEndDate,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/obsenddate, |
| 23 | 23 |
/*ID->/*s/plotObservation/obsStartDate,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/obsstartdate, |
| 24 | 24 |
/*ID->/*s/plotObservation/simpleUserdefined[name=precipitation]/value,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/precipitation, |
| ... | ... | |
| 49 | 49 |
/*ID->/*s/plotObservation/plotUniqueIdentifierID->/*s/plot[plotUniqueIdentifier]/plotName,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[./{.,*_id/location}/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{authorlocationcode,*_id/location/sourceaccessioncode/_merge/2/_alt/2}",
|
| 50 | 50 |
/*ID->/*s/plotObservation/plotUniqueIdentifierID->/*s/plot[plotUniqueIdentifier]/plotUniqueIdentifier,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[./{.,*_id/location}/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{sourceaccessioncode,*_id/location/sourceaccessioncode/_merge/2/_alt/1}",
|
| 51 | 51 |
/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/voucher,"/aggregateoccurrence/*_id/taxonoccurrence/_if:[cond/_eq:[left/_ref[addr=""../../../../_ignore/voucherType""],right=direct]]/{then/specimenreplicate,else/voucher/*_id/specimenreplicate:[*_id/taxonoccurrence]}/:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc",
|
| 52 |
/simpleUserdefined[name=collectionDate]/value,"/aggregateoccurrence/*_id/taxonoccurrence/_if:[cond/_eq:[left/_ref[addr=""../../../../_ignore/voucherType""],right=direct]]/{then/specimenreplicate,else/voucher/*_id/specimenreplicate:[*_id/taxonoccurrence]}/:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectiondate",
|
|
| 52 | 53 |
/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName,"/aggregateoccurrence/*_id/taxonoccurrence/_if:[cond/_eq:[left/_ref[addr=""../../../../_ignore/voucherType""],right=direct]]/{then/specimenreplicate,else/voucher/*_id/specimenreplicate:[*_id/taxonoccurrence]}/:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1",
|
| 53 | 54 |
/simpleUserdefined[name=growthForm]/value,/aggregateoccurrence/*_id/taxonoccurrence/growthform, |
| 54 |
/simpleUserdefined[name=collectionDate]/value,/aggregateoccurrence/*_id/taxonoccurrence/specimenreplicate:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectiondate, |
|
| 55 | 55 |
"/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=TaxonomicRankBelowSubspeciesEnum])/tcs:Rank","/aggregateoccurrence/*_id/taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first", |
| 56 | 56 |
"/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=auth])/tcs:Name","/aggregateoccurrence/*_id/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname", |
| 57 | 57 |
"/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=TaxonomicRankBelowSubspeciesEnum])/tcs:Name","/aggregateoccurrence/*_id/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last", |
| inputs/SALVIAS/maps/VegBIEN.plots.csv | ||
|---|---|---|
| 14 | 14 |
LongDec,"/*_id/location/{locationdetermination/longitude,centerlongitude}",
|
| 15 | 15 |
PlotMethod,/*_id/method/name, |
| 16 | 16 |
project_id,/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/projectname, |
| 17 |
life_zone_code,"/_collapse:[require=""commdetermination/*_id/commconcept/*_id/*/commname""]/value/commclass/commdetermination/*_id/commconcept/*_id/*/commname",
|
|
| 18 |
life_zone,"/_collapse:[require=""commdetermination/*_id/commconcept/*_id/*/commname""]/value/commclass/commdetermination/*_id/commconcept/commdescription",
|
|
| 17 |
life_zone_code,/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
|
|
| 18 |
life_zone,/commclass/commdetermination/*_id/commconcept/commdescription,
|
|
| 19 | 19 |
date_finish,/obsenddate/_*/date, |
| 20 | 20 |
date_start,/obsstartdate/_*/date, |
| 21 | 21 |
Precip,/precipitation, |
| inputs/SALVIAS/maps/VegBIEN.organisms.csv | ||
|---|---|---|
| 4 | 4 |
Line,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[./{.,*_id/location}/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{authorlocationcode,*_id/location/sourceaccessioncode/_merge/2/_alt/2}",
|
| 5 | 5 |
coll_number,"/aggregateoccurrence/*_id/taxonoccurrence/_if:[cond/_eq:[left/_ref[addr=""../../../../_ignore/voucherType""],right=direct]]/{then/specimenreplicate,else/voucher/*_id/specimenreplicate:[*_id/taxonoccurrence]}/:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc/_alt/1",Brad: Incorrect. Map instead as for voucher_string
|
| 6 | 6 |
SourceVoucher,"/aggregateoccurrence/*_id/taxonoccurrence/_if:[cond/_eq:[left/_ref[addr=""../../../../_ignore/voucherType""],right=direct]]/{then/specimenreplicate,else/voucher/*_id/specimenreplicate:[*_id/taxonoccurrence]}/:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc/_alt/2","Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
|
| 7 |
census_date,"/aggregateoccurrence/*_id/taxonoccurrence/_if:[cond/_eq:[left/_ref[addr=""../../../../_ignore/voucherType""],right=direct]]/{then/specimenreplicate,else/voucher/*_id/specimenreplicate:[*_id/taxonoccurrence]}/:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectiondate/_*/date",
|
|
| 7 | 8 |
Habit,"/aggregateoccurrence/*_id/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""Hemiepífito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=]/value","Brad: Incorrect for VegBank, correct for VegX. This is growth form (tree, shrub, herb, etc.). It is an observation of a trait."
|
| 8 |
census_date,/aggregateoccurrence/*_id/taxonoccurrence/specimenreplicate:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectiondate/_*/date, |
|
| 9 | 9 |
infra_rank_1,"/aggregateoccurrence/*_id/taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first", |
| 10 | 10 |
auth,"/aggregateoccurrence/*_id/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss. |
| 11 | 11 |
infra_ep_1,"/aggregateoccurrence/*_id/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last", |
| mappings/VegX-VegBIEN.plots.csv | ||
|---|---|---|
| 17 | 17 |
/simpleUserdefined[name=method]/*ID/method/name,/*_id/method/name, |
| 18 | 18 |
/*ID->/*s/project/personnel[role=metadataProvider]/organizationName,/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1, |
| 19 | 19 |
/*ID->/*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/projectname, |
| 20 |
->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,"/_collapse:[require=""commdetermination/*_id/commconcept/*_id/*/commname""]/value/commclass/commdetermination/*_id/commconcept/*_id/*/commname",
|
|
| 21 |
->/*s/communityDetermination[*ID]/*s/communityConcept/name,"/_collapse:[require=""commdetermination/*_id/commconcept/*_id/*/commname""]/value/commclass/commdetermination/*_id/commconcept/commdescription",
|
|
| 20 |
->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
|
|
| 21 |
->/*s/communityDetermination[*ID]/*s/communityConcept/name,/commclass/commdetermination/*_id/commconcept/commdescription,
|
|
| 22 | 22 |
/obsEndDate,/obsenddate, |
| 23 | 23 |
/obsStartDate,/obsstartdate, |
| 24 | 24 |
/simpleUserdefined[name=precipitation]/value,/precipitation, |
| mappings/VegX-VegBIEN.organisms.csv | ||
|---|---|---|
| 17 | 17 |
/*ID->/*s/plotObservation/simpleUserdefined[name=method]/*ID/method/name,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/method/name, |
| 18 | 18 |
/*ID->/*s/plotObservation/*ID->/*s/project/personnel[role=metadataProvider]/organizationName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1, |
| 19 | 19 |
/*ID->/*s/plotObservation/*ID->/*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/projectname, |
| 20 |
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/_collapse:[require=""commdetermination/*_id/commconcept/*_id/*/commname""]/value/commclass/commdetermination/*_id/commconcept/*_id/*/commname",
|
|
| 21 |
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/name,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/_collapse:[require=""commdetermination/*_id/commconcept/*_id/*/commname""]/value/commclass/commdetermination/*_id/commconcept/commdescription",
|
|
| 20 |
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
|
|
| 21 |
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/name,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
|
|
| 22 | 22 |
/*ID->/*s/plotObservation/obsEndDate,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/obsenddate, |
| 23 | 23 |
/*ID->/*s/plotObservation/obsStartDate,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/obsstartdate, |
| 24 | 24 |
/*ID->/*s/plotObservation/simpleUserdefined[name=precipitation]/value,/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/precipitation, |
| ... | ... | |
| 49 | 49 |
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[./{.,*_id/location}/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{authorlocationcode,*_id/location/sourceaccessioncode/_merge/2/_alt/2}",
|
| 50 | 50 |
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[./{.,*_id/location}/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{sourceaccessioncode,*_id/location/sourceaccessioncode/_merge/2/_alt/1}",
|
| 51 | 51 |
/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/voucher,"/aggregateoccurrence/*_id/taxonoccurrence/_if:[cond/_eq:[left/_ref[addr=""../../../../_ignore/voucherType""],right=direct]]/{then/specimenreplicate,else/voucher/*_id/specimenreplicate:[*_id/taxonoccurrence]}/:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc",
|
| 52 |
/simpleUserdefined[name=collectionDate]/value,"/aggregateoccurrence/*_id/taxonoccurrence/_if:[cond/_eq:[left/_ref[addr=""../../../../_ignore/voucherType""],right=direct]]/{then/specimenreplicate,else/voucher/*_id/specimenreplicate:[*_id/taxonoccurrence]}/:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectiondate",
|
|
| 52 | 53 |
/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName,"/aggregateoccurrence/*_id/taxonoccurrence/_if:[cond/_eq:[left/_ref[addr=""../../../../_ignore/voucherType""],right=direct]]/{then/specimenreplicate,else/voucher/*_id/specimenreplicate:[*_id/taxonoccurrence]}/:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1",
|
| 53 | 54 |
/simpleUserdefined[name=growthForm]/value,/aggregateoccurrence/*_id/taxonoccurrence/growthform, |
| 54 |
/simpleUserdefined[name=collectionDate]/value,/aggregateoccurrence/*_id/taxonoccurrence/specimenreplicate:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectiondate, |
|
| 55 | 55 |
"/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=TaxonomicRankBelowSubspeciesEnum])/tcs:Rank","/aggregateoccurrence/*_id/taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first", |
| 56 | 56 |
"/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=auth])/tcs:Name","/aggregateoccurrence/*_id/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname", |
| 57 | 57 |
"/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=TaxonomicRankBelowSubspeciesEnum])/tcs:Name","/aggregateoccurrence/*_id/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last", |
| mappings/for_review/VegX-VegBIEN.organisms.csv | ||
|---|---|---|
| 49 | 49 |
//plot/plotName,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{authorlocationcode,*_id/location/sourceaccessioncode/_merge/2/_alt/2}",
|
| 50 | 50 |
//plot/plotUniqueIdentifier,"/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{sourceaccessioncode,*_id/location/sourceaccessioncode/_merge/2/_alt/1}",
|
| 51 | 51 |
//taxonNameUsageConcept/voucher,"//*_id/taxonoccurrence/_if:[cond/_eq:[left/_ref[addr=""../../../../_ignore/voucherType""],right=direct]]/{then/specimenreplicate,else/voucher/*_id/specimenreplicate}//catalognumber_dwc",
|
| 52 |
/simpleUserdefined[name=collectionDate]/value,"//*_id/taxonoccurrence/_if:[cond/_eq:[left/_ref[addr=""../../../../_ignore/voucherType""],right=direct]]/{then/specimenreplicate,else/voucher/*_id/specimenreplicate}//collectiondate",
|
|
| 52 | 53 |
//party/organizationName,"//*_id/taxonoccurrence/_if:[cond/_eq:[left/_ref[addr=""../../../../_ignore/voucherType""],right=direct]]/{then/specimenreplicate,else/voucher/*_id/specimenreplicate}//datasource_id/party/organizationname/_alt/1",
|
| 53 | 54 |
/simpleUserdefined[name=growthForm]/value,//taxonoccurrence/growthform, |
| 54 |
/simpleUserdefined[name=collectionDate]/value,//specimenreplicate/collectiondate, |
|
| 55 | 55 |
//*s/taxonConcept[tcs:@code=TaxonomicRankBelowSubspeciesEnum]/tcs:Rank,"//taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first", |
| 56 | 56 |
//*s/taxonConcept[tcs:@code=auth]/tcs:Name,"//taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname", |
| 57 | 57 |
//*s/taxonConcept[tcs:@code=TaxonomicRankBelowSubspeciesEnum]/tcs:Name,"//taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last", |
| mappings/for_review/VegX-VegBIEN.stems.csv | ||
|---|---|---|
| 49 | 49 |
//plot/plotName,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{authorlocationcode,*_id/location/sourceaccessioncode/_merge/2/_alt/2}",
|
| 50 | 50 |
//plot/plotUniqueIdentifier,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{sourceaccessioncode,*_id/location/sourceaccessioncode/_merge/2/_alt/1}",
|
| 51 | 51 |
//taxonNameUsageConcept/voucher,"//*_id/taxonoccurrence/_if:[cond/_eq:[left/_ref[addr=""../../../../_ignore/voucherType""],right=direct]]/{then/specimenreplicate,else/voucher/*_id/specimenreplicate}//catalognumber_dwc",
|
| 52 |
//individualOrganismObservation/simpleUserdefined[name=collectionDate]/value,"//*_id/taxonoccurrence/_if:[cond/_eq:[left/_ref[addr=""../../../../_ignore/voucherType""],right=direct]]/{then/specimenreplicate,else/voucher/*_id/specimenreplicate}//collectiondate",
|
|
| 52 | 53 |
//party/organizationName,"//*_id/taxonoccurrence/_if:[cond/_eq:[left/_ref[addr=""../../../../_ignore/voucherType""],right=direct]]/{then/specimenreplicate,else/voucher/*_id/specimenreplicate}//datasource_id/party/organizationname/_alt/1",
|
| 53 | 54 |
//individualOrganismObservation/simpleUserdefined[name=growthForm]/value,//taxonoccurrence/growthform, |
| 54 |
//individualOrganismObservation/simpleUserdefined[name=collectionDate]/value,//specimenreplicate/collectiondate, |
|
| 55 | 55 |
//*s/taxonConcept[tcs:@code=TaxonomicRankBelowSubspeciesEnum]/tcs:Rank,"//taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first", |
| 56 | 56 |
//*s/taxonConcept[tcs:@code=auth]/tcs:Name,"//taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname", |
| 57 | 57 |
//*s/taxonConcept[tcs:@code=TaxonomicRankBelowSubspeciesEnum]/tcs:Name,"//taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last", |
| mappings/VegX-VegBIEN.stems.csv | ||
|---|---|---|
| 49 | 49 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotName,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[./{.,*_id/location}/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{authorlocationcode,*_id/location/sourceaccessioncode/_merge/2/_alt/2}",
|
| 50 | 50 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent:[./{.,*_id/location}/datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/{sourceaccessioncode,*_id/location/sourceaccessioncode/_merge/2/_alt/1}",
|
| 51 | 51 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/voucher,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/_if:[cond/_eq:[left/_ref[addr=""../../../../_ignore/voucherType""],right=direct]]/{then/specimenreplicate,else/voucher/*_id/specimenreplicate:[*_id/taxonoccurrence]}/:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc",
|
| 52 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/simpleUserdefined[name=collectionDate]/value,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/_if:[cond/_eq:[left/_ref[addr=""../../../../_ignore/voucherType""],right=direct]]/{then/specimenreplicate,else/voucher/*_id/specimenreplicate:[*_id/taxonoccurrence]}/:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectiondate",
|
|
| 52 | 53 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName,"/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/_if:[cond/_eq:[left/_ref[addr=""../../../../_ignore/voucherType""],right=direct]]/{then/specimenreplicate,else/voucher/*_id/specimenreplicate:[*_id/taxonoccurrence]}/:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1",
|
| 53 | 54 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/simpleUserdefined[name=growthForm]/value,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/growthform, |
| 54 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/simpleUserdefined[name=collectionDate]/value,/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/specimenreplicate:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectiondate, |
|
| 55 | 55 |
"/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=TaxonomicRankBelowSubspeciesEnum])/tcs:Rank","/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first", |
| 56 | 56 |
"/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=auth])/tcs:Name","/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname", |
| 57 | 57 |
"/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=TaxonomicRankBelowSubspeciesEnum])/tcs:Name","/*_id/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last", |
Also available in: Unified diff
mappings/VegX-VegBIEN.stems.csv: Map collectiondate to specimenreplicate via voucher when the voucher is indirect, rather than always directly to the taxonoccurrence, because the collectiondate relates to the specimenreplicate, not the taxonoccurrence, and is not necessarily 1:1 with it