plotador_trafico.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/jespimentel/sis_geo/blob/main/plotador_trafico.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "STCg_Fr0BKKQ"
      },
      "outputs": [],
      "source": [
        "import pandas as pd\n",
        "\n",
        "import folium, random\n",
        "from folium.plugins import HeatMap, TagFilterButton"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "from google.colab import drive\n",
        "drive.mount('/content/drive')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "MFGkRrQTHPTi",
        "outputId": "94524027-4ef0-4b39-dbbe-a3844735e46a"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Drive already mounted at /content/drive; to attempt to forcibly remount, call drive.mount(\"/content/drive\", force_remount=True).\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "lDRu7llmBKKe",
        "outputId": "759b6f67-2921-4fd5-f501-638a000d6204"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 3168 entries, 0 to 3167\n",
            "Data columns (total 14 columns):\n",
            " #   Column                Non-Null Count  Dtype  \n",
            "---  ------                --------------  -----  \n",
            " 0   Número TJ             3168 non-null   object \n",
            " 1   Número MP             3168 non-null   object \n",
            " 2   Tipo de Procedimento  3168 non-null   object \n",
            " 3   Situação              3168 non-null   object \n",
            " 4   Delegacia             3164 non-null   object \n",
            " 5   Assunto               3168 non-null   object \n",
            " 6   DtFatoInicial         3168 non-null   object \n",
            " 7   Violência Doméstica   3167 non-null   object \n",
            " 8   Município             3168 non-null   object \n",
            " 9   Logradouro            3168 non-null   object \n",
            " 10  Num_Logradouro        2904 non-null   object \n",
            " 11  Bairro                3019 non-null   object \n",
            " 12  Latitude              3168 non-null   float64\n",
            " 13  Longitude             3168 non-null   float64\n",
            "dtypes: float64(2), object(12)\n",
            "memory usage: 346.6+ KB\n"
          ]
        }
      ],
      "source": [
        "df_1 = pd.read_csv('/content/drive/MyDrive/Datasets/sis_geo/registros_nos_limites_0_2000.csv')\n",
        "df_2 = pd.read_csv('/content/drive/MyDrive/Datasets/sis_geo/registros_nos_limites_2001_3314.csv')\n",
        "df_partes = pd.read_csv('/content/drive/MyDrive/Datasets/sis_geo/partes.csv')\n",
        "df = pd.concat([df_1,df_2] , ignore_index=True)\n",
        "df.info()"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "print(df_partes.info())"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Jt_Y4YXay52e",
        "outputId": "69bdeae2-b0ba-4a24-a2a5-3ac80ad4f31b"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 3592 entries, 0 to 3591\n",
            "Data columns (total 2 columns):\n",
            " #   Column     Non-Null Count  Dtype \n",
            "---  ------     --------------  ----- \n",
            " 0   Número MP  3592 non-null   object\n",
            " 1   Partes     3592 non-null   object\n",
            "dtypes: object(2)\n",
            "memory usage: 56.2+ KB\n",
            "None\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df['Assunto'].value_counts().head(10)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "7Fu_vC2nPyWL",
        "outputId": "b0bed425-6684-4d28-81be-a11ec90f27d7"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              " Ameaça                                764\n",
              " Tráfico de Drogas e Condutas Afins    593\n",
              " Contra a Mulher                       193\n",
              " Furto Qualificado                     185\n",
              " Vias de fato                          183\n",
              " Furto                                 138\n",
              " Injúria                               130\n",
              " Homicídio Qualificado                  91\n",
              " Estelionato                            59\n",
              " Estupro de vulnerável                  57\n",
              "Name: Assunto, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "eCA48ObjBKKf",
        "outputId": "f752fa56-e0aa-488c-e814-9f9f40c3e498"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                   Número MP                  Número TJ  \\\n",
              "7     13.0723.0002119/2023-7  1500815-66.2023.8.26.0599   \n",
              "10    13.0723.0002017/2023-0  1500799-15.2023.8.26.0599   \n",
              "23    13.0723.0002094/2023-5  1500780-09.2023.8.26.0599   \n",
              "42    24.0723.0001815/2023-9  1500730-80.2023.8.26.0599   \n",
              "62    13.0723.0001817/2023-8  1500714-29.2023.8.26.0599   \n",
              "...                      ...                        ...   \n",
              "3127  13.0723.0000083/2022-4  1500045-10.2022.8.26.0599   \n",
              "3147  13.0723.0000219/2022-2  1500018-27.2022.8.26.0599   \n",
              "3149  13.0723.0000560/2022-4  1500014-87.2022.8.26.0599   \n",
              "3150  13.0723.0000447/2022-1  1500016-57.2022.8.26.0599   \n",
              "3153  13.0723.0000239/2022-0  1500009-65.2022.8.26.0599   \n",
              "\n",
              "                                 Assunto DtFatoInicial  Latitude  Longitude  \n",
              "7     Tráfico de Drogas e Condutas Afins    2023-04-13 -22.74584  -47.67720  \n",
              "10    Tráfico de Drogas e Condutas Afins    2023-04-11 -22.67482  -47.69167  \n",
              "23    Tráfico de Drogas e Condutas Afins    2023-04-06 -22.67035  -47.65785  \n",
              "42    Tráfico de Drogas e Condutas Afins    2023-03-30 -22.76780  -47.62849  \n",
              "62    Tráfico de Drogas e Condutas Afins    2023-03-27 -22.75088  -47.65960  \n",
              "...                                  ...           ...       ...        ...  \n",
              "3127  Tráfico de Drogas e Condutas Afins    2022-01-05 -22.75249  -47.63069  \n",
              "3147  Tráfico de Drogas e Condutas Afins    2022-01-03 -22.75581  -47.65983  \n",
              "3149  Tráfico de Drogas e Condutas Afins    2022-01-03 -22.69542  -47.66435  \n",
              "3150  Tráfico de Drogas e Condutas Afins    2022-01-03 -22.67422  -47.69469  \n",
              "3153  Tráfico de Drogas e Condutas Afins    2022-01-02 -22.74385  -47.65958  \n",
              "\n",
              "[529 rows x 6 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-21cb2837-a35e-440f-a9f8-3e21e7c9ba8f\">\n",
              "    <div 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>Número MP</th>\n",
              "      <th>Número TJ</th>\n",
              "      <th>Assunto</th>\n",
              "      <th>DtFatoInicial</th>\n",
              "      <th>Latitude</th>\n",
              "      <th>Longitude</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>13.0723.0002119/2023-7</td>\n",
              "      <td>1500815-66.2023.8.26.0599</td>\n",
              "      <td>Tráfico de Drogas e Condutas Afins</td>\n",
              "      <td>2023-04-13</td>\n",
              "      <td>-22.74584</td>\n",
              "      <td>-47.67720</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>13.0723.0002017/2023-0</td>\n",
              "      <td>1500799-15.2023.8.26.0599</td>\n",
              "      <td>Tráfico de Drogas e Condutas Afins</td>\n",
              "      <td>2023-04-11</td>\n",
              "      <td>-22.67482</td>\n",
              "      <td>-47.69167</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>13.0723.0002094/2023-5</td>\n",
              "      <td>1500780-09.2023.8.26.0599</td>\n",
              "      <td>Tráfico de Drogas e Condutas Afins</td>\n",
              "      <td>2023-04-06</td>\n",
              "      <td>-22.67035</td>\n",
              "      <td>-47.65785</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>24.0723.0001815/2023-9</td>\n",
              "      <td>1500730-80.2023.8.26.0599</td>\n",
              "      <td>Tráfico de Drogas e Condutas Afins</td>\n",
              "      <td>2023-03-30</td>\n",
              "      <td>-22.76780</td>\n",
              "      <td>-47.62849</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>62</th>\n",
              "      <td>13.0723.0001817/2023-8</td>\n",
              "      <td>1500714-29.2023.8.26.0599</td>\n",
              "      <td>Tráfico de Drogas e Condutas Afins</td>\n",
              "      <td>2023-03-27</td>\n",
              "      <td>-22.75088</td>\n",
              "      <td>-47.65960</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3127</th>\n",
              "      <td>13.0723.0000083/2022-4</td>\n",
              "      <td>1500045-10.2022.8.26.0599</td>\n",
              "      <td>Tráfico de Drogas e Condutas Afins</td>\n",
              "      <td>2022-01-05</td>\n",
              "      <td>-22.75249</td>\n",
              "      <td>-47.63069</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3147</th>\n",
              "      <td>13.0723.0000219/2022-2</td>\n",
              "      <td>1500018-27.2022.8.26.0599</td>\n",
              "      <td>Tráfico de Drogas e Condutas Afins</td>\n",
              "      <td>2022-01-03</td>\n",
              "      <td>-22.75581</td>\n",
              "      <td>-47.65983</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3149</th>\n",
              "      <td>13.0723.0000560/2022-4</td>\n",
              "      <td>1500014-87.2022.8.26.0599</td>\n",
              "      <td>Tráfico de Drogas e Condutas Afins</td>\n",
              "      <td>2022-01-03</td>\n",
              "      <td>-22.69542</td>\n",
              "      <td>-47.66435</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3150</th>\n",
              "      <td>13.0723.0000447/2022-1</td>\n",
              "      <td>1500016-57.2022.8.26.0599</td>\n",
              "      <td>Tráfico de Drogas e Condutas Afins</td>\n",
              "      <td>2022-01-03</td>\n",
              "      <td>-22.67422</td>\n",
              "      <td>-47.69469</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3153</th>\n",
              "      <td>13.0723.0000239/2022-0</td>\n",
              "      <td>1500009-65.2022.8.26.0599</td>\n",
              "      <td>Tráfico de Drogas e Condutas Afins</td>\n",
              "      <td>2022-01-02</td>\n",
              "      <td>-22.74385</td>\n",
              "      <td>-47.65958</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>529 rows × 6 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-21cb2837-a35e-440f-a9f8-3e21e7c9ba8f')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-21cb2837-a35e-440f-a9f8-3e21e7c9ba8f 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-21cb2837-a35e-440f-a9f8-3e21e7c9ba8f');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 6
        }
      ],
      "source": [
        "# Criando novo dataframe com o assunto que interessa\n",
        "\n",
        "criterio = (df['Assunto'] == ' Tráfico de Drogas e Condutas Afins') & (df['Situação'] == 'DENUNCIADO')\n",
        "df_filtrado = df.loc[criterio][['Número MP', 'Número TJ', 'Assunto', 'DtFatoInicial','Latitude','Longitude']]\n",
        "df_filtrado['Assunto'] = df_filtrado['Assunto'].apply(lambda x: x.strip())\n",
        "df_filtrado"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Converter a coluna 'DtFatoInicial' para o tipo datetime\n",
        "df_filtrado['DtFatoInicial'] = pd.to_datetime(df_filtrado['DtFatoInicial'], dayfirst=False)\n",
        "df_filtrado['DiaDaSemana'] = df_filtrado['DtFatoInicial'].dt.day_name()\n",
        "df_filtrado['DtFatoInicial'] = df_filtrado['DtFatoInicial'].dt.strftime('%d/%m/%Y')\n",
        "\n",
        "traducao_dias_semana = {\n",
        "    'Monday': 'Segunda-feira',\n",
        "    'Tuesday': 'Terça-feira',\n",
        "    'Wednesday': 'Quarta-feira',\n",
        "    'Thursday': 'Quinta-feira',\n",
        "    'Friday': 'Sexta-feira',\n",
        "    'Saturday': 'Sábado',\n",
        "    'Sunday': 'Domingo'\n",
        "}\n",
        "\n",
        "df_filtrado['DiaDaSemana'] = df_filtrado['DiaDaSemana'].map(traducao_dias_semana)\n",
        "\n",
        "df_filtrado"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "WH7Wl_3i1HYR",
        "outputId": "0a372585-974d-46dd-850f-affb5b070f9b"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                   Número MP                  Número TJ  \\\n",
              "7     13.0723.0002119/2023-7  1500815-66.2023.8.26.0599   \n",
              "10    13.0723.0002017/2023-0  1500799-15.2023.8.26.0599   \n",
              "23    13.0723.0002094/2023-5  1500780-09.2023.8.26.0599   \n",
              "42    24.0723.0001815/2023-9  1500730-80.2023.8.26.0599   \n",
              "62    13.0723.0001817/2023-8  1500714-29.2023.8.26.0599   \n",
              "...                      ...                        ...   \n",
              "3127  13.0723.0000083/2022-4  1500045-10.2022.8.26.0599   \n",
              "3147  13.0723.0000219/2022-2  1500018-27.2022.8.26.0599   \n",
              "3149  13.0723.0000560/2022-4  1500014-87.2022.8.26.0599   \n",
              "3150  13.0723.0000447/2022-1  1500016-57.2022.8.26.0599   \n",
              "3153  13.0723.0000239/2022-0  1500009-65.2022.8.26.0599   \n",
              "\n",
              "                                 Assunto DtFatoInicial  Latitude  Longitude  \\\n",
              "7     Tráfico de Drogas e Condutas Afins    13/04/2023 -22.74584  -47.67720   \n",
              "10    Tráfico de Drogas e Condutas Afins    11/04/2023 -22.67482  -47.69167   \n",
              "23    Tráfico de Drogas e Condutas Afins    06/04/2023 -22.67035  -47.65785   \n",
              "42    Tráfico de Drogas e Condutas Afins    30/03/2023 -22.76780  -47.62849   \n",
              "62    Tráfico de Drogas e Condutas Afins    27/03/2023 -22.75088  -47.65960   \n",
              "...                                  ...           ...       ...        ...   \n",
              "3127  Tráfico de Drogas e Condutas Afins    05/01/2022 -22.75249  -47.63069   \n",
              "3147  Tráfico de Drogas e Condutas Afins    03/01/2022 -22.75581  -47.65983   \n",
              "3149  Tráfico de Drogas e Condutas Afins    03/01/2022 -22.69542  -47.66435   \n",
              "3150  Tráfico de Drogas e Condutas Afins    03/01/2022 -22.67422  -47.69469   \n",
              "3153  Tráfico de Drogas e Condutas Afins    02/01/2022 -22.74385  -47.65958   \n",
              "\n",
              "        DiaDaSemana  \n",
              "7      Quinta-feira  \n",
              "10      Terça-feira  \n",
              "23     Quinta-feira  \n",
              "42     Quinta-feira  \n",
              "62    Segunda-feira  \n",
              "...             ...  \n",
              "3127   Quarta-feira  \n",
              "3147  Segunda-feira  \n",
              "3149  Segunda-feira  \n",
              "3150  Segunda-feira  \n",
              "3153        Domingo  \n",
              "\n",
              "[529 rows x 7 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-586ad175-369a-4998-a26e-76e3deee72ca\">\n",
              "    <div 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>Número MP</th>\n",
              "      <th>Número TJ</th>\n",
              "      <th>Assunto</th>\n",
              "      <th>DtFatoInicial</th>\n",
              "      <th>Latitude</th>\n",
              "      <th>Longitude</th>\n",
              "      <th>DiaDaSemana</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>13.0723.0002119/2023-7</td>\n",
              "      <td>1500815-66.2023.8.26.0599</td>\n",
              "      <td>Tráfico de Drogas e Condutas Afins</td>\n",
              "      <td>13/04/2023</td>\n",
              "      <td>-22.74584</td>\n",
              "      <td>-47.67720</td>\n",
              "      <td>Quinta-feira</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>13.0723.0002017/2023-0</td>\n",
              "      <td>1500799-15.2023.8.26.0599</td>\n",
              "      <td>Tráfico de Drogas e Condutas Afins</td>\n",
              "      <td>11/04/2023</td>\n",
              "      <td>-22.67482</td>\n",
              "      <td>-47.69167</td>\n",
              "      <td>Terça-feira</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>13.0723.0002094/2023-5</td>\n",
              "      <td>1500780-09.2023.8.26.0599</td>\n",
              "      <td>Tráfico de Drogas e Condutas Afins</td>\n",
              "      <td>06/04/2023</td>\n",
              "      <td>-22.67035</td>\n",
              "      <td>-47.65785</td>\n",
              "      <td>Quinta-feira</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>24.0723.0001815/2023-9</td>\n",
              "      <td>1500730-80.2023.8.26.0599</td>\n",
              "      <td>Tráfico de Drogas e Condutas Afins</td>\n",
              "      <td>30/03/2023</td>\n",
              "      <td>-22.76780</td>\n",
              "      <td>-47.62849</td>\n",
              "      <td>Quinta-feira</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>62</th>\n",
              "      <td>13.0723.0001817/2023-8</td>\n",
              "      <td>1500714-29.2023.8.26.0599</td>\n",
              "      <td>Tráfico de Drogas e Condutas Afins</td>\n",
              "      <td>27/03/2023</td>\n",
              "      <td>-22.75088</td>\n",
              "      <td>-47.65960</td>\n",
              "      <td>Segunda-feira</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3127</th>\n",
              "      <td>13.0723.0000083/2022-4</td>\n",
              "      <td>1500045-10.2022.8.26.0599</td>\n",
              "      <td>Tráfico de Drogas e Condutas Afins</td>\n",
              "      <td>05/01/2022</td>\n",
              "      <td>-22.75249</td>\n",
              "      <td>-47.63069</td>\n",
              "      <td>Quarta-feira</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3147</th>\n",
              "      <td>13.0723.0000219/2022-2</td>\n",
              "      <td>1500018-27.2022.8.26.0599</td>\n",
              "      <td>Tráfico de Drogas e Condutas Afins</td>\n",
              "      <td>03/01/2022</td>\n",
              "      <td>-22.75581</td>\n",
              "      <td>-47.65983</td>\n",
              "      <td>Segunda-feira</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3149</th>\n",
              "      <td>13.0723.0000560/2022-4</td>\n",
              "      <td>1500014-87.2022.8.26.0599</td>\n",
              "      <td>Tráfico de Drogas e Condutas Afins</td>\n",
              "      <td>03/01/2022</td>\n",
              "      <td>-22.69542</td>\n",
              "      <td>-47.66435</td>\n",
              "      <td>Segunda-feira</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3150</th>\n",
              "      <td>13.0723.0000447/2022-1</td>\n",
              "      <td>1500016-57.2022.8.26.0599</td>\n",
              "      <td>Tráfico de Drogas e Condutas Afins</td>\n",
              "      <td>03/01/2022</td>\n",
              "      <td>-22.67422</td>\n",
              "      <td>-47.69469</td>\n",
              "      <td>Segunda-feira</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3153</th>\n",
              "      <td>13.0723.0000239/2022-0</td>\n",
              "      <td>1500009-65.2022.8.26.0599</td>\n",
              "      <td>Tráfico de Drogas e Condutas Afins</td>\n",
              "      <td>02/01/2022</td>\n",
              "      <td>-22.74385</td>\n",
              "      <td>-47.65958</td>\n",
              "      <td>Domingo</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>529 rows × 7 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-586ad175-369a-4998-a26e-76e3deee72ca')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-586ad175-369a-4998-a26e-76e3deee72ca 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-586ad175-369a-4998-a26e-76e3deee72ca');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Mapa de calor\n",
        "\n",
        "# Extrai as colunas de latitude e longitude do dataset\n",
        "latitude = df_filtrado['Latitude']\n",
        "longitude = df_filtrado['Longitude']\n",
        "\n",
        "PIRA_COORDINATES = (-22.769960, -47.647579)\n",
        "\n",
        "# Cria um mapa vazio em Piracicaba\n",
        "mapa = folium.Map(location=PIRA_COORDINATES, zoom_start=12)\n",
        "\n",
        "# Agrupa as coordenadas de latitude e longitude em uma lista\n",
        "dados = list(zip(latitude, longitude))\n",
        "\n",
        "# Adiciona o mapa de calor\n",
        "heatmap = HeatMap(dados).add_to(mapa)\n",
        "\n",
        "# Adiciona um título ao mapa\n",
        "title_html = \"\"\"\n",
        "<h1 style=\"text-align:center;\"><b>Mapa de calor do tráfico - denunciados para data do fato entre 01/01/2022 e 24/04/2023</b></h1>\n",
        "<h2 style=\"text-align:center;\"><b>Base: SISMP INTEGRADO - Extração em 24/04/2023</b></h2>\n",
        "\"\"\"\n",
        "mapa.get_root().html.add_child(folium.Element(title_html))\n",
        "\n",
        "folium.TileLayer('openstreetmap').add_to(mapa)\n",
        "folium.LayerControl().add_to(mapa)\n",
        "\n",
        "# Salva o mapa em um arquivo HTML\n",
        "mapa.save(\"heatmap_trafico.html\")\n",
        "mapa"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "xsIMzkBtSa1A",
        "outputId": "8eb3ae54-c81a-437f-c1d7-ecbf556c08d8"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<folium.folium.Map at 0x7f36e9aba560>"
            ],
            "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_b9e4a3d2ff76a825fbd4d96fa2ee9d45 {\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",
              "    &lt;script src=&quot;https://cdn.jsdelivr.net/gh/python-visualization/folium@main/folium/templates/leaflet_heat.min.js&quot;&gt;&lt;/script&gt;\n",
              "&lt;/head&gt;\n",
              "&lt;body&gt;\n",
              "    \n",
              "    \n",
              "&lt;h1 style=&quot;text-align:center;&quot;&gt;&lt;b&gt;Mapa de calor do tráfico - denunciados para data do fato entre 01/01/2022 e 24/04/2023&lt;/b&gt;&lt;/h1&gt;\n",
              "&lt;h2 style=&quot;text-align:center;&quot;&gt;&lt;b&gt;Base: SISMP INTEGRADO - Extração em 24/04/2023&lt;/b&gt;&lt;/h2&gt;\n",
              "    \n",
              "            &lt;div class=&quot;folium-map&quot; id=&quot;map_b9e4a3d2ff76a825fbd4d96fa2ee9d45&quot; &gt;&lt;/div&gt;\n",
              "        \n",
              "&lt;/body&gt;\n",
              "&lt;script&gt;\n",
              "    \n",
              "    \n",
              "            var map_b9e4a3d2ff76a825fbd4d96fa2ee9d45 = L.map(\n",
              "                &quot;map_b9e4a3d2ff76a825fbd4d96fa2ee9d45&quot;,\n",
              "                {\n",
              "                    center: [-22.76996, -47.647579],\n",
              "                    crs: L.CRS.EPSG3857,\n",
              "                    zoom: 12,\n",
              "                    zoomControl: true,\n",
              "                    preferCanvas: false,\n",
              "                }\n",
              "            );\n",
              "\n",
              "            \n",
              "\n",
              "        \n",
              "    \n",
              "            var tile_layer_7c0ee63f36c22a71427b78cb134c752e = 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_b9e4a3d2ff76a825fbd4d96fa2ee9d45);\n",
              "        \n",
              "    \n",
              "            var heat_map_360f623c9a168eadd54235aeb4f4d0b5 = L.heatLayer(\n",
              "                [[-22.74584, -47.6772], [-22.67482, -47.69167], [-22.67035, -47.65785], [-22.7678, -47.62849], [-22.75088, -47.6596], [-22.75248, -47.65652], [-22.73581, -47.53893], [-22.73619, -47.65553], [-22.67309, -47.70067], [-22.66664, -47.67742], [-22.68174, -47.72457], [-22.74845, -47.68992], [-22.74415, -47.65922], [-22.67035, -47.65785], [-22.74513, -47.62334], [-22.76917, -47.62556], [-22.75276, -47.67679], [-22.72069, -47.64558], [-22.72732, -47.64575], [-22.77554, -47.59261], [-22.66783, -47.66167], [-22.67089, -47.69323], [-22.67527, -47.70332], [-22.74059, -47.62954], [-22.73951, -47.62913], [-22.77054, -47.62693], [-22.6681, -47.68109], [-22.74307, -47.66214], [-22.69908, -47.63997], [-22.72028, -47.63474], [-22.73966, -47.62916], [-22.72285, -47.59404], [-22.75669, -47.66072], [-22.75917, -47.67817], [-22.78271, -47.67436], [-22.76061, -47.68011], [-22.76925, -47.62667], [-22.76031, -47.60931], [-22.67286, -47.70137], [-22.68225, -47.72581], [-22.66784, -47.66169], [-22.74724, -47.67485], [-22.7701, -47.62558], [-22.73072, -47.63097], [-22.72759, -47.64604], [-22.76127, -47.60974], [-22.6869, -47.63465], [-22.75519, -47.65922], [-22.67623, -47.7114], [-22.74584, -47.6772], [-22.73987, -47.62865], [-22.74584, -47.6772], [-22.74113, -47.62863], [-22.72087, -47.64458], [-22.75676, -47.65143], [-22.76253, -47.61966], [-22.76897, -47.6264], [-22.74673, -47.6535], [-22.76096, -47.61009], [-22.69251, -47.67004], [-22.75858, -47.67926], [-22.75737, -47.66175], [-22.73755, -47.6435], [-22.75846, -47.61107], [-22.74573, -47.65658], [-22.67106, -47.65963], [-22.76705, -47.63133], [-22.76753, -47.64331], [-22.78188, -47.6683], [-22.67286, -47.70176], [-22.70318, -47.66157], [-22.74584, -47.6772], [-22.75916, -47.6107], [-22.76897, -47.6264], [-22.67119, -47.65991], [-22.75569, -47.65171], [-22.76947, -47.62672], [-22.67706, -47.70791], [-22.68064, -47.72727], [-22.70239, -47.61034], [-22.76093, -47.65179], [-22.75618, -47.66275], [-22.75906, -47.61502], [-22.74174, -47.6546], [-22.66797, -47.65799], [-22.74218, -47.65266], [-22.76093, -47.65179], [-22.67982, -47.67799], [-22.76884, -47.62588], [-22.74843, -47.68628], [-22.67088, -47.69803], [-22.76936, -47.63339], [-22.74464, -47.6586], [-22.74577, -47.65642], [-22.74673, -47.65333], [-22.74955, -47.68545], [-22.74584, -47.6772], [-22.67951, -47.68002], [-22.72814, -47.64397], [-22.75788, -47.63958], [-22.7563, -47.64001], [-22.77018, -47.60474], [-22.74975, -47.66078], [-22.71968, -47.68455], [-22.705, -47.66827], [-22.67165, -47.69925], [-22.75739, -47.65698], [-22.67125, -47.66006], [-22.74552, -47.67253], [-22.80215, -47.94166], [-22.76926, -47.63332], [-22.76603, -47.6226], [-22.6705, -47.6583], [-22.75982, -47.67634], [-22.75115, -47.59048], [-22.75389, -47.64982], [-22.75594, -47.65168], [-22.74655, -47.65555], [-22.66605, -47.65739], [-22.74842, -47.67136], [-22.67291, -47.70275], [-22.75252, -47.6603], [-22.67088, -47.69803], [-22.72699, -47.64644], [-22.76965, -47.62606], [-22.76891, -47.62686], [-22.76792, -47.62757], [-22.68128, -47.66889], [-22.75976, -47.65148], [-22.73456, -47.63085], [-22.6869, -47.63465], [-22.75714, -47.65652], [-22.67575, -47.68534], [-22.74673, -47.6533], [-22.67016, -47.66053], [-22.76124, -47.67666], [-22.74866, -47.68562], [-22.68291, -47.65875], [-22.74116, -47.62805], [-22.76862, -47.62648], [-22.67316, -47.69275], [-22.76863, -47.62654], [-22.74673, -47.65351], [-22.67369, -47.69335], [-22.75358, -47.64952], [-22.77309, -47.59417], [-22.73911, -47.62156], [-22.74673, -47.65346], [-22.72643, -47.63429], [-22.76952, -47.62603], [-22.75407, -47.65327], [-22.75594, -47.65168], [-22.75816, -47.64028], [-22.76936, -47.62681], [-22.74345, -47.66071], [-22.74749, -47.65677], [-22.67951, -47.68002], [-22.74851, -47.68502], [-22.75882, -47.61106], [-22.67106, -47.65963], [-22.736, -47.66222], [-22.74314, -47.62515], [-22.74673, -47.65343], [-22.77308, -47.59368], [-22.67165, -47.69925], [-22.75816, -47.64028], [-22.75669, -47.66072], [-22.77625, -47.59274], [-22.74594, -47.65562], [-22.67379, -47.70025], [-22.7679, -47.62751], [-22.74673, -47.65333], [-22.73901, -47.62993], [-22.75564, -47.65151], [-22.66854, -47.65938], [-22.74584, -47.6772], [-22.74531, -47.6779], [-22.76851, -47.62569], [-22.75504, -47.67836], [-22.74965, -47.67399], [-22.7612, -47.61524], [-22.74622, -47.67665], [-22.76925, -47.62667], [-22.73978, -47.62918], [-22.7431, -47.66263], [-22.74584, -47.6772], [-22.74421, -47.65908], [-22.75848, -47.63953], [-22.67309, -47.70067], [-22.73555, -47.66858], [-22.67165, -47.69925], [-22.72437, -47.64418], [-22.74107, -47.63216], [-22.7403, -47.62983], [-22.74241, -47.67492], [-22.74072, -47.62937], [-22.72609, -47.66043], [-22.67066, -47.6997], [-22.75765, -47.66013], [-22.73978, -47.62918], [-22.75765, -47.66013], [-22.7431, -47.66259], [-22.75933, -47.65205], [-22.77002, -47.59893], [-22.73887, -47.62291], [-22.76915, -47.59964], [-22.74375, -47.60856], [-22.75411, -47.65004], [-22.67341, -47.70278], [-22.67022, -47.65745], [-22.67119, -47.65991], [-22.67163, -47.66083], [-22.75737, -47.66175], [-22.74122, -47.65347], [-22.73989, -47.62905], [-22.67037, -47.66173], [-22.76945, -47.62693], [-22.75158, -47.65832], [-22.74619, -47.65525], [-22.74814, -47.65341], [-22.7707, -47.62567], [-22.74308, -47.66209], [-22.67119, -47.65991], [-22.76926, -47.63332], [-22.67099, -47.70352], [-22.7687, -47.62596], [-22.75687, -47.65062], [-22.75348, -47.66026], [-22.77309, -47.59417], [-22.74305, -47.65969], [-22.74479, -47.65387], [-22.69441, -47.67117], [-22.75716, -47.67855], [-22.76855, -47.62694], [-22.73978, -47.62918], [-22.73535, -47.53917], [-22.7467, -47.65332], [-22.67094, -47.70353], [-22.74612, -47.65336], [-22.67123, -47.66029], [-22.76999, -47.62601], [-22.66055, -47.69062], [-22.67119, -47.65991], [-22.71966, -47.63002], [-22.74059, -47.62954], [-22.72765, -47.64611], [-22.74278, -47.65881], [-22.76897, -47.6264], [-22.66456, -47.65549], [-22.75411, -47.65004], [-22.76952, -47.62603], [-22.76603, -47.6226], [-22.76999, -47.62587], [-22.75751, -47.66043], [-22.76974, -47.62641], [-22.75966, -47.59997], [-22.74308, -47.66208], [-22.67575, -47.68534], [-22.76933, -47.62677], [-22.74435, -47.66015], [-22.74673, -47.65327], [-22.76897, -47.62645], [-22.77532, -47.63334], [-22.66411, -47.66021], [-22.66782, -47.66167], [-22.76897, -47.6264], [-22.67203, -47.6619], [-22.75661, -47.63807], [-22.70419, -47.65788], [-22.74621, -47.65524], [-22.75946, -47.60041], [-22.76801, -47.62763], [-22.74673, -47.65333], [-22.74598, -47.65559], [-22.76573, -47.58752], [-22.76925, -47.62667], [-22.75363, -47.65007], [-22.75705, -47.6784], [-22.74619, -47.65525], [-22.67593, -47.69073], [-22.74657, -47.654], [-22.75899, -47.63774], [-22.73917, -47.62793], [-22.74108, -47.62214], [-22.71688, -47.6342], [-22.76933, -47.62677], [-22.76975, -47.63479], [-22.7544, -47.66829], [-22.76845, -47.62923], [-22.75594, -47.66431], [-22.75733, -47.67772], [-22.73886, -47.62951], [-22.74005, -47.62823], [-22.68468, -47.65629], [-22.67443, -47.69782], [-22.76897, -47.6264], [-22.76897, -47.6264], [-22.73551, -47.64139], [-22.74648, -47.65467], [-22.75751, -47.66043], [-22.74539, -47.65613], [-22.74673, -47.65343], [-22.73702, -47.66838], [-22.74403, -47.65951], [-22.6708, -47.68707], [-22.74571, -47.65584], [-22.75221, -47.65913], [-22.75152, -47.66216], [-22.74621, -47.65524], [-22.67423, -47.69796], [-22.74629, -47.65296], [-22.67165, -47.69925], [-22.75949, -47.67777], [-22.70238, -47.66621], [-22.76756, -47.5974], [-22.74621, -47.65524], [-22.73512, -47.64104], [-22.67109, -47.66028], [-22.69793, -47.66794], [-22.67379, -47.67089], [-22.74621, -47.65524], [-22.66882, -47.65623], [-22.75485, -47.649], [-22.7636, -47.58671], [-22.75167, -47.65122], [-22.66782, -47.66167], [-22.7383, -47.59911], [-22.75602, -47.68065], [-22.77111, -47.59721], [-22.77187, -47.62557], [-22.70488, -47.66864], [-22.74799, -47.66399], [-22.76897, -47.6264], [-22.66404, -47.65969], [-22.74553, -47.64769], [-22.74235, -47.60139], [-22.76897, -47.6264], [-22.7439, -47.65944], [-22.67025, -47.66341], [-22.76926, -47.63332], [-22.75785, -47.65385], [-22.75933, -47.65205], [-22.74664, -47.65361], [-22.70618, -47.65688], [-22.74428, -47.6749], [-22.7003, -47.66867], [-22.67138, -47.66028], [-22.72699, -47.64644], [-22.75382, -47.6424], [-22.75753, -47.65853], [-22.74668, -47.65395], [-22.7582, -47.67901], [-22.74611, -47.67668], [-22.74927, -47.62257], [-22.76936, -47.62681], [-22.74973, -47.68491], [-22.72699, -47.64644], [-22.75549, -47.66368], [-22.72657, -47.64674], [-22.67606, -47.68116], [-22.76868, -47.62655], [-22.7396, -47.62931], [-22.66332, -47.69882], [-22.7679, -47.62751], [-22.75115, -47.65896], [-22.74393, -47.65936], [-22.73627, -47.53993], [-22.7541, -47.65021], [-22.75618, -47.66275], [-22.74607, -47.6553], [-22.67106, -47.65963], [-22.75737, -47.66175], [-22.67217, -47.6946], [-22.67633, -47.71508], [-22.77309, -47.59417], [-22.73555, -47.66858], [-22.77017, -47.5985], [-22.72562, -47.64615], [-22.73974, -47.62924], [-22.73994, -47.60237], [-22.74008, -47.63019], [-22.76946, -47.63316], [-22.75613, -47.6629], [-22.7722, -47.59522], [-22.74189, -47.65305], [-22.74265, -47.64224], [-22.75972, -47.67787], [-22.72324, -47.65201], [-22.66778, -47.67916], [-22.74311, -47.66259], [-22.76945, -47.63386], [-22.72768, -47.62074], [-22.75752, -47.65099], [-22.66491, -47.65837], [-22.67113, -47.66015], [-22.77268, -47.59408], [-22.73985, -47.62911], [-22.67196, -47.70066], [-22.69198, -47.66495], [-22.70151, -47.66079], [-22.75746, -47.65746], [-22.74242, -47.62918], [-22.67053, -47.65838], [-22.70239, -47.61034], [-22.66481, -47.69129], [-22.75369, -47.65384], [-22.7736, -47.59401], [-22.76976, -47.6264], [-22.67311, -47.7005], [-22.67309, -47.70067], [-22.67575, -47.68534], [-22.69155, -47.66738], [-22.74393, -47.65936], [-22.687, -47.63464], [-22.74312, -47.6595], [-22.72768, -47.64656], [-22.75527, -47.65655], [-22.66814, -47.71162], [-22.75618, -47.66301], [-22.74336, -47.67359], [-22.76962, -47.6334], [-22.67018, -47.68787], [-22.74403, -47.65951], [-22.74393, -47.65936], [-22.68174, -47.72457], [-22.69184, -47.66843], [-22.74448, -47.64915], [-22.69121, -47.66789], [-22.75014, -47.68463], [-22.67335, -47.65965], [-22.77457, -47.6039], [-22.67165, -47.69925], [-22.7143, -47.6513], [-22.77107, -47.6334], [-22.73978, -47.62918], [-22.71315, -47.63558], [-22.74027, -47.6298], [-22.75737, -47.66175], [-22.77309, -47.594], [-22.66673, -47.65704], [-22.75152, -47.66216], [-22.66436, -47.77571], [-22.74623, -47.65522], [-22.76962, -47.6334], [-22.75864, -47.67932], [-22.74509, -47.67815], [-22.76832, -47.63313], [-22.7679, -47.62751], [-22.76027, -47.67439], [-22.68252, -47.7246], [-22.77024, -47.59693], [-22.72315, -47.61623], [-22.74692, -47.65714], [-22.67116, -47.70644], [-22.76539, -47.6558], [-22.75933, -47.65205], [-22.73478, -47.66752], [-22.77441, -47.59483], [-22.67108, -47.66168], [-22.77441, -47.59483], [-22.7679, -47.62751], [-22.76952, -47.62603], [-22.7479, -47.65766], [-22.67689, -47.68037], [-22.72317, -47.62623], [-22.67203, -47.6619], [-22.67186, -47.66167], [-22.75105, -47.6618], [-22.7469, -47.65618], [-22.74079, -47.62929], [-22.68128, -47.56938], [-22.73931, -47.62771], [-22.75306, -47.6608], [-22.74377, -47.66019], [-22.76485, -47.58893], [-22.75602, -47.65177], [-22.77026, -47.63445], [-22.67197, -47.66247], [-22.77309, -47.594], [-22.67291, -47.70275], [-22.74764, -47.66325], [-22.75399, -47.65704], [-22.75839, -47.67906], [-22.75321, -47.64871], [-22.75968, -47.61252], [-22.67056, -47.69302], [-22.69155, -47.66738], [-22.67224, -47.70682], [-22.76965, -47.6258], [-22.77291, -47.59382], [-22.67066, -47.6997], [-22.6919, -47.66835], [-22.76952, -47.62603], [-22.74475, -47.66075], [-22.73869, -47.62838], [-22.68128, -47.56938], [-22.75341, -47.66011], [-22.73978, -47.62918], [-22.67066, -47.6997], [-22.72618, -47.64958], [-22.66373, -47.65409], [-22.74594, -47.65562], [-22.76722, -47.62805], [-22.72618, -47.64958], [-22.75796, -47.66021], [-22.67066, -47.6997], [-22.75647, -47.6581], [-22.76997, -47.63481], [-22.74548, -47.64766], [-22.74673, -47.6535], [-22.74536, -47.52559], [-22.74406, -47.65945], [-22.66837, -47.65719], [-22.76984, -47.62631], [-22.7404, -47.59783], [-22.74686, -47.67285], [-22.75286, -47.66049], [-22.76706, -47.62645], [-22.66939, -47.65835], [-22.73978, -47.62918], [-22.74877, -47.65753], [-22.67741, -47.67978], [-22.77094, -47.59753], [-22.77111, -47.59721], [-22.75249, -47.63069], [-22.75581, -47.65983], [-22.69542, -47.66435], [-22.67422, -47.69469], [-22.74385, -47.65958]],\n",
              "                {&quot;blur&quot;: 15, &quot;maxZoom&quot;: 18, &quot;minOpacity&quot;: 0.5, &quot;radius&quot;: 25}\n",
              "            ).addTo(map_b9e4a3d2ff76a825fbd4d96fa2ee9d45);\n",
              "        \n",
              "    \n",
              "            var tile_layer_e3a90bd9c681dd0bfe747a29924a05b6 = 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_b9e4a3d2ff76a825fbd4d96fa2ee9d45);\n",
              "        \n",
              "    \n",
              "            var layer_control_13dccf0cb5b27436e81cfc352fc2e6e8 = {\n",
              "                base_layers : {\n",
              "                    &quot;openstreetmap&quot; : tile_layer_e3a90bd9c681dd0bfe747a29924a05b6,\n",
              "                },\n",
              "                overlays :  {\n",
              "                    &quot;macro_element_360f623c9a168eadd54235aeb4f4d0b5&quot; : heat_map_360f623c9a168eadd54235aeb4f4d0b5,\n",
              "                },\n",
              "            };\n",
              "            L.control.layers(\n",
              "                layer_control_13dccf0cb5b27436e81cfc352fc2e6e8.base_layers,\n",
              "                layer_control_13dccf0cb5b27436e81cfc352fc2e6e8.overlays,\n",
              "                {&quot;autoZIndex&quot;: true, &quot;collapsed&quot;: true, &quot;position&quot;: &quot;topright&quot;}\n",
              "            ).addTo(map_b9e4a3d2ff76a825fbd4d96fa2ee9d45);\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": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "merged_df = pd.merge(df_filtrado, df_partes, on= 'Número MP')\n",
        "merged_df.reset_index(drop=True, inplace=True)\n",
        "merged_df.info()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "0GITABhmUqbQ",
        "outputId": "dd6010e9-2f9a-4ca5-ca27-db0cd8f869b6"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 606 entries, 0 to 605\n",
            "Data columns (total 8 columns):\n",
            " #   Column         Non-Null Count  Dtype  \n",
            "---  ------         --------------  -----  \n",
            " 0   Número MP      606 non-null    object \n",
            " 1   Número TJ      606 non-null    object \n",
            " 2   Assunto        606 non-null    object \n",
            " 3   DtFatoInicial  606 non-null    object \n",
            " 4   Latitude       606 non-null    float64\n",
            " 5   Longitude      606 non-null    float64\n",
            " 6   DiaDaSemana    606 non-null    object \n",
            " 7   Partes         606 non-null    object \n",
            "dtypes: float64(2), object(6)\n",
            "memory usage: 38.0+ KB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "UZvBQPx1BKKf"
      },
      "outputs": [],
      "source": [
        "partes = list(set(merged_df['Partes'].tolist()))\n",
        "dias_da_semana = list(set(df_filtrado['DiaDaSemana'].tolist()))\n",
        "partes [:10]"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Locais da prisão\n",
        "\n",
        "PIRA_COORDINATES = (-22.769960, -47.647579)\n",
        "\n",
        "# Cria um mapa vazio em Piracicaba\n",
        "_map = folium.Map(location=PIRA_COORDINATES, zoom_start=12)\n",
        "\n",
        "# Adiciona um título ao mapa\n",
        "title_html = \"\"\"\n",
        "<h1 style=\"text-align:center;\"><b>Tráficos denunciados para data do fato entre 01/01/2022 e 24/04/2023</b></h1>\n",
        "<h2 style=\"text-align:center;\"><b>Base: SISMP INTEGRADO - Extração em 24/04/2023</b></h2>\n",
        "\"\"\"\n",
        "_map.get_root().html.add_child(folium.Element(title_html))\n",
        "\n",
        "# Adiciona o marcador para cada ocorrência\n",
        "for each in merged_df.iterrows():\n",
        "    parte = each[1]['Partes']\n",
        "    dia_da_semana = each[1]['DiaDaSemana']\n",
        "    folium.Marker(\n",
        "        location=[each[1][\"Latitude\"], each[1][\"Longitude\"]],\n",
        "        clustered_marker=True,\n",
        "        tags=[dia_da_semana],\n",
        "        popup=f\"{parte}<br>{each[1]['DtFatoInicial']}<br>{each[1]['Número TJ']}<br>{each[1]['DiaDaSemana']}\",\n",
        "    ).add_to(_map)\n",
        "\n",
        "# Adiciona botões de filtro por tag\n",
        "TagFilterButton(dias_da_semana, clear_text=\"Todos\",name='DiaDaSemana').add_to(_map)\n",
        "\n",
        "display(_map)\n",
        "_map.save('traficantes.html')"
      ],
      "metadata": {
        "id": "Go9dF9ry3doo"
      },
      "execution_count": null,
      "outputs": []
    }
  ],
  "metadata": {
    "kernelspec": {
      "display_name": "base",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "codemirror_mode": {
        "name": "ipython",
        "version": 3
      },
      "file_extension": ".py",
      "mimetype": "text/x-python",
      "name": "python",
      "nbconvert_exporter": "python",
      "pygments_lexer": "ipython3",
      "version": "3.10.11"
    },
    "orig_nbformat": 4,
    "colab": {
      "provenance": [],
      "include_colab_link": true
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}