CMO Project Monitoring & Review — based on On-Demand Instant Satellite Imagery (POC)
Verification layer for government infrastructure projects in Rajasthan and Maharashtra:
every project has a site, dated satellite / drone / field imagery, progress history, issues and directives.
See PROJECT_BRIEF.md for the full scope.
Stack
Next.js 16 (App Router) · TypeScript · Tailwind v4 · shadcn/ui (Base UI) · Prisma 7 + SQLite (better-sqlite3 adapter) · next-intl (English / हिन्दी / मराठी)
Getting started
npm install # also runs `prisma generate`
cp .env.example .env # then set AUTH_SECRET (see below)
npm run db:migrate # create / update the SQLite database
npm run db:seed # demo data + real site imagery
npm run dev # then open a portal (below)
Portals: one address per state
The main page shows Rajasthan and Maharashtra (plus greyed-out "Coming soon" states from
config/upcoming-states.ts) and never links to the admin portal, which stays an internal address.
During development http://localhost:3000/portals lists every portal, admin included. *.localhost addresses work in any
browser with no setup. A state portal never shows or links to the other state; a user of one state can't
sign in on the other's portal, and sessions only work on the portal that issued them.
For production, point each address at the same deployment and set them in .env:
PORTAL_HOST_RJ="rajasthan.cmo-monitor.in"
PORTAL_HOST_MH="maharashtra.cmo-monitor.in"
PORTAL_HOST_ADMIN="admin.cmo-monitor.in"
PORTAL_HOST_MAIN="cmo-monitor.in"
Unknown addresses get "Not found". Behind a reverse proxy, forward the public host (X-Forwarded-Host).
npm 11 blocks dependency install scripts unless approved. The ones this project needs
(better-sqlite3, prisma, @prisma/engines, esbuild, unrs-resolver) are already listed
under allowScripts in package.json.
AUTH_SECRET encrypts the login session cookie. Generate one with openssl rand -base64 33 and paste it
into .env. Changing it signs everyone out.
Useful scripts:
| Script | What it does |
|---|
npm run db:seed | Wipes and re-seeds all data (safe to re-run) |
npm run db:reset | Drops the DB, re-applies migrations and re-seeds |
npm run db:studio | Opens Prisma Studio to browse the data |
npm run check:scopes | Verifies each demo user sees only the data in their scope |
npm run geo:build | Regenerates the district boundary files in public/geo/ |
npm run imagery:migrate | One-off: moves imagery from the old public public/uploads/ into private storage (keeps all data) |
Demo users
All demo users have the password Demo@123. Each portal's login page has a clickable "Demo accounts"
list with only that portal's accounts; hide it with NEXT_PUBLIC_SHOW_DEMO_ACCOUNTS="false" in .env.
Admin: [email protected] on the admin portal.
Demo data
- Districts: Rajasthan 41 (post Dec-2024 reorganisation), Maharashtra 36 — all seeded with English + local names.
- Departments (per state): PWD, Metro, Drainage & Sewer, Urban, Roads & Buildings, Rural, MGNREGA.
- Projects: for the demo, eight per state: six with real satellite imagery and two still awaiting imagery
(Udaipur in Rajasthan, Pune in Maharashtra; listed in
WITHOUT_IMAGERY in prisma/seed.ts). The six real before/after image sets (four from Jaipur, two from Mumbai) are each
used once in Rajasthan (Jaipur, Jodhpur) and once in Maharashtra (Mumbai Suburban, Mumbai City, Pune, Nagpur);
the copies carry local project names and locations, but the screenshots show the original site. prisma/seed-data/projects.ts
holds 65 projects; set ONLY_IMAGED_PROJECTS = false in prisma/seed.ts to seed them all.
- Each project has monthly progress updates and issues (open ones tagged to the last review meeting). CMO
directives exist per state, some overdue.
- Meetings (per state): CMO review meetings are held on the 15th and 30th of every month (the last day
in February), 11:00 am. The demo has the two most recent (with the issues tagged to them), the next one with a
published agenda, and a draft for the one after. In demo mode these move with the calendar, so the next meeting
is always the coming 15th or 30th. New meetings default to the next free 15th / 30th.
- Imagery: each seeded project has real before/after satellite imagery (see Imagery).
- Seed data lives in
prisma/seed-data/ — edit those files to change names, budgets or statuses.
This is the beginning of the README. Read the rest at the original. Read the full README ↗
