City of Windsor Data Portal

A Java GUI application for managing and accessing City of Windsor's open datasets with role-based access control.

🎥 Demo

Download-Demo-Video

or

🎬Project Demo

Watch the full demo on YouTube:

Features

• Guest Access: Browse and download public datasets
• User Management: Account creation and role-based authentication
• Dataset Management: Upload, review, and approval workflow
• Admin Dashboard: Manage users and approve dataset submissions
• Contributor Portal: Upload datasets for community use

Tech Stack

• Backend: Java, MySQL
• Frontend: Java GUI
• Build Tool: Maven
• Database: MySQL with open datasets from City of Windsor

Architecture

• MVC Pattern: Clean separation of concerns
• Role-Based Access: Guest, Contributor, Admin roles
• Database Integration: MySQL for data persistence
• Design Patterns: Indirection, Polymorphism, Pure Fabrication

Team

Group 11 - COMP3220 Project