Australian Vegetation Attribute Manual

National Vegetation Information System, Version 6.0
Executive Steering Committee for Australian Vegetation Information (ESCAVI)
Department of the Environment and Heritage, 2003
ISBN 0 642 54953 2

Appendix D: List of NVIS Database Fields by Table


Field_Name Nullable? Field_Definition Old_Field_Name
DATA_SET      
DATA_SET_ID NOT NULL NUMBER(10) DATSET_ID
AGENCY_ID NOT NULL NUMBER(10) AGE_ID
---------- (Administrative Fields) ----------- ---------------- ------------------------  
DATA_SET_NAME (+) NOT NULL VARCHAR2(2000) DATSET_NAME (+)
DATA_SET_NUMBER (+) NOT NULL NUMBER(10) DATSET_NUMBER (+)
VEGETATION_THEME_CODE (+) NOT NULL VARCHAR2(20) DATSET_COVERAGE_TYPE
VEGETATION_THEME_CONSTRAINTS (+)   VARCHAR2(2000) VEGETATION_THEME_LIMITATIONS (+)
---------- (Attribute Information) ----------- ---------------- ------------------------  
ANZLIC_METADATA_IDENTIFIER   VARCHAR2(50)  
ANZLIC_METADATA_NAME   VARCHAR2(2000)  
ANZLIC_METADATA_URL   VARCHAR2(2000)  
STRUCTURAL_CLASSFN_SYSTEM NOT NULL VARCHAR2(50)  
FLORISTIC_GROUP_TYPE   VARCHAR2(20)  
CLASSIFICATION_METHOD NOT NULL VARCHAR2(4000) CLASSIFICATION_SUPPORT
SAMPLING_TYPE NOT NULL VARCHAR2(50)  
BOTANICAL_EXPERTISE   VARCHAR2(2000)  
POSITIONAL_ACCURACY NOT NULL NUMBER(5,1)  
POSITIONAL_ACCURACY_DETERM NOT NULL VARCHAR2(20) POSITIONAL_ACC_DETERM
POSITIONAL_ACCURACY_MEASURE   VARCHAR2(20) POSITIONAL_ACC_MEASURE
MAP_PUBLICATION_SCALE NOT NULL NUMBER(10)  
FINEST_SCALE   NUMBER(10) FINE_SCALE
BROADEST_SCALE   NUMBER(10) BROAD_SCALE
SURVEY_AND_MAP_RELIABILITY NOT NULL VARCHAR2(2000) RELIABILITY
START_DATE_ATTRIBUTE NOT NULL DATE  
END_DATE_ATTRIBUTE NOT NULL DATE  
START_DATE_SPATIAL (+) NOT NULL DATE  
END_DATE_SPATIAL (+) NOT NULL DATE  
       
MAPPING_SOURCE     MAPPING_METHOD, MAP_SOURCE
MAPPING_SOURCE_ID (+) NOT NULL NUMBER(10)  
DATA_SET_ID NOT NULL NUMBER(10) DATSET_ID
------------------------- ---------------- ------------------------  
MAPPING_SOURCE_NUMBER   NUMBER(10) MAPMTH_NUMBER, MAPSRC_NUMBER
MAPPING_METHOD NOT NULL VARCHAR2(2000)  
MAPPING_EXPERTISE   VARCHAR2(2000)  
IMAGERY_SOURCE NOT NULL VARCHAR2(2000) INTERPRETIVE_BASE
IMAGERY_SCALE NOT NULL NUMBER(10) SCALE_OR_RESOLUTION
IMAGERY_RESOLUTION   NUMBER(10) SCALE_OR_RESOLUTION
MAPPING_SOURCE_EXTENT (+)   VARCHAR2(4000)  
DELINEATION_ MEDIUM   VARCHAR2(2000) MEDIUM
START_DATE_SOURCE   DATE START_DATE
END_DATE_SOURCE   DATE END_DATE
MAP_BASE   VARCHAR2(2000)  
       
REFERENCE      
REFERENCE_ID NOT NULL NUMBER(10) REF_ID
DATA_SET_ID NOT NULL NUMBER(10) DATSET_ID
------------------------- ---------------- ------------------------  
CITATION NOT NULL VARCHAR2(2000)  
FORMAT   VARCHAR2(2000)  
STORAGE_LOCATION   VARCHAR2(2000)  
       
MAP_UNIT      
MAP_UNIT_ID NOT NULL NUMBER(10)  
VEG_ID NOT NULL NUMBER(10)  
DATA_SET_ID NOT NULL NUMBER(10) DATSET_ID
------------------------- ---------------- ------------------------  
MAPUNT_IDENTIFIER NOT NULL NUMBER(10)  
NVIS_ID NOT NULL NUMBER(10) States may decide to include this for operational reasons
SPATIAL_MIX NOT NULL VARCHAR2(50)  
# MOSAIC_TYPE   VARCHAR2(1)  
NUMBER_OF_VEG_DESCRIPTIONS NOT NULL NUMBER(10)  
VEG_DESC_POSITION NOT NULL NUMBER(10)  
VEG_DESC_PROPORTION   NUMBER(10)  
# SOURCE_CODE NOT NULL VARCHAR2(50)  
# SOURCE_DESCRIPTION NOT NULL VARCHAR2(2000)  
# SOURCE_CODE_COMPONENT NOT NULL VARCHAR2(50) SRC_CODE_COMPONENT
       
VEG_DESCRIPTION      
VEG_ID NOT NULL NUMBER(10)  
NVIS_ID   NUMBER(10) NOT NULL in C/W system
------------------------- ---------------- ------------------------  
SOURCE_CODE NOT NULL VARCHAR2(50)  
LEVEL_OF_DETAIL (+) NOT NULL VARCHAR2(50) ENTRY_LEVEL (+)
NUMBER_OF_STRATA NOT NULL NUMBER(10)  
L1_CLASS NOT NULL VARCHAR2(50) CLASS_L1
L2_STRUCTURAL_FORMATION NOT NULL VARCHAR2(2000) STRUCTURAL_FORMATION_L2
L3_BROAD_FLORISTIC_FORMATION NOT NULL VARCHAR2(2000) BROAD_FLORISTIC_FORMATION_L3
L4_SUB_FORMATION NOT NULL VARCHAR2(2000) SUB_FORMATION_L4
L5_ASSOCIATION NOT NULL VARCHAR2(2000) ASSOCIATION_L5
L6_SUB_ASSOCIATION NOT NULL VARCHAR2(2000) SUB_ASSOCIATION_L6
SOURCE_DESCRIPTION NOT NULL VARCHAR2(2000)  
ENVIRONMENTAL_DESCRIPTION   VARCHAR2(2000)  
STATE   VARCHAR2(20)  
COMMENTS   VARCHAR2(2000)  
XML_LOADDATE   DATE  
XML_STATUS   VARCHAR2(50)  
       
STRATUM      
STRATUM_ID NOT NULL NUMBER(10) STR_ID
VEG_ID (NVIS_ID in C/W system) NOT NULL NUMBER(10) NVIS_ID
------------------------- ---------------- ------------------------  
STRATUM_CODE NOT NULL VARCHAR2(20)  
SUB_STRATUM_RANK   NUMBER(10) STR_NUMBER
NUMBER_OF_GROWTH_FORMS NOT NULL NUMBER(10)  
NUMBER_OF_TAXA NOT NULL NUMBER(10)  
COVER_TYPE NOT NULL VARCHAR2(20)  
COVER_TYPE_DERIV_METHOD   VARCHAR2(2000)  
COVER_MINIMUM_VALUE   NUMBER(5,1)  
COVER_MAXIMUM_VALUE   NUMBER(5,1)  
COVER_MEDIAN_VALUE   NUMBER(5,1)  
COVER_MEAN_VALUE NOT NULL NUMBER(5,1)  
COVER_CODE NOT NULL VARCHAR2(20)  
HEIGHT_TYPE NOT NULL VARCHAR2(20)  
HEIGHT_TYPE_DERIV_METHOD   VARCHAR2(2000)  
HEIGHT_MINIMUM_VALUE   NUMBER(5,1)  
HEIGHT_MAXIMUM_VALUE   NUMBER(5,1)  
HEIGHT_MEAN_VALUE NOT NULL NUMBER(5,1)  
HEIGHT_MEDIAN_VALUE   NUMBER(5,1)  
HEIGHT_CLASS NOT NULL NUMBER(10)  
DOMINANT_STRATUM_FLAG NOT NULL VARCHAR2(1) IS_DOMINANT
       
TAXON_DATA     TAXON
TAXON_DATA_ID NOT NULL NUMBER(10) TAX_ID
STRATUM_ID NOT NULL NUMBER(10) STR_ID
TAXON_LISTS_ID   NUMBER(10) TAXDSC_ID
------------------------- ---------------- ------------------------  
TAXON_DATA_RANK NOT NULL NUMBER(10) TAX_NUMBER
TAXON_DATA_DESCRIPTION (+) NOT NULL VARCHAR2(2000) TAXON_DESCRIPTION
TAXON_DATA_SOURCE_CODE (+)   VARCHAR2(50)  
COVER_TYPE NOT NULL VARCHAR2(20)  
COVER_TYPE_DERIV_METHOD   VARCHAR2(2000)  
COVER_MINIMUM_VALUE   NUMBER(5,1)  
COVER_MAXIMUM_VALUE   NUMBER(5,1)  
COVER_MEDIAN_VALUE   NUMBER(5,1)  
COVER_MEAN_VALUE   NUMBER(5,1)  
TAXON_DATA_DOMINANCE_QUALIFIER (+)   VARCHAR2(20) COVER_DOMINANCE
TAXON_DATA_FREQUENCY   VARCHAR2(20) C0VER_FREQUENCY
TAXON_DATA_ALWAYS_THERE (+) NOT NULL VARCHAR2(20)  
TAXON_DATA_SUMMARY_FLAG (+) NOT NULL VARCHAR2(1) SUMMARY_FLAG
       
GROWTH_FORM      
GROWTH_FORM_ID NOT NULL NUMBER(10) GROFRM_ID
STRATUM_ID NOT NULL NUMBER(10) STR_ID
------------------------- ---------------- ------------------------  
GROWTH_FORM_RANK   NUMBER(10) GROFRM_NUMBER
GROWTH_FORM_CODE NOT NULL VARCHAR2(20)  
COVER_TYPE   VARCHAR2(20)  
COVER_TYPE_DERIV_METHOD   VARCHAR2(2000)  
COVER_MINIMUM_VALUE   NUMBER(5,1)  
COVER_MAXIMUM_VALUE   NUMBER(5,1)  
COVER_MEDIAN_VALUE   NUMBER(5,1)  
COVER_MEAN_VALUE   NUMBER(5,1)  
GR_FORM_DOMINANCE_QUALIFIER (+)   VARCHAR2(20) DOMINANCE
GROWTH_FORM_FREQUENCY   VARCHAR2(20) FREQUENCY
GROWTH_FORM_ALWAYS_THERE (+) NOT NULL VARCHAR2(20)  
GROWTH_FORM_SUMMARY_FLAG (+) NOT NULL VARCHAR2(1) SUMMARY_FLAG
       
TAXON_LIST_ORIGIN     TAXON_LIST
TAXON_LIST_ORIGIN_ID NOT NULL NUMBER(10) TAXLST_ID
------------------------- ---------------- ------------------------  
TAXON_LIST_ORIGIN_CUSTODIAN NOT NULL VARCHAR2(2000) TAXLST_SOURCE
TAXON_LIST_ORIGIN_STATE NOT NULL VARCHAR2(20) STATE
TAXON_LIST_ORIGIN_DETAILS NOT NULL VARCHAR2(2000) TAXLST_NAME
       
TAXON_LISTS     TAXON_DESCRIPTION
TAXON_LISTS_ID NOT NULL NUMBER(10) TAXDSC_ID
TAXON_LIST_ORIGIN_ID NOT NULL NUMBER(10) TAXDSC_TAXLST_ID
------------------------- ---------------- ------------------------ -------------------------
TAXON_LISTS_SOURCE_CODE NOT NULL VARCHAR2(50) TAXDSC_SOURCE_CODE
TAXON_LISTS_FAMILY   VARCHAR2(50) TAXDSC_FAMILY
TAXON_LISTS_GENUS NOT NULL VARCHAR2(50) TAXDSC_GENUS
TAXON_LISTS_SPECIES NOT NULL VARCHAR2(50) TAXDSC_SPECIES
TAXON_LISTS_AUTHOR   VARCHAR2(2000) TAXDSC_AUTHOR
TAXON_LISTS_INFRA_SPECIES_RANK   VARCHAR2(50) TAXDSC_INFRA_SPECIES_RANK
TAXON_LISTS_INFRA_SPECIES   VARCHAR2(50) TAXDSC_INFRA_SPECIES
TAXON_LISTS_INFRA_SP_AUTHOR   VARCHAR2(2000) TAXDSC_INFRA_SPECIES_AUTHOR
TAXON_LISTS_COMMON_NAME   VARCHAR2(2000) TAXDSC_COMMON_NAME
TAXON_LISTS_REFERENCE (+)   VARCHAR2(2000) TAXDSC_REFERENCE
       
AGENCY      
AGENCY_ID NOT NULL NUMBER(10) AGE_ID
------------------------ ---------------- ------------------------  
AGENCY_NAME NOT NULL VARCHAR2(2000) AGE_NAME
AGENCY_ADDRESS   VARCHAR2(2000) AGE_ADDRESS
AGENCY_LOCATION   VARCHAR2(2000) AGE_LOCATION
STATE   VARCHAR2(20)  
       
CONTACT      
CONTACT_ID NOT NULL NUMBER(10) CON_ID
AGENCY_ID NOT NULL NUMBER(10) CON_AGE_ID
------------------------ ---------------- ------------------------  
CONTACT_TYPE   VARCHAR2(2000) CON_TYPE
CONTACT_NAME   VARCHAR2(2000) CON_NAME
CONTACT_ADDRESS   VARCHAR2(2000) CON_ADDRESS
CONTACT_PHONE_NUMBERS   VARCHAR2(2000) CON_PHONE_NUMBERS
CONTACT_EMAIL   VARCHAR2(2000) CON_EMAIL
       
VEG_HABITAT      
VEG_HABITAT_ID NOT NULL NUMBER(10) VEGHAB_ID
NVIS_ID NOT NULL NUMBER(10)  
------------------------- ---------------- ------------------------  
HABITAT_CODE NOT NULL VARCHAR2(50)  
HABITAT_TEXT NOT NULL VARCHAR2(300)  
       
ATTRIBUTE_LOOKUP      
TABLE NOT NULL VARCHAR2(50)  
FIELD NOT NULL VARCHAR2(50)  
LOOKUP_CODE NOT NULL VARCHAR2(50)  
LOOKUP_TEXT NOT NULL VARCHAR2(4000)  
       
SPATIAL_DATA (SDE or COVERAGE)      
MAPUNT_IDENTIFIER NOT_NULL NUMBER(10)  
VEGDSC1 NOT NULL VARCHAR2(50)  
VEGDSC2   VARCHAR2(50)  
VEGDSC3   VARCHAR2(50)  
VEGDSC4   VARCHAR2(50)  
VEGDSC5   VARCHAR2(50)  
VEGDSC6   VARCHAR2(50)  
VEGPROP1   NUMBER(5)  
VEGPROP2   NUMBER(5)  
VEGPROP3   NUMBER(5)  
VEGPROP4   NUMBER(5)  
VEGPROP5   NUMBER(5)  
VEGPROP6   NUMBER(5)  
SPATIAL_MIX NOT NULL VARCHAR2(30)  
NO_VEG_DESC NOT NULL NUMBER(5)  
       
(+) Fields moved or added during database restructure or subsequently 
Shaded tables/fields are probably not relevant to state d/b structure proposals
# fields retained until mosaics are resolved in legacy data
(-) deleted fields (not listed)