Einzelmessungen
- Messung_Datum
- Datum der Messung
- Messung_Timestamp
- Zeitpunkt der Messung
- Messung_Zeit
- Uhrzeit der Messung
- Phase
- Phase der Messung (Vormessung, Betrieb, Nachmessung oder nach Ende)
- V_Ausfahrt
- Ausfahrtsgeschwindigkeit in km/h
- V_Delta
- Differenz zwischen Einfahrts- und Ausfahrtsgeschwindigkeit in km/h
- V_Einfahrt
- Einfahrtsgeschwindigkeit in km/h
- Zyklus
- Messzyklus
- id_standort
- Eindeutige Standortkennung
>10,000 rows count all where ID = "1-57" sorted by Messung_Timestamp descending
This data as json, copyable, CSV (advanced)
Suggested facets: Phase, Messung_Datum, Messung_Datum (date), Messung_Timestamp (date)
Link | rowid | ID | id_standort | Zyklus | Phase | Messung_Datum | Messung_Zeit | V_Einfahrt | V_Ausfahrt | Messung_Timestamp ▲ | V_Delta |
---|---|---|---|---|---|---|---|---|---|---|---|
6436720 | 6436720 | Erlenmattstrasse 1-57 | 57 | 1 | Nach Ende | 2023-07-10 | 12:51:34.000000 | 15 | 14 | 2023-07-10 12:51:34+02:00 | -1 |
6436719 | 6436719 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 12:36:45.000000 | 27 | 26 | 2023-07-10 12:36:45+02:00 | -1 |
6436718 | 6436718 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 12:29:02.000000 | 16 | 20 | 2023-07-10 12:29:02+02:00 | 4 |
6436717 | 6436717 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 12:14:48.000000 | 25 | 23 | 2023-07-10 12:14:48+02:00 | -2 |
6436716 | 6436716 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 12:12:13.000000 | 17 | 22 | 2023-07-10 12:12:13+02:00 | 5 |
6436715 | 6436715 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 12:04:04.000000 | 25 | 27 | 2023-07-10 12:04:04+02:00 | 2 |
6436714 | 6436714 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 11:57:32.000000 | 14 | 12 | 2023-07-10 11:57:32+02:00 | -2 |
6436713 | 6436713 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 11:09:14.000000 | 30 | 28 | 2023-07-10 11:09:14+02:00 | -2 |
6436712 | 6436712 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 11:06:09.000000 | 23 | 30 | 2023-07-10 11:06:09+02:00 | 7 |
6436711 | 6436711 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 11:04:07.000000 | 18 | 12 | 2023-07-10 11:04:07+02:00 | -6 |
6436710 | 6436710 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 10:39:59.000000 | 24 | 32 | 2023-07-10 10:39:59+02:00 | 8 |
6436709 | 6436709 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 10:30:00.000000 | 23 | 25 | 2023-07-10 10:30:00+02:00 | 2 |
6436708 | 6436708 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 09:55:37.000000 | 19 | 15 | 2023-07-10 09:55:37+02:00 | -4 |
6436707 | 6436707 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 09:50:13.000000 | 25 | 31 | 2023-07-10 09:50:13+02:00 | 6 |
6436706 | 6436706 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 09:27:37.000000 | 17 | 18 | 2023-07-10 09:27:37+02:00 | 1 |
6436705 | 6436705 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 09:18:13.000000 | 16 | 13 | 2023-07-10 09:18:13+02:00 | -3 |
6436704 | 6436704 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 09:00:31.000000 | 24 | 26 | 2023-07-10 09:00:31+02:00 | 2 |
6436703 | 6436703 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 08:50:31.000000 | 10 | 13 | 2023-07-10 08:50:31+02:00 | 3 |
6436702 | 6436702 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 08:00:19.000000 | 30 | 25 | 2023-07-10 08:00:19+02:00 | -5 |
6436701 | 6436701 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 07:54:25.000000 | 20 | 18 | 2023-07-10 07:54:25+02:00 | -2 |
6436700 | 6436700 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 07:53:24.000000 | 15 | 18 | 2023-07-10 07:53:24+02:00 | 3 |
6436699 | 6436699 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 07:51:30.000000 | 17 | 15 | 2023-07-10 07:51:30+02:00 | -2 |
6436698 | 6436698 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 07:34:31.000000 | 20 | 14 | 2023-07-10 07:34:31+02:00 | -6 |
6436697 | 6436697 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 07:27:43.000000 | 13 | 16 | 2023-07-10 07:27:43+02:00 | 3 |
6436696 | 6436696 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 07:21:23.000000 | 16 | 11 | 2023-07-10 07:21:23+02:00 | -5 |
6436695 | 6436695 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 07:17:55.000000 | 12 | 17 | 2023-07-10 07:17:55+02:00 | 5 |
6436694 | 6436694 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 07:04:34.000000 | 20 | 19 | 2023-07-10 07:04:34+02:00 | -1 |
6436693 | 6436693 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 06:57:29.000000 | 19 | 19 | 2023-07-10 06:57:29+02:00 | 0 |
6436692 | 6436692 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 06:38:47.000000 | 10 | 13 | 2023-07-10 06:38:47+02:00 | 3 |
6436691 | 6436691 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 05:21:34.000000 | 32 | 24 | 2023-07-10 05:21:34+02:00 | -8 |
6436690 | 6436690 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 05:19:27.000000 | 30 | 34 | 2023-07-10 05:19:27+02:00 | 4 |
6436689 | 6436689 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 03:23:02.000000 | 13 | 10 | 2023-07-10 03:23:02+02:00 | -3 |
6436688 | 6436688 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 00:54:05.000000 | 19 | 26 | 2023-07-10 00:54:05+02:00 | 7 |
6436687 | 6436687 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 00:14:59.000000 | 23 | 27 | 2023-07-10 00:14:59+02:00 | 4 |
6436820 | 6436820 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 23:25:58.000000 | 12 | 10 | 2023-07-09 23:25:58+02:00 | -2 |
6436819 | 6436819 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 22:07:50.000000 | 31 | 25 | 2023-07-09 22:07:50+02:00 | -6 |
6436818 | 6436818 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 20:49:58.000000 | 20 | 22 | 2023-07-09 20:49:58+02:00 | 2 |
6436817 | 6436817 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 20:36:43.000000 | 27 | 27 | 2023-07-09 20:36:43+02:00 | 0 |
6436816 | 6436816 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 19:59:15.000000 | 32 | 16 | 2023-07-09 19:59:15+02:00 | -16 |
6436815 | 6436815 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 19:50:53.000000 | 18 | 16 | 2023-07-09 19:50:53+02:00 | -2 |
6436814 | 6436814 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 19:40:40.000000 | 35 | 23 | 2023-07-09 19:40:40+02:00 | -12 |
6436813 | 6436813 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 19:27:51.000000 | 26 | 20 | 2023-07-09 19:27:51+02:00 | -6 |
6436812 | 6436812 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 19:22:05.000000 | 20 | 18 | 2023-07-09 19:22:05+02:00 | -2 |
6436811 | 6436811 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 19:16:09.000000 | 15 | 20 | 2023-07-09 19:16:09+02:00 | 5 |
6436810 | 6436810 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 19:13:22.000000 | 15 | 19 | 2023-07-09 19:13:22+02:00 | 4 |
6436809 | 6436809 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 19:05:43.000000 | 25 | 29 | 2023-07-09 19:05:43+02:00 | 4 |
6436808 | 6436808 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 19:02:40.000000 | 17 | 31 | 2023-07-09 19:02:40+02:00 | 14 |
6436807 | 6436807 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 18:33:07.000000 | 23 | 35 | 2023-07-09 18:33:07+02:00 | 12 |
6436806 | 6436806 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 17:41:13.000000 | 27 | 29 | 2023-07-09 17:41:13+02:00 | 2 |
6436805 | 6436805 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 17:19:17.000000 | 26 | 32 | 2023-07-09 17:19:17+02:00 | 6 |
6436804 | 6436804 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 17:19:05.000000 | 23 | 25 | 2023-07-09 17:19:05+02:00 | 2 |
6436803 | 6436803 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 16:48:28.000000 | 30 | 23 | 2023-07-09 16:48:28+02:00 | -7 |
6436802 | 6436802 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 16:32:54.000000 | 27 | 26 | 2023-07-09 16:32:54+02:00 | -1 |
6436801 | 6436801 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 16:31:35.000000 | 18 | 12 | 2023-07-09 16:31:35+02:00 | -6 |
6436800 | 6436800 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 16:30:21.000000 | 15 | 12 | 2023-07-09 16:30:21+02:00 | -3 |
6436799 | 6436799 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 16:24:57.000000 | 19 | 22 | 2023-07-09 16:24:57+02:00 | 3 |
6436798 | 6436798 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 15:50:29.000000 | 15 | 9 | 2023-07-09 15:50:29+02:00 | -6 |
6436797 | 6436797 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 15:05:47.000000 | 23 | 19 | 2023-07-09 15:05:47+02:00 | -4 |
6436796 | 6436796 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 13:48:41.000000 | 12 | 15 | 2023-07-09 13:48:41+02:00 | 3 |
6436795 | 6436795 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 12:43:41.000000 | 12 | 14 | 2023-07-09 12:43:41+02:00 | 2 |
6436794 | 6436794 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 12:37:58.000000 | 27 | 24 | 2023-07-09 12:37:58+02:00 | -3 |
6436793 | 6436793 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 11:23:19.000000 | 15 | 24 | 2023-07-09 11:23:19+02:00 | 9 |
6436792 | 6436792 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 11:03:46.000000 | 17 | 20 | 2023-07-09 11:03:46+02:00 | 3 |
6436791 | 6436791 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 11:01:03.000000 | 32 | 25 | 2023-07-09 11:01:03+02:00 | -7 |
6436790 | 6436790 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 10:27:18.000000 | 23 | 31 | 2023-07-09 10:27:18+02:00 | 8 |
6436789 | 6436789 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 10:05:18.000000 | 17 | 11 | 2023-07-09 10:05:18+02:00 | -6 |
6436788 | 6436788 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 09:29:25.000000 | 28 | 33 | 2023-07-09 09:29:25+02:00 | 5 |
6436787 | 6436787 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 09:18:18.000000 | 12 | 4 | 2023-07-09 09:18:18+02:00 | -8 |
6436786 | 6436786 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 09:02:15.000000 | 14 | 12 | 2023-07-09 09:02:15+02:00 | -2 |
6436785 | 6436785 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 08:53:04.000000 | 16 | 20 | 2023-07-09 08:53:04+02:00 | 4 |
6436784 | 6436784 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 08:43:37.000000 | 20 | 25 | 2023-07-09 08:43:37+02:00 | 5 |
6436783 | 6436783 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 08:41:46.000000 | 14 | 12 | 2023-07-09 08:41:46+02:00 | -2 |
6436782 | 6436782 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 07:38:39.000000 | 14 | 12 | 2023-07-09 07:38:39+02:00 | -2 |
6436781 | 6436781 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 06:11:25.000000 | 26 | 17 | 2023-07-09 06:11:25+02:00 | -9 |
6436780 | 6436780 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 05:52:10.000000 | 16 | 13 | 2023-07-09 05:52:10+02:00 | -3 |
6436779 | 6436779 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 04:18:05.000000 | 20 | 20 | 2023-07-09 04:18:05+02:00 | 0 |
6436778 | 6436778 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 03:38:21.000000 | 17 | 18 | 2023-07-09 03:38:21+02:00 | 1 |
6436777 | 6436777 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 02:43:32.000000 | 19 | 13 | 2023-07-09 02:43:32+02:00 | -6 |
6436776 | 6436776 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 02:29:28.000000 | 20 | 13 | 2023-07-09 02:29:28+02:00 | -7 |
6436775 | 6436775 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 02:17:28.000000 | 25 | 22 | 2023-07-09 02:17:28+02:00 | -3 |
6436774 | 6436774 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 01:25:39.000000 | 7 | 8 | 2023-07-09 01:25:39+02:00 | 1 |
6436773 | 6436773 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 00:45:47.000000 | 12 | 17 | 2023-07-09 00:45:47+02:00 | 5 |
6436772 | 6436772 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 00:37:03.000000 | 20 | 15 | 2023-07-09 00:37:03+02:00 | -5 |
6436771 | 6436771 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 00:24:32.000000 | 20 | 18 | 2023-07-09 00:24:32+02:00 | -2 |
6432963 | 6432963 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 23:46:04.000000 | 3 | 3 | 2023-07-08 23:46:04+02:00 | 0 |
6432962 | 6432962 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 22:59:13.000000 | 19 | 16 | 2023-07-08 22:59:13+02:00 | -3 |
6432961 | 6432961 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 22:47:58.000000 | 26 | 24 | 2023-07-08 22:47:58+02:00 | -2 |
6432960 | 6432960 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 22:17:45.000000 | 27 | 26 | 2023-07-08 22:17:45+02:00 | -1 |
6432959 | 6432959 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 21:20:22.000000 | 13 | 12 | 2023-07-08 21:20:22+02:00 | -1 |
6432958 | 6432958 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 21:17:57.000000 | 7 | 3 | 2023-07-08 21:17:57+02:00 | -4 |
6432957 | 6432957 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 20:46:48.000000 | 23 | 28 | 2023-07-08 20:46:48+02:00 | 5 |
6432956 | 6432956 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 20:24:16.000000 | 13 | 20 | 2023-07-08 20:24:16+02:00 | 7 |
6432955 | 6432955 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 20:06:39.000000 | 14 | 15 | 2023-07-08 20:06:39+02:00 | 1 |
6432954 | 6432954 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 19:48:48.000000 | 23 | 19 | 2023-07-08 19:48:48+02:00 | -4 |
6432953 | 6432953 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 19:17:15.000000 | 14 | 12 | 2023-07-08 19:17:15+02:00 | -2 |
6432952 | 6432952 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 18:40:44.000000 | 19 | 20 | 2023-07-08 18:40:44+02:00 | 1 |
6432951 | 6432951 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 18:33:16.000000 | 7 | 4 | 2023-07-08 18:33:16+02:00 | -3 |
6432950 | 6432950 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 18:27:30.000000 | 11 | 13 | 2023-07-08 18:27:30+02:00 | 2 |
6432949 | 6432949 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 18:15:01.000000 | 16 | 23 | 2023-07-08 18:15:01+02:00 | 7 |
6432948 | 6432948 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 18:11:36.000000 | 23 | 28 | 2023-07-08 18:11:36+02:00 | 5 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE Einzelmessungen ( ID TEXT, id_standort INTEGER, Zyklus INTEGER, Phase TEXT, Messung_Datum TEXT, Messung_Zeit TEXT, V_Einfahrt INTEGER, V_Ausfahrt INTEGER, Messung_Timestamp TEXT, V_Delta INTEGER, FOREIGN KEY (ID) REFERENCES Einsatzplan (ID) ON DELETE CASCADE ); CREATE INDEX idx_Einzelmessungen_id ON "Einzelmessungen" ("ID"); CREATE INDEX idx_Einzelmessungen_id_standort ON "Einzelmessungen" ("id_standort"); CREATE INDEX idx_Einzelmessungen_zyklus ON "Einzelmessungen" ("Zyklus"); CREATE INDEX idx_Einzelmessungen_phase ON "Einzelmessungen" ("Phase"); CREATE INDEX idx_Einzelmessungen_messung_datum ON "Einzelmessungen" ("Messung_Datum"); CREATE INDEX idx_Einzelmessungen_messung_timestamp ON "Einzelmessungen" ("Messung_Timestamp");