Ecosyste.ms: OpenCollective

An open API service for software projects hosted on Open Collective.

github.com/public-transport/gtfs-via-postgres

Process GTFS Static/Schedule by importing it into a PostgreSQL database.
https://github.com/public-transport/gtfs-via-postgres

arrivals_departures/connections: expose trips.bikes_allowed ✅

closes https://github.com/public-transport/gtfs-via-postgres/pull/60

Co-Authored-By: Jannis R <...

df50320faca87d3861eab3b47919a489d7950128 authored 10 months ago by Magnus Burton <[email protected]>
arrivals_departures/connections: expose trips.wheelchair_accessible ✅

closes https://github.com/public-transport/gtfs-via-postgres/pull/59

Co-Authored-By: Jannis R <...

a69397c5e71d069caed2885f58963e201788ac2b authored 10 months ago by Magnus Burton <[email protected]>
tests: fail on unbound (undefined) variables, minor tweaks ✅

7924be1956bdc1117d501fd2723a3ffaeb41a405 authored 10 months ago by Jannis R <[email protected]>
minor tweak 📝; 4.9.1

9d389e0e31cffe061929b4d36f988bf79ad3fcca authored 10 months ago by Jannis R <[email protected]>
make all enums castable to text 🐛

fixes https://github.com/mobidata-bw/ipl-orchestration/pull/97 properly

d3c85e7a27f0498a2dad70d0d107f67a56e5ecc5 authored 11 months ago by Jannis R <[email protected]>
CI publishing: fix Docker image name 💚

c5b28ec08159a07352579ade77a0c3f03956156b authored 11 months ago by Jannis R <[email protected]>
CI smoke tests: remote ticketing_*.txt from VVS feed before import 💚

f163bb06446635bb1d16d96a372bc527b098abe3 authored 11 months ago by Jannis R <[email protected]>
minor tweaks

- SQL: add gtfs-via-postgres version to comment
- package.json#homepage: use Git tag
- package.j...

8d9182e10f3be54a7f206d43931ffe7e5453ed3f authored 11 months ago by Jannis R <[email protected]>
SQL: remove superfluous REVOKE commands

342be4f4dcbf7e860a6a53b4cd996b61800b3120 authored 11 months ago by Jannis R <[email protected]>
add --postgrest-query-cost-limit option 📝

23f331a2c750461927cc08d5eb235d5c02e167f1 authored 11 months ago by Jannis R <[email protected]>
minor tweaks 📝; 4.9.0

d3ad1f93388a0b8484fb8351777891f90c01cc3c authored 12 months ago by Jannis R <[email protected]>
set opt.tripsWithoutShapeId to true if shapes.csv is missing 🐛📝

related: d7ad83d

4f0b1d3b49aa33cd48653bf56a1d0075ab5f2959 authored 12 months ago by Jannis R <[email protected]>
GTFS reference links: change to gtfs.org

8a53f6835f7582d9b99ee9a041dcd263b73e74bf authored 12 months ago by Jannis R <[email protected]>
document public.gtfs_via_postgres_import_version() 📝

follow-up of ea6395c

b6e9ec77bf180db267f853708fc23874342b718b authored 12 months ago by Jannis R <[email protected]>
only print PostgREST/PostGraphile passwords if enabled 🐛

related: https://github.com/derhuerst/berlin-gtfs-rt-server/issues/5#issuecomment-1908286800

c9dd8804dbcca4eb45aa6e3344de45737b7a7209 authored 12 months ago by Jannis R <[email protected]>
calendar_dates_only test: also check stop/station wheelchair_boarding ✅

3d56854587295b4a74782648cf45df63edc4472e authored 12 months ago by Jannis R <[email protected]>
connections: expose {from_,to}_wheelchair_boarding

closes #47

Co-Authored-By: Jannis R <[email protected]>

4c4ebd5aeeb42746bb27ffd59b9ca22ab5bfe2e2 authored 12 months ago by Magnus Burton <[email protected]>
arrivals_departures: expose wheelchair_boarding

Co-Authored-By: Jannis R <[email protected]>

a3ad613203a28f083191ab1d77a960c0d285f3b4 authored 12 months ago by Magnus Burton <[email protected]>
stop_times: don't parse shape_dist_traveled as integer 🐛

closes #53

Co-Authored-By: Jannis R <[email protected]>

112e38bfb57a71be06db8a1d60f545b6c9fd1ffe authored about 1 year ago by smohiudd <[email protected]>
support safely importing >1 datasets into one DB ✅📝

fixes #51

ea6395c8d5be6e6fcdedc900838d1361afc7b348 authored about 1 year ago by Jannis R <[email protected]>
add multiple schemas test ✅

related: #51

0a9c4aecea39045a5bb325aaa7062057446d5135 authored about 1 year ago by Jannis R <[email protected]>
only create postgrest role if it doesn't exist 🐛; 4.8.2

57da5fde064928207a7c072b61fba1dd46e3b490 authored about 1 year ago by Jannis R <[email protected]>
--postgraphile-password: default to $POSTGRAPHILE_PASSWORD again 🐛; 4.8.1

22a564a2d75bbaefc62abb85d499bf92d3f285e5 authored about 1 year ago by Jannis R <[email protected]>
add --postgrest-password option 📝

93c86354c1f54c3e08d277b524f0950d480300c0 authored about 1 year ago by Jannis R <[email protected]>
PostgREST password: respect $POSTGREST_PASSWORD

a9a61580927c9eebd384bc987f4d436935e9f21d authored about 1 year ago by Jannis R <[email protected]>
PostgREST: add `postgrest` user 🐛

e6dc1a23c76d81681e769b4490ee41c0292c378f authored about 1 year ago by Jannis R <[email protected]>
add benchmark results ⚡️; 4.8.0

fc0e4c5f243f6fa58e9d85751e1e0a3a4207de77 authored over 1 year ago by Jannis R <[email protected]>
--postgrest: only create role web_anon if it doesn't exist 📝

390f9cd6a9bd2bddc4ce7d219acce01f8581935f authored over 1 year ago by Jannis R <[email protected]>
add --postgrest option 📝✅💚

a90f224ebbc74567afea084113da7597980ecbd9 authored over 1 year ago by Jannis R <[email protected]>
add benchmark results ⚡️; 4.7.5

238fb4bd9c2120ebca63b6f84fcf2ed8999f9144 authored over 1 year ago by Jannis R <[email protected]>
tweak .dockerignore & .gitignore

2012629fa1f984cc764b93056aa585d7462bee29 authored over 1 year ago by Jannis R <[email protected]>
CI: run smoke test with VVS GTFS 💚

920a7bbfd5c366a454ac32adb5d4a8758a1f3d37 authored over 1 year ago by Jannis R <[email protected]>
CI smoke tests: download feeds with User-Agent 💚

6c003917e497d2525364f1f5ac1224aba683d244 authored over 1 year ago by Jannis R <[email protected]>
add --lower-case-lang-codes option 📝

2da56cdba1e0834fc2103bbe59f7ea1dc6f30b21 authored over 1 year ago by Jannis R <[email protected]>
readme: update usage 📝; minor tweak

7082c652f914738f6fccc3d1aafaf3b4766a4d18 authored over 1 year ago by Jannis R <[email protected]>
readme: update benchmark results 📝

bd529d5b054d9da33a6b7810fcb9030e730dfa66 authored over 1 year ago by Jannis R <[email protected]>
add benchmark results ⚡️; 4.7.4

8875882adf4083f6b4b43c039e3e88fbac68f778 authored over 1 year ago by Jannis R <[email protected]>
usage docs: use 2022-07-01 VBB GTFS 📝

f6539d81a93f808de238545329fb146f66ba8756 authored over 1 year ago by Jannis R <[email protected]>
ignore stop_timezone when calculating arrivals/departures 🐛✅

Apparently, stop_timezone was only ever intended for displaying local date+time.
The current ope...

761510266429c3c6ecb6f160c4ef46adcb78ab2b authored over 1 year ago by Jannis R <[email protected]>
fix CI publishing 💚

e03a6ddd6e57af1eb1a71ba6791d3cb138016087 authored over 1 year ago by Jannis R <[email protected]>
CI: run smoke test with VGN GTFS 💚

related: #43
related: #45

18a1223c2fd91b90751cd8ba72a5e0863cf4228d authored over 1 year ago by Jannis R <[email protected]>
Fix typo

605b00dfa6a5d26b1d0077b3698e3d4a81ac5641 authored over 1 year ago by Max Buchholz <[email protected]>
add benchmark results ⚡️; minor tweaks; 4.7.3

c75a08f3946f24e283ecb86c55cf1aefe147f0f9 authored over 1 year ago by Jannis R <[email protected]>
fix handling of --stops-without-level-id flag 🐛✅

fixes #43

Thanks @langbein-daniel!

469f94a0a018ad79f689da29549936959c30c45b authored over 1 year ago by Jannis R <[email protected]>
with --routes-without-agency-id, handle routes.agency_id = null 🐛✅

related: #45
follow-up of 02d307b

ac29bc6d24d9eab50b35f44f74e2f3a0cdbe1f0a authored over 1 year ago by Jannis R <[email protected]>
fix CI 💚

Apparently, $GLOBIGNORE behaves differently on a GNU Bash von Ubuntu 22.04 than on GNU Bash on m...

21aad0358a7ed2abe57c07cce5bd6113786f2318 authored over 1 year ago by Jannis R <[email protected]>
add benchmark init script ⚡️

b2cc9e230340db8e0fa0eb5f20cebde5cbe7a7c0 authored over 1 year ago by Jannis R <[email protected]>
add 4.7.1 & 4.7.2 benchmark results ⚡️

6f7f91ee9d4967d8cba6611e78d71764617aa262 authored over 1 year ago by Jannis R <[email protected]>
minor tweaks ✅⚡️📝; make SQL nicer; 4.7.2

24474e15b9f1b6d1f662f2169a767157868b0ae2 authored over 1 year ago by Jannis R <[email protected]>
handle feeds with 1 agency & routes.agency_id = null 🐛✅

fixes #45

02d307b66cd6fc1768ffe5f8c8a9176f96a3c0c1 authored over 1 year ago by Jannis R <[email protected]>
pass nr of rows of previous files into formatters

8ac97233c75ab40025b34c62076e4899bb61ea48 authored over 1 year ago by Jannis R <[email protected]>
CLI: print (input) data errors properly

9ec03e33d3c492b99ed14f487ea67fdf8a48cb19 authored over 1 year ago by Jannis R <[email protected]>
fix benchmarks ⚡️

288da7edf4cd2f44c429cc560f48d9eb884cbf04 authored over 1 year ago by Jannis R <[email protected]>
minor tweaks; 4.7.1

- gitignore & dockerignore *.gtfs

3c77aec0c70640acbb85890254f212dc6592193a authored over 1 year ago by Jannis R <[email protected]>
CI: publish compressed binaries too 💚

48e30e35b484f7fa02e4f6871e66b5411b55c1c2 authored over 1 year ago by Jannis R <[email protected]>
only set opt.stopsWithoutLevelId if --stops-without-level-id is present 🐛✅

fixes #43

d7ad83d124eb8aa306b6428e014934f835b540d5 authored over 1 year ago by Jannis R <[email protected]>
docs: fix typo in readme.md

7159d0f54a397f48e15ed1e3afda06ddc62389d0 authored over 1 year ago by Daniel Langbein <[email protected]>
readme: document largest_{arrival,departure}_time() 📝

aa7da4e04fbdeee356792d14ff9e72e50537b1c5 authored over 1 year ago by Jannis R <[email protected]>
minor tweaks; 4.7.0

3bcf237eb31f33e7c5818ba89a2291e38648497c authored over 1 year ago by Jannis R <[email protected]>
add --postgraphile-password option 📝

94e7f6202a3e79ad2b4bd0f638360892fbfadc40 authored over 1 year ago by Jannis R <[email protected]>
add --stats-active-trips-by-hour option ✅📝

79b6983acf42d0152151076386fc7076f8bb1d76 authored over 1 year ago by Jannis R <[email protected]>
docs: no. of active trips with a custom temporal resolution 📝

514d53229f320f0ca72a907602e67c598a7e8af6 authored over 1 year ago by Jannis R <[email protected]>
benchmark script: report rounded milliseconds

a48ecabcdffa811cf2a5804b390ae389618a849a authored over 1 year ago by Jannis R <[email protected]>
add --stats-by-agency-route-stop-hour option 📝✅

d747d9a7cad3fb897972a1cfe9f2136ba4d86f1a authored over 1 year ago by Jannis R <[email protected]>
benchmarks: use date_filter_{min,max}() ⚡️📝

7a063ad41e96d0897dadb68c0005d4b2788b3194 authored over 1 year ago by Jannis R <[email protected]>
add --stats-by-route-date option 📝✅⚡️

Supports analyzing a feed by route and/or date and/or day of the week.

part of #33

d76e23cc0a5cb64160e866c8e3f73dc1c05ff062 authored over 1 year ago by Jannis R <[email protected]>
tests: buffer generated SQL using sponge ✅💚

8edb2b7c630dc00a1fc524271e0765d7d9f56e7c authored over 1 year ago by Jannis R <[email protected]>
Dockerfile, docs: use sponge too 📝

36f848aabc7b6811de775acaf57c3b3ca733271c authored over 1 year ago by Jannis R <[email protected]>
Dockerfile: default command; 4.6.0

e1a5d94c3bf0d346ec07f0fb6ec1a716750340bd authored over 1 year ago by Jannis R <[email protected]>
add date_filter_{min,max}() helper functions 📝✅

d86505c62f5782add716288e9a447c9eb275de9a authored over 1 year ago by Jannis R <[email protected]>
add --import-metadata option ✅📝

fa50150cf4e84780e161c20785fbde6d309583e7 authored over 1 year ago by Jannis R <[email protected]>
service_days: add index

229241867bf18012a7b3575f488d7e828998a7e5 authored almost 2 years ago by Jannis R <[email protected]>
readme: update benchmarks 📝

d27ae9bd09c5ca22fc29fb61d253d2eeca279b3b authored almost 2 years ago by Jannis R <[email protected]>
arrivals_departures: expose stop_sequence_consec

1576810d7f7d1efb34e0f3ff8f216835bef1a68f authored almost 2 years ago by Jannis R <[email protected]>
add todo; 4.5.3

32511a8bd3c762198acd6515135f679de96e5853 authored almost 2 years ago by Jannis R <[email protected]>
CLI: add missing --routes-without-agency-id option 🐛✅

513566ccdaa0d7cd1349da04869b5f6a126aed60 authored almost 2 years ago by Jannis R <[email protected]>
minor tweaks & fixes 🐛✅; put todos; 4.5.2

9d89b5c025ed4552facf7899b10a2a0c423e6339 authored almost 2 years ago by Jannis R <[email protected]>
push Docker image to Github 💚📝

6150163d3aae30cb4a5590eafacafc5f122367b6 authored almost 2 years ago by Jannis R <[email protected]>
readme: tweak instructions on how to import from within Docker 📝

ba217d2f0edcda74208ee755d2c0a78b8af1db62 authored almost 2 years ago by Jannis R <[email protected]>
Dockerfile: accept & evaluate globs by running via /bin/sh 🐛📝

76bb6d21fdfda7c63b9ab4d363109995ec742546 authored almost 2 years ago by Jannis R <[email protected]>
tweak readme 📝; 4.5.1

5d00586b2bb942912a5ef9e3d4d2952e8ce15edf authored almost 2 years ago by Jannis R <[email protected]>
fix serve-gtfs-via-graphql executable 🐛

8c2c7868d905dcc3225417502ad96eb560b7b678 authored almost 2 years ago by Jannis R <[email protected]>
eslint@8

24db08963f48c2dae3e746c406492d8a624a911f authored almost 2 years ago by Jannis R <[email protected]>
add {arrivals_departures,connections} by stop benchmark, refresh others ⚡️📝

6a022f24dcb166fc9daee967739026c7d356e67d authored about 2 years ago by Jannis R <[email protected]>
support TPEG-PTI route_type scheme 📝💚

81d3ba80f48bf9adcc0acc5a7a1bece685592ba4 authored about 2 years ago by Jannis R <[email protected]>
allow custom route_type scheme via opt.routeTypesScheme/--route-types-scheme 📝

66cbacd29bacbd8d28a8c62dcfa85f7c87c48ff7 authored about 2 years ago by Jannis R <[email protected]>
connections: expose {from,to}_stop_sequence_consec

d56fb16c5dbf521694fedf91efdb244edb772a52 authored about 2 years ago by Jannis R <[email protected]>
CI: run smoke tests with some GTFS datasets 💚

1bb057e2f82e6d6221cb1bad08ecdfacd55adde1 authored about 2 years ago by Jannis R <[email protected]>
readme: mention GraphQL peer dependencies 📝; 4.5.0

85e612597d0c0d38137691bbbe73880fd1587c0e authored about 2 years ago by Jannis R <[email protected]>
only create `postgraphile` role if it doesn't exist 🐛

df47b4c69f4730ea58da25545be618e5b1675709 authored about 2 years ago by Jannis R <[email protected]>
fix usage with non-default schema 🐛

ce6d5f25921dfe92ec52efec3536f61bd15eb6a4 authored about 2 years ago by Jannis R <[email protected]>
mri -> util.parseArgs

08fbb52c2f1c248951c350b7b15aab6e1268ddb3 authored about 2 years ago by Jannis R <[email protected]>
GraphQL schema: integrate spatial data types ✅

5f1300b3d4fbd0d68471a9930c4d3bfbd1862e59 authored about 2 years ago by Jannis R <[email protected]>
GraphQL schema: add translated* fields ✅

added:
- Stop.translatedStopName(language: String!)
- Route.translatedRouteShortName(language: S...

4747f200e2353d0ed4b46adb07e5926a4e8e6d06 authored about 2 years ago by Jannis R <[email protected]>
add {arrival_departure,connection}_id ✅

df5849a05cedd2e15a55506cc14231b8696249f9 authored about 2 years ago by Jannis R <[email protected]>
PostGraphile: tweak GraphQL schema inflection, add sample query ✅📝

9dae200755b8d005d8a42230b782b2da0484fb35 authored about 2 years ago by Jannis R <[email protected]>
tweak GraphQL schema using PostGraphile smart tags, indexes & constraints 📝

16409ea3eaaca56dfedbb4e18c16bef2dd6ef787 authored about 2 years ago by Jannis R <[email protected]>
add serve-gtfs-via-graphql PostGraphile script 📝

54fcc53dab4fa8cab481e298109d3d0842c4b399 authored about 2 years ago by Jannis R <[email protected]>
is_bcp_47_code: handle PostgreSQL with ICU locales only 🐛💚

832ca5728487d21af56477d90cb4669ae468adda authored about 2 years ago by Jannis R <[email protected]>
CI: always use Node 16, also test with PostgreSQL 15 💚

534ad8bb811115d5ac8ffe32c591b201c2dd4cf1 authored about 2 years ago by Jannis R <[email protected]>