Council Safety Diagnosis Build Report v0.1
Generated: 2026-06-29T11:56:50
Data dir: A:\TrafficAnalytics\ROADCRASHDATA
DB: A:\TrafficAnalytics\ROADCRASHDATA\road_crash.duckdb
Table: road_crash_location_enriched
Site root: A:\TrafficAnalytics\ROADCRASHDATA\outputs\11_public_site\road_harm_intelligence
Output dir: A:\TrafficAnalytics\ROADCRASHDATA\outputs\19_council_safety_diagnosis
Crash rows loaded: 198,600
Councils diagnosed: 79
Council pages patched: 79
Homepage patched: True
Missing council pages: 0

Column mapping used:
- accident_no: ACCIDENT_NO
- lga_name: lga_name
- location_label: location_label
- fatalities: fatalities
- serious_injuries: serious_injuries
- other_injuries: other_injuries
- harm_score: harm_score
- pedestrian: pedestrian_crash
- bicyclist: bicyclist_crash
- motorcyclist: (not found)
- heavy_vehicle: heavy_vehicle_crash
- dca: DCA_CODE_DESCRIPTION
- road_geometry: ROAD_GEOMETRY
- speed_zone: SPEED_ZONE
- light_condition: LIGHT_CONDITION
- road_surface: (not found)
- traffic_control: (not found)
- accident_date: accident_date
- year: (not found)
- lat: latitude
- lng: longitude

Missing pages:

Main outputs:
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\19_council_safety_diagnosis\all_council_safety_diagnosis_summary_v0_1.csv
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\19_council_safety_diagnosis\all_council_safety_diagnosis_top_dimension_rows_v0_1.csv
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\11_public_site\road_harm_intelligence\diagnosis\index.html