Mountain Doodles

spare time data, analysis, visualization

Tax Density in Vancouver

| Comments

The other day I saw that Downtown brings in 23% of CoV tax revenue but only makes up 5% of the city area. Intrigued by that I decided to add a ‘Tax Density’ layer to my Vancouver Assessment Map. The idea was to try and understand the tax revenue generated by different areas in Vancouver. The data is already available in the CoV open data property dataset so it would only take half an hour to ad it to my map.

"Tax Density"

There has been a lot of discussion around density in Vancouver. One aspect of density is that it will generally increase the tax revenue that the city can collect per square metre. At the same time the city spending for services of the added density increases at a much lower rate. Leaving a net gain of revenue for the city. As property taxes are need-based, this means lower property taxes for everyone when density increases. In short, density leads to efficiency increases that materialize in form of lower property taxes for everyone.

That also points to one possible way to break some of the resistance to density increases that Vancouver currently sees. If a neighbourhood (or smaller region) accepts density increases, maybe some of the associated benefits of lower property taxes should be applied locally instead of everything being spread out over the entire city.

So what exactly does the Tax Density layer show?

The Tax Density I mapped is simply the amount of taxes collected per m². Under that measure, Downtown comes out at $127.1/m², followed by the West End at $72.7/m² and Fairview at $42.7/m². The Vancouver average is $20/m², only 6 of the 23 neighbourhoods have an above-average Tax Density. A complete list of Tax Density by neighbourhood is at the bottom.

For this calculation I did not count the parks doward the area of the neighbourhoods, but school for example are included. In light of this some of the aggregated data should be viewed with caution.

Where to go from here?

I also thought about mapping the density of housing units, but sadly the data in the CoV open data catalogue is ill-suited to do this. I can easily extract the number of tax entities and map the density of these. This works great for a traditional single family home (one tax entity) and for stratas (one tax entity per unit), but it becomes a problem because e.g. laneway houses and granny suites don’t show up as separate tax entities. And it gets really bad with rental apartments, where the whole building will be a single tax entity with potentially a very large number of units. And then the dataset does not distinguish between commercial and residential units. That data could be reverse engineered from the tax data, but that’s more work than my usual half hour tolerance level for this kind of side project.

Another option is to use census data and merge the datasets. But that gets messy, the aggregation levels don’t match and this is well beyond a side project time frame.

Similarly, it would be interesting to map the changes in tax density and the changes in unit density in Vancouver, but again the CoV dataset does hold the necessary information. In particular, when properties get a new tax coordinate (for example when they get re-developed) the CoV dataset drops the old tax data associated with that physical location. This makes it impossible to map the changes in tax density that redevelopment has brought.

Long story hort, if you are interested in browsing Vancouver by tax revenue collected per square meter, click through to the Vancouver Assessment Map and select the Tax Density layer.

Tax density by neighbourhood

  1. Downtown: $127.1/m²
  2. West End: $72.7/m²
  3. Fairview: $42.7/m²
  4. Kitsilano: $27.8/m²
  5. Downtown Eastside: $26.4/m²
  6. Mount Pleasant: $25.4/m²
  7. Arbutus Ridge: $17.5/m²
  8. Grandview-Woodland: $16.4/m²
  9. West Point Grey: $16.3/m²
  10. Dunbar Southlands: $15.0/m²
  11. Riley Park: $14.4/m²
  12. Oakridge: $13.8/m²
  13. Shaughnessy: $13.5/m²
  14. Kensington-Cedar Cottage: $12.8/m²
  15. Renfrew-Collingwood: $12.4/m²
  16. Strathcona: $12.2/m²
  17. Kerrisdale: $11.9/m²
  18. Marpole: $11.8/m²
  19. South Cambie: $11.7/m²
  20. Sunset: $11.2/m²
  21. Hastings-Sunrise: $10.6/m²
  22. Victoria-Fraserview: $10.0/m²
  23. Killarney: $7.7/m²

Comments