Revision 6603
Added by Aaron Marcuse-Kubitza about 12 years ago
| mappings/VegCore.csv | ||
|---|---|---|
| 1 | 1 |
VegCore,Comments,Source,Order within table |
| 2 |
taxonNameOrEpithet,,"(0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#Taxon, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#specificEpithet, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#higherClassification, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#scientificName", |
|
| 2 |
taxonNameOrEpithet,,"(0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#Taxon, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#specificEpithet, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#higherClassification, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#scientificName",", 150, 141, 134"
|
|
| 3 | 3 |
acceptedNameUsage,,(0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#acceptedNameUsage,135 |
| 4 | 4 |
acceptedNameUsageID,,(0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#acceptedNameUsageID,128 |
| 5 | 5 |
associatedMedia,,(0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#associatedMedia,36 |
| ... | ... | |
| 249 | 249 |
longitude_DMS,Added units,(0:DwC)(2:Classic)http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Longitude,33 |
| 250 | 250 |
dateCollected,Prefix removed to use for non-ranges,(0:DwC)(8:history)http://rs.tdwg.org/dwc/terms/history/index.htm#EarliestDateCollected-2007-04-17, |
| 251 | 251 |
accordingTo,,(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonConcepts/TaxonConcept/AccordingTo, |
| 252 |
forma,,"(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonomicRankBelowSubspeciesEnum/fm, (8:Wikipedia)http://en.wikipedia.org/wiki/Taxonomic_rank#Ranks_in_botany", |
|
| 252 |
forma,,"(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonomicRankBelowSubspeciesEnum/fm, (8:Wikipedia)http://en.wikipedia.org/wiki/Taxonomic_rank#Ranks_in_botany",", "
|
|
| 253 | 253 |
acceptedVariety,,"(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonomicRankBelowSubspeciesEnum/fm, (8:Wikipedia)http://en.wikipedia.org/wiki/Taxonomic_rank#Ranks_in_botany, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#acceptedNameUsage",", , 135" |
| 254 | 254 |
originalVariety,,"(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonomicRankBelowSubspeciesEnum/fm, (8:Wikipedia)http://en.wikipedia.org/wiki/Taxonomic_rank#Ranks_in_botany, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#originalNameUsage",", , 137" |
| 255 |
verbatimVariety,,"(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonomicRankBelowSubspeciesEnum/fm, (8:Wikipedia)http://en.wikipedia.org/wiki/Taxonomic_rank#Ranks_in_botany, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#verbatimTaxonRank", |
|
| 256 |
variety,,"(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonomicRankBelowSubspeciesEnum/var, (8:Wikipedia)http://en.wikipedia.org/wiki/Taxonomic_rank#Ranks_in_botany", |
|
| 255 |
verbatimVariety,,"(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonomicRankBelowSubspeciesEnum/fm, (8:Wikipedia)http://en.wikipedia.org/wiki/Taxonomic_rank#Ranks_in_botany, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#verbatimTaxonRank",", , 152"
|
|
| 256 |
variety,,"(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonomicRankBelowSubspeciesEnum/var, (8:Wikipedia)http://en.wikipedia.org/wiki/Taxonomic_rank#Ranks_in_botany",", "
|
|
| 257 | 257 |
acceptedForma,,"(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonomicRankBelowSubspeciesEnum/var, (8:Wikipedia)http://en.wikipedia.org/wiki/Taxonomic_rank#Ranks_in_botany, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#acceptedNameUsage",", , 135" |
| 258 | 258 |
originalForma,,"(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonomicRankBelowSubspeciesEnum/var, (8:Wikipedia)http://en.wikipedia.org/wiki/Taxonomic_rank#Ranks_in_botany, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#originalNameUsage",", , 137" |
| 259 |
verbatimForma,,"(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonomicRankBelowSubspeciesEnum/var, (8:Wikipedia)http://en.wikipedia.org/wiki/Taxonomic_rank#Ranks_in_botany, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#verbatimTaxonRank", |
|
| 259 |
verbatimForma,,"(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonomicRankBelowSubspeciesEnum/var, (8:Wikipedia)http://en.wikipedia.org/wiki/Taxonomic_rank#Ranks_in_botany, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#verbatimTaxonRank",", , 152"
|
|
| 260 | 260 |
cultivar,,(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonomicRankCultivatedPlants/cv, |
| 261 | 261 |
acceptedCultivar,,"(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonomicRankCultivatedPlants/cv, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#acceptedNameUsage",", 135" |
| 262 | 262 |
originalCultivar,,"(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonomicRankCultivatedPlants/cv, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#originalNameUsage",", 137" |
| 263 |
verbatimCultivar,,"(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonomicRankCultivatedPlants/cv, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#verbatimTaxonRank", |
|
| 264 |
subspecies,,"(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonomicRankSpeciesGroupEnum/ssp, (8:Wikipedia)http://en.wikipedia.org/wiki/Taxonomic_rank#Ranks_in_botany", |
|
| 263 |
verbatimCultivar,,"(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonomicRankCultivatedPlants/cv, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#verbatimTaxonRank",", 152"
|
|
| 264 |
subspecies,,"(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonomicRankSpeciesGroupEnum/ssp, (8:Wikipedia)http://en.wikipedia.org/wiki/Taxonomic_rank#Ranks_in_botany",", "
|
|
| 265 | 265 |
acceptedSubspecies,,"(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonomicRankSpeciesGroupEnum/ssp, (8:Wikipedia)http://en.wikipedia.org/wiki/Taxonomic_rank#Ranks_in_botany, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#acceptedNameUsage",", , 135" |
| 266 | 266 |
originalSubspecies,,"(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonomicRankSpeciesGroupEnum/ssp, (8:Wikipedia)http://en.wikipedia.org/wiki/Taxonomic_rank#Ranks_in_botany, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#originalNameUsage",", , 137" |
| 267 |
verbatimSubspecies,,"(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonomicRankSpeciesGroupEnum/ssp, (8:Wikipedia)http://en.wikipedia.org/wiki/Taxonomic_rank#Ranks_in_botany, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#verbatimTaxonRank", |
|
| 267 |
verbatimSubspecies,,"(1:TCS)http://www.tdwg.org/standards/117/download/#/v101.xsd#/TaxonomicRankSpeciesGroupEnum/ssp, (8:Wikipedia)http://en.wikipedia.org/wiki/Taxonomic_rank#Ranks_in_botany, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#verbatimTaxonRank",", , 152"
|
|
| 268 | 268 |
magnesium_fraction,Added units,(2:VegX)http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/magnesium,4 |
| 269 | 269 |
magnesium_percent,Added units,(2:VegX)http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/magnesium,4 |
| 270 | 270 |
nitrogen_fraction,Added units,(2:VegX)http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/nitrogen,5 |
| ... | ... | |
| 366 | 366 |
observationMeasure,,"(5:BIEN)(1:VegBIEN)http://vegbiendev.nceas.ucsb.edu/phppgadmin/redirect.php?subject=table&server=localhost%3A5432%3Aallow&database=vegbien&schema=public&table=method#observationmeasure, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#samplingProtocol",", 42" |
| 367 | 367 |
sampleType,"e.g. plot, specimen","(5:BIEN)(1:VegBIEN)http://vegbiendev.nceas.ucsb.edu/phppgadmin/redirect.php?subject=table&server=localhost%3A5432%3Aallow&database=vegbien&schema=public&table=method#observationmeasure, (0:DwC)(0:terms)http://rs.tdwg.org/dwc/terms/#samplingProtocol",", 42" |
| 368 | 368 |
threatened,,(6:IUCN)http://www.iucnredlist.org/initiatives/europe/publications#The+IUCN+Red+List+of+Threatened+Species, |
| 369 |
speciesBinomial,genus+specificEpithet,"(8:Wikipedia)http://en.wikipedia.org/wiki/Binomial_nomenclature, (0:DwC)(2:Classic)http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Species", |
|
| 369 |
speciesBinomial,genus+specificEpithet,"(8:Wikipedia)http://en.wikipedia.org/wiki/Binomial_nomenclature, (0:DwC)(2:Classic)http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Species",", 12"
|
|
| 370 | 370 |
OMIT,Special value: The field contains data but is omitted. The reason for omission should be described in the mapping's comments.,, |
| 371 | 371 |
PRIVATE,Special value: The field contains private data which should be omitted from a public database,, |
| 372 | 372 |
UNUSED,Special value: The field does not contain any data. The following query should return no rows: SELECT * FROM table WHERE field IS NOT NULL,, |
Also available in: Unified diff
mappings/VegCore.csv: Order within table: Fixed to include one entry for every URL, including when the Order field is empty and there are multiple URLs