city_data_organisation.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "indoor-translator",
   "metadata": {},
   "outputs": [],
   "source": [
    "import geopandas as gpd\n",
    "import matplotlib.pyplot as plt\n",
    "import pandas as pd\n",
    "import folium\n",
    "import geojson"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "timely-learning",
   "metadata": {},
   "outputs": [],
   "source": [
    "upz_bogota = 'upz_bogota.geojson'\n",
    "municipios_cundinamarca = 'cundi_municipios.geojson'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "developmental-seventh",
   "metadata": {},
   "outputs": [],
   "source": [
    "bog = gpd.read_file(upz_bogota)\n",
    "cu = gpd.read_file(municipios_cundinamarca)\n",
    "\n",
    "#Aquí se carga la base de datos de SZ, RMU, RC\n",
    "equipos = pd.read_excel('prueba.xlsx', index_col=0)\n",
    "rc = gpd.GeoDataFrame(equipos, geometry = gpd.points_from_xy(equipos.y, equipos.x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "orange-palestine",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>shape_area</th>\n",
       "      <th>objectid</th>\n",
       "      <th>muncodigo</th>\n",
       "      <th>shape_len</th>\n",
       "      <th>munnombre</th>\n",
       "      <th>munarea</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.011670</td>\n",
       "      <td>89</td>\n",
       "      <td>25823</td>\n",
       "      <td>0.688952</td>\n",
       "      <td>Topaipí</td>\n",
       "      <td>143.151124</td>\n",
       "      <td>POLYGON ((-74.23397 5.39736, -74.23399 5.39681...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.009684</td>\n",
       "      <td>21</td>\n",
       "      <td>25599</td>\n",
       "      <td>0.694097</td>\n",
       "      <td>Apulo</td>\n",
       "      <td>118.935887</td>\n",
       "      <td>POLYGON ((-74.50244 4.48430, -74.50341 4.48403...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.008336</td>\n",
       "      <td>97</td>\n",
       "      <td>25779</td>\n",
       "      <td>0.514737</td>\n",
       "      <td>Susa</td>\n",
       "      <td>102.248027</td>\n",
       "      <td>POLYGON ((-73.74288 5.47057, -73.77074 5.47103...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.008379</td>\n",
       "      <td>31</td>\n",
       "      <td>25099</td>\n",
       "      <td>0.497898</td>\n",
       "      <td>Bojacá</td>\n",
       "      <td>102.881836</td>\n",
       "      <td>POLYGON ((-74.29833 4.71720, -74.29903 4.71710...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.016547</td>\n",
       "      <td>79</td>\n",
       "      <td>25793</td>\n",
       "      <td>0.926214</td>\n",
       "      <td>Tausa</td>\n",
       "      <td>203.029113</td>\n",
       "      <td>POLYGON ((-73.99509 5.25832, -73.99339 5.25566...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>0.010568</td>\n",
       "      <td>80</td>\n",
       "      <td>25398</td>\n",
       "      <td>0.549177</td>\n",
       "      <td>La Peña</td>\n",
       "      <td>129.669905</td>\n",
       "      <td>POLYGON ((-74.35431 5.25602, -74.35455 5.25595...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>0.005294</td>\n",
       "      <td>81</td>\n",
       "      <td>25781</td>\n",
       "      <td>0.368425</td>\n",
       "      <td>Sutatausa</td>\n",
       "      <td>64.949362</td>\n",
       "      <td>POLYGON ((-73.80509 5.25911, -73.80436 5.25810...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>0.005049</td>\n",
       "      <td>85</td>\n",
       "      <td>25871</td>\n",
       "      <td>0.440719</td>\n",
       "      <td>Villagómez</td>\n",
       "      <td>61.947737</td>\n",
       "      <td>POLYGON ((-74.21999 5.34164, -74.21975 5.34161...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>0.078175</td>\n",
       "      <td>101</td>\n",
       "      <td>25885</td>\n",
       "      <td>1.966545</td>\n",
       "      <td>Yacopí</td>\n",
       "      <td>958.580586</td>\n",
       "      <td>POLYGON ((-74.29688 5.76456, -74.29685 5.76452...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>0.011710</td>\n",
       "      <td>104</td>\n",
       "      <td>25053</td>\n",
       "      <td>0.756887</td>\n",
       "      <td>Arbeláez</td>\n",
       "      <td>143.875713</td>\n",
       "      <td>POLYGON ((-74.24368 4.19670, -74.24374 4.19659...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>116 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     shape_area  objectid muncodigo  shape_len   munnombre     munarea  \\\n",
       "0      0.011670        89     25823   0.688952     Topaipí  143.151124   \n",
       "1      0.009684        21     25599   0.694097       Apulo  118.935887   \n",
       "2      0.008336        97     25779   0.514737        Susa  102.248027   \n",
       "3      0.008379        31     25099   0.497898      Bojacá  102.881836   \n",
       "4      0.016547        79     25793   0.926214       Tausa  203.029113   \n",
       "..          ...       ...       ...        ...         ...         ...   \n",
       "111    0.010568        80     25398   0.549177     La Peña  129.669905   \n",
       "112    0.005294        81     25781   0.368425   Sutatausa   64.949362   \n",
       "113    0.005049        85     25871   0.440719  Villagómez   61.947737   \n",
       "114    0.078175       101     25885   1.966545      Yacopí  958.580586   \n",
       "115    0.011710       104     25053   0.756887    Arbeláez  143.875713   \n",
       "\n",
       "                                              geometry  \n",
       "0    POLYGON ((-74.23397 5.39736, -74.23399 5.39681...  \n",
       "1    POLYGON ((-74.50244 4.48430, -74.50341 4.48403...  \n",
       "2    POLYGON ((-73.74288 5.47057, -73.77074 5.47103...  \n",
       "3    POLYGON ((-74.29833 4.71720, -74.29903 4.71710...  \n",
       "4    POLYGON ((-73.99509 5.25832, -73.99339 5.25566...  \n",
       "..                                                 ...  \n",
       "111  POLYGON ((-74.35431 5.25602, -74.35455 5.25595...  \n",
       "112  POLYGON ((-73.80509 5.25911, -73.80436 5.25810...  \n",
       "113  POLYGON ((-74.21999 5.34164, -74.21975 5.34161...  \n",
       "114  POLYGON ((-74.29688 5.76456, -74.29685 5.76452...  \n",
       "115  POLYGON ((-74.24368 4.19670, -74.24374 4.19659...  \n",
       "\n",
       "[116 rows x 7 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cundi = 'cundi_municipios.geojson'\n",
    "cu = gpd.read_file(cundi)\n",
    "cu\n",
    "#axi = cu.plot(figsize=(5,5))\n",
    "#rc.plot(ax = axi, color = 'black')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "infinite-equation",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>shape_area</th>\n",
       "      <th>objectid</th>\n",
       "      <th>codigo</th>\n",
       "      <th>shape_len</th>\n",
       "      <th>nombre</th>\n",
       "      <th>area</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.011670</td>\n",
       "      <td>89</td>\n",
       "      <td>25823</td>\n",
       "      <td>0.688952</td>\n",
       "      <td>Topaipí</td>\n",
       "      <td>143.151124</td>\n",
       "      <td>POLYGON ((-74.23397 5.39736, -74.23399 5.39681...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.009684</td>\n",
       "      <td>21</td>\n",
       "      <td>25599</td>\n",
       "      <td>0.694097</td>\n",
       "      <td>Apulo</td>\n",
       "      <td>118.935887</td>\n",
       "      <td>POLYGON ((-74.50244 4.48430, -74.50341 4.48403...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.008336</td>\n",
       "      <td>97</td>\n",
       "      <td>25779</td>\n",
       "      <td>0.514737</td>\n",
       "      <td>Susa</td>\n",
       "      <td>102.248027</td>\n",
       "      <td>POLYGON ((-73.74288 5.47057, -73.77074 5.47103...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.008379</td>\n",
       "      <td>31</td>\n",
       "      <td>25099</td>\n",
       "      <td>0.497898</td>\n",
       "      <td>Bojacá</td>\n",
       "      <td>102.881836</td>\n",
       "      <td>POLYGON ((-74.29833 4.71720, -74.29903 4.71710...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.016547</td>\n",
       "      <td>79</td>\n",
       "      <td>25793</td>\n",
       "      <td>0.926214</td>\n",
       "      <td>Tausa</td>\n",
       "      <td>203.029113</td>\n",
       "      <td>POLYGON ((-73.99509 5.25832, -73.99339 5.25566...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>0.010568</td>\n",
       "      <td>80</td>\n",
       "      <td>25398</td>\n",
       "      <td>0.549177</td>\n",
       "      <td>La Peña</td>\n",
       "      <td>129.669905</td>\n",
       "      <td>POLYGON ((-74.35431 5.25602, -74.35455 5.25595...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>0.005294</td>\n",
       "      <td>81</td>\n",
       "      <td>25781</td>\n",
       "      <td>0.368425</td>\n",
       "      <td>Sutatausa</td>\n",
       "      <td>64.949362</td>\n",
       "      <td>POLYGON ((-73.80509 5.25911, -73.80436 5.25810...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>0.005049</td>\n",
       "      <td>85</td>\n",
       "      <td>25871</td>\n",
       "      <td>0.440719</td>\n",
       "      <td>Villagómez</td>\n",
       "      <td>61.947737</td>\n",
       "      <td>POLYGON ((-74.21999 5.34164, -74.21975 5.34161...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>0.078175</td>\n",
       "      <td>101</td>\n",
       "      <td>25885</td>\n",
       "      <td>1.966545</td>\n",
       "      <td>Yacopí</td>\n",
       "      <td>958.580586</td>\n",
       "      <td>POLYGON ((-74.29688 5.76456, -74.29685 5.76452...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>0.011710</td>\n",
       "      <td>104</td>\n",
       "      <td>25053</td>\n",
       "      <td>0.756887</td>\n",
       "      <td>Arbeláez</td>\n",
       "      <td>143.875713</td>\n",
       "      <td>POLYGON ((-74.24368 4.19670, -74.24374 4.19659...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>116 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     shape_area  objectid codigo  shape_len      nombre        area  \\\n",
       "0      0.011670        89  25823   0.688952     Topaipí  143.151124   \n",
       "1      0.009684        21  25599   0.694097       Apulo  118.935887   \n",
       "2      0.008336        97  25779   0.514737        Susa  102.248027   \n",
       "3      0.008379        31  25099   0.497898      Bojacá  102.881836   \n",
       "4      0.016547        79  25793   0.926214       Tausa  203.029113   \n",
       "..          ...       ...    ...        ...         ...         ...   \n",
       "111    0.010568        80  25398   0.549177     La Peña  129.669905   \n",
       "112    0.005294        81  25781   0.368425   Sutatausa   64.949362   \n",
       "113    0.005049        85  25871   0.440719  Villagómez   61.947737   \n",
       "114    0.078175       101  25885   1.966545      Yacopí  958.580586   \n",
       "115    0.011710       104  25053   0.756887    Arbeláez  143.875713   \n",
       "\n",
       "                                              geometry  \n",
       "0    POLYGON ((-74.23397 5.39736, -74.23399 5.39681...  \n",
       "1    POLYGON ((-74.50244 4.48430, -74.50341 4.48403...  \n",
       "2    POLYGON ((-73.74288 5.47057, -73.77074 5.47103...  \n",
       "3    POLYGON ((-74.29833 4.71720, -74.29903 4.71710...  \n",
       "4    POLYGON ((-73.99509 5.25832, -73.99339 5.25566...  \n",
       "..                                                 ...  \n",
       "111  POLYGON ((-74.35431 5.25602, -74.35455 5.25595...  \n",
       "112  POLYGON ((-73.80509 5.25911, -73.80436 5.25810...  \n",
       "113  POLYGON ((-74.21999 5.34164, -74.21975 5.34161...  \n",
       "114  POLYGON ((-74.29688 5.76456, -74.29685 5.76452...  \n",
       "115  POLYGON ((-74.24368 4.19670, -74.24374 4.19659...  \n",
       "\n",
       "[116 rows x 7 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Procesar la base de datos cundi_municipios\n",
    "cu = cu.rename(columns={\"munnombre\":\"nombre\",\"munarea\":\"area\", \"muncodigo\":\"codigo\" })\n",
    "cu"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "czech-highway",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>uplnombre</th>\n",
       "      <th>uplaadmini</th>\n",
       "      <th>objectid</th>\n",
       "      <th>uplarea</th>\n",
       "      <th>shape_len</th>\n",
       "      <th>shape_area</th>\n",
       "      <th>upltipo</th>\n",
       "      <th>uplcodigo</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Parque Simón Bolívar - CAN</td>\n",
       "      <td>Dcto. 301-12/07/2011 Modifica el 254-26/08/2004</td>\n",
       "      <td>37</td>\n",
       "      <td>3.986843e+06</td>\n",
       "      <td>0.110476</td>\n",
       "      <td>0.000325</td>\n",
       "      <td>1</td>\n",
       "      <td>UPZ104</td>\n",
       "      <td>POLYGON ((-74.08581 4.65535, -74.08721 4.65480...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Danubio</td>\n",
       "      <td>Dcto. 409-23/12/2004</td>\n",
       "      <td>51</td>\n",
       "      <td>2.887409e+06</td>\n",
       "      <td>0.087399</td>\n",
       "      <td>0.000235</td>\n",
       "      <td>1</td>\n",
       "      <td>UPZ56</td>\n",
       "      <td>POLYGON ((-74.12013 4.54431, -74.11900 4.54281...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ciudad Usme</td>\n",
       "      <td>None</td>\n",
       "      <td>61</td>\n",
       "      <td>9.254733e+06</td>\n",
       "      <td>0.242374</td>\n",
       "      <td>0.000754</td>\n",
       "      <td>1</td>\n",
       "      <td>UPZ61</td>\n",
       "      <td>MULTIPOLYGON (((-74.09418 4.51033, -74.09419 4...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>20 de Julio</td>\n",
       "      <td>Dcto. 353-04/09/2006 (Gaceta 436/2006) Mod.=De...</td>\n",
       "      <td>95</td>\n",
       "      <td>2.625357e+06</td>\n",
       "      <td>0.061764</td>\n",
       "      <td>0.000214</td>\n",
       "      <td>1</td>\n",
       "      <td>UPZ34</td>\n",
       "      <td>POLYGON ((-74.08531 4.56958, -74.08559 4.56931...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Chico Lago</td>\n",
       "      <td>Dcto. 059-14/02/2007 modific¢ el 075-20/03/200...</td>\n",
       "      <td>82</td>\n",
       "      <td>4.224476e+06</td>\n",
       "      <td>0.104655</td>\n",
       "      <td>0.000344</td>\n",
       "      <td>1</td>\n",
       "      <td>UPZ97</td>\n",
       "      <td>POLYGON ((-74.04820 4.68490, -74.04690 4.68430...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>Ciudad Montes</td>\n",
       "      <td>Dcto. 413-04/11/2005 (Gac 391/2005)</td>\n",
       "      <td>94</td>\n",
       "      <td>4.455787e+06</td>\n",
       "      <td>0.079855</td>\n",
       "      <td>0.000363</td>\n",
       "      <td>1</td>\n",
       "      <td>UPZ40</td>\n",
       "      <td>POLYGON ((-74.09788 4.60655, -74.09899 4.60518...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>Las Cruces</td>\n",
       "      <td>Dcto. 492-26/10/2007</td>\n",
       "      <td>99</td>\n",
       "      <td>9.236831e+05</td>\n",
       "      <td>0.042618</td>\n",
       "      <td>0.000075</td>\n",
       "      <td>1</td>\n",
       "      <td>UPZ95</td>\n",
       "      <td>POLYGON ((-74.08114 4.59507, -74.08114 4.59506...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>Marruecos</td>\n",
       "      <td>Dcto. 406-23/12/2004 Mod.=Res 482/2007 (Gaceta...</td>\n",
       "      <td>107</td>\n",
       "      <td>3.628885e+06</td>\n",
       "      <td>0.079179</td>\n",
       "      <td>0.000295</td>\n",
       "      <td>1</td>\n",
       "      <td>UPZ54</td>\n",
       "      <td>POLYGON ((-74.10627 4.56390, -74.10621 4.56383...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>Ismael Perdomo</td>\n",
       "      <td>Dcto. 078-15/03/2006</td>\n",
       "      <td>111</td>\n",
       "      <td>5.598956e+06</td>\n",
       "      <td>0.094757</td>\n",
       "      <td>0.000456</td>\n",
       "      <td>1</td>\n",
       "      <td>UPZ69</td>\n",
       "      <td>POLYGON ((-74.17743 4.59692, -74.17684 4.59688...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>UPR Rio Sumapaz</td>\n",
       "      <td>Decreto 552 de diciembre de 2015</td>\n",
       "      <td>115</td>\n",
       "      <td>4.212839e+08</td>\n",
       "      <td>1.245788</td>\n",
       "      <td>0.034277</td>\n",
       "      <td>2</td>\n",
       "      <td>UPR5</td>\n",
       "      <td>POLYGON ((-74.24627 4.10244, -74.24631 4.10219...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>116 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                      uplnombre  \\\n",
       "0    Parque Simón Bolívar - CAN   \n",
       "1                       Danubio   \n",
       "2                   Ciudad Usme   \n",
       "3                   20 de Julio   \n",
       "4                    Chico Lago   \n",
       "..                          ...   \n",
       "111               Ciudad Montes   \n",
       "112                  Las Cruces   \n",
       "113                   Marruecos   \n",
       "114              Ismael Perdomo   \n",
       "115             UPR Rio Sumapaz   \n",
       "\n",
       "                                            uplaadmini  objectid  \\\n",
       "0      Dcto. 301-12/07/2011 Modifica el 254-26/08/2004        37   \n",
       "1                                 Dcto. 409-23/12/2004        51   \n",
       "2                                                 None        61   \n",
       "3    Dcto. 353-04/09/2006 (Gaceta 436/2006) Mod.=De...        95   \n",
       "4    Dcto. 059-14/02/2007 modific¢ el 075-20/03/200...        82   \n",
       "..                                                 ...       ...   \n",
       "111                Dcto. 413-04/11/2005 (Gac 391/2005)        94   \n",
       "112                               Dcto. 492-26/10/2007        99   \n",
       "113  Dcto. 406-23/12/2004 Mod.=Res 482/2007 (Gaceta...       107   \n",
       "114                               Dcto. 078-15/03/2006       111   \n",
       "115                   Decreto 552 de diciembre de 2015       115   \n",
       "\n",
       "          uplarea  shape_len  shape_area  upltipo uplcodigo  \\\n",
       "0    3.986843e+06   0.110476    0.000325        1    UPZ104   \n",
       "1    2.887409e+06   0.087399    0.000235        1     UPZ56   \n",
       "2    9.254733e+06   0.242374    0.000754        1     UPZ61   \n",
       "3    2.625357e+06   0.061764    0.000214        1     UPZ34   \n",
       "4    4.224476e+06   0.104655    0.000344        1     UPZ97   \n",
       "..            ...        ...         ...      ...       ...   \n",
       "111  4.455787e+06   0.079855    0.000363        1     UPZ40   \n",
       "112  9.236831e+05   0.042618    0.000075        1     UPZ95   \n",
       "113  3.628885e+06   0.079179    0.000295        1     UPZ54   \n",
       "114  5.598956e+06   0.094757    0.000456        1     UPZ69   \n",
       "115  4.212839e+08   1.245788    0.034277        2      UPR5   \n",
       "\n",
       "                                              geometry  \n",
       "0    POLYGON ((-74.08581 4.65535, -74.08721 4.65480...  \n",
       "1    POLYGON ((-74.12013 4.54431, -74.11900 4.54281...  \n",
       "2    MULTIPOLYGON (((-74.09418 4.51033, -74.09419 4...  \n",
       "3    POLYGON ((-74.08531 4.56958, -74.08559 4.56931...  \n",
       "4    POLYGON ((-74.04820 4.68490, -74.04690 4.68430...  \n",
       "..                                                 ...  \n",
       "111  POLYGON ((-74.09788 4.60655, -74.09899 4.60518...  \n",
       "112  POLYGON ((-74.08114 4.59507, -74.08114 4.59506...  \n",
       "113  POLYGON ((-74.10627 4.56390, -74.10621 4.56383...  \n",
       "114  POLYGON ((-74.17743 4.59692, -74.17684 4.59688...  \n",
       "115  POLYGON ((-74.24627 4.10244, -74.24631 4.10219...  \n",
       "\n",
       "[116 rows x 9 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "upz = 'upz_bogota.geojson'\n",
    "up = gpd.read_file(upz)\n",
    "up"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "reflected-colors",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>nombre</th>\n",
       "      <th>objectid</th>\n",
       "      <th>area</th>\n",
       "      <th>shape_len</th>\n",
       "      <th>shape_area</th>\n",
       "      <th>codigo</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Parque Simón Bolívar - CAN</td>\n",
       "      <td>37</td>\n",
       "      <td>3.99</td>\n",
       "      <td>0.110476</td>\n",
       "      <td>0.000325</td>\n",
       "      <td>UPZ104</td>\n",
       "      <td>POLYGON ((-74.08581 4.65535, -74.08721 4.65480...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Danubio</td>\n",
       "      <td>51</td>\n",
       "      <td>2.89</td>\n",
       "      <td>0.087399</td>\n",
       "      <td>0.000235</td>\n",
       "      <td>UPZ56</td>\n",
       "      <td>POLYGON ((-74.12013 4.54431, -74.11900 4.54281...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ciudad Usme</td>\n",
       "      <td>61</td>\n",
       "      <td>9.25</td>\n",
       "      <td>0.242374</td>\n",
       "      <td>0.000754</td>\n",
       "      <td>UPZ61</td>\n",
       "      <td>MULTIPOLYGON (((-74.09418 4.51033, -74.09419 4...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>20 de Julio</td>\n",
       "      <td>95</td>\n",
       "      <td>2.63</td>\n",
       "      <td>0.061764</td>\n",
       "      <td>0.000214</td>\n",
       "      <td>UPZ34</td>\n",
       "      <td>POLYGON ((-74.08531 4.56958, -74.08559 4.56931...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Chico Lago</td>\n",
       "      <td>82</td>\n",
       "      <td>4.22</td>\n",
       "      <td>0.104655</td>\n",
       "      <td>0.000344</td>\n",
       "      <td>UPZ97</td>\n",
       "      <td>POLYGON ((-74.04820 4.68490, -74.04690 4.68430...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>Ciudad Montes</td>\n",
       "      <td>94</td>\n",
       "      <td>4.46</td>\n",
       "      <td>0.079855</td>\n",
       "      <td>0.000363</td>\n",
       "      <td>UPZ40</td>\n",
       "      <td>POLYGON ((-74.09788 4.60655, -74.09899 4.60518...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>Las Cruces</td>\n",
       "      <td>99</td>\n",
       "      <td>0.92</td>\n",
       "      <td>0.042618</td>\n",
       "      <td>0.000075</td>\n",
       "      <td>UPZ95</td>\n",
       "      <td>POLYGON ((-74.08114 4.59507, -74.08114 4.59506...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>Marruecos</td>\n",
       "      <td>107</td>\n",
       "      <td>3.63</td>\n",
       "      <td>0.079179</td>\n",
       "      <td>0.000295</td>\n",
       "      <td>UPZ54</td>\n",
       "      <td>POLYGON ((-74.10627 4.56390, -74.10621 4.56383...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>Ismael Perdomo</td>\n",
       "      <td>111</td>\n",
       "      <td>5.60</td>\n",
       "      <td>0.094757</td>\n",
       "      <td>0.000456</td>\n",
       "      <td>UPZ69</td>\n",
       "      <td>POLYGON ((-74.17743 4.59692, -74.17684 4.59688...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>UPR Rio Sumapaz</td>\n",
       "      <td>115</td>\n",
       "      <td>421.28</td>\n",
       "      <td>1.245788</td>\n",
       "      <td>0.034277</td>\n",
       "      <td>UPR5</td>\n",
       "      <td>POLYGON ((-74.24627 4.10244, -74.24631 4.10219...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>116 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                         nombre  objectid    area  shape_len  shape_area  \\\n",
       "0    Parque Simón Bolívar - CAN        37    3.99   0.110476    0.000325   \n",
       "1                       Danubio        51    2.89   0.087399    0.000235   \n",
       "2                   Ciudad Usme        61    9.25   0.242374    0.000754   \n",
       "3                   20 de Julio        95    2.63   0.061764    0.000214   \n",
       "4                    Chico Lago        82    4.22   0.104655    0.000344   \n",
       "..                          ...       ...     ...        ...         ...   \n",
       "111               Ciudad Montes        94    4.46   0.079855    0.000363   \n",
       "112                  Las Cruces        99    0.92   0.042618    0.000075   \n",
       "113                   Marruecos       107    3.63   0.079179    0.000295   \n",
       "114              Ismael Perdomo       111    5.60   0.094757    0.000456   \n",
       "115             UPR Rio Sumapaz       115  421.28   1.245788    0.034277   \n",
       "\n",
       "     codigo                                           geometry  \n",
       "0    UPZ104  POLYGON ((-74.08581 4.65535, -74.08721 4.65480...  \n",
       "1     UPZ56  POLYGON ((-74.12013 4.54431, -74.11900 4.54281...  \n",
       "2     UPZ61  MULTIPOLYGON (((-74.09418 4.51033, -74.09419 4...  \n",
       "3     UPZ34  POLYGON ((-74.08531 4.56958, -74.08559 4.56931...  \n",
       "4     UPZ97  POLYGON ((-74.04820 4.68490, -74.04690 4.68430...  \n",
       "..      ...                                                ...  \n",
       "111   UPZ40  POLYGON ((-74.09788 4.60655, -74.09899 4.60518...  \n",
       "112   UPZ95  POLYGON ((-74.08114 4.59507, -74.08114 4.59506...  \n",
       "113   UPZ54  POLYGON ((-74.10627 4.56390, -74.10621 4.56383...  \n",
       "114   UPZ69  POLYGON ((-74.17743 4.59692, -74.17684 4.59688...  \n",
       "115    UPR5  POLYGON ((-74.24627 4.10244, -74.24631 4.10219...  \n",
       "\n",
       "[116 rows x 7 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "upz = 'upz_bogota.geojson'\n",
    "up = gpd.read_file(upz)\n",
    "up = up.rename(columns={\"uplarea\":\"area\", \"uplcodigo\":\"codigo\", \"uplnombre\":\"nombre\"})\n",
    "up['area'] = ( up['area'] / 1e6 ).round(2)\n",
    "del up['uplaadmini']\n",
    "del up['upltipo']\n",
    "up"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "changed-palace",
   "metadata": {},
   "outputs": [],
   "source": [
    "cundi = 'cundi_municipios.geojson'\n",
    "cu = gpd.read_file(cundi)\n",
    "cu = cu.rename(columns={\"munnombre\":\"nombre\",\"munarea\":\"area\", \"muncodigo\":\"codigo\" })\n",
    "\n",
    "upz = 'upz_bogota.geojson'\n",
    "up = gpd.read_file(upz)\n",
    "up = up.rename(columns={\"uplarea\":\"area\", \"uplcodigo\":\"codigo\", \"uplnombre\":\"nombre\"})\n",
    "up['area'] = ( up['area'] / 1e6 ).round(2)\n",
    "del up['uplaadmini']\n",
    "del up['upltipo']\n",
    "\n",
    "bog_cund = pd.concat([up, cu])\n",
    "bog_cund.index = bog_cund['codigo']\n",
    "\n",
    "equipos = pd.read_excel('prueba.xlsx', index_col=0)\n",
    "rc = gpd.GeoDataFrame(equipos, geometry = gpd.points_from_xy(equipos.y, equipos.x))\n",
    "\n",
    "with open('bocu.geojson', 'w', encoding='utf-8') as f:\n",
    "    geojson.dump(bog_cund, f)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "median-aberdeen",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Procesar la base maestra para extraer la información de ubicación necesaria\n",
    "df = pd.read_excel('Base_Maestra.xlsx')\n",
    "df = df[[\"TIPO\",\"EQUIPO\",\"DIRECCION\", \"COORDENADA X\", \"COORDENADA Y\", \"MARCA\", \"MODELO\"]]\n",
    "df = df.rename(columns={\"COORDENADA X\":\"COOR_X\", \"COORDENADA Y\":\"COOR_Y\"})\n",
    "gdf = gpd.GeoDataFrame(df, geometry = gpd.points_from_xy(df.COOR_X, df.COOR_Y))\n",
    "gdf\n",
    "\n",
    "with open('base_maestra.geojson', 'w', encoding='utf-8') as f:\n",
    "    geojson.dump(gdf, f, ensure_ascii=False)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "quality-leadership",
   "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_9639729ee3e343b1aaf4f3f83388f335%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_9639729ee3e343b1aaf4f3f83388f335%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_9639729ee3e343b1aaf4f3f83388f335%20%3D%20L.map%28%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22map_9639729ee3e343b1aaf4f3f83388f335%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%5B0%2C%200%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%201%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_00e2a66f0d8841d48bf1be4125e7efde%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_9639729ee3e343b1aaf4f3f83388f335%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 0x1313b930>"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Para graficar con la libreria folium\n",
    "bog_cund = gpd.read_file('bocu.geojson')\n",
    "map = folium.Map(location=[45, -74], zoom_start=8, tiles=\"Stamen Terrain\")\n",
    "\n",
    "equipos2 = pd.read_excel('prueba.xlsx')\n",
    "rc2 = gpd.GeoDataFrame(equipos2, geometry = gpd.points_from_xy(equipos2.y, equipos2.x))\n",
    "\n",
    "#codigo para permitir que sea leido por geojson\n",
    "rc2 = rc2.set_crs(\"EPSG:4326\")\n",
    "rc2 = rc2.set_crs(epsg=4326)\n",
    "\n",
    "bog_cund = gpd.read_file('bocu.geojson')\n",
    "map = folium.Map(location=[4.5, -74], tiles=\"Cartodb Positron\", zoom_start=6)\n",
    "\n",
    "def style_function(feature):\n",
    "    return {\n",
    "        \"fillOpacity\": 0.1,\n",
    "        \"weight\": 1,\n",
    "    }\n",
    "\n",
    "folium.GeoJson(bog_cund, style_function=style_function,\n",
    "               popup = folium.GeoJsonPopup(fields=[\"nombre\"])\n",
    "              ).add_to(map)\n",
    "\n",
    "\n",
    "folium.GeoJson(\n",
    "    rc2,\n",
    "    marker = folium.Circle(radius=4, fill_color=\"green\", fill_opacity=0.4, color=\"green\", weight=1),\n",
    "    popup = folium.GeoJsonPopup(fields=[\"Equipo\",\"x\", \"y\"])\n",
    "    ).add_to(map)\n",
    "map\n",
    "\n",
    "map.save('mapa.html')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "catholic-context",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.7.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}