Revision 3906
Added by Aaron Marcuse-Kubitza over 12 years ago
| mappings/VegX-VegCSV.stems.csv | ||
|---|---|---|
| 31 | 31 |
/*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,diameterBreastHeightGentry,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=stems&target=tbl_structure.php#gentry_dbh,7 |
| 32 | 32 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,eventDate,,http://rs.tdwg.org/dwc/terms/#eventDate,44 |
| 33 | 33 |
"/*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/#family,146 |
| 34 |
/*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/#fieldNotes,54
|
|
| 34 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,fieldNotes,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54 |
|
| 35 | 35 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=authorPlantCode]/value,fieldNumber,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53 |
| 36 | 36 |
/*s/plot/geospatial/FootprintWKT,footprintWKT,,http://rs.tdwg.org/dwc/terms/#footprintWKT,91 |
| 37 | 37 |
"/*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/#genus,147 |
| ... | ... | |
| 90 | 90 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,sodium,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_Na,41 |
| 91 | 91 |
"/*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=sp])/tcs:Name",specificEpithet,,http://rs.tdwg.org/dwc/terms/#specificEpithet,149 |
| 92 | 92 |
/*s/plot/location[placeType=state]/placeName,stateProvince,,http://rs.tdwg.org/dwc/terms/#stateProvince,65 |
| 93 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,stemNotes,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=stems&target=tbl_structure.php#stem_notes,8 |
|
| 93 | 94 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel[@id=1],tag,Number removed for clarity,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.tag2,9 |
| 94 | 95 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/identificationLabel[@id=1],tag,Number removed for clarity,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.tag2,9 |
| 95 | 96 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/temperature,temperature,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plotObservations/plotObservation/observationConditions/temperature,1900 |
| mappings/VegCSV-VegBIEN.specimens.csv | ||
|---|---|---|
| 85 | 85 |
family,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,http://rs.tdwg.org/dwc/terms/#family,146 |
| 86 | 86 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,http://rs.tdwg.org/dwc/terms/#family,146 |
| 87 | 87 |
fieldNotes,/location/locationevent/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54 |
| 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/#fieldNotes,54 |
|
| 88 |
fieldNotes,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54 |
|
| 89 |
fieldNotes,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54 |
|
| 89 | 90 |
fieldNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53 |
| 90 | 91 |
fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode,"""{"" sorts it with other _if:[name=specimenreplicate_via]s",http://rs.tdwg.org/dwc/terms/#fieldNumber,53
|
| 91 | 92 |
fieldNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2,"""{"" sorts it with other _if:[name=specimenreplicate_via]s",http://rs.tdwg.org/dwc/terms/#fieldNumber,53
|
| ... | ... | |
| 260 | 261 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://rs.tdwg.org/dwc/terms/#specificEpithet,149 |
| 261 | 262 |
startDayOfYear,,,http://rs.tdwg.org/dwc/terms/#startDayOfYear,46 |
| 262 | 263 |
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,http://rs.tdwg.org/dwc/terms/#stateProvince,65 |
| 264 |
stemNotes,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=notes]]:[@fkey=tablerecord_id]/definedvalue",,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=stems&target=tbl_structure.php#stem_notes,8 |
|
| 263 | 265 |
subgenus,,,http://rs.tdwg.org/dwc/terms/#subgenus,148 |
| 264 | 266 |
tag,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Number removed for clarity; Quotes sort it before tag2,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.tag2,9 |
| 265 | 267 |
taxonConceptID,,,http://rs.tdwg.org/dwc/terms/#taxonConceptID,133 |
| mappings/VegCSV.self.specimens.csv | ||
|---|---|---|
| 208 | 208 |
specificEpithet,specificEpithet |
| 209 | 209 |
startDayOfYear,startDayOfYear |
| 210 | 210 |
stateProvince,stateProvince |
| 211 |
stemNotes,stemNotes |
|
| 211 | 212 |
subgenus,subgenus |
| 212 | 213 |
tag,tag |
| 213 | 214 |
taxonConceptID,taxonConceptID |
| mappings/for_review/VegX-VegCSV.stems.csv | ||
|---|---|---|
| 31 | 31 |
/*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,diameterBreastHeightGentry,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=stems&target=tbl_structure.php#gentry_dbh,7 |
| 32 | 32 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,eventDate,,http://rs.tdwg.org/dwc/terms/#eventDate,44 |
| 33 | 33 |
"/*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/#family,146 |
| 34 |
/*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/#fieldNotes,54
|
|
| 34 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,fieldNotes,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54 |
|
| 35 | 35 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=authorPlantCode]/value,fieldNumber,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53 |
| 36 | 36 |
/*s/plot/geospatial/FootprintWKT,footprintWKT,,http://rs.tdwg.org/dwc/terms/#footprintWKT,91 |
| 37 | 37 |
"/*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/#genus,147 |
| ... | ... | |
| 90 | 90 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,sodium,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_Na,41 |
| 91 | 91 |
"/*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=sp])/tcs:Name",specificEpithet,,http://rs.tdwg.org/dwc/terms/#specificEpithet,149 |
| 92 | 92 |
/*s/plot/location[placeType=state]/placeName,stateProvince,,http://rs.tdwg.org/dwc/terms/#stateProvince,65 |
| 93 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,stemNotes,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=stems&target=tbl_structure.php#stem_notes,8 |
|
| 93 | 94 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel[@id=1],tag,Number removed for clarity,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.tag2,9 |
| 94 | 95 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/identificationLabel[@id=1],tag,Number removed for clarity,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.tag2,9 |
| 95 | 96 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/temperature,temperature,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plotObservations/plotObservation/observationConditions/temperature,1900 |
Also available in: Unified diff
mappings/VegX-VegCSV.stems.csv: Remapped stem notes to new stemNotes term, and mapped new organism notes VegX XPath to now-available DwC fieldNotes