Sunduk - Redmine

04/16/2026

04:25 AM Hum Rahi User Story #598 (Backend completed): US-025 · Citizen Views All Submitted Reports with Current Status

zaid ali

04/13/2026

04:37 AM Hum Rahi Sub Task #643 (Backend completed): Roman Script Convert English Text

zaid ali

04:36 AM Hum Rahi Task #636 (Backend completed): Implement Keyword Extraction Logic

zaid ali

04/03/2026

04:46 AM Hum Rahi Task #642 (To Do): Optimize Spatial Query Performance

Add DB index on latitude and longitude columns.
Ensure query performs efficiently under load.
Benchmark query perfo... zaid ali

04:45 AM Hum Rahi Task #641 (To Do): Persist Duplicate Flag in Incident Entity

Update Incident entity:
- add isDuplicate flag
- add reference to originalIncidentId
Ensure original report linkage. zaid ali

04:45 AM Hum Rahi Task #640 (To Do): Implement Duplicate Detection Query

Query database for existing incidents within:
- 50 meter radius
- 10 minute window
Return original Report_ID if du... zaid ali

04:44 AM Hum Rahi Task #639 (To Do): Implement Time Window Filtering

Filter incidents created within last 10 minutes.
Combine spatial and temporal filters. zaid ali

04:43 AM Hum Rahi Task #638 (To Do): Implement Distance Calculation Logic

Calculate distance between incident coordinates using Haversine formula.
Support radius threshold of 50 meters. zaid ali

04:40 AM Hum Rahi Task #637 (Backend completed): Implement Error Handling for Audio Processing Failures

Handle cases of:
- noisy audio
- unsupported format
- STT failure
Return error:
"Audio processing failed: Excess... zaid ali

04:40 AM Hum Rahi Task #636 (Backend completed): Implement Keyword Extraction Logic

Extract critical keywords from transcript:
examples:
weapon, bleeding, fire, trapped
Use keywords to influence sev... zaid ali