api-pandas-folium.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Uso de folium con pandas"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Establecer variable url"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "url_zrgz = 'https://www.zaragoza.es/sede/servicio/transporte/accidentalidad-trafico/accidente.csv'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Comentario explicativo\n",
    "Lo primero que vamos a hacer es establecer la variable `url_zrgz`con `=` del mismo modo que lo hicimos en el trabajo con la API de la Covid-19. A continuación incluimos (entre `''`, es texto literal) la url de donde sacamos los datos que usaremos después, un csv con la accidentalidad de tráfico de Zaragoza."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Establecer coordenadas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "geo_zrgz = [41.649693,-0.887712]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Comentario explicativo\n",
    "Para poder usar después folium y crear un mapa, necesitamos establecer sus coordenadas. Bajo el nombre `geo_zrgz`establecemos la equivalencia `=`a las coordenadas de Zaragoza, que escribimos entre `[]`."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Instalación de folium"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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: 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: jinja2>=2.9 in /usr/lib/python3/dist-packages (from folium) (2.10.1)\n",
      "Requirement already satisfied: branca>=0.3.0 in ./.local/lib/python3.8/site-packages (from folium) (0.4.2)\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: idna<3,>=2.5 in /usr/lib/python3/dist-packages (from requests->folium) (2.8)\n",
      "Requirement already satisfied: chardet<4,>=3.0.2 in /usr/lib/python3/dist-packages (from requests->folium) (3.0.4)\n"
     ]
    }
   ],
   "source": [
    "!pip install folium"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Comentario explicativo\n",
    "Instalamos folium usando el lenguaje de bash `!pip install`.Folium es lo que nos va a permitir visualizar información sobre un mapa en Python. "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Importar pandas y folium"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import folium"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Comentario explicativo\n",
    "Importamos `pandas as pd`y `folium`para poder utilizarlos, de manera análoga a como lo explicamos en el cuaderno del uso de la API de datos del covid."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Creación del mapa"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "mapa_zrgz = folium.Map(location=geo_zrgz)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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 src=\"about:blank\" style=\"position:absolute;width:100%;height:100%;left:0;top:0;border:none !important;\" data-html=%3C%21DOCTYPE%20html%3E%0A%3Chead%3E%20%20%20%20%0A%20%20%20%20%3Cmeta%20http-equiv%3D%22content-type%22%20content%3D%22text/html%3B%20charset%3DUTF-8%22%20/%3E%0A%20%20%20%20%0A%20%20%20%20%20%20%20%20%3Cscript%3E%0A%20%20%20%20%20%20%20%20%20%20%20%20L_NO_TOUCH%20%3D%20false%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20L_DISABLE_3D%20%3D%20false%3B%0A%20%20%20%20%20%20%20%20%3C/script%3E%0A%20%20%20%20%0A%20%20%20%20%3Cstyle%3Ehtml%2C%20body%20%7Bwidth%3A%20100%25%3Bheight%3A%20100%25%3Bmargin%3A%200%3Bpadding%3A%200%3B%7D%3C/style%3E%0A%20%20%20%20%3Cstyle%3E%23map%20%7Bposition%3Aabsolute%3Btop%3A0%3Bbottom%3A0%3Bright%3A0%3Bleft%3A0%3B%7D%3C/style%3E%0A%20%20%20%20%3Cscript%20src%3D%22https%3A//cdn.jsdelivr.net/npm/leaflet%401.6.0/dist/leaflet.js%22%3E%3C/script%3E%0A%20%20%20%20%3Cscript%20src%3D%22https%3A//code.jquery.com/jquery-1.12.4.min.js%22%3E%3C/script%3E%0A%20%20%20%20%3Cscript%20src%3D%22https%3A//maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js%22%3E%3C/script%3E%0A%20%20%20%20%3Cscript%20src%3D%22https%3A//cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.js%22%3E%3C/script%3E%0A%20%20%20%20%3Clink%20rel%3D%22stylesheet%22%20href%3D%22https%3A//cdn.jsdelivr.net/npm/leaflet%401.6.0/dist/leaflet.css%22/%3E%0A%20%20%20%20%3Clink%20rel%3D%22stylesheet%22%20href%3D%22https%3A//maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css%22/%3E%0A%20%20%20%20%3Clink%20rel%3D%22stylesheet%22%20href%3D%22https%3A//maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap-theme.min.css%22/%3E%0A%20%20%20%20%3Clink%20rel%3D%22stylesheet%22%20href%3D%22https%3A//maxcdn.bootstrapcdn.com/font-awesome/4.6.3/css/font-awesome.min.css%22/%3E%0A%20%20%20%20%3Clink%20rel%3D%22stylesheet%22%20href%3D%22https%3A//cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.css%22/%3E%0A%20%20%20%20%3Clink%20rel%3D%22stylesheet%22%20href%3D%22https%3A//cdn.jsdelivr.net/gh/python-visualization/folium/folium/templates/leaflet.awesome.rotate.min.css%22/%3E%0A%20%20%20%20%0A%20%20%20%20%20%20%20%20%20%20%20%20%3Cmeta%20name%3D%22viewport%22%20content%3D%22width%3Ddevice-width%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20initial-scale%3D1.0%2C%20maximum-scale%3D1.0%2C%20user-scalable%3Dno%22%20/%3E%0A%20%20%20%20%20%20%20%20%20%20%20%20%3Cstyle%3E%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23map_8eab3b1ffc514e9bbab89ca1ec6232ab%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20position%3A%20relative%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20width%3A%20100.0%25%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20height%3A%20100.0%25%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20left%3A%200.0%25%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20top%3A%200.0%25%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%20%20%20%20%20%20%3C/style%3E%0A%20%20%20%20%20%20%20%20%0A%3C/head%3E%0A%3Cbody%3E%20%20%20%20%0A%20%20%20%20%0A%20%20%20%20%20%20%20%20%20%20%20%20%3Cdiv%20class%3D%22folium-map%22%20id%3D%22map_8eab3b1ffc514e9bbab89ca1ec6232ab%22%20%3E%3C/div%3E%0A%20%20%20%20%20%20%20%20%0A%3C/body%3E%0A%3Cscript%3E%20%20%20%20%0A%20%20%20%20%0A%20%20%20%20%20%20%20%20%20%20%20%20var%20map_8eab3b1ffc514e9bbab89ca1ec6232ab%20%3D%20L.map%28%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22map_8eab3b1ffc514e9bbab89ca1ec6232ab%22%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20center%3A%20%5B41.649693%2C%20-0.887712%5D%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20crs%3A%20L.CRS.EPSG3857%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20zoom%3A%2010%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20zoomControl%3A%20true%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20preferCanvas%3A%20false%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%20%20%20%20%20%20%29%3B%0A%0A%20%20%20%20%20%20%20%20%20%20%20%20%0A%0A%20%20%20%20%20%20%20%20%0A%20%20%20%20%0A%20%20%20%20%20%20%20%20%20%20%20%20var%20tile_layer_79430d689e714fc5b738cecc90dd0486%20%3D%20L.tileLayer%28%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22https%3A//%7Bs%7D.tile.openstreetmap.org/%7Bz%7D/%7Bx%7D/%7By%7D.png%22%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%7B%22attribution%22%3A%20%22Data%20by%20%5Cu0026copy%3B%20%5Cu003ca%20href%3D%5C%22http%3A//openstreetmap.org%5C%22%5Cu003eOpenStreetMap%5Cu003c/a%5Cu003e%2C%20under%20%5Cu003ca%20href%3D%5C%22http%3A//www.openstreetmap.org/copyright%5C%22%5Cu003eODbL%5Cu003c/a%5Cu003e.%22%2C%20%22detectRetina%22%3A%20false%2C%20%22maxNativeZoom%22%3A%2018%2C%20%22maxZoom%22%3A%2018%2C%20%22minZoom%22%3A%200%2C%20%22noWrap%22%3A%20false%2C%20%22opacity%22%3A%201%2C%20%22subdomains%22%3A%20%22abc%22%2C%20%22tms%22%3A%20false%7D%0A%20%20%20%20%20%20%20%20%20%20%20%20%29.addTo%28map_8eab3b1ffc514e9bbab89ca1ec6232ab%29%3B%0A%20%20%20%20%20%20%20%20%0A%3C/script%3E onload=\"this.contentDocument.open();this.contentDocument.write(    decodeURIComponent(this.getAttribute('data-html')));this.contentDocument.close();\" allowfullscreen webkitallowfullscreen mozallowfullscreen></iframe></div></div>"
      ],
      "text/plain": [
       "<folium.folium.Map at 0x7f295d6933a0>"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mapa_zrgz"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Comentario explicativo\n",
    "Una vez hemos instalado folium y pandas y establecido las variables necesarias, es hora de crear nuestro mapa. De manera similar a como lo hacíamos con los gráficos, establecemos la variable con `=`. Delante de ello, ponemos cómo vamos a nombrarlo `mapa_zrgz` y después del `=`nombramos `folium.Map`(lo que nos permitirá visualizarlo, como ya adelantamos) y entre `()` que la `location=`a las coordenadas que habíamos establecido anteriormente, es decir `folium.Map(location=geo_zrgz)`.\n",
    "Así es como establecemos la variable. Para visualizarlo, solo escribimos la manera en que hemos decidido nombrarlo: `mapa_zrgz`. "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Crear los datos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_zrgz = pd.read_csv(url_zrgz,delimiter=';')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Comentario explicativo\n",
    "En el apartado anterior creamos un mapa de Zaragoza, pero lo verdaderamente interesante sería plasmar los datos de la accidentalidad de tráfico sobre él. Para ello, creamos un dataframe con la `url_zrgz`que establecimos al principio.\n",
    "Lo hacemos igual que lo hicimos para los datos del covid. `df_zrgz`será `=`a `pd.read_csv`, es decir, con pandas leemos en formato csv `(url_zrgz,delimiter=\";\")`, el argumento de la función: la url donde están los datos, especificando que el delimitador del csv son (`=`) \";\" (entre comillas porque es texto literal). "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Explorar los datos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['id', 'year', 'type', 'accidentType', 'firstAddress', 'secondAddress',\n",
       "       'geometry', 'reason', 'area', 'creationDate', 'daniosMateriales',\n",
       "       'falloMecanico', 'estadoPavimento', 'tipoEstadoPavimento',\n",
       "       'estadoAtmosfera', 'tipoEstadoAtmosfera', 'afectado', 'vehiculo'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 50 entries, 0 to 49\n",
      "Data columns (total 18 columns):\n",
      " #   Column               Non-Null Count  Dtype  \n",
      "---  ------               --------------  -----  \n",
      " 0   id                   50 non-null     object \n",
      " 1   year                 50 non-null     int64  \n",
      " 2   type                 50 non-null     object \n",
      " 3   accidentType         0 non-null      float64\n",
      " 4   firstAddress         50 non-null     object \n",
      " 5   secondAddress        24 non-null     object \n",
      " 6   geometry             50 non-null     object \n",
      " 7   reason               50 non-null     object \n",
      " 8   area                 44 non-null     float64\n",
      " 9   creationDate         50 non-null     object \n",
      " 10  daniosMateriales     50 non-null     bool   \n",
      " 11  falloMecanico        50 non-null     bool   \n",
      " 12  estadoPavimento      50 non-null     object \n",
      " 13  tipoEstadoPavimento  0 non-null      float64\n",
      " 14  estadoAtmosfera      50 non-null     object \n",
      " 15  tipoEstadoAtmosfera  0 non-null      float64\n",
      " 16  afectado             24 non-null     object \n",
      " 17  vehiculo             50 non-null     object \n",
      "dtypes: bool(2), float64(4), int64(1), object(11)\n",
      "memory usage: 6.5+ KB\n"
     ]
    }
   ],
   "source": [
    "df_zrgz.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Comentario explicativo\n",
    "Exploramos los datos con funciones como `columns`, para saber cuáles son las columnas de nuestro dataset, o `info()`, que explicita algunas de sus características (número de columnas y filas, los datatype, etc.). "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz['reason']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Comentario explicativo\n",
    "Escribiendo entre `[]`el nombre entrecomillado de una o varias de las columnas (aquí 'reason') solo se nos muestran esos valores."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz['reason'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz['type'].unique()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Comentario explicativo\n",
    "Sobre lo anterior, podemos usar la función `.unique()` para saber cuáles son los tipos de valores de cada caso, es decir, eliminamos las repeticiones e, interpretando los datos, entendemos que son las \"categorías\" que pueden darse, respectivamente, como valores en la columna \"reason\" y \"type\" que especificamos usando `[]`."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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
}