Skip to main content
`Ctrl`+`K`

# stops table structure

The stops table holds information on the stops where vehicles pick up or drop off riders. This table information comes from the GTFS file stops.txt. You can find more information about the stops table here.

stop_id is an unique identifier for a stop

stop idenfifies a stop, statio, or station entrance

agency_id identifies the agency fot the specified route

link identifies the link_id in the links table that corresponds to the pattern matching

dir indicates the direction of travel for a trip

name identifies the name of a stop

parent_station defines hierarchy between different locations defined in stops.txt.

description provides useful description of the stop location

street identifies the address of a stop

zone_id identifies the TAZ for a stop

transit_fare_zone identifies the transit fare zone for a stop

route_type indicates the type of transporation used on a route

Field | Type | NULL allowed | Default Value
--- | --- | --- | ---
stop_id* | TEXT | YES |
stop | TEXT | NO |
agency_id | INTEGER | NO |
link | INTEGER | YES |
dir | INTEGER | YES |
name | TEXT | YES |
parent_station | TEXT | YES |
description | TEXT | YES |
street | TEXT | YES |
zone_id | INTEGER | YES |
transit_fare_zone | TEXT | YES |
route_type | INTEGER | NO | -1
geometry | POINT | NO | ‘’

(* - Primary key)

The SQL statement for table and index creation is below.

    CREATE TABLE IF NOT EXISTS stops (
         stop_id           TEXT    PRIMARY KEY,
         stop              TEXT    NOT NULL ,
         agency_id         INTEGER NOT NULL,
         link              INTEGER,
         dir               INTEGER,
         name              TEXT,
         parent_station    TEXT,
         description       TEXT,
         street            TEXT,
         zone_id           INTEGER,
         transit_fare_zone TEXT,
         route_type        INTEGER NOT NULL DEFAULT -1,
         FOREIGN KEY(agency_id) REFERENCES agencies(agency_id)
    );

    create INDEX IF NOT EXISTS stops_stop_id ON stops (stop_id);

    select AddGeometryColumn( 'stops', 'geometry', 4326, 'POINT', 'XY', 1);

    select CreateSpatialIndex( 'stops' , 'geometry' );