Vulnerable Road User Atlas Build Report v0.1
Generated: 2026-06-29T12:09:34
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\21_vulnerable_road_user_atlas
Crash rows loaded: 198,600
VRU crash rows: 36,451
Councils: 79
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
- pedestrian: pedestrian_crash
- bicyclist: bicyclist_crash
- motorcyclist: (not found)
- heavy_vehicle: heavy_vehicle_crash
- child_ped_cyclist_5_12: ped_cyclist_5_12
- teen_ped_cyclist_13_18: ped_cyclist_13_18
- old_ped_65_plus: old_ped_65_and_over
- age_group: (not found)
- road_user_type: (not found)
- vehicle_type: (not found)
- 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: (not found)
- lat: latitude
- lng: longitude

Main outputs:
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\21_vulnerable_road_user_atlas\vru_council_summary_v0_1.csv
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\21_vulnerable_road_user_atlas\vru_top_locations_v0_1.csv
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\21_vulnerable_road_user_atlas\pedestrian_top_locations_v0_1.csv
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\21_vulnerable_road_user_atlas\bicyclist_top_locations_v0_1.csv
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\21_vulnerable_road_user_atlas\motorcyclist_top_locations_v0_1.csv
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\11_public_site\road_harm_intelligence\vulnerable-road-users\index.html

Missing pages: