Revision 1038
Added by Aaron Marcuse-Kubitza almost 13 years ago
| mappings/VegX-VegBIEN.plots.csv | ||
|---|---|---|
| 1 | 1 |
VegX:/*s/plotObservation,VegBIEN:/locationevent,Comments |
| 2 |
/partyWithRole/*ID->/parties/party/organizationName,"/""""/*_id/location/*_id/reference/shortname/_alt/1",Quotes sort this before other mappings |
|
| 3 | 2 |
/*UniqueIdentifierID->/*s/plot/area,/*_id/location/area, |
| 4 | 3 |
/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*_id/location/authorlocationcode, |
| 5 | 4 |
/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation,/*_id/location/elevation/_alt/1, |
| ... | ... | |
| 49 | 48 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/soilobs:[soilhorizon=unknown]/soiltexture, |
| 50 | 49 |
/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,/waterdepth/max, |
| 51 | 50 |
/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,/waterdepth/min, |
| 51 |
/partyWithRole/*ID->/parties/party/organizationName,:[*_id/location/*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/*_id/location/*_id/reference/shortname/_alt/1, |
|
| 52 | 52 |
:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=authorCode]/value,:[*_id/location/*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/authoreventcode, |
| mappings/VegX-VegBIEN.organisms.csv | ||
|---|---|---|
| 1 | 1 |
VegX:/*s/individualOrganismObservation,VegBIEN:/taxonoccurrence,Comments |
| 2 |
/*ID->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,"/*_id/locationevent/""""/*_id/location/*_id/reference/shortname/_alt/1",Quotes sort this before other mappings |
|
| 3 | 2 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/area,/*_id/locationevent/*_id/location/area, |
| 4 | 3 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*_id/locationevent/*_id/location/authorlocationcode, |
| 5 | 4 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation,/*_id/locationevent/*_id/location/elevation/_alt/1, |
| ... | ... | |
| 49 | 48 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,/*_id/locationevent/soilobs:[soilhorizon=unknown]/soiltexture, |
| 50 | 49 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumDepthInMeters,/*_id/locationevent/waterdepth/max, |
| 51 | 50 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumDepthInMeters,/*_id/locationevent/waterdepth/min, |
| 51 |
/*ID->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,/*_id/locationevent:[*_id/location/*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/*_id/location/*_id/reference/shortname/_alt/1, |
|
| 52 | 52 |
/*ID->/*s/plotObservation:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/simpleUserdefined[name=authorCode]/value,/*_id/locationevent:[*_id/location/*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/authoreventcode, |
| 53 | 53 |
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/voucher,/aggregateoccurrence/*_id/plantobservation/authorplantcode, |
| 54 | 54 |
/height,/aggregateoccurrence/*_id/plantobservation/overallheight, |
| ... | ... | |
| 90 | 90 |
/simpleUserdefined[name=habit]/value,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=habit]]:[@fkey=tableRecord_ID]/definedvalue", |
| 91 | 91 |
/simpleUserdefined[name=individualCode]/value,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=individualCode]]:[@fkey=tableRecord_ID]/definedvalue", |
| 92 | 92 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType","/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=voucherType]]:[@fkey=tableRecord_ID]/definedvalue", |
| 93 |
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName,"/specimenreplicate/""""/*_id/reference/shortname/_alt/1",Quotes sort this before other mappings
|
|
| 93 |
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName,/specimenreplicate:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/*_id/reference/shortname/_alt/1,
|
|
| 94 | 94 |
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept:[partyWithRole/*ID->/parties/party/organizationName=$/_ignore/inLabel]/authorCode,/specimenreplicate:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc, |
| 95 | 95 |
/simpleUserdefined[name=collectionDate]/value,/specimenreplicate:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/collectiondate, |
| 96 | 96 |
/simpleUserdefined[name=collectionDate]/value/_*/date,/specimenreplicate:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/collectiondate/_*/date, |
| mappings/for_review/VegX-VegBIEN.plots.csv | ||
|---|---|---|
| 1 | 1 |
VegX:/*s/plotObservation,VegBIEN:/locationevent,Comments |
| 2 |
//party/organizationName,"/""""/*_id/location/*_id/reference/shortname/_alt/1",Quotes sort this before other mappings |
|
| 3 | 2 |
//plot/area,//location/area, |
| 4 | 3 |
//plot/plotUniqueIdentifier,//location/authorlocationcode, |
| 5 | 4 |
//geospatial/verbatimElevation,//location/elevation/_alt/1, |
| ... | ... | |
| 49 | 48 |
//*s/abioticObservation/simpleUserdefined[name=texture]/value,//soilobs/soiltexture, |
| 50 | 49 |
//geospatial/maximumDepthInMeters,//waterdepth/max, |
| 51 | 50 |
//geospatial/minimumDepthInMeters,//waterdepth/min, |
| 51 |
//party/organizationName,//reference/shortname/_alt/1, |
|
| 52 | 52 |
/simpleUserdefined[name=authorCode]/value,/authoreventcode, |
| mappings/for_review/VegX-VegBIEN.organisms.csv | ||
|---|---|---|
| 1 | 1 |
VegX:/*s/individualOrganismObservation,VegBIEN:/taxonoccurrence,Comments |
| 2 |
//party/organizationName,"/*_id/locationevent/""""/*_id/location/*_id/reference/shortname/_alt/1",Quotes sort this before other mappings |
|
| 3 | 2 |
//plot/area,//location/area, |
| 4 | 3 |
//plot/plotUniqueIdentifier,//location/authorlocationcode, |
| 5 | 4 |
//geospatial/verbatimElevation,//location/elevation/_alt/1, |
| ... | ... | |
| 49 | 48 |
//*s/abioticObservation/simpleUserdefined[name=texture]/value,//soilobs/soiltexture, |
| 50 | 49 |
//geospatial/maximumDepthInMeters,//waterdepth/max, |
| 51 | 50 |
//geospatial/minimumDepthInMeters,//waterdepth/min, |
| 51 |
//party/organizationName,//reference/shortname/_alt/1, |
|
| 52 | 52 |
//plotObservation/simpleUserdefined[name=authorCode]/value,//locationevent/authoreventcode, |
| 53 | 53 |
//taxonNameUsageConcept/voucher,//plantobservation/authorplantcode, |
| 54 | 54 |
/height,//plantobservation/overallheight, |
| ... | ... | |
| 90 | 90 |
/simpleUserdefined[name=habit]/value,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=habit]]/definedvalue", |
| 91 | 91 |
/simpleUserdefined[name=individualCode]/value,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=individualCode]]/definedvalue", |
| 92 | 92 |
//*s/taxonDetermination[role=collector]/groupType,"/definedvalue[*_id/userdefined[tablename=taxonoccurrence,userdefinedname=voucherType]]/definedvalue", |
| 93 |
//party/organizationName,"/specimenreplicate/""""/*_id/reference/shortname/_alt/1",Quotes sort this before other mappings
|
|
| 93 |
//party/organizationName,//reference/shortname/_alt/1,
|
|
| 94 | 94 |
//taxonNameUsageConcept/authorCode,//specimenreplicate/catalognumber_dwc, |
| 95 | 95 |
/simpleUserdefined[name=collectionDate]/value,//specimenreplicate/collectiondate, |
| 96 | 96 |
/simpleUserdefined[name=collectionDate]/value/_*/date,//specimenreplicate/collectiondate/_*/date, |
Also available in: Unified diff
VegX-VegBIEN mapping: Reordered 2-step-only mappings that use /_ignore/inLabel so they run at the same time as other mappings that set the field that uses /_ignore/inLabel. This fixes almost all of the failing 2-step tests.