← Back to all projects
🗺️

My product In development

LokTathya

Civic data platform for India

A civic data platform for India built on maps and public data — making public information easier to find, check and understand.

50 tablesPostGIS maps76 CI tests

Built for: Citizens, journalists and researchers working with Indian public data.

↓ Scroll to explore the problem, architecture and stack

😩

The problem

Public data in India is scattered across formats and portals, which makes it hard for citizens and researchers to find, compare or verify.

💡

Why it matters

Bringing public data together on a map-aware database makes it searchable and verifiable for anyone.

What you can do with it

01Explore public data on maps.
02Search and compare information by place.
03Check facts against the underlying public sources.

How it’s built

A simplified view of the architecture — follow the dots as a request moves down the layers.

Web
Next.js frontendmaps + search
API
FastAPI
Data
PostgreSQL + PostGIS50 tables · geo queries
Delivery
GitHub Actionsmigrations + 76 tests

A request, step by step

  1. The Next.js app asks the API for data about a place or topic.
  2. FastAPI runs geo-aware queries on PostGIS.
  3. Every change is tested and migrated automatically in GitHub Actions.

Tech stack

Backend
PythonFastAPI
Data
PostgreSQLPostGIS
Frontend
Next.js
Platform
GitHub Actions

What I built

  • A FastAPI backend on PostgreSQL / PostGIS with 50 tables.
  • A Next.js frontend.
  • A GitHub Actions pipeline that runs database migrations and 76 automated tests.