Skip to main content
Ctrl+K

AequilibraE

    • Main menu
    • The AequilibraE Project
    • Run module
    • Network manipulation
    • Distribution Procedures
    • Path Computation
    • Traffic Assignment
    • Public Transport
    • Route choice
    • Other Applications
  • Python
  • QGIS
  • GitHub
    • Main menu
    • The AequilibraE Project
    • Run module
    • Network manipulation
    • Distribution Procedures
    • Path Computation
    • Traffic Assignment
    • Public Transport
    • Route choice
    • Other Applications
  • Python
  • QGIS
  • GitHub

Section Navigation

The AequilibraE Project

  • Project database
  • Project database SQL data model
  • Parameters YAML File
  • Public Transport Database
  • Public Transport SQL Data model
    • agencies table structure
    • attributes documentation table structure
    • fare attributes table structure
    • fare rules table structure
    • fare zones table structure
    • link types table structure
    • links table structure
    • modes table structure
    • node types table structure
    • nodes table structure
    • pattern mapping table structure
    • route links table structure
    • routes table structure
    • stop connectors table structure
    • stops table structure
    • trigger settings table structure
    • trips table structure
    • trips schedule table structure
    • zones table structure
  • Project Data Components
  • Examples
  • The AequilibraE project
  • Public Transport SQL Data model
  • link types table structure

link types table structure#

The link_types table holds information about the available link types in the network.

The link_type field corresponds to the link type, and it is the table’s primary key

The link_type_id field presents the identification of the link type

The description field holds the description of the link type

The lanes field presents the number or lanes for the link type

The lane_capacity field presents the number of lanes for the link type

The speed field holds information about the speed in the link type Attributes follow

Field

Type

NULL allowed

Default Value

link_type*

VARCHAR

NO

link_type_id

VARCHAR

NO

description

VARCHAR

YES

lanes

NUMERIC

YES

lane_capacity

NUMERIC

YES

speed

NUMERIC

YES

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE  if not exists link_types (link_type     VARCHAR UNIQUE NOT NULL PRIMARY KEY,
                                        link_type_id  VARCHAR UNIQUE NOT NULL,
                                        description   VARCHAR,
                                        lanes         NUMERIC,
                                        lane_capacity NUMERIC,
                                        speed         NUMERIC
                                        CHECK(LENGTH(link_type_id) == 1));

INSERT INTO 'link_types' (link_type, link_type_id, description, lanes, lane_capacity) VALUES('centroid_connector', 'z', 'VIRTUAL centroid connectors only', 10, 10000);

INSERT INTO 'link_types' (link_type, link_type_id, description, lanes, lane_capacity) VALUES('default', 'y', 'Default general link type', 2, 900);

INSERT INTO 'attributes_documentation' (name_table, attribute, description) VALUES('link_types','link_type', 'Link type name. E.g. arterial, or connector');
INSERT INTO 'attributes_documentation' (name_table, attribute, description) VALUES('link_types','link_type_id', 'Single letter identifying the mode. E.g. a, for arterial');
INSERT INTO 'attributes_documentation' (name_table, attribute, description) VALUES('link_types','description', 'Description of the same. E.g. Arterials are streets like AequilibraE Avenue');
INSERT INTO 'attributes_documentation' (name_table, attribute, description) VALUES('link_types','lanes', 'Default number of lanes in each direction. E.g. 2');
INSERT INTO 'attributes_documentation' (name_table, attribute, description) VALUES('link_types','lane_capacity', 'Default vehicle capacity per lane. E.g.  900');
INSERT INTO 'attributes_documentation' (name_table, attribute, description) VALUES('link_types','speed', 'Free flow velocity in m/s');

previous

fare zones table structure

next

links table structure

This Page

  • Show Source

© Copyright 2025-09-02, AequilibraE developers.

Created using Sphinx 8.1.3.

Built with the PyData Sphinx Theme 0.16.1.