Is there a relationship between car robbery and street lighting?

The last article was related to robbery and theft cars registered in the Police Department in the year of 2017. This article wants to check if there is a correlation between car robbery and less street lighting.

The Figure 1 bellow shows concentration of car's robbery per neighborhood. A neighborhood filled in black doesn't have any records. Soft yellow are neighborhood with less records, going up to orange dark…

Moving forward with crimes committed analysis in São Paulo city, this time I studied vehicles robbery and theft registered in São Paulo Polices Stations in 2017. First of all, it's worth to explain the difference between robbery and theft. Robbery is a crime committed with violence or threat. Theft doesn't involve violence or threat. Now, talking about the study, a robbery heat map is presented below:…

I believe in the potential of analyzing public data, so I conducted an analysis of the data on rapes and thefts registered in the 93 Police Stations (PSs) of the city of São Paulo. The balls in the maps below represent the location of the PSs, and the size is proportional to the amount of occurrence recorded in the PS. The first figure shows the distribution of rapes. Since July 2001, offenses have been transferred to the closest PS to the crime scene, even if the incident report is…

Today I'm writing this post to explain how it's possible to make geographic analysis and answer questions like: which is the richest area in my city? How many people do live in one neighborhood? 

You can do it combining shape files with an excel spreadsheet, let's understand it together...

First of all, we need to install one Geographic Information System (GIS), and I recommend QGIS - free and open source GIS

Then,…