bird_migration.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "import geopandas as gpd\n",
    "from keplergl import KeplerGl\n",
    "import numpy as np\n",
    "from shapely.geometry import Point, LineString, shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>Data_Release_DOI</th>\n",
       "      <th>Data_Release_Version</th>\n",
       "      <th>Animal_ID</th>\n",
       "      <th>Animal_Species</th>\n",
       "      <th>Location_Timestamp_UTC</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Location_DAF_Filter</th>\n",
       "      <th>Location_Class</th>\n",
       "      <th>Location_NOPC</th>\n",
       "      <th>...</th>\n",
       "      <th>Tracking_Status</th>\n",
       "      <th>Lat_ShedDead</th>\n",
       "      <th>Lon_ShedDead</th>\n",
       "      <th>Pass_Satellite_ID</th>\n",
       "      <th>Pass_Messages_N</th>\n",
       "      <th>Pass_Messages_gt120dB</th>\n",
       "      <th>Pass_Messages_BestLeveldB</th>\n",
       "      <th>Pass_Duration</th>\n",
       "      <th>Pass_EstimatedFrequency</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10.5066/P9KBR79C</td>\n",
       "      <td>v01</td>\n",
       "      <td>TUSW_KS7</td>\n",
       "      <td>Cygnus columbianus</td>\n",
       "      <td>2008/07/16 23:37:58</td>\n",
       "      <td>58.57</td>\n",
       "      <td>-156.834</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>alive</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>NN</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>-133</td>\n",
       "      <td>436</td>\n",
       "      <td>401675318.4</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10.5066/P9KBR79C</td>\n",
       "      <td>v01</td>\n",
       "      <td>TUSW_KS7</td>\n",
       "      <td>Cygnus columbianus</td>\n",
       "      <td>2008/07/17 00:08:02</td>\n",
       "      <td>58.561</td>\n",
       "      <td>-156.854</td>\n",
       "      <td>0</td>\n",
       "      <td>B</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>alive</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>NK</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-137</td>\n",
       "      <td>125</td>\n",
       "      <td>401675318.4</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>10.5066/P9KBR79C</td>\n",
       "      <td>v01</td>\n",
       "      <td>TUSW_KS7</td>\n",
       "      <td>Cygnus columbianus</td>\n",
       "      <td>2008/07/20 02:04:21</td>\n",
       "      <td>58.574</td>\n",
       "      <td>-156.762</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>alive</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>NL</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>-127</td>\n",
       "      <td>472</td>\n",
       "      <td>401675327.6</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>10.5066/P9KBR79C</td>\n",
       "      <td>v01</td>\n",
       "      <td>TUSW_KS7</td>\n",
       "      <td>Cygnus columbianus</td>\n",
       "      <td>2008/07/20 02:18:07</td>\n",
       "      <td>58.564</td>\n",
       "      <td>-156.812</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>alive</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>NK</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>-125</td>\n",
       "      <td>436</td>\n",
       "      <td>401675310.8</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>10.5066/P9KBR79C</td>\n",
       "      <td>v01</td>\n",
       "      <td>TUSW_KS7</td>\n",
       "      <td>Cygnus columbianus</td>\n",
       "      <td>2008/07/20 03:46:30</td>\n",
       "      <td>58.566</td>\n",
       "      <td>-156.834</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>alive</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>NL</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>-131</td>\n",
       "      <td>188</td>\n",
       "      <td>401675377.5</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96043</th>\n",
       "      <td>10.5066/P9KBR79C</td>\n",
       "      <td>v01</td>\n",
       "      <td>TUSW_NS3</td>\n",
       "      <td>Cygnus columbianus</td>\n",
       "      <td>2011/01/13 02:51:42</td>\n",
       "      <td>38.188</td>\n",
       "      <td>-76.917</td>\n",
       "      <td>0</td>\n",
       "      <td>B</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>alive</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>MA</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-129</td>\n",
       "      <td>71</td>\n",
       "      <td>401672275.870</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96045</th>\n",
       "      <td>10.5066/P9KBR79C</td>\n",
       "      <td>v01</td>\n",
       "      <td>TUSW_NS3</td>\n",
       "      <td>Cygnus columbianus</td>\n",
       "      <td>2011/01/28 07:16:34</td>\n",
       "      <td>38.104</td>\n",
       "      <td>-76.997</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>alive</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>NP</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>-133</td>\n",
       "      <td>366</td>\n",
       "      <td>401672238.730</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96046</th>\n",
       "      <td>10.5066/P9KBR79C</td>\n",
       "      <td>v01</td>\n",
       "      <td>TUSW_NS3</td>\n",
       "      <td>Cygnus columbianus</td>\n",
       "      <td>2011/01/28 09:15:14</td>\n",
       "      <td>38.152</td>\n",
       "      <td>-76.877</td>\n",
       "      <td>0</td>\n",
       "      <td>B</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>alive</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>NK</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-136</td>\n",
       "      <td>74</td>\n",
       "      <td>401672275.870</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96047</th>\n",
       "      <td>10.5066/P9KBR79C</td>\n",
       "      <td>v01</td>\n",
       "      <td>TUSW_NS3</td>\n",
       "      <td>Cygnus columbianus</td>\n",
       "      <td>2011/02/01 10:57:38</td>\n",
       "      <td>38.102</td>\n",
       "      <td>-77.023</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>alive</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>NK</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>-134</td>\n",
       "      <td>303</td>\n",
       "      <td>401672203.170</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96048</th>\n",
       "      <td>10.5066/P9KBR79C</td>\n",
       "      <td>v01</td>\n",
       "      <td>TUSW_NS3</td>\n",
       "      <td>Cygnus columbianus</td>\n",
       "      <td>2011/02/05 09:19:50</td>\n",
       "      <td>38.072</td>\n",
       "      <td>-76.92</td>\n",
       "      <td>0</td>\n",
       "      <td>B</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>alive</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>NK</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-134</td>\n",
       "      <td>155</td>\n",
       "      <td>401672203.170</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>92218 rows × 35 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Data_Release_DOI Data_Release_Version Animal_ID      Animal_Species  \\\n",
       "0      10.5066/P9KBR79C                  v01  TUSW_KS7  Cygnus columbianus   \n",
       "1      10.5066/P9KBR79C                  v01  TUSW_KS7  Cygnus columbianus   \n",
       "2      10.5066/P9KBR79C                  v01  TUSW_KS7  Cygnus columbianus   \n",
       "3      10.5066/P9KBR79C                  v01  TUSW_KS7  Cygnus columbianus   \n",
       "4      10.5066/P9KBR79C                  v01  TUSW_KS7  Cygnus columbianus   \n",
       "...                 ...                  ...       ...                 ...   \n",
       "96043  10.5066/P9KBR79C                  v01  TUSW_NS3  Cygnus columbianus   \n",
       "96045  10.5066/P9KBR79C                  v01  TUSW_NS3  Cygnus columbianus   \n",
       "96046  10.5066/P9KBR79C                  v01  TUSW_NS3  Cygnus columbianus   \n",
       "96047  10.5066/P9KBR79C                  v01  TUSW_NS3  Cygnus columbianus   \n",
       "96048  10.5066/P9KBR79C                  v01  TUSW_NS3  Cygnus columbianus   \n",
       "\n",
       "      Location_Timestamp_UTC Latitude Longitude Location_DAF_Filter  \\\n",
       "0        2008/07/16 23:37:58    58.57  -156.834                   0   \n",
       "1        2008/07/17 00:08:02   58.561  -156.854                   0   \n",
       "2        2008/07/20 02:04:21   58.574  -156.762                   0   \n",
       "3        2008/07/20 02:18:07   58.564  -156.812                   0   \n",
       "4        2008/07/20 03:46:30   58.566  -156.834                   0   \n",
       "...                      ...      ...       ...                 ...   \n",
       "96043    2011/01/13 02:51:42   38.188   -76.917                   0   \n",
       "96045    2011/01/28 07:16:34   38.104   -76.997                   0   \n",
       "96046    2011/01/28 09:15:14   38.152   -76.877                   0   \n",
       "96047    2011/02/01 10:57:38   38.102   -77.023                   0   \n",
       "96048    2011/02/05 09:19:50   38.072    -76.92                   0   \n",
       "\n",
       "      Location_Class Location_NOPC  ... Tracking_Status Lat_ShedDead  \\\n",
       "0                  3             2  ...           alive                \n",
       "1                  B             2  ...           alive                \n",
       "2                  0             3  ...           alive                \n",
       "3                  1             1  ...           alive                \n",
       "4                  0             3  ...           alive                \n",
       "...              ...           ...  ...             ...          ...   \n",
       "96043              B             1  ...           alive                \n",
       "96045              2             1  ...           alive                \n",
       "96046              B             1  ...           alive                \n",
       "96047              A             1  ...           alive                \n",
       "96048              B             1  ...           alive                \n",
       "\n",
       "      Lon_ShedDead Pass_Satellite_ID Pass_Messages_N Pass_Messages_gt120dB  \\\n",
       "0                                 NN               7                     0   \n",
       "1                                 NK               2                     0   \n",
       "2                                 NL               9                     0   \n",
       "3                                 NK               8                     0   \n",
       "4                                 NL               4                     0   \n",
       "...            ...               ...             ...                   ...   \n",
       "96043                             MA               2                     0   \n",
       "96045                             NP               6                     0   \n",
       "96046                             NK               2                     0   \n",
       "96047                             NK               3                     0   \n",
       "96048                             NK               2                     0   \n",
       "\n",
       "      Pass_Messages_BestLeveldB Pass_Duration Pass_EstimatedFrequency geometry  \n",
       "0                          -133           436             401675318.4     None  \n",
       "1                          -137           125             401675318.4     None  \n",
       "2                          -127           472             401675327.6     None  \n",
       "3                          -125           436             401675310.8     None  \n",
       "4                          -131           188             401675377.5     None  \n",
       "...                         ...           ...                     ...      ...  \n",
       "96043                      -129            71           401672275.870     None  \n",
       "96045                      -133           366           401672238.730     None  \n",
       "96046                      -136            74           401672275.870     None  \n",
       "96047                      -134           303           401672203.170     None  \n",
       "96048                      -134           155           401672203.170     None  \n",
       "\n",
       "[92218 rows x 35 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "path = 'E:\\\\Pro\\\\BDD\\\\ARGOS\\\\tundraSwan_USGS_ASC_argos_processedData\\\\processedData\\\\tundraSwan_USGS_ASC_argos_diag_filteredLocations.csv' #DATA FROM USGS\n",
    "\n",
    "df_swan = gpd.read_file(path)\n",
    "df_swan = df_swan.query(\"Location_DAF_Filter == '0'\")           #FILTER BY QUALITY FLAG \n",
    "df_swan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>Data_Release_DOI</th>\n",
       "      <th>Data_Release_Version</th>\n",
       "      <th>Animal_ID</th>\n",
       "      <th>Animal_Species</th>\n",
       "      <th>Location_Timestamp_UTC</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Location_DAF_Filter</th>\n",
       "      <th>Location_Class</th>\n",
       "      <th>Location_NOPC</th>\n",
       "      <th>...</th>\n",
       "      <th>Lat_ShedDead</th>\n",
       "      <th>Lon_ShedDead</th>\n",
       "      <th>Pass_Satellite_ID</th>\n",
       "      <th>Pass_Messages_N</th>\n",
       "      <th>Pass_Messages_gt120dB</th>\n",
       "      <th>Pass_Messages_BestLeveldB</th>\n",
       "      <th>Pass_Duration</th>\n",
       "      <th>Pass_EstimatedFrequency</th>\n",
       "      <th>geometry</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1902</th>\n",
       "      <td>10.5066/P9KBR79C</td>\n",
       "      <td>v01</td>\n",
       "      <td>TUSW_KS7</td>\n",
       "      <td>Cygnus columbianus</td>\n",
       "      <td>2011/02/12 05:52:40</td>\n",
       "      <td>42.62</td>\n",
       "      <td>-121.947</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>MA</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-126</td>\n",
       "      <td>452</td>\n",
       "      <td>401675350.880</td>\n",
       "      <td>None</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1903</th>\n",
       "      <td>10.5066/P9KBR79C</td>\n",
       "      <td>v01</td>\n",
       "      <td>TUSW_KS7</td>\n",
       "      <td>Cygnus columbianus</td>\n",
       "      <td>2011/02/12 10:25:30</td>\n",
       "      <td>42.625</td>\n",
       "      <td>-122.035</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>NN</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>-130</td>\n",
       "      <td>390</td>\n",
       "      <td>401675334.010</td>\n",
       "      <td>None</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1904</th>\n",
       "      <td>10.5066/P9KBR79C</td>\n",
       "      <td>v01</td>\n",
       "      <td>TUSW_KS7</td>\n",
       "      <td>Cygnus columbianus</td>\n",
       "      <td>2011/02/16 10:43:17</td>\n",
       "      <td>42.873</td>\n",
       "      <td>-121.738</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>NP</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>-135</td>\n",
       "      <td>324</td>\n",
       "      <td>401675287.600</td>\n",
       "      <td>None</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1905</th>\n",
       "      <td>10.5066/P9KBR79C</td>\n",
       "      <td>v01</td>\n",
       "      <td>TUSW_KS7</td>\n",
       "      <td>Cygnus columbianus</td>\n",
       "      <td>2011/02/16 11:24:54</td>\n",
       "      <td>42.879</td>\n",
       "      <td>-121.726</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>NN</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>-136</td>\n",
       "      <td>259</td>\n",
       "      <td>401675294.360</td>\n",
       "      <td>None</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1906</th>\n",
       "      <td>10.5066/P9KBR79C</td>\n",
       "      <td>v01</td>\n",
       "      <td>TUSW_KS7</td>\n",
       "      <td>Cygnus columbianus</td>\n",
       "      <td>2011/02/17 10:33:49</td>\n",
       "      <td>42.854</td>\n",
       "      <td>-121.76</td>\n",
       "      <td>0</td>\n",
       "      <td>B</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>NP</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-135</td>\n",
       "      <td>64</td>\n",
       "      <td>401675294.360</td>\n",
       "      <td>None</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96043</th>\n",
       "      <td>10.5066/P9KBR79C</td>\n",
       "      <td>v01</td>\n",
       "      <td>TUSW_NS3</td>\n",
       "      <td>Cygnus columbianus</td>\n",
       "      <td>2011/01/13 02:51:42</td>\n",
       "      <td>38.188</td>\n",
       "      <td>-76.917</td>\n",
       "      <td>0</td>\n",
       "      <td>B</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>MA</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-129</td>\n",
       "      <td>71</td>\n",
       "      <td>401672275.870</td>\n",
       "      <td>None</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96045</th>\n",
       "      <td>10.5066/P9KBR79C</td>\n",
       "      <td>v01</td>\n",
       "      <td>TUSW_NS3</td>\n",
       "      <td>Cygnus columbianus</td>\n",
       "      <td>2011/01/28 07:16:34</td>\n",
       "      <td>38.104</td>\n",
       "      <td>-76.997</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>NP</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>-133</td>\n",
       "      <td>366</td>\n",
       "      <td>401672238.730</td>\n",
       "      <td>None</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96046</th>\n",
       "      <td>10.5066/P9KBR79C</td>\n",
       "      <td>v01</td>\n",
       "      <td>TUSW_NS3</td>\n",
       "      <td>Cygnus columbianus</td>\n",
       "      <td>2011/01/28 09:15:14</td>\n",
       "      <td>38.152</td>\n",
       "      <td>-76.877</td>\n",
       "      <td>0</td>\n",
       "      <td>B</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>NK</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-136</td>\n",
       "      <td>74</td>\n",
       "      <td>401672275.870</td>\n",
       "      <td>None</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96047</th>\n",
       "      <td>10.5066/P9KBR79C</td>\n",
       "      <td>v01</td>\n",
       "      <td>TUSW_NS3</td>\n",
       "      <td>Cygnus columbianus</td>\n",
       "      <td>2011/02/01 10:57:38</td>\n",
       "      <td>38.102</td>\n",
       "      <td>-77.023</td>\n",
       "      <td>0</td>\n",
       "      <td>A</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>NK</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>-134</td>\n",
       "      <td>303</td>\n",
       "      <td>401672203.170</td>\n",
       "      <td>None</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96048</th>\n",
       "      <td>10.5066/P9KBR79C</td>\n",
       "      <td>v01</td>\n",
       "      <td>TUSW_NS3</td>\n",
       "      <td>Cygnus columbianus</td>\n",
       "      <td>2011/02/05 09:19:50</td>\n",
       "      <td>38.072</td>\n",
       "      <td>-76.92</td>\n",
       "      <td>0</td>\n",
       "      <td>B</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>NK</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-134</td>\n",
       "      <td>155</td>\n",
       "      <td>401672203.170</td>\n",
       "      <td>None</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11374 rows × 36 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Data_Release_DOI Data_Release_Version Animal_ID      Animal_Species  \\\n",
       "1902   10.5066/P9KBR79C                  v01  TUSW_KS7  Cygnus columbianus   \n",
       "1903   10.5066/P9KBR79C                  v01  TUSW_KS7  Cygnus columbianus   \n",
       "1904   10.5066/P9KBR79C                  v01  TUSW_KS7  Cygnus columbianus   \n",
       "1905   10.5066/P9KBR79C                  v01  TUSW_KS7  Cygnus columbianus   \n",
       "1906   10.5066/P9KBR79C                  v01  TUSW_KS7  Cygnus columbianus   \n",
       "...                 ...                  ...       ...                 ...   \n",
       "96043  10.5066/P9KBR79C                  v01  TUSW_NS3  Cygnus columbianus   \n",
       "96045  10.5066/P9KBR79C                  v01  TUSW_NS3  Cygnus columbianus   \n",
       "96046  10.5066/P9KBR79C                  v01  TUSW_NS3  Cygnus columbianus   \n",
       "96047  10.5066/P9KBR79C                  v01  TUSW_NS3  Cygnus columbianus   \n",
       "96048  10.5066/P9KBR79C                  v01  TUSW_NS3  Cygnus columbianus   \n",
       "\n",
       "      Location_Timestamp_UTC Latitude Longitude Location_DAF_Filter  \\\n",
       "1902     2011/02/12 05:52:40    42.62  -121.947                   0   \n",
       "1903     2011/02/12 10:25:30   42.625  -122.035                   0   \n",
       "1904     2011/02/16 10:43:17   42.873  -121.738                   0   \n",
       "1905     2011/02/16 11:24:54   42.879  -121.726                   0   \n",
       "1906     2011/02/17 10:33:49   42.854   -121.76                   0   \n",
       "...                      ...      ...       ...                 ...   \n",
       "96043    2011/01/13 02:51:42   38.188   -76.917                   0   \n",
       "96045    2011/01/28 07:16:34   38.104   -76.997                   0   \n",
       "96046    2011/01/28 09:15:14   38.152   -76.877                   0   \n",
       "96047    2011/02/01 10:57:38   38.102   -77.023                   0   \n",
       "96048    2011/02/05 09:19:50   38.072    -76.92                   0   \n",
       "\n",
       "      Location_Class Location_NOPC  ... Lat_ShedDead Lon_ShedDead  \\\n",
       "1902               1             1  ...                             \n",
       "1903               A             3  ...                             \n",
       "1904               A             1  ...                             \n",
       "1905               A             3  ...                             \n",
       "1906               B             2  ...                             \n",
       "...              ...           ...  ...          ...          ...   \n",
       "96043              B             1  ...                             \n",
       "96045              2             1  ...                             \n",
       "96046              B             1  ...                             \n",
       "96047              A             1  ...                             \n",
       "96048              B             1  ...                             \n",
       "\n",
       "      Pass_Satellite_ID Pass_Messages_N Pass_Messages_gt120dB  \\\n",
       "1902                 MA               5                     0   \n",
       "1903                 NN               3                     0   \n",
       "1904                 NP               3                     0   \n",
       "1905                 NN               3                     0   \n",
       "1906                 NP               2                     0   \n",
       "...                 ...             ...                   ...   \n",
       "96043                MA               2                     0   \n",
       "96045                NP               6                     0   \n",
       "96046                NK               2                     0   \n",
       "96047                NK               3                     0   \n",
       "96048                NK               2                     0   \n",
       "\n",
       "      Pass_Messages_BestLeveldB Pass_Duration Pass_EstimatedFrequency  \\\n",
       "1902                       -126           452           401675350.880   \n",
       "1903                       -130           390           401675334.010   \n",
       "1904                       -135           324           401675287.600   \n",
       "1905                       -136           259           401675294.360   \n",
       "1906                       -135            64           401675294.360   \n",
       "...                         ...           ...                     ...   \n",
       "96043                      -129            71           401672275.870   \n",
       "96045                      -133           366           401672238.730   \n",
       "96046                      -136            74           401672275.870   \n",
       "96047                      -134           303           401672203.170   \n",
       "96048                      -134           155           401672203.170   \n",
       "\n",
       "      geometry  year  \n",
       "1902      None  2011  \n",
       "1903      None  2011  \n",
       "1904      None  2011  \n",
       "1905      None  2011  \n",
       "1906      None  2011  \n",
       "...        ...   ...  \n",
       "96043     None  2011  \n",
       "96045     None  2011  \n",
       "96046     None  2011  \n",
       "96047     None  2011  \n",
       "96048     None  2011  \n",
       "\n",
       "[11374 rows x 36 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_swan['year'] = df_swan['Location_Timestamp_UTC'].apply(lambda x : x[:4]).astype(int)  #RETRIEVE THE YERAR\n",
    "df_swan_2011 = df_swan.loc[df_swan['year'] == 2011]\n",
    "df_swan_2011"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Create one DataFrame per Swan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "our_swans = df_swan_2011['Animal_ID'].unique()\n",
    "dict_df_swan = dict()\n",
    "for swan in our_swans:\n",
    "    dict_df_swan[swan] = df_swan_2011.query(\"Animal_ID == '{}'\".format(swan))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['TUSW_KS7', 'TUSW_CB3', 'TUSW_KS6', 'TUSW_KZ1', 'TUSW_CB6',\n",
       "       'TUSW_NS2', 'TUSW_KZ8', 'TUSW_KZ10', 'TUSW_NS5', 'TUSW_NS4',\n",
       "       'TUSW_YK10', 'TUSW_YK2', 'TUSW_KS8', 'TUSW_CB4', 'TUSW_YK3',\n",
       "       'TUSW_CB1', 'TUSW_KS9', 'TUSW_CB10', 'TUSW_NS10', 'TUSW_CB9',\n",
       "       'TUSW_CB7', 'TUSW_KZ4', 'TUSW_NS8', 'TUSW_NS7', 'TUSW_KS4',\n",
       "       'TUSW_KS3', 'TUSW_KS2', 'TUSW_CB2', 'TUSW_CB5', 'TUSW_NS1',\n",
       "       'TUSW_NS9', 'TUSW_KZ7', 'TUSW_KZ9', 'TUSW_YK4', 'TUSW_NS3'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "our_swans"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "dict_df_swan_line = dict()\n",
    "for swan in dict_df_swan.keys():\n",
    "    \n",
    "    #CLEANING THE DATA\n",
    "    dict_df_swan[swan] = dict_df_swan[swan].replace(\"\", float(\"NaN\"), inplace = False)\n",
    "    dict_df_swan[swan] = dict_df_swan[swan].dropna(subset =['Latitude', 'Longitude'], inplace = False)\n",
    "             \n",
    "    #PROCESSING THE DATA\n",
    "    dict_df_swan[swan]['Latitude']    = dict_df_swan[swan]['Latitude'].astype(float)\n",
    "    dict_df_swan[swan]['Longitude']   = dict_df_swan[swan]['Longitude'].astype(float)\n",
    "    dict_df_swan[swan]['geometry']    = gpd.points_from_xy(dict_df_swan[swan].Longitude, dict_df_swan[swan].Latitude)\n",
    "    dict_df_swan[swan]['geometry']    = LineString(dict_df_swan[swan]['geometry'].tolist())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "User Guide: https://github.com/keplergl/kepler.gl/blob/master/docs/keplergl-jupyter/user-guide.md\n"
     ]
    },
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "7ae7abd64ac8479a8643b504667a9e9c",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "KeplerGl(config={'version': 'v1', 'config': {'visState': {'filters': [], 'layers': [{'id': 'jr6s2vf', 'type': …"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "map_one_swan = KeplerGl(height=500, data={'TUSW_KS7' : dict_df_swan['TUSW_KS7']})\n",
    "map_one_swan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "User Guide: https://github.com/keplergl/kepler.gl/blob/master/docs/keplergl-jupyter/user-guide.md\n",
      "Map saved to E:\\Pro\\BDD\\ARGOS\\Lac_des_Cygnes.html!\n"
     ]
    }
   ],
   "source": [
    "# MAP WITH ALL THE SWAN\n",
    "map_all_swan = KeplerGl(height=500, data=dict_df_swan)\n",
    "map_all_swan.save_to_html(file_name=\"E:\\\\Pro\\\\BDD\\\\ARGOS\\\\Lac_des_Cygnes.html\")"
   ]
  }
 ],
 "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.6.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}