Second Pass at Analytics X Prize

For my second attempt at predicting homicides in Philadelphia, I included roads in the model.  I got the roads data from the census link in the last post, imported the roads into my PostgreSQL/PostGIS database, and visualized the resulting prediction using Quantum GIS connected to my PostGIS store.  The following image was exported from QGIS:

  

The image shows the Philadelphia zip codes, the local roads network of Philadelphia, and the new prediction as a red gradient where the deeper the red the more likely a crime will occur at that location according to the prediction.