easy-to-use stream processing for Smart Cities

Combine raw data (waste and lighting networks, road and vehicle status, social media and geolocation sensors, public call systems and alerts, seismic and weather data) and stored data (traffic and maintenance reports, demographics, seismic and weather data) to decrease traffic congestion, reduce pollution and system outages, and optimize utilization of services through an integrated, multi-modal platform for monitoring and control.

A full-cycle smart city platform

Smart City technology is dependent on effective use of both the data and the communications network infrastructure. Traditional solutions struggle to scale with the rapid increase in data volume, and struggle to deliver the real-time responses that are essential to ensure the Smart in “Smart Grid” and “Smart Transportation”. 

SQLstream integrates all real-time public and private transportation and smart city data sources on a single platform, delivering real-time intelligence and streaming analytics to your operations centers, planning teams and website applications, as well as driving real-time web APIs to support device and smartphone app development.

the challenges of wrangling, analyzing, and acting upon smart city data in real time

Real-time data wrangling

  • Too many data sources, too far apart
  • Collection and data transport not secure
  • Too many data formats
  • Variable bandwidth conditions
  • Data volumes too volatile
  • Volume too high for real-time responsiveness
  • Not all data is relevant
  • Interruptions 

Streaming data analytics

  • Results take too long
  • Results are not easy to access
  • Results are confined to a specialized crew
  • Development takes a long time
  • Development is dependent on skill sets
  • Data manipulation cannot be done on-the-fly

Real-time, third-party integrations

  • Visualizations are not real-time
  • Visualizations are not customizable
  • Insight cannot trigger alerts
  • Insight cannot trigger automated actions
  • Consumer-facing interactions are delayed


Case study: real-time traffic control

Roads and Maritime Services (RMS) is the Australian government agency responsible for managing transportation and delivering customer- focused services, in a cost-effective manner, to people who use roads, harbors and waterways- in total, over 2 Million travelers in the New South Wales region.

When population and business sector growth in Sydney has led to a sharp increase in road network congestion (threatening with financial losses upwards of $4B), the agency realized that traditional traffic monitoring platforms would not deliver significant or cost-effective reductions.

read more


Guavus SQLstream is free to download and use up to 1GB/day (after which it throttles).