How the evidence was created, tested and bounded.
This platform was constructed through a staged analytical workflow rather than from a single spreadsheet or browser calculation. Source records were imported into analytical databases, enriched with spatial and directional context, subjected to completeness and evidence-quality gates, transformed into purpose-specific products, and exported into reviewable CSV, JSON, map, graph and web assets. Each public result retains a source stage, calculation meaning and interpretation boundary.
From official source to public conclusion
The browser is a presentation layer. Rankings, profiles and review screens are generated upstream from governed analytical exports rather than calculated ad hoc from the page.
Obtain source files, record provenance, dates, schemas and licences.
Import and normalise records in DuckDB for repeatable SQL analysis.
Attach coordinates, locality, corridor, heading and geographic context.
Apply completeness, density, pairing, temporal and tiering gates.
Create rankings, corrected exposure, temporal, paired-site and speed evidence.
Export reviewable files, integrate the page and test integrity.
01Scope, independence and review statusWhat this method describes and how the platform should be reviewed
Victorian Freight Network Intelligence is an independent analytical publication prepared by Traffic Analytics and published by Spotswood Trailers. It is not an official Victorian Transport Association, Department of Transport and Planning or Victorian Government publication.
The method describes the connected public evidence architecture through Stage 22.0.1 and Stage 23A.4.0, together with the Commercial Gold and West Gate question-register presentation layers. Later products consume governed upstream outputs rather than silently redefining them.
Where the reviewed project materials do not expose an exact threshold or component weight, the value is not guessed. The responsible governed stage artifact remains the controlling source.
02Source datasets and record semanticsTIRTL, SCATS, coordinates, boundaries and what one record actually means
TIRTL classified traffic evidence
TIRTL supplies classified passing records at monitored locations and headings. A TIRTL passing is one detector observation. It is not a unique truck, a unique load, an origin–destination movement or a complete journey. A vehicle may be observed at more than one monitored point.
Official source: Department of Transport and Planning, TIRTL Traffic Counts. The platform separately identifies the official source-availability window and the governed period used by a published analytical release.
SCATS movement evidence
SCATS contributes long-term signal-derived movement observations for general traffic, intersection and local-road context. A SCATS movement must not automatically be described as a unique vehicle count. Coverage and completeness vary by site and date. The detailed upstream SCATS ingestion and cleaning specification belongs to the established SCATS workflow and is not reconstructed from this freight page.
Coordinates and administrative geography
The foundational TIRTL workflow combines the analytical database with site coordinates and official Vicmap locality polygons. Each coordinate-bearing site-heading is treated as a point; the containing locality polygon supplies the locality name. In the documented foundational build, 562 of 562 site-heading rows were matched and zero remained unmatched.
03Data engineering and spatial enrichmentHow technical source files become reviewable analytical products
- Acquire source files and preserve source names, dates, schema and provenance.
- Inspect fields, data types, temporal coverage, site identifiers and heading semantics.
- Import source records into DuckDB and construct repeatable analytical tables.
- Build site and site-heading masters using governed identifiers and coordinate sources.
- Convert required spatial boundaries into analysis-ready geometry.
- Run point-in-polygon and lookup joins for locality, council, electorate or other governed context.
- Create nightly, hourly, corridor-direction, paired-site and speed-evidence tables.
- Write CSV, JSON and GeoJSON products before rendering HTML, maps or graphs.
The primary implementation technologies are DuckDB for analytical storage and SQL aggregation, Python for ingestion, validation, spatial processing and export generation, and PowerShell for repeatable orchestration. The public site is static HTML, CSS and JavaScript with Leaflet maps, Google Charts and generated PNG/SVG graph assets.
Maps distinguish exact detector points from inferred analytical corridor lines. An inferred line connecting monitored locations is a presentation of monitored corridor evidence; it is not necessarily a surveyed or road-centreline-snapped engineering alignment.
04Evidence architectureWhy direction, corrected exposure, timing, paired sites and speed are kept separate
Raw site-heading evidence
One monitored direction at one location. Used for exact sensor inspection, directional volume, truck share and raw overnight rankings.
Corrected corridor-direction exposure
Repeated monitoring is consolidated into governed corridor-direction components before community or political-geography interpretation. This prevents a corridor with more detector headings from automatically receiving proportionally more weight solely because it is monitored more densely.
Temporal freight pressure
Eligible records are organised across the complete eight-hour overnight window from 10 pm to 6 am. The analysis examines onset, peak, persistence and release, subject to complete-hour, outage, source-boundary and daylight-saving rules.
Paired whole-site evidence
Complementary directions are joined only under a governed paired-site identifier. This supports combined two-way freight scale, dominant-direction share, imbalance and balanced-night measures. Arbitrary headings must not be combined.
Point-speed pressure and reliability
Governed truck speed-bin evidence is reconstructed, validated and assigned an evidence tier before public temporal comparison. Relative point-speed measures are suitable for monitored pressure and reliability screening, but not for complete journey-time claims.
05Analytical stage lineageThe dependency chain from raw rankings to governed operator and project questions
| Stage | Purpose | Public role | Status | Key boundary |
|---|---|---|---|---|
| Stage 17 | Direction-level overnight evidence | Raw monitored rankings | Connected | Monitoring density differs by corridor |
| Stage 20.1–20.2 | Density correction and political geography | Corrected community/network exposure | Connected | Monitored evidence, not complete jurisdiction census |
| Stage 21.0.2 | Hourly temporal pressure | Onset, peak and persistence | PASS | Overnight window and exclusion rules apply |
| Stage 22.0.1 | Paired whole-site evidence | Two-way scale, dominance and imbalance | PASS | Pairing rules are fixed and governed |
| Stage 23A.1–23A.3 | Speed provenance, reconstruction and tiering | Validated publication population | PASS | Tier B descriptive; Tier C excluded |
| Stage 23A.4.0 | Pressure and reliability | Relative point-speed ranking and profiles | PASS | Not journey delay or economic loss |
| Commercial Gold | Operator-facing review screens | Pricing, contingency, fuel/wear and opportunity review | Regression PASS | Signals, not recommendations or exact costs |
| Stage 23A.5 | Opening-period segmentation | Clean West Gate comparison | Not built | Fresh coverage and density gates required |
| Stage 23B | Journey-time and delay evidence | Potential journey or productivity products | BLOCKED | Requires linked journeys and governed distances |
06Metric definitions and auditable formulasWhat is calculated exactly and what remains controlled by a stage artifact
Truck share
truck share (%) = 100 × truck passings ÷ all classified vehicle passingsWeighted truck share
weighted truck share (%) = 100 × total truck passings ÷ total vehicle passings across the selected scopeObserved-to-reference speed
observed/reference (%) = 100 × governed observed truck speed ÷ hourly P85 reference speedObserved speed deficit
speed deficit (km/h) = hourly P85 reference speed − governed observed truck speedThe hourly P85 reference is a frozen observed upper-normal point-speed reference for a governed heading and hour. It is not the posted speed limit, an engineering free-flow speed or a pure pre-opening counterfactual.
Pressure and recurrence
Below-90%, below-80% and below-70% occurrence measures report the share of eligible governed hours below each relative threshold. The governed pressure index is a 0–100 composite point-speed measure derived from relative speed and recurrence evidence.
Paired-site measures
Average normalised eight-hour combined trucks represents governed two-direction passings normalised to the full overnight window. Median directional imbalance is the typical absolute difference between paired directional shares. Balanced nights report the share of eligible paired nights satisfying the governed Stage 22 rule.
07Quality gates, evidence tiers and exclusionsHow incomplete or sparse evidence is prevented from entering inappropriate comparisons
Quality gates are applied before evidence enters a public ranking or temporal comparison. Depending on the stage, gates address schema validity, coordinate availability, duplicate handling, complete hours, eligible nights, source boundaries, outages, daylight-saving transitions, evidence density, governed pairing and speed-bin completeness.
| Tier | Current population | Permitted use | Restriction |
|---|---|---|---|
| Tier A | 269 site-headings | Full governed temporal comparison | One direction per heading; monitored evidence only |
| Tier B | 12 site-headings | Long-period descriptive aggregate evidence | Not used for full temporal comparison |
| Tier C | 2 site-headings | Excluded | Must not enter public comparative ranking |
The Stage 23A.4 governed population includes 2,152 reference-ready heading-hours, 374,900 complete speed hours, 46,697 eligible heading-nights and 372,586 eligible pressure observations. Heading-nights are accumulated across headings; they are not unique network-wide calendar nights.
Stage 22 contains 119 governed paired sites. Pair construction must remain fixed. A visually plausible pair is not sufficient unless it exists in the governed paired-site register.
08Missing values and null semanticsWhy unavailable evidence is not silently converted to zero
The workflow distinguishes a measured zero from absent, incomplete, excluded or non-comparable evidence. These states have different meanings and must remain different in analytical tables and public presentation.
- Measured zero: a valid eligible observation exists and the measured quantity is zero.
- No record: no source row is present for the expected scope.
- Incomplete hour: the hour fails the governing completeness rule.
- Detector outage or source boundary: evidence is unavailable because the monitored source is not valid for that interval.
- Excluded evidence: the record or heading fails an evidence gate.
- Not applicable: the metric does not logically apply to the selected evidence object.
- Not derivable: the available datasets cannot support the requested measure.
09Publication, reproducibility and regression QAHow reviewers can inspect more than the rendered webpage
Major stages write explicit analytical files before web integration. These may include source manifests, CSV tables, JSON data products, GeoJSON layers, method notes, QA summaries, graphs and stage packages. The public HTML is therefore not the only evidence object.
Web integrations use explicit START/END markers so a later script can replace its own governed block without rewriting unrelated sections. Integration scripts create timestamped backups, update both the framework and published roots, run structural audits and compare generated asset hashes.
Static QA checks include marker uniqueness, required assets, duplicate IDs, internal-anchor integrity, expected source references, parseable JSON, required downloads and framework-to-published file equality. Browser QA should additionally examine console errors, failed requests, map/chart rendering, keyboard behaviour, mobile overflow and performance.
10Interpretation boundaries and blocked claimsWhat the evidence can describe and what it cannot establish by itself
The connected evidence can describe monitored passings, movements, truck share, directional concentration, corrected exposure, temporal profiles, point-speed pressure, threshold recurrence, persistence and relative reliability.
- unique trucks, unique vehicles, origins, destinations, commodities or load status;
- complete linked journeys, end-to-end travel time or journey delay;
- truck-hours, litres, emissions, maintenance cost or productivity dollars;
- a recommended price, surcharge, tariff or exact schedule buffer;
- a confirmed backload or optimal depot, staging or cross-dock location;
- the cause of a pressure or reliability episode;
- a clean West Gate Tunnel opening benefit or failure verdict from the mixed reference alone.
Stage 23B remains blocked until governed segment distances, linked travel times and complete journey definitions are available. Point-speed evidence must not be converted into journey delay, truck-hours or dollars without those inputs.
11West Gate Tunnel period classificationWhy the current reference is not a pure pre-opening baseline
The Stage 23A.4 frozen reference runs from 1 November 2025 to 21 May 2026. The West Gate Tunnel opened to traffic on 14 December 2025. The reference therefore contains 43 pre-opening nights and 159 nights on or after opening.
The correct classification is a mixed pre-opening, opening-transition and early-operation reference. It is suitable as a frozen reference for later comparisons, but it cannot be described as a pure pre-opening baseline.
A clean opening-effect study requires Stage 23A.5: separately governed pre-opening, transition and stable operating windows, with fresh coverage, density and completeness gates applied to each segment.
Freeze ID: VTA_STAGE23A4_P85_20251101_2026052112Controlled method disclosures and next technical workDetails that must come from responsible stage artifacts rather than reconstruction
This integration publishes every method detail supported by the reviewed project materials. It deliberately does not invent the following:
- exact Stage 17 evidence-class thresholds;
- the exact Stage 20.1 corridor-density correction formula;
- the exact Stage 21 context thresholds and full excluded-night schedule;
- the exact Stage 22 pairing criteria and balanced-night threshold;
- the exact Stage 23A.3 Tier A/B/C threshold values;
- the exact Stage 23A.4 pressure-index weights and sustained-pressure rule;
- the complete upstream SCATS ingestion and cleaning specification;
- the exact construction of the older combined freight-exposure score in the analytics workspace.