About Our Capstone Project

The City Data Group is developing an interactive dashboard that highlights reported tree hazards in New Orleans, the severity of each report, and provides precise locations of tree damage, offering a clear and accessible view of the city's tree maintenance needs. Information is sourced from the 311 OPCD calls and Tree Location datasets from data.nola.gov. Our goal is to incorporate the Tree Location data to show the nearest city-owned trees to the report. Additionally, we plan to improve interactivity by incorporating features that will allow residents to upload photos and comment on specific cases, with the goals of fostering community engagement, improving data accuracy, and providing additional context.

About our data:

The 311 report data on the homepage is sourced from https://data.nola.gov/City-Administration/311-OPCD-Calls-2012-Present-/2jgv-pqrq/about_data with a script that runs daily at midnight UTC. The script fetches the new rows in the dataset (rows where that request number has not already been fetched), fills any blank fields with 'Unknown', and inserts these rows into our Heroku database. From there, we filter out closed requests, in addition to requests unrelated to tree issues/hazards into a DataFrame object that is used to display the points on the map. In the future, report points will connect to New Orleans tree locations by latitude and longitude coordinates and displayed on the map using a 3-nearest-neighbors algorithm.

Roadmap:

By End of February:

  • User can hover on report point and see relevant ticket information (number, address, type, status)
  • User can click on report point and see list of 3 nearest trees

By End of March:

  • User can click on report point and the 3 nearest trees will appear on the map
  • User has the option to upload photos and comments to report point

By End of April:

  • When user clicks on report point, they can see other users' photos and comments in addition to ticket information from the dataset
  • In addition to "Home" and "About", there will be an "Analytics" page displaying statistics such as average ticket working time per ward
Project Image

Team Members: Zoe Birnbaum, Daniel Cicero, Cece Haase, Gabby Reese

Advisor: Dr. Nick Mattei