Project Description:

The Smart Waste Collection Management System is a web platform for municipal authorities and private waste collection agencies to digitize the process of waste pickup scheduling, tracking collection vehicles, and managing user requests. Citizens can raise pickup requests, track status, and provide feedback.

User Roles:

1. Admin:

   • Register and manage collection vehicles and drivers

   • View pickup requests and assign vehicles

   • Monitor collection status and generate reports

2. Driver/Collector:

   • Log in to view assigned pickups

   • Update collection status (pending, collected)

   • Record waste quantities

3. Citizen/User:

   • Register and log in

   • Request waste pickup

   • Track request status and estimated arrival

   • Submit feedback after collection

Core Features:

Pickup Request Management:

• Citizens create a pickup request specifying waste type (general, recyclable, hazardous)

• Admin assigns vehicles and staff

Vehicle & Route Management:

• Maintain vehicle records and driver profiles

• Assign optimized routes to drivers

Status Tracking:

• Driver updates status in real-time (on the way, collected)

• Users receive notifications about pickup progress

Feedback & Reporting:

• Citizens rate the service

• Admin views analytics (number of pickups, types of waste, feedback ratings)

MySQL Tables:

• users

• vehicles

• drivers

• pickup_requests

• routes

• feedback