CivicGuard 311 – Civic Issue Reporting CMS

Improve communication between residents and local authorities with CivicGuard 311, a responsive civic issue reporting and management system built with PHP and MySQL. Residents can submit reports about local infrastructure and community concerns, pinpoint issue locations on an interactive map, and follow progress as municipal staff review and resolve each report.

Key Features

• Interactive Geographic Maps: Use Leaflet.js and OpenStreetMap tiles to display reported issues and allow residents to mark issue locations with map pins.
• Citizen Issue Reporting: Provide a central way for residents to report problems such as potholes, broken streetlights, and illegal waste dumping.
• Transparent Status Tracking: Follow complaints through the defined workflow: Reported, Acknowledged, In Progress, and Resolved.
• Status Notes and Updates: Display explanatory updates so residents can understand the progress of their reported issues.
• Municipal Staff Workspace: Give staff a dedicated administrative interface for reviewing complaints, searching by keyword, filtering by category or status, and updating resolution stages.
• Issue Image Uploads: Support citizen-uploaded images with file type validation, size limits, and randomized filenames.
• Guided Installation Wizard: Check server requirements, configure database access, initialize database tables, and create the administrator account.
• Responsive Interface: Provide a mobile-first layout for residents and municipal staff using Bootstrap-compatible styling.
• Customizable Issue Categories: Adapt categories to local needs, including traffic signals, pavement markings, and other municipal concerns.
• Security-Focused Architecture: Includes PDO prepared statements, CSRF token validation, output sanitization, protected uploads, and error logging.

Issue Resolution Workflow

• Reported: A resident submits a new civic issue.
• Acknowledged: The report is recognized by the responsible team.
• In Progress: Staff update the report as work proceeds.
• Resolved: The issue is marked as resolved.

Interactive Map Experience

The integrated Leaflet map uses OpenStreetMap tiles to help residents identify the location of civic problems. A public overview map displays issue markers, while location pins help associate reports with specific coordinates.

Administrative Tools

• Centralized issue dashboard
• Keyword-based complaint search
• Filtering by issue status and category
• Issue detail views and status update controls
• Explanatory resolution log updates
• Administrator account and application configuration

Technology Stack

• PHP 8.0 or higher
• MySQL 5.7+ or MariaDB 10.3+
• PDO and PDO MySQL
• Leaflet.js
• OpenStreetMap tiles
• Apache with mod_rewrite
• HTML, CSS, and JavaScript
• Fileinfo extension for upload validation

Installation

Install locally using XAMPP or WAMP, or deploy to compatible Apache hosting. Open the included installation wizard, enter database credentials, create the administrator account, and initialize the database. Manual installation is also supported using the included SQL schema and configuration sample.

Included in the Package

• Public-facing civic issue reporting portal
• Municipal staff administration workspace
• Issue status and resolution management screens
• Leaflet map integration
• Database installation schema and optional demo data
• Automated installation wizard
• Shared PHP utilities and authentication helpers
• Image upload directory and responsive styling assets
• Configuration sample and changelog

System Requirements

PHP 8.0+, MySQL 5.7+ or MariaDB 10.3+, PDO, PDO MySQL, Apache with mod_rewrite, and suitable upload directory permissions. The GD extension is optional for image processing.

Security and Deployment Notes

Remove the installer directory after successful setup, change demo credentials, and configure appropriate database and file permissions before production use. Map tiles depend on the configured OpenStreetMap service and its usage policies. The application provides issue reporting and status management; integration with official municipal systems or dispatch services is not specified in the README.

Ideal For

• Municipalities and local councils
• Community service departments
• Neighborhood associations
• Public works and maintenance teams
• Developers building customized civic reporting portals

Make local issue reporting more organized and transparent with CivicGuard 311.