goinvo / visual-town-budget Goto Github PK

Doesn't track the cursor. FireFox 43.0.1 on Windows 7. Untested on Mac.

• Links in pop-overs displayed as HTML (www.arlingtonvisualbudget.org) or don't work.

• How are these sorted, if any? Should sort by columns (name/$/etc.)?
• Pop-overs block highlighting new tabs
• Can click through pop-overs to toggle display on parent tabs
• Some graph lines draw below their allotted tab
• Triangles should transition when opening/closing parent tabs

trying to use 'processCSV.py' with a csv file (first two lines below). getting the following error:

@expenses
list index out of range
Error reconstructing tree at node: <main.entry instance at 0x7f9edeafccb0>

==========CSV Example=================================
LEVEL1,LEVEL2,LEVEL3,LEVEL4,LEVEL5,TOOLTIP,SOURCE,SOURCE URL,2010,2011,2012,2013,2014,2015,2016,2017,2018,LEVEL
General Fund,Administration,SALARIES AND WAGES,,,,,,104357.00,111563.00,179844.00,115976.00,222554.00,160906.00,,,,3

Occasionally the layers in the graph do not line up on the top with the overall 'total' line. There is a blank space of background color.

Default year is now derived from current year, but fiscal years start July 1. Also for some purposes, might want to start on some FY in the future.

• First year on graph says '100%' increase from last year. Maybe put in prior year's values without drawing them?
• Values for years change in-between year tick marks (changing on fiscal year?)

• No tool tips for treemap
• No labels on treemap
• Can't dive into treemap

IE8 and earlier, doesn't work at all, Just see the header and footer with no map or graph.

IE9&10 shows Labels but missing the money totals on the tree map. (Ex on Revenues screen. Shows "Property Tax" but missing "79M"

IE11 Missing all labels on tree map, can't click through map. Graph works.

• Left/Right swap buttons do not line up on swapping
• 'Town of Arlington' link should open in new tab

Remove the data files (csv & json) from /data & /data/processing. Rename /includes/localized_variables.php to localized_variables_template.php. The intent is to allow updating a site by simply overwriting with all the files in the distro, without overwriting the data and localization. Sample data files could be packaged separately for the initial installation.

There is no background color on the left side of the slider when only one entry is being displayed (no layers).

IE popovers show block title, should show "Your contribution is $XXX" for Expenses, tooltip field for Funds & Revenues.

When showing fiscal budgets over time, its a good idea to adjust for inflation to ensure apples to apples comparisons of spending. I looked through your code and didn't see any evidence that you were doing so.

A straightforward way to do this is to take the Consumer Price Index (CPI) and multiply your data by it for each year.

Here's a table of CPI: ftp://ftp.bls.gov/pub/time.series/cu/cu.data.4.AsizeNorthCentral
Here's an R script we use to do the calculation: https://github.com/open-city/hows-business/blob/master/import/taxes.R

Make a variable file so new instances of VTB can more easily be spun up with the proper data. Replace hard coded data with these variables.

• Why is 'Funds' the landing page?
• Keep tabular/map view when switching between Revenue/Expenses/Funds?
• Transitions on tour not lined up. Div gets highlighted before transition
• Not all pop-overs have descriptions
• When you dive in a parent that has one child, you first view the parent zoomed in, then you click again and view the child, but the data is exactly the same because there is only one child holding any data for the parent. This middle zone should be bypassed. (E.g. Revenues > Other Revenues)
• No highway maintenance salaires in 2010?

• Pop-overs/arrow don't line up for some blocks, especially smaller ones
• Mouse overs are finicky

So $5.7M instead of $6M.
Probably in format_currency() in statistics.js. Could just add a digit, or set a variable on localized_variables.php, or make the function clever about space available.

Small entries for data are nearly impossible to see sometimes at the bottom of the tree map. Especially if drawn as a small thin line rather than a square.

Should be require_once '../../includes/localized_variables.php';

Use "town" or "city" in various text strings, e.g. "City/Town budget visualized", "how much money does the city/town spend on schools", "Education is an important factor in City/Town expenses". Could be a separate field in localized_variables.php, or just parse $longName.

Pop-overs sometimes don't disappear when transitioning, and get permanently stuck on page.