SP Sangareddy — Command & Intelligence Dashboard

📋

Petitions

—

Active SP Petitions

Loading petition records...

⚖️

BNSS Alert

—

Charge Sheets Critical / Overdue

Default bail risk window

✓

Clearance

—%

Petition Resolution Rate

District Target: ≥ 85%

📊

Crime Intel

—

Crime Incidents Logged

Direct station database entries

➕ + New Petition

📅 Date:

Petitions & Grievances Register

Showing all registered petitions

⚡ Open Janata Darbar (PetitionAI v2.0) →

Loading Petitions...

Fetching verified records from secure SP District database

BNSS Statutory Charge Sheet Monitor

Statutory bail deadline tracking (60 / 90 Days)

Loading Court Cases...

Calculating statutory countdown timers

🔬

FIR & MO Monitoring System

Automated district command MO monitor tracking 7-day Material Object (MO) FSL dispatch window and chargesheet countdowns under BNSS §187.

📋 Open FIR Portal →

⚖️ Row 1: Chargesheet Days Ladder (BNSS §187 60/90-Day Early Warning)

🟢 Green (≤44 Days)

0

Routine • Evidence Intake

🟡 Yellow (45–49 Days)

0

Station Alert • FSL Follow-up

🟠 Orange (50–54 Days)

0

Escalation Warning • SHO Alert

🔴 Red (≥55 Days)

0

SP Escalation • Default Bail Risk

📦 Row 2: MO-to-FSL Dispatch Tracker (7-Day Statutory Window)

🟢 Sent to FSL

0

Material Objects Dispatched to Lab

🟡 Pending (≤7 Days)

0

Under Intake Window • Dispatch Required

🔴 Overdue (>7 Days)

0

Overdue Dispatch • Immediate Action

📅 Registration Date: to

🕒 Disposal Set Date: to

⚖️ CCTNS Chargesheet Date: to

Showing All Active Cases (Click any tile or filter below)

Station	Sub-Division	Crime No	Offence	Date of Reg	Chargesheet Ladder	MO Status Flag	Disposal	Action
Loading FSL cases...

District Crime Pattern Intelligence

Live station crime incidents submitted via CrimeDataForm.html and analyzed on server.

+ Log Crime Incident 🗺️ Open CrimeMapAI Report

Latest Crime Incident Records in Database 0 records

From Date:

To Date:

Loading Crime Records...

Face Recognition Surveillance Alerts

Real-time mobile camera matching stream

Total FIRs Today

Under Investigation

Chargesheeted

Total This Month

🏢 Station:

⚖️ Offence:

📅 Date:

➕ + Register FIR

District FIR Live Register

Auto-refreshes every 30 seconds · Live Stream

FIR No	Station	Date / Time	Complainant	Accused	Offence Section & Type	IO Name	Status	Update Status	Actions
Loading FIR Live Register...

Data Location & Storage Policy

All data is stored securely in MySQL database on Hostinger India servers (srv1493.hstgr.io). Database: u967886501_spsgr. Weekly automatic backups enabled. Data never leaves India. Only authorized personnel with approved Gmail accounts can access this system.

🛡️ Tool Visibility Settings

Toggle which tools appear on the Home navigation portal for Station Writers vs Administrators. Direct tool URLs remain accessible to Administrators.

Tool Application	Key	Writer View	Admin View
Loading tool visibility settings...

Writer & Officer Access Management

Manage authorized Gmail accounts for Station Writers, Officers, and Admin staff.

Gmail Address	Name	Role	Assigned Station	Added On	Action
Loading authorized writers...

➕ Add New Authorized Writer / Officer

Gmail Address

Full Name

Role

Assigned Police Station *

📲 Share Tools with Writers

Send these links to your Station Writers so they can sign in and start entering data.

📂 FIR Entry Portal

spsgr.in/FIR_Entry.html

📋 Petition Registration

spsgr.in/PetitionAI_v2.html

⚖️ Court Case Entry

spsgr.in/CourtAlertAI.html

🚨 Crime Data Entry

spsgr.in/CrimeDataForm.html

Database Management & Reset Controls

Perform targeted data resets or clear all demo entries to begin a pristine production session for Sangareddy District Police.

⚠ Reset actions permanently delete records from the district server database (Petitions, Court Cases, Crime Incidents, FIR Records, FIR Monitoring & FSL Tracker).

Officer Direct Access

This command dashboard operates entirely on the local district server with zero Google Sheets / third-party dependencies.

Direct URL for Officers:
https://spsgr.in/SP_LiveDashboard.html

📜

FSL & System Audit Log — Case Mutation Ledger

Chronological, immutable audit ledger tracking case creations and status modifications across all Sangareddy police stations. Restricted Admin / SP command oversight tool.

0 Total Logs

Station

Officer (Gmail / Name)

Action

From Date

To Date

Timestamp	Officer (Gmail / Name)	Station	Case	Action	Field Changed	Old Value → New Value
Select tab to load audit log...