8731.0 - Building Approvals, Australia, Jul 2007  
ARCHIVED ISSUE Released at 11:30 AM (CANBERRA TIME) 03/09/2007   
   Page tools: Print Print Page Print all pages in this productPrint All

Specific information regarding Building Approvals SuperTABLE Data Cubes

Building Approvals data are subject to revision. Data cubes are re-released each month including data for the latest month and revisions to data for previous months.

Building Approvals Data Cubes for small area data are available in two formats: SuperTABLE and Excel spreadsheet.

The Excel spreadsheets contain data available from the SuperTABLE data cubes but with less detail e.g. SuperTABLE data cubes include data for each individual month whereas the Excel spreadsheets contain data for the total year.


SuperTABLE data cubes

Number and Value ($m) of Approvals, States and Territories: is a SuperTABLE dataset containing state level data for all states/territories for the latest 37 months.

Classifications
State/TerritoriesAll States & Territories
Reference MonthMonthly (latest 37 months)
Sector of OwnershipPrivate, Public
Type of BuildingHouses, Other Residential, Residential, Non-residential, Non-house and Total building
Type of WorkNew, Alterations & additions (incl. conversions and refurbishments), Total work
Data ItemsValue of approval ($m), Number of dwelling units (no.)

Statistical Local Areas: State, Year
: are SuperTABLE datasets containing Statistical Local Area data for that state/territory for each month in the relevant year.

Classifications
Geographic ClassificationStatistical Local Area (SLA), Statistical Subdivision (SSD), Statistical Division (SD) and State
Reference MonthMonthly (yyyy refers to the financial year)
Sector of OwnershipPrivate, Public
Type of BuildingHouses, Other residential, Residential, Non-residential, Total building
Type of WorkNew, Alterations & additions (incl. conversions and refurbishments), Total work
Data ItemsValue of approval ($000's), Number of dwelling units (no.)


Excel Spreadsheets

Statistical Local Areas: State, Year: are Excel spreadsheets containing Statistical Local Area data for that state/territory for the relevant year.


Information available
Geographic ClassificationStatistical Local Area (SLA), Statistical Subdivision (SSD), Statistical Division (SD) and State
Time periodTotal year, or year to date for the current financial year
Data itemsNew houses (number and value)
New other residential building (number and value)
Total dwellings (number)
Alterations and additions to residential buildings (value)
Total residential building (value)
Non-residential building (value)
Total building (value)


Validation Table for use with SuperTABLE data cubes

The validation table is an Excel spreadsheet containing state level data for checking purposes when using SuperTABLE datasets. It is VERY IMPORTANT to check totals from tables created against the validation table to ensure you have extracted correct data. This is due to overcounting that will occur in the table if you make no selection for some classifications:

1. For Type of Work and Type of Building, you MUST select the categories you require for these classifications, and drag the classification into the table. If you do not do this, records will be counted more than once because sub-totals and totals are included in these classifications, and all levels will be added together. Even if these classifications are not required in your table, overcounting will occur unless you select only the total category and drag this into the table. For definitions of which categories comprise the various sub-totals and totals for Type of Work and Type of Building, see 'Formula'.

2. Reference Month should be brought into the table. Without this, all time periods will be added together.

3. The Statistical Local Area data cubes contain a hierarchical classification for Area, which means that the classification can have a number of levels e.g. State, Statistical Local Area. If nothing from this classification is included in the table, all levels will be added together. Make sure you at least include a total from this classification.

Best practice is to make sure all fields are selected and put into the table.


Formula

Type of Work
Total = New + Total alterations/additions (incl. refurb and conversion)

Type of Building
Total residential building = Total houses + Total other residential building
Non-house building = Total other residential building + Total non-residential building
Total building = Total residential building + Total non-residential building
Total building = Total houses + Non-house building

Definition of Conversions etc.
Conversions etc. = Total building - New houses - New other residential buildings
(This is how to calculate Conversions etc., but it is the equivalent of new non-residential buildings + alterations and additions for total building)


Volatility of Statistical Local Area Data

Note that the estimates for small areas vary from month to month and caution should be used in drawing conclusions from monthly movements.


For Further Information

For any queries about the Buildings data in the cubes, please contact the National Information and Referral Service 1300 135 070.