Comments (3)
MYank0
commented on August 21, 2024
- Data uploaded to database under the table "train_passengers_per_hour". When we receive the new data we can quickly update it. I will commit the script that helps with the upload.
- Re:dash SQL query to get average of passengers by day of the week is here.
- I started making a spreadsheet of ratio between number of passengers arriving and bus leaving the station.
- Something is odd about the column n_passengers - there are some rows that miss that info and some have real numbers. Can we ask Israel railway how comes some of the numbers are real and not integer?
from open-bus.
MYank0
commented on August 21, 2024
Hi!
We got new new and full data from Rakevet Israel! 😄
Raw csv can be found here and data also uploaded to "train_passengers_per_hour" on Postgres.
from open-bus.
daphshez
commented on August 21, 2024
The original Excel files from Israel Railway, if someone is interested:
https://drive.google.com/drive/u/0/folders/0B9FEqRIWfmxLZllpdzlndVh2TVE
from open-bus.
Related Issues (20)
- Can't access siri br file HOT 2
- Duplicates rows in the db HOT 1
- API call gets an error: "QueuePool limit of size 5 overflow 10 reached" HOT 4
- Missing rows in siri_vehicle_locations HOT 18
- datacity stride project HOT 2
- siri data should reflect changes in OriginAimedDepartureTime / siri_ride__scheduled_start_time HOT 4
- permission to push to open-bus-stride-client HOT 2
- Adding data for route geometry is extremely important HOT 11
- stride api siri vehicle locations should allow to filter by lont/lat bounding box HOT 1
- get number of results for each api call HOT 1
- error in stride api gtfs_stop/get HOT 2
- השלמות stride
- stride additional tasks HOT 1
- all processing should be idempotent and make sure data is available for last X days HOT 2
- MOT problems with SIRI and GTFS data HOT 1
- StrideRequestFailedException: Failure response from Stride API (500): QueuePool limit of size 5 overflow 10 reached, connection timed out, timeout 30.00 HOT 1
- add date/timestamp in /gtfs_rides/list HOT 3
- stride-api feature request: add parameter to siri_ride to enable querying gtfs_ride_id HOT 1
- should have an efficient method to get all vehicle locations in geo area in a day
- filtering unrealistic duration_minutes values from siri_rides
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from open-bus.