Lets look at recent crime in Orlando and adjacent cities. What can we find out by exploring Orlando’s crime data? Is the Central Florida area a relatively safe place? Can we tell from 90 day’s worth of day? Are some areas safer than others? Do we have any false ideas about places in Orlando?
At the very least, lets attempt to get a better understanding of the crime issue which affects us everywhere.
About The Data
The data used in this post can be obtained here.
Orange County provides 90 days of property crimes and robberies for Orange County. The set in this post was fetched on Oct 24th, 2014. Orange County does not provide records for any other crimes online. Phone calls inquiring for other crime types went unanswered.
Primary Data – The following primary information is provided in this dataset.
1. Zone – Orange County is geographically divided into 6 Patrol Sectors. Each of these sectors is, in turn, divided into Zones.
2. Case Number – This is the number assigned to the case for identification.
3. Crime – This is the type of crime reported.
4. Location – This is the location where the crime took place in the form of “Street Number Range – Street Name”.
5. Date – This is the date the crime is reported to have occurred.
Derived Data – From these, we can derive the following without much trouble.
1. Patrol Sector – These are grouping of patrol zones. Some information about each zone can be found here.
2. Zip Codes for Orange County – These will be used to define the geographical area or Orange County. Go here for zip code/city list used.
These zip codes define both the patrol zones above, as well as, Orange County, Florida.
3. Day Of Week – From the date of the crime, we can obtain the day of the week the crime occurred.
4. Street Address, Approximate – Approximate address has been obtained by choosing the midpoint between the street number range given in Location.
5. State – Florida.
Putting approximate street address in Google Refine, we invoke the Google Maps API to obtain gegeospatialnformation for said address. The api will return an object which contains a wealth of information such as geographical coordinates, names, etc.
First of, lets create a new column in Google Refine to hold this object. From ‘Approximate Address (+ State)’, lets generate a new column from column from URL using the following call
‘http://maps.googleapis.com/maps/api/geocode/json?’ + ‘sensor=false&’ + ‘address=’ + escape(value, ‘url’)
Note 1 – Watch your limits, depending on the amount of records to be processed, you may run into Google Maps API limits as I did.
“”error_message”” : “”You have exceeded your daily request quota for this API.””,
“”results”” : ,
“”status”” : “”OVER_QUERY_LIMIT””
Setting up DataScienceToolkit for next time!
Note 2 – Almost a third of the data came back incomplete or needed further cleanup to be usable, ymmv.
From new column, we simply retrieve data as needed from the newly created column from api call.
7. Zip code
8. Complete Address
The end result looks like this.
Here‘s download link for this data, enjoy.
Exploring The Data
Crimes By Day Of Week – The distribution of crimes over the day of the week looks uniform. Friday is the most active day with 15.5% of crimes committed and Saturday the least active with 12.8%.
Looking at the second chart, however, clearly shows Friday Monday and Tuesday are the days of the week with the highest number of crimes. Also, we can see Saturday and Sunday are the days with the lowest crimes committed.
Crime Activity By Crime Type – For property crimes (remember the county does not willingly share other crimes), this is how crime frequency looks for the last 90 days of crime activity in Orange County.
We can also see the crime types by city for all of Orange County. The number on the chart is the actual count for the crime type of that color on legend.
In general thou, 68% of crimes are either residential or auto burglaries.
Cities Without Crime – It is interesting to report which city areas did not report any property crimes for the set provided. This list gives the zip codes for each city where we obtained no crime reports.
Crimes Over Time – I thought it would be interesting to see crimes over time so I grabbed this from Tableau with, clearly, limited success. I am not sure this brings any value to this post…
This is Orlando area, in a nutshell…
We can obtain a lot of information from the, already available, crime data for any city around the world. This was but a sampling of what we can do with readily available tools.
Thanks for reading.