Revision 3863
Added by Aaron Marcuse-Kubitza over 12 years ago
| mappings/VegX-VegCSV.stems.csv | ||
|---|---|---|
| 23 | 23 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=precipitation]/value,//plotObservation/simpleUserdefined[name=precipitation]/value,,, |
| 24 | 24 |
/*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 |
| 25 | 25 |
/*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 |
| 26 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance/value=0]/diameter,basalDiameter,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=stems#basal_diam,5
|
|
| 26 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance/value=0]/diameter,basalDiameter,Expanded for clarity from basal_diam,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=stems,5
|
|
| 27 | 27 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,baseSaturation,,http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#soilObs,14 |
| 28 | 28 |
/*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 |
| 29 | 29 |
/*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 |
| ... | ... | |
| 48 | 48 |
/*s/plot/location[placeType=county]/placeName,county,,http://rs.tdwg.org/dwc/terms/,66 |
| 49 | 49 |
/*s/plot/geospatial/DecimalLatitude,decimalLatitude,,http://rs.tdwg.org/dwc/terms/,85 |
| 50 | 50 |
/*s/plot/geospatial/DecimalLongitude,decimalLongitude,,http://rs.tdwg.org/dwc/terms/,86 |
| 51 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance[!attributeID]/value=1.37]/diameter,diameterBreastHeight,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=stems#stem_dbh,6
|
|
| 52 |
/*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,diameterBreastHeight.gentry,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=stems#gentry_dbh,7
|
|
| 51 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance[!attributeID]/value=1.37]/diameter,diameterBreastHeight,Expanded for clarity from stem_dbh,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=stems,6
|
|
| 52 |
/*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,diameterBreastHeight.gentry,Expanded for clarity from gentry_dbh,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=stems,7
|
|
| 53 | 53 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/obsEndDate,eventDate.end,,http://rs.tdwg.org/dwc/terms/,44 |
| 54 | 54 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/obsStartDate,eventDate.start,,http://rs.tdwg.org/dwc/terms/,44 |
| 55 | 55 |
"/*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=fam])/tcs:Name",family,,http://rs.tdwg.org/dwc/terms/,146 |
| mappings/VegCSV-VegBIEN.specimens.csv | ||
|---|---|---|
| 79 | 79 |
height,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/overallheight,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/individualOrganismObservations/individualOrganismObservation,4 |
| 80 | 80 |
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",
|
| 81 | 81 |
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,,http://rs.tdwg.org/dwc/terms/,25 |
| 82 |
basalDiameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=stems#basal_diam,5
|
|
| 82 |
basalDiameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter,Expanded for clarity from basal_diam,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=stems,5
|
|
| 83 | 83 |
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 |
| 84 | 84 |
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 |
| 85 |
diameterBreastHeight.gentry,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=gentryDiameter]]:[@fkey=tablerecord_id]/definedvalue",Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=stems#gentry_dbh,7
|
|
| 85 |
diameterBreastHeight.gentry,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=gentryDiameter]]:[@fkey=tablerecord_id]/definedvalue",Expanded for clarity from gentry_dbh,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=stems,7
|
|
| 86 | 86 |
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 |
| 87 | 87 |
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 |
| 88 |
diameterBreastHeight,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=stems#stem_dbh,6
|
|
| 88 |
diameterBreastHeight,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight,Expanded for clarity from stem_dbh,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=stems,6
|
|
| 89 | 89 |
height,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/individualOrganismObservations/individualOrganismObservation,4 |
| 90 | 90 |
heightFirstBranch,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/heightfirstbranch,,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=salvias_plots&table=plotObservations,43 |
| 91 | 91 |
//individualOrganism/identificationLabel[@id=1],"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2,, |
Also available in: Unified diff
mappings/VegX-VegCSV.stems.csv: Corrected SALVIAS stem diameter terms to place original name (before expansion for clarity) in the Comments column instead of appending it to the source URL, because the source URL should point just to the table the term is in. The actual term is identified directly by its order # and indirectly by the name of the VegCSV term, which should be similar (if not, the original term should be listed in the comments).