{ "cells": [ { "cell_type": "markdown", "metadata": { "id": "view-in-github", "colab_type": "text" }, "source": [ "\"Open" ] }, { "cell_type": "markdown", "metadata": { "id": "Vg3eLyR1TSnW" }, "source": [ "
\"Logo
\n", "# Getting started with Spark: Spark SQL in Python" ] }, { "cell_type": "markdown", "metadata": { "id": "NhuWJnjPTSnX" }, "source": [ "This tutorial is based on [Spark SQL Guide - Getting started](https://spark.apache.org/docs/latest/sql-getting-started.html). All Spark jobs run on the local Spark engine included in the PySpark packaging (see [PySpark project](https://pypi.org/project/pyspark/) for details).\n", "\n", "For this demo we used the city of Vienna trees dataset (\"Baumkataster\") made available by [Open Data Österreich](https://www.data.gv.at) and downloadable from [here](https://www.data.gv.at/katalog/dataset/c91a4635-8b7d-43fe-9b27-d95dec8392a7).\n", "\n", "# Table of contents\n", "1. [Spark session](#sparkSession)\n", "2. [Count the number of rows with `count()`](#count)\n", "3. [Pretty-printing](#prettyprint)\n", "4. [`groupBy`](#groupby)\n", "5. [Running SQL Queries Programmatically](#SQLquery)\n", " - [Data cleaning](#cleaning)\n", "6. [Some data exploration](#exploration)\n", "7. [Close Spark session](#closing)" ] }, { "cell_type": "markdown", "metadata": { "id": "1d8lWgXjTSnY" }, "source": [ "## Spark session \n", "\n", "We're going to start by creating a [Spark _session_](https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/spark_session.html). Our Spark job will be named \"Python Spark SQL basic example\". `spark` is the variable holding our Spark session." ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "id": "_ZrOl3otTSnY" }, "outputs": [], "source": [ "from pyspark.sql import SparkSession\n", "spark = SparkSession \\\n", " .builder \\\n", " .appName(\"Python Spark SQL basic example\") \\\n", " .getOrCreate()" ] }, { "cell_type": "markdown", "metadata": { "id": "xAa3BSJITSnZ" }, "source": [ "Read the file into a Spark [_dataframe_](https://spark.apache.org/docs/latest/sql-programming-guide.html#datasets-and-dataframes)." ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "id": "cR11bC03TSnZ", "colab": { "base_uri": "https://localhost:8080/" }, "outputId": "1deb73c7-1718-451c-87c8-6d34d500eca5" }, "outputs": [ { "output_type": "stream", "name": "stdout", "text": [ "Downloading baumkataster.csv...\n" ] } ], "source": [ "import pandas as pd\n", "import requests\n", "import os\n", "from pyspark.sql.types import StructType, StructField, StringType, DoubleType, IntegerType\n", "\n", "url = \"https://data.wien.gv.at/daten/geo?service=WFS&request=GetFeature&version=1.1.0&typeName=ogdwien:BAUMKATOGD&srsName=EPSG:4326&outputFormat=csv\"\n", "file_path = \"baumkataster.csv\"\n", "\n", "# Download the file using requests and save it locally if it doesn't exist\n", "if not os.path.exists(file_path):\n", " print(f\"Downloading {file_path}...\")\n", " response = requests.get(url)\n", " with open(file_path, \"wb\") as f:\n", " f.write(response.content)\n", "else:\n", " print(f\"{file_path} already exists, skipping download.\")\n" ] }, { "cell_type": "markdown", "source": [ "Look at the first few lines in the `.csv` file to figure out its format (separator and if it has column headers). Hopefully Spark will guess the correct encoding." ], "metadata": { "id": "b74vs1odbwLI" } }, { "cell_type": "code", "source": [ "!head baumkataster.csv" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "6fNz_ZJ0bwWF", "outputId": "c1b2f601-d117-4b17-cd63-265a1faef6af" }, "execution_count": 3, "outputs": [ { "output_type": "stream", "name": "stdout", "text": [ "FID,OBJECTID,SHAPE,BAUM_ID,DATENFUEHRUNG,BEZIRK,OBJEKT_STRASSE,GEBIETSGRUPPE,GATTUNG_ART,PFLANZJAHR,PFLANZJAHR_TXT,STAMMUMFANG,STAMMUMFANG_TXT,BAUMHOEHE,BAUMHOEHE_TXT,KRONENDURCHMESSER,KRONENDURCHMESSER_TXT,BAUMNUMMER,SE_ANNO_CAD_DATA\r\n", "BAUMKATOGD.742832161,742832161,POINT (16.37305290330624 48.25396526394613),128890,magistrat,20,Knoten Nordbrücke,Hauptstraße B14,Prunus mahaleb (Steinweichsel),0,nicht definiert,148,148 cm,2,6-10 m,3,7-9 m,2560,\r\n", "BAUMKATOGD.742832162,742832162,POINT (16.27350822664159 48.14422147386553),401554,magistrat,23,Schwarzwaldgasse,\"MA 28 - Straße, Grünanlage\",Jungbaum wird gepflanzt,0,nicht definiert,0,nicht bekannt,0,nicht bekannt,0,nicht bekannt,2016,\r\n", "BAUMKATOGD.742832163,742832163,POINT (16.398122022316993 48.20013311276198),130667,magistrat,3,Apostelgasse,\"MA 28 - Straße, Grünanlage\",Tilia tomentosa (Silberlinde),1927,1927,230,230 cm,4,16-20 m,5,13-15 m,1007,\r\n", "BAUMKATOGD.742832164,742832164,POINT (16.37306490734576 48.25399152008363),128891,magistrat,20,Knoten Nordbrücke,Hauptstraße B14,Prunus mahaleb (Steinweichsel),0,nicht definiert,91,91 cm,2,6-10 m,3,7-9 m,2561,\r\n", "BAUMKATOGD.742832165,742832165,POINT (16.397960567598144 48.200110806556005),130669,magistrat,3,Apostelgasse,\"MA 28 - Straße, Grünanlage\",Acer platanoides 'Globosum' (Kugelspitzahorn),1996,1996,60,60 cm,1,0-5 m,2,4-6 m,1009,\r\n", "BAUMKATOGD.742832166,742832166,POINT (16.37304432757755 48.254024711408654),128892,magistrat,20,Knoten Nordbrücke,Hauptstraße B14,Prunus mahaleb (Steinweichsel),0,nicht definiert,188,188 cm,2,6-10 m,3,7-9 m,2562,\r\n", "BAUMKATOGD.742832167,742832167,POINT (16.373025591936745 48.2540007057163),128893,magistrat,20,Knoten Nordbrücke,Hauptstraße B14,Prunus mahaleb (Steinweichsel),0,nicht definiert,97,97 cm,2,6-10 m,3,7-9 m,2563,\r\n", "BAUMKATOGD.742832168,742832168,POINT (16.50515266676725 48.226967273711146),343856,magistrat,22,\"22., Seepark, MA42\",MA 42 - Parkanlage,Carpinus betulus (Hainbuche),2019,2019,20,20 cm,1,0-5 m,1,0-3 m,35/A,\r\n", "BAUMKATOGD.742832169,742832169,POINT (16.37298786450012 48.25397095049507),128895,magistrat,20,Knoten Nordbrücke,Hauptstraße B14,Prunus mahaleb (Steinweichsel),0,nicht definiert,160,160 cm,2,6-10 m,3,7-9 m,2565,\r\n" ] } ] }, { "cell_type": "code", "source": [ "# Load the local file into a Spark DataFrame\n", "df = spark.read \\\n", " .load(\"baumkataster.csv\",\n", " format=\"csv\", sep=\",\", header=\"true\")" ], "metadata": { "id": "CpzySN3nbmtM" }, "execution_count": 4, "outputs": [] }, { "cell_type": "code", "execution_count": 5, "metadata": { "id": "52766AE5TSna", "outputId": "f70ff96c-b77b-488f-f695-45b2d6ed43b3", "colab": { "base_uri": "https://localhost:8080/" } }, "outputs": [ { "output_type": "stream", "name": "stdout", "text": [ "+--------------------+---------+--------------------+-------+-------------+------+-------------------+--------------------+--------------------+----------+---------------+-----------+---------------+---------+-------------+-----------------+---------------------+----------+----------------+\n", "| FID| OBJECTID| SHAPE|BAUM_ID|DATENFUEHRUNG|BEZIRK| OBJEKT_STRASSE| GEBIETSGRUPPE| GATTUNG_ART|PFLANZJAHR| PFLANZJAHR_TXT|STAMMUMFANG|STAMMUMFANG_TXT|BAUMHOEHE|BAUMHOEHE_TXT|KRONENDURCHMESSER|KRONENDURCHMESSER_TXT|BAUMNUMMER|SE_ANNO_CAD_DATA|\n", "+--------------------+---------+--------------------+-------+-------------+------+-------------------+--------------------+--------------------+----------+---------------+-----------+---------------+---------+-------------+-----------------+---------------------+----------+----------------+\n", "|BAUMKATOGD.742832161|742832161|POINT (16.3730529...| 128890| magistrat| 20| Knoten Nordbrücke| Hauptstraße B14|Prunus mahaleb (S...| 0|nicht definiert| 148| 148 cm| 2| 6-10 m| 3| 7-9 m| 2560| NULL|\n", "|BAUMKATOGD.742832162|742832162|POINT (16.2735082...| 401554| magistrat| 23| Schwarzwaldgasse|MA 28 - Straße, G...|Jungbaum wird gep...| 0|nicht definiert| 0| nicht bekannt| 0|nicht bekannt| 0| nicht bekannt| 2016| NULL|\n", "|BAUMKATOGD.742832163|742832163|POINT (16.3981220...| 130667| magistrat| 3| Apostelgasse|MA 28 - Straße, G...|Tilia tomentosa (...| 1927| 1927| 230| 230 cm| 4| 16-20 m| 5| 13-15 m| 1007| NULL|\n", "|BAUMKATOGD.742832164|742832164|POINT (16.3730649...| 128891| magistrat| 20| Knoten Nordbrücke| Hauptstraße B14|Prunus mahaleb (S...| 0|nicht definiert| 91| 91 cm| 2| 6-10 m| 3| 7-9 m| 2561| NULL|\n", "|BAUMKATOGD.742832165|742832165|POINT (16.3979605...| 130669| magistrat| 3| Apostelgasse|MA 28 - Straße, G...|Acer platanoides ...| 1996| 1996| 60| 60 cm| 1| 0-5 m| 2| 4-6 m| 1009| NULL|\n", "|BAUMKATOGD.742832166|742832166|POINT (16.3730443...| 128892| magistrat| 20| Knoten Nordbrücke| Hauptstraße B14|Prunus mahaleb (S...| 0|nicht definiert| 188| 188 cm| 2| 6-10 m| 3| 7-9 m| 2562| NULL|\n", "|BAUMKATOGD.742832167|742832167|POINT (16.3730255...| 128893| magistrat| 20| Knoten Nordbrücke| Hauptstraße B14|Prunus mahaleb (S...| 0|nicht definiert| 97| 97 cm| 2| 6-10 m| 3| 7-9 m| 2563| NULL|\n", "|BAUMKATOGD.742832168|742832168|POINT (16.5051526...| 343856| magistrat| 22| 22., Seepark, MA42| MA 42 - Parkanlage|Carpinus betulus ...| 2019| 2019| 20| 20 cm| 1| 0-5 m| 1| 0-3 m| 35/A| NULL|\n", "|BAUMKATOGD.742832169|742832169|POINT (16.3729878...| 128895| magistrat| 20| Knoten Nordbrücke| Hauptstraße B14|Prunus mahaleb (S...| 0|nicht definiert| 160| 160 cm| 2| 6-10 m| 3| 7-9 m| 2565| NULL|\n", "|BAUMKATOGD.742832170|742832170|POINT (16.4076829...| 29209| magistrat| 2|Rustenschacherallee|MA 28 - Straße, G...|Platanus x acerif...| 1867| 1867| 437| 437 cm| 5| 21-25 m| 6| 16-18 m| 3122| NULL|\n", "+--------------------+---------+--------------------+-------+-------------+------+-------------------+--------------------+--------------------+----------+---------------+-----------+---------------+---------+-------------+-----------------+---------------------+----------+----------------+\n", "only showing top 10 rows\n", "\n" ] } ], "source": [ "df.show(10)" ] }, { "cell_type": "markdown", "source": [ "## Count the number of rows with `count()`\n", "\n", "Using [pyspark.sql.DataFrame.count](https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/api/pyspark.sql.DataFrame.count.html)" ], "metadata": { "id": "dAcCRnNosTVp" } }, { "cell_type": "code", "source": [ "df.count()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "2qSe93LpbmzY", "outputId": "969b4130-cb29-414d-c152-21c959f2eda9" }, "execution_count": 6, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "229231" ] }, "metadata": {}, "execution_count": 6 } ] }, { "cell_type": "markdown", "source": [ "The size of the datafile 1s $50$MB." ], "metadata": { "id": "AcdGCXud4IW5" } }, { "cell_type": "code", "source": [ "!ls -lh baumkataster.csv" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "bZ_W5IPAYfJL", "outputId": "50f78951-e3bb-43f8-c87b-3674a23ddd03" }, "execution_count": 7, "outputs": [ { "output_type": "stream", "name": "stdout", "text": [ "-rw-r--r-- 1 root root 50M Oct 11 10:44 baumkataster.csv\n" ] } ] }, { "cell_type": "markdown", "source": [ "## Pretty-printing " ], "metadata": { "id": "hVYH-LrrzNEZ" } }, { "cell_type": "markdown", "metadata": { "id": "PUjwmqkZTSna" }, "source": [ "For pretty-printing you can use `toPandas()`" ] }, { "cell_type": "code", "execution_count": 8, "metadata": { "id": "XyW-43WWTSna" }, "outputs": [], "source": [ "pdf = df.toPandas()" ] }, { "cell_type": "code", "source": [ "pdf.head()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 399 }, "id": "jAYJvU1gdayp", "outputId": "7e23c6f3-9adf-48b3-e642-c514577e3684" }, "execution_count": 9, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " FID OBJECTID \\\n", "0 BAUMKATOGD.742832161 742832161 \n", "1 BAUMKATOGD.742832162 742832162 \n", "2 BAUMKATOGD.742832163 742832163 \n", "3 BAUMKATOGD.742832164 742832164 \n", "4 BAUMKATOGD.742832165 742832165 \n", "\n", " SHAPE BAUM_ID DATENFUEHRUNG BEZIRK \\\n", "0 POINT (16.37305290330624 48.25396526394613) 128890 magistrat 20 \n", "1 POINT (16.27350822664159 48.14422147386553) 401554 magistrat 23 \n", "2 POINT (16.398122022316993 48.20013311276198) 130667 magistrat 3 \n", "3 POINT (16.37306490734576 48.25399152008363) 128891 magistrat 20 \n", "4 POINT (16.397960567598144 48.200110806556005) 130669 magistrat 3 \n", "\n", " OBJEKT_STRASSE GEBIETSGRUPPE \\\n", "0 Knoten Nordbrücke Hauptstraße B14 \n", "1 Schwarzwaldgasse MA 28 - Straße, Grünanlage \n", "2 Apostelgasse MA 28 - Straße, Grünanlage \n", "3 Knoten Nordbrücke Hauptstraße B14 \n", "4 Apostelgasse MA 28 - Straße, Grünanlage \n", "\n", " GATTUNG_ART PFLANZJAHR PFLANZJAHR_TXT \\\n", "0 Prunus mahaleb (Steinweichsel) 0 nicht definiert \n", "1 Jungbaum wird gepflanzt 0 nicht definiert \n", "2 Tilia tomentosa (Silberlinde) 1927 1927 \n", "3 Prunus mahaleb (Steinweichsel) 0 nicht definiert \n", "4 Acer platanoides 'Globosum' (Kugelspitzahorn) 1996 1996 \n", "\n", " STAMMUMFANG STAMMUMFANG_TXT BAUMHOEHE BAUMHOEHE_TXT KRONENDURCHMESSER \\\n", "0 148 148 cm 2 6-10 m 3 \n", "1 0 nicht bekannt 0 nicht bekannt 0 \n", "2 230 230 cm 4 16-20 m 5 \n", "3 91 91 cm 2 6-10 m 3 \n", "4 60 60 cm 1 0-5 m 2 \n", "\n", " KRONENDURCHMESSER_TXT BAUMNUMMER SE_ANNO_CAD_DATA \n", "0 7-9 m 2560 None \n", "1 nicht bekannt 2016 None \n", "2 13-15 m 1007 None \n", "3 7-9 m 2561 None \n", "4 4-6 m 1009 None " ], "text/html": [ "\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
FIDOBJECTIDSHAPEBAUM_IDDATENFUEHRUNGBEZIRKOBJEKT_STRASSEGEBIETSGRUPPEGATTUNG_ARTPFLANZJAHRPFLANZJAHR_TXTSTAMMUMFANGSTAMMUMFANG_TXTBAUMHOEHEBAUMHOEHE_TXTKRONENDURCHMESSERKRONENDURCHMESSER_TXTBAUMNUMMERSE_ANNO_CAD_DATA
0BAUMKATOGD.742832161742832161POINT (16.37305290330624 48.25396526394613)128890magistrat20Knoten NordbrückeHauptstraße B14Prunus mahaleb (Steinweichsel)0nicht definiert148148 cm26-10 m37-9 m2560None
1BAUMKATOGD.742832162742832162POINT (16.27350822664159 48.14422147386553)401554magistrat23SchwarzwaldgasseMA 28 - Straße, GrünanlageJungbaum wird gepflanzt0nicht definiert0nicht bekannt0nicht bekannt0nicht bekannt2016None
2BAUMKATOGD.742832163742832163POINT (16.398122022316993 48.20013311276198)130667magistrat3ApostelgasseMA 28 - Straße, GrünanlageTilia tomentosa (Silberlinde)19271927230230 cm416-20 m513-15 m1007None
3BAUMKATOGD.742832164742832164POINT (16.37306490734576 48.25399152008363)128891magistrat20Knoten NordbrückeHauptstraße B14Prunus mahaleb (Steinweichsel)0nicht definiert9191 cm26-10 m37-9 m2561None
4BAUMKATOGD.742832165742832165POINT (16.397960567598144 48.200110806556005)130669magistrat3ApostelgasseMA 28 - Straße, GrünanlageAcer platanoides 'Globosum' (Kugelspitzahorn)199619966060 cm10-5 m24-6 m1009None
\n", "
\n", "
\n", "\n", "
\n", " \n", "\n", " \n", "\n", " \n", "
\n", "\n", "\n", "
\n", " \n", "\n", "\n", "\n", " \n", "
\n", "\n", "
\n", "
\n" ], "application/vnd.google.colaboratory.intrinsic+json": { "type": "dataframe", "variable_name": "pdf" } }, "metadata": {}, "execution_count": 9 } ] }, { "cell_type": "markdown", "source": [ "Use Google's `data_table` for interactive tables." ], "metadata": { "id": "maOxLujadjuz" } }, { "cell_type": "code", "source": [ "# true if running on Google Colab\n", "import sys\n", "IN_COLAB = 'google.colab' in sys.modules\n", "\n", "if IN_COLAB:\n", " from google.colab import data_table\n", " from vega_datasets import data\n", " data_table.enable_dataframe_formatter()\n", "else:\n", " !pip install itables\n", " !pip install bokeh\n", " !pip install matplotlib\n", " from itables import init_notebook_mode\n", " init_notebook_mode(all_interactive=True)" ], "metadata": { "id": "Y95u5J72dj4w" }, "execution_count": 10, "outputs": [] }, { "cell_type": "code", "source": [ "pdf.head(100)" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 1577 }, "id": "pBoofR5Xdm23", "outputId": "e086974f-aaa9-4a4d-f66c-6103fdd98d24" }, "execution_count": 11, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " FID OBJECTID \\\n", "0 BAUMKATOGD.742832161 742832161 \n", "1 BAUMKATOGD.742832162 742832162 \n", "2 BAUMKATOGD.742832163 742832163 \n", "3 BAUMKATOGD.742832164 742832164 \n", "4 BAUMKATOGD.742832165 742832165 \n", ".. ... ... \n", "95 BAUMKATOGD.742832497 742832497 \n", "96 BAUMKATOGD.742832498 742832498 \n", "97 BAUMKATOGD.742832499 742832499 \n", "98 BAUMKATOGD.742832500 742832500 \n", "99 BAUMKATOGD.742832501 742832501 \n", "\n", " SHAPE BAUM_ID DATENFUEHRUNG \\\n", "0 POINT (16.37305290330624 48.25396526394613) 128890 magistrat \n", "1 POINT (16.27350822664159 48.14422147386553) 401554 magistrat \n", "2 POINT (16.398122022316993 48.20013311276198) 130667 magistrat \n", "3 POINT (16.37306490734576 48.25399152008363) 128891 magistrat \n", "4 POINT (16.397960567598144 48.200110806556005) 130669 magistrat \n", ".. ... ... ... \n", "95 POINT (16.322439773232073 48.15880274326233) 343206 magistrat \n", "96 POINT (16.414271910022116 48.20241321681734) 29285 magistrat \n", "97 POINT (16.48418195149353 48.27670809760198) 295651 magistrat \n", "98 POINT (16.4843354038467 48.276755203728975) 243711 magistrat \n", "99 POINT (16.475675981738746 48.16806414859867) 144178 magistrat \n", "\n", " BEZIRK OBJEKT_STRASSE \\\n", "0 20 Knoten Nordbrücke \n", "1 23 Schwarzwaldgasse \n", "2 3 Apostelgasse \n", "3 20 Knoten Nordbrücke \n", "4 3 Apostelgasse \n", ".. ... ... \n", "95 12 12., Parkanlage An den Eisteichen, MA42 \n", "96 2 Rustenschacherallee \n", "97 22 Wagramer Straße \n", "98 22 Wagramer Straße \n", "99 11 Zinnergasse \n", "\n", " GEBIETSGRUPPE \\\n", "0 Hauptstraße B14 \n", "1 MA 28 - Straße, Grünanlage \n", "2 MA 28 - Straße, Grünanlage \n", "3 Hauptstraße B14 \n", "4 MA 28 - Straße, Grünanlage \n", ".. ... \n", "95 MA 42 - Parkanlage \n", "96 MA 28 - Straße, Grünanlage \n", "97 MA 28 - Straße, Grünanlage \n", "98 MA 28 - Straße, Grünanlage \n", "99 Hauptstraße B14 \n", "\n", " GATTUNG_ART PFLANZJAHR \\\n", "0 Prunus mahaleb (Steinweichsel) 0 \n", "1 Jungbaum wird gepflanzt 0 \n", "2 Tilia tomentosa (Silberlinde) 1927 \n", "3 Prunus mahaleb (Steinweichsel) 0 \n", "4 Acer platanoides 'Globosum' (Kugelspitzahorn) 1996 \n", ".. ... ... \n", "95 Carpinus betulus 'Frans Fontaine' (Schlanke Sä... 2020 \n", "96 Acer platanoides (Spitzahorn) 1974 \n", "97 Pyrus calleryana 'Chanticleer' (Zierbirne) 2018 \n", "98 Celtis australis (Südlicher Zürgelbaum) 2018 \n", "99 Acer platanoides (Spitzahorn) 2005 \n", "\n", " PFLANZJAHR_TXT STAMMUMFANG STAMMUMFANG_TXT BAUMHOEHE BAUMHOEHE_TXT \\\n", "0 nicht definiert 148 148 cm 2 6-10 m \n", "1 nicht definiert 0 nicht bekannt 0 nicht bekannt \n", "2 1927 230 230 cm 4 16-20 m \n", "3 nicht definiert 91 91 cm 2 6-10 m \n", "4 1996 60 60 cm 1 0-5 m \n", ".. ... ... ... ... ... \n", "95 2020 29 29 cm 2 6-10 m \n", "96 1974 135 135 cm 3 11-15 m \n", "97 2018 36 36 cm 1 0-5 m \n", "98 2018 43 43 cm 1 0-5 m \n", "99 2005 68 68 cm 2 6-10 m \n", "\n", " KRONENDURCHMESSER KRONENDURCHMESSER_TXT BAUMNUMMER SE_ANNO_CAD_DATA \n", "0 3 7-9 m 2560 None \n", "1 0 nicht bekannt 2016 None \n", "2 5 13-15 m 1007 None \n", "3 3 7-9 m 2561 None \n", "4 2 4-6 m 1009 None \n", ".. ... ... ... ... \n", "95 1 0-3 m 66 None \n", "96 3 7-9 m 3198 None \n", "97 1 0-3 m 1012 None \n", "98 2 4-6 m 1013 None \n", "99 2 4-6 m 1061 None \n", "\n", "[100 rows x 19 columns]" ], "text/html": [ "\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
FIDOBJECTIDSHAPEBAUM_IDDATENFUEHRUNGBEZIRKOBJEKT_STRASSEGEBIETSGRUPPEGATTUNG_ARTPFLANZJAHRPFLANZJAHR_TXTSTAMMUMFANGSTAMMUMFANG_TXTBAUMHOEHEBAUMHOEHE_TXTKRONENDURCHMESSERKRONENDURCHMESSER_TXTBAUMNUMMERSE_ANNO_CAD_DATA
0BAUMKATOGD.742832161742832161POINT (16.37305290330624 48.25396526394613)128890magistrat20Knoten NordbrückeHauptstraße B14Prunus mahaleb (Steinweichsel)0nicht definiert148148 cm26-10 m37-9 m2560None
1BAUMKATOGD.742832162742832162POINT (16.27350822664159 48.14422147386553)401554magistrat23SchwarzwaldgasseMA 28 - Straße, GrünanlageJungbaum wird gepflanzt0nicht definiert0nicht bekannt0nicht bekannt0nicht bekannt2016None
2BAUMKATOGD.742832163742832163POINT (16.398122022316993 48.20013311276198)130667magistrat3ApostelgasseMA 28 - Straße, GrünanlageTilia tomentosa (Silberlinde)19271927230230 cm416-20 m513-15 m1007None
3BAUMKATOGD.742832164742832164POINT (16.37306490734576 48.25399152008363)128891magistrat20Knoten NordbrückeHauptstraße B14Prunus mahaleb (Steinweichsel)0nicht definiert9191 cm26-10 m37-9 m2561None
4BAUMKATOGD.742832165742832165POINT (16.397960567598144 48.200110806556005)130669magistrat3ApostelgasseMA 28 - Straße, GrünanlageAcer platanoides 'Globosum' (Kugelspitzahorn)199619966060 cm10-5 m24-6 m1009None
............................................................
95BAUMKATOGD.742832497742832497POINT (16.322439773232073 48.15880274326233)343206magistrat1212., Parkanlage An den Eisteichen, MA42MA 42 - ParkanlageCarpinus betulus 'Frans Fontaine' (Schlanke Sä...202020202929 cm26-10 m10-3 m66None
96BAUMKATOGD.742832498742832498POINT (16.414271910022116 48.20241321681734)29285magistrat2RustenschacheralleeMA 28 - Straße, GrünanlageAcer platanoides (Spitzahorn)19741974135135 cm311-15 m37-9 m3198None
97BAUMKATOGD.742832499742832499POINT (16.48418195149353 48.27670809760198)295651magistrat22Wagramer StraßeMA 28 - Straße, GrünanlagePyrus calleryana 'Chanticleer' (Zierbirne)201820183636 cm10-5 m10-3 m1012None
98BAUMKATOGD.742832500742832500POINT (16.4843354038467 48.276755203728975)243711magistrat22Wagramer StraßeMA 28 - Straße, GrünanlageCeltis australis (Südlicher Zürgelbaum)201820184343 cm10-5 m24-6 m1013None
99BAUMKATOGD.742832501742832501POINT (16.475675981738746 48.16806414859867)144178magistrat11ZinnergasseHauptstraße B14Acer platanoides (Spitzahorn)200520056868 cm26-10 m24-6 m1061None
\n", "

100 rows × 19 columns

\n", "
\n", "
\n", "\n", "
\n", " \n", "\n", " \n", "\n", " \n", "
\n", "\n", "\n", "
\n", " \n", "\n", "\n", "\n", " \n", "
\n", "\n", "
\n", "
\n" ], "application/vnd.google.colaboratory.intrinsic+json": { "type": "dataframe", "variable_name": "pdf" }, "application/vnd.google.colaboratory.module+javascript": "\n import \"https://ssl.gstatic.com/colaboratory/data_table/9e65f7085e7ffcb7/data_table.js\";\n\n const table = window.createDataTable({\n data: [[{\n 'v': 0,\n 'f': \"0\",\n },\n\"BAUMKATOGD.742832161\",\n\"742832161\",\n\"POINT (16.37305290330624 48.25396526394613)\",\n\"128890\",\n\"magistrat\",\n\"20\",\n\"Knoten Nordbr\\u00fccke\",\n\"Hauptstra\\u00dfe B14\",\n\"Prunus mahaleb (Steinweichsel)\",\n\"0\",\n\"nicht definiert\",\n\"148\",\n\"148 cm\",\n\"2\",\n\"6-10 m\",\n\"3\",\n\"7-9 m\",\n\"2560\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 1,\n 'f': \"1\",\n },\n\"BAUMKATOGD.742832162\",\n\"742832162\",\n\"POINT (16.27350822664159 48.14422147386553)\",\n\"401554\",\n\"magistrat\",\n\"23\",\n\"Schwarzwaldgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Jungbaum wird gepflanzt\",\n\"0\",\n\"nicht definiert\",\n\"0\",\n\"nicht bekannt\",\n\"0\",\n\"nicht bekannt\",\n\"0\",\n\"nicht bekannt\",\n\"2016\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 2,\n 'f': \"2\",\n },\n\"BAUMKATOGD.742832163\",\n\"742832163\",\n\"POINT (16.398122022316993 48.20013311276198)\",\n\"130667\",\n\"magistrat\",\n\"3\",\n\"Apostelgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Tilia tomentosa (Silberlinde)\",\n\"1927\",\n\"1927\",\n\"230\",\n\"230 cm\",\n\"4\",\n\"16-20 m\",\n\"5\",\n\"13-15 m\",\n\"1007\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 3,\n 'f': \"3\",\n },\n\"BAUMKATOGD.742832164\",\n\"742832164\",\n\"POINT (16.37306490734576 48.25399152008363)\",\n\"128891\",\n\"magistrat\",\n\"20\",\n\"Knoten Nordbr\\u00fccke\",\n\"Hauptstra\\u00dfe B14\",\n\"Prunus mahaleb (Steinweichsel)\",\n\"0\",\n\"nicht definiert\",\n\"91\",\n\"91 cm\",\n\"2\",\n\"6-10 m\",\n\"3\",\n\"7-9 m\",\n\"2561\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 4,\n 'f': \"4\",\n },\n\"BAUMKATOGD.742832165\",\n\"742832165\",\n\"POINT (16.397960567598144 48.200110806556005)\",\n\"130669\",\n\"magistrat\",\n\"3\",\n\"Apostelgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer platanoides 'Globosum' (Kugelspitzahorn)\",\n\"1996\",\n\"1996\",\n\"60\",\n\"60 cm\",\n\"1\",\n\"0-5 m\",\n\"2\",\n\"4-6 m\",\n\"1009\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 5,\n 'f': \"5\",\n },\n\"BAUMKATOGD.742832166\",\n\"742832166\",\n\"POINT (16.37304432757755 48.254024711408654)\",\n\"128892\",\n\"magistrat\",\n\"20\",\n\"Knoten Nordbr\\u00fccke\",\n\"Hauptstra\\u00dfe B14\",\n\"Prunus mahaleb (Steinweichsel)\",\n\"0\",\n\"nicht definiert\",\n\"188\",\n\"188 cm\",\n\"2\",\n\"6-10 m\",\n\"3\",\n\"7-9 m\",\n\"2562\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 6,\n 'f': \"6\",\n },\n\"BAUMKATOGD.742832167\",\n\"742832167\",\n\"POINT (16.373025591936745 48.2540007057163)\",\n\"128893\",\n\"magistrat\",\n\"20\",\n\"Knoten Nordbr\\u00fccke\",\n\"Hauptstra\\u00dfe B14\",\n\"Prunus mahaleb (Steinweichsel)\",\n\"0\",\n\"nicht definiert\",\n\"97\",\n\"97 cm\",\n\"2\",\n\"6-10 m\",\n\"3\",\n\"7-9 m\",\n\"2563\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 7,\n 'f': \"7\",\n },\n\"BAUMKATOGD.742832168\",\n\"742832168\",\n\"POINT (16.50515266676725 48.226967273711146)\",\n\"343856\",\n\"magistrat\",\n\"22\",\n\"22., Seepark, MA42\",\n\"MA 42 - Parkanlage\",\n\"Carpinus betulus (Hainbuche)\",\n\"2019\",\n\"2019\",\n\"20\",\n\"20 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"35/A\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 8,\n 'f': \"8\",\n },\n\"BAUMKATOGD.742832169\",\n\"742832169\",\n\"POINT (16.37298786450012 48.25397095049507)\",\n\"128895\",\n\"magistrat\",\n\"20\",\n\"Knoten Nordbr\\u00fccke\",\n\"Hauptstra\\u00dfe B14\",\n\"Prunus mahaleb (Steinweichsel)\",\n\"0\",\n\"nicht definiert\",\n\"160\",\n\"160 cm\",\n\"2\",\n\"6-10 m\",\n\"3\",\n\"7-9 m\",\n\"2565\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 9,\n 'f': \"9\",\n },\n\"BAUMKATOGD.742832170\",\n\"742832170\",\n\"POINT (16.407682929449027 48.20259979915417)\",\n\"29209\",\n\"magistrat\",\n\"2\",\n\"Rustenschacherallee\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Platanus x acerifolia (Ahornbl\\u00e4ttrige Platane)\",\n\"1867\",\n\"1867\",\n\"437\",\n\"437 cm\",\n\"5\",\n\"21-25 m\",\n\"6\",\n\"16-18 m\",\n\"3122\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 10,\n 'f': \"10\",\n },\n\"BAUMKATOGD.742832171\",\n\"742832171\",\n\"POINT (16.341925640071775 48.13945079326718)\",\n\"122873\",\n\"magistrat\",\n\"23\",\n\"Pfarrgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer platanoides 'Crimson King' (Blutahorn)\",\n\"1994\",\n\"1994\",\n\"89\",\n\"89 cm\",\n\"2\",\n\"6-10 m\",\n\"3\",\n\"7-9 m\",\n\"1043\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 11,\n 'f': \"11\",\n },\n\"BAUMKATOGD.742832172\",\n\"742832172\",\n\"POINT (16.372852526046476 48.25396991461836)\",\n\"181068\",\n\"magistrat\",\n\"20\",\n\"Knoten Nordbr\\u00fccke\",\n\"Hauptstra\\u00dfe B14\",\n\"Acer platanoides (Spitzahorn)\",\n\"2010\",\n\"2010\",\n\"47\",\n\"47 cm\",\n\"2\",\n\"6-10 m\",\n\"2\",\n\"4-6 m\",\n\"2566\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 12,\n 'f': \"12\",\n },\n\"BAUMKATOGD.742832173\",\n\"742832173\",\n\"POINT (16.39772024814629 48.20017208953374)\",\n\"14842\",\n\"magistrat\",\n\"3\",\n\"Apostelgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Ulmus minor 'Dampieri' (Feldulme)\",\n\"2003\",\n\"2003\",\n\"112\",\n\"112 cm\",\n\"2\",\n\"6-10 m\",\n\"2\",\n\"4-6 m\",\n\"1013\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 13,\n 'f': \"13\",\n },\n\"BAUMKATOGD.742832174\",\n\"742832174\",\n\"POINT (16.397359322991147 48.19949554150092)\",\n\"186683\",\n\"magistrat\",\n\"3\",\n\"Apostelgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Ulmus minor (Feldulme)\",\n\"2011\",\n\"2011\",\n\"61\",\n\"61 cm\",\n\"3\",\n\"11-15 m\",\n\"3\",\n\"7-9 m\",\n\"1015\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 14,\n 'f': \"14\",\n },\n\"BAUMKATOGD.742832175\",\n\"742832175\",\n\"POINT (16.33272874187207 48.24165950872352)\",\n\"120294\",\n\"magistrat\",\n\"19\",\n\"Sailer\\u00e4ckergasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer pseudoplatanus 'Atropurpureum' (Purpurner Bergahorn)\",\n\"1940\",\n\"1940\",\n\"121\",\n\"121 cm\",\n\"2\",\n\"6-10 m\",\n\"3\",\n\"7-9 m\",\n\"247\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 15,\n 'f': \"15\",\n },\n\"BAUMKATOGD.742832176\",\n\"742832176\",\n\"POINT (16.406313269383386 48.20318097648066)\",\n\"29192\",\n\"magistrat\",\n\"2\",\n\"Rustenschacherallee\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer platanoides (Spitzahorn)\",\n\"1993\",\n\"1993\",\n\"81\",\n\"81 cm\",\n\"3\",\n\"11-15 m\",\n\"2\",\n\"4-6 m\",\n\"3105\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 16,\n 'f': \"16\",\n },\n\"BAUMKATOGD.742832177\",\n\"742832177\",\n\"POINT (16.372799488738966 48.25399852975512)\",\n\"181070\",\n\"magistrat\",\n\"20\",\n\"Knoten Nordbr\\u00fccke\",\n\"Hauptstra\\u00dfe B14\",\n\"Celtis occidentalis (Westlicher Z\\u00fcrgelbaum)\",\n\"2010\",\n\"2010\",\n\"43\",\n\"43 cm\",\n\"2\",\n\"6-10 m\",\n\"1\",\n\"0-3 m\",\n\"2567\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 17,\n 'f': \"17\",\n },\n\"BAUMKATOGD.742832178\",\n\"742832178\",\n\"POINT (16.397252003307507 48.19929334077038)\",\n\"349242\",\n\"magistrat\",\n\"3\",\n\"Apostelgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Carpinus betulus (Hainbuche)\",\n\"2020\",\n\"2020\",\n\"21\",\n\"21 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"1016\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 18,\n 'f': \"18\",\n },\n\"BAUMKATOGD.742832179\",\n\"742832179\",\n\"POINT (16.432798178530295 48.2496474799565)\",\n\"298026\",\n\"magistrat\",\n\"22\",\n\"22., Kirschbl\\u00fctenpark, MA42\",\n\"MA 42 - Parkanlage\",\n\"Prunus serrulata 'Amanogawa' (S\\u00e4ulenkirsche)\",\n\"2014\",\n\"2014\",\n\"32\",\n\"32 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"75\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 19,\n 'f': \"19\",\n },\n\"BAUMKATOGD.742832180\",\n\"742832180\",\n\"POINT (16.397026127448658 48.19894011644642)\",\n\"349566\",\n\"magistrat\",\n\"3\",\n\"Apostelgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Carpinus betulus (Hainbuche)\",\n\"2020\",\n\"2020\",\n\"23\",\n\"23 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"2001\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 20,\n 'f': \"20\",\n },\n\"BAUMKATOGD.742832181\",\n\"742832181\",\n\"POINT (16.37289889894446 48.254037348410364)\",\n\"181069\",\n\"magistrat\",\n\"20\",\n\"Knoten Nordbr\\u00fccke\",\n\"Hauptstra\\u00dfe B14\",\n\"Celtis occidentalis (Westlicher Z\\u00fcrgelbaum)\",\n\"2010\",\n\"2010\",\n\"36\",\n\"36 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"2569\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 21,\n 'f': \"21\",\n },\n\"BAUMKATOGD.742832182\",\n\"742832182\",\n\"POINT (16.39112010186532 48.14493873327755)\",\n\"346357\",\n\"magistrat\",\n\"10\",\n\"10., Parkanlage Ada-Christen-Gasse, MA42\",\n\"MA 42 - Parkanlage\",\n\"Sorbus aria (Gew\\u00f6hnliche Mehlbeere)\",\n\"2020\",\n\"2020\",\n\"25\",\n\"25 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"343\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 22,\n 'f': \"22\",\n },\n\"BAUMKATOGD.742832183\",\n\"742832183\",\n\"POINT (16.40648417134481 48.20311728990144)\",\n\"29194\",\n\"magistrat\",\n\"2\",\n\"Rustenschacherallee\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer platanoides (Spitzahorn)\",\n\"1970\",\n\"1970\",\n\"110\",\n\"110 cm\",\n\"3\",\n\"11-15 m\",\n\"4\",\n\"10-12 m\",\n\"3107\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 23,\n 'f': \"23\",\n },\n\"BAUMKATOGD.742832184\",\n\"742832184\",\n\"POINT (16.372808974746643 48.25408171334927)\",\n\"128900\",\n\"magistrat\",\n\"20\",\n\"Knoten Nordbr\\u00fccke\",\n\"Hauptstra\\u00dfe B14\",\n\"Populus simonii (Birkenpappel)\",\n\"0\",\n\"nicht definiert\",\n\"93\",\n\"93 cm\",\n\"2\",\n\"6-10 m\",\n\"2\",\n\"4-6 m\",\n\"2570\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 24,\n 'f': \"24\",\n },\n\"BAUMKATOGD.742832185\",\n\"742832185\",\n\"POINT (16.40681171288633 48.202989295221826)\",\n\"29198\",\n\"magistrat\",\n\"2\",\n\"Rustenschacherallee\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer platanoides (Spitzahorn)\",\n\"2002\",\n\"2002\",\n\"72\",\n\"72 cm\",\n\"3\",\n\"11-15 m\",\n\"2\",\n\"4-6 m\",\n\"3111\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 25,\n 'f': \"25\",\n },\n\"BAUMKATOGD.742832186\",\n\"742832186\",\n\"POINT (16.396175580986302 48.1971188938734)\",\n\"330133\",\n\"magistrat\",\n\"3\",\n\"Apostelgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer campestre 'Elsrijk' (Feldahorn)\",\n\"2018\",\n\"2018\",\n\"25\",\n\"25 cm\",\n\"2\",\n\"6-10 m\",\n\"2\",\n\"4-6 m\",\n\"2006\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 26,\n 'f': \"26\",\n },\n\"BAUMKATOGD.742832187\",\n\"742832187\",\n\"POINT (16.37276913482783 48.25411086384992)\",\n\"387072\",\n\"magistrat\",\n\"20\",\n\"Knoten Nordbr\\u00fccke\",\n\"Hauptstra\\u00dfe B14\",\n\"Acer campestre 'Elsrijk' (Feldahorn)\",\n\"2024\",\n\"2024\",\n\"20\",\n\"20 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"2571\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 27,\n 'f': \"27\",\n },\n\"BAUMKATOGD.742832188\",\n\"742832188\",\n\"POINT (16.406977227413947 48.202922013927896)\",\n\"29200\",\n\"magistrat\",\n\"2\",\n\"Rustenschacherallee\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer platanoides (Spitzahorn)\",\n\"1987\",\n\"1987\",\n\"89\",\n\"89 cm\",\n\"3\",\n\"11-15 m\",\n\"3\",\n\"7-9 m\",\n\"3113\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 28,\n 'f': \"28\",\n },\n\"BAUMKATOGD.742832189\",\n\"742832189\",\n\"POINT (16.372667800527687 48.25420667311857)\",\n\"128903\",\n\"magistrat\",\n\"20\",\n\"Knoten Nordbr\\u00fccke\",\n\"Hauptstra\\u00dfe B14\",\n\"Acer campestre (Feldahorn)\",\n\"0\",\n\"nicht definiert\",\n\"87\",\n\"87 cm\",\n\"2\",\n\"6-10 m\",\n\"2\",\n\"4-6 m\",\n\"2573\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 29,\n 'f': \"29\",\n },\n\"BAUMKATOGD.742832190\",\n\"742832190\",\n\"POINT (16.315458615839184 48.206051211618686)\",\n\"385687\",\n\"magistrat\",\n\"15\",\n\"15., Rohrauerpark, MA42\",\n\"MA 42 - Parkanlage\",\n\"Gleditsia triacanthos 'Skyline' (S\\u00e4ulengleditschie)\",\n\"2024\",\n\"2024\",\n\"24\",\n\"24 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"45/A\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 30,\n 'f': \"30\",\n },\n\"BAUMKATOGD.742832191\",\n\"742832191\",\n\"POINT (16.372643853789526 48.254239865440475)\",\n\"128904\",\n\"magistrat\",\n\"20\",\n\"Knoten Nordbr\\u00fccke\",\n\"Hauptstra\\u00dfe B14\",\n\"Acer campestre (Feldahorn)\",\n\"0\",\n\"nicht definiert\",\n\"83\",\n\"83 cm\",\n\"2\",\n\"6-10 m\",\n\"2\",\n\"4-6 m\",\n\"2574\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 31,\n 'f': \"31\",\n },\n\"BAUMKATOGD.742832192\",\n\"742832192\",\n\"POINT (16.407525904256016 48.20267570969648)\",\n\"29207\",\n\"magistrat\",\n\"2\",\n\"Rustenschacherallee\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer platanoides (Spitzahorn)\",\n\"1950\",\n\"1950\",\n\"128\",\n\"128 cm\",\n\"3\",\n\"11-15 m\",\n\"4\",\n\"10-12 m\",\n\"3120\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 32,\n 'f': \"32\",\n },\n\"BAUMKATOGD.742832193\",\n\"742832193\",\n\"POINT (16.407597696368928 48.20264203041397)\",\n\"169037\",\n\"magistrat\",\n\"2\",\n\"Rustenschacherallee\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Ulmus 'Regal' (Resista Ulme)\",\n\"2011\",\n\"2011\",\n\"29\",\n\"29 cm\",\n\"2\",\n\"6-10 m\",\n\"1\",\n\"0-3 m\",\n\"3121\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 33,\n 'f': \"33\",\n },\n\"BAUMKATOGD.742832194\",\n\"742832194\",\n\"POINT (16.37259239466185 48.254215870064904)\",\n\"128905\",\n\"magistrat\",\n\"20\",\n\"Knoten Nordbr\\u00fccke\",\n\"Hauptstra\\u00dfe B14\",\n\"Acer campestre (Feldahorn)\",\n\"0\",\n\"nicht definiert\",\n\"116\",\n\"116 cm\",\n\"2\",\n\"6-10 m\",\n\"2\",\n\"4-6 m\",\n\"2575\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 34,\n 'f': \"34\",\n },\n\"BAUMKATOGD.742832195\",\n\"742832195\",\n\"POINT (16.372477800417442 48.254223910246665)\",\n\"128906\",\n\"magistrat\",\n\"20\",\n\"Knoten Nordbr\\u00fccke\",\n\"Hauptstra\\u00dfe B14\",\n\"Fraxinus excelsior (Gemeine Esche)\",\n\"0\",\n\"nicht definiert\",\n\"91\",\n\"91 cm\",\n\"2\",\n\"6-10 m\",\n\"3\",\n\"7-9 m\",\n\"2576\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 35,\n 'f': \"35\",\n },\n\"BAUMKATOGD.742832437\",\n\"742832437\",\n\"POINT (16.400400370039634 48.19512793469756)\",\n\"331610\",\n\"magistrat\",\n\"3\",\n\"Baumgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Pyrus calleryana 'Chanticleer' (Zierbirne)\",\n\"2020\",\n\"2020\",\n\"25\",\n\"25 cm\",\n\"2\",\n\"6-10 m\",\n\"1\",\n\"0-3 m\",\n\"1003\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 36,\n 'f': \"36\",\n },\n\"BAUMKATOGD.742832438\",\n\"742832438\",\n\"POINT (16.474953787638288 48.166574925378306)\",\n\"371515\",\n\"magistrat\",\n\"11\",\n\"Zinnergasse\",\n\"Hauptstra\\u00dfe B14\",\n\"Celtis spec. (Z\\u00fcrgelbaum)\",\n\"2022\",\n\"2022\",\n\"20\",\n\"20 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"1047\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 37,\n 'f': \"37\",\n },\n\"BAUMKATOGD.742832439\",\n\"742832439\",\n\"POINT (16.47499649755465 48.166659500628185)\",\n\"80578\",\n\"magistrat\",\n\"11\",\n\"Zinnergasse\",\n\"Hauptstra\\u00dfe B14\",\n\"Acer platanoides (Spitzahorn)\",\n\"0\",\n\"nicht definiert\",\n\"119\",\n\"119 cm\",\n\"3\",\n\"11-15 m\",\n\"4\",\n\"10-12 m\",\n\"1048\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 38,\n 'f': \"38\",\n },\n\"BAUMKATOGD.742832440\",\n\"742832440\",\n\"POINT (16.4104636552697 48.20120300498909)\",\n\"29243\",\n\"magistrat\",\n\"2\",\n\"Rustenschacherallee\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer pseudoplatanus (Bergahorn)\",\n\"1965\",\n\"1965\",\n\"111\",\n\"111 cm\",\n\"3\",\n\"11-15 m\",\n\"3\",\n\"7-9 m\",\n\"3156\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 39,\n 'f': \"39\",\n },\n\"BAUMKATOGD.742832441\",\n\"742832441\",\n\"POINT (16.475162648188743 48.16700329303332)\",\n\"80587\",\n\"magistrat\",\n\"11\",\n\"Zinnergasse\",\n\"Hauptstra\\u00dfe B14\",\n\"Acer platanoides (Spitzahorn)\",\n\"0\",\n\"nicht definiert\",\n\"107\",\n\"107 cm\",\n\"2\",\n\"6-10 m\",\n\"3\",\n\"7-9 m\",\n\"1051\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 40,\n 'f': \"40\",\n },\n\"BAUMKATOGD.742832442\",\n\"742832442\",\n\"POINT (16.410548122561288 48.2011926081289)\",\n\"124777\",\n\"magistrat\",\n\"2\",\n\"Rustenschacherallee\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Ulmus 'Regal' (Resista Ulme)\",\n\"2008\",\n\"2008\",\n\"53\",\n\"53 cm\",\n\"3\",\n\"11-15 m\",\n\"2\",\n\"4-6 m\",\n\"3157\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 41,\n 'f': \"41\",\n },\n\"BAUMKATOGD.742832443\",\n\"742832443\",\n\"POINT (16.400761718597284 48.22147651838835)\",\n\"372176\",\n\"magistrat\",\n\"2\",\n\"Ennsgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Tilia tomentosa 'Brabant' (Silberlinde)\",\n\"2023\",\n\"2023\",\n\"23\",\n\"23 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"1005\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 42,\n 'f': \"42\",\n },\n\"BAUMKATOGD.742832444\",\n\"742832444\",\n\"POINT (16.384904606432404 48.17606733291749)\",\n\"309965\",\n\"magistrat\",\n\"10\",\n\"Steudelgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Celtis australis (S\\u00fcdlicher Z\\u00fcrgelbaum)\",\n\"2018\",\n\"2018\",\n\"44\",\n\"44 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"2007\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 43,\n 'f': \"43\",\n },\n\"BAUMKATOGD.742832445\",\n\"742832445\",\n\"POINT (16.43932071572619 48.261933104637066)\",\n\"254998\",\n\"magistrat\",\n\"21\",\n\"Oskar-Grissemann-Stra\\u00dfe\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer campestre 'Elsrijk' (Feldahorn)\",\n\"2019\",\n\"2019\",\n\"22\",\n\"22 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"101\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 44,\n 'f': \"44\",\n },\n\"BAUMKATOGD.742832446\",\n\"742832446\",\n\"POINT (16.4752048363775 48.167093534601406)\",\n\"308531\",\n\"magistrat\",\n\"11\",\n\"Zinnergasse\",\n\"Hauptstra\\u00dfe B14\",\n\"Celtis spec. (Z\\u00fcrgelbaum)\",\n\"2020\",\n\"2020\",\n\"18\",\n\"18 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"1052\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 45,\n 'f': \"45\",\n },\n\"BAUMKATOGD.742832447\",\n\"742832447\",\n\"POINT (16.381949400360348 48.286696309826915)\",\n\"197256\",\n\"magistrat\",\n\"21\",\n\"Scheydgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Fraxinus ornus 'Obelisk' (S\\u00e4ulenblumenesche)\",\n\"2012\",\n\"2012\",\n\"40\",\n\"40 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"109\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 46,\n 'f': \"46\",\n },\n\"BAUMKATOGD.742832448\",\n\"742832448\",\n\"POINT (16.323788264450027 48.16088304537375)\",\n\"203313\",\n\"magistrat\",\n\"12\",\n\"12., Parkanlage An den Eisteichen, MA42\",\n\"MA 42 - Parkanlage\",\n\"Gleditsia triacanthos (Lederh\\u00fclsenbaum)\",\n\"1990\",\n\"1990\",\n\"108\",\n\"108 cm\",\n\"2\",\n\"6-10 m\",\n\"2\",\n\"4-6 m\",\n\"12\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 47,\n 'f': \"47\",\n },\n\"BAUMKATOGD.742832449\",\n\"742832449\",\n\"POINT (16.405849952259732 48.2374787205566)\",\n\"265648\",\n\"magistrat\",\n\"22\",\n\"22., Donaupark, MA42\",\n\"MA 42 - Parkanlage\",\n\"Robinia pseudoacacia (Scheinakazie)\",\n\"1984\",\n\"1984\",\n\"149\",\n\"149 cm\",\n\"2\",\n\"6-10 m\",\n\"3\",\n\"7-9 m\",\n\"13074\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 48,\n 'f': \"48\",\n },\n\"BAUMKATOGD.742832450\",\n\"742832450\",\n\"POINT (16.29987834494889 48.14923687837238)\",\n\"369000\",\n\"magistrat\",\n\"23\",\n\"23., Parkanlage Stadtpark Atzgersdorf, MA42\",\n\"MA 42 - Parkanlage\",\n\"Taxus baccata (Heimische Eibe)\",\n\"0\",\n\"nicht definiert\",\n\"45\",\n\"45 cm\",\n\"2\",\n\"6-10 m\",\n\"1\",\n\"0-3 m\",\n\"151\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 49,\n 'f': \"49\",\n },\n\"BAUMKATOGD.742832451\",\n\"742832451\",\n\"POINT (16.432870044122765 48.248555830142145)\",\n\"298064\",\n\"magistrat\",\n\"22\",\n\"22., Kirschbl\\u00fctenpark, MA42\",\n\"MA 42 - Parkanlage\",\n\"Acer griseum (Zimtahorn)\",\n\"2014\",\n\"2014\",\n\"17\",\n\"17 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"113\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 50,\n 'f': \"50\",\n },\n\"BAUMKATOGD.742832452\",\n\"742832452\",\n\"POINT (16.380554330063703 48.28825068426368)\",\n\"212676\",\n\"magistrat\",\n\"21\",\n\"21., Parkanlage Miklosichgasse, MA42\",\n\"MA 42 - Parkanlage\",\n\"Tilia cordata (Winterlinde)\",\n\"0\",\n\"nicht definiert\",\n\"160\",\n\"160 cm\",\n\"2\",\n\"6-10 m\",\n\"2\",\n\"4-6 m\",\n\"4\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 51,\n 'f': \"51\",\n },\n\"BAUMKATOGD.742832453\",\n\"742832453\",\n\"POINT (16.38483587407217 48.17590089661611)\",\n\"202556\",\n\"magistrat\",\n\"10\",\n\"Steudelgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Celtis australis (S\\u00fcdlicher Z\\u00fcrgelbaum)\",\n\"2013\",\n\"2013\",\n\"62\",\n\"62 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"2008\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 52,\n 'f': \"52\",\n },\n\"BAUMKATOGD.742832454\",\n\"742832454\",\n\"POINT (16.38472805878238 48.17563905818937)\",\n\"202557\",\n\"magistrat\",\n\"10\",\n\"Steudelgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Celtis australis (S\\u00fcdlicher Z\\u00fcrgelbaum)\",\n\"2013\",\n\"2013\",\n\"59\",\n\"59 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"2010\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 53,\n 'f': \"53\",\n },\n\"BAUMKATOGD.742832455\",\n\"742832455\",\n\"POINT (16.320329732726695 48.209961966758044)\",\n\"4150\",\n\"magistrat\",\n\"16\",\n\"Hasnerstra\\u00dfe\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Aesculus x carnea (Rotbl\\u00fchende Kastanie)\",\n\"1995\",\n\"1995\",\n\"107\",\n\"107 cm\",\n\"2\",\n\"6-10 m\",\n\"2\",\n\"4-6 m\",\n\"1088\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 54,\n 'f': \"54\",\n },\n\"BAUMKATOGD.742832456\",\n\"742832456\",\n\"POINT (16.475251039085926 48.16717684646327)\",\n\"337982\",\n\"magistrat\",\n\"11\",\n\"Zinnergasse\",\n\"Hauptstra\\u00dfe B14\",\n\"Celtis australis (S\\u00fcdlicher Z\\u00fcrgelbaum)\",\n\"2018\",\n\"2018\",\n\"18\",\n\"18 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"1053\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 55,\n 'f': \"55\",\n },\n\"BAUMKATOGD.742832457\",\n\"742832457\",\n\"POINT (16.44092316535775 48.262047127364745)\",\n\"189981\",\n\"magistrat\",\n\"21\",\n\"Oskar-Grissemann-Stra\\u00dfe\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer platanoides 'Columnare' (S\\u00e4ulenahorn)\",\n\"2014\",\n\"2014\",\n\"25\",\n\"25 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"106\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 56,\n 'f': \"56\",\n },\n\"BAUMKATOGD.742832458\",\n\"742832458\",\n\"POINT (16.410936031436943 48.20114855934656)\",\n\"29248\",\n\"magistrat\",\n\"2\",\n\"Rustenschacherallee\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer pseudoplatanus (Bergahorn)\",\n\"1970\",\n\"1970\",\n\"118\",\n\"118 cm\",\n\"3\",\n\"11-15 m\",\n\"3\",\n\"7-9 m\",\n\"3161\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 57,\n 'f': \"57\",\n },\n\"BAUMKATOGD.742832459\",\n\"742832459\",\n\"POINT (16.384680349132033 48.17552135642537)\",\n\"202558\",\n\"magistrat\",\n\"10\",\n\"Steudelgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Celtis australis (S\\u00fcdlicher Z\\u00fcrgelbaum)\",\n\"2013\",\n\"2013\",\n\"81\",\n\"81 cm\",\n\"1\",\n\"0-5 m\",\n\"2\",\n\"4-6 m\",\n\"2011\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 58,\n 'f': \"58\",\n },\n\"BAUMKATOGD.742832460\",\n\"742832460\",\n\"POINT (16.384286018084474 48.17455537504523)\",\n\"181397\",\n\"magistrat\",\n\"10\",\n\"Steudelgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Celtis australis (S\\u00fcdlicher Z\\u00fcrgelbaum)\",\n\"2011\",\n\"2011\",\n\"111\",\n\"111 cm\",\n\"2\",\n\"6-10 m\",\n\"2\",\n\"4-6 m\",\n\"2016\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 59,\n 'f': \"59\",\n },\n\"BAUMKATOGD.742832461\",\n\"742832461\",\n\"POINT (16.48286551240245 48.276314537442786)\",\n\"373712\",\n\"magistrat\",\n\"22\",\n\"Wagramer Stra\\u00dfe\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Pyrus calleryana 'Chanticleer' (Zierbirne)\",\n\"2023\",\n\"2023\",\n\"19\",\n\"19 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"1002\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 60,\n 'f': \"60\",\n },\n\"BAUMKATOGD.742832462\",\n\"742832462\",\n\"POINT (16.411423931739215 48.20113142350813)\",\n\"29253\",\n\"magistrat\",\n\"2\",\n\"Rustenschacherallee\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer platanoides (Spitzahorn)\",\n\"1940\",\n\"1940\",\n\"116\",\n\"116 cm\",\n\"3\",\n\"11-15 m\",\n\"3\",\n\"7-9 m\",\n\"3166\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 61,\n 'f': \"61\",\n },\n\"BAUMKATOGD.742832463\",\n\"742832463\",\n\"POINT (16.38406163204221 48.17400139324288)\",\n\"237853\",\n\"magistrat\",\n\"10\",\n\"Steudelgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Celtis australis (S\\u00fcdlicher Z\\u00fcrgelbaum)\",\n\"2014\",\n\"2014\",\n\"67\",\n\"67 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"2020\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 62,\n 'f': \"62\",\n },\n\"BAUMKATOGD.742832464\",\n\"742832464\",\n\"POINT (16.48295166613687 48.27633744985749)\",\n\"157549\",\n\"magistrat\",\n\"22\",\n\"Wagramer Stra\\u00dfe\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Pyrus calleryana 'Chanticleer' (Zierbirne)\",\n\"2007\",\n\"2007\",\n\"55\",\n\"55 cm\",\n\"2\",\n\"6-10 m\",\n\"2\",\n\"4-6 m\",\n\"1003\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 63,\n 'f': \"63\",\n },\n\"BAUMKATOGD.742832465\",\n\"742832465\",\n\"POINT (16.383992501310892 48.17383441694713)\",\n\"12712\",\n\"magistrat\",\n\"10\",\n\"Steudelgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Fraxinus excelsior (Gemeine Esche)\",\n\"1992\",\n\"1992\",\n\"69\",\n\"69 cm\",\n\"2\",\n\"6-10 m\",\n\"1\",\n\"0-3 m\",\n\"2021\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 64,\n 'f': \"64\",\n },\n\"BAUMKATOGD.742832466\",\n\"742832466\",\n\"POINT (16.44110953050052 48.26202771206641)\",\n\"20857\",\n\"magistrat\",\n\"21\",\n\"Oskar-Grissemann-Stra\\u00dfe\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer pseudoplatanus (Bergahorn)\",\n\"1972\",\n\"1972\",\n\"125\",\n\"125 cm\",\n\"3\",\n\"11-15 m\",\n\"3\",\n\"7-9 m\",\n\"107\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 65,\n 'f': \"65\",\n },\n\"BAUMKATOGD.742832467\",\n\"742832467\",\n\"POINT (16.411718283668897 48.20113779541656)\",\n\"29256\",\n\"magistrat\",\n\"2\",\n\"Rustenschacherallee\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer platanoides (Spitzahorn)\",\n\"1945\",\n\"1945\",\n\"129\",\n\"129 cm\",\n\"3\",\n\"11-15 m\",\n\"3\",\n\"7-9 m\",\n\"3169\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 66,\n 'f': \"66\",\n },\n\"BAUMKATOGD.742832468\",\n\"742832468\",\n\"POINT (16.441462736732824 48.2619916863213)\",\n\"20859\",\n\"magistrat\",\n\"21\",\n\"Oskar-Grissemann-Stra\\u00dfe\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer pseudoplatanus (Bergahorn)\",\n\"1974\",\n\"1974\",\n\"111\",\n\"111 cm\",\n\"3\",\n\"11-15 m\",\n\"3\",\n\"7-9 m\",\n\"109\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 67,\n 'f': \"67\",\n },\n\"BAUMKATOGD.742832469\",\n\"742832469\",\n\"POINT (16.41191618919699 48.20114998585669)\",\n\"29258\",\n\"magistrat\",\n\"2\",\n\"Rustenschacherallee\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer pseudoplatanus (Bergahorn)\",\n\"1984\",\n\"1984\",\n\"85\",\n\"85 cm\",\n\"3\",\n\"11-15 m\",\n\"2\",\n\"4-6 m\",\n\"3171\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 68,\n 'f': \"68\",\n },\n\"BAUMKATOGD.742832470\",\n\"742832470\",\n\"POINT (16.48304134233518 48.27636719247568)\",\n\"157550\",\n\"magistrat\",\n\"22\",\n\"Wagramer Stra\\u00dfe\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Pyrus calleryana 'Chanticleer' (Zierbirne)\",\n\"2007\",\n\"2007\",\n\"44\",\n\"44 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"1004\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 69,\n 'f': \"69\",\n },\n\"BAUMKATOGD.742832471\",\n\"742832471\",\n\"POINT (16.475292538601455 48.16726088346218)\",\n\"371516\",\n\"magistrat\",\n\"11\",\n\"Zinnergasse\",\n\"Hauptstra\\u00dfe B14\",\n\"Celtis spec. (Z\\u00fcrgelbaum)\",\n\"2022\",\n\"2022\",\n\"18\",\n\"18 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"1054\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 70,\n 'f': \"70\",\n },\n\"BAUMKATOGD.742832472\",\n\"742832472\",\n\"POINT (16.383741840490256 48.17321263609346)\",\n\"194750\",\n\"magistrat\",\n\"10\",\n\"Steudelgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Celtis australis (S\\u00fcdlicher Z\\u00fcrgelbaum)\",\n\"2012\",\n\"2012\",\n\"71\",\n\"71 cm\",\n\"1\",\n\"0-5 m\",\n\"2\",\n\"4-6 m\",\n\"2025\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 71,\n 'f': \"71\",\n },\n\"BAUMKATOGD.742832473\",\n\"742832473\",\n\"POINT (16.441634423190678 48.261973452724455)\",\n\"20860\",\n\"magistrat\",\n\"21\",\n\"Oskar-Grissemann-Stra\\u00dfe\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer platanoides 'Crimson King' (Blutahorn)\",\n\"2008\",\n\"2008\",\n\"48\",\n\"48 cm\",\n\"2\",\n\"6-10 m\",\n\"2\",\n\"4-6 m\",\n\"110\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 72,\n 'f': \"72\",\n },\n\"BAUMKATOGD.742832474\",\n\"742832474\",\n\"POINT (16.483265469539496 48.2764428078318)\",\n\"157551\",\n\"magistrat\",\n\"22\",\n\"Wagramer Stra\\u00dfe\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Pyrus calleryana 'Chanticleer' (Zierbirne)\",\n\"2009\",\n\"2009\",\n\"56\",\n\"56 cm\",\n\"2\",\n\"6-10 m\",\n\"2\",\n\"4-6 m\",\n\"1006\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 73,\n 'f': \"73\",\n },\n\"BAUMKATOGD.742832475\",\n\"742832475\",\n\"POINT (16.441803962905396 48.261959267755614)\",\n\"189982\",\n\"magistrat\",\n\"21\",\n\"Oskar-Grissemann-Stra\\u00dfe\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer platanoides 'Columnare' (S\\u00e4ulenahorn)\",\n\"2014\",\n\"2014\",\n\"30\",\n\"30 cm\",\n\"2\",\n\"6-10 m\",\n\"1\",\n\"0-3 m\",\n\"111\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 74,\n 'f': \"74\",\n },\n\"BAUMKATOGD.742832476\",\n\"742832476\",\n\"POINT (16.4128825882798 48.201396748550984)\",\n\"130188\",\n\"magistrat\",\n\"2\",\n\"Rustenschacherallee\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Ulmus 'Regal' (Resista Ulme)\",\n\"2008\",\n\"2008\",\n\"47\",\n\"47 cm\",\n\"2\",\n\"6-10 m\",\n\"2\",\n\"4-6 m\",\n\"3181\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 75,\n 'f': \"75\",\n },\n\"BAUMKATOGD.742832477\",\n\"742832477\",\n\"POINT (16.383686053737126 48.17307928891305)\",\n\"237854\",\n\"magistrat\",\n\"10\",\n\"Steudelgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Celtis australis (S\\u00fcdlicher Z\\u00fcrgelbaum)\",\n\"2014\",\n\"2014\",\n\"54\",\n\"54 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"2026\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 76,\n 'f': \"76\",\n },\n\"BAUMKATOGD.742832478\",\n\"742832478\",\n\"POINT (16.38358849527737 48.172846403393514)\",\n\"251834\",\n\"magistrat\",\n\"10\",\n\"Steudelgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Celtis australis (S\\u00fcdlicher Z\\u00fcrgelbaum)\",\n\"2015\",\n\"2015\",\n\"62\",\n\"62 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"2028\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 77,\n 'f': \"77\",\n },\n\"BAUMKATOGD.742832479\",\n\"742832479\",\n\"POINT (16.4426818137931 48.26188075699106)\",\n\"198891\",\n\"magistrat\",\n\"21\",\n\"Oskar-Grissemann-Stra\\u00dfe\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer platanoides 'Columnare' (S\\u00e4ulenahorn)\",\n\"2014\",\n\"2014\",\n\"31\",\n\"31 cm\",\n\"2\",\n\"6-10 m\",\n\"1\",\n\"0-3 m\",\n\"115\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 78,\n 'f': \"78\",\n },\n\"BAUMKATOGD.742832480\",\n\"742832480\",\n\"POINT (16.475325405809805 48.16733440875272)\",\n\"377315\",\n\"magistrat\",\n\"11\",\n\"Zinnergasse\",\n\"Hauptstra\\u00dfe B14\",\n\"Celtis australis (S\\u00fcdlicher Z\\u00fcrgelbaum)\",\n\"2023\",\n\"2023\",\n\"20\",\n\"20 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"1055\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 79,\n 'f': \"79\",\n },\n\"BAUMKATOGD.742832481\",\n\"742832481\",\n\"POINT (16.413049252471506 48.20147712658516)\",\n\"29270\",\n\"magistrat\",\n\"2\",\n\"Rustenschacherallee\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer pseudoplatanus (Bergahorn)\",\n\"1986\",\n\"1986\",\n\"39\",\n\"39 cm\",\n\"3\",\n\"11-15 m\",\n\"2\",\n\"4-6 m\",\n\"3183\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 80,\n 'f': \"80\",\n },\n\"BAUMKATOGD.742832482\",\n\"742832482\",\n\"POINT (16.44286805083913 48.26186511607825)\",\n\"198892\",\n\"magistrat\",\n\"21\",\n\"Oskar-Grissemann-Stra\\u00dfe\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer platanoides 'Columnare' (S\\u00e4ulenahorn)\",\n\"2014\",\n\"2014\",\n\"33\",\n\"33 cm\",\n\"2\",\n\"6-10 m\",\n\"1\",\n\"0-3 m\",\n\"116\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 81,\n 'f': \"81\",\n },\n\"BAUMKATOGD.742832483\",\n\"742832483\",\n\"POINT (16.41320274421271 48.201564617860484)\",\n\"29272\",\n\"magistrat\",\n\"2\",\n\"Rustenschacherallee\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer platanoides (Spitzahorn)\",\n\"1994\",\n\"1994\",\n\"65\",\n\"65 cm\",\n\"3\",\n\"11-15 m\",\n\"3\",\n\"7-9 m\",\n\"3185\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 82,\n 'f': \"82\",\n },\n\"BAUMKATOGD.742832484\",\n\"742832484\",\n\"POINT (16.41334830113617 48.20165328337926)\",\n\"29274\",\n\"magistrat\",\n\"2\",\n\"Rustenschacherallee\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer pseudoplatanus 'Purpurascens' (Bergahorn 'Purpurascens')\",\n\"1985\",\n\"1985\",\n\"79\",\n\"79 cm\",\n\"3\",\n\"11-15 m\",\n\"3\",\n\"7-9 m\",\n\"3187\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 83,\n 'f': \"83\",\n },\n\"BAUMKATOGD.742832485\",\n\"742832485\",\n\"POINT (16.383489850416495 48.1726008377101)\",\n\"306807\",\n\"magistrat\",\n\"10\",\n\"Steudelgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Celtis australis (S\\u00fcdlicher Z\\u00fcrgelbaum)\",\n\"2018\",\n\"2018\",\n\"45\",\n\"45 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"2030\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 84,\n 'f': \"84\",\n },\n\"BAUMKATOGD.742832486\",\n\"742832486\",\n\"POINT (16.47555702951992 48.16782597086923)\",\n\"308532\",\n\"magistrat\",\n\"11\",\n\"Zinnergasse\",\n\"Hauptstra\\u00dfe B14\",\n\"Celtis australis (S\\u00fcdlicher Z\\u00fcrgelbaum)\",\n\"2018\",\n\"2018\",\n\"18\",\n\"18 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"1057\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 85,\n 'f': \"85\",\n },\n\"BAUMKATOGD.742832487\",\n\"742832487\",\n\"POINT (16.413554075343498 48.20179703667993)\",\n\"29277\",\n\"magistrat\",\n\"2\",\n\"Rustenschacherallee\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer platanoides (Spitzahorn)\",\n\"1993\",\n\"1993\",\n\"109\",\n\"109 cm\",\n\"3\",\n\"11-15 m\",\n\"3\",\n\"7-9 m\",\n\"3190\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 86,\n 'f': \"86\",\n },\n\"BAUMKATOGD.742832488\",\n\"742832488\",\n\"POINT (16.44325412286784 48.26183148246528)\",\n\"20868\",\n\"magistrat\",\n\"21\",\n\"Oskar-Grissemann-Stra\\u00dfe\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer pseudoplatanus (Bergahorn)\",\n\"1965\",\n\"1965\",\n\"154\",\n\"154 cm\",\n\"3\",\n\"11-15 m\",\n\"3\",\n\"7-9 m\",\n\"118\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 87,\n 'f': \"87\",\n },\n\"BAUMKATOGD.742832489\",\n\"742832489\",\n\"POINT (16.413619394130336 48.201845376254106)\",\n\"29278\",\n\"magistrat\",\n\"2\",\n\"Rustenschacherallee\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer platanoides (Spitzahorn)\",\n\"2002\",\n\"2002\",\n\"64\",\n\"64 cm\",\n\"3\",\n\"11-15 m\",\n\"2\",\n\"4-6 m\",\n\"3191\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 88,\n 'f': \"88\",\n },\n\"BAUMKATOGD.742832490\",\n\"742832490\",\n\"POINT (16.40888293602997 48.20830102039272)\",\n\"374564\",\n\"magistrat\",\n\"2\",\n\"Hauptallee\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Aesculus hippocastanum (Rosskastanie)\",\n\"2023\",\n\"2023\",\n\"23\",\n\"23 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"4193\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 89,\n 'f': \"89\",\n },\n\"BAUMKATOGD.742832491\",\n\"742832491\",\n\"POINT (16.47565203018013 48.16800671057775)\",\n\"267646\",\n\"magistrat\",\n\"11\",\n\"Zinnergasse\",\n\"Hauptstra\\u00dfe B14\",\n\"Celtis australis (S\\u00fcdlicher Z\\u00fcrgelbaum)\",\n\"2015\",\n\"2015\",\n\"25\",\n\"25 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"1060\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 90,\n 'f': \"90\",\n },\n\"BAUMKATOGD.742832492\",\n\"742832492\",\n\"POINT (16.38329283836026 48.17211618110326)\",\n\"12724\",\n\"magistrat\",\n\"10\",\n\"Steudelgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Fraxinus excelsior (Gemeine Esche)\",\n\"1992\",\n\"1992\",\n\"70\",\n\"70 cm\",\n\"2\",\n\"6-10 m\",\n\"1\",\n\"0-3 m\",\n\"2033\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 91,\n 'f': \"91\",\n },\n\"BAUMKATOGD.742832493\",\n\"742832493\",\n\"POINT (16.322712258188652 48.15922042412994)\",\n\"343205\",\n\"magistrat\",\n\"12\",\n\"12., Parkanlage An den Eisteichen, MA42\",\n\"MA 42 - Parkanlage\",\n\"Carpinus betulus 'Frans Fontaine' (Schlanke S\\u00e4ulenhainbuche)\",\n\"2020\",\n\"2020\",\n\"31\",\n\"31 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"60\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 92,\n 'f': \"92\",\n },\n\"BAUMKATOGD.742832494\",\n\"742832494\",\n\"POINT (16.398399181146473 48.21370796232881)\",\n\"374567\",\n\"magistrat\",\n\"2\",\n\"Hauptallee\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Aesculus hippocastanum (Rosskastanie)\",\n\"2023\",\n\"2023\",\n\"20\",\n\"20 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"5065\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 93,\n 'f': \"93\",\n },\n\"BAUMKATOGD.742832495\",\n\"742832495\",\n\"POINT (16.484060054069765 48.27667111290372)\",\n\"243710\",\n\"magistrat\",\n\"22\",\n\"Wagramer Stra\\u00dfe\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Celtis australis (S\\u00fcdlicher Z\\u00fcrgelbaum)\",\n\"2018\",\n\"2018\",\n\"44\",\n\"44 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"1011\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 94,\n 'f': \"94\",\n },\n\"BAUMKATOGD.742832496\",\n\"742832496\",\n\"POINT (16.38309399569382 48.1716840456067)\",\n\"332240\",\n\"magistrat\",\n\"10\",\n\"Steudelgasse\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Celtis australis (S\\u00fcdlicher Z\\u00fcrgelbaum)\",\n\"2019\",\n\"2019\",\n\"44\",\n\"44 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"2036\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 95,\n 'f': \"95\",\n },\n\"BAUMKATOGD.742832497\",\n\"742832497\",\n\"POINT (16.322439773232073 48.15880274326233)\",\n\"343206\",\n\"magistrat\",\n\"12\",\n\"12., Parkanlage An den Eisteichen, MA42\",\n\"MA 42 - Parkanlage\",\n\"Carpinus betulus 'Frans Fontaine' (Schlanke S\\u00e4ulenhainbuche)\",\n\"2020\",\n\"2020\",\n\"29\",\n\"29 cm\",\n\"2\",\n\"6-10 m\",\n\"1\",\n\"0-3 m\",\n\"66\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 96,\n 'f': \"96\",\n },\n\"BAUMKATOGD.742832498\",\n\"742832498\",\n\"POINT (16.414271910022116 48.20241321681734)\",\n\"29285\",\n\"magistrat\",\n\"2\",\n\"Rustenschacherallee\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Acer platanoides (Spitzahorn)\",\n\"1974\",\n\"1974\",\n\"135\",\n\"135 cm\",\n\"3\",\n\"11-15 m\",\n\"3\",\n\"7-9 m\",\n\"3198\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 97,\n 'f': \"97\",\n },\n\"BAUMKATOGD.742832499\",\n\"742832499\",\n\"POINT (16.48418195149353 48.27670809760198)\",\n\"295651\",\n\"magistrat\",\n\"22\",\n\"Wagramer Stra\\u00dfe\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Pyrus calleryana 'Chanticleer' (Zierbirne)\",\n\"2018\",\n\"2018\",\n\"36\",\n\"36 cm\",\n\"1\",\n\"0-5 m\",\n\"1\",\n\"0-3 m\",\n\"1012\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 98,\n 'f': \"98\",\n },\n\"BAUMKATOGD.742832500\",\n\"742832500\",\n\"POINT (16.4843354038467 48.276755203728975)\",\n\"243711\",\n\"magistrat\",\n\"22\",\n\"Wagramer Stra\\u00dfe\",\n\"MA 28 - Stra\\u00dfe, Gr\\u00fcnanlage\",\n\"Celtis australis (S\\u00fcdlicher Z\\u00fcrgelbaum)\",\n\"2018\",\n\"2018\",\n\"43\",\n\"43 cm\",\n\"1\",\n\"0-5 m\",\n\"2\",\n\"4-6 m\",\n\"1013\",\n{\n 'v': null,\n 'f': \"null\",\n }],\n [{\n 'v': 99,\n 'f': \"99\",\n },\n\"BAUMKATOGD.742832501\",\n\"742832501\",\n\"POINT (16.475675981738746 48.16806414859867)\",\n\"144178\",\n\"magistrat\",\n\"11\",\n\"Zinnergasse\",\n\"Hauptstra\\u00dfe B14\",\n\"Acer platanoides (Spitzahorn)\",\n\"2005\",\n\"2005\",\n\"68\",\n\"68 cm\",\n\"2\",\n\"6-10 m\",\n\"2\",\n\"4-6 m\",\n\"1061\",\n{\n 'v': null,\n 'f': \"null\",\n }]],\n columns: [[\"number\", \"index\"], [\"string\", \"FID\"], [\"string\", \"OBJECTID\"], [\"string\", \"SHAPE\"], [\"string\", \"BAUM_ID\"], [\"string\", \"DATENFUEHRUNG\"], [\"string\", \"BEZIRK\"], [\"string\", \"OBJEKT_STRASSE\"], [\"string\", \"GEBIETSGRUPPE\"], [\"string\", \"GATTUNG_ART\"], [\"string\", \"PFLANZJAHR\"], [\"string\", \"PFLANZJAHR_TXT\"], [\"string\", \"STAMMUMFANG\"], [\"string\", \"STAMMUMFANG_TXT\"], [\"string\", \"BAUMHOEHE\"], [\"string\", \"BAUMHOEHE_TXT\"], [\"string\", \"KRONENDURCHMESSER\"], [\"string\", \"KRONENDURCHMESSER_TXT\"], [\"string\", \"BAUMNUMMER\"], [\"number\", \"SE_ANNO_CAD_DATA\"]],\n columnOptions: [{\"width\": \"1px\", \"className\": \"index_column\"}],\n rowsPerPage: 25,\n helpUrl: \"https://colab.research.google.com/notebooks/data_table.ipynb\",\n suppressOutputScrolling: true,\n minimumWidth: undefined,\n });\n\n function appendQuickchartButton(parentElement) {\n let quickchartButtonContainerElement = document.createElement('div');\n quickchartButtonContainerElement.innerHTML = `\n
\n \n\n\n\n \n
`;\n parentElement.appendChild(quickchartButtonContainerElement);\n }\n\n appendQuickchartButton(table);\n " }, "metadata": {}, "execution_count": 11 } ] }, { "cell_type": "markdown", "metadata": { "id": "V6V_EW6zTSnb" }, "source": [ "## `groupBy` \n", "\n", "Using [pyspark.sql.DataFrame.groupBy](https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/api/pyspark.sql.DataFrame.groupBy.html) show number of different trees (count species/`GATTUNG_ART` names in `df` and sort by count).\n", "\n", "Use `truncate=False` to show the full content of the column `GATTUNG_ART`." ] }, { "cell_type": "code", "execution_count": 12, "metadata": { "id": "tAwknhF-TSnb", "outputId": "0142c894-c597-46cf-836a-f470cb3017a1", "colab": { "base_uri": "https://localhost:8080/" } }, "outputs": [ { "output_type": "stream", "name": "stdout", "text": [ "+-------------------------------------------------+-----+\n", "|GATTUNG_ART |count|\n", "+-------------------------------------------------+-----+\n", "|Acer platanoides (Spitzahorn) |19312|\n", "|Aesculus hippocastanum (Rosskastanie) |11805|\n", "|Celtis australis (Südlicher Zürgelbaum) |9191 |\n", "|Fraxinus excelsior (Gemeine Esche) |8467 |\n", "|Tilia cordata (Winterlinde) |8034 |\n", "|Acer campestre (Feldahorn) |7605 |\n", "|Platanus x acerifolia (Ahornblättrige Platane) |7377 |\n", "|Acer pseudoplatanus (Bergahorn) |7000 |\n", "|Pinus nigra (Schwarzkiefer, Schwarzföhre) |6181 |\n", "|Robinia pseudoacacia (Scheinakazie) |5768 |\n", "|Tilia platyphyllos (Sommerlinde) |5505 |\n", "|Pyrus calleryana 'Chanticleer' (Zierbirne) |3993 |\n", "|Acer platanoides 'Columnare' (Säulenahorn) |3963 |\n", "|Acer campestre 'Elsrijk' (Feldahorn) |3872 |\n", "|Populus nigra (Schwarzpappel) |3773 |\n", "|Jungbaum wird gepflanzt |3720 |\n", "|Sophora japonica (Schnurbaum) |3381 |\n", "|Pinus nigra nigra (Österreichische Schwarzkiefer)|3321 |\n", "|Carpinus betulus (Hainbuche) |3161 |\n", "|Corylus colurna (Baumhasel) |2891 |\n", "+-------------------------------------------------+-----+\n", "only showing top 20 rows\n", "\n" ] } ], "source": [ "df.groupBy(\"GATTUNG_ART\").count().orderBy('count', ascending=False).show(truncate=False)" ] }, { "cell_type": "markdown", "metadata": { "id": "dKB2NJ9hTSnb" }, "source": [ "## Running SQL Queries Programmatically \n", "\n", "An example of SQL query (see [Running SQL Queries Programmatically](https://spark.apache.org/docs/latest/sql-getting-started.html#running-sql-queries-programmatically)): let's sort trees by height (\"Hoehe\").\n", "\n", "`trees` is a local temporary view of `df` (see [pyspark.sql.DataFrame.createOrReplaceTempView](https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/api/pyspark.sql.DataFrame.createOrReplaceTempView.html?highlight=createorreplace#pyspark.sql.DataFrame.createOrReplaceTempView))." ] }, { "cell_type": "code", "execution_count": 13, "metadata": { "id": "vdkkmcm9TSnb" }, "outputs": [], "source": [ "df.createOrReplaceTempView(\"trees\")" ] }, { "cell_type": "code", "execution_count": 14, "metadata": { "id": "h8KcRgMzTSnb", "outputId": "72ead215-9911-4bfc-bd3b-25176b085c63", "colab": { "base_uri": "https://localhost:8080/", "height": 441 } }, "outputs": [ { "output_type": "stream", "name": "stdout", "text": [ "Warning: total number of rows (229231) exceeds max_rows (20000). Falling back to pandas display.\n" ] }, { "output_type": "execute_result", "data": { "text/plain": [ " BAUM_ID GATTUNG_ART BAUMHOEHE \\\n", "0 401554 Jungbaum wird gepflanzt 0 \n", "1 351187 Jungbaum wird gepflanzt 0 \n", "2 401555 Jungbaum wird gepflanzt 0 \n", "3 391210 Jungbaum wird gepflanzt 0 \n", "4 401553 Jungbaum wird gepflanzt 0 \n", "... ... ... ... \n", "229226 384803 Tamarix spec. (Tamariske) 1 \n", "229227 226708 Malus spec. (Apfelbaum) 1 \n", "229228 226716 Prunus serrulata 'Kanzan' (Japanische Blütenki... 1 \n", "229229 226720 Carpinus betulus (Hainbuche) 1 \n", "229230 226723 Carpinus betulus (Hainbuche) 1 \n", "\n", " BAUMHOEHE_TXT BEZIRK \n", "0 nicht bekannt 23 \n", "1 nicht bekannt 20 \n", "2 nicht bekannt 22 \n", "3 nicht bekannt 23 \n", "4 nicht bekannt 23 \n", "... ... ... \n", "229226 0-5 m 5 \n", "229227 0-5 m 19 \n", "229228 0-5 m 19 \n", "229229 0-5 m 19 \n", "229230 0-5 m 19 \n", "\n", "[229231 rows x 5 columns]" ], "text/html": [ "\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
BAUM_IDGATTUNG_ARTBAUMHOEHEBAUMHOEHE_TXTBEZIRK
0401554Jungbaum wird gepflanzt0nicht bekannt23
1351187Jungbaum wird gepflanzt0nicht bekannt20
2401555Jungbaum wird gepflanzt0nicht bekannt22
3391210Jungbaum wird gepflanzt0nicht bekannt23
4401553Jungbaum wird gepflanzt0nicht bekannt23
..................
229226384803Tamarix spec. (Tamariske)10-5 m5
229227226708Malus spec. (Apfelbaum)10-5 m19
229228226716Prunus serrulata 'Kanzan' (Japanische Blütenki...10-5 m19
229229226720Carpinus betulus (Hainbuche)10-5 m19
229230226723Carpinus betulus (Hainbuche)10-5 m19
\n", "

229231 rows × 5 columns

\n", "
\n", "
\n", "\n", "
\n", " \n", "\n", " \n", "\n", " \n", "
\n", "\n", "\n", "
\n", " \n", "\n", "\n", "\n", " \n", "
\n", "\n", "
\n", "
\n" ], "application/vnd.google.colaboratory.intrinsic+json": { "type": "dataframe" } }, "metadata": {}, "execution_count": 14 } ], "source": [ "spark.sql(\"SELECT BAUM_ID, GATTUNG_ART, BAUMHOEHE, BAUMHOEHE_TXT, BEZIRK FROM trees order by BAUMHOEHE_TXT desc\").toPandas()" ] }, { "cell_type": "markdown", "source": [ "### Data cleaning \n", "\n", "This doesn't quite make sense, let us investigate what these `BAUMHOEHE` and `BAUMHOEHE_TXT` columns contain.\n", "\n", "💡 Making sense of \"dirty data\" is called _data cleansing_ or _data cleaning_. This process involves identifying and correcting or removing errors, inconsistencies, and inaccuracies in a dataset to make it accurate, complete, and consistent." ], "metadata": { "id": "JLMlayQyjYJL" } }, { "cell_type": "code", "source": [ "spark.sql(\"SELECT distinct BAUMHOEHE, BAUMHOEHE_TXT from trees order by BAUMHOEHE asc\").toPandas()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 656 }, "id": "FRRdBYUsggmF", "outputId": "f3fdfc9a-f6e7-4ef2-bf7b-ecd99871a8dd" }, "execution_count": 15, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " BAUMHOEHE BAUMHOEHE_TXT\n", "0 0 nicht bekannt\n", "1 1 0-5 m\n", "2 102 cm 3\n", "3 116 cm 3\n", "4 117 cm 3\n", "5 134 cm 2\n", "6 145 cm 4\n", "7 177 cm 3\n", "8 2 6-10 m\n", "9 29 cm 1\n", "10 3 11-15 m\n", "11 4 16-20 m\n", "12 5 21-25 m\n", "13 50 cm 1\n", "14 52 cm 2\n", "15 55 cm 2\n", "16 58 cm 2\n", "17 59 cm 2\n", "18 6 26-30 m\n", "19 62 cm 2\n", "20 63 cm 2\n", "21 65 cm 2\n", "22 68 cm 3\n", "23 68 cm 2\n", "24 7 31-35 m\n", "25 73 cm 2\n", "26 76 cm 2\n", "27 78 cm 3\n", "28 8 > 35 m\n", "29 86 cm 2\n", "30 86 cm 3\n", "31 92 cm 2" ], "text/html": [ "\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
BAUMHOEHEBAUMHOEHE_TXT
00nicht bekannt
110-5 m
2102 cm3
3116 cm3
4117 cm3
5134 cm2
6145 cm4
7177 cm3
826-10 m
929 cm1
10311-15 m
11416-20 m
12521-25 m
1350 cm1
1452 cm2
1555 cm2
1658 cm2
1759 cm2
18626-30 m
1962 cm2
2063 cm2
2165 cm2
2268 cm3
2368 cm2
24731-35 m
2573 cm2
2676 cm2
2778 cm3
288> 35 m
2986 cm2
3086 cm3
3192 cm2
\n", "
\n", "
\n", "\n", "
\n", " \n", "\n", " \n", "\n", " \n", "
\n", "\n", "\n", "
\n", " \n", "\n", "\n", "\n", " \n", "
\n", "\n", "
\n", "
\n" ], "application/vnd.google.colaboratory.intrinsic+json": { "type": "dataframe", "summary": "{\n \"name\": \"spark\",\n \"rows\": 32,\n \"fields\": [\n {\n \"column\": \"BAUMHOEHE\",\n \"properties\": {\n \"dtype\": \"string\",\n \"num_unique_values\": 30,\n \"samples\": [\n \"8\",\n \"55 cm\",\n \"7\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"BAUMHOEHE_TXT\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 13,\n \"samples\": [\n \"31-35 m\",\n \"21-25 m\",\n \"nicht bekannt\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n }\n ]\n}" }, "application/vnd.google.colaboratory.module+javascript": "\n import \"https://ssl.gstatic.com/colaboratory/data_table/9e65f7085e7ffcb7/data_table.js\";\n\n const table = window.createDataTable({\n data: [[{\n 'v': 0,\n 'f': \"0\",\n },\n\"0\",\n\"nicht bekannt\"],\n [{\n 'v': 1,\n 'f': \"1\",\n },\n\"1\",\n\"0-5 m\"],\n [{\n 'v': 2,\n 'f': \"2\",\n },\n\"102 cm\",\n\"3\"],\n [{\n 'v': 3,\n 'f': \"3\",\n },\n\"116 cm\",\n\"3\"],\n [{\n 'v': 4,\n 'f': \"4\",\n },\n\"117 cm\",\n\"3\"],\n [{\n 'v': 5,\n 'f': \"5\",\n },\n\"134 cm\",\n\"2\"],\n [{\n 'v': 6,\n 'f': \"6\",\n },\n\"145 cm\",\n\"4\"],\n [{\n 'v': 7,\n 'f': \"7\",\n },\n\"177 cm\",\n\"3\"],\n [{\n 'v': 8,\n 'f': \"8\",\n },\n\"2\",\n\"6-10 m\"],\n [{\n 'v': 9,\n 'f': \"9\",\n },\n\"29 cm\",\n\"1\"],\n [{\n 'v': 10,\n 'f': \"10\",\n },\n\"3\",\n\"11-15 m\"],\n [{\n 'v': 11,\n 'f': \"11\",\n },\n\"4\",\n\"16-20 m\"],\n [{\n 'v': 12,\n 'f': \"12\",\n },\n\"5\",\n\"21-25 m\"],\n [{\n 'v': 13,\n 'f': \"13\",\n },\n\"50 cm\",\n\"1\"],\n [{\n 'v': 14,\n 'f': \"14\",\n },\n\"52 cm\",\n\"2\"],\n [{\n 'v': 15,\n 'f': \"15\",\n },\n\"55 cm\",\n\"2\"],\n [{\n 'v': 16,\n 'f': \"16\",\n },\n\"58 cm\",\n\"2\"],\n [{\n 'v': 17,\n 'f': \"17\",\n },\n\"59 cm\",\n\"2\"],\n [{\n 'v': 18,\n 'f': \"18\",\n },\n\"6\",\n\"26-30 m\"],\n [{\n 'v': 19,\n 'f': \"19\",\n },\n\"62 cm\",\n\"2\"],\n [{\n 'v': 20,\n 'f': \"20\",\n },\n\"63 cm\",\n\"2\"],\n [{\n 'v': 21,\n 'f': \"21\",\n },\n\"65 cm\",\n\"2\"],\n [{\n 'v': 22,\n 'f': \"22\",\n },\n\"68 cm\",\n\"3\"],\n [{\n 'v': 23,\n 'f': \"23\",\n },\n\"68 cm\",\n\"2\"],\n [{\n 'v': 24,\n 'f': \"24\",\n },\n\"7\",\n\"31-35 m\"],\n [{\n 'v': 25,\n 'f': \"25\",\n },\n\"73 cm\",\n\"2\"],\n [{\n 'v': 26,\n 'f': \"26\",\n },\n\"76 cm\",\n\"2\"],\n [{\n 'v': 27,\n 'f': \"27\",\n },\n\"78 cm\",\n\"3\"],\n [{\n 'v': 28,\n 'f': \"28\",\n },\n\"8\",\n\"> 35 m\"],\n [{\n 'v': 29,\n 'f': \"29\",\n },\n\"86 cm\",\n\"2\"],\n [{\n 'v': 30,\n 'f': \"30\",\n },\n\"86 cm\",\n\"3\"],\n [{\n 'v': 31,\n 'f': \"31\",\n },\n\"92 cm\",\n\"2\"]],\n columns: [[\"number\", \"index\"], [\"string\", \"BAUMHOEHE\"], [\"string\", \"BAUMHOEHE_TXT\"]],\n columnOptions: [{\"width\": \"1px\", \"className\": \"index_column\"}],\n rowsPerPage: 25,\n helpUrl: \"https://colab.research.google.com/notebooks/data_table.ipynb\",\n suppressOutputScrolling: true,\n minimumWidth: undefined,\n });\n\n function appendQuickchartButton(parentElement) {\n let quickchartButtonContainerElement = document.createElement('div');\n quickchartButtonContainerElement.innerHTML = `\n
\n \n\n\n\n \n
`;\n parentElement.appendChild(quickchartButtonContainerElement);\n }\n\n appendQuickchartButton(table);\n " }, "metadata": {}, "execution_count": 15 } ] }, { "cell_type": "markdown", "metadata": { "id": "W0QvtwRpTSnc" }, "source": [ "It looks like there was an attempt to map different heights (`BAUMHOEHE`) to height categories where `BAUMHOEHE_TXT` is a number from $0$ to $8$:\n", " - `0`: unknown height\n", " - `1`: 0-5m\n", " - `2` 6-10m\n", " - `3`: 11-15m\n", " - `4`: 16-20m\n", " - `5`: 21-25m\n", " - `6`: 26-30m\n", " - `7`: 31-35m\n", " - `8`: >35m\n", "\n", " But for a few trees these columns don't seem to make much sense." ] }, { "cell_type": "code", "source": [ "spark.sql(\"SELECT BAUMHOEHE, BAUMHOEHE_TXT, count(BAUM_ID) from trees group by BAUMHOEHE, BAUMHOEHE_TXT sort by count(BAUM_ID) desc\").show()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "bovcyLCBoAr5", "outputId": "ebcf3d85-9afd-49e8-f903-f9b3c1a6ebad" }, "execution_count": 16, "outputs": [ { "output_type": "stream", "name": "stdout", "text": [ "+---------+-------------+--------------+\n", "|BAUMHOEHE|BAUMHOEHE_TXT|count(BAUM_ID)|\n", "+---------+-------------+--------------+\n", "| 2| 6-10 m| 81407|\n", "| 1| 0-5 m| 62924|\n", "| 3| 11-15 m| 55737|\n", "| 4| 16-20 m| 18304|\n", "| 5| 21-25 m| 4978|\n", "| 0|nicht bekannt| 4448|\n", "| 6| 26-30 m| 1284|\n", "| 7| 31-35 m| 110|\n", "| 8| > 35 m| 14|\n", "| 86 cm| 2| 2|\n", "| 76 cm| 2| 2|\n", "| 55 cm| 2| 1|\n", "| 134 cm| 2| 1|\n", "| 145 cm| 4| 1|\n", "| 58 cm| 2| 1|\n", "| 68 cm| 3| 1|\n", "| 73 cm| 2| 1|\n", "| 117 cm| 3| 1|\n", "| 65 cm| 2| 1|\n", "| 78 cm| 3| 1|\n", "+---------+-------------+--------------+\n", "only showing top 20 rows\n", "\n" ] } ] }, { "cell_type": "code", "source": [ "spark.sql(\"SELECT BAUMHOEHE, BAUMHOEHE_TXT, count(BAUM_ID) from trees where BAUMHOEHE RLIKE '^[0-8]$' group by BAUMHOEHE, BAUMHOEHE_TXT sort by count(BAUM_ID) desc\").show()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "vn11R7hZpF3F", "outputId": "a8a3f45f-a921-4171-e250-38f19cc84eb7" }, "execution_count": 17, "outputs": [ { "output_type": "stream", "name": "stdout", "text": [ "+---------+-------------+--------------+\n", "|BAUMHOEHE|BAUMHOEHE_TXT|count(BAUM_ID)|\n", "+---------+-------------+--------------+\n", "| 2| 6-10 m| 81407|\n", "| 1| 0-5 m| 62924|\n", "| 3| 11-15 m| 55737|\n", "| 4| 16-20 m| 18304|\n", "| 5| 21-25 m| 4978|\n", "| 0|nicht bekannt| 4448|\n", "| 6| 26-30 m| 1284|\n", "| 7| 31-35 m| 110|\n", "| 8| > 35 m| 14|\n", "+---------+-------------+--------------+\n", "\n" ] } ] }, { "cell_type": "markdown", "source": [ "We can just ignore these few trees (there's just $25$ of them) that have the incorrectly formatted `BAUMHOEHE`. These trees are all in the same location and apparently also the `GATTUNG_ART` and `PFLANZJAHR` entries for these trees are incorrect." ], "metadata": { "id": "2YrV0nS-p6j8" } }, { "cell_type": "code", "source": [ "spark.sql(\"SELECT BAUM_ID, BAUMHOEHE, BAUMHOEHE_TXT, GATTUNG_ART, PFLANZJAHR, BEZIRK, OBJEKT_STRASSE from trees where not BAUMHOEHE RLIKE '^[0-8]$'\").toPandas()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 646 }, "id": "RE-kqe8HpqdM", "outputId": "a750b43f-5a0e-4589-c843-21caef9ad212" }, "execution_count": 18, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " BAUM_ID BAUMHOEHE BAUMHOEHE_TXT GATTUNG_ART \\\n", "0 315066 68 cm 3 Diverse \n", "1 286030 50 cm 1 Diverse \n", "2 286040 59 cm 2 Diverse \n", "3 315064 102 cm 3 Diverse \n", "4 315071 116 cm 3 Diverse \n", "5 330854 29 cm 1 Diverse \n", "6 286029 177 cm 3 Diverse \n", "7 286033 52 cm 2 Diverse \n", "8 286034 68 cm 2 Diverse \n", "9 286041 62 cm 2 Diverse \n", "10 286042 145 cm 4 Diverse \n", "11 315063 86 cm 3 Diverse \n", "12 315065 117 cm 3 Diverse \n", "13 389464 63 cm 2 Diverse \n", "14 315067 78 cm 3 Diverse \n", "15 315068 134 cm 2 Diverse \n", "16 315069 55 cm 2 Diverse \n", "17 315070 58 cm 2 Diverse \n", "18 286036 92 cm 2 Diverse \n", "19 286037 86 cm 2 Diverse \n", "20 286038 86 cm 2 Diverse \n", "21 286039 65 cm 2 Diverse \n", "22 286031 76 cm 2 Diverse \n", "23 286032 76 cm 2 Diverse \n", "24 286035 73 cm 2 Diverse \n", "\n", " PFLANZJAHR BEZIRK \\\n", "0 Robinia pseudoacacia (Scheinakazie) 10 \n", "1 Morus nigra (Schwarzer Maulbeerbaum) 10 \n", "2 Pyrus calleryana 'Chanticleer' (Zierbirne) 10 \n", "3 Robinia pseudoacacia (Scheinakazie) 10 \n", "4 Prunus avium (Vogelkirsche) 10 \n", "5 Pyrus calleryana 'Aristocrat' (Zierbirne) 10 \n", "6 Populus nigra 'Italica' (Pyramidenpappel) 10 \n", "7 Pyrus calleryana 'Chanticleer' (Zierbirne) 10 \n", "8 Pyrus calleryana 'Chanticleer' (Zierbirne) 10 \n", "9 Pyrus calleryana 'Chanticleer' (Zierbirne) 10 \n", "10 Populus nigra 'Italica' (Pyramidenpappel) 10 \n", "11 Robinia pseudoacacia (Scheinakazie) 10 \n", "12 Populus x canescens (Graupappel) 10 \n", "13 Populus x canescens (Graupappel) 10 \n", "14 Robinia pseudoacacia (Scheinakazie) 10 \n", "15 Robinia pseudoacacia (Scheinakazie) 10 \n", "16 Robinia pseudoacacia (Scheinakazie) 10 \n", "17 Robinia pseudoacacia (Scheinakazie) 10 \n", "18 Acer campestre (Feldahorn) 10 \n", "19 Acer campestre (Feldahorn) 10 \n", "20 Acer campestre (Feldahorn) 10 \n", "21 Acer campestre (Feldahorn) 10 \n", "22 Morus nigra (Schwarzer Maulbeerbaum) 10 \n", "23 Acer campestre (Feldahorn) 10 \n", "24 Acer campestre (Feldahorn) 10 \n", "\n", " OBJEKT_STRASSE \n", "0 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "1 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "2 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "3 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "4 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "5 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "6 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "7 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "8 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "9 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "10 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "11 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "12 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "13 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "14 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "15 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "16 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "17 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "18 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "19 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "20 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "21 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "22 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "23 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" \n", "24 \"10., Monte Laa Wiesenfläche \"\"Dreieck\"\" " ], "text/html": [ "\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
BAUM_IDBAUMHOEHEBAUMHOEHE_TXTGATTUNG_ARTPFLANZJAHRBEZIRKOBJEKT_STRASSE
031506668 cm3DiverseRobinia pseudoacacia (Scheinakazie)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
128603050 cm1DiverseMorus nigra (Schwarzer Maulbeerbaum)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
228604059 cm2DiversePyrus calleryana 'Chanticleer' (Zierbirne)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
3315064102 cm3DiverseRobinia pseudoacacia (Scheinakazie)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
4315071116 cm3DiversePrunus avium (Vogelkirsche)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
533085429 cm1DiversePyrus calleryana 'Aristocrat' (Zierbirne)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
6286029177 cm3DiversePopulus nigra 'Italica' (Pyramidenpappel)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
728603352 cm2DiversePyrus calleryana 'Chanticleer' (Zierbirne)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
828603468 cm2DiversePyrus calleryana 'Chanticleer' (Zierbirne)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
928604162 cm2DiversePyrus calleryana 'Chanticleer' (Zierbirne)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
10286042145 cm4DiversePopulus nigra 'Italica' (Pyramidenpappel)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
1131506386 cm3DiverseRobinia pseudoacacia (Scheinakazie)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
12315065117 cm3DiversePopulus x canescens (Graupappel)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
1338946463 cm2DiversePopulus x canescens (Graupappel)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
1431506778 cm3DiverseRobinia pseudoacacia (Scheinakazie)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
15315068134 cm2DiverseRobinia pseudoacacia (Scheinakazie)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
1631506955 cm2DiverseRobinia pseudoacacia (Scheinakazie)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
1731507058 cm2DiverseRobinia pseudoacacia (Scheinakazie)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
1828603692 cm2DiverseAcer campestre (Feldahorn)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
1928603786 cm2DiverseAcer campestre (Feldahorn)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
2028603886 cm2DiverseAcer campestre (Feldahorn)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
2128603965 cm2DiverseAcer campestre (Feldahorn)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
2228603176 cm2DiverseMorus nigra (Schwarzer Maulbeerbaum)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
2328603276 cm2DiverseAcer campestre (Feldahorn)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
2428603573 cm2DiverseAcer campestre (Feldahorn)10\"10., Monte Laa Wiesenfläche \"\"Dreieck\"\"
\n", "
\n", "
\n", "\n", "
\n", " \n", "\n", " \n", "\n", " \n", "
\n", "\n", "\n", "
\n", " \n", "\n", "\n", "\n", " \n", "
\n", "\n", "
\n", "
\n" ], "application/vnd.google.colaboratory.intrinsic+json": { "type": "dataframe", "summary": "{\n \"name\": \"spark\",\n \"rows\": 25,\n \"fields\": [\n {\n \"column\": \"BAUM_ID\",\n \"properties\": {\n \"dtype\": \"string\",\n \"num_unique_values\": 25,\n \"samples\": [\n \"286034\",\n \"315069\",\n \"315066\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"BAUMHOEHE\",\n \"properties\": {\n \"dtype\": \"string\",\n \"num_unique_values\": 21,\n \"samples\": [\n \"68 cm\",\n \"92 cm\",\n \"55 cm\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"BAUMHOEHE_TXT\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 4,\n \"samples\": [\n \"1\",\n \"4\",\n \"3\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"GATTUNG_ART\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 1,\n \"samples\": [\n \"Diverse\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"PFLANZJAHR\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 8,\n \"samples\": [\n \"Morus nigra (Schwarzer Maulbeerbaum)\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"BEZIRK\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 1,\n \"samples\": [\n \"10\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"OBJEKT_STRASSE\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 1,\n \"samples\": [\n \"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n }\n ]\n}" }, "application/vnd.google.colaboratory.module+javascript": "\n import \"https://ssl.gstatic.com/colaboratory/data_table/9e65f7085e7ffcb7/data_table.js\";\n\n const table = window.createDataTable({\n data: [[{\n 'v': 0,\n 'f': \"0\",\n },\n\"315066\",\n\"68 cm\",\n\"3\",\n\"Diverse\",\n\"Robinia pseudoacacia (Scheinakazie)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 1,\n 'f': \"1\",\n },\n\"286030\",\n\"50 cm\",\n\"1\",\n\"Diverse\",\n\"Morus nigra (Schwarzer Maulbeerbaum)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 2,\n 'f': \"2\",\n },\n\"286040\",\n\"59 cm\",\n\"2\",\n\"Diverse\",\n\"Pyrus calleryana 'Chanticleer' (Zierbirne)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 3,\n 'f': \"3\",\n },\n\"315064\",\n\"102 cm\",\n\"3\",\n\"Diverse\",\n\"Robinia pseudoacacia (Scheinakazie)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 4,\n 'f': \"4\",\n },\n\"315071\",\n\"116 cm\",\n\"3\",\n\"Diverse\",\n\"Prunus avium (Vogelkirsche)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 5,\n 'f': \"5\",\n },\n\"330854\",\n\"29 cm\",\n\"1\",\n\"Diverse\",\n\"Pyrus calleryana 'Aristocrat' (Zierbirne)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 6,\n 'f': \"6\",\n },\n\"286029\",\n\"177 cm\",\n\"3\",\n\"Diverse\",\n\"Populus nigra 'Italica' (Pyramidenpappel)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 7,\n 'f': \"7\",\n },\n\"286033\",\n\"52 cm\",\n\"2\",\n\"Diverse\",\n\"Pyrus calleryana 'Chanticleer' (Zierbirne)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 8,\n 'f': \"8\",\n },\n\"286034\",\n\"68 cm\",\n\"2\",\n\"Diverse\",\n\"Pyrus calleryana 'Chanticleer' (Zierbirne)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 9,\n 'f': \"9\",\n },\n\"286041\",\n\"62 cm\",\n\"2\",\n\"Diverse\",\n\"Pyrus calleryana 'Chanticleer' (Zierbirne)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 10,\n 'f': \"10\",\n },\n\"286042\",\n\"145 cm\",\n\"4\",\n\"Diverse\",\n\"Populus nigra 'Italica' (Pyramidenpappel)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 11,\n 'f': \"11\",\n },\n\"315063\",\n\"86 cm\",\n\"3\",\n\"Diverse\",\n\"Robinia pseudoacacia (Scheinakazie)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 12,\n 'f': \"12\",\n },\n\"315065\",\n\"117 cm\",\n\"3\",\n\"Diverse\",\n\"Populus x canescens (Graupappel)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 13,\n 'f': \"13\",\n },\n\"389464\",\n\"63 cm\",\n\"2\",\n\"Diverse\",\n\"Populus x canescens (Graupappel)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 14,\n 'f': \"14\",\n },\n\"315067\",\n\"78 cm\",\n\"3\",\n\"Diverse\",\n\"Robinia pseudoacacia (Scheinakazie)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 15,\n 'f': \"15\",\n },\n\"315068\",\n\"134 cm\",\n\"2\",\n\"Diverse\",\n\"Robinia pseudoacacia (Scheinakazie)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 16,\n 'f': \"16\",\n },\n\"315069\",\n\"55 cm\",\n\"2\",\n\"Diverse\",\n\"Robinia pseudoacacia (Scheinakazie)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 17,\n 'f': \"17\",\n },\n\"315070\",\n\"58 cm\",\n\"2\",\n\"Diverse\",\n\"Robinia pseudoacacia (Scheinakazie)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 18,\n 'f': \"18\",\n },\n\"286036\",\n\"92 cm\",\n\"2\",\n\"Diverse\",\n\"Acer campestre (Feldahorn)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 19,\n 'f': \"19\",\n },\n\"286037\",\n\"86 cm\",\n\"2\",\n\"Diverse\",\n\"Acer campestre (Feldahorn)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 20,\n 'f': \"20\",\n },\n\"286038\",\n\"86 cm\",\n\"2\",\n\"Diverse\",\n\"Acer campestre (Feldahorn)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 21,\n 'f': \"21\",\n },\n\"286039\",\n\"65 cm\",\n\"2\",\n\"Diverse\",\n\"Acer campestre (Feldahorn)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 22,\n 'f': \"22\",\n },\n\"286031\",\n\"76 cm\",\n\"2\",\n\"Diverse\",\n\"Morus nigra (Schwarzer Maulbeerbaum)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 23,\n 'f': \"23\",\n },\n\"286032\",\n\"76 cm\",\n\"2\",\n\"Diverse\",\n\"Acer campestre (Feldahorn)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"],\n [{\n 'v': 24,\n 'f': \"24\",\n },\n\"286035\",\n\"73 cm\",\n\"2\",\n\"Diverse\",\n\"Acer campestre (Feldahorn)\",\n\"10\",\n\"\\\"10., Monte Laa Wiesenfl\\u00e4che \\\"\\\"Dreieck\\\"\\\"\"]],\n columns: [[\"number\", \"index\"], [\"string\", \"BAUM_ID\"], [\"string\", \"BAUMHOEHE\"], [\"string\", \"BAUMHOEHE_TXT\"], [\"string\", \"GATTUNG_ART\"], [\"string\", \"PFLANZJAHR\"], [\"string\", \"BEZIRK\"], [\"string\", \"OBJEKT_STRASSE\"]],\n columnOptions: [{\"width\": \"1px\", \"className\": \"index_column\"}],\n rowsPerPage: 25,\n helpUrl: \"https://colab.research.google.com/notebooks/data_table.ipynb\",\n suppressOutputScrolling: true,\n minimumWidth: undefined,\n });\n\n function appendQuickchartButton(parentElement) {\n let quickchartButtonContainerElement = document.createElement('div');\n quickchartButtonContainerElement.innerHTML = `\n
\n \n\n\n\n \n
`;\n parentElement.appendChild(quickchartButtonContainerElement);\n }\n\n appendQuickchartButton(table);\n " }, "metadata": {}, "execution_count": 18 } ] }, { "cell_type": "markdown", "source": [ "Let us filter out these $25$ trees from the original dataframe using\n", "\n", "[`pyspark.sql.DataFrame.filter`](https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/api/pyspark.sql.DataFrame.filter.html)" ], "metadata": { "id": "eVjZKC38r35n" } }, { "cell_type": "code", "source": [ "df.filter(\"BAUMHOEHE NOT RLIKE '^[0-8]$'\").count()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "8qSU8qwZr4FR", "outputId": "da77c3ce-4cb0-4f01-f0de-9540aa05df52" }, "execution_count": 19, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "25" ] }, "metadata": {}, "execution_count": 19 } ] }, { "cell_type": "code", "source": [ "df = df.filter(\"BAUMHOEHE RLIKE '^[0-8]$'\")" ], "metadata": { "id": "uaCj15INtFPA" }, "execution_count": 20, "outputs": [] }, { "cell_type": "code", "source": [ "df.count()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/" }, "id": "kzpK3iP7tJKQ", "outputId": "a4937321-f7d7-4445-d5e9-90202cc9f1d9" }, "execution_count": 21, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "229206" ] }, "metadata": {}, "execution_count": 21 } ] }, { "cell_type": "markdown", "source": [ "The temporary view `trees` needs to be updated." ], "metadata": { "id": "dbMIBpQeuiLu" } }, { "cell_type": "code", "source": [ "df.createOrReplaceTempView(\"trees\")\n", "spark.sql(\"SELECT BAUM_ID, BAUMHOEHE, BAUMHOEHE_TXT, GATTUNG_ART, PFLANZJAHR, BEZIRK, OBJEKT_STRASSE from trees where not BAUMHOEHE RLIKE '^[0-8]$'\").toPandas()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 119 }, "id": "ZkixdYIttaqi", "outputId": "43341ba4-f843-4cfe-c938-b1f67e69815e" }, "execution_count": 22, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "Empty DataFrame\n", "Columns: [BAUM_ID, BAUMHOEHE, BAUMHOEHE_TXT, GATTUNG_ART, PFLANZJAHR, BEZIRK, OBJEKT_STRASSE]\n", "Index: []" ], "text/html": [ "\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
BAUM_IDBAUMHOEHEBAUMHOEHE_TXTGATTUNG_ARTPFLANZJAHRBEZIRKOBJEKT_STRASSE
\n", "
\n", "
\n", "\n", "
\n", " \n", "\n", " \n", "\n", " \n", "
\n", "\n", "\n", "
\n", "
\n" ], "application/vnd.google.colaboratory.intrinsic+json": { "type": "dataframe", "repr_error": "Out of range float values are not JSON compliant: nan" }, "application/vnd.google.colaboratory.module+javascript": "\n import \"https://ssl.gstatic.com/colaboratory/data_table/9e65f7085e7ffcb7/data_table.js\";\n\n const table = window.createDataTable({\n data: [],\n columns: [[\"number\", \"index\"], [\"number\", \"BAUM_ID\"], [\"number\", \"BAUMHOEHE\"], [\"number\", \"BAUMHOEHE_TXT\"], [\"number\", \"GATTUNG_ART\"], [\"number\", \"PFLANZJAHR\"], [\"number\", \"BEZIRK\"], [\"number\", \"OBJEKT_STRASSE\"]],\n columnOptions: [{\"width\": \"1px\", \"className\": \"index_column\"}],\n rowsPerPage: 25,\n helpUrl: \"https://colab.research.google.com/notebooks/data_table.ipynb\",\n suppressOutputScrolling: true,\n minimumWidth: undefined,\n });\n\n function appendQuickchartButton(parentElement) {\n let quickchartButtonContainerElement = document.createElement('div');\n quickchartButtonContainerElement.innerHTML = `\n
\n \n\n\n\n \n
`;\n parentElement.appendChild(quickchartButtonContainerElement);\n }\n\n appendQuickchartButton(table);\n " }, "metadata": {}, "execution_count": 22 } ] }, { "cell_type": "markdown", "source": [ "We can now show trees sorted by their height category (`BAUMHOEHE`)." ], "metadata": { "id": "Yrlm_7Xwuyn-" } }, { "cell_type": "code", "source": [ "spark.sql(\"SELECT BAUMHOEHE, BAUMHOEHE_TXT, count(*) as COUNT from trees group by BAUMHOEHE, BAUMHOEHE_TXT sort by BAUMHOEHE desc\").toPandas()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 309 }, "id": "jf7Bgcwwv4eD", "outputId": "bc19d8e9-10d3-4537-b3b6-3ecfa243b3b5" }, "execution_count": 23, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " BAUMHOEHE BAUMHOEHE_TXT COUNT\n", "0 8 > 35 m 14\n", "1 7 31-35 m 110\n", "2 6 26-30 m 1284\n", "3 5 21-25 m 4978\n", "4 4 16-20 m 18304\n", "5 3 11-15 m 55737\n", "6 2 6-10 m 81407\n", "7 1 0-5 m 62924\n", "8 0 nicht bekannt 4448" ], "text/html": [ "\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
BAUMHOEHEBAUMHOEHE_TXTCOUNT
08> 35 m14
1731-35 m110
2626-30 m1284
3521-25 m4978
4416-20 m18304
5311-15 m55737
626-10 m81407
710-5 m62924
80nicht bekannt4448
\n", "
\n", "
\n", "\n", "
\n", " \n", "\n", " \n", "\n", " \n", "
\n", "\n", "\n", "
\n", " \n", "\n", "\n", "\n", " \n", "
\n", "\n", "
\n", "
\n" ], "application/vnd.google.colaboratory.intrinsic+json": { "type": "dataframe", "summary": "{\n \"name\": \"spark\",\n \"rows\": 9,\n \"fields\": [\n {\n \"column\": \"BAUMHOEHE\",\n \"properties\": {\n \"dtype\": \"string\",\n \"num_unique_values\": 9,\n \"samples\": [\n \"1\",\n \"7\",\n \"3\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"BAUMHOEHE_TXT\",\n \"properties\": {\n \"dtype\": \"string\",\n \"num_unique_values\": 9,\n \"samples\": [\n \"0-5 m\",\n \"31-35 m\",\n \"11-15 m\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"COUNT\",\n \"properties\": {\n \"dtype\": \"number\",\n \"std\": 32088,\n \"min\": 14,\n \"max\": 81407,\n \"num_unique_values\": 9,\n \"samples\": [\n 62924,\n 110,\n 55737\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n }\n ]\n}" }, "application/vnd.google.colaboratory.module+javascript": "\n import \"https://ssl.gstatic.com/colaboratory/data_table/9e65f7085e7ffcb7/data_table.js\";\n\n const table = window.createDataTable({\n data: [[{\n 'v': 0,\n 'f': \"0\",\n },\n\"8\",\n\"> 35 m\",\n{\n 'v': 14,\n 'f': \"14\",\n }],\n [{\n 'v': 1,\n 'f': \"1\",\n },\n\"7\",\n\"31-35 m\",\n{\n 'v': 110,\n 'f': \"110\",\n }],\n [{\n 'v': 2,\n 'f': \"2\",\n },\n\"6\",\n\"26-30 m\",\n{\n 'v': 1284,\n 'f': \"1284\",\n }],\n [{\n 'v': 3,\n 'f': \"3\",\n },\n\"5\",\n\"21-25 m\",\n{\n 'v': 4978,\n 'f': \"4978\",\n }],\n [{\n 'v': 4,\n 'f': \"4\",\n },\n\"4\",\n\"16-20 m\",\n{\n 'v': 18304,\n 'f': \"18304\",\n }],\n [{\n 'v': 5,\n 'f': \"5\",\n },\n\"3\",\n\"11-15 m\",\n{\n 'v': 55737,\n 'f': \"55737\",\n }],\n [{\n 'v': 6,\n 'f': \"6\",\n },\n\"2\",\n\"6-10 m\",\n{\n 'v': 81407,\n 'f': \"81407\",\n }],\n [{\n 'v': 7,\n 'f': \"7\",\n },\n\"1\",\n\"0-5 m\",\n{\n 'v': 62924,\n 'f': \"62924\",\n }],\n [{\n 'v': 8,\n 'f': \"8\",\n },\n\"0\",\n\"nicht bekannt\",\n{\n 'v': 4448,\n 'f': \"4448\",\n }]],\n columns: [[\"number\", \"index\"], [\"string\", \"BAUMHOEHE\"], [\"string\", \"BAUMHOEHE_TXT\"], [\"number\", \"COUNT\"]],\n columnOptions: [{\"width\": \"1px\", \"className\": \"index_column\"}],\n rowsPerPage: 25,\n helpUrl: \"https://colab.research.google.com/notebooks/data_table.ipynb\",\n suppressOutputScrolling: true,\n minimumWidth: undefined,\n });\n\n function appendQuickchartButton(parentElement) {\n let quickchartButtonContainerElement = document.createElement('div');\n quickchartButtonContainerElement.innerHTML = `\n
\n \n\n\n\n \n
`;\n parentElement.appendChild(quickchartButtonContainerElement);\n }\n\n appendQuickchartButton(table);\n " }, "metadata": {}, "execution_count": 23 } ] }, { "cell_type": "markdown", "source": [ "## Some data exploration " ], "metadata": { "id": "pE1FnLlb1fcS" } }, { "cell_type": "markdown", "source": [ "What species are the tallest trees?" ], "metadata": { "id": "YXBTC90FwYMR" } }, { "cell_type": "code", "source": [ "spark.sql(\"SELECT BAUMHOEHE, BAUMHOEHE_TXT, GATTUNG_ART, count(*) as COUNT from trees where BAUMHOEHE=8 group by BAUMHOEHE, BAUMHOEHE_TXT, GATTUNG_ART sort by COUNT desc\").toPandas()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 245 }, "id": "Q7MhDqE8kLIt", "outputId": "e9853996-d6be-408e-af31-9a8251a9c0d7" }, "execution_count": 24, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " BAUMHOEHE BAUMHOEHE_TXT GATTUNG_ART \\\n", "0 8 > 35 m Populus nigra 'Italica' (Pyramidenpappel) \n", "1 8 > 35 m Fraxinus excelsior (Gemeine Esche) \n", "2 8 > 35 m Populus nigra (Schwarzpappel) \n", "3 8 > 35 m Platanus x acerifolia (Ahornblättrige Platane) \n", "4 8 > 35 m Acer platanoides (Spitzahorn) \n", "5 8 > 35 m Tilia tomentosa 'Brabant' (Silberlinde) \n", "\n", " COUNT \n", "0 7 \n", "1 2 \n", "2 2 \n", "3 1 \n", "4 1 \n", "5 1 " ], "text/html": [ "\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
BAUMHOEHEBAUMHOEHE_TXTGATTUNG_ARTCOUNT
08> 35 mPopulus nigra 'Italica' (Pyramidenpappel)7
18> 35 mFraxinus excelsior (Gemeine Esche)2
28> 35 mPopulus nigra (Schwarzpappel)2
38> 35 mPlatanus x acerifolia (Ahornblättrige Platane)1
48> 35 mAcer platanoides (Spitzahorn)1
58> 35 mTilia tomentosa 'Brabant' (Silberlinde)1
\n", "
\n", "
\n", "\n", "
\n", " \n", "\n", " \n", "\n", " \n", "
\n", "\n", "\n", "
\n", " \n", "\n", "\n", "\n", " \n", "
\n", "\n", "
\n", "
\n" ], "application/vnd.google.colaboratory.intrinsic+json": { "type": "dataframe", "summary": "{\n \"name\": \"spark\",\n \"rows\": 6,\n \"fields\": [\n {\n \"column\": \"BAUMHOEHE\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 1,\n \"samples\": [\n \"8\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"BAUMHOEHE_TXT\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 1,\n \"samples\": [\n \"> 35 m\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"GATTUNG_ART\",\n \"properties\": {\n \"dtype\": \"string\",\n \"num_unique_values\": 6,\n \"samples\": [\n \"Populus nigra 'Italica' (Pyramidenpappel)\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"COUNT\",\n \"properties\": {\n \"dtype\": \"number\",\n \"std\": 2,\n \"min\": 1,\n \"max\": 7,\n \"num_unique_values\": 3,\n \"samples\": [\n 7\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n }\n ]\n}" }, "application/vnd.google.colaboratory.module+javascript": "\n import \"https://ssl.gstatic.com/colaboratory/data_table/9e65f7085e7ffcb7/data_table.js\";\n\n const table = window.createDataTable({\n data: [[{\n 'v': 0,\n 'f': \"0\",\n },\n\"8\",\n\"> 35 m\",\n\"Populus nigra 'Italica' (Pyramidenpappel)\",\n{\n 'v': 7,\n 'f': \"7\",\n }],\n [{\n 'v': 1,\n 'f': \"1\",\n },\n\"8\",\n\"> 35 m\",\n\"Fraxinus excelsior (Gemeine Esche)\",\n{\n 'v': 2,\n 'f': \"2\",\n }],\n [{\n 'v': 2,\n 'f': \"2\",\n },\n\"8\",\n\"> 35 m\",\n\"Populus nigra (Schwarzpappel)\",\n{\n 'v': 2,\n 'f': \"2\",\n }],\n [{\n 'v': 3,\n 'f': \"3\",\n },\n\"8\",\n\"> 35 m\",\n\"Platanus x acerifolia (Ahornbl\\u00e4ttrige Platane)\",\n{\n 'v': 1,\n 'f': \"1\",\n }],\n [{\n 'v': 4,\n 'f': \"4\",\n },\n\"8\",\n\"> 35 m\",\n\"Acer platanoides (Spitzahorn)\",\n{\n 'v': 1,\n 'f': \"1\",\n }],\n [{\n 'v': 5,\n 'f': \"5\",\n },\n\"8\",\n\"> 35 m\",\n\"Tilia tomentosa 'Brabant' (Silberlinde)\",\n{\n 'v': 1,\n 'f': \"1\",\n }]],\n columns: [[\"number\", \"index\"], [\"string\", \"BAUMHOEHE\"], [\"string\", \"BAUMHOEHE_TXT\"], [\"string\", \"GATTUNG_ART\"], [\"number\", \"COUNT\"]],\n columnOptions: [{\"width\": \"1px\", \"className\": \"index_column\"}],\n rowsPerPage: 25,\n helpUrl: \"https://colab.research.google.com/notebooks/data_table.ipynb\",\n suppressOutputScrolling: true,\n minimumWidth: undefined,\n });\n\n function appendQuickchartButton(parentElement) {\n let quickchartButtonContainerElement = document.createElement('div');\n quickchartButtonContainerElement.innerHTML = `\n
\n \n\n\n\n \n
`;\n parentElement.appendChild(quickchartButtonContainerElement);\n }\n\n appendQuickchartButton(table);\n " }, "metadata": {}, "execution_count": 24 } ] }, { "cell_type": "code", "source": [ "spark.sql(\"SELECT BAUMHOEHE, BAUMHOEHE_TXT, GATTUNG_ART, BEZIRK, OBJEKT_STRASSE from trees where BAUMHOEHE=8 sort by cast(BEZIRK as int)\").toPandas()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 414 }, "id": "xT6fof3Uwo4N", "outputId": "5931116d-b2b3-4f54-b216-ae1def6047ff" }, "execution_count": 25, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " BAUMHOEHE BAUMHOEHE_TXT GATTUNG_ART \\\n", "0 8 > 35 m Platanus x acerifolia (Ahornblättrige Platane) \n", "1 8 > 35 m Populus nigra 'Italica' (Pyramidenpappel) \n", "2 8 > 35 m Populus nigra 'Italica' (Pyramidenpappel) \n", "3 8 > 35 m Populus nigra 'Italica' (Pyramidenpappel) \n", "4 8 > 35 m Populus nigra (Schwarzpappel) \n", "5 8 > 35 m Populus nigra 'Italica' (Pyramidenpappel) \n", "6 8 > 35 m Fraxinus excelsior (Gemeine Esche) \n", "7 8 > 35 m Acer platanoides (Spitzahorn) \n", "8 8 > 35 m Tilia tomentosa 'Brabant' (Silberlinde) \n", "9 8 > 35 m Populus nigra 'Italica' (Pyramidenpappel) \n", "10 8 > 35 m Populus nigra (Schwarzpappel) \n", "11 8 > 35 m Populus nigra 'Italica' (Pyramidenpappel) \n", "12 8 > 35 m Populus nigra 'Italica' (Pyramidenpappel) \n", "13 8 > 35 m Fraxinus excelsior (Gemeine Esche) \n", "\n", " BEZIRK OBJEKT_STRASSE \n", "0 1 01., Rathauspark, MA42 \n", "1 2 02., Wettsteinpark, MA42 \n", "2 2 02., Wettsteinpark, MA42 \n", "3 2 02., Wettsteinpark, MA42 \n", "4 2 02., Donaukanal Pachtflächen 2. Bezirk, DHK \n", "5 2 02., Wettsteinpark, MA42 \n", "6 18 17., Schafbergbad, BAD \n", "7 19 19., Grinzinger Straße 111, SPO \n", "8 2 Stella-Klein-Löw-Weg \n", "9 2 02., Wettsteinpark, MA42 \n", "10 2 02., Freie Mitte - Parkband 1, MA42 \n", "11 2 02., Emilie-Turecek-Promenade, MA42 \n", "12 9 09., Karoline-Tintner-Promenade, MA42 \n", "13 23 23., Draschepark, MA42 " ], "text/html": [ "\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
BAUMHOEHEBAUMHOEHE_TXTGATTUNG_ARTBEZIRKOBJEKT_STRASSE
08> 35 mPlatanus x acerifolia (Ahornblättrige Platane)101., Rathauspark, MA42
18> 35 mPopulus nigra 'Italica' (Pyramidenpappel)202., Wettsteinpark, MA42
28> 35 mPopulus nigra 'Italica' (Pyramidenpappel)202., Wettsteinpark, MA42
38> 35 mPopulus nigra 'Italica' (Pyramidenpappel)202., Wettsteinpark, MA42
48> 35 mPopulus nigra (Schwarzpappel)202., Donaukanal Pachtflächen 2. Bezirk, DHK
58> 35 mPopulus nigra 'Italica' (Pyramidenpappel)202., Wettsteinpark, MA42
68> 35 mFraxinus excelsior (Gemeine Esche)1817., Schafbergbad, BAD
78> 35 mAcer platanoides (Spitzahorn)1919., Grinzinger Straße 111, SPO
88> 35 mTilia tomentosa 'Brabant' (Silberlinde)2Stella-Klein-Löw-Weg
98> 35 mPopulus nigra 'Italica' (Pyramidenpappel)202., Wettsteinpark, MA42
108> 35 mPopulus nigra (Schwarzpappel)202., Freie Mitte - Parkband 1, MA42
118> 35 mPopulus nigra 'Italica' (Pyramidenpappel)202., Emilie-Turecek-Promenade, MA42
128> 35 mPopulus nigra 'Italica' (Pyramidenpappel)909., Karoline-Tintner-Promenade, MA42
138> 35 mFraxinus excelsior (Gemeine Esche)2323., Draschepark, MA42
\n", "
\n", "
\n", "\n", "
\n", " \n", "\n", " \n", "\n", " \n", "
\n", "\n", "\n", "
\n", " \n", "\n", "\n", "\n", " \n", "
\n", "\n", "
\n", "
\n" ], "application/vnd.google.colaboratory.intrinsic+json": { "type": "dataframe", "summary": "{\n \"name\": \"spark\",\n \"rows\": 14,\n \"fields\": [\n {\n \"column\": \"BAUMHOEHE\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 1,\n \"samples\": [\n \"8\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"BAUMHOEHE_TXT\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 1,\n \"samples\": [\n \"> 35 m\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"GATTUNG_ART\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 6,\n \"samples\": [\n \"Platanus x acerifolia (Ahornbl\\u00e4ttrige Platane)\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"BEZIRK\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 6,\n \"samples\": [\n \"1\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"OBJEKT_STRASSE\",\n \"properties\": {\n \"dtype\": \"string\",\n \"num_unique_values\": 10,\n \"samples\": [\n \"09., Karoline-Tintner-Promenade, MA42\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n }\n ]\n}" }, "application/vnd.google.colaboratory.module+javascript": "\n import \"https://ssl.gstatic.com/colaboratory/data_table/9e65f7085e7ffcb7/data_table.js\";\n\n const table = window.createDataTable({\n data: [[{\n 'v': 0,\n 'f': \"0\",\n },\n\"8\",\n\"> 35 m\",\n\"Platanus x acerifolia (Ahornbl\\u00e4ttrige Platane)\",\n\"1\",\n\"01., Rathauspark, MA42\"],\n [{\n 'v': 1,\n 'f': \"1\",\n },\n\"8\",\n\"> 35 m\",\n\"Populus nigra 'Italica' (Pyramidenpappel)\",\n\"2\",\n\"02., Wettsteinpark, MA42\"],\n [{\n 'v': 2,\n 'f': \"2\",\n },\n\"8\",\n\"> 35 m\",\n\"Populus nigra 'Italica' (Pyramidenpappel)\",\n\"2\",\n\"02., Wettsteinpark, MA42\"],\n [{\n 'v': 3,\n 'f': \"3\",\n },\n\"8\",\n\"> 35 m\",\n\"Populus nigra 'Italica' (Pyramidenpappel)\",\n\"2\",\n\"02., Wettsteinpark, MA42\"],\n [{\n 'v': 4,\n 'f': \"4\",\n },\n\"8\",\n\"> 35 m\",\n\"Populus nigra (Schwarzpappel)\",\n\"2\",\n\"02., Donaukanal Pachtfl\\u00e4chen 2. Bezirk, DHK\"],\n [{\n 'v': 5,\n 'f': \"5\",\n },\n\"8\",\n\"> 35 m\",\n\"Populus nigra 'Italica' (Pyramidenpappel)\",\n\"2\",\n\"02., Wettsteinpark, MA42\"],\n [{\n 'v': 6,\n 'f': \"6\",\n },\n\"8\",\n\"> 35 m\",\n\"Fraxinus excelsior (Gemeine Esche)\",\n\"18\",\n\"17., Schafbergbad, BAD\"],\n [{\n 'v': 7,\n 'f': \"7\",\n },\n\"8\",\n\"> 35 m\",\n\"Acer platanoides (Spitzahorn)\",\n\"19\",\n\"19., Grinzinger Stra\\u00dfe 111, SPO\"],\n [{\n 'v': 8,\n 'f': \"8\",\n },\n\"8\",\n\"> 35 m\",\n\"Tilia tomentosa 'Brabant' (Silberlinde)\",\n\"2\",\n\"Stella-Klein-L\\u00f6w-Weg\"],\n [{\n 'v': 9,\n 'f': \"9\",\n },\n\"8\",\n\"> 35 m\",\n\"Populus nigra 'Italica' (Pyramidenpappel)\",\n\"2\",\n\"02., Wettsteinpark, MA42\"],\n [{\n 'v': 10,\n 'f': \"10\",\n },\n\"8\",\n\"> 35 m\",\n\"Populus nigra (Schwarzpappel)\",\n\"2\",\n\"02., Freie Mitte - Parkband 1, MA42\"],\n [{\n 'v': 11,\n 'f': \"11\",\n },\n\"8\",\n\"> 35 m\",\n\"Populus nigra 'Italica' (Pyramidenpappel)\",\n\"2\",\n\"02., Emilie-Turecek-Promenade, MA42\"],\n [{\n 'v': 12,\n 'f': \"12\",\n },\n\"8\",\n\"> 35 m\",\n\"Populus nigra 'Italica' (Pyramidenpappel)\",\n\"9\",\n\"09., Karoline-Tintner-Promenade, MA42\"],\n [{\n 'v': 13,\n 'f': \"13\",\n },\n\"8\",\n\"> 35 m\",\n\"Fraxinus excelsior (Gemeine Esche)\",\n\"23\",\n\"23., Draschepark, MA42\"]],\n columns: [[\"number\", \"index\"], [\"string\", \"BAUMHOEHE\"], [\"string\", \"BAUMHOEHE_TXT\"], [\"string\", \"GATTUNG_ART\"], [\"string\", \"BEZIRK\"], [\"string\", \"OBJEKT_STRASSE\"]],\n columnOptions: [{\"width\": \"1px\", \"className\": \"index_column\"}],\n rowsPerPage: 25,\n helpUrl: \"https://colab.research.google.com/notebooks/data_table.ipynb\",\n suppressOutputScrolling: true,\n minimumWidth: undefined,\n });\n\n function appendQuickchartButton(parentElement) {\n let quickchartButtonContainerElement = document.createElement('div');\n quickchartButtonContainerElement.innerHTML = `\n
\n \n\n\n\n \n
`;\n parentElement.appendChild(quickchartButtonContainerElement);\n }\n\n appendQuickchartButton(table);\n " }, "metadata": {}, "execution_count": 25 } ] }, { "cell_type": "markdown", "source": [ "## Close Spark session " ], "metadata": { "id": "JkoW4Nc42EaP" } }, { "cell_type": "markdown", "source": [ "When done, close the Spark session. This will release resources." ], "metadata": { "id": "Z07D3TKxxlw1" } }, { "cell_type": "code", "execution_count": 26, "metadata": { "id": "LV2qM806TSne" }, "outputs": [], "source": [ "spark.stop()" ] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.6.9" }, "colab": { "provenance": [], "collapsed_sections": [ "1d8lWgXjTSnY", "dAcCRnNosTVp", "hVYH-LrrzNEZ", "V6V_EW6zTSnb", "dKB2NJ9hTSnb", "pE1FnLlb1fcS", "JkoW4Nc42EaP" ], "include_colab_link": true } }, "nbformat": 4, "nbformat_minor": 0 }