Project

General

Profile

« Previous | Next » 

Revision 3891

mappings/VegX-VegCSV.stems.csv: Changed collectedDate to the associated DwC term eventDate

View differences:

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