notebooks/02-visualization-lonboard.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "958dbea2",
   "metadata": {},
   "outputs": [],
   "source": [
    "import geopandas as gpd\n",
    "from lonboard import Map, ScatterplotLayer"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "03dec670",
   "metadata": {},
   "outputs": [],
   "source": [
    "url = \"../data/industrial_vessels.parquet\"\n",
    "gdf = gpd.read_parquet(url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "116ea42b",
   "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>location</th>\n",
       "      <th>timestamp</th>\n",
       "      <th>detect_id</th>\n",
       "      <th>scene_id</th>\n",
       "      <th>mmsi</th>\n",
       "      <th>length_m</th>\n",
       "      <th>matching_score</th>\n",
       "      <th>fishing_score</th>\n",
       "      <th>matched_category</th>\n",
       "      <th>overpasses_2017_2021</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>POINT (24.49526 40.93169)</td>\n",
       "      <td>2024-01-04 08:43:45</td>\n",
       "      <td>S1A_IW_GRDH_1SDV_20181126T043101_20181126T0431...</td>\n",
       "      <td>S1A_IW_GRDH_1SDV_20181126T043101_20181126T0431...</td>\n",
       "      <td>271002689</td>\n",
       "      <td>103.883240</td>\n",
       "      <td>13.895070</td>\n",
       "      <td>0.012883</td>\n",
       "      <td>matched_nonfishing</td>\n",
       "      <td>894</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>POINT (-3.24526 36.07382)</td>\n",
       "      <td>2024-01-04 08:43:45</td>\n",
       "      <td>S1A_IW_GRDH_1SDV_20210519T061929_20210519T0619...</td>\n",
       "      <td>S1A_IW_GRDH_1SDV_20210519T061929_20210519T0619...</td>\n",
       "      <td>255806051</td>\n",
       "      <td>116.015938</td>\n",
       "      <td>1.042563</td>\n",
       "      <td>0.079186</td>\n",
       "      <td>matched_nonfishing</td>\n",
       "      <td>894</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>POINT (-3.26087 36.13436)</td>\n",
       "      <td>2024-01-04 08:43:45</td>\n",
       "      <td>S1A_IW_GRDH_1SDV_20180429T061909_20180429T0619...</td>\n",
       "      <td>S1A_IW_GRDH_1SDV_20180429T061909_20180429T0619...</td>\n",
       "      <td>538004153</td>\n",
       "      <td>99.993713</td>\n",
       "      <td>0.582640</td>\n",
       "      <td>0.254946</td>\n",
       "      <td>matched_nonfishing</td>\n",
       "      <td>894</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>POINT (30.15132 42.03163)</td>\n",
       "      <td>2024-01-04 08:43:45</td>\n",
       "      <td>S1A_IW_GRDH_1SDV_20180901T155133_20180901T1551...</td>\n",
       "      <td>S1A_IW_GRDH_1SDV_20180901T155133_20180901T1551...</td>\n",
       "      <td>636092729</td>\n",
       "      <td>175.798828</td>\n",
       "      <td>0.031309</td>\n",
       "      <td>0.012883</td>\n",
       "      <td>matched_nonfishing</td>\n",
       "      <td>894</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>POINT (-2.84207 36.35213)</td>\n",
       "      <td>2024-01-04 08:43:45</td>\n",
       "      <td>S1B_IW_GRDH_1SDV_20210917T061036_20210917T0611...</td>\n",
       "      <td>S1B_IW_GRDH_1SDV_20210917T061036_20210917T0611...</td>\n",
       "      <td>636016651</td>\n",
       "      <td>182.102692</td>\n",
       "      <td>0.026239</td>\n",
       "      <td>0.012883</td>\n",
       "      <td>matched_nonfishing</td>\n",
       "      <td>894</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23088620</th>\n",
       "      <td>POINT (-109.88553 22.87621)</td>\n",
       "      <td>2024-01-04 08:43:45</td>\n",
       "      <td>S1B_IW_GRDH_1SDV_20190719T012156_20190719T0122...</td>\n",
       "      <td>S1B_IW_GRDH_1SDV_20190719T012156_20190719T0122...</td>\n",
       "      <td>316033095</td>\n",
       "      <td>21.548384</td>\n",
       "      <td>0.001107</td>\n",
       "      <td>0.539910</td>\n",
       "      <td>matched_nonfishing</td>\n",
       "      <td>279</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23088621</th>\n",
       "      <td>POINT (-96.45013 28.07624)</td>\n",
       "      <td>2024-01-04 08:43:45</td>\n",
       "      <td>S1A_IW_GRDH_1SDV_20180402T002553_20180402T0026...</td>\n",
       "      <td>S1A_IW_GRDH_1SDV_20180402T002553_20180402T0026...</td>\n",
       "      <td>367151170</td>\n",
       "      <td>16.487610</td>\n",
       "      <td>0.000161</td>\n",
       "      <td>0.926911</td>\n",
       "      <td>matched_nonfishing</td>\n",
       "      <td>279</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23088622</th>\n",
       "      <td>POINT (113.30324 -5.33849)</td>\n",
       "      <td>2024-01-04 08:43:45</td>\n",
       "      <td>S1A_IW_GRDH_1SDV_20181024T105024_20181024T1050...</td>\n",
       "      <td>S1A_IW_GRDH_1SDV_20181024T105024_20181024T1050...</td>\n",
       "      <td>525012191</td>\n",
       "      <td>179.885269</td>\n",
       "      <td>0.052076</td>\n",
       "      <td>0.012883</td>\n",
       "      <td>matched_nonfishing</td>\n",
       "      <td>279</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23088623</th>\n",
       "      <td>POINT (105.64373 3.84356)</td>\n",
       "      <td>2024-01-04 08:43:45</td>\n",
       "      <td>S1A_IW_GRDH_1SDV_20211223T223924_20211223T2239...</td>\n",
       "      <td>S1A_IW_GRDH_1SDV_20211223T223924_20211223T2239...</td>\n",
       "      <td>255806430</td>\n",
       "      <td>375.075226</td>\n",
       "      <td>0.018200</td>\n",
       "      <td>0.031119</td>\n",
       "      <td>matched_nonfishing</td>\n",
       "      <td>279</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23088624</th>\n",
       "      <td>POINT (123.66437 11.54144)</td>\n",
       "      <td>2024-01-04 08:43:45</td>\n",
       "      <td>S1A_IW_GRDH_1SDV_20181117T213123_20181117T2131...</td>\n",
       "      <td>S1A_IW_GRDH_1SDV_20181117T213123_20181117T2131...</td>\n",
       "      <td>548260100</td>\n",
       "      <td>135.279724</td>\n",
       "      <td>0.002046</td>\n",
       "      <td>0.012883</td>\n",
       "      <td>matched_nonfishing</td>\n",
       "      <td>279</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>23088625 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             location           timestamp  \\\n",
       "0           POINT (24.49526 40.93169) 2024-01-04 08:43:45   \n",
       "1           POINT (-3.24526 36.07382) 2024-01-04 08:43:45   \n",
       "2           POINT (-3.26087 36.13436) 2024-01-04 08:43:45   \n",
       "3           POINT (30.15132 42.03163) 2024-01-04 08:43:45   \n",
       "4           POINT (-2.84207 36.35213) 2024-01-04 08:43:45   \n",
       "...                               ...                 ...   \n",
       "23088620  POINT (-109.88553 22.87621) 2024-01-04 08:43:45   \n",
       "23088621   POINT (-96.45013 28.07624) 2024-01-04 08:43:45   \n",
       "23088622   POINT (113.30324 -5.33849) 2024-01-04 08:43:45   \n",
       "23088623    POINT (105.64373 3.84356) 2024-01-04 08:43:45   \n",
       "23088624   POINT (123.66437 11.54144) 2024-01-04 08:43:45   \n",
       "\n",
       "                                                  detect_id  \\\n",
       "0         S1A_IW_GRDH_1SDV_20181126T043101_20181126T0431...   \n",
       "1         S1A_IW_GRDH_1SDV_20210519T061929_20210519T0619...   \n",
       "2         S1A_IW_GRDH_1SDV_20180429T061909_20180429T0619...   \n",
       "3         S1A_IW_GRDH_1SDV_20180901T155133_20180901T1551...   \n",
       "4         S1B_IW_GRDH_1SDV_20210917T061036_20210917T0611...   \n",
       "...                                                     ...   \n",
       "23088620  S1B_IW_GRDH_1SDV_20190719T012156_20190719T0122...   \n",
       "23088621  S1A_IW_GRDH_1SDV_20180402T002553_20180402T0026...   \n",
       "23088622  S1A_IW_GRDH_1SDV_20181024T105024_20181024T1050...   \n",
       "23088623  S1A_IW_GRDH_1SDV_20211223T223924_20211223T2239...   \n",
       "23088624  S1A_IW_GRDH_1SDV_20181117T213123_20181117T2131...   \n",
       "\n",
       "                                                   scene_id       mmsi  \\\n",
       "0         S1A_IW_GRDH_1SDV_20181126T043101_20181126T0431...  271002689   \n",
       "1         S1A_IW_GRDH_1SDV_20210519T061929_20210519T0619...  255806051   \n",
       "2         S1A_IW_GRDH_1SDV_20180429T061909_20180429T0619...  538004153   \n",
       "3         S1A_IW_GRDH_1SDV_20180901T155133_20180901T1551...  636092729   \n",
       "4         S1B_IW_GRDH_1SDV_20210917T061036_20210917T0611...  636016651   \n",
       "...                                                     ...        ...   \n",
       "23088620  S1B_IW_GRDH_1SDV_20190719T012156_20190719T0122...  316033095   \n",
       "23088621  S1A_IW_GRDH_1SDV_20180402T002553_20180402T0026...  367151170   \n",
       "23088622  S1A_IW_GRDH_1SDV_20181024T105024_20181024T1050...  525012191   \n",
       "23088623  S1A_IW_GRDH_1SDV_20211223T223924_20211223T2239...  255806430   \n",
       "23088624  S1A_IW_GRDH_1SDV_20181117T213123_20181117T2131...  548260100   \n",
       "\n",
       "            length_m  matching_score  fishing_score    matched_category  \\\n",
       "0         103.883240       13.895070       0.012883  matched_nonfishing   \n",
       "1         116.015938        1.042563       0.079186  matched_nonfishing   \n",
       "2          99.993713        0.582640       0.254946  matched_nonfishing   \n",
       "3         175.798828        0.031309       0.012883  matched_nonfishing   \n",
       "4         182.102692        0.026239       0.012883  matched_nonfishing   \n",
       "...              ...             ...            ...                 ...   \n",
       "23088620   21.548384        0.001107       0.539910  matched_nonfishing   \n",
       "23088621   16.487610        0.000161       0.926911  matched_nonfishing   \n",
       "23088622  179.885269        0.052076       0.012883  matched_nonfishing   \n",
       "23088623  375.075226        0.018200       0.031119  matched_nonfishing   \n",
       "23088624  135.279724        0.002046       0.012883  matched_nonfishing   \n",
       "\n",
       "          overpasses_2017_2021  \n",
       "0                          894  \n",
       "1                          894  \n",
       "2                          894  \n",
       "3                          894  \n",
       "4                          894  \n",
       "...                        ...  \n",
       "23088620                   279  \n",
       "23088621                   279  \n",
       "23088622                   279  \n",
       "23088623                   279  \n",
       "23088624                   279  \n",
       "\n",
       "[23088625 rows x 10 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gdf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "8453214c",
   "metadata": {},
   "outputs": [],
   "source": [
    "unmatched_gdf = gdf.loc[gdf['matched_category']=='unmatched']\n",
    "matched_gdf = gdf.loc[gdf['matched_category']=='matched_fishing']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "051c2c15",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "713749a0954945ec8bb0678cc23a8202",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "Map(layers=[ScatterplotLayer(get_fill_color=[200, 0, 0, 200], table=pyarrow.Table\n",
       "timestamp: timestamp[ns]\n",
       "det…"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "unmatched_layer = ScatterplotLayer.from_geopandas(unmatched_gdf, get_fill_color = [200, 0, 0, 200])\n",
    "matched_layer = ScatterplotLayer.from_geopandas(matched_gdf, get_fill_color = [0, 200, 0, 200])\n",
    "map_ = Map(layers=[unmatched_layer, matched_layer])\n",
    "map_"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "50a7c53b",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.11.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}