Revision 3872
Added by Aaron Marcuse-Kubitza over 12 years ago
mappings/VegX-VegCSV.stems.csv | ||
---|---|---|
15 | 15 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=precipitation]/value,//plotObservation/simpleUserdefined[name=precipitation]/value,,, |
16 | 16 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,acidity,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_acidity,42 |
17 | 17 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=authorPlantCode]/value,authorPlantCode,,"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 |
18 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,authorPlotCode,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename,1 |
|
19 | 18 |
/*s/plot/plotName,authorPlotCode,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename,1 |
20 | 19 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance/value=0]/diameter,basalDiameter,Expanded for clarity,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.basal_diam,5 |
21 | 20 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,baseSaturation,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#baseSaturation,14 |
... | ... | |
72 | 71 |
/*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 |
73 | 72 |
"/*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 |
74 | 73 |
/*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 |
74 |
/*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 |
|
75 |
/*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 |
|
75 | 76 |
/*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 |
76 | 77 |
/*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 |
77 | 78 |
"/*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 |
78 | 79 |
/*s/plot/note,plot.note,Table name included to distinguish from other notes,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plot.note,4 |
79 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*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 |
|
80 | 80 |
/*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 |
81 | 81 |
/*s/plot/area,plotArea,Table name prefixed for clarity,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotArea,11 |
82 | 82 |
/*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/potassium,3 |
mappings/VegCSV-VegBIEN.specimens.csv | ||
---|---|---|
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.start,44 |
29 | 29 |
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,,http://rs.tdwg.org/dwc/terms/#eventDate,44 |
30 |
plot.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 |
|
31 |
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 |
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 |
plot.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 |
|
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
|
|
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 |
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
|
|
34 | 34 |
//plotObservation/simpleUserdefined[name=precipitation]/value,/location/locationevent/precipitation,,, |
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 |
... | ... | |
129 | 129 |
occurrenceID,/location/sourceaccessioncode/_alt/1,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19 |
130 | 130 |
institutionCode,/location/sourceaccessioncode/_alt/2/_merge/1,,http://rs.tdwg.org/dwc/terms/#institutionCode,11 |
131 | 131 |
collectionCode,/location/sourceaccessioncode/_alt/2/_merge/2,,http://rs.tdwg.org/dwc/terms/#collectionCode,12 |
132 |
plot.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 |
|
133 |
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 |
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
|
|
133 |
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
|
|
134 | 134 |
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 |
135 | 135 |
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 |
136 | 136 |
acceptedNameUsage,,,http://rs.tdwg.org/dwc/terms/#acceptedNameUsage,135 |
mappings/VegCSV.self.specimens.csv | ||
---|---|---|
177 | 177 |
ownerInstitutionCode,ownerInstitutionCode |
178 | 178 |
parentNameUsage,parentNameUsage |
179 | 179 |
parentNameUsageID,parentNameUsageID |
180 |
parentPlot.authorPlotCode,parentPlot.authorPlotCode |
|
181 |
parentPlot.uniqueID,parentPlot.uniqueID |
|
180 | 182 |
ph,ph |
181 | 183 |
phosphorus,phosphorus |
182 | 184 |
phylum,phylum |
Also available in: Unified diff
mappings/VegX-VegCSV.stems.csv: Corrected parent plot-only mappings by prefixing "parentPlot."