Skip to content

Instantly share code, notes, and snippets.

@jaircastruita
Created May 4, 2016 04:38
Show Gist options
  • Save jaircastruita/44624e43546a6996b6f8958bd615ea43 to your computer and use it in GitHub Desktop.
Save jaircastruita/44624e43546a6996b6f8958bd615ea43 to your computer and use it in GitHub Desktop.
This file has been truncated, but you can view the full file.
{
"metadata": {
"name": "",
"signature": "sha256:3f377aaa4530cb2b7f98231fc80000d4ce68686f1805ceaa487a9269a324a17d"
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "code",
"collapsed": false,
"input": [
"from geopandas import GeoDataFrame\n",
"import matplotlib.pyplot as plt\n",
"import pandas as pd\n",
"import numpy as np\n",
"%matplotlib inline"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 1
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"path = r'D:\\ownCloud\\Documentos posgrado\\Posgrado 2do semestre\\INEGI shapefiles\\agebsymas\\scince\\shps\\df'\n",
"boros = GeoDataFrame.from_file(path+'\\\\df_servicios_a.shp')\n",
"agebs = GeoDataFrame.from_file(path+'\\\\df_ageb_urb.shp')"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 2
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"geo_boros = boros.to_json()\n",
"geo_agebs = agebs.to_json()"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 10
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"import folium"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 5
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"CDMX_COORDINATES = (19.4186, -99.1686) \n",
"\n",
"#create empty map zoomed in on Mexico City\n",
"station_coords = pd.read_csv('C:\\Users\\ghost\\Google Drive\\JairCastruitaGastelum\\Progress Reports\\Clustering_ECOBICI\\DATA\\estacion_coordenadas.csv')\n",
"map = folium.Map(location=CDMX_COORDINATES, tiles='Stamen Toner', zoom_start=14)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 7
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"folium.GeoJson(geo_boros,\n",
" name='geojson'\n",
" ).add_to(map)"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 12,
"text": [
"<folium.features.GeoJson at 0x116c3b70>"
]
}
],
"prompt_number": 12
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"station_coords"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>id</th>\n",
" <th>longitud</th>\n",
" <th>latitud</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1</td>\n",
" <td>-99.168480</td>\n",
" <td>19.432930</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2</td>\n",
" <td>-99.171510</td>\n",
" <td>19.431590</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>3</td>\n",
" <td>-99.158750</td>\n",
" <td>19.431660</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>4</td>\n",
" <td>-99.171690</td>\n",
" <td>19.428490</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>5</td>\n",
" <td>-99.169450</td>\n",
" <td>19.429800</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>6</td>\n",
" <td>-99.166990</td>\n",
" <td>19.430960</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>7</td>\n",
" <td>-99.175150</td>\n",
" <td>19.425360</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>8</td>\n",
" <td>-99.158150</td>\n",
" <td>19.431260</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>9</td>\n",
" <td>-99.170010</td>\n",
" <td>19.428180</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>10</td>\n",
" <td>-99.155140</td>\n",
" <td>19.433430</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>11</td>\n",
" <td>-99.163550</td>\n",
" <td>19.431190</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>12</td>\n",
" <td>-99.161690</td>\n",
" <td>19.432220</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>13</td>\n",
" <td>-99.175220</td>\n",
" <td>19.423620</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>14</td>\n",
" <td>-99.173250</td>\n",
" <td>19.424540</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>15</td>\n",
" <td>-99.171410</td>\n",
" <td>19.425600</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>16</td>\n",
" <td>-99.169230</td>\n",
" <td>19.426460</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>17</td>\n",
" <td>-99.167400</td>\n",
" <td>19.427550</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>18</td>\n",
" <td>-99.165250</td>\n",
" <td>19.428320</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>19</td>\n",
" <td>-99.161600</td>\n",
" <td>19.430070</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>20</td>\n",
" <td>-99.160150</td>\n",
" <td>19.430910</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>21</td>\n",
" <td>-99.175030</td>\n",
" <td>19.423360</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>22</td>\n",
" <td>-99.172210</td>\n",
" <td>19.424680</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>23</td>\n",
" <td>-99.170490</td>\n",
" <td>19.425450</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>24</td>\n",
" <td>-99.169060</td>\n",
" <td>19.426100</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>25</td>\n",
" <td>-99.166840</td>\n",
" <td>19.427190</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>26</td>\n",
" <td>-99.155000</td>\n",
" <td>19.432600</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>27</td>\n",
" <td>-99.162700</td>\n",
" <td>19.429160</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>28</td>\n",
" <td>-99.172570</td>\n",
" <td>19.423660</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>29</td>\n",
" <td>-99.150300</td>\n",
" <td>19.434940</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>30</td>\n",
" <td>-99.164260</td>\n",
" <td>19.426380</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>243</th>\n",
" <td>246</td>\n",
" <td>-99.179835</td>\n",
" <td>19.434147</td>\n",
" </tr>\n",
" <tr>\n",
" <th>244</th>\n",
" <td>247</td>\n",
" <td>-99.180565</td>\n",
" <td>19.432102</td>\n",
" </tr>\n",
" <tr>\n",
" <th>245</th>\n",
" <td>248</td>\n",
" <td>-99.177399</td>\n",
" <td>19.431750</td>\n",
" </tr>\n",
" <tr>\n",
" <th>246</th>\n",
" <td>249</td>\n",
" <td>-99.177569</td>\n",
" <td>19.429877</td>\n",
" </tr>\n",
" <tr>\n",
" <th>247</th>\n",
" <td>250</td>\n",
" <td>-99.179660</td>\n",
" <td>19.429057</td>\n",
" </tr>\n",
" <tr>\n",
" <th>248</th>\n",
" <td>251</td>\n",
" <td>-99.175380</td>\n",
" <td>19.429261</td>\n",
" </tr>\n",
" <tr>\n",
" <th>249</th>\n",
" <td>252</td>\n",
" <td>-99.177020</td>\n",
" <td>19.427575</td>\n",
" </tr>\n",
" <tr>\n",
" <th>250</th>\n",
" <td>253</td>\n",
" <td>-99.177924</td>\n",
" <td>19.425835</td>\n",
" </tr>\n",
" <tr>\n",
" <th>251</th>\n",
" <td>254</td>\n",
" <td>-99.160074</td>\n",
" <td>19.439347</td>\n",
" </tr>\n",
" <tr>\n",
" <th>252</th>\n",
" <td>255</td>\n",
" <td>-99.165099</td>\n",
" <td>19.437880</td>\n",
" </tr>\n",
" <tr>\n",
" <th>253</th>\n",
" <td>256</td>\n",
" <td>-99.158313</td>\n",
" <td>19.437167</td>\n",
" </tr>\n",
" <tr>\n",
" <th>254</th>\n",
" <td>257</td>\n",
" <td>-99.166223</td>\n",
" <td>19.433803</td>\n",
" </tr>\n",
" <tr>\n",
" <th>255</th>\n",
" <td>258</td>\n",
" <td>-99.200000</td>\n",
" <td>19.400000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>256</th>\n",
" <td>259</td>\n",
" <td>-99.154680</td>\n",
" <td>19.437569</td>\n",
" </tr>\n",
" <tr>\n",
" <th>257</th>\n",
" <td>260</td>\n",
" <td>-99.148570</td>\n",
" <td>19.433013</td>\n",
" </tr>\n",
" <tr>\n",
" <th>258</th>\n",
" <td>261</td>\n",
" <td>-99.175196</td>\n",
" <td>19.423704</td>\n",
" </tr>\n",
" <tr>\n",
" <th>259</th>\n",
" <td>262</td>\n",
" <td>-99.133952</td>\n",
" <td>19.436931</td>\n",
" </tr>\n",
" <tr>\n",
" <th>260</th>\n",
" <td>263</td>\n",
" <td>-99.158425</td>\n",
" <td>19.436274</td>\n",
" </tr>\n",
" <tr>\n",
" <th>261</th>\n",
" <td>264</td>\n",
" <td>-99.152935</td>\n",
" <td>19.440985</td>\n",
" </tr>\n",
" <tr>\n",
" <th>262</th>\n",
" <td>265</td>\n",
" <td>-99.152265</td>\n",
" <td>19.440839</td>\n",
" </tr>\n",
" <tr>\n",
" <th>263</th>\n",
" <td>266</td>\n",
" <td>-99.152187</td>\n",
" <td>19.444031</td>\n",
" </tr>\n",
" <tr>\n",
" <th>264</th>\n",
" <td>267</td>\n",
" <td>-99.179143</td>\n",
" <td>19.416727</td>\n",
" </tr>\n",
" <tr>\n",
" <th>265</th>\n",
" <td>268</td>\n",
" <td>-99.153082</td>\n",
" <td>19.444272</td>\n",
" </tr>\n",
" <tr>\n",
" <th>266</th>\n",
" <td>269</td>\n",
" <td>-99.152187</td>\n",
" <td>19.444031</td>\n",
" </tr>\n",
" <tr>\n",
" <th>267</th>\n",
" <td>270</td>\n",
" <td>-99.152640</td>\n",
" <td>19.444199</td>\n",
" </tr>\n",
" <tr>\n",
" <th>268</th>\n",
" <td>271</td>\n",
" <td>-99.152894</td>\n",
" <td>19.444244</td>\n",
" </tr>\n",
" <tr>\n",
" <th>269</th>\n",
" <td>272</td>\n",
" <td>-99.152265</td>\n",
" <td>19.440839</td>\n",
" </tr>\n",
" <tr>\n",
" <th>270</th>\n",
" <td>273</td>\n",
" <td>-99.152935</td>\n",
" <td>19.440985</td>\n",
" </tr>\n",
" <tr>\n",
" <th>271</th>\n",
" <td>274</td>\n",
" <td>-99.158425</td>\n",
" <td>19.436274</td>\n",
" </tr>\n",
" <tr>\n",
" <th>272</th>\n",
" <td>275</td>\n",
" <td>-99.153865</td>\n",
" <td>19.436764</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>273 rows \u00d7 3 columns</p>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 17,
"text": [
" id longitud latitud\n",
"0 1 -99.168480 19.432930\n",
"1 2 -99.171510 19.431590\n",
"2 3 -99.158750 19.431660\n",
"3 4 -99.171690 19.428490\n",
"4 5 -99.169450 19.429800\n",
"5 6 -99.166990 19.430960\n",
"6 7 -99.175150 19.425360\n",
"7 8 -99.158150 19.431260\n",
"8 9 -99.170010 19.428180\n",
"9 10 -99.155140 19.433430\n",
"10 11 -99.163550 19.431190\n",
"11 12 -99.161690 19.432220\n",
"12 13 -99.175220 19.423620\n",
"13 14 -99.173250 19.424540\n",
"14 15 -99.171410 19.425600\n",
"15 16 -99.169230 19.426460\n",
"16 17 -99.167400 19.427550\n",
"17 18 -99.165250 19.428320\n",
"18 19 -99.161600 19.430070\n",
"19 20 -99.160150 19.430910\n",
"20 21 -99.175030 19.423360\n",
"21 22 -99.172210 19.424680\n",
"22 23 -99.170490 19.425450\n",
"23 24 -99.169060 19.426100\n",
"24 25 -99.166840 19.427190\n",
"25 26 -99.155000 19.432600\n",
"26 27 -99.162700 19.429160\n",
"27 28 -99.172570 19.423660\n",
"28 29 -99.150300 19.434940\n",
"29 30 -99.164260 19.426380\n",
".. ... ... ...\n",
"243 246 -99.179835 19.434147\n",
"244 247 -99.180565 19.432102\n",
"245 248 -99.177399 19.431750\n",
"246 249 -99.177569 19.429877\n",
"247 250 -99.179660 19.429057\n",
"248 251 -99.175380 19.429261\n",
"249 252 -99.177020 19.427575\n",
"250 253 -99.177924 19.425835\n",
"251 254 -99.160074 19.439347\n",
"252 255 -99.165099 19.437880\n",
"253 256 -99.158313 19.437167\n",
"254 257 -99.166223 19.433803\n",
"255 258 -99.200000 19.400000\n",
"256 259 -99.154680 19.437569\n",
"257 260 -99.148570 19.433013\n",
"258 261 -99.175196 19.423704\n",
"259 262 -99.133952 19.436931\n",
"260 263 -99.158425 19.436274\n",
"261 264 -99.152935 19.440985\n",
"262 265 -99.152265 19.440839\n",
"263 266 -99.152187 19.444031\n",
"264 267 -99.179143 19.416727\n",
"265 268 -99.153082 19.444272\n",
"266 269 -99.152187 19.444031\n",
"267 270 -99.152640 19.444199\n",
"268 271 -99.152894 19.444244\n",
"269 272 -99.152265 19.440839\n",
"270 273 -99.152935 19.440985\n",
"271 274 -99.158425 19.436274\n",
"272 275 -99.153865 19.436764\n",
"\n",
"[273 rows x 3 columns]"
]
}
],
"prompt_number": 17
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"map"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment