Centralized Proposal Management for the Estonian Transport Administration

A feature expansion for the existing Road Maintenance Plan (THK) system that centralizes the entire commenting and proposal workflow. The solution replaces fragmented Excel-based processes with a structured, role-based decision-making environment directly within the legacy application.

About the Client

The Estonian Transport Administration (TRAM) is a government agency responsible for managing traffic on land, in the air, and on water. They ensure infrastructure maintenance and general safety. Their primary tasks include the construction and maintenance of state roads, management of the traffic register (vehicles and licenses), and supervision across all transport modes. Their goal is to provide a safe, convenient, and smart mobility environment for people and businesses.

Client Transpordiamet (TRAM)
Link to the project see here
Start of the project September 2025
End of the project December 2025

Client brief

The Challenge: Fragmented Decision History in Excel

While the Road Maintenance Plan (THK) module had been in use since 2017, its commenting functionality was technically present but practically unusable for modern needs.

Core Problem:

Fragmented and Excel-based Commenting Process. Because the system lacked usable collaborative tools, structured commenting, analysis, and decision justification were carried out outside the system, primarily using Excel spreadsheets and manual email chains.

  • No Single Source of Truth: Decision history was scattered across disparate files, making it impossible to track proposals centrally.

  • Loss of Context: There was a high risk of losing the “why” behind investment decisions as objects progressed from planning to realization.

  • Poor Traceability: It was difficult to audit how specific costs or dates were agreed upon, as the justification was not tied to the data object in the system.

The Solution: Native Integration into Legacy Infrastructure

Wenture developed a Centralized Commenting and Proposal Management feature embedded directly into the existing THK module. The solution was designed to make the workflow a native process, eliminating the need for external workarounds.

Key Technical Components:

  1. Structured Commenting Lists: Dedicated lists created per THK group with strict lifecycle management (active, closed, logically deleted). This allows objects from all phases (initial data, planning, realization) to be managed in a single view.

  2. Role-Based Workflows: The system distinguishes between “Analysis” comments (provided by administrators/managers) and “Proposals” (submitted by other roles).

  3. Mandatory Justification Logic: To ensure data integrity, the system enforces mandatory comments whenever an object’s estimated values (cost, start/end date, work method) are changed or proposed.

  4. Financial Integration: The feature captures expected costs and dates alongside comments, providing aggregated cost calculations directly above the commentation list for better budget visibility.

  5. Auditability & History: Full visibility into who commented, when, and why. The system supports logical deletion, ensuring that even deleted objects and their associated decision history remain traceable.

Tech Stack & Integrations:

The solution was built to integrate seamlessly with the client’s existing legacy stack:

  • Backend: Java 1.8, Spring 4.1.6, WildFly 10.0, Hibernate 4.3.10.

  • Frontend: AngularJS 1.3.11, Bootstrap 3.3.2.

  • Database: PostgreSQL 9.4.

Results & Impact: Structured Governance

The project successfully shifted the client’s workflow from scattered spreadsheets to a centralized, governable system.

Key Results:

  • Centralized Decision Making: All comments, analyses, and proposals are now handled directly in the THK module, creating a single source of truth.

  • Clear Ownership: Introduced the “Meetmejuht” role, giving specific users responsibility for managing deadlines, confirming proposals, and closing lists.

  • Standardized Process: Commenting now follows a uniform workflow regardless of the object’s phase, streamlining collaboration between designers, builders, and administrators.

  • Enhanced Auditability: Every action—adding, modifying, rejecting, or confirming a proposal—is time-stamped and role-restricted, strengthening governance and accountability.