Skip to content

Home > Labour Market Information > Tools > Snapshot

Department of Labour logo for printing

In This Section

Downloads

Contacts

Labour Market Information

Regional Industry Snapshot Tool 2007

The Regional Industry Snapshot Tool is an interactive tool which allows you to select and view key facts about selected regions or industry in terms of the number of employees. Various measures are available in the tool to analyse the underlying information. Click here to access it directly [MS Excel 5.3MB].

Troubleshooting for the Regional Industry Snapshot Tool

Hold down the Ctrl Key and use the mouse scroll to resize the window and obtain the desired view.
Note that this is still a ‘trial tool” so if you have any technical problems or questions about interpretation, please contact us at the address shown at the bottom.

Why was it developed?

The Regional Industry Snapshot Tool was developed to help users to interactively view the number of employees at a regional or industry level, identifying key features, similarities and differences across and between regions.

What it contains

The Regional Industry Snapshot Tool ranks, sorts and displays industries (using a 1-5 digit ANZSIC classification) for any selected region or regions or for any industry in terms of the number of employees. The number of employees is defined as the head count of salary and wage earners (NOT self employed) sourced from taxation data.Various measures are shown for each of these variables, such as:

  • Latest numeric value in region or industry (2007).
  • Change in region or industry for the period 2003-2007 (%).
  • Latest share in region or industry (%).
  • Change in comparison region 2003-2007(%).
  • Share of New Zealand-wide industry in 2007 (%), the share of the regional industry in the national industry (e.g. Paper and Pulp Manufacturing in the Rotorua as a percentage of aggregate Paper and Pulp Manufacturing in New Zealand).
  • Share of industry employment across regions in 2007 (%)
  • Relative Importance measure (ratio), for employees only, also known as Location Quotient (explained below under “Other features”).

How to use it

The tool has 5 menu sheets that view:

  • the number of employees for 17 1-digit industries in a selected region
  • the number of employees for 58 2-digit industries in a selected region
  • the number of employees for 158 3-digit industries in a selected region
  • the number of employees for a selected 5/3/2/1 digit industry across TLAs
  • the number of employees for a selected 5/3/2/1 digit industry across RDCs

The Regions menus (1-3) which allows you to make the following selections:

  • Select region: The menu offers Territorial Authority (TA) and Regional Council (RC). Up to 5 regions can be combined. To avoid double counting a TA region or its larger RDC region, a warning and protection mechanism is built in.
  • Select comparison region: any specified (set) region(s) can be compared to one single other region as well as the country as a whole.
  • Select ranking measure: for each (set) of region(s) chosen, one of three ranking measures can be selected for graphic display: numeric value, growth or share in New Zealand sector. A definition of these is presented below.
    • Numeric value: the total value, e.g. the total number of employees counted.
    • Growth: compound annual average growth rates over the last 5 years.
    • Share in New Zealand sector: the national share of an industry in a given region, expressed as a percentage. For example, in Bay of Plenty it will show that 20.2% of employment in Zealand’s Forestry industry (NZSIC A03) is located in that region.

The Industry by TA and Industry by RC tabs use a similar approach. The main difference is that shares are now calculated across regions and compared with the distribution of number of employees for all industries across regions.

Updates

This information relies primarily on annual business frame data from Statistics New Zealand, therefore will be updated every year.

Other Features

  • Graphic information: the industries can be ranked in a graph according to a selected measure with additional information in brackets of the labels. For example, if growth is selected, share is shown in brackets beside the labels and if absolute value (share in region) is selected, growth rates are shown in brackets beside the labels.
  • Table-based information: each 1-3 digit industry can be ranked according to a selected measure with other information shown in relevant columns.
  • Relative Importance is a ratio showing the share of employment in an industry in a region compared to its share at the economy-wide level (known in economic literature as the Location Quotient). A value higher than one, assuming there are no special factors (such as government subsidies), implies relatively high labour inputs in this industry in a region compared to the national labour inputs. This suggests the industry might have a comparative advantage in that particular region.

Data Sources

If you want more detail on how the numbers were derived and sourced, view the Notes & Data Sources tab on the spreadsheet.