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

Fork me!

Fork and clone the project!

$ git clone [email protected]:[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.

Most of the new development on Oklahoma City 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!

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

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

What you'll need:

• Node
• npm
• Harp

Once you have npm installed,

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

# npm install can be omitted on subsequent runs
npm start

• 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.

This project is coded with:

• jade
• Sass
• Bootstrap

• 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.)

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 Oklahoma City 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:

1. add the CSV to _src/data/proposed_1517_flow/ and remove the placeholder file FY13-14__FY14-15.csv
2. rename the file to include the two fiscal years it includes, separated by two underscores ("FY15-16__FY16-17.csv")
3. 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)
4. test it in Harp in the dev branch, and it should compile properly for deployment

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.