Field name

Type

Description

ID

int(11)

Unique REBIOMA database id

Owner

int(11)

Data owner id (assigned on upload)

Public

tinyint(1)

Boolean public or private

Vettable

tinyint(1)

Validated

tinyint(1)

Vetted

tinyint(1)

TapirAccessible

tinyint(1)

email

varchar(128)

Data owner email address (assigned on upload)

VettingError

text

ValidationError

text

Validation error name

BasisOfRecord

text

Basis of record name

YearCollected

int(11)

Year collected

Genus

text

Genus name provided at upload

SpecificEpithet

text

Species name provided at upload

DecimalLatitude

double(10,7)

Latitude in decimal degrees

DecimalLongitude

double(10,7)

Longitude in decimal degrees

GeodeticDatum

text

Geodetic Datum

CoordinateUncertaintyInMeters

double

Coordinate uncertainty in meters

DateLastModified

text

Date last modified

InstitutionCode

text

Institution code

CollectionCode

text

Collection code

CatalogNumber

text

Catalog number

ScientificName

text

Scientific name provided at upload

GlobalUniqueIdentifier

text

Global unique identifier

InformationWithheld

text

Remarks

text

Remarks

HigherTaxon

text

Kingdom

text

Kingdom provided at upload

Phylum

text

Phylum provided at upload

Class

text

Class provided at upload

Order

text

Order provided at upload

Family

text

Family provided at upload

InfraspecificRank

text

InfraspecificRank provided at upload

InfraspecificEpithet

text

InfraspecificEpithet provided at upload

AuthorYearOfScientificName

text

Author year of scientific name

NomenclaturalCode

text

Nomenclatural code

IdentificationQualifer

text

HigherGeography

text

Continent

text

WaterBody

text

IslandGroup

text

Island

text

Country

text

Country

StateProvince

text

State or province

County

text

County

Locality

text

Locality

MinimumElevationInMeters

double

MaximumElevationInMeters

double

MinimumDepthInMeters

double

MaximumDepthInMeters

double

CollectingMethod

text

ValidDistributionFlag

tinyint(1)

EarliestDateCollected

text

LatestDateCollected

text

DayOfYear

int(11)

MonthCollected

int(11)

DayCollected

int(11)

Collector

text

Sex

text

LifeStage

text

Attributes

text

ImageURL

text

RelatedInformation

text

CatalogNumberNumeric

double

IdentifiedBy

text

DateIdentified

text

CollectorNumber

text

FieldNumber

text

FieldNotes

text

VerbatimCollectingDate

text

VerbatimElevation

text

VerbatimDepth

text

Preparations

text

TypeStatus

text

GenBankNumber

text

OtherCatalogNumbers

text

RelatedCatalogedItems

text

Disposition

text

IndividualCount

int(11)

PointRadiusSpatialFit

double

VerbatimCoordinates

text

VerbatimLatitude

text

VerbatimLongitude

text

VerbatimCoordinateSystem

text

GeoreferenceProtocol

text

GeoreferenceSources

text

GeoreferenceVerificationStatus

text

GeoreferenceRemarks

text

FootprintWKT

text

FootprintSpatialFit

double

VerbatimSpecies

text

Verbatim species

AcceptedSpecies

text

Accepted species (genus + species)

AcceptedNomenclaturalCode

text

Accepted nomenclatural code

AcceptedKingdom

text

Accepted kingdom

AcceptedPhylum

text

Accepted phylum

AcceptedClass

text

Accepted class

AcceptedOrder

text

Accepted order

AcceptedSuborder

text

Accepted suborder

AcceptedFamily

text

Accepted family

AcceptedSubfamily

text

Accepted subfamily

AcceptedGenus

text

Accepted genus

AcceptedSubgenus

text

Accepted subgenus

AcceptedSpecificEpithet

text

Accepted species

DecLatInWGS84

double(10,7)

DecLongInWGS84

double(10,7)

LastUpdated

timestamp

Last updated time

TimeCreated

timestamp

Time created

Obfuscated

tinyint(1)

SharedUsers

text

EmailVisible

tinyint(1)

Visibility of email

reviewed

tinyint(1)

Review status