Template:NZ population data 1992: Difference between revisions
mNo edit summary |
Update and expand urban area figures. Cite source. |
||
Line 89: | Line 89: | ||
| Invercargill City = 52,900 |
| Invercargill City = 52,900 |
||
<!-- Table 3 = Urban areas --> |
<!-- Table 3 = Urban areas --> |
||
| Whangarei = |
| Whangarei = 52500 |
||
| Auckland = |
| Auckland = 1397300 |
||
| Northern Auckland Zone = |
| Northern Auckland Zone = 285100 |
||
| Western Auckland Zone = |
| Western Auckland Zone = 221300 |
||
| Central Auckland Zone = |
| Central Auckland Zone = 452400 |
||
| Southern Auckland Zone = |
| Southern Auckland Zone = 438500 |
||
| Hamilton = |
| Hamilton = 209300 |
||
| Hamilton Zone = |
| Hamilton Zone = 176900 |
||
| Cambridge Zone = |
| Cambridge Zone = 16950 |
||
| Te Awamutu Zone = |
| Te Awamutu Zone = 15550 |
||
| Tauranga = |
| Tauranga = 122200 |
||
| Rotorua = |
| Rotorua = 56100 |
||
| Gisborne = |
| Gisborne = 34400 |
||
| Napier-Hastings = |
| Napier-Hastings = 125000 |
||
| Napier Zone = |
| Napier Zone = 58800 |
||
| Hastings Zone = |
| Hastings Zone = 66200 |
||
| New Plymouth = |
| New Plymouth = 53000 |
||
| Wanganui = |
| Wanganui = 39500 |
||
| Palmerston North = |
| Palmerston North = 83300 |
||
| Kapiti = |
| Kapiti = 40300 |
||
| Wellington = |
| Wellington = 395600 |
||
| Upper Hutt Zone = |
| Upper Hutt Zone = 39300 |
||
| Lower Hutt Zone = |
| Lower Hutt Zone = 102100 |
||
| Porirua Zone = |
| Porirua Zone = 52900 |
||
| Wellington Zone = |
| Wellington Zone = 201300 |
||
| Nelson = |
| Nelson = 61100 |
||
| Christchurch = |
| Christchurch = 375900 |
||
| Dunedin = |
| Dunedin = 118400 |
||
| Invercargill = |
| Invercargill = 49000 |
||
| Pukekohe = |
| Pukekohe = 26600 |
||
| Tokoroa = |
| Tokoroa = 13300 |
||
| Taupo = |
| Taupo = 22800 |
||
| Whakatane = |
| Whakatane = 18750 |
||
| Hawera = |
| Hawera = 11050 |
||
| Feilding = |
| Feilding = 14600 |
||
| Levin = |
| Levin = 19600 |
||
| Masterton = |
| Masterton = 20300 |
||
| Blenheim = |
| Blenheim = 30500 |
||
| Greymouth = |
| Greymouth = 10050 |
||
| Ashburton = |
| Ashburton = 18300 |
||
| Timaru = |
| Timaru = 27800 |
||
| Oamaru = |
| Oamaru = 13050 |
||
| Gore = |
| Gore = 9700 |
||
| Taipa Bay-Mangonui = 1640 |
|||
| Kaitaia = 5460 |
|||
| Kerikeri = 6670 |
|||
| Russell = 790 |
|||
| Paihia = 1690 |
|||
| Kawakawa = 1330 |
|||
| Moerewa = 1530 |
|||
| Kaikohe = 4260 |
|||
| Dargaville = 4490 |
|||
| Wellsford = 1720 |
|||
| Warkworth = 3940 |
|||
| Snells Beach = 4170 |
|||
| Helensville = 2830 |
|||
| Waiheke Island = 8800 |
|||
| Waiuku = 8810 |
|||
| Raglan = 2890 |
|||
| Huntly = 7010 |
|||
| Otorohanga = 2560 |
|||
| Te Kuiti = 4610 |
|||
| Taumarunui = 4870 |
|||
| Whitianga = 4310 |
|||
| Coromandel = 1530 |
|||
| Whangamata = 3590 |
|||
| Tairua = 1220 |
|||
| Thames = 6780 |
|||
| Waihi Beach = 1840 |
|||
| Paeroa = 4200 |
|||
| Waihi = 4660 |
|||
| Te Aroha = 3870 |
|||
| Morrinsville = 6970 |
|||
| Matamata = 7020 |
|||
| Putaruru = 3760 |
|||
| Katikati Community = 4210 |
|||
| Te Puke Community = 7510 |
|||
| Mangakino = 970 |
|||
| Turangi = 3200 |
|||
| Edgecumbe = 1650 |
|||
| Kawerau = 6910 |
|||
| Murupara = 1900 |
|||
| Opotiki = 4100 |
|||
| Wairoa = 4180 |
|||
| Waipawa = 2040 |
|||
| Waipukurau = 4070 |
|||
| Dannevirke = 5480 |
|||
| Woodville = 1350 |
|||
| Waitara = 6440 |
|||
| Inglewood = 3300 |
|||
| Stratford = 5580 |
|||
| Opunake = 1300 |
|||
| Eltham = 1990 |
|||
| Manaia = 950 |
|||
| Patea = 1090 |
|||
| Ohakune = 1070 |
|||
| Raetihi = 1080 |
|||
| Waiouru = 1140 |
|||
| Bulls = 1660 |
|||
| Taihape = 1740 |
|||
| Marton = 4650 |
|||
| Foxton Community = 4490 |
|||
| Shannon = 1300 |
|||
| Otaki = 5680 |
|||
| Pahiatua = 2450 |
|||
| Carterton = 4400 |
|||
| Greytown = 2140 |
|||
| Featherston = 2370 |
|||
| Martinborough = 1440 |
|||
| Picton = 4200 |
|||
| Kaikoura = 2150 |
|||
| Takaka = 1240 |
|||
| Brightwater = 2040 |
|||
| Wakefield = 2200 |
|||
| Motueka = 7880 |
|||
| Westport = 4170 |
|||
| Reefton = 990 |
|||
| Hokitika = 3500 |
|||
| Hanmer Springs = 840 |
|||
| Woodend = 2790 |
|||
| Rangiora = 14650 |
|||
| Oxford = 1890 |
|||
| Darfield = 1790 |
|||
| Lincoln = 3270 |
|||
| Leeston = 1400 |
|||
| Pleasant Point = 1270 |
|||
| Geraldine = 2340 |
|||
| Temuka = 4080 |
|||
| Twizel Community = 1080 |
|||
| Waimate = 2950 |
|||
| Milton = 1930 |
|||
| Balclutha = 3970 |
|||
| Alexandra = 4950 |
|||
| Cromwell = 4330 |
|||
| Wanaka = 7080 |
|||
| Arrowtown = 2460 |
|||
| Queenstown = 11750 |
|||
| Winton = 2150 |
|||
| Bluff = 1810 |
|||
| Te Anau = 1980 |
|||
| Riverton = 1490 |
|||
| Rolleston = 9150 |
|||
<!-- Table A: Pre-Auckland Council ---> |
<!-- Table A: Pre-Auckland Council ---> |
||
| Auckland Region old = 1,459,700 |
| Auckland Region old = 1,459,700 |
||
Line 144: | Line 243: | ||
| Papakura District = 49,800 |
| Papakura District = 49,800 |
||
| Franklin District = 65,200 |
| Franklin District = 65,200 |
||
}}}}{{if||{{{3|{{{showtitle|}}}}}}|{{if||{{{2|{{{showpopulation|}}}}}}| }}{{{5|{{{titlepre|}}}}}}June 2012 estimate{{{6|{{{titlepost|}}}}}}}}{{if||{{{4|{{{showref|}}}}}}|<ref name="NZ_population_data">{{cite web |url=http://www.stats.govt.nz/browse_for_stats/population/estimates_and_projections/subnational-pop-estimates-tables.aspx |title=Subnational population estimates at 30 June 2012|date=23 October 2012 |publisher=[[Statistics New Zealand]] |accessdate=23 October 2012}}</ref>}}{{if||{{{7|{{{aucklandref|}}}}}}|<ref name="Auckland_population_data">{{cite web|url=http://www.stats.govt.nz/~/media/Statistics/Methods%20and%20Services/Tables/Subnational%20population%20estimates/subnational-pop-estimate-jun2006-10.ashx|title=Subnational population estimates at 30 June 2010 (boundaries at 30 June 2010) |date=26 October 2010|publisher=Statistics New Zealand|accessdate=26 October 2010}}</ref>}}<noinclude>{{Documentation}}[[Category:New Zealand templates|Population data]][[Category:Data templates|New Zealand]]</noinclude> |
}}}}{{if||{{{3|{{{showtitle|}}}}}}|{{if||{{{2|{{{showpopulation|}}}}}}| }}{{{5|{{{titlepre|}}}}}}June 2012 estimate{{{6|{{{titlepost|}}}}}}}}{{if||{{{4|{{{showref|}}}}}}|<ref name="NZ_population_data">{{cite web |url=http://www.stats.govt.nz/browse_for_stats/population/estimates_and_projections/subnational-pop-estimates-tables.aspx |title=Subnational population estimates at 30 June 2012|date=23 October 2012 |publisher=[[Statistics New Zealand]] |accessdate=23 October 2012}} Also {{cite web |url=http://www.stats.govt.nz/infoshare/SelectVariables.aspx?pxID=2f5a6aa2-7aeb-4792-a34a-d5567eb8082f |title=Infoshare; Group: Population Estimates - DPE; Table: Estimated Resident Population for Urban Areas, at 30 June (1996+) (Annual-Jun) |date=19 December 2012 |publisher=[[Statistics New Zealand]] |accessdate=23 October 2012}}</ref>}}{{if||{{{7|{{{aucklandref|}}}}}}|<ref name="Auckland_population_data">{{cite web|url=http://www.stats.govt.nz/~/media/Statistics/Methods%20and%20Services/Tables/Subnational%20population%20estimates/subnational-pop-estimate-jun2006-10.ashx|title=Subnational population estimates at 30 June 2010 (boundaries at 30 June 2010) |date=26 October 2010|publisher=Statistics New Zealand|accessdate=26 October 2010}}</ref>}}<noinclude>{{Documentation}}[[Category:New Zealand templates|Population data]][[Category:Data templates|New Zealand]]</noinclude> |
Revision as of 11:08, 19 December 2012
Usage
This template is to supply uniform, up-to-date population data to New Zealand articles. It facilitates a mass update of all the population numbers in articles.
It is used for dynamically-changing populations. Populations on a specific date should not use this template, but should instead be hard-coded manually into the article.
This template uses the New Zealand Standard Areas Classification 1992 (NZSAC92). For the newer Statistical Standard for Geographic Areas 2018 (SSGA18), use {{NZ population data 2018}}. This template is "macron-sensitive", i.e. it will only look up a value if the spelling is exactly as specified (with or without a macron). As a workaround, all places that have recently received a macron have been duplicated in this template and that means that there is always the correct spelling available for a lookup to work.
Adding to an article
{{NZ population data|Example city|y|y|y}}
The template has seven parameters:
- area = Statistics NZ name of area for population (e.g. Lower Hutt City). This parameter is mandatory if showpopulation is used. List of names here
- showpopulation = display the population figure
- showtitle = display the title (e.g. "June 2008")
- showref = display the reference, can subsequently be reused by adding: <ref name="NZ_population_data"/>
- titlepre = free text before the title, for example to add parentheses
- titlepost = free text after the title
Leaving a show parameter empty results in that value being hidden.
The template data uses formatted text numbers, with the comma thousands separator, which is suitable for the majority of uses. For the numerical value, for example to use in {{Infobox Settlement}}, use the formula: {{formatnum:{{NZ population data| ##Example city## |y}}|R}}
Automatically updating formulae
- Population density: {{Decimals|{{formatnum:{{NZ population data| ##Example city## |y}}|R}}/ ##numerical land area## |1}}
- Percent of national population: {{Decimals|{{formatnum:{{NZ population data| ##Example city## |y}}|R}}/{{formatnum:{{NZ population data|New Zealand|y}}|R}}*100|1}}
Annual update
The data on this template needs to be updated once per year, as of 2016 Statistics NZ releases annual population estimates around 20 October.
- Download latest spreadsheet from Statistics New Zealand
- In a new spreadsheet, collect the data from all tables to get two columns, area name and most recent year data
- create a new column with formula =" | "&A1&" = "&TEXT(B1,"#,##0") for first entry, copy down entire column. The TEXT function makes sure that commas are kept in the numbers.
- copy & paste results into template
- update the name "June XXXX"
- update the reference
- verify Statistics NZ names are consistent with "Show changes", affected articles need the new name
- verify everything is ok by looking at a sample of pages. You may need to purge the cache on some articles by adding ?action=purge to the end of the URL for changes to show.
- List of cities in New Zealand and List of New Zealand urban areas need checks for rank changes, affected articles may need a minor reword