Link-based simulation results

These tables stores different types of data provided by TRE.

RLIN_TSYS_TRE
RLIN_TSYS_TRE_RLTM
RLIN_TSYS_TRE_FORE
RLIN_TSYS_TRE_EQUA

Important: The following tables must have the same structure, since the software makes copies from these tables without analyzing the attributes.

Simulation results – RLIN_TSYS_TRE table

The tables RLIN_TSYS_TRE* store flow, speed, and state results produced by TRE.

Results are based on links and transport systems.

Some results are calculated as instant values (generally the .

Some results are calculated as average values; all average values are "averages over time", based on a "results time period" composed of several "simulations periods". For every simulation period is calculated a specific result and all results are used to calculate the average values.

RLIN_TSYS_TRE_# tables may be used to store results from past days.

The numeric suffix # is added to indicate the number of days before the current date.

Attribute	Type	Unit	Validity	Description	Default
SIMU ^U	Integer	ID	[SIMU.IDNO]	Simulation ID.	serial
LINK ^U	Integer	ID	[LINK.IDNO]	Link ID.
FNOD ^U	Integer	ID	[NODE.IDNO]	Link tail ID.
SDAY ^U	Integer	yyyyMMdd		Simulation day.
INST ^U	Integer	HHmmss		Instant coinciding with the final time of the simulation interval (see also ENDTIME).
FORE	Integer	s	≥ 0	Time gap between the expected export time of the simulation results and the end time of the simulation interval. It indicates the distance between the availability of the forecast results (when the results are stored in the DB), and the end time of the simulation that generated the forecast. This value is rounded to the closest multiple of the duration of the result interval. Important: This information is static and not applicable for real-time requests, which would require a continuous update of this attribute.	900
TSYS ^U	Integer	ID	[TSYS.IDNO]	Transport system ID null = equivalent values.	null
TIME	Real	s	≥ 0	Travel time, considered in the final instant.
IFLW	Real	veh/h	≥ 0	Average of input flows.
OFLW	Real	veh/h	≥ 0	Average of output flows.
OUCA	Real	veh/h	≥ 0	Average of the exit capacity.
NVEH	Real	veh	≥ 0	Average of the number of vehicles.
QUEU	Real	veh	≥ 0	Average of the number of vehicles in queue (in hypercritical state), including: The under-saturation queue due to delays (for example, yield or stop signs, traffic lights). ESTA is anyhow hypocritical and the link is not considered congested. The over-saturation queue due to intense traffic flow.
QUEL	Real	coef	[0, 1]	Average of the length of the queue (as link length share).
QUEN	Real	coef	[0, 1]	Average of the share of queuing vehicles.
ISTA	Integer	option	{0, 1, 2, … 6}	Instant value for the entry section traffic state. Admitted values: 0=Hypocritical 1= Hypercritical (generic) 2=Hypercritical due to insufficient entry capacity 3= Hypercritical due to spillback (queue along the link itself) 4= Hypercritical due to gridlock 6 = Hypercritical due to road closure (Values 2 and 5 are not used.)
ESTA	Integer	option	{0, 1, 2, … 6}	Instant value for the exit section traffic state. Admitted values: 0=Hypocritical 1=Hypercritical (generic) 2=Hypercritical due to insufficient exit capacity 3=Hypercritical due to spillback 4=Hypercritical due to gridlock 5=Hypercritical due to red light 6=Hypercritical due to road closure
FLOW	Real	veh/h	≥ 0	Space average flow.
DENS	Real	veh/km	≥ 0	Space average density.
SPED	Real	km/h	≥ 0	Average speed, calculated as the weighted average (over time) of hypercritical and hypocritical speed. The number of hypercritical and hypocritical vehicles are the weights used to compute the average speed.
STOR	Real	veh	≥ 0	Vertical storage??????
SPEED_RATIO	Real		[0, 1]	Average over time of the free flow speed ratio.
STARTTIME	Timestamp	datetime		Start time of the simulation interval.
ENDTIME	Timestamp	datetime		End time of the simulation interval.