Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

update documentation - gtfsdb-rt-loader doesnt'exists #5

Open
francot opened this issue Oct 18, 2022 · 2 comments
Open

update documentation - gtfsdb-rt-loader doesnt'exists #5

francot opened this issue Oct 18, 2022 · 2 comments
Assignees

Comments

@francot
Copy link

francot commented Oct 18, 2022

Edit documentation to make it clearer.
For example this is my experience and I cannot use the application to test trimet data.

Install and use via the gtfsdb source tree:

  1. Install Python 2.7 ok
  2. Install easy_install ok
  3. Install buildout : easy_install zc.buildout ok
  4. git clone https://github.com/OpenTransitTools/gtfsdb_realtime.git ok
  5. cd gtfsdb_realtime ok
  6. run buildout ok(buildout install prod pg return Error: The referenced section, 'pg', was not defined. )

Run TriMet example:

  1. get a TriMet api key: http://developer.trimet.org/appid/registration/ ok
  2. bin/gtfsdb-rt-loader -a TRIMET -d postgresql+psycopg2://[email protected]:5432/ott --api_key -c bin/gtfsdb-rt-loader doesn't exists
    I try to run bin/gtfsrt-load -a TRIMET -d postgresql+psycopg2://[email protected]:5432/ott --api_key -c but the script doesn't create the table trimet.routes so i get error relation "trimet.routes" doesn't exist

@fpurcell

@fpurcell fpurcell self-assigned this Oct 18, 2022
@fpurcell
Copy link
Member

fpurcell commented Oct 18, 2022

Thanks @francot ... looking into this.

BTW, do you have the postgres database installed on your machine (docs could be better here)

@francot
Copy link
Author

francot commented Oct 19, 2022

Thank you @fpurcell
Yes a Postgres database is installed on my machine.
But as I already write the command buildout install prod pg doesn't work for me.

Also I think you have to specify that first to run: bin/gtfsrt-load -a TRIMET -d postgresql+psycopg2://[email protected]:5432/ott --api_key -c (not bin/gtfsdb-rt-loader -a TRIMET -d postgresql+psycopg2://[email protected]:5432/ott --api_key -c as you write in documentation) you have to import the static gtfs using gtfsdb. The correct sequence could be:

Run TriMet example:

  1. get a TriMet api key: http://developer.trimet.org/appid/registration/
  2. import TRIMET static gtfs running: bin/gtfsdb-load --database_url postgresql://postgres:postgres@localhost:5432/dbname --schema trimet --is_geospatial local filename
  3. create real time tables. What is the command to create only table (schema trimet is already created by gtfsdb during static gtfs import) ?
  4. import trimet real time data running bin/gtfsrt-load -a TRIMET -d postgresql+psycopg2://postgres:postgres@localhost:5432/dbname --api_key apikey (without c because table are already created in step 3)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants