πŸ”§ Processing Diagnostics completed

πŸ“Š Core Incident Data

call_id 2026031702426
incident_type BREATHING PROBL
headline Breathing Problem Reported at Public Square Apartment
description Telephone alarm for a breathing problem in Apartment 204.
location 86 Public Sq, Watertown, NY, 13601
agencies City of Watertown Fire
datetime 2026-03-17 02:42:56
category medical
severity minor
update_type new_incident

🎯 Processing & Status

processing_status completed
ai_completed_at 2026-03-17 02:44:02
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_02_42_56.mp3
source_file WT_47_City_of_Watertown_2026_03_17_02_42_56.mp3

πŸ—ΊοΈ Location Validation Process

βœ“ Successfully Validated

Final Address: 86 Public Sq, Watertown, NY, 13601

1 Attempt
3.01s processing time

Validation Attempts Timeline:

Attempt #1 - NYS GIS βœ“
2:43:59 AM
OK
Input Address:
86 Public Square, Watertown, NY
βœ“ Validated Address:
86 Public Sq, Watertown, NY, 13601
πŸ“ 43.9746228, -75.9077630 View on Map β†—
AI Decision: ACCEPT
"NYS GIS returned a clean standardized match for the dispatched address: 86 Public Sq, Watertown, NY 13601. This aligns with the transcript (86 Public Square, Apt 204). Apartment/unit detail isn’t needed for geocoding; the street-level address is specific and usable for emergency response in Watertown, Jefferson County."

πŸ”§ Technical Details

β–Ό
Started At 03/17/2026 2:43:59 AM
Completed At 03/17/2026 2:44:02 AM
Total Processing Time 3.01 seconds
Outcome Code validated

Raw JSON Data:

{
    "attempts": [
        {
            "attempt_number": 1,
            "timestamp": "2026-03-17T02:43:59.826999",
            "provider": "NYS GIS",
            "input_address": "86 Public Square, Watertown, NY",
            "validation_result": "OK",
            "validated_address": "86 Public Sq, Watertown, NY, 13601",
            "latitude": 43.97462284891091,
            "longitude": -75.90776302459209,
            "ai_action": "accept",
            "ai_reasoning": "NYS GIS returned a clean standardized match for the dispatched address: 86 Public Sq, Watertown, NY 13601. This aligns with the transcript (86 Public Square, Apt 204). Apartment/unit detail isn\u2019t needed for geocoding; the street-level address is specific and usable for emergency response in Watertown, Jefferson County."
        }
    ],
    "summary": {
        "total_attempts": 1,
        "final_outcome": "validated",
        "final_address": "86 Public Sq, Watertown, NY, 13601",
        "processing_time_seconds": 3.01,
        "started_at": "2026-03-17T02:43:59.539947",
        "completed_at": "2026-03-17T02:44:02.550696"
    }
}

πŸ”Š Audio Playback

File: /audio/WT_47_City_of_Watertown_2026_03_17_02_42_56.mp3

πŸ“ Primary Transcription (OpenAI)

City fire telephone alarm engine two, respond. 86 Public Square, Apartment 204. One one and a half year old female, breathing problem. Repeating for city fire telephone alarm. Engine two, respond. 86 Public Square, Apartment 204, one and a half year old female, breathing problem. Cross streets of State Street and Mill Street.

πŸ“ Secondary Transcription (Whisper)

City Fire Telephone Alarm, Engine 2, respond 86, Public Square, Apartment 204, one and a half year old female, breathing problem, repeating for City Fire Telephone Alarm, Engine 2, respond 86, Public Square, Apartment 204, one and a half year old female, breathing problem, cross streets of State Street and Mill Street.

πŸ€– AI Context & Reasoning

Model Feedback:

Both transcripts closely match: City of Watertown Fire telephone alarm, Engine 2 to 86 Public Square Apt 204 for a 1.5-year-old female with breathing problem; cross streets State St and Mill St. No clear linkage to the earlier 01:13 breathing problem call at a different address, so treated as a new incident. Medical call category β†’ should_post_publicly set to false per rules.

Memory/Context:

City of Watertown Fire telephone alarm medical call. Engine 2 dispatched to 86 Public Square, Apartment 204, Watertown for a 1.5-year-old female with breathing problem. Cross streets: State Street and Mill Street.

πŸ”— Related Calls Timeline

02:42:56 - Breathing Problem Reported at Public Square Apartment
Call ID: 2026031702426 | Type: new_incident

πŸ” Database Info

β–Ό

Test Queries:

Get this incident:

SELECT * FROM incidents WHERE call_id = '2026031702426';

Get alert queue:

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

Get related incidents:

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

Get latest incidents:

SELECT * FROM incidents ORDER BY ai_completed_at DESC LIMIT 10;

Raw Database Record:

{
    "call_id": "2026031702426",
    "headline": "Breathing Problem Reported at Public Square Apartment",
    "description": "Telephone alarm for a breathing problem in Apartment 204.",
    "location": "86 Public Sq, Watertown, NY, 13601",
    "agencies": "City of Watertown Fire",
    "incident_type": "BREATHING PROBL",
    "file_name": "WT_47_City_of_Watertown_2026_03_17_02_42_56.mp3",
    "source_file": "WT_47_City_of_Watertown_2026_03_17_02_42_56.mp3",
    "date": "0000-00-00 00:00:00",
    "category": "medical",
    "model_feedback": "Both transcripts closely match: City of Watertown Fire telephone alarm, Engine 2 to 86 Public Square Apt 204 for a 1.5-year-old female with breathing problem; cross streets State St and Mill St. No clear linkage to the earlier 01:13 breathing problem call at a different address, so treated as a new incident. Medical call category \u2192 should_post_publicly set to false per rules.",
    "memory": "City of Watertown Fire telephone alarm medical call. Engine 2 dispatched to 86 Public Square, Apartment 204, Watertown for a 1.5-year-old female with breathing problem. Cross streets: State Street and Mill Street.",
    "related_calls": "[]",
    "update_type": "new_incident",
    "severity": "minor",
    "should_post_publicly": 0,
    "transcription": "City fire telephone alarm engine two, respond. 86 Public Square, Apartment 204. One one and a half year old female, breathing problem. Repeating for city fire telephone alarm. Engine two, respond. 86 Public Square, Apartment 204, one and a half year old female, breathing problem. Cross streets of State Street and Mill Street.",
    "transcription2": "City Fire Telephone Alarm, Engine 2, respond 86, Public Square, Apartment 204, one and a half year old female, breathing problem, repeating for City Fire Telephone Alarm, Engine 2, respond 86, Public Square, Apartment 204, one and a half year old female, breathing problem, cross streets of State Street and Mill Street.",
    "datetime": "2026-03-17 02:42:56",
    "confidence_score": null,
    "audio_hash": null,
    "processing_status": "completed",
    "ai_completed_at": "2026-03-17 02:44:02",
    "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-17T02:43:59.826999\", \"provider\": \"NYS GIS\", \"input_address\": \"86 Public Square, Watertown, NY\", \"validation_result\": \"OK\", \"validated_address\": \"86 Public Sq, Watertown, NY, 13601\", \"latitude\": 43.97462284891091, \"longitude\": -75.90776302459209, \"ai_action\": \"accept\", \"ai_reasoning\": \"NYS GIS returned a clean standardized match for the dispatched address: 86 Public Sq, Watertown, NY 13601. This aligns with the transcript (86 Public Square, Apt 204). Apartment/unit detail isn\\u2019t needed for geocoding; the street-level address is specific and usable for emergency response in Watertown, Jefferson County.\"}], \"summary\": {\"total_attempts\": 1, \"final_outcome\": \"validated\", \"final_address\": \"86 Public Sq, Watertown, NY, 13601\", \"processing_time_seconds\": 3.01, \"started_at\": \"2026-03-17T02:43:59.539947\", \"completed_at\": \"2026-03-17T02:44:02.550696\"}}",
    "low_confidence_reason": null,
    "transcription_agreement": "0.71",
    "cad_code": "BREATHING PROBL",
    "incident_type_friendly": "Breathing Problems",
    "type_icon": "medical"
}