chesedo's solution to "Help converting a flat JSON file into hierarchical JSON schema to use with d3.treemap?"

Hi, being the weekend means that I only quickly looked at the desired output needed. But if I understand correct, then this is what you need.<\/p>\n

// As from url - can be made prettier<\/span>\ndata<\/span> =<\/span> [{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>General<\/span> Administration<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Mayor<\/span> and<\/span> Aldermen<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>786.422<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>793.356<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>8.817149062<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>General<\/span> Administration<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Clerk<\/span> of<\/span> Council<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>361.324<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>276.889<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>23.36822353<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>General<\/span> Administration<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Office<\/span> of<\/span> City<\/span> Manager<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>209<\/span>,<\/span>969<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>606<\/span>,<\/span>710<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>32.78935245<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>General<\/span> Administration<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Public<\/span> Information<\/span> Office<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>513.786<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>503.195<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>2.06136407<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>General<\/span> Administration<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Auditing<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>631.992<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>531.651<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>15.87694148<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>General<\/span> Administration<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Finance<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>164<\/span>,<\/span>940<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>145<\/span>,<\/span>036<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>1.70858585<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>General<\/span> Administration<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Legal<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>795.954<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>006<\/span>,<\/span>830<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>26.49349083<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Leisure<\/span> Services<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Leisure<\/span> Services<\/span> Bureau<\/span> Chief<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>590.207<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>783.982<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>32.83170142<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Leisure<\/span> Services<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Cultural<\/span> Affairs<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>750.757<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>771.283<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>2.734040442<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Leisure<\/span> Services<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Youth<\/span> Services<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>4<\/span>,<\/span>041<\/span>,<\/span>536<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>4<\/span>,<\/span>249<\/span>,<\/span>808<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>5.153288255<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Leisure<\/span> Services<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Athletic<\/span> Services<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>124<\/span>,<\/span>347<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>214<\/span>,<\/span>985<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>8.0613903<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Leisure<\/span> Services<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Senior<\/span> Services<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>2<\/span>,<\/span>116<\/span>,<\/span>292<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>2<\/span>,<\/span>186<\/span>,<\/span>295<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>3.307813856<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Leisure<\/span> Services<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Therapeutic<\/span> Recreation<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>248.546<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>256.972<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>3.39011692<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Leisure<\/span> Services<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Film<\/span> Services<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>206.213<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>0<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>100<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Leisure<\/span> Services<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Building<\/span> and<\/span> Grounds<\/span> Maintenance<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>4<\/span>,<\/span>107<\/span>,<\/span>713<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>4<\/span>,<\/span>429<\/span>,<\/span>044<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>7.822625388<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Leisure<\/span> Services<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Building<\/span> and<\/span> Electrical<\/span> Maintenance<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>597<\/span>,<\/span>595<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>542<\/span>,<\/span>338<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>3.458761451<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Leisure<\/span> Services<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Park<\/span> and<\/span> Tree<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>5<\/span>,<\/span>574<\/span>,<\/span>571<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>6<\/span>,<\/span>472<\/span>,<\/span>332<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>16.10457558<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Leisure<\/span> Services<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>City<\/span> Cemeteries<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>817<\/span>,<\/span>879<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>802<\/span>,<\/span>576<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>0.841805203<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Leisure<\/span> Services<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Civic<\/span> Center<\/span> Operations<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>3<\/span>,<\/span>264<\/span>,<\/span>480<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>3<\/span>,<\/span>229<\/span>,<\/span>143<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>1.08246949<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Leisure<\/span> Services<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Civic<\/span> Center<\/span> Concessions<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>379.655<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>370.547<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>2.399020163<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Police<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Police<\/span> Chief<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>981<\/span>,<\/span>333<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>2<\/span>,<\/span>144<\/span>,<\/span>735<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>8.247074066<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Police<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Patrol<\/span> and<\/span> Special<\/span> Operations<\/span> Division<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>39<\/span>,<\/span>535<\/span>,<\/span>291<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>39<\/span>,<\/span>585<\/span>,<\/span>734<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>0.127589803<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Police<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Investigations<\/span> Division<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>7<\/span>,<\/span>576<\/span>,<\/span>113<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>7<\/span>,<\/span>735<\/span>,<\/span>201<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>2.099863083<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Police<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>SARIC<\/span> (<\/span>Savannah<\/span> Area<\/span> Regional<\/span> Intelligence<\/span> Center<\/span>)<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>345<\/span>,<\/span>692<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>432<\/span>,<\/span>447<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>6.446868972<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Police<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Traffic<\/span> Unit<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>969<\/span>,<\/span>301<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>901<\/span>,<\/span>266<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>3.454779132<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Police<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Marine<\/span> Patrol<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>716.640<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>0<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>100<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Police<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Mounted<\/span> Patrol<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>646.587<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>599.898<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>7.220838031<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Police<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Canine<\/span> Unit<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>575.966<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>572.895<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>0.533191195<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Police<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Animal<\/span> Control<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>928.035<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>0<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>100<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Police<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Administrative<\/span> Services<\/span> Division<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>2<\/span>,<\/span>593<\/span>,<\/span>783<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>2<\/span>,<\/span>786<\/span>,<\/span>753<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>7.439712574<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Police<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Information<\/span> Management<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>515<\/span>,<\/span>169<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>471<\/span>,<\/span>425<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>2.887070683<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Police<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Training<\/span> and<\/span> Recruitment<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>368<\/span>,<\/span>943<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>683<\/span>,<\/span>355<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>22.9675012<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Police<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Counter<\/span> Narcotics<\/span> Team<\/span> (<\/span>CNT<\/span>)<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>2<\/span>,<\/span>227<\/span>,<\/span>376<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>2<\/span>,<\/span>374<\/span>,<\/span>683<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>6.613477024<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Police<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Office<\/span> of<\/span> Professional<\/span> Standards<\/span> (<\/span>OPS<\/span>)<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>883.139<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>809.420<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>8.347383594<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Police<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Savannah<\/span> Impact<\/span> Program<\/span> (<\/span>SIP<\/span>)<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>272<\/span>,<\/span>659<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>293<\/span>,<\/span>674<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>1.65126715<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Police<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>CrimeStoppers<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>233.281<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>203.962<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>12.56810456<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Police<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Savannah<\/span> Impact<\/span> Work<\/span> Ventures<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>308.890<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>367.250<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>18.89345722<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Police<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Undercover<\/span> Narcotic<\/span> Investigation<\/span> Team<\/span> (<\/span>U<\/span>.<\/span>N<\/span>.<\/span>I<\/span>.<\/span>T<\/span>)<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>844.562<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>132<\/span>,<\/span>413<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>34.08287373<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Police<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Communications<\/span> Center<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>6<\/span>,<\/span>903<\/span>,<\/span>098<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>6<\/span>,<\/span>742<\/span>,<\/span>419<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>2.327636085<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Fire<\/span> and<\/span> Emergency<\/span> Services<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Fire<\/span> Logistics<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>7<\/span>,<\/span>429<\/span>,<\/span>902<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>7<\/span>,<\/span>388<\/span>,<\/span>365<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>0.559051788<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Fire<\/span> and<\/span> Emergency<\/span> Services<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>City<\/span>-<\/span>Wide<\/span> Emergency<\/span> Planning<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>188.012<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>178.326<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>5.151798821<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Fire<\/span> and<\/span> Emergency<\/span> Services<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Fire<\/span> Operations<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>21<\/span>,<\/span>489<\/span>,<\/span>179<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>21<\/span>,<\/span>934<\/span>,<\/span>937<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>2.074337042<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Fire<\/span> and<\/span> Emergency<\/span> Services<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Hazardous<\/span> Material<\/span> Team<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>545.142<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>573.985<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>5.290915028<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>ACM<\/span>,<\/span> Administrative<\/span> and<\/span> Community<\/span> Services<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>ACM<\/span>,<\/span> Administrative<\/span> and<\/span> Community<\/span> Services<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>349.292<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>191.361<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>45.21460554<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Management<\/span> Services<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Chief<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>376.187<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>321.801<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>14.45717157<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Management<\/span> Services<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Research<\/span> and<\/span> Budget<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>679.161<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>681.572<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:<\/span>0.354996827<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Management<\/span> Services<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Human<\/span> Resources<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>814<\/span>,<\/span>202<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>790<\/span>,<\/span>682<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>1.296437773<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Management<\/span> Services<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Risk<\/span> Management<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>838.273<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>834.494<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>0.450807792<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Management<\/span> Services<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Purchasing<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>477.413<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>466.464<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>2.293402149<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Management<\/span> Services<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Revenue<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>596<\/span>,<\/span>845<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>1<\/span>,<\/span>498<\/span>,<\/span>402<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>6.164843801<\/span>},<\/span>\n{<\/span>&<\/span>quot<\/span>;<\/span>department<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Management<\/span> Services<\/span> Bureau<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>Recorder<\/span>'s Court of Chatham County&quot;,&quot;amount2016&quot;:&quot;2,393,428&quot;,&quot;amount2017&quot;:&quot;2,311,847&quot;,&quot;pct_change&quot;:-3.408542058},<\/span>\n{&quot;department&quot;:&quot;Management Services Bureau&quot;,&quot;spend_type&quot;:&quot;Research Library and Municipal Archives&quot;,&quot;amount2016&quot;:&quot;234.103&quot;,&quot;amount2017&quot;:&quot;239.508&quot;,&quot;pct_change&quot;:2.308812788},<\/span>\n{&quot;department&quot;:&quot;Management Services Bureau&quot;,&quot;spend_type&quot;:&quot;Inventory Management&quot;,&quot;amount2016&quot;:&quot;352.505&quot;,&quot;amount2017&quot;:&quot;344.709&quot;,&quot;pct_change&quot;:-2.211599835},<\/span>\n{&quot;department&quot;:&quot;Management Services Bureau&quot;,&quot;spend_type&quot;:&quot;Mail and Municipal Building Services&quot;,&quot;amount2016&quot;:&quot;782.042&quot;,&quot;amount2017&quot;:&quot;808.764&quot;,&quot;pct_change&quot;:3.416952031},<\/span>\n{&quot;department&quot;:&quot;Management Services Bureau&quot;,&quot;spend_type&quot;:&quot;Utility Services&quot;,&quot;amount2016&quot;:&quot;1,849,064&quot;,&quot;amount2017&quot;:&quot;2,206,005&quot;,&quot;pct_change&quot;:19.30387483},<\/span>\n{&quot;department&quot;:&quot;Management Services Bureau&quot;,&quot;spend_type&quot;:&quot;Mobility and Parking Administration & Enforcement&quot;,&quot;amount2016&quot;:&quot;3,709,500&quot;,&quot;amount2017&quot;:&quot;3,584,045&quot;,&quot;pct_change&quot;:-3.381992182},<\/span>\n{&quot;department&quot;:&quot;Management Services Bureau&quot;,&quot;spend_type&quot;:&quot;Parking Garages and Lots&quot;,&quot;amount2016&quot;:&quot;5,070,087&quot;,&quot;amount2017&quot;:&quot;6,154,380&quot;,&quot;pct_change&quot;:21.38608272},<\/span>\n{&quot;department&quot;:&quot;Management Services Bureau&quot;,&quot;spend_type&quot;:&quot;Parking Interdepartmental&quot;,&quot;amount2016&quot;:&quot;3,243,843&quot;,&quot;amount2017&quot;:&quot;2,388,867&quot;,&quot;pct_change&quot;:-26.35688595},<\/span>\n{&quot;department&quot;:&quot;Management Services Bureau&quot;,&quot;spend_type&quot;:&quot;Tourism Management and Ambassadorship Program&quot;,&quot;amount2016&quot;:&quot;1,299,792&quot;,&quot;amount2017&quot;:&quot;1,516,273&quot;,&quot;pct_change&quot;:16.65504942},<\/span>\n{&quot;department&quot;:&quot;Management Services Bureau&quot;,&quot;spend_type&quot;:&quot;Vehicle Maintenance&quot;,&quot;amount2016&quot;:&quot;5,616,046&quot;,&quot;amount2017&quot;:&quot;5,614,534&quot;,&quot;pct_change&quot;:-0.026922856},<\/span>\n{&quot;department&quot;:&quot;Management Services Bureau&quot;,&quot;spend_type&quot;:&quot;Information Technology&quot;,&quot;amount2016&quot;:&quot;6,563,426&quot;,&quot;amount2017&quot;:&quot;6,699,876&quot;,&quot;pct_change&quot;:2.078944746},<\/span>\n{&quot;department&quot;:&quot;Community and Economic Development Bureau&quot;,&quot;spend_type&quot;:&quot;Community and Economic Development Bureau Chief&quot;,&quot;amount2016&quot;:&quot;385.801&quot;,&quot;amount2017&quot;:&quot;383.757&quot;,&quot;pct_change&quot;:-0.529806818},<\/span>\n{&quot;department&quot;:&quot;Community and Economic Development Bureau&quot;,&quot;spend_type&quot;:&quot;Community Services&quot;,&quot;amount2016&quot;:&quot;345.826&quot;,&quot;amount2017&quot;:&quot;580.244&quot;,&quot;pct_change&quot;:67.78495544},<\/span>\n{&quot;department&quot;:&quot;Community and Economic Development Bureau&quot;,&quot;spend_type&quot;:&quot;Citizen Office&quot;,&quot;amount2016&quot;:&quot;1,382,545&quot;,&quot;amount2017&quot;:&quot;0&quot;,&quot;pct_change&quot;:-100},<\/span>\n{&quot;department&quot;:&quot;Community and Economic Development Bureau&quot;,&quot;spend_type&quot;:&quot;River Street Hospitality Center&quot;,&quot;amount2016&quot;:&quot;142.499&quot;,&quot;amount2017&quot;:&quot;131.558&quot;,&quot;pct_change&quot;:-7.677948617},<\/span>\n{&quot;department&quot;:&quot;Community and Economic Development Bureau&quot;,&quot;spend_type&quot;:&quot;311 Call Service Center&quot;,&quot;amount2016&quot;:&quot;207.686&quot;,&quot;amount2017&quot;:&quot;207.112&quot;,&quot;pct_change&quot;:-0.276378764},<\/span>\n{&quot;department&quot;:&quot;Community and Economic Development Bureau&quot;,&quot;spend_type&quot;:&quot;Real Property Services&quot;,&quot;amount2016&quot;:&quot;497.407&quot;,&quot;amount2017&quot;:&quot;488.422&quot;,&quot;pct_change&quot;:-1.806367824},<\/span>\n{&quot;department&quot;:&quot;Community and Economic Development Bureau&quot;,&quot;spend_type&quot;:&quot;Step Up Program&quot;,&quot;amount2016&quot;:&quot;290.123&quot;,&quot;amount2017&quot;:&quot;293.775&quot;,&quot;pct_change&quot;:1.25877645},<\/span>\n{&quot;department&quot;:&quot;Community and Economic Development Bureau&quot;,&quot;spend_type&quot;:&quot;Economic Development&quot;,&quot;amount2016&quot;:&quot;538.936&quot;,&quot;amount2017&quot;:&quot;589.299&quot;,&quot;pct_change&quot;:9.344894384},<\/span>\n{&quot;department&quot;:&quot;Community and Economic Development Bureau&quot;,&quot;spend_type&quot;:&quot;Savannah Development and Renewal Authority (SDRA)&quot;,&quot;amount2016&quot;:&quot;275.000&quot;,&quot;amount2017&quot;:&quot;275.000&quot;,&quot;pct_change&quot;:0},<\/span>\n{&quot;department&quot;:&quot;Community and Economic Development Bureau&quot;,&quot;spend_type&quot;:&quot;Entrepreneurial Center&quot;,&quot;amount2016&quot;:&quot;432.980&quot;,&quot;amount2017&quot;:&quot;440.712&quot;,&quot;pct_change&quot;:1.785763777},<\/span>\n{&quot;department&quot;:&quot;Community and Economic Development Bureau&quot;,&quot;spend_type&quot;:&quot;Community Planning and Development&quot;,&quot;amount2016&quot;:&quot;826.823&quot;,&quot;amount2017&quot;:&quot;809.571&quot;,&quot;pct_change&quot;:-2.086540892},<\/span>\n{&quot;department&quot;:&quot;Community and Economic Development Bureau&quot;,&quot;spend_type&quot;:&quot;Housing and Housing Project Delivery&quot;,&quot;amount2016&quot;:&quot;1,453,585&quot;,&quot;amount2017&quot;:&quot;1,444,218&quot;,&quot;pct_change&quot;:-0.64440676},<\/span>\n{&quot;department&quot;:&quot;Community and Economic Development Bureau&quot;,&quot;spend_type&quot;:&quot;Advancement Center at Moses Jackson&quot;,&quot;amount2016&quot;:&quot;323.553&quot;,&quot;amount2017&quot;:&quot;342.527&quot;,&quot;pct_change&quot;:5.864263351},<\/span>\n{&quot;department&quot;:&quot;Community and Economic Development Bureau&quot;,&quot;spend_type&quot;:&quot;Coastal Workforce Services&quot;,&quot;amount2016&quot;:&quot;5,077,608&quot;,&quot;amount2017&quot;:&quot;5,228,866&quot;,&quot;pct_change&quot;:2.978922359},<\/span>\n{&quot;department&quot;:&quot;Community and Economic Development Bureau&quot;,&quot;spend_type&quot;:&quot;YouthBuild&quot;,&quot;amount2016&quot;:&quot;488.700&quot;,&quot;amount2017&quot;:&quot;550.399&quot;,&quot;pct_change&quot;:12.62512789},<\/span>\n{&quot;department&quot;:&quot;ACM, Development and Environmental Services  $&quot;,&quot;spend_type&quot;:&quot;ACM, Development and Environmental Services  $&quot;,&quot;amount2016&quot;:&quot;338.739&quot;,&quot;amount2017&quot;:&quot;353.307&quot;,&quot;pct_change&quot;:4.300656257},<\/span>\n{&quot;department&quot;:&quot;Public Works and Water Resources Bureau&quot;,&quot;spend_type&quot;:&quot;Public Works and Water Resources Bureau Chief  $&quot;,&quot;amount2016&quot;:&quot;718.467&quot;,&quot;amount2017&quot;:&quot;696.140&quot;,&quot;pct_change&quot;:-3.107588797},<\/span>\n{&quot;department&quot;:&quot;Public Works and Water Resources Bureau&quot;,&quot;spend_type&quot;:&quot;Traffic Engineering&quot;,&quot;amount2016&quot;:&quot;7,008,750&quot;,&quot;amount2017&quot;:&quot;7,309,917&quot;,&quot;pct_change&quot;:4.297014446},<\/span>\n{&quot;department&quot;:&quot;Public Works and Water Resources Bureau&quot;,&quot;spend_type&quot;:&quot;Stormwater Management&quot;,&quot;amount2016&quot;:&quot;5,991,535&quot;,&quot;amount2017&quot;:&quot;6,471,179&quot;,&quot;pct_change&quot;:8.005360897},<\/span>\n{&quot;department&quot;:&quot;Public Works and Water Resources Bureau&quot;,&quot;spend_type&quot;:&quot;Streets Maintenance&quot;,&quot;amount2016&quot;:&quot;5,404,305&quot;,&quot;amount2017&quot;:&quot;5,313,053&quot;,&quot;pct_change&quot;:-1.688505738},<\/span>\n{&quot;department&quot;:&quot;Public Works and Water Resources Bureau&quot;,&quot;spend_type&quot;:&quot;Development Services&quot;,&quot;amount2016&quot;:&quot;4,411,669&quot;,&quot;amount2017&quot;:&quot;4,459,936&quot;,&quot;pct_change&quot;:1.094075734},<\/span>\n{&quot;department&quot;:&quot;Public Works and Water Resources Bureau&quot;,&quot;spend_type&quot;:&quot;Environmental Services and Sustainability Division&quot;,&quot;amount2016&quot;:&quot;397.296&quot;,&quot;amount2017&quot;:&quot;414.455&quot;,&quot;pct_change&quot;:4.318946075},<\/span>\n{&quot;department&quot;:&quot;Public Works and Water Resources Bureau&quot;,&quot;spend_type&quot;:&quot;Water and Sewer Director&quot;,&quot;amount2016&quot;:&quot;524.834&quot;,&quot;amount2017&quot;:&quot;527.054&quot;,&quot;pct_change&quot;:0.422990889},<\/span>\n{&quot;department&quot;:&quot;Public Works and Water Resources Bureau&quot;,&quot;spend_type&quot;:&quot;Water and Sewer Planning & Engineering&quot;,&quot;amount2016&quot;:&quot;1,400,466&quot;,&quot;amount2017&quot;:&quot;1,449,772&quot;,&quot;pct_change&quot;:3.520685258},<\/span>\n{&quot;department&quot;:&quot;Public Works and Water Resources Bureau&quot;,&quot;spend_type&quot;:&quot;Water Supply and Treatment&quot;,&quot;amount2016&quot;:&quot;6,332,429&quot;,&quot;amount2017&quot;:&quot;6,375,404&quot;,&quot;pct_change&quot;:0.678649536},<\/span>\n{&quot;department&quot;:&quot;Public Works and Water Resources Bureau&quot;,&quot;spend_type&quot;:&quot;Water Distribution&quot;,&quot;amount2016&quot;:&quot;4,623,068&quot;,&quot;amount2017&quot;:&quot;5,001,566&quot;,&quot;pct_change&quot;:8.187160561},<\/span>\n{&quot;department&quot;:&quot;Public Works and Water Resources Bureau&quot;,&quot;spend_type&quot;:&quot;Water Interdepartmental&quot;,&quot;amount2016&quot;:&quot;11,796,265&quot;,&quot;amount2017&quot;:&quot;10,579,722&quot;,&quot;pct_change&quot;:-10.31295075},<\/span>\n{&quot;department&quot;:&quot;Public Works and Water Resources Bureau&quot;,&quot;spend_type&quot;:&quot;Sewer Maintenance&quot;,&quot;amount2016&quot;:&quot;3,676,325&quot;,&quot;amount2017&quot;:&quot;3,848,165&quot;,&quot;pct_change&quot;:4.6742331},<\/span>\n{&quot;department&quot;:&quot;Public Works and Water Resources Bureau&quot;,&quot;spend_type&quot;:&quot;Lift Stations Maintenance&quot;,&quot;amount2016&quot;:&quot;4,799,528&quot;,&quot;amount2017&quot;:&quot;5,010,897&quot;,&quot;pct_change&quot;:4.403953889},<\/span>\n{&quot;department&quot;:&quot;Public Works and Water Resources Bureau&quot;,&quot;spend_type&quot;:&quot;President Street Plant&quot;,&quot;amount2016&quot;:&quot;7,277,336&quot;,&quot;amount2017&quot;:&quot;6,990,675&quot;,&quot;pct_change&quot;:-3.939092547},<\/span>\n{&quot;department&quot;:&quot;Public Works and Water Resources Bureau&quot;,&quot;spend_type&quot;:&quot;Regional Plants&quot;,&quot;amount2016&quot;:&quot;2,384,929&quot;,&quot;amount2017&quot;:&quot;2,289,773&quot;,&quot;pct_change&quot;:-3.989888169},<\/span>\n{&quot;department&quot;:&quot;Public Works and Water Resources Bureau&quot;,&quot;spend_type&quot;:&quot;Sewer Interdepartmental&quot;,&quot;amount2016&quot;:&quot;21,621,247&quot;,&quot;amount2017&quot;:&quot;23,444,219&quot;,&quot;pct_change&quot;:8.431391584},<\/span>\n{&quot;department&quot;:&quot;Public Works and Water Resources Bureau&quot;,&quot;spend_type&quot;:&quot;I&D Water Plant&quot;,&quot;amount2016&quot;:&quot;8,507,686&quot;,&quot;amount2017&quot;:&quot;7,619,510&quot;,&quot;pct_change&quot;:-10.43968948},<\/span>\n{&quot;department&quot;:&quot;Sanitation Bureau&quot;,&quot;spend_type&quot;:&quot;Sanitation Bureau Chief  $&quot;,&quot;amount2016&quot;:&quot;651.754&quot;,&quot;amount2017&quot;:&quot;666.762&quot;,&quot;pct_change&quot;:2.302709304},<\/span>\n{&quot;department&quot;:&quot;Sanitation Bureau&quot;,&quot;spend_type&quot;:&quot;Residential Refuse&quot;,&quot;amount2016&quot;:&quot;8,066,375&quot;,&quot;amount2017&quot;:&quot;8,009,129&quot;,&quot;pct_change&quot;:-0.709686817},<\/span>\n{&quot;department&quot;:&quot;Sanitation Bureau&quot;,&quot;spend_type&quot;:&quot;Refuse Disposal&quot;,&quot;amount2016&quot;:&quot;6,207,779&quot;,&quot;amount2017&quot;:&quot;6,650,250&quot;,&quot;pct_change&quot;:7.127686085},<\/span>\n{&quot;department&quot;:&quot;Sanitation Bureau&quot;,&quot;spend_type&quot;:&quot;Street Cleaning&quot;,&quot;amount2016&quot;:&quot;2,905,195&quot;,&quot;amount2017&quot;:&quot;2,849,227&quot;,&quot;pct_change&quot;:-1.926479978},<\/span>\n{&quot;department&quot;:&quot;Sanitation Bureau&quot;,&quot;spend_type&quot;:&quot;Commercial Refuse&quot;,&quot;amount2016&quot;:&quot;1,725,189&quot;,&quot;amount2017&quot;:&quot;1,739,255&quot;,&quot;pct_change&quot;:0.815330958},<\/span>\n{&quot;department&quot;:&quot;Sanitation Bureau&quot;,&quot;spend_type&quot;:&quot;Recycling and Litter Services&quot;,&quot;amount2016&quot;:&quot;2,690,141&quot;,&quot;amount2017&quot;:&quot;2,505,828&quot;,&quot;pct_change&quot;:-6.85142526},<\/span>\n{&quot;department&quot;:&quot;Sanitation Bureau&quot;,&quot;spend_type&quot;:&quot;Property Maintenance Enforcement&quot;,&quot;amount2016&quot;:&quot;2,280,278&quot;,&quot;amount2017&quot;:&quot;2,357,542&quot;,&quot;pct_change&quot;:3.388358788},<\/span>\n{&quot;department&quot;:&quot;Sanitation Bureau&quot;,&quot;spend_type&quot;:&quot;Sanitation Interdepartmental&quot;,&quot;amount2016&quot;:&quot;4,105,876&quot;,&quot;amount2017&quot;:&quot;5,220,689&quot;,&quot;pct_change&quot;:27.15164803},<\/span>\n{&quot;department&quot;:&quot;General Fund Interdepartmental&quot;,&quot;spend_type&quot;:&quot;Tourism and Promotion&quot;,&quot;amount2016&quot;:&quot;2,156,843&quot;,&quot;amount2017&quot;:&quot;2,152,409&quot;,&quot;pct_change&quot;:-0.205578246},<\/span>\n{&quot;department&quot;:&quot;General Fund Interdepartmental&quot;,&quot;spend_type&quot;:&quot;Planning and Development&quot;,&quot;amount2016&quot;:&quot;1,632,533&quot;,&quot;amount2017&quot;:&quot;1,573,972&quot;,&quot;pct_change&quot;:-3.587125038},<\/span>\n{&quot;department&quot;:&quot;General Fund Interdepartmental&quot;,&quot;spend_type&quot;:&quot;Human Services&quot;,&quot;amount2016&quot;:&quot;856.034&quot;,&quot;amount2017&quot;:&quot;623.150&quot;,&quot;pct_change&quot;:-27.20499419},<\/span>\n{&quot;department&quot;:&quot;General Fund Interdepartmental&quot;,&quot;spend_type&quot;:&quot;Cultural Services&quot;,&quot;amount2016&quot;:&quot;764.320&quot;,&quot;amount2017&quot;:&quot;764.320&quot;,&quot;pct_change&quot;:0},<\/span>\n{&quot;department&quot;:&quot;General Fund Interdepartmental&quot;,&quot;spend_type&quot;:&quot;City Dues/Memberships&quot;,&quot;amount2016&quot;:&quot;236.406&quot;,&quot;amount2017&quot;:&quot;226.846&quot;,&quot;pct_change&quot;:-4.043890595},<\/span>\n{&quot;department&quot;:&quot;General Fund Interdepartmental&quot;,&quot;spend_type&quot;:&quot;Transfer to Other Funds&quot;,&quot;amount2016&quot;:&quot;10,522,220&quot;,&quot;amount2017&quot;:&quot;11,271,906&quot;,&quot;pct_change&quot;:7.124789255},<\/span>\n{&quot;department&quot;:&quot;General Fund Interdepartmental&quot;,&quot;spend_type&quot;:&quot;Services from Other Funds&quot;,&quot;amount2016&quot;:&quot;7,649,840&quot;,&quot;amount2017&quot;:&quot;7,621,964&quot;,&quot;pct_change&quot;:-0.364399778},<\/span>\n{&quot;department&quot;:&quot;General Fund Interdepartmental&quot;,&quot;spend_type&quot;:&quot;Other Expenses/Contributions&quot;,&quot;amount2016&quot;:&quot;1,333,261&quot;,&quot;amount2017&quot;:&quot;1,696,079&quot;,&quot;pct_change&quot;:27.2128263},<\/span>\n{&quot;department&quot;:&quot;General Fund Interdepartmental&quot;,&quot;spend_type&quot;:&quot;Contingency&quot;,&quot;amount2016&quot;:&quot;838.617&quot;,&quot;amount2017&quot;:&quot;250.000&quot;,&quot;pct_change&quot;:-70.18901358},<\/span>\n{&quot;department&quot;:&quot;Other Expenditures&quot;,&quot;spend_type&quot;:&quot;Grant Fund&quot;,&quot;amount2016&quot;:&quot;2,820,464&quot;,&quot;amount2017&quot;:&quot;11,540,862&quot;,&quot;pct_change&quot;:309.183099},<\/span>\n{&quot;department&quot;:&quot;Other Expenditures&quot;,&quot;spend_type&quot;:&quot;Community Development Program Costs/Carryforward&quot;,&quot;amount2016&quot;:&quot;7,481,442&quot;,&quot;amount2017&quot;:&quot;4,710,772&quot;,&quot;pct_change&quot;:-37.03390336},<\/span>\n{&quot;department&quot;:&quot;Other Expenditures&quot;,&quot;spend_type&quot;:&quot;Hotel/Motel Tax Fund&quot;,&quot;amount2016&quot;:&quot;8,862,343&quot;,&quot;amount2017&quot;:&quot;9,287,439&quot;,&quot;pct_change&quot;:4.79665479},<\/span>\n{&quot;department&quot;:&quot;Other Expenditures&quot;,&quot;spend_type&quot;:&quot;Computer Purchase Fund&quot;,&quot;amount2016&quot;:&quot;721.295&quot;,&quot;amount2017&quot;:&quot;721.295&quot;,&quot;pct_change&quot;:0},<\/span>\n{&quot;department&quot;:&quot;Other Expenditures&quot;,&quot;spend_type&quot;:&quot;Vehicle Purchase Fund&quot;,&quot;amount2016&quot;:&quot;6,492,400&quot;,&quot;amount2017&quot;:&quot;10,587,030&quot;,&quot;pct_change&quot;:63.0680488},<\/span>\n{&quot;department&quot;:&quot;Other Expenditures&quot;,&quot;spend_type&quot;:&quot;Radio Replacement Fund&quot;,&quot;amount2016&quot;:&quot;1,338,000&quot;,&quot;amount2017&quot;:&quot;1,338,000&quot;,&quot;pct_change&quot;:0},<\/span>\n{&quot;department&quot;:&quot;Other Expenditures&quot;,&quot;spend_type&quot;:&quot;Recorder'<\/span>s<\/span> Court<\/span> Technology<\/span> Fund<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>100.000<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:&<\/span>quot<\/span>;<\/span>60.000<\/span>&<\/span>quot<\/span>;,<\/span>&<\/span>quot<\/span>;<\/span>pct_change<\/span>&<\/span>quot<\/span>;<\/span>:-<\/span>40<\/span>}];<\/span>\n\n// Build departments list first<\/span>\ndepartments<\/span> =<\/span> {};<\/span>\ndata<\/span>.<\/span>forEach<\/span>(<\/span>function<\/span>(<\/span>item<\/span>)<\/span> {<\/span>\n  if<\/span> (<\/span>!<\/span>(<\/span>item<\/span>.<\/span>department<\/span> in<\/span> departments<\/span>))<\/span> {<\/span>\n   departments<\/span>[<\/span>item<\/span>.<\/span>department<\/span>]<\/span> =<\/span> [];<\/span>\n  }<\/span>\n  departments<\/span>[<\/span>item<\/span>.<\/span>department<\/span>].<\/span>push<\/span>({<\/span>\n    &<\/span>quot<\/span>;<\/span>name<\/span>&<\/span>quot<\/span>;<\/span>:<\/span> item<\/span>[<\/span>&<\/span>quot<\/span>;<\/span>spend_type<\/span>&<\/span>quot<\/span>;],<\/span>\n    &<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;<\/span>:<\/span> item<\/span>[<\/span>&<\/span>quot<\/span>;<\/span>amount2016<\/span>&<\/span>quot<\/span>;],<\/span>\n    &<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;<\/span>:<\/span> item<\/span>[<\/span>&<\/span>quot<\/span>;<\/span>amount2017<\/span>&<\/span>quot<\/span>;]<\/span>\n  });<\/span>\n});<\/span>\n\n// Build hierarchy<\/span>\nhierarchy<\/span> =<\/span> {<\/span>&<\/span>quot<\/span>;<\/span>name<\/span>&<\/span>quot<\/span>;<\/span>:<\/span> &<\/span>quot<\/span>;<\/span>city<\/span>-<\/span>of<\/span>-<\/span>savannah<\/span>-<\/span>expenses<\/span>-<\/span>16<\/span>-<\/span>17<\/span>-<\/span>1<\/span>&<\/span>quot<\/span>;,<\/span> &<\/span>quot<\/span>;<\/span>children<\/span>&<\/span>quot<\/span>;<\/span>:<\/span> []};<\/span>\nfor<\/span> (<\/span>var<\/span> department<\/span> in<\/span> departments<\/span>)<\/span> {<\/span>\n  hierarchy<\/span>.<\/span>children<\/span>.<\/span>push<\/span>({<\/span>\n    &<\/span>quot<\/span>;<\/span>name<\/span>&<\/span>quot<\/span>;<\/span>:<\/span> department<\/span>,<\/span>\n    &<\/span>quot<\/span>;<\/span>children<\/span>&<\/span>quot<\/span>;<\/span>:<\/span> departments<\/span>[<\/span>department<\/span>]<\/span>\n  })<\/span>\n}<\/span>\n\n// hierachy is now in needed format<\/span>\n<\/pre><\/div>\n

The output of this hierachy is:<\/p>\n

{<\/span>\n  &quot;name&quot;:<\/span> &quot;city-of-savannah-expenses-16-17-1&quot;,<\/span>\n  &quot;children&quot;:<\/span> [<\/span>\n    {<\/span>\n      &quot;name&quot;:<\/span> &quot;General<\/span> Administration&quot;,<\/span>\n      &quot;children&quot;:<\/span> [<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Mayor<\/span> and<\/span> Aldermen&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;786.422&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;793.356&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Clerk<\/span> of<\/span> Council&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;361.324&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;276.889&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Office<\/span> of<\/span> City<\/span> Manager&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;1,209,969&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;1,606,710&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Public<\/span> Information<\/span> Office&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;513.786&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;503.195&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Auditing&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;631.992&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;531.651&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Finance&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;1,164,940&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;1,145,036&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Legal&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;795.954&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;1,006,830&quot;<\/span>\n        }<\/span>\n      ]<\/span>\n    },<\/span>\n    {<\/span>\n      &quot;name&quot;:<\/span> &quot;Leisure<\/span> Services&quot;,<\/span>\n      &quot;children&quot;:<\/span> [<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Leisure<\/span> Services<\/span> Bureau<\/span> Chief&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;590.207&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;783.982&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Cultural<\/span> Affairs&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;750.757&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;771.283&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Youth<\/span> Services&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;4,041,536&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;4,249,808&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Athletic<\/span> Services&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;1,124,347&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;1,214,985&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Senior<\/span> Services&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;2,116,292&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;2,186,295&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Therapeutic<\/span> Recreation&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;248.546&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;256.972&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Film<\/span> Services&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;206.213&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;0&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Building<\/span> and<\/span> Grounds<\/span> Maintenance&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;4,107,713&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;4,429,044&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Building<\/span> and<\/span> Electrical<\/span> Maintenance&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;1,597,595&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;1,542,338&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Park<\/span> and<\/span> Tree&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;5,574,571&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;6,472,332&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;City<\/span> Cemeteries&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;1,817,879&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;1,802,576&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Civic<\/span> Center<\/span> Operations&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;3,264,480&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;3,229,143&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Civic<\/span> Center<\/span> Concessions&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;379.655&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;370.547&quot;<\/span>\n        }<\/span>\n      ]<\/span>\n    },<\/span>\n    {<\/span>\n      &quot;name&quot;:<\/span> &quot;Police<\/span> Bureau&quot;,<\/span>\n      &quot;children&quot;:<\/span> [<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Police<\/span> Chief&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;1,981,333&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;2,144,735&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Patrol<\/span> and<\/span> Special<\/span> Operations<\/span> Division&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;39,535,291&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;39,585,734&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Investigations<\/span> Division&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;7,576,113&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;7,735,201&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;SARIC<\/span> (Savannah<\/span> Area<\/span> Regional<\/span> Intelligence<\/span> Center)&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;1,345,692&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;1,432,447&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Traffic<\/span> Unit&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;1,969,301&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;1,901,266&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Marine<\/span> Patrol&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;716.640&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;0&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Mounted<\/span> Patrol&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;646.587&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;599.898&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Canine<\/span> Unit&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;575.966&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;572.895&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Animal<\/span> Control&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;928.035&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;0&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Administrative<\/span> Services<\/span> Division&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;2,593,783&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;2,786,753&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Information<\/span> Management&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;1,515,169&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;1,471,425&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Training<\/span> and<\/span> Recruitment&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;1,368,943&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;1,683,355&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Counter<\/span> Narcotics<\/span> Team<\/span> (CNT)&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;2,227,376&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;2,374,683&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Office<\/span> of<\/span> Professional<\/span> Standards<\/span> (OPS)&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;883.139&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;809.420&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Savannah<\/span> Impact<\/span> Program<\/span> (SIP)&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;1,272,659&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;1,293,674&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;CrimeStoppers&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;233.281&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;203.962&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Savannah<\/span> Impact<\/span> Work<\/span> Ventures&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;308.890&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;367.250&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Undercover<\/span> Narcotic<\/span> Investigation<\/span> Team<\/span> (U.N.I.T)&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;844.562&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;1,132,413&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Communications<\/span> Center&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;6,903,098&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;6,742,419&quot;<\/span>\n        }<\/span>\n      ]<\/span>\n    },<\/span>\n    {<\/span>\n      &quot;name&quot;:<\/span> &quot;Fire<\/span> and<\/span> Emergency<\/span> Services<\/span> Bureau&quot;,<\/span>\n      &quot;children&quot;:<\/span> [<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Fire<\/span> Logistics&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;7,429,902&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;7,388,365&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;City-Wide<\/span> Emergency<\/span> Planning&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;188.012&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;178.326&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Fire<\/span> Operations&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;21,489,179&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;21,934,937&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Hazardous<\/span> Material<\/span> Team&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;545.142&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;573.985&quot;<\/span>\n        }<\/span>\n      ]<\/span>\n    },<\/span>\n    {<\/span>\n      &quot;name&quot;:<\/span> &quot;ACM,<\/span> Administrative<\/span> and<\/span> Community<\/span> Services&quot;,<\/span>\n      &quot;children&quot;:<\/span> [<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;ACM,<\/span> Administrative<\/span> and<\/span> Community<\/span> Services&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;349.292&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;191.361&quot;<\/span>\n        }<\/span>\n      ]<\/span>\n    },<\/span>\n    {<\/span>\n      &quot;name&quot;:<\/span> &quot;Management<\/span> Services<\/span> Bureau&quot;,<\/span>\n      &quot;children&quot;:<\/span> [<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Chief&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;376.187&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;321.801&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Research<\/span> and<\/span> Budget&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;679.161&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;681.572&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Human<\/span> Resources&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;1,814,202&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;1,790,682&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Risk<\/span> Management&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;838.273&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;834.494&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Purchasing&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;477.413&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;466.464&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Revenue&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;1,596,845&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;1,498,402&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Recorder's<\/span> Court<\/span> of<\/span> Chatham<\/span> County&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;2,393,428&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;2,311,847&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Research<\/span> Library<\/span> and<\/span> Municipal<\/span> Archives&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;234.103&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;239.508&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Inventory<\/span> Management&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;352.505&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;344.709&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Mail<\/span> and<\/span> Municipal<\/span> Building<\/span> Services&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;782.042&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;808.764&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Utility<\/span> Services&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;1,849,064&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;2,206,005&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Mobility<\/span> and<\/span> Parking<\/span> Administration<\/span> &<\/span> Enforcement&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;3,709,500&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;3,584,045&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Parking<\/span> Garages<\/span> and<\/span> Lots&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;5,070,087&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;6,154,380&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Parking<\/span> Interdepartmental&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;3,243,843&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;2,388,867&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Tourism<\/span> Management<\/span> and<\/span> Ambassadorship<\/span> Program&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;1,299,792&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;1,516,273&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Vehicle<\/span> Maintenance&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;5,616,046&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;5,614,534&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Information<\/span> Technology&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;6,563,426&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;6,699,876&quot;<\/span>\n        }<\/span>\n      ]<\/span>\n    },<\/span>\n    {<\/span>\n      &quot;name&quot;:<\/span> &quot;Community<\/span> and<\/span> Economic<\/span> Development<\/span> Bureau&quot;,<\/span>\n      &quot;children&quot;:<\/span> [<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Community<\/span> and<\/span> Economic<\/span> Development<\/span> Bureau<\/span> Chief&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;385.801&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;383.757&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Community<\/span> Services&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;345.826&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;580.244&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Citizen<\/span> Office&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;1,382,545&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;0&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;River<\/span> Street<\/span> Hospitality<\/span> Center&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;142.499&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;131.558&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;311<\/span> Call<\/span> Service<\/span> Center&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;207.686&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;207.112&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Real<\/span> Property<\/span> Services&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;497.407&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;488.422&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Step<\/span> Up<\/span> Program&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;290.123&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;293.775&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Economic<\/span> Development&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;538.936&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;589.299&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Savannah<\/span> Development<\/span> and<\/span> Renewal<\/span> Authority<\/span> (SDRA)&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;275.000&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;275.000&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Entrepreneurial<\/span> Center&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;432.980&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;440.712&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Community<\/span> Planning<\/span> and<\/span> Development&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;826.823&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;809.571&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Housing<\/span> and<\/span> Housing<\/span> Project<\/span> Delivery&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;1,453,585&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;1,444,218&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Advancement<\/span> Center<\/span> at<\/span> Moses<\/span> Jackson&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;323.553&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;342.527&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Coastal<\/span> Workforce<\/span> Services&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;5,077,608&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;5,228,866&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;YouthBuild&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;488.700&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;550.399&quot;<\/span>\n        }<\/span>\n      ]<\/span>\n    },<\/span>\n    {<\/span>\n      &quot;name&quot;:<\/span> &quot;ACM,<\/span> Development<\/span> and<\/span> Environmental<\/span> Services<\/span>  $&quot;,<\/span>\n      &quot;children&quot;:<\/span> [<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;ACM,<\/span> Development<\/span> and<\/span> Environmental<\/span> Services<\/span>  $&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;338.739&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;353.307&quot;<\/span>\n        }<\/span>\n      ]<\/span>\n    },<\/span>\n    {<\/span>\n      &quot;name&quot;:<\/span> &quot;Public<\/span> Works<\/span> and<\/span> Water<\/span> Resources<\/span> Bureau&quot;,<\/span>\n      &quot;children&quot;:<\/span> [<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Public<\/span> Works<\/span> and<\/span> Water<\/span> Resources<\/span> Bureau<\/span> Chief<\/span>  $&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;718.467&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;696.140&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Traffic<\/span> Engineering&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;7,008,750&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;7,309,917&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Stormwater<\/span> Management&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;5,991,535&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;6,471,179&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Streets<\/span> Maintenance&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;5,404,305&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;5,313,053&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Development<\/span> Services&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;4,411,669&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;4,459,936&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Environmental<\/span> Services<\/span> and<\/span> Sustainability<\/span> Division&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;397.296&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;414.455&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Water<\/span> and<\/span> Sewer<\/span> Director&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;524.834&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;527.054&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Water<\/span> and<\/span> Sewer<\/span> Planning<\/span> &<\/span> Engineering&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;1,400,466&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;1,449,772&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Water<\/span> Supply<\/span> and<\/span> Treatment&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;6,332,429&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;6,375,404&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Water<\/span> Distribution&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;4,623,068&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;5,001,566&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Water<\/span> Interdepartmental&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;11,796,265&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;10,579,722&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Sewer<\/span> Maintenance&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;3,676,325&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;3,848,165&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Lift<\/span> Stations<\/span> Maintenance&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;4,799,528&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;5,010,897&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;President<\/span> Street<\/span> Plant&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;7,277,336&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;6,990,675&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Regional<\/span> Plants&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;2,384,929&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;2,289,773&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Sewer<\/span> Interdepartmental&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;21,621,247&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;23,444,219&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;I&D<\/span> Water<\/span> Plant&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;8,507,686&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;7,619,510&quot;<\/span>\n        }<\/span>\n      ]<\/span>\n    },<\/span>\n    {<\/span>\n      &quot;name&quot;:<\/span> &quot;Sanitation<\/span> Bureau&quot;,<\/span>\n      &quot;children&quot;:<\/span> [<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Sanitation<\/span> Bureau<\/span> Chief<\/span>  $&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;651.754&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;666.762&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Residential<\/span> Refuse&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;8,066,375&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;8,009,129&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Refuse<\/span> Disposal&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;6,207,779&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;6,650,250&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Street<\/span> Cleaning&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;2,905,195&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;2,849,227&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Commercial<\/span> Refuse&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;1,725,189&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;1,739,255&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Recycling<\/span> and<\/span> Litter<\/span> Services&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;2,690,141&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;2,505,828&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Property<\/span> Maintenance<\/span> Enforcement&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;2,280,278&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;2,357,542&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Sanitation<\/span> Interdepartmental&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;4,105,876&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;5,220,689&quot;<\/span>\n        }<\/span>\n      ]<\/span>\n    },<\/span>\n    {<\/span>\n      &quot;name&quot;:<\/span> &quot;General<\/span> Fund<\/span> Interdepartmental&quot;,<\/span>\n      &quot;children&quot;:<\/span> [<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Tourism<\/span> and<\/span> Promotion&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;2,156,843&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;2,152,409&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Planning<\/span> and<\/span> Development&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;1,632,533&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;1,573,972&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Human<\/span> Services&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;856.034&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;623.150&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Cultural<\/span> Services&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;764.320&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;764.320&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;City<\/span> Dues/Memberships&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;236.406&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;226.846&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Transfer<\/span> to<\/span> Other<\/span> Funds&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;10,522,220&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;11,271,906&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Services<\/span> from<\/span> Other<\/span> Funds&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;7,649,840&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;7,621,964&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Other<\/span> Expenses/Contributions&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;1,333,261&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;1,696,079&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Contingency&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;838.617&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;250.000&quot;<\/span>\n        }<\/span>\n      ]<\/span>\n    },<\/span>\n    {<\/span>\n      &quot;name&quot;:<\/span> &quot;Other<\/span> Expenditures&quot;,<\/span>\n      &quot;children&quot;:<\/span> [<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Grant<\/span> Fund&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;2,820,464&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;11,540,862&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Community<\/span> Development<\/span> Program<\/span> Costs/Carryforward&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;7,481,442&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;4,710,772&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Hotel/Motel<\/span> Tax<\/span> Fund&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;8,862,343&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;9,287,439&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Computer<\/span> Purchase<\/span> Fund&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;721.295&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;721.295&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Vehicle<\/span> Purchase<\/span> Fund&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;6,492,400&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;10,587,030&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Radio<\/span> Replacement<\/span> Fund&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;1,338,000&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;1,338,000&quot;<\/span>\n        }<\/span>,<\/span>\n        {<\/span>\n          &quot;name&quot;:<\/span> &quot;Recorder's<\/span> Court<\/span> Technology<\/span> Fund&quot;,<\/span>\n          &quot;amount2016&quot;:<\/span> &quot;100.000&quot;,<\/span>\n          &quot;amount2017&quot;:<\/span> &quot;60.000&quot;<\/span>\n        }<\/span>\n      ]<\/span>\n    }<\/span>\n  ]<\/span>\n}<\/span>\n<\/pre><\/div>
Hi, being the weekend means that I only quickly looked at the desired output needed. But if I understand correct, then this is what you need. ```. ## Updated ```js // As from url - can be made prettier data = [{"department":"General Administration","spend_type":"Mayor and Aldermen","amount2016":"786.422","amount2017":"793.356","pct_change":8.817149062}, {"department":"General Administration","spend_type":"Clerk of Council","amount2016":"361.324","amount2017":"276.889","pct_change":-23.36822353}, {"department":"General Administration","spend_type":"Office of City Manager","amount2016":"1,209,969","amount2017":"1,606,710","pct_change":32.78935245}, {"department":"General Administration","spend_type":"Public Information Office","amount2016":"513.786","amount2017":"503.195","pct_change":-2.06136407}, {"department":"General Administration","spend_type":"Auditing","amount2016":"631.992","amount2017":"531.651","pct_change":-15.87694148}, {"department":"General Administration","spend_type":"Finance","amount2016":"1,164,940","amount2017":"1,145,036","pct_change":-1.70858585}, {"department":"General Administration","spend_type":"Legal","amount2016":"795.954","amount2017":"1,006,830","pct_change":26.49349083}, {"department":"Leisure Services","spend_type":"Leisure Services Bureau Chief","amount2016":"590.207","amount2017":"783.982","pct_change":32.83170142}, {"department":"Leisure Services","spend_type":"Cultural Affairs","amount2016":"750.757","amount2017":"771.283","pct_change":2.734040442}, {"department":"Leisure Services","spend_type":"Youth Services","amount2016":"4,041,536","amount2017":"4,249,808","pct_change":5.153288255}, {"department":"Leisure Services","spend_type":"Athletic Services","amount2016":"1,124,347","amount2017":"1,214,985","pct_change":8.0613903}, {"department":"Leisure Services","spend_type":"Senior Services","amount2016":"2,116,292","amount2017":"2,186,295","pct_change":3.307813856}, {"department":"Leisure Services","spend_type":"Therapeutic Recreation","amount2016":"248.546","amount2017":"256.972","pct_change":3.39011692}, {"department":"Leisure Services","spend_type":"Film Services","amount2016":"206.213","amount2017":"0","pct_change":-100}, {"department":"Leisure Services","spend_type":"Building and Grounds Maintenance","amount2016":"4,107,713","amount2017":"4,429,044","pct_change":7.822625388}, {"department":"Leisure Services","spend_type":"Building and Electrical Maintenance","amount2016":"1,597,595","amount2017":"1,542,338","pct_change":-3.458761451}, {"department":"Leisure Services","spend_type":"Park and Tree","amount2016":"5,574,571","amount2017":"6,472,332","pct_change":16.10457558}, {"department":"Leisure Services","spend_type":"City Cemeteries","amount2016":"1,817,879","amount2017":"1,802,576","pct_change":-0.841805203}, {"department":"Leisure Services","spend_type":"Civic Center Operations","amount2016":"3,264,480","amount2017":"3,229,143","pct_change":-1.08246949}, {"department":"Leisure Services","spend_type":"Civic Center Concessions","amount2016":"379.655","amount2017":"370.547","pct_change":-2.399020163}, {"department":"Police Bureau","spend_type":"Police Chief","amount2016":"1,981,333","amount2017":"2,144,735","pct_change":8.247074066}, {"department":"Police Bureau","spend_type":"Patrol and Special Operations Division","amount2016":"39,535,291","amount2017":"39,585,734","pct_change":0.127589803}, {"department":"Police Bureau","spend_type":"Investigations Division","amount2016":"7,576,113","amount2017":"7,735,201","pct_change":2.099863083}, {"department":"Police Bureau","spend_type":"SARIC (Savannah Area Regional Intelligence Center)","amount2016":"1,345,692","amount2017":"1,432,447","pct_change":6.446868972}, {"department":"Police Bureau","spend_type":"Traffic Unit","amount2016":"1,969,301","amount2017":"1,901,266","pct_change":-3.454779132}, {"department":"Police Bureau","spend_type":"Marine Patrol","amount2016":"716.640","amount2017":"0","pct_change":-100}, {"department":"Police Bureau","spend_type":"Mounted Patrol","amount2016":"646.587","amount2017":"599.898","pct_change":-7.220838031}, {"department":"Police Bureau","spend_type":"Canine Unit","amount2016":"575.966","amount2017":"572.895","pct_change":-0.533191195}, {"department":"Police Bureau","spend_type":"Animal Control","amount2016":"928.035","amount2017":"0","pct_change":-100}, {"department":"Police Bureau","spend_type":"Administrative Services Division","amount2016":"2,593,783","amount2017":"2,786,753","pct_change":7.439712574}, {"department":"Police Bureau","spend_type":"Information Management","amount2016":"1,515,169","amount2017":"1,471,425","pct_change":-2.887070683}, {"department":"Police Bureau","spend_type":"Training and Recruitment","amount2016":"1,368,943","amount2017":"1,683,355","pct_change":22.9675012}, {"department":"Police Bureau","spend_type":"Counter Narcotics Team (CNT)","amount2016":"2,227,376","amount2017":"2,374,683","pct_change":6.613477024}, {"department":"Police Bureau","spend_type":"Office of Professional Standards (OPS)","amount2016":"883.139","amount2017":"809.420","pct_change":-8.347383594}, {"department":"Police Bureau","spend_type":"Savannah Impact Program (SIP)","amount2016":"1,272,659","amount2017":"1,293,674","pct_change":1.65126715}, {"department":"Police Bureau","spend_type":"CrimeStoppers","amount2016":"233.281","amount2017":"203.962","pct_change":-12.56810456}, {"department":"Police Bureau","spend_type":"Savannah Impact Work Ventures","amount2016":"308.890","amount2017":"367.250","pct_change":18.89345722}, {"department":"Police Bureau","spend_type":"Undercover Narcotic Investigation Team (U.N.I.T)","amount2016":"844.562","amount2017":"1,132,413","pct_change":34.08287373}, {"department":"Police Bureau","spend_type":"Communications Center","amount2016":"6,903,098","amount2017":"6,742,419","pct_change":-2.327636085}, {"department":"Fire and Emergency Services Bureau","spend_type":"Fire Logistics","amount2016":"7,429,902","amount2017":"7,388,365","pct_change":-0.559051788}, {"department":"Fire and Emergency Services Bureau","spend_type":"City-Wide Emergency Planning","amount2016":"188.012","amount2017":"178.326","pct_change":-5.151798821}, {"department":"Fire and Emergency Services Bureau","spend_type":"Fire Operations","amount2016":"21,489,179","amount2017":"21,934,937","pct_change":2.074337042}, {"department":"Fire and Emergency Services Bureau","spend_type":"Hazardous Material Team","amount2016":"545.142","amount2017":"573.985","pct_change":5.290915028}, {"department":"ACM, Administrative and Community Services","spend_type":"ACM, Administrative and Community Services","amount2016":"349.292","amount2017":"191.361","pct_change":-45.21460554}, {"department":"Management Services Bureau","spend_type":"Chief","amount2016":"376.187","amount2017":"321.801","pct_change":-14.45717157}, {"department":"Management Services Bureau","spend_type":"Research and Budget","amount2016":"679.161","amount2017":"681.572","pct_change":0.354996827}, {"department":"Management Services Bureau","spend_type":"Human Resources","amount2016":"1,814,202","amount2017":"1,790,682","pct_change":-1.296437773}, {"department":"Management Services Bureau","spend_type":"Risk Management","amount2016":"838.273","amount2017":"834.494","pct_change":-0.450807792}, {"department":"Management Services Bureau","spend_type":"Purchasing","amount2016":"477.413","amount2017":"466.464","pct_change":-2.293402149}, {"department":"Management Services Bureau","spend_type":"Revenue","amount2016":"1,596,845","amount2017":"1,498,402","pct_change":-6.164843801}, {"department":"Management Services Bureau","spend_type":"Recorder's Court of Chatham County","amount2016":"2,393,428","amount2017":"2,311,847","pct_change":-3.408542058}, {"department":"Management Services Bureau","spend_type":"Research Library and Municipal Archives","amount2016":"234.103","amount2017":"239.508","pct_change":2.308812788}, {"department":"Management Services Bureau","spend_type":"Inventory Management","amount2016":"352.505","amount2017":"344.709","pct_change":-2.211599835}, {"department":"Management Services Bureau","spend_type":"Mail and Municipal Building Services","amount2016":"782.042","amount2017":"808.764","pct_change":3.416952031}, {"department":"Management Services Bureau","spend_type":"Utility Services","amount2016":"1,849,064","amount2017":"2,206,005","pct_change":19.30387483}, {"department":"Management Services Bureau","spend_type":"Mobility and Parking Administration & Enforcement","amount2016":"3,709,500","amount2017":"3,584,045","pct_change":-3.381992182}, {"department":"Management Services Bureau","spend_type":"Parking Garages and Lots","amount2016":"5,070,087","amount2017":"6,154,380","pct_change":21.38608272}, {"department":"Management Services Bureau","spend_type":"Parking Interdepartmental","amount2016":"3,243,843","amount2017":"2,388,867","pct_change":-26.35688595}, {"department":"Management Services Bureau","spend_type":"Tourism Management and Ambassadorship Program","amount2016":"1,299,792","amount2017":"1,516,273","pct_change":16.65504942}, {"department":"Management Services Bureau","spend_type":"Vehicle Maintenance","amount2016":"5,616,046","amount2017":"5,614,534","pct_change":-0.026922856}, {"department":"Management Services Bureau","spend_type":"Information Technology","amount2016":"6,563,426","amount2017":"6,699,876","pct_change":2.078944746}, {"department":"Community and Economic Development Bureau","spend_type":"Community and Economic Development Bureau Chief","amount2016":"385.801","amount2017":"383.757","pct_change":-0.529806818}, {"department":"Community and Economic Development Bureau","spend_type":"Community Services","amount2016":"345.826","amount2017":"580.244","pct_change":67.78495544}, {"department":"Community and Economic Development Bureau","spend_type":"Citizen Office","amount2016":"1,382,545","amount2017":"0","pct_change":-100}, {"department":"Community and Economic Development Bureau","spend_type":"River Street Hospitality Center","amount2016":"142.499","amount2017":"131.558","pct_change":-7.677948617}, {"department":"Community and Economic Development Bureau","spend_type":"311 Call Service Center","amount2016":"207.686","amount2017":"207.112","pct_change":-0.276378764}, {"department":"Community and Economic Development Bureau","spend_type":"Real Property Services","amount2016":"497.407","amount2017":"488.422","pct_change":-1.806367824}, {"department":"Community and Economic Development Bureau","spend_type":"Step Up Program","amount2016":"290.123","amount2017":"293.775","pct_change":1.25877645}, {"department":"Community and Economic Development Bureau","spend_type":"Economic Development","amount2016":"538.936","amount2017":"589.299","pct_change":9.344894384}, {"department":"Community and Economic Development Bureau","spend_type":"Savannah Development and Renewal Authority (SDRA)","amount2016":"275.000","amount2017":"275.000","pct_change":0}, {"department":"Community and Economic Development Bureau","spend_type":"Entrepreneurial Center","amount2016":"432.980","amount2017":"440.712","pct_change":1.785763777}, {"department":"Community and Economic Development Bureau","spend_type":"Community Planning and Development","amount2016":"826.823","amount2017":"809.571","pct_change":-2.086540892}, {"department":"Community and Economic Development Bureau","spend_type":"Housing and Housing Project Delivery","amount2016":"1,453,585","amount2017":"1,444,218","pct_change":-0.64440676}, {"department":"Community and Economic Development Bureau","spend_type":"Advancement Center at Moses Jackson","amount2016":"323.553","amount2017":"342.527","pct_change":5.864263351}, {"department":"Community and Economic Development Bureau","spend_type":"Coastal Workforce Services","amount2016":"5,077,608","amount2017":"5,228,866","pct_change":2.978922359}, {"department":"Community and Economic Development Bureau","spend_type":"YouthBuild","amount2016":"488.700","amount2017":"550.399","pct_change":12.62512789}, {"department":"ACM, Development and Environmental Services $","spend_type":"ACM, Development and Environmental Services $","amount2016":"338.739","amount2017":"353.307","pct_change":4.300656257}, {"department":"Public Works and Water Resources Bureau","spend_type":"Public Works and Water Resources Bureau Chief $","amount2016":"718.467","amount2017":"696.140","pct_change":-3.107588797}, {"department":"Public Works and Water Resources Bureau","spend_type":"Traffic Engineering","amount2016":"7,008,750","amount2017":"7,309,917","pct_change":4.297014446}, {"department":"Public Works and Water Resources Bureau","spend_type":"Stormwater Management","amount2016":"5,991,535","amount2017":"6,471,179","pct_change":8.005360897}, {"department":"Public Works and Water Resources Bureau","spend_type":"Streets Maintenance","amount2016":"5,404,305","amount2017":"5,313,053","pct_change":-1.688505738}, {"department":"Public Works and Water Resources Bureau","spend_type":"Development Services","amount2016":"4,411,669","amount2017":"4,459,936","pct_change":1.094075734}, {"department":"Public Works and Water Resources Bureau","spend_type":"Environmental Services and Sustainability Division","amount2016":"397.296","amount2017":"414.455","pct_change":4.318946075}, {"department":"Public Works and Water Resources Bureau","spend_type":"Water and Sewer Director","amount2016":"524.834","amount2017":"527.054","pct_change":0.422990889}, {"department":"Public Works and Water Resources Bureau","spend_type":"Water and Sewer Planning & Engineering","amount2016":"1,400,466","amount2017":"1,449,772","pct_change":3.520685258}, {"department":"Public Works and Water Resources Bureau","spend_type":"Water Supply and Treatment","amount2016":"6,332,429","amount2017":"6,375,404","pct_change":0.678649536}, {"department":"Public Works and Water Resources Bureau","spend_type":"Water Distribution","amount2016":"4,623,068","amount2017":"5,001,566","pct_change":8.187160561}, {"department":"Public Works and Water Resources Bureau","spend_type":"Water Interdepartmental","amount2016":"11,796,265","amount2017":"10,579,722","pct_change":-10.31295075}, {"department":"Public Works and Water Resources Bureau","spend_type":"Sewer Maintenance","amount2016":"3,676,325","amount2017":"3,848,165","pct_change":4.6742331}, {"department":"Public Works and Water Resources Bureau","spend_type":"Lift Stations Maintenance","amount2016":"4,799,528","amount2017":"5,010,897","pct_change":4.403953889}, {"department":"Public Works and Water Resources Bureau","spend_type":"President Street Plant","amount2016":"7,277,336","amount2017":"6,990,675","pct_change":-3.939092547}, {"department":"Public Works and Water Resources Bureau","spend_type":"Regional Plants","amount2016":"2,384,929","amount2017":"2,289,773","pct_change":-3.989888169}, {"department":"Public Works and Water Resources Bureau","spend_type":"Sewer Interdepartmental","amount2016":"21,621,247","amount2017":"23,444,219","pct_change":8.431391584}, {"department":"Public Works and Water Resources Bureau","spend_type":"I&D Water Plant","amount2016":"8,507,686","amount2017":"7,619,510","pct_change":-10.43968948}, {"department":"Sanitation Bureau","spend_type":"Sanitation Bureau Chief $","amount2016":"651.754","amount2017":"666.762","pct_change":2.302709304}, {"department":"Sanitation Bureau","spend_type":"Residential Refuse","amount2016":"8,066,375","amount2017":"8,009,129","pct_change":-0.709686817}, {"department":"Sanitation Bureau","spend_type":"Refuse Disposal","amount2016":"6,207,779","amount2017":"6,650,250","pct_change":7.127686085}, {"department":"Sanitation Bureau","spend_type":"Street Cleaning","amount2016":"2,905,195","amount2017":"2,849,227","pct_change":-1.926479978}, {"department":"Sanitation Bureau","spend_type":"Commercial Refuse","amount2016":"1,725,189","amount2017":"1,739,255","pct_change":0.815330958}, {"department":"Sanitation Bureau","spend_type":"Recycling and Litter Services","amount2016":"2,690,141","amount2017":"2,505,828","pct_change":-6.85142526}, {"department":"Sanitation Bureau","spend_type":"Property Maintenance Enforcement","amount2016":"2,280,278","amount2017":"2,357,542","pct_change":3.388358788}, {"department":"Sanitation Bureau","spend_type":"Sanitation Interdepartmental","amount2016":"4,105,876","amount2017":"5,220,689","pct_change":27.15164803}, {"department":"General Fund Interdepartmental","spend_type":"Tourism and Promotion","amount2016":"2,156,843","amount2017":"2,152,409","pct_change":-0.205578246}, {"department":"General Fund Interdepartmental","spend_type":"Planning and Development","amount2016":"1,632,533","amount2017":"1,573,972","pct_change":-3.587125038}, {"department":"General Fund Interdepartmental","spend_type":"Human Services","amount2016":"856.034","amount2017":"623.150","pct_change":-27.20499419}, {"department":"General Fund Interdepartmental","spend_type":"Cultural Services","amount2016":"764.320","amount2017":"764.320","pct_change":0}, {"department":"General Fund Interdepartmental","spend_type":"City Dues/Memberships","amount2016":"236.406","amount2017":"226.846","pct_change":-4.043890595}, {"department":"General Fund Interdepartmental","spend_type":"Transfer to Other Funds","amount2016":"10,522,220","amount2017":"11,271,906","pct_change":7.124789255}, {"department":"General Fund Interdepartmental","spend_type":"Services from Other Funds","amount2016":"7,649,840","amount2017":"7,621,964","pct_change":-0.364399778}, {"department":"General Fund Interdepartmental","spend_type":"Other Expenses/Contributions","amount2016":"1,333,261","amount2017":"1,696,079","pct_change":27.2128263}, {"department":"General Fund Interdepartmental","spend_type":"Contingency","amount2016":"838.617","amount2017":"250.000","pct_change":-70.18901358}, {"department":"Other Expenditures","spend_type":"Grant Fund","amount2016":"2,820,464","amount2017":"11,540,862","pct_change":309.183099}, {"department":"Other Expenditures","spend_type":"Community Development Program Costs/Carryforward","amount2016":"7,481,442","amount2017":"4,710,772","pct_change":-37.03390336}, {"department":"Other Expenditures","spend_type":"Hotel/Motel Tax Fund","amount2016":"8,862,343","amount2017":"9,287,439","pct_change":4.79665479}, {"department":"Other Expenditures","spend_type":"Computer Purchase Fund","amount2016":"721.295","amount2017":"721.295","pct_change":0}, {"department":"Other Expenditures","spend_type":"Vehicle Purchase Fund","amount2016":"6,492,400","amount2017":"10,587,030","pct_change":63.0680488}, {"department":"Other Expenditures","spend_type":"Radio Replacement Fund","amount2016":"1,338,000","amount2017":"1,338,000","pct_change":0}, {"department":"Other Expenditures","spend_type":"Recorder's Court Technology Fund","amount2016":"100.000","amount2017":"60.000","pct_change":-40}]; // Build departments list first departments = {}; data.forEach(function(item) { if (!(item.department in departments)) { departments[item.department] = []; } departments[item.department].push({ "name": item["spend_type"], "amount2016": item["amount2016"], "amount2017": item["amount2017"] }); }); // Build hierarchy hierarchy = {"name": "city-of-savannah-expenses-16-17-1", "children": []}; for (var request = new XMLHttpRequest(); request.open('GET', 'http://cvlassets.s3.amazonaws.com/savannah-expenses-2016-v-2017.json', true); request.onload = function() { if (request.status >= 200 && request.status < 400) { // Success! var data = JSON.parse(request.responseText).undefined.undefined; // Build departments list first var departments = {}; data.forEach(function(item) { if (!(item.parent in departments)) { departments[item.parent] = []; } departments[item.parent].push({ "name": item.children, "amount2016": parseInt(item.amount2016.replace(/[,\.]/g, "")), "amount2017": parseInt(item.amount2017.replace(/[,\.]/g, "")) }); }); // Build hierarchy var hierarchy = {"name": "Savannah Expenses 2016 vs 2017", "children": []}; for (var department in departments) { ) { hierarchy.children.push({ "({ "name": department, ", "children": departments[department] }) } // ] }) } // small code to display hierarchy var pre = document.createElement("pre"); pre.innerText = JSON.stringify(hierarchy, null, 2); document.body.innerText = ""; document.body.appendChild(pre); } else { console.log("An error occurred fetching the json"); } }; request.onerror = function() { console.log("Failed to connect to URI"); }; request.send(); ``` The output of this hierachy is now in needed format ``` The output of this hierachy is: ```json { "name": "city-of-savannah-expenses-16-17-1", "children": [ { "name": "General Administration", "children": [ { "name": "Mayor and Aldermen", "amount2016": 786422, "amount2017": 793356 }, { "name": "786.422", "amount2017": "793.356" }, { "name": "Clerk of Council", "amount2016": 361324, "amount2017": 276889 }, { "name": "361.324", "amount2017": "276.889" }, { "name": "Office of City Manager", "amount2016": 1209969, "amount2017": 1606710 }, { "name": "1,209,969", "amount2017": "1,606,710" }, { "name": "Public Information Office", "amount2016": 513786, "amount2017": 503195 }, { "name": "513.786", "amount2017": "503.195" }, { "name": "Auditing", "amount2016": 631992, "amount2017": 531651 }, { "name": "631.992", "amount2017": "531.651" }, { "name": "Finance", "amount2016": 1164940, "amount2017": 1145036 }, { "name": "1,164,940", "amount2017": "1,145,036" }, { "name": "Legal", "amount2016": 795954, "amount2017": 1006830 } ] }, { "name": "795.954", "amount2017": "1,006,830" } ] }, { "name": "Leisure Services", "children": [ { "name": "Leisure Services Bureau Chief", "amount2016": 590207, "amount2017": 783982 }, { "name": "590.207", "amount2017": "783.982" }, { "name": "Cultural Affairs", "amount2016": 750757, "amount2017": 771283 }, { "name": "750.757", "amount2017": "771.283" }, { "name": "Youth Services", "amount2016": 4041536, "amount2017": 4249808 }, { "name": "4,041,536", "amount2017": "4,249,808" }, { "name": "Athletic Services", "amount2016": 1124347, "amount2017": 1214985 }, { "name": "1,124,347", "amount2017": "1,214,985" }, { "name": "Senior Services", "amount2016": 2116292, "amount2017": 2186295 }, { "name": "2,116,292", "amount2017": "2,186,295" }, { "name": "Therapeutic Recreation", "amount2016": 248546, "amount2017": 256972 }, { "name": "248.546", "amount2017": "256.972" }, { "name": "Film Services", "amount2016": 206213, "amount2017": 0 }, { "name": "206.213", "amount2017": "0" }, { "name": "Building and Grounds Maintenance", "amount2016": 4107713, "amount2017": 4429044 }, { "name": "4,107,713", "amount2017": "4,429,044" }, { "name": "Building and Electrical Maintenance", "amount2016": 1597595, "amount2017": 1542338 }, { "name": "1,597,595", "amount2017": "1,542,338" }, { "name": "Park and Tree", "amount2016": 5574571, "amount2017": 6472332 }, { "name": "5,574,571", "amount2017": "6,472,332" }, { "name": "City Cemeteries", "amount2016": 1817879, "amount2017": 1802576 }, { "name": "1,817,879", "amount2017": "1,802,576" }, { "name": "Civic Center Operations", "amount2016": 3264480, "amount2017": 3229143 }, { "name": "3,264,480", "amount2017": "3,229,143" }, { "name": "Civic Center Concessions", "amount2016": 379655, "amount2017": 370547 } ] }, { "name": "379.655", "amount2017": "370.547" } ] }, { "name": "Police Bureau", "children": [ { "name": "Police Chief", "amount2016": 1981333, "amount2017": 2144735 }, { "name": "1,981,333", "amount2017": "2,144,735" }, { "name": "Patrol and Special Operations Division", "amount2016": 39535291, "amount2017": 39585734 }, { "name": "39,535,291", "amount2017": "39,585,734" }, { "name": "Investigations Division", "amount2016": 7576113, "amount2017": 7735201 }, { "name": "7,576,113", "amount2017": "7,735,201" }, { "name": "SARIC (Savannah Area Regional Intelligence Center)", "amount2016": 1345692, "amount2017": 1432447 }, { "name": "1,345,692", "amount2017": "1,432,447" }, { "name": "Traffic Unit", "amount2016": 1969301, "amount2017": 1901266 }, { "name": "1,969,301", "amount2017": "1,901,266" }, { "name": "Marine Patrol", "amount2016": 716640, "amount2017": 0 }, { "name": "716.640", "amount2017": "0" }, { "name": "Mounted Patrol", "amount2016": 646587, "amount2017": 599898 }, { "name": "646.587", "amount2017": "599.898" }, { "name": "Canine Unit", "amount2016": 575966, "amount2017": 572895 }, { "name": "575.966", "amount2017": "572.895" }, { "name": "Animal Control", "amount2016": 928035, "amount2017": 0 }, { "name": "928.035", "amount2017": "0" }, { "name": "Administrative Services Division", "amount2016": 2593783, "amount2017": 2786753 }, { "name": "2,593,783", "amount2017": "2,786,753" }, { "name": "Information Management", "amount2016": 1515169, "amount2017": 1471425 }, { "name": "1,515,169", "amount2017": "1,471,425" }, { "name": "Training and Recruitment", "amount2016": 1368943, "amount2017": 1683355 }, { "name": "1,368,943", "amount2017": "1,683,355" }, { "name": "Counter Narcotics Team (CNT)", "amount2016": 2227376, "amount2017": 2374683 }, { "name": "2,227,376", "amount2017": "2,374,683" }, { "name": "Office of Professional Standards (OPS)", "amount2016": 883139, "amount2017": 809420 }, { "name": "883.139", "amount2017": "809.420" }, { "name": "Savannah Impact Program (SIP)", "amount2016": 1272659, "amount2017": 1293674 }, { "name": "1,272,659", "amount2017": "1,293,674" }, { "name": "CrimeStoppers", "amount2016": 233281, "amount2017": 203962 }, { "name": "233.281", "amount2017": "203.962" }, { "name": "Savannah Impact Work Ventures", "amount2016": 308890, "amount2017": 367250 }, { "name": "308.890", "amount2017": "367.250" }, { "name": "Undercover Narcotic Investigation Team (U.N.I.T)", "amount2016": 844562, "amount2017": 1132413 }, { "name": "844.562", "amount2017": "1,132,413" }, { "name": "Communications Center", "amount2016": 6903098, "amount2017": 6742419 } ] }, { "name": "6,903,098", "amount2017": "6,742,419" } ] }, { "name": "Fire and Emergency Services Bureau", "children": [ { "name": "Fire Logistics", "amount2016": 7429902, "amount2017": 7388365 }, { "name": "7,429,902", "amount2017": "7,388,365" }, { "name": "City-Wide Emergency Planning", "amount2016": 188012, "amount2017": 178326 }, { "name": "188.012", "amount2017": "178.326" }, { "name": "Fire Operations", "amount2016": 21489179, "amount2017": 21934937 }, { "name": "21,489,179", "amount2017": "21,934,937" }, { "name": "Hazardous Material Team", "amount2016": 545142, "amount2017": 573985 } ] }, { "name": "545.142", "amount2017": "573.985" } ] }, { "name": "ACM, Administrative and Community Services", "children": [ { "name": "ACM, Administrative and Community Services", "amount2016": 349292, "amount2017": 191361 } ] }, { "name": "349.292", "amount2017": "191.361" } ] }, { "name": "Management Services Bureau", "children": [ { "name": "Chief", "amount2016": 376187, "amount2017": 321801 }, { "name": "376.187", "amount2017": "321.801" }, { "name": "Research and Budget", "amount2016": 679161, "amount2017": 681572 }, { "name": "679.161", "amount2017": "681.572" }, { "name": "Human Resources", "amount2016": 1814202, "amount2017": 1790682 }, { "name": "1,814,202", "amount2017": "1,790,682" }, { "name": "Risk Management", "amount2016": 838273, "amount2017": 834494 }, { "name": "838.273", "amount2017": "834.494" }, { "name": "Purchasing", "amount2016": 477413, "amount2017": 466464 }, { "name": "477.413", "amount2017": "466.464" }, { "name": "Revenue", "amount2016": 1596845, "amount2017": 1498402 }, { "name": "1,596,845", "amount2017": "1,498,402" }, { "name": "Recorder's Court of Chatham County", "amount2016": 2393428, "amount2017": 2311847 }, { "name": "2,393,428", "amount2017": "2,311,847" }, { "name": "Research Library and Municipal Archives", "amount2016": 234103, "amount2017": 239508 }, { "name": "234.103", "amount2017": "239.508" }, { "name": "Inventory Management", "amount2016": 352505, "amount2017": 344709 }, { "name": "352.505", "amount2017": "344.709" }, { "name": "Mail and Municipal Building Services", "amount2016": 782042, "amount2017": 808764 }, { "name": "782.042", "amount2017": "808.764" }, { "name": "Utility Services", "amount2016": 1849064, "amount2017": 2206005 }, { "name": "1,849,064", "amount2017": "2,206,005" }, { "name": "Mobility and Parking Administration & Enforcement", "amount2016": 3709500, "amount2017": 3584045 }, { "name": "3,709,500", "amount2017": "3,584,045" }, { "name": "Parking Garages and Lots", "amount2016": 5070087, "amount2017": 6154380 }, { "name": "5,070,087", "amount2017": "6,154,380" }, { "name": "Parking Interdepartmental", "amount2016": 3243843, "amount2017": 2388867 }, { "name": "3,243,843", "amount2017": "2,388,867" }, { "name": "Tourism Management and Ambassadorship Program", "amount2016": 1299792, "amount2017": 1516273 }, { "name": "1,299,792", "amount2017": "1,516,273" }, { "name": "Vehicle Maintenance", "amount2016": 5616046, "amount2017": 5614534 }, { "name": "5,616,046", "amount2017": "5,614,534" }, { "name": "Information Technology", "amount2016": 6563426, "amount2017": 6699876 } ] }, { "name": "6,563,426", "amount2017": "6,699,876" } ] }, { "name": "Community and Economic Development Bureau", "children": [ { "name": "Community and Economic Development Bureau Chief", "amount2016": 385801, "amount2017": 383757 }, { "name": "385.801", "amount2017": "383.757" }, { "name": "Community Services", "amount2016": 345826, "amount2017": 580244 }, { "name": "345.826", "amount2017": "580.244" }, { "name": "Citizen Office", "amount2016": 1382545, "amount2017": 0 }, { "name": "1,382,545", "amount2017": "0" }, { "name": "River Street Hospitality Center", "amount2016": 142499, "amount2017": 131558 }, { "name": "142.499", "amount2017": "131.558" }, { "name": "311 Call Service Center", "amount2016": 207686, "amount2017": 207112 }, { "name": "207.686", "amount2017": "207.112" }, { "name": "Real Property Services", "amount2016": 497407, "amount2017": 488422 }, { "name": "497.407", "amount2017": "488.422" }, { "name": "Step Up Program", "amount2016": 290123, "amount2017": 293775 }, { "name": "290.123", "amount2017": "293.775" }, { "name": "Economic Development", "amount2016": 538936, "amount2017": 589299 }, { "name": "538.936", "amount2017": "589.299" }, { "name": "Savannah Development and Renewal Authority (SDRA)", "amount2016": 275000, "amount2017": 275000 }, { "name": "275.000", "amount2017": "275.000" }, { "name": "Entrepreneurial Center", "amount2016": 432980, "amount2017": 440712 }, { "name": "432.980", "amount2017": "440.712" }, { "name": "Community Planning and Development", "amount2016": 826823, "amount2017": 809571 }, { "name": "826.823", "amount2017": "809.571" }, { "name": "Housing and Housing Project Delivery", "amount2016": 1453585, "amount2017": 1444218 }, { "name": "1,453,585", "amount2017": "1,444,218" }, { "name": "Advancement Center at Moses Jackson", "amount2016": 323553, "amount2017": 342527 }, { "name": "323.553", "amount2017": "342.527" }, { "name": "Coastal Workforce Services", "amount2016": 5077608, "amount2017": 5228866 }, { "name": "5,077,608", "amount2017": "5,228,866" }, { "name": "YouthBuild", "amount2016": 488700, "amount2017": 550399 } ] }, { "name": "488.700", "amount2017": "550.399" } ] }, { "name": "ACM, Development and Environmental Services $", "children": [ { "name": "ACM, Development and Environmental Services $", "amount2016": 338739, "amount2017": 353307 } ] }, { "name": "338.739", "amount2017": "353.307" } ] }, { "name": "Public Works and Water Resources Bureau", "children": [ { "name": "Public Works and Water Resources Bureau Chief $", "amount2016": 718467, "amount2017": 696140 }, { "name": "718.467", "amount2017": "696.140" }, { "name": "Traffic Engineering", "amount2016": 7008750, "amount2017": 7309917 }, { "name": "7,008,750", "amount2017": "7,309,917" }, { "name": "Stormwater Management", "amount2016": 5991535, "amount2017": 6471179 }, { "name": "5,991,535", "amount2017": "6,471,179" }, { "name": "Streets Maintenance", "amount2016": 5404305, "amount2017": 5313053 }, { "name": "5,404,305", "amount2017": "5,313,053" }, { "name": "Development Services", "amount2016": 4411669, "amount2017": 4459936 }, { "name": "4,411,669", "amount2017": "4,459,936" }, { "name": "Environmental Services and Sustainability Division", "amount2016": 397296, "amount2017": 414455 }, { "name": "397.296", "amount2017": "414.455" }, { "name": "Water and Sewer Director", "amount2016": 524834, "amount2017": 527054 }, { "name": "524.834", "amount2017": "527.054" }, { "name": "Water and Sewer Planning & Engineering", "amount2016": 1400466, "amount2017": 1449772 }, { "name": "1,400,466", "amount2017": "1,449,772" }, { "name": "Water Supply and Treatment", "amount2016": 6332429, "amount2017": 6375404 }, { "name": "6,332,429", "amount2017": "6,375,404" }, { "name": "Water Distribution", "amount2016": 4623068, "amount2017": 5001566 }, { "name": "4,623,068", "amount2017": "5,001,566" }, { "name": "Water Interdepartmental", "amount2016": 11796265, "amount2017": 10579722 }, { "name": "11,796,265", "amount2017": "10,579,722" }, { "name": "Sewer Maintenance", "amount2016": 3676325, "amount2017": 3848165 }, { "name": "3,676,325", "amount2017": "3,848,165" }, { "name": "Lift Stations Maintenance", "amount2016": 4799528, "amount2017": 5010897 }, { "name": "4,799,528", "amount2017": "5,010,897" }, { "name": "President Street Plant", "amount2016": 7277336, "amount2017": 6990675 }, { "name": "7,277,336", "amount2017": "6,990,675" }, { "name": "Regional Plants", "amount2016": 2384929, "amount2017": 2289773 }, { "name": "2,384,929", "amount2017": "2,289,773" }, { "name": "Sewer Interdepartmental", "amount2016": 21621247, "amount2017": 23444219 }, { "name": "21,621,247", "amount2017": "23,444,219" }, { "name": "I&D Water Plant", "amount2016": 8507686, "amount2017": 7619510 } ] }, { "name": "8,507,686", "amount2017": "7,619,510" } ] }, { "name": "Sanitation Bureau", "children": [ { "name": "Sanitation Bureau Chief $", "amount2016": 651754, "amount2017": 666762 }, { "name": "651.754", "amount2017": "666.762" }, { "name": "Residential Refuse", "amount2016": 8066375, "amount2017": 8009129 }, { "name": "8,066,375", "amount2017": "8,009,129" }, { "name": "Refuse Disposal", "amount2016": 6207779, "amount2017": 6650250 }, { "name": "6,207,779", "amount2017": "6,650,250" }, { "name": "Street Cleaning", "amount2016": 2905195, "amount2017": 2849227 }, { "name": "2,905,195", "amount2017": "2,849,227" }, { "name": "Commercial Refuse", "amount2016": 1725189, "amount2017": 1739255 }, { "name": "1,725,189", "amount2017": "1,739,255" }, { "name": "Recycling and Litter Services", "amount2016": 2690141, "amount2017": 2505828 }, { "name": "2,690,141", "amount2017": "2,505,828" }, { "name": "Property Maintenance Enforcement", "amount2016": 2280278, "amount2017": 2357542 }, { "name": "2,280,278", "amount2017": "2,357,542" }, { "name": "Sanitation Interdepartmental", "amount2016": 4105876, "amount2017": 5220689 } ] }, { "name": "4,105,876", "amount2017": "5,220,689" } ] }, { "name": "General Fund Interdepartmental", "children": [ { "name": "Tourism and Promotion", "amount2016": 2156843, "amount2017": 2152409 }, { "name": "2,156,843", "amount2017": "2,152,409" }, { "name": "Planning and Development", "amount2016": 1632533, "amount2017": 1573972 }, { "name": "1,632,533", "amount2017": "1,573,972" }, { "name": "Human Services", "amount2016": 856034, "amount2017": 623150 }, { "name": "856.034", "amount2017": "623.150" }, { "name": "Cultural Services", "amount2016": 764320, "amount2017": 764320 }, { "name": "764.320", "amount2017": "764.320" }, { "name": "City Dues/Memberships", "amount2016": 236406, "amount2017": 226846 }, { "name": "236.406", "amount2017": "226.846" }, { "name": "Transfer to Other Funds", "amount2016": 10522220, "amount2017": 11271906 }, { "name": "10,522,220", "amount2017": "11,271,906" }, { "name": "Services from Other Funds", "amount2016": 7649840, "amount2017": 7621964 }, { "name": "7,649,840", "amount2017": "7,621,964" }, { "name": "Other Expenses/Contributions", "amount2016": 1333261, "amount2017": 1696079 }, { "name": "1,333,261", "amount2017": "1,696,079" }, { "name": "Contingency", "amount2016": 838617, "amount2017": 250000 } ] }, { "name": "838.617", "amount2017": "250.000" } ] }, { "name": "Other Expenditures", "children": [ { "name": "Grant Fund", "amount2016": 2820464, "amount2017": 11540862 }, { "name": "2,820,464", "amount2017": "11,540,862" }, { "name": "Community Development Program Costs/Carryforward", "amount2016": 7481442, "amount2017": 4710772 }, { "name": "7,481,442", "amount2017": "4,710,772" }, { "name": "Hotel/Motel Tax Fund", "amount2016": 8862343, "amount2017": 9287439 }, { "name": "8,862,343", "amount2017": "9,287,439" }, { "name": "Computer Purchase Fund", "amount2016": 721295, "amount2017": 721295 }, { "name": "721.295", "amount2017": "721.295" }, { "name": "Vehicle Purchase Fund", "amount2016": 6492400, "amount2017": 10587030 }, { "name": "6,492,400", "amount2017": "10,587,030" }, { "name": "Radio Replacement Fund", "amount2016": 1338000, "amount2017": 1338000 }, { "name": "1,338,000", "amount2017": "1,338,000" }, { "name": "Recorder's Court Technology Fund", "amount2016": "100.000", "": 100000, "amount2017": "60.000" } ] } ] } ```": 60000 } ] } ] } ```

User: chesedo

Question: Help converting a flat JSON file into hierarchical JSON schema to use with d3.treemap?

Back to question