City of Chicago has been opening-up its technology and data so others can build amazing apps and services. Just like the people and companies who built a world-class architecture on city-build roads, Chicago open data and APIs let you can build world-class software on top of it. Now, residents have access to bus trackers, plow trackers, and new ways to report 311 requests on their phones and computer. These services make it easier to live and visit the city.

Redesigned website on a laptop computer

A big part of this is ensuring software developers have access to the information and documentation needed to build these services. We have launched a completely redesigned to help discover APIs and documentation in a central location. Now, there is a comprehensive place to find city-supported APIs and platforms that the City of Chicago and its sister agencies offer to the public. For instance, details on the Open311 API–which allows apps to create new 311 requests in city databases–is documented here.

Dev Blog

The site also includes a new blog aimed for software developers and data scientists. Dev Blog lets you know about upcoming changes that might impact existing apps and also give updates on outages or maintenance schedules. Unlike this blog, Dev Blog is targeted to engineers who need the technical details to keep their app updated and users happy.

As part of this, the Chicago Data Portal Status Blog has been retired and moved to the new Developer Blog. We’ll post any technical changes to the portal and let you know of outages as before. New posts will also be Tweeted from @ChicagoCDO.

Finally, the new website is open source, based on Jekyll. If you spot any problems with the website, such as type-o’s or other issues, we’d welcome your contributions on our GitHub site.

Feel free to reach out to us with questions or feedback through Twitter or email.


Featured image “O88/365: New Construction” © Don Harder 2017 and is licensed under Creative Commons Attribution-NoCommercial 2.0 Generic (CC BY-NC 2.0).

Although data portals offer a variety of tools to examine datasets, the ultimate “open” in “open data” is the ability to export the data to a file and do as one wishes with it.  However, this can get challenging with very large datasets, particularly over slower Internet connections.  It can also be inefficient if one needs only a portion of the data.

There are a number of techniques to attack this problem but a particularly good, yet frequently overlooked, one is to use the filtering at the core of a Data Lens page (often called a “Dashboard” on the Chicago Data Portal).

Using an example that comes up frequently in questions from our users, our Taxi Trips dataset contains over 107 million trips, as of this writing.  Downloading the full dataset in CSV format could take hours over even a fast connection and produce a very large file.

Suppose that you only needed the records from the last three months of 2016.  You may know that you can easily filter the Data Lens view to show those records.  Simply hover over the October 2016 slice on any of the time-based cards, click, drag across November and December, and release.  You have now selected approximately four million trips.

Image of a Data Lens card where October 2016 through December 2016 has been selected.

Using Data Lens to select three months of trips.

However, this is only the start.  Not only can you view those trips within the page — including how they affect other cards — but you can also export just those records.  To do so, click the Export button at the top of the page.  It will default to export all records but you can change that option to export only the currently selected records.

Screenshot of the Data Lens Export button, showing the option to download only selected records.

Data Lens Export button, showing the option to download only selected records.

You can even apply multiple filters.  If all you really need is trips from those three months originating in Logan Square, apply that filter, as well, on one of the map cards.

Screenshot showing filtering to just Logan Square pickups.

Filtering by Community Area

The download now becomes a very-manageable 24,963 records that download in a matter of minutes or seconds to a file under 10 MB in size.

As mentioned above, there are other ways to filter a large dataset.  For some more-complicated needs, it may be helpful to use them and they can be very powerful.  However, to make one or a few quick slices of a dataset and download the results, it is hard to beat the convenience of the graphical filters in a Data Lens page.

Feature image by luckey_sun and is licensed under Creative Commons Attribution-ShareAlike 2.0 Generic (CC BY-SA 2.0).

The City of Chicago has launched the newest Energy Benchmarking data as part of the Energy Benchmark ordinance passed in 2013, which includes information on energy consumption, size of buildings, ENERGY STAR® rating and more. For the first time, the data now includes residential buildings over 50,000 square feet. Nearly 2,700 properties are available in the data set, which was released alongside the most recent edition of the Chicago Energy Benchmarking Report for 2016.

Chicago Energy Benchmarking – 2015 Data Reported in 2016 – Map

Transparency on energy consumption data has always been a part of the Energy Benchmarking ordinance, where updates are published to the open data portal each year; allowing researchers, engineers, policymakers, and others to see and understand energy consumption of Chicago’s largest buildings. In 2014, the City released a 3D interactive energy map based on citywide energy consumption data as of 2010.

Read more about the Energy Benchmark ordinance, the findings, and data on its homepage.

Feature image by Jesse Collins and is licensed under Creative Commons Zero 1.0 Universal (CC0 1.0).

(c) 2014. Sean MacEntee. Licensed under CC-BY-2.0Did you notice it? Chicago’s main webpages were are safer and more secure than they were in 2016. Chicago’s homepage is now using “HTTPS” for its visitors. Things will not look different, but it provides a number of benefits for those visiting Chicago’s home pages. Now when visitors visit and select city websites, the connection will be secure so others cannot snoop or steal information being sent between users and the City of Chicago. Everything is encrypted between your device and the City of Chicago so it can even keep your information private when you are on a wireless connection.

City of Chicago websites will also be easier to find because sites using HTTPS are preferred by Google. In the future, encryption will allow webpages to load faster. New web standards, such as SPDY, are much faster and will only work with secure websites.

You may also notice that other websites you use, such as Facebook, Twitter, and Google also use HTTPS. Secure websites are becoming more important and now City of Chicago websites provide the same level of trust and privacy each time you visit the site. We have a few websites still being transitioned to HTTPS, just look for the padlock icon in your address bar.

OpenGrid was launched almost one year ago. Since that time, users have been providing feedback on how the platform can be even easier to navigate their neighborhoods. Over the past few months, the team has continued to focus on bettering the user experience and making data more easily accessible to the user as they navigate around the map. Users have told us that it took too many clicks to see data. For instance, users would need to click the “Find Data” to anytime they moved the map to get updated data.

The latest version of OpenGrid will now refresh each time the map is moved. You will no longer need to manually re-run your search when you want to see data for a new area. Each time the map moves or you zoom in or out, OpenGrid will instantaneously refresh with the newest data. Simply choose the data you want to see, click “Find Data” once, and you can explore Chicago.

The number of clicks needed to retrieve data has been significantly reduced in the last few months, making it easier to get data but still allowing powerful searching across over two dozen data sets.

OpenGrid in 2017

New features will be rolled out to OpenGrid team through 2017.  In the next few month we are aiming to add some new features:

  • Implement bubble plots on the map—The bubbles will vary in sized based on a numeric value associated with queried data. Consider, plotting the potholes in the city. It would be useful to be able to plot the site of the circle to correspond to the number of potholes filled on the block.
  • Display data with parent-child relationships
  • Graph time-series data
  • Improve the ability to share queries

Interested in contributing to OpenGrid?

If you’re interested in collaborating with the city, you can take a look at the past meeting notes on the project’s Wiki. While the source code is online, the project’s documentation gives a concise overview for developers. Likewise, look at the instructions for contributors to help us run a useful, collaborative project.

Chicago residents and visitors took more than 27 million taxi rides in 2015, traveling 83 million miles and spending more than $400 million.

The City of Chicago assures the quality and safety of those rides through its Department of Business Affairs & Consumer Protection (BACP).  We have long published the taxi drivers and vehicles licensed by BACP on the Chicago Data Portal.

As part of its mission, BACP is also authorized to collect information on taxi rides, themselves.  It does so through periodic reporting by two major payment processors believed to cover most taxis in Chicago.  Based on these reports, we are now able to provide a dataset of over 100 million Chicago taxi rides, dating back to 2013.

Chart of rides per month

Rides Per Month


Back in April, the City of Chicago partnered with one of the Smart Chicago Collaborative anchor programs, the Civic User Testing Group (CUTGroup), to host a UX testing feedback session attended by more than 20 Chicago residents for OpenGrid. The purpose of these tests was not only to engage all of Chicago in the civic app development process, but provide valuable information to OpenGrid developers seeking to enhance the apps’ usability and performance. The newest version contains improvements to OpenGrid to make it easier to use. The latest release contains friendlier language, an improved user interface to highlight more important features while deemphasizing more technical options, and reducing the number of mouse clicks to see data. Below are some of the highlights of this release.

Simpler Advanced Search Panel

More Accessible Language throughout the application

During the CUTGroup testing, we saw that there were some opportunities to make the language more accessible. Users commented that the language throughout the application seemed to be targeted more towards developers and people with tech backgrounds. For example, in the Advanced Search panel, language such as “Geo-spatial filters” and “Queries” seemed to cause some hesitation to users.  Therefore, we simplified the language to make it more user friendly. “Advanced Search” was changed to “Find Data,” “Datasets and Standard Filters” was changed to “Select Data,” and “Submit” and “Reset” were changed to “Get Data” and “Clear Search” respectively.

Submit and Reset buttons are now set as footer

Previously, users would have to scroll to the bottom of the advanced search panel to run or clear a search. Now these buttons are static at the bottom of the page for easier accessibility.


Color coded dots for each dataset

When multiple datasets are added to a search, the dots for each dataset are now assigned a different color by default. Now that the user doesn’t have to manually assign a new color, we have cleaned up the advanced search panel to retract the color and opacity under “Color Options.”


Advanced Search Panel Retracts After Executing Query

To maximize the amount of data viewable to the user upon executing a search, the advanced search panel now retracts upon performing a search.

The ability to perform searches using OR

When applying filters for a dataset, users were only limited to applying an “AND” operator, now users can select “OR.”

Easier-to-read Map

Map Icons More Accessible

Users no longer have to retract the Find Data Panel in order to apply a layer or create a measurement on the grid. The layers and measurement icons have been moved to the boot left of the map for easier access.


More Prominent Grid View

As seen in the screenshots above, we have changed the grid view access bar to a bold and black color, whereas previously it was gray and overlooked by users.

Map Extent by Default

When performing a search, all of the data is limited to a default geographical area shown on the map (i.e. map extent). The map extent is now setup to return results of the area that is currently visible on the grid. For example, if a user pans or zooms in to the Loop or Humboldt Park area and runs a quick search on crimes or fires, the results will return within the area that the user extended on the map.

Note: The default map extent does not apply when searching for points of interest like Starbucks, McDonalds, etc.

New Base Map

The new base map is now lighter and has a better contrast quality, allowing users to see the data displayed on the grid more clearly.

Map Legend

The map legend displays all of the datasets that were included in the users search. It appears at the bottom right of the grid when an advanced or quick search is executed.


Future of OpenGrid

To continue our efforts in improving the user experience, the team is working towards making the map more responsive as users move around the city. As the user drags the map, the query will refresh to the new map extent. The team is also working towards upgrading Leaflet to v1.0 (previously v0.7) as well as all dependent plugins. Lastly, we will also be improving the Quick Search feature to allow users to perform multiple quick searches as well as perform a quick search along with an advanced search (now called, “Find Data”).

Interested in contributing to OpenGrid?

If you’re interested in collaborating with the city, you can take a look at the past meeting notes on the project’s Wiki. While the source code is online, the project’s documentation gives a concise overview for developers. Likewise, look at the instructions for contributors to help us run a useful, collaborative project.

Earlier this month, Mayor Emanuel and Mayor of London, Sadiq Khan visited toured Chicago’s tech centers, including 1871 and UI Labs to look at Chicago’s startup culture and data-driven innovation. Chicago and London signed a data alliance for “bi-lateral relationship to enable the exchange of knowledge and expertise with the intention of driving expanded growth and opportunity for all people in the two cities.” The two cities will sharing solutions to avoid duplication and share ideas on how to use data within large cities.

White House highlights Chicago data and technology initiatives

  • Array of Things are being installed across Chicago to collect environmental, noise, density and other data that is designed to improve the city and is limited to protect individual privacy. The data will be made publicly available online. You can now follow along when new nodes are installed on the open data portal. See a map of new locations.
  • Digging for the next innovation! An underground utility is struck every 60 seconds in the United States, causing billions in damage. Chicago partnered with UI Labs’ City Digital and a consortium to build and pilot new technology to scan and map underground infrastructure. Take a look at the video to show how this information can be browsed in the future.

[iframe width=”720″ height=”460″ src=”//″ frameborder=”0″ allowfullscreen]

  • The White House highlighted Array of Things and the Underground Mapping project as examples of innovative programs as part of their $80 million expansion of investments in the Smart Cities Initiative.

Redesigned websites ready for public feedback

Screenshot of the new open data portal

  • Chicago’s Annual Financial Analysis report went digital for the first time this year. The report was assembled using open source and available tools, suck as Jekyll and GitHub, forgoing more costlier methods.
  • Chicago has released a half-dozen APIs in the past 5 years. A beta of a new developer portal is now available to connect developers and researchers with documentation and updates to those services. You can reach out to to provide your thoughts.

Open Data Portal continues to expand

  • Dozens of new education-related data sets are on the open data portal. See maps of school locations for the past 10 years, school profiles, and much more.
  • Business Activity codes — which describe what a business does — has been added to the open data portal’s Business Licenses data set.

Chicago is leveraging open data as part of it’s predictive analytics

Chicago’s Chief Data Officer spoke with Manhattan Institute’s Aaron Renn on the intersection of open data and predictive analytics in a recent podcast:

[iframe width=”100%” height=”166″ scrolling=”no” frameborder=”no” src=””]


Banner image “Great Lakes in Sunglint” by NASA (c) 2012 and licensed under Creative Commons Attribution Non-Commercial 2.0 (CC BY-NC 2.0)


This Friday, Chicago’s open data team will be presenting a free workshop on how to use the city’s open data portal. The data portal contains a wide range of data, from liquor licenses, building permits, incidents of crimes, school profiles, and much more. You will see how you can search and find data related to your community and the ability to make maps and graphs using this freely accessible data. You don’t need to be an IT professional or a researcher to work with data from the portal and this workshop will help connect you with data about your school, business, and community.

Register for the event here. It’s free and open to the public.

If you cannot make the workshop, you can see other tutorials on the data portal from the team’s YouTube channel:

[iframe width=”720″ height=”460″ src=”//″ frameborder=”0″ allowfullscreen]