DataIngestionGrowingRegion.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "fb32b4db",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "pd.set_option('display.max_rows', 500)\n",
    "import mysql.connector\n",
    "import geopandas as gpd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "d681eb0f",
   "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>CARUID</th>\n",
       "      <th>CARENAME</th>\n",
       "      <th>CARFNAME</th>\n",
       "      <th>PRUID</th>\n",
       "      <th>PRNAME</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1205</td>\n",
       "      <td>Agricultural Region 5</td>\n",
       "      <td>Région agricole 5</td>\n",
       "      <td>12</td>\n",
       "      <td>Nova Scotia / Nouvelle-Écosse</td>\n",
       "      <td>POLYGON ((8525489.391 1790548.500, 8525639.114...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1301</td>\n",
       "      <td>Agricultural Region 1</td>\n",
       "      <td>Région agricole 1</td>\n",
       "      <td>13</td>\n",
       "      <td>New Brunswick / Nouveau-Brunswick</td>\n",
       "      <td>POLYGON ((7998578.391 1612051.631, 7998668.814...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1302</td>\n",
       "      <td>Agricultural Region 2</td>\n",
       "      <td>Région agricole 2</td>\n",
       "      <td>13</td>\n",
       "      <td>New Brunswick / Nouveau-Brunswick</td>\n",
       "      <td>POLYGON ((8204574.134 1544487.454, 8208027.917...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1303</td>\n",
       "      <td>Agricultural Region 3</td>\n",
       "      <td>Région agricole 3</td>\n",
       "      <td>13</td>\n",
       "      <td>New Brunswick / Nouveau-Brunswick</td>\n",
       "      <td>POLYGON ((8217369.071 1620627.260, 8217713.531...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1304</td>\n",
       "      <td>Agricultural Region 4</td>\n",
       "      <td>Région agricole 4</td>\n",
       "      <td>13</td>\n",
       "      <td>New Brunswick / Nouveau-Brunswick</td>\n",
       "      <td>POLYGON ((8188457.820 1707919.583, 8188444.194...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2401</td>\n",
       "      <td>Bas-Saint-Laurent</td>\n",
       "      <td>Bas-Saint-Laurent</td>\n",
       "      <td>24</td>\n",
       "      <td>Quebec / Québec</td>\n",
       "      <td>POLYGON ((7983960.509 1783925.871, 7985523.191...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2402</td>\n",
       "      <td>Saguenay--Lac-Saint-Jean--Côte-Nord</td>\n",
       "      <td>Saguenay--Lac-Saint-Jean--Côte-Nord</td>\n",
       "      <td>24</td>\n",
       "      <td>Quebec / Québec</td>\n",
       "      <td>MULTIPOLYGON (((8449366.226 2385149.363, 84505...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2403</td>\n",
       "      <td>Québec</td>\n",
       "      <td>Québec</td>\n",
       "      <td>24</td>\n",
       "      <td>Quebec / Québec</td>\n",
       "      <td>POLYGON ((7811516.777 1616612.783, 7813390.280...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2404</td>\n",
       "      <td>Mauricie</td>\n",
       "      <td>Mauricie</td>\n",
       "      <td>24</td>\n",
       "      <td>Quebec / Québec</td>\n",
       "      <td>POLYGON ((7459301.751 1597664.723, 7459403.646...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2405</td>\n",
       "      <td>Estrie</td>\n",
       "      <td>Estrie</td>\n",
       "      <td>24</td>\n",
       "      <td>Quebec / Québec</td>\n",
       "      <td>POLYGON ((7854287.706 1351074.386, 7854803.251...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2406</td>\n",
       "      <td>Montréal--Laval</td>\n",
       "      <td>Montréal--Laval</td>\n",
       "      <td>24</td>\n",
       "      <td>Quebec / Québec</td>\n",
       "      <td>POLYGON ((7632385.269 1268099.211, 7632355.463...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2407</td>\n",
       "      <td>Lanaudière</td>\n",
       "      <td>Lanaudière</td>\n",
       "      <td>24</td>\n",
       "      <td>Quebec / Québec</td>\n",
       "      <td>POLYGON ((7494000.817 1466728.294, 7494089.857...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2408</td>\n",
       "      <td>Outaouais</td>\n",
       "      <td>Outaouais</td>\n",
       "      <td>24</td>\n",
       "      <td>Quebec / Québec</td>\n",
       "      <td>POLYGON ((7417836.414 1448561.194, 7417214.306...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2409</td>\n",
       "      <td>Laurentides</td>\n",
       "      <td>Laurentides</td>\n",
       "      <td>24</td>\n",
       "      <td>Quebec / Québec</td>\n",
       "      <td>POLYGON ((7480340.943 1451311.980, 7481653.474...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2410</td>\n",
       "      <td>Abitibi-Témiscamingue--Nord-du-Québec</td>\n",
       "      <td>Abitibi-Témiscamingue--Nord-du-Québec</td>\n",
       "      <td>24</td>\n",
       "      <td>Quebec / Québec</td>\n",
       "      <td>POLYGON ((7143607.286 3010209.309, 7149855.863...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2411</td>\n",
       "      <td>Gaspésie--Îles-de-la-Madeleine</td>\n",
       "      <td>Gaspésie--Îles-de-la-Madeleine</td>\n",
       "      <td>24</td>\n",
       "      <td>Quebec / Québec</td>\n",
       "      <td>MULTIPOLYGON (((8118937.531 1865516.623, 81189...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2412</td>\n",
       "      <td>Chaudière-Appalaches</td>\n",
       "      <td>Chaudière-Appalaches</td>\n",
       "      <td>24</td>\n",
       "      <td>Quebec / Québec</td>\n",
       "      <td>POLYGON ((7825812.920 1523677.477, 7826570.777...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2413</td>\n",
       "      <td>Montérégie</td>\n",
       "      <td>Montérégie</td>\n",
       "      <td>24</td>\n",
       "      <td>Quebec / Québec</td>\n",
       "      <td>POLYGON ((7658841.323 1321633.289, 7658863.331...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2414</td>\n",
       "      <td>Centre-du-Québec</td>\n",
       "      <td>Centre-du-Québec</td>\n",
       "      <td>24</td>\n",
       "      <td>Quebec / Québec</td>\n",
       "      <td>POLYGON ((7711256.483 1393539.114, 7711264.229...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>3501</td>\n",
       "      <td>Southern Ontario Region</td>\n",
       "      <td>Région du Sud de l'Ontario</td>\n",
       "      <td>35</td>\n",
       "      <td>Ontario</td>\n",
       "      <td>POLYGON ((7192649.137 886943.691, 7192658.017 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>3502</td>\n",
       "      <td>Western Ontario Region</td>\n",
       "      <td>Région de l'Ouest de l'Ontario</td>\n",
       "      <td>35</td>\n",
       "      <td>Ontario</td>\n",
       "      <td>POLYGON ((7067798.240 1083586.060, 7070871.029...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>3503</td>\n",
       "      <td>Central Ontario Region</td>\n",
       "      <td>Région du Centre de l'Ontario</td>\n",
       "      <td>35</td>\n",
       "      <td>Ontario</td>\n",
       "      <td>POLYGON ((7169056.906 1216085.683, 7169392.609...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>3504</td>\n",
       "      <td>Eastern Ontario Region</td>\n",
       "      <td>Région de l'Est de l'Ontario</td>\n",
       "      <td>35</td>\n",
       "      <td>Ontario</td>\n",
       "      <td>POLYGON ((7267538.923 1237671.437, 7269021.437...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>3505</td>\n",
       "      <td>Northern Ontario Region</td>\n",
       "      <td>Région du Nord de l'Ontario</td>\n",
       "      <td>35</td>\n",
       "      <td>Ontario</td>\n",
       "      <td>POLYGON ((6378815.614 2295412.440, 6378746.814...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>4601</td>\n",
       "      <td>Agricultural Region 1</td>\n",
       "      <td>Région agricole 1</td>\n",
       "      <td>46</td>\n",
       "      <td>Manitoba</td>\n",
       "      <td>POLYGON ((5562870.440 1532574.780, 5562908.066...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>4602</td>\n",
       "      <td>Agricultural Region 2</td>\n",
       "      <td>Région agricole 2</td>\n",
       "      <td>46</td>\n",
       "      <td>Manitoba</td>\n",
       "      <td>MULTIPOLYGON (((5655631.591 1599562.029, 56557...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>4603</td>\n",
       "      <td>Agricultural Region 3</td>\n",
       "      <td>Région agricole 3</td>\n",
       "      <td>46</td>\n",
       "      <td>Manitoba</td>\n",
       "      <td>POLYGON ((5612573.023 1654348.289, 5612632.997...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>4604</td>\n",
       "      <td>Agricultural Region 4</td>\n",
       "      <td>Région agricole 4</td>\n",
       "      <td>46</td>\n",
       "      <td>Manitoba</td>\n",
       "      <td>POLYGON ((5557425.843 1766740.606, 5557876.357...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>4605</td>\n",
       "      <td>Agricultural Region 5</td>\n",
       "      <td>Région agricole 5</td>\n",
       "      <td>46</td>\n",
       "      <td>Manitoba</td>\n",
       "      <td>POLYGON ((5558796.551 1895845.191, 5559127.694...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>4606</td>\n",
       "      <td>Agricultural Region 6</td>\n",
       "      <td>Région agricole 6</td>\n",
       "      <td>46</td>\n",
       "      <td>Manitoba</td>\n",
       "      <td>POLYGON ((5650771.940 1802331.591, 5650891.340...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>4607</td>\n",
       "      <td>Agricultural Region 7</td>\n",
       "      <td>Région agricole 7</td>\n",
       "      <td>46</td>\n",
       "      <td>Manitoba</td>\n",
       "      <td>POLYGON ((5679331.449 1641141.903, 5680237.029...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>4608</td>\n",
       "      <td>Agricultural Region 8</td>\n",
       "      <td>Région agricole 8</td>\n",
       "      <td>46</td>\n",
       "      <td>Manitoba</td>\n",
       "      <td>POLYGON ((5777322.629 1512527.626, 5777303.520...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>4609</td>\n",
       "      <td>Agricultural Region 9</td>\n",
       "      <td>Région agricole 9</td>\n",
       "      <td>46</td>\n",
       "      <td>Manitoba</td>\n",
       "      <td>POLYGON ((5870765.929 1583233.997, 5871226.809...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>4610</td>\n",
       "      <td>Agricultural Region 10</td>\n",
       "      <td>Région agricole 10</td>\n",
       "      <td>46</td>\n",
       "      <td>Manitoba</td>\n",
       "      <td>POLYGON ((5873864.783 1637832.080, 5874194.457...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>4611</td>\n",
       "      <td>Agricultural Region 11</td>\n",
       "      <td>Région agricole 11</td>\n",
       "      <td>46</td>\n",
       "      <td>Manitoba</td>\n",
       "      <td>POLYGON ((5839858.777 1608473.626, 5840487.871...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>4612</td>\n",
       "      <td>Agricultural Region 12</td>\n",
       "      <td>Région agricole 12</td>\n",
       "      <td>46</td>\n",
       "      <td>Manitoba</td>\n",
       "      <td>POLYGON ((6039656.509 2636304.343, 6039620.443...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>4701</td>\n",
       "      <td>Agricultural Region 1</td>\n",
       "      <td>Région agricole 1</td>\n",
       "      <td>47</td>\n",
       "      <td>Saskatchewan</td>\n",
       "      <td>POLYGON ((5430601.546 1846035.049, 5430608.446...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>4702</td>\n",
       "      <td>Agricultural Region 2</td>\n",
       "      <td>Région agricole 2</td>\n",
       "      <td>47</td>\n",
       "      <td>Saskatchewan</td>\n",
       "      <td>POLYGON ((5253247.371 1763719.194, 5253324.311...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>4703</td>\n",
       "      <td>Agricultural Region 3</td>\n",
       "      <td>Région agricole 3</td>\n",
       "      <td>47</td>\n",
       "      <td>Saskatchewan</td>\n",
       "      <td>POLYGON ((4988242.323 1860657.677, 4988244.780...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>4704</td>\n",
       "      <td>Agricultural Region 4</td>\n",
       "      <td>Région agricole 4</td>\n",
       "      <td>47</td>\n",
       "      <td>Saskatchewan</td>\n",
       "      <td>POLYGON ((5033127.871 2038855.063, 5033179.086...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>4705</td>\n",
       "      <td>Agricultural Region 5</td>\n",
       "      <td>Région agricole 5</td>\n",
       "      <td>47</td>\n",
       "      <td>Saskatchewan</td>\n",
       "      <td>POLYGON ((5438452.149 2011470.549, 5438186.106...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>4706</td>\n",
       "      <td>Agricultural Region 6</td>\n",
       "      <td>Région agricole 6</td>\n",
       "      <td>47</td>\n",
       "      <td>Saskatchewan</td>\n",
       "      <td>POLYGON ((5069906.640 2212621.191, 5070955.526...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>4707</td>\n",
       "      <td>Agricultural Region 7</td>\n",
       "      <td>Région agricole 7</td>\n",
       "      <td>47</td>\n",
       "      <td>Saskatchewan</td>\n",
       "      <td>POLYGON ((5248633.914 2767057.263, 5249285.640...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>4810</td>\n",
       "      <td>Agricultural Region 1</td>\n",
       "      <td>Région agricole 1</td>\n",
       "      <td>48</td>\n",
       "      <td>Alberta</td>\n",
       "      <td>POLYGON ((4926800.134 1979203.977, 4926825.983...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>4820</td>\n",
       "      <td>Agricultural Region 2</td>\n",
       "      <td>Région agricole 2</td>\n",
       "      <td>48</td>\n",
       "      <td>Alberta</td>\n",
       "      <td>POLYGON ((4757911.131 2003278.000, 4757911.149...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>4830</td>\n",
       "      <td>Agricultural Region 3</td>\n",
       "      <td>Région agricole 3</td>\n",
       "      <td>48</td>\n",
       "      <td>Alberta</td>\n",
       "      <td>POLYGON ((4452472.249 2307439.651, 4453182.789...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>4840</td>\n",
       "      <td>Agricultural Region 4A</td>\n",
       "      <td>Région agricole 4A</td>\n",
       "      <td>48</td>\n",
       "      <td>Alberta</td>\n",
       "      <td>POLYGON ((4923727.731 2060739.871, 4923972.617...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>4841</td>\n",
       "      <td>Agricultural Region 4B</td>\n",
       "      <td>Région agricole 4B</td>\n",
       "      <td>48</td>\n",
       "      <td>Alberta</td>\n",
       "      <td>POLYGON ((4889307.549 2195049.694, 4889375.091...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>4850</td>\n",
       "      <td>Agricultural Region 5</td>\n",
       "      <td>Région agricole 5</td>\n",
       "      <td>48</td>\n",
       "      <td>Alberta</td>\n",
       "      <td>POLYGON ((4819297.311 2218897.894, 4820771.649...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>4860</td>\n",
       "      <td>Agricultural Region 6</td>\n",
       "      <td>Région agricole 6</td>\n",
       "      <td>48</td>\n",
       "      <td>Alberta</td>\n",
       "      <td>POLYGON ((5228304.177 2767597.891, 5228098.463...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>4870</td>\n",
       "      <td>Agricultural Region 7</td>\n",
       "      <td>Région agricole 7</td>\n",
       "      <td>48</td>\n",
       "      <td>Alberta</td>\n",
       "      <td>POLYGON ((4981679.743 2724461.931, 4980294.180...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>5901</td>\n",
       "      <td>Vancouver Island-Coast</td>\n",
       "      <td>Vancouver Island-Coast</td>\n",
       "      <td>59</td>\n",
       "      <td>British Columbia / Colombie-Britannique</td>\n",
       "      <td>POLYGON ((3991663.969 2528376.829, 3992887.114...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>5902</td>\n",
       "      <td>Lower Mainland-Southwest</td>\n",
       "      <td>Lower Mainland-Southwest</td>\n",
       "      <td>59</td>\n",
       "      <td>British Columbia / Colombie-Britannique</td>\n",
       "      <td>POLYGON ((4130403.431 2186768.054, 4131349.843...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>5903</td>\n",
       "      <td>Thompson-Okanagan</td>\n",
       "      <td>Thompson-Okanagan</td>\n",
       "      <td>59</td>\n",
       "      <td>British Columbia / Colombie-Britannique</td>\n",
       "      <td>POLYGON ((4375952.111 2269366.100, 4376642.717...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>5904</td>\n",
       "      <td>Kootenay</td>\n",
       "      <td>Kootenay</td>\n",
       "      <td>59</td>\n",
       "      <td>British Columbia / Colombie-Britannique</td>\n",
       "      <td>POLYGON ((4556246.526 2001695.963, 4556130.637...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>5905</td>\n",
       "      <td>Cariboo</td>\n",
       "      <td>Cariboo</td>\n",
       "      <td>59</td>\n",
       "      <td>British Columbia / Colombie-Britannique</td>\n",
       "      <td>POLYGON ((4329993.003 2673366.229, 4330170.811...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>5906</td>\n",
       "      <td>North Coast</td>\n",
       "      <td>North Coast</td>\n",
       "      <td>59</td>\n",
       "      <td>British Columbia / Colombie-Britannique</td>\n",
       "      <td>POLYGON ((4225567.209 3090162.077, 4178712.863...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>5907</td>\n",
       "      <td>Nechako</td>\n",
       "      <td>Nechako</td>\n",
       "      <td>59</td>\n",
       "      <td>British Columbia / Colombie-Britannique</td>\n",
       "      <td>POLYGON ((4018904.414 3410247.271, 4019429.869...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>5908</td>\n",
       "      <td>Peace River</td>\n",
       "      <td>Peace River</td>\n",
       "      <td>59</td>\n",
       "      <td>British Columbia / Colombie-Britannique</td>\n",
       "      <td>POLYGON ((4357078.791 3166775.097, 4357652.426...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>6001</td>\n",
       "      <td>Agricultural Region 1</td>\n",
       "      <td>Région agricole 1</td>\n",
       "      <td>60</td>\n",
       "      <td>Yukon</td>\n",
       "      <td>POLYGON ((4561932.471 4312865.174, 4564007.580...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>6101</td>\n",
       "      <td>Agricultural Region 1</td>\n",
       "      <td>Région agricole 1</td>\n",
       "      <td>61</td>\n",
       "      <td>Northwest Territories / Territoires du Nord-Ouest</td>\n",
       "      <td>POLYGON ((5689672.257 4324508.314, 5685498.029...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>6201</td>\n",
       "      <td>Agricultural Region 1</td>\n",
       "      <td>Région agricole 1</td>\n",
       "      <td>62</td>\n",
       "      <td>Nunavut</td>\n",
       "      <td>POLYGON ((7297737.369 3983558.454, 7316653.440...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>1001</td>\n",
       "      <td>Agricultural Region 1</td>\n",
       "      <td>Région agricole 1</td>\n",
       "      <td>10</td>\n",
       "      <td>Newfoundland and Labrador / Terre-Neuve-et-Lab...</td>\n",
       "      <td>POLYGON ((8936349.397 2205358.140, 8941041.589...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>1002</td>\n",
       "      <td>Agricultural Region 2</td>\n",
       "      <td>Région agricole 2</td>\n",
       "      <td>10</td>\n",
       "      <td>Newfoundland and Labrador / Terre-Neuve-et-Lab...</td>\n",
       "      <td>POLYGON ((8816520.789 2335270.254, 8821544.297...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>1003</td>\n",
       "      <td>Agricultural Region 3</td>\n",
       "      <td>Région agricole 3</td>\n",
       "      <td>10</td>\n",
       "      <td>Newfoundland and Labrador / Terre-Neuve-et-Lab...</td>\n",
       "      <td>POLYGON ((7644464.869 2980078.217, 7648864.423...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>1101</td>\n",
       "      <td>Agricultural Region 1</td>\n",
       "      <td>Région agricole 1</td>\n",
       "      <td>11</td>\n",
       "      <td>Prince Edward Island / Île-du-Prince-Édouard</td>\n",
       "      <td>POLYGON ((8427169.677 1633933.906, 8427164.649...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>1102</td>\n",
       "      <td>Agricultural Region 2</td>\n",
       "      <td>Région agricole 2</td>\n",
       "      <td>11</td>\n",
       "      <td>Prince Edward Island / Île-du-Prince-Édouard</td>\n",
       "      <td>POLYGON ((8382758.289 1638763.660, 8382833.617...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>1103</td>\n",
       "      <td>Agricultural Region 3</td>\n",
       "      <td>Région agricole 3</td>\n",
       "      <td>11</td>\n",
       "      <td>Prince Edward Island / Île-du-Prince-Édouard</td>\n",
       "      <td>POLYGON ((8294354.734 1636914.940, 8296485.909...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>1201</td>\n",
       "      <td>Agricultural Region 1</td>\n",
       "      <td>Région agricole 1</td>\n",
       "      <td>12</td>\n",
       "      <td>Nova Scotia / Nouvelle-Écosse</td>\n",
       "      <td>POLYGON ((8362506.940 1428541.960, 8367260.740...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>1202</td>\n",
       "      <td>Agricultural Region 2</td>\n",
       "      <td>Région agricole 2</td>\n",
       "      <td>12</td>\n",
       "      <td>Nova Scotia / Nouvelle-Écosse</td>\n",
       "      <td>POLYGON ((8389627.240 1508346.011, 8390011.831...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>1203</td>\n",
       "      <td>Agricultural Region 3</td>\n",
       "      <td>Région agricole 3</td>\n",
       "      <td>12</td>\n",
       "      <td>Nova Scotia / Nouvelle-Écosse</td>\n",
       "      <td>MULTIPOLYGON (((8381659.560 1574688.929, 83836...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>1204</td>\n",
       "      <td>Agricultural Region 4</td>\n",
       "      <td>Région agricole 4</td>\n",
       "      <td>12</td>\n",
       "      <td>Nova Scotia / Nouvelle-Écosse</td>\n",
       "      <td>POLYGON ((8494876.626 1635345.826, 8494939.046...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   CARUID                               CARENAME  \\\n",
       "0    1205                  Agricultural Region 5   \n",
       "1    1301                  Agricultural Region 1   \n",
       "2    1302                  Agricultural Region 2   \n",
       "3    1303                  Agricultural Region 3   \n",
       "4    1304                  Agricultural Region 4   \n",
       "5    2401                      Bas-Saint-Laurent   \n",
       "6    2402    Saguenay--Lac-Saint-Jean--Côte-Nord   \n",
       "7    2403                                 Québec   \n",
       "8    2404                               Mauricie   \n",
       "9    2405                                 Estrie   \n",
       "10   2406                        Montréal--Laval   \n",
       "11   2407                             Lanaudière   \n",
       "12   2408                              Outaouais   \n",
       "13   2409                            Laurentides   \n",
       "14   2410  Abitibi-Témiscamingue--Nord-du-Québec   \n",
       "15   2411         Gaspésie--Îles-de-la-Madeleine   \n",
       "16   2412                   Chaudière-Appalaches   \n",
       "17   2413                             Montérégie   \n",
       "18   2414                       Centre-du-Québec   \n",
       "19   3501                Southern Ontario Region   \n",
       "20   3502                 Western Ontario Region   \n",
       "21   3503                 Central Ontario Region   \n",
       "22   3504                 Eastern Ontario Region   \n",
       "23   3505                Northern Ontario Region   \n",
       "24   4601                  Agricultural Region 1   \n",
       "25   4602                  Agricultural Region 2   \n",
       "26   4603                  Agricultural Region 3   \n",
       "27   4604                  Agricultural Region 4   \n",
       "28   4605                  Agricultural Region 5   \n",
       "29   4606                  Agricultural Region 6   \n",
       "30   4607                  Agricultural Region 7   \n",
       "31   4608                  Agricultural Region 8   \n",
       "32   4609                  Agricultural Region 9   \n",
       "33   4610                 Agricultural Region 10   \n",
       "34   4611                 Agricultural Region 11   \n",
       "35   4612                 Agricultural Region 12   \n",
       "36   4701                  Agricultural Region 1   \n",
       "37   4702                  Agricultural Region 2   \n",
       "38   4703                  Agricultural Region 3   \n",
       "39   4704                  Agricultural Region 4   \n",
       "40   4705                  Agricultural Region 5   \n",
       "41   4706                  Agricultural Region 6   \n",
       "42   4707                  Agricultural Region 7   \n",
       "43   4810                  Agricultural Region 1   \n",
       "44   4820                  Agricultural Region 2   \n",
       "45   4830                  Agricultural Region 3   \n",
       "46   4840                 Agricultural Region 4A   \n",
       "47   4841                 Agricultural Region 4B   \n",
       "48   4850                  Agricultural Region 5   \n",
       "49   4860                  Agricultural Region 6   \n",
       "50   4870                  Agricultural Region 7   \n",
       "51   5901                 Vancouver Island-Coast   \n",
       "52   5902               Lower Mainland-Southwest   \n",
       "53   5903                      Thompson-Okanagan   \n",
       "54   5904                               Kootenay   \n",
       "55   5905                                Cariboo   \n",
       "56   5906                            North Coast   \n",
       "57   5907                                Nechako   \n",
       "58   5908                            Peace River   \n",
       "59   6001                  Agricultural Region 1   \n",
       "60   6101                  Agricultural Region 1   \n",
       "61   6201                  Agricultural Region 1   \n",
       "62   1001                  Agricultural Region 1   \n",
       "63   1002                  Agricultural Region 2   \n",
       "64   1003                  Agricultural Region 3   \n",
       "65   1101                  Agricultural Region 1   \n",
       "66   1102                  Agricultural Region 2   \n",
       "67   1103                  Agricultural Region 3   \n",
       "68   1201                  Agricultural Region 1   \n",
       "69   1202                  Agricultural Region 2   \n",
       "70   1203                  Agricultural Region 3   \n",
       "71   1204                  Agricultural Region 4   \n",
       "\n",
       "                                 CARFNAME PRUID  \\\n",
       "0                       Région agricole 5    12   \n",
       "1                       Région agricole 1    13   \n",
       "2                       Région agricole 2    13   \n",
       "3                       Région agricole 3    13   \n",
       "4                       Région agricole 4    13   \n",
       "5                       Bas-Saint-Laurent    24   \n",
       "6     Saguenay--Lac-Saint-Jean--Côte-Nord    24   \n",
       "7                                  Québec    24   \n",
       "8                                Mauricie    24   \n",
       "9                                  Estrie    24   \n",
       "10                        Montréal--Laval    24   \n",
       "11                             Lanaudière    24   \n",
       "12                              Outaouais    24   \n",
       "13                            Laurentides    24   \n",
       "14  Abitibi-Témiscamingue--Nord-du-Québec    24   \n",
       "15         Gaspésie--Îles-de-la-Madeleine    24   \n",
       "16                   Chaudière-Appalaches    24   \n",
       "17                             Montérégie    24   \n",
       "18                       Centre-du-Québec    24   \n",
       "19             Région du Sud de l'Ontario    35   \n",
       "20         Région de l'Ouest de l'Ontario    35   \n",
       "21          Région du Centre de l'Ontario    35   \n",
       "22           Région de l'Est de l'Ontario    35   \n",
       "23            Région du Nord de l'Ontario    35   \n",
       "24                      Région agricole 1    46   \n",
       "25                      Région agricole 2    46   \n",
       "26                      Région agricole 3    46   \n",
       "27                      Région agricole 4    46   \n",
       "28                      Région agricole 5    46   \n",
       "29                      Région agricole 6    46   \n",
       "30                      Région agricole 7    46   \n",
       "31                      Région agricole 8    46   \n",
       "32                      Région agricole 9    46   \n",
       "33                     Région agricole 10    46   \n",
       "34                     Région agricole 11    46   \n",
       "35                     Région agricole 12    46   \n",
       "36                      Région agricole 1    47   \n",
       "37                      Région agricole 2    47   \n",
       "38                      Région agricole 3    47   \n",
       "39                      Région agricole 4    47   \n",
       "40                      Région agricole 5    47   \n",
       "41                      Région agricole 6    47   \n",
       "42                      Région agricole 7    47   \n",
       "43                      Région agricole 1    48   \n",
       "44                      Région agricole 2    48   \n",
       "45                      Région agricole 3    48   \n",
       "46                     Région agricole 4A    48   \n",
       "47                     Région agricole 4B    48   \n",
       "48                      Région agricole 5    48   \n",
       "49                      Région agricole 6    48   \n",
       "50                      Région agricole 7    48   \n",
       "51                 Vancouver Island-Coast    59   \n",
       "52               Lower Mainland-Southwest    59   \n",
       "53                      Thompson-Okanagan    59   \n",
       "54                               Kootenay    59   \n",
       "55                                Cariboo    59   \n",
       "56                            North Coast    59   \n",
       "57                                Nechako    59   \n",
       "58                            Peace River    59   \n",
       "59                      Région agricole 1    60   \n",
       "60                      Région agricole 1    61   \n",
       "61                      Région agricole 1    62   \n",
       "62                      Région agricole 1    10   \n",
       "63                      Région agricole 2    10   \n",
       "64                      Région agricole 3    10   \n",
       "65                      Région agricole 1    11   \n",
       "66                      Région agricole 2    11   \n",
       "67                      Région agricole 3    11   \n",
       "68                      Région agricole 1    12   \n",
       "69                      Région agricole 2    12   \n",
       "70                      Région agricole 3    12   \n",
       "71                      Région agricole 4    12   \n",
       "\n",
       "                                               PRNAME  \\\n",
       "0                       Nova Scotia / Nouvelle-Écosse   \n",
       "1                   New Brunswick / Nouveau-Brunswick   \n",
       "2                   New Brunswick / Nouveau-Brunswick   \n",
       "3                   New Brunswick / Nouveau-Brunswick   \n",
       "4                   New Brunswick / Nouveau-Brunswick   \n",
       "5                                     Quebec / Québec   \n",
       "6                                     Quebec / Québec   \n",
       "7                                     Quebec / Québec   \n",
       "8                                     Quebec / Québec   \n",
       "9                                     Quebec / Québec   \n",
       "10                                    Quebec / Québec   \n",
       "11                                    Quebec / Québec   \n",
       "12                                    Quebec / Québec   \n",
       "13                                    Quebec / Québec   \n",
       "14                                    Quebec / Québec   \n",
       "15                                    Quebec / Québec   \n",
       "16                                    Quebec / Québec   \n",
       "17                                    Quebec / Québec   \n",
       "18                                    Quebec / Québec   \n",
       "19                                            Ontario   \n",
       "20                                            Ontario   \n",
       "21                                            Ontario   \n",
       "22                                            Ontario   \n",
       "23                                            Ontario   \n",
       "24                                           Manitoba   \n",
       "25                                           Manitoba   \n",
       "26                                           Manitoba   \n",
       "27                                           Manitoba   \n",
       "28                                           Manitoba   \n",
       "29                                           Manitoba   \n",
       "30                                           Manitoba   \n",
       "31                                           Manitoba   \n",
       "32                                           Manitoba   \n",
       "33                                           Manitoba   \n",
       "34                                           Manitoba   \n",
       "35                                           Manitoba   \n",
       "36                                       Saskatchewan   \n",
       "37                                       Saskatchewan   \n",
       "38                                       Saskatchewan   \n",
       "39                                       Saskatchewan   \n",
       "40                                       Saskatchewan   \n",
       "41                                       Saskatchewan   \n",
       "42                                       Saskatchewan   \n",
       "43                                            Alberta   \n",
       "44                                            Alberta   \n",
       "45                                            Alberta   \n",
       "46                                            Alberta   \n",
       "47                                            Alberta   \n",
       "48                                            Alberta   \n",
       "49                                            Alberta   \n",
       "50                                            Alberta   \n",
       "51            British Columbia / Colombie-Britannique   \n",
       "52            British Columbia / Colombie-Britannique   \n",
       "53            British Columbia / Colombie-Britannique   \n",
       "54            British Columbia / Colombie-Britannique   \n",
       "55            British Columbia / Colombie-Britannique   \n",
       "56            British Columbia / Colombie-Britannique   \n",
       "57            British Columbia / Colombie-Britannique   \n",
       "58            British Columbia / Colombie-Britannique   \n",
       "59                                              Yukon   \n",
       "60  Northwest Territories / Territoires du Nord-Ouest   \n",
       "61                                            Nunavut   \n",
       "62  Newfoundland and Labrador / Terre-Neuve-et-Lab...   \n",
       "63  Newfoundland and Labrador / Terre-Neuve-et-Lab...   \n",
       "64  Newfoundland and Labrador / Terre-Neuve-et-Lab...   \n",
       "65       Prince Edward Island / Île-du-Prince-Édouard   \n",
       "66       Prince Edward Island / Île-du-Prince-Édouard   \n",
       "67       Prince Edward Island / Île-du-Prince-Édouard   \n",
       "68                      Nova Scotia / Nouvelle-Écosse   \n",
       "69                      Nova Scotia / Nouvelle-Écosse   \n",
       "70                      Nova Scotia / Nouvelle-Écosse   \n",
       "71                      Nova Scotia / Nouvelle-Écosse   \n",
       "\n",
       "                                             geometry  \n",
       "0   POLYGON ((8525489.391 1790548.500, 8525639.114...  \n",
       "1   POLYGON ((7998578.391 1612051.631, 7998668.814...  \n",
       "2   POLYGON ((8204574.134 1544487.454, 8208027.917...  \n",
       "3   POLYGON ((8217369.071 1620627.260, 8217713.531...  \n",
       "4   POLYGON ((8188457.820 1707919.583, 8188444.194...  \n",
       "5   POLYGON ((7983960.509 1783925.871, 7985523.191...  \n",
       "6   MULTIPOLYGON (((8449366.226 2385149.363, 84505...  \n",
       "7   POLYGON ((7811516.777 1616612.783, 7813390.280...  \n",
       "8   POLYGON ((7459301.751 1597664.723, 7459403.646...  \n",
       "9   POLYGON ((7854287.706 1351074.386, 7854803.251...  \n",
       "10  POLYGON ((7632385.269 1268099.211, 7632355.463...  \n",
       "11  POLYGON ((7494000.817 1466728.294, 7494089.857...  \n",
       "12  POLYGON ((7417836.414 1448561.194, 7417214.306...  \n",
       "13  POLYGON ((7480340.943 1451311.980, 7481653.474...  \n",
       "14  POLYGON ((7143607.286 3010209.309, 7149855.863...  \n",
       "15  MULTIPOLYGON (((8118937.531 1865516.623, 81189...  \n",
       "16  POLYGON ((7825812.920 1523677.477, 7826570.777...  \n",
       "17  POLYGON ((7658841.323 1321633.289, 7658863.331...  \n",
       "18  POLYGON ((7711256.483 1393539.114, 7711264.229...  \n",
       "19  POLYGON ((7192649.137 886943.691, 7192658.017 ...  \n",
       "20  POLYGON ((7067798.240 1083586.060, 7070871.029...  \n",
       "21  POLYGON ((7169056.906 1216085.683, 7169392.609...  \n",
       "22  POLYGON ((7267538.923 1237671.437, 7269021.437...  \n",
       "23  POLYGON ((6378815.614 2295412.440, 6378746.814...  \n",
       "24  POLYGON ((5562870.440 1532574.780, 5562908.066...  \n",
       "25  MULTIPOLYGON (((5655631.591 1599562.029, 56557...  \n",
       "26  POLYGON ((5612573.023 1654348.289, 5612632.997...  \n",
       "27  POLYGON ((5557425.843 1766740.606, 5557876.357...  \n",
       "28  POLYGON ((5558796.551 1895845.191, 5559127.694...  \n",
       "29  POLYGON ((5650771.940 1802331.591, 5650891.340...  \n",
       "30  POLYGON ((5679331.449 1641141.903, 5680237.029...  \n",
       "31  POLYGON ((5777322.629 1512527.626, 5777303.520...  \n",
       "32  POLYGON ((5870765.929 1583233.997, 5871226.809...  \n",
       "33  POLYGON ((5873864.783 1637832.080, 5874194.457...  \n",
       "34  POLYGON ((5839858.777 1608473.626, 5840487.871...  \n",
       "35  POLYGON ((6039656.509 2636304.343, 6039620.443...  \n",
       "36  POLYGON ((5430601.546 1846035.049, 5430608.446...  \n",
       "37  POLYGON ((5253247.371 1763719.194, 5253324.311...  \n",
       "38  POLYGON ((4988242.323 1860657.677, 4988244.780...  \n",
       "39  POLYGON ((5033127.871 2038855.063, 5033179.086...  \n",
       "40  POLYGON ((5438452.149 2011470.549, 5438186.106...  \n",
       "41  POLYGON ((5069906.640 2212621.191, 5070955.526...  \n",
       "42  POLYGON ((5248633.914 2767057.263, 5249285.640...  \n",
       "43  POLYGON ((4926800.134 1979203.977, 4926825.983...  \n",
       "44  POLYGON ((4757911.131 2003278.000, 4757911.149...  \n",
       "45  POLYGON ((4452472.249 2307439.651, 4453182.789...  \n",
       "46  POLYGON ((4923727.731 2060739.871, 4923972.617...  \n",
       "47  POLYGON ((4889307.549 2195049.694, 4889375.091...  \n",
       "48  POLYGON ((4819297.311 2218897.894, 4820771.649...  \n",
       "49  POLYGON ((5228304.177 2767597.891, 5228098.463...  \n",
       "50  POLYGON ((4981679.743 2724461.931, 4980294.180...  \n",
       "51  POLYGON ((3991663.969 2528376.829, 3992887.114...  \n",
       "52  POLYGON ((4130403.431 2186768.054, 4131349.843...  \n",
       "53  POLYGON ((4375952.111 2269366.100, 4376642.717...  \n",
       "54  POLYGON ((4556246.526 2001695.963, 4556130.637...  \n",
       "55  POLYGON ((4329993.003 2673366.229, 4330170.811...  \n",
       "56  POLYGON ((4225567.209 3090162.077, 4178712.863...  \n",
       "57  POLYGON ((4018904.414 3410247.271, 4019429.869...  \n",
       "58  POLYGON ((4357078.791 3166775.097, 4357652.426...  \n",
       "59  POLYGON ((4561932.471 4312865.174, 4564007.580...  \n",
       "60  POLYGON ((5689672.257 4324508.314, 5685498.029...  \n",
       "61  POLYGON ((7297737.369 3983558.454, 7316653.440...  \n",
       "62  POLYGON ((8936349.397 2205358.140, 8941041.589...  \n",
       "63  POLYGON ((8816520.789 2335270.254, 8821544.297...  \n",
       "64  POLYGON ((7644464.869 2980078.217, 7648864.423...  \n",
       "65  POLYGON ((8427169.677 1633933.906, 8427164.649...  \n",
       "66  POLYGON ((8382758.289 1638763.660, 8382833.617...  \n",
       "67  POLYGON ((8294354.734 1636914.940, 8296485.909...  \n",
       "68  POLYGON ((8362506.940 1428541.960, 8367260.740...  \n",
       "69  POLYGON ((8389627.240 1508346.011, 8390011.831...  \n",
       "70  MULTIPOLYGON (((8381659.560 1574688.929, 83836...  \n",
       "71  POLYGON ((8494876.626 1635345.826, 8494939.046...  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "car = gpd.read_file(\"lcar000a16a_e.shp\")\n",
    "car"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "6198f801",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "CARUID                                                   1205\n",
       "CARENAME                                Agricultural Region 5\n",
       "CARFNAME                                    Région agricole 5\n",
       "PRUID                                                      12\n",
       "PRNAME                          Nova Scotia / Nouvelle-Écosse\n",
       "geometry    POLYGON ((8525489.391429998 1790548.5, 8525639...\n",
       "Name: 0, dtype: object"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "car.iloc[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "a95cccca",
   "metadata": {},
   "outputs": [],
   "source": [
    "connection = mysql.connector.connect(user='root', password='your_password', host='127.0.0.1', database='field_crops')\n",
    "cursor = connection.cursor()\n",
    "\n",
    "add_car = (\"INSERT INTO growing_region \"\n",
    "           \"(CARUID, province, name, region, boundary) \"\n",
    "           \"VALUES (%s, %s, %s, %s, %s)\")\n",
    "\n",
    "for i in range(0, len(car)):\n",
    "\n",
    "    record = car.iloc[i]\n",
    "\n",
    "    CARUID = int(record.CARUID)\n",
    "\n",
    "    province = int(record.PRUID)\n",
    "    if(province == 10):\n",
    "        province = 'NL'\n",
    "    elif(province == 11):\n",
    "        province = 'PE'\n",
    "    elif(province == 12):\n",
    "        province = 'NS'\n",
    "    elif(province == 13):\n",
    "        province = 'NB'\n",
    "    elif(province == 24):\n",
    "        province = 'QC'\n",
    "    elif(province == 35):\n",
    "        province = 'ON'\n",
    "    elif(province == 46):\n",
    "        province = 'MB'\n",
    "    elif(province == 47):\n",
    "        province = 'SK'\n",
    "    elif(province == 48):\n",
    "        province = 'AB'\n",
    "    elif(province == 59):\n",
    "        province = 'BC'\n",
    "    elif(province == 60):\n",
    "        province = 'YT'\n",
    "    elif(province == 61):\n",
    "        province = 'NT'\n",
    "    elif(province == 62):\n",
    "        province = 'NU'\n",
    "    else:\n",
    "        province = '?'\n",
    "    \n",
    "    if(province == '?'):\n",
    "        print(record.PRUID)\n",
    "    \n",
    "    name = record.CARENAME\n",
    "\n",
    "    region = int(record.CARUID[-2:])\n",
    "    \n",
    "    boundary = record.geometry.to_wkt()\n",
    "\n",
    "    data_car = (CARUID, province, name, region, boundary)\n",
    "    \n",
    "    \n",
    "\n",
    "    cursor.execute(add_car, data_car)\n",
    "\n",
    "    connection.commit()\n",
    "\n",
    "\n",
    "\n",
    "cursor.close()\n",
    "connection.close()\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "aab3e5ba",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}