Mapping Old CORVEG to QBEIS-CORVEG

Below are the mappings of Old CORVEG to the QBEIS-CORVEG version. The columns show the name of tables in QBEIS-CORVEG, followed for the analogous tables on old CORVEG. When a column present in old corveg is not in the new version this is marked on the third column.

table name in mapping

newcorveg table

oldcorveg table

columns in oldcorveg missing in new (comment number)

comments

table name in mapping

newcorveg table

oldcorveg table

columns in oldcorveg missing in new (comment number)

comments

 

geology

geology

NA

 

 

landform

situation

elevation of site (1)

1 elevation of site appears in tern_location

 

soil

soil

soil pH (1)

 Not available anymore

 

surveyattribute,
surveyattributecomplexity,
surveyattributegroundcoverestimatecharacteristic,
surveyattributegrowthform,
surveyattributeleaffallcharacteristic,
surveyattributeleafsizecanopytree,
surveyattributewoodycoverestimate

tern_rf_structure

NA

1 This is new in QBEIS and forms part of Rainforest Survey. CORVEG never really handled rainforest surveys very well.  These attributes were not in CORVEG so there was no data to migrate, and no data has been entered yet.

 

tern_climate_data

tern_climate_data

NA

1 this gets added by tern, no changes

tern_disturbanceobservation, tern_disturbancetypeassessment

tern_disturbanceobservation, tern_disturbancetypeassessment

disturbance

non-remnant present (1),
ringbarking present (2),
storm damage present (2),
time since salinity (2),
ringbarked stem count (2)

 1 non-remnant present has gone to vegetation community

2 Not present anymore

tern_groundlayer

tern_groundlayer,
tern_groundlayercharacteristic

tern_site (only ground layer variables)

 

 

tern_site

location, site

tern_site

ground cover - bare (1),
ground cover - cryptogam (1),
ground cover - litter (1),
ground cover - rock (1 )

1 ground columns appear now in tern_groundlayer,
tern_groundlayercharacteristic tables

tern_surveytaxa

surveytaxa

NA

 

 

tern_surveytaxastemdensityperspeciesperstrata

surveytaxastemdensityperspeciesperstrata

tern_site_tax_strata

crown cover (1)

 1 this now lives in surveytaxa table

tern_surveytaxabasalareaperspeciesperstrata

surveytaxabasalareaperspeciesperstrata

tern_site_tax_strata

 

 

tern_surveytaxasummary

surveytaxasummary

tern_structure

vegetation structural formation classification (1)
structural formation ( 1 )

 1. in vegetationcommunity

tern_surveytaxabasalareaperspecies

surveytaxabasalareaperspecies

NA

 

 

tern_surveytaxabasalareaperstrata

surveytaxabasalareaperstrata

NA

 

 

tern_surveytaxacrowncoverperstratum

surveytaxacrowncoverperstratum

NA

 

 

tern_surveytaxastemdensityperstrata

surveytaxastemdensityperstrata

NA

 

 

 

vegetationcommunity

tern_vegetationcommunity

NA

 

tern_vegetationcommunitystructure

vegetationcommunitystructure

site_strata

average crown cover (3),
maximum crown cover (3),
minimum crown cover (3),
crown cover class ( 1 ),
method for estimating crown cover (2),
type of crown cover measure (2)

1 In surveytaxa table

2 standardsurveyparameter table

3 Data incomplete and when present not adding up see footnote (*) for explanation from Dale Richter

 

tern_groundlayerobservation

NA

NA

1 This table did not exist in Old Corveg

tern_bioconditiontreediameter

bioconditiontreediameter

NA

NA

1 Currently not ingested, ingest scientific name, diameter at breast height, plot area

tern_bioconditionwoodydebris

bioconditionwoodydebris

NA

NA

1 Currently not ingested, ingest DEBRISLENGTH, AREA

 

lineinterceptcrowncoverperspeciesperstrata

NA

NA

1 Currently not ingested

 

lineinterceptcrowncoverperstrata

NA

NA

1 Currently not ingested

 

lineinterceptform

NA

NA

1 Currently not ingested

 

lineintercepttotalshrubcrowncover

NA

NA

1 Currently not ingested

 

lineintercepttotaltreecrowncover

NA

NA

1 Currently not ingested

 

methodverificationstatus

NA

NA

1 Currently not ingested

\* check the “coverassessmentworksheet” field in the “Standardsurveyparameters” table for crown cover values.  If it is true than you use the crown cover values from “lineinterceptcrowncoverperspeciesperstrata” if false then “surveytaxacrowncoverperstratum”.  However, presence records “0” will always be recorded in the “surveytaxacrowncoverperstratum”. For the background on this its probably better to have a chat.