seb/group-1-db23
Archived
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

Commit Graph

  • da26e965a3 Remove big files. main Sebastian Lenzlinger 2024-04-22 22:55:40 +02:00
  • 40c3ceee19 Update .gitignore Sebastian Lenzlinger 2024-04-22 22:53:54 +02:00
  • 41d4320cd2 Update file map_michel.py Sebastian Lenzlinger 2024-02-01 16:09:55 +00:00
  • 1523dd3953 both methodes are executed now SoulKindred 2024-01-08 16:07:00 +01:00
  • 3faa920e8f Merge branch 'sebl' into 'main' Sebastian Lenzlinger 2024-01-08 15:01:22 +00:00
  • 1360ba04dc Fix small bugs in plot generation. Sebastian Lenzlinger 2024-01-08 16:00:26 +01:00
  • 06e3897b9c Merge remote-tracking branch 'origin/sebl' into sebl SoulKindred 2024-01-08 15:52:34 +01:00
  • 4a39a7c265 added some plots and calculations SoulKindred 2024-01-08 15:49:50 +01:00
  • f9f8323cfd SYNC COMMIT. Sebastian Lenzlinger 2024-01-08 15:30:17 +01:00
  • a768ee8b99 Update wiki.md Sebastian Lenzlinger 2024-01-08 14:29:34 +00:00
  • d2b311c731 Update wiki.md Sebastian Lenzlinger 2024-01-08 14:28:42 +00:00
  • beef5ad2c7 Merge remote-tracking branch 'origin/sebl' into sebl SoulKindred 2024-01-08 11:09:22 +01:00
  • 36dba35696 html that combines all plots SoulKindred 2024-01-08 11:08:58 +01:00
  • eda751f4e1 Merge branch 'sebl' into 'main' Sebastian Lenzlinger 2024-01-08 09:58:02 +00:00
  • 19ee2b27b7 Fix typo. Sebastian Lenzlinger 2024-01-08 10:57:03 +01:00
  • a22a0824d5 Merge remote-tracking branch 'origin/sebl' into sebl Sebastian Lenzlinger 2024-01-08 10:55:09 +01:00
  • aebb6f01f4 SYNC COMMIT Sebastian Lenzlinger 2024-01-08 10:54:58 +01:00
  • 9536153371 Merge branch 'michelr_testing' into sebl SoulKindred 2024-01-08 10:53:07 +01:00
  • bbfd93fc05 Calculations.py goes through all speed-limit zones and calculates how many accidents happened in a 5 meter radius around the line SoulKindred 2024-01-08 10:52:48 +01:00
  • 42561cbbd9 Merge branch 'michelr_testing' into sebl SoulKindred 2024-01-08 10:50:16 +01:00
  • 03ea16b1ab some refractoring for big html SoulKindred 2024-01-07 17:20:16 +01:00
  • aeeb2e368d Merge branch 'sebl' into 'main' Sebastian Lenzlinger 2024-01-06 15:57:11 +00:00
  • 7d9d561139 Add accident_copy.sql Sebastian Lenzlinger 2024-01-06 16:39:58 +01:00
  • 419856ab41 Merge remote-tracking branch 'origin/sebl' into sebl Sebastian Lenzlinger 2024-01-06 16:33:58 +01:00
  • e4f6b5bd7a Finalize making plots. Sebastian Lenzlinger 2024-01-06 16:33:06 +01:00
  • f5c75f5762 Finalize making plots. Sebastian Lenzlinger 2024-01-06 16:33:06 +01:00
  • 75a7ec967c Add method stubs for creating time series charts. Sebastian Lenzlinger 2024-01-06 14:10:21 +01:00
  • 96dbb54e50 SYNC COMMIT Sebastian Lenzlinger 2024-01-06 14:03:43 +01:00
  • def2784231 SYNC COMMIT Sebastian Lenzlinger 2024-01-06 13:48:20 +01:00
  • c4a139c6ef Add instructions to wiki.md. Sebastian Lenzlinger 2024-01-05 19:09:47 +01:00
  • 758bfa45f3 SYNC COMMIT Sebastian Lenzlinger 2024-01-05 19:05:09 +01:00
  • 7ae7d486f1 Fix HeatMap and HeatMapTime. We now generate correct html maps. Sebastian Lenzlinger 2024-01-05 18:14:38 +01:00
  • 0605036052 SYNC COMMIT Sebastian Lenzlinger 2024-01-05 16:46:35 +01:00
  • d563a0af0b SYNC COMMIT Sebastian Lenzlinger 2024-01-05 16:43:05 +01:00
  • 915066f735 Merge remote-tracking branch 'origin/sebl' into sebl Sebastian Lenzlinger 2024-01-05 16:03:21 +01:00
  • 033e66849e Small refactor of map.py. Sebastian Lenzlinger 2024-01-05 16:02:19 +01:00
  • 85864c32ab Merge remote-tracking branch 'origin/sebl' into sebl SoulKindred 2024-01-05 16:01:56 +01:00
  • 88c571d2f8 Added differentiation SoulKindred 2024-01-05 16:01:49 +01:00
  • 617cd2d1f4 Small refactor of map.py. Sebastian Lenzlinger 2024-01-05 15:45:39 +01:00
  • 0f73f829aa Fix map.py. Issue: No datapoints where displayed. Sebastian Lenzlinger 2024-01-05 15:44:00 +01:00
  • 3c00de0afb Refactor map.py Sebastian Lenzlinger 2024-01-05 14:42:05 +01:00
  • 685a5cf2d3 Merge remote-tracking branch 'origin/sebl' into sebl Sebastian Lenzlinger 2024-01-05 13:52:41 +01:00
  • cd6746d0ea Add Heat Map Generation Sebastian Lenzlinger 2024-01-05 13:52:04 +01:00
  • 40adf8a397 Add Heat Map Generation Sebastian Lenzlinger 2024-01-05 13:52:04 +01:00
  • 7c58cfc335 Fix 2 Add comments to setup_tables.sql Sebastian Lenzlinger 2024-01-04 18:37:16 +01:00
  • 200d913fa9 Fix 2 setup_tables.sql Sebastian Lenzlinger 2024-01-04 18:27:41 +01:00
  • 27c5ca1587 Fix setup_tables.sql Sebastian Lenzlinger 2024-01-04 18:26:36 +01:00
  • 6af1f734ef SYNC COMMIT Sebastian Lenzlinger 2024-01-04 18:20:55 +01:00
  • 843ed0a1a3 SYNC COMMIT Sebastian Lenzlinger 2024-01-04 16:18:28 +01:00
  • 4c5e7e1251 Hot Fix and add tester.ipynb. Sebastian Lenzlinger 2024-01-04 16:03:04 +01:00
  • 4523b3d8e5 Update .gitignore. Sebastian Lenzlinger 2024-01-04 15:47:54 +01:00
  • 92e54174cc Add db_connector.py body and beginnings of map.py. As well as config_example.py to use as central source of truth for connection credentials. Sebastian Lenzlinger 2024-01-04 15:47:00 +01:00
  • ab1baacf47 Changed something ? SoulKindred 2024-01-04 12:36:26 +01:00
  • a26d822a78 Uploading new html map and interactive map now works with time slider SoulKindred 2024-01-03 18:49:19 +01:00
  • a1c2dfcdd8 html map SoulKindred 2024-01-03 17:29:00 +01:00
  • f2ae25268c Made map less noizy SoulKindred 2024-01-03 17:26:20 +01:00
  • 7bd5c24e9d Corrected speedlimits SoulKindred 2024-01-03 17:22:42 +01:00
  • e8dfcc72c4 Not much changed. Sig_speeds are now by default not shown SoulKindred 2024-01-03 16:52:39 +01:00
  • b14dd6036a Merge remote-tracking branch 'refs/remotes/origin/sebl' into sebl SoulKindred 2024-01-03 15:53:38 +01:00
  • c450fbe7ef miv-testing and adding speed to i-map SoulKindred 2024-01-03 15:52:20 +01:00
  • 0d9e71618d Update requirements.txt. Begin Analysis. Sebastian Lenzlinger 2024-01-03 15:50:55 +01:00
  • 994b9ce7d0 Fix implicit boolean conversion bug for integrate.py when integrating accident data. FIXES: Non empty strings are all converted to true when using bool() constructor, so 'true' and 'false' become True regardelss. Sebastian Lenzlinger 2024-01-03 15:34:50 +01:00
  • 5b41db5e7e Add logger statements and first plays with accident data in notebook. Sebastian Lenzlinger 2024-01-03 13:49:01 +01:00
  • b9ee59e4ae Modification to make scripts run on server Sebastian Lenzlinger 2024-01-02 15:53:22 +01:00
  • a927d982b4 Update file README.md Sebastian Lenzlinger 2023-12-03 23:00:07 +00:00
  • 8be3279ace Merge branch 'dev-explore' into 'main' Sebastian Lenzlinger 2023-12-03 22:58:31 +00:00
  • 9e2709eaaa Merge branch 'main' into 'dev-explore' Sebastian Lenzlinger 2023-12-03 22:56:37 +00:00
  • 49bb3f4e20 Data Integration Milestone Completed. Refactored ensuring all relevant dirs exist into separate script. Sebastian Lenzlinger 2023-12-03 23:53:36 +01:00
  • 1ab8c9fb2e Update file README.md Michel Romancuk 2023-12-03 21:57:42 +00:00
  • e9b1d82517 FINAL TOUCH: Add functions to get data from api link. Refactor bash script into python function to ensure portability. Add sql queries to create "Contemporaneous" db table. Sebastian Lenzlinger 2023-12-03 22:52:20 +01:00
  • b79ee792b6 Preliminary: Completed Integration Scripts. Add scripts that load data into a database of choice. Some config is still manual. Sebastian Lenzlinger 2023-12-03 21:40:29 +01:00
  • fcfb3f028b Intermediate Commit Sebastian Lenzlinger 2023-12-03 20:46:54 +01:00
  • 45b4f7b998 Merge remote-tracking branch 'origin/dev-explore' into dev-explore Sebastian Lenzlinger 2023-12-03 19:27:35 +01:00
  • 39b28a4b65 Merge remote-tracking branch 'origin/dev-explore' into dev-explore Sebastian Lenzlinger 2023-12-03 17:37:07 +01:00
  • dcf921292b Merge remote-tracking branch 'origin/dev-explore' into dev-explore Sebastian Lenzlinger 2023-12-03 17:37:07 +01:00
  • 90a38b1bb5 Drop duplicates in unified miv csv. Sebastian Lenzlinger 2023-12-03 17:05:09 +01:00
  • 920f725d74 Drop duplicates in unified miv csv. Sebastian Lenzlinger 2023-12-03 17:05:09 +01:00
  • c33ca87aaf UNFINNISHED: Script to create csv of integrated and clean datasets. Sebastian Lenzlinger 2023-12-03 16:34:40 +01:00
  • 1ef7bbe39b Convert MIV coordinate to Int Sebastian Lenzlinger 2023-12-03 13:37:11 +01:00
  • 94ee3cc3b0 ADD ID to fb. Sebastian Lenzlinger 2023-12-03 13:18:01 +01:00
  • 65bd9480e7 Load accident file from internet if not present. Sebastian Lenzlinger 2023-12-03 12:35:38 +01:00
  • 0afab39397 Merge remote-tracking branch 'origin/dev-explore' into dev-explore Sebastian Lenzlinger 2023-12-03 12:30:26 +01:00
  • ca3450a4de Add logger. Sebastian Lenzlinger 2023-12-03 12:28:32 +01:00
  • e4d0484a23 Add logger. Sebastian Lenzlinger 2023-12-03 12:28:32 +01:00
  • e73962d8e1 + Sebastian Lenzlinger 2023-12-03 11:48:32 +01:00
  • cd0bb639ca Merge remote-tracking branch 'origin/dev-explore' into dev-explore Sebastian Lenzlinger 2023-12-03 11:48:19 +01:00
  • 793b783dd9 + Sebastian Lenzlinger 2023-12-03 11:45:00 +01:00
  • 983f85b116 Fix requirements.txt Sebastian Lenzlinger 2023-12-03 11:45:00 +01:00
  • 250e13acba Fix requirements.txt Sebastian Lenzlinger 2023-12-03 11:44:42 +01:00
  • b6715a0ff1 UNFINNISHED: Commit for Syncing Repos Sebastian Lenzlinger 2023-12-03 01:09:32 +01:00
  • 101243fae8 Add test notebook for debugging on different machine Sebastian Lenzlinger 2023-12-03 00:28:25 +01:00
  • e07932a113 UNFINNISHED: Add data integration scripts. Sebastian Lenzlinger 2023-12-02 22:10:47 +01:00
  • 77bf140efc Add Text File containing relevant datasource urls. First diary entries written. Wiki entries on how to setup a python virtual env for the project Sebastian Lenzlinger 2023-11-16 18:40:42 +01:00
  • 653c3341ce Add Text File containing relevant datasource urls. First diary entries written. Wiki entries on how to setup a python virtual env for the project Sebastian Lenzlinger 2023-11-16 18:40:42 +01:00
  • 8cf5940a4d Add Text File containing relevant datasource urls. First diary entries written. Wiki entries on how to setup a python virtual env for the project Sebastian Lenzlinger 2023-11-16 18:04:10 +01:00
  • 552b49f118 Add Text File containing relevant datasource urls. First diary entries written. Wiki entries on how to setup a python virtual env for the project Sebastian Lenzlinger 2023-11-16 17:27:21 +01:00
  • f39d3d5963 Merge branch 'dev-explore' into 'main' Sebastian Lenzlinger 2023-11-16 15:50:19 +00:00
  • b47ee9ea1d Add Text File containing relevant datasource urls Sebastian Lenzlinger 2023-11-16 16:49:10 +01:00
  • c70ecbc11e Merge branch 'dev-explore' into 'main' Sebastian Lenzlinger 2023-11-16 15:25:30 +00:00
  • 401ce9dd30 Update .gitignore Sebastian Lenzlinger 2023-11-16 15:24:47 +00:00