Hum Rahi

User Story 5 (BE): Geospatial Duplicate Detection¶

Story: As a System Admin, I want to flag reports coming from the same location within a short window, so that the Police Panel isn't cluttered with 50 reports for the same pothole.

• In-Scope:
  • Spatial query to identify reports within a 50-meter radius.
  • Time-window check (10-minute threshold).
  • Flagging logic (marking as Is_Duplicate = True).
• Out-of-Scope: Automatically deleting reports (flags only).
• Acceptance Criteria (AC):
  1. System must search the database for existing reports within X meters and Y minutes.
  2. Duplicate reports must be linked to the "Original" report ID.
• Validation Rules:
  • Radius: 50 meters.
  • Time: 10 minutes.
• DoD: Spatial index optimized for performance, SQL/NoSQL query benchmarked.