Skip to main content
Ctrl+K

AequilibraE 1.1.0

Site Navigation

  • Examples
  • Modeling with AequilibraE
  • API Reference

Site Navigation

  • Examples
  • Modeling with AequilibraE
  • API Reference

Section Navigation

  • The AequilibraE project
  • Parameters YAML File
  • Project database
    • About table
    • Network
    • Modes table
    • Link types table
    • Matrices
    • Zones table
    • Parameters metadata table
    • Results
    • SQL Data model
      • about table structure
      • attributes documentation table structure
      • link types table structure
      • links table structure
      • matrices table structure
      • modes table structure
      • nodes table structure
      • periods table structure
      • results table structure
      • transit graph configs table structure
      • zones table structure
  • Public Transport database
    • 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
      • results 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
  • Static Traffic Assignment
    • Multi-class Equilibrium assignment
    • Path-finding and assignment mechanics
  • Transit assignment
    • Hyperpath routing in the context of transit assignment
    • The Transit assignment graph
  • Route Choice
    • Choice set generation algorithms
    • Route choice models
  • Modeling with AequilibraE
  • 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

Show Source

© Copyright 2024-07-26, AequilibraE developers.

Created using Sphinx 7.4.7.

Built with the PyData Sphinx Theme 0.13.3.