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 |
---|---|---|---|---|
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, | 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), | 1 non-remnant present has gone to vegetation community 2 Not present anymore |
tern_groundlayer | tern_groundlayer, | tern_site (only ground layer variables) |
|
|
tern_site | location, site | tern_site | ground cover - bare (1), | 1 ground columns appear now in tern_groundlayer, |
tern_surveytaxa | surveytaxa | NA | ||
tern_surveytaxastemdensityperspeciesperstrata | surveytaxastemdensityperspeciesperstrata | tern_site_tax_strata | tree basal area (2), | 1 this now lives in surveytaxa table 2 CHECK, this cannot be calculated from current data |
tern_surveytaxasummary | surveytaxasummary | tern_structure | vegetation structural formation classification (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), | 1 In surveytaxa table 2 standardsurveyparameter table 3 Not available, and unclear whether raw data should come from lineintercept or surveytaxa tables |
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 |