570 likes | 718 Views
CrimeBase: Integrating a Crime Information with Community Statistics Robert Cheetham cheetham@avencia.com. Presentation. 1. CrimeBase Overview 2. NIS Overview 3. Lessons. Customized Map Products. Phila PD Crime Analysis Unit. Weekly CompStat Meetings. “Real Time” Intranet Web Site.
E N D
CrimeBase: Integrating a Crime Information with Community Statistics Robert Cheetham cheetham@avencia.com Avencia
Presentation 1. CrimeBase Overview 2. NIS Overview 3. Lessons Avencia
Customized Map Products Phila PD Crime Analysis Unit • Weekly CompStat Meetings • “Real Time” Intranet Web Site • Updated Daily • Automated Routines for Geocoding • Date Range, Time of Day, Day of Week • Crime or Incident Type, Nature Code • District, Sector or Street Address Avencia
Cartographic Modeling Lab Univ. of Penn Research Lab Graduate School of Design and School of Social Work Small, full-time staff plus student help Teach classes Perform research Host applications that serve academic and public Avencia
Avencia • Clients: • Local/State/Federal Government • Non-Profits • Academic Institutions • Topic Domains: • GIS Software Development in: • Real Estate • Urban/Neighborhood Redevelopment • Natural Resources • Crime Analysis Avencia
Partner Relationships - Manages the Project - Aggregates Data - Hosts Application CML - Strip out personal id’s - Send Data - Develop Software Components - Develop Database Design - Install and maintain software Avencia Phila PD Avencia
Data 2000 Census: Basic Population and Housing Variables Incidents: Approx. 12 million records 1998-2003 Excludes Sexual Assaults, Homicides, Rapes Avencia
Data Complainant Verizon 911 District 48 Desk INCT District X 911 Operator CAD Police Officer District Y Radio Dispatcher District Z Daily download & Geocoding Routines Incident Report Completed by Officer Maps distributed Through Intranet, Printing, CompStat Avencia
Development Process Phila PD CML Avencia CML Incident Geocoding Data Aggregation Element Suppression Software Development Data Loading Testing Rollout Production Avencia
System Architecture Database Data Access Preparation Presentation Avencia
CrimeBase Home Avencia
Tables Avencia
Tables Avencia
Tables Avencia
Tables Avencia
Tables Avencia
Tables Avencia
Tables Avencia
Tables Avencia
Stats Avencia
Stats Avencia
Stats Avencia
Scatter Charts Avencia
Trend Charts Avencia
Maps Avencia
Maps Avencia
Maps Avencia
Data Matrix Avencia
Data Matrix Avencia
Data Matrix Avencia
Data Matrix Avencia
Custom Neighborhoods Avencia
Custom Neighborhoods Avencia
Custom Neighborhoods Avencia
Administration Avencia
Presentation 1. CrimeBase Overview 2. NIS Overview 3. Lessons Avencia
ParcelBase Avencia
ParcelBase Avencia
ParcelBase Avencia
ParcelBase Avencia
ParcelBase Avencia
Community Surveys Avencia
NeighborhoodBase Avencia
NeighborhoodBase Avencia
NeighborhoodBase Avencia
MuralBase Avencia
MuralBase Avencia
MuralBase Avencia
MuralBase Avencia
MuralBase Avencia