Manaf-Yakubu/Ghana-Statistical-Service

A responsive web app for the Ghana Statistical Service that displays Upper West Region population data. It pulls data from a database, groups communities by district, offers fast search/filter tools, and allows one-click Excel/Word downloads with a clean, modern, animated UI. # Ghana Statistical Service - Upper West Regional Office A comprehensive web-based population data management system for the Ghana Statistical Service Upper West Regional Office. ## 🚀 Features - **Population Data Visualization**: Interactive charts and tables displaying population statistics - **Data Filtering**: Advanced filtering by district, locality, and year (2000, 2010, 2021) - **Export Functionality**: Export data in CSV, Excel, and PDF formats - **Admin Panel**: Secure administrative interface for data management - **Responsive Design**: Mobile-friendly interface with modern UI/UX - **PostgreSQL Integration**: Robust database backend with optimized queries ## 📊 Data Coverage - **Years**: 2000, 2010, 2021 census data - **Districts**: 11 districts in Upper West Region - **Localities**: 2,711 localities across all years - **Demographics**: Population by gender, households, and household heads ## 🛠 Technology Stack - **Frontend**: HTML5, CSS3, JavaScript (ES6+), Bootstrap 5 - **Backend**: PHP 8.x with PDO - **Database**: PostgreSQL 17.6 - **Charts**: Chart.js - **Export**: jsPDF, SheetJS (XLSX) - **Server**: Apache (XAMPP) ## 📁 Project Structure ``` Ghana Statistical Service/ ├── assets/ │ ├── css/ # Stylesheets │ ├── js/ # JavaScript files │ └── images/ # Images and logos ├── api/ # Backend API endpoints ├── Data/ # CSV data files ├── docs/ # Documentation ├── scripts/ # Database scripts ├── index.html # Homepage ├── population-data.html # Population data page ├── data-download.html # Filter data page └── admin-panel.html # Admin interface ``` ## 🔧 Installation ### Prerequisites - XAMPP (Apache + PHP 8.x) - PostgreSQL 17.6+ - Web browser (Chrome, Firefox, Safari, Edge) ### Setup Instructions 1. **Clone/Download the project** ```bash git clone github.com cd ghana-statistical-service ``` 2. **Database Setu …