The complete system — from data sources to what each stakeholder gets. This is the workflow you present in every meeting.
fetch-doam.php — imports 6,220+ sitesfetch-wikipedia.php — enriches with contentfetch-wikivoyage.php — adds travel datafetch-wikidata.php — fills coordinatesgenerate-briefs.php — AI writes descriptionsfetch-met.php — museum objectsfetch-unesco.php — source linksrun-all.php — one-click orchestratorTriggered from admin panel or cron.
sites — 6,220 heritage locationspois — GPS-tagged points of interestvisit_info — tickets, hours, transportarticles — OCR'd book contentich_elements — UNESCO living heritagearchive_submissions — citizen documentationanalytics — every interaction logged+ 12 more tablesGets a free guide in their language. Their visit = engagement data.
Every quiz, question, and visit logged. The data World Bank says doesn't exist.
Gets provable impact metrics. Funds the next phase. Zero platform cost.
| API | Purpose | Where Used | Status |
|---|---|---|---|
| Open-Meteo | Live weather + climate | Site pages, trip planner | ✓ Live |
| OSRM | Routing & travel times | Trip planner | ✓ Live |
| Aladhan | Prayer times | Practical page | ✓ Live |
| Wikipedia REST | Site histories EN/UR | Pipeline → database | ✓ Pipeline |
| DOAM | National site inventory | Pipeline → database | ✓ 6,220 sites |
| MET Museum | Gandhara objects (CC0) | Gallery, pipeline | Ready |
| Wikidata SPARQL | Coordinates batch | Pipeline → database | Ready |
| Google News RSS | Heritage headlines | News page | ✓ Live |
| LLM (optional) | AI guide enhancement | Guide chat | Config |
"Pakistan's heritage has no digital layer. The government's own content sits in PDFs on a website that crashes. We've already built the platform — 6,220 sites mapped, AI guide in 9 languages, live dashboard — using their own data, on free APIs, at zero cost to the public. One MoU letter unlocks the full 10,000+ sites, digitizes the national book collection, and gives you the M&E dashboard donors demand. The SCO 2027 chairmanship is in [counting] days. This platform is ready before that deadline."