main.ipynb

{
 "cells": [
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Hackaton"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "b6ea68fa-b981-4b38-8315-a9a50736c919",
     "showTitle": false,
     "title": ""
    }
   },
   "outputs": [],
   "source": [
    "import folium\n",
    "import json\n",
    "import pandas as pd \n",
    "import geopandas as gpd\n",
    "from shapely.geometry import Point\n",
    "from gpt import parse_data, get_insights_of_disasters, get_insights_of_disasters_and_hospitals\n",
    "from helpers.get_geojson import get_geojson\n",
    "from helpers.polygons import is_inside"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "from IPython.display import display, HTML\n",
    "\n",
    "def nice_print(string):\n",
    "  html_string = \"\"\n",
    "  string_array = string.split(' ')\n",
    "  for i in range(0, len(string_array), 16):\n",
    "    string_line = \" \".join(string_array[i: i + 16])\n",
    "    html_string += f'<p style=\"font-size: 16px\";>{string_line}</p>\\n'\n",
    "  display(HTML(html_string))"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Load data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "disasters_df = gpd.read_file('data/distasters_parsed.geojson')\n",
    "hospitals_df = pd.read_csv('data/centros_salud_filtered_urgencia.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "disasters_df['Disaster Type'] = disasters_df['Disaster Type'].replace({\"Flood\": \"Inundacion\",\n",
    "                                          \"Volcanic activity\": \"Volcan\",\n",
    "                                          \"Storm\": \"Tormenta\",\n",
    "                                          \"Earthquake\": \"Terremoto\",\n",
    "                                          \"Landslide\": \"Aluvion\",\n",
    "                                          \"Wildfire\": \"Incendio\"})"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Main Loop\n",
    "\n",
    "- read input\n",
    "- parse to structured\n",
    "- get geojson\n",
    "- filter type\n",
    "- show data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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>Year</th>\n",
       "      <th>Seq</th>\n",
       "      <th>Glide</th>\n",
       "      <th>Disaster Group</th>\n",
       "      <th>Disaster Subgroup</th>\n",
       "      <th>Disaster Type</th>\n",
       "      <th>Disaster Subtype</th>\n",
       "      <th>Disaster Subsubtype</th>\n",
       "      <th>Event Name</th>\n",
       "      <th>Country</th>\n",
       "      <th>...</th>\n",
       "      <th>No Homeless</th>\n",
       "      <th>Total Affected</th>\n",
       "      <th>Insured Damages ('000 US$)</th>\n",
       "      <th>Total Damages ('000 US$)</th>\n",
       "      <th>CPI</th>\n",
       "      <th>Adm Level</th>\n",
       "      <th>Admin1 Code</th>\n",
       "      <th>Admin2 Code</th>\n",
       "      <th>Geo Locations</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1964</td>\n",
       "      <td>17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Natural</td>\n",
       "      <td>Geophysical</td>\n",
       "      <td>Volcan</td>\n",
       "      <td>Ash fall</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Chile</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.984281</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POINT (-72.23078 -39.28201)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1965</td>\n",
       "      <td>40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Natural</td>\n",
       "      <td>Hydrological</td>\n",
       "      <td>Inundacion</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Chile</td>\n",
       "      <td>...</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>375000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>12.174253</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POINT (-70.39750 -23.65093)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1968</td>\n",
       "      <td>9008</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Natural</td>\n",
       "      <td>Climatological</td>\n",
       "      <td>Drought</td>\n",
       "      <td>Drought</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Chile</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>120000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>55000.0</td>\n",
       "      <td>13.439657</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POINT (-71.54297 -35.67515)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1968</td>\n",
       "      <td>57</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Natural</td>\n",
       "      <td>Meteorological</td>\n",
       "      <td>Tormenta</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Chile</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.439657</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POINT (-71.54297 -35.67515)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1974</td>\n",
       "      <td>27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Natural</td>\n",
       "      <td>Hydrological</td>\n",
       "      <td>Inundacion</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Chile</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>19.051854</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>POINT (-71.54297 -35.67515)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 46 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Year   Seq Glide Disaster Group Disaster Subgroup Disaster Type  \\\n",
       "0  1964    17   NaN        Natural       Geophysical        Volcan   \n",
       "1  1965    40   NaN        Natural      Hydrological    Inundacion   \n",
       "2  1968  9008   NaN        Natural    Climatological       Drought   \n",
       "3  1968    57   NaN        Natural    Meteorological      Tormenta   \n",
       "4  1974    27   NaN        Natural      Hydrological    Inundacion   \n",
       "\n",
       "  Disaster Subtype Disaster Subsubtype Event Name Country  ... No Homeless  \\\n",
       "0         Ash fall                 NaN        NaN   Chile  ...         NaN   \n",
       "1              NaN                 NaN        NaN   Chile  ...     25000.0   \n",
       "2          Drought                 NaN        NaN   Chile  ...         NaN   \n",
       "3              NaN                 NaN        NaN   Chile  ...         NaN   \n",
       "4              NaN                 NaN        NaN   Chile  ...         NaN   \n",
       "\n",
       "  Total Affected Insured Damages ('000 US$) Total Damages ('000 US$)  \\\n",
       "0         2000.0                        NaN                      NaN   \n",
       "1       375000.0                        NaN                  10000.0   \n",
       "2       120000.0                        NaN                  55000.0   \n",
       "3            NaN                        NaN                      NaN   \n",
       "4        40000.0                        NaN                  10000.0   \n",
       "\n",
       "         CPI Adm Level Admin1 Code Admin2 Code Geo Locations  \\\n",
       "0  11.984281       NaN         NaN         NaN           NaN   \n",
       "1  12.174253       NaN         NaN         NaN           NaN   \n",
       "2  13.439657       NaN         NaN         NaN           NaN   \n",
       "3  13.439657       NaN         NaN         NaN           NaN   \n",
       "4  19.051854       NaN         NaN         NaN           NaN   \n",
       "\n",
       "                      geometry  \n",
       "0  POINT (-72.23078 -39.28201)  \n",
       "1  POINT (-70.39750 -23.65093)  \n",
       "2  POINT (-71.54297 -35.67515)  \n",
       "3  POINT (-71.54297 -35.67515)  \n",
       "4  POINT (-71.54297 -35.67515)  \n",
       "\n",
       "[5 rows x 46 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "disasters_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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>X</th>\n",
       "      <th>Y</th>\n",
       "      <th>FID</th>\n",
       "      <th>codest</th>\n",
       "      <th>nomeste</th>\n",
       "      <th>codreg</th>\n",
       "      <th>nomreg</th>\n",
       "      <th>codss</th>\n",
       "      <th>nomss</th>\n",
       "      <th>codcom</th>\n",
       "      <th>...</th>\n",
       "      <th>Place</th>\n",
       "      <th>certifi</th>\n",
       "      <th>depend</th>\n",
       "      <th>nivel</th>\n",
       "      <th>viaacceso</th>\n",
       "      <th>direcc</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>cod_nuevo</th>\n",
       "      <th>Coordinates</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-70.290543</td>\n",
       "      <td>-18.437603</td>\n",
       "      <td>15</td>\n",
       "      <td>01-900</td>\n",
       "      <td>SAPU-Dr. Amador Neghme de Arica</td>\n",
       "      <td>15</td>\n",
       "      <td>De Arica Parinacota</td>\n",
       "      <td>1</td>\n",
       "      <td>Servicio de Salud Arica</td>\n",
       "      <td>15101</td>\n",
       "      <td>...</td>\n",
       "      <td>Servicio de Atencion Primaria de Urgencia</td>\n",
       "      <td>S/C</td>\n",
       "      <td>Municipal</td>\n",
       "      <td>Primario</td>\n",
       "      <td>Avenida</td>\n",
       "      <td>Cancha Rayada 4149 Arica</td>\n",
       "      <td>-70.290543</td>\n",
       "      <td>-18.437603</td>\n",
       "      <td>200094</td>\n",
       "      <td>POINT (-70.2905433131 -18.4376026272)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-70.282444</td>\n",
       "      <td>-18.483881</td>\n",
       "      <td>16</td>\n",
       "      <td>01-901</td>\n",
       "      <td>SAPU-Iris Véliz Hume</td>\n",
       "      <td>15</td>\n",
       "      <td>De Arica Parinacota</td>\n",
       "      <td>1</td>\n",
       "      <td>Servicio de Salud Arica</td>\n",
       "      <td>15101</td>\n",
       "      <td>...</td>\n",
       "      <td>Servicio de Atencion Primaria de Urgencia</td>\n",
       "      <td>S/C</td>\n",
       "      <td>Municipal</td>\n",
       "      <td>Primario</td>\n",
       "      <td>Calle</td>\n",
       "      <td>Barros Luco 2269 Arica</td>\n",
       "      <td>-70.282444</td>\n",
       "      <td>-18.483881</td>\n",
       "      <td>200095</td>\n",
       "      <td>POINT (-70.2824436462 -18.4838808045)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-70.134674</td>\n",
       "      <td>-20.226259</td>\n",
       "      <td>34</td>\n",
       "      <td>02-800</td>\n",
       "      <td>SAPU-Cirujano Aguirre</td>\n",
       "      <td>1</td>\n",
       "      <td>De Tarapacá</td>\n",
       "      <td>2</td>\n",
       "      <td>Servicio de Salud Iquique</td>\n",
       "      <td>1101</td>\n",
       "      <td>...</td>\n",
       "      <td>Servicio de Atencion Primaria de Urgencia</td>\n",
       "      <td>S/C</td>\n",
       "      <td>Municipal</td>\n",
       "      <td>Primario</td>\n",
       "      <td>Pasaje</td>\n",
       "      <td>Chintaguay S/N Iquique</td>\n",
       "      <td>-70.134674</td>\n",
       "      <td>-20.226259</td>\n",
       "      <td>102800</td>\n",
       "      <td>POINT (-70.1346740237 -20.2262589719)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-70.150170</td>\n",
       "      <td>-20.208263</td>\n",
       "      <td>35</td>\n",
       "      <td>02-801</td>\n",
       "      <td>SAPU-Cirujano Videla</td>\n",
       "      <td>1</td>\n",
       "      <td>De Tarapacá</td>\n",
       "      <td>2</td>\n",
       "      <td>Servicio de Salud Iquique</td>\n",
       "      <td>1101</td>\n",
       "      <td>...</td>\n",
       "      <td>Servicio de Atencion Primaria de Urgencia</td>\n",
       "      <td>S/C</td>\n",
       "      <td>Municipal</td>\n",
       "      <td>Primario</td>\n",
       "      <td>Calle</td>\n",
       "      <td>Obispo Labbé S/N Iquique</td>\n",
       "      <td>-70.150170</td>\n",
       "      <td>-20.208263</td>\n",
       "      <td>102801</td>\n",
       "      <td>POINT (-70.150170342 -20.2082628936)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>-70.136451</td>\n",
       "      <td>-20.236900</td>\n",
       "      <td>36</td>\n",
       "      <td>02-802</td>\n",
       "      <td>SAPU-Cirujano Guzmán</td>\n",
       "      <td>1</td>\n",
       "      <td>De Tarapacá</td>\n",
       "      <td>2</td>\n",
       "      <td>Servicio de Salud Iquique</td>\n",
       "      <td>1101</td>\n",
       "      <td>...</td>\n",
       "      <td>Servicio de Atencion Primaria de Urgencia</td>\n",
       "      <td>S/C</td>\n",
       "      <td>Municipal</td>\n",
       "      <td>Primario</td>\n",
       "      <td>Avenida</td>\n",
       "      <td>Pedro Prado 2736 Iquique</td>\n",
       "      <td>-70.136451</td>\n",
       "      <td>-20.236900</td>\n",
       "      <td>102802</td>\n",
       "      <td>POINT (-70.1364509765 -20.2369000291)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           X          Y  FID  codest                          nomeste  codreg  \\\n",
       "0 -70.290543 -18.437603   15  01-900  SAPU-Dr. Amador Neghme de Arica      15   \n",
       "1 -70.282444 -18.483881   16  01-901             SAPU-Iris Véliz Hume      15   \n",
       "2 -70.134674 -20.226259   34  02-800            SAPU-Cirujano Aguirre       1   \n",
       "3 -70.150170 -20.208263   35  02-801             SAPU-Cirujano Videla       1   \n",
       "4 -70.136451 -20.236900   36  02-802             SAPU-Cirujano Guzmán       1   \n",
       "\n",
       "                nomreg  codss                      nomss  codcom  ...  \\\n",
       "0  De Arica Parinacota      1    Servicio de Salud Arica   15101  ...   \n",
       "1  De Arica Parinacota      1    Servicio de Salud Arica   15101  ...   \n",
       "2          De Tarapacá      2  Servicio de Salud Iquique    1101  ...   \n",
       "3          De Tarapacá      2  Servicio de Salud Iquique    1101  ...   \n",
       "4          De Tarapacá      2  Servicio de Salud Iquique    1101  ...   \n",
       "\n",
       "                                       Place certifi     depend     nivel  \\\n",
       "0  Servicio de Atencion Primaria de Urgencia     S/C  Municipal  Primario   \n",
       "1  Servicio de Atencion Primaria de Urgencia     S/C  Municipal  Primario   \n",
       "2  Servicio de Atencion Primaria de Urgencia     S/C  Municipal  Primario   \n",
       "3  Servicio de Atencion Primaria de Urgencia     S/C  Municipal  Primario   \n",
       "4  Servicio de Atencion Primaria de Urgencia     S/C  Municipal  Primario   \n",
       "\n",
       "  viaacceso                    direcc  Longitude   Latitude  cod_nuevo  \\\n",
       "0   Avenida  Cancha Rayada 4149 Arica -70.290543 -18.437603     200094   \n",
       "1     Calle    Barros Luco 2269 Arica -70.282444 -18.483881     200095   \n",
       "2    Pasaje    Chintaguay S/N Iquique -70.134674 -20.226259     102800   \n",
       "3     Calle  Obispo Labbé S/N Iquique -70.150170 -20.208263     102801   \n",
       "4   Avenida  Pedro Prado 2736 Iquique -70.136451 -20.236900     102802   \n",
       "\n",
       "                             Coordinates  \n",
       "0  POINT (-70.2905433131 -18.4376026272)  \n",
       "1  POINT (-70.2824436462 -18.4838808045)  \n",
       "2  POINT (-70.1346740237 -20.2262589719)  \n",
       "3   POINT (-70.150170342 -20.2082628936)  \n",
       "4  POINT (-70.1364509765 -20.2369000291)  \n",
       "\n",
       "[5 rows x 22 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hospitals_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "def plot_map(disasters_filtered, hospitals_filtered):\n",
    "  m = folium.Map(location=[disasters_df['Latitude'].mean(), disasters_df['Longitude'].mean()], zoom_start=6)\n",
    "  latitudes, longitudes = [], []\n",
    "  for i in range(0, len(disasters_filtered)):\n",
    "    latitudes.append(disasters_filtered.iloc[i]['Latitude'])\n",
    "    longitudes.append(disasters_filtered.iloc[i]['Longitude'])\n",
    "    folium.Marker([disasters_filtered.iloc[i]['Latitude'], disasters_filtered.iloc[i]['Longitude']], icon=folium.Icon(color='red'), popup=disasters_filtered.iloc[i]['Disaster Type']).add_to(m)\n",
    "  for i in range(0, len(hospitals_filtered)):\n",
    "    latitudes.append(hospitals_filtered.iloc[i]['Latitude'])\n",
    "    longitudes.append(hospitals_filtered.iloc[i]['Longitude'])\n",
    "    folium.Marker([hospitals_filtered.iloc[i]['Latitude'], hospitals_filtered.iloc[i]['Longitude']], icon=folium.Icon(color='blue'), popup=hospitals_filtered.iloc[i]['nomeste']).add_to(m)\n",
    "  min_lat = min(latitudes)\n",
    "  max_lat = max(latitudes)\n",
    "  min_long = min(longitudes)\n",
    "  max_long = max(longitudes)\n",
    "  bounds = [[min_lat, min_long], [max_lat, max_long]]\n",
    "  m.fit_bounds(bounds)\n",
    "  return m"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "def location_insights(ubicacion):\n",
    "    geojson = get_geojson(ubicacion)\n",
    "    boolean_filter = []\n",
    "    for _, row in disasters_df.iterrows():\n",
    "        is_in = False\n",
    "        for _, zone in geojson.iterrows():\n",
    "            if zone['geometry'].contains(row['geometry']):\n",
    "                boolean_filter.append(True)\n",
    "                is_in = True\n",
    "                break\n",
    "        if not is_in:\n",
    "            boolean_filter.append(False)\n",
    "\n",
    "    filtered_disasters = disasters_df[boolean_filter]\n",
    "    if len(filtered_disasters) == 0:\n",
    "        print('No hay datos en la zona:', geojson)\n",
    "        return\n",
    "    disasters = filtered_disasters['Disaster Type'].value_counts()\n",
    "    disasters_str = \"\"\n",
    "    for index, value in disasters.items():\n",
    "        disasters_str += f\"{index}: {value}\\n\"\n",
    "    print(disasters_str)\n",
    "    nice_print(get_insights_of_disasters(disasters_str, ubicacion))\n",
    "    return plot_map(filtered_disasters, [])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "def calculate_distance(point1, point2):\n",
    "    point1 = point1.strip('POINT ').strip('(').strip(')')\n",
    "    x, y = point1.split()\n",
    "    x, y = float(x), float(y)\n",
    "    point1 = Point(x, y)\n",
    "    return point1.distance(point2)\n",
    "\n",
    "def get_nearest_hospitals(polygon):\n",
    "    center = polygon.centroid\n",
    "    point = Point(center.x, center.y)\n",
    "    hosp_copy = hospitals_df.copy()\n",
    "    hosp_copy['Distance'] = hosp_copy['Coordinates'].apply(lambda x: calculate_distance(x, point))\n",
    "    nearest_row = hosp_copy.loc[hosp_copy['Distance'].idxmin()]\n",
    "    return nearest_row"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "from shapely.geometry import Point, Polygon\n",
    "\n",
    "def get_location_and_assist(ubicacion):\n",
    "    geojson = get_geojson(ubicacion)\n",
    "    boolean_filter = []\n",
    "    boolean_filter_2 = []\n",
    "    for _, row in disasters_df.iterrows():\n",
    "        is_in = False\n",
    "        for _, zone in geojson.iterrows():\n",
    "            if zone['geometry'].contains(row['geometry']):\n",
    "                boolean_filter.append(True)\n",
    "                is_in = True\n",
    "                break\n",
    "        if not is_in:\n",
    "            boolean_filter.append(False)\n",
    "    for _, row in hospitals_df.iterrows():\n",
    "        is_in = False\n",
    "        for _, zone in geojson.iterrows():\n",
    "            point = Point(row['Longitude'], row['Latitude'])\n",
    "            if zone['geometry'].contains(point):\n",
    "                boolean_filter_2.append(True)\n",
    "                is_in = True\n",
    "                break\n",
    "        if not is_in:\n",
    "            boolean_filter_2.append(False)\n",
    "    filtered_disasters = disasters_df[boolean_filter]\n",
    "    filtered_hospitals = hospitals_df[boolean_filter_2]\n",
    "    print('hospitales:', len(filtered_hospitals))\n",
    "    if len(filtered_disasters) == 0:\n",
    "        print('No hay datos en la zona:', geojson)\n",
    "        return\n",
    "    disasters = filtered_disasters['Disaster Type'].value_counts()\n",
    "    disasters_str = \"\"\n",
    "    total_disasters = 0\n",
    "    for index, value in disasters.items():\n",
    "        disasters_str += f\"{index}: {value}\\n\"\n",
    "        total_disasters += value\n",
    "    if len(filtered_hospitals) == 0:\n",
    "        ratio = 0\n",
    "    else:\n",
    "        ratio = len(filtered_hospitals) / total_disasters\n",
    "    print('Ratio desastres/centros:', ratio)\n",
    "    print(disasters_str)\n",
    "    if len(filtered_hospitals) == 0:\n",
    "        hosp = get_nearest_hospitals(geojson)\n",
    "        filtered_hospitals = pd.DataFrame([hosp])\n",
    "    nice_print(get_insights_of_disasters_and_hospitals(disasters_str, ubicacion, ratio))\n",
    "    return plot_map(filtered_disasters, filtered_hospitals)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "queries = [\n",
    "  'estoy en chaiten, hablame sobre los desastres naturales y los hospitales',\n",
    "  'por favor hablame sobre que peligros hay en antofagasta, y que centros asistenciales me pueden ayudar',\n",
    "  'cuanto miden los gatos en promedio',\n",
    "  'estoy yendo a puerto mont. de que me debería preocupar',\n",
    "  'voy a punta arenas hospitales',\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'ubicacion': 'punta arenas', 'tipo_de_desastre': None, 'centro_asistencial': 'hospital'}\n",
      "hospitales: 3\n",
      "Ratio desastres/centros: 0.75\n",
      "Inundacion: 2\n",
      "Incendio: 2\n",
      "\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<p style=\"font-size: 16px\";>En la zona de Punta Arenas existen desastres naturales como inundaciones e incendios, los cuales pueden</p>\n",
       "<p style=\"font-size: 16px\";>poner en riesgo la salud y la vida de las personas. El ratio desastre natural/centros asistenciales</p>\n",
       "<p style=\"font-size: 16px\";>es de 0.75, lo que indica que se necesitan más centros asistenciales para poder atender a</p>\n",
       "<p style=\"font-size: 16px\";>la población en caso de emergencia. Es importante tomar medidas preventivas para evitar estos desastres, como</p>\n",
       "<p style=\"font-size: 16px\";>mantener limpios los cauces de los ríos y evitar el uso de fuego en zonas forestales.</p>\n",
       "<p style=\"font-size: 16px\";>Además, es fundamental contar con planes de evacuación y estar preparados ante cualquier eventualidad. La prevención</p>\n",
       "<p style=\"font-size: 16px\";>es la clave para evitar tragedias.</p>\n"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "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_08f2029681a1ee8e9d05b6da4ba6f664 {\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;/head&gt;\n",
       "&lt;body&gt;\n",
       "    \n",
       "    \n",
       "            &lt;div class=&quot;folium-map&quot; id=&quot;map_08f2029681a1ee8e9d05b6da4ba6f664&quot; &gt;&lt;/div&gt;\n",
       "        \n",
       "&lt;/body&gt;\n",
       "&lt;script&gt;\n",
       "    \n",
       "    \n",
       "            var map_08f2029681a1ee8e9d05b6da4ba6f664 = L.map(\n",
       "                &quot;map_08f2029681a1ee8e9d05b6da4ba6f664&quot;,\n",
       "                {\n",
       "                    center: [-33.69372640007141, -67.05419160613896],\n",
       "                    crs: L.CRS.EPSG3857,\n",
       "                    zoom: 6,\n",
       "                    zoomControl: true,\n",
       "                    preferCanvas: false,\n",
       "                }\n",
       "            );\n",
       "\n",
       "            \n",
       "\n",
       "        \n",
       "    \n",
       "            var tile_layer_7bc983b6f592792c3efda2e5332b212d = 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_08f2029681a1ee8e9d05b6da4ba6f664);\n",
       "        \n",
       "    \n",
       "            var marker_758b371794d7f721611cfcae10565434 = L.marker(\n",
       "                [-53.1633845, -70.9078263],\n",
       "                {}\n",
       "            ).addTo(map_08f2029681a1ee8e9d05b6da4ba6f664);\n",
       "        \n",
       "    \n",
       "            var icon_170ec5df4c5290d745a07e748867f8a5 = L.AwesomeMarkers.icon(\n",
       "                {&quot;extraClasses&quot;: &quot;fa-rotate-0&quot;, &quot;icon&quot;: &quot;info-sign&quot;, &quot;iconColor&quot;: &quot;white&quot;, &quot;markerColor&quot;: &quot;red&quot;, &quot;prefix&quot;: &quot;glyphicon&quot;}\n",
       "            );\n",
       "            marker_758b371794d7f721611cfcae10565434.setIcon(icon_170ec5df4c5290d745a07e748867f8a5);\n",
       "        \n",
       "    \n",
       "        var popup_86caf746d28eb8ca2a51851bb9e70c1c = L.popup({&quot;maxWidth&quot;: &quot;100%&quot;});\n",
       "\n",
       "        \n",
       "            \n",
       "                var html_d7fe730fc1f945876cb8714bb9f793a2 = $(`&lt;div id=&quot;html_d7fe730fc1f945876cb8714bb9f793a2&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;Inundacion&lt;/div&gt;`)[0];\n",
       "                popup_86caf746d28eb8ca2a51851bb9e70c1c.setContent(html_d7fe730fc1f945876cb8714bb9f793a2);\n",
       "            \n",
       "        \n",
       "\n",
       "        marker_758b371794d7f721611cfcae10565434.bindPopup(popup_86caf746d28eb8ca2a51851bb9e70c1c)\n",
       "        ;\n",
       "\n",
       "        \n",
       "    \n",
       "    \n",
       "            var marker_3309217d0f290b788321bfc3c73b31e4 = L.marker(\n",
       "                [-53.4428344, -72.1496817],\n",
       "                {}\n",
       "            ).addTo(map_08f2029681a1ee8e9d05b6da4ba6f664);\n",
       "        \n",
       "    \n",
       "            var icon_fd62b5efc757acd01b0e02a846d503e9 = L.AwesomeMarkers.icon(\n",
       "                {&quot;extraClasses&quot;: &quot;fa-rotate-0&quot;, &quot;icon&quot;: &quot;info-sign&quot;, &quot;iconColor&quot;: &quot;white&quot;, &quot;markerColor&quot;: &quot;red&quot;, &quot;prefix&quot;: &quot;glyphicon&quot;}\n",
       "            );\n",
       "            marker_3309217d0f290b788321bfc3c73b31e4.setIcon(icon_fd62b5efc757acd01b0e02a846d503e9);\n",
       "        \n",
       "    \n",
       "        var popup_4cbb918bb43adc5d056405a96d663a7b = L.popup({&quot;maxWidth&quot;: &quot;100%&quot;});\n",
       "\n",
       "        \n",
       "            \n",
       "                var html_a6ae4ed8ca131ac8d8b2abd854da4162 = $(`&lt;div id=&quot;html_a6ae4ed8ca131ac8d8b2abd854da4162&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;Inundacion&lt;/div&gt;`)[0];\n",
       "                popup_4cbb918bb43adc5d056405a96d663a7b.setContent(html_a6ae4ed8ca131ac8d8b2abd854da4162);\n",
       "            \n",
       "        \n",
       "\n",
       "        marker_3309217d0f290b788321bfc3c73b31e4.bindPopup(popup_4cbb918bb43adc5d056405a96d663a7b)\n",
       "        ;\n",
       "\n",
       "        \n",
       "    \n",
       "    \n",
       "            var marker_b6e1e1c15fa01a3b61b7574f8c57ea2a = L.marker(\n",
       "                [-53.4428344, -72.1496817],\n",
       "                {}\n",
       "            ).addTo(map_08f2029681a1ee8e9d05b6da4ba6f664);\n",
       "        \n",
       "    \n",
       "            var icon_a2501963ec52ae430ab4bb75c638d9b7 = L.AwesomeMarkers.icon(\n",
       "                {&quot;extraClasses&quot;: &quot;fa-rotate-0&quot;, &quot;icon&quot;: &quot;info-sign&quot;, &quot;iconColor&quot;: &quot;white&quot;, &quot;markerColor&quot;: &quot;red&quot;, &quot;prefix&quot;: &quot;glyphicon&quot;}\n",
       "            );\n",
       "            marker_b6e1e1c15fa01a3b61b7574f8c57ea2a.setIcon(icon_a2501963ec52ae430ab4bb75c638d9b7);\n",
       "        \n",
       "    \n",
       "        var popup_e1db2e143244129488a2aacf4fe7c591 = L.popup({&quot;maxWidth&quot;: &quot;100%&quot;});\n",
       "\n",
       "        \n",
       "            \n",
       "                var html_99b325cddac4cdb16a0474d3ac65e463 = $(`&lt;div id=&quot;html_99b325cddac4cdb16a0474d3ac65e463&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;Incendio&lt;/div&gt;`)[0];\n",
       "                popup_e1db2e143244129488a2aacf4fe7c591.setContent(html_99b325cddac4cdb16a0474d3ac65e463);\n",
       "            \n",
       "        \n",
       "\n",
       "        marker_b6e1e1c15fa01a3b61b7574f8c57ea2a.bindPopup(popup_e1db2e143244129488a2aacf4fe7c591)\n",
       "        ;\n",
       "\n",
       "        \n",
       "    \n",
       "    \n",
       "            var marker_60e38699f8cd1fa42edc31a577fbb942 = L.marker(\n",
       "                [-53.4428344, -72.1496817],\n",
       "                {}\n",
       "            ).addTo(map_08f2029681a1ee8e9d05b6da4ba6f664);\n",
       "        \n",
       "    \n",
       "            var icon_061546303256d7531aafb91748be43d0 = L.AwesomeMarkers.icon(\n",
       "                {&quot;extraClasses&quot;: &quot;fa-rotate-0&quot;, &quot;icon&quot;: &quot;info-sign&quot;, &quot;iconColor&quot;: &quot;white&quot;, &quot;markerColor&quot;: &quot;red&quot;, &quot;prefix&quot;: &quot;glyphicon&quot;}\n",
       "            );\n",
       "            marker_60e38699f8cd1fa42edc31a577fbb942.setIcon(icon_061546303256d7531aafb91748be43d0);\n",
       "        \n",
       "    \n",
       "        var popup_99170daf810139f7a1c9a538b9ba88c5 = L.popup({&quot;maxWidth&quot;: &quot;100%&quot;});\n",
       "\n",
       "        \n",
       "            \n",
       "                var html_46a172001e03dec424419df233f7d1d8 = $(`&lt;div id=&quot;html_46a172001e03dec424419df233f7d1d8&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;Incendio&lt;/div&gt;`)[0];\n",
       "                popup_99170daf810139f7a1c9a538b9ba88c5.setContent(html_46a172001e03dec424419df233f7d1d8);\n",
       "            \n",
       "        \n",
       "\n",
       "        marker_60e38699f8cd1fa42edc31a577fbb942.bindPopup(popup_99170daf810139f7a1c9a538b9ba88c5)\n",
       "        ;\n",
       "\n",
       "        \n",
       "    \n",
       "    \n",
       "            var marker_4b0e5fd3799571f84ef3342c97ed2afc = L.marker(\n",
       "                [-53.1419199859, -70.9122030067],\n",
       "                {}\n",
       "            ).addTo(map_08f2029681a1ee8e9d05b6da4ba6f664);\n",
       "        \n",
       "    \n",
       "            var icon_28c6d4a8e95aa631f409b0c2e04a2598 = L.AwesomeMarkers.icon(\n",
       "                {&quot;extraClasses&quot;: &quot;fa-rotate-0&quot;, &quot;icon&quot;: &quot;info-sign&quot;, &quot;iconColor&quot;: &quot;white&quot;, &quot;markerColor&quot;: &quot;blue&quot;, &quot;prefix&quot;: &quot;glyphicon&quot;}\n",
       "            );\n",
       "            marker_4b0e5fd3799571f84ef3342c97ed2afc.setIcon(icon_28c6d4a8e95aa631f409b0c2e04a2598);\n",
       "        \n",
       "    \n",
       "        var popup_d513fc71e1863328b98c496c21a52b8e = L.popup({&quot;maxWidth&quot;: &quot;100%&quot;});\n",
       "\n",
       "        \n",
       "            \n",
       "                var html_a14c457163dc094b53eb3ef070a2a990 = $(`&lt;div id=&quot;html_a14c457163dc094b53eb3ef070a2a990&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;SAPU-Dr. Mateo Bencur&lt;/div&gt;`)[0];\n",
       "                popup_d513fc71e1863328b98c496c21a52b8e.setContent(html_a14c457163dc094b53eb3ef070a2a990);\n",
       "            \n",
       "        \n",
       "\n",
       "        marker_4b0e5fd3799571f84ef3342c97ed2afc.bindPopup(popup_d513fc71e1863328b98c496c21a52b8e)\n",
       "        ;\n",
       "\n",
       "        \n",
       "    \n",
       "    \n",
       "            var marker_35452a2ae87ab406633df613ead313a0 = L.marker(\n",
       "                [-53.174948958, -70.9379560499],\n",
       "                {}\n",
       "            ).addTo(map_08f2029681a1ee8e9d05b6da4ba6f664);\n",
       "        \n",
       "    \n",
       "            var icon_6952dc461bee2bdc93b021caebec5560 = L.AwesomeMarkers.icon(\n",
       "                {&quot;extraClasses&quot;: &quot;fa-rotate-0&quot;, &quot;icon&quot;: &quot;info-sign&quot;, &quot;iconColor&quot;: &quot;white&quot;, &quot;markerColor&quot;: &quot;blue&quot;, &quot;prefix&quot;: &quot;glyphicon&quot;}\n",
       "            );\n",
       "            marker_35452a2ae87ab406633df613ead313a0.setIcon(icon_6952dc461bee2bdc93b021caebec5560);\n",
       "        \n",
       "    \n",
       "        var popup_51e53892ea811b646337d323421f7fec = L.popup({&quot;maxWidth&quot;: &quot;100%&quot;});\n",
       "\n",
       "        \n",
       "            \n",
       "                var html_f8118ff1afe475f5b76686eb4846e5b1 = $(`&lt;div id=&quot;html_f8118ff1afe475f5b76686eb4846e5b1&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;SAPU-Dr. Juan Damianovic&lt;/div&gt;`)[0];\n",
       "                popup_51e53892ea811b646337d323421f7fec.setContent(html_f8118ff1afe475f5b76686eb4846e5b1);\n",
       "            \n",
       "        \n",
       "\n",
       "        marker_35452a2ae87ab406633df613ead313a0.bindPopup(popup_51e53892ea811b646337d323421f7fec)\n",
       "        ;\n",
       "\n",
       "        \n",
       "    \n",
       "    \n",
       "            var marker_a37248bcbda481c446f6bb3abe23087e = L.marker(\n",
       "                [-53.16519959, -70.9309574493],\n",
       "                {}\n",
       "            ).addTo(map_08f2029681a1ee8e9d05b6da4ba6f664);\n",
       "        \n",
       "    \n",
       "            var icon_9b9f324523d695d7a065152a9dd25ac5 = L.AwesomeMarkers.icon(\n",
       "                {&quot;extraClasses&quot;: &quot;fa-rotate-0&quot;, &quot;icon&quot;: &quot;info-sign&quot;, &quot;iconColor&quot;: &quot;white&quot;, &quot;markerColor&quot;: &quot;blue&quot;, &quot;prefix&quot;: &quot;glyphicon&quot;}\n",
       "            );\n",
       "            marker_a37248bcbda481c446f6bb3abe23087e.setIcon(icon_9b9f324523d695d7a065152a9dd25ac5);\n",
       "        \n",
       "    \n",
       "        var popup_35f1d089d23b448d767be621fbf453d2 = L.popup({&quot;maxWidth&quot;: &quot;100%&quot;});\n",
       "\n",
       "        \n",
       "            \n",
       "                var html_1872000bfcfb4f41b4c0a4f126f921c4 = $(`&lt;div id=&quot;html_1872000bfcfb4f41b4c0a4f126f921c4&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;SAPU-18 de Septiembre&lt;/div&gt;`)[0];\n",
       "                popup_35f1d089d23b448d767be621fbf453d2.setContent(html_1872000bfcfb4f41b4c0a4f126f921c4);\n",
       "            \n",
       "        \n",
       "\n",
       "        marker_a37248bcbda481c446f6bb3abe23087e.bindPopup(popup_35f1d089d23b448d767be621fbf453d2)\n",
       "        ;\n",
       "\n",
       "        \n",
       "    \n",
       "    \n",
       "            map_08f2029681a1ee8e9d05b6da4ba6f664.fitBounds(\n",
       "                [[-53.4428344, -72.1496817], [-53.1419199859, -70.9078263]],\n",
       "                {}\n",
       "            );\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>"
      ],
      "text/plain": [
       "<folium.folium.Map at 0x7fdac8e5aaf0>"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "_input = queries[0]\n",
    "# _input = input('Ingrese query:')\n",
    "parsed_input = parse_data(_input)\n",
    "print(parsed_input)\n",
    "ubicacion = parsed_input['ubicacion']\n",
    "\n",
    "# location filter\n",
    "\n",
    "if ubicacion and parsed_input['centro_asistencial']:\n",
    "    m = get_location_and_assist(ubicacion)\n",
    "elif ubicacion:\n",
    "    m = location_insights(ubicacion)\n",
    "else:\n",
    "    print('Esa no es una query valida.')\n",
    "    m = None\n",
    "\n",
    "m"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<folium.features.GeoJson at 0x7faa6909d370>"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Load GeoJSON data\n",
    "with open(\"data/establecimientos_salud.geojson\") as f:\n",
    "    geo_json_data = json.load(f)\n",
    "\n",
    "# Add the GeoJSON layer\n",
    "folium.GeoJson(geo_json_data, name='geojson').add_to(m)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {},
     "inputWidgets": {},
     "nuid": "c50377af-bfc8-4400-848c-017d77863d90",
     "showTitle": false,
     "title": ""
    }
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "application/vnd.databricks.v1+notebook": {
   "dashboards": [],
   "language": "python",
   "notebookMetadata": {
    "pythonIndentUnit": 2
   },
   "notebookName": "Hackaton",
   "widgets": {}
  },
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}