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