CORVEG-QBEIS Tables Overview

CORVEG-QBEIS consists of 121 tables including look up tables. Currently TERN has access to all tables. The collection contains only human observations. All tables are provided as an H2 database. The source of truth is in TERN’s S3 Bucket. The publishing platform for all these tables is Ecoplots.

Below is an overview of tables included in this database.

 

table name

content

Number of records

tables to join

dictionaries/lookuptables

columns excluded that need checking

table name

content

Number of records

tables to join

dictionaries/lookuptables

columns excluded that need checking

altitudederivation

Dictionary for altitude derivation method

21

 

 

 

australianbioregion

Dictionary of Australian bioregions sensu X

267

 

 

 

bioconditiontreediameter

Data on diameter at breast height for individual trees

189

surveyparameterstreediameter

taxon,surveyparametertable

 

bioconditionwoodydebris

Data for woody debris length

68

surveyparameterswoodydebris

standardsurveyparametertable

 

bioregion

Dictionary of Australian bioregions sensu Y

26

 

 

 

broadhabitat

Dictionary of vegetation habitat types sensu X

306

 

 

 

communityarea

Dictionary for community extent (area)

12

 

 

 

communitywidth

Dictionary for community width

12

 

 

 

contact

Dictionary for people contacts

878

 

 

 

contacttype

Dictionary for contact types (i.e. roles such as Custodian, User, Recorder)

10

 

 

 

coordinatederivation

Dictionary for geographical coordinates derivation methods (e.g, gps, map, gis)

10

 

 

 

country

Dictionary of Countries

22

 

 

 

countrystate

Dictionary of States (currently only for Australia)

24

 

 

 

coverassessmentmeasure

Dictionary for plant cover measure type (e.g. projective foliar, crown cover, unrecorded)

9

 

 

 

coverassessmentmethod

Dictionary for plant cover method type (e.g. intercept, visual estimate)

8

 

 

 

coverquadrat

CHECK Currently we think this is raw data for ground cover data, it is assumed that 5 quadrats are always sample. Groundcover tables take average of that

188

 

 

all columns are excluded as table seems to be incomplete (i.e. it is missing 90% or more of rows)

custodian

Dictionary for data custodians

2

 

 

 

custodianproject

Original Projects that carry out the surveys

240

 

 

 

custodiansource

Dictionary with custodian metadata.

2

 

 

 

custodiantype

Dictionary for types of data custodians (e.g. Government, Interional agency, Private)

20

 

 

 

datum

Dictionary for geodetic datum used

4

 

 

 

disturbance

Data on unique disturbance- sitevisitid and whether or not disturbance was assesed or not

15786

 

 

 

disturbanceassessment

Dictionary for whether a disturbance has been assessed or not

6

disturbance

 

 

disturbanceobservation

Data on fire, gully cover, height, severity, and count

28732

 

disturbancetype, observationtype, firetypecode,proportion, severity,meanfireheight, timesinceevent, erosiontype, gullydepth,

time since salinity, ringbarked stem count, GULLYDEPTHCODE, observatiotype, firetype (mostly empty and only one type of data),

disturbancetype

Dictionary for types of disturbance

26

 

 

 

disturbancetypeassessment

Data on whether a disturbance is present or not

189450

 

disturbance

 

enduser

Data on end user ID

472

 

 

 

erosionallandformpattern

Dictionary on types of erosional land form patterns (e.g. Rolling mountains, Badlands,Undulating plain )

44

 

 

 

erosiontype

Dictionary for erosion type

20

 

 

 

firetype

Dictionary for types of fire

6

 

 

 

geology

Data on geology for a site

27754

 

 

 

geologyreliability

Dictionary for reliability of geological observations

8

 

 

 

geologysource

Dictionary for the source of geology data

12

 

 

 

groundlayer

Data on vegetative cover and total ground cover

28568

 

 

 

groundlayercharacteristic

Data on average ground cover for all ground cover except vegetation

48190

 

 

 

groundlayercharacteristic_ref

Dictionary for types of ground cover

12

 

 

 

groundlayerobservation

Data on plant species cover percentage CHECK unsure if this is for all plants or only herbs/shrubs

499084

 

taxon, observationtype, survey,sitevisit,speciesidentificationcode

 

growthform

Dictionary for plants growth form

69

 

 

 

gullydepth

Dictionary for gully depth

8

 

 

 

health

Dictionary for vegetation health

10

 

 

 

jurisdiction

Dictionary for Australian jurisdictions (e.g. NSW, QLD)

20

 

 

 

landform

Data on landform features

26374

 

 

relief_class (no data)

landformelement

Dictionary for landform elements

160

 

 

 

landformelementcombinations

CHECK (unsure if this for permissble landform-slope combinations) Dictionary for land form-slope combinations

224

 

 

 

landformpattern

Dictionary of land form pattern

80

 

 

 

landformpatterncombinations

Dictionary of land form - relief combinations

100

 

 

 

landformsituation

Dictionary for land form situation

40

 

 

 

leafsizecanopytree

Dictionary for leaf size

18

 

 

 

lineinterceptcrowncoverperspeciesperstrata

Data on crown cover per species and stratum using line intercept method

82

 

 

 

lineinterceptcrowncoverperstrata

Data on crown cover per species and stratum using line intercept method

72

 

 

 

lineinterceptform

Data on species presence/abundance using line intercept method

222

 

 

 

lineintercepttotalshrubcrowncover

Data on shrub cover derived from line intercept

24

 

 

 

lineintercepttotaltreecrowncover

Data on tree cover derived from lineintercept

16

 

 

 

location

Data on location (description, latitude, longitude)

29126

 

 

 

lookupretobvg1m

CHECK Dictionary for transforming a CV to other type of CV

2370

 

 

 

meanfirescarheight

Dictionary for fire scar heigth

18

 

 

 

methodverificationstatus

Data on data verification at the site visit level CHECK

239068

 

 

 

modalslopeclass

Dictionary for slope classes

16

 

 

 

observationtype

Dictionary on type of observation

8

 

 

 

plotorientation

Dictionary on plot orientation

10

 

 

 

plotsizesampletype

Dictionary on tyep of sampling method or plot shape used

14

 

 

 

project

Data on original project name

240

 

 

 

projectsite

Data on project-site relationship

29398

 

 

 

proportion

Dictionary for proportions

8

 

 

 

relativeabundance

Dictionary on species relative abundance

6

 

 

 

reliefclass

Dictionary on relief class

10

 

 

 

representativesite

Dictionary on landform type of relief

6

 

 

 

samplefloristic

Dictionary on plant species sample (e.g. all plant community, only woody, only herbaceous)

12

 

 

 

samplelevel

Dictionary on type of sample carrying according to Methods for CORVEG

8

 

 

 

securitylevel

Dictionary for security level of data (e.g. public, restricted)

8

 

 

 

severity

Dictionary on disturbance severity CHECK

12

 

 

 

sfclassification

Dictionary on vegetation structure classification method used

6

 

 

 

site

Data on site attributes

29126

 

 

 

sitevisit

Data on site visit attributes

29622

 

 

sitevistimethod

sitevisitrecorder

Data on person in charge of site visit

56300

 

 

 

slopetype

Dictionary for slope sites

33

 

 

 

soil

Data on soil surveys

26080

 

 

SOILISBELLCODE,SOILMUNSELLCODE, SOILDEPTH

soilcolour

Dictionary for soil colour

36

 

 

 

soildepth

Dictionary for soil depth (currently not in use)

9

 

 

 

soilreliability

Dictionary for soil data reliability

12

 

 

 

soilsource

Dictionary for soil data source

24

 

 

 

soiltexture

Dictionary for soil texture types

129

 

 

 

soiltype

Dictionary for soil type

72

 

 

 

sourcetype

Check

51

 

 

 

speciesidentification

Dictionary on type of species identification done

12

 

 

 

standardsurveyparameters

Data on vegetation survey methods used

29822

 

 

 

status

Dictionary on vegetation survey status

15

 

 

 

stemcountplotsize

Data on size of thestem count area, it is divided by stratum

46962

 

 

 

stratum

Dictionary for stratum

21

 

 

 

structuralformation

Dictionary for vegetation structural formation

183

 

 

 

substrategenetictype

Dictionary for geology genetic type

123

 

 

 

substratelithology

Dictionary for geology rock types

246

 

 

 

survey

Data on type of vegetation survey done

30222

 

 

 

surveyattribute

EMPTY TABLE

0

 

 

 

surveyattributecomplexity

EMPTY TABLE

0

 

 

 

surveyattributegroundcoverestimatecharacteristic

EMPTY TABLE

0

 

 

 

surveyattributegrowthform

EMPTY TABLE

0

 

 

 

surveyattributeleaffallcharacteristic

EMPTY TABLE

0

 

 

 

surveyattributeleafsizecanopytree

EMPTY TABLE

0

 

 

 

surveyattributewoodycoverestimate

EMPTY TABLE

0

 

 

 

surveyparameterstreediameter

Data on tree diameter plot size

12

 

 

 

surveyparameterswoodydebris

Data on woody debris plot size

24

 

 

 

surveysitevisitrecorder

Data on person that carried (recorder) the site survey

42

 

 

 

surveytaxa

DAta on species identified on each survey

324862

 

 

 

surveytaxabasalareaperspecies

Data on species basal area per survey

77332

 

 

 

surveytaxabasalareaperstrata

Data on species-strata basal area

35998

 

 

 

surveytaxacrowncoverperstratum

Data on crown cover per species per stratum

36594

 

 

 

surveytaxamethodobservation

Data on which type of abundance estimate was used

935376

 

 

 

surveytaxamethodtype

Dictionary for surveytaxamethodobservation

9

 

 

 

surveytaxastemdensityperspeciesperstrata

Data on stem density per species per stratum

66289

 

 

 

surveytaxastemdensityperstrata

Data on stem density per stratum

18377

 

 

 

surveytaxasummary

Data summary of all woody species “sirveytaxa” tables

29106

 

 

 

surveytype

Dictionary on type survey carried

6

 

 

 

taxon

Species identification

19592

 

 

 

timesinceevent

Dictionary for disturbance time since

20

 

 

 

treemeasuressummary

Unclear what this is

8

 

 

 

userstatus

Dictionary on user activity

8

 

 

 

vegetationcommunity

Data on vegetation community description

15011

 

 

broadhabitatcode (no values)

vegetationcommunitystructure

Data on vegetation community structure

49845

 

 

 

verificationstatus

Dictionary for verification status

9

 

 

 

verifymethodtype

Dictionary for type of verification carried on different data types

36