Project

General

Profile

« Previous | Next » 

Revision 3868

Added by Aaron Marcuse-Kubitza over 12 years ago

mappings/VegX-VegCSV.stems.csv: Source VegBank terms directly from the appropriate VegBank data dictionary page, to provide an automatic link to the description of the term. Having these direct links will also assist in creating a data dictionary for VegCSV and eventually VegBIEN (using mappings/VegCSV-VegBIEN.specimens.csv).

View differences:

mappings/VegX-VegCSV.stems.csv
18 18 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=method]/*ID/method/name,//plotObservation/simpleUserdefined[name=method]/*ID/method/name,,,
19 19 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=precipitation]/value,//plotObservation/simpleUserdefined[name=precipitation]/value,,,
20 20 
/*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
21 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=authorPlantCode]/value,authorPlantCode,,"http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#observation.authorObsCode, http://vegbiendev.nceas.ucsb.edu/phppgadmin/tblproperties.php?subject=table&table=plantobservation&server=localhost%3A5432%3Aallow&database=vegbien&schema=public#authorplantcode",4
21 
/*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
22 22 
/*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://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=stems&target=tbl_structure.php#basal_diam,5
23 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,baseSaturation,,http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#soilObs.baseSaturation,14
23 
/*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
24 24 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,calcium,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_Ca,40
25 25 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/simpleUserdefined[name=canopyForm]/value,canopyForm,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotObservations&target=tbl_structure.php#canopy_form,57
26 26 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/simpleUserdefined[name=canopyPosition]/value,canopyPosition,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotObservations&target=tbl_structure.php#canopy_position,56
27 27 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value,carbon,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_C,37
28 28 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/voucher,catalogNumber,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
29 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationExchangeCapacity]/value,cationExchangeCapacity,Expanded for clarity,"http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#soilObs.exchangeCapacity, http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_cation_cap",13
29 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationExchangeCapacity]/value,cationExchangeCapacity,Expanded for clarity,"http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#exchangeCapacity, http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_cation_cap",13
30 30 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=censusNo]/value,censusNumber,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotObservations&target=tbl_structure.php#census_no,4
31 31 
"/*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=cl])/tcs:Name",class,,http://rs.tdwg.org/dwc/terms/#class,144
32 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=clay]/value,clay,,http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#soilObs.soilClay,10
32 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=clay]/value,clay,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilClay,10
33 33 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,collectedDate,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien2_staging&table=nybg_raw&target=tbl_structure.php#CollectedDate,29
34 34 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=fam])/tcs:Name",computer.family,,"http://rs.tdwg.org/dwc/terms/#family, https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/schemas/vegbien.sql#role.computer",146
35 35 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=gen])/tcs:Name",computer.genus,,"http://rs.tdwg.org/dwc/terms/#genus, https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/schemas/vegbien.sql#role.computer",147
......
52 52 
/*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
53 53 
/*s/plot/geospatial/FootprintWKT,footprintWKT,,http://rs.tdwg.org/dwc/terms/#footprintWKT,91
54 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=gen])/tcs:Name",genus,,http://rs.tdwg.org/dwc/terms/#genus,147
55 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=growthForm]/value,growthForm,a.k.a. habit (SALVIAS: http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data),http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#observation.growthform1Type,62
55 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=growthForm]/value,growthForm,a.k.a. habit (SALVIAS: http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data),http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=observation&entity=dba_tabledescription&where=where_tablename#growthform1Type,62
56 56 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/simpleUserdefined[name=height]/value,height,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/individualOrganismObservations/individualOrganismObservation/height,4
57 57 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/height,height,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/individualOrganismObservations/individualOrganismObservation/height,4
58 58 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=height]/value,height,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/individualOrganismObservations/individualOrganismObservation/height,4
......
73 73 
/*s/plot/geospatial/minimumElevationInMeters,minimumElevationInMeters,,http://rs.tdwg.org/dwc/terms/#minimumElevationInMeters,71
74 74 
/*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
75 75 
"/*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
76 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=organic]/value,organic,,http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#soilObs.soilOrganic,6
76 
/*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
77 77 
/*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
78 78 
/*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
79 79 
"/*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
......
86 86 
/*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
87 87 
/*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
88 88 
/*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
89 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=sand]/value,sand,,http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#soilObs.soilSand,8
89 
/*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
90 90 
"/*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
91 91 
"/*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
92 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=silt]/value,silt,,http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#soilObs.soilSilt,9
92 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=silt]/value,silt,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilSilt,9
93 93 
/*s/plot/slopeAspect,slopeAspect,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/slopeAspect,15
94 94 
/*s/plot/slopeGradient,slopeGradient,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/slopeGradient,16
95 95 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,sodium,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_Na,41
96 96 
"/*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=sp])/tcs:Name",specificEpithet,,http://rs.tdwg.org/dwc/terms/#specificEpithet,149
97 97 
/*s/plot/location[placeType=state]/placeName,stateProvince,,http://rs.tdwg.org/dwc/terms/#stateProvince,65
98 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,texture,,http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#soilObs.soilTexture,7
98 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,texture,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilTexture,7
99 99 
/*s/plot/geospatial/verbatimElevation,verbatimElevation,,http://rs.tdwg.org/dwc/terms/#verbatimElevation,70
mappings/VegCSV-VegBIEN.specimens.csv
33 33 
//plot/plotUniqueIdentifier,/location/locationevent/parent_id/locationevent/sourceaccessioncode,,,
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 
baseSaturation,/location/locationevent/soilobs/basesaturation,,http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#soilObs.baseSaturation,14
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
37 37 
calcium,/location/locationevent/soilobs/calcium,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_Ca,40
38 38 
carbon,/location/locationevent/soilobs/carbon,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_C,37
39 
cationExchangeCapacity,/location/locationevent/soilobs/cationexchangecapacity,Expanded for clarity,"http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#soilObs.exchangeCapacity, http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_cation_cap",13
40 
clay,/location/locationevent/soilobs/clay,,http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#soilObs.soilClay,10
39 
cationExchangeCapacity,/location/locationevent/soilobs/cationexchangecapacity,Expanded for clarity,"http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#exchangeCapacity, http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_cation_cap",13
40 
clay,/location/locationevent/soilobs/clay,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilClay,10
41 41 
conductivity,/location/locationevent/soilobs/conductivity,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_conductivity,45
42 42 
magnesium,/location/locationevent/soilobs/magnesium,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/magnesium,4
43 43 
nitrogen,/location/locationevent/soilobs/nitrogen,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/nitrogen,5
44 
organic,/location/locationevent/soilobs/organic,,http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#soilObs.soilOrganic,6
44 
organic,/location/locationevent/soilobs/organic,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilOrganic,6
45 45 
ph,/location/locationevent/soilobs/ph,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/ph,6
46 46 
phosphorus,/location/locationevent/soilobs/phosphorus,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/phosphorus,2
47 47 
potassium,/location/locationevent/soilobs/potassium,Spelling corrected,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/potassium,3
48 
sand,/location/locationevent/soilobs/sand,,http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#soilObs.soilSand,8
49 
silt,/location/locationevent/soilobs/silt,,http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#soilObs.soilSilt,9
48 
sand,/location/locationevent/soilobs/sand,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilSand,8
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 
texture,/location/locationevent/soilobs/texture,,http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#soilObs.soilTexture,7
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 52 
//plot/plotUniqueIdentifier,/location/locationevent/sourceaccessioncode,,,
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
......
75 75 
//ordinal/coverPercent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,,,
76 76 
censusNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue",Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotObservations&target=tbl_structure.php#census_no,4
77 77 
//*s/individualOrganismObservation/volumeCanopy/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover,,,
78 
authorPlantCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode,"""{"" sorts it with other _if:[name=specimenreplicate_via]s","http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#observation.authorObsCode, http://vegbiendev.nceas.ucsb.edu/phppgadmin/tblproperties.php?subject=table&table=plantobservation&server=localhost%3A5432%3Aallow&database=vegbien&schema=public#authorplantcode",4
78 
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 79 
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 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",
81 81 
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,,http://rs.tdwg.org/dwc/terms/#individualCount,25
......
92 92 
//individualOrganism/identificationLabel[@id=2],/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag,,,
93 93 
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 94 
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 
growthForm,/location/locationevent/taxonoccurrence/growthform,a.k.a. habit (SALVIAS: http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data),http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#observation.growthform1Type,62
95 
growthForm,/location/locationevent/taxonoccurrence/growthform,a.k.a. habit (SALVIAS: http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data),http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=observation&entity=dba_tabledescription&where=where_tablename#growthform1Type,62
96 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",
97 
authorPlantCode,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2,"""{"" sorts it with other _if:[name=specimenreplicate_via]s","http://vegbank.org/vegdocs/design/erd/vegbank_erd.pdf#observation.authorObsCode, http://vegbiendev.nceas.ucsb.edu/phppgadmin/tblproperties.php?subject=table&table=plantobservation&server=localhost%3A5432%3Aallow&database=vegbien&schema=public#authorplantcode",4
97 
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 98 
scientificName,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3,,http://rs.tdwg.org/dwc/terms/#scientificName,134
99 99 
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
100 100 
computer.scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",,"http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship, https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/schemas/vegbien.sql#role.computer",153

Also available in: Unified diff