9jaDevo/nigeria-lga-ward
Domain:
geospatialRecord type:
dataset
Creator:
9ja
Host:
Ready-to-import MySQL seed files for Nigeria — 37 states, 774 LGAs, 8 800 + wards (auto-generated from open data)
# 🇳🇬 Nigeria States → LGAs → Wards – Ready-to-import MySQL seed files
**37 states, 774 local‐government areas, ~8 800 wards** — packaged as three SQL files you can drop straight into MySQL, MariaDB, Laravel, WordPress, Django, Node/Knex, or even a one-shot Docker stack.
> **Repo:** **`nigeria-lga-ward`** ·
> **Data version:** auto-generated weekly from the latest open JSON
> **License:** Code MIT | Data CC‑BY 4.0 © afeibukun
---
## 🔗 Quick import
```bash
git clone github.com
cd nigeria-lga-ward/data
mysql -u root -p yourdb **Table shapes**
| Table | Primary key | Foreign key | Columns |
| -------- | ----------- | ----------- | ------------------------------------------------------ |
| `states` | `id` | – | id, name, status, created_at, updated_at |
| `lgas` | `id` | `state_id` | id, **state_id**, name, status, created_at, updated_at |
| `wards` | – | `lga_id` | **lga_id**, name, status, created_at, updated_at |
---
## 📚 Language-specific helpers
| Stack / Tool | Helper file | One‑liner to run |
| ------------------- | ------------------------------------------ | ---------------------------------------------- |
| Laravel 10 | `helpers/laravel/NigeriaGeoSeeder.php` | `php artisan db:seed --class=NigeriaGeoSeeder` |
| WordPress | `helpers/wordpress/nigeria-geo-import.php` | Upload & **Activate** plugin |
| Node.js + Knex | `helpers/node/001_import_nigeria_geo.js` | `knex migrate:latest` |
| Python + SQLAlchemy | `helpers/python/import_nigeria_geo.py` | `python helpers/python/import_nigeria_geo.py` |
| Django | `helpers/django/import_nigeria_geo.py` | `python manage.py import_nigeria_geo` |
| Docker | `helpers/docker-compose.yml` …