Chistiakov_VV_PythonUrban_final_task.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "collapsed_sections": [
        "vGDfbdLe5PUs"
      ],
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/pspuser/PythonUrbanITMO2023/blob/main/Chistiakov_VV_PythonUrban_final_task.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "vGDfbdLe5PUs"
      },
      "source": [
        "# Итоговый проект. Улицы. Объекты культурного наследия."
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# TODO собрать установку всех необходимых модулей в одном месте\n",
        "!pip install geopandas mapclassify  # mapclassify для визуализации\n",
        "!pip install osmnx # устанавливаем модуль osmnx"
      ],
      "metadata": {
        "id": "YDz_w4ncmVMT",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "0be139d7-758b-45c2-e6ad-b2b714d8f3d3"
      },
      "execution_count": 94,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Requirement already satisfied: geopandas in /usr/local/lib/python3.10/dist-packages (0.13.2)\n",
            "Requirement already satisfied: mapclassify in /usr/local/lib/python3.10/dist-packages (2.6.1)\n",
            "Requirement already satisfied: fiona>=1.8.19 in /usr/local/lib/python3.10/dist-packages (from geopandas) (1.9.5)\n",
            "Requirement already satisfied: packaging in /usr/local/lib/python3.10/dist-packages (from geopandas) (23.2)\n",
            "Requirement already satisfied: pandas>=1.1.0 in /usr/local/lib/python3.10/dist-packages (from geopandas) (1.5.3)\n",
            "Requirement already satisfied: pyproj>=3.0.1 in /usr/local/lib/python3.10/dist-packages (from geopandas) (3.6.1)\n",
            "Requirement already satisfied: shapely>=1.7.1 in /usr/local/lib/python3.10/dist-packages (from geopandas) (2.0.2)\n",
            "Requirement already satisfied: networkx>=2.7 in /usr/local/lib/python3.10/dist-packages (from mapclassify) (3.2)\n",
            "Requirement already satisfied: numpy>=1.23 in /usr/local/lib/python3.10/dist-packages (from mapclassify) (1.23.5)\n",
            "Requirement already satisfied: scikit-learn>=1.0 in /usr/local/lib/python3.10/dist-packages (from mapclassify) (1.2.2)\n",
            "Requirement already satisfied: scipy>=1.8 in /usr/local/lib/python3.10/dist-packages (from mapclassify) (1.11.3)\n",
            "Requirement already satisfied: attrs>=19.2.0 in /usr/local/lib/python3.10/dist-packages (from fiona>=1.8.19->geopandas) (23.1.0)\n",
            "Requirement already satisfied: certifi in /usr/local/lib/python3.10/dist-packages (from fiona>=1.8.19->geopandas) (2023.7.22)\n",
            "Requirement already satisfied: click~=8.0 in /usr/local/lib/python3.10/dist-packages (from fiona>=1.8.19->geopandas) (8.1.7)\n",
            "Requirement already satisfied: click-plugins>=1.0 in /usr/local/lib/python3.10/dist-packages (from fiona>=1.8.19->geopandas) (1.1.1)\n",
            "Requirement already satisfied: cligj>=0.5 in /usr/local/lib/python3.10/dist-packages (from fiona>=1.8.19->geopandas) (0.7.2)\n",
            "Requirement already satisfied: six in /usr/local/lib/python3.10/dist-packages (from fiona>=1.8.19->geopandas) (1.16.0)\n",
            "Requirement already satisfied: setuptools in /usr/local/lib/python3.10/dist-packages (from fiona>=1.8.19->geopandas) (67.7.2)\n",
            "Requirement already satisfied: python-dateutil>=2.8.1 in /usr/local/lib/python3.10/dist-packages (from pandas>=1.1.0->geopandas) (2.8.2)\n",
            "Requirement already satisfied: pytz>=2020.1 in /usr/local/lib/python3.10/dist-packages (from pandas>=1.1.0->geopandas) (2023.3.post1)\n",
            "Requirement already satisfied: joblib>=1.1.1 in /usr/local/lib/python3.10/dist-packages (from scikit-learn>=1.0->mapclassify) (1.3.2)\n",
            "Requirement already satisfied: threadpoolctl>=2.0.0 in /usr/local/lib/python3.10/dist-packages (from scikit-learn>=1.0->mapclassify) (3.2.0)\n",
            "Requirement already satisfied: osmnx in /usr/local/lib/python3.10/dist-packages (1.7.0)\n",
            "Requirement already satisfied: geopandas>=0.12 in /usr/local/lib/python3.10/dist-packages (from osmnx) (0.13.2)\n",
            "Requirement already satisfied: networkx>=2.5 in /usr/local/lib/python3.10/dist-packages (from osmnx) (3.2)\n",
            "Requirement already satisfied: numpy>=1.20 in /usr/local/lib/python3.10/dist-packages (from osmnx) (1.23.5)\n",
            "Requirement already satisfied: pandas>=1.1 in /usr/local/lib/python3.10/dist-packages (from osmnx) (1.5.3)\n",
            "Requirement already satisfied: requests>=2.27 in /usr/local/lib/python3.10/dist-packages (from osmnx) (2.31.0)\n",
            "Requirement already satisfied: shapely>=2.0 in /usr/local/lib/python3.10/dist-packages (from osmnx) (2.0.2)\n",
            "Requirement already satisfied: fiona>=1.8.19 in /usr/local/lib/python3.10/dist-packages (from geopandas>=0.12->osmnx) (1.9.5)\n",
            "Requirement already satisfied: packaging in /usr/local/lib/python3.10/dist-packages (from geopandas>=0.12->osmnx) (23.2)\n",
            "Requirement already satisfied: pyproj>=3.0.1 in /usr/local/lib/python3.10/dist-packages (from geopandas>=0.12->osmnx) (3.6.1)\n",
            "Requirement already satisfied: python-dateutil>=2.8.1 in /usr/local/lib/python3.10/dist-packages (from pandas>=1.1->osmnx) (2.8.2)\n",
            "Requirement already satisfied: pytz>=2020.1 in /usr/local/lib/python3.10/dist-packages (from pandas>=1.1->osmnx) (2023.3.post1)\n",
            "Requirement already satisfied: charset-normalizer<4,>=2 in /usr/local/lib/python3.10/dist-packages (from requests>=2.27->osmnx) (3.3.1)\n",
            "Requirement already satisfied: idna<4,>=2.5 in /usr/local/lib/python3.10/dist-packages (from requests>=2.27->osmnx) (3.4)\n",
            "Requirement already satisfied: urllib3<3,>=1.21.1 in /usr/local/lib/python3.10/dist-packages (from requests>=2.27->osmnx) (2.0.7)\n",
            "Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.10/dist-packages (from requests>=2.27->osmnx) (2023.7.22)\n",
            "Requirement already satisfied: attrs>=19.2.0 in /usr/local/lib/python3.10/dist-packages (from fiona>=1.8.19->geopandas>=0.12->osmnx) (23.1.0)\n",
            "Requirement already satisfied: click~=8.0 in /usr/local/lib/python3.10/dist-packages (from fiona>=1.8.19->geopandas>=0.12->osmnx) (8.1.7)\n",
            "Requirement already satisfied: click-plugins>=1.0 in /usr/local/lib/python3.10/dist-packages (from fiona>=1.8.19->geopandas>=0.12->osmnx) (1.1.1)\n",
            "Requirement already satisfied: cligj>=0.5 in /usr/local/lib/python3.10/dist-packages (from fiona>=1.8.19->geopandas>=0.12->osmnx) (0.7.2)\n",
            "Requirement already satisfied: six in /usr/local/lib/python3.10/dist-packages (from fiona>=1.8.19->geopandas>=0.12->osmnx) (1.16.0)\n",
            "Requirement already satisfied: setuptools in /usr/local/lib/python3.10/dist-packages (from fiona>=1.8.19->geopandas>=0.12->osmnx) (67.7.2)\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# TODO собрать импорты всех модулей в одном месте\n",
        "import numpy as np\n",
        "import pandas as pd\n",
        "import osmnx as ox\n",
        "import geopandas as gpd\n",
        "import json\n",
        "import requests"
      ],
      "metadata": {
        "id": "Cpn6YWHImmCz"
      },
      "execution_count": 95,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "TILES = \"CartoDB positron\"  # Название подложки для карт\n",
        "\n",
        "# TODO указать любой район Санкт-Петербург из OSM https://wiki.openstreetmap.org/wiki/RU:%D0%A1%D0%B0%D0%BD%D0%BA%D1%82-%D0%9F%D0%B5%D1%82%D0%B5%D1%80%D0%B1%D1%83%D1%80%D0%B3/%D0%A0%D0%B0%D0%B9%D0%BE%D0%BD%D1%8B\n",
        "TERRITORY_NAME = \"Красносельский район, Санкт-Петербург\"  # название территории для которой будут строиться слои\n",
        "\n",
        "# TODO указать ссылку на файл из вашего github репозитория, которая начинается с https://raw.githubusercontent.com/\n",
        "KGIOP_FILE_URL = \"https://raw.githubusercontent.com/pspuser/PythonUrbanITMO2023/main/geojson_layers/kgiop_objects.geojson\"  # ссылка на слой с объектами культурного наследия\n",
        "STREETS_FILE_URL = \"https://raw.githubusercontent.com/pspuser/PythonUrbanITMO2023/main/geojson_layers/streets.geojson\"  # ссылка на слой с улицами"
      ],
      "metadata": {
        "id": "4iT2LzegmfYz"
      },
      "execution_count": 97,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Территория"
      ],
      "metadata": {
        "id": "cTIgCuVU5uIT"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Загрузка территории из OSM (Extract)"
      ],
      "metadata": {
        "id": "RdQsk6TT9vgX"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# TODO загрузить geodataframe с геометрией для территории TERRITORY_NAME\n",
        "district = ox.geocode_to_gdf(TERRITORY_NAME)\n",
        "district.explore() # TODO убрать explore()"
      ],
      "metadata": {
        "id": "N6qDafuQ9_Nv",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 627
        },
        "outputId": "2f60dc4f-6261-4081-cf53-685d2dd01d17"
      },
      "execution_count": 98,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<folium.folium.Map at 0x7a67cfea76d0>"
            ],
            "text/html": [
              "<div style=\"width:100%;\"><div style=\"position:relative;width:100%;height:0;padding-bottom:60%;\"><span style=\"color:#565656\">Make this Notebook Trusted to load map: File -> Trust Notebook</span><iframe srcdoc=\"&lt;!DOCTYPE html&gt;\n",
              "&lt;html&gt;\n",
              "&lt;head&gt;\n",
              "    \n",
              "    &lt;meta http-equiv=&quot;content-type&quot; content=&quot;text/html; charset=UTF-8&quot; /&gt;\n",
              "    \n",
              "        &lt;script&gt;\n",
              "            L_NO_TOUCH = false;\n",
              "            L_DISABLE_3D = false;\n",
              "        &lt;/script&gt;\n",
              "    \n",
              "    &lt;style&gt;html, body {width: 100%;height: 100%;margin: 0;padding: 0;}&lt;/style&gt;\n",
              "    &lt;style&gt;#map {position:absolute;top:0;bottom:0;right:0;left:0;}&lt;/style&gt;\n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.9.3/dist/leaflet.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://code.jquery.com/jquery-1.12.4.min.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/js/bootstrap.bundle.min.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.js&quot;&gt;&lt;/script&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.9.3/dist/leaflet.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.2.2/dist/css/bootstrap.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://netdna.bootstrapcdn.com/bootstrap/3.0.0/css/bootstrap.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/@fortawesome/fontawesome-free@6.2.0/css/all.min.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.css&quot;/&gt;\n",
              "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/gh/python-visualization/folium/folium/templates/leaflet.awesome.rotate.min.css&quot;/&gt;\n",
              "    \n",
              "            &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width,\n",
              "                initial-scale=1.0, maximum-scale=1.0, user-scalable=no&quot; /&gt;\n",
              "            &lt;style&gt;\n",
              "                #map_59b6f02e37c324826c30f8ce015b20f4 {\n",
              "                    position: relative;\n",
              "                    width: 100.0%;\n",
              "                    height: 100.0%;\n",
              "                    left: 0.0%;\n",
              "                    top: 0.0%;\n",
              "                }\n",
              "                .leaflet-container { font-size: 1rem; }\n",
              "            &lt;/style&gt;\n",
              "        \n",
              "    \n",
              "                    &lt;style&gt;\n",
              "                        .foliumtooltip {\n",
              "                            \n",
              "                        }\n",
              "                       .foliumtooltip table{\n",
              "                            margin: auto;\n",
              "                        }\n",
              "                        .foliumtooltip tr{\n",
              "                            text-align: left;\n",
              "                        }\n",
              "                        .foliumtooltip th{\n",
              "                            padding: 2px; padding-right: 8px;\n",
              "                        }\n",
              "                    &lt;/style&gt;\n",
              "            \n",
              "&lt;/head&gt;\n",
              "&lt;body&gt;\n",
              "    \n",
              "    \n",
              "            &lt;div class=&quot;folium-map&quot; id=&quot;map_59b6f02e37c324826c30f8ce015b20f4&quot; &gt;&lt;/div&gt;\n",
              "        \n",
              "&lt;/body&gt;\n",
              "&lt;script&gt;\n",
              "    \n",
              "    \n",
              "            var map_59b6f02e37c324826c30f8ce015b20f4 = L.map(\n",
              "                &quot;map_59b6f02e37c324826c30f8ce015b20f4&quot;,\n",
              "                {\n",
              "                    center: [59.769633, 30.15175505],\n",
              "                    crs: L.CRS.EPSG3857,\n",
              "                    zoom: 10,\n",
              "                    zoomControl: true,\n",
              "                    preferCanvas: false,\n",
              "                }\n",
              "            );\n",
              "            L.control.scale().addTo(map_59b6f02e37c324826c30f8ce015b20f4);\n",
              "\n",
              "            \n",
              "\n",
              "        \n",
              "    \n",
              "            var tile_layer_507d09ff6d606a96d4eea64587df9462 = L.tileLayer(\n",
              "                &quot;https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png&quot;,\n",
              "                {&quot;attribution&quot;: &quot;Data by \\u0026copy; \\u003ca target=\\&quot;_blank\\&quot; href=\\&quot;http://openstreetmap.org\\&quot;\\u003eOpenStreetMap\\u003c/a\\u003e, under \\u003ca target=\\&quot;_blank\\&quot; href=\\&quot;http://www.openstreetmap.org/copyright\\&quot;\\u003eODbL\\u003c/a\\u003e.&quot;, &quot;detectRetina&quot;: false, &quot;maxNativeZoom&quot;: 18, &quot;maxZoom&quot;: 18, &quot;minZoom&quot;: 0, &quot;noWrap&quot;: false, &quot;opacity&quot;: 1, &quot;subdomains&quot;: &quot;abc&quot;, &quot;tms&quot;: false}\n",
              "            ).addTo(map_59b6f02e37c324826c30f8ce015b20f4);\n",
              "        \n",
              "    \n",
              "            map_59b6f02e37c324826c30f8ce015b20f4.fitBounds(\n",
              "                [[59.6673744, 30.0349646], [59.8718916, 30.2685455]],\n",
              "                {}\n",
              "            );\n",
              "        \n",
              "    \n",
              "        function geo_json_17530bf56f170681aeb12bfa032a8bd8_styler(feature) {\n",
              "            switch(feature.id) {\n",
              "                default:\n",
              "                    return {&quot;fillOpacity&quot;: 0.5, &quot;weight&quot;: 2};\n",
              "            }\n",
              "        }\n",
              "        function geo_json_17530bf56f170681aeb12bfa032a8bd8_highlighter(feature) {\n",
              "            switch(feature.id) {\n",
              "                default:\n",
              "                    return {&quot;fillOpacity&quot;: 0.75};\n",
              "            }\n",
              "        }\n",
              "        function geo_json_17530bf56f170681aeb12bfa032a8bd8_pointToLayer(feature, latlng) {\n",
              "            var opts = {&quot;bubblingMouseEvents&quot;: true, &quot;color&quot;: &quot;#3388ff&quot;, &quot;dashArray&quot;: null, &quot;dashOffset&quot;: null, &quot;fill&quot;: true, &quot;fillColor&quot;: &quot;#3388ff&quot;, &quot;fillOpacity&quot;: 0.2, &quot;fillRule&quot;: &quot;evenodd&quot;, &quot;lineCap&quot;: &quot;round&quot;, &quot;lineJoin&quot;: &quot;round&quot;, &quot;opacity&quot;: 1.0, &quot;radius&quot;: 2, &quot;stroke&quot;: true, &quot;weight&quot;: 3};\n",
              "            \n",
              "            let style = geo_json_17530bf56f170681aeb12bfa032a8bd8_styler(feature)\n",
              "            Object.assign(opts, style)\n",
              "            \n",
              "            return new L.CircleMarker(latlng, opts)\n",
              "        }\n",
              "\n",
              "        function geo_json_17530bf56f170681aeb12bfa032a8bd8_onEachFeature(feature, layer) {\n",
              "            layer.on({\n",
              "                mouseout: function(e) {\n",
              "                    if(typeof e.target.setStyle === &quot;function&quot;){\n",
              "                        geo_json_17530bf56f170681aeb12bfa032a8bd8.resetStyle(e.target);\n",
              "                    }\n",
              "                },\n",
              "                mouseover: function(e) {\n",
              "                    if(typeof e.target.setStyle === &quot;function&quot;){\n",
              "                        const highlightStyle = geo_json_17530bf56f170681aeb12bfa032a8bd8_highlighter(e.target.feature)\n",
              "                        e.target.setStyle(highlightStyle);\n",
              "                    }\n",
              "                },\n",
              "            });\n",
              "        };\n",
              "        var geo_json_17530bf56f170681aeb12bfa032a8bd8 = L.geoJson(null, {\n",
              "                onEachFeature: geo_json_17530bf56f170681aeb12bfa032a8bd8_onEachFeature,\n",
              "            \n",
              "                style: geo_json_17530bf56f170681aeb12bfa032a8bd8_styler,\n",
              "                pointToLayer: geo_json_17530bf56f170681aeb12bfa032a8bd8_pointToLayer\n",
              "        });\n",
              "\n",
              "        function geo_json_17530bf56f170681aeb12bfa032a8bd8_add (data) {\n",
              "            geo_json_17530bf56f170681aeb12bfa032a8bd8\n",
              "                .addData(data)\n",
              "                .addTo(map_59b6f02e37c324826c30f8ce015b20f4);\n",
              "        }\n",
              "            geo_json_17530bf56f170681aeb12bfa032a8bd8_add({&quot;bbox&quot;: [30.0349646, 59.6673744, 30.2685455, 59.8718916], &quot;features&quot;: [{&quot;bbox&quot;: [30.0349646, 59.6673744, 30.2685455, 59.8718916], &quot;geometry&quot;: {&quot;coordinates&quot;: [[[[30.0349646, 59.7178541], [30.0404651, 59.7154701], [30.0409922, 59.7152416], [30.0500183, 59.7173239], [30.05048, 59.7169875], [30.0513658, 59.716116], [30.0555489, 59.7130753], [30.0717148, 59.7166834], [30.0737278, 59.7164217], [30.0744045, 59.716071], [30.0782445, 59.7163382], [30.0786138, 59.7160186], [30.0806791, 59.7157305], [30.0811271, 59.7157716], [30.0821114, 59.7143481], [30.0826205, 59.7136807], [30.0830555, 59.7131496], [30.08504, 59.7109408], [30.1008979, 59.6991988], [30.1010409, 59.6992093], [30.1023048, 59.6993025], [30.1056761, 59.6993121], [30.106797, 59.6992333], [30.106857, 59.6995587], [30.1071427, 59.6996901], [30.1074094, 59.6997157], [30.10833, 59.7004973], [30.1090228, 59.7006129], [30.1091822, 59.7005834], [30.1092264, 59.7005371], [30.1095001, 59.7004904], [30.1096977, 59.7003366], [30.1096795, 59.7001575], [30.1098011, 59.7000144], [30.1100905, 59.6999122], [30.110212, 59.6997515], [30.1102178, 59.6996026], [30.1103857, 59.699588], [30.1106751, 59.6994391], [30.1108198, 59.6993281], [30.1110281, 59.6992639], [30.1112828, 59.6992639], [30.1115249, 59.6992499], [30.1118406, 59.6991934], [30.1124246, 59.699123], [30.1128225, 59.6990354], [30.1129718, 59.6989848], [30.1132831, 59.6990874], [30.1134252, 59.6991983], [30.1134324, 59.6992625], [30.1136604, 59.6994514], [30.1138399, 59.6994371], [30.1143896, 59.699324], [30.1157111, 59.6991379], [30.1159908, 59.6990682], [30.1150023, 59.6981434], [30.1136204, 59.6972484], [30.1140486, 59.697134], [30.1143589, 59.6970457], [30.1141452, 59.6963726], [30.113983, 59.6955192], [30.1142025, 59.6950659], [30.1125976, 59.6950025], [30.1127484, 59.6940697], [30.1165074, 59.6943876], [30.1171252, 59.6944104], [30.1177898, 59.6943607], [30.1177559, 59.6942981], [30.1173715, 59.6939877], [30.1171823, 59.6937848], [30.1170521, 59.6935908], [30.1169607, 59.6934393], [30.1191283, 59.6935451], [30.1197177, 59.6935631], [30.1198828, 59.6930901], [30.119979, 59.6926775], [30.1198971, 59.6924395], [30.1197725, 59.6922726], [30.1199263, 59.6921542], [30.1203095, 59.6921123], [30.1210887, 59.6921046], [30.1215652, 59.6920181], [30.1227201, 59.692069], [30.1232723, 59.6921339], [30.1243382, 59.6922838], [30.1250094, 59.6925201], [30.1256293, 59.6927383], [30.1269835, 59.693215], [30.1281207, 59.6936683], [30.1297936, 59.6942042], [30.1306338, 59.6935879], [30.131051, 59.6936923], [30.1317784, 59.6939032], [30.1322277, 59.694045], [30.1326271, 59.6942213], [30.1331731, 59.6944686], [30.1337431, 59.6947567], [30.1342877, 59.6951588], [30.1351702, 59.6959349], [30.1357048, 59.6962454], [30.1358538, 59.6963571], [30.1359015, 59.6963929], [30.1360225, 59.6965736], [30.1361293, 59.6968351], [30.1362268, 59.6971745], [30.1363384, 59.6977103], [30.1363196, 59.6982248], [30.1363575, 59.6988139], [30.1363234, 59.699053], [30.1359591, 59.6995263], [30.1355153, 59.700053], [30.1354049, 59.7003703], [30.1359176, 59.7003155], [30.136834, 59.7003227], [30.1375096, 59.7004044], [30.1330839, 59.705309], [30.1330152, 59.7055601], [30.1327442, 59.7058389], [30.1327664, 59.7060912], [30.1326087, 59.7067005], [30.1323287, 59.7067994], [30.1312918, 59.706895], [30.131306, 59.7066522], [30.1300294, 59.7065911], [30.1299902, 59.7068753], [30.1298832, 59.706922], [30.1253652, 59.70694], [30.125219, 59.7067511], [30.1242276, 59.7068141], [30.1234509, 59.7068841], [30.1231224, 59.7081149], [30.1226826, 59.7081529], [30.1224205, 59.7088779], [30.1219997, 59.7088043], [30.1220791, 59.7086855], [30.1213277, 59.708461], [30.1216051, 59.7079479], [30.1209444, 59.7078767], [30.1206973, 59.7078487], [30.1201376, 59.7082124], [30.1191761, 59.7088539], [30.119082, 59.7089141], [30.1184148, 59.7093409], [30.1169955, 59.7102618], [30.1165177, 59.7106251], [30.1150343, 59.7118301], [30.1132649, 59.7134879], [30.1140525, 59.7137417], [30.1110656, 59.716691], [30.1099508, 59.7236504], [30.1096583, 59.7236631], [30.1087152, 59.7239809], [30.1080015, 59.7245668], [30.1070257, 59.7245485], [30.1068272, 59.7253676], [30.1065111, 59.7261882], [30.1066571, 59.7261837], [30.1063935, 59.7271061], [30.1065647, 59.7273182], [30.1065692, 59.7289907], [30.1060169, 59.7291305], [30.1048875, 59.7292479], [30.1048069, 59.7292591], [30.1049697, 59.7295322], [30.1054634, 59.7301508], [30.1057167, 59.7303386], [30.1059855, 59.7304562], [30.1063937, 59.7305646], [30.1086346, 59.7310051], [30.1086328, 59.7310295], [30.1108014, 59.734206], [30.1109497, 59.7342017], [30.1119835, 59.7356346], [30.110365, 59.7360659], [30.1089809, 59.7364028], [30.1093111, 59.7368886], [30.1096234, 59.7371809], [30.1097126, 59.7376305], [30.1086866, 59.7378159], [30.1096122, 59.7387095], [30.1110174, 59.7387208], [30.1149214, 59.7412501], [30.1158587, 59.741397], [30.1175922, 59.7434886], [30.1195206, 59.7458152], [30.1199075, 59.7473568], [30.1192585, 59.7488688], [30.1179459, 59.753096], [30.1177968, 59.7535763], [30.1176186, 59.7541501], [30.1170151, 59.7571896], [30.1181386, 59.760129], [30.1180023, 59.7616155], [30.1179873, 59.7617794], [30.1166561, 59.7618371], [30.1166312, 59.7621759], [30.120171, 59.7620891], [30.1221558, 59.7620404], [30.1232856, 59.76199], [30.1416855, 59.7611696], [30.143017, 59.7624405], [30.1437809, 59.7631695], [30.1527763, 59.7717536], [30.1459901, 59.7743835], [30.1462708, 59.7747368], [30.1461784, 59.7747613], [30.148506, 59.7772932], [30.1483392, 59.7773387], [30.1486348, 59.7776642], [30.1474349, 59.77798], [30.1499317, 59.7805335], [30.153066, 59.7832906], [30.1550991, 59.7848841], [30.1553208, 59.7848913], [30.1555724, 59.7858517], [30.1540374, 59.7862175], [30.1540776, 59.7865703], [30.1542358, 59.7866407], [30.1544653, 59.7867279], [30.1547151, 59.7868741], [30.1548476, 59.7869306], [30.1552704, 59.7870812], [30.1557569, 59.7871428], [30.1566784, 59.7872409], [30.1573849, 59.7873636], [30.1577071, 59.7874026], [30.1579401, 59.7874619], [30.1581027, 59.7875196], [30.1583913, 59.787674], [30.1585684, 59.78778], [30.1587117, 59.7878493], [30.1588993, 59.7879766], [30.1590094, 59.7880361], [30.1590135, 59.7881182], [30.1589931, 59.7881859], [30.1589931, 59.7883173], [30.1589971, 59.7886125], [30.1589895, 59.7888771], [30.1589661, 59.7890684], [30.1589146, 59.7893398], [30.158884, 59.7895271], [30.1588432, 59.7896502], [30.1587106, 59.7898426], [30.1586851, 59.7899709], [30.1587106, 59.7900915], [30.1587718, 59.7902967], [30.1588636, 59.7904352], [30.158991, 59.7905661], [30.1591542, 59.7907046], [30.1592867, 59.7908251], [30.1593632, 59.7909252], [30.1593887, 59.7910381], [30.1594091, 59.7912381], [30.1594193, 59.7914588], [30.1593785, 59.7916409], [30.1593224, 59.7917512], [30.1593275, 59.791823], [30.1593122, 59.7920385], [30.1593275, 59.7921975], [30.1593632, 59.7923001], [30.1594058, 59.7923764], [30.158855, 59.7925713], [30.1593214, 59.7929546], [30.1597347, 59.7932943], [30.1600276, 59.7935681], [30.1600861, 59.7936228], [30.1628142, 59.7962689], [30.1627319, 59.7962984], [30.1620601, 59.796539], [30.1611233, 59.7967428], [30.1601859, 59.7968789], [30.1589799, 59.7968804], [30.157037, 59.796849], [30.1554286, 59.7967834], [30.1540157, 59.7968778], [30.151344, 59.7947228], [30.1498858, 59.7935465], [30.1465703, 59.7908718], [30.1465119, 59.7908246], [30.1439304, 59.7887238], [30.1399454, 59.7853716], [30.1378348, 59.7860076], [30.1332614, 59.7820046], [30.1297612, 59.7824678], [30.1295059, 59.7825016], [30.1499325, 59.8009257], [30.1564251, 59.7989285], [30.1593206, 59.8011707], [30.1765628, 59.7960498], [30.1798214, 59.7934854], [30.1775295, 59.7915209], [30.1787847, 59.7910758], [30.1793625, 59.7908735], [30.1796163, 59.7907839], [30.1799222, 59.7908864], [30.1807548, 59.7910418], [30.1813556, 59.7911282], [30.1820594, 59.7910677], [30.1827546, 59.7909555], [30.1835014, 59.7909684], [30.1845056, 59.7910289], [30.1854068, 59.7911325], [30.1878186, 59.7913269], [30.1883937, 59.7914046], [30.1889173, 59.7914823], [30.1898357, 59.7918667], [30.1909257, 59.792251], [30.1923419, 59.7927304], [30.1927024, 59.7927865], [30.194007, 59.7932399], [30.1954318, 59.7937279], [30.1969596, 59.7941856], [30.198084, 59.7945613], [30.1988136, 59.7947556], [30.1992084, 59.7948895], [30.201234, 59.795494], [30.2036973, 59.7960985], [30.2043067, 59.7961935], [30.2051822, 59.7965001], [30.2064925, 59.7967254], [30.2079345, 59.7970233], [30.2091619, 59.7973083], [30.2097489, 59.7974167], [30.2100974, 59.797481], [30.2104665, 59.797481], [30.2108877, 59.7973836], [30.2113935, 59.7975371], [30.2114909, 59.7976913], [30.2109141, 59.7977428], [30.2104744, 59.7977863], [30.2094595, 59.7979842], [30.2093663, 59.7980023], [30.2083251, 59.7982053], [30.2061846, 59.7985798], [30.2042159, 59.7989058], [30.2010118, 59.7994916], [30.2003894, 59.7996273], [30.2002634, 59.7996547], [30.2001762, 59.7997278], [30.2001445, 59.7998133], [30.2002154, 59.8000436], [30.2002638, 59.8001769], [30.2001212, 59.8008743], [30.2000703, 59.8010976], [30.2000009, 59.8012465], [30.1999383, 59.8013343], [30.1998699, 59.801385], [30.1997215, 59.8014109], [30.1993875, 59.8014132], [30.1991435, 59.8014813], [30.1988845, 59.8015212], [30.1987721, 59.8016053], [30.1990074, 59.801804], [30.1992686, 59.8023554], [30.1996442, 59.8029397], [30.2000848, 59.8036783], [30.200092, 59.8036903], [30.2105705, 59.8021757], [30.2140295, 59.8019512], [30.2147762, 59.8018864], [30.2166054, 59.8015527], [30.2172595, 59.8015444], [30.2174924, 59.8015797], [30.2176045, 59.8016333], [30.2175585, 59.8017288], [30.217231, 59.8022966], [30.2193424, 59.802629], [30.2203633, 59.8047367], [30.2202699, 59.8048019], [30.220465, 59.8048726], [30.2205453, 59.804902], [30.2207709, 59.8049837], [30.2206025, 59.8051283], [30.2223541, 59.8085762], [30.2225483, 59.8087834], [30.222713, 59.8088244], [30.2237596, 59.8088099], [30.2238548, 59.8088086], [30.2241067, 59.8111565], [30.2242176, 59.81219], [30.2248991, 59.8124517], [30.2265293, 59.8130775], [30.2273363, 59.8132788], [30.2275238, 59.8132997], [30.2356037, 59.8128514], [30.2371781, 59.812764], [30.2384804, 59.812954], [30.2391634, 59.8130537], [30.2392089, 59.8130603], [30.2399944, 59.8130276], [30.2445733, 59.8191429], [30.247513, 59.8226702], [30.2479055, 59.8229036], [30.2487752, 59.8234209], [30.2488545, 59.8234676], [30.2546514, 59.8268597], [30.2646724, 59.8327226], [30.2685455, 59.8349407], [30.26819, 59.834854], [30.2629599, 59.8335731], [30.2560398, 59.8319556], [30.2543397, 59.8315508], [30.2480468, 59.8300523], [30.2375111, 59.8274533], [30.2315351, 59.8259811], [30.2272329, 59.8251399], [30.2219972, 59.8244064], [30.2185597, 59.8241242], [30.2160856, 59.8239211], [30.2095303, 59.8233063], [30.2027711, 59.8227508], [30.1977178, 59.8225728], [30.1920637, 59.822713], [30.1882121, 59.8228047], [30.185723, 59.8229342], [30.1835942, 59.8228861], [30.1848221, 59.8239704], [30.186746, 59.8256761], [30.1871289, 59.8260712], [30.1885553, 59.8275], [30.1889788, 59.8278418], [30.1892402, 59.8280432], [30.1901481, 59.8288728], [30.1906738, 59.8294201], [30.1919734, 59.8307937], [30.193518, 59.8321222], [30.1943211, 59.8327561], [30.1948934, 59.8332144], [30.1965728, 59.8344532], [30.1972385, 59.8349428], [30.1989319, 59.8362103], [30.1995256, 59.8366366], [30.2017459, 59.8382643], [30.2039187, 59.8398817], [30.2048856, 59.8406064], [30.206138, 59.8414806], [30.2080083, 59.8427622], [30.2101681, 59.84422], [30.2121917, 59.8456066], [30.216555, 59.8485577], [30.2212463, 59.8517784], [30.2286061, 59.8567574], [30.2320975, 59.8591263], [30.2391956, 59.8639293], [30.2373178, 59.8639801], [30.2354642, 59.8640238], [30.2337943, 59.8640562], [30.2329482, 59.8640243], [30.2319048, 59.8640523], [30.2313783, 59.8640664], [30.2311729, 59.8640719], [30.2293539, 59.8641039], [30.2290027, 59.8641278], [30.2280011, 59.8641278], [30.2272081, 59.8642386], [30.2262371, 59.864276], [30.2256855, 59.8642858], [30.2249779, 59.8642866], [30.2245496, 59.8643037], [30.2239356, 59.8642661], [30.2231212, 59.8642558], [30.2215111, 59.8643355], [30.2208459, 59.8643355], [30.219537, 59.864454], [30.2189684, 59.8644863], [30.2182496, 59.8645348], [30.2177131, 59.8645941], [30.2168119, 59.8646803], [30.21649, 59.864718], [30.2162218, 59.8647341], [30.2159536, 59.8647449], [30.2155, 59.8647524], [30.2151617, 59.8647631], [30.2147563, 59.8648293], [30.2141529, 59.8649536], [30.2138548, 59.8650299], [30.2135444, 59.8651181], [30.2133965, 59.8651614], [30.2131802, 59.8652009], [30.2128573, 59.8652433], [30.2125796, 59.865263], [30.212285, 59.8653061], [30.2118429, 59.8653787], [30.2113935, 59.8654486], [30.2110687, 59.8654861], [30.2108896, 59.8655111], [30.2103897, 59.8656177], [30.2101616, 59.86568], [30.2098792, 59.8657709], [30.2097673, 59.8658151], [30.2095914, 59.865858], [30.2093559, 59.8659173], [30.2090804, 59.8660013], [30.2086277, 59.8661312], [30.2078526, 59.8663717], [30.2072134, 59.8665702], [30.2070911, 59.8666221], [30.2069451, 59.8666877], [30.2067193, 59.8667515], [30.2063239, 59.8668444], [30.2059207, 59.8669456], [30.205435, 59.8670781], [30.2049986, 59.8672019], [30.2045809, 59.8673677], [30.2043546, 59.867488], [30.2041131, 59.8676467], [30.2039162, 59.8678174], [30.2037611, 59.867964], [30.2036165, 59.8680915], [30.2034529, 59.8681961], [30.2031644, 59.8683053], [30.2027493, 59.8684069], [30.2022795, 59.8684725], [30.2018232, 59.8685318], [30.2014026, 59.8686091], [30.2010591, 59.8687028], [30.2008593, 59.8688044], [30.2006803, 59.8689516], [30.2005921, 59.8690128], [30.2004624, 59.8690284], [30.2002639, 59.8690234], [30.2000736, 59.8690213], [30.1998692, 59.8689816], [30.1996214, 59.8689194], [30.1993808, 59.8688377], [30.1990941, 59.8687133], [30.1986198, 59.868596], [30.1981527, 59.8685161], [30.1976713, 59.8683917], [30.197375, 59.8683856], [30.1968571, 59.868313], [30.1963602, 59.8681669], [30.1951765, 59.8679146], [30.194724, 59.8678627], [30.1928043, 59.86776], [30.1923163, 59.867694], [30.1919549, 59.867622], [30.1915912, 59.8675868], [30.1911756, 59.8675801], [30.1905539, 59.8676041], [30.1899719, 59.8676105], [30.18944, 59.867611], [30.1888889, 59.8676084], [30.1886033, 59.8675956], [30.1883409, 59.867556], [30.1878886, 59.8675371], [30.1876809, 59.8675298], [30.187434, 59.867513], [30.1868618, 59.8674312], [30.1863857, 59.8673371], [30.186121, 59.867265], [30.18593, 59.8671933], [30.1857317, 59.8671011], [30.1855592, 59.8669905], [30.1852783, 59.8665998], [30.1851671, 59.866562], [30.1849778, 59.8665547], [30.1845537, 59.8666452], [30.1840654, 59.8667986], [30.1839549, 59.8668182], [30.1838225, 59.8668182], [30.1835044, 59.8667573], [30.1832474, 59.8667171], [30.1828562, 59.8666957], [30.1825937, 59.8666803], [30.182284, 59.8666782], [30.1818913, 59.8666893], [30.1816045, 59.866705], [30.1813912, 59.8667323], [30.1812139, 59.8667678], [30.1810825, 59.8668382], [30.1809163, 59.8669092], [30.1807608, 59.8670183], [30.180663, 59.8671182], [30.1805788, 59.8672276], [30.1805072, 59.8673163], [30.1803906, 59.8674888], [30.1803342, 59.8676605], [30.1803257, 59.8677856], [30.1803047, 59.8678399], [30.180211, 59.8678923], [30.1799229, 59.8680099], [30.1798115, 59.8681039], [30.1798063, 59.8681807], [30.1797958, 59.8682507], [30.1797633, 59.8683202], [30.1796514, 59.8683732], [30.1795156, 59.8683901], [30.1794339, 59.8684064], [30.1792664, 59.8684603], [30.1791099, 59.8685224], [30.1789298, 59.8685582], [30.1787578, 59.8686086], [30.1786121, 59.8687093], [30.1784476, 59.8688543], [30.1781989, 59.8690619], [30.1779066, 59.869266], [30.1777166, 59.869362], [30.1775161, 59.8694526], [30.1773317, 59.8695331], [30.1771571, 59.8696609], [30.1770361, 59.8697944], [30.1769694, 59.8698565], [30.1767971, 59.8699172], [30.1766249, 59.8700347], [30.1763905, 59.8701464], [30.1761534, 59.8702354], [30.1756255, 59.8703529], [30.1753895, 59.8703115], [30.1729295, 59.8705154], [30.1726361, 59.870098], [30.1724014, 59.8700118], [30.1721993, 59.8699266], [30.1719091, 59.8697417], [30.1718404, 59.869575], [30.1714111, 59.8695894], [30.1710218, 59.8696526], [30.1706726, 59.869756], [30.1704608, 59.8699198], [30.1706128, 59.8699643], [30.1707387, 59.8700333], [30.1707673, 59.8700678], [30.1707802, 59.8701123], [30.1707516, 59.8701561], [30.170713, 59.8701913], [30.1706156, 59.8702193], [30.1704783, 59.8702294], [30.1703308, 59.8702222], [30.1701605, 59.8701971], [30.1699948, 59.8702502], [30.169781, 59.8703774], [30.1700961, 59.8704147], [30.1706211, 59.8704658], [30.1706955, 59.870552], [30.1704951, 59.870644], [30.17002, 59.8706554], [30.1696708, 59.8706066], [30.1692144, 59.8707802], [30.1685445, 59.8709402], [30.1682568, 59.8709632], [30.1677531, 59.8709457], [30.1673238, 59.871006], [30.1670032, 59.8711238], [30.1666082, 59.8712215], [30.1664307, 59.8712589], [30.1662823, 59.8712537], [30.1661164, 59.8712801], [30.165906, 59.8712992], [30.1657645, 59.8712811], [30.1656007, 59.8713048], [30.1652373, 59.8713164], [30.1650821, 59.8713015], [30.1648393, 59.8711724], [30.1647037, 59.871143], [30.164438, 59.8711432], [30.1642139, 59.8711775], [30.163969, 59.8712009], [30.1638088, 59.8711872], [30.1636593, 59.8711511], [30.1635986, 59.8711135], [30.1636006, 59.8710678], [30.16368, 59.8709719], [30.1637172, 59.8709188], [30.1637143, 59.8708426], [30.1636742, 59.8707766], [30.163504, 59.8706862], [30.1625685, 59.8703709], [30.1561923, 59.8717536], [30.1560851, 59.8717687], [30.1559922, 59.8717881], [30.1559167, 59.8718197], [30.1558449, 59.8718585], [30.1557711, 59.8718828], [30.1556954, 59.8718916], [30.1556278, 59.8718877], [30.1555566, 59.8718703], [30.1554954, 59.8718449], [30.1554416, 59.8718114], [30.1552158, 59.8716404], [30.1551544, 59.8715853], [30.1550977, 59.8715279], [30.1550429, 59.8714587], [30.1550108, 59.8714012], [30.1549834, 59.8713378], [30.1549731, 59.8712754], [30.1549844, 59.8712094], [30.1550101, 59.8711411], [30.1550522, 59.8710708], [30.1551421, 59.8709404], [30.1552484, 59.8708151], [30.1552705, 59.8707715], [30.1552798, 59.8707282], [30.1552615, 59.8706727], [30.1551685, 59.8705682], [30.1551058, 59.8705226], [30.1550184, 59.8704702], [30.1549342, 59.8704271], [30.1548214, 59.8703792], [30.1546746, 59.8703225], [30.1545917, 59.8702804], [30.1545227, 59.8702389], [30.1544657, 59.870189], [30.1544127, 59.8701382], [30.1543789, 59.8700946], [30.1543196, 59.8700353], [30.1542555, 59.8699857], [30.1541901, 59.8699414], [30.1540539, 59.8698505], [30.1539386, 59.8697798], [30.1538639, 59.8697235], [30.1537813, 59.8696594], [30.153688, 59.8695792], [30.1536373, 59.8695408], [30.1535663, 59.8695091], [30.1534827, 59.8694864], [30.15338, 59.8694721], [30.1532778, 59.8694673], [30.1531723, 59.8694664], [30.1530778, 59.8694627], [30.1529824, 59.8694574], [30.1528726, 59.8694495], [30.1527357, 59.8694314], [30.1526459, 59.8694125], [30.1525571, 59.8693877], [30.1524882, 59.8693548], [30.1524293, 59.8693142], [30.152383, 59.869269], [30.152343, 59.8692216], [30.1519661, 59.868751], [30.1518877, 59.8686626], [30.1518009, 59.8685492], [30.1517121, 59.8684489], [30.1516193, 59.8683514], [30.1515182, 59.868246], [30.1504008, 59.8671615], [30.150239, 59.8670223], [30.150095, 59.8669067], [30.1499352, 59.8667848], [30.149758, 59.8666558], [30.149554, 59.8665195], [30.1489208, 59.8660956], [30.1486342, 59.8659303], [30.1483728, 59.865803], [30.1482518, 59.8657422], [30.1461505, 59.8650227], [30.1434702, 59.8642677], [30.1425836, 59.864013], [30.1424074, 59.8639581], [30.1422842, 59.8639107], [30.1422366, 59.8638818], [30.1422128, 59.8638474], [30.1422053, 59.8638014], [30.1422132, 59.8637506], [30.1422182, 59.8637372], [30.1422473, 59.8636598], [30.1422516, 59.863614], [30.1422318, 59.8635762], [30.1421838, 59.8635391], [30.1421169, 59.8635146], [30.1420391, 59.8634946], [30.1410568, 59.8632755], [30.140945, 59.8632404], [30.1408564, 59.8632052], [30.1407742, 59.8631649], [30.1407125, 59.8631343], [30.1406503, 59.8631109], [30.140582, 59.8630953], [30.1405008, 59.8630856], [30.1400539, 59.8630545], [30.1399678, 59.8630463], [30.1398969, 59.86303], [30.1398439, 59.863002], [30.1398061, 59.8629628], [30.1397894, 59.8629232], [30.1397856, 59.8628718], [30.1397842, 59.8626649], [30.1397705, 59.8626258], [30.1397384, 59.8625843], [30.1396932, 59.86255], [30.1396254, 59.8625109], [30.1395349, 59.8624741], [30.1394444, 59.8624444], [30.1389545, 59.8623066], [30.1388895, 59.8622932], [30.1388318, 59.8622851], [30.13876, 59.8622758], [30.1386908, 59.8622654], [30.1386043, 59.8622441], [30.1385301, 59.8622193], [30.1384431, 59.8621892], [30.1383534, 59.8621644], [30.1382492, 59.8621365], [30.1381274, 59.8621043], [30.1380062, 59.8620729], [30.137898, 59.8620442], [30.1377682, 59.8620124], [30.1376413, 59.861979], [30.1374883, 59.8619394], [30.137327, 59.8619069], [30.1371383, 59.861885], [30.1369051, 59.8618566], [30.1366571, 59.8618316], [30.1363872, 59.8618128], [30.1361454, 59.8618006], [30.1359121, 59.8617895], [30.1356777, 59.8617716], [30.1354433, 59.8617459], [30.1352136, 59.8617249], [30.1349863, 59.8617123], [30.1348003, 59.8617092], [30.1340582, 59.8616855], [30.1338844, 59.8616895], [30.1337315, 59.8616942], [30.1335511, 59.8616914], [30.1333495, 59.8616909], [30.133191, 59.8616929], [30.1330083, 59.8617043], [30.1328452, 59.8617244], [30.1326917, 59.8617517], [30.1326062, 59.8617802], [30.1325157, 59.8618174], [30.1324457, 59.8618638], [30.1323843, 59.861919], [30.1323267, 59.8619745], [30.1322741, 59.8620325], [30.1319164, 59.8622912], [30.1318419, 59.8623701], [30.1318218, 59.8624049], [30.1318263, 59.8624411], [30.1318538, 59.8624752], [30.131909, 59.8625074], [30.1319813, 59.8625387], [30.1320404, 59.862568], [30.1321053, 59.8626046], [30.1321669, 59.862648], [30.132239, 59.8626997], [30.1323051, 59.86274], [30.1323944, 59.8627894], [30.132857, 59.863039], [30.1329168, 59.8630751], [30.1329487, 59.8631057], [30.1329616, 59.8631375], [30.1329478, 59.8631651], [30.1329123, 59.8631837], [30.132858, 59.863189], [30.1328109, 59.8631827], [30.1327565, 59.8631659], [30.1327046, 59.8631413], [30.1326449, 59.8631069], [30.1318847, 59.8626496], [30.131816, 59.8626242], [30.1317202, 59.8626041], [30.1316057, 59.8625924], [30.1314725, 59.8625892], [30.1307866, 59.8625831], [30.1297413, 59.8625737], [30.126689, 59.8625912], [30.1215945, 59.8626592], [30.1213673, 59.8626921], [30.1205065, 59.8627031], [30.1204497, 59.8626745], [30.1192579, 59.8627315], [30.1183849, 59.8627733], [30.1180738, 59.8627959], [30.1180064, 59.8627898], [30.1177453, 59.8627284], [30.1176156, 59.8626564], [30.1175808, 59.8625501], [30.1175605, 59.8624776], [30.1175613, 59.8624081], [30.1175483, 59.8623555], [30.1175707, 59.862334], [30.1175613, 59.8622927], [30.1175688, 59.8622176], [30.1175427, 59.8621304], [30.117466, 59.8620825], [30.1174679, 59.8619756], [30.1173689, 59.8618752], [30.1173203, 59.8617767], [30.1172418, 59.8616922], [30.1171428, 59.8615599], [30.1171558, 59.8614576], [30.1171801, 59.8613394], [30.1172343, 59.8612325], [30.1172231, 59.8611452], [30.1172026, 59.8609951], [30.1171857, 59.8609219], [30.1171633, 59.8608206], [30.1171091, 59.860723], [30.1171278, 59.8606601], [30.117225, 59.8605616], [30.1172072, 59.8605281], [30.117225, 59.8604603], [30.1171988, 59.8603993], [30.1171988, 59.8603308], [30.117167, 59.8602895], [30.1171857, 59.8602304], [30.1172119, 59.8601609], [30.117225, 59.8600925], [30.1172119, 59.8600418], [30.1172586, 59.8600155], [30.1171895, 59.859978], [30.1172026, 59.8599198], [30.1171708, 59.8598494], [30.1171727, 59.8597931], [30.1172072, 59.8597481], [30.1172455, 59.8596937], [30.1172511, 59.8596158], [30.1172754, 59.859567], [30.1173109, 59.8594835], [30.117367, 59.8594263], [30.1173352, 59.8593822], [30.1173128, 59.8593137], [30.1173558, 59.8592358], [30.1173894, 59.8591851], [30.1173838, 59.8591354], [30.117367, 59.8590819], [30.1173633, 59.8589899], [30.1173913, 59.858882], [30.1174329, 59.8588301], [30.1174733, 59.8587715], [30.1174761, 59.8587133], [30.1174204, 59.8586771], [30.1173271, 59.8586508], [30.117212, 59.8586405], [30.1170919, 59.8586518], [30.1170035, 59.8586904], [30.1169902, 59.8587577], [30.1170146, 59.8588394], [30.1169916, 59.8592129], [30.1168157, 59.8592502], [30.1167767, 59.8593215], [30.1167859, 59.8593984], [30.1168105, 59.8594524], [30.1167695, 59.8595326], [30.1168723, 59.8597402], [30.1168381, 59.8604592], [30.1167074, 59.8612655], [30.1165938, 59.8613969], [30.1165666, 59.8616598], [30.1166873, 59.8619268], [30.1163083, 59.8626238], [30.1162796, 59.8627945], [30.1162326, 59.8628972], [30.1161447, 59.8629409], [30.1160238, 59.8629522], [30.115899, 59.86292], [30.115785, 59.8628562], [30.1156275, 59.8628039], [30.1154191, 59.8627678], [30.1143364, 59.8628384], [30.1139042, 59.862837], [30.1136814, 59.8627685], [30.113489, 59.862663], [30.1134836, 59.8625017], [30.1135768, 59.8624278], [30.1137701, 59.8623746], [30.1141939, 59.8624277], [30.1144036, 59.8623514], [30.1144348, 59.8621774], [30.1143819, 59.8620305], [30.1142332, 59.8619415], [30.1139423, 59.8619186], [30.1109447, 59.862241], [30.1088044, 59.8632172], [30.108506, 59.8632296], [30.107617, 59.8632893], [30.1076862, 59.8635195], [30.1070578, 59.8635652], [30.1062787, 59.8627721], [30.10511, 59.86312], [30.1041953, 59.8631785], [30.10312, 59.86354], [30.1023757, 59.8637214], [30.10186, 59.86383], [30.10114, 59.86424], [30.10063, 59.86425], [30.09959, 59.86402], [30.09852, 59.86353], [30.0985512, 59.8589191], [30.0986692, 59.8581002], [30.0985948, 59.8573323], [30.098401, 59.855331], [30.1005952, 59.8539786], [30.1005728, 59.8534059], [30.0963986, 59.8538518], [30.096153, 59.8538678], [30.0958909, 59.85387], [30.0956232, 59.8538672], [30.0954145, 59.8538503], [30.0952289, 59.8538305], [30.094746, 59.8537442], [30.0941477, 59.8536274], [30.0905873, 59.8529002], [30.0903906, 59.8528541], [30.090429, 59.8528152], [30.090445, 59.8527861], [30.09047, 59.8527404], [30.0905175, 59.8526487], [30.0905416, 59.8521853], [30.0905434, 59.8521516], [30.0905527, 59.8520019], [30.0905598, 59.8518856], [30.0905615, 59.8518586], [30.0905641, 59.8518175], [30.0905652, 59.8517989], [30.0905702, 59.8517186], [30.0905784, 59.8515857], [30.090592, 59.8513657], [30.0906025, 59.8511961], [30.0906121, 59.8510417], [30.0906201, 59.8509115], [30.0906331, 59.8507019], [30.0906496, 59.8504359], [30.0906573, 59.8503124], [30.0906606, 59.8502586], [30.0906614, 59.8502456], [30.0906746, 59.8500319], [30.0907804, 59.8483204], [30.0907862, 59.8482271], [30.0909117, 59.8461987], [30.0909867, 59.8449874], [30.0911827, 59.8417945], [30.0912134, 59.8413226], [30.0912173, 59.8412747], [30.0912438, 59.8409279], [30.0912495, 59.8407601], [30.091258, 59.8406083], [30.091261, 59.8404168], [30.0912615, 59.8403866], [30.0912742, 59.840193], [30.0912808, 59.8400911], [30.0912952, 59.8398711], [30.0913084, 59.8396686], [30.0913252, 59.8394117], [30.0914666, 59.8372481], [30.0915256, 59.8363183], [30.0915387, 59.8361116], [30.0915503, 59.8359282], [30.0867103, 59.8353227], [30.0861596, 59.8346936], [30.0860707, 59.8346083], [30.0835866, 59.8351542], [30.0755159, 59.8370548], [30.0697365, 59.8384233], [30.0701593, 59.8366258], [30.0701704, 59.8365785], [30.0702286, 59.8363312], [30.0702637, 59.8361799], [30.0706904, 59.8342319], [30.0713065, 59.8318133], [30.0719006, 59.8293176], [30.0719189, 59.8292366], [30.0719367, 59.8291614], [30.0719888, 59.8289417], [30.0720036, 59.828879], [30.0720625, 59.8285787], [30.0724248, 59.8271892], [30.0726871, 59.8261279], [30.0728509, 59.8254056], [30.0730096, 59.8247047], [30.0732069, 59.8238645], [30.0732735, 59.8235808], [30.073429, 59.8229854], [30.0735415, 59.8225546], [30.073553, 59.8225096], [30.0735657, 59.8224553], [30.0736101, 59.8222713], [30.0737935, 59.8215107], [30.073931, 59.8208984], [30.0739547, 59.8207928], [30.0739995, 59.8205932], [30.0740246, 59.8204732], [30.0740502, 59.82036], [30.0742216, 59.8196697], [30.0742355, 59.8196137], [30.0742649, 59.8194946], [30.0743407, 59.8191959], [30.0743672, 59.8190573], [30.0744703, 59.8186641], [30.0745779, 59.8182862], [30.074666, 59.8179072], [30.07493, 59.8166825], [30.0752888, 59.8152343], [30.0858923, 59.8161376], [30.0909658, 59.8148603], [30.1046843, 59.817297], [30.1276856, 59.8090654], [30.1253276, 59.8065195], [30.1234163, 59.8044557], [30.1122215, 59.8034567], [30.110023, 59.8032605], [30.1097807, 59.8033301], [30.1095154, 59.8031706], [30.1048977, 59.8028605], [30.1056051, 59.7973586], [30.1052008, 59.7969392], [30.0992919, 59.7963058], [30.0992126, 59.7961541], [30.0987841, 59.7954994], [30.0986889, 59.7951907], [30.0986995, 59.7948661], [30.0986743, 59.7946264], [30.0982638, 59.7906001], [30.0982066, 59.7900389], [30.0982613, 59.789396], [30.09866, 59.7870778], [30.098834, 59.7862369], [30.0988054, 59.7858785], [30.0985115, 59.7852595], [30.0978411, 59.7843515], [30.0979511, 59.7839266], [30.0969224, 59.7835855], [30.0962698, 59.7833691], [30.0966669, 59.7829892], [30.0970493, 59.7827297], [30.0961434, 59.7824513], [30.0960503, 59.7824227], [30.0958151, 59.7826162], [30.0948213, 59.7824764], [30.0944855, 59.7824271], [30.0914177, 59.7820667], [30.0907193, 59.7815239], [30.090737, 59.7814215], [30.0839774, 59.7786159], [30.0839294, 59.778596], [30.0846326, 59.7757298], [30.0782718, 59.7731913], [30.0771797, 59.7728388], [30.0718376, 59.7711143], [30.0629227, 59.7681975], [30.0614719, 59.7677228], [30.0563799, 59.7660567], [30.0522612, 59.7658585], [30.045602, 59.7655379], [30.0453501, 59.7655258], [30.0433427, 59.7641834], [30.0438245, 59.7623881], [30.0559636, 59.763282], [30.0563606, 59.7617221], [30.0579176, 59.7618586], [30.0603272, 59.7620699], [30.0616624, 59.7585987], [30.0620134, 59.7576863], [30.0619703, 59.7570123], [30.0698659, 59.7568468], [30.0703611, 59.7559718], [30.0718473, 59.7559865], [30.0718652, 59.7559438], [30.0719942, 59.7552681], [30.0665334, 59.7552664], [30.0682605, 59.7527314], [30.0624768, 59.752127], [30.0628376, 59.7510644], [30.0639893, 59.7498861], [30.0708832, 59.7497434], [30.0761388, 59.7479223], [30.0719071, 59.745851], [30.0658112, 59.742867], [30.0655585, 59.7427433], [30.0646471, 59.7422971], [30.0617277, 59.740868], [30.0550926, 59.7351849], [30.0561195, 59.7339613], [30.0558056, 59.7337741], [30.0548869, 59.7332627], [30.0552978, 59.7330652], [30.0538103, 59.7320439], [30.0536892, 59.7320877], [30.0534551, 59.7319284], [30.0535757, 59.7318822], [30.0513323, 59.7303433], [30.0509155, 59.7300373], [30.0500484, 59.7300039], [30.0502553, 59.7281985], [30.0473685, 59.7253575], [30.0475993, 59.7244941], [30.0457785, 59.7195836], [30.0384198, 59.7206975], [30.0349646, 59.7178541]]], [[[30.0650571, 59.6683027], [30.073311, 59.6673744], [30.082713, 59.6760822], [30.0839517, 59.6802946], [30.0728262, 59.6797451], [30.065169, 59.677984], [30.065326, 59.6763773], [30.0650571, 59.6683027]]]], &quot;type&quot;: &quot;MultiPolygon&quot;}, &quot;id&quot;: &quot;0&quot;, &quot;properties&quot;: {&quot;addresstype&quot;: &quot;administrative&quot;, &quot;bbox_east&quot;: 30.2685455, &quot;bbox_north&quot;: 59.8718916, &quot;bbox_south&quot;: 59.6673744, &quot;bbox_west&quot;: 30.0349646, &quot;class&quot;: &quot;boundary&quot;, &quot;display_name&quot;: &quot;Krasnoselsky District, Saint Petersburg, Northwestern Federal District, Russia&quot;, &quot;importance&quot;: 0.40269308307498786, &quot;lat&quot;: 59.78176425, &quot;lon&quot;: 30.12117968928648, &quot;name&quot;: &quot;Krasnoselsky District&quot;, &quot;osm_id&quot;: 363103, &quot;osm_type&quot;: &quot;relation&quot;, &quot;place_id&quot;: 181803738, &quot;place_rank&quot;: 10, &quot;type&quot;: &quot;administrative&quot;}, &quot;type&quot;: &quot;Feature&quot;}], &quot;type&quot;: &quot;FeatureCollection&quot;});\n",
              "\n",
              "        \n",
              "    \n",
              "    geo_json_17530bf56f170681aeb12bfa032a8bd8.bindTooltip(\n",
              "    function(layer){\n",
              "    let div = L.DomUtil.create(&#x27;div&#x27;);\n",
              "    \n",
              "    let handleObject = feature=&gt;typeof(feature)==&#x27;object&#x27; ? JSON.stringify(feature) : feature;\n",
              "    let fields = [&quot;bbox_north&quot;, &quot;bbox_south&quot;, &quot;bbox_east&quot;, &quot;bbox_west&quot;, &quot;place_id&quot;, &quot;osm_type&quot;, &quot;osm_id&quot;, &quot;lat&quot;, &quot;lon&quot;, &quot;class&quot;, &quot;type&quot;, &quot;place_rank&quot;, &quot;importance&quot;, &quot;addresstype&quot;, &quot;name&quot;, &quot;display_name&quot;];\n",
              "    let aliases = [&quot;bbox_north&quot;, &quot;bbox_south&quot;, &quot;bbox_east&quot;, &quot;bbox_west&quot;, &quot;place_id&quot;, &quot;osm_type&quot;, &quot;osm_id&quot;, &quot;lat&quot;, &quot;lon&quot;, &quot;class&quot;, &quot;type&quot;, &quot;place_rank&quot;, &quot;importance&quot;, &quot;addresstype&quot;, &quot;name&quot;, &quot;display_name&quot;];\n",
              "    let table = &#x27;&lt;table&gt;&#x27; +\n",
              "        String(\n",
              "        fields.map(\n",
              "        (v,i)=&gt;\n",
              "        `&lt;tr&gt;\n",
              "            &lt;th&gt;${aliases[i]}&lt;/th&gt;\n",
              "            \n",
              "            &lt;td&gt;${handleObject(layer.feature.properties[v])}&lt;/td&gt;\n",
              "        &lt;/tr&gt;`).join(&#x27;&#x27;))\n",
              "    +&#x27;&lt;/table&gt;&#x27;;\n",
              "    div.innerHTML=table;\n",
              "    \n",
              "    return div\n",
              "    }\n",
              "    ,{&quot;className&quot;: &quot;foliumtooltip&quot;, &quot;sticky&quot;: true});\n",
              "                     \n",
              "&lt;/script&gt;\n",
              "&lt;/html&gt;\" style=\"position:absolute;width:100%;height:100%;left:0;top:0;border:none !important;\" allowfullscreen webkitallowfullscreen mozallowfullscreen></iframe></div></div>"
            ]
          },
          "metadata": {},
          "execution_count": 98
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Улицы"
      ],
      "metadata": {
        "id": "K3VY8W4d93Yt"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Загрузка файла с улицами (Extract)"
      ],
      "metadata": {
        "id": "4mH1FBw4-GB5"
      }
    },
    {
      "cell_type": "code",
      "execution_count": 99,
      "metadata": {
        "id": "SRXpUAvk5ONJ",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 572
        },
        "outputId": "17af36aa-cab6-49b2-f16a-23472c20c9b5"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'geopandas.geodataframe.GeoDataFrame'>\n",
            "RangeIndex: 1582 entries, 0 to 1581\n",
            "Data columns (total 2 columns):\n",
            " #   Column    Non-Null Count  Dtype   \n",
            "---  ------    --------------  -----   \n",
            " 0   name      1582 non-null   object  \n",
            " 1   geometry  1582 non-null   geometry\n",
            "dtypes: geometry(1), object(1)\n",
            "memory usage: 24.8+ KB\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                       name                                           geometry\n",
              "0            улица Доблести  LINESTRING (3359594.246 8368940.704, 3359610.6...\n",
              "1        проспект Будённого  LINESTRING (3349643.598 8367056.893, 3349646.9...\n",
              "2           улица Стойкости  LINESTRING (3360780.923 8361696.899, 3360753.1...\n",
              "3     улица Солдата Корзуна  LINESTRING (3362732.566 8364821.874, 3362740.1...\n",
              "4        Восточный переулок  LINESTRING (3350559.957 8338315.414, 3350805.8...\n",
              "...                     ...                                                ...\n",
              "1577   Лиговский путепровод  LINESTRING (3360027.836 8360383.607, 3360102.8...\n",
              "1578       Таллинское шоссе  LINESTRING (3358251.878 8357338.717, 3358302.2...\n",
              "1579       Таллинское шоссе  LINESTRING (3358029.339 8357012.149, 3358023.5...\n",
              "1580       Таллинское шоссе  LINESTRING (3358052.750 8357050.952, 3358029.3...\n",
              "1581         улица Доблести  LINESTRING (3359206.164 8367740.483, 3359211.4...\n",
              "\n",
              "[1582 rows x 2 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-12294635-ded4-4f61-a8e5-0c21ff5f214c\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>name</th>\n",
              "      <th>geometry</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>улица Доблести</td>\n",
              "      <td>LINESTRING (3359594.246 8368940.704, 3359610.6...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>проспект Будённого</td>\n",
              "      <td>LINESTRING (3349643.598 8367056.893, 3349646.9...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>улица Стойкости</td>\n",
              "      <td>LINESTRING (3360780.923 8361696.899, 3360753.1...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>улица Солдата Корзуна</td>\n",
              "      <td>LINESTRING (3362732.566 8364821.874, 3362740.1...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Восточный переулок</td>\n",
              "      <td>LINESTRING (3350559.957 8338315.414, 3350805.8...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1577</th>\n",
              "      <td>Лиговский путепровод</td>\n",
              "      <td>LINESTRING (3360027.836 8360383.607, 3360102.8...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1578</th>\n",
              "      <td>Таллинское шоссе</td>\n",
              "      <td>LINESTRING (3358251.878 8357338.717, 3358302.2...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1579</th>\n",
              "      <td>Таллинское шоссе</td>\n",
              "      <td>LINESTRING (3358029.339 8357012.149, 3358023.5...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1580</th>\n",
              "      <td>Таллинское шоссе</td>\n",
              "      <td>LINESTRING (3358052.750 8357050.952, 3358029.3...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1581</th>\n",
              "      <td>улица Доблести</td>\n",
              "      <td>LINESTRING (3359206.164 8367740.483, 3359211.4...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1582 rows × 2 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-12294635-ded4-4f61-a8e5-0c21ff5f214c')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-12294635-ded4-4f61-a8e5-0c21ff5f214c button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-12294635-ded4-4f61-a8e5-0c21ff5f214c');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-2dd1ddda-4f3e-44a6-889d-b3e3d3b51889\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-2dd1ddda-4f3e-44a6-889d-b3e3d3b51889')\"\n",
              "            title=\"Suggest charts.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-2dd1ddda-4f3e-44a6-889d-b3e3d3b51889 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 99
        }
      ],
      "source": [
        "# TODO отфильтровать улицы по маске геометрии территории полученной ранее\n",
        "gdf = gpd.read_file(STREETS_FILE_URL, mask=district)\n",
        "gdf.info()\n",
        "gdf"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Обработка данных с улицами (Transform)"
      ],
      "metadata": {
        "id": "eC3YdkziAcaE"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# TODO переименовать столбцы в русские названия, кроме столбца geometry\n",
        "rename_columns = {\n",
        "    \"name\": \"Название\"\n",
        "}\n",
        "gdf.rename(columns=rename_columns, inplace=True)\n",
        "\n",
        "# Поменял местами 2 задания, потому что после gdf.dissolve(), судя\n",
        "# по геодатафрейму и его инфо, из двух столбцов остается один\n",
        "\n",
        "# TODO сгруппировать и объединить геометрии с одинаковыми названиями\n",
        "\n",
        "gdf = gdf.dissolve(by=\"Название\")\n",
        "gdf"
      ],
      "metadata": {
        "id": "7LD0J-YE_uSh",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 450
        },
        "outputId": "d7cc6bed-c301-48b5-b3a3-6e391a600570"
      },
      "execution_count": 101,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                                                   geometry\n",
              "Название                                                                   \n",
              "1-й Купальный переулок    LINESTRING (3350719.422 8338033.644, 3350939.5...\n",
              "1-й Петергофский мост     MULTILINESTRING ((3357212.599 8365672.439, 335...\n",
              "1-й проезд                MULTILINESTRING ((3354027.771 8348984.834, 335...\n",
              "1-й проезд Красной улицы  LINESTRING (3351597.076 8361086.489, 3351646.1...\n",
              "1-я Берёзовая улица       LINESTRING (3351006.360 8368299.479, 3350930.0...\n",
              "...                                                                     ...\n",
              "улица Чекистов            MULTILINESTRING ((3354082.718 8365335.330, 335...\n",
              "улица Щорса               LINESTRING (3348360.796 8361203.960, 3348452.2...\n",
              "улица Энгельса            LINESTRING (3350739.894 8362337.506, 3350827.1...\n",
              "улица Юных Пионеров       MULTILINESTRING ((3349366.345 8340543.193, 334...\n",
              "улица Юрия Пасторова      LINESTRING (3349068.053 8339161.010, 3349075.1...\n",
              "\n",
              "[406 rows x 1 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-544260ad-8b1a-4b78-bf39-27fd01fcfbf9\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>geometry</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Название</th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1-й Купальный переулок</th>\n",
              "      <td>LINESTRING (3350719.422 8338033.644, 3350939.5...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1-й Петергофский мост</th>\n",
              "      <td>MULTILINESTRING ((3357212.599 8365672.439, 335...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1-й проезд</th>\n",
              "      <td>MULTILINESTRING ((3354027.771 8348984.834, 335...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1-й проезд Красной улицы</th>\n",
              "      <td>LINESTRING (3351597.076 8361086.489, 3351646.1...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1-я Берёзовая улица</th>\n",
              "      <td>LINESTRING (3351006.360 8368299.479, 3350930.0...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>улица Чекистов</th>\n",
              "      <td>MULTILINESTRING ((3354082.718 8365335.330, 335...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>улица Щорса</th>\n",
              "      <td>LINESTRING (3348360.796 8361203.960, 3348452.2...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>улица Энгельса</th>\n",
              "      <td>LINESTRING (3350739.894 8362337.506, 3350827.1...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>улица Юных Пионеров</th>\n",
              "      <td>MULTILINESTRING ((3349366.345 8340543.193, 334...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>улица Юрия Пасторова</th>\n",
              "      <td>LINESTRING (3349068.053 8339161.010, 3349075.1...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>406 rows × 1 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-544260ad-8b1a-4b78-bf39-27fd01fcfbf9')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-544260ad-8b1a-4b78-bf39-27fd01fcfbf9 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-544260ad-8b1a-4b78-bf39-27fd01fcfbf9');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-7648ddb2-703d-4e45-b66d-b04c38f2f7c3\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-7648ddb2-703d-4e45-b66d-b04c38f2f7c3')\"\n",
              "            title=\"Suggest charts.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-7648ddb2-703d-4e45-b66d-b04c38f2f7c3 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 101
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Сохранение слоя с улицами (Load)"
      ],
      "metadata": {
        "id": "Y6kceXrXAJDn"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# TODO сохранить слой в географической проекции в формате GeoJSON\n",
        "gdf.to_crs(4326).to_file('streets.geojson', driver='GeoJSON')"
      ],
      "metadata": {
        "id": "OuIm2guxAQHS"
      },
      "execution_count": 102,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Объекты культурного наследия"
      ],
      "metadata": {
        "id": "zqqWUNPzuJu0"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Загрузка объектов культурного наследия (Extract)"
      ],
      "metadata": {
        "id": "473VG26vbdUX"
      }
    },
    {
      "cell_type": "code",
      "execution_count": 103,
      "metadata": {
        "id": "u-NrRHTl5lmx",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 949
        },
        "outputId": "6b4addd3-69a9-4572-8bd6-e9906c760c0b"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "       id                     ensemble_name  \\\n",
              "0    2896                                 —   \n",
              "1    2897                                 —   \n",
              "2    2898                                 —   \n",
              "3    2899                                 —   \n",
              "4    2900                                 —   \n",
              "..    ...                               ...   \n",
              "102  3006                                 —   \n",
              "103  3007                                 —   \n",
              "104  3008                                 —   \n",
              "105  7363  Сооружения периода 1941-1943 гг.   \n",
              "106  9491                                 —   \n",
              "\n",
              "                                           object_name  \\\n",
              "0    Сосновая поляна. Парк, остатки исторической пл...   \n",
              "1    Мемориал в память обороны города в 1941-1944 г...   \n",
              "2    Мемориал в память обороны города в 1941-1944 г...   \n",
              "3    Мемориал в память обороны города в 1941-1944 г...   \n",
              "4                                        Матисов канал   \n",
              "..                                                 ...   \n",
              "102  Братская могила моряков крейсера \"Аврора\", пог...   \n",
              "103  Братская могила воинов Советской Армии, погибш...   \n",
              "104  Исторические трассы Петергофской и Нарвской дорог   \n",
              "105                                 ДОТ артиллерийский   \n",
              "106            Железнодорожный вокзал станции Горелово   \n",
              "\n",
              "                                   occurrence_time  \\\n",
              "0                                        1710-1714   \n",
              "1                                             1966   \n",
              "2                                             1968   \n",
              "3                                             1944   \n",
              "4                                       1800-около   \n",
              "..                                             ...   \n",
              "102               1964 (памятник); 1984 (мемориал)   \n",
              "103                                              —   \n",
              "104  17 в.-18 в.сер.; 1773-1784 (реконструирована)   \n",
              "105                                      1941-1943   \n",
              "106                                     1912; 1948   \n",
              "\n",
              "                                       object_location  \\\n",
              "0    Ветеранов пр.; Летчика Пилютова ул.; Балтийска...   \n",
              "1    Маршала Жукова пр. (напротив дома 38, корп.1 п...   \n",
              "2    Петергофское шоссе, 14-й км (на пересечении с ...   \n",
              "3      Петергофское шоссе, 16-км (около Тамбасова ул.)   \n",
              "4    Петергофское шоссе, в створе 2-й Комсомольской...   \n",
              "..                                                 ...   \n",
              "102      пос. Можайский, на территории Нагорного парка   \n",
              "103                                         пос. Урицк   \n",
              "104  пр. Стачек и Петергофское шоссе, пр. Маршала Ж...   \n",
              "105             Красное Село, ул. Нарвская, д. 8, к. 1   \n",
              "106  Участок железной дороги Аннинское шоссе – река...   \n",
              "\n",
              "                                   historical_category  \\\n",
              "0    объект культурного наследия регионального знач...   \n",
              "1    объект культурного наследия федерального значения   \n",
              "2    объект культурного наследия федерального значения   \n",
              "3    объект культурного наследия федерального значения   \n",
              "4    объект культурного наследия регионального знач...   \n",
              "..                                                 ...   \n",
              "102  объект культурного наследия регионального знач...   \n",
              "103  объект культурного наследия регионального знач...   \n",
              "104  объект культурного наследия регионального знач...   \n",
              "105  объект культурного наследия регионального знач...   \n",
              "106  объект культурного наследия регионального знач...   \n",
              "\n",
              "                                         normative_act object_type  \\\n",
              "0    Распоряжение мэра Санкт-Петербурга № 108-р от ...    Ансамбль   \n",
              "1    Постановление Правительства РФ № 527 от 10.07....    Ансамбль   \n",
              "2    Постановление Правительства РФ № 527 от 10.07....    Памятник   \n",
              "3    Постановление Правительства РФ № 527 от 10.07....    Памятник   \n",
              "4    Распоряжение мэра Санкт-Петербурга № 108-р от ...    Памятник   \n",
              "..                                                 ...         ...   \n",
              "102  Решение исполкома Ленгорсовета № 124 от 27.02....    Памятник   \n",
              "103  Решение Исполкома Ленгорсовета от 03.05.1976 г...    Памятник   \n",
              "104  Распоряжение мэра Санкт-Петербурга № 108-р от ...    Ансамбль   \n",
              "105          Распоряжение КГИОП № 10-192 от 07.05.2015    Памятник   \n",
              "106           Распоряжение КГИОП № 162-р от 22.05.2020    Памятник   \n",
              "\n",
              "                            geometry  \n",
              "0    POINT (3354589.144 8362088.243)  \n",
              "1    POINT (3360642.587 8363693.884)  \n",
              "2    POINT (3359555.997 8365524.138)  \n",
              "3    POINT (3357077.023 8365562.254)  \n",
              "4    POINT (3355630.204 8367035.215)  \n",
              "..                               ...  \n",
              "102  POINT (3353358.507 8331564.745)  \n",
              "103  POINT (3358341.835 8362845.606)  \n",
              "104  POINT (3359992.147 8360308.446)  \n",
              "105  POINT (3347383.879 8337529.501)  \n",
              "106  POINT (3353604.078 8350713.666)  \n",
              "\n",
              "[107 rows x 9 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-959d948e-d1d4-46ce-955d-142600f76d40\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>id</th>\n",
              "      <th>ensemble_name</th>\n",
              "      <th>object_name</th>\n",
              "      <th>occurrence_time</th>\n",
              "      <th>object_location</th>\n",
              "      <th>historical_category</th>\n",
              "      <th>normative_act</th>\n",
              "      <th>object_type</th>\n",
              "      <th>geometry</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2896</td>\n",
              "      <td>—</td>\n",
              "      <td>Сосновая поляна. Парк, остатки исторической пл...</td>\n",
              "      <td>1710-1714</td>\n",
              "      <td>Ветеранов пр.; Летчика Пилютова ул.; Балтийска...</td>\n",
              "      <td>объект культурного наследия регионального знач...</td>\n",
              "      <td>Распоряжение мэра Санкт-Петербурга № 108-р от ...</td>\n",
              "      <td>Ансамбль</td>\n",
              "      <td>POINT (3354589.144 8362088.243)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2897</td>\n",
              "      <td>—</td>\n",
              "      <td>Мемориал в память обороны города в 1941-1944 г...</td>\n",
              "      <td>1966</td>\n",
              "      <td>Маршала Жукова пр. (напротив дома 38, корп.1 п...</td>\n",
              "      <td>объект культурного наследия федерального значения</td>\n",
              "      <td>Постановление Правительства РФ № 527 от 10.07....</td>\n",
              "      <td>Ансамбль</td>\n",
              "      <td>POINT (3360642.587 8363693.884)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2898</td>\n",
              "      <td>—</td>\n",
              "      <td>Мемориал в память обороны города в 1941-1944 г...</td>\n",
              "      <td>1968</td>\n",
              "      <td>Петергофское шоссе, 14-й км (на пересечении с ...</td>\n",
              "      <td>объект культурного наследия федерального значения</td>\n",
              "      <td>Постановление Правительства РФ № 527 от 10.07....</td>\n",
              "      <td>Памятник</td>\n",
              "      <td>POINT (3359555.997 8365524.138)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2899</td>\n",
              "      <td>—</td>\n",
              "      <td>Мемориал в память обороны города в 1941-1944 г...</td>\n",
              "      <td>1944</td>\n",
              "      <td>Петергофское шоссе, 16-км (около Тамбасова ул.)</td>\n",
              "      <td>объект культурного наследия федерального значения</td>\n",
              "      <td>Постановление Правительства РФ № 527 от 10.07....</td>\n",
              "      <td>Памятник</td>\n",
              "      <td>POINT (3357077.023 8365562.254)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2900</td>\n",
              "      <td>—</td>\n",
              "      <td>Матисов канал</td>\n",
              "      <td>1800-около</td>\n",
              "      <td>Петергофское шоссе, в створе 2-й Комсомольской...</td>\n",
              "      <td>объект культурного наследия регионального знач...</td>\n",
              "      <td>Распоряжение мэра Санкт-Петербурга № 108-р от ...</td>\n",
              "      <td>Памятник</td>\n",
              "      <td>POINT (3355630.204 8367035.215)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>102</th>\n",
              "      <td>3006</td>\n",
              "      <td>—</td>\n",
              "      <td>Братская могила моряков крейсера \"Аврора\", пог...</td>\n",
              "      <td>1964 (памятник); 1984 (мемориал)</td>\n",
              "      <td>пос. Можайский, на территории Нагорного парка</td>\n",
              "      <td>объект культурного наследия регионального знач...</td>\n",
              "      <td>Решение исполкома Ленгорсовета № 124 от 27.02....</td>\n",
              "      <td>Памятник</td>\n",
              "      <td>POINT (3353358.507 8331564.745)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>103</th>\n",
              "      <td>3007</td>\n",
              "      <td>—</td>\n",
              "      <td>Братская могила воинов Советской Армии, погибш...</td>\n",
              "      <td>—</td>\n",
              "      <td>пос. Урицк</td>\n",
              "      <td>объект культурного наследия регионального знач...</td>\n",
              "      <td>Решение Исполкома Ленгорсовета от 03.05.1976 г...</td>\n",
              "      <td>Памятник</td>\n",
              "      <td>POINT (3358341.835 8362845.606)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>104</th>\n",
              "      <td>3008</td>\n",
              "      <td>—</td>\n",
              "      <td>Исторические трассы Петергофской и Нарвской дорог</td>\n",
              "      <td>17 в.-18 в.сер.; 1773-1784 (реконструирована)</td>\n",
              "      <td>пр. Стачек и Петергофское шоссе, пр. Маршала Ж...</td>\n",
              "      <td>объект культурного наследия регионального знач...</td>\n",
              "      <td>Распоряжение мэра Санкт-Петербурга № 108-р от ...</td>\n",
              "      <td>Ансамбль</td>\n",
              "      <td>POINT (3359992.147 8360308.446)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>105</th>\n",
              "      <td>7363</td>\n",
              "      <td>Сооружения периода 1941-1943 гг.</td>\n",
              "      <td>ДОТ артиллерийский</td>\n",
              "      <td>1941-1943</td>\n",
              "      <td>Красное Село, ул. Нарвская, д. 8, к. 1</td>\n",
              "      <td>объект культурного наследия регионального знач...</td>\n",
              "      <td>Распоряжение КГИОП № 10-192 от 07.05.2015</td>\n",
              "      <td>Памятник</td>\n",
              "      <td>POINT (3347383.879 8337529.501)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>106</th>\n",
              "      <td>9491</td>\n",
              "      <td>—</td>\n",
              "      <td>Железнодорожный вокзал станции Горелово</td>\n",
              "      <td>1912; 1948</td>\n",
              "      <td>Участок железной дороги Аннинское шоссе – река...</td>\n",
              "      <td>объект культурного наследия регионального знач...</td>\n",
              "      <td>Распоряжение КГИОП № 162-р от 22.05.2020</td>\n",
              "      <td>Памятник</td>\n",
              "      <td>POINT (3353604.078 8350713.666)</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>107 rows × 9 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-959d948e-d1d4-46ce-955d-142600f76d40')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-959d948e-d1d4-46ce-955d-142600f76d40 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-959d948e-d1d4-46ce-955d-142600f76d40');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-8b31b348-46f7-48c5-9289-da8f60f0f736\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-8b31b348-46f7-48c5-9289-da8f60f0f736')\"\n",
              "            title=\"Suggest charts.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-8b31b348-46f7-48c5-9289-da8f60f0f736 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 103
        }
      ],
      "source": [
        "# TODO отфильтровать улицы по маске геометрии территории полученной ранее\n",
        "gdf = gpd.read_file(KGIOP_FILE_URL, mask=district)\n",
        "gdf"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Обработка объектов культурного наследия (Transform)"
      ],
      "metadata": {
        "id": "E_d2aqIHENQ0"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# TODO добавить два столбца lon и lat, в которых будут долгота и широта\n",
        "gdf[\"lon\"] = gdf.to_crs(3857).geometry.centroid.to_crs(4326).x\n",
        "gdf[\"lat\"] = gdf.to_crs(3857).geometry.centroid.to_crs(4326).y"
      ],
      "metadata": {
        "id": "ufqqSwaJEjpD"
      },
      "execution_count": 104,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Сохранение слоя с объектами культурного наследия (Load)"
      ],
      "metadata": {
        "id": "Fwpp7cniENRC"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# TODO переименовать столбцы в русские названия, кроме столбца geometry\n",
        "rename_columns = {\n",
        "    \"id\": \"Идентификатор\",\n",
        "    \"ensemble_name\": \"Наименование ансамбля\",\n",
        "    \"object_name\": \"Наименование объекта\",\n",
        "    \"occurrence_time\": \"Время возникновения\",\n",
        "    \"object_location\": \"Местоположение объекта\",\n",
        "    \"historical_category\": \"Историческая категория\",\n",
        "    \"normative_act\": \"Нормативный акт\",\n",
        "    \"object_type\": \"Тип объекта\",\n",
        "    \"lon\": \"Долгота\",\n",
        "    \"lat\": \"Широта\"\n",
        "}\n",
        "gdf.rename(columns=rename_columns, inplace=True)\n",
        "gdf.head()"
      ],
      "metadata": {
        "id": "3IMdU0us_q0S",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 581
        },
        "outputId": "9d93f601-1a7e-48e0-fafa-2d9f9f7523cf"
      },
      "execution_count": 92,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   Идентификатор Наименование ансамбля  \\\n",
              "0           2896                     —   \n",
              "1           2897                     —   \n",
              "2           2898                     —   \n",
              "3           2899                     —   \n",
              "4           2900                     —   \n",
              "\n",
              "                                Наименование объекта Время возникновения  \\\n",
              "0  Сосновая поляна. Парк, остатки исторической пл...           1710-1714   \n",
              "1  Мемориал в память обороны города в 1941-1944 г...                1966   \n",
              "2  Мемориал в память обороны города в 1941-1944 г...                1968   \n",
              "3  Мемориал в память обороны города в 1941-1944 г...                1944   \n",
              "4                                      Матисов канал          1800-около   \n",
              "\n",
              "                              Местоположение объекта  \\\n",
              "0  Ветеранов пр.; Летчика Пилютова ул.; Балтийска...   \n",
              "1  Маршала Жукова пр. (напротив дома 38, корп.1 п...   \n",
              "2  Петергофское шоссе, 14-й км (на пересечении с ...   \n",
              "3    Петергофское шоссе, 16-км (около Тамбасова ул.)   \n",
              "4  Петергофское шоссе, в створе 2-й Комсомольской...   \n",
              "\n",
              "                              Историческая категория  \\\n",
              "0  объект культурного наследия регионального знач...   \n",
              "1  объект культурного наследия федерального значения   \n",
              "2  объект культурного наследия федерального значения   \n",
              "3  объект культурного наследия федерального значения   \n",
              "4  объект культурного наследия регионального знач...   \n",
              "\n",
              "                                     Нормативный акт Тип объекта  \\\n",
              "0  Распоряжение мэра Санкт-Петербурга № 108-р от ...    Ансамбль   \n",
              "1  Постановление Правительства РФ № 527 от 10.07....    Ансамбль   \n",
              "2  Постановление Правительства РФ № 527 от 10.07....    Памятник   \n",
              "3  Постановление Правительства РФ № 527 от 10.07....    Памятник   \n",
              "4  Распоряжение мэра Санкт-Петербурга № 108-р от ...    Памятник   \n",
              "\n",
              "                          geometry    Долгота     Широта  \n",
              "0  POINT (3354589.144 8362088.243)  30.134787  59.830461  \n",
              "1  POINT (3360642.587 8363693.884)  30.189166  59.837709  \n",
              "2  POINT (3359555.997 8365524.138)  30.179405  59.845969  \n",
              "3  POINT (3357077.023 8365562.254)  30.157136  59.846141  \n",
              "4  POINT (3355630.204 8367035.215)  30.144139  59.852787  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-ad750538-b865-44b9-b8c7-d02190e1d177\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Идентификатор</th>\n",
              "      <th>Наименование ансамбля</th>\n",
              "      <th>Наименование объекта</th>\n",
              "      <th>Время возникновения</th>\n",
              "      <th>Местоположение объекта</th>\n",
              "      <th>Историческая категория</th>\n",
              "      <th>Нормативный акт</th>\n",
              "      <th>Тип объекта</th>\n",
              "      <th>geometry</th>\n",
              "      <th>Долгота</th>\n",
              "      <th>Широта</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2896</td>\n",
              "      <td>—</td>\n",
              "      <td>Сосновая поляна. Парк, остатки исторической пл...</td>\n",
              "      <td>1710-1714</td>\n",
              "      <td>Ветеранов пр.; Летчика Пилютова ул.; Балтийска...</td>\n",
              "      <td>объект культурного наследия регионального знач...</td>\n",
              "      <td>Распоряжение мэра Санкт-Петербурга № 108-р от ...</td>\n",
              "      <td>Ансамбль</td>\n",
              "      <td>POINT (3354589.144 8362088.243)</td>\n",
              "      <td>30.134787</td>\n",
              "      <td>59.830461</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2897</td>\n",
              "      <td>—</td>\n",
              "      <td>Мемориал в память обороны города в 1941-1944 г...</td>\n",
              "      <td>1966</td>\n",
              "      <td>Маршала Жукова пр. (напротив дома 38, корп.1 п...</td>\n",
              "      <td>объект культурного наследия федерального значения</td>\n",
              "      <td>Постановление Правительства РФ № 527 от 10.07....</td>\n",
              "      <td>Ансамбль</td>\n",
              "      <td>POINT (3360642.587 8363693.884)</td>\n",
              "      <td>30.189166</td>\n",
              "      <td>59.837709</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2898</td>\n",
              "      <td>—</td>\n",
              "      <td>Мемориал в память обороны города в 1941-1944 г...</td>\n",
              "      <td>1968</td>\n",
              "      <td>Петергофское шоссе, 14-й км (на пересечении с ...</td>\n",
              "      <td>объект культурного наследия федерального значения</td>\n",
              "      <td>Постановление Правительства РФ № 527 от 10.07....</td>\n",
              "      <td>Памятник</td>\n",
              "      <td>POINT (3359555.997 8365524.138)</td>\n",
              "      <td>30.179405</td>\n",
              "      <td>59.845969</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2899</td>\n",
              "      <td>—</td>\n",
              "      <td>Мемориал в память обороны города в 1941-1944 г...</td>\n",
              "      <td>1944</td>\n",
              "      <td>Петергофское шоссе, 16-км (около Тамбасова ул.)</td>\n",
              "      <td>объект культурного наследия федерального значения</td>\n",
              "      <td>Постановление Правительства РФ № 527 от 10.07....</td>\n",
              "      <td>Памятник</td>\n",
              "      <td>POINT (3357077.023 8365562.254)</td>\n",
              "      <td>30.157136</td>\n",
              "      <td>59.846141</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2900</td>\n",
              "      <td>—</td>\n",
              "      <td>Матисов канал</td>\n",
              "      <td>1800-около</td>\n",
              "      <td>Петергофское шоссе, в створе 2-й Комсомольской...</td>\n",
              "      <td>объект культурного наследия регионального знач...</td>\n",
              "      <td>Распоряжение мэра Санкт-Петербурга № 108-р от ...</td>\n",
              "      <td>Памятник</td>\n",
              "      <td>POINT (3355630.204 8367035.215)</td>\n",
              "      <td>30.144139</td>\n",
              "      <td>59.852787</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-ad750538-b865-44b9-b8c7-d02190e1d177')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-ad750538-b865-44b9-b8c7-d02190e1d177 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-ad750538-b865-44b9-b8c7-d02190e1d177');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-5ec2c74c-a37e-42ab-b591-319d4593795a\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-5ec2c74c-a37e-42ab-b591-319d4593795a')\"\n",
              "            title=\"Suggest charts.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-5ec2c74c-a37e-42ab-b591-319d4593795a button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 92
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# TODO сохранить слой в географической проекции в формате GeoJSON\n",
        "gdf.to_crs(4326).to_file('KGIOP.geojson', driver='GeoJSON')"
      ],
      "metadata": {
        "id": "9Dpv_9sEzGV-"
      },
      "execution_count": 105,
      "outputs": []
    }
  ]
}