Revision 3856
Added by Aaron Marcuse-Kubitza over 12 years ago
mappings/VegX-VegCSV.stems.csv | ||
---|---|---|
32 | 32 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=method]/*ID/method/name,//plotObservation/simpleUserdefined[name=method]/*ID/method/name,,, |
33 | 33 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=precipitation]/value,//plotObservation/simpleUserdefined[name=precipitation]/value,,, |
34 | 34 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/*ID->/*s/project/title[@id=name],//project/title[@id=name],,, |
35 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/*ID->/*s/project/title[@id=sourceAccessionCode],//project/title[@id=sourceAccessionCode],,, |
|
36 | 35 |
/*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 |
37 | 36 |
/*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 |
38 | 37 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,baseSaturation,,http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#soilObs,14 |
... | ... | |
72 | 71 |
"/*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 | 72 |
/*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 | 73 |
/*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 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=sourceAccessionCode]/value,individualOrganismObservation.uniqueID,Shortened for standardization,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/individualOrganismObservations/individualOrganismObservation, http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotUniqueIdentifier",
|
|
74 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=sourceAccessionCode]/value,individualOrganismObservation.uniqueID,Field name shortened for standardization,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/individualOrganismObservations/individualOrganismObservation, http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotUniqueIdentifier",
|
|
76 | 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 |
77 | 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 |
78 | 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 |
... | ... | |
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.xsd#/abioticObservations/abioticObservation,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 |
90 | 89 |
/*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.xsd#/abioticObservations/abioticObservation,3 |
90 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/*ID->/*s/project/title[@id=sourceAccessionCode],project.uniqueID,Field name shortened for standardization,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/projects/project, http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotUniqueIdentifier", |
|
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,,http://rs.tdwg.org/dwc/terms/,134 |
93 | 93 |
"/*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=auth])/tcs:Name",scientificNameAuthorship,,http://rs.tdwg.org/dwc/terms/,153 |
mappings/VegCSV-VegBIEN.specimens.csv | ||
---|---|---|
19 | 19 |
continent,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",,http://rs.tdwg.org/dwc/terms/,59 |
20 | 20 |
//plotObservation/simpleUserdefined[name=method]/*ID/method/name,/location/locationevent/*_id/method/name,,, |
21 | 21 |
//project/title[@id=name],/location/locationevent/*_id/project/projectname,,, |
22 |
//project/title[@id=sourceAccessionCode],/location/locationevent/*_id/project/sourceaccessioncode,,,
|
|
22 |
project.uniqueID,/location/locationevent/*_id/project/sourceaccessioncode,Field name shortened for standardization,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/projects/project, http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotUniqueIdentifier",
|
|
23 | 23 |
//plot/plotName,/location/locationevent/authorlocationcode,,, |
24 | 24 |
//*s/communityDetermination/*s/communityConcept/commonName,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,,, |
25 | 25 |
//*s/communityDetermination/*s/communityConcept/name,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,,, |
... | ... | |
78 | 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 | 80 |
height,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/overallheight,,http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#stemCount,4 |
81 |
individualOrganismObservation.uniqueID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,"Shortened for standardization; ""{"" sorts it with other _if:[name=specimenreplicate_via]s","http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/individualOrganismObservations/individualOrganismObservation, http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotUniqueIdentifier",
|
|
81 |
individualOrganismObservation.uniqueID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,"Field name shortened for standardization; ""{"" sorts it with other _if:[name=specimenreplicate_via]s","http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/individualOrganismObservations/individualOrganismObservation, http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotUniqueIdentifier",
|
|
82 | 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 |
... | ... | |
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 | 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 |
individualOrganismObservation.uniqueID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,"Shortened for standardization; ""{"" sorts it with other _if:[name=specimenreplicate_via]s","http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/individualOrganismObservations/individualOrganismObservation, http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotUniqueIdentifier",
|
|
99 |
individualOrganismObservation.uniqueID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,"Field name shortened for standardization; ""{"" sorts it with other _if:[name=specimenreplicate_via]s","http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/individualOrganismObservations/individualOrganismObservation, http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotUniqueIdentifier",
|
|
100 | 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,,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 |
mappings/VegCSV.self.specimens.csv | ||
---|---|---|
28 | 28 |
//plotObservation/simpleUserdefined[name=method]/*ID/method/name,//plotObservation/simpleUserdefined[name=method]/*ID/method/name |
29 | 29 |
//plotObservation/simpleUserdefined[name=precipitation]/value,//plotObservation/simpleUserdefined[name=precipitation]/value |
30 | 30 |
//project/title[@id=name],//project/title[@id=name] |
31 |
//project/title[@id=sourceAccessionCode],//project/title[@id=sourceAccessionCode] |
|
32 | 31 |
acceptedNameUsage,acceptedNameUsage |
33 | 32 |
acceptedNameUsageID,acceptedNameUsageID |
34 | 33 |
acidity,acidity |
... | ... | |
196 | 195 |
potassium,potassium |
197 | 196 |
preparations,preparations |
198 | 197 |
previousIdentifications,previousIdentifications |
198 |
project.uniqueID,project.uniqueID |
|
199 | 199 |
recordNumber,recordNumber |
200 | 200 |
recordedBy,recordedBy |
201 | 201 |
relatedResourceID,relatedResourceID |
Also available in: Unified diff
mappings/VegX-VegCSV.stems.csv: Mapped remaining sourceAccessionCode user-defined terms to <VegX-table>.uniqueID