one of the many reasons local governments don't approve housing is that tax revenues from housing rapidly decay to 0 while services for the additional residents cost significantly more than 0
All new houses and transferred properties are taxed at the value they were purchased.
Unrelatedly, Brisbane found that they could raise 9 times as much revenue and provide 0 times as much additional services to residents by approving hotels instead of housing. https://brianlui.dog/2018/08/01/housing-shortages/#_edn4