NDC Transport Tracker Dashboard

Interactive dashboard for visualizing NDC transport targets and mitigation measures.

Live Dashboard

Main Dashboard: https://belentdc.github.io/tracker/

Comparison Dashboard: https://belentdc.github.io/tracker/comparison/

Embed in WordPress:

<iframe 
  src="https://belentdc.github.io/tracker/" 
  width="100%" 
  height="900px" 
  frameborder="0"
  style="border: none;">
</iframe>

---

How to Update Data

Method: GitHub Repository

1. Replace the Excel file GIZ-SLOCAT_Transport-Tracker-database.xlsx in the data/ folder
2. Click "Commit to main"
3. Click "Push origin"
4. Done!

---

Repository Structure

ndc-tracker/
├── data/
│   ├── GIZ-SLOCAT_Transport-Tracker-database.xlsx  ← UPDATE THIS
│   └── processed/
│       ├── data.json                               ← Auto-generated (main dashboard)
│       └── comparison-data.json                    ← Auto-generated (comparison dashboard)
│
├── comparison/
│   ├── index.html                                  ← Comparison dashboard HTML
│   ├── script.js                                   ← Comparison dashboard JavaScript
│   └── styles.css                                  ← Comparison dashboard styles
│
├── .github/
│   └── workflows/
│       └── update-data.yml                         ← GitHub Actions config
│
├── index.html                                      ← Main dashboard HTML
├── styles.css                                      ← Main dashboard styles
├── script.js                                       ← Main dashboard JavaScript
├── update_data.py                                  ← Data processing script
└── README.md                                       ← This file

---

How It Works

1. You upload a new Excel file to the data/ folder
2. GitHub Actions automatically detects the change
3. Python script processes the Excel and generates data.json
4. Dashboard reads the JSON and updates visualizations
5. Changes go live on GitHub Pages automatically

---

Dashboard Features

Main Dashboard (/)

Tab 1: Progress in NDC Transport Targets

• Bar chart showing % of NDCs with transport targets across 3 generations
• Interactive map with country-level data (color-coded by target status)
• Filters: Region
• Toggle between chart and map views
• Download PDF

Tab 2: Leading Measures for Decarbonisation

• Bar chart of top mitigation measure categories by number of NDCs
• Heat map showing measure mentions by country
• Filters: Generation (Latest Active / 1st / 2nd / 3rd), Region, Category
• Toggle between chart and map views
• Download PDF

Comparison Dashboard (/comparison/)

Side-by-side view of a country's NDC commitments across all three generations.

• Country selector — choose any country to load its full NDC history
• Three columns — one per generation (1st: 2015–2019, 2nd: 2020–2024, 3rd: 2024–ongoing)
• Version selector — shown when a country submitted multiple NDCs in the same generation
• Summary bar — counts of mitigation targets, adaptation targets, net zero targets, and measures per NDC
• Mitigation tab:
  • Transport mitigation targets (with GHG target, type, conditionality, target year)
  • Net zero targets
  • Mitigation measures grouped by category (with A-S-I label and transport modes)
• Adaptation tab:
  • Transport adaptation targets
  • Adaptation measures grouped by category (with transport modes)
• Synchronized scrolling — scrolling one column scrolls all three simultaneously
• Page references link directly to the source NDC document

---

Technical Details

Frontend:

• Pure HTML/CSS/JavaScript
• Chart.js for visualizations
• Leaflet.js for maps
• Fully responsive

Data Processing:

• Python 3.11+
• openpyxl library
• Generates data.json (main dashboard) and comparison-data.json (comparison dashboard)
• Runs automatically in GitHub Actions

Hosting:

• GitHub Pages (free)
• Auto-deploys on every update
• HTTPS included

---

Troubleshooting

Dashboard not updating after uploading Excel?

1. Check GitHub Actions tab in your repository
2. Look for the "Update Dashboard Data" workflow
3. If it failed, check the error logs
4. Common issues:
   • Excel file name changed (must be exact: GIZ-SLOCAT_Transport-Tracker-database.xlsx)
   • Excel file corrupted
   • Wrong folder (must be in data/ folder)

How to check if data updated?

Visit: https://[your-username].github.io/ndc-tracker/data/processed/data.json

You should see the JSON data. Check the modification date.

Dashboard shows old data?

• Clear browser cache (Ctrl+Shift+R or Cmd+Shift+R)
• Wait 2-3 minutes after uploading (GitHub Pages takes time to deploy)

---

📄 License

Data: GIZ-SLOCAT Transport Tracker Database
Dashboard: Custom implementation for GIZ/SLOCAT

---

Credits

Data Source: GIZ-SLOCAT Partnership Dashboard: Interactive visualization platform for NDC tracking

Last updated: Auto-generated on each data update