Crime and Community Data Challenge

Posted by on Apr 3, 2016 in New Data | 0 comments

To announce the arrival of a new set of crime data, our next meetup will be a mini data contest, with a $100 prize for the best student analysis. In this meeting, we will present the new Crime Incident dataset and talk about how to link it to other social datasets. After the presentation, we’ll challenge you to do you own analysis, with a $100 prize for the best analysis from a student, undergraduate or lower.

Then, for the next meeting, we’ll invite the best analysts to present their findings and techniques.

Read More

New Crime Data

Posted by on Mar 23, 2016 in New Data | 0 comments

When we last requested crime data from SANDAG, 3 years ago, it took four months of negotiation to get them to admit they could produce it, and two more months to get the price down to a reasonable amount.

Last week when I requested an update, I got one clarification email, then a phone call, and the files were in my inbox a few minutes later. Thanks SANDAG! As a bonus, the data is now geocoded to census block and track, making the files more immediately analyzable.

You can find both the old data file and the new one in an Ambry package on our new data repository.

Read More

Data Project Context: Journalism vs Nonprofits

Posted by on Oct 5, 2015 in Commentary | 0 comments

The Data Library works primarily with journalists and nonprofits, but until recently, I hadn’t fully realized how different the processes are in these two environments. We’d been following two different processes, but didn’t have names for them, so it is worthwhile to give the two contexts names, so we can be sure we are working in a process that is comfortable for our clients and partners.

In the Journalist / Exploratory context, the journalist is looking for a story in data, or wants to use data to support a story idea. In either case, the dataset is novel; there is no pre-existing format to follow, and most times, neither the journalist nor the analyst has worked with the data before.

In this context, we follow a light, fast process that produces a lot of graphs and tables to look at different angles. The outputs are very rough, so the plots aren’t properly labeled and table columns can be cryptic. The goal is to sift through the data quickly to find a few gems, and polish them later. We don’t want to spend a lot of time making plots look good if they will never be used.

In this context, we will work directly from IPython and plotly, documenting the process in Google Docs,  and will share with the journalist the IPython Notebooks, which like this one, are complicated, ugly, and not at all suitable for publication, but they are very useful for exploring ideas quickly.

The other context is the Nonprofit / Reporting context, where an organization has a fairly specific goal, most often a well defined report. In this context, the projects run most smoothly when we start with a copy of a previous report, discuss changes to it, and use it as a template. If there isn’t a previous report, we’ll mock up one in Excel first.

In the reporting context, the client doesn’t want to see the rough work, and the IPython notebooks are very confusing and distracting, so we usually share Excel files for data, and load the data into Tableau for presentation and discussion. The Tableau workbooks are much easier to understand, and a whole lot more attractive. Here is an example of a Tableau workbook organized for reporting.

There are other contexts as well, one for programming projects and another for producing datasets for later analysis, but these are the two where proper communication about which context will be used for a project has the most impact on project success.

Read More

SDSU Big Data Hackathon

Posted by on Sep 23, 2015 in News | 0 comments

Big Data Hackathon on Oct 3 at 9AM at SDSU!

On October 3, the Center for Human Dynamics in the Mobile Age will host a Big Data Hackathon at San Diego State University. Contestants will use data analysis and programming to solve civic problems related to water conservation, disaster recovery and crime prevention.  Visit the Devpost website for details and to register,  or hit Github for the tech details and data.


Read More