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 empty tables | |
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 anynore |
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, | 1 this now lives in surveytaxa table |
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 no raw data available |
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 |