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

CITYDASH City-wide analytics dashboard from public and private data sources
CITYDASH
Team Organizations	Apu Kumar CEO LotaData Inc.
Team Leaders	Tony Batalla IT Director
Participating Municipalities	City of San Leandro CA
Status	Ready for Public Announcement
Document	None

Description

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

Challenges

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.

Solutions

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

Impacts

• 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

Demonstration/Deployment

• 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