Freight Conflict Index Build Report v0.1
Generated: 2026-06-29T12:16:03
Data dir: A:\TrafficAnalytics\ROADCRASHDATA
DB: A:\TrafficAnalytics\ROADCRASHDATA\road_crash.duckdb
Table: road_crash_location_enriched
Summary dir: A:\TrafficAnalytics\ROADCRASHDATA\outputs\08b_all_council_summary_cleaned_v0_2
Site root: A:\TrafficAnalytics\ROADCRASHDATA\outputs\11_public_site\road_harm_intelligence
Output dir: A:\TrafficAnalytics\ROADCRASHDATA\outputs\22_freight_conflict_index
Crash rows loaded: 198,600
Heavy-vehicle crash rows: 8,967
Councils: 79
TIRTL council summary rows: 16
TIRTL site summary rows: 252
TIRTL matched HV crash rows: 1,133
Public council pages created: 79
Council report pages patched: 79
Homepage patched: True
Missing council report 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
- heavy_vehicle_crash: heavy_vehicle_crash
- heavy_vehicles: heavy_vehicles
- pedestrian_crash: pedestrian_crash
- bicyclist_crash: bicyclist_crash
- motorcyclist_crash: motorcyclist_crash
- dca: DCA_CODE_DESCRIPTION
- road_geometry: ROAD_GEOMETRY
- speed_zone: SPEED_ZONE
- light_condition: LIGHT_CONDITION
- traffic_control: (not found)
- accident_date: accident_date
- year: crash_year
- lat: latitude
- lng: longitude

Main outputs:
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\22_freight_conflict_index\freight_conflict_council_summary_v0_1.csv
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\22_freight_conflict_index\freight_conflict_tirtl_site_priority_v0_1.csv
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\22_freight_conflict_index\heavy_vehicle_location_priority_v0_1.csv
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\22_freight_conflict_index\freight_vru_conflict_locations_v0_1.csv
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\22_freight_conflict_index\heavy_vehicle_mechanism_by_council_v0_1.csv
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\22_freight_conflict_index\heavy_vehicle_dca_by_council_v0_1.csv
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\22_freight_conflict_index\heavy_vehicle_speed_by_council_v0_1.csv
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\22_freight_conflict_index\heavy_vehicle_geometry_by_council_v0_1.csv
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\22_freight_conflict_index\heavy_vehicle_light_by_council_v0_1.csv
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\22_freight_conflict_index\tirtl_matched_hv_crashes_v0_1.csv
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\11_public_site\road_harm_intelligence\freight-conflict\index.html

Missing pages: