Project

General

Profile

« Previous | Next » 

Revision 3853

Added by Aaron Marcuse-Kubitza over 12 years ago

mappings/VegX-VegCSV.stems.csv: Mapped aggregateOrganismObservation terms

View differences:

mappings/VegX-VegCSV.stems.csv
1 1 
VegX:,VegCSV[DwC],Comments,Source,Order
2 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/aggregateOrganismObservation[*ID]/*/aggregateValue/value,//*s/aggregateOrganismObservation/*/aggregateValue/value,,,
3 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/aggregateOrganismObservation[*ID]/*/aggregateValue/value,//*s/aggregateOrganismObservation/*/aggregateValue/value,,,
4 2 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,//*s/communityDetermination/*s/communityConcept/commonName,,,
5 3 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/communityDetermination[*ID]/*s/communityConcept/name,//*s/communityDetermination/*s/communityConcept/name,,,
6 4 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/height,//*s/individualOrganismObservation/height,,,
......
72 70 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=height]/value,height,,http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#stemCount,4
73 71 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/simpleUserdefined[name=heightFirstBranch]/value,heightFirstBranch,,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=plotObservations,43
74 72 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,!partyWithRole]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=binom])/fit",identificationQualifier,,http://rs.tdwg.org/dwc/terms/,124
73 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/aggregateOrganismObservation[*ID]/*/aggregateValue/value,individualCount,,http://rs.tdwg.org/dwc/terms/,25
74 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/aggregateOrganismObservation[*ID]/*/aggregateValue/value,individualCount,,http://rs.tdwg.org/dwc/terms/,25
75 75 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,!partyWithRole]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=ssp])/tcs:Name",infraspecificEpithet,,http://rs.tdwg.org/dwc/terms/,150
76 76 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,!partyWithRole]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=reg])/tcs:Name",kingdom,,http://rs.tdwg.org/dwc/terms/,142
77 77 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/simpleUserdefined[name=lianaInfestation]/value,lianaInfestation,,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=plotObservations,58
mappings/VegCSV-VegBIEN.specimens.csv
71 71 
collectedDate,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/collectiondate,,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=bien2_staging&table=nybg_raw,29
72 72 
catalogNumber,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/,20
73 73 
collectedDate,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/collectiondate,,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=bien2_staging&table=nybg_raw,29
74 
//*s/aggregateOrganismObservation/*/aggregateValue/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,,,
74 
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,,http://rs.tdwg.org/dwc/terms/,25
75 75 
//ordinal/coverPercent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,,,
76 76 
censusNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue",Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=plotObservations,4
77 77 
//*s/individualOrganismObservation/volumeCanopy/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover,,,
......
79 79 
//*s/individualOrganismObservation/height,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/overallheight,,,
80 80 
height,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/overallheight,,http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#stemCount,4
81 81 
plantObservation.sourceAccessionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,"""{"" sorts it with other _if:[name=specimenreplicate_via]s",http://vegbiendev.nceas.ucsb.edu/phppgadmin/tblproperties.php?subject=table&table=plantobservation&server=localhost%3A5432%3Aallow&database=vegbien&schema=public,2
82 
//*s/aggregateOrganismObservation/*/aggregateValue/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,,,
82 
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,,http://rs.tdwg.org/dwc/terms/,25
83 83 
//individualOrganismObservation/diameterBaseDistance[value=0]/diameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter,,,
84 84 
canopyForm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tablerecord_id]/definedvalue",,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=plotObservations,57
85 85 
canopyPosition,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tablerecord_id]/definedvalue",,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=plotObservations,56
......
190 190 
identificationReferences,,,http://rs.tdwg.org/dwc/terms/,121
191 191 
identificationRemarks,,,http://rs.tdwg.org/dwc/terms/,123
192 192 
identificationVerificationStatus,,,http://rs.tdwg.org/dwc/terms/,122
193 
individualCount,,,http://rs.tdwg.org/dwc/terms/,25
194 193 
individualID,,,http://rs.tdwg.org/dwc/terms/,24
195 194 
informationWithheld,,,http://rs.tdwg.org/dwc/terms/,16
196 195 
institutionID,,,http://rs.tdwg.org/dwc/terms/,8
mappings/VegCSV.self.specimens.csv
1 1 
VegCSV[DwC],VegCSV[DwC]
2 
//*s/aggregateOrganismObservation/*/aggregateValue/value,//*s/aggregateOrganismObservation/*/aggregateValue/value
3 2 
//*s/communityDetermination/*s/communityConcept/commonName,//*s/communityDetermination/*s/communityConcept/commonName
4 3 
//*s/communityDetermination/*s/communityConcept/name,//*s/communityDetermination/*s/communityConcept/name
5 4 
//*s/individualOrganismObservation/height,//*s/individualOrganismObservation/height

Also available in: Unified diff