Project

General

Profile

« Previous | Next » 

Revision 3849

Added by Aaron Marcuse-Kubitza over 12 years ago

mappings/VegX-VegCSV.stems.csv: Mapped individualOrganismObservation user-defined terms

View differences:

mappings/VegX-VegCSV.stems.csv
20 20 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance[*ID/*s/attribute/quantitative/*ID/*s/method(/name=Gentry)]/value=1.37]/diameter,//individualOrganismObservation/diameterBaseDistance[baseDistance[*ID/*s/attribute/quantitative/*ID/*s/method(/name=Gentry)]/value=1.37]/diameter,,,
21 21 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance[!attributeID]/value=1.37]/diameter,//individualOrganismObservation/diameterBaseDistance[baseDistance[]/value=1.37]/diameter,,,
22 22 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance/value=0]/diameter,//individualOrganismObservation/diameterBaseDistance[value=0]/diameter,,,
23 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=authorPlantCode]/value,//individualOrganismObservation/simpleUserdefined[name=authorPlantCode]/value,,,
24 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/simpleUserdefined[name=canopyForm]/value,//individualOrganismObservation/simpleUserdefined[name=canopyForm]/value,,,
25 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/simpleUserdefined[name=canopyPosition]/value,//individualOrganismObservation/simpleUserdefined[name=canopyPosition]/value,,,
26 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=censusNo]/value,//individualOrganismObservation/simpleUserdefined[name=censusNo]/value,,,
27 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,//individualOrganismObservation/simpleUserdefined[name=collectionDate]/value,,,
28 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=growthForm]/value,//individualOrganismObservation/simpleUserdefined[name=growthForm]/value,,,
29 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/simpleUserdefined[name=heightFirstBranch]/value,//individualOrganismObservation/simpleUserdefined[name=heightFirstBranch]/value,,,
30 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/simpleUserdefined[name=height]/value,//individualOrganismObservation/simpleUserdefined[name=height]/value,,,
31 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=height]/value,//individualOrganismObservation/simpleUserdefined[name=height]/value,,,
32 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/simpleUserdefined[name=lianaInfestation]/value,//individualOrganismObservation/simpleUserdefined[name=lianaInfestation]/value,,,
33 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=sourceAccessionCode]/value,//individualOrganismObservation/simpleUserdefined[name=sourceAccessionCode]/value,,,
34 23 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/volumeCanopy/*ID->/*s/attribute/ordinal/coverPercent,//ordinal/coverPercent,,,
35 24 
/*s/plot/area,//plot/area,,,
36 25 
/*s/plot/landform,//plot/landform,,,
......
47 36 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/*ID->/*s/project/title[@id=name],//project/title[@id=name],,,
48 37 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/*ID->/*s/project/title[@id=sourceAccessionCode],//project/title[@id=sourceAccessionCode],,,
49 38 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,acidity,,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=plotMetadata,42
39 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=authorPlantCode]/value,authorPlantCode,,"http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#observation, http://vegbiendev.nceas.ucsb.edu/phppgadmin/tblproperties.php?subject=table&table=plantobservation&server=localhost%3A5432%3Aallow&database=vegbien&schema=public",4
50 40 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,base,Shortened for standardization,"http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#soilObs, http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=plotMetadata",14
51 41 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,calcium,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=plotMetadata,40
42 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/simpleUserdefined[name=canopyForm]/value,canopyForm,,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=plotObservations,57
43 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/simpleUserdefined[name=canopyPosition]/value,canopyPosition,,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=plotObservations,56
52 44 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value,carbon,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=plotMetadata,37
53 45 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/voucher,catalogNumber,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",http://rs.tdwg.org/dwc/terms/,20
54 46 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationExchangeCapacity]/value,cationExchangeCapacity,Expanded for clarity,"http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#soilObs, http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=plotMetadata",13
47 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=censusNo]/value,censusNumber,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=plotObservations,4
55 48 
"/*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=cl])/tcs:Name",class,,http://rs.tdwg.org/dwc/terms/,144
56 49 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=clay]/value,clay,,http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#soilObs,10
50 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,collectedDate,,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=bien2_staging&table=nybg_raw,29
57 51 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=fam])/tcs:Name",computer.family,,http://rs.tdwg.org/dwc/terms/,146
58 52 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=gen])/tcs:Name",computer.genus,,http://rs.tdwg.org/dwc/terms/,147
59 53 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=TaxonomicRankBelowSubspeciesEnum])/tcs:Name",computer.infraspecificEpithet,,http://rs.tdwg.org/dwc/terms/,150
......
73 67 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,fieldNotes,,http://rs.tdwg.org/dwc/terms/,54
74 68 
/*s/plot/geospatial/FootprintWKT,footprintWKT,,http://rs.tdwg.org/dwc/terms/,91
75 69 
"/*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=gen])/tcs:Name",genus,,http://rs.tdwg.org/dwc/terms/,147
70 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=growthForm]/value,growthForm,a.k.a. habit (SALVIAS: http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data),http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#observation,62
71 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/simpleUserdefined[name=height]/value,height,,http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#stemCount,4
72 
/*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 
/*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
76 74 
"/*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,"Brad: Bob, Nick, please is this mapping OK?",http://rs.tdwg.org/dwc/terms/,124
77 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
78 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 
/*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
79 78 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/magnesium,magnesium,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg-plotobservation.xsd#/AbioticObservationType,4
80 79 
/*s/plot/geospatial/maximumDepthInMeters,maximumDepthInMeters,,http://rs.tdwg.org/dwc/terms/,75
81 80 
/*s/plot/geospatial/maximumElevationInMeters,maximumElevationInMeters,,http://rs.tdwg.org/dwc/terms/,72
......
87 86 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/ph,ph,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg-plotobservation.xsd#/AbioticObservationType,6
88 87 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/phosphorus,phosphorus,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg-plotobservation.xsd#/AbioticObservationType,2
89 88 
"/*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=phyl_div])/tcs:Name",phylum,,http://rs.tdwg.org/dwc/terms/,143
89 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=sourceAccessionCode]/value,plantObservation.sourceAccessionCode,,http://vegbiendev.nceas.ucsb.edu/phppgadmin/tblproperties.php?subject=table&table=plantobservation&server=localhost%3A5432%3Aallow&database=vegbien&schema=public,2
90 90 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/potassium,potassium,Spelling corrected,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg-plotobservation.xsd#/AbioticObservationType,3
91 91 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=sand]/value,sand,,http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#soilObs,8
92 92 
"/*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])/tcs:Name",scientificName,"Brad: Bob, Nick, please is this mapping OK?",http://rs.tdwg.org/dwc/terms/,134
mappings/VegCSV-VegBIEN.specimens.csv
68 68 
recordedBy,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/,23
69 69 
//*s/taxonDetermination[role=collector]/groupType,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/cond/_eq:[right=direct]/left,,,
70 70 
catalogNumber,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",http://rs.tdwg.org/dwc/terms/,20
71 
//individualOrganismObservation/simpleUserdefined[name=collectionDate]/value,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/collectiondate,,,
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,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",http://rs.tdwg.org/dwc/terms/,20
73 
//individualOrganismObservation/simpleUserdefined[name=collectionDate]/value,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/collectiondate,,,
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 74 
//*s/aggregateOrganismObservation/*/aggregateValue/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,,,
75 75 
//ordinal/coverPercent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,,,
76 
//individualOrganismObservation/simpleUserdefined[name=censusNo]/value,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue",,,
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,,,
78 
//individualOrganismObservation/simpleUserdefined[name=authorPlantCode]/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode,"""{"" sorts it with other _if:[name=specimenreplicate_via]s",,
78 
authorPlantCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode,"""{"" sorts it with other _if:[name=specimenreplicate_via]s","http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#observation, http://vegbiendev.nceas.ucsb.edu/phppgadmin/tblproperties.php?subject=table&table=plantobservation&server=localhost%3A5432%3Aallow&database=vegbien&schema=public",4
79 79 
//*s/individualOrganismObservation/height,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/overallheight,,,
80 
//individualOrganismObservation/simpleUserdefined[name=height]/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/overallheight,,,
81 
//individualOrganismObservation/simpleUserdefined[name=sourceAccessionCode]/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,"""{"" sorts it with other _if:[name=specimenreplicate_via]s",,
80 
height,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/overallheight,,http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#stemCount,4
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 82 
//*s/aggregateOrganismObservation/*/aggregateValue/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,,,
83 83 
//individualOrganismObservation/diameterBaseDistance[value=0]/diameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter,,,
84 
//individualOrganismObservation/simpleUserdefined[name=canopyForm]/value,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tablerecord_id]/definedvalue",,,
85 
//individualOrganismObservation/simpleUserdefined[name=canopyPosition]/value,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tablerecord_id]/definedvalue",,,
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 
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
86 86 
//individualOrganismObservation/diameterBaseDistance[baseDistance[*ID/*s/attribute/quantitative/*ID/*s/method(/name=Gentry)]/value=1.37]/diameter,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=gentryDiameter]]:[@fkey=tablerecord_id]/definedvalue",,,
87 
//individualOrganismObservation/simpleUserdefined[name=lianaInfestation]/value,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]:[@fkey=tablerecord_id]/definedvalue",,,
87 
lianaInfestation,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]:[@fkey=tablerecord_id]/definedvalue",,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=plotObservations,58
88 88 
fieldNotes,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=notes]]:[@fkey=tablerecord_id]/definedvalue",,http://rs.tdwg.org/dwc/terms/,54
89 89 
//individualOrganismObservation/diameterBaseDistance[baseDistance[]/value=1.37]/diameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight,,,
90 
//individualOrganismObservation/simpleUserdefined[name=height]/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height,,,
91 
//individualOrganismObservation/simpleUserdefined[name=heightFirstBranch]/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/heightfirstbranch,,,
90 
height,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height,,http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#stemCount,4
91 
heightFirstBranch,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/heightfirstbranch,,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=plotObservations,43
92 92 
//individualOrganism/identificationLabel[@id=1],"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2,,
93 93 
//individualOrganism/identificationLabel[@id=2],/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag,,,
94 94 
//*s/individualOrganismObservation/relativePlotPosition/relativeX,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition,,,
95 95 
//*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/relativePlotPosition/relativeX,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition,,,
96 96 
//*s/individualOrganismObservation/relativePlotPosition/relativeY,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,,,
97 97 
//*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/relativePlotPosition/relativeY,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,,,
98 
//individualOrganismObservation/simpleUserdefined[name=growthForm]/value,/location/locationevent/taxonoccurrence/growthform,,,
99 
//individualOrganismObservation/simpleUserdefined[name=sourceAccessionCode]/value,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,"""{"" sorts it with other _if:[name=specimenreplicate_via]s",,
100 
//individualOrganismObservation/simpleUserdefined[name=authorPlantCode]/value,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2,"""{"" sorts it with other _if:[name=specimenreplicate_via]s",,
98 
growthForm,/location/locationevent/taxonoccurrence/growthform,a.k.a. habit (SALVIAS: http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data),http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#observation,62
99 
plantObservation.sourceAccessionCode,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,"""{"" 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
100 
authorPlantCode,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2,"""{"" sorts it with other _if:[name=specimenreplicate_via]s","http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#observation, http://vegbiendev.nceas.ucsb.edu/phppgadmin/tblproperties.php?subject=table&table=plantobservation&server=localhost%3A5432%3Aallow&database=vegbien&schema=public",4
101 101 
scientificName,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3,"Brad: Bob, Nick, please is this mapping OK?",http://rs.tdwg.org/dwc/terms/,134
102 102 
computer.taxonRank,"/location/locationevent/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",,http://rs.tdwg.org/dwc/terms/,151
103 103 
computer.scientificNameAuthorship,"/location/locationevent/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: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",http://rs.tdwg.org/dwc/terms/,153
mappings/VegCSV.self.specimens.csv
17 17 
//individualOrganismObservation/diameterBaseDistance[baseDistance[*ID/*s/attribute/quantitative/*ID/*s/method(/name=Gentry)]/value=1.37]/diameter,//individualOrganismObservation/diameterBaseDistance[baseDistance[*ID/*s/attribute/quantitative/*ID/*s/method(/name=Gentry)]/value=1.37]/diameter
18 18 
//individualOrganismObservation/diameterBaseDistance[baseDistance[]/value=1.37]/diameter,//individualOrganismObservation/diameterBaseDistance[baseDistance[]/value=1.37]/diameter
19 19 
//individualOrganismObservation/diameterBaseDistance[value=0]/diameter,//individualOrganismObservation/diameterBaseDistance[value=0]/diameter
20 
//individualOrganismObservation/simpleUserdefined[name=authorPlantCode]/value,//individualOrganismObservation/simpleUserdefined[name=authorPlantCode]/value
21 
//individualOrganismObservation/simpleUserdefined[name=canopyForm]/value,//individualOrganismObservation/simpleUserdefined[name=canopyForm]/value
22 
//individualOrganismObservation/simpleUserdefined[name=canopyPosition]/value,//individualOrganismObservation/simpleUserdefined[name=canopyPosition]/value
23 
//individualOrganismObservation/simpleUserdefined[name=censusNo]/value,//individualOrganismObservation/simpleUserdefined[name=censusNo]/value
24 
//individualOrganismObservation/simpleUserdefined[name=collectionDate]/value,//individualOrganismObservation/simpleUserdefined[name=collectionDate]/value
25 
//individualOrganismObservation/simpleUserdefined[name=growthForm]/value,//individualOrganismObservation/simpleUserdefined[name=growthForm]/value
26 
//individualOrganismObservation/simpleUserdefined[name=heightFirstBranch]/value,//individualOrganismObservation/simpleUserdefined[name=heightFirstBranch]/value
27 
//individualOrganismObservation/simpleUserdefined[name=height]/value,//individualOrganismObservation/simpleUserdefined[name=height]/value
28 
//individualOrganismObservation/simpleUserdefined[name=lianaInfestation]/value,//individualOrganismObservation/simpleUserdefined[name=lianaInfestation]/value
29 
//individualOrganismObservation/simpleUserdefined[name=sourceAccessionCode]/value,//individualOrganismObservation/simpleUserdefined[name=sourceAccessionCode]/value
30 20 
//ordinal/coverPercent,//ordinal/coverPercent
31 21 
//plot/area,//plot/area
32 22 
//plot/landform,//plot/landform
......
48 38 
associatedReferences,associatedReferences
49 39 
associatedSequences,associatedSequences
50 40 
associatedTaxa,associatedTaxa
41 
authorPlantCode,authorPlantCode
51 42 
base,base
52 43 
basisOfRecord,basisOfRecord
53 44 
bed,bed
54 45 
behavior,behavior
55 46 
calcium,calcium
47 
canopyForm,canopyForm
48 
canopyPosition,canopyPosition
56 49 
carbon,carbon
57 50 
catalogNumber,catalogNumber
58 51 
cationExchangeCapacity,cationExchangeCapacity
52 
censusNumber,censusNumber
59 53 
class,class
60 54 
clay,clay
55 
collectedDate,collectedDate
61 56 
collectionCode,collectionCode
62 57 
collectionID,collectionID
63 58 
computer.family,computer.family
......
120 115 
georeferencedBy,georeferencedBy
121 116 
georeferencedDate,georeferencedDate
122 117 
group,group
118 
growthForm,growthForm
123 119 
habitat,habitat
120 
height,height
121 
heightFirstBranch,heightFirstBranch
124 122 
higherClassification,higherClassification
125 123 
higherGeography,higherGeography
126 124 
higherGeographyID,higherGeographyID
......
145 143 
latestEpochOrHighestSeries,latestEpochOrHighestSeries
146 144 
latestEraOrHighestErathem,latestEraOrHighestErathem
147 145 
latestPeriodOrHighestSystem,latestPeriodOrHighestSystem
146 
lianaInfestation,lianaInfestation
148 147 
lifeStage,lifeStage
149 148 
lithostratigraphicTerms,lithostratigraphicTerms
150 149 
locality,locality
......
193 192 
ph,ph
194 193 
phosphorus,phosphorus
195 194 
phylum,phylum
195 
plantObservation.sourceAccessionCode,plantObservation.sourceAccessionCode
196 196 
pointRadiusSpatialFit,pointRadiusSpatialFit
197 197 
potassium,potassium
198 198 
preparations,preparations

Also available in: Unified diff