Project

General

Profile

« Previous | Next » 

Revision 3890

Added by Aaron Marcuse-Kubitza over 12 years ago

mappings/VegX-VegCSV.stems.csv: Added plot prefix to eventStartDate/eventEndDate to distinguish it from the DwC eventDate, which is the date the specimen was collected

View differences:

mappings/VegX-VegCSV.stems.csv
32 32 
/*s/plot/geospatial/DecimalLongitude,decimalLongitude,,http://rs.tdwg.org/dwc/terms/#decimalLongitude,86
33 33 
/*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 34 
/*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
35 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/obsEndDate,eventEndDate,,"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"
36 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/obsStartDate,eventStartDate,,"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"
37 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
38 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
39 37 
/*s/plot/geospatial/FootprintWKT,footprintWKT,,http://rs.tdwg.org/dwc/terms/#footprintWKT,91
......
66 64 
/*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/phosphorus,2
67 65 
"/*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/#phylum,143
68 66 
/*s/plot/area,plotArea,Table name added for clarity,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/area,11
67 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/obsEndDate,plotEventEndDate,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"
68 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/obsStartDate,plotEventStartDate,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"
69 69 
/*s/plot/plotUniqueIdentifier,plotID,,"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/#occurrenceID",", 0"
70 70 
/*s/plot/plotName,plotName,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotName,1
71 71 
/*s/plot/note,plotNotes,Table name added for uniqueness,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/note, http://rs.tdwg.org/dwc/terms/#fieldNotes","4, 54"
mappings/VegCSV-VegBIEN.specimens.csv
23 23 
plotName,/location/locationevent/authorlocationcode,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotName,1
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 
eventEndDate,/location/locationevent/obsenddate,,"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"
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 27 
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,,http://rs.tdwg.org/dwc/terms/#eventDate,44
28 
eventStartDate,/location/locationevent/obsstartdate,,"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"
28 
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 29 
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,,http://rs.tdwg.org/dwc/terms/#eventDate,44
30 30 
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 31 
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"
mappings/VegCSV.self.specimens.csv
69 69 
endDayOfYear,endDayOfYear
70 70 
establishmentMeans,establishmentMeans
71 71 
eventDate,eventDate
72 
eventEndDate,eventEndDate
73 72 
eventID,eventID
74 73 
eventRemarks,eventRemarks
75 
eventStartDate,eventStartDate
76 74 
eventTime,eventTime
77 75 
family,family
78 76 
fieldNotes,fieldNotes
......
173 171 
phosphorus,phosphorus
174 172 
phylum,phylum
175 173 
plotArea,plotArea
174 
plotEventEndDate,plotEventEndDate
175 
plotEventStartDate,plotEventStartDate
176 176 
plotID,plotID
177 177 
plotName,plotName
178 178 
plotNotes,plotNotes

Also available in: Unified diff