api-pandas-folium.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Práctica en el mapa de Zaragoza"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "En este cuaderno utilizaremos las librerías de **Pandas** y **Folium** para leer una API que importaremos como archivo **.csv** sobre accidentes de tráfico en Zaragoza registrados por su Ayuntamiento. El objetivo es que **Python** lea esos datos para poder explorarlos con distintas funciones para representar la ubicación de los accidentes en un mapa. Lo primero lo podremos hacer con Pandas, una librería de código abierto de Python que proporciona herramientas de análisis y manipulación de datos. Lo segundo lo haremos con Folium, una librería de creación de mapas web interactivos con Python. \n",
    "\n",
    "La relación entre ambas librerías para el manejo y representación de este conjunto de datos es que una de sus catergorías es `calle` y sus datos son coordenadas geográficas. De ahí que supongan datos propicios para la combinación de ambas herramientas. "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Definición de variables"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Definimos las variables con las que vamos a trabajar para que Python conozca los datos. Una variable es aquello que puedo crear como tal al nombrarlo. Su sintaxis es `=`, por ejemplo, *x = x*. Vamos a definir como variables los elementos básicos de nuestro trabajo, a saber, los datos (para trabajarlos con Pandas) y las coordenadas geográficas de Zaragoza, escenario de los datos a representar (para hacerlo con Folium)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "url_zrgz = \"https://www.zaragoza.es/sede/servicio/transporte/accidentalidad-trafico/accidente.csv\"\n",
    "geo_zrgz = [41.646693,-0.887712]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Al definir estas variables no es necesario volver a copiar el link cuando queramos vincular los datos, sino que lo haremos con la referencia que hemos creado, en este caso `url_zrgz` y `geo_zrgz`. Como vemos, la sintaxis de la primera es  con `\"\"` y de la segunda con `[]`, puesto que se trata de un intervalo con ambos valores incluidos."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "No es imprescindible definir estas referencias en primer lugar, pero sí forma parte de los pasos previos al inicio propiamente dicho del proceso exploratorio de los datos. Podemos resumir estos pasos previos en tres:\n",
    "1. Definición de variables \n",
    "2. Preparación de librerías\n",
    "3. Creación del dataframe\n",
    "\n",
    "Procedemos al segundo punto:"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Preparación de librerías"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "La preparación de las librerías es la condición de posibilidad de nuestro trabajo. Conlleva dos pasos:\n",
    "- Instalación (`!pip install` *librería*)\n",
    "- Importación (`import` *librería* o `import` *librería* `as` *su abreviación*)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Instalación"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Solo es necesaria la instalación de la librería que vayamos a utilizar a contunuación. Por lo que no es imprescindible instalar ahora Pandas. Podríamos hacerlo cuando el documento lo requiriese. Pero vamos a tenerla ya preparada. Tampoco es imprescindible instalar librerías si ya lo hemos hecho en otros cuadernos y Python las ha utilizado con anterioridad. Por ello no necesito instalarme Pandas de nuevo. La importación siempre es necesaria. "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Instalo Folium: `!pip install folium`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: folium in ./.local/lib/python3.8/site-packages (0.12.1.post1)\n",
      "Requirement already satisfied: branca>=0.3.0 in ./.local/lib/python3.8/site-packages (from folium) (0.5.0)\n",
      "Requirement already satisfied: jinja2>=2.9 in /usr/lib/python3/dist-packages (from folium) (2.10.1)\n",
      "Requirement already satisfied: numpy in /usr/local/lib/python3.8/dist-packages (from folium) (1.21.1)\n",
      "Requirement already satisfied: requests in /usr/local/lib/python3.8/dist-packages (from folium) (2.25.0)\n",
      "Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.8/dist-packages (from requests->folium) (2020.6.20)\n",
      "Requirement already satisfied: urllib3<1.27,>=1.21.1 in /usr/lib/python3/dist-packages (from requests->folium) (1.25.8)\n",
      "Requirement already satisfied: chardet<4,>=3.0.2 in /usr/lib/python3/dist-packages (from requests->folium) (3.0.4)\n",
      "Requirement already satisfied: idna<3,>=2.5 in /usr/lib/python3/dist-packages (from requests->folium) (2.8)\n"
     ]
    }
   ],
   "source": [
    "!pip install folium "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Importación "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Ahora ya tengo las dos librerías instaladas en Python. Pero eso no significa que las tenga ya aquí en este documento para trabajar con ellas. Para ello necesito importarlas. Por eso, a diferencia que la instalación, que puede realizarse una sola vez, la importación es obligatoria en cada notebook en que quiera usarse. Con el comando `import` importo ambas librerías.La de pandas lo hago con su abreviación típica *pd*."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import folium "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Una vez tenemos las variables definidas (los datos y las coordenadas) y las librerías preparadas es hora de empezar a trabajar con los datos. Necesito abrirlos desde este documento creando un *dataframe* que los abra. Pero antes (aunque puedo no hacerlo así) abro el mapa para tener presente el espacio en el que quiero proceder a la representación de los datos."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Mapa Zaragoza\n",
    "\n",
    "De la librería Folium quiero que Python me muestre un mapa: el folio *map* con las cooredenadas anteriormente señaladas con la referencia `geo_zrgz`.  Definiremos esta acción **mapa_zrgz** con `=`."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "mapa_zrgz = folium.Map(location=geo_zrgz)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Hemos definido la variable, que a continuación decimos que la ejecute."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "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;head&gt;    \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.6.0/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://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.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.6.0/dist/leaflet.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap-theme.min.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://maxcdn.bootstrapcdn.com/font-awesome/4.6.3/css/font-awesome.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_cee2caf1ed7f37f2e9abace160a4150b {\n",
       "                    position: relative;\n",
       "                    width: 100.0%;\n",
       "                    height: 100.0%;\n",
       "                    left: 0.0%;\n",
       "                    top: 0.0%;\n",
       "                }\n",
       "            &lt;/style&gt;\n",
       "        \n",
       "&lt;/head&gt;\n",
       "&lt;body&gt;    \n",
       "    \n",
       "            &lt;div class=&quot;folium-map&quot; id=&quot;map_cee2caf1ed7f37f2e9abace160a4150b&quot; &gt;&lt;/div&gt;\n",
       "        \n",
       "&lt;/body&gt;\n",
       "&lt;script&gt;    \n",
       "    \n",
       "            var map_cee2caf1ed7f37f2e9abace160a4150b = L.map(\n",
       "                &quot;map_cee2caf1ed7f37f2e9abace160a4150b&quot;,\n",
       "                {\n",
       "                    center: [41.646693, -0.887712],\n",
       "                    crs: L.CRS.EPSG3857,\n",
       "                    zoom: 10,\n",
       "                    zoomControl: true,\n",
       "                    preferCanvas: false,\n",
       "                }\n",
       "            );\n",
       "\n",
       "            \n",
       "\n",
       "        \n",
       "    \n",
       "            var tile_layer_2b6a0e052c0f5e9b6a4394832af54567 = L.tileLayer(\n",
       "                &quot;https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png&quot;,\n",
       "                {&quot;attribution&quot;: &quot;Data by \\u0026copy; \\u003ca href=\\&quot;http://openstreetmap.org\\&quot;\\u003eOpenStreetMap\\u003c/a\\u003e, under \\u003ca 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_cee2caf1ed7f37f2e9abace160a4150b);\n",
       "        \n",
       "&lt;/script&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 0x7ff8c06dccd0>"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mapa_zrgz"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Ahora que tenemos este mapa necesitamos que Python lea los datos que queremos que en él represente. La librería que puede hacer esto es **Pandas**. Auqnue tengamos la librería instalada e importada, aún no vemos en este archivo los datos. Tenemos que pedir a Python que con la librería Pandas nos lea los datos. Para ello creamos un dataframe (*df_zrgz*) que será el resultado (esto lo indicamos con *=*) de leer el documento al que lo hemos vinculado. Esto último lo hace con la función `.read_`*tipodocumento*. En este caso vamos a indicarle que es un documento **.csv** aunque los datos no lo sean, porque de esta forma le decimos a Python que cada dato está delimitado por `;`. Al indicarle eso también haremos que el propio Python genere un archivo csv (como podemos comprobar en la interfaz de nuestro servidor) a partir de los datos de la api. \n",
    "\n",
    "Una vez indicado el tipo de archivo, corresponde en la sintaxis introducir la referencia del mismo. En nuestro caso es la base de datos, pero no es necesario copiar su link ya que anteriormente la hemos definido como variable, por lo que le damos la referencia (*url_zrgz*). Por último, le especificamos que introduzca los datos delimitados: `pd.read_csv(url_zrgz,delimiter=';')`."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**NOTA**: Un delimitador es una secuencia de uno o más caracteres para especificar el límite entre regiones separadas e independientes en flujos de datos. Así logramos que presente los datos, que no son tabulados, en categorías."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_zrgz = pd.read_csv(url_zrgz,delimiter=';')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>id</th>\n",
       "      <th>year</th>\n",
       "      <th>type</th>\n",
       "      <th>accidentType</th>\n",
       "      <th>firstAddress</th>\n",
       "      <th>secondAddress</th>\n",
       "      <th>geometry</th>\n",
       "      <th>reason</th>\n",
       "      <th>area</th>\n",
       "      <th>creationDate</th>\n",
       "      <th>daniosMateriales</th>\n",
       "      <th>falloMecanico</th>\n",
       "      <th>estadoPavimento</th>\n",
       "      <th>tipoEstadoPavimento</th>\n",
       "      <th>estadoAtmosfera</th>\n",
       "      <th>tipoEstadoAtmosfera</th>\n",
       "      <th>afectado</th>\n",
       "      <th>vehiculo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>SALIDA CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>COSTA, JOAQUIN</td>\n",
       "      <td>PERAL, ISAAC</td>\n",
       "      <td>-0.8818527060979306,41.649027473051156</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-10-09T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CADENA(MARQUES DE LA)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8645810716721081,41.661585829868585</td>\n",
       "      <td>DISTANCIA DE SEGURIDAD, no mantener</td>\n",
       "      <td>2560.0</td>\n",
       "      <td>2014-10-23T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GOMEZ AVELLANEDA, G.</td>\n",
       "      <td>CASTRO, R. (POETA)</td>\n",
       "      <td>-0.887776415002892,41.666992622958105</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>2598.0</td>\n",
       "      <td>2014-10-23T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLIS FRONTOLATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MONZON</td>\n",
       "      <td>GARCIA CONDOY, H.</td>\n",
       "      <td>-0.8825260453930127,41.62957498750602</td>\n",
       "      <td>CEDA EL PASO, no respetar prioridad de paso</td>\n",
       "      <td>2555.0</td>\n",
       "      <td>2014-10-23T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>SALIDA CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RIOJA</td>\n",
       "      <td>NAVARRA, AVENIDA DE</td>\n",
       "      <td>-0.908314757720389,41.6562121210704</td>\n",
       "      <td>PERDIDA del control por VELOCIDAD INADECUADA</td>\n",
       "      <td>2554.0</td>\n",
       "      <td>2014-10-24T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>OTRAS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MUEL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8691088511672924,41.65949772773082</td>\n",
       "      <td>Caída de ocupante en Transporte Público</td>\n",
       "      <td>2578.0</td>\n",
       "      <td>2014-10-24T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>ATROPELLO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PIGNATELLI, RAMON VIA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8880337913721866,41.633353667694024</td>\n",
       "      <td>PEATÓN cruza calz SIN PREFER. fuera de paso</td>\n",
       "      <td>2606.0</td>\n",
       "      <td>2014-10-24T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>CAIDA SOBRE CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALIERTA, AV. CESAREO</td>\n",
       "      <td>AULA, LUIS</td>\n",
       "      <td>-0.8708838775078237,41.6390382112928</td>\n",
       "      <td>INVADIR otro carril en el mismo sentido de cir...</td>\n",
       "      <td>2583.0</td>\n",
       "      <td>2014-10-24T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLIS. MARCHA ATRÁS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CERBUNA, PEDRO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8970649943808023,41.64083344974765</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>2556.0</td>\n",
       "      <td>2014-10-24T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN LATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ASALTO</td>\n",
       "      <td>COCCI, JORGE</td>\n",
       "      <td>-0.8718525605769747,41.64904657717317</td>\n",
       "      <td>INVADIR otro carril en el mismo sentido de cir...</td>\n",
       "      <td>4657.0</td>\n",
       "      <td>2013-12-20T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>OTRAS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ARAGON (CORONA DE)</td>\n",
       "      <td>SAN ANTONIO M CLARET</td>\n",
       "      <td>-0.8964627561577849,41.64322365075108</td>\n",
       "      <td>Caída de ocupante en Transporte Público</td>\n",
       "      <td>63.0</td>\n",
       "      <td>2013-12-21T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FRAGUA, LA</td>\n",
       "      <td>GASSIER, PIERRE</td>\n",
       "      <td>-0.8778095796207178,41.68753087470739</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>4780.0</td>\n",
       "      <td>2013-12-22T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>SALIDA CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PIRINEOS, AV. DE LOS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8812157329722801,41.661646612715046</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>4661.0</td>\n",
       "      <td>2013-12-22T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TORRES, CAMINO DE LAS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8762000299022707,41.6454384961757</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>4667.0</td>\n",
       "      <td>2013-12-22T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>ATROPELLO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RIOJA</td>\n",
       "      <td>NAVARRA, AVENIDA DE</td>\n",
       "      <td>-0.9089013552408617,41.65543768899759</td>\n",
       "      <td>PEATÓN cruza calz SIN PREFER. en PASO CON semá...</td>\n",
       "      <td>4664.0</td>\n",
       "      <td>2013-12-22T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ITALIA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.9004729973337304,41.65180346604993</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>4671.0</td>\n",
       "      <td>2013-12-22T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AGUSTIN, PASEO MARIA</td>\n",
       "      <td>MAYANDIA (GENERAL)</td>\n",
       "      <td>-0.8917562993466011,41.65233828238132</td>\n",
       "      <td>DISTANCIA DE SEGURIDAD, no mantener</td>\n",
       "      <td>18.0</td>\n",
       "      <td>2013-12-20T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AGUSTIN, PASEO MARIA</td>\n",
       "      <td>SANTA ANA</td>\n",
       "      <td>-0.888856043735591,41.65040494617356</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>4718.0</td>\n",
       "      <td>2013-12-23T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CASPE, AV.COMPROMISO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8629911318784169,41.645335650478316</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>4723.0</td>\n",
       "      <td>2013-12-23T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MURANO, ISLA DE AV.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8870207060655807,41.609992514227066</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-12-23T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN LATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HISPANIDAD, RONDA DE</td>\n",
       "      <td>ALIERTA, AV. CESAREO</td>\n",
       "      <td>-0.8636325074780108,41.63379905763323</td>\n",
       "      <td>PUERTA abierta incorrectamente</td>\n",
       "      <td>17.0</td>\n",
       "      <td>2013-12-23T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>CAIDA SOBRE CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ZARAGOZA LA VIEJA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8760724207544668,41.63275556609146</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>4677.0</td>\n",
       "      <td>2013-12-21T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ASIN Y PALACIOS, MIG.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.9036852209830768,41.63808926467497</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-12-17T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLIS. MARCHA ATRÁS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ZAMBRANO, M. (POETA)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8896980442453839,41.677487884305975</td>\n",
       "      <td>MARCHA ATRÁS</td>\n",
       "      <td>4783.0</td>\n",
       "      <td>2013-12-23T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>SALIDA CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALBA (DUQUE DE),PASEO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.9018264648858587,41.620591734015946</td>\n",
       "      <td>PERDIDA del control por VELOCIDAD INADECUADA</td>\n",
       "      <td>4679.0</td>\n",
       "      <td>2013-12-15T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLIS FRONTOLATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HISPANIDAD, VIA</td>\n",
       "      <td>MADRID, AVENIDA DE</td>\n",
       "      <td>-0.9187726932212442,41.64931371437485</td>\n",
       "      <td>SEMÁFORO, no respetar prioridad de paso</td>\n",
       "      <td>4773.0</td>\n",
       "      <td>2013-12-20T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN LATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PARAISO, PL.BASILIO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8855988456901538,41.646890443474554</td>\n",
       "      <td>INVADIR otro carril en el mismo sentido de cir...</td>\n",
       "      <td>4702.0</td>\n",
       "      <td>2013-12-17T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN LATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HISPANIDAD, RONDA DE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.887523212911549,41.62404668544956</td>\n",
       "      <td>PUERTA abierta incorrectamente</td>\n",
       "      <td>4701.0</td>\n",
       "      <td>2013-12-20T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN LATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SAGASTA, PASEO DE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8863120908790753,41.63964884250951</td>\n",
       "      <td>INVADIR otro carril en el mismo sentido de cir...</td>\n",
       "      <td>4700.0</td>\n",
       "      <td>2013-12-19T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN LATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CABALDOS, CAMINO DE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8689640327130923,41.638477534601776</td>\n",
       "      <td>INVADIR otro carril en el mismo sentido de cir...</td>\n",
       "      <td>4752.0</td>\n",
       "      <td>2013-12-24T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>CAIDA SOBRE CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GOYA,FCO.(PINTOR) AV.</td>\n",
       "      <td>TORRES MORALES, M.G.</td>\n",
       "      <td>-0.8900650666830714,41.64332496247496</td>\n",
       "      <td>DISTANCIA DE SEGURIDAD, no mantener</td>\n",
       "      <td>4751.0</td>\n",
       "      <td>2013-12-24T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>COLISIÓN LATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AGUSTIN, PASEO MARIA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8918524618079099,41.65260977469196</td>\n",
       "      <td>INVADIR otro carril en el mismo sentido de cir...</td>\n",
       "      <td>4750.0</td>\n",
       "      <td>2013-12-25T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>OTRAS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RIOJA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.9104038365599549,41.65248328671194</td>\n",
       "      <td>OTRAS CAUSAS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2013-12-19T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLISIÓN LATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CONSTITUCION, PASEO</td>\n",
       "      <td>PARAISO, PL.BASILIO</td>\n",
       "      <td>-0.8850103896969528,41.6474034449745</td>\n",
       "      <td>INVADIR otro carril en el mismo sentido de cir...</td>\n",
       "      <td>2682.0</td>\n",
       "      <td>2014-10-24T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLIS. MARCHA ATRÁS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TORRE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8734135018983006,41.64926981833846</td>\n",
       "      <td>MARCHA ATRÁS</td>\n",
       "      <td>2626.0</td>\n",
       "      <td>2014-10-27T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ECHEGARAY Y CABALLERO</td>\n",
       "      <td>MATUTE HERVIAS,JULIAN</td>\n",
       "      <td>-0.8593239531218387,41.650740541708075</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>2605.0</td>\n",
       "      <td>2014-10-27T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLIS FRONTOLATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CABALDOS, CAMINO DE</td>\n",
       "      <td>CASTELAR, EMILIO</td>\n",
       "      <td>-0.868891092151338,41.638807389014836</td>\n",
       "      <td>INVADIR otro carril en el mismo sentido de cir...</td>\n",
       "      <td>2591.0</td>\n",
       "      <td>2014-10-25T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>ATROPELLO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALMOZARA, AV. DE LA</td>\n",
       "      <td>PUERTA DE SANCHO, AV.</td>\n",
       "      <td>-0.9008107424460443,41.66374540604866</td>\n",
       "      <td>PEATÓN cruza calz CON PREFER. en PASO  CON sem...</td>\n",
       "      <td>2610.0</td>\n",
       "      <td>2014-10-29T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLIS. MARCHA ATRÁS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OLIVAN, ALEJANDRO</td>\n",
       "      <td>BOSQUED, JOSE (MOSEN)</td>\n",
       "      <td>-0.9211220937948997,41.64886535549928</td>\n",
       "      <td>MARCHA ATRÁS</td>\n",
       "      <td>2594.0</td>\n",
       "      <td>2014-10-24T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLIS. MARCHA ATRÁS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ARRUPE, PADRE</td>\n",
       "      <td>VAZQUEZ DE MELLA</td>\n",
       "      <td>-0.9026681648170423,41.63265453864093</td>\n",
       "      <td>MARCHA ATRÁS</td>\n",
       "      <td>2596.0</td>\n",
       "      <td>2014-10-20T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLIS FRONTOLATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RUIZ PICASSO, PABLO</td>\n",
       "      <td>ZAMBRANO, M. (POETA)</td>\n",
       "      <td>-0.8893162332922886,41.67281318904247</td>\n",
       "      <td>OTRAS CAUSAS</td>\n",
       "      <td>2640.0</td>\n",
       "      <td>2014-10-29T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>ATROPELLO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CAMPOAMOR, CLARA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8890866503471749,41.66895757951277</td>\n",
       "      <td>PEATÓN cruza calz CON PREFER. en PASO  SIN sem...</td>\n",
       "      <td>2600.0</td>\n",
       "      <td>2014-10-29T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>SALIDA CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CASCAJO, CN. DEL  SJN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8439506345833918,41.71496486522088</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-10-29T00:00:00Z</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>SALIDA CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EDISON, TOMAS A</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8665477541801948,41.67007665525934</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-10-29T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CUELLAR, PASEO DE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.8848493117953854,41.63484525009101</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>2604.0</td>\n",
       "      <td>2014-10-28T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLISIÓN LATERAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HISPANIDAD, VIA</td>\n",
       "      <td>GOMEZ LAGUNA(ALCALDE)</td>\n",
       "      <td>-0.9147014503640727,41.64060309287472</td>\n",
       "      <td>INVADIR otro carril en el mismo sentido de cir...</td>\n",
       "      <td>2624.0</td>\n",
       "      <td>2014-10-29T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>COLISIÓN ALCANCE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PLAN, IBON DE</td>\n",
       "      <td>AEROPUERTO, CARRETERA</td>\n",
       "      <td>-0.9388159722509236,41.66210291413718</td>\n",
       "      <td>DISTANCIA DE SEGURIDAD, no mantener</td>\n",
       "      <td>2611.0</td>\n",
       "      <td>2014-10-27T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2014</td>\n",
       "      <td>SALIDA CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FANLO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.9157439755527074,41.63348367532985</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>2631.0</td>\n",
       "      <td>2014-10-27T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>SALIDA CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AZNAR,ADOLFO(CINEASTA</td>\n",
       "      <td>BELTRAN,J.M.(CINEASTA</td>\n",
       "      <td>-0.8869959298557372,41.67593597602368</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>4438.0</td>\n",
       "      <td>2013-12-02T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "      <td>2013</td>\n",
       "      <td>SALIDA CALZADA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALLENDE, SALVADOR AV.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.876909940066992,41.672106692157605</td>\n",
       "      <td>PERDIDA del control por FALTA de ATENCIÓN</td>\n",
       "      <td>4684.0</td>\n",
       "      <td>2013-12-05T00:00:00Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BUEN ESTADO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.zaragoza.es/sede/servicio/transpor...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   id  year  \\\n",
       "0   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "1   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "2   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "3   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "4   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "5   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "6   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "7   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "8   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "9   https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "10  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "11  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "12  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "13  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "14  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "15  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "16  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "17  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "18  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "19  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "20  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "21  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "22  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "23  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "24  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "25  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "26  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "27  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "28  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "29  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "30  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "31  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "32  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "33  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "34  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "35  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "36  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "37  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "38  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "39  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "40  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "41  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "42  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "43  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "44  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "45  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "46  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "47  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "48  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "49  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "\n",
       "                   type  accidentType           firstAddress  \\\n",
       "0        SALIDA CALZADA           NaN         COSTA, JOAQUIN   \n",
       "1      COLISIÓN ALCANCE           NaN  CADENA(MARQUES DE LA)   \n",
       "2      COLISIÓN ALCANCE           NaN   GOMEZ AVELLANEDA, G.   \n",
       "3   COLIS FRONTOLATERAL           NaN                 MONZON   \n",
       "4        SALIDA CALZADA           NaN                  RIOJA   \n",
       "5                 OTRAS           NaN                   MUEL   \n",
       "6             ATROPELLO           NaN  PIGNATELLI, RAMON VIA   \n",
       "7   CAIDA SOBRE CALZADA           NaN   ALIERTA, AV. CESAREO   \n",
       "8   COLIS. MARCHA ATRÁS           NaN         CERBUNA, PEDRO   \n",
       "9      COLISIÓN LATERAL           NaN                 ASALTO   \n",
       "10                OTRAS           NaN     ARAGON (CORONA DE)   \n",
       "11     COLISIÓN ALCANCE           NaN             FRAGUA, LA   \n",
       "12       SALIDA CALZADA           NaN   PIRINEOS, AV. DE LOS   \n",
       "13     COLISIÓN ALCANCE           NaN  TORRES, CAMINO DE LAS   \n",
       "14            ATROPELLO           NaN                  RIOJA   \n",
       "15     COLISIÓN ALCANCE           NaN                 ITALIA   \n",
       "16     COLISIÓN ALCANCE           NaN   AGUSTIN, PASEO MARIA   \n",
       "17     COLISIÓN ALCANCE           NaN   AGUSTIN, PASEO MARIA   \n",
       "18     COLISIÓN ALCANCE           NaN   CASPE, AV.COMPROMISO   \n",
       "19     COLISIÓN ALCANCE           NaN    MURANO, ISLA DE AV.   \n",
       "20     COLISIÓN LATERAL           NaN   HISPANIDAD, RONDA DE   \n",
       "21  CAIDA SOBRE CALZADA           NaN      ZARAGOZA LA VIEJA   \n",
       "22     COLISIÓN ALCANCE           NaN  ASIN Y PALACIOS, MIG.   \n",
       "23  COLIS. MARCHA ATRÁS           NaN   ZAMBRANO, M. (POETA)   \n",
       "24       SALIDA CALZADA           NaN  ALBA (DUQUE DE),PASEO   \n",
       "25  COLIS FRONTOLATERAL           NaN        HISPANIDAD, VIA   \n",
       "26     COLISIÓN LATERAL           NaN    PARAISO, PL.BASILIO   \n",
       "27     COLISIÓN LATERAL           NaN   HISPANIDAD, RONDA DE   \n",
       "28     COLISIÓN LATERAL           NaN      SAGASTA, PASEO DE   \n",
       "29     COLISIÓN LATERAL           NaN    CABALDOS, CAMINO DE   \n",
       "30  CAIDA SOBRE CALZADA           NaN  GOYA,FCO.(PINTOR) AV.   \n",
       "31     COLISIÓN LATERAL           NaN   AGUSTIN, PASEO MARIA   \n",
       "32                OTRAS           NaN                  RIOJA   \n",
       "33     COLISIÓN LATERAL           NaN    CONSTITUCION, PASEO   \n",
       "34  COLIS. MARCHA ATRÁS           NaN                  TORRE   \n",
       "35     COLISIÓN ALCANCE           NaN  ECHEGARAY Y CABALLERO   \n",
       "36  COLIS FRONTOLATERAL           NaN    CABALDOS, CAMINO DE   \n",
       "37            ATROPELLO           NaN    ALMOZARA, AV. DE LA   \n",
       "38  COLIS. MARCHA ATRÁS           NaN      OLIVAN, ALEJANDRO   \n",
       "39  COLIS. MARCHA ATRÁS           NaN          ARRUPE, PADRE   \n",
       "40  COLIS FRONTOLATERAL           NaN    RUIZ PICASSO, PABLO   \n",
       "41            ATROPELLO           NaN       CAMPOAMOR, CLARA   \n",
       "42       SALIDA CALZADA           NaN  CASCAJO, CN. DEL  SJN   \n",
       "43       SALIDA CALZADA           NaN        EDISON, TOMAS A   \n",
       "44     COLISIÓN ALCANCE           NaN      CUELLAR, PASEO DE   \n",
       "45     COLISIÓN LATERAL           NaN        HISPANIDAD, VIA   \n",
       "46     COLISIÓN ALCANCE           NaN          PLAN, IBON DE   \n",
       "47       SALIDA CALZADA           NaN                  FANLO   \n",
       "48       SALIDA CALZADA           NaN  AZNAR,ADOLFO(CINEASTA   \n",
       "49       SALIDA CALZADA           NaN  ALLENDE, SALVADOR AV.   \n",
       "\n",
       "            secondAddress                                geometry  \\\n",
       "0            PERAL, ISAAC  -0.8818527060979306,41.649027473051156   \n",
       "1                     NaN  -0.8645810716721081,41.661585829868585   \n",
       "2      CASTRO, R. (POETA)   -0.887776415002892,41.666992622958105   \n",
       "3       GARCIA CONDOY, H.   -0.8825260453930127,41.62957498750602   \n",
       "4     NAVARRA, AVENIDA DE     -0.908314757720389,41.6562121210704   \n",
       "5                     NaN   -0.8691088511672924,41.65949772773082   \n",
       "6                     NaN  -0.8880337913721866,41.633353667694024   \n",
       "7              AULA, LUIS    -0.8708838775078237,41.6390382112928   \n",
       "8                     NaN   -0.8970649943808023,41.64083344974765   \n",
       "9            COCCI, JORGE   -0.8718525605769747,41.64904657717317   \n",
       "10   SAN ANTONIO M CLARET   -0.8964627561577849,41.64322365075108   \n",
       "11        GASSIER, PIERRE   -0.8778095796207178,41.68753087470739   \n",
       "12                    NaN  -0.8812157329722801,41.661646612715046   \n",
       "13                    NaN    -0.8762000299022707,41.6454384961757   \n",
       "14    NAVARRA, AVENIDA DE   -0.9089013552408617,41.65543768899759   \n",
       "15                    NaN   -0.9004729973337304,41.65180346604993   \n",
       "16     MAYANDIA (GENERAL)   -0.8917562993466011,41.65233828238132   \n",
       "17              SANTA ANA    -0.888856043735591,41.65040494617356   \n",
       "18                    NaN  -0.8629911318784169,41.645335650478316   \n",
       "19                    NaN  -0.8870207060655807,41.609992514227066   \n",
       "20   ALIERTA, AV. CESAREO   -0.8636325074780108,41.63379905763323   \n",
       "21                    NaN   -0.8760724207544668,41.63275556609146   \n",
       "22                    NaN   -0.9036852209830768,41.63808926467497   \n",
       "23                    NaN  -0.8896980442453839,41.677487884305975   \n",
       "24                    NaN  -0.9018264648858587,41.620591734015946   \n",
       "25     MADRID, AVENIDA DE   -0.9187726932212442,41.64931371437485   \n",
       "26                    NaN  -0.8855988456901538,41.646890443474554   \n",
       "27                    NaN    -0.887523212911549,41.62404668544956   \n",
       "28                    NaN   -0.8863120908790753,41.63964884250951   \n",
       "29                    NaN  -0.8689640327130923,41.638477534601776   \n",
       "30   TORRES MORALES, M.G.   -0.8900650666830714,41.64332496247496   \n",
       "31                    NaN   -0.8918524618079099,41.65260977469196   \n",
       "32                    NaN   -0.9104038365599549,41.65248328671194   \n",
       "33    PARAISO, PL.BASILIO    -0.8850103896969528,41.6474034449745   \n",
       "34                    NaN   -0.8734135018983006,41.64926981833846   \n",
       "35  MATUTE HERVIAS,JULIAN  -0.8593239531218387,41.650740541708075   \n",
       "36       CASTELAR, EMILIO   -0.868891092151338,41.638807389014836   \n",
       "37  PUERTA DE SANCHO, AV.   -0.9008107424460443,41.66374540604866   \n",
       "38  BOSQUED, JOSE (MOSEN)   -0.9211220937948997,41.64886535549928   \n",
       "39       VAZQUEZ DE MELLA   -0.9026681648170423,41.63265453864093   \n",
       "40   ZAMBRANO, M. (POETA)   -0.8893162332922886,41.67281318904247   \n",
       "41                    NaN   -0.8890866503471749,41.66895757951277   \n",
       "42                    NaN   -0.8439506345833918,41.71496486522088   \n",
       "43                    NaN   -0.8665477541801948,41.67007665525934   \n",
       "44                    NaN   -0.8848493117953854,41.63484525009101   \n",
       "45  GOMEZ LAGUNA(ALCALDE)   -0.9147014503640727,41.64060309287472   \n",
       "46  AEROPUERTO, CARRETERA   -0.9388159722509236,41.66210291413718   \n",
       "47                    NaN   -0.9157439755527074,41.63348367532985   \n",
       "48  BELTRAN,J.M.(CINEASTA   -0.8869959298557372,41.67593597602368   \n",
       "49                    NaN   -0.876909940066992,41.672106692157605   \n",
       "\n",
       "                                               reason    area  \\\n",
       "0           PERDIDA del control por FALTA de ATENCIÓN     NaN   \n",
       "1                 DISTANCIA DE SEGURIDAD, no mantener  2560.0   \n",
       "2           PERDIDA del control por FALTA de ATENCIÓN  2598.0   \n",
       "3         CEDA EL PASO, no respetar prioridad de paso  2555.0   \n",
       "4        PERDIDA del control por VELOCIDAD INADECUADA  2554.0   \n",
       "5             Caída de ocupante en Transporte Público  2578.0   \n",
       "6         PEATÓN cruza calz SIN PREFER. fuera de paso  2606.0   \n",
       "7   INVADIR otro carril en el mismo sentido de cir...  2583.0   \n",
       "8           PERDIDA del control por FALTA de ATENCIÓN  2556.0   \n",
       "9   INVADIR otro carril en el mismo sentido de cir...  4657.0   \n",
       "10            Caída de ocupante en Transporte Público    63.0   \n",
       "11          PERDIDA del control por FALTA de ATENCIÓN  4780.0   \n",
       "12          PERDIDA del control por FALTA de ATENCIÓN  4661.0   \n",
       "13          PERDIDA del control por FALTA de ATENCIÓN  4667.0   \n",
       "14  PEATÓN cruza calz SIN PREFER. en PASO CON semá...  4664.0   \n",
       "15          PERDIDA del control por FALTA de ATENCIÓN  4671.0   \n",
       "16                DISTANCIA DE SEGURIDAD, no mantener    18.0   \n",
       "17          PERDIDA del control por FALTA de ATENCIÓN  4718.0   \n",
       "18          PERDIDA del control por FALTA de ATENCIÓN  4723.0   \n",
       "19          PERDIDA del control por FALTA de ATENCIÓN     NaN   \n",
       "20                     PUERTA abierta incorrectamente    17.0   \n",
       "21          PERDIDA del control por FALTA de ATENCIÓN  4677.0   \n",
       "22          PERDIDA del control por FALTA de ATENCIÓN     NaN   \n",
       "23                                       MARCHA ATRÁS  4783.0   \n",
       "24       PERDIDA del control por VELOCIDAD INADECUADA  4679.0   \n",
       "25            SEMÁFORO, no respetar prioridad de paso  4773.0   \n",
       "26  INVADIR otro carril en el mismo sentido de cir...  4702.0   \n",
       "27                     PUERTA abierta incorrectamente  4701.0   \n",
       "28  INVADIR otro carril en el mismo sentido de cir...  4700.0   \n",
       "29  INVADIR otro carril en el mismo sentido de cir...  4752.0   \n",
       "30                DISTANCIA DE SEGURIDAD, no mantener  4751.0   \n",
       "31  INVADIR otro carril en el mismo sentido de cir...  4750.0   \n",
       "32                                       OTRAS CAUSAS     NaN   \n",
       "33  INVADIR otro carril en el mismo sentido de cir...  2682.0   \n",
       "34                                       MARCHA ATRÁS  2626.0   \n",
       "35          PERDIDA del control por FALTA de ATENCIÓN  2605.0   \n",
       "36  INVADIR otro carril en el mismo sentido de cir...  2591.0   \n",
       "37  PEATÓN cruza calz CON PREFER. en PASO  CON sem...  2610.0   \n",
       "38                                       MARCHA ATRÁS  2594.0   \n",
       "39                                       MARCHA ATRÁS  2596.0   \n",
       "40                                       OTRAS CAUSAS  2640.0   \n",
       "41  PEATÓN cruza calz CON PREFER. en PASO  SIN sem...  2600.0   \n",
       "42          PERDIDA del control por FALTA de ATENCIÓN     NaN   \n",
       "43          PERDIDA del control por FALTA de ATENCIÓN     NaN   \n",
       "44          PERDIDA del control por FALTA de ATENCIÓN  2604.0   \n",
       "45  INVADIR otro carril en el mismo sentido de cir...  2624.0   \n",
       "46                DISTANCIA DE SEGURIDAD, no mantener  2611.0   \n",
       "47          PERDIDA del control por FALTA de ATENCIÓN  2631.0   \n",
       "48          PERDIDA del control por FALTA de ATENCIÓN  4438.0   \n",
       "49          PERDIDA del control por FALTA de ATENCIÓN  4684.0   \n",
       "\n",
       "            creationDate  daniosMateriales  falloMecanico estadoPavimento  \\\n",
       "0   2014-10-09T00:00:00Z              True          False     BUEN ESTADO   \n",
       "1   2014-10-23T00:00:00Z             False          False     BUEN ESTADO   \n",
       "2   2014-10-23T00:00:00Z             False          False     BUEN ESTADO   \n",
       "3   2014-10-23T00:00:00Z             False          False     BUEN ESTADO   \n",
       "4   2014-10-24T00:00:00Z             False          False     BUEN ESTADO   \n",
       "5   2014-10-24T00:00:00Z             False          False     BUEN ESTADO   \n",
       "6   2014-10-24T00:00:00Z             False          False     BUEN ESTADO   \n",
       "7   2014-10-24T00:00:00Z             False          False     BUEN ESTADO   \n",
       "8   2014-10-24T00:00:00Z              True          False     BUEN ESTADO   \n",
       "9   2013-12-20T00:00:00Z             False          False     BUEN ESTADO   \n",
       "10  2013-12-21T00:00:00Z             False          False     BUEN ESTADO   \n",
       "11  2013-12-22T00:00:00Z              True          False     BUEN ESTADO   \n",
       "12  2013-12-22T00:00:00Z             False          False     BUEN ESTADO   \n",
       "13  2013-12-22T00:00:00Z             False          False     BUEN ESTADO   \n",
       "14  2013-12-22T00:00:00Z             False          False     BUEN ESTADO   \n",
       "15  2013-12-22T00:00:00Z              True          False     BUEN ESTADO   \n",
       "16  2013-12-20T00:00:00Z             False          False     BUEN ESTADO   \n",
       "17  2013-12-23T00:00:00Z             False          False     BUEN ESTADO   \n",
       "18  2013-12-23T00:00:00Z             False          False     BUEN ESTADO   \n",
       "19  2013-12-23T00:00:00Z              True          False     BUEN ESTADO   \n",
       "20  2013-12-23T00:00:00Z             False          False     BUEN ESTADO   \n",
       "21  2013-12-21T00:00:00Z             False          False     BUEN ESTADO   \n",
       "22  2013-12-17T00:00:00Z              True          False     BUEN ESTADO   \n",
       "23  2013-12-23T00:00:00Z              True          False     BUEN ESTADO   \n",
       "24  2013-12-15T00:00:00Z              True          False     BUEN ESTADO   \n",
       "25  2013-12-20T00:00:00Z              True          False     BUEN ESTADO   \n",
       "26  2013-12-17T00:00:00Z              True          False     BUEN ESTADO   \n",
       "27  2013-12-20T00:00:00Z              True          False     BUEN ESTADO   \n",
       "28  2013-12-19T00:00:00Z              True          False     BUEN ESTADO   \n",
       "29  2013-12-24T00:00:00Z             False          False     BUEN ESTADO   \n",
       "30  2013-12-24T00:00:00Z             False          False     BUEN ESTADO   \n",
       "31  2013-12-25T00:00:00Z             False          False     BUEN ESTADO   \n",
       "32  2013-12-19T00:00:00Z              True          False     BUEN ESTADO   \n",
       "33  2014-10-24T00:00:00Z              True          False     BUEN ESTADO   \n",
       "34  2014-10-27T00:00:00Z              True          False     BUEN ESTADO   \n",
       "35  2014-10-27T00:00:00Z              True          False     BUEN ESTADO   \n",
       "36  2014-10-25T00:00:00Z              True          False     BUEN ESTADO   \n",
       "37  2014-10-29T00:00:00Z             False          False     BUEN ESTADO   \n",
       "38  2014-10-24T00:00:00Z              True          False     BUEN ESTADO   \n",
       "39  2014-10-20T00:00:00Z              True          False     BUEN ESTADO   \n",
       "40  2014-10-29T00:00:00Z             False          False     BUEN ESTADO   \n",
       "41  2014-10-29T00:00:00Z             False          False     BUEN ESTADO   \n",
       "42  2014-10-29T00:00:00Z             False          False     BUEN ESTADO   \n",
       "43  2014-10-29T00:00:00Z              True          False     BUEN ESTADO   \n",
       "44  2014-10-28T00:00:00Z              True          False     BUEN ESTADO   \n",
       "45  2014-10-29T00:00:00Z              True          False     BUEN ESTADO   \n",
       "46  2014-10-27T00:00:00Z              True          False     BUEN ESTADO   \n",
       "47  2014-10-27T00:00:00Z              True          False     BUEN ESTADO   \n",
       "48  2013-12-02T00:00:00Z              True          False     BUEN ESTADO   \n",
       "49  2013-12-05T00:00:00Z              True          False     BUEN ESTADO   \n",
       "\n",
       "    tipoEstadoPavimento estadoAtmosfera  tipoEstadoAtmosfera  \\\n",
       "0                   NaN     BUEN ESTADO                  NaN   \n",
       "1                   NaN     BUEN ESTADO                  NaN   \n",
       "2                   NaN     BUEN ESTADO                  NaN   \n",
       "3                   NaN     BUEN ESTADO                  NaN   \n",
       "4                   NaN     BUEN ESTADO                  NaN   \n",
       "5                   NaN     BUEN ESTADO                  NaN   \n",
       "6                   NaN     BUEN ESTADO                  NaN   \n",
       "7                   NaN     BUEN ESTADO                  NaN   \n",
       "8                   NaN     BUEN ESTADO                  NaN   \n",
       "9                   NaN     BUEN ESTADO                  NaN   \n",
       "10                  NaN     BUEN ESTADO                  NaN   \n",
       "11                  NaN     BUEN ESTADO                  NaN   \n",
       "12                  NaN     BUEN ESTADO                  NaN   \n",
       "13                  NaN     BUEN ESTADO                  NaN   \n",
       "14                  NaN     BUEN ESTADO                  NaN   \n",
       "15                  NaN     BUEN ESTADO                  NaN   \n",
       "16                  NaN     BUEN ESTADO                  NaN   \n",
       "17                  NaN     BUEN ESTADO                  NaN   \n",
       "18                  NaN     BUEN ESTADO                  NaN   \n",
       "19                  NaN     BUEN ESTADO                  NaN   \n",
       "20                  NaN     BUEN ESTADO                  NaN   \n",
       "21                  NaN     BUEN ESTADO                  NaN   \n",
       "22                  NaN     BUEN ESTADO                  NaN   \n",
       "23                  NaN     BUEN ESTADO                  NaN   \n",
       "24                  NaN     BUEN ESTADO                  NaN   \n",
       "25                  NaN     BUEN ESTADO                  NaN   \n",
       "26                  NaN     BUEN ESTADO                  NaN   \n",
       "27                  NaN     BUEN ESTADO                  NaN   \n",
       "28                  NaN     BUEN ESTADO                  NaN   \n",
       "29                  NaN     BUEN ESTADO                  NaN   \n",
       "30                  NaN     BUEN ESTADO                  NaN   \n",
       "31                  NaN     BUEN ESTADO                  NaN   \n",
       "32                  NaN     BUEN ESTADO                  NaN   \n",
       "33                  NaN     BUEN ESTADO                  NaN   \n",
       "34                  NaN     BUEN ESTADO                  NaN   \n",
       "35                  NaN     BUEN ESTADO                  NaN   \n",
       "36                  NaN     BUEN ESTADO                  NaN   \n",
       "37                  NaN     BUEN ESTADO                  NaN   \n",
       "38                  NaN     BUEN ESTADO                  NaN   \n",
       "39                  NaN     BUEN ESTADO                  NaN   \n",
       "40                  NaN     BUEN ESTADO                  NaN   \n",
       "41                  NaN     BUEN ESTADO                  NaN   \n",
       "42                  NaN     BUEN ESTADO                  NaN   \n",
       "43                  NaN     BUEN ESTADO                  NaN   \n",
       "44                  NaN     BUEN ESTADO                  NaN   \n",
       "45                  NaN     BUEN ESTADO                  NaN   \n",
       "46                  NaN     BUEN ESTADO                  NaN   \n",
       "47                  NaN     BUEN ESTADO                  NaN   \n",
       "48                  NaN     BUEN ESTADO                  NaN   \n",
       "49                  NaN     BUEN ESTADO                  NaN   \n",
       "\n",
       "                                             afectado  \\\n",
       "0                                                 NaN   \n",
       "1   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "2   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "3   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "4   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "5   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "6   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "7   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "8                                                 NaN   \n",
       "9   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "10  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "11                                                NaN   \n",
       "12  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "13  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "14  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "15                                                NaN   \n",
       "16  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "17  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "18  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "19                                                NaN   \n",
       "20  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "21  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "22                                                NaN   \n",
       "23                                                NaN   \n",
       "24                                                NaN   \n",
       "25                                                NaN   \n",
       "26                                                NaN   \n",
       "27                                                NaN   \n",
       "28                                                NaN   \n",
       "29  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "30  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "31  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "32                                                NaN   \n",
       "33                                                NaN   \n",
       "34                                                NaN   \n",
       "35                                                NaN   \n",
       "36                                                NaN   \n",
       "37  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "38                                                NaN   \n",
       "39                                                NaN   \n",
       "40  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "41  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "42  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "43                                                NaN   \n",
       "44                                                NaN   \n",
       "45                                                NaN   \n",
       "46                                                NaN   \n",
       "47                                                NaN   \n",
       "48                                                NaN   \n",
       "49                                                NaN   \n",
       "\n",
       "                                             vehiculo  \n",
       "0   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "1   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "2   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "3   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "4   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "5   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "6   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "7   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "8   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "9   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "10  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "11  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "12  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "13  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "14  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "15  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "16  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "17  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "18  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "19  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "20  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "21  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "22  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "23  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "24  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "25  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "26  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "27  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "28  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "29  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "30  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "31  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "32  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "33  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "34  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "35  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "36  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "37  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "38  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "39  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "40  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "41  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "42  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "43  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "44  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "45  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "46  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "47  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "48  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "49  https://www.zaragoza.es/sede/servicio/transpor...  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Una vez tenemos el dataframe creado lo exploramos con distintas funciones. En primer lugar, `.info` para saber qué contiene el dataframe."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bound method DataFrame.info of                                                    id  year  \\\n",
       "0   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "1   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "2   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "3   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "4   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "5   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "6   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "7   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "8   https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "9   https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "10  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "11  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "12  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "13  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "14  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "15  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "16  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "17  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "18  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "19  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "20  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "21  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "22  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "23  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "24  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "25  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "26  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "27  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "28  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "29  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "30  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "31  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "32  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "33  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "34  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "35  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "36  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "37  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "38  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "39  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "40  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "41  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "42  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "43  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "44  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "45  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "46  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "47  https://www.zaragoza.es/sede/servicio/transpor...  2014   \n",
       "48  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "49  https://www.zaragoza.es/sede/servicio/transpor...  2013   \n",
       "\n",
       "                   type  accidentType           firstAddress  \\\n",
       "0        SALIDA CALZADA           NaN         COSTA, JOAQUIN   \n",
       "1      COLISIÓN ALCANCE           NaN  CADENA(MARQUES DE LA)   \n",
       "2      COLISIÓN ALCANCE           NaN   GOMEZ AVELLANEDA, G.   \n",
       "3   COLIS FRONTOLATERAL           NaN                 MONZON   \n",
       "4        SALIDA CALZADA           NaN                  RIOJA   \n",
       "5                 OTRAS           NaN                   MUEL   \n",
       "6             ATROPELLO           NaN  PIGNATELLI, RAMON VIA   \n",
       "7   CAIDA SOBRE CALZADA           NaN   ALIERTA, AV. CESAREO   \n",
       "8   COLIS. MARCHA ATRÁS           NaN         CERBUNA, PEDRO   \n",
       "9      COLISIÓN LATERAL           NaN                 ASALTO   \n",
       "10                OTRAS           NaN     ARAGON (CORONA DE)   \n",
       "11     COLISIÓN ALCANCE           NaN             FRAGUA, LA   \n",
       "12       SALIDA CALZADA           NaN   PIRINEOS, AV. DE LOS   \n",
       "13     COLISIÓN ALCANCE           NaN  TORRES, CAMINO DE LAS   \n",
       "14            ATROPELLO           NaN                  RIOJA   \n",
       "15     COLISIÓN ALCANCE           NaN                 ITALIA   \n",
       "16     COLISIÓN ALCANCE           NaN   AGUSTIN, PASEO MARIA   \n",
       "17     COLISIÓN ALCANCE           NaN   AGUSTIN, PASEO MARIA   \n",
       "18     COLISIÓN ALCANCE           NaN   CASPE, AV.COMPROMISO   \n",
       "19     COLISIÓN ALCANCE           NaN    MURANO, ISLA DE AV.   \n",
       "20     COLISIÓN LATERAL           NaN   HISPANIDAD, RONDA DE   \n",
       "21  CAIDA SOBRE CALZADA           NaN      ZARAGOZA LA VIEJA   \n",
       "22     COLISIÓN ALCANCE           NaN  ASIN Y PALACIOS, MIG.   \n",
       "23  COLIS. MARCHA ATRÁS           NaN   ZAMBRANO, M. (POETA)   \n",
       "24       SALIDA CALZADA           NaN  ALBA (DUQUE DE),PASEO   \n",
       "25  COLIS FRONTOLATERAL           NaN        HISPANIDAD, VIA   \n",
       "26     COLISIÓN LATERAL           NaN    PARAISO, PL.BASILIO   \n",
       "27     COLISIÓN LATERAL           NaN   HISPANIDAD, RONDA DE   \n",
       "28     COLISIÓN LATERAL           NaN      SAGASTA, PASEO DE   \n",
       "29     COLISIÓN LATERAL           NaN    CABALDOS, CAMINO DE   \n",
       "30  CAIDA SOBRE CALZADA           NaN  GOYA,FCO.(PINTOR) AV.   \n",
       "31     COLISIÓN LATERAL           NaN   AGUSTIN, PASEO MARIA   \n",
       "32                OTRAS           NaN                  RIOJA   \n",
       "33     COLISIÓN LATERAL           NaN    CONSTITUCION, PASEO   \n",
       "34  COLIS. MARCHA ATRÁS           NaN                  TORRE   \n",
       "35     COLISIÓN ALCANCE           NaN  ECHEGARAY Y CABALLERO   \n",
       "36  COLIS FRONTOLATERAL           NaN    CABALDOS, CAMINO DE   \n",
       "37            ATROPELLO           NaN    ALMOZARA, AV. DE LA   \n",
       "38  COLIS. MARCHA ATRÁS           NaN      OLIVAN, ALEJANDRO   \n",
       "39  COLIS. MARCHA ATRÁS           NaN          ARRUPE, PADRE   \n",
       "40  COLIS FRONTOLATERAL           NaN    RUIZ PICASSO, PABLO   \n",
       "41            ATROPELLO           NaN       CAMPOAMOR, CLARA   \n",
       "42       SALIDA CALZADA           NaN  CASCAJO, CN. DEL  SJN   \n",
       "43       SALIDA CALZADA           NaN        EDISON, TOMAS A   \n",
       "44     COLISIÓN ALCANCE           NaN      CUELLAR, PASEO DE   \n",
       "45     COLISIÓN LATERAL           NaN        HISPANIDAD, VIA   \n",
       "46     COLISIÓN ALCANCE           NaN          PLAN, IBON DE   \n",
       "47       SALIDA CALZADA           NaN                  FANLO   \n",
       "48       SALIDA CALZADA           NaN  AZNAR,ADOLFO(CINEASTA   \n",
       "49       SALIDA CALZADA           NaN  ALLENDE, SALVADOR AV.   \n",
       "\n",
       "            secondAddress                                geometry  \\\n",
       "0            PERAL, ISAAC  -0.8818527060979306,41.649027473051156   \n",
       "1                     NaN  -0.8645810716721081,41.661585829868585   \n",
       "2      CASTRO, R. (POETA)   -0.887776415002892,41.666992622958105   \n",
       "3       GARCIA CONDOY, H.   -0.8825260453930127,41.62957498750602   \n",
       "4     NAVARRA, AVENIDA DE     -0.908314757720389,41.6562121210704   \n",
       "5                     NaN   -0.8691088511672924,41.65949772773082   \n",
       "6                     NaN  -0.8880337913721866,41.633353667694024   \n",
       "7              AULA, LUIS    -0.8708838775078237,41.6390382112928   \n",
       "8                     NaN   -0.8970649943808023,41.64083344974765   \n",
       "9            COCCI, JORGE   -0.8718525605769747,41.64904657717317   \n",
       "10   SAN ANTONIO M CLARET   -0.8964627561577849,41.64322365075108   \n",
       "11        GASSIER, PIERRE   -0.8778095796207178,41.68753087470739   \n",
       "12                    NaN  -0.8812157329722801,41.661646612715046   \n",
       "13                    NaN    -0.8762000299022707,41.6454384961757   \n",
       "14    NAVARRA, AVENIDA DE   -0.9089013552408617,41.65543768899759   \n",
       "15                    NaN   -0.9004729973337304,41.65180346604993   \n",
       "16     MAYANDIA (GENERAL)   -0.8917562993466011,41.65233828238132   \n",
       "17              SANTA ANA    -0.888856043735591,41.65040494617356   \n",
       "18                    NaN  -0.8629911318784169,41.645335650478316   \n",
       "19                    NaN  -0.8870207060655807,41.609992514227066   \n",
       "20   ALIERTA, AV. CESAREO   -0.8636325074780108,41.63379905763323   \n",
       "21                    NaN   -0.8760724207544668,41.63275556609146   \n",
       "22                    NaN   -0.9036852209830768,41.63808926467497   \n",
       "23                    NaN  -0.8896980442453839,41.677487884305975   \n",
       "24                    NaN  -0.9018264648858587,41.620591734015946   \n",
       "25     MADRID, AVENIDA DE   -0.9187726932212442,41.64931371437485   \n",
       "26                    NaN  -0.8855988456901538,41.646890443474554   \n",
       "27                    NaN    -0.887523212911549,41.62404668544956   \n",
       "28                    NaN   -0.8863120908790753,41.63964884250951   \n",
       "29                    NaN  -0.8689640327130923,41.638477534601776   \n",
       "30   TORRES MORALES, M.G.   -0.8900650666830714,41.64332496247496   \n",
       "31                    NaN   -0.8918524618079099,41.65260977469196   \n",
       "32                    NaN   -0.9104038365599549,41.65248328671194   \n",
       "33    PARAISO, PL.BASILIO    -0.8850103896969528,41.6474034449745   \n",
       "34                    NaN   -0.8734135018983006,41.64926981833846   \n",
       "35  MATUTE HERVIAS,JULIAN  -0.8593239531218387,41.650740541708075   \n",
       "36       CASTELAR, EMILIO   -0.868891092151338,41.638807389014836   \n",
       "37  PUERTA DE SANCHO, AV.   -0.9008107424460443,41.66374540604866   \n",
       "38  BOSQUED, JOSE (MOSEN)   -0.9211220937948997,41.64886535549928   \n",
       "39       VAZQUEZ DE MELLA   -0.9026681648170423,41.63265453864093   \n",
       "40   ZAMBRANO, M. (POETA)   -0.8893162332922886,41.67281318904247   \n",
       "41                    NaN   -0.8890866503471749,41.66895757951277   \n",
       "42                    NaN   -0.8439506345833918,41.71496486522088   \n",
       "43                    NaN   -0.8665477541801948,41.67007665525934   \n",
       "44                    NaN   -0.8848493117953854,41.63484525009101   \n",
       "45  GOMEZ LAGUNA(ALCALDE)   -0.9147014503640727,41.64060309287472   \n",
       "46  AEROPUERTO, CARRETERA   -0.9388159722509236,41.66210291413718   \n",
       "47                    NaN   -0.9157439755527074,41.63348367532985   \n",
       "48  BELTRAN,J.M.(CINEASTA   -0.8869959298557372,41.67593597602368   \n",
       "49                    NaN   -0.876909940066992,41.672106692157605   \n",
       "\n",
       "                                               reason    area  \\\n",
       "0           PERDIDA del control por FALTA de ATENCIÓN     NaN   \n",
       "1                 DISTANCIA DE SEGURIDAD, no mantener  2560.0   \n",
       "2           PERDIDA del control por FALTA de ATENCIÓN  2598.0   \n",
       "3         CEDA EL PASO, no respetar prioridad de paso  2555.0   \n",
       "4        PERDIDA del control por VELOCIDAD INADECUADA  2554.0   \n",
       "5             Caída de ocupante en Transporte Público  2578.0   \n",
       "6         PEATÓN cruza calz SIN PREFER. fuera de paso  2606.0   \n",
       "7   INVADIR otro carril en el mismo sentido de cir...  2583.0   \n",
       "8           PERDIDA del control por FALTA de ATENCIÓN  2556.0   \n",
       "9   INVADIR otro carril en el mismo sentido de cir...  4657.0   \n",
       "10            Caída de ocupante en Transporte Público    63.0   \n",
       "11          PERDIDA del control por FALTA de ATENCIÓN  4780.0   \n",
       "12          PERDIDA del control por FALTA de ATENCIÓN  4661.0   \n",
       "13          PERDIDA del control por FALTA de ATENCIÓN  4667.0   \n",
       "14  PEATÓN cruza calz SIN PREFER. en PASO CON semá...  4664.0   \n",
       "15          PERDIDA del control por FALTA de ATENCIÓN  4671.0   \n",
       "16                DISTANCIA DE SEGURIDAD, no mantener    18.0   \n",
       "17          PERDIDA del control por FALTA de ATENCIÓN  4718.0   \n",
       "18          PERDIDA del control por FALTA de ATENCIÓN  4723.0   \n",
       "19          PERDIDA del control por FALTA de ATENCIÓN     NaN   \n",
       "20                     PUERTA abierta incorrectamente    17.0   \n",
       "21          PERDIDA del control por FALTA de ATENCIÓN  4677.0   \n",
       "22          PERDIDA del control por FALTA de ATENCIÓN     NaN   \n",
       "23                                       MARCHA ATRÁS  4783.0   \n",
       "24       PERDIDA del control por VELOCIDAD INADECUADA  4679.0   \n",
       "25            SEMÁFORO, no respetar prioridad de paso  4773.0   \n",
       "26  INVADIR otro carril en el mismo sentido de cir...  4702.0   \n",
       "27                     PUERTA abierta incorrectamente  4701.0   \n",
       "28  INVADIR otro carril en el mismo sentido de cir...  4700.0   \n",
       "29  INVADIR otro carril en el mismo sentido de cir...  4752.0   \n",
       "30                DISTANCIA DE SEGURIDAD, no mantener  4751.0   \n",
       "31  INVADIR otro carril en el mismo sentido de cir...  4750.0   \n",
       "32                                       OTRAS CAUSAS     NaN   \n",
       "33  INVADIR otro carril en el mismo sentido de cir...  2682.0   \n",
       "34                                       MARCHA ATRÁS  2626.0   \n",
       "35          PERDIDA del control por FALTA de ATENCIÓN  2605.0   \n",
       "36  INVADIR otro carril en el mismo sentido de cir...  2591.0   \n",
       "37  PEATÓN cruza calz CON PREFER. en PASO  CON sem...  2610.0   \n",
       "38                                       MARCHA ATRÁS  2594.0   \n",
       "39                                       MARCHA ATRÁS  2596.0   \n",
       "40                                       OTRAS CAUSAS  2640.0   \n",
       "41  PEATÓN cruza calz CON PREFER. en PASO  SIN sem...  2600.0   \n",
       "42          PERDIDA del control por FALTA de ATENCIÓN     NaN   \n",
       "43          PERDIDA del control por FALTA de ATENCIÓN     NaN   \n",
       "44          PERDIDA del control por FALTA de ATENCIÓN  2604.0   \n",
       "45  INVADIR otro carril en el mismo sentido de cir...  2624.0   \n",
       "46                DISTANCIA DE SEGURIDAD, no mantener  2611.0   \n",
       "47          PERDIDA del control por FALTA de ATENCIÓN  2631.0   \n",
       "48          PERDIDA del control por FALTA de ATENCIÓN  4438.0   \n",
       "49          PERDIDA del control por FALTA de ATENCIÓN  4684.0   \n",
       "\n",
       "            creationDate  daniosMateriales  falloMecanico estadoPavimento  \\\n",
       "0   2014-10-09T00:00:00Z              True          False     BUEN ESTADO   \n",
       "1   2014-10-23T00:00:00Z             False          False     BUEN ESTADO   \n",
       "2   2014-10-23T00:00:00Z             False          False     BUEN ESTADO   \n",
       "3   2014-10-23T00:00:00Z             False          False     BUEN ESTADO   \n",
       "4   2014-10-24T00:00:00Z             False          False     BUEN ESTADO   \n",
       "5   2014-10-24T00:00:00Z             False          False     BUEN ESTADO   \n",
       "6   2014-10-24T00:00:00Z             False          False     BUEN ESTADO   \n",
       "7   2014-10-24T00:00:00Z             False          False     BUEN ESTADO   \n",
       "8   2014-10-24T00:00:00Z              True          False     BUEN ESTADO   \n",
       "9   2013-12-20T00:00:00Z             False          False     BUEN ESTADO   \n",
       "10  2013-12-21T00:00:00Z             False          False     BUEN ESTADO   \n",
       "11  2013-12-22T00:00:00Z              True          False     BUEN ESTADO   \n",
       "12  2013-12-22T00:00:00Z             False          False     BUEN ESTADO   \n",
       "13  2013-12-22T00:00:00Z             False          False     BUEN ESTADO   \n",
       "14  2013-12-22T00:00:00Z             False          False     BUEN ESTADO   \n",
       "15  2013-12-22T00:00:00Z              True          False     BUEN ESTADO   \n",
       "16  2013-12-20T00:00:00Z             False          False     BUEN ESTADO   \n",
       "17  2013-12-23T00:00:00Z             False          False     BUEN ESTADO   \n",
       "18  2013-12-23T00:00:00Z             False          False     BUEN ESTADO   \n",
       "19  2013-12-23T00:00:00Z              True          False     BUEN ESTADO   \n",
       "20  2013-12-23T00:00:00Z             False          False     BUEN ESTADO   \n",
       "21  2013-12-21T00:00:00Z             False          False     BUEN ESTADO   \n",
       "22  2013-12-17T00:00:00Z              True          False     BUEN ESTADO   \n",
       "23  2013-12-23T00:00:00Z              True          False     BUEN ESTADO   \n",
       "24  2013-12-15T00:00:00Z              True          False     BUEN ESTADO   \n",
       "25  2013-12-20T00:00:00Z              True          False     BUEN ESTADO   \n",
       "26  2013-12-17T00:00:00Z              True          False     BUEN ESTADO   \n",
       "27  2013-12-20T00:00:00Z              True          False     BUEN ESTADO   \n",
       "28  2013-12-19T00:00:00Z              True          False     BUEN ESTADO   \n",
       "29  2013-12-24T00:00:00Z             False          False     BUEN ESTADO   \n",
       "30  2013-12-24T00:00:00Z             False          False     BUEN ESTADO   \n",
       "31  2013-12-25T00:00:00Z             False          False     BUEN ESTADO   \n",
       "32  2013-12-19T00:00:00Z              True          False     BUEN ESTADO   \n",
       "33  2014-10-24T00:00:00Z              True          False     BUEN ESTADO   \n",
       "34  2014-10-27T00:00:00Z              True          False     BUEN ESTADO   \n",
       "35  2014-10-27T00:00:00Z              True          False     BUEN ESTADO   \n",
       "36  2014-10-25T00:00:00Z              True          False     BUEN ESTADO   \n",
       "37  2014-10-29T00:00:00Z             False          False     BUEN ESTADO   \n",
       "38  2014-10-24T00:00:00Z              True          False     BUEN ESTADO   \n",
       "39  2014-10-20T00:00:00Z              True          False     BUEN ESTADO   \n",
       "40  2014-10-29T00:00:00Z             False          False     BUEN ESTADO   \n",
       "41  2014-10-29T00:00:00Z             False          False     BUEN ESTADO   \n",
       "42  2014-10-29T00:00:00Z             False          False     BUEN ESTADO   \n",
       "43  2014-10-29T00:00:00Z              True          False     BUEN ESTADO   \n",
       "44  2014-10-28T00:00:00Z              True          False     BUEN ESTADO   \n",
       "45  2014-10-29T00:00:00Z              True          False     BUEN ESTADO   \n",
       "46  2014-10-27T00:00:00Z              True          False     BUEN ESTADO   \n",
       "47  2014-10-27T00:00:00Z              True          False     BUEN ESTADO   \n",
       "48  2013-12-02T00:00:00Z              True          False     BUEN ESTADO   \n",
       "49  2013-12-05T00:00:00Z              True          False     BUEN ESTADO   \n",
       "\n",
       "    tipoEstadoPavimento estadoAtmosfera  tipoEstadoAtmosfera  \\\n",
       "0                   NaN     BUEN ESTADO                  NaN   \n",
       "1                   NaN     BUEN ESTADO                  NaN   \n",
       "2                   NaN     BUEN ESTADO                  NaN   \n",
       "3                   NaN     BUEN ESTADO                  NaN   \n",
       "4                   NaN     BUEN ESTADO                  NaN   \n",
       "5                   NaN     BUEN ESTADO                  NaN   \n",
       "6                   NaN     BUEN ESTADO                  NaN   \n",
       "7                   NaN     BUEN ESTADO                  NaN   \n",
       "8                   NaN     BUEN ESTADO                  NaN   \n",
       "9                   NaN     BUEN ESTADO                  NaN   \n",
       "10                  NaN     BUEN ESTADO                  NaN   \n",
       "11                  NaN     BUEN ESTADO                  NaN   \n",
       "12                  NaN     BUEN ESTADO                  NaN   \n",
       "13                  NaN     BUEN ESTADO                  NaN   \n",
       "14                  NaN     BUEN ESTADO                  NaN   \n",
       "15                  NaN     BUEN ESTADO                  NaN   \n",
       "16                  NaN     BUEN ESTADO                  NaN   \n",
       "17                  NaN     BUEN ESTADO                  NaN   \n",
       "18                  NaN     BUEN ESTADO                  NaN   \n",
       "19                  NaN     BUEN ESTADO                  NaN   \n",
       "20                  NaN     BUEN ESTADO                  NaN   \n",
       "21                  NaN     BUEN ESTADO                  NaN   \n",
       "22                  NaN     BUEN ESTADO                  NaN   \n",
       "23                  NaN     BUEN ESTADO                  NaN   \n",
       "24                  NaN     BUEN ESTADO                  NaN   \n",
       "25                  NaN     BUEN ESTADO                  NaN   \n",
       "26                  NaN     BUEN ESTADO                  NaN   \n",
       "27                  NaN     BUEN ESTADO                  NaN   \n",
       "28                  NaN     BUEN ESTADO                  NaN   \n",
       "29                  NaN     BUEN ESTADO                  NaN   \n",
       "30                  NaN     BUEN ESTADO                  NaN   \n",
       "31                  NaN     BUEN ESTADO                  NaN   \n",
       "32                  NaN     BUEN ESTADO                  NaN   \n",
       "33                  NaN     BUEN ESTADO                  NaN   \n",
       "34                  NaN     BUEN ESTADO                  NaN   \n",
       "35                  NaN     BUEN ESTADO                  NaN   \n",
       "36                  NaN     BUEN ESTADO                  NaN   \n",
       "37                  NaN     BUEN ESTADO                  NaN   \n",
       "38                  NaN     BUEN ESTADO                  NaN   \n",
       "39                  NaN     BUEN ESTADO                  NaN   \n",
       "40                  NaN     BUEN ESTADO                  NaN   \n",
       "41                  NaN     BUEN ESTADO                  NaN   \n",
       "42                  NaN     BUEN ESTADO                  NaN   \n",
       "43                  NaN     BUEN ESTADO                  NaN   \n",
       "44                  NaN     BUEN ESTADO                  NaN   \n",
       "45                  NaN     BUEN ESTADO                  NaN   \n",
       "46                  NaN     BUEN ESTADO                  NaN   \n",
       "47                  NaN     BUEN ESTADO                  NaN   \n",
       "48                  NaN     BUEN ESTADO                  NaN   \n",
       "49                  NaN     BUEN ESTADO                  NaN   \n",
       "\n",
       "                                             afectado  \\\n",
       "0                                                 NaN   \n",
       "1   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "2   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "3   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "4   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "5   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "6   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "7   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "8                                                 NaN   \n",
       "9   https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "10  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "11                                                NaN   \n",
       "12  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "13  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "14  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "15                                                NaN   \n",
       "16  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "17  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "18  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "19                                                NaN   \n",
       "20  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "21  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "22                                                NaN   \n",
       "23                                                NaN   \n",
       "24                                                NaN   \n",
       "25                                                NaN   \n",
       "26                                                NaN   \n",
       "27                                                NaN   \n",
       "28                                                NaN   \n",
       "29  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "30  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "31  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "32                                                NaN   \n",
       "33                                                NaN   \n",
       "34                                                NaN   \n",
       "35                                                NaN   \n",
       "36                                                NaN   \n",
       "37  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "38                                                NaN   \n",
       "39                                                NaN   \n",
       "40  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "41  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "42  https://www.zaragoza.es/sede/servicio/transpor...   \n",
       "43                                                NaN   \n",
       "44                                                NaN   \n",
       "45                                                NaN   \n",
       "46                                                NaN   \n",
       "47                                                NaN   \n",
       "48                                                NaN   \n",
       "49                                                NaN   \n",
       "\n",
       "                                             vehiculo  \n",
       "0   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "1   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "2   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "3   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "4   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "5   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "6   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "7   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "8   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "9   https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "10  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "11  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "12  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "13  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "14  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "15  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "16  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "17  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "18  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "19  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "20  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "21  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "22  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "23  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "24  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "25  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "26  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "27  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "28  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "29  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "30  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "31  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "32  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "33  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "34  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "35  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "36  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "37  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "38  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "39  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "40  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "41  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "42  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "43  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "44  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "45  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "46  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "47  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "48  https://www.zaragoza.es/sede/servicio/transpor...  \n",
       "49  https://www.zaragoza.es/sede/servicio/transpor...  >"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz.info"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Esto es un resumen de los datos de la tabla. `.info` nos informa sobre el conjunto de datos que estamos tratando. Estos son sobre la naturaleza de una serie de accidentes de tráfico: año, motivo, dirección... A continuación queremos conocer la razón de cada accidente de tráfico, para lo que ponemos `['reason]` detrás de *df_zrgz*. No lleva `.` porque no se trata de una función sobre los datos sino una forma de visualización diferente en la que nosotros pedimos el dato que queremos que nos muestre. La sisntaxis es `df['categoría']`, en este caso el motivo del accidente."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0             PERDIDA del control por FALTA de ATENCIÓN\n",
       "1                   DISTANCIA DE SEGURIDAD, no mantener\n",
       "2             PERDIDA del control por FALTA de ATENCIÓN\n",
       "3           CEDA EL PASO, no respetar prioridad de paso\n",
       "4          PERDIDA del control por VELOCIDAD INADECUADA\n",
       "5               Caída de ocupante en Transporte Público\n",
       "6           PEATÓN cruza calz SIN PREFER. fuera de paso\n",
       "7     INVADIR otro carril en el mismo sentido de cir...\n",
       "8             PERDIDA del control por FALTA de ATENCIÓN\n",
       "9     INVADIR otro carril en el mismo sentido de cir...\n",
       "10              Caída de ocupante en Transporte Público\n",
       "11            PERDIDA del control por FALTA de ATENCIÓN\n",
       "12            PERDIDA del control por FALTA de ATENCIÓN\n",
       "13            PERDIDA del control por FALTA de ATENCIÓN\n",
       "14    PEATÓN cruza calz SIN PREFER. en PASO CON semá...\n",
       "15            PERDIDA del control por FALTA de ATENCIÓN\n",
       "16                  DISTANCIA DE SEGURIDAD, no mantener\n",
       "17            PERDIDA del control por FALTA de ATENCIÓN\n",
       "18            PERDIDA del control por FALTA de ATENCIÓN\n",
       "19            PERDIDA del control por FALTA de ATENCIÓN\n",
       "20                       PUERTA abierta incorrectamente\n",
       "21            PERDIDA del control por FALTA de ATENCIÓN\n",
       "22            PERDIDA del control por FALTA de ATENCIÓN\n",
       "23                                         MARCHA ATRÁS\n",
       "24         PERDIDA del control por VELOCIDAD INADECUADA\n",
       "25              SEMÁFORO, no respetar prioridad de paso\n",
       "26    INVADIR otro carril en el mismo sentido de cir...\n",
       "27                       PUERTA abierta incorrectamente\n",
       "28    INVADIR otro carril en el mismo sentido de cir...\n",
       "29    INVADIR otro carril en el mismo sentido de cir...\n",
       "30                  DISTANCIA DE SEGURIDAD, no mantener\n",
       "31    INVADIR otro carril en el mismo sentido de cir...\n",
       "32                                         OTRAS CAUSAS\n",
       "33    INVADIR otro carril en el mismo sentido de cir...\n",
       "34                                         MARCHA ATRÁS\n",
       "35            PERDIDA del control por FALTA de ATENCIÓN\n",
       "36    INVADIR otro carril en el mismo sentido de cir...\n",
       "37    PEATÓN cruza calz CON PREFER. en PASO  CON sem...\n",
       "38                                         MARCHA ATRÁS\n",
       "39                                         MARCHA ATRÁS\n",
       "40                                         OTRAS CAUSAS\n",
       "41    PEATÓN cruza calz CON PREFER. en PASO  SIN sem...\n",
       "42            PERDIDA del control por FALTA de ATENCIÓN\n",
       "43            PERDIDA del control por FALTA de ATENCIÓN\n",
       "44            PERDIDA del control por FALTA de ATENCIÓN\n",
       "45    INVADIR otro carril en el mismo sentido de cir...\n",
       "46                  DISTANCIA DE SEGURIDAD, no mantener\n",
       "47            PERDIDA del control por FALTA de ATENCIÓN\n",
       "48            PERDIDA del control por FALTA de ATENCIÓN\n",
       "49            PERDIDA del control por FALTA de ATENCIÓN\n",
       "Name: reason, dtype: object"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz['reason']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Si queremos ver el conjunto de los datos (en este caso razones de los dintintos accidentes) sin una distinción por filas o el número de cada uno de los accidentes recogidos en la base de datos utilizamos la función `unique()`."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['PERDIDA del control por FALTA de ATENCIÓN',\n",
       "       'DISTANCIA DE SEGURIDAD, no mantener',\n",
       "       'CEDA EL PASO, no respetar prioridad de paso',\n",
       "       'PERDIDA del control por VELOCIDAD INADECUADA',\n",
       "       'Caída de ocupante en Transporte Público',\n",
       "       'PEATÓN cruza calz SIN PREFER. fuera de paso',\n",
       "       'INVADIR otro carril en el mismo sentido de circulación',\n",
       "       'PEATÓN cruza calz SIN PREFER. en PASO CON semáforo',\n",
       "       'PUERTA abierta incorrectamente', 'MARCHA ATRÁS',\n",
       "       'SEMÁFORO, no respetar prioridad de paso', 'OTRAS CAUSAS',\n",
       "       'PEATÓN cruza calz CON PREFER. en PASO  CON semáforo',\n",
       "       'PEATÓN cruza calz CON PREFER. en PASO  SIN semáforo'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz['reason'].unique()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "La función `.unique()` sirve para delimitar los valores únicos en columnas. Es decir, las razones (categoría *reason* que elegimos visualizar antes) de los motivos del accidente que no se repiten en este conjunto de datos. Con la sintaxis descrita anteriormente cambiamos la categoría que queremos que nos muestre para acercarnos más a los datos e ir extrayendo toda su información."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['SALIDA CALZADA', 'COLISIÓN ALCANCE', 'COLIS FRONTOLATERAL',\n",
       "       'OTRAS', 'ATROPELLO', 'CAIDA SOBRE CALZADA', 'COLIS. MARCHA ATRÁS',\n",
       "       'COLISIÓN LATERAL'], dtype=object)"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz['type'].unique()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Tras explorar los datos los representamos en el mapa."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Representación en el mapa"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Pedimos que nos enseñe los datos de las coordenadas geográficas a representar en el mapa que son los que se encuentran en la categoría *geometry*."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     -0.8818527060979306,41.649027473051156\n",
       "1     -0.8645810716721081,41.661585829868585\n",
       "2      -0.887776415002892,41.666992622958105\n",
       "3      -0.8825260453930127,41.62957498750602\n",
       "4        -0.908314757720389,41.6562121210704\n",
       "5      -0.8691088511672924,41.65949772773082\n",
       "6     -0.8880337913721866,41.633353667694024\n",
       "7       -0.8708838775078237,41.6390382112928\n",
       "8      -0.8970649943808023,41.64083344974765\n",
       "9      -0.8718525605769747,41.64904657717317\n",
       "10     -0.8964627561577849,41.64322365075108\n",
       "11     -0.8778095796207178,41.68753087470739\n",
       "12    -0.8812157329722801,41.661646612715046\n",
       "13      -0.8762000299022707,41.6454384961757\n",
       "14     -0.9089013552408617,41.65543768899759\n",
       "15     -0.9004729973337304,41.65180346604993\n",
       "16     -0.8917562993466011,41.65233828238132\n",
       "17      -0.888856043735591,41.65040494617356\n",
       "18    -0.8629911318784169,41.645335650478316\n",
       "19    -0.8870207060655807,41.609992514227066\n",
       "20     -0.8636325074780108,41.63379905763323\n",
       "21     -0.8760724207544668,41.63275556609146\n",
       "22     -0.9036852209830768,41.63808926467497\n",
       "23    -0.8896980442453839,41.677487884305975\n",
       "24    -0.9018264648858587,41.620591734015946\n",
       "25     -0.9187726932212442,41.64931371437485\n",
       "26    -0.8855988456901538,41.646890443474554\n",
       "27      -0.887523212911549,41.62404668544956\n",
       "28     -0.8863120908790753,41.63964884250951\n",
       "29    -0.8689640327130923,41.638477534601776\n",
       "30     -0.8900650666830714,41.64332496247496\n",
       "31     -0.8918524618079099,41.65260977469196\n",
       "32     -0.9104038365599549,41.65248328671194\n",
       "33      -0.8850103896969528,41.6474034449745\n",
       "34     -0.8734135018983006,41.64926981833846\n",
       "35    -0.8593239531218387,41.650740541708075\n",
       "36     -0.868891092151338,41.638807389014836\n",
       "37     -0.9008107424460443,41.66374540604866\n",
       "38     -0.9211220937948997,41.64886535549928\n",
       "39     -0.9026681648170423,41.63265453864093\n",
       "40     -0.8893162332922886,41.67281318904247\n",
       "41     -0.8890866503471749,41.66895757951277\n",
       "42     -0.8439506345833918,41.71496486522088\n",
       "43     -0.8665477541801948,41.67007665525934\n",
       "44     -0.8848493117953854,41.63484525009101\n",
       "45     -0.9147014503640727,41.64060309287472\n",
       "46     -0.9388159722509236,41.66210291413718\n",
       "47     -0.9157439755527074,41.63348367532985\n",
       "48     -0.8869959298557372,41.67593597602368\n",
       "49     -0.876909940066992,41.672106692157605\n",
       "Name: geometry, dtype: object"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz['geometry']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Le pedimos que nos enseñe el nombre de dichas coordenadas para tenerlas a mano para poder escribir su nombre en el mapa. La categoría es *firstAddress*. Añado la función `.unique()` para acortar su extensión. Esto no podía realizarlo en la función anterior porque trabajaba con números y era necesaria la distinción por líneas de cada una de las coordenadas para poder diferenciarlas. Pero ahora puedo prescindir de ello ya que trabajo con texto. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['COSTA, JOAQUIN', 'CADENA(MARQUES DE LA)', 'GOMEZ AVELLANEDA, G.',\n",
       "       'MONZON', 'RIOJA', 'MUEL', 'PIGNATELLI, RAMON VIA',\n",
       "       'ALIERTA, AV. CESAREO', 'CERBUNA, PEDRO', 'ASALTO',\n",
       "       'ARAGON (CORONA DE)', 'FRAGUA, LA', 'PIRINEOS, AV. DE LOS',\n",
       "       'TORRES, CAMINO DE LAS', 'ITALIA', 'AGUSTIN, PASEO MARIA',\n",
       "       'CASPE, AV.COMPROMISO', 'MURANO, ISLA DE AV.',\n",
       "       'HISPANIDAD, RONDA DE', 'ZARAGOZA LA VIEJA',\n",
       "       'ASIN Y PALACIOS, MIG.', 'ZAMBRANO, M. (POETA)',\n",
       "       'ALBA (DUQUE DE),PASEO', 'HISPANIDAD, VIA', 'PARAISO, PL.BASILIO',\n",
       "       'SAGASTA, PASEO DE', 'CABALDOS, CAMINO DE',\n",
       "       'GOYA,FCO.(PINTOR) AV.', 'CONSTITUCION, PASEO', 'TORRE',\n",
       "       'ECHEGARAY Y CABALLERO', 'ALMOZARA, AV. DE LA',\n",
       "       'OLIVAN, ALEJANDRO', 'ARRUPE, PADRE', 'RUIZ PICASSO, PABLO',\n",
       "       'CAMPOAMOR, CLARA', 'CASCAJO, CN. DEL  SJN', 'EDISON, TOMAS A',\n",
       "       'CUELLAR, PASEO DE', 'PLAN, IBON DE', 'FANLO',\n",
       "       'AZNAR,ADOLFO(CINEASTA', 'ALLENDE, SALVADOR AV.'], dtype=object)"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz['firstAddress'].unique()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Creamos un mapa (m) a partir del anterior al que añadimos marcardores con las coordenadas y nombres de las calles correspondientes utilizando la función `folium.Marquer`."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "La sintaxis de la función `folium.map`es la siguiente: \n",
    "- (`location=`*coordenadas de referencia*`,`\n",
    "- `zoom_start=`*número pertinente al caso*`,`\n",
    "- `tiles=`*estilo de mapa que queramos*). \n",
    "\n",
    "En este caso he borrado la opción 'tiles' opción ya que tras probar distintos estilos como 'Stamen Terrain' o 'Stamen Toner' he preferido el que viene definido en Folium y por tanto no necesita ser especificado.  \n",
    "\n",
    "La sintaxis de `folium.Marker`, que forma parte de nuestro nuevo mapa \"m\", es la siguiente:\n",
    "- `([*coordenadas],`\n",
    "- `popup=`*nombre de la calle*`,`\n",
    "- `tooltip=`*lo que quiera que se vea al posicionar el cursor en el marcador*`)` Puedo definir esta variable con antelación para dejarla preestablecida si quiero poner en todas las localizaciones la misma etiqueta; 'accidente' en este caso. La sintaxis entonces es para todos los marcadores `tooltip=tooltip)`\n",
    "- `.add_to(m)` para añadir los cambios al nuevo mapa resultante. \n",
    "\n",
    "Lo he llevado a cabo con las dos primeras coordenadas como ejemplo pero el proceso es el mismo para todas. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "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;head&gt;    \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.6.0/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://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.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.6.0/dist/leaflet.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap-theme.min.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://maxcdn.bootstrapcdn.com/font-awesome/4.6.3/css/font-awesome.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_f3b54300ec57ac58075b6780fbc340d3 {\n",
       "                    position: relative;\n",
       "                    width: 100.0%;\n",
       "                    height: 100.0%;\n",
       "                    left: 0.0%;\n",
       "                    top: 0.0%;\n",
       "                }\n",
       "            &lt;/style&gt;\n",
       "        \n",
       "&lt;/head&gt;\n",
       "&lt;body&gt;    \n",
       "    \n",
       "            &lt;div class=&quot;folium-map&quot; id=&quot;map_f3b54300ec57ac58075b6780fbc340d3&quot; &gt;&lt;/div&gt;\n",
       "        \n",
       "&lt;/body&gt;\n",
       "&lt;script&gt;    \n",
       "    \n",
       "            var map_f3b54300ec57ac58075b6780fbc340d3 = L.map(\n",
       "                &quot;map_f3b54300ec57ac58075b6780fbc340d3&quot;,\n",
       "                {\n",
       "                    center: [41.646693, -0.887712],\n",
       "                    crs: L.CRS.EPSG3857,\n",
       "                    zoom: 13,\n",
       "                    zoomControl: true,\n",
       "                    preferCanvas: false,\n",
       "                }\n",
       "            );\n",
       "\n",
       "            \n",
       "\n",
       "        \n",
       "    \n",
       "            var tile_layer_ce444db553ec56391f02c4c99224916b = L.tileLayer(\n",
       "                &quot;https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png&quot;,\n",
       "                {&quot;attribution&quot;: &quot;Data by \\u0026copy; \\u003ca href=\\&quot;http://openstreetmap.org\\&quot;\\u003eOpenStreetMap\\u003c/a\\u003e, under \\u003ca 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_f3b54300ec57ac58075b6780fbc340d3);\n",
       "        \n",
       "    \n",
       "            var marker_b895d69ed23970100aaf397ae3cc8e41 = L.marker(\n",
       "                [-0.8818527060979306, 41.649027473051156],\n",
       "                {}\n",
       "            ).addTo(map_f3b54300ec57ac58075b6780fbc340d3);\n",
       "        \n",
       "    \n",
       "        var popup_d4f99a1d40297c5dcf500c65e88f6f9c = L.popup({&quot;maxWidth&quot;: &quot;100%&quot;});\n",
       "\n",
       "        \n",
       "            var html_2e1c429d071967516427ed5c3501d3d4 = $(`&lt;div id=&quot;html_2e1c429d071967516427ed5c3501d3d4&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;Calle Joaquín Costa&lt;/div&gt;`)[0];\n",
       "            popup_d4f99a1d40297c5dcf500c65e88f6f9c.setContent(html_2e1c429d071967516427ed5c3501d3d4);\n",
       "        \n",
       "\n",
       "        marker_b895d69ed23970100aaf397ae3cc8e41.bindPopup(popup_d4f99a1d40297c5dcf500c65e88f6f9c)\n",
       "        ;\n",
       "\n",
       "        \n",
       "    \n",
       "    \n",
       "            marker_b895d69ed23970100aaf397ae3cc8e41.bindTooltip(\n",
       "                `&lt;div&gt;\n",
       "                     Accidente\n",
       "                 &lt;/div&gt;`,\n",
       "                {&quot;sticky&quot;: true}\n",
       "            );\n",
       "        \n",
       "    \n",
       "            var marker_7f8d4b3fafb25a0650d7d602ebcea836 = L.marker(\n",
       "                [-0.8645810716721081, 41.661585829868585],\n",
       "                {}\n",
       "            ).addTo(map_f3b54300ec57ac58075b6780fbc340d3);\n",
       "        \n",
       "    \n",
       "        var popup_8410986b3c5786599dbadda589eac505 = L.popup({&quot;maxWidth&quot;: &quot;100%&quot;});\n",
       "\n",
       "        \n",
       "            var html_dc74d5c5937f07f61321a0385ba9d88f = $(`&lt;div id=&quot;html_dc74d5c5937f07f61321a0385ba9d88f&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;Calle Marqués de la Cadena&lt;/div&gt;`)[0];\n",
       "            popup_8410986b3c5786599dbadda589eac505.setContent(html_dc74d5c5937f07f61321a0385ba9d88f);\n",
       "        \n",
       "\n",
       "        marker_7f8d4b3fafb25a0650d7d602ebcea836.bindPopup(popup_8410986b3c5786599dbadda589eac505)\n",
       "        ;\n",
       "\n",
       "        \n",
       "    \n",
       "    \n",
       "            marker_7f8d4b3fafb25a0650d7d602ebcea836.bindTooltip(\n",
       "                `&lt;div&gt;\n",
       "                     Accidente\n",
       "                 &lt;/div&gt;`,\n",
       "                {&quot;sticky&quot;: true}\n",
       "            );\n",
       "        \n",
       "&lt;/script&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 0x7ff8a7bfa4c0>"
      ]
     },
     "execution_count": 95,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "m=folium.Map(location=geo_zrgz,zoom_start=13)\n",
    "tooltip='Accidente'\n",
    "folium.Marker([-0.8818527060979306,41.649027473051156], popup='Calle Joaquín Costa', tooltip=tooltip).add_to(m)\n",
    "folium.Marker([-0.8645810716721081,41.661585829868585], popup='Calle Marqués de la Cadena', tooltip=tooltip).add_to(m)\n",
    "m"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Vemos así los puntos de los accidentes marcados en el mapa. "
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}