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