Analyzing 8 million data from public speed limit detectors radars

Analyzing 8 million data from public speed limit detectors radars

Organisation: El Confidencial (Spain)

Publication Date: 04/06/2017



Spain has a Freedom of Information Act for more than two years. Since then, El Confidencial Data Team has used it to gather data an important public documents. One of the best examples of the use of FOIA was the database obtained about the traffic sanctions due to exceeding the speed limits in 2013, 2014 and 2015. The Traffic Administration gave us a CD with three .txt files (one for each year), totalling nearly 8 million sanctions. Each registry of each sanction contains information about date, hour, road, kilometer, province, municipality, vehicle, radar, speed limit, speed, gravity of the sanctions, cuantity of the sanction, cuantity payed and points taken. All the information of the three txt files was uploaded in an unique PostgreSQL database to analyze it. The analysis was used to write three reports: the first one, an overview about 'When, where and hoy the radars caught the drivers who exceed the speed limits' (; the second one about the empty radar boxes, which we call 'ghost radars' (, and the third one about the differences between the fix radars and the mobile radars, which are managed by agents ( Although we did not upload the data to our Github due its size, we shared the data with three newspapers ofn Navarra (, Asturias ( and Granada (
Follow this project

Commentaires (0)

You have to be connected to contribute

You have to be connected to follow

Leave this project and no longer be informed about this project

By joining this project, you will be informed by email when an update or a new contribution is posted on the website.

Thank you for your active participation !

The GEN Community Team