NPS-UD Data 2020Q3

URL: https://catalogue.data.govt.nz/dataset/282744c5-1b2f-4b63-9490-2a36601e535e/resource/a04ce979-62d3-4d85-b536-efb777695c00/download/all_dashboard_data_2020q3.zip

Data refresh for the NPS-Urban Development dashboard.

https://huddashboards.shinyapps.io/urban-development/

From “Pop_Consents.csv” “Name” = TA Name “Date” = Date for the representative date of data (month) in a Year-Month-Day format “New_Households” = the change in the Subnational population divided by the average household size. “Consents_lag_RA” = rolling average number of consents per month over a 12 month period, lagged by 6 months. This is derived from data supplied by Statistics New Zealand.

From “TA.csv” “NAME” = TA Name “Date” = Date for the representative date of data (month) in a Year-Month-Day format "Median_SP” = This indicator shows the median prices of residential dwellings sold in each quarter. This median price series is not adjusted for size and quality of dwellings. Prices are presented in nominal terms and they have not been adjusted for general price inflation. “Median_SP_Real” = Median Sale Price of residential dwellings sold in each quarter. This median price series is not adjusted for size and quality of dwellings and Prices are presented in inflation adjusted terms with a base period of the most current period. Note that when we remove the effects of inflation prices are higher in the past compared with unadjusted prices when viewed from today's prices. "Fisher_PI" = This indicator uses mean sales price but is presented as an index to show the percentage change relative to a common base year of 1993. This index is weighted by past and present sales volumes and is not composition adjusted. It is adjusted by location. "Quantity" = This is the quantity of all dwellings sold. The numerator in the Dwellings sales volume as a percentage of total residential stock indicator. The latest quarter of data is likely to be underestimated due to a lag between sales and data collection. "Stock” = This is the estimate of dwelling stock. The denominator in the Dwellings sales volume as a percentage of total residential stock indicator “Quantity_Stock” = This indicator measures the quantity of all dwellings being bought and sold relative to the total stock. It is a measure of activity in the local housing market. "spar_chained" = The Sales Price Appraisal Ratio (SPAR) provides an index of percentage change in dwelling sales prices relative to a common base year. It is constructed by comparing the sales price of each dwelling sold in a period with its valuation estimate. It adjusts for the composition and quality of the dwellings sold over each period. "spar_chained_land" = The Sales Price Appraisal Ratio (SPAR) provides an index of percentage change in dwelling sales prices relative to a common base year. It is constructed by comparing the implied land sales price of each dwelling sold in a period with its land valuation estimate. It adjusts for the composition and quality of the dwellings on the land sold over each period. "LV_CV_mean" = This indicator shows the share of house values that are accounted for by land prices at each valuation period. A higher ratio indicates that land is more valuable relative to the buildings that occupy it. "LV_mean” = This indicator shows the mean land prices at each valuation period. The mean is weighted by the number of dwellings in each component meshblock.
"Geomean_Rent" = This indicator reflects nominal mean rents as reported in new rental bonds lodged with MBIE. The mean used is a geometric mean. The reason for using this mean is that rents cluster around round numbers, and tend to plateau for months at a time (spiking up by say $10 or $20 at a time). This makes analysis of time series difficult and using the geometric mean is a way of removing this clustering effect. Prices are presented in nominal terms; they have not been adjusted for general price inflation. The data is for private bonds only and so excludes social housing. "Geomean_Rent_Real" = This indicator reflects real mean rents as reported in new rental bonds lodged with MBIE. The mean used is a geometric mean. The reason for using this mean is that rents cluster around round numbers, and tend to plateau for months at a time (spiking up by say $10 or $20 at a time). This makes analysis of time series difficult and using the geometric mean is a way of removing this clustering effect. Prices are presented in inflation adjusted terms with a base period of the most current period. The data is for private bonds only and so excludes social housing. "Rent_Fisher_PI" = This indicator uses mean lodged rents but is presented as an index to show the percentage change relative to a common base year of 1993. This index is weighted by past and present sales volumes and is quality adjusted using number of bedrooms. It is also adjusted by location. "Rent_ratio” = This ratio augments the price and rent indicators by providing about the relationship between owning and renting dwellings over time. It indicates changes in the ease of moving from renting to home ownership, and shows trends in investor yields. "HAM_Buy" = The Housing Affordability Measure (HAM) measures trends in housing affordability for the first home buyer household. This is the HAM Percent Buy, and is an estimate of how many renters would spend more than 30 percent of their income if they bought a lower quartile house with the same number of bedrooms as their current house, in the area that they currently live in. Affordability is affected by dwelling prices, mortgage interest rates and the incomes of rental households. A higher number on the chart indicates more households are below the average and a lower level of affordability. "HAM_Rent" = The Housing Affordability Measure (HAM) measures trends in housing affordability for the renting household. This is the Housing Percent Measure and identifies the proportion of renters in an area (region, territorial authority and Auckland wards) whose rent is more than 30 percent of their household income. A higher number indicates more households are below the 30 percent threshold and a lower level of affordability. Rent outputs are derived from rental bond data supplied by Tenancy Services. Property Sales, Dwelling Stock, Land Values are derived from the District Valuation Role data, which is supplied by CoreLogic.

From “ratio_out.csv” Column 1 is a row number count. “TA_Name” is the name of the TA. “Year” is the year. “PCR” is the Price-Cost Ratio: the Property Sale Price of over the Cost to Build the dwelling. The difference between the two inputs implies the value of the land. A ratio of 1.5 is considered healthy where the land value is 1/3 of that of the property. The Cost to Build is derived from residential consents. This is derived from data supplied by Statistics New Zealand, and District Valuation Role data which is supplied by CoreLogic.

There are no views created for this resource yet.

Additional Information

Field Value
Last updated October 14, 2020
Created 2020-08-12
Format .csv
License Creative Commons Attribution 3.0 New Zealand
Size 816490
Record created October 9, 2019, Last Updated October 14, 2020