gtfs-sequelize

gtfs-sequelize

A model of the static GTFS using sequelize.js.

Currently works only with PostgreSQL (including PostGIS), MySQL (with spatial capabilities) and sqlite (but NOT spatialite).

Table of Contents

• Installation
• API

Installation

In order to use this library, you must also install the additional libraries in your project depending on the database that you use.

PostgreSQL

npm install pg --save
npm install pg-copy-streams --save
npm install pg-query-stream --save
npm install pg-hstore --save

With pg and node v0.10.x

You must also install the package promise-polyfill and write additional code. See here for more details.

MySQL

npm install mysql --save
npm install streamsql --save

SQLite

npm install sqlite3 --save
npm install streamsql --save

Usage with SQLite requires that sqlite is installed and is available via a unix command line.

API:

GTFS(options)

Create a new GTFS API.

Example:

var GTFS = require('gtfs-sequelize');

var pgConfig = {
  database: 'postgres://gtfs_sequelize:gtfs_sequelize@localhost:5432/gtfs-sequelize-test',
  downloadsDir: 'downloads',
  gtfsFileOrFolder: 'google_transit.zip',
  spatial: true,
  sequelizeOptions: {
    logging: false
  }
}

var gtfs = GTFS(pgConfig);
gtfs.loadGtfs(function() {
  //database loading has finished callback
});

options

Key	Value
database	A database connection string. You must specify a user and a database in your connection string. The database must already exist, but the tables within the db do not need to exist.
downloadsDir	The directory where you want the feed zip fils downloaded to or where you're going to read the feed read from.
gtfsFileOrFolder	The (zip) file or folder to load the gtfs from
interpolateStopTimes	Default is undefined. If true, after loading the stop_times table, all stop_times with undefined arrival and departure times will be updated to include interpolated arrival and departure times.
sequelizeOptions	Options to pass to sequelize. Note: to use a specific schema you'll want to pass something like this: { schema: 'your_schema' }
spatial	Default is undefined. If true, spatial tables for the shapes and stops will be created.

gtfs.connectToDatabase()

Return a sequelize api of the database.

Example:

var db = gtfs.connectToDatabase()

db.stop.findAll()
  .then(stops => {
    console.log(stops)
  })

gtfs.downloadGtfs(callback)

If a url is provided, the feed will be attempted to be downloaded. Works with http, https and ftp.

gtfs.interpolateStopTimes(callback)

Interpolate stop_times with undefined arrival and departure times. If you load a gtfs with the interpolateStopTimes flag set to true, you don't need to call this.

gtfs.loadGtfs(callback)

Load the gtfs into the database.