CITYDASH City-wide analytics dashboard from public and private data sources

From OpenCommons
Jump to navigation Jump to search

CITYDASH City-wide analytics dashboard from public and private data sources
GCTC logo 344x80.png
Sanleandro PR image 5-1.png
Team Organizations Apu Kumar
Team Leaders Tony Batalla
IT Director
Participating Municipalities City of San Leandro
Status Ready for Public Announcement


Data analytics and insights powered by machine intelligence for 4 target city departments:

  • 311 crowd-sourced civic issues
  • Recreation and Parks programs
  • Crime reports and police data
  • Building and Engineering permits


The proliferation of data from mobile apps, cloud computing, sensors and IoT, combined with traditional sources of City data, has created the opportunity for data-driven optimization of city services. However, most cities are taking a siloed approach to data analytics.


CityDashworks across departments (and datasets), enabling government officials and decision makers to derive insights from public and private data, and to create organizational efficiencies and social impact and by engaging with their data more meaningful and strategic ways.

Major Requirements

  • Create project team with City leaders and data science & machine learning experts
  • Identify sources of public data from city departments for analysis
  • Identify relevant sources of data provided by the private sector to be incorporated
  • Design and develop API-based data pipes and data integrations
  • Research and develop machine learning models to infer trends and correlations across the datasets
  • Design the UX for visual analytics with maps, charts and graphs
  • Implement the CityDash web app for desktop and mobile (web)
  • Pilot CityDash for 3 months

Performance Targets

Key Performance Indicators (KPIs) Measurement Methods
  • Minimum 5 City KPIs defined for each dataset/department and built into dashboard
  • CityDash used daily by at least one data analyst/manager or higher in each target department
  • Average daily session length of at least 5 minutes
  • City improvement targets identified in each department and tracking of data enabled (faster response time, increased program revenue, etc)
  • KPI impact measured over a period of 6 months

Standards, Replicability, Scalability, and Sustainability

  • Project to include open-data public-facing dashboard with access to raw datasets and files
  • Input data to be transformed into well-formed JSON
  • Output analysis and insights to be made available as APIs
  • Frontend development in HTML5, backend development in Java & R
  • 100% cloud solution. No on-premise software components
  • Less than 2 hours/week maintenance from IT departments
  • Insights will be used to directly influence city services and programs. As the value of data becomes better understood by city leaders, the program can spread to cover all city depts and datasets and easily be procured by other cities and agencies at the local, state, federal levels

Cybersecurity and Privacy


  • Increased responsiveness on 311 civic issues and complaints;
  • Improved quality of life in neighborhoods through increased and faster city response and resolution of issues
  • Deeper engagement with residents for city programs
  • Higher level of trust in government through open data; resident collaboration
  • Increased city revenue through better management of recreation programs
  • More popular city recreation programs through performance management


  • CityDash full implementation completed for 2 city departments
  1. 311 crowd-sourced civic issues
  2. Recreation and Parks programs
  • CityDash partial implementation for remaining 2 city departments
  1. Crime reports and police data
  2. Building and Engineering permits
  • Desktop version launched with visual analytics and insights for lead city including public-facing version

In segment Data

Year Started 2017