dancingCycle
|
0c0c4a916b
|
feat(gtfs): add gtfs/dload-pre.sh and gtfs/dload-post.sh
|
2023-09-12 13:23:38 +02:00 |
dancingCycle
|
45222fbb96
|
fix(db): refactor db/sql/update.sql
|
2023-08-31 19:36:01 +02:00 |
dancingCycle
|
79ce42f63e
|
fix(db): add table/ view gtfs_stops_not_de
|
2023-08-31 15:17:37 +02:00 |
dancingCycle
|
306aa0a6aa
|
fix(db): switch :schema_gtfs with :schema in db/sql/gtfs-join-trats.sql
|
2023-08-29 13:23:09 +02:00 |
dancingCycle
|
079407dbf8
|
feat(db): add script db/gtfs-join-trats.sh
|
2023-08-29 13:06:36 +02:00 |
dancingCycle
|
e1a6c977f3
|
feat(db): replace ORDER BY with ORDER BY DESC
|
2023-08-29 09:51:55 +02:00 |
dancingCycle
|
2844b401f5
|
fix(db): switch de_he to de_hh
|
2023-08-29 09:30:50 +02:00 |
dancingCycle
|
e970038606
|
fix(db): switch from schema:. to :schema.
|
2023-08-29 09:26:16 +02:00 |
dancingCycle
|
a697a72b60
|
feat(db): create table/view for gtfs stop names with part or no DHID
|
2023-08-29 09:23:06 +02:00 |
dancingCycle
|
a9337771a7
|
chore(db): refactor
|
2023-08-28 20:57:15 +02:00 |
dancingCycle
|
72b9beb170
|
chore(db): refactor
|
2023-08-28 20:13:39 +02:00 |
dancingCycle
|
aabed958be
|
feat(db): add :schema.vw_gtfs_stops_lt_0 view and corresponding table
|
2023-08-28 08:00:43 +02:00 |
dancingCycle
|
c9e3a17f55
|
feat(db): adjust db/sql/join_srta.sql for vmt-thueringen.de
|
2023-08-25 14:05:40 +02:00 |
dancingCycle
|
b6d7e0f314
|
feat(db): adjust db/sql/join_srta.sql for vrn
|
2023-08-23 11:56:20 +02:00 |
dancingCycle
|
7075cb35d7
|
feat(db): extend db/copy-stops-not-global-id.sh with states sh, mv, bb, be, st, nw, he, sn, th, rp, sl, by and bw
|
2023-08-22 12:07:16 +02:00 |
dancingCycle
|
b6bff81d57
|
fix(db): add sh, mv, bb, st, be, nw, he, sn, th, rp, sl, by and bw subset of stops that do not comply with Global ID
|
2023-08-22 09:36:12 +02:00 |
dancingCycle
|
330cb0d1b0
|
fix(db): add sh, mv, bb, st, be, nw, he, sn, th, rp, sl, by and bw subset of stops that do not comply with Global ID
|
2023-08-22 09:34:51 +02:00 |
dancingCycle
|
c5428fd6fe
|
fix(db): add sh, mv, bb, st, be, nw, he, sn, th, rp, sl, by and bw subset of stops that do not comply with Global ID
|
2023-08-22 09:31:24 +02:00 |
dancingCycle
|
a970631eda
|
feat(db): add sh, mv, bb, st, be, nw, he, sn, th, rp, sl, by and bw subset of stops that do not comply with Global ID
|
2023-08-22 09:13:28 +02:00 |
dancingCycle
|
5c3a03d107
|
feat(db): add db/copy-stops-not-global-id.sh
|
2023-08-21 08:49:39 +02:00 |
dancingCycle
|
16265d42b2
|
fix(chore): we do not need to DROP VIEW or DROP TABLE if we DROP SCHEMA in advance
|
2023-08-21 06:28:14 +02:00 |
dancingCycle
|
2be4def296
|
fix(db): call DROP SCHEMA on :schema but not on :schema_gtfs
|
2023-08-21 06:25:32 +02:00 |
dancingCycle
|
4832fb228b
|
fix(db): call DROP SCHEMA on :schema but not on :schema_gtfs
|
2023-08-21 06:23:43 +02:00 |
dancingCycle
|
db0087933f
|
fix(db): remove excess DROP SCHEMA call
|
2023-08-18 17:02:39 +02:00 |
dancingCycle
|
3efb5c5f9d
|
feat(db): add hb, hh and ni subset of stops that do not comply with Global ID
|
2023-08-18 14:21:27 +02:00 |
dancingCycle
|
d92bf2ae5b
|
fix(db): add missing schema variable :schema_gtfs
|
2023-08-18 11:52:35 +02:00 |
dancingCycle
|
18e8642a2c
|
feat(db): add db/sql/join_srta.sql
|
2023-08-18 11:50:19 +02:00 |
dancingCycle
|
c9adb0f251
|
feat: add schema_gtfs
|
2023-06-30 13:09:29 +02:00 |
dancingCycle
|
555cf97a83
|
refactor(db): introduce refine.sh
|
2023-06-21 11:50:08 +02:00 |
dancingCycle
|
ad9160acb9
|
feat(db): drop before create schema
|
2023-06-20 14:45:04 +02:00 |
dancingCycle
|
f756f91095
|
feat(db): add aditional index to sql/stops-gtfs-de-not-dhid-refine.sql
|
2023-06-20 14:37:01 +02:00 |
dancingCycle
|
cc6286f64e
|
feat(db): add refine.sh
|
2023-06-20 14:11:59 +02:00 |
dancingCycle
|
b16d29698b
|
fix(db): adjust :schema.vw_gtfs_stops_de
|
2023-06-20 13:47:25 +02:00 |
dancingCycle
|
837a64baf4
|
refactor(db): refactor
|
2023-06-20 13:43:51 +02:00 |
dancingCycle
|
f3733150b8
|
feat(db): add table tbl_stops_gtfs_de to sql/stops-gtfs-de-not-dhid.sql
|
2023-06-20 13:30:15 +02:00 |
dancingCycle
|
9cb43a4207
|
fix(db): query correct table analysis.tbl_stops_gtfs_de
|
2023-06-15 15:24:55 +02:00 |
dancingCycle
|
d60ffba848
|
refactor(db): mv sql folder
|
2023-06-15 15:17:12 +02:00 |
dancingCycle
|
8984cca8c7
|
feat(db): add sql script sql/stops-gtfs-de-not-dhid.sql
|
2023-06-15 15:14:57 +02:00 |