Appendix F - Listing of Non Spatial Tables

This appendix lists all the related tables and their definitions which occur within the NTDB. The related tables are listed in alphabetical order.

A single table may be used by multiple feature classes.

For more information relating to tables and how they fit within the Geoscience Australia's topographic database structures refer to Section 3 Chapter 4.4 Non Spatial Tables and Relationship Classes

NOTE: The item definition has been conducted in a similar manner to that is Appendix A Feature Type Dictionary, see 'An explanation of the feature type dictionary's layout and components' for more information

1. FeatureClassesFieldInpected

The 'FeatureClassesFieldInspected' table works with the relationship class 'FII_FCFI' and the feature class 'FieldInspectionIndex' to store information on the work conducted as part of field inspection exercises. The 'FeatureClassesFieldInspected' table stores information on the feature classes which have been reviewed as part of a field inspection and the resultant accuracies and reliability of the information obtained. In general, Geoscience Australia will populate this table and producers need only do so if directed in their project instructions.

The 'FeatureClassesFieldInpected' table has the following definition:

Data Attributes

FIELD INSPECTION NAME (FIELDINSPECTIONNAME) [String;Yes;50;Pop_Req] The name of the field inspection.

FEATURE RELIABILITY DATE (FEATURERELIABILITY) [Date;Yes;36;0;0;Pop_Req] The reliability date of the spatial object; Date to be adjusted only during spatial change or verification of an existing feature location or the capture of a new feature (see (see Section 1 Chapter 3.6) ; Most Recent Reliability Date of Revision Source Material (or Base Material/digital data for initial capture) used for Spatial Verification

ATTRIBUTE RELIABILITY DATE (ATTRIBUTERELIABILITY) [Date;Yes;36;0;0;Pop_Req] The reliability date of the attribute object; Date to be adjusted only during attribute change or verification of an existing feature's item values or the capture of a new feature (see Section 1 Chapter 3.6) ; Most Recent Reliability Date of Revision Source Material (or Base Material/digital data for initial capture) used for Attribute Verification.

PLANIMETRIC ACCURACY (PLANIMETRICACCURACY) [SmallInteger;Yes;0;4;0;Pop_Req] The standard deviation of the horizontal positional accuracy. (See Section 1 Chapter 3.7 Positional Accuracy for more information);

ELEVATION ACCURACY (ELEVATIONACCURACY) [SmallInteger;Yes;0;4;0;Pop_Req] The standard deviation of the vertical positional accuracy. (See Section 1 Chapter 3.7 Positional Accuracy for more information);

FEATURE CLASSES INSPECTED (FEATURECLASSESINSPECTED) [String;Yes;255;Pop_Req] The name/s of the inspected feature class/es;

GLOBAL IDENTIFIER (GlobalID) [Global ID;Yes;Pop_Aut] A unique system generated Global Identifier. This field will be entered/edited automatically by GEOSCIENCE AUSTRALIA.

2. FeatureClassesRevised

The 'FeatureClassesRevised' table works with the relationship class 'WPI_FCR_WUN' and the feature class 'WorkPackageIndex' to store information on the work conducted as part of Work Package revision processes. This information can be stored to the sub-workunit level. The 'FeatureClassesRevised' table is used to store metadata about the feature classes either to be revised, or those which have been revised, as part of a work package. It will provide information on the assigned feature and attribute reliability as well as planimetric and elevation accuracies achieved. In general, this table will be populated at the start of a workpackage and reviewed for correctness when the work package is completed. In general, Geoscience Australia will populate this table and provide it to producers to refer to during work package activities.

Dependent on Geoscience Australia's External Stakeholders needs, the 'WorkPackageIndex' and its related table 'FeatureClassesRevised' may be used in conjunction with feature level metadata on the 1:25 000 data capture program.

The 'FeatureClassesRevised' table has the following definition:

Data Attributes

WORK PACKAGE/WORK UNIT/SUBSET MERGED CODE (WPWUSSCODE) [String;Yes;12;Pop_Req] The unique code used to link with the WorkPackageIndex feature class;

FEATURE SOURCE (FEATURESOURCE) [String;Yes;50;0;0;Pop_Req] This primary source used to determine the spatial location of a feature.

ATTRIBUTE RELIABILITY DATE (ATTRIBUTERELIABILITY) [Date;Yes;36;0;0;Pop_Req] The reliability date of the attribute object; Date to be adjusted only during attribute change or verification of an existing feature's item values or the capture of a new feature (see Section 1 Chapter 3.6); Most Recent Reliability Date of Revision Source Material (or Base Material/digital data for initial capture) used for Attribute Verification.

ATTRIBUTE SOURCE (ATTRIBUTESOURCE) [String;Yes;50;0;0;Pop_Req] The primary source used to populate the attribute fields of a feature.

REVISED DATE (REVISED) [Date;Yes;36;0;0;Pop_Req] The date when the row record was last altered.;

FEATURE CLASSES REVISED (FEATURECLASSESREVISED) [String;Yes;255;Pop_Req] The name/s of the revised Feature Class/es;

GLOBAL IDENTIFIER (GlobalID) [Global ID;Yes;Pop_Aut] A unique system generated Global Identifier. This field will be entered/edited automatically by GEOSCIENCE AUSTRALIA.

3. Liquid Fuel Depot Specialised

The 'LiquidFuelDepotSpecialised' table works with the relationship class 'LiqFuelDepotRel' and the feature class 'LiquidFuelDepotPoints'. The 'LiquidFuelDepotSpecialised' table stores a variety of specialised information mainly focusing on attributes associated with exposure as well as risk management, assessment and mitigation. The 'LiquidFuelDepotSpecialised' table utilises 'SRCFEATURECLGIDLINK' field to link a relate to the 'LiquidFuelDepotPoints' global id value. In general, Geoscience Australia will populate this table and producers need only do so if directed in their project instructions.

For more details on the feature class 'LiquidFuelDepotPoints', see Appendix A - Utility - Liquid Fuel Depot Point.

For more details on the Relationship Class 'LiqFuelDepotRel', see Section 3 4.4 Non Spatial Tables and Relationship Classes.

The 'LiquidFuelDepotSpecialised' table has the following definition:

Data Attributes

LINK TO SOURCE FEATURE CLASS GLOBAL ID (SRCFEATURECLGIDLINK) [GUID; Yes; ; Pop_Req] The Global id value of the associated feature class entity to provide a relational link;

CONSTRUCTION MATERIAL TANK (CONSTRCTMATERIALTANK) [String; Yes; 20; Pop_Wk] The primary material used to construct the Tank or Tanks;

NUMBER OF EMPLOYEES (EMPLOYEENUMBERS) [SmallInteger; Yes; 6; Pop_Wk] The number of employees at the facility;

TYPE OF FUEL PRODUCTS (FUELPRODUCTS) [String; Yes; 100; Pop_Wk] A list of fuel products stored or traded at the site or facility;

NUMBER OF TANKS (NUMBEROFTANKS) [SmallInteger; Yes; 4; Pop_Wk] The number of tanks (generally storage) situated at a site or facility;

SITE CATEGORY (SITECATEGORY) [String; Yes; 7; Pop_Wk] The category level for the site or facility;
Acceptable Domain Entries from dm_SiteCategory;
Major
Medium
Minor
Unknown

STORAGE CAPACITY (STORAGECAPACITY) [Integer; Yes; 10; Pop_Wk] Volume of refined product that can be held at facility (eg in tanks for Depots);

PRINCIPAL FUEL DELIVERY METHOD (SUPPLYDELIVERYMETHOD) [String; Yes; 20; Pop_Wk] The principal method for delivering fuel to the facility;
Acceptable Domain Entries from dm_SupplyDeliveryMeth;
Conveyor
Pipeline
Railway
Road
Sea
Unknown

VOLUME IN MEGA LITRES (VOLUMEMEGAL) [Single; Yes; 6; 2; Pop_Wk] Volume through put of site or facility in mega litres per annum;

GLOBAL IDENTIFIER (GlobalID) [Global ID;Yes;Pop_Aut] A unique system generated Global Identifier. This field will be entered/edited automatically by GEOSCIENCE AUSTRALIA.

4. Liquid Fuel Refinery Specialised

The 'LiquidFuelRefinSpecialised' table works with the relationship class 'LiqFuelRefinRel' and the feature class 'LiquidFuelRefineryPoints'. The 'LiquidFuelRefinSpecialised' table stores a variety of specialised information mainly focusing on attributes associated with exposure as well as risk management, assessment and mitigation. The 'LiquidFuelRefinSpecialised' table utilises 'SRCFEATURECLGIDLINK' field to link a relate to the 'LiquidFuelRefineryPoints' global id value. In general, Geoscience Australia will populate this table and producers need only do so if directed in their project instructions.

For more details on the feature class 'LiquidFuelRefineryPoints', see Appendix A - Utility - Liquid Fuel Refinery Point.

For more details on the Relationship Class 'LiqFuelRefinRel', see Section 3 4.4 Non Spatial Tables and Relationship Classes.

The 'LiquidFuelRefinSpecialised' table has the following definition:

Data Attributes

LINK TO SOURCE FEATURE CLASS GLOBAL ID (SRCFEATURECLGIDLINK) [GUID; Yes; Pop_Aut] The Global id value of the associated feature class entity to provide a relational link;

NUMBER OF EMPLOYEES (EMPLOYEENUMBERS) [SmallInteger; Yes; 6; Pop_Wk] The number of employees at the facility;

LAST RECORDED UPGRADE (LASTRECORDEDUPGRADE) [SmallInteger; Yes; 4; Pop_Wk] The last recorded upgrade or retrofits to increase efficiency or rated generation capacity;

PRODUCTS ENTERING FACILITY (INPUTPRODUCTS) [String; Yes; 150; Pop_Wk] The products which enter the facility as part of the facilities function;

NUMBER OF TANKS (NUMBEROFTANKS) [SmallInteger; Yes; 4; Pop_Wk] The number of tanks (generally storage) situated at a site or facility;

PRODUCTS EXITING FACILITY (OUTPUTPRODUCTS) [String; Yes; 150; Pop_Wk] The products which exit the facility as part of the facilities function;

REPLACEMENT COST (REPLACEMENTCOST) [Single; Yes; 6; 2; Pop_Wk] Cost to rebuild in same location to todays standards in millions of dollars;

SITE OF AREA (SITEAREA) [Integer; Yes; 10; Pop_Wk] The area of the site or facility in (m2);

STORAGE CAPACITY OF LIQUIDS (STORCAPCTYLIQUIDS) [Integer; Yes; 10; Pop_Wk] Volume of refined petrol and diesel products that can be held at facility (Million Litres);

STORAGE CAPACITY OF LPG (STORCAPCTYLPG) [Integer; Yes; 10; Pop_Wk] Volume of LPG that can be held at facility (Tonnes);

STORAGE CAPACITY OF OTHER PRODUCT 1 (STORCAPCTYOTHER1) [Integer; Yes; 10; Pop_Wk] Volume of other product (eg Bitumen) that can be held at facility (Tonnes);

STORAGE CAPACITY OF OTHER PRODUCT 2 (STORCAPCTYOTHER2) [Double; Yes; 10; 2; Pop_Wk] Volume of other product (eg Base Oil, Detergents, Chemicals, Lubricants, etc) that can be held at facility (Million Litres);

STORAGE CAPACITY OF RAW PRODUCT (STORCAPCTYRAWPRODUCT) [Integer; Yes; 10; Pop_Wk] Volume of raw product that can be held at facility (Million Litres);

PRINCIPAL FUEL DELIVERY METHOD (SUPPLYDELIVERYMETHOD) [String; Yes; 20; Pop_Wk] The principal method for delivering fuel to the facility; Acceptable Domain Entries from dm_SupplyDeliveryMeth;
Conveyor
Pipeline
Railway
Road
Sea
Unknown

VOLUME IN MEGA LITRES (VOLUMEMEGAL) [Single; Yes; 6; 2; Pop_Wk] Volume through put of site or facility in mega litres per annum;

YEAR FACILITY COMMISSIONED (YEARCOMMISSIONED) [SmallInteger; Yes; 4; Pop_Dep] The year that the facility was originally commissioned (eg powerstation);

GLOBAL IDENTIFIER (GlobalID) [Global ID;Yes;Pop_Aut] A unique system generated Global Identifier. This field will be entered/edited automatically by GEOSCIENCE AUSTRALIA.

5. Liquid Fuel Terminal Specialised

The 'LiquidFuelTermSpecialised' table works with the relationship class 'LiqFuelTermRel' and the feature class 'LiquidFuelTerminalPoints'. The 'LiquidFuelTermSpecialised' table stores a variety of specialised information mainly focusing on attributes associated with exposure as well as risk management, assessment and mitigation. The 'LiquidFuelTermSpecialised' table utilises 'SRCFEATURECLGIDLINK' field to link a relate to the 'LiquidFuelTerminalPoints' global id value. In general, Geoscience Australia will populate this table and producers need only do so if directed in their project instructions.

For more details on the feature class 'LiquidFuelTerminalPoints', see Appendix A - Utility - Liquid Fuel Terminal Point.

For more details on the Relationship Class 'LiqFuelTermRel', see Section 3 4.4 Non Spatial Tables and Relationship Classes.

The 'LiquidFuelTermSpecialised' table has the following definition: