{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "## Plotting Vessel Trail with Signals API\n", "\n", "This notebook will mainly cover how to extract signals data from Signals API and how to visualize them in a map using plotly library.\n", "\n", "The example used in this notebook is LNG Exports out of Russia Arctic LNG 2 Plant terminal." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Import Library" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "c:\\Users\\OuiWeinJien\\anaconda3\\lib\\site-packages\\pandas\\core\\arrays\\masked.py:60: UserWarning: Pandas requires version '1.3.6' or newer of 'bottleneck' (version '1.3.5' currently installed).\n", " from pandas.core import (\n" ] } ], "source": [ "import pandas as pd\n", "from datetime import datetime\n", "import numpy as np\n", "import vortexasdk as v\n", "import requests\n", "import os\n", "import plotly.express as px" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "2024-09-17 15:13:57,286 vortexasdk.client — WARNING — You are using vortexasdk version 0.73.0, however version 0.73.1 is available.\n", "You should consider upgrading via the 'pip install vortexasdk --upgrade' command.\n" ] } ], "source": [ "lng = [p.id for p in v.Products().search('LNG').to_list() if p.name=='LNG']\n", "\n", "russia_arctic=[p.id for p in v.Geographies().search('Arctic LNG 2 Plant').to_list()]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Extract Cargo Movements data" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [], "source": [ "cm_df = v.CargoMovements().search(\n", " filter_activity='loading_end',\n", " filter_products=lng,\n", " filter_origins=russia_arctic,\n", " filter_time_min=datetime(2024, 1, 1),\n", " filter_time_max=datetime.today()\n", ").to_df(columns = 'all')" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
| \n", " | cargo_movement_id | \n", "quantity | \n", "status | \n", "vessels.0.dwt | \n", "vessels.0.fixture_id | \n", "vessels.0.flag.0.flag | \n", "vessels.0.flag.0.flag_country | \n", "vessels.0.flag.0.tag | \n", "vessels.0.mmsi | \n", "vessels.0.start_timestamp | \n", "... | \n", "events.cargo_waypoint_event.8.start_timestamp | \n", "events.cargo_waypoint_event.8.probability | \n", "events.cargo_waypoint_event.8.vessel_id | \n", "events.cargo_waypoint_event.8.location.waypoint.probability | \n", "events.cargo_waypoint_event.8.location.waypoint.id | \n", "events.cargo_waypoint_event.8.location.waypoint.label | \n", "events.cargo_waypoint_event.8.location.waypoint.source | \n", "events.cargo_waypoint_event.8.location.waypoint.layer | \n", "parent_ids.0.splinter_timestamp | \n", "parent_ids.0.id | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "a9486b756c4994b3fccbe9b66bec144ea9486b756c4994... | \n", "433936 | \n", "transiting_state | \n", "77410 | \n", "\n", " | PW | \n", "479de61e68a1f232b16498c726ae6afb6de766da18472e... | \n", "vessel_flag_tag | \n", "511101456 | \n", "2024-09-04 00:00:00+00:00 | \n", "... | \n", "NaT | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | NaT | \n", "\n", " |
| 1 | \n", "ad225abb9cf80f7a32e4eca229e1ca59ad225abb9cf80f... | \n", "833796 | \n", "transiting_state | \n", "79866 | \n", "\n", " | PW | \n", "479de61e68a1f232b16498c726ae6afb6de766da18472e... | \n", "vessel_flag_tag | \n", "511101428 | \n", "2024-08-07 00:00:00+00:00 | \n", "... | \n", "NaT | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | NaT | \n", "\n", " |
| 2 | \n", "c38b5ca7177a343a613fb60de51a1179c38b5ca7177a34... | \n", "433936 | \n", "transiting_state | \n", "77410 | \n", "\n", " | PW | \n", "479de61e68a1f232b16498c726ae6afb6de766da18472e... | \n", "vessel_flag_tag | \n", "511101456 | \n", "2024-08-23 08:00:00+00:00 | \n", "... | \n", "NaT | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | NaT | \n", "\n", " |
| 3 | \n", "c920f7d026d99a8424b9346e59531810c920f7d026d99a... | \n", "190805 | \n", "transiting_state | \n", "77712 | \n", "\n", " | PW | \n", "479de61e68a1f232b16498c726ae6afb6de766da18472e... | \n", "vessel_flag_tag | \n", "511101396 | \n", "2024-08-01 00:00:00+00:00 | \n", "... | \n", "NaT | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | NaT | \n", "\n", " |
| 4 | \n", "fb8b2b93e566c43dfed56a5410bbc8e7fb8b2b93e566c4... | \n", "676890 | \n", "transiting_state | \n", "77712 | \n", "\n", " | PW | \n", "479de61e68a1f232b16498c726ae6afb6de766da18472e... | \n", "vessel_flag_tag | \n", "511101396 | \n", "2024-08-01 00:00:00+00:00 | \n", "... | \n", "2024-09-16 09:49:32+00:00 | \n", "1.0 | \n", "3bc8490a0c382976f8746101508e709cb3f69d2a0efc5b... | \n", "1.0 | \n", "703a4af533b42e86a0473f6b464ad2da1bb04cf899a167... | \n", "Cape Finisterre | \n", "model | \n", "waypoint | \n", "2024-09-11 19:06:06+00:00 | \n", "c920f7d026d99a8424b9346e59531810c920f7d026d99a... | \n", "
5 rows × 529 columns
\n", "| \n", " | vessels.0.name | \n", "vessels.0.imo | \n", "vessels.0.id | \n", "vessels.1.name | \n", "vessels.1.imo | \n", "vessels.1.start_timestamp | \n", "
|---|---|---|---|---|---|---|
| 0 | \n", "EVEREST ENERGY | \n", "9243148 | \n", "fe16241b4f45168faa94269633b52a4336b0c9d6e4c76b... | \n", "\n", " | \n", " | NaT | \n", "
| 1 | \n", "ASYA ENERGY | \n", "9216298 | \n", "79138d1707099e3ed42779a5249bdf12343e0acdc53d85... | \n", "\n", " | \n", " | NaT | \n", "
| 2 | \n", "EVEREST ENERGY | \n", "9243148 | \n", "fe16241b4f45168faa94269633b52a4336b0c9d6e4c76b... | \n", "\n", " | \n", " | NaT | \n", "
| 3 | \n", "PIONEER | \n", "9256602 | \n", "72674aadb46c52864d2fa32ef49361f6873fd11c69574c... | \n", "\n", " | \n", " | NaT | \n", "
| 4 | \n", "PIONEER | \n", "9256602 | \n", "72674aadb46c52864d2fa32ef49361f6873fd11c69574c... | \n", "NEW ENERGY | \n", "9324277.0 | \n", "2024-08-22 00:00:00+00:00 | \n", "
| \n", " | lat | \n", "lon | \n", "vessel_id | \n", "timestamp | \n", "heading | \n", "speed | \n", "vessel_name | \n", "
|---|---|---|---|---|---|---|---|
| 0 | \n", "36.508051 | \n", "-6.617987 | \n", "3bc8490a0c382976 | \n", "2024-07-22T00:00:00.000Z | \n", "323.0 | \n", "0.0 | \n", "NEW ENERGY | \n", "
| 400 | \n", "36.125384 | \n", "-6.286485 | \n", "79138d1707099e3e | \n", "2024-07-22T00:00:00.000Z | \n", "119.0 | \n", "0.0 | \n", "ASYA ENERGY | \n", "
| 626 | \n", "24.108015 | \n", "58.110195 | \n", "fe16241b4f45168f | \n", "2024-07-22T00:00:00.000Z | \n", "112.5 | \n", "16.4 | \n", "EVEREST ENERGY | \n", "
| 170 | \n", "72.063506 | \n", "22.505845 | \n", "72674aadb46c5286 | \n", "2024-07-22T00:00:00.000Z | \n", "72.4 | \n", "8.2 | \n", "PIONEER | \n", "
| 1 | \n", "36.510765 | \n", "-6.614753 | \n", "3bc8490a0c382976 | \n", "2024-07-22T06:00:00.000Z | \n", "92.0 | \n", "0.0 | \n", "NEW ENERGY | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 841 | \n", "56.911525 | \n", "166.064280 | \n", "fe16241b4f45168f | \n", "2024-09-17T06:00:00.000Z | \n", "231.9 | \n", "11.1 | \n", "EVEREST ENERGY | \n", "
| 843 | \n", "31.603944 | \n", "32.302289 | \n", "72674aadb46c5286 | \n", "2024-09-17T07:07:59.000Z | \n", "41.9 | \n", "0.0 | \n", "PIONEER | \n", "
| 842 | \n", "47.111453 | \n", "-11.049882 | \n", "3bc8490a0c382976 | \n", "2024-09-17T07:10:04.000Z | \n", "0.0 | \n", "12.0 | \n", "NEW ENERGY | \n", "
| 845 | \n", "56.911525 | \n", "166.064280 | \n", "fe16241b4f45168f | \n", "2024-09-17T07:12:01.000Z | \n", "231.9 | \n", "11.1 | \n", "EVEREST ENERGY | \n", "
| 844 | \n", "76.308124 | \n", "87.467347 | \n", "79138d1707099e3e | \n", "2024-09-17T07:12:26.000Z | \n", "55.0 | \n", "10.0 | \n", "ASYA ENERGY | \n", "
845 rows × 7 columns
\n", "