> About_Me

# PTC Track/Switch Coincidence Detection
# ArcGIS Pro | Python 3 | Branch Versioning

import arcpy
from arcpy import env

def detect_coincidence(track_fc, switch_fc, tolerance):
    """Identify track/switch spatial coincidence
    within PTC operational boundaries."""

    env.workspace = r"Database Connections\PTC_PROD.sde"

    # Create spatial index for performance
    arcpy.AddSpatialIndex_management(track_fc)

    # Near analysis for coincidence detection
    near_table = arcpy.GenerateNearTable_analysis(
        in_features=track_fc,
        near_features=switch_fc,
        out_table="in_memory\\near_tbl",
        search_radius=f"{tolerance} Feet",
        closest="ALL"
    )

    arcpy.AddMessage(
        f"Found {arcpy.GetCount_management(near_table)[0]}"
        f" coincidence candidates"
    )
    return near_table

SELECT
    t.subdivision_name,
    t.track_class,
    t.max_permissible_speed,
    s.switch_id,
    SDO_GEOM.SDO_DISTANCE(
        t.shape, s.shape, 0.005, 'unit=FOOT'
    ) AS distance_ft
FROM
    ptc_track t
JOIN
    ptc_switches s
    ON SDO_WITHIN_DISTANCE(
        s.shape, t.shape,
        'distance=50 unit=FOOT'
    ) = 'TRUE'
WHERE
    t.division = 'PIEDMONT'
    AND t.track_status = 'ACTIVE'
ORDER BY
    distance_ft ASC;