Msuluzya/Zanzibar-Regions.
Domain:
geospatialRecord type:
dataset
Creator:
Msu
Host:
A comprehensive geographical database of Zanzibar administrative divisions with official postcode system integration.
# Zanzibar Regions Database
A comprehensive geographical database of Zanzibar administrative divisions with official postcode system integration.
## Features
- **5 Regions** with official codes
- **10 Districts** with proper zone assignments
- **44 Wards** with complete 5-digit postcodes
- **36 Streets** with location codes
- Full postcode system integration
- Multiple data formats (SQL, CSV, JSON)
## Postcode Structure
```
Format: XXXXX (5-digit)
- 1st digit: Zone (1=Unguja, 6=Pemba)
- 1st-2nd digits: Region code
- 1st-3rd digits: District/CBD code
- All 5 digits: Ward postcode
```
## Quick Start
### SQL
```sql
-- Import the complete database
mysql -u username -p database_name $region) {
echo "Region: {$regionName} (Code: {$region['tcra_code']})\n";
foreach ($region['districts'] as $districtName => $district) {
foreach ($district['wards'] as $wardName => $ward) {
echo " Ward: {$wardName} - Postcode: {$ward['postcode']}\n";
}
}
}
```
### Python
```python
import json
# Load data
with open('json/zanzibar-regions.json', 'r') as f:
data = json.load(f)
# Get regions by zone
def get_regions_by_zone(zone):
return {name: info for name, info in data.items() if info['zone'] == zone}
# Example: Get all Zone 1 (Unguja) regions
unguja_regions = get_regions_by_zone('1')
print(f"Unguja regions: {list(unguja_regions.keys())}")
```
## 📁 Files Structure
```
ZanzibarRegions/
├── README.md # This file
├── sql/
│ └── zanzibar-regions.sql # Complete SQL database with tables and data
├── csv/
│ ├── zanzibar-all.csv # All regions combined
│ ├── unguja-north.csv # Unguja North region data
│ ├── unguja-south.csv # Unguja South region data
│ ├── mjini-magharibi.csv # Mjini Magharibi region data
│ ├── pemba-north.csv # Pemba North region data
│ └── pemba-south.csv # Pemba South region data
├── json/
│ └── zanzibar-region …