+++++++ INSTALL +++++++ Dependencies: ------------- Python25 or Python26 setup tools (easy_install) psycopg "SqlAlchemy <= 0.5.8" GeoAlchemy Database: PostgreSQL (PostGIS for Geo tables) - preferred Oracle - tested MySQL - not yet tested SQLite - not yet tested Install Steps (on Windows): --------------------------- 0. Have a db - docs and examples assume Postgres/PostGIS installed http://www.postgresql.org/download/windows http://postgis.refractions.net/download/windows/ 1. Python25 - http://www.python.org/download/releases/2.5.4/ (python-2.5.4.msi) NOTE: see this for setting env variables correctly: http://blog.sadphaeton.com/2009/01/20/python-development-windows-part-1installing-python.html 2. http://pypi.python.org/pypi/setuptools#downloads (setuptools-0.6c11.win32-py2.5.exe) NOTE: see this for setting env variables correctly: http://blog.sadphaeton.com/2009/01/20/python-development-windows-part-2-installing-easyinstallcould-be-easier.html 3. Install Psygopg2 (from binary): http://www.stickpeople.com/projects/python/win-psycopg/ 4. Install GeoAlchemy a. Open a Command Prompt window b. easy_install -D "SqlAlchemy <= 0.5.8" c. easy_install GeoAlchemy 5. Check out gtfsdb from trunk with Mercurial - see http://code.google.com/p/gtfsdb/source/checkout 6. cd top level of gtfsdb tree 7. python setup.py develop 8. python gtfsdb/scripts/load.py 9. Change database information by editing this file: gtfsdb/data/default.cfg IMPORTANT: GeoSpatial switch must happen in a geo database. If you previously loaded a GTFS in a schema you'd like to now make geo, you need to delete the existing GTFS tables (eg: since they lack the necessary geom columns). NOTE: version of SqlAlchemy must be lower than the 0.6 beta that's out there for GeoAlchemy to work (that screwed us up)