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 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

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.

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);

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:

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;

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;

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

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);

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.



6. Petrol Station Specialised

The 'PetrolStationSpecialised' table works with the relationship class 'PetrolStationRel' and the feature class 'PetrolStationPoints'. The 'PetrolStationSpecialised' table stores a variety of specialised information mainly focusing on attributes associated with exposure as well as risk management, assessment and mitigation. The 'PetrolStationSpecialised' table utilises 'SRCFEATURECLGIDLINK' field to link a relate to the 'PetrolStationPoints' 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 'PetrolStationPoints', see Appendix A - Utility - Petrol Station Point.

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

The 'PetrolStationSpecialised' 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;

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 PUMPS (NUMBEROFPUMPS) [SmallInteger; Yes; 3; Pop_Wk] The number of pumps on site;

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.



7. Powerline Transmission Network Specialised

The 'PowerlineTransmissionNetworkSpecialised' table works with the relationship class 'PowerlineTransRel' and the feature class 'PowerlineTransmissionNetwork'. The 'PowerlineTransmissionNetworkSpecialised' table stores a variety of specialised information mainly focusing on attributes associated with exposure as well as risk management, assessment and mitigation. The 'PowerlineTransmissionNetworkSpecialised' table utilises 'SRCFEATURECLGIDLINK' field to link a relate to the 'PowerlineTransmissionNetwork' 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 'PowerlineTransmissionNetwork', see Appendix A - Utility - Powerline Transmission.

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

The 'PowerlineTransmissionNetworkSpecialised' 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;

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

NETWORK IDENTIFIER (NETWORKID) [String; Yes; 10; Pop_Wk] The network identifier assigned by AEMO or equivalent;

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.



8. Power Station Specialised

The 'PowerStationSpecialised' table works with the relationship class 'PowerStationRel' and the feature class 'PowerStations'. The 'PowerStationSpecialised' table stores a variety of specialised information mainly focusing on attributes associated with exposure as well as risk management, assessment and mitigation. The 'PowerStationSpecialised' table utilises 'SRCFEATURECLGIDLINK' field to link a relate to the 'PowerStations' 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 'PowerStations', see Appendix A - Utility - Power Station.

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

The 'PowerStationSpecialised' 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;

ASH POND NUMBER (ASHPONDNUMBER) [SmallInteger; Yes; 4; Pop_Wk] The number of ash ponds;

AUXILIARY FUEL SYSTEM (AUXILIARYFUELSYSTEM) [String; Yes; 20; Pop_Wk] The auxiliary fuel system used as a backup for the power station;
Acceptable Domain Entries from dm_AuxiliaryFuelType;
Briquettes
Diesel
Gas
Other
Unknown

NUMBER OF BOILERS (BOILERNUMBER) [SmallInteger; Yes; 4; Pop_Wk] The number of Boilers;

BLACK START CAPACITY (BLACKSTARTCAPACITY) [String; Yes; 7; Pop_Wk] Existence of a Black Start Capacity for the power system;
Acceptable Domain Entries from dm_BlackStartCapacity;
No
Unknown
Yes

NUMBER OF COAL BUNKERS (COALBUNKERNUMBER) [SmallInteger; Yes; 4; Pop_Wk] The number of Coal Bunkers;

NUMBER OF CONDENSERS (CONDENSERNUMBER) [SmallInteger; Yes; 4; Pop_Wk] The number of Condensers;

CONSTRUCTION MATERIAL OF BUILDING (CONSTRCTMATERIALBDLG) [String; Yes; 20; Pop_Wk] The material used to construct the generator building;
Acceptable Domain Entries from dm_ConstructionMeth;
Concrete
Masonry
Other
Unknown

CONSTRUCTION MATERIAL TOWER (CONSTRCTMATERIALTOWER) [String; Yes; 20; Pop_Wk] The material used to construct the Tower;
Acceptable Domain Entries from dm_ConstructionMeth;
Concrete
Masonry
Other
Unknown

NUMBER OF COOLING DAMS (COOLINGDAMNUMBER) [SmallInteger; Yes; 4; Pop_Wk] The number of Cooling Dams;

THE SOURCE FOR COOLING (COOLINGSOURCE) [String; Yes; 20; Pop_Wk] The water source used for cooling the system;
Acceptable Domain Entries from dm_CoolingSource;
Dam
Lake
Open Water
Pond
River
Unknown

COOLING WATER TYPE (COOLINGWATERTYPE) [String; Yes; 20; Pop_Wk] The type of water used within the cooling mechanism;
Acceptable Domain Entries from dm_WaterType;
Brackish Water
Fresh Water
Other Water
Recycled Water
Sea Water
Unknown

WATER USAGE FOR COOLING (COOLINGWATERUSAGE) [Integer; Yes; 10; Pop_Wk] The amount of water used or lost in the steam cycle for the cooling process in million litres per day;

NUMBER OF DEMINERALISATION PLANTS (DEMINERALPLANTNUMBER) [SmallInteger; Yes; 4; Pop_Wk] The number of demineralisation plants;

THERMAL EFFICIENCY RATING (EFFICIENCYRATING) [Single; Yes; 6; 1; Pop_Wk] The thermal efficiency rating of the facility;

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

NUMBER OF FEED CONVEYORS (FEEDCONVEYORSNUMBER) [SmallInteger; Yes; 4; Pop_Wk] The number of feed conveyors;

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

FUEL SOURCE LOCATION 1 (FUELSOURCELOC1) [String; Yes; 20; Pop_Wk] The source location for the fuel used within the facility;

FUEL SOURCE LOCATION 2 (FUELSOURCELOC2) [String; Yes; 20; Pop_Wk] The source location for the fuel used within the facility;

FUEL SOURCE NAME 1 (FUELSOURCENAME1) [String; Yes; 60; Pop_Wk] The name of the deposit where the fuel is sourced for the facility;
Acceptable Domain Entries from dm_FuelSource;
Offshore
Onshore
Open Cut
Other
Underground
Unknown

FUEL SOURCE NAME 2 (FUELSOURCENAME2) [String; Yes; 60; Pop_Wk] The name of the deposit where the fuel is sourced for the facility;
Acceptable Domain Entries from dm_FuelSource;
Offshore
Onshore
Open Cut
Other
Underground
Unknown

POWER GENERATION TYPE (GENERATIONTYPE) [String; Yes; 40; Pop_Req] Type of Generator used in Power Station;
Acceptable Domain Entries from dm_PowerGeneratorType;
Closed Cycle Turbine
CoGeneration
Combined Cycle Gas Turbine
Fluidized Bed Combustion
Gas Turbine
Gasification
Internal Combustion
Open Cycle Turbine
Other
Reciprocating Engine
Solar Concentrator
Solar General
Solar Heliostat
Solar Photovoltaic
Steam Turbine
Thermal General
Tidal Power
Unknown
Water Turbine
Water Turbine And Pump
Wind Turbine

INTERNAL POWER CONSUMPTION (INTERNALPOWERCONSUMP) [Single; Yes; 6; 2; Pop_Wk] The power used to operate auxiliary equipment (eg boilers);

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

RATED POWER OUTPUT (RATEDPOWEROUTPUT) [Single; Yes; 6; 2; Pop_Wk] Rated power out in MW per unit;

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

NUMBER OF STEP DOWN TRANSFORMERS (STEPDOWNTRANSFORMERNUM) [SmallInteger; Yes; 4; Pop_Wk] The number of step down transformers;

MAXIMUM HEIGHT OF COOLING TOWERS (TOWERCOOLINGMAXHEIGHT) [Single; Yes; 6; 2; Pop_Wk] The maximum height of tallest cooling tower within facility;

MAXIMUM HEIGHT OF EMISSION TOWERS (TOWEREMISSIONMAXHEIGHT) [Single; Yes; 6; 2; Pop_Req] The maximum height of tallest emission tower within facility;

NUMBER OF TURBINE BUILDINGS (TURBINEBUILDINGNUMBER) [SmallInteger; Yes; 4; Pop_Wk] The number of buildings that house generation turbines;

MAXIMUM HEIGHT OF WIND TURBINE BLADE (WINDTURBINEMAXBLADEHEIGHT) [Single; Yes; 6; 2; Pop_Wk] The maxiumum vertical height to tip of wind turbine blade in metres;

MAXIMUM HEIGHT OF WIND TURBINE HUB (WINDTURBINEMAXHUBHEIGHT) [Single; Yes; 6; 2; Pop_Wk] The maxiumum vertical height to hub of wind turbine blade in metres;

YEAR GENERATION UNIT COMMISSIONED (UNITCOMMISSIONYEAR) [SmallInteger; Yes; 4; Pop_Dep] The year that the oldest generation unit was originally commissioned;

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



9. Roads Specialised

The 'RoadsSpecialised' table works with the relationship class 'RoadsRel' and the feature class 'Roads'. The 'RoadsSpecialised' table stores a variety of information and has been introduced to bring greater alignment between Geoscience Australia data models and the Intergovernmental Committee on Surveying and Mapping (ICSM) proposed standardised Roads Data Model. In addition, some infrastructure exposure information has been included in the table for internal use. The 'RoadsSpecialised' table utilises 'SRCFEATURECLGIDLINK' field to link a relate to the 'Roads' global id value. Producers may be requested to populate/maintain this table as part of a work package revision process.

For more details on the feature class 'Roads', see Appendix A - RoadsTransport or alternatively Section 3 4.1 Structure Overview.

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

The 'RoadsSpecialised' 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;

CONSTRUCTION MATERIAL USED IN BUILDING ROAD (CONSTRCTMATERIALBDLG) [String; Yes; 20; Pop_Wk] The material used to construct the road;
Acceptable Domain Entries from dm_RoadConstruction;
Concrete
Earth
Gravel
Tar

ROUTE CLASSIFICATION (ROUTECLASS) [String; Yes; 20; Pop_Dep] The type of route;
Acceptable Domain Entries from dm_RouteClass;
Auslink
Cycleway
Heavy Haulage
National Route
State Route
Tourist Route

ROUTE NAME (ROUTENAME) [String; Yes; 100; Pop_Dep] The name of the entire route eg Hume Highway (and not sub names such as High Street, main street). This items should be populated where name is known.;

ASSOCIATED ROUTE NUMBER (ROUTENUMBER) [String; Yes; 12; Pop_Wk] The route number/s assigned to the road. Alpha characters in this field are to be in upper case;

WIDTH OF ROAD SHOULDER (SHOULDERWIDTH) [Single; Yes; 4; 2; Pop_Wk] The width in metres of the road shoulder;

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



10. Sewage Treatment Specialised

The 'SewageTreatmentSpecialised' table works with the relationship class 'SewageTreatRel' and the feature class 'SewageTreatmentPlants'. The 'SewageTreatmentSpecialised' table stores a variety of specialised information mainly focusing on attributes associated with exposure as well as risk management, assessment and mitigation. The 'SewageTreatmentSpecialised' table utilises 'SRCFEATURECLGIDLINK' field to link a relate to the 'SewageTreatmentPlants' 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 'SewageTreatmentPlants', see Appendix A - Utility - Sewage Treatment Plant.

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

The 'SewageTreatmentSpecialised' 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;

AREA OF PONDS AND LAGOONS (PONDLAGOONAREA) [Integer; Yes; 8; Pop_Wk] The surface area of ponds and lagoons held within the facility;

REBUILDING TIMEFRAME IN MONTHS (REBUILDINGTIMEFRAME) [SmallInteger; Yes; 4; Pop_Wk] The number of months required to rebuild the site or facility after destruction;

REGULATED (REGULATED) [String; Yes; 7; Pop_Wk] The designation of the facilities regulation status;
Acceptable Domain Entries from dm_Regulated;
No
Unknown
Yes

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 (STORAGECAPACITY) [Integer; Yes; 10; Pop_Wk] Volume of refined product that can be held at facility (eg in tanks for Depots);

AREA OF TANKS (TANKAREA) [Integer; Yes; 8; Pop_Wk] The surface area of tanks (generally circular) held within the facility;

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

TYPE OF WATER TREATMENT (WATERTREATMENTTYPE) [String; Yes; 20; Pop_Wk] The type of water treatment complexity which is undertaken at the site or facility;
Acceptable Domain Entries from dm_WaterTreatment;
Advanced Tertiary
Tertiary
Part Tertiary
Secondary
Primary
Pre Primary
Unknown

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.



11. Substation Specialised

The 'SubstationSpecialised' table works with the relationship class 'SubStationRel' and the feature class 'SubStations'. The 'SubstationSpecialised' table stores a variety of specialised information mainly focusing on attributes associated with exposure as well as risk management, assessment and mitigation. The 'SubstationSpecialised' table utilises 'SRCFEATURECLGIDLINK' field to link a relate to the 'SubStations' 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 'SubStations', see Appendix A - Utility - Sub Station.

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

The 'SubstationSpecialised' 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;

CONSTRUCTION MATERIAL OF BUILDING (CONSTRCTMATERIALBDLG) [String; Yes; 20; Pop_Wk] The material used to construct the Substation building;
Acceptable Domain Entries from dm_ConstructionMeth;
Concrete
Masonry
Other
Unknown

FUNCTIONAL CLASSIFICATION (FUNCTION) [String; Yes; 25; Pop_Dep] The functional classification for SubStation;

VOLTAGE IN KILOVOLTS ENTERING SITE (INVOLTAGEKV) [Integer; Yes; 8; Pop_Wk] The amount of Kilovolts entering site;

VOLTAGE IN KILOVOLTS EXITING SITE (OUTVOLTAGEKV) [Integer; Yes; 8; Pop_Wk] The amount of Kilovolts exiting site;

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

REBUILDING TIMEFRAME IN MONTHS (REBUILDINGTIMEFRAME) [SmallInteger; Yes; 4; Pop_Wk] The number of months required to rebuild the site or facility after destruction;

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

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

TRANSMISSION CONNECTIVITY (TRANSMISSIONCONNECTIVITY) [String; Yes; 100; Pop_Wk] ;

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



12. Telephone Exchange Specialised

The 'TelephoneExchangeSpecialised' table works with the relationship class 'TelephoneExRel' and the feature class 'TelephoneExchanges'. The 'TelephoneExchangeSpecialised' table stores a variety of specialised information mainly focusing on attributes associated with exposure as well as risk management, assessment and mitigation. The 'TelephoneExchangeSpecialised' table utilises 'SRCFEATURECLGIDLINK' field to link a relate to the 'TelephoneExchanges' 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 'TelephoneExchanges', see Appendix A - Utility - Telephone Exchange.

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

The 'TelephoneExchangeSpecialised' 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;

CLASSIFICATION (CLASS) [String; Yes; 40; Pop_Req] The entities classification or status;

CONSTRUCTION MATERIAL OF BUILDING (CONSTRCTMATERIALBDLG) [String; Yes; 20; Pop_Wk] The material used to construct the Telephone Exchange building;
Acceptable Domain Entries from dm_ConstructionMeth;
Concrete
Masonry
Other
Unknown

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

REBUILDING TIMEFRAME IN MONTHS (REBUILDINGTIMEFRAME) [SmallInteger; Yes; 4; Pop_Wk] The number of months required to rebuild the site or facility after destruction;

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

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.



13. Waste Management Point Specialised

The 'WasteManagementPointSpecialised' table works with the relationship class 'WMPRel' and the feature class 'WasteManagementPoints'. The 'WasteManagementPointSpecialised' table will in the future store a variety of specialised information mainly focusing on attributes associated with exposure as well as risk management, assessment and mitigation. The 'WasteManagementPointSpecialised' table utilises 'SRCFEATURECLGIDLINK' field to link a relate to the 'WasteManagementPoints' 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 'WasteManagementPoints', see Appendix A - Culture - Waste Management Point.

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

The 'WasteManagementPointSpecialised 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;

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



Topic contact: mapfeedback@ga.gov.au Last updated: January 20, 2012