Smart Waste Management System

Total Bins

-

Active Bins

-

Open Complaints

-

Open Maintenance Tickets

-

Recent Pickups

Loading...

Recent Complaints

Loading...

Pickups per Route (last 7 days)

Shows how many pickups each route completed in the past week (counts from route_pickups).

Bins & Relationships

Explore how bins connect to zones, pickups, complaints, maintenance tickets, and sensor devices.

Bins

Loading...

Selected Bin Details

Select a bin to view relationships.

Create Complaint

Quickly log a new complaint for the selected bin (or choose any bin).

Routes & Pickups

View collection routes and their scheduled/actual pickups.

Routes

Loading...

Pickups for Selected Route

Select a route to view pickups.

Complaints & Maintenance Tickets

Monitor citizen complaints and technical maintenance tasks.

Recent Complaints

Loading...

Recent Maintenance Tickets

Loading...

Create Maintenance Ticket

Assign a maintenance task against a bin.

Data Explorer

Inspect raw tables from your database (useful for debugging/API design).

Table data