Skip to content
Visualizing and analyzing Open311 data on one unified, customizable dashboard
Python JavaScript
Find file
New pull request
Fetching latest commit...
Cannot retrieve the latest commit at this time.
Failed to load latest commit information.
dashboard started refactoring update_db, added tests for first 3 methods


Open311 Dashboard

We are creating an application to help people visualize and analyze 311 data on one unified dashboard.

Non-Python Requirements

You will need all of the libraries to run GeoDjango. If you are so inclined, you can install most of these with homebrew. KyngChaos may also be a useful resource for MacOS X users.

Getting Started

  1. Set up a database using the PostGIS spatial database template.
  2. Rename to and set your db/secretkey variables.
  3. pip install -r requirements.txt
  4. python syncdb creates the database schema.
  5. python update_db imports initial data.
  6. Generate GeoJSON files with python geojson
  7. git submodule update --init adds bootstrap submodule
  8. python runserver

A Word on Mapnik

Mapnik2's Wiki has instructions for installing Mapnik2 on Mac OSX and Linux. Dane Springmeyer recently released Mapnik2 binaries for Mac OSX.

Database Update Script

To update data from the Open311 API, run python update_db. This command has a few options that may be useful. The first argument is the end date, defaults to yesterday. The second argument is the number of days to download previous to that date.

  • Ex: python updatedb 2011-07-01 30 will download the entire month of June.

To set up automatic updates (midnight every night):

  1. crontab -e
  2. Insert 0 0 * * * /path/to/dir/ update_db

API Access

There are a number API calls to return JSON in various forms.

  • /api
    • /tickets/(open|closed|both)
      • /[0-9]+ (n days previous to today)
      • /YYYY-MM-DD(/[0-9]+) (n days previous to the date)
      • /YYYY-MM-DD/YYYY-MM-DD (simple date range)
    • /more_info/YYYY-MM-DD (single day)
      • /YYYY-MM-DD (range)
    • /list/YYYY-MM-DD (singe day)
      • /YYYY-MM-DD (range)

More Information

Visit our project page.

Join the official Open311 Dashboard mailing list.

Code for America Tracker

Something went wrong with that request. Please try again.