From six fragmented source systems to a single, reliable overview of the entire waste chain.
The project
An organisation of this size generates large volumes of data daily. This data does not originate from a single system, but is scattered across six specialised source systems, each supporting its own part of the process.
This results in reliable dashboards, work process applications, and APIs that guide the entire organisation daily, from the administrative office to the recycling centre. The platform is not an isolated tool for a single department, but a shared foundation for the entire chain. The administrative office, tactical planning, operational planning, the recycling centre, and hazardous household waste (HHW) department all work with the same underlying data, each from their own perspective – whether strategic, tactical, or operational.
Applied data
The Afvalstoffendienst ’s-Hertogenbosch handles the collection and processing of household and commercial waste for the municipality of Den Bosch and surrounding areas. For this organisation, Clappform integrates all systems related to collection and processing, from ERP and vehicle navigation to weighing systems and recycling centres. All these sources are consolidated into a single data lakehouse, a central repository where all data is stored and prepared for use.
Clear, the ERP system that forms the administrative and financial foundation of the organisation
Webfleet, with the vehicle and route data of the waste collection fleet
Waste Vision, for collection on routes and at underground containers
Together, these sources record the entire process, from weights between collection and processing, and empties per container and per round, through completed journeys, vehicle movements, and separated fractions, to visits and processed volumes at recycling centres, and the subsequent analyses and route optimisations.
Yes, for collection along routes and from underground containers
Welvaarts, with weighing data directly on the vehicles
The challenge
As long as these systems remain disconnected, a comprehensive overview is lacking. Tactical and operational steering requires data from multiple sources simultaneously. This data must be accurate, up to date, and interpreted consistently by everyone. In practice, this means navigating between disparate systems before a complete picture can be established, even as each department views the same process from its own perspective.
Our solution
Clappform connects all source systems and aggregates the data into a single central lakehouse. This establishes a single, reliable, and up-to-date source of truth for everything that occurs within the waste management chain, from the moment a bin is emptied to the processing at the recycling centre.
This lakehouse is not a layer on top of an external platform, but a fully integrated component of Clappform itself. The same functionality you would expect from an environment like Databricks is built directly into our low-code data platform, where development requires minimal manual coding. This includes data ingestion, transformation, storage, governance (agreements on data management and access), and model-driven processing. Consequently, the Waste Management Service does not need to manage or connect a separate lakehouse environment, keeping everything within a single platform—from raw source data to analysis-ready data products.
From this lakehouse, Clappform builds targeted data products tailored to the users and the specific challenges they face. These data products broadly fall into three categories:
Dashboards for insight and management:
For management, this involves strategic and tactical steering information regarding performance, trends, and progress at an organisational level. Operational teams utilise dashboards that are closer to day-to-day operations, featuring scheduling, capacity, and progress per process.Work process applications for execution:
In addition to providing insights, Clappform also builds applications that drive the work itself, featuring ERP-like functionality to manage tasks such as container management. This makes the platform much more than a reporting layer. It is a work environment in which employees perform their daily tasks, supported by underlying data that is always up-to-date and consistent.APIs for integration and data sharing:
Clappform also delivers the underlying data via APIs as an independent data product. An API is an interface that allows systems to exchange data mutually. This enables other systems and applications, including those outside the Waste Management Department (Afvalstoffendienst), to directly use the same current and reliable figures. There is no need for manual data entry or retyping. Consequently, the lakehouse serves not only as a source of insight, but also as a building block for further system integration.
The result
By consolidating all source systems into a single lakehouse, no one within the Waste Management Service has to switch between separate systems to get a complete picture. Dashboards, work process applications, and APIs all draw from the same data. Consequently, decisions at every level are based on up-to-date and consistent figures—from daily scheduling to management steering—while other systems reuse that same source without redundant effort. The result is an organisation that steers collection, processing, and service delivery with greater oversight and control, all from a single platform for steering, execution, and integration.
Start today
How we assist municipalities with their data challenges
Within a municipality, various themes are at play: from housing and livability to sustainability, safety, and the social domain. These domains directly pertain to area development and require up-to-date, reliable data.
Whether it involves resource allocation, prioritizing policy interventions, or monitoring neighborhood developments, real-time insights help municipalities steer sharply, make well-founded decisions, and respond flexibly to change.
Clappform provides municipalities with a platform that translates complex data into clear, actionable insights. Through direct connections with data sources and thematic dashboards, the information seamlessly aligns with policy-related questions.
