Skip to content

Instantly share code, notes, and snippets.

@jjclavijo

jjclavijo/ejemplo-coordenadas-en-formatos.ipynb

Created October 18, 2021 00:41
Show Gist options
  • Save jjclavijo/962851f948382b9f54436c6e2a3bae07 to your computer and use it in GitHub Desktop.
Save jjclavijo/962851f948382b9f54436c6e2a3bae07 to your computer and use it in GitHub Desktop.
Download ZIP
Ejemplo Coordenadas en Formatos
Display the source blob
Display the rendered blob
Raw
ejemplo-coordenadas-en-formatos.ipynb
{
"nbformat": 4,
"nbformat_minor": 5,
"metadata": {
"jupytext": {
"cell_metadata_filter": "-all",
"main_language": "python",
"notebook_metadata_filter": "-all"
},
"colab": {
"name": "Ejemplo Coordenadas en Formatos",
"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/962851f948382b9f54436c6e2a3bae07/ejemplo-coordenadas-en-formatos.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "53f7427b"
},
"source": [
"\n",
"# Ejemplo de metadatos y coordenadas en varios formatos.\n",
"\n",
"Para no tener que asociar otro archivo al notebook vamos a comenzar bajando\n",
"una capa del wfs de ign. Ya vamos a ver mas adelante qué es WFS"
],
"id": "53f7427b"
},
{
"cell_type": "code",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "23f9453e",
"outputId": "b9582260-602c-4d19-9835-d7ef66658503"
},
"source": [
"_= !pip install geopandas matplotlib\n",
"_= !apt-get update && apt-get -y install curl jq\n",
"\n",
"# Descargar una capa del wfs de igm\n",
"!curl 'https://wms.ign.gob.ar/geoserver/bahra/ows?service=WFS&version=1.0.0&request=GetFeature&typeName=bahra%3Alocalidad_bahra&outputFormat=JSON' -J -O"
],
"id": "23f9453e",
"execution_count": 3,
"outputs": [
{
"output_type": "stream",
"name": "stdout",
"text": [
" % Total % Received % Xferd Average Speed Time Time Time Current\n",
" Dload Upload Total Spent Left Speed\n",
"100 2506k 0 2506k 0 0 956k 0 --:--:-- 0:00:02 --:--:-- 955k\n",
"curl: Saved to filename 'features.json'\n"
]
}
]
},
{
"cell_type": "code",
"metadata": {
"id": "0c4189ec"
},
"source": [
"import geopandas as gpd\n",
"import matplotlib.pyplot as plt"
],
"id": "0c4189ec",
"execution_count": 4,
"outputs": []
},
{
"cell_type": "markdown",
"metadata": {
"id": "69db1841"
},
"source": [
"# Previsualizamos el dataset, ya que podemos"
],
"id": "69db1841"
},
{
"cell_type": "code",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 265
},
"id": "734c23d5",
"outputId": "3b53eb0c-f15f-414a-b303-b1600db36a9d"
},
"source": [
"dset = gpd.read_file('./features.json')\n",
"dset.plot()\n",
"plt.show()"
],
"id": "734c23d5",
"execution_count": 5,
"outputs": [
{
"output_type": "display_data",
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAI4AAAD4CAYAAAA6ht7UAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAYsElEQVR4nO2df5BcVZXHP2c6HZmJVE2yDAJNhmAWwpoNzEiUUFNYhlWjIDJGJFBkWXWLrJSuxY+KFSBCRDApR4y766qFVf5hkXUHJNsGgQ1SoSwrOrATZsIQN1kIkEDDykAYLJPepDNz9o9+PemZ6R+v369+P+6nqivd73W/d7vznXPPvefcc0VVMRgapaXZDTBEEyMcgyOMcAyOMMIxOMIIx+CIWc1uQDmnnHKKLliwoNnNMFjs2rXrLVXtqHQuVMJZsGABg4ODzW6GwUJEDlQ7Z7oqgyOMcAyOMMIxOMIIx+AIIxyDI0I1qgoL2aEcfdv38fpYnjPaW1m7YhG93ZlmNytUSJii40uXLtVmD8ezQznWPrSbwsTU36U13cLGledXFNB0oS0/r4On9o5GXngisktVl1Y8Z4QzlXNuf5TCRP33ZSxBANzcP0ytXzGdEvquuiBy4qklHNNVlbE+O2JLNAC5sTw39Q/bem9hXLnjP0YiJ5xaGOe4jC0DB3279uFj42SHcr5dP2iMcCyyQ7ma3Y0XfPORPT7fITiMcCz6tu/z/R7vHCnExuoY4Vi8PpYP5D5BCDQIjHAodlNIMPfKjeVjYXUSL5zsUI7bto4Q5KzETf3DrM+OBHdDH0i8cPq27yNfGA/8vg8MHOS6n/w+8Pt6ReKFE5RvU4md+w/xV994PJJdV+KFc0Z7a1Pvny9McFP/MN13PxEpASVeOKWwQbN550iB27aOREY8iRdOb3eGtnQ4foZ8YZyb+ofp2bQj9AIKxy/WZPJ2A1QBkRvLc3PIR15GODTfz6mEUhx5fSCkznPihZMdynHk2PFmN6MqRwoT3PLgcOjEk2jhlCb/3jlSaHZTajKh4QuQusrHEZE+4ArgGLAf+KKqjonIAuC/gVJgZkBVv+zmXn4Q1ORfazrl+j7vHCmwYN2jALS3ptnwmcVNze9xa3F+Dfy1qp4P/A9wW9m5/araZT1CJxrwb/Iv3VLMEBSK/25cucTTUNhYvsBN/cMsWt88/8eVcFT1CVUtOQgDwJnumxQcfjnFs2el2LnuUl7edDk7110KQEuL91HUo8eLk4eL7/zPwAXkpY/zJeDxstdni8iQiPxGRC6p9iERWSMigyIyODo66mFz6rP8vA5fguLTs/36tu9jfMK/KOrhY+Os/cXuQMVTN1ldRJ4ETqtw6g5V/aX1njuApcBKVVUReQ/wXlV9W0QuBLLAYlX9U617BZmsXnKM/fRx5sxOce9nl9RNZveKTHvrpIWrRmlFRm4sj8Bku0Tguos6uad3yeR7XSWrq+rHap0XkS8Anwb+Ri0VqupR4Kj1fJeI7AfOBUJTiiIIx/jwsXHbCe1eUM9nm/7HUi5m1eK8ETBFPNVw1VWJyCeBrwOfUdUjZcc7RCRlPX8/cA7wkpt7eU0zo+J+Uc9ns/PH8oDNhH23Ps4PgJOBX4vIsIj82Dr+EeA5ERkGfgF8WVUPubyXp4Rxttgt9QK2OZt/LHZ8Jbejqr9U1fnTh92q+rCqLraOfVBVH3FzHz8IS1TcK1Yv6/RsXsdOXnRiZ47jtDgO7PkldrFjmRIrHCiuB48DGRvdrtdpqvH45RxyUjrV7CZ4gp1ud+d+b13MRAtnLOTBTTv0LJxXt9stxbi8JLHCCXItlZ9sueHimuediGbO7PqWOJHVKrJDOW59aHega6n84ux1j86owZMdyrFh2x7G8s4s6r2fre9oJ7I+TvfdT4Q+B8cJc2anOHzM+Wy4AJtXdU0KsFbIIZFdVRxFA7gSDRQnRe1OUyRSOIbKNBKGSaRw2lvTzW5CKGkkDJNI4Wz4zOJmNyGUNBKGSaRw4hZu8IJGY12JHY4birSlW/h2lTK8tUiUcMqz35LOSSlh772XOf58YoQTRKpoVDjn1Dn8+paPurpGYnycZhVQChvvO3m2a9FAgoQTx1TRRulZOI+n7/i4J9dKTFd1RntrYn2b1nSKjSuXeDqaTIzFWX5exT1JE4HXooGECCc7lOPhXckdgvsxb5UI4STZMbaTVuoE18IRkW+JyHPW8pgnROQM67iIyD+LyIvW+Q+6b25jZIdy9GzakVjfBvxbzeGFxelT1fNVtQv4FXCndfxTFBfinQOsAX7kwb1sU9qwLMmimduW9i284lo409aDz+HEytIrgZ9pkQGgXUROd3s/u2zYtmfGLndJIp0S7rrCv2CuJ8NxEbkXuB54F1huHc4Ar5a97TXr2BvTPruGokWis7PTi+YAOE6bjAOlYgd+BnNtWRwReVJEnq/wuBJAVe9Q1fnAFuCrjTRAVe9X1aWqurSjI7lDZq9YvayTPXd/0vcMAFsWp17FijK2AI8BdwE5YH7ZuTOtYwYf8XJFZy28GFWdU/bySmCv9XwbcL01uloGvKuqb8y4gMEz/Bp6V8ILH2eTiCwCJoADQKne32PAZcCLwBHgix7cyzazU8Kx8WQ5x0EWUnAtHFX9XJXjCnzF7fWdcvWH5tuu9RIHvKxWYYdYzhxnh3L0P/Nq/TfGiKB8mxKxFE7S53CCIJbCSfIcTlDEUjgG/zHCMTgilsKZ25aslZrNWJkaS+HcdcVi0qnGi9+0CHx/VRffX9XlQ6v8oxkrU2OZc1yaz/jmI3saqkxRqvgSti1+6tGMlamxEk5x7dRzrrZKDLISepSJjXCyQzlu6R/Gze6aZubHPrHxcfq273MsGh92BAqMZg0EYiMcNwvuojzJ7GeWXy1iI5w47s1gh2aVbImNcNauWBSfL2OTlDSvj43Nb93bneF7q7piU2bfDtdeNL/+m3wiNqMqKIqnZLr9qCYeJubMTgWeSlFOcv48Y8YRl6Vp3WKEE1GaPRiIrXDed/LsmueFYmWqZjqYbljwF0Y4vlCvgJACL7x5mHFVVi/rZPUy7xYDBsHO/Yc834OqEWIrHMB2lPuBgYM8/dLbfH9Vl62dU8JCM8XjdhfgapUqPioi71rHh0XkznrX8oPe7oxt8bzw5mH+9akXODbuJtoVPDv3H2LBukcDL8Hrdjjep6rfABCRr1GsVFFaV/VbVf20y+s3RHk52pQI46oNLVJ74c3DPrbOX0pR/aBmkt3uAlytUkXglMrRlsqajFvJNUkqcxJkSogXS4DvFZFXges4URsH4GIR2S0ij4tI1UiciKwRkUERGRwdHXXcjiRX3SonKJ+nrnAcVqp4FjhLVS8A/gXIVru+V9UqTDnaIl5v2lqNuj6Ok0oV5V2Yqj4mIj8UkVNU9S2H7ayLV+VoZ7UIx6OcZxEQbkdVFStViMhpIsWZNRH5sHWft93cqx5rVyyi1eV20D0L5xnR2MTtqKpapYqrgBtF5DiQB65Rnzf/LI0mbn1w96RjXE6mvZUjx45XTF5PiXDtRfP5+dPRX2/uYHGHI2K3mWulzT5a0yk+d2GG/mderbim/JxT5/Dim4djk3M8ty3NXVcsdj00T9Rmrr3dGTauXEKmvRWhaGk2rlzCU3tHqxYieCFGooHiZrW3PrTb10nB2Fmcapy97tFYicMOc9vSDN35Ccefr2VxIp/ItT47ws+ffpVxVVIiLHv/XF55O8/rY/kpG7k7GXWVZp+jip/bZEe6q1qfHeGBgYOT/7njquzcf4jcWB6lOGu81jLZjY66BLjv6gv8aXgMiLRw/u3p+qXaChPKhm17Jn0fu+uQ2qwoedIKGNgl0sKxO+Uyli/Qs2kHN/cP0zZ7FquXdU4GP0uJXNPzuQ4fG+e2rSN84PSTvWxybIi0cBqhvPt6eFeO5ed10JpOTXZzlVyZfGE8sCl8P+hZOM+3a0feOXZCvjCeiIqkW2642LdrR9birM+ONLsJiSaSwimNpuyQVOfW7+8dSeE0ElPy2rlNR6C0RarF3y2HIKLCaWRS7nceOrcCrPrwfF+dTi+47/MXhGP3mLDRyIyul/O+Cvxq9xscPR7ehHY/d8UrJ5IWp5mL7cfyhVCnqAZVLyeSwrmnd0nou4tm0JpuicYqh2axPjviqe8SFzauPD+we0VOONmhHFsGDiYuRaIeQW87FDnnuG/7PiOaMoLYuLUSkRNO0pfBCMXRXaYs16gZRE44Xi2DiRLpFqEvgLmZRoicj+PFMpgo0d6aDp1owEOLIyK3At8FOlT1LWtd1T9R3ND1CPAFVX3W7X1KP+DtW5/jiIvS+27JVLF8PQvn1UzFaG9NT9mIrS3dwuxZKd7NF6akuoYdT4QjIvOBTwDlkcdPAedYj4uAH1n/umbwwCFX+zV4wXTR9CycN5nGUKtw5fBdzpPHw4RXFmcz8HXgl2XHrgR+Zi3EGxCRdhE53e3e414Px1Mi7N94WcVz1/3k97YTuXbuP8T67EhTK4EGiWvhWMUHcqq6W6bmX2aA8jD2a9axKcIRkTXAGoDOzvrl1Lwejo+r0rNpx+SqiOXndfDU3tHJ1z0L5zHw0juTqyhqxcgeGDjIU3trV9zIDuUi0RXVw5ZzXKdixe1MLW/SEI1Wq/BjOF6eVvrAwMEpr3+3/xDXXjSfVzZdbitGVm/Et9bnhXJBYcviVKtYISJLgLOBkrU5E3jWKjSQA8p/6TOtY644Kd0SqH+jFC3JQ4OveRIVL0wofdv3Rd7quK3INaKqp6rqAlVdQLE7+qCq/i+wDbheiiwD3vXCv2mWU+xlKkUcJjH9nAB8jOJQ/EWKw/Evur1g3/Z9bi8RCppd3NoLPBWOZXVKzxX4ipfXj8OMcbpFWLtiUbOb4ZpIzRyHP9u3Nq3pllDOAjshUrGqKEfF29It/OFbn2p2MzwjUhYnynw7wCSrIIiUcKLYVQnBJ1kFQaSEE9auqrz6V6mgQen15lVdsQxDRMrHCSMpEXauu7TZzQicSFkcv2hvdb5cthTrikMYoRESL5wWYPEZlZcJz5mdQphZO2c6ubE8t20dSZR4IiUcP9ZSTQADL71T8Vx722xe3nQ5m6/uqrtmPF8Yj83Mth0iJZzPL/VnF7tqqRKlmFJvd4YWG8UG4hCDskukhOPXX3S1fTnLY0p2gpxxiEHZJVKjKr9iVbNnCccnoDB+wvK0plMsP6+D7rufsFX2tTWdikUMyi6REo5f5AsTpFuEuW1pxo4UJjMB+//r1Sliqkaz1zg1AyMci8KE8qf8ca5b1slTe0dtV/wSSOQ8TmSEE8RQd1y14aKSYZ3N9pvIOMdhHepGdcN7t0RGOGEd6jazyFMziYxwwjjUXb2sM5YBTDtExsdZu2IRN/cPN+RTzG1L1x1Kl6o/VKM1nWLjyuDLiISdyFic3u5MQ6JJSbFka60CBa3pFNeVpUHMbUvTmj7xk8xtSxvRVCEyFgeqL/SvxLUXzZ/8D+/bvo/Xx/K0t6VRpeIC/xNbMp6YIf6/wgSDBw5Nfj5KRQH8xpMd8ipUqvgoxXXkL1tv2aqqd9e7Tr0d8rJDOdY+tLvqFoklnPgePZt2VBTl9K4sSV2XrzvkValUAfBbVf202+uXU/rP2rBtz5RSIdNZetY8skO5hixFtVHbdImWouBJEE4tvOiqKlWq8I3e7gy93ZmqFgKY4USX8mVKn69EI5W+wjo1ECRuN6yfrFRR4fTFIrJbRB4XkapVm0VkjYgMisjg6GjtSg9Q7K5qiQYqj5Lq5cusXbHIdjJ8GKcGgqauxRGRJ4HTKpy6g2KlikqVgp4FzlLVP4vIZUCWYoGlGajq/cD9UPRxarWl0p7ijZAby08pMzK9O7Pj7SUtCl6NusJxUqnCKjpQ+vxjIvJDETlFVd9y09i+7ftcl8MvdVmDBw5NiUvVsmApESZUzaiqDMc+jqqOAKeWXovIK8BSa1R1GvBHVVWr5EkL8LbbxnrhW+QL43zzkT22t1ZO0iiqEfyax7kKuFFEjgN54Br1YNzvVanaeqLJtLeaeZs6eCacaZUqfgD8wKtrl3ASdnBCEvNrGiUyIQdoLOzQmk6xelnnjNUJ6RZxtY7KUCRSwskO5WoOmdvSLZNLbzeuXMLSs+bNWHA+rkphvHrieTpSv0jziFSsql7FUUXYvKpr0ifp2bRjRs7whBY3o6+GjRRjAxGzOPVGVdMn+ZyMwuqEwQwWkRKOnRnbcrE4neE1e5rXJ1LCsbMBSLlYnG4YsmXgYKLWgTshUsKBYp3jakwvzNjbnWHjyiWTiVp2R1NKeJPjw0JknGNbcaoKQ65SNL3E+uyIrb0gcmP5KaX6zUTgVCJjcezEqQrjWtdS3NO7hM2rusjU8X+EqaX6b+4fNr5PGZERjt0Rkp339XZn2LnuUl7ZdDmrl3XOMFSVEtgV4/uUExnh2B0hNTqSKrdApcnDat2Y8X1OEBkfZ+2KRXV9HKe5MtP9oFqJYib7r0hkLM70EVKlCp9epT/UygY02X9FImNxYKZl8PM+gwcOzRh9mey/E0RKOLVodFVDPe7pLQZJzZqqysRCONPneOysarBDUBYuikTGx6lFpTmepFUBDZrQWpxGup5qI51aIyCvu7akEUrhNNr1VMtFrjYC8qtrSxKh7KrqdT2lRXlnr3uUnk07WH5ex4woeK0RkOna3BNK4dTqekrWojyO9PCuHJ+7MGN7TsdJ12aYiquuSkQ2ADcApbW7t6vqY9a524C/B8aBr6nqdrvXrdX1VLMWT+0drbo6ITuUm1KooEWg0mIdM7lnHy8szmZV7bIeJdF8ALgGWAx8EvihiNjOqKqUgFXqehq1FqXSKOXVLSqlh5rJvcbwq6u6Evh3VT2qqi9T3EL6w3Y/XCkB66R0Czf3D9Nio3x+OX3b91Wtp5MS8TxckRS8GFV9VUSuBwaBW1X1HSADDJS95zXr2AxEZA2wBqCz88QmH6XJt+kjoEobdtSyFrX8lglVXt50ea3vZqhCXYsjIk+KyPMVHlcCPwIWAl3AG8B9jTZAVe9X1aWqurSjo2PG+WoJXHatRS2/xfg0znFcrWI6IvIT4FfWyxxQXgD4TOtYw1SzGHatxdoViyqWf0un4rFxfLNwW1jp9LKXnwWet55vA64RkfeIyNkUa+M84+Qe1ayCXWvR252h7/MXTElUn9uWpu+qeGwc3yzc+jjfEZEuislxrwD/AKCqe0TkQeAPwHHgK6rqqLBNpQSuRkdAJljpPa6Eo6p/W+PcvcC9bq4PJ0IAJq4ULkI5c1xOdijH7Vufm5wpfv3dPIMHDjW7WYknlEHOEtmhHLc8ODxlwk4VHhg4yMujf2bLDRfX/XwcLVUYvleoLU7f9n1ViwDs3H+o5lKVSjGtOGzxHJbvFWrh1As61opmxzUCHpbvFWrh1Bty1xJWXCPgYfleoRZOvSG3k1nhqM8Wh+V7hVo4vd0ZehbOq3iuhdrCqhVhjzJh+V6hFg7AlhsuZvWyTsprQLamW/heWcm2SlRawBeHCHhYvpcn2w55Rb1thwzBUmvbodBbHEM4McIxOMIIx+AIIxyDI4xwDI4IdZDTT8IQKIwyiRSOWQLsnkR2VWEJFEaZRAonLIHCKJNI4VQLCCrFwpFRz9kJgkQKZ+2KRTM2QCsRl4Qvv0mUc1waSdXb17Pk7xhHuTpu11VtEJGciAxbj8us4wtEJF92/MfeNNc55SmXdjD+Tm28sDibVfW7FY7vV9UuD67vCY3uWR71hC+/SYyP04gFiUPCl994IZyvishzIvJTEZlbdvxsERkSkd+IyCXVPiwia0RkUEQGR0dHq73NNfUsSMlVjkvCl9/UTeQSkSeB0yqcuoNiKZO3KI5kvwWcrqpfEpH3AO9V1bdF5EIgCyxW1T/VupefiVyV9rsq7RKTMSGHitRK5PKlWoWqHgWOWs93ich+4FyKNXSagllK7C1uawCerqpvWC8nq1WISAdwSFXHReT9FKtVvOSqpR5gig94hy/VKoCPAHeLSAGYAL6sqmbBd4zwpVqFqj4MPOzm2oZwk5jhuMFbjHAMjjDCMTgiVAvyRGQUOODBpU6hOL8UVcLS/rNUdWYpWEImHK8QkcFqE1dRIArtN12VwRFGOAZHxFU49ze7AS4Jfftj6eMY/CeuFsfgM0Y4BkfESjgi0l+W5/yKiAyXnbtNRF4UkX0isqKZ7ayGiPyjiOwVkT0i8p2y46Fre6xWOajqqtJzEbkPeNd6Xr5j3xnAkyJyrtP9JfxARJZT3CDuAlU9KiKnWsdD2fZYWZwSIiLA1cDPrUOuduwLiBuBTVYSHKr6pnU8lG2PpXCAS4A/quoL1usM8GrZ+ao79jWRc4FLRORpK0/7Q9bxULY9cl1VrRxoVf2l9fxaTlib0FAnf3sWMA9YBnwIeNDKngwlkRNOvRxoEZkFrAQuLDvs2Y59bqjVdhG5EdiqxYm1Z0RkgmKwMxRtn04cu6qPAXtV9bWyY57t2OcjWWA5gIicC8ymGCEPZdsjZ3FscA3Tuikvd+zzkZ8CPxWR54FjwN9Z1ieUbTchB4Mj4thVGQLACMfgCCMcgyOMcAyOMMIxOMIIx+AIIxyDI/4fR9ZqDSJgYPEAAAAASUVORK5CYII=\n",
"text/plain": [
"<Figure size 432x288 with 1 Axes>"
]
},
"metadata": {
"needs_background": "light"
}
}
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "7b3b3624"
},
"source": [
"# Vamos a convertir el archivo, que bajamos en GeoJSON, a otros formatos"
],
"id": "7b3b3624"
},
{
"cell_type": "code",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "1be01da4",
"outputId": "82073eb6-f6f2-47bd-f999-4440b2fa1ebd"
},
"source": [
"!ogr2ogr -f gml features.gml features.json\n",
"!ogr2ogr -f \"ESRI shapefile\" features.shp features.json\n",
"!ogr2ogr -f kml features.kml features.json\n",
"!ogr2ogr -f PGDump features.sql features.json"
],
"id": "1be01da4",
"execution_count": 6,
"outputs": [
{
"output_type": "stream",
"name": "stdout",
"text": [
"Warning 6: Normalized/laundered field name: 'nombre_geografico' to 'nombre_geo'\n",
"Warning 6: Normalized/laundered field name: 'tipo_asentamiento' to 'tipo_asent'\n",
"Warning 6: Normalized/laundered field name: 'codigo_asentamiento' to 'codigo_ase'\n",
"Warning 6: Normalized/laundered field name: 'nombre_aglomerado' to 'nombre_agl'\n",
"Warning 6: Normalized/laundered field name: 'codigo_aglomerado' to 'codigo_agl'\n",
"Warning 6: Normalized/laundered field name: 'nombre_departamento' to 'nombre_dep'\n",
"Warning 6: Normalized/laundered field name: 'codigo_indec_departamento' to 'codigo_ind'\n",
"Warning 6: Normalized/laundered field name: 'nombre_provincia' to 'nombre_pro'\n",
"Warning 6: Normalized/laundered field name: 'codigo_indec_provincia' to 'codigo_i_1'\n",
"Warning 6: Normalized/laundered field name: 'latitud_grado_decimal' to 'latitud_gr'\n",
"Warning 6: Normalized/laundered field name: 'longitud_grado_decimal' to 'longitud_g'\n",
"Warning 6: Normalized/laundered field name: 'latitud_grado_sexagecimal' to 'latitud__1'\n",
"Warning 6: Normalized/laundered field name: 'longitud_grado_sexagecimal' to 'longitud_1'\n",
"Warning 6: Normalized/laundered field name: 'fuente_ubicacion' to 'fuente_ubi'\n",
"Warning 1: One or several characters couldn't be converted correctly from UTF-8 to ISO-8859-1. This warning will not be emitted anymore.\n"
]
}
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "7635db20"
},
"source": [
"# En el PGDump, \n",
"\n",
"Que es una secuencia de comandos para cargar en una base de datos,\n",
"La proyección está referenciada por su ID en EPSG"
],
"id": "7635db20"
},
{
"cell_type": "code",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "fa76eddf",
"outputId": "a897dfe3-7710-45f7-89df-4691b822fce1"
},
"source": [
"!head -n 24 features.sql"
],
"id": "fa76eddf",
"execution_count": 8,
"outputs": [
{
"output_type": "stream",
"name": "stdout",
"text": [
"SET standard_conforming_strings = OFF;\n",
"DROP TABLE IF EXISTS \"public\".\"features\" CASCADE;\n",
"DELETE FROM geometry_columns WHERE f_table_name = 'features' AND f_table_schema = 'public';\n",
"BEGIN;\n",
"CREATE TABLE \"public\".\"features\" ( \"ogc_fid\" SERIAL, CONSTRAINT \"features_pk\" PRIMARY KEY (\"ogc_fid\") );\n",
"SELECT AddGeometryColumn('public','features','wkb_geometry',4326,'MULTIPOINT',2);\n",
"CREATE INDEX \"features_wkb_geometry_geom_idx\" ON \"public\".\"features\" USING GIST (\"wkb_geometry\");\n",
"ALTER TABLE \"public\".\"features\" ADD COLUMN \"id\" VARCHAR;\n",
"ALTER TABLE \"public\".\"features\" ADD COLUMN \"gid\" INTEGER;\n",
"ALTER TABLE \"public\".\"features\" ADD COLUMN \"nombre_geografico\" VARCHAR;\n",
"ALTER TABLE \"public\".\"features\" ADD COLUMN \"tipo_asentamiento\" VARCHAR;\n",
"ALTER TABLE \"public\".\"features\" ADD COLUMN \"codigo_asentamiento\" VARCHAR;\n",
"ALTER TABLE \"public\".\"features\" ADD COLUMN \"nombre_aglomerado\" VARCHAR;\n",
"ALTER TABLE \"public\".\"features\" ADD COLUMN \"codigo_aglomerado\" VARCHAR;\n",
"ALTER TABLE \"public\".\"features\" ADD COLUMN \"nombre_departamento\" VARCHAR;\n",
"ALTER TABLE \"public\".\"features\" ADD COLUMN \"codigo_indec_departamento\" VARCHAR;\n",
"ALTER TABLE \"public\".\"features\" ADD COLUMN \"nombre_provincia\" VARCHAR;\n",
"ALTER TABLE \"public\".\"features\" ADD COLUMN \"codigo_indec_provincia\" VARCHAR;\n",
"ALTER TABLE \"public\".\"features\" ADD COLUMN \"latitud_grado_decimal\" VARCHAR;\n",
"ALTER TABLE \"public\".\"features\" ADD COLUMN \"longitud_grado_decimal\" VARCHAR;\n",
"ALTER TABLE \"public\".\"features\" ADD COLUMN \"latitud_grado_sexagecimal\" VARCHAR;\n",
"ALTER TABLE \"public\".\"features\" ADD COLUMN \"longitud_grado_sexagecimal\" VARCHAR;\n",
"ALTER TABLE \"public\".\"features\" ADD COLUMN \"fuente_ubicacion\" VARCHAR;\n",
"INSERT INTO \"public\".\"features\" (\"wkb_geometry\" , \"id\", \"gid\", \"nombre_geografico\", \"tipo_asentamiento\", \"codigo_asentamiento\", \"nombre_aglomerado\", \"codigo_aglomerado\", \"nombre_departamento\", \"codigo_indec_departamento\", \"nombre_provincia\", \"codigo_indec_provincia\", \"latitud_grado_decimal\", \"longitud_grado_decimal\", \"latitud_grado_sexagecimal\", \"longitud_grado_sexagecimal\", \"fuente_ubicacion\") VALUES ('0104000020E6100000010000000101000000B2C68FE7E95D4EC0D7F0BA9F4F1941C0', 'localidad_bahra.2218', 2218, 'Rojas', 'Localidad simple', '06686060', 'Rojas', '0151', 'Rojas', '06686', 'Buenos Aires', '06', '-34.197742', '-60.733701', '-34º11''52\"', '-60º44'' 1\"', 'INDEC');\n"
]
}
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "35f5cd13"
},
"source": [
"# En el archivo gml\n",
"\n",
"También se referencia la proyección según su numero"
],
"id": "35f5cd13"
},
{
"cell_type": "code",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "a567e9ec",
"outputId": "8f94daa1-c3f2-46df-f2c1-a74b1795ecb6"
},
"source": [
"!head -n 30 features.gml"
],
"id": "a567e9ec",
"execution_count": 9,
"outputs": [
{
"output_type": "stream",
"name": "stdout",
"text": [
"<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n",
"<ogr:FeatureCollection\n",
" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n",
" xsi:schemaLocation=\"http://ogr.maptools.org/ features.xsd\"\n",
" xmlns:ogr=\"http://ogr.maptools.org/\"\n",
" xmlns:gml=\"http://www.opengis.net/gml\">\n",
" <gml:boundedBy>\n",
" <gml:Box>\n",
" <gml:coord><gml:X>-72.88591142</gml:X><gml:Y>-54.80740398</gml:Y></gml:coord>\n",
" <gml:coord><gml:X>-53.64673457</gml:X><gml:Y>-21.87680153</gml:Y></gml:coord>\n",
" </gml:Box>\n",
" </gml:boundedBy>\n",
" \n",
" <gml:featureMember>\n",
" <ogr:features fid=\"features.0\">\n",
" <ogr:geometryProperty><gml:MultiPoint srsName=\"EPSG:4326\"><gml:pointMember><gml:Point><gml:coordinates>-60.7337007,-34.19774243</gml:coordinates></gml:Point></gml:pointMember></gml:MultiPoint></ogr:geometryProperty>\n",
" <ogr:id>localidad_bahra.2218</ogr:id>\n",
" <ogr:gid>2218</ogr:gid>\n",
" <ogr:nombre_geografico>Rojas</ogr:nombre_geografico>\n",
" <ogr:tipo_asentamiento>Localidad simple</ogr:tipo_asentamiento>\n",
" <ogr:codigo_asentamiento>06686060</ogr:codigo_asentamiento>\n",
" <ogr:nombre_aglomerado>Rojas</ogr:nombre_aglomerado>\n",
" <ogr:codigo_aglomerado>0151</ogr:codigo_aglomerado>\n",
" <ogr:nombre_departamento>Rojas</ogr:nombre_departamento>\n",
" <ogr:codigo_indec_departamento>06686</ogr:codigo_indec_departamento>\n",
" <ogr:nombre_provincia>Buenos Aires</ogr:nombre_provincia>\n",
" <ogr:codigo_indec_provincia>06</ogr:codigo_indec_provincia>\n",
" <ogr:latitud_grado_decimal>-34.197742</ogr:latitud_grado_decimal>\n",
" <ogr:longitud_grado_decimal>-60.733701</ogr:longitud_grado_decimal>\n",
" <ogr:latitud_grado_sexagecimal>-34º11'52&quot;</ogr:latitud_grado_sexagecimal>\n"
]
}
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "3a08d929"
},
"source": [
"Podemos verificarlo con ogrinfo que extrae los metadatos del archivo"
],
"id": "3a08d929"
},
{
"cell_type": "code",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "b0b1c960",
"outputId": "21007cc4-878a-4aa1-ed0d-22ccc36ca6d8"
},
"source": [
"!ogrinfo features.gml -al | sed '/OGRFeature/q'"
],
"id": "b0b1c960",
"execution_count": 10,
"outputs": [
{
"output_type": "stream",
"name": "stdout",
"text": [
"Had to open data source read-only.\n",
"INFO: Open of `features.gml'\n",
" using driver `GML' successful.\n",
"\n",
"Layer name: features\n",
"Geometry: Multi Point\n",
"Feature Count: 3528\n",
"Extent: (-72.885911, -54.807404) - (-53.646735, -21.876802)\n",
"Layer SRS WKT:\n",
"(unknown)\n",
"Geometry Column = geometryProperty\n",
"fid: String (0.0) NOT NULL\n",
"id: String (0.0)\n",
"gid: Integer (16.0)\n",
"nombre_geografico: String (0.0)\n",
"tipo_asentamiento: String (0.0)\n",
"codigo_asentamiento: String (0.0)\n",
"nombre_aglomerado: String (0.0)\n",
"codigo_aglomerado: String (0.0)\n",
"nombre_departamento: String (0.0)\n",
"codigo_indec_departamento: String (0.0)\n",
"nombre_provincia: String (0.0)\n",
"codigo_indec_provincia: String (0.0)\n",
"latitud_grado_decimal: String (0.0)\n",
"longitud_grado_decimal: String (0.0)\n",
"latitud_grado_sexagecimal: String (0.0)\n",
"longitud_grado_sexagecimal: String (0.0)\n",
"fuente_ubicacion: String (0.0)\n",
"OGRFeature(features):0\n"
]
}
]
},
{
"cell_type": "markdown",
"metadata": {
"lines_to_next_cell": 0,
"id": "84f12de0"
},
"source": [
"# El archivo Shapefile\n",
"\n",
"Tiene un archivo .prj asociado, donde se especifica la referencia geográfica\n",
"en WKT."
],
"id": "84f12de0"
},
{
"cell_type": "code",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "145f9bad",
"outputId": "f349507c-4301-4c86-fd1f-93634e59008a"
},
"source": [
"!cat features.prj"
],
"id": "145f9bad",
"execution_count": 11,
"outputs": [
{
"output_type": "stream",
"name": "stdout",
"text": [
"GEOGCS[\"GCS_WGS_1984\",DATUM[\"D_WGS_1984\",SPHEROID[\"WGS_1984\",6378137,298.257223563]],PRIMEM[\"Greenwich\",0],UNIT[\"Degree\",0.017453292519943295]]"
]
}
]
},
{
"cell_type": "markdown",
"metadata": {
"lines_to_next_cell": 0,
"id": "9612e9f0"
},
"source": [
"# El Geojson\n",
"\n",
"Utiliza un formato específico de OGC, urn:...."
],
"id": "9612e9f0"
},
{
"cell_type": "code",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "cd4be3a2",
"outputId": "3b846a2d-5416-403a-c9c7-00b412c34501"
},
"source": [
"!jq . features.json | tail -n 40"
],
"id": "cd4be3a2",
"execution_count": 19,
"outputs": [
{
"output_type": "stream",
"name": "stdout",
"text": [
" \"nombre_geografico\": \"Puerto Argentino\",\n",
" \"tipo_asentamiento\": \"Localidad simple\",\n",
" \"codigo_asentamiento\": \"94021010\",\n",
" \"nombre_aglomerado\": null,\n",
" \"codigo_aglomerado\": null,\n",
" \"nombre_departamento\": \"Islas del Atlántico Sur\",\n",
" \"codigo_indec_departamento\": \"94021\",\n",
" \"nombre_provincia\": \"Tierra del Fuego\",\n",
" \"codigo_indec_provincia\": \"94\",\n",
" \"latitud_grado_decimal\": \"-51.693679\",\n",
" \"longitud_grado_decimal\": \"-57.860855\",\n",
" \"latitud_grado_sexagecimal\": \"-51º41'37''\",\n",
" \"longitud_grado_sexagecimal\": null,\n",
" \"fuente_ubicacion\": \"IGN\"\n",
" },\n",
" \"bbox\": [\n",
" -57.8608555,\n",
" -51.69367913,\n",
" -57.8608555,\n",
" -51.69367913\n",
" ]\n",
" }\n",
" ],\n",
" \"totalFeatures\": 3528,\n",
" \"numberMatched\": 3528,\n",
" \"numberReturned\": 3528,\n",
" \"timeStamp\": \"2021-10-18T00:33:55.174Z\",\n",
" \"crs\": {\n",
" \"type\": \"name\",\n",
" \"properties\": {\n",
" \"name\": \"urn:ogc:def:crs:EPSG::4326\"\n",
" }\n",
" },\n",
" \"bbox\": [\n",
" -72.88591142,\n",
" -54.80740398,\n",
" -53.64673457,\n",
" -21.87680153\n",
" ]\n",
"}\n"
]
}
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "bcfc0ebb"
},
"source": [
"# En el kml \n",
"\n",
"No aparece referencia georgráfica, porque siempre usa el mismo sistema. \n",
"Cuando se genera el archivo siempre aparece convertido."
],
"id": "bcfc0ebb"
},
{
"cell_type": "code",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "78a9c1db",
"outputId": "a0af45eb-0da1-47a0-b00b-b3383203fe76"
},
"source": [
"!head -n 50 features.kml\n",
"!tail -n 50 features.kml"
],
"id": "78a9c1db",
"execution_count": 22,
"outputs": [
{
"output_type": "stream",
"name": "stdout",
"text": [
"<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n",
"<kml xmlns=\"http://www.opengis.net/kml/2.2\">\n",
"<Document id=\"root_doc\">\n",
"<Schema name=\"features\" id=\"features\">\n",
"\t<SimpleField name=\"id\" type=\"string\"></SimpleField>\n",
"\t<SimpleField name=\"gid\" type=\"int\"></SimpleField>\n",
"\t<SimpleField name=\"nombre_geografico\" type=\"string\"></SimpleField>\n",
"\t<SimpleField name=\"tipo_asentamiento\" type=\"string\"></SimpleField>\n",
"\t<SimpleField name=\"codigo_asentamiento\" type=\"string\"></SimpleField>\n",
"\t<SimpleField name=\"nombre_aglomerado\" type=\"string\"></SimpleField>\n",
"\t<SimpleField name=\"codigo_aglomerado\" type=\"string\"></SimpleField>\n",
"\t<SimpleField name=\"nombre_departamento\" type=\"string\"></SimpleField>\n",
"\t<SimpleField name=\"codigo_indec_departamento\" type=\"string\"></SimpleField>\n",
"\t<SimpleField name=\"nombre_provincia\" type=\"string\"></SimpleField>\n",
"\t<SimpleField name=\"codigo_indec_provincia\" type=\"string\"></SimpleField>\n",
"\t<SimpleField name=\"latitud_grado_decimal\" type=\"string\"></SimpleField>\n",
"\t<SimpleField name=\"longitud_grado_decimal\" type=\"string\"></SimpleField>\n",
"\t<SimpleField name=\"latitud_grado_sexagecimal\" type=\"string\"></SimpleField>\n",
"\t<SimpleField name=\"longitud_grado_sexagecimal\" type=\"string\"></SimpleField>\n",
"\t<SimpleField name=\"fuente_ubicacion\" type=\"string\"></SimpleField>\n",
"</Schema>\n",
"<Folder><name>features</name>\n",
" <Placemark>\n",
"\t<ExtendedData><SchemaData schemaUrl=\"#features\">\n",
"\t\t<SimpleData name=\"id\">localidad_bahra.2218</SimpleData>\n",
"\t\t<SimpleData name=\"gid\">2218</SimpleData>\n",
"\t\t<SimpleData name=\"nombre_geografico\">Rojas</SimpleData>\n",
"\t\t<SimpleData name=\"tipo_asentamiento\">Localidad simple</SimpleData>\n",
"\t\t<SimpleData name=\"codigo_asentamiento\">06686060</SimpleData>\n",
"\t\t<SimpleData name=\"nombre_aglomerado\">Rojas</SimpleData>\n",
"\t\t<SimpleData name=\"codigo_aglomerado\">0151</SimpleData>\n",
"\t\t<SimpleData name=\"nombre_departamento\">Rojas</SimpleData>\n",
"\t\t<SimpleData name=\"codigo_indec_departamento\">06686</SimpleData>\n",
"\t\t<SimpleData name=\"nombre_provincia\">Buenos Aires</SimpleData>\n",
"\t\t<SimpleData name=\"codigo_indec_provincia\">06</SimpleData>\n",
"\t\t<SimpleData name=\"latitud_grado_decimal\">-34.197742</SimpleData>\n",
"\t\t<SimpleData name=\"longitud_grado_decimal\">-60.733701</SimpleData>\n",
"\t\t<SimpleData name=\"latitud_grado_sexagecimal\">-34º11'52&quot;</SimpleData>\n",
"\t\t<SimpleData name=\"longitud_grado_sexagecimal\">-60º44' 1&quot;</SimpleData>\n",
"\t\t<SimpleData name=\"fuente_ubicacion\">INDEC</SimpleData>\n",
"\t</SchemaData></ExtendedData>\n",
" <MultiGeometry><Point><coordinates>-60.7337007,-34.19774243</coordinates></Point></MultiGeometry>\n",
" </Placemark>\n",
" <Placemark>\n",
"\t<ExtendedData><SchemaData schemaUrl=\"#features\">\n",
"\t\t<SimpleData name=\"id\">localidad_bahra.11665</SimpleData>\n",
"\t\t<SimpleData name=\"gid\">11665</SimpleData>\n",
"\t\t<SimpleData name=\"nombre_geografico\">Bouquet</SimpleData>\n",
"\t\t<SimpleData name=\"tipo_asentamiento\">Localidad simple</SimpleData>\n",
"\t\t<SimpleData name=\"codigo_asentamiento\">82007020</SimpleData>\n",
"\t\t<SimpleData name=\"longitud_grado_decimal\">-67.762905</SimpleData>\n",
"\t\t<SimpleData name=\"latitud_grado_sexagecimal\">-54º38'27&quot;</SimpleData>\n",
"\t\t<SimpleData name=\"longitud_grado_sexagecimal\">-67º45'46&quot;</SimpleData>\n",
"\t\t<SimpleData name=\"fuente_ubicacion\">INDEC</SimpleData>\n",
"\t</SchemaData></ExtendedData>\n",
" <MultiGeometry><Point><coordinates>-67.76290453,-54.64078327</coordinates></Point></MultiGeometry>\n",
" </Placemark>\n",
" <Placemark>\n",
"\t<ExtendedData><SchemaData schemaUrl=\"#features\">\n",
"\t\t<SimpleData name=\"id\">localidad_bahra.14672</SimpleData>\n",
"\t\t<SimpleData name=\"gid\">14672</SimpleData>\n",
"\t\t<SimpleData name=\"nombre_geografico\">Ciudad de Buenos Aires</SimpleData>\n",
"\t\t<SimpleData name=\"tipo_asentamiento\">Componente de localidad compuesta</SimpleData>\n",
"\t\t<SimpleData name=\"codigo_asentamiento\">02002010</SimpleData>\n",
"\t\t<SimpleData name=\"nombre_aglomerado\">Gran Buenos Aires</SimpleData>\n",
"\t\t<SimpleData name=\"codigo_aglomerado\">0001</SimpleData>\n",
"\t\t<SimpleData name=\"nombre_departamento\">Comuna 1,Comuna 10,Comuna 11,Comuna 12,Comuna 13,Comuna 14,Comuna 15,Comuna 2,Comuna 3,Comuna 4,Comuna 5,Comuna 6,Comuna 7,Comuna 8,Comuna 9\n",
"</SimpleData>\n",
"\t\t<SimpleData name=\"codigo_indec_departamento\">02001,02002,02003,02004,02005,02006,02007,02008,02009,02010,02011,02012,02013,02014,02015\n",
"</SimpleData>\n",
"\t\t<SimpleData name=\"nombre_provincia\">Ciudad de Buenos Aires</SimpleData>\n",
"\t\t<SimpleData name=\"codigo_indec_provincia\">02</SimpleData>\n",
"\t\t<SimpleData name=\"latitud_grado_decimal\">-34.608416</SimpleData>\n",
"\t\t<SimpleData name=\"longitud_grado_decimal\">-58.372135</SimpleData>\n",
"\t\t<SimpleData name=\"latitud_grado_sexagecimal\">-34º36'30&quot;</SimpleData>\n",
"\t\t<SimpleData name=\"longitud_grado_sexagecimal\">-58º22'20&quot;</SimpleData>\n",
"\t\t<SimpleData name=\"fuente_ubicacion\">INDEC</SimpleData>\n",
"\t</SchemaData></ExtendedData>\n",
" <MultiGeometry><Point><coordinates>-58.37213468,-34.60841638</coordinates></Point></MultiGeometry>\n",
" </Placemark>\n",
" <Placemark>\n",
"\t<ExtendedData><SchemaData schemaUrl=\"#features\">\n",
"\t\t<SimpleData name=\"id\">localidad_bahra.14673</SimpleData>\n",
"\t\t<SimpleData name=\"gid\">14673</SimpleData>\n",
"\t\t<SimpleData name=\"nombre_geografico\">Puerto Argentino</SimpleData>\n",
"\t\t<SimpleData name=\"tipo_asentamiento\">Localidad simple</SimpleData>\n",
"\t\t<SimpleData name=\"codigo_asentamiento\">94021010</SimpleData>\n",
"\t\t<SimpleData name=\"nombre_departamento\">Islas del Atlántico Sur</SimpleData>\n",
"\t\t<SimpleData name=\"codigo_indec_departamento\">94021</SimpleData>\n",
"\t\t<SimpleData name=\"nombre_provincia\">Tierra del Fuego</SimpleData>\n",
"\t\t<SimpleData name=\"codigo_indec_provincia\">94</SimpleData>\n",
"\t\t<SimpleData name=\"latitud_grado_decimal\">-51.693679</SimpleData>\n",
"\t\t<SimpleData name=\"longitud_grado_decimal\">-57.860855</SimpleData>\n",
"\t\t<SimpleData name=\"latitud_grado_sexagecimal\">-51º41'37''</SimpleData>\n",
"\t\t<SimpleData name=\"fuente_ubicacion\">IGN</SimpleData>\n",
"\t</SchemaData></ExtendedData>\n",
" <MultiGeometry><Point><coordinates>-57.8608555,-51.69367913</coordinates></Point></MultiGeometry>\n",
" </Placemark>\n",
"</Folder>\n",
"</Document></kml>\n"
]
}
]
},
{
"cell_type": "code",
"metadata": {
"id": "ZPAMtEMG1-rd"
},
"source": [
""
],
"id": "ZPAMtEMG1-rd",
"execution_count": null,
"outputs": []
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment