/DBMS-project

Project to automate traffic rule violation detection

Primary LanguagePython

DBMS-project

Project to automate traffic rule violation detection

This project is done as part of LAB component of DBMS subject

Project contributors:
😃Jaikishan Jaikumar
😄Keerthan Kumar A
😉Mahendra Vishwakarma

Tools and Components


Backend - Flask and Flask_SQLAlchemy
Frontend - Flask, HTML and CSS
OCR using pytesseract
Databases - postgreSQL(SQL) and Elasticsearch(NoSQL)

Working

camera.py is the script responsible for backend work. Run it using

python camera.py


Enter either image path (PNG image specifically) which you want to recognize using OCR, or directly give vehicle number itself. Vehicle details are fetched and fines are calculated. It is also simultaneously updated in the database, and also being checked for missing status. If found as missing, a mail alert is sent (to email address specified in alert.py). Fine rates are fetched from NoSQL.

main.py is the script responsible for frontend work. Run it using

python main.py


This runs the website on https://localhost:5000, and can then be used to access project functionalities.
Snapshots of outputs are provided in the output folder. Report and other DBMS works are included in the report folder.