Project

General

Profile

« Previous | Next » 

Revision 3872

mappings/VegX-VegCSV.stems.csv: Corrected parent plot-only mappings by prefixing "parentPlot."

View differences:

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