πŸ”§ Processing Diagnostics completed

πŸ“Š Core Incident Data

call_id 2026031701136
incident_type BREATHING PROBL
headline Breathing Problem Reported on North Hamilton Street
description Engine 2 dispatched for a 37-year-old male with breathing problems in Apartment 1. Cross streets are Bronson Street and Remington Street.
location 300 N Hamilton St, Watertown, NY, 13601
agencies City of Watertown Fire
datetime 2026-03-17 01:13:26
category medical
severity minor
update_type new_incident

🎯 Processing & Status

processing_status completed
ai_completed_at 2026-03-17 01:14:26
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_01_13_26.mp3
source_file WT_47_City_of_Watertown_2026_03_17_01_13_26.mp3

πŸ—ΊοΈ Location Validation Process

βœ“ Successfully Validated

Final Address: 300 N Hamilton St, Watertown, NY, 13601

1 Attempt
2.37s processing time

Validation Attempts Timeline:

Attempt #1 - NYS GIS βœ“
1:14:24 AM
OK
Input Address:
300 N Hamilton St, Watertown, NY
βœ“ Validated Address:
300 N Hamilton St, Watertown, NY, 13601
πŸ“ 43.9749634, -75.8931201 View on Map β†—
AI Decision: ACCEPT
"Transcript and extracted address match exactly (300 N Hamilton St, Apt 1, Watertown). NYS GIS returned a specific street address with ZIP 13601 in Watertown, which is sufficient for emergency response; apartment number is not required for geocoding."

πŸ”§ Technical Details

β–Ό
Started At 03/17/2026 1:14:23 AM
Completed At 03/17/2026 1:14:26 AM
Total Processing Time 2.37 seconds
Outcome Code validated

Raw JSON Data:

{
    "attempts": [
        {
            "attempt_number": 1,
            "timestamp": "2026-03-17T01:14:24.039317",
            "provider": "NYS GIS",
            "input_address": "300 N Hamilton St, Watertown, NY",
            "validation_result": "OK",
            "validated_address": "300 N Hamilton St, Watertown, NY, 13601",
            "latitude": 43.97496341609641,
            "longitude": -75.89312008313632,
            "ai_action": "accept",
            "ai_reasoning": "Transcript and extracted address match exactly (300 N Hamilton St, Apt 1, Watertown). NYS GIS returned a specific street address with ZIP 13601 in Watertown, which is sufficient for emergency response; apartment number is not required for geocoding."
        }
    ],
    "summary": {
        "total_attempts": 1,
        "final_outcome": "validated",
        "final_address": "300 N Hamilton St, Watertown, NY, 13601",
        "processing_time_seconds": 2.37,
        "started_at": "2026-03-17T01:14:23.769010",
        "completed_at": "2026-03-17T01:14:26.134574"
    }
}

πŸ”Š Audio Playback

File: /audio/WT_47_City_of_Watertown_2026_03_17_01_13_26.mp3

πŸ“ Primary Transcription (OpenAI)

City fire telephone alarm engine two, respond. 300 North Hamilton Street, Apartment Number 1. 37 year old male. Breathing problems. Repeating for city fire telephone alarm engine two, respond. 300 North Hamilton Street, Apartment Number 1. 37 year old male breathing problem. Crossridge, Bronson Street and Remington Street.

πŸ“ Secondary Transcription (Whisper)

City Fire Telephone Alarm Engine 2, respond 300, North Hamilton Street, apartment number 1, 37-year-old male, breathing problems, repeating for City Fire Telephone Alarm Engine 2, respond 300, North Hamilton Street, apartment number 1, 37-year-old male, breathing problems, cross streets, Bronson Street and Remington Street.

πŸ€– AI Context & Reasoning

Model Feedback:

Both transcripts closely match: City Fire telephone alarm, Engine 2 to 300 North Hamilton St Apt 1 for a 37-year-old male with breathing problems; cross streets Bronson and Remington. Deepgram's 'Crossridge' interpreted as 'cross streets.' No relationship to the earlier 12:43 AM heart problem call (different address/nature), so treated as a new incident. Medical category β†’ do not post publicly per publishing rules.

Memory/Context:

City of Watertown Fire telephone alarm medical call. Engine 2 dispatched to 300 North Hamilton Street, Apartment 1, Watertown for a 37-year-old male with breathing problems. Cross streets: Bronson Street and Remington Street. Dispatch repeated the assignment.

πŸ”— Related Calls Timeline

01:13:26 - Breathing Problem Reported on North Hamilton Street
Call ID: 2026031701136 | Type: new_incident

πŸ” Database Info

β–Ό

Test Queries:

Get this incident:

SELECT * FROM incidents WHERE call_id = '2026031701136';

Get alert queue:

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

Get related incidents:

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

Get latest incidents:

SELECT * FROM incidents ORDER BY ai_completed_at DESC LIMIT 10;

Raw Database Record:

{
    "call_id": "2026031701136",
    "headline": "Breathing Problem Reported on North Hamilton Street",
    "description": "Engine 2 dispatched for a 37-year-old male with breathing problems in Apartment 1. Cross streets are Bronson Street and Remington Street.",
    "location": "300 N Hamilton St, Watertown, NY, 13601",
    "agencies": "City of Watertown Fire",
    "incident_type": "BREATHING PROBL",
    "file_name": "WT_47_City_of_Watertown_2026_03_17_01_13_26.mp3",
    "source_file": "WT_47_City_of_Watertown_2026_03_17_01_13_26.mp3",
    "date": "0000-00-00 00:00:00",
    "category": "medical",
    "model_feedback": "Both transcripts closely match: City Fire telephone alarm, Engine 2 to 300 North Hamilton St Apt 1 for a 37-year-old male with breathing problems; cross streets Bronson and Remington. Deepgram's 'Crossridge' interpreted as 'cross streets.' No relationship to the earlier 12:43 AM heart problem call (different address/nature), so treated as a new incident. Medical category \u2192 do not post publicly per publishing rules.",
    "memory": "City of Watertown Fire telephone alarm medical call. Engine 2 dispatched to 300 North Hamilton Street, Apartment 1, Watertown for a 37-year-old male with breathing problems. Cross streets: Bronson Street and Remington Street. Dispatch repeated the assignment.",
    "related_calls": "[]",
    "update_type": "new_incident",
    "severity": "minor",
    "should_post_publicly": 0,
    "transcription": "City fire telephone alarm engine two, respond. 300 North Hamilton Street, Apartment Number 1. 37 year old male. Breathing problems. Repeating for city fire telephone alarm engine two, respond. 300 North Hamilton Street, Apartment Number 1. 37 year old male breathing problem. Crossridge, Bronson Street and Remington Street.",
    "transcription2": "City Fire Telephone Alarm Engine 2, respond 300, North Hamilton Street, apartment number 1, 37-year-old male, breathing problems, repeating for City Fire Telephone Alarm Engine 2, respond 300, North Hamilton Street, apartment number 1, 37-year-old male, breathing problems, cross streets, Bronson Street and Remington Street.",
    "datetime": "2026-03-17 01:13:26",
    "confidence_score": null,
    "audio_hash": null,
    "processing_status": "completed",
    "ai_completed_at": "2026-03-17 01:14:26",
    "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-17T01:14:24.039317\", \"provider\": \"NYS GIS\", \"input_address\": \"300 N Hamilton St, Watertown, NY\", \"validation_result\": \"OK\", \"validated_address\": \"300 N Hamilton St, Watertown, NY, 13601\", \"latitude\": 43.97496341609641, \"longitude\": -75.89312008313632, \"ai_action\": \"accept\", \"ai_reasoning\": \"Transcript and extracted address match exactly (300 N Hamilton St, Apt 1, Watertown). NYS GIS returned a specific street address with ZIP 13601 in Watertown, which is sufficient for emergency response; apartment number is not required for geocoding.\"}], \"summary\": {\"total_attempts\": 1, \"final_outcome\": \"validated\", \"final_address\": \"300 N Hamilton St, Watertown, NY, 13601\", \"processing_time_seconds\": 2.37, \"started_at\": \"2026-03-17T01:14:23.769010\", \"completed_at\": \"2026-03-17T01:14:26.134574\"}}",
    "low_confidence_reason": null,
    "transcription_agreement": "0.59",
    "cad_code": "BREATHING PROBL",
    "incident_type_friendly": "Breathing Problems",
    "type_icon": "medical"
}