j AS (
SELECT h.the_geom, h.trip_id, h.stop_id_array, h.reverse, h.offset_id,
(-0.5*i.overlap_count+(h.offset_id-0.5)) AS offset_dist
FROM h
JOIN i
ON h.the_geom = i.the_geom
)