We worked on an automated system for monitoring, analyzing, and managing road traffic. The El Pixel team was responsible for migrating data from the previous system, handling traffic violations, API integrations, reporting, and application management tools.
Challenges
- Data migration. Data had to be transferred from the previous system to the new one, including moving some data and indexes from a non-relational database to a relational database.
- Traffic violation handling. The system needed to support the detection of traffic violations and further processing of fines.
- Integrations and system management. Data exchange with other systems had to be organized through APIs, along with reporting and application management tools.
Solutions
- Data and storage structure migration. We migrated data from the previous system and transferred the required indexes from a non-relational database to a relational database.
- Violation processing. We implemented functionality for handling detected traffic violations and issuing fines.
- API integrations. We integrated the required APIs to exchange data with other systems and services.
- Reporting and management. We implemented tools for working with the system, generating reports, and administration, and also prepared technical documentation.
Result
As a result, a new version of the system was prepared with migrated data and an updated storage structure. The system supports processing traffic violations and issuing fines, exchanges data with external services via APIs, and provides tools for reporting and administration.