Day/Time Crime Heatmaps

Here is an interactive data application that explores how crime incidents vary over the day of week and time of day. In the checkbox below, select one or more crime types, and the heatmap will show the relative intensity of those crime types over day of week and time of day. There many interesting patterns … Read more

Visualizing Traffic Accidents

We recently converted the SWITRS database of traffic collisions in California, extracting the records for San Diego County and creating a basic visualization in Tableau Public. Tableau Public is a fantastic data analysis tool, although it takes a bit of training to do complex things. Below is a simple visualization of the number of people … Read more

Crime at Street Segments

A few weeks ago, we received crime incident data from SANDAG for the years from 2007 to March of 2013. The data has the location of the crime listed as a “hundred block,” so a crime at 1435 Main street would be listed at 1400 Main. Since we don’t know where the crime occurred on the block – we … Read more

SANDAG Transportation Resources

SANDAG Senior Research Analyst Mike Calandra sent us some traffic data updates for our Data As a Public Good report. I’m always thrilled when I get to communicate directly with agency analysts, and having them write to me is like an early Christmas. In our Data as a Public Good report several interviewees reported that … Read more

Population Density Maps

Here is some  eye candy, a population density map of Pacific Beach and surrounding neighborhoods. This map was created with a lot of Python code, using the 2010 census shapefiles for census blocks, setting a value for each block as the population of the block divided by the area of the block, and rasterizing all … Read more

Python Data Analysis Workshop

I’m spending the morning at Qualcomm for the Python Data Analysis Workshop, run by Dave Cook of the San Diego Python User group. I’m presenting about using Python to analyze crime and census data. If you like pretty pictures, the presentation has plenty of them: Analyzing Crime and Census Data Presentation.

Report: Municipal Open Data Policies

We’ve released a new report, Municipal Open Data Policies. The best way to ensure that San Diego area nonprofits and citizens get useful data is for local governments to adopt Open Data policies. These policies, which have been implemented in many cities around the country, mandate that cities publish data. So, instead of fighting for months … Read more

Report: Data as a Public Good

Our first report, Data as a Public Good, assesses data requirements from over 20 civic and social organizations in the San Diego region and documents specific needs for municipal data. The report highlights the datasets that city governments control that would be most useful to the public if they were easily available. The report also discusses limits to … Read more

TGIF Chula Vista, It’s Crime Minimum Day

Our resident data slinger sent me an initial analysis of time series data for specific crime hot spots in San Diego, and the results are interesting. Rather than look at the whole of the region at once, we’ve identified specific high intensity areas, and are doing time-series analysis for them independently. The major areas are: North Park, … Read more

What Is Crime Analysis?

On Wednesday March 6 we’ll kick off our Crime Data Analysis project, and before then, it may be worth asking “Why are a bunch of amateurs attempting what the police should be doing? ” The answer is that police departments analyze crime to catch criminals, and the Data Library analyzes crime to help residents understand their … Read more