Revision 3891
Added by Aaron Marcuse-Kubitza over 12 years ago
mappings/VegX-VegCSV.stems.csv | ||
---|---|---|
16 | 16 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=censusNo]/value,censusNumber,Expanded for clarity,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.census_no,3 |
17 | 17 |
"/*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/#class,144 |
18 | 18 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=clay]/value,clay,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilClay,10 |
19 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,collectedDate,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien2_staging&table=nybg_raw&target=tbl_structure.php#CollectedDate,29 |
|
20 | 19 |
"/*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/#family, https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/schemas/vegbien.sql#role.computer","146, 2" |
21 | 20 |
"/*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/#genus, https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/schemas/vegbien.sql#role.computer","147, 2" |
22 | 21 |
"/*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/#infraspecificEpithet, https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/schemas/vegbien.sql#role.computer","150, 2" |
... | ... | |
32 | 31 |
/*s/plot/geospatial/DecimalLongitude,decimalLongitude,,http://rs.tdwg.org/dwc/terms/#decimalLongitude,86 |
33 | 32 |
/*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://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.stem_dbh,36 |
34 | 33 |
/*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 |
34 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,eventDate,,http://rs.tdwg.org/dwc/terms/#eventDate,44 |
|
35 | 35 |
"/*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 |
36 | 36 |
/*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 |
37 | 37 |
/*s/plot/geospatial/FootprintWKT,footprintWKT,,http://rs.tdwg.org/dwc/terms/#footprintWKT,91 |
mappings/VegCSV-VegBIEN.specimens.csv | ||
---|---|---|
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,,, |
26 | 26 |
plotEventEndDate,/location/locationevent/obsenddate,Table name added for uniqueness,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot, http://rs.tdwg.org/dwc/terms/#eventDate, http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=observation&entity=dba_tabledescription&where=where_tablename#obsEndDate",", 44, 6" |
27 |
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,,http://rs.tdwg.org/dwc/terms/#eventDate,44 |
|
28 | 27 |
plotEventStartDate,/location/locationevent/obsstartdate,Table name added for uniqueness,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot, http://rs.tdwg.org/dwc/terms/#eventDate, http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=observation&entity=dba_tabledescription&where=where_tablename#obsStartDate",", 44, 5" |
29 |
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,,http://rs.tdwg.org/dwc/terms/#eventDate,44 |
|
30 | 28 |
parentPlotID,/location/locationevent/parent_id/locationevent/*_id/location/sourceaccessioncode/_alt/1,,"http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename#PARENT_ID, http://rs.tdwg.org/dwc/terms/#occurrenceID","3, 0" |
31 | 29 |
parentPlotName,/location/locationevent/parent_id/locationevent/*_id/location/sourceaccessioncode/_alt/2,,"http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename#PARENT_ID, http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotName","3, 1" |
32 | 30 |
parentPlotName,/location/locationevent/parent_id/locationevent/authorlocationcode,,"http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename#PARENT_ID, http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotName","3, 1" |
... | ... | |
67 | 65 |
recordedBy,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/#recordedBy,23 |
68 | 66 |
voucherType,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/cond/_eq:[right=direct]/left,"values: direct, indirect",http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.det_type,17 |
69 | 67 |
catalogNumber,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20 |
70 |
collectedDate,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/collectiondate,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien2_staging&table=nybg_raw&target=tbl_structure.php#CollectedDate,29
|
|
68 |
eventDate,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/collectiondate,,http://rs.tdwg.org/dwc/terms/#eventDate,44
|
|
71 | 69 |
catalogNumber,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20 |
72 |
collectedDate,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/collectiondate,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien2_staging&table=nybg_raw&target=tbl_structure.php#CollectedDate,29
|
|
70 |
eventDate,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/collectiondate,,http://rs.tdwg.org/dwc/terms/#eventDate,44
|
|
73 | 71 |
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,,http://rs.tdwg.org/dwc/terms/#individualCount,25 |
74 | 72 |
//ordinal/coverPercent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,,, |
75 | 73 |
censusNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue",Expanded for clarity,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.census_no,3 |
mappings/VegCSV.self.specimens.csv | ||
---|---|---|
26 | 26 |
censusNumber,censusNumber |
27 | 27 |
class,class |
28 | 28 |
clay,clay |
29 |
collectedDate,collectedDate |
|
30 | 29 |
collectionCode,collectionCode |
31 | 30 |
collectionID,collectionID |
32 | 31 |
computer.family,computer.family |
Also available in: Unified diff
mappings/VegX-VegCSV.stems.csv: Changed collectedDate to the associated DwC term eventDate