In this post, I will give a semi-detailed overview of how to make an animated heat map over a time range. This is my first attempt at making an animated heat map.
I will be revisiting Chicago crime statistics from City of Chicago Data Portal 2001-2013
This dataset reflects reported incidents of crime (with the exception of murders where data exists for each victim) that occurred in the City of Chicago from 2001 to present, minus the most recent seven days.Data is extracted from the Chicago Police Department’s CLEAR (Citizen Law Enforcement Analysis and Reporting) system. Read More about the dataset here
On 11/28/2013 I downloaded a csv from chicago’s data portal named Crimes_-_2001_to_present.csv, its size was 1,050,688 KB
Here is an example of how I would parse out all coordinates of narcotics violations for the month of January in 2013.
Okay, now I’m going to manually make one of these images (with static center and size) for each month from January 2012 to October 2013. Next, I wrote a quick c# application using ImageMagick to programmatically crop each Browser screenshot.
The dataset details 2014 Budget Recommendations, which is the line-item budget document proposed by the Mayor to the City Council for approval. Budgeted expenditures are identified by department, appropriation account, and funding type: Local, Community Development Block Grant Program (CDBG), and other Grants. “Local” funds refer to those line items that are balanced with locally-generated revenue sources, including but not limited to the Corporate Fund, Water Fund, Midway and O’Hare Airport funds, Vehicle Tax Fund, Library Fund and General Obligation Bond funds. Owner: Budget and Management. Frequency: Data is updated annually. For more information about the budget process, visit the Budget Documents page:
Here is a breakdown of the 2014 recommendations compared with revised 2013 appropriations by department.
Over 10 million dollars and excluding Finance General
Here’s Financial General
Breakdown of Financial General
Police Breakdown excluding Corporate Fund
Police Corporate Fund
Department of Transportation
Office of the Mayor
City of Chicago Budget – 2014 Budget Recommendations vs 2013 Revised Appropriations OFFICE OF INSPECTOR GENERAL (APPROPRIATION AUTHORITY) by APPROPRIATION ACCOUNT DESCRIPTION
This dataset is a listing of all current City of Chicago employees, complete with full names, departments, positions, and annual salaries. For hourly employees the annual salary is estimated. Data Owner: Human Resources. Frequency: Data is updated quarterly.
Dim con As System.Data.OleDb.OleDbConnection
con = New System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;"
& "data source=C:\ExcelFile.xls;Extended Properties=Excel 8.0;")
Dim dtSheets As DataTable =
Dim drSheet As DataRow
ForEach drSheet In dtSheets.Rows
''Here are all your possible worksheets.
This dataset displays location for vehicles that have been towed and impounded by the City of Chicago within the last 90 days. Illegally parked vehicles, abandoned vehicles and vehicles used for illegal activities may be towed by the Chicago Police Department, the Department of Streets and Sanitation, the Department of Revenue, Aviation and the office of the City Clerk.