Created
October 17, 2021 09:36
-
-
Save jjclavijo/a58844143c6b94ee584438c9f79c7284 to your computer and use it in GitHub Desktop.
Csv y VRT
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "nbformat": 4, | |
| "nbformat_minor": 5, | |
| "metadata": { | |
| "jupytext": { | |
| "cell_metadata_filter": "-all", | |
| "main_language": "python", | |
| "notebook_metadata_filter": "-all" | |
| }, | |
| "colab": { | |
| "name": "Csv y VRT", | |
| "provenance": [], | |
| "include_colab_link": true | |
| }, | |
| "language_info": { | |
| "name": "python" | |
| }, | |
| "kernelspec": { | |
| "name": "python3", | |
| "display_name": "Python 3" | |
| } | |
| }, | |
| "cells": [ | |
| { | |
| "cell_type": "markdown", | |
| "metadata": { | |
| "id": "view-in-github", | |
| "colab_type": "text" | |
| }, | |
| "source": [ | |
| "<a href=\"https://colab.research.google.com/gist/jjclavijo/a58844143c6b94ee584438c9f79c7284/csv-y-vrt.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>" | |
| ] | |
| }, | |
| { | |
| "cell_type": "markdown", | |
| "metadata": { | |
| "id": "fe6159f5" | |
| }, | |
| "source": [ | |
| "# Ejemplo: Metadatos geográficos en CSV y conversión \"a mano\"\n", | |
| "\n", | |
| "En este ejemplo vemos cómo se puede dar metadatos geográficos a un archivo que \n", | |
| "no los tiene, si sabemos qué sistema de referencia utiliza." | |
| ], | |
| "id": "fe6159f5" | |
| }, | |
| { | |
| "cell_type": "code", | |
| "metadata": { | |
| "id": "3ab40ad6" | |
| }, | |
| "source": [ | |
| "data=\"\"\"\n", | |
| "efector,direccion,long,lat\n", | |
| "Oficina Nacional Scout,Libertad 1282,-58.384513289,-34.5932002169999\n", | |
| "Sede Oscoema,Bernardo de Irigoyen 330,-58.3804817989999,-34.6121475259999\n", | |
| "Club San Lorenzo (Sede Av. La Plata),Av. La Plata 1770,-58.424583539,-34.635385358\n", | |
| "Club Italiano,Yerbal 150,-58.43291479,-34.615378958\n", | |
| "Parque Roca,Av. Cnel. Roca 4200,-58.4474659099999,-34.675489764\n", | |
| "Club Glorias Argentinas,Bragado 6875,-58.5098882519999,-34.659278768\n", | |
| "Club Vélez,Juan B. Justo 9200,-58.519510635,-34.6336534769999\n", | |
| "Club Mitre,Segurola 1332,-58.4954611649999,-34.623691739\n", | |
| "Club Sin Rumbo,Tamborini 6157,-58.503764648,-34.5725296059999\n", | |
| "Fundación Pardes,Céspedes 3370,-58.4540267579999,-34.5777902849999\n", | |
| "Club Atlanta,Humboldt 374,-58.4485728609999,-34.5953127779999\n", | |
| "CEMAR 2,Iriarte 3501,-58.396662723,-34.651432175\n", | |
| "Centro Cultural Julián Centeya,San Juan 3255,-58.4113330929999,-34.62479608\n", | |
| "Club Huracán,Av. Amancio Alcorta 2570,-58.3968637099999,-34.642947009\n", | |
| "Club Racing Villa del Parque,Nogoyá 3045,-58.491358963,-34.602564812\n", | |
| "Club Morán,Pedro Morán 2446,-58.491102493,-34.589612367\n", | |
| "Centro Cultural Adán Buenosayres,Emilio Mitre 975,-58.441114064,-34.632353807\n", | |
| "Centro Islámico,Av. Int. Bullrich 55,-58.424407171,-34.573124847\n", | |
| "Estadio San Lorenzo,Fernández de la Cruz 2145,-58.436474994,-34.6544400139999\n", | |
| "Corralón Floresta,Av. Gaona 4660,-58.488448632,-34.626973381\n", | |
| "Casa del Historiador,Bolívar 466,-58.3732409149999,-34.613284257\n", | |
| "Centro Cultural Recoleta,Junín 1930,-58.3915747899999,-34.586496898\n", | |
| "Usina del Arte,Agustín Caffarena 1,-58.356452341,-34.62891954\n", | |
| "Club Ferro Carril Oeste,Martín de Gainza 206,-58.445996024,-34.620492939\n", | |
| "Club Comunicaciones (Salón de fiestas),Av. San Martín 5125,-58.4906717709999,-34.5970241549999\n", | |
| "Centro de Día Nº 9 y 13,Paraguay 5170,-58.4306325119999,-34.579759467\n", | |
| "La Rural,Av. Sarmiento 2704,-58.421406732,-34.5802241119999\n", | |
| "Club Boca Junior (Social),20 de Septiembre y Martín Rodríguez,-58.364283793,-34.631351298\n", | |
| "Posta de vacunación extrahospitalaria River Plate,Av. Figueroa Alcorta 7597,-58.4489679229999,-34.546176077\n", | |
| "Hospital Gral. de Agudos Dr. C. Argerich,Pi y Margall 750,-58.3659850879999,-34.628344859\n", | |
| "Hospital Gral. de Agudos Dr. C. Durand,Av. Díaz Vélez 5044,-58.437981361,-34.6089728539999\n", | |
| "Hospital Gral. de Agudos J. M. Ramos Mejía,Gral. Urquiza 609,-58.409610748,-34.6176598449999\n", | |
| "Hospital Gral. de Agudos D. Vélez Sársfield,Calderón de la Barca 1550,-58.50761514,-34.6253367959999\n", | |
| "Hospital Gral. de Agudos Donación F. Santojanni,Pilar 950,-58.5156291929999,-34.649186728\n", | |
| "Unidad de Vacunación Monasterio,Monasterio 490,-58.393824245,-34.641363424\n", | |
| "Centro de Día Parque Chacabuco,Picheuta 1517,-58.435088626,-34.636604521\n", | |
| "Luna Park,BOUCHARD 437,-58.3690209449999,-34.6023483709999\n", | |
| "Movistar Arena,Humboldt 450,-58.447787617,-34.594737047\n", | |
| "Ministerio de Desarrollo Humano y Hábitat,Av. Piedrabuena 3280,-58.4938934469999,-34.671813846\n", | |
| "Local Papa Francisco,Albariño 4315,-58.463916206,-34.675096068\n", | |
| "Ministerio de Educación,\"Perette, Carlos H. e Islas Galápagos (ex eje I calle 10)\",-58.378762949,-34.5822673669999\n", | |
| "Parque de la Estación,Tte. Gral. Juan Domingo Perón 3326,-58.4132627929999,-34.607512217\n", | |
| "Complejo Cultural Sanidad,Venezuela 2255,-58.398669131,-34.6149790439999\n", | |
| "Asociación Corredores Turismo Carretera,Bogotá 166,-58.4337695789999,-34.6132646459999\n", | |
| "Teatro San Martín,Av. Corrientes 1530,-58.38863902,-34.604241723\n", | |
| "Costa Salguero,Av. Costanera Rafael Obligado 1221,-58.3980050599999,-34.5705393119999\n", | |
| "EOF\"\"\"\n", | |
| "\n", | |
| "!cat > postas.csv <<EOF {data}" | |
| ], | |
| "id": "3ab40ad6", | |
| "execution_count": 1, | |
| "outputs": [] | |
| }, | |
| { | |
| "cell_type": "markdown", | |
| "metadata": { | |
| "id": "c81ca7ea" | |
| }, | |
| "source": [ | |
| "En este ejemplo, de coordenadas geográficas, lo que necesitamos es indicarle qué\n", | |
| "columnas tienen la latitud y la longitud, y que el SRC es EPSG:4326\n", | |
| "\n", | |
| "Esto se puede hacer creando un archivo VRT. Lamentablemente estor archivos se\n", | |
| "arman \"a pulmon\", por lo que hay que partir de algun ejemplo." | |
| ], | |
| "id": "c81ca7ea" | |
| }, | |
| { | |
| "cell_type": "code", | |
| "metadata": { | |
| "id": "e2c985ed" | |
| }, | |
| "source": [ | |
| "vrt = \"\"\"\n", | |
| "<OGRVRTDataSource>\n", | |
| " <OGRVRTLayer name=\"Postas\">\n", | |
| " <SrcDataSource>postas.csv</SrcDataSource>\n", | |
| " <SrcLayer>postas</SrcLayer>\n", | |
| " <GeometryType>wkbPoint</GeometryType>\n", | |
| " <LayerSRS>WGS84</LayerSRS>\n", | |
| " <Field name=\"Longitud\" src=\"long\" type=\"Real\"/>\n", | |
| " <Field name=\"Latitud\" src=\"lat\" type=\"Real\"/>\n", | |
| " <Field name=\"efector\" type=\"String\"/>\n", | |
| " <Field name=\"direccion\" type=\"String\"/>\n", | |
| " <GeometryField encoding=\"PointFromColumns\" x=\"long\" y=\"lat\"/>\n", | |
| " </OGRVRTLayer>\n", | |
| "</OGRVRTDataSource>\n", | |
| "EOF\"\"\"\n", | |
| "\n", | |
| "!cat > postas.vrt <<EOF {vrt}" | |
| ], | |
| "id": "e2c985ed", | |
| "execution_count": 3, | |
| "outputs": [] | |
| }, | |
| { | |
| "cell_type": "markdown", | |
| "metadata": { | |
| "id": "91b4d302" | |
| }, | |
| "source": [ | |
| "Lo interesante de esto es que podríamos calcular a mano las coordenadas web-mercator\n", | |
| "de los puntos y crear un vrt que indique ese otro sistema, por ejemplo:" | |
| ], | |
| "id": "91b4d302" | |
| }, | |
| { | |
| "cell_type": "code", | |
| "metadata": { | |
| "colab": { | |
| "base_uri": "https://localhost:8080/", | |
| "height": 1000 | |
| }, | |
| "id": "f6511be6", | |
| "outputId": "473711c2-0000-4e38-f77f-a61790ebcc55" | |
| }, | |
| "source": [ | |
| "import pandas as pd\n", | |
| "from math import pi\n", | |
| "from numpy import log,tan\n", | |
| "\n", | |
| "df = pd.read_csv('postas.csv')\n", | |
| "\n", | |
| "a = 6378137.0\n", | |
| "DEG2RAD = pi/180\n", | |
| "\n", | |
| "df.loc[:,'XWM'] = a * df.long.values * DEG2RAD\n", | |
| "df.loc[:,'YWM'] = a * log(tan(pi/4 + df.lat.values * DEG2RAD/ 2))\n", | |
| "\n", | |
| "df.to_csv('postasWebMerc.csv')\n", | |
| "\n", | |
| "df" | |
| ], | |
| "id": "f6511be6", | |
| "execution_count": 4, | |
| "outputs": [ | |
| { | |
| "output_type": "execute_result", | |
| "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>efector</th>\n", | |
| " <th>direccion</th>\n", | |
| " <th>long</th>\n", | |
| " <th>lat</th>\n", | |
| " <th>XWM</th>\n", | |
| " <th>YWM</th>\n", | |
| " </tr>\n", | |
| " </thead>\n", | |
| " <tbody>\n", | |
| " <tr>\n", | |
| " <th>0</th>\n", | |
| " <td>Oficina Nacional Scout</td>\n", | |
| " <td>Libertad 1282</td>\n", | |
| " <td>-58.384513</td>\n", | |
| " <td>-34.593200</td>\n", | |
| " <td>-6.499334e+06</td>\n", | |
| " <td>-4.108735e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1</th>\n", | |
| " <td>Sede Oscoema</td>\n", | |
| " <td>Bernardo de Irigoyen 330</td>\n", | |
| " <td>-58.380482</td>\n", | |
| " <td>-34.612148</td>\n", | |
| " <td>-6.498886e+06</td>\n", | |
| " <td>-4.111298e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2</th>\n", | |
| " <td>Club San Lorenzo (Sede Av. La Plata)</td>\n", | |
| " <td>Av. La Plata 1770</td>\n", | |
| " <td>-58.424584</td>\n", | |
| " <td>-34.635385</td>\n", | |
| " <td>-6.503795e+06</td>\n", | |
| " <td>-4.114441e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>3</th>\n", | |
| " <td>Club Italiano</td>\n", | |
| " <td>Yerbal 150</td>\n", | |
| " <td>-58.432915</td>\n", | |
| " <td>-34.615379</td>\n", | |
| " <td>-6.504722e+06</td>\n", | |
| " <td>-4.111735e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>4</th>\n", | |
| " <td>Parque Roca</td>\n", | |
| " <td>Av. Cnel. Roca 4200</td>\n", | |
| " <td>-58.447466</td>\n", | |
| " <td>-34.675490</td>\n", | |
| " <td>-6.506342e+06</td>\n", | |
| " <td>-4.119868e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>5</th>\n", | |
| " <td>Club Glorias Argentinas</td>\n", | |
| " <td>Bragado 6875</td>\n", | |
| " <td>-58.509888</td>\n", | |
| " <td>-34.659279</td>\n", | |
| " <td>-6.513291e+06</td>\n", | |
| " <td>-4.117674e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>6</th>\n", | |
| " <td>Club Vélez</td>\n", | |
| " <td>Juan B. Justo 9200</td>\n", | |
| " <td>-58.519511</td>\n", | |
| " <td>-34.633653</td>\n", | |
| " <td>-6.514362e+06</td>\n", | |
| " <td>-4.114207e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>7</th>\n", | |
| " <td>Club Mitre</td>\n", | |
| " <td>Segurola 1332</td>\n", | |
| " <td>-58.495461</td>\n", | |
| " <td>-34.623692</td>\n", | |
| " <td>-6.511685e+06</td>\n", | |
| " <td>-4.112859e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>8</th>\n", | |
| " <td>Club Sin Rumbo</td>\n", | |
| " <td>Tamborini 6157</td>\n", | |
| " <td>-58.503765</td>\n", | |
| " <td>-34.572530</td>\n", | |
| " <td>-6.512609e+06</td>\n", | |
| " <td>-4.105940e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>9</th>\n", | |
| " <td>Fundación Pardes</td>\n", | |
| " <td>Céspedes 3370</td>\n", | |
| " <td>-58.454027</td>\n", | |
| " <td>-34.577790</td>\n", | |
| " <td>-6.507072e+06</td>\n", | |
| " <td>-4.106652e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>10</th>\n", | |
| " <td>Club Atlanta</td>\n", | |
| " <td>Humboldt 374</td>\n", | |
| " <td>-58.448573</td>\n", | |
| " <td>-34.595313</td>\n", | |
| " <td>-6.506465e+06</td>\n", | |
| " <td>-4.109021e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>11</th>\n", | |
| " <td>CEMAR 2</td>\n", | |
| " <td>Iriarte 3501</td>\n", | |
| " <td>-58.396663</td>\n", | |
| " <td>-34.651432</td>\n", | |
| " <td>-6.500687e+06</td>\n", | |
| " <td>-4.116612e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>12</th>\n", | |
| " <td>Centro Cultural Julián Centeya</td>\n", | |
| " <td>San Juan 3255</td>\n", | |
| " <td>-58.411333</td>\n", | |
| " <td>-34.624796</td>\n", | |
| " <td>-6.502320e+06</td>\n", | |
| " <td>-4.113009e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>13</th>\n", | |
| " <td>Club Huracán</td>\n", | |
| " <td>Av. Amancio Alcorta 2570</td>\n", | |
| " <td>-58.396864</td>\n", | |
| " <td>-34.642947</td>\n", | |
| " <td>-6.500709e+06</td>\n", | |
| " <td>-4.115464e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>14</th>\n", | |
| " <td>Club Racing Villa del Parque</td>\n", | |
| " <td>Nogoyá 3045</td>\n", | |
| " <td>-58.491359</td>\n", | |
| " <td>-34.602565</td>\n", | |
| " <td>-6.511228e+06</td>\n", | |
| " <td>-4.110002e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>15</th>\n", | |
| " <td>Club Morán</td>\n", | |
| " <td>Pedro Morán 2446</td>\n", | |
| " <td>-58.491102</td>\n", | |
| " <td>-34.589612</td>\n", | |
| " <td>-6.511200e+06</td>\n", | |
| " <td>-4.108250e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>16</th>\n", | |
| " <td>Centro Cultural Adán Buenosayres</td>\n", | |
| " <td>Emilio Mitre 975</td>\n", | |
| " <td>-58.441114</td>\n", | |
| " <td>-34.632354</td>\n", | |
| " <td>-6.505635e+06</td>\n", | |
| " <td>-4.114031e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>17</th>\n", | |
| " <td>Centro Islámico</td>\n", | |
| " <td>Av. Int. Bullrich 55</td>\n", | |
| " <td>-58.424407</td>\n", | |
| " <td>-34.573125</td>\n", | |
| " <td>-6.503775e+06</td>\n", | |
| " <td>-4.106021e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>18</th>\n", | |
| " <td>Estadio San Lorenzo</td>\n", | |
| " <td>Fernández de la Cruz 2145</td>\n", | |
| " <td>-58.436475</td>\n", | |
| " <td>-34.654440</td>\n", | |
| " <td>-6.505119e+06</td>\n", | |
| " <td>-4.117020e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>19</th>\n", | |
| " <td>Corralón Floresta</td>\n", | |
| " <td>Av. Gaona 4660</td>\n", | |
| " <td>-58.488449</td>\n", | |
| " <td>-34.626973</td>\n", | |
| " <td>-6.510904e+06</td>\n", | |
| " <td>-4.113303e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>20</th>\n", | |
| " <td>Casa del Historiador</td>\n", | |
| " <td>Bolívar 466</td>\n", | |
| " <td>-58.373241</td>\n", | |
| " <td>-34.613284</td>\n", | |
| " <td>-6.498079e+06</td>\n", | |
| " <td>-4.111451e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>21</th>\n", | |
| " <td>Centro Cultural Recoleta</td>\n", | |
| " <td>Junín 1930</td>\n", | |
| " <td>-58.391575</td>\n", | |
| " <td>-34.586497</td>\n", | |
| " <td>-6.500120e+06</td>\n", | |
| " <td>-4.107829e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>22</th>\n", | |
| " <td>Usina del Arte</td>\n", | |
| " <td>Agustín Caffarena 1</td>\n", | |
| " <td>-58.356452</td>\n", | |
| " <td>-34.628920</td>\n", | |
| " <td>-6.496211e+06</td>\n", | |
| " <td>-4.113566e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>23</th>\n", | |
| " <td>Club Ferro Carril Oeste</td>\n", | |
| " <td>Martín de Gainza 206</td>\n", | |
| " <td>-58.445996</td>\n", | |
| " <td>-34.620493</td>\n", | |
| " <td>-6.506179e+06</td>\n", | |
| " <td>-4.112427e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>24</th>\n", | |
| " <td>Club Comunicaciones (Salón de fiestas)</td>\n", | |
| " <td>Av. San Martín 5125</td>\n", | |
| " <td>-58.490672</td>\n", | |
| " <td>-34.597024</td>\n", | |
| " <td>-6.511152e+06</td>\n", | |
| " <td>-4.109252e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25</th>\n", | |
| " <td>Centro de Día Nº 9 y 13</td>\n", | |
| " <td>Paraguay 5170</td>\n", | |
| " <td>-58.430633</td>\n", | |
| " <td>-34.579759</td>\n", | |
| " <td>-6.504468e+06</td>\n", | |
| " <td>-4.106918e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>26</th>\n", | |
| " <td>La Rural</td>\n", | |
| " <td>Av. Sarmiento 2704</td>\n", | |
| " <td>-58.421407</td>\n", | |
| " <td>-34.580224</td>\n", | |
| " <td>-6.503441e+06</td>\n", | |
| " <td>-4.106981e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>27</th>\n", | |
| " <td>Club Boca Junior (Social)</td>\n", | |
| " <td>20 de Septiembre y Martín Rodríguez</td>\n", | |
| " <td>-58.364284</td>\n", | |
| " <td>-34.631351</td>\n", | |
| " <td>-6.497082e+06</td>\n", | |
| " <td>-4.113895e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>28</th>\n", | |
| " <td>Posta de vacunación extrahospitalaria River Plate</td>\n", | |
| " <td>Av. Figueroa Alcorta 7597</td>\n", | |
| " <td>-58.448968</td>\n", | |
| " <td>-34.546176</td>\n", | |
| " <td>-6.506509e+06</td>\n", | |
| " <td>-4.102378e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>29</th>\n", | |
| " <td>Hospital Gral. de Agudos Dr. C. Argerich</td>\n", | |
| " <td>Pi y Margall 750</td>\n", | |
| " <td>-58.365985</td>\n", | |
| " <td>-34.628345</td>\n", | |
| " <td>-6.497272e+06</td>\n", | |
| " <td>-4.113489e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>30</th>\n", | |
| " <td>Hospital Gral. de Agudos Dr. C. Durand</td>\n", | |
| " <td>Av. Díaz Vélez 5044</td>\n", | |
| " <td>-58.437981</td>\n", | |
| " <td>-34.608973</td>\n", | |
| " <td>-6.505286e+06</td>\n", | |
| " <td>-4.110868e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>31</th>\n", | |
| " <td>Hospital Gral. de Agudos J. M. Ramos Mejía</td>\n", | |
| " <td>Gral. Urquiza 609</td>\n", | |
| " <td>-58.409611</td>\n", | |
| " <td>-34.617660</td>\n", | |
| " <td>-6.502128e+06</td>\n", | |
| " <td>-4.112043e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>32</th>\n", | |
| " <td>Hospital Gral. de Agudos D. Vélez Sársfield</td>\n", | |
| " <td>Calderón de la Barca 1550</td>\n", | |
| " <td>-58.507615</td>\n", | |
| " <td>-34.625337</td>\n", | |
| " <td>-6.513038e+06</td>\n", | |
| " <td>-4.113082e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>33</th>\n", | |
| " <td>Hospital Gral. de Agudos Donación F. Santojanni</td>\n", | |
| " <td>Pilar 950</td>\n", | |
| " <td>-58.515629</td>\n", | |
| " <td>-34.649187</td>\n", | |
| " <td>-6.513930e+06</td>\n", | |
| " <td>-4.116309e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>34</th>\n", | |
| " <td>Unidad de Vacunación Monasterio</td>\n", | |
| " <td>Monasterio 490</td>\n", | |
| " <td>-58.393824</td>\n", | |
| " <td>-34.641363</td>\n", | |
| " <td>-6.500371e+06</td>\n", | |
| " <td>-4.115250e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>35</th>\n", | |
| " <td>Centro de Día Parque Chacabuco</td>\n", | |
| " <td>Picheuta 1517</td>\n", | |
| " <td>-58.435089</td>\n", | |
| " <td>-34.636605</td>\n", | |
| " <td>-6.504964e+06</td>\n", | |
| " <td>-4.114606e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>36</th>\n", | |
| " <td>Luna Park</td>\n", | |
| " <td>BOUCHARD 437</td>\n", | |
| " <td>-58.369021</td>\n", | |
| " <td>-34.602348</td>\n", | |
| " <td>-6.497610e+06</td>\n", | |
| " <td>-4.109972e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>37</th>\n", | |
| " <td>Movistar Arena</td>\n", | |
| " <td>Humboldt 450</td>\n", | |
| " <td>-58.447788</td>\n", | |
| " <td>-34.594737</td>\n", | |
| " <td>-6.506378e+06</td>\n", | |
| " <td>-4.108943e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>38</th>\n", | |
| " <td>Ministerio de Desarrollo Humano y Hábitat</td>\n", | |
| " <td>Av. Piedrabuena 3280</td>\n", | |
| " <td>-58.493893</td>\n", | |
| " <td>-34.671814</td>\n", | |
| " <td>-6.511510e+06</td>\n", | |
| " <td>-4.119371e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>39</th>\n", | |
| " <td>Local Papa Francisco</td>\n", | |
| " <td>Albariño 4315</td>\n", | |
| " <td>-58.463916</td>\n", | |
| " <td>-34.675096</td>\n", | |
| " <td>-6.508173e+06</td>\n", | |
| " <td>-4.119815e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>40</th>\n", | |
| " <td>Ministerio de Educación</td>\n", | |
| " <td>Perette, Carlos H. e Islas Galápagos (ex eje I...</td>\n", | |
| " <td>-58.378763</td>\n", | |
| " <td>-34.582267</td>\n", | |
| " <td>-6.498694e+06</td>\n", | |
| " <td>-4.107257e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>41</th>\n", | |
| " <td>Parque de la Estación</td>\n", | |
| " <td>Tte. Gral. Juan Domingo Perón 3326</td>\n", | |
| " <td>-58.413263</td>\n", | |
| " <td>-34.607512</td>\n", | |
| " <td>-6.502535e+06</td>\n", | |
| " <td>-4.110671e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>42</th>\n", | |
| " <td>Complejo Cultural Sanidad</td>\n", | |
| " <td>Venezuela 2255</td>\n", | |
| " <td>-58.398669</td>\n", | |
| " <td>-34.614979</td>\n", | |
| " <td>-6.500910e+06</td>\n", | |
| " <td>-4.111681e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>43</th>\n", | |
| " <td>Asociación Corredores Turismo Carretera</td>\n", | |
| " <td>Bogotá 166</td>\n", | |
| " <td>-58.433770</td>\n", | |
| " <td>-34.613265</td>\n", | |
| " <td>-6.504817e+06</td>\n", | |
| " <td>-4.111449e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>44</th>\n", | |
| " <td>Teatro San Martín</td>\n", | |
| " <td>Av. Corrientes 1530</td>\n", | |
| " <td>-58.388639</td>\n", | |
| " <td>-34.604242</td>\n", | |
| " <td>-6.499794e+06</td>\n", | |
| " <td>-4.110228e+06</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>45</th>\n", | |
| " <td>Costa Salguero</td>\n", | |
| " <td>Av. Costanera Rafael Obligado 1221</td>\n", | |
| " <td>-58.398005</td>\n", | |
| " <td>-34.570539</td>\n", | |
| " <td>-6.500836e+06</td>\n", | |
| " <td>-4.105671e+06</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " efector ... YWM\n", | |
| "0 Oficina Nacional Scout ... -4.108735e+06\n", | |
| "1 Sede Oscoema ... -4.111298e+06\n", | |
| "2 Club San Lorenzo (Sede Av. La Plata) ... -4.114441e+06\n", | |
| "3 Club Italiano ... -4.111735e+06\n", | |
| "4 Parque Roca ... -4.119868e+06\n", | |
| "5 Club Glorias Argentinas ... -4.117674e+06\n", | |
| "6 Club Vélez ... -4.114207e+06\n", | |
| "7 Club Mitre ... -4.112859e+06\n", | |
| "8 Club Sin Rumbo ... -4.105940e+06\n", | |
| "9 Fundación Pardes ... -4.106652e+06\n", | |
| "10 Club Atlanta ... -4.109021e+06\n", | |
| "11 CEMAR 2 ... -4.116612e+06\n", | |
| "12 Centro Cultural Julián Centeya ... -4.113009e+06\n", | |
| "13 Club Huracán ... -4.115464e+06\n", | |
| "14 Club Racing Villa del Parque ... -4.110002e+06\n", | |
| "15 Club Morán ... -4.108250e+06\n", | |
| "16 Centro Cultural Adán Buenosayres ... -4.114031e+06\n", | |
| "17 Centro Islámico ... -4.106021e+06\n", | |
| "18 Estadio San Lorenzo ... -4.117020e+06\n", | |
| "19 Corralón Floresta ... -4.113303e+06\n", | |
| "20 Casa del Historiador ... -4.111451e+06\n", | |
| "21 Centro Cultural Recoleta ... -4.107829e+06\n", | |
| "22 Usina del Arte ... -4.113566e+06\n", | |
| "23 Club Ferro Carril Oeste ... -4.112427e+06\n", | |
| "24 Club Comunicaciones (Salón de fiestas) ... -4.109252e+06\n", | |
| "25 Centro de Día Nº 9 y 13 ... -4.106918e+06\n", | |
| "26 La Rural ... -4.106981e+06\n", | |
| "27 Club Boca Junior (Social) ... -4.113895e+06\n", | |
| "28 Posta de vacunación extrahospitalaria River Plate ... -4.102378e+06\n", | |
| "29 Hospital Gral. de Agudos Dr. C. Argerich ... -4.113489e+06\n", | |
| "30 Hospital Gral. de Agudos Dr. C. Durand ... -4.110868e+06\n", | |
| "31 Hospital Gral. de Agudos J. M. Ramos Mejía ... -4.112043e+06\n", | |
| "32 Hospital Gral. de Agudos D. Vélez Sársfield ... -4.113082e+06\n", | |
| "33 Hospital Gral. de Agudos Donación F. Santojanni ... -4.116309e+06\n", | |
| "34 Unidad de Vacunación Monasterio ... -4.115250e+06\n", | |
| "35 Centro de Día Parque Chacabuco ... -4.114606e+06\n", | |
| "36 Luna Park ... -4.109972e+06\n", | |
| "37 Movistar Arena ... -4.108943e+06\n", | |
| "38 Ministerio de Desarrollo Humano y Hábitat ... -4.119371e+06\n", | |
| "39 Local Papa Francisco ... -4.119815e+06\n", | |
| "40 Ministerio de Educación ... -4.107257e+06\n", | |
| "41 Parque de la Estación ... -4.110671e+06\n", | |
| "42 Complejo Cultural Sanidad ... -4.111681e+06\n", | |
| "43 Asociación Corredores Turismo Carretera ... -4.111449e+06\n", | |
| "44 Teatro San Martín ... -4.110228e+06\n", | |
| "45 Costa Salguero ... -4.105671e+06\n", | |
| "\n", | |
| "[46 rows x 6 columns]" | |
| ] | |
| }, | |
| "metadata": {}, | |
| "execution_count": 4 | |
| } | |
| ] | |
| }, | |
| { | |
| "cell_type": "markdown", | |
| "metadata": { | |
| "id": "33bfef98" | |
| }, | |
| "source": [ | |
| "El vrt creado es similar al anterior, sólo cambian las coordenadas y el nombre\n", | |
| "de la proyección, que es EPSG:3857." | |
| ], | |
| "id": "33bfef98" | |
| }, | |
| { | |
| "cell_type": "code", | |
| "metadata": { | |
| "id": "c880fde7" | |
| }, | |
| "source": [ | |
| "vrt = \"\"\"\n", | |
| "<OGRVRTDataSource>\n", | |
| " <OGRVRTLayer name=\"Postas\">\n", | |
| " <SrcDataSource relativeToVRT=\"1\">postasWebMerc.csv</SrcDataSource>\n", | |
| " <SrcLayer>postasWebMerc</SrcLayer>\n", | |
| " <GeometryType>wkbPoint</GeometryType>\n", | |
| " <LayerSRS>EPSG:3857</LayerSRS>\n", | |
| " <Field name=\"Longitud\" src=\"long\" type=\"Real\"/>\n", | |
| " <Field name=\"Latitud\" src=\"lat\" type=\"Real\"/>\n", | |
| " <Field name=\"efector\" type=\"String\"/>\n", | |
| " <Field name=\"direccion\" type=\"String\"/>\n", | |
| " <GeometryField encoding=\"PointFromColumns\" x=\"XWM\" y=\"YWM\"/>\n", | |
| " </OGRVRTLayer>\n", | |
| "</OGRVRTDataSource>\n", | |
| "EOF\"\"\"\n", | |
| "\n", | |
| "!cat > postasWebMerc.vrt <<EOF {vrt}" | |
| ], | |
| "id": "c880fde7", | |
| "execution_count": 6, | |
| "outputs": [] | |
| }, | |
| { | |
| "cell_type": "markdown", | |
| "metadata": { | |
| "id": "6cb01d86" | |
| }, | |
| "source": [ | |
| "Puede verificarse descargando los archivos, que al abrir los vrt en QGIS ambos\n", | |
| "están correctamente referenciados y coinciden entre sí." | |
| ], | |
| "id": "6cb01d86" | |
| } | |
| ] | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment