Download PDF
ACI Consult gets traffic under control with QlikView
Technology Category
- Analytics & Modeling - Real Time Analytics
Applicable Industries
- Cities & Municipalities
- Transportation
Applicable Functions
- Logistics & Transportation
Use Cases
- Real-Time Location System (RTLS)
- Traffic Monitoring
Services
- Data Science Services
The Challenge
ACI Consult, a member of the Automobile Club d’Italia (ACI) group, was originally founded to handle ACI operations in the area of transport engineering. Since 2003, the company has been responsible for designing, developing and creating innovative traffic-control services, regional and environmental services, urban furnishings and lowimpact technologies. Among its more innovative initiatives, ACI Consult has been involved in ACITRAFF, a project intended to provide a great many regional bodies with targeted traffic reports in order to analyze traffic patterns and plan infrastructure projects. ACITRAFF monitors traffic flows and uses sensors positioned along the main roadways in order to gather data on the number of vehicles, their speed, their size and traffic congestion, so as to provide accurate, up-to-date traffic information. The ACITRAFF architecture is comprised of peripherals, including active and passive optical sensors, that communicate with one or more dataprocessing centers using a variety of communication networks (phone, cable, radio, GSM, GPRS, etc.). The system gathers data on an ongoing basis and sends it to a central database, which is then used for studies and subsequent traffic planning.
About The Customer
ACI Consult is a member of the Automobile Club d’Italia (ACI) group. The company was originally founded to handle ACI operations in the area of transport engineering. Since 2003, ACI Consult has been responsible for designing, developing and creating innovative traffic-control services, regional and environmental services, urban furnishings and lowimpact technologies. ACI Consult identifies critical issues, arranges for advanced multi-purpose technologies and provides government agencies with solutions that save energy. Among its more innovative initiatives, ACI Consult has been involved in ACITRAFF, a project intended to provide a great many regional bodies with targeted traffic reports in order to analyze traffic patterns and plan infrastructure projects.
The Solution
ACI Consult chose to use QlikView’s leading in-memory business analysis suite to manage the innovative ACITRAFF traffic analysis data in real time. QlikView’s strengths include QlikTech’s patented innovative technology, which makes it possible to create a natively multi-dimensional, high-capacity, in-memory associative database that is highly efficient. Therefore, unlike with more conventional OLAP analyses, it is unnecessary to define aggregations, selections, hierarchies or inquiry paths in advance. A specific application was created that uses the basic data gathered by the sensors and analyzes processes. It aggregates this data in order to present a variety of charts and tables to the user, which can then be used to meet any research need in a simple, intuitive manner. The system, which includes a speciallydesigned interface and customizations developed by ACI Consult, makes it possible to monitor traffic flows and to analyze vast quantities of data, such as the total and average number of vehicles, average speeds by day and by night and the level of traffic congestion.
Operational Impact
Related Case Studies.
Case Study
Turning A Stadium Into A Smart Building
Honeywell created what it called the “intelligent system” for the National Stadium in Beijing, China, turning the venue for the opening and closing events at the 2008 Summer Olympics into a “smart building.” Designed by highly controversial artist Ai Weiwei, the “Bird’s Nest” remains one of the most impressive feats of stadium architecture in the world. The 250,000 square meter structure housed more than 100,000 athletes and spectators at a time. To accommodate such capacity, China turned to Honeywell’s EBI Integrated Building Management System to create an integrated “intelligent system” for improved building security, safety and energy efficiency.
.png)
Case Study
Smart Street Light Network (Copenhagen)
Key stakeholders are taking a comprehensive approach to rethinking smart city innovation. City leaders have collaborated through partnerships involving government, research institutions and solution providers. The Copenhagen Solutions Lab is one of the leading organizations at the forefront of this movement. By bringing together manufacturers with municipal buyers, the Copenhagen Solutions Lab has catalyzed the development and deployment of next-generation smart city innovations. Copenhagen is leveraging this unique approach to accelerate the implementation of smart city solutions. One of the primary focus areas is LED street lighting.
Case Study
Airport SCADA Systems Improve Service Levels
Modern airports are one of the busiest environments on Earth and rely on process automation equipment to ensure service operators achieve their KPIs. Increasingly airport SCADA systems are being used to control all aspects of the operation and associated facilities. This is because unplanned system downtime can cost dearly, both in terms of reduced revenues and the associated loss of customer satisfaction due to inevitable travel inconvenience and disruption.
Case Study
IoT-based Fleet Intelligence Innovation
Speed to market is precious for DRVR, a rapidly growing start-up company. With a business model dependent on reliable mobile data, managers were spending their lives trying to negotiate data roaming deals with mobile network operators in different countries. And, even then, service quality was a constant concern.
Case Study
Buoy Status Monitoring with LoRa
The Netherlands are well-known for their inland waterways, canals, sluices and of course port activities. The Dutch Ministry of Infrastructure indicates that there are thousands of buoys and fixed items in and near water environments that would profit from IoT monitoring. One of the problems with buoys for example, is that they get hit by ships and the anchor cable breaks. Without connectivity, it takes quite some time to find out that something has happened with that buoy. Not to mention the costs of renting a boat to go to the buoy to fix it. Another important issue, is that there is no real-time monitoring of the buoys at this moment. Only by physically visiting the object on the water, one gains insight in its status.
