Project

General

Profile

« Previous | Next » 

Revision 3881

mappings/VegX-VegCSV.stems.csv: Changed uniqueIDs with table names to the table name + "ID", for standardization

View differences:

mappings/VegX-VegCSV.stems.csv
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
68
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,parentPlot.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
68
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,parentPlotID,,"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",0
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 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
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
74 73
/*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
74
/*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
75 75
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/potassium,potassium,Spelling corrected,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/pottasium,3
76 76
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=precipitation]/value,precipitation,Expanded for clarity,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+metadata.precip_mm,13
77 77
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/*ID->/*s/project/title[@id=name],project.title,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
78
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/*ID->/*s/project/title[@id=sourceAccessionCode],project.uniqueID,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",
78
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/*ID->/*s/project/title[@id=sourceAccessionCode],projectID,,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/projects/project, http://rs.tdwg.org/dwc/terms/#occurrenceID",
79 79
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/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
80 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
81 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
mappings/VegCSV-VegBIEN.specimens.csv
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 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
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",
22
projectID,/location/locationevent/*_id/project/sourceaccessioncode,,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/projects/project, http://rs.tdwg.org/dwc/terms/#occurrenceID",
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
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,,,
......
27 27
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,,http://rs.tdwg.org/dwc/terms/#eventDate,44
28 28
eventDate.start,/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
29 29
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,,http://rs.tdwg.org/dwc/terms/#eventDate,44
30
parentPlot.uniqueID,/location/locationevent/parent_id/locationevent/*_id/location/sourceaccessioncode/_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
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",0
31 31
parentPlot.authorPlotCode,/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,1
32 32
parentPlot.authorPlotCode,/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,1
33
parentPlot.uniqueID,/location/locationevent/parent_id/locationevent/sourceaccessioncode,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
33
parentPlotID,/location/locationevent/parent_id/locationevent/sourceaccessioncode,,"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",0
34 34
precipitation,/location/locationevent/precipitation,Expanded for clarity,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+metadata.precip_mm,13
35 35
acidity,/location/locationevent/soilobs/acidity,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_acidity,42
36 36
baseSaturation,/location/locationevent/soilobs/basesaturation,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#baseSaturation,14
......
49 49
silt,/location/locationevent/soilobs/silt,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilSilt,9
50 50
sodium,/location/locationevent/soilobs/sodium,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_Na,41
51 51
texture,/location/locationevent/soilobs/texture,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilTexture,7
52
plot.uniqueID,/location/locationevent/sourceaccessioncode,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
52
plotID,/location/locationevent/sourceaccessioncode,,"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
53 53
collectionCode,/location/locationevent/specimenreplicate/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,http://rs.tdwg.org/dwc/terms/#collectionCode,12
54 54
recordNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/1,,http://rs.tdwg.org/dwc/terms/#recordNumber,22
55 55
collectionID,/location/locationevent/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9
......
127 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
128 128
institutionCode,/location/sourceaccessioncode/_alt/2/_merge/1,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
129 129
collectionCode,/location/sourceaccessioncode/_alt/2/_merge/2,,http://rs.tdwg.org/dwc/terms/#collectionCode,12
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
130
parentPlotID,/location/sourceaccessioncode/_merge/1/_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",0
131 131
parentPlot.authorPlotCode,/location/sourceaccessioncode/_merge/1/_alt/2,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename,1
132
plot.uniqueID,/location/sourceaccessioncode/_merge/2/_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
132
plotID,/location/sourceaccessioncode/_merge/2/_alt/1,,"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
133 133
authorPlotCode,/location/sourceaccessioncode/_merge/2/_alt/2,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename,1
134 134
acceptedNameUsage,,,http://rs.tdwg.org/dwc/terms/#acceptedNameUsage,135
135 135
acceptedNameUsageID,,,http://rs.tdwg.org/dwc/terms/#acceptedNameUsageID,128
mappings/VegCSV.self.specimens.csv
172 172
parentNameUsage,parentNameUsage
173 173
parentNameUsageID,parentNameUsageID
174 174
parentPlot.authorPlotCode,parentPlot.authorPlotCode
175
parentPlot.uniqueID,parentPlot.uniqueID
175
parentPlotID,parentPlotID
176 176
ph,ph
177 177
phosphorus,phosphorus
178 178
phylum,phylum
179 179
plot.note,plot.note
180
plot.uniqueID,plot.uniqueID
181 180
plotArea,plotArea
181
plotID,plotID
182 182
pointRadiusSpatialFit,pointRadiusSpatialFit
183 183
potassium,potassium
184 184
precipitation,precipitation
185 185
preparations,preparations
186 186
previousIdentifications,previousIdentifications
187 187
project.title,project.title
188
project.uniqueID,project.uniqueID
188
projectID,projectID
189 189
recordNumber,recordNumber
190 190
recordedBy,recordedBy
191 191
relatedResourceID,relatedResourceID

Also available in: Unified diff