VegCore

Combines 371 terms from existing vegetation data formats

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.
.

Data dictionary

Note: Some links point to a field within a document which isn't directly hyperlinked. For these links, mouse over the link to see the name or path of the field.

The list is autogenerated from the VegCore terms spreadsheet: On vegbiendev, run make --dir=/home/bien/svn mappings/VegCore.redmine-remake

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

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

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

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

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

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

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

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

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

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

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