codefornola / 311 Goto Github PK

Create scripts to load data into the deployment environment

There is another more general problem that we are trying to solve. There is a lot of information about the 311 system, the Department of Public Works, and the Sewerage and Water Board that is spread over multiple sites. We want to bring all of that information together on a website to provide a summary of useful information that will help citizens understand infrastructure issues more deeply. For example, I think we could point how many potholes the city fixes and show how much that costs. That information is tracked and can be viewed on datadriven.nola.gov

The information architecture should be structured for usability. It should identify the ways the content of the website should be labeled and organized. There's a lot more to it and you can read more here.

As a citizen, I want to see open issues near me so that I can determine if someone already reported the issue.

To find issues near me, I can enter my address, allow the browser to access my location, or zoom into a map. Open issues should be filtered to only include results for this year.

As a citizen, I would like to view interesting aggregations on the 311 data.

Number of issues per request type
Most recently open issue
Most recently closed issue
Percentages of time spent open (median & histogram)

It would be useful to view the following stats for each neighborhood:

• Total number of open tickets
• Total number tickets by type
• Rank median time to close across all neighborhoods
• Median time to close (across all, and by type)
• Top issue type
• Most recently opened tickets
• Most recently closed tickets
• YTD number of closed tickets

remove the gh-pages branch

Related to #35

Deploy app and put URL in readme