codeisland / ribudget_treemap

RI State Expenditure Data: Fiscal Year2009-2014
3 stars 2 forks source link

Create Sankey chart of expenditure data #6

Closed theryankelly closed 10 years ago

theryankelly commented 10 years ago

Who wants to take on this viz?

theryankelly commented 10 years ago

http://bost.ocks.org/mike/sankey/

nelsonri72 commented 10 years ago

I like this more focused example http://codeforftl.org/Budget-Visualization/

and better yet this that allows selecting middle category and showing relationship left and right : http://www.friendsofqueentheater.org/budget_sankey/examples/budget_alpha.html

I imagine we may add more options by year, proposed budget version, include programs+ expense type with additional levels to the right and may hover or be clickable for more detail

jamesrhaley commented 10 years ago

I have great news. I have made changes to the snakey and it did not crash. It is also under an MIT license so we are free to use it. Here is a file of how the data needs to be formatted. Also note at the bottom of the file the keys are called in stacks so we can easily make this two columns until we have more data. I will push all the files to github later today.

On Mon, Oct 20, 2014 at 2:21 PM, nelsonri72 notifications@github.com wrote:

I like this more focused example http://codeforftl.org/Budget-Visualization/

and better yet this that allows selecting middle category and showing relationship left and right :

http://www.friendsofqueentheater.org/budget_sankey/examples/budget_alpha.html

I imagine we may add more options by year, proposed budget version, include programs+ expense type with additional levels to the right and may hover or be clickable for more detail

— Reply to this email directly or view it on GitHub https://github.com/codeisland/RI_Budget/issues/6#issuecomment-59824386.

["Budget and Fiscal Services",406189,"Consultant Services"], ["Budget and Fiscal Services",15600,"Holiday Overtime Pay"], ["Budget and Fiscal Services",369078,"Non-Holiday Overtime Pay"], ["Budget and Fiscal Services",280650,"Other Services - Not Classified"], ["Budget and Fiscal Services",568632,"Personal Svcs-Contract Positions"], ["Budget and Fiscal Services",18021660,"Regular Pay"], ["Budget and Fiscal Services",0,"Sub Recipient Grants"], ["Budget and Fiscal Services",17110,"Unleaded Gas"], ["Community Services",0,"Consultant Services"], ["Community Services",44474000,"DHCD-Rental Subsidy"], ["Community Services",0,"Electricity"], ["Community Services",0,"Holiday Overtime Pay"], ["Community Services",2500,"Non-Holiday Overtime Pay"], ["Community Services",1603387,"Other Services - Not Classified"], ["Community Services",64404,"Personal Svcs-Contract Positions"], ["Community Services",10247148,"Regular Pay"], ["Community Services",11841386,"Sub Recipient Grants"], ["Community Services",2500,"Unleaded Gas"], ["Corporation Counsel",1702472,"Consultant Services"], ["Corporation Counsel",0,"Non-Holiday Overtime Pay"], ["Corporation Counsel",125000,"Other Services - Not Classified"], ["Corporation Counsel",0,"Personal Svcs-Contract Positions"], ["Corporation Counsel",5489136,"Regular Pay"], ["Customer Services",0,"Consultant Services"], ["Customer Services",140123,"Electricity"], ["Customer Services",0,"Holiday Overtime Pay"], ["Customer Services",78113,"Non-Holiday Overtime Pay"], ["Customer Services",4621121,"Other Services - Not Classified"], ["Customer Services",467856,"Personal Svcs-Contract Positions"], ["Customer Services",12086544,"Regular Pay"], ["Customer Services",0,"Solid Waste Disposal (including management svcs)"], ["Design and Construction",100,"Chemical Supplies"], ["Design and Construction",55000,"Consultant Services"], ["Design and Construction",529413,"Electricity"], ["Design and Construction",10246,"Holiday Overtime Pay"], ["Design and Construction",220466,"Non-Holiday Overtime Pay"], ["Design and Construction",829750,"Other Services - Not Classified"], ["Design and Construction",0,"Personal Svcs-Contract Positions"], ["Design and Construction",18032136,"Regular Pay"], ["Emergency Management",0,"Consultant Services"], ["Emergency Management",350,"Diesel"], ["Emergency Management",75475,"Electricity"], ["Emergency Management",700,"Holiday Overtime Pay"], ["Emergency Management",35000,"Non-Holiday Overtime Pay"], ["Emergency Management",41500,"Other Services - Not Classified"], ["Emergency Management",0,"Personal Svcs-Contract Positions"], ["Emergency Management",755520,"Regular Pay"], ["Emergency Services",557089,"Diesel"], ["Emergency Services",130907,"Electricity"], ["Emergency Services",595775,"Holiday Overtime Pay"], ["Emergency Services",4449698,"Non-Holiday Overtime Pay"], ["Emergency Services",17000,"Other Services - Not Classified"], ["Emergency Services",935772,"Personal Svcs-Contract Positions"], ["Emergency Services",436650,"Public Liability Insurance"], ["Emergency Services",20227032,"Regular Pay"], ["Emergency Services",2300,"Solid Waste Disposal (including management svcs)"], ["Emergency Services",70906,"Unleaded Gas"], ["Enterprise Services",34400,"Chemical Supplies"], ["Enterprise Services",60188,"Diesel"], ["Enterprise Services",2690891,"Electricity"], ["Enterprise Services",161887,"Holiday Overtime Pay"], ["Enterprise Services",282586,"Non-Holiday Overtime Pay"], ["Enterprise Services",676721,"Other Services - Not Classified"], ["Enterprise Services",936852,"Personal Svcs-Contract Positions"], ["Enterprise Services",400,"Recycling Services"], ["Enterprise Services",11373900,"Regular Pay"], ["Enterprise Services",63500,"Solid Waste Disposal (including management svcs)"], ["Enterprise Services",168529,"Unleaded Gas"], ["Environmental Services",8355950,"Chemical Supplies"], ["Environmental Services",9325000,"Consultant Services"], ["Environmental Services",1480900,"Diesel"], ["Environmental Services",25867539,"Electricity"], ["Environmental Services",1583950,"Holiday Overtime Pay"], ["Environmental Services",10231990,"Non-Holiday Overtime Pay"], ["Environmental Services",141872981,"Other Services - Not Classified"], ["Environmental Services",36576,"Personal Svcs-Contract Positions"], ["Environmental Services",10948580,"Recycling Services"], ["Environmental Services",52086816,"Regular Pay"], ["Environmental Services",17378901,"Solid Waste Disposal (including management svcs)"], ["Environmental Services",0,"Unleaded Gas"], ["Facility Maintenance",83500,"Chemical Supplies"], ["Facility Maintenance",0,"Consultant Services"], ["Facility Maintenance",27270,"Diesel"], ["Facility Maintenance",17581489,"Electricity"], ["Facility Maintenance",158650,"Holiday Overtime Pay"], ["Facility Maintenance",2477911,"Non-Holiday Overtime Pay"], ["Facility Maintenance",1015212,"Other Services - Not Classified"], ["Facility Maintenance",452196,"Personal Svcs-Contract Positions"], ["Facility Maintenance",15000,"Recycling Services"], ["Facility Maintenance",31560732,"Regular Pay"], ["Facility Maintenance",535316,"Solid Waste Disposal (including management svcs)"], ["Facility Maintenance",1376881,"Unleaded Gas"], ["Fire",207560,"Auto Allowance HPD/HFD/CCL"], ["Fire",43217,"Chemical Supplies"], ["Fire",541,"Consultant Services"], ["Fire",522711,"Diesel"], ["Fire",1543812,"Electricity"], ["Fire",5002635,"Holiday Overtime Pay"], ["Fire",5991748,"Non-Holiday Overtime Pay"], ["Fire",153150,"Other Services - Not Classified"], ["Fire",66996,"Personal Svcs-Contract Positions"], ["Fire",1500,"Recycling Services"], ["Fire",70485480,"Regular Pay"], ["Fire",1050,"Solid Waste Disposal (including management svcs)"], ["Fire",152253,"Unleaded Gas"], ["Human Resources",150,"Consultant Services"], ["Human Resources",0,"Holiday Overtime Pay"], ["Human Resources",38935,"Non-Holiday Overtime Pay"], ["Human Resources",106700,"Other Services - Not Classified"], ["Human Resources",80832,"Personal Svcs-Contract Positions"], ["Human Resources",5079768,"Regular Pay"], ["Human Resources",180,"Solid Waste Disposal (including management svcs)"], ["Information Technology",112000,"Consultant Services"], ["Information Technology",6630,"Electricity"], ["Information Technology",17500,"Holiday Overtime Pay"], ["Information Technology",215879,"Non-Holiday Overtime Pay"], ["Information Technology",0,"Other Services - Not Classified"], ["Information Technology",0,"Personal Svcs-Contract Positions"], ["Information Technology",8508792,"Regular Pay"], ["Managing Director",9600,"Non-Holiday Overtime Pay"], ["Managing Director",6999,"Other Services - Not Classified"], ["Managing Director",68484,"Personal Svcs-Contract Positions"], ["Managing Director",1823508,"Regular Pay"], ["Managing Director",0,"Sub Recipient Grants"], ["Mayor",1700,"Non-Holiday Overtime Pay"], ["Mayor",5702,"Other Services - Not Classified"], ["Mayor",0,"Personal Svcs-Contract Positions"], ["Mayor",437940,"Regular Pay"], ["Mayor",0,"Unleaded Gas"], ["Medical Examiner",19040,"Holiday Overtime Pay"], ["Medical Examiner",28900,"Non-Holiday Overtime Pay"], ["Medical Examiner",93300,"Other Services - Not Classified"], ["Medical Examiner",48756,"Personal Svcs-Contract Positions"], ["Medical Examiner",1162296,"Regular Pay"], ["Medical Examiner",5208,"Solid Waste Disposal (including management svcs)"], ["Neighborhood Commission",17000,"Non-Holiday Overtime Pay"], ["Neighborhood Commission",42000,"Other Services - Not Classified"], ["Neighborhood Commission",0,"Personal Svcs-Contract Positions"], ["Neighborhood Commission",644568,"Regular Pay"], ["Parks and Recreation",377000,"Chemical Supplies"], ["Parks and Recreation",8383,"Diesel"], ["Parks and Recreation",6777213,"Electricity"], ["Parks and Recreation",309443,"Holiday Overtime Pay"], ["Parks and Recreation",736500,"Non-Holiday Overtime Pay"], ["Parks and Recreation",2396369,"Other Services - Not Classified"], ["Parks and Recreation",4954992,"Personal Svcs-Contract Positions"], ["Parks and Recreation",21000,"Recycling Services"], ["Parks and Recreation",36013404,"Regular Pay"], ["Parks and Recreation",505500,"Solid Waste Disposal (including management svcs)"], ["Parks and Recreation",5695,"Unleaded Gas"], ["Planning and Permitting",320000,"Consultant Services"], ["Planning and Permitting",147036,"Non-Holiday Overtime Pay"], ["Planning and Permitting",439000,"Other Services - Not Classified"], ["Planning and Permitting",75936,"Personal Svcs-Contract Positions"], ["Planning and Permitting",16854576,"Regular Pay"], ["Planning and Permitting",0,"Unleaded Gas"], ["Police",9022749,"Auto Allowance HPD/HFD/CCL"], ["Police",2000,"Chemical Supplies"], ["Police",0,"Consultant Services"], ["Police",8850,"Diesel"], ["Police",31613,"Electricity"], ["Police",5442257,"Holiday Overtime Pay"], ["Police",16611150,"Non-Holiday Overtime Pay"], ["Police",3361250,"Other Services - Not Classified"], ["Police",1612188,"Personal Svcs-Contract Positions"], ["Police",162319548,"Regular Pay"], ["Police",6427198,"Unleaded Gas"], ["Prosecuting Attorney",0,"Consultant Services"], ["Prosecuting Attorney",100,"Holiday Overtime Pay"], ["Prosecuting Attorney",40750,"Non-Holiday Overtime Pay"], ["Prosecuting Attorney",741000,"Other Services - Not Classified"], ["Prosecuting Attorney",161496,"Personal Svcs-Contract Positions"], ["Prosecuting Attorney",14283792,"Regular Pay"], ["Prosecuting Attorney",0,"Sub Recipient Grants"], ["Royal Hawaiian Band",30000,"Non-Holiday Overtime Pay"], ["Royal Hawaiian Band",52248,"Personal Svcs-Contract Positions"], ["Royal Hawaiian Band",1836732,"Regular Pay"], ["Royal Hawaiian Band",0,"Unleaded Gas"], ["Transportation Services",8944719,"Bus Parts"], ["Transportation Services",235000,"Consultant Services"], ["Transportation Services",24778427,"Diesel"], ["Transportation Services",1039339,"Electricity"], ["Transportation Services",17401486,"Health, Welfare & Medical Plans-Bargaining Unit Em"], ["Transportation Services",3000,"Holiday Overtime Pay"], ["Transportation Services",236250,"Non-Holiday Overtime Pay"], ["Transportation Services",1786501,"Other Services - Not Classified"], ["Transportation Services",104781070,"OTS Payroll"], ["Transportation Services",8015752,"OTS Payroll Taxes"], ["Transportation Services",36480,"Personal Svcs-Contract Positions"], ["Transportation Services",11350000,"Public Liability Insurance"], ["Transportation Services",0,"Recycling Services"], ["Transportation Services",6285768,"Regular Pay"], ["Transportation Services",15211142,"Retirement Plans-Bargaining Unit Employees"], ["Transportation Services",9402197,"Services-OTS Operations"], ["Transportation Services",60,"Unleaded Gas"], ["Budget and Fiscal Services",2464016,"OTHER"], ["Community Services",12129579,"OTHER"], ["Corporation Counsel",647235,"OTHER"], ["Customer Services",4719830,"OTHER"], ["Design and Construction",-4886949,"OTHER"], ["Emergency Management",308446,"OTHER"], ["Emergency Services",6503101,"OTHER"], ["Enterprise Services",4825278,"OTHER"], ["Environmental Services",21597006,"OTHER"], ["Facility Maintenance",20814047,"OTHER"], ["Fire",11458551,"OTHER"], ["Human Resources",542504,"OTHER"], ["Information Technology",9271991,"OTHER"], ["Managing Director",795524,"OTHER"], ["Mayor",98006,"OTHER"], ["Medical Examiner",174579,"OTHER"], ["Neighborhood Commission",327000,"OTHER"], ["Parks and Recreation",13626991,"OTHER"], ["Planning and Permitting",-846583,"OTHER"], ["Police",18977888,"OTHER"], ["Prosecuting Attorney",2895783,"OTHER"], ["Royal Hawaiian Band",57418,"OTHER"], ["Transportation Services",18900766,"OTHER"],

["Bikeway Fund",28809,"Facility Maintenance"], ["Bikeway Fund",5550,"Parks and Recreation"], ["Bikeway Fund",403860,"Transportation Services"], ["Bus Transportation Fund",193279747,"Transportation Services"], ["Community Development Fund",681029,"Budget and Fiscal Services"], ["Community Development Fund",930042,"Community Services"], ["Federal Grants Fund",442989,"Budget and Fiscal Services"], ["Federal Grants Fund",20712415,"Community Services"], ["Federal Grants Fund",0,"Design and Construction"], ["Federal Grants Fund",181692,"Emergency Management"], ["Federal Grants Fund",0,"Environmental Services"], ["Federal Grants Fund",0,"Facility Maintenance"], ["Federal Grants Fund",0,"Fire"], ["Federal Grants Fund",47724,"Information Technology"], ["Federal Grants Fund",0,"Managing Director"], ["Federal Grants Fund",107610,"Parks and Recreation"], ["Federal Grants Fund",0,"Police"], ["Federal Grants Fund",1074531,"Prosecuting Attorney"], ["Federal Grants Fund",27209000,"Transportation Services"], ["General Fund",16412424,"Budget and Fiscal Services"], ["General Fund",3240648,"Community Services"], ["General Fund",7428754,"Corporation Counsel"], ["General Fund",19363582,"Customer Services"], ["General Fund",8355849,"Design and Construction"], ["General Fund",1003442,"Emergency Management"], ["General Fund",32455460,"Emergency Services"], ["General Fund",5574116,"Environmental Services"], ["General Fund",27836987,"Facility Maintenance"], ["General Fund",95631204,"Fire"], ["General Fund",5849069,"Human Resources"], ["General Fund",17768496,"Information Technology"], ["General Fund",2704115,"Managing Director"], ["General Fund",543348,"Mayor"], ["General Fund",1532079,"Medical Examiner"], ["General Fund",1030568,"Neighborhood Commission"], ["General Fund",61268279,"Parks and Recreation"], ["General Fund",13686178,"Planning and Permitting"], ["General Fund",198689431,"Police"], ["General Fund",16591048,"Prosecuting Attorney"], ["General Fund",1976398,"Royal Hawaiian Band"], ["General Fund",0,"Transportation Services"], ["Glass Incentive Account - SWSF",1995020,"Environmental Services"], ["Golf Fund",9823918,"Enterprise Services"], ["Hanauma Bay Nature Preserve Fund",834632,"Emergency Services"], ["Hanauma Bay Nature Preserve Fund",5000,"Enterprise Services"], ["Hanauma Bay Nature Preserve Fund",3002262,"Parks and Recreation"], ["Highway Beautification Fund",2707226,"Customer Services"], ["Highway Beautification Fund",154044,"Facility Maintenance"], ["Highway Beautification Fund",993649,"Parks and Recreation"], ["Highway Fund",5109685,"Design and Construction"], ["Highway Fund",35589796,"Facility Maintenance"], ["Highway Fund",2300647,"Planning and Permitting"], ["Highway Fund",25127260,"Police"], ["Highway Fund",7515350,"Transportation Services"], ["Housing & Comm Dev Rehab Fund",3205000,"Community Services"], ["Housing & Comm Dev Sec 8 Fund",155734,"Budget and Fiscal Services"], ["Housing & Comm Dev Sec 8 Fund",47612928,"Community Services"], ["Housing Development Special Fund",200000,"Facility Maintenance"], ["Leasehold Conversion Fund",89641,"Community Services"], ["Liquor Commission Fund",4100026,"Budget and Fiscal Services"], ["Liquor Commission Fund",126696,"Corporation Counsel"], ["Liquor Commission Fund",50988,"Information Technology"], ["Recycling Account - SWSF",11499324,"Environmental Services"], ["Recycling Account - SWSF",4949153,"Facility Maintenance"], ["Refuse Genl Operating Acct -SWSF",97340,"Budget and Fiscal Services"], ["Refuse Genl Operating Acct -SWSF",61984702,"Environmental Services"], ["Refuse Genl Operating Acct -SWSF",5067653,"Facility Maintenance"], ["Refuse Genl Operating Acct -SWSF",43296,"Information Technology"], ["Rental Assistance Fund",233000,"Community Services"], ["Sewer Fund",209852,"Budget and Fiscal Services"], ["Sewer Fund",408393,"Corporation Counsel"], ["Sewer Fund",1324628,"Design and Construction"], ["Sewer Fund",113064052,"Environmental Services"], ["Sewer Fund",2271762,"Facility Maintenance"], ["Sewer Fund",222288,"Information Technology"], ["Sewer Fund",325140,"Parks and Recreation"], ["Sewer Fund",1003140,"Planning and Permitting"], ["Sld Wst Dis Fac Acct - SWSF",106648975,"Environmental Services"], ["Special Events Fund",43541,"Budget and Fiscal Services"], ["Special Events Fund",11444014,"Enterprise Services"], ["Special Projects Fund",0,"Budget and Fiscal Services"], ["Special Projects Fund",4341230,"Community Services"], ["Special Projects Fund",42779,"Customer Services"], ["Special Projects Fund",31857,"Emergency Management"], ["Special Projects Fund",636138,"Emergency Services"], ["Special Projects Fund",0,"Fire"], ["Special Projects Fund",0,"Information Technology"], ["Special Projects Fund",0,"Managing Director"], ["Special Projects Fund",0,"Mayor"], ["Special Projects Fund",30000,"Parks and Recreation"], ["Special Projects Fund",0,"Planning and Permitting"], ["Special Projects Fund",0,"Police"], ["Special Projects Fund",457342,"Prosecuting Attorney"], ["Transit Fund",0,"Budget and Fiscal Services"], ["Transit Fund",0,"Corporation Counsel"], ["Transit Fund",0,"Design and Construction"], ["Transit Fund",0,"Planning and Permitting"], ["Zoo Animal Purchase Fund",2200,"Enterprise Services"],

]; sankey = new Sankey();

  name_conversions = {
    "Ngas":"Natural gas",
    "UK land based bioenergy":"Forests & biocrops",
    "Bio-conversion":"Biomass processing",
    "H2 conversion":"Hydrogen production",
    "H2":"Hydrogen",
    "Useful district heat":"Delivered heat",
    "Heating and cooling - homes":"Home heating & cooling",
    "Heating and cooling - commercial":"Office heating & cooling",
    "Lighting & appliances - homes":"Home lighting & appliances",
    "Lighting & appliances - commercial":"Office lighting & appliances",
  }

  sankey.convert_box_description_labels_callback = function(name) {
    console.log(">"+name+"<");
    var alternative_name = name_conversions[name];
    if(alternative_name == null) alternative_name = name;
    return alternative_name;
  };

  sankey.stack(0,[
    "General Fund",
    "Bus Transportation Fund",
    "Sewer Fund",
    "Sld Wst Dis Fac Acct - SWSF",
    "Highway Fund",
    "Refuse Genl Operating Acct -SWSF",
    "Federal Grants Fund",
    "Housing & Comm Dev Sec 8 Fund",
    "Recycling Account - SWSF",
    "Special Events Fund",
    "Golf Fund",
    "Special Projects Fund",
    "Liquor Commission Fund",
    "Highway Beautification Fund",
    "Hanauma Bay Nature Preserve Fund",
    "Housing & Comm Dev Rehab Fund",
    "Glass Incentive Account - SWSF",
    "Community Development Fund",
    "Bikeway Fund",
    "Rental Assistance Fund",
    "Housing Development Special Fund",
    "Leasehold Conversion Fund",
    "Zoo Animal Purchase Fund",
    "Transit Fund"
  ]);

  sankey.stack(1,[
    "Environmental Services",
    "Transportation Services",
    "Police",
    "Fire",
    "Community Services",
    "Facility Maintenance",
    "Parks and Recreation",
    "Emergency Services",
    "Budget and Fiscal Services",
    "Customer Services",
    "Enterprise Services",
    "Information Technology",
    "Prosecuting Attorney",
    "Planning and Permitting",
    "Design and Construction",
    "Corporation Counsel",
    "Human Resources",
    "Managing Director",
    "Royal Hawaiian Band",
    "Medical Examiner",
    "Emergency Management",
    "Neighborhood Commission",
    "Mayor",

   ]);

  sankey.stack(2,[  
    "Regular Pay",
    "Other Services - Not Classified",
    "OTS Payroll",
    "Electricity",
    "DHCD-Rental Subsidy",
    "Non-Holiday Overtime Pay",
    "Diesel",
    "Solid Waste Disposal (including management svcs)",
    "Health, Welfare & Medical Plans-Bargaining Unit Em",
    "Retirement Plans-Bargaining Unit Employees",
    "Holiday Overtime Pay",
    "Consultant Services",
    "Sub Recipient Grants",
    "Public Liability Insurance",
    "Recycling Services",
    "Personal Svcs-Contract Positions",
    "Services-OTS Operations**",
    "Auto Allowance HPD/HFD/CCL",
    "Bus Parts**",
    "Chemical Supplies",
    "Unleaded Gas",
    "OTS Payroll Taxes",
    "OTHER"
   ]);
jamesrhaley commented 10 years ago

Hello data visualization group,

I have started a repo for the snakey at https://github.com/jamesrhaley/snakey. On a side note to Joe Alba thank you in advance for offering to format the data to match the charts convention. I appreciate it.

Best, James Haley

On Wed, Oct 22, 2014 at 11:25 AM, James Haley james.r.haley@gmail.com wrote:

I have great news. I have made changes to the snakey and it did not crash. It is also under an MIT license so we are free to use it. Here is a file of how the data needs to be formatted. Also note at the bottom of the file the keys are called in stacks so we can easily make this two columns until we have more data. I will push all the files to github later today.

On Mon, Oct 20, 2014 at 2:21 PM, nelsonri72 notifications@github.com wrote:

I like this more focused example http://codeforftl.org/Budget-Visualization/

and better yet this that allows selecting middle category and showing relationship left and right :

http://www.friendsofqueentheater.org/budget_sankey/examples/budget_alpha.html

I imagine we may add more options by year, proposed budget version, include programs+ expense type with additional levels to the right and may hover or be clickable for more detail

— Reply to this email directly or view it on GitHub https://github.com/codeisland/RI_Budget/issues/6#issuecomment-59824386.

mrengy commented 10 years ago

Hey, awesome to see this!

I think you mean a “Sankey” diagram, not “snakey” (like the legless reptile), right?


Mike Eng 401-234-4611 www.mike-eng.com www.linkedin.com/in/mikeeng401

On Oct 22, 2014, at 9:27 PM, jamesrhaley notifications@github.com wrote:

Hello data visualization group,

I have started a repo for the snakey at https://github.com/jamesrhaley/snakey. On a side note to Joe Alba thank you in advance for offering to format the data to match the charts convention. I appreciate it.

Best, James Haley

On Wed, Oct 22, 2014 at 11:25 AM, James Haley james.r.haley@gmail.com wrote:

I have great news. I have made changes to the snakey and it did not crash. It is also under an MIT license so we are free to use it. Here is a file of how the data needs to be formatted. Also note at the bottom of the file the keys are called in stacks so we can easily make this two columns until we have more data. I will push all the files to github later today.

On Mon, Oct 20, 2014 at 2:21 PM, nelsonri72 notifications@github.com wrote:

I like this more focused example http://codeforftl.org/Budget-Visualization/

and better yet this that allows selecting middle category and showing relationship left and right :

http://www.friendsofqueentheater.org/budget_sankey/examples/budget_alpha.html

I imagine we may add more options by year, proposed budget version, include programs+ expense type with additional levels to the right and may hover or be clickable for more detail

— Reply to this email directly or view it on GitHub https://github.com/codeisland/RI_Budget/issues/6#issuecomment-59824386.

— Reply to this email directly or view it on GitHub.

jamesrhaley commented 10 years ago

Whoops! I knew something looked wrong. Everything is now "Sankey." Thanks for catching that.

James Haley

On Thu, Oct 23, 2014 at 10:54 AM, mrengy notifications@github.com wrote:

Hey, awesome to see this!

I think you mean a “Sankey” diagram, not “snakey” (like the legless reptile), right?


Mike Eng 401-234-4611 www.mike-eng.com www.linkedin.com/in/mikeeng401

On Oct 22, 2014, at 9:27 PM, jamesrhaley notifications@github.com wrote:

Hello data visualization group,

I have started a repo for the snakey at https://github.com/jamesrhaley/snakey. On a side note to Joe Alba thank you in advance for offering to format the data to match the charts convention. I appreciate it.

Best, James Haley

On Wed, Oct 22, 2014 at 11:25 AM, James Haley james.r.haley@gmail.com wrote:

I have great news. I have made changes to the snakey and it did not crash. It is also under an MIT license so we are free to use it. Here is a file of how the data needs to be formatted. Also note at the bottom of the file the keys are called in stacks so we can easily make this two columns until we have more data. I will push all the files to github later today.

On Mon, Oct 20, 2014 at 2:21 PM, nelsonri72 notifications@github.com

wrote:

I like this more focused example http://codeforftl.org/Budget-Visualization/

and better yet this that allows selecting middle category and showing relationship left and right :

http://www.friendsofqueentheater.org/budget_sankey/examples/budget_alpha.html

I imagine we may add more options by year, proposed budget version, include programs+ expense type with additional levels to the right and may hover or be clickable for more detail

— Reply to this email directly or view it on GitHub < https://github.com/codeisland/RI_Budget/issues/6#issuecomment-59824386>.

— Reply to this email directly or view it on GitHub.

— Reply to this email directly or view it on GitHub https://github.com/codeisland/RI_Budget/issues/6#issuecomment-60261459.

theryankelly commented 10 years ago

Moved issue to ribudget_sankey