Tuesday, May 10, 2016

City of Atlanta Budget, FY2017

The City of Atlanta recently released their proposed Fiscal Year 2017 budget. The city provides a 640-page document explaining the budget, as well as interactive data visuals in the Atlanta Budget Explorer (ABE). I was part of the team that created ABE in 2014 after we built a prototype in a city hackathon. To supplement the information in ABE this year I created the interactive visuals below to explore the 2017 proposed budget.

The first visual shows the 2017 budget by department, and the changes from the 2016 budget in both dollar amounts and as a percentage. The visual is interactive; click a department to view spending by office and account.

The data show the police department is the largest city department at $181.39 million, which is a $6.8 million increase from 2016, or 3.9%. However, if you click on the police services, you'll see that the budget for uniform patrol has dropped by 1.5% (closer to 3% in real terms, assuming inflation). The Account drill-down shows that total salaries for sworn officers is increasing by 2.1%, so the decline in uniform patrol spending does not indicate a decline in the total number of officers. The budget book (p. 75) confirms there is not a decline in staff. 

The largest increase in the police department is $6.29 million for "SSP Administration". Consulting the budget book (p. 351), I can see that "SSP" is the "Strategy and Special Projects Division". However, it is unclear to me whether the SSP increase is new spending, or just a re-organization of existing services (perhaps out of uniform patrol, explaining the decrease). This is a good example of the breadth and limitations of the budget data used to create the visuals. As one might expect, the budget data set does not have detailed department descriptions or narratives. Therefore, the budget book is a useful compliment. For more detail, you can attend the public hearing on May 12 or email the city council.

The next visual shows budget changes by department over time. This visual is also interactive by clicking a department.

This view shows which departments have been consistently growing, such as city council, whose budget rose from $6.37 million in 2013 to a proposed $12.71 million in 2017.

The last visual shows revenue, both the 2017 amounts and the multi-year changes.

Property tax is the largest source of city revenue, but the visual shows the city raises money in several different ways. Property tax revenue is projected to fall this year, despite the city's growth. This is because some of the city's new construction falls in Tax Allocation Districts and due to roll-backs from the Georgia Taxpayer Bill of Rights.

The visuals above only show budget and revenue from the city's general fund. Both ABE and the budget book have more details on other funds, such as special revenue.

Of course the budget data and budget book don't answer every question about the budget (and can't be expected to do so), but both the level of detail and the accessibility of the information are impressive.

Update: Councilman Alex Wan has a nice Youtube video encouraging engagement in the budget process.


  1. Thanks for sharing your awesome thought with us its really helpful for reader like me.
    showbox app
    showbox apk

  2. Oh such a well short and sweetly presented budget. I feel after India it's your budget that attracted me . You should perhaps be happy that India is welcoming businesses and see the uptrend of businesses being listed on b2b portals like IndiaBizClub?

  3. Daredevil season 3 is going to be extremely absorbing as the show runners might bring back Elektra.

  4. Atlanta is the important state of the American and the budget is very important for the people of Atlanta. Some previous year the budget is not effective but I prefer to join rushessay custom writing service because of the improper plan. But this year I can expect the good plan and good budget and it is looking good.

  5. Their bartenders are nice and friendly. We stayed till closing and weren't ushered out or anything. Definitely want to go to these Seattle venues again and see if their unlimited drinks brunch is worth it!

  6. This comment has been removed by the author.

    1. Lenders are apt to qualify you for as much as they are willing to lend, which can be more than you can really Mortgage Calculators afford. It’s up to you to take stock of your income and expenses, both current and projected, to determine what you can comfortably manage each month.

  7. I prefer the whole set of items, Thought about really enjoyed, I need more info . on this, considering that it is somewhat decent., Thanks a lot for the purpose of showing webstagram

  8. Excellent Blog , i appreciate your hardwork ,it is useful
    Tableau Online Course

  9. If power is interrupted, it may take up to 20 minutes for the arcs to re-strike – depending on the type Texas Led Lightings of metal halite lamp used. This is because the pressure inside the arc tubes may rise significantly, preventing the arcs from re-striking.

  10. This is exactly what I was looking for. Thanks for sharing this great article! That is very interesting Smile I love reading and I am always searching for informative information like this! Groupon Discount Code