Data Update 2

 Lead

Vancouver's rate of New Building development has plummeted by nearly 90% since 2017, according to City of Vancouver data.   

Excel Workbook Link and Explanation 

The workbook includes the original raw data along with the slice that highlights the drastic decrease in issued building permits for New Buildings.  

    As mentioned previously in Data Update 1, the original dataset contains information on Building Permit Issuances in the City of Vancouver from 2017 to 2024.  I've primarily analyzed the Type of Work column which broadly categorizes the permits into six classifications: Addition/Alteration; Demolition/Deconstruction; New Building; Outdoor Uses (No Buildings Proposed); Salvage and Abatement; and Temporary Building/Structure. 

    The slice essentially features a pivot table that sums the number of projects within each permit category/"Type of Work" category from the years 2017 to 2024.  Next to the pivot table, I've included the percentage change calculations for each type of work. While all categories illustrate a decline in permit issuances, with some showing even greater declines than that of New Buildings, I chose to focus on the New Building category as I believe its relevance will resonate more strongly with a broader audience.  

Original Dataset Link 

The original dataset, Issued Building Permits, was found on City of Vancouver's Open Data Portal. 


Comments

  1. Lucas.SNovember 3, 2024 at 3:36 PM

    Hi Madi! I really enjoyed reading through your dataset; it is very informative and detailed. The only thing that I would suggest would be adding why that 90% number is important and its relevance to the plummeted building developments.

    ReplyDelete
  2. Andrew GauntleyNovember 3, 2024 at 9:00 PM

    Hi Madi, great job on your analysis. You have a succinct yet intirguing lead sentence, complimented by your good find in the data, 90% is quite mind-boggling. I noticed in your data slice that you have two ending columns, one for the values you found as a decimal and the other as a percentage. I couldn't see any other difference between the two, so just a reminder that you can switch the decimals to percentages without having to copy them, just to cut down on a column. Other than that, great job!

    ReplyDelete
  3. Sander OlafsenNovember 3, 2024 at 9:19 PM

    Hi Madi! Great work on the dataset update and slice. Your lead is clear and backed by your data splice. The 90% drop is fascinating and it would be interesting to see what factors have impacted the permit rate although I know that’s outside the scope of the assignment. Keep it up!

    ReplyDelete

Post a Comment

Popular posts from this blog

Data Update 1

What dataset will you use for your final report?  Issued Building Permits  Describe the dataset. What kind of data does it contain?       The 42,708 row dataset is for Building Permit Issuances in the City of Vancouver from 2017 onwards.  The building permits would be for instances such as construction, deconstruction, demolition, and development.  It contains information about application and permit approval timelines; the "Type of Work" the for building permit (e.g. demolitions, additions/alteration, new buildings, etc.); the "Property Use" on a macro scale (e.g. Culture/recreational, Dwelling, Institutional, etc.); the "Specific Use Category" of the building (e.g. Fitness centre, duplex w/ secondary suite, financial institution, etc.); and the building location information. Is there anything about your data that you don't understand? (i.e. what a column heading means). How will you find this out?       For the most part I un...
Read more

Legislation Hindering the Housing Crisis Solution

Since 2017, Vancouver's rate of issued New Building Permits has declined by nearly half.      City of Vancouver data reveals a significant decline in issued building permits across all categories.  New Building permits, in particular, have shown a downward trend of 47% since 2017. Given the city's current housing crisis, this raises the urgent question, "Why is Vancouver's rate of new building permit issuance declining in a time of need?"      As a population grows, it's essential for construction and development to grow in tandem.  This, however, is most definitely not the case in Vancouver.  The city's population growth is far outpacing new homes being built, creating immense pressure on renters and prospective home buyers struggling with unaffordability.  At a glance, one might assume that simply building more would resolve the affordability problem.  Though it would be nice if it were as simple as that, the reality is the core...
Read more