GitHub - scascketta/gtfsdb: Python 3 fork of gtfsdb v0.1.5 (note that the original gtfsdb master is at version 0.1.6dev).

scascketta / gtfsdb Public

forked from OpenTransitTools/gtfsdb

Notifications You must be signed in to change notification settings
Fork 0
Star 0

Python 3 fork of gtfsdb v0.1.5 (note that the original gtfsdb master is at version 0.1.6dev).

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 132 Commits
docs		docs
gtfsdb		gtfsdb
.hgignore		.hgignore
.project		.project
MANIFEST.in		MANIFEST.in
README		README
buildout.cfg		buildout.cfg
setup.py		setup.py

Repository files navigation

GTFSDB
++++++

Supported Databases
===================

- PostgreSQL (PostGIS for Geo tables) - preferred
- Oracle - tested
- MySQL  - tested
- SQLite - tested

Installation
============

All
---

- Install PostgreSQL (and PostGIS) or some other SQLAlchemy-supported RDBMS
- Install Distribute (or setuptools)
  - http://pypi.python.org/pypi/distribute#installation-instructions

Linux
-----

Clone the gtfsdb repository, then run `easy_install .` at the top level. Or,
set up a virtualenv and run `python setup.py develop`.

Windows
-------

- Have a database--the docs and examples assume Postgres & PostGIS are
  installed
  - http://www.postgresql.org/download/windows
  - http://postgis.refractions.net/download/windows/
- Install Python 2.6 or 2.7 using an installer from python.org
- Install Psygopg2 using installer
  - http://www.stickpeople.com/projects/python/win-psycopg/
- Clone gtfsdb repository
- cd to top level of gtfsdb tree
- `python setup.py install` or `python setup.py develop`

Usage
=====

The GTFS file being used is assumed to be valid.

Example load of GTFS sample into SQLite:

    gtfsdb-load http://code.google.com/transit/spec/sample-feed.zip


Example load of GTFS sample into PostgreSQL with PostGIS enabled:

    gtfsdb-load --database_url postgresql://postgres@localhost --is_geospatial \
        http://code.google.com/transit/spec/sample-feed.zip

Note: using the `is_geospatial` arg will take much longer to load