Open Budget Wichita

Chat

Join the Open Wichita Slack room here: http://openwichita-slack.herokuapp.com/. Once there, check out the #openbudget channel for discussion about this project.

Getting Started

Fork me!

Fork and clone the project!

$ git clone git@github.com:[your-user]/openbudgetwichita.git
$ cd openbudgetwichita

[](TODO: Point to our wiki, once we have one) Read helpful info about image sizes, data types and color schemes on the wiki.

Developing Locally

D3 Sandbox

Most of the new development on Wichita data visualizations is currently occuring in the sandbox directory. Each of the charts can be viewed by opening them directly in your browser.

$ open openbudgetwichita/sandbox/zoomable.html

This area is in active development so all of the graphs may not be functioning correctly!

Generating json files from a csv

We have a small script written in ruby for generating a json file from a csv of city data. The script asks for the file and then steps through each required field and asks you to specify the correct header which matches.

To run the script

$ cd <project_root>/sandbox
$ ruby data_to_json.rb

Harp

This site is built on Harp using Node.js That means you can run it locally with minimal setup!

What you'll need:

Install & Run

Once you have npm installed,

# to install dependencies and run
npm install && npm start

# npm install can be omitted on subsequent runs
npm start

Pitfalls

node version 6

Currently, there is a problem with installing on node V6 It can be fixed by changing the harp line to

"harp": "https://github.com/sintaxi/harp.git#v0.21.0-pre" in the package.json at the root of this project.

Making Changes

This project is coded with:

Creating & Editing Pages

Page content is inserted into the layout.jade file (which includes basic header and footer snippets)
Create your .jade file
Add a link to the main nav in the appropriate place
Add relevant metadata in _data.json (page title, page slug (url), ...)
If your page uses custom page-specific css, add it to a new .scss partial and import it into the main stylesheet. (Make sure to namespace it the same way the others are.)

Adding additional datasets to the Flow diagram page

To request revenue and expense data for a new fiscal year, submit an Open Records request and type the following in the description field. Update FYXX with the last two digits of the year (ex: FY16).

-A csv file of the City of Wichita revenue and expenditure budget for FYXX, including Fund, Fund name, Operating Unit, Operating Unit Description, Agency, Agency Name, Program ID, Program Name, Line of Business ID, Line of Business name, Account, Account Name, Account Description, Budget Amount. (Budget database query names qry_Current_Yr_Budget_detail and qry_Current_Yr_Budget_Detail_Revenue)

This chart takes as input the full budget datatable from data.oaklandnet.com (in CSV format)

Right now the 2015-17 Proposed page is an unpublished placeholder, pending the data release. When the data becomes available:

add the CSV to _src/data/proposed_1517_flow/ and remove the placeholder file FY13-14__FY14-15.csv
rename the file to include the two fiscal years it includes, separated by two underscores ("FY15-16__FY16-17.csv")
open the csv and make sure all column headings are standardized to the following names:
- budget_year
- department
- division
- org_code
- org_description
- fund_code
- fund_description
- account_type (this should be the Expense/Revenue column, if there are duplicate names)
- account_category
- account_code
- account_description
- amount
- (any other columns should be deleted)
test it in Harp in the dev branch, and it should compile properly for deployment

Contributing

If you're new to contributing to open source projects Github has a pretty great video series.

If you're comfortable already, our workflow is:

Fork the repo.
Make your changes.
Commit the changes. (How to write a great commit message!)
Push them to your fork.
And open a pull request.

br0xen/openbudgetwichita