Mapping Old CORVEG to QBEIS-CORVEG
- Habacuc FM (Unlicensed)
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 |
| This is now been added to the plant population FOI |
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) | 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 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.