[NEW REPORT] The State of European Energy Data Maturity - In-depth research with E.DSO and GEODE

Download here
Product

Open Data Use Case: Measuring Crime Rates in Chicago

We attended the ODI Summit a couple of weeks ago, and during a training session, a very interesting dataset was showcased: crime reports in the city of Chicago from 2001 to present.

Sales Director - North America, Opendatasoft
More articles

Throughout all our previous posts, we have introduced many major features of the Opendatasoft platform: APIs, advanced geo mapping, real-time datasets, user engagement…

Today, we would like to come back to the roots of the platform features: the ability to explore large datasets using full-text search, facetted search and data visualizations.

We attended the ODI Summit a couple of weeks ago, and during a training session, a very interesting dataset was showcased: crime reports in the city of Chicago from 2001 to present.

 

Copy to clipboard

As you can see below, the left column contains a set of filters that you can use to refine your current view. These filters are called facets. The whole set of facets gives a quite interesting summary of the dataset content. For instance we learn that 20% of the reported incidents are “thefts”. Facets can also be used to refine the view to only display records related to a specific facet or set of facets.

Copy to clipboard

An interesting feature as well is the ability to filter the results with a full-text query. The below states that 87k reported incidents are related to heroin. Of course, query terms can be combined together to build complex queries, mixing both full-text and numerical filters.

 

Copy to clipboard

Now, let’s switch to the map view. The first view displays the data geographically clustered. As you zoom in or out or as you move the map, the clusters adapt themselves to map position and zoom level in real time. And at the max zoom level, you have the ability to display detailed data. This view makes it possible to display on a single map and in a very efficient way hundreds of thousands or millions of records.

Copy to clipboard

The analysis view makes it possible to quickly build analytics visualizations. These are based on aggregations built on the facets. A wide set of display features are available: bar and stack charts, pie charts, timelines…

 

Copy to clipboard

And of course you can use our Cartograph and Chart Builder features to build much more advanced data visualizations.

 

As you can see, all these representations are built with standard features of the platform in a matter of seconds. Open data is often about small datasets but also sometimes about large or very large datasets. And having in such cases simple and scalable features to explore and visualize them is now a must-have for an open data platform.


Learn more
2023 Open Data Maturity Report: the importance of data portals Data Trends
2023 Open Data Maturity Report: the importance of data portals

What is the state of open data maturity across Europe? We analyze the latest EU Open Data Maturity Report to understand progress to date and where countries need to focus to increase data sharing and enable data democratization.

How local government can build trust through transparent data sharing Open data & transparency
How local government can build trust through transparent data sharing

Around the world, trust levels between government organizations and citizens are dropping. Rebuilding trust relies on greater transparency - we explore the importance of data sharing to the process and outline how municipalities can create effective open data portals to strengthen engagement with their stakeholders.

5 key types of dataset for your municipality to share Public Sector
5 key types of dataset for your municipality to share

To drive usage of your city or town’s data portal you need to publish information residents and visitors want to see, accessible in ways that best meet their needs. Based on analysis of our North American customers, we pinpoint the most popular datasets you should look to share.

2023 Open Data Maturity Report: the importance of data portals Data Trends
2023 Open Data Maturity Report: the importance of data portals

What is the state of open data maturity across Europe? We analyze the latest EU Open Data Maturity Report to understand progress to date and where countries need to focus to increase data sharing and enable data democratization.

How local government can build trust through transparent data sharing Open data & transparency
How local government can build trust through transparent data sharing

Around the world, trust levels between government organizations and citizens are dropping. Rebuilding trust relies on greater transparency - we explore the importance of data sharing to the process and outline how municipalities can create effective open data portals to strengthen engagement with their stakeholders.

5 key types of dataset for your municipality to share Public Sector
5 key types of dataset for your municipality to share

To drive usage of your city or town’s data portal you need to publish information residents and visitors want to see, accessible in ways that best meet their needs. Based on analysis of our North American customers, we pinpoint the most popular datasets you should look to share.