api-pandas-folium.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Práctica 3 - Mapa"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Esta tercera práctica consiste en recoger los datos sacados de la página web zaragoza.es en la que se muestran los accidentes de tráfico que han ocurrido en la ciudad de Zaragoza.\n",
    "\n",
    "Los datos se encuentran  clasificados según categorías (año, tipo, afectado, estado, vehículo), pero, en la web, también podemos acceder a información acerca de la ubicación ha acontecido el accidente (la calle). \n",
    "\n",
    "Ello significa que los datos geográficos también nos son importantes para el análisis de los datos, de modo que hemos añadido también la localización geográfica de Zaragoza a través de unas coordenadas. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "url_zrgz = 'https://www.zaragoza.es/sede/servicio/transporte/accidentalidad-trafico/accidente.csv'\n",
    "geo_zrgz = [41.649693,-0.887712]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Para instalarlo utilizamos el motor de instalación recomendado de Phyton que sería pip y la !, que significa que no estamos ejecutando Phyton sino Bash."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Collecting folium\n",
      "  Downloading folium-0.12.1.post1-py2.py3-none-any.whl (95 kB)\n",
      "\u001b[K     |████████████████████████████████| 95 kB 854 kB/s eta 0:00:011\n",
      "\u001b[?25hCollecting branca>=0.3.0\n",
      "  Downloading branca-0.4.2-py3-none-any.whl (24 kB)\n",
      "Requirement already satisfied: jinja2>=2.9 in /usr/lib/python3/dist-packages (from folium) (2.10.1)\n",
      "Requirement already satisfied: numpy in /usr/local/lib/python3.8/dist-packages (from folium) (1.21.1)\n",
      "Requirement already satisfied: requests in /usr/local/lib/python3.8/dist-packages (from folium) (2.25.0)\n",
      "Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.8/dist-packages (from requests->folium) (2020.6.20)\n",
      "Requirement already satisfied: 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",
      "Requirement already satisfied: urllib3<1.27,>=1.21.1 in /usr/lib/python3/dist-packages (from requests->folium) (1.25.8)\n",
      "Installing collected packages: branca, folium\n",
      "Successfully installed branca-0.4.2 folium-0.12.1.post1\n"
     ]
    }
   ],
   "source": [
    "!pip install folium"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Usamos la convención de pandas como pd. Ahora, a diferencia de los demás trabajos, seguiremos trabajando con Pandas como API pero utilizaremos la librería folium, es por ello que previamente la hemos instalado. Folium facilita la visualización de datos manipulados en Phyton en un mapa interactivo generado en folios."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import folium"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Crear un mapa"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Dentro de la librería folium utilizamos la función map en la que añadiremos las coordenadas de Zaragoza."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "mapa_zrgz = folium.Map(location=geo_zrgz)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "¿Cómo visualizamos el mapa que acabamos de crear? Mediante el siguiente comando"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"width:100%;\"><div style=\"position:relative;width:100%;height:0;padding-bottom:60%;\"><span style=\"color:#565656\">Make this Notebook Trusted to load map: File -> Trust Notebook</span><iframe 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_664cad270e604e449df6726d50d7fa64%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_664cad270e604e449df6726d50d7fa64%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_664cad270e604e449df6726d50d7fa64%20%3D%20L.map%28%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22map_664cad270e604e449df6726d50d7fa64%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_5b4c7d493dfa429c9cb68489218eb801%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_664cad270e604e449df6726d50d7fa64%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 0x7f1cb4201cd0>"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mapa_zrgz"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Vamos a leer los datos de la url y para ello creamos un Data Frame. Se pone csv porque el url acaba de esta manera. Existía un paso previo en el que ocurría un error porque lo está leyendo como csv cuando en realidad no lo es. Por ello, utilizamos delimiter para evitarlo y es necesario indicar el ;"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_zrgz = pd.read_csv(url_zrgz,delimiter=';')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Ponemos df_zrgz para ver que funciona"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "scrolled": false
   },
   "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": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Para ver cuál es el nombre de las columnas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Para obtener un resumen de la tabla (¿qué tipo de datos tenemos dentro?)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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": [
    "Para ver un valor de la tabla"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz['reason']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Dentro de todos los casos, los motivos se repiten. Es por ello que utilizamos el comando unique, para ver los valores únicos de la columna."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz['reason'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz['type'].unique()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Pintar un punto"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "El próximo día vamos a pintar un punto en el mapa que ya tenemos creado. Para ello, llevamos a cabo el paso previo de Geometry que creará el punto. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     -0.8818527060979306,41.649027473051156\n",
       "1     -0.8645810716721081,41.661585829868585\n",
       "2      -0.887776415002892,41.666992622958105\n",
       "3      -0.8825260453930127,41.62957498750602\n",
       "4        -0.908314757720389,41.6562121210704\n",
       "5      -0.8691088511672924,41.65949772773082\n",
       "6     -0.8880337913721866,41.633353667694024\n",
       "7       -0.8708838775078237,41.6390382112928\n",
       "8      -0.8970649943808023,41.64083344974765\n",
       "9      -0.8718525605769747,41.64904657717317\n",
       "10     -0.8964627561577849,41.64322365075108\n",
       "11     -0.8778095796207178,41.68753087470739\n",
       "12    -0.8812157329722801,41.661646612715046\n",
       "13      -0.8762000299022707,41.6454384961757\n",
       "14     -0.9089013552408617,41.65543768899759\n",
       "15     -0.9004729973337304,41.65180346604993\n",
       "16     -0.8917562993466011,41.65233828238132\n",
       "17      -0.888856043735591,41.65040494617356\n",
       "18    -0.8629911318784169,41.645335650478316\n",
       "19    -0.8870207060655807,41.609992514227066\n",
       "20     -0.8636325074780108,41.63379905763323\n",
       "21     -0.8760724207544668,41.63275556609146\n",
       "22     -0.9036852209830768,41.63808926467497\n",
       "23    -0.8896980442453839,41.677487884305975\n",
       "24    -0.9018264648858587,41.620591734015946\n",
       "25     -0.9187726932212442,41.64931371437485\n",
       "26    -0.8855988456901538,41.646890443474554\n",
       "27      -0.887523212911549,41.62404668544956\n",
       "28     -0.8863120908790753,41.63964884250951\n",
       "29    -0.8689640327130923,41.638477534601776\n",
       "30     -0.8900650666830714,41.64332496247496\n",
       "31     -0.8918524618079099,41.65260977469196\n",
       "32     -0.9104038365599549,41.65248328671194\n",
       "33      -0.8850103896969528,41.6474034449745\n",
       "34     -0.8734135018983006,41.64926981833846\n",
       "35    -0.8593239531218387,41.650740541708075\n",
       "36     -0.868891092151338,41.638807389014836\n",
       "37     -0.9008107424460443,41.66374540604866\n",
       "38     -0.9211220937948997,41.64886535549928\n",
       "39     -0.9026681648170423,41.63265453864093\n",
       "40     -0.8893162332922886,41.67281318904247\n",
       "41     -0.8890866503471749,41.66895757951277\n",
       "42     -0.8439506345833918,41.71496486522088\n",
       "43     -0.8665477541801948,41.67007665525934\n",
       "44     -0.8848493117953854,41.63484525009101\n",
       "45     -0.9147014503640727,41.64060309287472\n",
       "46     -0.9388159722509236,41.66210291413718\n",
       "47     -0.9157439755527074,41.63348367532985\n",
       "48     -0.8869959298557372,41.67593597602368\n",
       "49     -0.876909940066992,41.672106692157605\n",
       "Name: geometry, dtype: object"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_zrgz['geometry']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Lo que faltaría sería llevar a cabo esta función y conseguir crear con éxito el mapa con el punto. \n"
   ]
  }
 ],
 "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
}