Locally-held signal geometry and agency drift (ticket 19, mig 20260821_011). claimed_at NOT NULL means signal.geom is OURS and fn_signal_merge skips it. agency_geom is the last point upstream published and the baseline for moved_ft. A row exists only for a claimed signal or one that has drifted.
agency_geom_moved_at claimed_at claimed_by created_date created_user last_edited_date last_edited_user moved_ft reason row_version signal_id