Commit Graph

149 Commits

Author SHA1 Message Date
dancingCycle 94831d2a6b feat(api): add api routes stops-count-gtfs for states hb, hh and ni 2023-08-21 14:29:54 +02:00
dancingCycle 929b1d25ea chore(api): adjust package.json 2023-08-21 14:04:14 +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 715c9d4054 feat(gtfs): add WORK_DIR to gtfs/load.sh 2023-08-18 14:39:30 +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 56c7fe74e7 feat(zhv): remove excessive tmp csv files 2023-08-18 11:54:39 +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 0326681635 refactor: rename import.sh to init.sh 2023-06-30 11:27:51 +02:00
dancingCycle d874bb24ca feat(gtfs): adjust gtfs/import.sh 2023-06-30 05:26:08 +02:00
dancingCycle dbc899b599 feat(gtfs): add gtfs/import.sh 2023-06-29 19:43:25 +02:00
dancingCycle 01362f55b2 #29 feat: adjust gtfs/stops_zhv.sh 2023-06-29 11:49:15 +02:00
dancingCycle 63ed490670 #29 feat: adjust zhv/crontab 2023-06-29 11:30:12 +02:00
dancingCycle ff65a1cee8 #29 feat: adjust dload.sh 2023-06-29 11:27:32 +02:00
dancingCycle 82fafc9900 #29 chore: mv crontab 2023-06-29 11:02:08 +02:00
dancingCycle 8ea9d48eba #29 feat: adjust sql/create-tbl-stops.sql to DROP SCHEMA 2023-06-29 10:51:02 +02:00
dancingCycle 93db672ed4 #29 chore: mv crontab 2023-06-29 10:43:08 +02:00
dancingCycle 1e04c4682c feat(zhv): adjust dload/dload.sh 2023-06-28 21:43:36 +02:00
dancingCycle e9ece395c4 feat(zhv): adjust import.sh 2023-06-28 21:04:54 +02:00
dancingCycle 723acf42a0 feat(zhv): adjust import2*.sh 2023-06-28 21:02:20 +02:00
dancingCycle 25769554ab fix(zhv): adjust import2*.sh 2023-06-28 20:54:31 +02:00
dancingCycle d3b83c7b0e refactor(zhv): refactor import.sh 2023-06-28 20:47:30 +02:00
dancingCycle 93da3f0ff4 feat(zhv): add import2*.sh 2023-06-28 15:33:19 +02:00
dancingCycle 91053267a8 feat(zhv): adjust import.sh 2023-06-27 15:41:15 +02:00
dancingCycle fd089b721d fix(zhv): adjust sql/import.sql 2023-06-27 15:33:18 +02:00
dancingCycle d1faba1d3f feat(zhv): adjust sql/import.sql 2023-06-27 15:32:27 +02:00
dancingCycle dc04e04d5b feat(zhv): adjust sql/import.sql 2023-06-27 15:31:35 +02:00
dancingCycle 582eb509d8 fix(zhv): get rid of IMPORT variable 2023-06-27 15:24:52 +02:00
dancingCycle b420980aa3 feat(zhv): add import.sh 2023-06-27 15:15:18 +02:00
dancingCycle d98de92fa6 chore(ui): bump version to v0.0.4 2023-06-21 13:05:56 +02:00
dancingCycle 03795f68cc feat(ui): add pages stops-* 2023-06-21 13:05:16 +02:00
dancingCycle d2955366c9 chore(ui): bump version to v0.0.3 2023-06-21 11:53:20 +02:00
dancingCycle 555cf97a83 refactor(db): introduce refine.sh 2023-06-21 11:50:08 +02:00
dancingCycle 6c4b0523fc fix(api): adjust table names 2023-06-21 11:50:08 +02:00
dancingCycle 107501a0e9 feat(ui): add route gtfs-stops-de-not-dhid-refine* 2023-06-21 11:49:25 +02:00
dancingCycle a6b9af118a fix(ui): let api.js return value in error case 2023-06-21 11:03:33 +02:00
dancingCycle 9b45da2d63 feat(api): adjust route stops-gtfs-de-not-dhid-refine* 2023-06-21 10:42:38 +02:00
dancingCycle 2d77439bbd feat(ui): add route gtfs-stops-de-not-dhid-refine* 2023-06-20 15:27:32 +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 2b80cf060e chore(ui): bump version to v0.0.2 2023-06-15 16:13:32 +02:00