Smart Park

About

An smart parking system that will detect parked cars using opencv and arduino for a real-life model. The information is stored in a MariaDB database and statistics/UI are shown in Streamlit framework.

Setup

Requirements

1. Clone the repository using command:

git clone https://github.com/gabrielrueda/win-hacks-2024.git

2. To install the requirements, type this command:

pip install -r requirements.txt

3. Set up the database (we are using mariadb): https://mariadb.com/kb/en/getting-installing-and-upgrading-mariadb/

4. Activate the database using command:

mariadb -u {username} -p

5. Once mariadb is activated, use the following queries

CREATE TABLE PARKING_SLOTS (
    DetectedTime Timestamp NOT NULL,
    Slot1 BOOLEAN NOT NULL,
    Slot2 BOOLEAN NOT NULL,
    Slot3 BOOLEAN NOT NULL,
    Slot4 BOOLEAN NOT NULL,
    Slot5 BOOLEAN NOT NULL,
    Slot6 BOOLEAN NOT NULL,
    Slot7 BOOLEAN NOT NULL,
    Slot8 BOOLEAN NOT NULL,
    Slot9 BOOLEAN NOT NULL,
    Slot10 BOOLEAN NOT NULL,
    Slot11 BOOLEAN NOT NULL
);

6. Hardware tools used: Webcam, electric tape for outlining the parking slot sections, model cars (Hot Wheels), Arduino Nano, general electronics, and LED bulbs that will light up if spot is not taken.

Run

1. To run the UI application, write command:

streamlit run streamlit.py

NOTE: to get up to date information for slots changing, you must refresh page

2. Connect micro USB-B to USB port to computer

3. To run the parking slot demonstration, write command:

python3 install app.py

Snapshots

Videos

https://youtu.be/vlWlhAm0BZU

Credits

We took inspiration from this repository: https://github.com/offsouza/parking_lot_opencv