Layout_Model_Simulation

Tables

public.path_resu
public.path_resu_link
public.rlin_tsys_tre
public.rlin_tsys_tre_equa
public.rlin_tsys_tre_fore
public.rlin_tsys_tre_midterm
public.rlin_tsys_tre_planning
public.rlin_tsys_tre_roll_hor
public.rlin_tsys_tre_scen
public.rpath_tsys_tre_rltm
public.rtur_tsys_tre
public.rtur_tsys_tre_equa
public.rtur_tsys_tre_fore
public.rtur_tsys_tre_midterm
public.rtur_tsys_tre_rltm
public.tprb

Schema public

standard public schema

Table public.path_resu

It stores the private paths configured in Visum. It contains, in a different way, the values of the table Paths of Visum.

Idx	Field Name	Data Type	Description
*	idno	integer DEFAULT nextval('path_resu_idno_seq'::regclass)	Contains the identity number of the path. It is an auto-incremental field; Unit: N.A.; Possible Values: N.A.
	code	varchar(255) DEFAULT NULL::character varying	Contains the code associated with the NAME of the table Paths in Visum; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
	shap	geometry	Contains the shape which represents the geometry of the path; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
Indexes
	path_resu_pkey	ON idno
Referring Foreign Keys
	path_resu_link_path_fkey	(idno) ← path_resu_link(path)

Table public.path_resu_link

It stores the private paths configured in Visum. It contains, in a different way, the values of the table Path Items of Visum.

Idx	Field Name	Data Type	Description
*	idno	integer DEFAULT nextval('path_resu_link_idno_seq'::regclass)	Contains the identity number of the path items. It is an auto-incremental field; Unit: N.A.; Possible Values: N.A.
	link	integer	Generally contains the idno of the table link (link.idno) associated to this item. But could be also contain street.idno if the application (for examaple, Hyperpath) is managing a street; Unit: N.A.; Possible Values: N.A.
	fromNode	integer	Contains the idno of the table node which represents the from node value; Unit: N.A.; Possible Values: N.A.
	linkCoveredPerc	double precision	Contains the percentage of the coverage along the link; Unit: N.A.; Possible Values: [0,100]; Example: 100
	path	integer
	name	varchar(255) DEFAULT NULL::character varying	Contains the name of the item; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
	progressive	double precision	Contains the progressive of the link along the path; Unit: N.A.; Possible Values: N.A.
	leng	double precision	Contains the lenght of the link associated to this item; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
	capa	double precision	Contains the capacity of the link associated to this item; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
	sped	double precision	Contains the speed of the link associated to this item; Unit: m/s; Possible Values: N.A.; Default Value: NULL
	shap	geometry	Contains the shape which represents the geometry of the link associated to this item.; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
Indexes
	path_resu_link_pkey	ON idno
Foreign Keys
	path_resu_link_path_fkey	(path) → path_resu(idno)

Table public.rlin_tsys_tre

It stores flow, speed and state results produced by the forecast software TRE. Results are link based and transport system based. rlin_tsys_tre_# tables may be used to freeze and store results from past days: the numeric suffix # is added to indicate the number of days back from the current date which a given table refers to.

Idx	Field Name	Data Type	Description
	simu	integer
	link	integer	Contains the idno of the table link (link.idno) associated to this item; Unit: N.A.; Possible Values: N.A.
	fnod	integer	Contains the idno of the table node (node.idno) which represents the from node value; Unit: N.A.; Possible Values: N.A.
	sday	integer	Contains the simulation day represented like yyyymmdd; Unit: N.A.; Possible Values: N.A.
	inst	integer	Contains the instant coinciding with the final time of the simulation interval represented like hhmmss; Unit: N.A.; Possible Values: N.A.
	fore	integer	Contains the time gap between the availability of the forecast results (when the results are stored in the DB), and the end time of the simulation that have generated the forecast; Unit: s; Possible Values: N.A.; Default Value: 900
	tsys	integer	Contains the idno of the table tsys (tsys.idno, transport system) associated to this item; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
	time	double precision	Contains the travel time, considered in the final instant; Unit: s; Possible Values: N.A.
	iflw	double precision	Contains the average of input flows; Unit: veh/h; Possible Values: N.A.
	oflw	double precision	Contains the average of output flows; Unit: veh/h; Possible Values: N.A.
	ouca	double precision	Contains the average of the exit capacity; Unit: veh/h; Possible Values: N.A.
	nveh	double precision	Contains the average of the number of vehicles; Unit: veh; Possible Values: N.A.
	stor	double precision	Contains the average storage capacity (maximum number of vehicles), given traffic flow conditions during the interval [0, maximum number of vehicles]; Unit: veh; Possible Values: N.A.
	queu	double precision	Contains the average of the number of vehicles in queue in hypercritical state; Unit: veh; Possible Values: N.A.
	quel	double precision	Contains the average of the length of the queue (as link length share); Unit: N.A.; Possible Values: N.A.
	quen	double precision	Contains the average value of the share of queuing vehicles; Unit: N.A.; Possible Values: N.A.
	ista	integer	Contains the instant value for the entry section traffic state; Unit: N.A.; Possible 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
	esta	integer	Contains the instant value for the exit section traffic state; Unit: N.A.; Possible 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	double precision	Contains the space average flow; Unit: veh/h; Possible Values: N.A.
	dens	double precision	Contains the space average density; Unit: veh/km; Possible Values: N.A.
	sped	double precision	Contains the average speed, calculated as the weighted average (over time) of hypercritical and hypocritical speed; Unit: km/h; Possible Values: N.A.
	speed_ratio	double precision	Contains the average over time of the free flow speed ratio index expressed as speed/MaxSpeed; Unit: N.A.; Possible Values: N.A.
	co	double precision	Contains the measurable impact of the carbon monoxide; Unit: N.A.; Possible Values: N.A.
	co2	double precision	Contains the measurable impact of the carbon dioxide; Unit: N.A.; Possible Values: N.A.
	fc	double precision	Contains the average of the fuel consumption; Unit: N.A.; Possible Values: N.A.
	hc	double precision	Contains the measurable impact of the hydrocarbons; Unit: veh; Possible Values: N.A.
	nox	double precision	Contains the measurable impact of the nitrogen oxides; Unit: N.A.; Possible Values: N.A.
	pm	double precision	Contains the measurable impact of the particulate emission; Unit: N.A.; Possible Values: N.A.
*	starttime	timestamp	Contains the start time of the simulation interval; Unit: N.A.; Possible Values: N.A.
*	endtime	timestamp	Contains the end time of the simulation interval; Unit: N.A.; Possible Values: N.A.
Indexes
	rlin_tsys_tre_link_tsys_idx	ON link, tsys
Foreign Keys
	rlin_tsys_tre_simu_fkey	(simu) → simu(idno)

Table public.rlin_tsys_tre_equa

It stores flow, speed and state results produced by the forecast software TRE. Results are link based and transport system based.

Idx	Field Name	Data Type	Description
	simu	integer
	link	integer	Contains the idno of the table link (link.idno) associated to this item; Unit: N.A.; Possible Values: N.A.
	fnod	integer	Contains the idno of the table node (node.idno) which represents the from node value; Unit: N.A.; Possible Values: N.A.
	dtyp	integer	Contains the idno of the table dtyp (dtyp.idno) which represents the day type associated to this item; Unit: N.A.; Possible Values: N.A.
	inst	integer	Contains the instant coinciding with the final time of the simulation interval represented like hhmmss; Unit: N.A.; Possible Values: N.A.
	fore	integer	Contains the time gap, in seconds, between the availability of the forecast results (when the results are stored in the DB), and the end time of the simulation that have generated the forecast; Unit: s; Possible Values: N.A.; Default Value: 900
	tsys	integer	Contains the idno of the table tsys (tsys.idno, transport system) associated to this item; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
	time	double precision	Contains the travel time, considered in the final instant; Unit: s; Possible Values: N.A.
	iflw	double precision	Contains the average of input flows; Unit: veh/h; Possible Values: N.A.
	oflw	double precision	Contains the average of output flows; Unit: veh/h; Possible Values: N.A.
	ouca	double precision	Contains the average of the exit capacity; Unit: veh/h; Possible Values: N.A.
	nveh	double precision	Contains the average of the number of vehicles; Unit: veh; Possible Values: N.A.
	stor	double precision	Contains the average storage capacity (maximum number of vehicles), given traffic flow conditions during the interval [0, maximum number of vehicles]; Unit: veh; Possible Values: N.A.
	queu	double precision	Contains the average of the number of vehicles in queue in hypercritical state; Unit: veh; Possible Values: N.A.
	quel	double precision	Contains the average of the length of the queue (as link length share); Unit: N.A.; Possible Values: N.A.
	quen	double precision	Contains the average value of the share of queuing vehicles; Unit: N.A.; Possible Values: N.A.
	ista	integer	Contains the instant value for the entry section traffic state; Unit: N.A.; Possible Values: 0=Hypocritical, 1=Hypercritical (generic), 3=Hypercritical due to spillback (queue along the link itself), 4=Hypercritical due to gridlock, 6=Hypercritical due to road closure
	esta	integer	Contains the instant value for the exit section traffic state.; Unit: N.A.; Possible 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	double precision	Contains the space average flow; Unit: veh/h; Possible Values: N.A.
	dens	double precision	Contains the space average density; Unit: veh/km; Possible Values: N.A.
	sped	double precision	Contains the average speed, calculated as the weighted average (over time) of hypercritical and hypocritical speed; Unit: km/h; Possible Values: N.A.
	speed_ratio	double precision	Contains the average over time of the free flow speed ratio index expressed as speed/MaxSpeed; Unit: N.A.; Possible Values: N.A.
	co	double precision	Contains the measurable impact of the carbon monoxide; Unit: N.A.; Possible Values: N.A.
	co2	double precision	Contains the measurable impact of the carbon dioxide; Unit: N.A.; Possible Values: N.A.
	fc	double precision	Contains the average of the fuel consumption; Unit: N.A.; Possible Values: N.A.
	hc	double precision	Contains the measurable impact of the hydrocarbons; Unit: veh; Possible Values: N.A.
	nox	double precision	Contains the measurable impact of the nitrogen oxides; Unit: N.A.; Possible Values: N.A.
	pm	double precision	Contains the measurable impact of the particulate emission; Unit: N.A.; Possible Values: N.A.
*	starttime	timestamp	Contains the start time of the simulation interval; Unit: N.A.; Possible Values: N.A.
*	endtime	timestamp	Contains the end time of the simulation interval; Unit: N.A.; Possible Values: N.A.
Foreign Keys
	rlin_tsys_tre_equa_simu_fkey	(simu) → simu(idno)

Table public.rlin_tsys_tre_fore

It stores flow, speed and state results produced by the forecast software TRE. Results are link based and transport system based.

Idx	Field Name	Data Type	Description
	simu	integer
	link	integer	Contains the idno of the table link (link.idno) associated to this item; Unit: N.A.; Possible Values: N.A.
	fnod	integer	Contains the idno of the table node (node.idno) which represents the from node value; Unit: N.A.; Possible Values: N.A.
	sday	integer	Contains the simulation day represented like yyyymmdd; Unit: N.A.; Possible Values: N.A.
	inst	integer	Contains the instant coinciding with the final time of the simulation interval represented like hhmmss; Unit: N.A.; Possible Values: N.A.
	fore	integer	Contains the time gap between the availability of the forecast results (when the results are stored in the DB), and the end time of the simulation that have generated the forecast; Unit: s; Possible Values: N.A.; Default Value: 900
	tsys	integer	Contains the idno of the table tsys (tsys.idno, transport system) associated to this item; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
	time	double precision	Contains the travel time, considered in the final instant; Unit: s; Possible Values: N.A.
	iflw	double precision	Contains the average of input flows; Unit: veh/h; Possible Values: N.A.
	oflw	double precision	Contains the average of output flows; Unit: veh/h; Possible Values: N.A.
	ouca	double precision	Contains the average of the exit capacity; Unit: veh/h; Possible Values: N.A.
	nveh	double precision	Contains the average of the number of vehicles; Unit: veh; Possible Values: N.A.
	stor	double precision	Contains the average storage capacity (maximum number of vehicles), given traffic flow conditions during the interval [0, maximum number of vehicles]; Unit: veh; Possible Values: N.A.
	queu	double precision	Contains the average of the number of vehicles in queue in hypercritical state.; Unit: veh; Possible Values: N.A.
	quel	double precision	Contains the average of the length of the queue (as link length share); Unit: N.A.; Possible Values: N.A.
	quen	double precision	Contains the average verage of the share of queuing vehicles; Unit: N.A.; Possible Values: N.A.
	ista	integer	Contains the instant value for the entry section traffic state; Unit: N.A.; Possible Values: 0=Hypocritical, 1=Hypercritical (generic), 3=Hypercritical due to spillback (queue along the link itself), 4=Hypercritical due to gridlock, 6=Hypercritical due to road closure
	esta	integer	Contains the instant value for the exit section traffic state; Unit: N.A.; Possible 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	double precision	Contains the space average flow; Unit: veh/h; Possible Values: N.A.
	dens	double precision	Contains the space average density; Unit: veh/km; Possible Values: N.A.
	sped	double precision	Contains the average speed, calculated as the weighted average (over time) of hypercritical and hypocritical speed; Unit: km/h; Possible Values: N.A.
	speed_ratio	double precision	Contains the average over time of the free flow speed ratio index expressed as speed/MaxSpeed; Unit: N.A.; Possible Values: N.A.
	co	double precision	Contains the measurable impact of the carbon monoxide; Unit: N.A.; Possible Values: N.A.
	co2	double precision	Contains the measurable impact of the carbon dioxide; Unit: N.A.; Possible Values: N.A.
	fc	double precision	Contains the average of the fuel consumption; Unit: N.A.; Possible Values: N.A.
	hc	double precision	Contains the measurable impact of the hydrocarbons; Unit: veh; Possible Values: N.A.
	nox	double precision	Contains the measurable impact of the nitrogen oxides; Unit: N.A.; Possible Values: N.A.
	pm	double precision	Contains the measurable impact of the particulate emission; Unit: N.A.; Possible Values: N.A.
*	starttime	timestamp	Contains the start time of the simulation interval; Unit: N.A.; Possible Values: N.A.
*	endtime	timestamp	Contains the end time of the simulation interva.; Unit: N.A.; Possible Values: N.A.
Indexes
	rlin_tsys_tre_fore_link_fnod_idx	ON link, fnod
Foreign Keys
	rlin_tsys_tre_fore_simu_fkey	(simu) → simu(idno)

Table public.rlin_tsys_tre_midterm

It stores flow, speed and state results produced by the mid term forecast simulations of TRE. Results are link based and transport system based. The table should be empty because the results are written into the children tables created using the inheritance of PostgreSQL.

Idx	Field Name	Data Type	Description
	simu	integer
	link	integer	Contains the idno of the table link (link.idno) associated to this item; Unit: N.A.; Possible Values: N.A.
	fnod	integer	Contains the idno of the table node (node.idno) which represents the from node value; Unit: N.A.; Possible Values: N.A.
	sday	integer	Contains the simulation day represented like yyyymmdd; Unit: N.A.; Possible Values: N.A.
	inst	integer	Contains the instant coinciding with the final time of the simulation interval represented like hhmmss; Unit: N.A.; Possible Values: N.A.
	fore	integer	Contains the time gap, in seconds, between the availability of the forecast results (when the results are stored in the DB) and the end time of the simulation that have generated the forecast; Unit: s; Possible Values: N.A.; Default Value: 900
	tsys	integer	Contains the idno of the table tsys (tsys.idno, transport system) associated to this item; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
	time	double precision	Contains the travel time, considered in the final instant; Unit: s; Possible Values: N.A.
	iflw	double precision	Contains the average of input flows; Unit: veh/h; Possible Values: N.A.
	oflw	double precision	Contains the average of output flows; Unit: veh/h; Possible Values: N.A.
	ouca	double precision	Contains the average of the exit capacity; Unit: veh/h; Possible Values: N.A.
	nveh	double precision	Contains the average of the number of vehicles; Unit: veh; Possible Values: N.A.
	stor	double precision	Contains the average storage capacity (maximum number of vehicles), given traffic flow conditions during the interval [0, maximum number of vehicles]; Unit: veh; Possible Values: N.A.
	queu	double precision	Contains the average of the number of vehicles in queue in hypercritical state; Unit: veh; Possible Values: N.A.
	quel	double precision	Contains the average of the length of the queue (as link length share); Unit: N.A.; Possible Values: N.A.
	quen	double precision	Contains the average value of the share of queuing vehicles; Unit: N.A.; Possible Values: N.A.
	ista	integer	Contains the instant value for the entry section traffic state; Unit: N.A.; Possible Values: 0=Hypocritical, 1=Hypercritical (generic), 3=Hypercritical due to spillback (queue along the link itself), 4=Hypercritical due to gridlock, 6=Hypercritical due to road closure
	esta	integer	Contains the instant value for the exit section traffic state; Unit: N.A.; Possible 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	double precision	Contains the space average flow; Unit: veh/h; Possible Values: N.A.
	dens	double precision	Contains the space average density; Unit: veh/km; Possible Values: N.A.
	sped	double precision	Contains the average speed, calculated as the weighted average (over time) of hypercritical and hypocritical speed; Unit: km/h; Possible Values: N.A.
	speed_ratio	double precision	Contains the average over time of the free flow speed ratio index expressed as speed/MaxSpeed; Unit: N.A.; Possible Values: N.A.
	co	double precision	Contains the measurable impact of the carbon monoxide; Unit: N.A.; Possible Values: N.A.
	co2	double precision	Contains the measurable impact of the carbon dioxide; Unit: N.A.; Possible Values: N.A.
	fc	double precision	Contains the average of the fuel consumption; Unit: N.A.; Possible Values: N.A.
	hc	double precision	Contains the measurable impact of the hydrocarbons; Unit: veh; Possible Values: N.A.
	nox	double precision	Contains the measurable impact of the nitrogen oxides; Unit: N.A.; Possible Values: N.A.
	pm	double precision	Contains the measurable impact of the particulate emission; Unit: N.A.; Possible Values: N.A.
*	starttime	timestamp	Contains the start time of the simulation interval; Unit: N.A.; Possible Values: N.A.
*	endtime	timestamp	Contains the end time of the simulation interval; Unit: N.A.; Possible Values: N.A.
Foreign Keys
	rlin_tsys_tre_midterm_simu_fkey	(simu) → simu(idno)

Table public.rlin_tsys_tre_planning

Idx	Field Name	Data Type
	simu	integer
	link	integer
	fnod	integer
	sday	integer
	inst	integer
	fore	integer
	tsys	integer
	time	double precision
	iflw	double precision
	oflw	double precision
	ouca	double precision
	nveh	double precision
	stor	double precision
	queu	double precision
	quel	double precision
	quen	double precision
	ista	integer
	esta	integer
	flow	double precision
	dens	double precision
	sped	double precision
	speed_ratio	double precision
	co	double precision
	co2	double precision
	fc	double precision
	hc	double precision
	nox	double precision
	pm	double precision
*	starttime	timestamp
*	endtime	timestamp
Options
PARTITION BY LIST (simu)

Table public.rlin_tsys_tre_roll_hor

It stores flow, speed and state results produced by the forecast software TRE. Results are link based and transport system based.

Idx	Field Name	Data Type	Description
	simu	integer
	link	integer	Contains the idno of the table link (link.idno) associated to this item; Unit: N.A.; Possible Values: N.A.
	fnod	integer	Contains the idno of the table node (node.idno) which represents the from node value; Unit: N.A.; Possible Values: N.A.
	sday	integer	Contains the simulation day represented through the pattern yyyymmdd; Unit: N.A.; Possible Values: N.A.
	inst	integer	Contains the instant coinciding with the final time of the simulation interval represented like hhmmss; Unit: N.A.; Possible Values: N.A.
	fore	integer	Contains the time gap, in seconds, between the availability of the forecast results (when the results are stored in the DB), and the end time of the simulation that have generated the forecast; Unit: s; Possible Values: N.A.; Default Value: 900
	tsys	integer	Contains the idno of the table tsys (tsys.idno, transport system) associated to this item; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
	time	double precision	Contains the travel time, considered in the final instant; Unit: s; Possible Values: N.A.
	iflw	double precision	Contains the average of input flows; Unit: veh/h; Possible Values: N.A.
	oflw	double precision	Contains the average of output flows; Unit: veh/h; Possible Values: N.A.
	ouca	double precision	Contains the average of the exit capacity; Unit: veh/h; Possible Values: N.A.
	nveh	double precision	Contains the average of the number of vehicles; Unit: veh; Possible Values: N.A.
	stor	double precision	Contains the average storage capacity (maximum number of vehicles), given traffic flow conditions during the interval [0, maximum number of vehicles]; Unit: veh; Possible Values: N.A.
	queu	double precision	Contains the average of the number of vehicles in queue in hypercritical state; Unit: veh; Possible Values: N.A.
	quel	double precision	Contains the average of the length of the queue (as link length share); Unit: N.A.; Possible Values: N.A.
	quen	double precision	Contains the average value of the share of queuing vehicles; Unit: N.A.; Possible Values: N.A.
	ista	integer	Contains the instant value for the entry section traffic state; Unit: N.A.; Possible Values: 0=Hypocritical, 1=Hypercritical (generic), 3=Hypercritical due to spillback (queue along the link itself), 4=Hypercritical due to gridlock, 6=Hypercritical due to road closure
	esta	integer	Contains the instant value for the exit section traffic state; Unit: N.A.; Possible 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	double precision	Contains the space average flow; Unit: veh/h; Possible Values: N.A.
	dens	double precision	Contains the space average density; Unit: veh/km; Possible Values: N.A.
	sped	double precision	Contains the average speed, calculated as the weighted average (over time) of hypercritical and hypocritical speed; Unit: km/h; Possible Values: N.A.
	speed_ratio	double precision	Contains the average over time of the free flow speed ratio index expressed as speed/MaxSpeed; Unit: N.A.; Possible Values: N.A.
	co	double precision	Contains the measurable impact of the carbon monoxide; Unit: N.A.; Possible Values: N.A.
	co2	double precision	Contains the measurable impact of the carbon dioxide; Unit: N.A.; Possible Values: N.A.
	fc	double precision	Contains the average of the fuel consumption; Unit: N.A.; Possible Values: N.A.
	hc	double precision	Contains the measurable impact of the hydrocarbons; Unit: veh; Possible Values: N.A.
	nox	double precision	Contains the measurable impact of the nitrogen oxides; Unit: N.A.; Possible Values: N.A.
	pm	double precision	Contains the measurable impact of the particulate emission; Unit: N.A.; Possible Values: N.A.
*	starttime	timestamp	Contains the start time of the simulation interval; Unit: N.A.; Possible Values: N.A.
*	endtime	timestamp	Contains the end time of the simulation interval; Unit: N.A.; Possible Values: N.A.
Indexes
	rlin_tsys_tre_roll_hor_fore_idx	ON fore
	rlin_tsys_tre_roll_hor_link_fnod_idx	ON link, fnod
Foreign Keys
	rlin_tsys_tre_roll_hor_simu_fkey	(simu) → simu(idno)

Table public.rlin_tsys_tre_scen

Idx	Field Name	Data Type
	simu	integer
	link	integer
	fnod	integer
	sday	integer
	inst	integer
	fore	integer
	tsys	integer
	time	double precision
	iflw	double precision
	oflw	double precision
	ouca	double precision
	nveh	double precision
	stor	double precision
	queu	double precision
	quel	double precision
	quen	double precision
	ista	integer
	esta	integer
	flow	double precision
	dens	double precision
	sped	double precision
	speed_ratio	double precision
	co	double precision
	co2	double precision
	fc	double precision
	hc	double precision
	nox	double precision
	pm	double precision
*	starttime	timestamp
*	endtime	timestamp
Options
PARTITION BY LIST (simu)

Table public.rpath_tsys_tre_rltm

It stores the simulation result related the private path set.

Idx	Field Name	Data Type	Description
*	simu	integer	Contains the idno of the table simu associated to this item; Unit: N.A.; Possible Values: N.A.
*	path	integer	Contains the idno of the correspondant path taken by the table path_resu; Unit: N.A.; Possible Values: N.A.
*	entrytime	timestamp	Contains the instant coinciding with the entry time of the simulation interval. The format is yyyymmdd; Unit: N.A.; Possible Values: N.A.; Example: 20220105
	fore	integer	Contains the time gap 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.; Unit: sec; Possible Values: N.A.; Default Value: 900
	link	integer	Contains the idno of the table link associated to this item; Unit: N.A.; Possible Values: N.A.
	fnod	integer	Contains the idno of the table node which represents the from node value; Unit: N.A.; Possible Values: N.A.
	plen	double precision	Contains the length of the path; Unit: N.A.; Possible Values: N.A.
	tsys	integer	Contains the idno of the table tsys (transport system) associated to this item; Unit: N.A.; Possible Values: N.A.
	time	double precision	Contains the travel time, considered in the final instant; Unit: s; Possible Values: N.A.
	speed	double precision	Contains the average speed, calculated as the weighted average (over time) of hypercritical and hypocritical speed; Unit: km/h; Possible Values: N.A.
	speed_ratio	double precision	Contains the average over time of the free flow speed ratio index expressed as speed/MaxSpeed.; Unit: N.A.; Possible Values: N.A.

Table public.rtur_tsys_tre

It stores turn flow results produced by TRE. Results are turn based, identified by the link-link or lane-link pairs forming the core of the unique key. RTUR_TSYS_TRE_# tables may be used to freeze and store results from previous days. The numeric suffix is added to indicate the number of days back from the current date which a given table refers to.

Idx	Field Name	Data Type	Description
*	simu	integer
*	frlk	integer	Contains the idno of the table link (link.idno) which represents the from link; Unit: N.A.; Possible Values: N.A.
*	fnod	integer	Contains the idno of the table node (node.idno) which represents the from node value; Unit: N.A.; Possible Values: N.A.
	tolk	integer	Contains the idno of the table link (link.idno) which represents the to link; Unit: N.A.; Possible Values: N.A.
*	vnod	integer	Contains the idno of the table link (link.idno) which represents the destination link tail identity; Unit: N.A.; Possible Values: N.A.
	tsys	integer	Contains the idno of the table tsys (tsys.idno, transport system) associated to this item; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
	orig	integer	Contains the idno of the table node (node.idno) which represents the origin value; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
	dest	integer	Contains the idno of the table node (node.idno) which represents the destination value; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
	inst	integer	Contains the instant coinciding with the final time of the simulation interval represented like hhmmssss; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
	flow	double precision	Contains the value of the flow; Unit: veh/h; Possible Values: N.A.; Default Value: 0
	sday	integer	Contains the simulation day represented like yyyymmdd; Unit: N.A.; Possible Values: N.A.
	fore	integer	Contains the time gap, in seconds, between the expected export time of the simulation results and the end time instant of the simulation interval. It indicates how far the forecast of that result interval is with respect to the computation time of the simulation; Unit: s; Possible Values: N.A.; Default Value: 900
*	starttime	timestamp	Contains the start time of the simulation interval; Unit: s; Possible Values: N.A.
*	endtime	timestamp	Contains the end time of the simulation interval; Unit: s; Possible Values: N.A.
Foreign Keys
	rtur_tsys_tre_simu_fkey	(simu) → simu(idno)

Table public.rtur_tsys_tre_equa

It stores turn flow results produced by TRE. Results are turn based, identified by the link-link or lane-link pairs forming the core of the unique key.

Idx	Field Name	Data Type	Description
	simu	integer
	frlk	integer	Contains the idno of the table link (link.idno) which represents the from link; Unit: N.A.; Possible Values: N.A.
	fnod	integer	Contains the idno of the table node (node.idno) which represents the from node value; Unit: N.A.; Possible Values: N.A.
	tolk	integer	Contains the idno of the table link (link.idno) which represents the to link; Unit: N.A.; Possible Values: N.A.
	vnod	integer	Contains the idno of the table link (link.idno) which represents the destination link tail identity; Unit: N.A.; Possible Values: N.A.
	tsys	integer	Contains the idno of the table tsys (tsys.idno, transport system) associated to this item; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
	orig	integer	Contains the idno of the table node (node.idno) which represents the origin value; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
	dest	integer	Contains the idno of the table node (node.idno) which represents the destination value; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
	inst	integer	Contains the instant coinciding with the final time of the simulation interval represented like hhmmssss; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
	flow	double precision	Contains the value of the flow; Unit: veh/h; Possible Values: N.A.; Default Value: 0
	dtyp	integer	Contains the idno of the table dtyp (dtyp.idno) which represents the day type associated to this item; Unit: N.A.; Possible Values: N.A.
	fore	integer	Contains the time gap (in seconds) between the expected export time of the simulation results and the end time instant of the simulation interval. It indicates how far the forecast of that result interval is with respect to the computation time of the simulation; Unit: s; Possible Values: N.A.; Default Value: 900
*	starttime	timestamp	Contains the start time of the simulation interval; Unit: s; Possible Values: N.A.
*	endtime	timestamp	Contains the end time of the simulation interval; Unit: s; Possible Values: N.A.
Foreign Keys
	rtur_tsys_tre_equa_simu_fkey	(simu) → simu(idno)

Table public.rtur_tsys_tre_fore

It stores turn flow results produced by TRE. Results are turn based, identified by the link-link or lane-link pairs forming the core of the unique key.

Idx	Field Name	Data Type	Description
*	simu	integer
*	frlk	integer	Contains the idno of the table link (link.idno) which represents the from link; Unit: N.A.; Possible Values: N.A.
*	fnod	integer	Contains the idno of the table node (node.idno) which represents the from node value; Unit: N.A.; Possible Values: N.A.
	tolk	integer	Contains the idno of the table link (link.idno) which represents the to link; Unit: N.A.; Possible Values: N.A.
*	vnod	integer	Contains the idno of the table link (link.idno) which represents the destination link tail identity; Unit: N.A.; Possible Values: N.A.
	tsys	integer	Contains the idno of the table tsys (tsys.idno, transport system) associated to this item; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
	orig	integer	Contains the idno of the table node (node.idno) which represents the origin value; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
	dest	integer	Contains the idno of the table node (node.idno) which represents the destination value; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
*	inst	integer	Contains the instant coinciding with the final time of the simulation interval represented like hhmmss; Unit: N.A.; Possible Values: N.A.
	flow	double precision	Contains the value of the flow; Unit: veh/h; Possible Values: N.A.; Default Value: 0
*	sday	integer	Contains the simulation day represented like yyyymmdd; Unit: N.A.; Possible Values: N.A.
*	fore	integer	Contains the time gap, in seconds, between the expected export time of the simulation results and the end time instant of the simulation interval. It indicates how far the forecast of that result interval is with respect to the computation time of the simulation; Unit: s; Possible Values: N.A.; Default Value: 900
*	starttime	timestamp	Contains the start time of the simulation interval; Unit: s; Possible Values: N.A.
*	endtime	timestamp	Contains the end time of the simulation interval; Unit: s; Possible Values: N.A.
Foreign Keys
	rtur_tsys_tre_fore_simu_fkey	(simu) → simu(idno)

Table public.rtur_tsys_tre_midterm

It stores turn flow results produced by TRE. Results are turn based, identified by the link-link or lane-link pairs forming the core of the unique key.

Idx	Field Name	Data Type	Description
	simu	integer	Contains the idno of the table simu (simu.idno) associated to this item; Unit: N.A.; Possible Values: N.A.
	frlk	integer	Contains the idno of the table link (link.idno) which represents the from link; Unit: N.A.; Possible Values: N.A.
	fnod	integer	Contains the idno of the table node (node.idno) which represents the from node value; Unit: N.A.; Possible Values: N.A.
	tolk	integer	Contains the idno of the table link (link.idno) which represents the to link; Unit: N.A.; Possible Values: N.A.
	vnod	integer	Contains the idno of the table link (link.idno) which represents the destination link tail identity; Unit: N.A.; Possible Values: N.A.
	tsys	integer	Contains the idno of the table tsys (tsys.idno, transport system) associated to this item; Unit: N.A.; Possible Values: N.A.
	orig	integer	Contains the idno of the table node (node.idno) which represents the origin value; Unit: N.A.; Possible Values: N.A.
	dest	integer	Contains the idno of the table node (node.idno) which represents the destination value; Unit: N.A.; Possible Values: N.A.
	inst	integer	Contains the instant coinciding with the final time of the simulation interval represented like hhmmss; Unit: N.A.; Possible Values: N.A.
	flow	double precision	Contains the value of the flow; Unit: veh/h; Possible Values: N.A.; Default Value: 0
	sday	integer	Contains the simulation day represented like yyyyMMdd.; Unit: N.A.; Possible Values: N.A.
	fore	integer	Contains the time gap, in seconds, between the expected export time of the simulation results and the end time instant of the simulation interval. It indicates how far the forecast of that result interval is with respect to the computation time of the simulation; Unit: s; Possible Values: N.A.; Default Value: 900
*	starttime	timestamp	Contains the start time of the simulation interval; Unit: s; Possible Values: N.A.
*	endtime	timestamp	Contains the end time of the simulation interval; Unit: s; Possible Values: N.A.

Table public.rtur_tsys_tre_rltm

It stores turn flow results produced by TRE. Results are turn based, identified by the link-link or lane-link pairs forming the core of the unique key.

Idx	Field Name	Data Type	Description
	simu	integer
	frlk	integer	Contains the idno of the table link (link.idno) which represents the from link; Unit: N.A.; Possible Values: N.A.
	fnod	integer	Contains the idno of the table node (node.idno) which represents the from node value; Unit: N.A.; Possible Values: N.A.
	tolk	integer	Contains the idno of the table link (link.idno) which represents the to link; Unit: N.A.; Possible Values: N.A.
	vnod	integer	Contains the idno of the table link (link.idno) which represents the destination link tail identity; Unit: N.A.; Possible Values: N.A.
	tsys	integer	Contains the idno of the table tsys (tsys.idno, transport system) associated to this item; Unit: N.A.; Possible Values: N.A.
	orig	integer	Contains the idno of the table node (node.idno) which represents the origin value; Unit: N.A.; Possible Values: N.A.
	dest	integer	Contains the idno of the table node (node.idno) which represents the destination value; Unit: N.A.; Possible Values: N.A.
	inst	integer	Contains the instant coinciding with the final time of the simulation interval represented like hhmmss; Unit: N.A.; Possible Values: N.A.
	flow	double precision	Contains the value of the flow; Unit: veh/h; Possible Values: N.A.; Default Value: 0
	sday	integer	Contains the simulation day represented like yyyymmdd; Unit: N.A.; Possible Values: N.A.
	fore	integer	Contains the time gap, in seconds, between the expected export time of the simulation results and the end time instant of the simulation interval. It indicates how far the forecast of that result interval is with respect to the computation time of the simulation; Unit: s; Possible Values: N.A.; Default Value: 900
*	starttime	timestamp	Contains the start time of the simulation interval; Unit: s; Possible Values: N.A.
*	endtime	timestamp	Contains the end time of the simulation interval; Unit: s; Possible Values: N.A.
Foreign Keys
	rtur_tsys_tre_rltm_simu_fkey	(simu) → simu(idno)

Table public.tprb

It stores the turn probability values.

Idx	Field Name	Data Type	Description
*	dtyp	integer	Contains the idno of the table dtyp (dtyp.idno) which represents the day type associated to this item; Unit: N.A.; Possible Values: N.A.
	frlk	integer	Contains the idno of the table link (link.idno) which represents the from link; Unit: N.A.; Possible Values: N.A.
	fnod	integer	Contains the idno of the table node (node.idno) which represents the from node value; Unit: N.A.; Possible Values: N.A.
	flan	integer	Contains the idno of the table lane (lane.idno) which represents the from link lane identifier; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
	tolk	integer	Contains the idno of the table link (link.idno) which represent the to link; Unit: N.A.; Possible Values: N.A.
	vnod	integer	Contains the idno of the table link (link.idno) which represent the destination link tail identity; Unit: N.A.; Possible Values: N.A.
	mode	integer	Contains the idno of the table mode (mode.idno) which represents the identity number of the transport system; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
	orig	integer	Contains the idno of the table node (node.idno)which represents the origin value; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
	dest	integer	Contains the idno of the table node (node.idno) which represents the destination value; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
*	inst	integer	Contains the instant coinciding with the final instant of the turn probability represented like hhmmssss; Unit: N.A.; Possible Values: N.A.; Example: 0=000000, 240000=midnight
*	weight	double precision	Contains the weight.It is the turn probability flow (veh/sec) for this turn at each time interval, used by TRE during the computation. ; Unit: N.A.; Possible Values: N.A.
	numerosity	integer	Contains the cardinality of the data set used to compute the weight only if the turn probabilities coming from real data. The best practice is to populate tprb.numerosity with the number of elements counted on the backward link (attributes frlk and fnod). Usually it is computed by dividing the counter on the turn by the counter on the backward link. So it is not necessary to provide the counter for the forward link; Unit: N.A.; Possible Values: N.A.; Default Value: NULL
Indexes
	tprb_dtyp_idx	ON dtyp

View rlin_data

Query
CREATE VIEW ${schema}.${name} AS SELECT rlin_tsys_tre_rltm_base.simu, rlin_tsys_tre_rltm_base.link, rlin_tsys_tre_rltm_base.fnod, rlin_tsys_tre_rltm_base.sday, rlin_tsys_tre_rltm_base.inst, rlin_tsys_tre_rltm_base.fore, rlin_tsys_tre_rltm_base.tsys, rlin_tsys_tre_rltm_base."time", rlin_tsys_tre_rltm_base.iflw, rlin_tsys_tre_rltm_base.oflw, rlin_tsys_tre_rltm_base.ouca, rlin_tsys_tre_rltm_base.nveh, rlin_tsys_tre_rltm_base.stor, rlin_tsys_tre_rltm_base.queu, rlin_tsys_tre_rltm_base.quel, rlin_tsys_tre_rltm_base.quen, rlin_tsys_tre_rltm_base.ista, rlin_tsys_tre_rltm_base.esta, rlin_tsys_tre_rltm_base.flow, rlin_tsys_tre_rltm_base.dens, rlin_tsys_tre_rltm_base.sped, rlin_tsys_tre_rltm_base.speed_ratio, rlin_tsys_tre_rltm_base.co, rlin_tsys_tre_rltm_base.co2, rlin_tsys_tre_rltm_base.fc, rlin_tsys_tre_rltm_base.hc, rlin_tsys_tre_rltm_base.nox, rlin_tsys_tre_rltm_base.pm, rlin_tsys_tre_rltm_base.starttime, rlin_tsys_tre_rltm_base.endtime FROM rlin_tsys_tre_rltm_base UNION SELECT rlin_tsys_tre_fore.simu, rlin_tsys_tre_fore.link, rlin_tsys_tre_fore.fnod, rlin_tsys_tre_fore.sday, rlin_tsys_tre_fore.inst, rlin_tsys_tre_fore.fore, rlin_tsys_tre_fore.tsys, rlin_tsys_tre_fore."time", rlin_tsys_tre_fore.iflw, rlin_tsys_tre_fore.oflw, rlin_tsys_tre_fore.ouca, rlin_tsys_tre_fore.nveh, rlin_tsys_tre_fore.stor, rlin_tsys_tre_fore.queu, rlin_tsys_tre_fore.quel, rlin_tsys_tre_fore.quen, rlin_tsys_tre_fore.ista, rlin_tsys_tre_fore.esta, rlin_tsys_tre_fore.flow, rlin_tsys_tre_fore.dens, rlin_tsys_tre_fore.sped, rlin_tsys_tre_fore.speed_ratio, rlin_tsys_tre_fore.co, rlin_tsys_tre_fore.co2, rlin_tsys_tre_fore.fc, rlin_tsys_tre_fore.hc, rlin_tsys_tre_fore.nox, rlin_tsys_tre_fore.pm, rlin_tsys_tre_fore.starttime, rlin_tsys_tre_fore.endtime FROM rlin_tsys_tre_fore
Idx	Field Name	Data Type
	simu	integer
	link	integer
	fnod	integer
	sday	integer
	inst	integer
	fore	integer
	tsys	integer
	time	double precision
	iflw	double precision
	oflw	double precision
	ouca	double precision
	nveh	double precision
	stor	double precision
	queu	double precision
	quel	double precision
	quen	double precision
	ista	integer
	esta	integer
	flow	double precision
	dens	double precision
	sped	double precision
	speed_ratio	double precision
	co	double precision
	co2	double precision
	fc	double precision
	hc	double precision
	nox	double precision
	pm	double precision
	starttime	timestamp
	endtime	timestamp

View rlin_tre_planning_shap_v

This view is designed to show in a best way data from tables rlin_tsys_tre_planning and link in order to provide data to Geoserver for layers visualization.

Query
CREATE VIEW ${schema}.${name} AS SELECT rlin.link, rlin.fnod, rlin.simu, link.hier, rlin.sday, rlin.inst, link.conn, rlin.ouca, rlin.iflw, rlin.oflw AS flow, rlin."time", rlin.sped, link.shap, CASE WHEN (link.sped = (0)::double precision) THEN (0)::double precision ELSE rlin.speed_ratio END AS "case", CASE WHEN (rlin.ouca = (0)::double precision) THEN (1)::double precision WHEN (link.capa = (0)::double precision) THEN (0)::double precision ELSE (rlin.iflw / link.capa) END AS vc, CASE WHEN (rlin.oflw = (0)::double precision) THEN (1)::double precision WHEN (rlin.ouca = (0)::double precision) THEN (0)::double precision ELSE (rlin.oflw / rlin.ouca) END AS vco, date_part('epoch'::text, (rlin.starttime)::timestamp with time zone) AS start_time, date_part('epoch'::text, (rlin.endtime)::timestamp with time zone) AS end_time FROM rlin_tsys_tre_planning rlin, link WHERE ((rlin.link = link.idno) AND (rlin.fnod = link.tail) AND (link.conn = 0) AND (rlin.tsys IS NULL))
Idx	Field Name	Data Type	Description
	link	integer
	fnod	integer
	simu	integer
	hier	integer
	sday	integer
	inst	integer
	conn	integer
	ouca	double precision
	iflw	double precision
	flow	double precision
	time	double precision
	sped	double precision
	shap	geometry
	case	double precision
	vc	double precision
	vco	double precision
	start_time	double precision
	end_time	double precision

View rlin_tre_rltm_shap_v

This view is designed to show in a best way data from tables rlin_tsys_tre_rltm and link in order to provide data to Geoserver for layers visualization.

Query
CREATE VIEW ${schema}.${name} AS WITH tre_interval AS ( SELECT (rlin_tsys_tre_rltm.endtime - rlin_tsys_tre_rltm.starttime) AS interval_length FROM rlin_tsys_tre_rltm LIMIT 1 ) SELECT rlin.link, rlin.fnod, rlin.simu, link.hier, rlin.sday, rlin.inst, link.conn, rlin.ouca, rlin.iflw, rlin.oflw AS flow, rlin."time", rlin.sped, link.shap, CASE WHEN (link.sped = (0)::double precision) THEN (0)::double precision ELSE rlin.speed_ratio END AS "case", CASE WHEN (rlin.ouca = (0)::double precision) THEN (1)::double precision WHEN (link.capa = (0)::double precision) THEN (0)::double precision ELSE (rlin.iflw / link.capa) END AS vc, CASE WHEN (rlin.oflw = (0)::double precision) THEN (1)::double precision WHEN (rlin.ouca = (0)::double precision) THEN (0)::double precision ELSE (rlin.oflw / rlin.ouca) END AS vco, CASE WHEN ((date_part('epoch'::text, ((rlin.endtime)::timestamp with time zone - now())))::integer >= 0) THEN (((date_part('epoch'::text, ((rlin.endtime)::timestamp with time zone - now())))::integer / (date_part('epoch'::text, ( SELECT tre_interval.interval_length FROM tre_interval LIMIT 1)))::integer) * (date_part('epoch'::text, ( SELECT tre_interval.interval_length FROM tre_interval LIMIT 1)))::integer) ELSE ((((date_part('epoch'::text, ((rlin.endtime)::timestamp with time zone - now())))::integer / (date_part('epoch'::text, ( SELECT tre_interval.interval_length FROM tre_interval LIMIT 1)))::integer) * (date_part('epoch'::text, ( SELECT tre_interval.interval_length FROM tre_interval LIMIT 1)))::integer) - (date_part('epoch'::text, ( SELECT tre_interval.interval_length FROM tre_interval LIMIT 1)))::integer) END AS fore FROM rlin_tsys_tre_rltm rlin, link WHERE ((rlin.link = link.idno) AND (rlin.fnod = link.tail) AND (link.conn = 0) AND (rlin.tsys IS NULL))
Idx	Field Name	Data Type	Description
	link	integer
	fnod	integer
	simu	integer
	hier	integer
	sday	integer
	inst	integer
	conn	integer
	ouca	double precision
	iflw	double precision
	flow	double precision
	time	double precision
	sped	double precision
	shap	geometry
	case	double precision
	vc	double precision
	vco	double precision
	fore	integer

View rlin_tre_rltm_shap_v_labmode

This view is designed to show in a best way data from tables rlin_tsys_tre_rltm and link in order to provide data to Geoserver for layers visualization.

Query
CREATE VIEW ${schema}.${name} AS SELECT rlin.link, rlin.fnod, rlin.fore, rlin.simu, link.hier, rlin.sday, rlin.inst, link.conn, rlin.ouca, rlin.iflw, rlin.oflw AS flow, rlin."time", rlin.sped, link.shap, CASE WHEN (link.sped = (0)::double precision) THEN (0)::double precision ELSE rlin.speed_ratio END AS "case", CASE WHEN (rlin.ouca = (0)::double precision) THEN (1)::double precision WHEN (link.capa = (0)::double precision) THEN (0)::double precision ELSE (rlin.iflw / link.capa) END AS vc, CASE WHEN (rlin.oflw = (0)::double precision) THEN (1)::double precision WHEN (rlin.ouca = (0)::double precision) THEN (0)::double precision ELSE (rlin.oflw / rlin.ouca) END AS vco FROM rlin_tsys_tre_rltm rlin, link WHERE ((rlin.link = link.idno) AND (rlin.fnod = link.tail) AND (link.conn = 0) AND (rlin.tsys IS NULL))
Idx	Field Name	Data Type	Description
	link	integer
	fnod	integer
	fore	integer
	simu	integer
	hier	integer
	sday	integer
	inst	integer
	conn	integer
	ouca	double precision
	iflw	double precision
	flow	double precision
	time	double precision
	sped	double precision
	shap	geometry
	case	double precision
	vc	double precision
	vco	double precision

View rlin_tre_simg_shap_v

This view is designed to show in a best way data from tables rlin_tsys_tre_scen and link in order to provide data to Geoserver for layers visualization.

Query
CREATE VIEW ${schema}.${name} AS WITH tre_interval AS ( SELECT (rlin_tsys_tre_rltm.endtime - rlin_tsys_tre_rltm.starttime) AS interval_length FROM rlin_tsys_tre_rltm LIMIT 1 ) SELECT rlin.link, rlin.fnod, rlin.simu, link.hier, rlin.sday, rlin.inst, link.conn, rlin.ouca, rlin.iflw, rlin.oflw AS flow, rlin."time", rlin.sped, link.shap, CASE WHEN (link.sped = (0)::double precision) THEN (0)::double precision ELSE rlin.speed_ratio END AS "case", CASE WHEN (rlin.ouca = (0)::double precision) THEN (1)::double precision WHEN (link.capa = (0)::double precision) THEN (0)::double precision ELSE (rlin.iflw / link.capa) END AS vc, CASE WHEN (rlin.oflw = (0)::double precision) THEN (1)::double precision WHEN (rlin.ouca = (0)::double precision) THEN (0)::double precision ELSE (rlin.oflw / rlin.ouca) END AS vco, date_part('epoch'::text, (rlin.starttime)::timestamp with time zone) AS start_time, date_part('epoch'::text, (rlin.endtime)::timestamp with time zone) AS end_time, CASE WHEN ((date_part('epoch'::text, ((rlin.endtime)::timestamp with time zone - now())))::integer >= 0) THEN (((date_part('epoch'::text, ((rlin.endtime)::timestamp with time zone - now())))::integer / (date_part('epoch'::text, ( SELECT tre_interval.interval_length FROM tre_interval LIMIT 1)))::integer) * (date_part('epoch'::text, ( SELECT tre_interval.interval_length FROM tre_interval LIMIT 1)))::integer) ELSE ((((date_part('epoch'::text, ((rlin.endtime)::timestamp with time zone - now())))::integer / (date_part('epoch'::text, ( SELECT tre_interval.interval_length FROM tre_interval LIMIT 1)))::integer) * (date_part('epoch'::text, ( SELECT tre_interval.interval_length FROM tre_interval LIMIT 1)))::integer) - (date_part('epoch'::text, ( SELECT tre_interval.interval_length FROM tre_interval LIMIT 1)))::integer) END AS fore FROM rlin_tsys_tre_scen rlin, link WHERE ((rlin.link = link.idno) AND (rlin.fnod = link.tail) AND (link.conn = 0) AND (rlin.tsys IS NULL))
Idx	Field Name	Data Type	Description
	link	integer
	fnod	integer
	simu	integer
	hier	integer
	sday	integer
	inst	integer
	conn	integer
	ouca	double precision
	iflw	double precision
	flow	double precision
	time	double precision
	sped	double precision
	shap	geometry
	case	double precision
	vc	double precision
	vco	double precision
	start_time	double precision
	end_time	double precision
	fore	integer

View rlin_tsys_tre_midterm_shap_v

This view is designed to show in a best way data from tables rlin_tsys_tre_midterm and link in order to provide data to Geoserver for layers visualization.

Query
CREATE VIEW ${schema}.${name} AS SELECT rlin.link, rlin.fnod, link.hier, rlin.sday, rlin.inst, link.conn, rlin.ouca, rlin.iflw, rlin.oflw AS flow, rlin."time", rlin.sped, link.shap, CASE WHEN (link.sped = (0)::double precision) THEN (0)::double precision ELSE rlin.speed_ratio END AS "case", CASE WHEN (rlin.ouca = (0)::double precision) THEN (1)::double precision WHEN (link.capa = (0)::double precision) THEN (0)::double precision ELSE (rlin.iflw / link.capa) END AS vc, CASE WHEN (rlin.oflw = (0)::double precision) THEN (1)::double precision WHEN (rlin.ouca = (0)::double precision) THEN (0)::double precision ELSE (rlin.oflw / rlin.ouca) END AS vco FROM rlin_tsys_tre_midterm rlin, link WHERE ((rlin.link = link.idno) AND (rlin.fnod = link.tail) AND (link.conn = 0) AND (rlin.tsys IS NULL))
Idx	Field Name	Data Type	Description
	link	integer
	fnod	integer
	hier	integer
	sday	integer
	inst	integer
	conn	integer
	ouca	double precision
	iflw	double precision
	flow	double precision
	time	double precision
	sped	double precision
	shap	geometry
	case	double precision
	vc	double precision
	vco	double precision

View rlin_tsys_tre_rltm

Query
CREATE VIEW ${schema}.${name} AS SELECT rlin_tsys_tre_roll_hor.simu, rlin_tsys_tre_roll_hor.link, rlin_tsys_tre_roll_hor.fnod, rlin_tsys_tre_roll_hor.sday, rlin_tsys_tre_roll_hor.inst, rlin_tsys_tre_roll_hor.fore, rlin_tsys_tre_roll_hor.tsys, rlin_tsys_tre_roll_hor."time", rlin_tsys_tre_roll_hor.iflw, rlin_tsys_tre_roll_hor.oflw, rlin_tsys_tre_roll_hor.ouca, rlin_tsys_tre_roll_hor.nveh, rlin_tsys_tre_roll_hor.stor, rlin_tsys_tre_roll_hor.queu, rlin_tsys_tre_roll_hor.quel, rlin_tsys_tre_roll_hor.quen, rlin_tsys_tre_roll_hor.ista, rlin_tsys_tre_roll_hor.esta, rlin_tsys_tre_roll_hor.flow, rlin_tsys_tre_roll_hor.dens, rlin_tsys_tre_roll_hor.sped, rlin_tsys_tre_roll_hor.speed_ratio, rlin_tsys_tre_roll_hor.co, rlin_tsys_tre_roll_hor.co2, rlin_tsys_tre_roll_hor.fc, rlin_tsys_tre_roll_hor.hc, rlin_tsys_tre_roll_hor.nox, rlin_tsys_tre_roll_hor.pm, rlin_tsys_tre_roll_hor.starttime, rlin_tsys_tre_roll_hor.endtime FROM rlin_tsys_tre_roll_hor
Idx	Field Name	Data Type
	simu	integer
	link	integer
	fnod	integer
	sday	integer
	inst	integer
	fore	integer
	tsys	integer
	time	double precision
	iflw	double precision
	oflw	double precision
	ouca	double precision
	nveh	double precision
	stor	double precision
	queu	double precision
	quel	double precision
	quen	double precision
	ista	integer
	esta	integer
	flow	double precision
	dens	double precision
	sped	double precision
	speed_ratio	double precision
	co	double precision
	co2	double precision
	fc	double precision
	hc	double precision
	nox	double precision
	pm	double precision
	starttime	timestamp
	endtime	timestamp

View rlin_tsys_tre_rltm_base

Query
CREATE VIEW ${schema}.${name} AS SELECT rlin_tsys_tre_roll_hor.simu, rlin_tsys_tre_roll_hor.link, rlin_tsys_tre_roll_hor.fnod, rlin_tsys_tre_roll_hor.sday, rlin_tsys_tre_roll_hor.inst, rlin_tsys_tre_roll_hor.fore, rlin_tsys_tre_roll_hor.tsys, rlin_tsys_tre_roll_hor."time", rlin_tsys_tre_roll_hor.iflw, rlin_tsys_tre_roll_hor.oflw, rlin_tsys_tre_roll_hor.ouca, rlin_tsys_tre_roll_hor.nveh, rlin_tsys_tre_roll_hor.stor, rlin_tsys_tre_roll_hor.queu, rlin_tsys_tre_roll_hor.quel, rlin_tsys_tre_roll_hor.quen, rlin_tsys_tre_roll_hor.ista, rlin_tsys_tre_roll_hor.esta, rlin_tsys_tre_roll_hor.flow, rlin_tsys_tre_roll_hor.dens, rlin_tsys_tre_roll_hor.sped, rlin_tsys_tre_roll_hor.speed_ratio, rlin_tsys_tre_roll_hor.co, rlin_tsys_tre_roll_hor.co2, rlin_tsys_tre_roll_hor.fc, rlin_tsys_tre_roll_hor.hc, rlin_tsys_tre_roll_hor.nox, rlin_tsys_tre_roll_hor.pm, rlin_tsys_tre_roll_hor.starttime, rlin_tsys_tre_roll_hor.endtime FROM rlin_tsys_tre_roll_hor
Idx	Field Name	Data Type
	simu	integer
	link	integer
	fnod	integer
	sday	integer
	inst	integer
	fore	integer
	tsys	integer
	time	double precision
	iflw	double precision
	oflw	double precision
	ouca	double precision
	nveh	double precision
	stor	double precision
	queu	double precision
	quel	double precision
	quen	double precision
	ista	integer
	esta	integer
	flow	double precision
	dens	double precision
	sped	double precision
	speed_ratio	double precision
	co	double precision
	co2	double precision
	fc	double precision
	hc	double precision
	nox	double precision
	pm	double precision
	starttime	timestamp
	endtime	timestamp

View rlin_vissim_shap_v

View designed to show in a best way data from tables vissim_link_result and link in order to provide data to Geoserver for layers visualization.

Query
CREATE VIEW ${schema}.${name} AS SELECT vissim.link, vissim.fnod, vissim.simulation_id AS simu, link.hier, vissim.start_time, vissim.end_time, link.conn, vissim.outflow AS flow, vissim.travel_time AS "time", vissim.fore, link.shap, CASE WHEN (vissim.outflow = (0)::double precision) THEN (1)::double precision WHEN (link.ocap = (0)::double precision) THEN (0)::double precision ELSE (vissim.outflow / link.ocap) END AS vco FROM vissim_link_result vissim, link WHERE ((vissim.link = link.idno) AND (vissim.fnod = link.tail) AND (link.conn = 0))
Idx	Field Name	Data Type	Description
	link	integer
	fnod	integer
	simu	bigint
	hier	integer
	start_time	bigint
	end_time	bigint
	conn	integer
	flow	double precision
	time	double precision
	fore	integer
	shap	geometry
	vco	double precision