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

minor tweaks 📝; 4.4.3

7de216b1a9c5b7be15690b381026b341f483445f authored about 2 years ago by Jannis R <[email protected]>

CI: also publish as publictransport/gtfs-via-postgres:4 💚

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

frequencies: add unique(trip_id, {start,end}_time, headway_secs, exact_times) constraint

8d7a63fc9f15d881453203f83131a0566443444d authored about 2 years ago by Jannis R <[email protected]>

fix options parsing & defaults 🐛, add them to the SQL

4ad0c177e1e055d264694f93d5ef7fa6697c4973 authored about 2 years ago by Jannis R <[email protected]>

change commercial license link 📝

fixes #29

b0e0a0c1112953e5ec1fae5a1436cf2260bcbe88 authored over 2 years ago by Jannis R <[email protected]>

minor fixes 📝; 4.4.2

c5bcdad7db0ccb1422cf2c970e222dfb84fd4489 authored over 2 years ago by Jannis R <[email protected]>

move to public-transport org, publictransport Docker org 📝

13e84874c37a110c850d659139094ee676b38d77 authored over 2 years ago by Jannis R <[email protected]>

move to public-transport org; 4.4.1

02bcfec50981e4e68847e95bc7475094e8bf3396 authored over 2 years ago by Jannis R <[email protected]>

put comment; 4.4.0

17c37c69acde253aae71dacceda876041bc8687f authored over 2 years ago by Jannis R <[email protected]>

add {stops,routes,trips,arrivals_departures,connections}_translated views ✅

7f35edc52f575c7dbcc4397431a94e9a0d11cdb4 authored over 2 years ago by Jannis R <[email protected]>

arrivals_departures/connections: expose trip/stop headsign

a0e78824da58b0b91515bb7a102d9b729fd2644a authored over 2 years ago by Jannis R <[email protected]>

translations: handle refs to missing tables 🐛

3e3abd3d25703150dd986f738863f92576631a59 authored over 2 years ago by Jannis R <[email protected]>

translations.txt: validate references to other table's columns

72adac149b1901f61da124c4d0e791a487245b30 authored over 2 years ago by Jannis R <[email protected]>

support translations.txt ✅📝

e477aa1fa75a046e854246a0a3d09805523d74d5 authored over 2 years ago by Jannis R <[email protected]>

readme: update list of related projects 📝; 4.3.1

7748403985bb6d2e340bac9b1c2d721183f4d7e1 authored over 2 years ago by Jannis R <[email protected]>

feed_info: validate {feed,default}_lang, minor fixes

9219d21edb9d8fb760dbf8a2a88463e6f41f6dd1 authored over 2 years ago by Jannis R <[email protected]>

csv-stringify@6

related: https://github.com/adaltas/node-csv/issues/315#issuecomment-1200431904

b8d05298ebb5218effa1d1afde731c5970730f8c authored over 2 years ago by Jannis R <[email protected]>

fix usage without shapes.csv 🐛

follow-up of f29683b

e62146a70efd81fd53139b36203c63e6acb06618 authored over 2 years ago by Jannis R <[email protected]>

Rename e02e3ce-2022-07-08T21:17:49+02:00.csv to e02e3ce-2022-07-08.csv

Filename made git cloning fail from remote, filename change fixing issue.

2a27ef56edeec5bc7bf862b43d0eea598e7bdfb3 authored over 2 years ago by Benoit <[email protected]>

tweak readme 📝

f0e08828638c24c3c36bedb8e044ed5e32b95d6a authored over 2 years ago by Jannis R <[email protected]>

build Node-18-based binaries

8f9151b639d19f1926fd2a7162c806356b7653c0 authored over 2 years ago by Jannis R <[email protected]>

add more benchmarks 🚀📝

2fa8caedcd14f2b5a8295b251914a8be062d59e6 authored over 2 years ago by Jannis R <[email protected]>

add benchmarks ⚡️📝

e748dfb37794d7a7c0ebc7cd63d89318538d1db5 authored over 2 years ago by Jannis R <[email protected]>

minor fixes; 4.3.0

e02e3ce3b877bc46f6e157ea9f0379d5f2a2692d authored over 2 years ago by Jannis R <[email protected]>

add --stops-location-index option 📝

2c942e1ebdb7e9ba098c19ca23cff2087821aea1 authored over 2 years ago by Jannis R <[email protected]>

add todo; 4.2.0

[ci skip]

61adf72586f715a32dc79584ac192741507bd104 authored over 2 years ago by Jannis R <[email protected]>

fix usage without shapes.csv 🐛

follow-up of a1304a9

related: #20

f29683bac713b3fdbf8c46d036ee808135c681db authored over 2 years ago by Jannis R <[email protected]>

trips: handle non-unique shapes.shape_id 🐛

fixes #20

a1304a923c94c982106cc892b6894941f12f1eee authored over 2 years ago by Jannis R <[email protected]>

add --schema option, default to "public"

closes #22

Co-authored-by: Jannis R <[email protected]>

f6881e3d65166b0fd3b36db35d4ee660fe67f858 authored over 2 years ago by Majk Shkurti <[email protected]>

pre-built binaries: Node latest -> 16

b9c7796964b96816d775c69a453cc8f8720f06a0 authored almost 3 years ago by Jannis R <[email protected]>

arrivals_departures & connections: expose direction_id

531cbb8d53452e6029063c02f0c4cc10d530e969 authored almost 3 years ago by Jannis R <[email protected]>

minor tweaks; 4.1.0

1299dfca53305469008574e3bf0e446ae559d792 authored almost 3 years ago by Jannis R <[email protected]>

minor tweaks 📝; 4.0.1

474d7419cdcf2fd6b1ae1f10b1e2d2abd2650379 authored almost 3 years ago by Jannis R <[email protected]>

Docker build: ignore more files

6fe12ac244ea9efdb0d68a3f9b743bbaf7924632 authored almost 3 years ago by Jannis R <[email protected]>

CI: publish arm64 Linux/macOS binaries too 💚

b84579059c59afefea2b55e17a035cc4c10792e2 authored almost 3 years ago by Jannis R <[email protected]>

CI: fix publishing by running with PostgreSQL 14 💚

54f3dfe36815384d4d957d95f02e8d8cb6fcfe47 authored almost 3 years ago by Jannis R <[email protected]>

minor tweaks 📝; 4.0.0

c4320ee1b5b1dabe03470154195d3bcf283c3c35 authored almost 3 years ago by Jannis R <[email protected]>

add debug logging

fad2414cf42c964dee085c7ec96a1598ad6a81a7 authored almost 3 years ago by Jannis R <[email protected]>

handle missing frequencies.txt 🐛

d11e5dc506a8014a03df4924fd76e69b6a6314b2 authored almost 3 years ago by Jannis R <[email protected]>

CI: run with PostgreSQL 14 💚

14fa99c2208373a8c5b243afecd7b63ff431709e authored almost 3 years ago by Jannis R <[email protected]>

gtfs-utils@5; Node 16+ 💥💚

7c3a11c10ceeef20bcfb3e445be8852af15c66df authored almost 3 years ago by Jannis R <[email protected]>

readme: compare with gtfs-sql-importer 📝

068c8d7b50c6fb080ad8baa82dbbbe73c5106c4f authored almost 3 years ago by Jannis R <[email protected]>

readme: update performance, minor tweaks 📝

[ci skip]

ef50409f138386eb21293017369ef291c4c55248 authored almost 3 years ago by Jannis R <[email protected]>

arrivals_departures: support frequencies.txt ✅📝

part of #2

25423d9bb481b88dcf1b4c554f88b0039e86bd80 authored almost 3 years ago by Jannis R <[email protected]>

connections: refactor for frequencies.txt support

113c0c60efab362c7f0dcc5566bf05b2444b8e53 authored almost 3 years ago by Jannis R <[email protected]>

connections: support frequencies.txt ✅📝

fixes #2

b66039187fb5a551405c4509f7bdb436ea16a2cd authored almost 3 years ago by Jannis R <[email protected]>

arrivals_departures: refactor for frequencies.txt support

part of #2

c325a668ebed79fe3401c032d2d7511d6b4eeb35 authored almost 3 years ago by Jannis R <[email protected]>

minor tweaks 📝; 3.1.0

[ci skip]

7145b924ca59ed34ff4d9534480ab7fdfac0d891 authored almost 3 years ago by Jannis R <[email protected]>

readme: update to 2022-02-25 VBB GTFS 📝

[ci skip]

f2248f5ba0a61427bf32495947609078979df0ad authored almost 3 years ago by Jannis R <[email protected]>

support pathways.txt ✅

c47c954abc51b90113015b38da8c8470f782974a authored almost 3 years ago by Jannis R <[email protected]>

arrival_departures & connections: add timepoint ✅

fdad3242dc0fafbd88043867aed7f47ab89e25e8 authored almost 3 years ago by Jannis R <[email protected]>

support levels.txt, add --stops-without-level-id option 📝✅

ca202be777d207af83d2a1a7e0c9877ca440a49b authored almost 3 years ago by Jannis R <[email protected]>

fix CI binary & Docker image publishing 💚

bd23f33fb831f821b2a24dcfb3c083c3afebd57f authored about 3 years ago by Jannis R <[email protected]>

minor tweaks; 3.0.2

effdcf59634788c58a1f7ea0ceecf5c7de3bfe59 authored about 3 years ago by Jannis R <[email protected]>

validate stops.stop_timezone

a711f02c660f093a65437dcbb15851b2a72129ab authored about 3 years ago by Jannis R <[email protected]>

handle missing {calendar,calendar_dates} 🐛

part of #18
fixes #16
fixes #18

5b3381fb36bd4633b59b815a0dd0296664374800 authored about 3 years ago by Jannis R <[email protected]>

calendar_dates only test ✅

part of #18

04fe087725ebd240a3dec1529f19753b144b956a authored about 3 years ago by Jannis R <[email protected]>

Amtrak 2021-10-06 test ✅

01339dc927a7a3996b4a5849d054548d9bf9be76 authored about 3 years ago by Jannis R <[email protected]>

--routes-without-agency-id: don't depend on agency.txt 🐛

e97a3fde1052dc452562afecaea1ebd3bb455eae authored about 3 years ago by Jannis R <[email protected]>

adapt tests to PostgreSQL 14 💚

85741a97d7227eb593ca9862d9ca2123ee55e671 authored about 3 years ago by Jannis R <[email protected]>

CI: run linter 💚; 3.0.1

f3f64aac668ecd21aa6f6cb2a4477dd25b892d6d authored about 3 years ago by Jannis R <[email protected]>

handle stdout backpressure 🐛

bf17cb815d7962df56bbab335991efb7485ba000 authored about 3 years ago by Jannis R <[email protected]>

minor tweaks; 3.0.0

ec980819e1ee7cd1fcb5310f36d70e9eac905cd8 authored over 3 years ago by Jannis R <[email protected]>

gtfs-utils@4; Node 14+ 💥

9982b36c4c69da3b14d71f7d736d5c574e3aba26 authored over 3 years ago by Jannis R <[email protected]>

connections: stop_sequence -> {from,to}_stop_sequence 💥

b5bf51d1b01a6e3351046bc2665158eaacc80928 authored over 3 years ago by Jannis R <[email protected]>

CI: publish on tags 💚

c63b356609bbe9bc0ecd0b6b2a58ef75eb96b740 authored over 3 years ago by Jannis R <[email protected]>

remove (service_days|arrivals_departures).t_base 💥

cbec416bfc2e6d3b424f3ba35d8ac75ddf4fe3d9 authored over 3 years ago by Jannis R <[email protected]>

lib/converter: pass opt into formatRow & afterAll

5a83cb03e5e84f1802e1177e9375f811725d1c36 authored over 3 years ago by Jannis R <[email protected]>

tweak readme 📝; 2.9.2

bc440f32764bd58faca6a4258b7f0b6429abd8c4 authored over 3 years ago by Jannis R <[email protected]>

don't hardcode Europe/Berlin time zone

The GTFS spec *requires* `agency_timezone` to be present, so in `coalesce()`, we always have a f...

11f208c7d5e1fc21a176c8cb33965419d4e43849 authored over 3 years ago by Jannis R <[email protected]>

validate agency.agency_timezone

part of #9

7bec1d821ad0026ed805ac796f57e359fb08c2ac authored over 3 years ago by Jannis R <[email protected]>

[email protected], pkg@5

b49b9446dca4d4e0b05436584ac76f4c00aa057d authored over 3 years ago by Jannis R <[email protected]>

CI: build & publish Docker image 💚

44171adf910588b3641a0ffef12754b137705eec authored over 3 years ago by Jannis R <[email protected]>

fix ON_ERROR_STOP flag 🐛; 2.9.1

964866b14f08a7ddb53373c98dc3b0d72d2d878c authored over 3 years ago by Jannis R <[email protected]>

arrivals_departures: add shape_id column

ed577102ce2245bac0eade79dca28b019094dc36 authored over 3 years ago by Jannis R <[email protected]>

fix --routes-with-agency-id option 🐛

8e19ebc2db196bac7d0e6635f72d3e47a2a5b19a authored over 3 years ago by Jannis R <[email protected]>

minor tweaks 📝; 2.9.0

4ed659b5ffc6b3b84a6c198180ad931464a4e5b9 authored over 3 years ago by Jannis R <[email protected]>

connections: expose more columns

0f9c4107e06c5d6ca30475ee355e54bbb5d3aa66 authored over 3 years ago by Jannis R <[email protected]>

arrivals_departures: expose more columns

106bd09d84864a624b9c12ae807b9b3a1a48e4e9 authored over 3 years ago by Jannis R <[email protected]>

add --routes-without-agency-id

97236cbad9cb1297856d4917fc55021386c8c829 authored over 3 years ago by Jannis R <[email protected]>

fix binary publishing again 💚

8a1032f2de7f429dd270c3a1eab9c768657e6ba9 authored over 3 years ago by Jannis R <[email protected]>

various fixes 📝; 2.8.4

5c588357714cc3d2a2d3ee0136d313c740720e2e authored over 3 years ago by Jannis R <[email protected]>

add Dockerfile; readme: how to use Docker image 📝

86825eac61ae64563d2730b7f4ab2f87c2b9072b authored over 3 years ago by Jannis R <[email protected]>

example.sh: how to query connections/arrivals_departures 📝; 2.8.3

560744ecfb2b35feb0c6da9230f94f3042a50dc5 authored over 3 years ago by Jannis R <[email protected]>

connections: handle missing to_stations row 🐛

adc3892c156ae48e030576b8fab6b53b8db68108 authored over 3 years ago by Jannis R <[email protected]>

readme: fix binary build badge, minor tweaks 📝; 2.8.2

a23de28f7e117e1a56f9ab231e615185b0798aa2 authored over 3 years ago by Jannis R <[email protected]>

CI: don't run two workflows on tags 💚

- run `test` workflow only on *branch* pushes/PRs
- let `publish-binaries` workflow all run the ...

32580912b0e939c42545b82203f9ff0e2a1f9973 authored over 3 years ago by Jannis R <[email protected]>

tweak CLI help 📝; eslint@7; 2.8.1

7036713d9a2b41ce42caf471ff7664c2bf7662ae authored over 3 years ago by Jannis R <[email protected]>

trips: reference shapes.shape_id; readme: add --trips-without-shape-id 📝

related: #8

30855132f15699a263cec3a22866013a50d517e5 authored over 3 years ago by Jannis R <[email protected]>

CI: simplify binary names 💚; readme: mention binaries 📝

[ci skip]

3dc41110f32f1512d3a83d30d7b0da5da140857a authored over 3 years ago by Jannis R <[email protected]>

[email protected]; 2.8.0

085b3bf61390605b4a4475daf71045dcdb086d18 authored over 3 years ago by Jannis R <[email protected]>

connections: add from_pickup_type/to_drop_off_type

ef2bef45609a61ac2f0edc9f274adb365039fc78 authored over 3 years ago by Jannis R <[email protected]>

build & upload binaries ✅

e553ccf1e74031cbd2a6c768122e23d4ae1be60b authored over 3 years ago by Jannis R <[email protected]>

--trips-without-shape-id option; 2.7.0

be807f1d358a9fbaca93990c46bc37ee367f3c8f authored almost 4 years ago by Jannis R <[email protected]>

minor tweaks; readme: explain COPY SQL cmd 📝

481b325d3a78a5cb31a6e1df27585c7930f3c1c4 authored almost 4 years ago by Jannis R <[email protected]>

readme: minor tweaks 📝; 2.6.1

[ci skip]

b2caec9d4bf13e7c05b5ca22ea94f97aede11cce authored almost 4 years ago by Jannis R <[email protected]>

speed up connections view 🐛

Thanks @hbruch!

closes #10

34f2f6873067103e66946e6289a25c78b617ccfe authored almost 4 years ago by Jannis R <[email protected]>

stop_times: add stop_sequence_consec column

a910265747fb33eaf2ee9321fef900a107ced74f authored almost 4 years ago by Jannis R <[email protected]>

2.6.0

[ci skip]

7a89df8fd6c966a4fae3905a7a80f34caeae36f8 authored almost 4 years ago by Jannis R <[email protected]>

arrivals_departures/connections: don't hardcode tz 🐛

Use station tz, falling back to stop tz, falling back to agency tz.

811dffdb8ef8ff907a0f62a09678a2292e8b7aca authored almost 4 years ago by Jannis R <[email protected]>

Ecosyste.ms: OpenCollective

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