Project

General

Profile

« Previous | Next » 

Revision 3880

mappings/VegX-VegCSV.stems.csv: Changed terms with table names to DwC terms where possible

View differences:

mappings/VegX-VegCSV.stems.csv
50 50
"/*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=binom])/fit",identificationQualifier,,http://rs.tdwg.org/dwc/terms/#identificationQualifier,124
51 51
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/aggregateOrganismObservation[*ID]/*/aggregateValue/value,individualCount,,http://rs.tdwg.org/dwc/terms/#individualCount,25
52 52
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/aggregateOrganismObservation[*ID]/*/aggregateValue/value,individualCount,,http://rs.tdwg.org/dwc/terms/#individualCount,25
53
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=sourceAccessionCode]/value,individualOrganismObservation.uniqueID,Field name shortened for standardization,"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",
54 53
"/*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=ssp])/tcs:Name",infraspecificEpithet,,http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,150
55 54
"/*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=reg])/tcs:Name",kingdom,,http://rs.tdwg.org/dwc/terms/#kingdom,142
56 55
/*s/plot/landform,landform,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/landform,18
......
62 61
/*s/plot/geospatial/minimumDepthInMeters,minimumDepthInMeters,,http://rs.tdwg.org/dwc/terms/#minimumDepthInMeters,74
63 62
/*s/plot/geospatial/minimumElevationInMeters,minimumElevationInMeters,,http://rs.tdwg.org/dwc/terms/#minimumElevationInMeters,71
64 63
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/nitrogen,nitrogen,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/nitrogen,5
64
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=sourceAccessionCode]/value,occurrenceID,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19
65 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=ord])/tcs:Name",order,,http://rs.tdwg.org/dwc/terms/#order,145
66 66
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=organic]/value,organic,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilOrganic,6
67 67
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,parentPlot.authorPlotCode,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename,1
......
69 69
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/ph,ph,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/ph,6
70 70
/*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
71 71
"/*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
72
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=method]/*ID/method/name,plot.method,Table name included to distinguish elements with a method,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+metadata.plot_methodology,
73 72
/*s/plot/note,plot.note,Table name included to distinguish elements with notes,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/note,4
74 73
/*s/plot/plotUniqueIdentifier,plot.uniqueID,Field name shortened for standardization,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotUniqueIdentifier,0
75 74
/*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
......
81 80
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/relativePlotPosition/relativeX,relativePlotX,Table name added for clarity,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/individualOrganismObservations/individualOrganismObservation/relativePlotPosition/relativeX,801
82 81
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/relativePlotPosition/relativeY,relativePlotY,Table name added for clarity,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/individualOrganismObservations/individualOrganismObservation/relativePlotPosition/relativeY,802
83 82
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/relativePlotPosition/relativeY,relativePlotY,Table name added for clarity,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/individualOrganismObservations/individualOrganismObservation/relativePlotPosition/relativeY,802
83
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=method]/*ID/method/name,samplingProtocol,,http://rs.tdwg.org/dwc/terms/#samplingProtocol,42
84 84
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=sand]/value,sand,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilSand,8
85 85
"/*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=binom])/tcs:Name",scientificName,,http://rs.tdwg.org/dwc/terms/#scientificName,134
86 86
"/*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=auth])/tcs:Name",scientificNameAuthorship,,http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship,153
mappings/VegCSV-VegBIEN.specimens.csv
17 17
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
18 18
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",,http://rs.tdwg.org/dwc/terms/#country,63
19 19
continent,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",,http://rs.tdwg.org/dwc/terms/#continent,59
20
plot.method,/location/locationevent/*_id/method/name,Table name included to distinguish elements with a method,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+metadata.plot_methodology,
20
samplingProtocol,/location/locationevent/*_id/method/name,,http://rs.tdwg.org/dwc/terms/#samplingProtocol,42
21 21
project.title,/location/locationevent/*_id/project/projectname,Table name included to distinguish elements with a title,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/projects/project/title,0
22 22
project.uniqueID,/location/locationevent/*_id/project/sourceaccessioncode,Field name shortened for standardization,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/projects/project, http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotUniqueIdentifier",
23 23
authorPlotCode,/location/locationevent/authorlocationcode,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename,1
......
60 60
institutionCode,/location/locationevent/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
61 61
establishmentMeans,"/location/locationevent/specimenreplicate/iscultivated/_map:[cultivated=t,wild=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
62 62
establishmentMeans,"/location/locationevent/specimenreplicate/isnative/_map:[native=t,exotic=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
63
occurrenceID,/location/locationevent/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19
64 63
dateIdentified,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value,,http://rs.tdwg.org/dwc/terms/#dateIdentified,120
65 64
identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
66 65
identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
......
77 76
//*s/individualOrganismObservation/volumeCanopy/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover,,,
78 77
authorPlantCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode,"""{"" sorts it with other _if:[name=specimenreplicate_via]s","http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=observation&entity=dba_tabledescription&where=where_tablename#authorObsCode, http://vegbiendev.nceas.ucsb.edu/phppgadmin/tblproperties.php?subject=table&table=plantobservation&server=localhost%3A5432%3Aallow&database=vegbien&schema=public#authorplantcode",4
79 78
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/height,4
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",
79
occurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,"""{"" sorts it with other _if:[name=specimenreplicate_via]s",http://rs.tdwg.org/dwc/terms/#occurrenceID,19
81 80
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,,http://rs.tdwg.org/dwc/terms/#individualCount,25
82 81
basalDiameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter,Expanded for clarity,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.basal_diam,5
83 82
canopyForm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tablerecord_id]/definedvalue",,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.stem_canopy_form,57
......
93 92
relativePlotX,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition,Table name added for clarity,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/individualOrganismObservations/individualOrganismObservation/relativePlotPosition/relativeX,801
94 93
relativePlotY,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,Table name added for clarity,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/individualOrganismObservations/individualOrganismObservation/relativePlotPosition/relativeY,802
95 94
growthForm,/location/locationevent/taxonoccurrence/growthform,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=observation&entity=dba_tabledescription&where=where_tablename#growthform1Type,62
96
individualOrganismObservation.uniqueID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,"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",
95
occurrenceID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,"""{"" sorts it with other _if:[name=specimenreplicate_via]s",http://rs.tdwg.org/dwc/terms/#occurrenceID,19
97 96
authorPlantCode,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2,"""{"" sorts it with other _if:[name=specimenreplicate_via]s","http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=observation&entity=dba_tabledescription&where=where_tablename#authorObsCode, http://vegbiendev.nceas.ucsb.edu/phppgadmin/tblproperties.php?subject=table&table=plantobservation&server=localhost%3A5432%3Aallow&database=vegbien&schema=public#authorplantcode",4
98 97
scientificName,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3,,http://rs.tdwg.org/dwc/terms/#scientificName,134
99 98
computer.taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first",,"http://rs.tdwg.org/dwc/terms/#taxonRank, https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/schemas/vegbien.sql#role.computer",151
......
126 125
plot.note,/location/notespublic,Table name included to distinguish elements with notes,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/note,4
127 126
slopeAspect,/location/slopeaspect/_compass/value,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/slopeAspect,15
128 127
slopeGradient,/location/slopegradient,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/slopeGradient,16
129
occurrenceID,/location/sourceaccessioncode/_alt/1,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19
130 128
institutionCode,/location/sourceaccessioncode/_alt/2/_merge/1,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
131 129
collectionCode,/location/sourceaccessioncode/_alt/2/_merge/2,,http://rs.tdwg.org/dwc/terms/#collectionCode,12
132 130
parentPlot.uniqueID,/location/sourceaccessioncode/_merge/1/_alt/1,Field name shortened for standardization,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotUniqueIdentifier,0
......
244 242
resourceID,,,http://rs.tdwg.org/dwc/terms/#resourceID,160
245 243
resourceRelationshipID,,,http://rs.tdwg.org/dwc/terms/#resourceRelationshipID,159
246 244
samplingEffort,,,http://rs.tdwg.org/dwc/terms/#samplingEffort,43
247
samplingProtocol,,,http://rs.tdwg.org/dwc/terms/#samplingProtocol,42
248 245
scientificNameID,,,http://rs.tdwg.org/dwc/terms/#scientificNameID,127
249 246
startDayOfYear,,,http://rs.tdwg.org/dwc/terms/#startDayOfYear,46
250 247
subgenus,,,http://rs.tdwg.org/dwc/terms/#subgenus,148
mappings/VegCSV.self.specimens.csv
111 111
identifiedBy,identifiedBy
112 112
individualCount,individualCount
113 113
individualID,individualID
114
individualOrganismObservation.uniqueID,individualOrganismObservation.uniqueID
115 114
informationWithheld,informationWithheld
116 115
infraspecificEpithet,infraspecificEpithet
117 116
institutionCode,institutionCode
......
177 176
ph,ph
178 177
phosphorus,phosphorus
179 178
phylum,phylum
180
plot.method,plot.method
181 179
plot.note,plot.note
182 180
plot.uniqueID,plot.uniqueID
183 181
plotArea,plotArea

Also available in: Unified diff