Emerging Road-Harm Hotspots Build Report v0.1
Generated: 2026-06-29T12:02:17
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\20_emerging_hotspots
Baseline: 2012-2019; annualisation years: 8.00
Recent: 2022-2025; annualisation years: 3.83
Crash rows loaded: 198,600
Baseline rows: 114,241
Recent rows: 58,200
Council worsening rows: 38
Location worsening rows: 3,083
VRU location worsening rows: 3,399
Heavy-vehicle location worsening rows: 913
Mechanism worsening rows: 264
Detailed DCA worsening rows: 1,283
Speed-zone worsening rows: 216
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
- dca: DCA_CODE_DESCRIPTION
- road_geometry: ROAD_GEOMETRY
- speed_zone: SPEED_ZONE
- light_condition: LIGHT_CONDITION
- accident_date: accident_date
- year: (not found)
- lat: latitude
- lng: longitude

Main outputs:
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\20_emerging_hotspots\council_worsening_v0_1.csv
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\20_emerging_hotspots\location_worsening_v0_1.csv
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\20_emerging_hotspots\vru_location_worsening_v0_1.csv
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\20_emerging_hotspots\heavy_vehicle_location_worsening_v0_1.csv
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\20_emerging_hotspots\mechanism_worsening_v0_1.csv
- A:\TrafficAnalytics\ROADCRASHDATA\outputs\11_public_site\road_harm_intelligence\emerging-hotspots\index.html

Missing pages: