πŸ”§ Processing Diagnostics completed

πŸ“Š Core Incident Data

call_id 2026031708196
incident_type WIRES/TREE DOWN
headline Third Activation for Snapped Power Line on Elm Ridge Road
description Dispatch advises a snapped power line at the address, near Sandy Hollow and Hall. This is a re-page/third activation for the same incident.
location 32125 Elm Ridge Rd, Philadelphia, NY, 13673
agencies Theresa Fire
datetime 2026-03-17 08:19:16
category other
severity minor
update_type related_activation

🎯 Processing & Status

processing_status completed
ai_completed_at 2026-03-17 08:20:18
confidence_score not set
should_post_publicly NO
pre_alert_sent NO
summary_alert_sent YES
audio_hash not set
file_name JE_42_Theresa_Fire_2026_03_17_08_19_16.mp3
source_file JE_42_Theresa_Fire_2026_03_17_08_19_16.mp3

πŸ—ΊοΈ Location Validation Process

βœ“ Successfully Validated

Final Address: 32125 Elm Ridge Rd, Philadelphia, NY, 13673

1 Attempt
1.63s processing time

Validation Attempts Timeline:

Attempt #1 - NYS GIS βœ“
8:20:16 AM
OK
Input Address:
32125 Elm Ridge Rd, Philadelphia, NY 13673
βœ“ Validated Address:
32125 Elm Ridge Rd, Philadelphia, NY, 13673
πŸ“ 44.1337885, -75.7680983 View on Map β†—
AI Decision: ACCEPT
"NYS GIS returned an exact match for the dispatched address: 32125 Elm Ridge Rd, Philadelphia, NY 13673. Street name, house number, municipality, and ZIP are consistent with the transcript and are specific enough for emergency response."

πŸ”§ Technical Details

β–Ό
Started At 03/17/2026 8:20:16 AM
Completed At 03/17/2026 8:20:18 AM
Total Processing Time 1.63 seconds
Outcome Code validated

Raw JSON Data:

{
    "attempts": [
        {
            "attempt_number": 1,
            "timestamp": "2026-03-17T08:20:16.767794",
            "provider": "NYS GIS",
            "input_address": "32125 Elm Ridge Rd, Philadelphia, NY 13673",
            "validation_result": "OK",
            "validated_address": "32125 Elm Ridge Rd, Philadelphia, NY, 13673",
            "latitude": 44.133788532145566,
            "longitude": -75.7680983420229,
            "ai_action": "accept",
            "ai_reasoning": "NYS GIS returned an exact match for the dispatched address: 32125 Elm Ridge Rd, Philadelphia, NY 13673. Street name, house number, municipality, and ZIP are consistent with the transcript and are specific enough for emergency response."
        }
    ],
    "summary": {
        "total_attempts": 1,
        "final_outcome": "validated",
        "final_address": "32125 Elm Ridge Rd, Philadelphia, NY, 13673",
        "processing_time_seconds": 1.63,
        "started_at": "2026-03-17T08:20:16.767426",
        "completed_at": "2026-03-17T08:20:18.397229"
    }
}

πŸ”Š Audio Playback

File: /audio/JE_42_Theresa_Fire_2026_03_17_08_19_16.mp3

πŸ“ Primary Transcription (OpenAI)

Evansville fire, third activation. Theresa fire, mutual aid. Power line snapped. 32125 Elm Ridge Road. Repeating, Evansville fire, third activation. Theresa fire, mutual aid. Power line snapped. 32125 Elm Ridge Road crosses Sandy Hollow and Hall.

πŸ“ Secondary Transcription (Whisper)

Evans Mills Fire, 3rd Activation, Theresa Fire, Mutual Aid, power line snapped, 32125, Elm Ridge Road, repeating, Evans Mills Fire, 3rd Activation, Theresa Fire, Mutual Aid, power line snapped, 32125, Elm Ridge Road, crosses Sandy Hollow and Hall.

πŸ€– AI Context & Reasoning

Model Feedback:

Both transcripts clearly indicate: third activation, mutual aid, snapped power line, 32125 Elm Ridge Road, with crosses Sandy Hollow and Hall. Recent history shows the same address/nature originally dispatched to Philadelphia Fire (2026031707482) and then a third activation with Evans Mills mutual aid (2026031708020). This call is best treated as another re-page/continuation of that same wires incident; linked both prior call IDs for correlation. Agency extraction is constrained by filename metadata: Dept#42 Theresa Fire is confirmed; transcript mentions Evans Mills but that agency is not present in this file metadata. Location city set to Philadelphia based on recent history for 32125 Elm Ridge Rd. Not posted publicly because related_activation with no major new operational info.

Memory/Context:

Audio file JE_42_Theresa_Fire_2026_03_17_08_19_16.mp3: Third activation (re-page) for Theresa Fire; mutual aid referenced; incident is a snapped power line at 32125 Elm Ridge Road, Philadelphia, NY 13673. Cross streets/nearby roads: Sandy Hollow and Hall. Dispatch repeats assignment and location.

πŸ”— Related Calls Timeline

07:48:32 - Power Line Snapped on Elm Ridge Road
Call ID: 2026031707482 | Type: new_incident
08:02:40 - Third Activation for Snapped Power Line on Elm Ridge
Call ID: 2026031708020 | Type: related_activation
08:19:16 - Third Activation for Snapped Power Line on Elm Ridge Road
Call ID: 2026031708196 | Type: related_activation

πŸ” Database Info

β–Ό

Test Queries:

Get this incident:

SELECT * FROM incidents WHERE call_id = '2026031708196';

Get alert queue:

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

Get related incidents:

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

Get latest incidents:

SELECT * FROM incidents ORDER BY ai_completed_at DESC LIMIT 10;

Raw Database Record:

{
    "call_id": "2026031708196",
    "headline": "Third Activation for Snapped Power Line on Elm Ridge Road",
    "description": "Dispatch advises a snapped power line at the address, near Sandy Hollow and Hall. This is a re-page/third activation for the same incident.",
    "location": "32125 Elm Ridge Rd, Philadelphia, NY, 13673",
    "agencies": "Theresa Fire",
    "incident_type": "WIRES/TREE DOWN",
    "file_name": "JE_42_Theresa_Fire_2026_03_17_08_19_16.mp3",
    "source_file": "JE_42_Theresa_Fire_2026_03_17_08_19_16.mp3",
    "date": "0000-00-00 00:00:00",
    "category": "other",
    "model_feedback": "Both transcripts clearly indicate: third activation, mutual aid, snapped power line, 32125 Elm Ridge Road, with crosses Sandy Hollow and Hall. Recent history shows the same address/nature originally dispatched to Philadelphia Fire (2026031707482) and then a third activation with Evans Mills mutual aid (2026031708020). This call is best treated as another re-page/continuation of that same wires incident; linked both prior call IDs for correlation. Agency extraction is constrained by filename metadata: Dept#42 Theresa Fire is confirmed; transcript mentions Evans Mills but that agency is not present in this file metadata. Location city set to Philadelphia based on recent history for 32125 Elm Ridge Rd. Not posted publicly because related_activation with no major new operational info.",
    "memory": "Audio file JE_42_Theresa_Fire_2026_03_17_08_19_16.mp3: Third activation (re-page) for Theresa Fire; mutual aid referenced; incident is a snapped power line at 32125 Elm Ridge Road, Philadelphia, NY 13673. Cross streets/nearby roads: Sandy Hollow and Hall. Dispatch repeats assignment and location.",
    "related_calls": "[\"2026031707482\", \"2026031708020\"]",
    "update_type": "related_activation",
    "severity": "minor",
    "should_post_publicly": 0,
    "transcription": "Evansville fire, third activation. Theresa fire, mutual aid. Power line snapped. 32125 Elm Ridge Road. Repeating, Evansville fire, third activation. Theresa fire, mutual aid. Power line snapped. 32125 Elm Ridge Road crosses Sandy Hollow and Hall.",
    "transcription2": "Evans Mills Fire, 3rd Activation, Theresa Fire, Mutual Aid, power line snapped, 32125, Elm Ridge Road, repeating, Evans Mills Fire, 3rd Activation, Theresa Fire, Mutual Aid, power line snapped, 32125, Elm Ridge Road, crosses Sandy Hollow and Hall.",
    "datetime": "2026-03-17 08:19:16",
    "confidence_score": null,
    "audio_hash": null,
    "processing_status": "completed",
    "ai_completed_at": "2026-03-17 08:20:18",
    "pre_alert_sent": 0,
    "summary_alert_sent": 1,
    "latitude": null,
    "longitude": null,
    "follow_up_alerts_sent": "[\"2026031707482\", \"2026031708020\"]",
    "detected_tones": "[\"42\"]",
    "location_validation_log": "{\"attempts\": [{\"attempt_number\": 1, \"timestamp\": \"2026-03-17T08:20:16.767794\", \"provider\": \"NYS GIS\", \"input_address\": \"32125 Elm Ridge Rd, Philadelphia, NY 13673\", \"validation_result\": \"OK\", \"validated_address\": \"32125 Elm Ridge Rd, Philadelphia, NY, 13673\", \"latitude\": 44.133788532145566, \"longitude\": -75.7680983420229, \"ai_action\": \"accept\", \"ai_reasoning\": \"NYS GIS returned an exact match for the dispatched address: 32125 Elm Ridge Rd, Philadelphia, NY 13673. Street name, house number, municipality, and ZIP are consistent with the transcript and are specific enough for emergency response.\"}], \"summary\": {\"total_attempts\": 1, \"final_outcome\": \"validated\", \"final_address\": \"32125 Elm Ridge Rd, Philadelphia, NY, 13673\", \"processing_time_seconds\": 1.63, \"started_at\": \"2026-03-17T08:20:16.767426\", \"completed_at\": \"2026-03-17T08:20:18.397229\"}}",
    "low_confidence_reason": null,
    "transcription_agreement": "0.26",
    "cad_code": "WIRES/TREE DOWN",
    "incident_type_friendly": "Wires or Trees Down",
    "type_icon": "other"
}