GPS Driver Tracking Web Application

**** If you do not read my specification first, then please don't bid After you're done reading, please say I am the best person for the right job because…. If this sentence is not added to your opening bid, you will not be accepted. Driver Location Tracking System Objective: Develop a real-time driver location tracking system using Google Maps, MySQL, Python, and Bootstrap. Technical Stack: • Backend: Python (Flask framework) • Database: MySQL 8 • Frontend: HTML, CSS (Bootstrap) • Maps: Google Maps Platform Functionalities: • Driver Location Tracking: o Drivers share their location with the system by granting location access to a designated Google account (company profile). o System retrieves driver location (latitude and longitude) using the Geolocation API at a 10-minute interval. o Location data is stored in a MySQL database. • Real-time Visualization: o A user interface (UI) displays a map with markers representing driver locations on a Google Map. o The map updates automatically every 10 minutes to reflect the latest positions. Frontend - User Interface (UI): • Utilize Bootstrap for a responsive and user-friendly UI. • Display a Google Map centered on the company's location (configurable). • Markers representing drivers should be displayed on the map. • Consider adding tooltips with driver information upon hovering over a marker (optional). Backend - Server-side Logic: • Develop a Flask application: o Handle API requests from the frontend to retrieve driver locations from the database. o Implement a background task (using a scheduler like Celery) to periodically fetch driver locations using the Google Maps Geolocation API with proper authentication (OAuth 2.0). o Store retrieved location data in a MySQL database (consider using an ORM like SQLAlchemy for easier data manipulation). Data Storage: • Design a MySQL database schema to store driver information (ID, name) and their corresponding location data (timestamp, latitude, longitude). • Implement secure data storage practices (e.g., user authentication, data encryption). Google Maps Platform: • Obtain a Google Maps Platform API key and enable the Geolocation API in the Google Cloud Console. • Refer to the official documentation for detailed instructions: [login to view URL] Deployment: • This system can be deployed on various platforms depending on your needs. Consider cloud platforms like Google App Engine or AWS for ease of scaling and maintenance. Additional Considerations: • Security: Implement robust security measures to protect user privacy and data integrity. This includes user authentication, authorization, and data encryption. • Error Handling: Implement proper error handling mechanisms to gracefully handle potential issues like API calls failing or database connectivity problems. • Scalability: Consider future scalability needs and design the system with potential growth in mind. • Testing: Implement comprehensive unit and integration tests to ensure the system functions as expected. Code Ideas: • Utilize Flask-SocketIO for real-time communication between the server and client, potentially offering a more dynamic map update experience. • Explore integrating additional functionalities like route optimization or geofencing.