Hyderabad pilot · live concept

Every animal.
A living record.

One view for identity, health, sightings and care—built around the people already looking after community animals.

Community map

● 342 recently verified
Last network update: 4 minutes ago

Banjara Hills pilot

Jubilee HillsBanjara HillsSomajigudaFilm Nagar

● Verified● Needs help12 Cluster

Registered animals486

Open care cases18

Active volunteers42

Care activity

Verified updates this week

+18%

126 events

MonTueWedThuFriSatSun

Coverage

Vaccination by locality

June

58%

Film
Nagar

71%

Jubilee
Hills

86%

Banjara
Hills

74%

Somaji-
guda

Recently verified

Meet Moti

A calm community dog cared for by residents near Road No. 12. His QR profile keeps every vaccination and sighting connected.

VaccSafe IDVS-HYD-0011

Last seenToday, 9:42 AM

Rabies vaccineValid until Feb 2027

SterilisationVerified · 2025

Needs attention

Prioritised for QRB coordinators

4 urgent

!

Injured dog · SomajigudaReported 12 min ago

P1

↻

Vaccination due · 7 animalsJubilee Hills cluster

Due

✓

Clinic record to verifyBlue Cross partner update

6

⌖

Not seen for 14 daysKaali · Film Nagar

Check

Public experience

Spot. Search.
Help nearby.

A citizen can contribute in under a minute—without learning a complicated system.

Animals around you

Approximate public locations protect animals and caregivers.

Near Banjara Hills

Jubilee HillsBanjara HillsPanjagutta

Public view · locations are approximate

Persistent identity

One profile.
Every update.

Search across animals, sightings and health records while preserving a chronological history.

Admin experience

From report
to resolved care.

A visible workflow helps QRB coordinate volunteers, veterinarians and municipal partners.

Median response48 min

Resolved this month74

Partner vets online3

Google Sheet → live insight

Measure care,
not just records.

A dynamic management view for QRB, partner clinics, donors and civic collaborators.

Synced 4 min ago

Vaccination status

486 registered animals

All species

73%

Currently protected355

Record incomplete73

Due within 30 days58

Care outcomes

Cases opened vs resolved

+24%

JanFebMarAprMayJun

— Resolved— Opened

Coverage by locality

Where the next field drive matters

Looker-ready

Locality	Animals	Vaccinated
Banjara Hills	126	108
Jubilee Hills	89	63
Somajiguda	78	58
Film Nagar	64	37

Data quality

Profiles needing administrator attention

31 checks

◌

Missing multi-angle photo16 animal profiles

16

⌖

Location not recently verifiedMore than 90 days old

9

↔

Possible duplicate profilesHuman review required

6

Developer handoff

Build small.
Prove value.
Grow safely.

A near-zero-cost pilot using QRB’s existing Google workflow—without adding a paid runtime AI dependency.

Review the stack

Public mobile app

QR animal profile

Admin dashboard

↓ ↓ ↓

Google Apps Script · API, permissions and automation

↓

Google Sheets
records

Google Drive
photos

Looker Studio
reporting

01 · Recommended stack

Everything needed for the pilot

Codex can produce the entire interface and Apps Script code. No LLM is required when the application is running.

▤

Google SheetsInitial database and operational source of truth.₹0 · existing workflow

⚙

Apps ScriptBackend, public API, permissions, email and automation.₹0 · quota based

◫

HTML · CSS · JSResponsive public app and admin operations dashboard.₹0 · Codex-built

⌁

MapLibre + OSMAnimal discovery map with approximate public locations.₹0 · pilot use

▦

QR browser toolsStable profile links and mobile camera scanning.₹0 · client-side

▰

Google DriveAnimal photos and supporting treatment documents.₹0 · within storage

⌁

Chart.jsFast operational charts inside the custom dashboard.₹0 · open source

↗

Looker StudioRead-only reporting for management, donors and partners.₹0 · Sheet connector

02 · Google Sheet model

Eight clean tabs—not one giant table

History should be appended as events. Existing animal records should not be overwritten whenever something changes.

Animals

AnimalID · Species · Name
Sex · Age band · Markings
Status · Locality · Visibility

Photos

PhotoID · AnimalID
DriveURL · ViewAngle
UploadedAt · Verified

Updates

UpdateID · AnimalID
Type · Date · Notes
ReporterID · Verification

MedicalEvents

EventID · AnimalID
Vaccine · Batch · DueDate
VetID · CertificateURL

CareCases

CaseID · AnimalID · Priority
Status · Assignee · Outcome
OpenedAt · ClosedAt

Users

UserID · Email · Role
Locality · Organisation
Active · LastSeen

Locations

LocationID · Locality
LatPublic · LngPublic
LatPrivate · LngPrivate

AuditLog

ActionID · UserID
Action · EntityID
Timestamp · Before · After

03 · Delivery roadmap

A practical sequence for QRB

The public app grows only after administrators can trust the underlying records and workflow.

WEEK 01

Data foundation

Audit current Sheet
Map and clean columns
Create stable IDs
Define public/private fields

WEEKS 02–03

Core web app

Search and profiles
QR retrieval
Timeline and updates
Admin permissions

WEEKS 04–05

Field workflow

Fast sighting form
Photo and GPS
Care case assignment
Mobile QA

WEEK 06+

Pilot and learn

100–300 animals
15–25 volunteers
Two vet partners
Measure care outcomes

04 · Cost and guardrails

Designed to stay near zero

Google quotas are fine for a pilot. Heavy city-wide usage becomes the trigger for a database migration—not an assumption on day one.

Google Sheets database	₹0
Apps Script backend + hosting	₹0
Custom web interface	₹0 runtime
Charts, maps and QR libraries	₹0
Looker Studio reporting	₹0
Existing qrb-mc.com domain	Already owned

Non-negotiable build checks

Small controls that prevent expensive problems.

✓

Separate public and admin dataNever publish the raw Google Sheet or private coordinates.

✓

Append history, do not erase itEvery medical event and status change remains auditable.

✓

Human-confirm possible duplicatesPhoto matching may suggest; an authorised user decides.

✓

Cache dashboards and watch quotasAvoid re-reading the full Sheet on every interaction.