🗺️
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
- The Next.js app asks the API for data about a place or topic.
- FastAPI runs geo-aware queries on PostGIS.
- 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.