Bt tables - dssg/cta-sim GitHub Wiki

The BusTools tables come from the interface and software by Clever Devices for their AVL hardware. The column types are copied below.

BT_PATTERN

BT_VER      NUMBER(3) NOT NULL,
PATTERNID   NUMBER(5) NOT NULL,
TAROUTE     VARCHAR2(5),
PATTERNNAME VARCHAR2(50),
DIRECTION   NUMBER(2),
DISTANCE    NUMBER(6),
ROUTE       CHAR(5),
PATTERN     CHAR(2),
PATTERNDESC VARCHAR2(60),
ROUTETXT    VARCHAR2(32)

BT_PATTERNDETAIL

BT_VER        NUMBER(3),
PATTERNID     NUMBER(5),
GEOID         NUMBER(5),
STOPID        NUMBER(5),
TIMEPOINTID   NUMBER(4),
DISTANCE      NUMBER(9),
PATTERNORDER  NUMBER(3),
SORTORDER     NUMBER(9),
STOPSORTORDER NUMBER(3)

BT_STOP

BT_VER         NUMBER(3),
GEOID          NUMBER(6),
GEODESCRIPTION VARCHAR2(50),
TAGEOID        VARCHAR2(6),
LONGITUDE      FLOAT,
LATITUDE       FLOAT,
HEADING        NUMBER(5,2)

BT_STOPDESC

BT_VER   NUMBER(3),
TAGEOID  VARCHAR2(6),
STOPDESC VARCHAR2(80),
ENABLED  NUMBER(1)

BT_STOPINFO

BT_VER   NUMBER(3),
STOPID   NUMBER(5),
STOPDESC VARCHAR2(50)

BT_S_VERSION

S_VER         NUMBER(2) NOT NULL,
SIGNUPNAME    VARCHAR2(50) NOT NULL,
SIGNUPVERSION NUMBER(1) NOT NULL,
NOTES         VARCHAR2(200),
STARTDATE     DATE,
ENDDATE       DATE,
ACTIVE        NUMBER(1),
RTAVAILABLE   NUMBER(1),
NOTES2        VARCHAR2(200),
RBS_VER       VARCHAR2(15)

BT_TERMINAL

BT_VER            NUMBER(3) NOT NULL,
TERMINALID        NUMBER(3) NOT NULL,
BTPLACEID         NUMBER(3),
DEPOTCIRCLERADIUS NUMBER(5),
NAME              VARCHAR2(10),
GEODESCRIPTION    VARCHAR2(50),
REASON1           VARCHAR2(50),
REASON2           VARCHAR2(50),
CREATOR           VARCHAR2(50)

BT_TIMEPOINT

BT_VER      NUMBER(3),
TIMEPOINTID NUMBER(4),
PLACEID     VARCHAR2(50),
DESCRIPTION VARCHAR2(50),
LATITUDE    FLOAT,
LONGITUDE   FLOAT

BT_TIMEPOINTDIST

BT_VER    NUMBER(3) NOT NULL,
PATTERNID NUMBER(5) NOT NULL,
FROM_TP   VARCHAR2(50) NOT NULL,
TO_TP     VARCHAR2(50) NOT NULL,
DIST      NUMBER

BT_TRIP2

S_VER        NUMBER(2),
TRIPNO       NUMBER(8),
PATTERNID    NUMBER(5),
TRIPTYPE     NUMBER(1),
SCHEDULETYPE NUMBER(1),
REVENUE      NUMBER(1),
BLOCKNO      NUMBER(7),
BLOCKID      VARCHAR2(10),
DAYMAP       NUMBER(2),
TRIPID       VARCHAR2(15),
TRIPSTART    NUMBER(22),
TRIPEND      NUMBER(22),
GUZINTO      NUMBER(1),
TPSTART      VARCHAR2(6),
TPEND        VARCHAR2(6)

BT_TRIPDETAIL

S_VER       NUMBER(2),
TRIPNO      NUMBER(8),
TIMEPOINTID NUMBER(4),
PASSINGTIME DATE,
TIMESEC     NUMBER(6),
RUNID       CHAR(4),
GARAGE      CHAR(1),
SHORTRUNNO  NUMBER(3)

BT_VERSION

BT_VER           NUMBER(3),
S_VER            NUMBER(3),
NOTES            VARCHAR2(200),
DISTRIBUTIONDATE DATE,
ACTIVE           NUMBER(1),
PASSINGTIME      NUMBER(1)