πŸ”§ Processing Diagnostics completed

πŸ“Š Core Incident Data

call_id 2026031700431
incident_type HEART PROBLEM
headline Heart Problem Reported on Remington Street
description City of Watertown Fire dispatched for a 41-year-old female with a reported heart problem. Cross streets are Hamilton Street and Central Street.
location 943 Remington St, Watertown, NY, 13601
agencies City of Watertown Fire
datetime 2026-03-17 00:43:31
category medical
severity minor
update_type new_incident

🎯 Processing & Status

processing_status completed
ai_completed_at 2026-03-17 00:44:27
confidence_score not set
should_post_publicly NO
pre_alert_sent NO
summary_alert_sent YES
audio_hash not set
file_name WT_47_City_of_Watertown_2026_03_17_00_43_31.mp3
source_file WT_47_City_of_Watertown_2026_03_17_00_43_31.mp3

πŸ—ΊοΈ Location Validation Process

βœ“ Successfully Validated

Final Address: 943 Remington St, Watertown, NY, 13601

1 Attempt
2.00s processing time

Validation Attempts Timeline:

Attempt #1 - NYS GIS βœ“
12:44:25 AM
OK
Input Address:
943 Remington St, Watertown, NY
βœ“ Validated Address:
943 Remington St, Watertown, NY, 13601
πŸ“ 43.9760450, -75.8936421 View on Map β†—
AI Decision: ACCEPT
"NYS GIS returned an exact match for the dispatched address: 943 Remington St, Watertown, NY 13601. Street name and number align with the transcript and are specific enough for emergency response in Watertown."

πŸ”§ Technical Details

β–Ό
Started At 03/17/2026 12:44:25 AM
Completed At 03/17/2026 12:44:27 AM
Total Processing Time 2.00 seconds
Outcome Code validated

Raw JSON Data:

{
    "attempts": [
        {
            "attempt_number": 1,
            "timestamp": "2026-03-17T00:44:25.537440",
            "provider": "NYS GIS",
            "input_address": "943 Remington St, Watertown, NY",
            "validation_result": "OK",
            "validated_address": "943 Remington St, Watertown, NY, 13601",
            "latitude": 43.976045015178514,
            "longitude": -75.89364212023088,
            "ai_action": "accept",
            "ai_reasoning": "NYS GIS returned an exact match for the dispatched address: 943 Remington St, Watertown, NY 13601. Street name and number align with the transcript and are specific enough for emergency response in Watertown."
        }
    ],
    "summary": {
        "total_attempts": 1,
        "final_outcome": "validated",
        "final_address": "943 Remington St, Watertown, NY, 13601",
        "processing_time_seconds": 2,
        "started_at": "2026-03-17T00:44:25.267058",
        "completed_at": "2026-03-17T00:44:27.263685"
    }
}

πŸ”Š Audio Playback

File: /audio/WT_47_City_of_Watertown_2026_03_17_00_43_31.mp3

πŸ“ Primary Transcription (OpenAI)

City fire telephone alarm engine two, respond. 943 Remington Street. 41 year old female. Heart problem. Repeating for city fire telephone alarm engine two, respond. 943 Remington Street. 41 year old female. Heart problem. Cross streets of North Hamilton Street and Central Street.

πŸ“ Secondary Transcription (Whisper)

City Fire Telephone Alarm, Engine 2, respond 943 Remington Street, 41 year old female, heart problem, repeating for City Fire Telephone Alarm, Engine 2, respond 943 Remington Street, 41 year old female, heart problem, cross streets of Hamilton Street and Central Street.

πŸ€– AI Context & Reasoning

Model Feedback:

Both transcripts closely match: City of Watertown Fire (Dept 47) Engine 2 to 943 Remington Street for a 41-year-old female with a heart problem; cross streets Hamilton (Deepgram adds 'North') and Central. Classified as HEART PROBLEM (medical). Per publishing rules, medical incidents are not posted publicly. 'Telephone alarm' treated as dispatch method/jargon and kept only in memory.

Memory/Context:

CAD/dispatch: City Fire 'telephone alarm' medical call. Engine 2 dispatched to 943 Remington St, Watertown for a 41-year-old female with a heart problem. Cross streets: (North) Hamilton St and Central St. No additional patient condition details provided in audio.

πŸ”— Related Calls Timeline

00:43:31 - Heart Problem Reported on Remington Street
Call ID: 2026031700431 | Type: new_incident

πŸ” Database Info

β–Ό

Test Queries:

Get this incident:

SELECT * FROM incidents WHERE call_id = '2026031700431';

Get alert queue:

SELECT * FROM u390051648_alerting.alert_queue WHERE call_id = '2026031700431';

Get related incidents:

SELECT * FROM incidents WHERE JSON_CONTAINS(related_calls, '"2026031700431"');

Get latest incidents:

SELECT * FROM incidents ORDER BY ai_completed_at DESC LIMIT 10;

Raw Database Record:

{
    "call_id": "2026031700431",
    "headline": "Heart Problem Reported on Remington Street",
    "description": "City of Watertown Fire dispatched for a 41-year-old female with a reported heart problem. Cross streets are Hamilton Street and Central Street.",
    "location": "943 Remington St, Watertown, NY, 13601",
    "agencies": "City of Watertown Fire",
    "incident_type": "HEART PROBLEM",
    "file_name": "WT_47_City_of_Watertown_2026_03_17_00_43_31.mp3",
    "source_file": "WT_47_City_of_Watertown_2026_03_17_00_43_31.mp3",
    "date": "0000-00-00 00:00:00",
    "category": "medical",
    "model_feedback": "Both transcripts closely match: City of Watertown Fire (Dept 47) Engine 2 to 943 Remington Street for a 41-year-old female with a heart problem; cross streets Hamilton (Deepgram adds 'North') and Central. Classified as HEART PROBLEM (medical). Per publishing rules, medical incidents are not posted publicly. 'Telephone alarm' treated as dispatch method/jargon and kept only in memory.",
    "memory": "CAD/dispatch: City Fire 'telephone alarm' medical call. Engine 2 dispatched to 943 Remington St, Watertown for a 41-year-old female with a heart problem. Cross streets: (North) Hamilton St and Central St. No additional patient condition details provided in audio.",
    "related_calls": "[]",
    "update_type": "new_incident",
    "severity": "minor",
    "should_post_publicly": 0,
    "transcription": "City fire telephone alarm engine two, respond. 943 Remington Street. 41 year old female. Heart problem. Repeating for city fire telephone alarm engine two, respond. 943 Remington Street. 41 year old female. Heart problem. Cross streets of North Hamilton Street and Central Street.",
    "transcription2": "City Fire Telephone Alarm, Engine 2, respond 943 Remington Street, 41 year old female, heart problem, repeating for City Fire Telephone Alarm, Engine 2, respond 943 Remington Street, 41 year old female, heart problem, cross streets of Hamilton Street and Central Street.",
    "datetime": "2026-03-17 00:43:31",
    "confidence_score": null,
    "audio_hash": null,
    "processing_status": "completed",
    "ai_completed_at": "2026-03-17 00:44:27",
    "pre_alert_sent": 0,
    "summary_alert_sent": 1,
    "latitude": null,
    "longitude": null,
    "follow_up_alerts_sent": null,
    "detected_tones": "[\"47\"]",
    "location_validation_log": "{\"attempts\": [{\"attempt_number\": 1, \"timestamp\": \"2026-03-17T00:44:25.537440\", \"provider\": \"NYS GIS\", \"input_address\": \"943 Remington St, Watertown, NY\", \"validation_result\": \"OK\", \"validated_address\": \"943 Remington St, Watertown, NY, 13601\", \"latitude\": 43.976045015178514, \"longitude\": -75.89364212023088, \"ai_action\": \"accept\", \"ai_reasoning\": \"NYS GIS returned an exact match for the dispatched address: 943 Remington St, Watertown, NY 13601. Street name and number align with the transcript and are specific enough for emergency response in Watertown.\"}], \"summary\": {\"total_attempts\": 1, \"final_outcome\": \"validated\", \"final_address\": \"943 Remington St, Watertown, NY, 13601\", \"processing_time_seconds\": 2.0, \"started_at\": \"2026-03-17T00:44:25.267058\", \"completed_at\": \"2026-03-17T00:44:27.263685\"}}",
    "low_confidence_reason": null,
    "transcription_agreement": "0.33",
    "cad_code": "HEART PROBLEM",
    "incident_type_friendly": "Heart Problems",
    "type_icon": "medical"
}