Revision 5013
Added by Aaron Marcuse-Kubitza over 12 years ago
| mappings/Veg+-VegCore.csv | ||
|---|---|---|
| 1 | 1 |
Veg+,VegCore,Comments,Source,Order within table |
| 2 |
acidity,"?acidity_percent, acidity_fraction",,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_acidity,42 |
|
| 3 |
baseSaturation,"?baseSaturation_percent, baseSaturation_fraction",,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#baseSaturation,14 |
|
| 4 |
calcium,"?calcium_percent, calcium_fraction",Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_Ca,40 |
|
| 5 |
carbon,"?carbon_percent, carbon_fraction",Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_C,37 |
|
| 6 |
cationExchangeCapacity,?cationExchangeCapacity_cmol_kg,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, 44" |
|
| 7 |
clay,"?clay_percent, clay_fraction",,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilClay,10 |
|
| 8 |
DBH,"?diameterBreastHeight_cm, diameterBreastHeight_in",Table removed because term is unique,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.stem_dbh,36 |
|
| 9 |
magnesium,"?magnesium_percent, magnesium_fraction",,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/magnesium,4 |
|
| 10 |
nitrogen,"?nitrogen_percent, nitrogen_fraction",,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/nitrogen,5 |
|
| 11 |
organic,"?organic_percent, organic_fraction",,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilOrganic,6 |
|
| 12 |
phosphorus,"?phosphorus_percent, phosphorus_fraction",,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/phosphorus,2 |
|
| 13 |
potassium,"?potassium_percent, potassium_fraction",Spelling corrected,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/pottasium,3 |
|
| 14 |
sand,"?sand_percent, sand_fraction",,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilSand,8 |
|
| 15 |
silt,"?silt_percent, silt_fraction",,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilSilt,9 |
|
| 16 |
sodium,"?sodium_percent, sodium_fraction",Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_Na,41 |
|
| 2 | 17 |
realLatitude,PRIVATE,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename#realLatitude, |
| 3 | 18 |
realLongitude,PRIVATE,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename#realLongitude, |
| 4 |
acidity,"acidity_percent, acidity_fraction",,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_acidity,42 |
|
| 5 |
baseSaturation,"baseSaturation_percent, baseSaturation_fraction",,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#baseSaturation,14 |
|
| 6 |
calcium,"calcium_percent, calcium_fraction",Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_Ca,40 |
|
| 7 |
carbon,"carbon_percent, carbon_fraction",Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_C,37 |
|
| 8 |
cationExchangeCapacity,cationExchangeCapacity_cmol_kg?,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, 44" |
|
| 9 |
clay,"clay_percent, clay_fraction",,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilClay,10 |
|
| 10 | 19 |
continentOcean,continent,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ContinentOcean,17 |
| 11 | 20 |
countryName,country,,CTFS#Country.CountryName, |
| 12 | 21 |
collectedDate,dateCollected,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien2_staging&table=nybg_raw&target=tbl_structure.php#CollectedDate,29 |
| ... | ... | |
| 23 | 32 |
type,dcterms:type,Versions without namespace,http://rs.tdwg.org/dwc/terms/#type,0 |
| 24 | 33 |
latitude,decimalLatitude,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Latitude,34 |
| 25 | 34 |
longitude,decimalLongitude,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Longitude,33 |
| 26 |
DBH,"diameterBreastHeight_cm, diameterBreastHeight_in",Table removed because term is unique,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.stem_dbh,36 |
|
| 27 | 35 |
plotEventEndDate,endDate,Table added for uniqueness,"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/#eventDate, http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=observation&entity=dba_tabledescription&where=where_tablename#obsEndDate",", 44, 6" |
| 28 | 36 |
censusID,eventID,,CTFS#Census.CensusID, |
| 29 | 37 |
plotEventID,eventID,,"http://rs.tdwg.org/dwc/terms/#eventID, http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename","41, " |
| ... | ... | |
| 38 | 46 |
locationName,locality,,CTFS#Site.LocationName, |
| 39 | 47 |
locationNarrative,locality,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/locationNarrative,6 |
| 40 | 48 |
plotID,locationID,,"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" |
| 41 |
magnesium,"magnesium_percent, magnesium_fraction",,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/magnesium,4 |
|
| 42 | 49 |
maximumDepth,maximumDepthInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MaximumDepth,40 |
| 43 | 50 |
maximumElevation,maximumElevationInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MaximumElevation,38 |
| 44 | 51 |
minimumDepth,minimumDepthInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MinimumDepth,39 |
| 45 | 52 |
minimumElevation,minimumElevationInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MinimumElevation,37 |
| 46 |
nitrogen,"nitrogen_percent, nitrogen_fraction",,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/nitrogen,5 |
|
| 47 | 53 |
ID,occurrenceID,,"ACAD#id, MT#id, QMOR#id, U#ID", |
| 48 | 54 |
globalUniqueIdentifier,occurrenceID,,http://rs.tdwg.org/dwc/tdwg_dw_core.xsd#/GlobalUniqueIdentifier,0 |
| 49 |
organic,"organic_percent, organic_fraction",,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilOrganic,6 |
|
| 50 | 55 |
relativePlotX,organismX,Table 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 |
| 51 | 56 |
relativePlotY,organismY,Table 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 |
| 52 | 57 |
previousCatalogNumber,otherCatalogNumbers,,"http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/PreviousCatalogNumber, http://rs.tdwg.org/dwc/terms/history/index.htm#PreviousCatalogNumber-2003-06-13","44, " |
| 53 | 58 |
parentPlotID,parentLocationID,,"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","3, 0" |
| 54 |
phosphorus,"phosphorus_percent, phosphorus_fraction",,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/phosphorus,2 |
|
| 55 |
potassium,"potassium_percent, potassium_fraction",Spelling corrected,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/pottasium,3 |
|
| 56 | 59 |
preparation,preparations,,REMIB#preparation, |
| 57 | 60 |
preparationType,preparations,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/PreparationType,42 |
| 58 | 61 |
authorPlantCode,recordNumber,,http://vegbiendev.nceas.ucsb.edu/phppgadmin/tblproperties.php?subject=table&table=plantobservation&server=localhost%3A5432%3Aallow&database=vegbien&schema=public#authorplantcode,6 |
| ... | ... | |
| 62 | 65 |
collector.surName,recordedBy.surName,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=taxoninterpretation&entity=dba_tabledescription&where=where_tablename#collector_ID,14 |
| 63 | 66 |
relatedCatalogItem,relatedResourceID,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/RelatedCatalogItem,46 |
| 64 | 67 |
relationshipType,relationshipOfResource,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/RelationshipType,45 |
| 65 |
sand,"sand_percent, sand_fraction",,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilSand,8 |
|
| 66 | 68 |
scientificNameAuthor,scientificNameAuthorship,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ScientificNameAuthor,50 |
| 67 |
silt,"silt_percent, silt_fraction",,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilSilt,9 |
|
| 68 |
sodium,"sodium_percent, sodium_fraction",Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_Na,41 |
|
| 69 | 69 |
species,specificEpithet,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Species,12 |
| 70 | 70 |
speciesName,specificEpithet,,CTFS#Species.SpeciesName, |
| 71 | 71 |
plotEventStartDate,startDate,Table added for uniqueness,"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/#eventDate, http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=observation&entity=dba_tabledescription&where=where_tablename#obsStartDate",", 44, 5" |
Also available in: Unified diff
mappings/Veg+-VegCore.csv: Prefix ambiguous terms' VegCore replacement with "?" so it's visually flagged in map.csv, in the same way that unmatched terms are flagged with a "*" prefix