traffic incident table structure

traffic incident table structure#

Incidents to be applied during the simulation (only supported in Mesoscopic model)

Table Structure#

Field

Type

NULL allowed

Default Value

Foreign key

Description

link

INTEGER

NO

Link(link)

link in which the incident applies

dir

INTEGER

NO

0

direction (0 for A to B, 1 from B to A)

start_time

INTEGER

NO

0

initial time (in seconds from midnight) in which the incident occurs

end_time

INTEGER

NO

0

final time (in seconds from midnight) in which the incident occurs

capacity_scale

REAL

NO

0

relative capacity that the link will experience from 0 (completely blocked) to 1 (no impact)

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE IF NOT EXISTS Traffic_Incident(
    link           INTEGER NOT NULL,
    dir            INTEGER NOT NULL DEFAULT 0,
    start_time     INTEGER NOT NULL DEFAULT 0,
    end_time       INTEGER NOT NULL DEFAULT 0,
    capacity_scale REAL    NOT NULL DEFAULT 0,
    CONSTRAINT "link_fk" FOREIGN KEY ("link") REFERENCES "Link" ("link") DEFERRABLE INITIALLY DEFERRED -- check
);