VegCore

Combines 371 terms from existing vegetation data formats

Note: Some links point to a location within a text file. For these links, mouse over the link to see the location within the file.

Examples

Example specimen data

See ACAD.Specimen.csv1, which contains well-formed Darwin Core data.

1 The dataset is from ACAD, a Canadensys herbarium, so it's public domain.
.

Index

Categories: Record, Occurrence, Event, Location, GeologicalContext, Identification, Taxon, ResourceRelationship, MeasurementOrFact, Uncategorized

Namespaces

DwC

Darwin Core

VegCore is a strict superset, adding ~200 terms to Darwin Core

TCS

Taxonomic Concept Schema

VegX

VegX

VegBank

VegBank

SALVIAS

SALVIAS

BIEN2

BIEN2

BIEN2-web

schema | database

BIEN2-core

schema | database

BIEN2-geoscrub

database

BIEN2-staging

database

VegBIEN

VegBIEN

Record

Sources: DwC:Record-level Terms

type

Sources: DwC:dcterms:type

modified

"I think is this merely an internal timestamp indicated when record last modified, not necessarily when determination (taxon name) last modified" (Brad Boyle)

Sources: DwC:dcterms:modified

language

Sources: DwC:dcterms:language

rights

Sources: DwC:dcterms:rights

rightsHolder

Sources: DwC:dcterms:rightsHolder

accessRights

Sources: DwC:dcterms:accessRights

bibliographicCitation

Sources: DwC:dcterms:bibliographicCitation

references

Sources: DwC:dcterms:references

institutionID

Sources: DwC:institutionID

collectionID

Sources: DwC:collectionID

datasetID

Sources: DwC:datasetID

institutionCode

Sources: DwC:institutionCode

collectionCode

Sources: DwC:collectionCode

datasetName

Sources: DwC:datasetName

ownerInstitutionCode

Sources: DwC:ownerInstitutionCode

basisOfRecord

Sources: DwC:basisOfRecord

informationWithheld

Sources: DwC:informationWithheld

dataGeneralizations

Sources: DwC:dataGeneralizations

dynamicProperties

Sources: DwC:dynamicProperties

Occurrence

Sources: DwC:Occurrence (components)

occurrenceID

Sources: DwC:occurrenceID

catalogNumber

Sources: DwC:catalogNumber

occurrenceRemarks

Sources: DwC:occurrenceRemarks

recordNumber

Sources: DwC:recordNumber

recordedBy

"A list (concatenated and separated) of names of people, groups, or organizations responsible for recording the original Occurrence. The primary collector or observer, especially one who applies a personal identifier (recordNumber), should be listed first." (DwC)

Sources: DwC:recordedBy

recordedBy_givenName

"The given name" (VegX) of "The primary collector or observer, especially one who applies a personal identifier (recordNumber)" (DwC)

Sources: DwC:recordedBy, VegX:givenName

recordedBy_surName

"The last name" (VegX) of "The primary collector or observer, especially one who applies a personal identifier (recordNumber)" (DwC)

Sources: DwC:recordedBy, VegX:surName

recordedBy_middleName

The "middle name or initial" (VegBank) of "The primary collector or observer, especially one who applies a personal identifier (recordNumber)" (DwC)

Sources: DwC:recordedBy, VegBank:middleName

individualID

Sources: DwC:individualID

individualCount

Sources: DwC:individualCount

sex

Sources: DwC:sex

lifeStage

Sources: DwC:lifeStage

reproductiveCondition

Sources: DwC:reproductiveCondition

behavior

Sources: DwC:behavior

establishmentMeans

Sources: DwC:establishmentMeans

cultivated

Sources: DwC:cultivated
Comments: Picklist value extracted

cultivatedBasis

Sources: DwC:cultivated
Comments: Picklist value extracted

occurrenceStatus

Sources: DwC:occurrenceStatus

preparations

Sources: DwC:preparations

disposition

Sources: DwC:disposition

otherCatalogNumbers

Sources: DwC:otherCatalogNumbers

previousIdentifications

Sources: DwC:previousIdentifications

associatedMedia

Sources: DwC:associatedMedia

associatedReferences

Sources: DwC:associatedReferences

associatedOccurrences

Sources: DwC:associatedOccurrences

associatedSequences

Sources: DwC:associatedSequences

associatedTaxa

Sources: DwC:associatedTaxa

Event

Sources: DwC:Event (components)

eventID

Sources: DwC:eventID

samplingProtocol

Sources: DwC:samplingProtocol

samplingProtocolID

Sources: DwC:samplingProtocol, DwC:occurrenceID

samplingEffort

Sources: DwC:samplingEffort

eventDate

"The date-time or interval during which an Event occurred" (DwC)

Sources: DwC:eventDate

startDate

"The start date" (VegX) of the "interval during which an Event occurred" (DwC)

Sources: DwC:eventDate, VegX:obsStartDate
Comments: Table removed because a date range usually applies to the event

endDate

"The end date" (VegX) of the "interval during which an Event occurred" (DwC)

Sources: DwC:eventDate, VegX:obsEndDate
Comments: Table removed because a date range usually applies to the event

eventTime

Sources: DwC:eventTime

startDayOfYear

Sources: DwC:startDayOfYear

endDayOfYear

Sources: DwC:endDayOfYear

year

Sources: DwC:year

month

Sources: DwC:month

day

Sources: DwC:day

verbatimEventDate

Sources: DwC:verbatimEventDate

habitat

Sources: DwC:habitat

fieldNumber

Sources: DwC:fieldNumber

fieldNotes

Sources: DwC:fieldNotes

eventRemarks

Sources: DwC:eventRemarks

Location

Sources: DwC:Location (components)

locationID

Sources: DwC:locationID

parentLocationID

Sources: DwC:locationID, VegBank:PARENT_ID

subplotID

Sources: DwC:locationID, SALVIAS:subplot

higherGeographyID

Sources: DwC:higherGeographyID

higherGeography

Sources: DwC:higherGeography

continent

Sources: DwC:continent

waterBody

Sources: DwC:waterBody

islandGroup

Sources: DwC:islandGroup

island

Sources: DwC:island

country

Sources: DwC:country

acceptedCountry

Sources: DwC:country, DwC:acceptedNameUsage

countryCode

Sources: DwC:countryCode

stateProvince

Sources: DwC:stateProvince

acceptedStateProvince

Sources: DwC:stateProvince, DwC:acceptedNameUsage

county

Sources: DwC:county

acceptedCounty

Sources: DwC:county, DwC:acceptedNameUsage

municipality

Sources: DwC:municipality

locality

Sources: DwC:locality

verbatimLocality

Sources: DwC:verbatimLocality

verbatimElevation

Sources: DwC:verbatimElevation
Comments: Must include units

verbatimElevation_m

Sources: DwC:verbatimElevation
Comments: Added units

elevationInMeters

Sources: DwC:minimumElevationInMeters
Comments: Prefix removed to use for non-ranges

minimumElevationInMeters

Sources: DwC:minimumElevationInMeters

maximumElevationInMeters

Sources: DwC:maximumElevationInMeters

verbatimDepth

Sources: DwC:verbatimDepth

minimumDepthInMeters

Sources: DwC:minimumDepthInMeters

maximumDepthInMeters

Sources: DwC:maximumDepthInMeters

minimumDistanceAboveSurfaceInMeters

Sources: DwC:minimumDistanceAboveSurfaceInMeters

maximumDistanceAboveSurfaceInMeters

Sources: DwC:maximumDistanceAboveSurfaceInMeters

locationAccordingTo

Sources: DwC:locationAccordingTo

locationRemarks

Sources: DwC:locationRemarks

verbatimCoordinates

Sources: DwC:verbatimCoordinates

verbatimLatitude

Sources: DwC:verbatimLatitude

verbatimLongitude

Sources: DwC:verbatimLongitude

verbatimCoordinateSystem

Sources: DwC:verbatimCoordinateSystem

verbatimSRS

Sources: DwC:verbatimSRS

decimalLatitude

Sources: DwC:decimalLatitude

acceptedDecimalLatitude

Sources: DwC:decimalLatitude, DwC:acceptedNameUsage

decimalLongitude

Sources: DwC:decimalLongitude

acceptedDecimalLongitude

Sources: DwC:decimalLongitude, DwC:acceptedNameUsage

geodeticDatum

Sources: DwC:geodeticDatum

coordinateUncertaintyInMeters

Sources: DwC:coordinateUncertaintyInMeters

coordinatePrecision_deg

Sources: DwC:coordinatePrecision
Comments: Added units

pointRadiusSpatialFit

Sources: DwC:pointRadiusSpatialFit

footprintWKT

Sources: DwC:footprintWKT

footprintSRS

Sources: DwC:footprintSRS

footprintSpatialFit

Sources: DwC:footprintSpatialFit

georeferencedBy

Sources: DwC:georeferencedBy

georeferencedDate

Sources: DwC:georeferencedDate

georeferenceProtocol

Sources: DwC:georeferenceProtocol

georeferenceSources

Sources: DwC:georeferenceSources

georeferenceVerificationStatus

Sources: DwC:georeferenceVerificationStatus

georeferenceRemarks

Sources: DwC:georeferenceRemarks

GeologicalContext

Sources: DwC:GeologicalContext (components)

geologicalContextID

Sources: DwC:geologicalContextID

earliestEonOrLowestEonothem

Sources: DwC:earliestEonOrLowestEonothem

latestEonOrHighestEonothem

Sources: DwC:latestEonOrHighestEonothem

earliestEraOrLowestErathem

Sources: DwC:earliestEraOrLowestErathem

latestEraOrHighestErathem

Sources: DwC:latestEraOrHighestErathem

earliestPeriodOrLowestSystem

Sources: DwC:earliestPeriodOrLowestSystem

latestPeriodOrHighestSystem

Sources: DwC:latestPeriodOrHighestSystem

earliestEpochOrLowestSeries

Sources: DwC:earliestEpochOrLowestSeries

latestEpochOrHighestSeries

Sources: DwC:latestEpochOrHighestSeries

earliestAgeOrLowestStage

Sources: DwC:earliestAgeOrLowestStage

latestAgeOrHighestStage

Sources: DwC:latestAgeOrHighestStage

lowestBiostratigraphicZone

Sources: DwC:lowestBiostratigraphicZone

highestBiostratigraphicZone

Sources: DwC:highestBiostratigraphicZone

lithostratigraphicTerms

Sources: DwC:lithostratigraphicTerms

group

Sources: DwC:group

formation

Sources: DwC:formation

member

Sources: DwC:member

bed

Sources: DwC:bed

Identification

Sources: DwC:Identification (components)

identificationID

Sources: DwC:identificationID

identifiedBy

Sources: DwC:identifiedBy

dateIdentified

Sources: DwC:dateIdentified

identificationReferences

Sources: DwC:identificationReferences

identificationVerificationStatus

Sources: DwC:identificationVerificationStatus

identificationRemarks

Sources: DwC:identificationRemarks

identificationQualifier

Sources: DwC:identificationQualifier

acceptedIdentificationQualifier

Sources: DwC:identificationQualifier, DwC:acceptedNameUsage

originalIdentificationQualifier

Sources: DwC:identificationQualifier, DwC:originalNameUsage

verbatimIdentificationQualifier

Sources: DwC:identificationQualifier, DwC:verbatimTaxonRank

typeStatus

"Indicates whether this specimen served as type for taxon name" (Brad Boyle)

Sources: DwC:typeStatus

Taxon

Sources: DwC:Taxon (components)

taxonID

Sources: DwC:taxonID

parentTaxonID

Sources: DwC:taxonID, VegBank:plantParent_ID

scientificNameID

Sources: DwC:scientificNameID

parentScientificNameID

Sources: DwC:scientificNameID, VegBank:plantParent_ID

acceptedNameUsageID

Sources: DwC:acceptedNameUsageID

parentNameUsageID

Sources: DwC:parentNameUsageID

originalNameUsageID

Sources: DwC:originalNameUsageID

nameAccordingToID

Sources: DwC:nameAccordingToID

namePublishedInID

Sources: DwC:namePublishedInID

taxonConceptID

Sources: DwC:taxonConceptID

parentTaxonConceptID

Sources: DwC:taxonConceptID, VegBank:plantParent_ID

scientificName

Sources: DwC:scientificName

taxonName

Taxonomic name without author

Sources: DwC:scientificName, DwC:Taxon

acceptedTaxonName

Taxonomic name without author

Sources: DwC:scientificName, DwC:Taxon, DwC:acceptedNameUsage

originalTaxonName

Taxonomic name without author

Sources: DwC:scientificName, DwC:Taxon, DwC:originalNameUsage

taxonNameOrEpithet

Sources: DwC:scientificName, DwC:Taxon, DwC:specificEpithet, DwC:higherClassification

verbatimTaxonName

Taxonomic name without author

Sources: DwC:scientificName, DwC:Taxon, DwC:verbatimTaxonRank

acceptedScientificName

Sources: DwC:scientificName, DwC:acceptedNameUsage

originalScientificName

Sources: DwC:scientificName, DwC:originalNameUsage

verbatimScientificName

Sources: DwC:scientificName, DwC:verbatimTaxonRank

scientificNameWithMorphospecies

Sources: DwC:scientificName, SALVIAS:morphospecies

acceptedNameUsage

Sources: DwC:acceptedNameUsage

parentNameUsage

Sources: DwC:parentNameUsage

originalNameUsage

Sources: DwC:originalNameUsage

nameAccordingTo

Sources: DwC:nameAccordingTo

namePublishedIn

Sources: DwC:namePublishedIn

namePublishedInYear

Sources: DwC:namePublishedInYear

higherClassification

Sources: DwC:higherClassification

kingdom

Sources: DwC:kingdom

acceptedKingdom

Sources: DwC:kingdom, DwC:acceptedNameUsage

originalKingdom

Sources: DwC:kingdom, DwC:originalNameUsage

verbatimKingdom

Sources: DwC:kingdom, DwC:verbatimTaxonRank

phylum

Sources: DwC:phylum

acceptedPhylum

Sources: DwC:phylum, DwC:acceptedNameUsage

originalPhylum

Sources: DwC:phylum, DwC:originalNameUsage

verbatimPhylum

Sources: DwC:phylum, DwC:verbatimTaxonRank

class

Sources: DwC:class

acceptedClass

Sources: DwC:class, DwC:acceptedNameUsage

originalClass

Sources: DwC:class, DwC:originalNameUsage

verbatimClass

Sources: DwC:class, DwC:verbatimTaxonRank

order

Sources: DwC:order

acceptedOrder

Sources: DwC:order, DwC:acceptedNameUsage

originalOrder

Sources: DwC:order, DwC:originalNameUsage

verbatimOrder

Sources: DwC:order, DwC:verbatimTaxonRank

family

Sources: DwC:family

acceptedFamily

Sources: DwC:family, DwC:acceptedNameUsage

originalFamily

Sources: DwC:family, DwC:originalNameUsage

verbatimFamily

Sources: DwC:family, DwC:verbatimTaxonRank

genus

Sources: DwC:genus

acceptedGenus

Sources: DwC:genus, DwC:acceptedNameUsage

originalGenus

Sources: DwC:genus, DwC:originalNameUsage

verbatimGenus

Sources: DwC:genus, DwC:verbatimTaxonRank

subgenus

Sources: DwC:subgenus

verbatimSubgenus

Sources: DwC:subgenus, DwC:verbatimTaxonRank

specificEpithet

Sources: DwC:specificEpithet

acceptedSpecificEpithet

Sources: DwC:specificEpithet, DwC:acceptedNameUsage

originalSpecificEpithet

Sources: DwC:specificEpithet, DwC:originalNameUsage

verbatimSpecificEpithet

Sources: DwC:specificEpithet, DwC:verbatimTaxonRank

infraspecificEpithet

Sources: DwC:infraspecificEpithet

acceptedInfraspecificEpithet

Sources: DwC:infraspecificEpithet, DwC:acceptedNameUsage

originalInfraspecificEpithet

Sources: DwC:infraspecificEpithet, DwC:originalNameUsage

verbatimInfraspecificEpithet

Sources: DwC:infraspecificEpithet, DwC:verbatimTaxonRank

taxonRank

Sources: DwC:taxonRank

acceptedTaxonRank

Sources: DwC:taxonRank, DwC:acceptedNameUsage

originalTaxonRank

Sources: DwC:taxonRank, DwC:originalNameUsage

verbatimTaxonRank

Sources: DwC:verbatimTaxonRank

scientificNameAuthorship

Sources: DwC:scientificNameAuthorship

acceptedScientificNameAuthorship

Sources: DwC:scientificNameAuthorship, DwC:acceptedNameUsage

originalScientificNameAuthorship

Sources: DwC:scientificNameAuthorship, DwC:originalNameUsage

verbatimScientificNameAuthorship

Sources: DwC:scientificNameAuthorship, DwC:verbatimTaxonRank

vernacularName

Sources: DwC:vernacularName

nomenclaturalCode

Sources: DwC:nomenclaturalCode

taxonomicStatus

Sources: DwC:taxonomicStatus

taxonIsCanonical

Sources: DwC:accepted

nomenclaturalStatus

Sources: DwC:nomenclaturalStatus

taxonRemarks

Sources: DwC:taxonRemarks

ResourceRelationship

Sources: DwC:ResourceRelationship (components)

resourceRelationshipID

Sources: DwC:resourceRelationshipID

resourceID

Sources: DwC:resourceID

relatedResourceID

Sources: DwC:relatedResourceID

relationshipOfResource

Sources: DwC:relationshipOfResource

relationshipAccordingTo

Sources: DwC:relationshipAccordingTo

relationshipEstablishedDate

Sources: DwC:relationshipEstablishedDate

relationshipRemarks

Sources: DwC:relationshipRemarks

MeasurementOrFact

Sources: DwC:MeasurementOrFact (components)

measurementID

Sources: DwC:measurementID

measurementType

Sources: DwC:measurementType

measurementValue

Sources: DwC:measurementValue

measurementAccuracy

Sources: DwC:measurementAccuracy

measurementUnit

Sources: DwC:measurementUnit

measurementDeterminedDate

Sources: DwC:measurementDeterminedDate

measurementDeterminedBy

Sources: DwC:measurementDeterminedBy

measurementMethod

Sources: DwC:measurementMethod

measurementRemarks

Sources: DwC:measurementRemarks

Uncategorized

yearCollected

Sources: DwC:MaNIS:YearCollected

monthCollected

Sources: DwC:MaNIS:MonthCollected

dayCollected

Sources: DwC:MaNIS:DayCollected

yearIdentified

Sources: DwC:MaNIS:YearIdentified

monthIdentified

Sources: DwC:MaNIS:MonthIdentified

dayIdentified

Sources: DwC:MaNIS:DayIdentified

longitude_DMS

Sources: DwC:Classic:Longitude
Comments: Added units

latitude_DMS

Sources: DwC:Classic:Latitude
Comments: Added units

dateCollected

Sources: DwC:history:EarliestDateCollected-2007-04-17
Comments: Prefix removed to use for non-ranges

accordingTo

"Information about the authorship of this concept which uses the Name in their sense (i.e. secundum, sensu)" (TCS)

Sources: TCS:AccordingTo

forma

Sources: TCS:fm, Wikipedia:Ranks_in_botany
Comments: "Form, race, variety are not subject to regulation in zoology; see ICZN Article 1.3.4" (TCS)

acceptedForma

Sources: TCS:fm, Wikipedia:Ranks_in_botany, DwC:acceptedNameUsage
Comments: "Form, race, variety are not subject to regulation in zoology; see ICZN Article 1.3.4" (TCS)

originalForma

Sources: TCS:fm, Wikipedia:Ranks_in_botany, DwC:originalNameUsage
Comments: "Form, race, variety are not subject to regulation in zoology; see ICZN Article 1.3.4" (TCS)

verbatimForma

Sources: TCS:fm, Wikipedia:Ranks_in_botany, DwC:verbatimTaxonRank
Comments: "Form, race, variety are not subject to regulation in zoology; see ICZN Article 1.3.4" (TCS)

variety

Sources: TCS:var, Wikipedia:Ranks_in_botany
Comments: "Form, race, variety are not subject to regulation in zoology; see ICZN Article 1.3.4" (TCS)

acceptedVariety

Sources: TCS:var, Wikipedia:Ranks_in_botany, DwC:acceptedNameUsage
Comments: "Form, race, variety are not subject to regulation in zoology; see ICZN Article 1.3.4" (TCS)

originalVariety

Sources: TCS:var, Wikipedia:Ranks_in_botany, DwC:originalNameUsage
Comments: "Form, race, variety are not subject to regulation in zoology; see ICZN Article 1.3.4" (TCS)

verbatimVariety

Sources: TCS:var, Wikipedia:Ranks_in_botany, DwC:verbatimTaxonRank
Comments: "Form, race, variety are not subject to regulation in zoology; see ICZN Article 1.3.4" (TCS)

cultivar

Sources: TCS:cv
Comments: "The epithet is usually output in single quotes and may contain multiple words, see ICBN §28" (TCS)

acceptedCultivar

Sources: TCS:cv, DwC:acceptedNameUsage
Comments: "The epithet is usually output in single quotes and may contain multiple words, see ICBN §28" (TCS)

originalCultivar

Sources: TCS:cv, DwC:originalNameUsage
Comments: "The epithet is usually output in single quotes and may contain multiple words, see ICBN §28" (TCS)

verbatimCultivar

Sources: TCS:cv, DwC:verbatimTaxonRank
Comments: "The epithet is usually output in single quotes and may contain multiple words, see ICBN §28" (TCS)

subspecies

Sources: TCS:ssp, Wikipedia:Ranks_in_botany

acceptedSubspecies

Sources: TCS:ssp, Wikipedia:Ranks_in_botany, DwC:acceptedNameUsage

originalSubspecies

Sources: TCS:ssp, Wikipedia:Ranks_in_botany, DwC:originalNameUsage

verbatimSubspecies

Sources: TCS:ssp, Wikipedia:Ranks_in_botany, DwC:verbatimTaxonRank

projectName

"Title of the project" (VegX)

Sources: VegX:title, VegX:plotName

locationName

"Name or label for a plot" (VegX)

Sources: VegX:plotName, DwC:locationID

parentPlotName

"Name or label" (VegX) for "the parent plot when plot is nested within another plot" (VegBank)

Sources: VegX:plotName, VegBank:PARENT_ID

plotNotes

"The text of notes taken in the field" (DwC) about the plot

Sources: VegX:note, DwC:fieldNotes
Comments: Table added for uniqueness

plotArea_m2

"Total area of the plot. Usually recorded in square meters." (VegX)

Sources: VegX:area
Comments: Table added for clarity. Added units.

slopeAspect

"Representative azimuth of slope gradient (0-360 degrees) or as a cardinal direction (e.g. N, S, NE)" (VegX)

Sources: VegX:slopeAspect

slopeGradient

"Representative inclination of slope in degrees" (VegX)

Sources: VegX:slopeGradient

landform

"A recognizable physical feature on the surface of the earth, often including consideration of the natural cause of its formation" (VegX)

Sources: VegX:landform

subplotX

"The X-coordinate of the related items position in meters. The user will enter the relative position of related item with respect to the plot origin (in meters) with the x-axis defined by the plot azimuth." (VegX)

Sources: VegX:relativeX, SALVIAS:subplot

subplotY

"The Y-coordinate of the related items position in metres. The user will enter the relative position of related item with respect to the plot origin (in meters) with the y-axis defined by the plot azimuth." (VegX)

Sources: VegX:relativeY, SALVIAS:subplot

projectID

"A reference to a specific 'project'" (VegX)

Sources: VegX:projectID

temperature

"Temperature during observation" (VegX)

Sources: VegX:temperature

communityID

"A community type is an abstract grouping of organisms that tend to co-occur on the landscape due to shared ecological requirements or preferences. May be designated by syntaxon or physiognomic types." (VegX)

Sources: VegX:communityConcept, DwC:occurrenceID
Comments: Table shortened for standardization

communityName

"A textual label for a community type" (VegX)

Sources: VegX:name
Comments: Table shortened for standardization

aggregateOccurrenceID

The ID for the aggregateOccurrence

Sources: VegX:aggregateOrganismObservation, DwC:occurrenceID

height_ft

"The measured height of the stem" (VegBank) in feet

Sources: VegX:height, VegBank:stemHeight
Comments: Added units

height_m

"The measured height of the stem in meters" (VegBank)

Sources: VegX:height, VegBank:stemHeight
Comments: Added units

organismX_m

"The X-coordinate of the related item position in m. The user will enter the relative position of related item with respect to the plot origin (in meters) with the x-axis defined by the plot azimuth." (VegX)

Sources: VegX:relativeX
Comments: Table added for clarity. Added units.

organismY_m

"The Y-coordinate of the relatedSpatialItem position in m. The user will enter the relative position of relatedSpatialItems with respect to the plot origin (in meters) with the y-axis defined by the plot azimuth." (VegX)

Sources: VegX:relativeY
Comments: Table added for clarity. Added units.

phosphorus_fraction

"Phosphorus of soil" (VegX)

Sources: VegX:phosphorus
Comments: Added units

phosphorus_percent

"Phosphorus of soil" (VegX)

Sources: VegX:phosphorus
Comments: Added units

potassium_fraction

"Pottasium of soil" (VegX)

Sources: VegX:pottasium
Comments: Spelling corrected. Added units.

potassium_percent

"Pottasium of soil" (VegX)

Sources: VegX:pottasium
Comments: Spelling corrected. Added units.

magnesium_fraction

"Magnesium of soil" (VegX)

Sources: VegX:magnesium
Comments: Added units

magnesium_percent

"Magnesium of soil" (VegX)

Sources: VegX:magnesium
Comments: Added units

nitrogen_fraction

"Nitrogen of soil" (VegX)

Sources: VegX:nitrogen
Comments: Added units

nitrogen_percent

"Nitrogen of soil" (VegX)

Sources: VegX:nitrogen
Comments: Added units

ph

"The pH of the soil" (VegX)

Sources: VegX:ph

coverPercent

"Average cover of the index in percent" (VegX)

Sources: VegX:coverPercent

growthForm

Sources: VegBank:growthform1Type, habitClassIncluded

authorStemCode

Sources: VegBank:authorPlotCode, VegBank:stemCode

minSlopeAspect

Sources: VegBank:minSlopeAspect

maxSlopeAspect

Sources: VegBank:maxSlopeAspect

minSlopeGradient

Sources: VegBank:minSlopeGradient

maxSlopeGradient

Sources: VegBank:maxSlopeGradient

projectStartDate

"Project start date" (VegBank)

Sources: VegBank:startDate, VegX:obsStartDate

projectEndDate

"Project stop date" (VegBank)

Sources: VegBank:stopDate, VegX:obsEndDate

referenceType

Values: herbarium, primary database, aggregator, …
Sources: VegBank:referenceType, BIEN2:bien_web:aggregatorOrPrimary, BIEN2:bien_web:isHerbarium

organic_fraction

Sources: VegBank:soilOrganic
Comments: Added units

organic_percent

Sources: VegBank:soilOrganic
Comments: Added units

texture

Sources: VegBank:soilTexture

sand_fraction

Sources: VegBank:soilSand
Comments: Added units

sand_percent

Sources: VegBank:soilSand
Comments: Added units

silt_fraction

Sources: VegBank:soilSilt
Comments: Added units

silt_percent

Sources: VegBank:soilSilt
Comments: Added units

clay_fraction

Sources: VegBank:soilClay
Comments: Added units

clay_percent

Sources: VegBank:soilClay
Comments: Added units

cationExchangeCapacity_cmol_kg

Sources: VegBank:exchangeCapacity, SALVIAS:DB:soil_cation_cap
Comments: Expanded for clarity

baseSaturation_fraction

Sources: VegBank:baseSaturation
Comments: Added units

baseSaturation_percent

Sources: VegBank:baseSaturation
Comments: Added units

stemCount

Sources: VegBank:stemCount

matchedTaxonFit_fraction

Sources: VegBank:taxonFit, TNRS:Overall_score, TNRS:Name_matched
Comments: Added units

matchedFamilyFit_fraction

Sources: VegBank:taxonFit, TNRS:Family_score, TNRS:Family_matched
Comments: Added units

matchedGenusFit_fraction

Sources: VegBank:taxonFit, TNRS:Genus_score, TNRS:Genus_matched
Comments: Added units

matchedSpeciesFit_fraction

Sources: VegBank:taxonFit, TNRS:Specific_epithet_score, TNRS:Specific_epithet_matched, DwC:Classic:Species
Comments: Added units

taxonOccurrenceID

Sources: VegBank:where_tablename, DwC:occurrenceID

precipitation

Sources: SALVIAS:precip_mm
Comments: Expanded for clarity

observationMeasure

Sources: SALVIAS:observation_type, VegBIEN:observationmeasure, DwC:samplingProtocol

plotArea_ha

Sources: SALVIAS:plot_area_ha

censusNumber

Sources: SALVIAS:census_no
Comments: Expanded for clarity

subplot

Sources: SALVIAS:subplot

tag

Sources: SALVIAS:tag2
Comments: Number removed for clarity

voucherType

Values: direct, indirect
Sources: SALVIAS:det_type

morphospecies

Sources: SALVIAS:morphospecies

intercept_cm

Sources: SALVIAS:intercept_cm

intercept_m

Sources: SALVIAS:intercept_cm
Comments: Changed to SI base units

heightFirstBranch

Sources: SALVIAS:ht_first_branch_m

diameterBreastHeight_cm

Sources: SALVIAS:stem_dbh
Comments: Expanded for clarity. Added units.

diameterBreastHeight_in

Sources: SALVIAS:stem_dbh
Comments: Expanded for clarity. Added units.

diameterBreastHeight_m

Sources: SALVIAS:stem_dbh
Comments: Expanded for clarity. Added units.

basalDiameter

Sources: SALVIAS:basal_diam
Comments: Expanded for clarity

canopyForm

Sources: SALVIAS:stem_canopy_form

canopyPosition

Sources: SALVIAS:stem_canopy_position

lianaInfestation

Sources: SALVIAS:stem_liana_infestation

carbon_fraction

Sources: SALVIAS:DB:soil_C
Comments: Expanded for clarity. Added units.

carbon_percent

Sources: SALVIAS:DB:soil_C
Comments: Expanded for clarity. Added units.

calcium_fraction

Sources: SALVIAS:DB:soil_Ca
Comments: Expanded for clarity. Added units.

calcium_percent

Sources: SALVIAS:DB:soil_Ca
Comments: Expanded for clarity. Added units.

sodium_fraction

Sources: SALVIAS:DB:soil_Na
Comments: Expanded for clarity. Added units.

sodium_percent

Sources: SALVIAS:DB:soil_Na
Comments: Expanded for clarity. Added units.

acidity_fraction

Sources: SALVIAS:DB:soil_acidity
Comments: Added units

acidity_percent

Sources: SALVIAS:DB:soil_acidity
Comments: Added units

conductivity

Sources: SALVIAS:DB:soil_conductivity

stemID

Sources: SALVIAS:DB:stem_id

diameterBreastHeightGentry

Sources: SALVIAS:DB:gentry_dbh
Comments: Expanded for clarity

stemNotes

Sources: SALVIAS:DB:stem_notes

datasource

Sources: BIEN2:bien_web:dataSourceName, DwC:institutionCode

observationType

Values: plot, specimen
Sources: BIEN2:bien_web:observationType

higherPlantGroup

Sources: BIEN2:bien_web:higherPlantGroup, DwC:higherClassification

latLongDomainValid

Whether the coordinates are in the range of valid decimal values

Sources: BIEN2:bien_web:isValidLatLong

latLongDomainInvalid

Whether the coordinates are not in the range of valid decimal values

Sources: BIEN2:bien_web:isValidLatLong, BIEN2:geoscrub:isBadLatLong

geovalid

Sources: BIEN2:bien_web:isGeovalid

individualCount_1cm_or_more

Sources: BIEN2:bien_web:abund1, DwC:individualCount

individualCount_2_5cm_or_more

Sources: BIEN2:bien_web:5, DwC:individualCount

individualCount_10cm_or_more

Sources: BIEN2:bien_web:abund10, DwC:individualCount

oldGrowth

Sources: BIEN2:geoscrub:oldgrowth

latLongInCountry

Sources: BIEN2:geoscrub:isInCountry, BIEN2:geoscrub:isBadLatLong, DwC:country

distanceToCountry_km

Sources: BIEN2:geoscrub:distErrCountry, DwC:country
Comments: Added units

distanceToCountry_m

Sources: BIEN2:geoscrub:distErrCountry, DwC:country
Comments: Added units

latLongInStateProvince

Sources: BIEN2:geoscrub:isInStateProvince, BIEN2:geoscrub:isBadLatLong, DwC:stateProvince

distanceToStateProvince_km

Sources: BIEN2:geoscrub:distErrStateProvince, DwC:stateProvince
Comments: Added units

distanceToStateProvince_m

Sources: BIEN2:geoscrub:distErrStateProvince, DwC:stateProvince
Comments: Added units

latLongInCounty

Sources: BIEN2:geoscrub:isInCountyParish, BIEN2:geoscrub:isBadLatLong, DwC:county

isNewWorld

Sources: BIEN2:geoscrub:isNewWorld

threatened

Sources: IUCN:The_IUCN_Red_List_of_Threatened_Species

speciesBinomial

genus+specificEpithet

Sources: Wikipedia:Binomial_nomenclature, DwC:Classic:Species

OMIT

The field contains data but should be omitted

Comments: The reason for omission should be described in the mapping's comments

PRIVATE

The field contains private data which should be omitted from a public database

UNUSED

The field does not contain any data

Comments: The following query should return no rows: SELECT * FROM table WHERE field IS NOT NULL

See also

ACAD.Specimen.csv Magnifier (12 KB) Aaron Marcuse-Kubitza, 12/05/2012 09:21 am