The Afvalstoffendienst ’s-Hertogenbosch manages 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, ranging 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 utilisation.
This results in reliable dashboards, work process applications, and APIs that the entire organisation uses for daily steering, from the operations 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 operations office, tactical planning, scheduling, the recycling centre, and the HW (Hazardous Waste) department all work with the same underlying data, each from their own perspective—whether strategic, tactical, or operational.
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.
Clear, the ERP system that forms the administrative and financial foundation of the organisation
Webfleet, featuring vehicle and route data from the waste collection fleet
Waste Vision, for collection on routes and at underground containers
Together, these sources record the complete process, from weights between collection and processing and emptyings per container and per round, through driven trips, vehicle movements, and separated fractions, to visits and processed volumes at recycling centres and the subsequent analyses and route optimisations.
Jama, for collection on routes and from underground containers
Welvaarts, with weighing data on the vehicles
Signals, featuring reports from public spaces and residents
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 consistently interpreted by everyone. In practice, this means toggling between disparate systems to piece together a complete picture, while 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 occurring within the waste management chain, from the moment a container is emptied to its processing at the recycling centre.
This lakehouse is not an additional layer on top of an external platform, but a fully integrated component of Clappform itself. The same functionality expected from an environment like Databricks is built directly into our low-code data platform, developed with minimal manual coding. This includes data ingestion, transformation, storage, governance (the policies governing data management and access), and model-based processing. Consequently, the waste management service (Afvalstoffendienst) does not need to manage or connect a separate lakehouse environment; everything remains 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 control:
For management, this involves strategic and tactical steering information regarding performance, trends, and progress at the organisational level. Operational teams utilise dashboards that are closer to daily activities, featuring scheduling, capacity, and progress per process.Workflow applications for operations:
In addition to providing insights, Clappform builds applications that direct the work itself, featuring ERP-like functionality for tasks such as container management. This makes the platform more than just a reporting layer. It serves as a working environment where employees perform their daily duties, supported by underlying data that is always current and consistent.APIs for accessibility and integration:
Clappform also delivers the underlying data via APIs as independent data products. An API is an interface through which systems exchange data. This allows other systems and applications, including those outside the waste management service, to directly access the same current and reliable figures. This eliminates the need for manual data re-entry, making the lakehouse not only a source of insight but also a foundational block for further system integration.
The result
By consolidating all source systems into a single lakehouse, no one within the Waste Management Service needs to switch between disparate systems to obtain a complete overview. Dashboards, operational process applications, and APIs all utilise the same data. Decisions at every level are therefore based on up-to-date and consistent figures, from daily scheduling to management steering, and other systems reuse the same source without duplicating effort. The result is an organisation that manages collection, processing, and service delivery with greater oversight and control, driven by 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.
Case study
Case Studies
