1.0 release

Overview

StreamLine is designed to streamline the management of fire hydrants across urban, suburban, and rural areas. Fire hydrants require routine maintenance and inspections, but current data management is fragmented across spreadsheets, handwritten logs, and legacy systems.

StreamLine provides a centralized hub for hydrant data, making it easier for field workers to access and update critical information in real time.

Key Features

✔ CRUD Operations for Hydrants – Add, view, update, and delete hydrant records.
✔ CRUD Operations for Regions – Manage regions by creating, updating, and removing records.
✔ CRUD Operations for Inspections – Log, modify, and track hydrant inspection records.
✔ CRUD Operations for Workers – Add new workers, update assignments, and remove records.
✔ CRUD Operations for Maintenance Logs – Record, edit, and manage maintenance activities.
✔ CRUD Operations for Worker-Inspection Assignments – Assign workers to inspections and update or remove links.
✔ CRUD Operations for Hydrant-Inspection Assignments – Track hydrant inspections and modify records as needed.

Tech Stack

🔹 Frontend: Flask, Python, HTML5, CSS3, JavaScript
🔹 Backend: SQL

Installation Guide

1. Clone the Repository:

   git clone https://github.com/PiekoRocks/StreamLine

2. Set Up Virtual Environment:
   • Mac/Linux:

     python3 -m venv venv  
     source venv/bin/activate  

   • Windows (PowerShell):

     python -m venv venv  
     venv\Scripts\activate  

3. Install Dependencies:

   pip install flask mysql-connector-python  

4. Run the Flask Server:

   python app.py  

Contributors ✨

• @troydiaz – Troy Diaz
• @PiekoRocks - Nico Johnson
• @zcroy75 – Adam Danielson

Live Link 🔗

📌 Must be on the OSU network (VPN) to access
🔗 StreamLine Web App