Dreispitz-Ahorn (Acer buergerianum)
Pilotbaum 1 (Europaplatz)
Dreispitz-Ahorn mit kompakter, harmonischer Krone und auffälliger scharlachroter bis tiefroter Herbstfärbung.
Steckbrief
Species: Acer buergerianum
- Blatt: Sommergrün, gegenständig, 3-lappig, dunkelgrün, bis ca. 8 cm breit. Herbstfärbung scharlachrot bis tiefrot, sehr dekorativ.
- Wuchs: Anfangs schmal-aufrecht, später breit ausladend. Wird etwa 10–15 m hoch, mit kompakter, harmonischer Krone.
- Herkunft: Japan, Taiwan, östliches China.
- Standort & Boden: Bevorzugt gut durchlässige, schwach saure Böden. Absonnige bis halbschattige Lagen ideal; auch sonnig möglich, wenn der Boden nicht zu trocken wird.
- Blüte & Frucht: Kleine gelbliche Blüten im Mai. Fruchtflügel färben sich rötlich.
- Stadtklima: Frosthart, gesund, stadtklimafest. Gut geeignet für Straßenräume, Parks und kleinere Gärten dank kompakter Wuchsform.
Europaplatz
Sensoren vom Baum tree-001 (letzte 24 Stunden)
Sensecap Bodenfeuchte
Dragino Bodenfeuchte
Dragino Blattfeuchte
Sensecap (CO2)
Data from Timescale (view_data_last, letzte 30 Min) – alle Devices
SELECT * FROM view_data_last ORDER BY tree_id ASC;
| time_at | tree_id | app_id | count | leaf_moisture | leaf_temperature | leaf_temp | soil_moisture | soil_moisture_1 | soil_moisture_2 | soil_temperature | soil_temperature_1 | soil_temperature_2 | soil_conductivity | co2 | air_temperature | humidity |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10.03.2026 06:12 Uhr | tree-001 | smarttrees | 7 | 0.00 | 13.90 | 327.60 | 0.00 | 14.70 | 0.00 | 651.00 | 15.09 | 48.99 | ||||
| 10.03.2026 06:09 Uhr | tree-002 | smarttrees | 7 | 1.10 | 20.70 | 327.60 | 0.00 | 20.50 | 0.00 | 65403.00 | 20.47 | 37.51 |
Daten vom Baum tree-001 (letzte 24 Stunden)
SELECT * FROM trees.fn_sensor_data(p_from => (now() - interval '24 hours'), p_tree => $1) ORDER BY time_at DESC LIMIT 50;
| time_at | tree_id | count | leaf_moisture | leaf_temperature | leaf_temp | soil_moisture_1 | soil_temperature_1 | soil_conductivity_1 | soil_moisture_2 | soil_temperature_2 | soil_conductivity_2 | co2 | humid_temperature | humidity |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10.03.2026 06:00 Uhr | tree-001 | 5 | 0.00 | 13.90 | 327.60 | 0.00 | 14.65 | 0.00 | 0.00 | 14.63 | 0.00 | 651.00 | 15.27 | 51.98 |
| 10.03.2026 05:30 Uhr | tree-001 | 9 | 0.00 | 13.70 | 327.60 | 0.00 | 14.33 | 0.00 | 0.00 | 14.29 | 0.00 | 652.33 | 15.09 | 52.43 |
| 10.03.2026 05:00 Uhr | tree-001 | 10 | 0.00 | 13.30 | 327.60 | 0.00 | 13.67 | 0.00 | 0.00 | 13.73 | 0.00 | 654.00 | 14.66 | 53.50 |
| 10.03.2026 04:30 Uhr | tree-001 | 7 | 0.00 | 13.27 | 0.00 | 0.00 | 13.50 | 0.00 | 655.50 | 14.55 | 53.96 | |||
| 10.03.2026 04:00 Uhr | tree-001 | 8 | 0.00 | 13.40 | 327.60 | 0.00 | 13.40 | 0.00 | 0.00 | 13.52 | 0.00 | 655.67 | 14.62 | 53.91 |
| 10.03.2026 03:30 Uhr | tree-001 | 10 | 0.00 | 13.50 | 327.60 | 0.00 | 13.53 | 0.00 | 0.00 | 13.68 | 0.00 | 657.00 | 14.74 | 53.94 |
| 10.03.2026 03:00 Uhr | tree-001 | 9 | 0.00 | 13.65 | 327.60 | 0.00 | 13.67 | 0.00 | 0.00 | 13.83 | 0.00 | 656.33 | 14.82 | 53.87 |
| 10.03.2026 02:30 Uhr | tree-001 | 11 | 0.00 | 13.90 | 327.60 | 0.00 | 13.83 | 0.00 | 0.00 | 13.98 | 0.00 | 659.25 | 14.95 | 53.82 |
| 10.03.2026 02:00 Uhr | tree-001 | 7 | 0.00 | 14.00 | 327.60 | 0.00 | 13.97 | 0.00 | 0.00 | 14.14 | 0.00 | 660.00 | 15.09 | 53.55 |
| 10.03.2026 01:30 Uhr | tree-001 | 7 | 0.00 | 14.30 | 327.60 | 0.00 | 14.20 | 0.00 | 661.00 | 15.28 | 53.21 | |||
| 10.03.2026 01:00 Uhr | tree-001 | 9 | 0.00 | 14.55 | 327.60 | 0.00 | 14.47 | 0.00 | 0.00 | 14.66 | 0.00 | 659.33 | 15.51 | 52.69 |
| 10.03.2026 00:30 Uhr | tree-001 | 9 | 0.00 | 14.80 | 327.60 | 0.00 | 14.80 | 0.00 | 0.00 | 15.00 | 0.00 | 666.67 | 15.81 | 52.12 |
| 10.03.2026 00:00 Uhr | tree-001 | 9 | 0.00 | 15.10 | 327.60 | 0.00 | 15.10 | 0.00 | 0.00 | 15.26 | 0.00 | 666.33 | 16.10 | 51.63 |
| 09.03.2026 23:30 Uhr | tree-001 | 9 | 0.00 | 15.30 | 327.60 | 0.00 | 15.40 | 0.00 | 0.00 | 15.57 | 0.00 | 667.67 | 16.35 | 51.25 |
| 09.03.2026 23:00 Uhr | tree-001 | 9 | 0.00 | 15.60 | 327.60 | 0.00 | 15.70 | 0.00 | 669.00 | 16.65 | 50.81 | |||
| 09.03.2026 22:30 Uhr | tree-001 | 7 | 0.00 | 16.00 | 327.60 | 0.00 | 16.00 | 0.00 | 0.00 | 16.36 | 0.00 | 667.50 | 16.93 | 50.42 |
| 09.03.2026 22:00 Uhr | tree-001 | 9 | 0.00 | 16.30 | 327.60 | 0.00 | 16.37 | 0.00 | 0.00 | 16.59 | 0.00 | 669.00 | 17.18 | 50.11 |
| 09.03.2026 21:30 Uhr | tree-001 | 9 | 0.00 | 16.70 | 327.60 | 0.00 | 16.73 | 0.00 | 0.00 | 17.00 | 0.00 | 665.67 | 17.45 | 49.74 |
| 09.03.2026 21:00 Uhr | tree-001 | 9 | 0.00 | 17.05 | 327.60 | 0.00 | 17.13 | 0.00 | 0.00 | 17.30 | 0.00 | 666.33 | 17.78 | 49.35 |
| 09.03.2026 20:30 Uhr | tree-001 | 8 | 0.00 | 17.50 | 327.60 | 0.00 | 17.53 | 0.00 | 0.00 | 17.51 | 0.00 | 667.33 | 18.11 | 48.95 |
| 09.03.2026 20:00 Uhr | tree-001 | 7 | 0.00 | 18.00 | 327.60 | 0.00 | 17.97 | 0.00 | 663.67 | 18.44 | 48.69 | |||
| 09.03.2026 19:30 Uhr | tree-001 | 9 | 0.00 | 18.30 | 327.60 | 0.00 | 18.40 | 0.00 | 0.00 | 18.58 | 0.00 | 667.67 | 18.79 | 48.35 |
| 09.03.2026 19:00 Uhr | tree-001 | 9 | 0.00 | 18.85 | 327.60 | 0.00 | 18.90 | 0.00 | 0.00 | 19.03 | 0.00 | 662.67 | 19.19 | 47.88 |
| 09.03.2026 18:30 Uhr | tree-001 | 10 | 0.00 | 19.40 | 327.60 | 0.00 | 19.43 | 0.00 | 0.00 | 19.60 | 0.00 | 667.50 | 19.78 | 47.16 |
| 09.03.2026 18:00 Uhr | tree-001 | 9 | 0.00 | 20.00 | 327.60 | 0.00 | 20.13 | 0.00 | 0.00 | 20.26 | 0.00 | 667.67 | 20.28 | 46.53 |
| 09.03.2026 17:30 Uhr | tree-001 | 8 | 0.00 | 20.60 | 327.60 | 0.00 | 20.87 | 0.00 | 0.00 | 21.32 | 0.00 | 669.67 | 20.96 | 45.48 |
| 09.03.2026 17:00 Uhr | tree-001 | 9 | 0.00 | 21.15 | 327.60 | 0.00 | 21.63 | 0.00 | 0.00 | 22.00 | 0.00 | 668.67 | 21.75 | 44.04 |
| 09.03.2026 16:30 Uhr | tree-001 | 9 | 0.00 | 21.40 | 327.60 | 0.00 | 22.20 | 0.00 | 0.00 | 22.45 | 0.00 | 674.33 | 22.45 | 41.87 |
| 09.03.2026 16:00 Uhr | tree-001 | 8 | 0.00 | 20.60 | 327.60 | 0.00 | 21.57 | 0.00 | 0.00 | 21.93 | 0.00 | 631.67 | 22.12 | 37.56 |
| 09.03.2026 15:30 Uhr | tree-001 | 8 | 0.00 | 21.33 | 0.00 | 0.00 | 21.42 | 0.00 | 601.67 | 21.73 | 36.88 | |||
| 09.03.2026 15:00 Uhr | tree-001 | 9 | 0.00 | 20.85 | 327.60 | 0.00 | 21.57 | 0.00 | 0.00 | 21.57 | 0.00 | 604.33 | 21.84 | 36.35 |
| 09.03.2026 14:30 Uhr | tree-001 | 8 | 0.00 | 20.90 | 327.60 | 0.00 | 21.50 | 0.00 | 0.00 | 21.89 | 0.00 | 613.00 | 21.90 | 36.65 |
| 09.03.2026 14:00 Uhr | tree-001 | 9 | 0.00 | 21.00 | 327.60 | 0.00 | 21.87 | 0.00 | 0.00 | 22.91 | 0.00 | 786.00 | 22.29 | 40.12 |
| 09.03.2026 13:30 Uhr | tree-001 | 7 | 0.00 | 21.53 | 0.00 | 0.00 | 22.10 | 0.00 | 892.67 | 22.18 | 42.35 | |||
| 09.03.2026 13:00 Uhr | tree-001 | 9 | 0.00 | 20.05 | 327.60 | 0.00 | 20.90 | 0.00 | 0.00 | 21.68 | 0.00 | 820.67 | 21.66 | 42.00 |
| 09.03.2026 12:30 Uhr | tree-001 | 7 | 0.00 | 20.57 | 0.00 | 0.00 | 21.28 | 0.00 | 776.33 | 21.23 | 41.95 | |||
| 09.03.2026 12:00 Uhr | tree-001 | 9 | 0.00 | 19.10 | 327.60 | 0.00 | 20.37 | 0.00 | 0.00 | 20.97 | 0.00 | 763.33 | 20.97 | 41.90 |
| 09.03.2026 11:30 Uhr | tree-001 | 9 | 0.00 | 18.50 | 327.60 | 0.00 | 19.80 | 0.00 | 0.00 | 20.31 | 0.00 | 752.00 | 20.68 | 42.08 |
| 09.03.2026 11:00 Uhr | tree-001 | 9 | 0.00 | 17.95 | 327.60 | 0.00 | 19.30 | 0.00 | 0.00 | 19.85 | 0.00 | 729.33 | 20.10 | 42.65 |
| 09.03.2026 10:30 Uhr | tree-001 | 9 | 0.00 | 17.50 | 327.60 | 0.00 | 19.03 | 0.00 | 0.00 | 19.39 | 0.00 | 711.67 | 19.70 | 42.96 |
| 09.03.2026 10:00 Uhr | tree-001 | 7 | 0.00 | 17.93 | 0.00 | 0.00 | 18.59 | 0.00 | 704.67 | 18.96 | 44.33 | |||
| 09.03.2026 09:30 Uhr | tree-001 | 7 | 0.00 | 17.27 | 0.00 | 0.00 | 17.91 | 0.00 | 695.00 | 17.92 | 45.75 | |||
| 09.03.2026 09:00 Uhr | tree-001 | 9 | 0.00 | 16.40 | 327.60 | 0.00 | 16.73 | 0.00 | 0.00 | 17.71 | 0.00 | 655.67 | 17.36 | 46.43 |
| 09.03.2026 08:30 Uhr | tree-001 | 7 | 0.00 | 15.87 | 0.00 | 0.00 | 15.47 | 0.00 | 626.00 | 16.69 | 47.57 | |||
| 09.03.2026 08:00 Uhr | tree-001 | 7 | 0.00 | 14.10 | 327.60 | 0.00 | 14.97 | 0.00 | 616.00 | 15.93 | 48.82 | |||
| 09.03.2026 07:30 Uhr | tree-001 | 9 | 0.00 | 14.00 | 327.60 | 0.00 | 14.83 | 0.00 | 0.00 | 14.87 | 0.00 | 601.67 | 15.64 | 49.51 |
| 09.03.2026 07:00 Uhr | tree-001 | 7 | 0.00 | 13.60 | 327.60 | 0.00 | 14.57 | 0.00 | 582.67 | 15.38 | 50.00 | |||
| 09.03.2026 06:30 Uhr | tree-001 | 9 | 0.00 | 13.50 | 327.60 | 0.00 | 14.33 | 0.00 | 0.00 | 14.34 | 0.00 | 565.00 | 15.11 | 50.45 |
| 09.03.2026 06:00 Uhr | tree-001 | 4 | 0.00 | 13.30 | 327.60 | 0.00 | 14.20 | 0.00 | 567.50 | 14.81 | 51.18 |