Methodology, governance and reproducibility

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.

12+ yearsSCATS movement history, with coverage varying by site and date
3.13B+TIRTL classified sensor records represented by the platform
159.6M+classified truck passings, not unique trucks or journeys
269Tier A site-headings suitable for full governed temporal comparison
119governed paired whole-site freight locations
202 dayscurrent governed TIRTL analytical window, 1 Nov 2025–21 May 2026

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.

01Source acquisition

Obtain source files, record provenance, dates, schemas and licences.

02Database construction

Import and normalise records in DuckDB for repeatable SQL analysis.

03Spatial and directional enrichment

Attach coordinates, locality, corridor, heading and geographic context.

04Evidence classification

Apply completeness, density, pairing, temporal and tiering gates.

05Analytical products

Create rankings, corrected exposure, temporal, paired-site and speed evidence.

06Publication and regression QA

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.

Review principle: a technical reviewer should be able to move from a public finding to its metric definition, source stage, coverage window, quality status, downloadable table and interpretation boundary.

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.

Geographic boundary: the locality identifies the polygon containing the detector point. It does not mean all corridor effects are confined to that locality, and it does not make the output a complete council- or suburb-wide census.
03Data engineering and spatial enrichmentHow technical source files become reviewable analytical products
  1. Acquire source files and preserve source names, dates, schema and provenance.
  2. Inspect fields, data types, temporal coverage, site identifiers and heading semantics.
  3. Import source records into DuckDB and construct repeatable analytical tables.
  4. Build site and site-heading masters using governed identifiers and coordinate sources.
  5. Convert required spatial boundaries into analysis-ready geometry.
  6. Run point-in-polygon and lookup joins for locality, council, electorate or other governed context.
  7. Create nightly, hourly, corridor-direction, paired-site and speed-evidence tables.
  8. 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.

Separation of concerns: the public browser does not create the governed evidence from raw source rows. It reads generated analytical assets. This prevents a display interaction from changing the upstream metric definition.

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
Connected and proposed analytical stages. The downloadable lineage CSV provides the expanded register.
StagePurposePublic roleStatusKey boundary
Stage 17Direction-level overnight evidenceRaw monitored rankingsConnectedMonitoring density differs by corridor
Stage 20.1–20.2Density correction and political geographyCorrected community/network exposureConnectedMonitored evidence, not complete jurisdiction census
Stage 21.0.2Hourly temporal pressureOnset, peak and persistencePASSOvernight window and exclusion rules apply
Stage 22.0.1Paired whole-site evidenceTwo-way scale, dominance and imbalancePASSPairing rules are fixed and governed
Stage 23A.1–23A.3Speed provenance, reconstruction and tieringValidated publication populationPASSTier B descriptive; Tier C excluded
Stage 23A.4.0Pressure and reliabilityRelative point-speed ranking and profilesPASSNot journey delay or economic loss
Commercial GoldOperator-facing review screensPricing, contingency, fuel/wear and opportunity reviewRegression PASSSignals, not recommendations or exact costs
Stage 23A.5Opening-period segmentationClean West Gate comparisonNot builtFresh coverage and density gates required
Stage 23BJourney-time and delay evidencePotential journey or productivity productsBLOCKEDRequires 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 passings

Weighted truck share

weighted truck share (%) = 100 × total truck passings ÷ total vehicle passings across the selected scope

Observed-to-reference speed

observed/reference (%) = 100 × governed observed truck speed ÷ hourly P85 reference speed

Observed speed deficit

speed deficit (km/h) = hourly P85 reference speed − governed observed truck speed

The 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.

Controlled formula disclosure: the exact pressure-index component weights and sustained-pressure rule are not reconstructed from presentation outputs. The Stage 23A.4 calculation artifact remains authoritative.

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.

Stage 23A evidence tiers and current governed publication population.
TierCurrent populationPermitted useRestriction
Tier A269 site-headingsFull governed temporal comparisonOne direction per heading; monitored evidence only
Tier B12 site-headingsLong-period descriptive aggregate evidenceNot used for full temporal comparison
Tier C2 site-headingsExcludedMust 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.

West Gate Bridge controlled exception: the public method retains the governed synthetic bridge-asset exception and completed legacy validation. The exception does not, by itself, remove either bridge direction from Tier A.
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.
Zero-filling prohibition: missing, excluded or unavailable evidence is not interpreted as zero traffic, zero pressure or zero impact.
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.

Reproducibility principle: a reviewer does not need to trust the visual design alone. The methodology manifest, stage lineage, metric dictionary, evidence register and governed analytical downloads provide separate inspection routes.
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.

The current evidence does not, by itself, establish:
  • 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_20260521
12Controlled 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.
Next technical-method stage: extract these values directly from the current governed manifests, QA reports or calculation code, publish them in a versioned method supplement and link each public metric to the exact controlling formula.