"""Tables + figures for the report (Data / Setup / Results / Study 1) -> build/report/. Every table is regenerated from build/ outputs, so it always matches the current data and runs. provenance.md every model input: value, measured / derived / assumed, evidence volumes.md PM peak-hour volumes and turn shares per light and approach (+ lanes, effective s) timing.md County PM timing (pattern, cycle, offset, phase splits) and its 2-phase reduction results.md every plan: SUMO delay (mean ± sd over seeds), stops, throughput, formula delay validation.md simulated vs counted volumes (GEH) study1.md Study 1 summary (if run) figures: corridor.png, results.png, (study1 figures live in build/study1/) """ import json, sys, pathlib, tomllib sys.path.insert(0, str(pathlib.Path(__file__).parent)) from common import BUILD, ROOT, corridor import plans as P OUT = BUILD/"report" def md_table(head, rows): s = "| " + " | ".join(head) + " |\n|" + "|".join("---" for _ in head) + "|\n" return s + "".join("| " + " | ".join(str(x) for x in r) + " |\n" for r in rows) def main(): OUT.mkdir(parents=True, exist_ok=True) cor = corridor(); asm = tomllib.load(open(ROOT/"config/assumptions.toml", "rb")) # provenance rows = [] for l in cor["lights"]: for d, A in l["approaches"].items(): rows.append([f"{l['id']} {l['name']}", d, "volume q", f"{A['q_vph']:.0f} veh/h", A["q_source"], A["q_evidence"]]) rows.append([f"{l['id']} {l['name']}", d, "turn shares L/T/R", "/".join(f"{A['turn_share'][k]:.2f}" for k in "LTR"), A["turn_source"], A["turn_evidence"][:120]]) rows.append([f"{l['id']} {l['name']}", d, "lanes", A["lanes"], A["lanes_source"], ""]) rows.append([f"{l['id']} {l['name']}", d, "sat. flow s (model)", f"{A['s_vph']:.0f} veh/h", A["s_source"], A.get("s_evidence", f"{A['lanes']} lanes x {cor['params']['sat_flow_per_lane_vph']}")]) T = l.get("timing") if T: rows.append([f"{l['id']} {l['name']}", "-", "lost time L", f"{T['L_s']} s", "measured", f"County sheet {T['sheet']} ({T['sheet_date']}), {T['lost_time_basis']}"]) rows.append([f"{l['id']} {l['name']}", "-", "current timing", f"C {T['C_s']} s, offset {T['offset_county_s']} s", "measured", f"County pattern {T['pattern']} (PM weekday)"]) for k in cor["links"]: rows.append([f"link {k['from']}->{k['to']}", "-", "length / speed / tau", f"{k['length_m']} m / {k['speed_mps']} m/s / {k['tau_s']} s", f"{k['length_source']} / {k['speed_source']}", k["length_evidence"]]) p = cor["params"] for key, src in (("p", "model_source"), ("g_min_s", "model_source"), ("C_min_s", "model_source"), ("C_max_s", "model_source"), ("x_max", "model_source")): rows.append(["model", "-", key, p[key], p[src], asm["model"]["evidence"]]) dem = json.load(open(BUILD/"sumo/demand.json")) for b in dem.get("balancing", []): rows.append([f"link {b['link']}", b["direction"], "mid-block balancing flow", f"{b['balance_vph']:+.0f} veh/h", b["source"], b["evidence"]]) for key in ("bay_m",): v = tomllib.load(open(ROOT/"config/corridor.toml", "rb")).get("network", {}).get(key) rows.append(["network", "-", "left-turn bay length", f"{v} m", "assumed", "typical urban 75-100 m; not measured"]) (OUT/"provenance.md").write_text("# Input provenance\n\n" + md_table(["where", "approach", "input", "value", "source", "evidence"], rows)) # volumes rows = [[f"{l['id']} {l['name']}", d, f"{A['q_vph']:.0f}", *(f"{A['turn_share'][k]:.2f}" for k in "LTR"), A["lanes"], f"{A['s_vph']:.0f}", A["q_source"]] for l in cor["lights"] for d, A in l["approaches"].items()] (OUT/"volumes.md").write_text(f"# PM peak hour ({cor['meta'].get('design_hour','')}) volumes\n\n" + md_table(["light", "approach", "veh/h", "L", "T", "R", "lanes", "s (model)", "source"], rows)) # timing rows = [] for l in cor["lights"]: T = l.get("timing") if T: rows.append([f"{l['id']} {l['name']}", T["sheet_date"], T["pattern"], T["C_s"], T["offset_county_s"], " ".join(f"{k}:{v}" for k, v in sorted(T["splits"].items(), key=lambda kv: int(kv[0]))), T["main_block_s"], T["side_block_s"], T["g_main_s"], T["L_s"]]) (OUT/"timing.md").write_text("# County timing, PM pattern\n\n" + md_table( ["light", "sheet date", "pattern", "cycle", "offset", "phase splits (s)", "Big Bend block", "cross block", "g_main (2-phase)", "L"], rows)) # results S = json.load(open(BUILD/"results_summary.json")) if (BUILD/"results_summary.json").exists() else {} rows = [] for name, v in sorted(S.items(), key=lambda kv: kv[1]["delay_mean"]): try: pl = P.load(name); fd = P.formula_delay(cor, pl); src = pl["source"]; C = pl["C"] except FileNotFoundError: fd, src, C = None, "", "" rows.append([name, C, f"{v['delay_mean']:.1f} ± {v['delay_sd']:.1f}", f"{v['stops_mean']:.2f}", f"{v['throughput_mean']:.0f}", "n/a" if fd is None else f"{fd:.1f}", v["seeds"], src]) (OUT/"results.md").write_text("# Plan comparison (SUMO, corridor delay in the PM peak hour)\n\n" + md_table( ["plan", "cycle (s)", "SUMO delay veh-h/h", "stops/veh", "throughput veh/h", "formula delay veh-h/h", "seeds", "source"], rows)) # validation if (BUILD/"validation.json").exists(): V = json.load(open(BUILD/"validation.json")) (OUT/"validation.md").write_text("# Validation: simulated vs counted volumes\n\n" + md_table( ["light", "approach", "kind", "counted veh/h", "simulated veh/h", "GEH"], [[f"{r['light']} {r['name']}", r["approach"], r["kind"], r["target_vph"], r["sim_vph"], r["geh"]] for r in V])) if (BUILD/"study1/summary.json").exists(): s = json.load(open(BUILD/"study1/summary.json")) (OUT/"study1.md").write_text("# Study 1 summary\n\n```json\n" + json.dumps(s, indent=1) + "\n```\n") figures(cor, S) print("wrote", ", ".join(sorted(x.name for x in OUT.iterdir()))) def figures(cor, S): import matplotlib; matplotlib.use("Agg"); import matplotlib.pyplot as plt f, ax = plt.subplots(figsize=(4, 6)) xs = [l["lon"] for l in cor["lights"]]; ys = [l["lat"] for l in cor["lights"]] ax.plot(xs, ys, "-", color="0.6"); ax.scatter(xs, ys, s=60, zorder=3) for l in cor["lights"]: A = l["approaches"] ax.annotate(f"{l['name']} (#{l['id']})\nNB {A['NB']['q_vph']:.0f} SB {A['SB']['q_vph']:.0f}\nEB {A['EB']['q_vph']:.0f} WB {A['WB']['q_vph']:.0f}", (l["lon"], l["lat"]), xytext=(8, -4), textcoords="offset points", fontsize=7) for k, (a, b) in zip(cor["links"], zip(cor["lights"], cor["lights"][1:])): ax.annotate(f"{k['length_m']:.0f} m", ((a["lon"]+b["lon"])/2, (a["lat"]+b["lat"])/2), xytext=(-40, 0), textcoords="offset points", fontsize=7) ax.set_title("Big Bend Blvd corridor, PM peak (veh/h)", fontsize=9); ax.set_xticks([]); ax.set_yticks([]) ax.set_xlim(min(xs)-0.004, max(xs)+0.012); f.tight_layout(); f.savefig(OUT/"corridor.png", dpi=150) if S: items = sorted(S.items(), key=lambda kv: kv[1]["delay_mean"]) f, ax = plt.subplots(figsize=(6, 3.2)) ax.barh([k for k, _ in items], [v["delay_mean"] for _, v in items], xerr=[v["delay_sd"] for _, v in items], color="tab:blue") ax.invert_yaxis(); ax.set_xlabel("corridor delay, SUMO (veh-h per hour)"); ax.set_title("Timing plans compared", fontsize=9) f.tight_layout(); f.savefig(OUT/"results.png", dpi=150) if __name__ == "__main__": main()