Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

plotsizesampletype

Dictionary on tyep of sampling method or plot shape used

14

project

Data on original project name

240

projectsite

Data on project-site relationship

29398

proportion

Dictionary for proportions

8

relativeabundance

Dictionary on species relative abundance

6

reliefclass

Dictionary on relief class

10

representativesite

Dictionary on landform type of relief

6

samplefloristic

Dictionary on plant species sample (e.g. all plant community, only woody, only herbaceous)

12

samplelevel

Dictionary on type of sample carrying according to Methods for CORVEG

8

securitylevel

Dictionary for security level of data (e.g. public, restricted)

8

severity

Dictionary on disturbance severity CHECK

12

sfclassification

Dictionary on vegetation structure classification method used

6

site

Data on site attributes

29126

sitevisit

Data on site visit attributes

29622

sitevistimethod

sitevisitrecorder

Data on person in charge of site visit

56300

slopetype

Dictionary for slope sites

33

soil

Data on soil surveys

26080

SOILISBELLCODE,SOILMUNSELLCODE, SOILDEPTH

soilcolour

Dictionary for soil colour

36

soildepth

Dictionary for soil depth (currently not in use)

9

soilreliability

Dictionary for soil data reliability

12

soilsource

Dictionary for soil data source

24

soiltexture

Dictionary for soil texture types

129

soiltype

Dictionary for soil type

72

sourcetype

Check

51

speciesidentification

Dictionary on type of species identification done

12

standardsurveyparameters

Data on vegetation survey methods used

29822

status

Dictionary on vegetation survey status

15

stemcountplotsize

Data on size of thestem count area, it is divided by stratum

46962

stratum

Dictionary for stratum

21

structuralformation

Dictionary for vegetation structural formation

183

substrategenetictype

Dictionary for geology genetic type

123

substratelithology

Dictionary for geology rock types

246

survey

Data on type of vegetation survey done

30222

surveyattribute

EMPTY TABLE

0

surveyattributecomplexity

EMPTY TABLE

0

surveyattributegroundcoverestimatecharacteristic

EMPTY TABLE

0

surveyattributegrowthform

EMPTY TABLE

0

surveyattributeleaffallcharacteristic

EMPTY TABLE

0

surveyattributeleafsizecanopytree

EMPTY TABLE

0

surveyattributewoodycoverestimate

EMPTY TABLE

0

surveyparameterstreediameter

Data on tree diameter plot size

12

surveyparameterswoodydebris

Data on woody debris plot size

24

surveysitevisitrecorder

Data on person that carried (recorder) the site survey

42

surveytaxa

DAta on species identified on each survey

324862

surveytaxabasalareaperspecies

Data on species basal area per survey

77332

surveytaxabasalareaperstrata

Data on species-strata basal area

35998

surveytaxacrowncoverperstratum

Data on crown cover per species per stratum

36594

surveytaxamethodobservation

Data on which type of abundance estimate was used

935376

surveytaxamethodtype

Dictionary for surveytaxamethodobservation

9

surveytaxastemdensityperspeciesperstrata

Data on stem density per species per stratum

66289

surveytaxastemdensityperstrata

Data on stem density per stratum

18377

surveytaxasummary

Data summary of all woody species “sirveytaxa” tables

29106

surveytype

Dictionary on type survey carried

6

taxon

Species identification

19592

timesinceevent

Dictionary for disturbance time since

20

treemeasuressummary

Unclear what this is

8

userstatus

Dictionary on user activity

8

vegetationcommunity

Data on vegetation community description

15011

broadhabitatcode (no values)

vegetationcommunitystructure

Data on vegetation community structure

49845

verificationstatus

Dictionary for verification status

9

verifymethodtype

Dictionary for type of verification carried on different data types

36

...