πŸ”§ Processing Diagnostics completed

πŸ“Š Core Incident Data

call_id 2026031707482
incident_type WIRES/TREE DOWN
headline Power Line Snapped on Elm Ridge Road
description A power line is reported snapped with low-hanging wires next to the roadway.
location 32125 Elm Ridge Rd, Philadelphia, NY, 13673
agencies Philadelphia Fire
datetime 2026-03-17 07:48:32
category other
severity minor
update_type new_incident

🎯 Processing & Status

processing_status completed
ai_completed_at 2026-03-17 07:49:14
confidence_score not set
should_post_publicly YES
pre_alert_sent NO
summary_alert_sent YES
audio_hash not set
file_name JE_35_Philadelphia_Fire_2026_03_17_07_48_32.mp3
source_file JE_35_Philadelphia_Fire_2026_03_17_07_48_32.mp3

πŸ—ΊοΈ Location Validation Process

βœ“ Successfully Validated

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

1 Attempt
1.95s processing time

Validation Attempts Timeline:

Attempt #1 - NYS GIS βœ“
7:49:12 AM
OK
Input Address:
32125 Elm Ridge Rd, Philadelphia, NY
βœ“ 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 same address stated in the transcript: 32125 Elm Ridge Rd, Philadelphia, NY 13673. This is a specific street address in Jefferson County and is usable for emergency response without further retries."

πŸ”§ Technical Details

β–Ό
Started At 03/17/2026 7:49:12 AM
Completed At 03/17/2026 7:49:13 AM
Total Processing Time 1.95 seconds
Outcome Code validated

Raw JSON Data:

{
    "attempts": [
        {
            "attempt_number": 1,
            "timestamp": "2026-03-17T07:49:12.266403",
            "provider": "NYS GIS",
            "input_address": "32125 Elm Ridge Rd, Philadelphia, NY",
            "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 same address stated in the transcript: 32125 Elm Ridge Rd, Philadelphia, NY 13673. This is a specific street address in Jefferson County and is usable for emergency response without further retries."
        }
    ],
    "summary": {
        "total_attempts": 1,
        "final_outcome": "validated",
        "final_address": "32125 Elm Ridge Rd, Philadelphia, NY, 13673",
        "processing_time_seconds": 1.95,
        "started_at": "2026-03-17T07:49:12.042838",
        "completed_at": "2026-03-17T07:49:13.993877"
    }
}

πŸ”Š Audio Playback

File: /audio/JE_35_Philadelphia_Fire_2026_03_17_07_48_32.mp3

πŸ“ Primary Transcription (OpenAI)

Fire. Power line snapped. Low hanging wires. 32125 Elm Ridge Road. Repeating. Philadelphia Fire. Power line snapped. Low hanging wires next to road. 32125 Elm Ridge Road.

πŸ“ Secondary Transcription (Whisper)

Philadelphia Fire, power line snapped, low hanging wires, 3-2-1-2-5 Elmridge Road, repeating Philadelphia Fire, power line snapped, low hanging wires next to road, 3-2-1-2-5 Elmridge Road.

πŸ€– AI Context & Reasoning

Model Feedback:

Both transcripts closely match: 'power line snapped' and 'low hanging wires next to road' at 32125 Elm Ridge/Elmridge Road. Interpreted as a wires/down-type call; closest approved CAD code is WIRES/TREE DOWN (used for downed/low wires even without a tree). Agency derived from filename: Philadelphia Fire. No related incidents in recent history for same location/agency, so new_incident. Location formatted as Elm Ridge Rd in Philadelphia, NY.

Memory/Context:

Philadelphia Fire dispatched for a snapped power line with low-hanging wires next to the road at 32125 Elm Ridge Road, Philadelphia. No additional hazards (arcing/fire/pole down/road blockage) mentioned in the dispatch audio.

πŸ”— 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 = '2026031707482';

Get alert queue:

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

Get related incidents:

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

Get latest incidents:

SELECT * FROM incidents ORDER BY ai_completed_at DESC LIMIT 10;

Raw Database Record:

{
    "call_id": "2026031707482",
    "headline": "Power Line Snapped on Elm Ridge Road",
    "description": "A power line is reported snapped with low-hanging wires next to the roadway.",
    "location": "32125 Elm Ridge Rd, Philadelphia, NY, 13673",
    "agencies": "Philadelphia Fire",
    "incident_type": "WIRES/TREE DOWN",
    "file_name": "JE_35_Philadelphia_Fire_2026_03_17_07_48_32.mp3",
    "source_file": "JE_35_Philadelphia_Fire_2026_03_17_07_48_32.mp3",
    "date": "0000-00-00 00:00:00",
    "category": "other",
    "model_feedback": "Both transcripts closely match: 'power line snapped' and 'low hanging wires next to road' at 32125 Elm Ridge/Elmridge Road. Interpreted as a wires/down-type call; closest approved CAD code is WIRES/TREE DOWN (used for downed/low wires even without a tree). Agency derived from filename: Philadelphia Fire. No related incidents in recent history for same location/agency, so new_incident. Location formatted as Elm Ridge Rd in Philadelphia, NY.",
    "memory": "Philadelphia Fire dispatched for a snapped power line with low-hanging wires next to the road at 32125 Elm Ridge Road, Philadelphia. No additional hazards (arcing/fire/pole down/road blockage) mentioned in the dispatch audio.",
    "related_calls": "[\"2026031708020\", \"2026031708196\"]",
    "update_type": "new_incident",
    "severity": "minor",
    "should_post_publicly": 1,
    "transcription": "Fire. Power line snapped. Low hanging wires. 32125 Elm Ridge Road. Repeating. Philadelphia Fire. Power line snapped. Low hanging wires next to road. 32125 Elm Ridge Road.",
    "transcription2": "Philadelphia Fire, power line snapped, low hanging wires, 3-2-1-2-5 Elmridge Road, repeating Philadelphia Fire, power line snapped, low hanging wires next to road, 3-2-1-2-5 Elmridge Road.",
    "datetime": "2026-03-17 07:48:32",
    "confidence_score": null,
    "audio_hash": null,
    "processing_status": "completed",
    "ai_completed_at": "2026-03-17 07:49:14",
    "pre_alert_sent": 0,
    "summary_alert_sent": 1,
    "latitude": null,
    "longitude": null,
    "follow_up_alerts_sent": null,
    "detected_tones": "[\"35\"]",
    "location_validation_log": "{\"attempts\": [{\"attempt_number\": 1, \"timestamp\": \"2026-03-17T07:49:12.266403\", \"provider\": \"NYS GIS\", \"input_address\": \"32125 Elm Ridge Rd, Philadelphia, NY\", \"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 same address stated in the transcript: 32125 Elm Ridge Rd, Philadelphia, NY 13673. This is a specific street address in Jefferson County and is usable for emergency response without further retries.\"}], \"summary\": {\"total_attempts\": 1, \"final_outcome\": \"validated\", \"final_address\": \"32125 Elm Ridge Rd, Philadelphia, NY, 13673\", \"processing_time_seconds\": 1.95, \"started_at\": \"2026-03-17T07:49:12.042838\", \"completed_at\": \"2026-03-17T07:49:13.993877\"}}",
    "low_confidence_reason": null,
    "transcription_agreement": "0.89",
    "cad_code": "WIRES/TREE DOWN",
    "incident_type_friendly": "Wires or Trees Down",
    "type_icon": "other"
}