{
    "info": {
        "author": "Open Transit Tools",
        "author_email": "info@opentransittools.org",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 4 - Beta",
            "Environment :: Console",
            "Intended Audience :: Developers",
            "License :: OSI Approved :: GNU General Public License (GPL)",
            "Natural Language :: English",
            "Programming Language :: Python :: 2.7",
            "Programming Language :: Python :: 3.6"
        ],
        "description": "======\nGTFSDB\n======\n\n.. image:: https://badges.gitter.im/Join%20Chat.svg\n   :alt: Join the chat at https://gitter.im/OpenTransitTools/gtfsdb\n   :target: https://gitter.im/OpenTransitTools/gtfsdb?utm_source=badge&utm_medium=badge&utm_campaign=pr-badge&utm_content=badge\n\n\nSupported Databases\n===================\n\n- PostgreSQL (PostGIS for Geo tables) - preferred\n- Oracle - tested\n- MySQL  - tested\n- SQLite - tested\n\n\nGTFS (General Transit Feed Specification) Database\n==================================================\n\nPython code that will load GTFS data into a relational database, and SQLAlchemy ORM bindings to the GTFS tables in the gtfsdb. \nThe gtfsdb project's focus is on making GTFS data available in a programmatic context for software developers. The need for the\ngtfsdb project comes from the fact that a lot of developers start out a GTFS-related effort by first building some amount of code\nto read GTFS data (whether that's an in-memory loader, a database loader, etc...);  GTFSDB can hopefully reduce the need for such\ndrudgery, and give developers a starting point beyond the first step of dealing with GTFS in .csv file format.\n\n(Pretty old stuff) available on pypi: https://pypi.python.org/pypi/gtfsdb\n\n\nInstall and use via the gtfsdb source tree:\n==========================================\n\n1. Install Python 2.7 (or 3.x), easy_install (https://pypi.python.org/pypi/setuptools) and zc.buildout (https://pypi.python.org/pypi/zc.buildout/2.5.2) on your system...\n1. git clone https://github.com/OpenTransitTools/gtfsdb.git\n1. cd gtfsdb\n1. buildout install prod -- NOTE: if you're using postgres, do a 'buildout install prod postgresql'\n1. bin/gtfsdb-load --database_url <db url>  <gtfs file | url>\n   examples:\n   - bin/gtfsdb-load --database_url sqlite:///gtfs.db gtfsdb/tests/large-sample-feed.zip\n   - bin/gtfsdb-load --database_url sqlite:///gtfs.db http://developer.trimet.org/schedule/gtfs.zip\n   - bin/gtfsdb-load --database_url postgresql://postgres@localhost:5432 --is_geospatial http://developer.trimet.org/schedule/gtfs.zip  \n   NOTE: using the `is_geospatial` arg will take much longer to load...\n\n\nThe best way to get gtfsbd up and running is via the python 'buildout' and 'easy_install' tools.\nHighly recommended to first install easy_install (setup tools) and buildout (e.g., easy_install zc.buildout)\nbefore doing anything else.\n\nPostgres users, gtfsdb requires the psycopg2 database driver. If you are on linux / mac, buildout will\ninstall the necessary dependencies (or re-use whatever you have in your system site-lib).\nIf you are on windows, you most likely have to find and install a pre-compiled version (see below).\n\n\nInstall Steps (on Windows):\n===========================\n    0. Have a db - docs and examples assume Postgres/PostGIS installed\n       http://www.postgresql.org/download/windows\n       http://postgis.refractions.net/download/windows/\n\n    1. Python2.7 - http://www.python.org/download/releases/2.7.6/ (python-2.7.6.msi)\n       NOTE: see this for setting env variables correctly: https://docs.python.org/3/using/windows.html#excursus-setting-environment-variables\n\n    2a. Install Setup Tools (easy_install) https://pypi.python.org/pypi/setuptools#windows-8-powershell\n    2b. easy_install zc.buildout\n\n    3. Install Psygopg2 (from binary):  http://www.stickpeople.com/projects/python/win-psycopg/\n\n    4. Check out gtfsdb from trunk with Git - see: git clone https://github.com/OpenTransitTools/gtfsdb.git\n\n    5. cd top level of gtfsdb tree\n\n    6. buildout install prod\n\n    7. bin/gtfsdb-load --database_url <db url>  <gtfs file | url>\n\n\nExample Query:\n==============\n\n-- get first stop time of each trip for route_id 1\nselect *\nfrom trips t, stop_times st\nwhere t.route_id = '1'\nand t.trip_id = st.trip_id\nand st.stop_sequence = 1\n\n\n-- get agency name and number of routes \nselect a.agency_name, a.agency_id, count(r.route_id)\nfrom routes r, agency a\nwhere r.agency_id = a.agency_id\ngroup by a.agency_id, a.agency_name\norder by 3 desc\n\n\n",
        "description_content_type": "",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "",
        "keywords": "GTFS",
        "license": "",
        "maintainer": "",
        "maintainer_email": "",
        "name": "gtfsdb",
        "package_url": "https://pypi.org/project/gtfsdb/",
        "platform": "",
        "project_url": "https://pypi.org/project/gtfsdb/",
        "project_urls": null,
        "release_url": "https://pypi.org/project/gtfsdb/0.5.0/",
        "requires_dist": [
            "geoalchemy2",
            "sqlalchemy",
            "psycopg2",
            "cx-oracle (>=5.1) ; extra == 'oracle'",
            "psycopg2 (>=2.4.2) ; extra == 'postgresql'"
        ],
        "requires_python": "",
        "summary": "GTFS Database",
        "version": "0.5.0"
    },
    "last_serial": 5040839,
    "releases": {
        "0.1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "5ac2afa5938cb1125732e0eb0f8c2b12",
                    "sha256": "c3e12d5fbcfda4d8ee3420ed154f518929bd11553ce299836592b157b9ca5ec5"
                },
                "downloads": -1,
                "filename": "gtfsdb-0.1.0.win32.exe",
                "has_sig": false,
                "md5_digest": "5ac2afa5938cb1125732e0eb0f8c2b12",
                "packagetype": "bdist_wininst",
                "python_version": "any",
                "requires_python": null,
                "size": 252682,
                "upload_time": "2013-07-30T20:49:23",
                "url": "https://files.pythonhosted.org/packages/1a/69/e988674afab6b59c91d6c1e3fe1acdad4fd69697de6b8c89815b775931fb/gtfsdb-0.1.0.win32.exe"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "ef5493aa75f74b83dc5c090241e7e052",
                    "sha256": "c08a20343053cc72cc1e2047f7eb41f65a87401080b94b8900c6da7023a0ea24"
                },
                "downloads": -1,
                "filename": "gtfsdb-0.1.0.zip",
                "has_sig": false,
                "md5_digest": "ef5493aa75f74b83dc5c090241e7e052",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 23248,
                "upload_time": "2013-07-30T20:49:19",
                "url": "https://files.pythonhosted.org/packages/f2/b0/26ea4c0b740c247c933ffb7de7ad2579eeb17f9bde4c52bc962e4645467f/gtfsdb-0.1.0.zip"
            }
        ],
        "0.1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "0877848e9c13d21fe43d536da6629502",
                    "sha256": "8daec08342e9b80482313dee788271e28571197a364a2b8f106e3293fac0a93e"
                },
                "downloads": -1,
                "filename": "gtfsdb-0.1.1.zip",
                "has_sig": false,
                "md5_digest": "0877848e9c13d21fe43d536da6629502",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 23423,
                "upload_time": "2013-09-24T15:36:33",
                "url": "https://files.pythonhosted.org/packages/5d/cd/82aa1d63518046af68d6447d5cc5ce40701228cfe33a05cd58113ece8815/gtfsdb-0.1.1.zip"
            }
        ],
        "0.1.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "8fc80036d87dfef76ebceee9797c0f6b",
                    "sha256": "c2ecda6d4ff9e11b21eefc085c7dac8a5b07e4e38311e902934f219b57e55be4"
                },
                "downloads": -1,
                "filename": "gtfsdb-0.1.2.zip",
                "has_sig": false,
                "md5_digest": "8fc80036d87dfef76ebceee9797c0f6b",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 26387,
                "upload_time": "2013-10-30T22:58:24",
                "url": "https://files.pythonhosted.org/packages/23/09/30f8a3b0554f86a0f16b9ffa005c8222e747e51dcdf6716eed509f69c0f3/gtfsdb-0.1.2.zip"
            }
        ],
        "0.1.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "c7032d3e01cb62a0666052ff5b2b43d8",
                    "sha256": "ffce5e0960500dfffe1e52499c535fdbca8de30661e5da57345f8bb529d2f223"
                },
                "downloads": -1,
                "filename": "gtfsdb-0.1.3.zip",
                "has_sig": false,
                "md5_digest": "c7032d3e01cb62a0666052ff5b2b43d8",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 27650,
                "upload_time": "2014-02-28T02:21:16",
                "url": "https://files.pythonhosted.org/packages/8f/55/ffcb7a1975be07b194b691edfb47489ef50eca0b51f7e0ff986c48f218d8/gtfsdb-0.1.3.zip"
            }
        ],
        "0.1.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "5f62d6a9538668b3c908a53c984d441f",
                    "sha256": "3bc24102b72801aaef0a94d8f03a0c148825840e96da11869eecbd867a55b7e8"
                },
                "downloads": -1,
                "filename": "gtfsdb-0.1.4.zip",
                "has_sig": false,
                "md5_digest": "5f62d6a9538668b3c908a53c984d441f",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 27822,
                "upload_time": "2014-03-18T21:11:28",
                "url": "https://files.pythonhosted.org/packages/c1/b3/0885e2c9ecae196f363c056e8b2ca3e2d3904592dc173576663a789bd9ed/gtfsdb-0.1.4.zip"
            }
        ],
        "0.1.5": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "5183a3487836bd330dbd801edc2dd31d",
                    "sha256": "729c4683d205c854e7ceb8c9bc13ffbe4fde7d0499600af90949978ba239f40d"
                },
                "downloads": -1,
                "filename": "gtfsdb-0.1.5.zip",
                "has_sig": false,
                "md5_digest": "5183a3487836bd330dbd801edc2dd31d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 143853,
                "upload_time": "2014-03-21T17:59:49",
                "url": "https://files.pythonhosted.org/packages/58/64/600e3736295251354bbd57677ec778c36770dbc0e7094a0a8c698b31b04e/gtfsdb-0.1.5.zip"
            }
        ],
        "0.5.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "7ce60ec78555ec6846c37d73b84b6213",
                    "sha256": "3166eca880ed50d9970eb72b5c7706cb40eba9a62ac2b5ab7afd7d26eb7f7b71"
                },
                "downloads": -1,
                "filename": "gtfsdb-0.5.0-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "7ce60ec78555ec6846c37d73b84b6213",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 47456,
                "upload_time": "2019-04-01T20:13:46",
                "url": "https://files.pythonhosted.org/packages/86/42/4b0152b692ae747c32cdf8cbedde8d8c44fa1426c67e200e8c0cf86333c1/gtfsdb-0.5.0-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "ed2511797d7d88c41f7ca2e55275434a",
                    "sha256": "d6d1c8e6be252f5734f5f4256c1ffd79bc1a991f1a0debc90a20a31eb4b3ca3e"
                },
                "downloads": -1,
                "filename": "gtfsdb-0.5.0.tar.gz",
                "has_sig": false,
                "md5_digest": "ed2511797d7d88c41f7ca2e55275434a",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 32159,
                "upload_time": "2019-04-01T20:13:47",
                "url": "https://files.pythonhosted.org/packages/ef/e4/aed9d0b4b842752f8289d88bebd8de25f413f7adc5b381620a949562a1a2/gtfsdb-0.5.0.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "7ce60ec78555ec6846c37d73b84b6213",
                "sha256": "3166eca880ed50d9970eb72b5c7706cb40eba9a62ac2b5ab7afd7d26eb7f7b71"
            },
            "downloads": -1,
            "filename": "gtfsdb-0.5.0-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "7ce60ec78555ec6846c37d73b84b6213",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 47456,
            "upload_time": "2019-04-01T20:13:46",
            "url": "https://files.pythonhosted.org/packages/86/42/4b0152b692ae747c32cdf8cbedde8d8c44fa1426c67e200e8c0cf86333c1/gtfsdb-0.5.0-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "ed2511797d7d88c41f7ca2e55275434a",
                "sha256": "d6d1c8e6be252f5734f5f4256c1ffd79bc1a991f1a0debc90a20a31eb4b3ca3e"
            },
            "downloads": -1,
            "filename": "gtfsdb-0.5.0.tar.gz",
            "has_sig": false,
            "md5_digest": "ed2511797d7d88c41f7ca2e55275434a",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 32159,
            "upload_time": "2019-04-01T20:13:47",
            "url": "https://files.pythonhosted.org/packages/ef/e4/aed9d0b4b842752f8289d88bebd8de25f413f7adc5b381620a949562a1a2/gtfsdb-0.5.0.tar.gz"
        }
    ]
}