Samples from a port
Mapped from Data for Digital Twin_MAK1 Kvarken Ports.xlsx. Columns in message comments refer to columns in the excel file. Some data is mocked for illustrational purposes.
Estimated time of arrival for ship SCA OBBOLA to Port of Umeå is 2023-09-01 at 7:22. Estimate was reported on 2023-08-21 at 17:48 by Grieg (a system identity)
{
"payload": {
"@type": "LocationState",
"comment": "Column D",
"timeType": "estimated",
"referenceObject": "tcmf:reference_object:ship:name:SCA OBBOLA",
"timeSequence": "arrived_to",
"location": "tcmf:location:port:SEUME",
"time": "2023-09-01T07:22:00.000Z"
},
"grouping": [
"tcmf:grouping:ship:name:SCA OBBOLA",// Column L
"tcmf:grouping:ship:portcall_id:grieg:1556" // Column C
"tcmf:grouping:shipping_agent:SCA SHIPPING AB" // ? Column J
],
"messageId": "tcmf:message:677ff7cf-e4ea-44c6-94ec-e110d8634c29",
"reportedAt": "2023-08-21T17:48:52.100Z",
"reportedBy": "tcmf:user:grieg",
"version": "0.0.7"
}
Estimated time of arrival for ship SCA OBBOLA to Port of Umeå is 2023-09-01 at 7:32. Estimate was reported on 2023-08-30 at 22:48 by Grieg:AI, to indicate this is a predicted time
{
"payload": {
"@type": "LocationState",
"comment": "Column E",
"timeType": "estimated",
"referenceObject": "tcmf:reference_object:ship:name:SCA OBBOLA",
"timeSequence": "arrived_to",
"location": "tcmf:location:port:SEUME",
"time": "2023-09-01T07:32:00.000Z"
},
"grouping": [
"tcmf:grouping:ship:name:SCA OBBOLA",
"tcmf:grouping:ship:portcall_id:grieg:1556"
],
"messageId": "tcmf:message:677ff7cf-e4ea-44c6-94ec-e110d8634c29",
"reportedAt": "2023-08-30T22:48:52.100Z",
"reportedBy": "tcmf:user:grieg:AI",
"version": "0.0.7"
}
Actual arrival
Actual time of arrival for ship SCA OBBOLA is 2023-09-01 at 7:48
{
"payload": {
"@type": "LocationState",
"comment": "Column F, Column I",
"timeType": "actual",
"referenceObject": "tcmf:reference_object:ship:name:SCA OBBOLA",
"timeSequence": "arrived_to",
"location": "tcmf:location:port:SEUME:Södra Kajen",
"time": "2023-09-01T07:48:00.000Z"
},
"grouping": [
"tcmf:grouping:ship:name:SCA OBBOLA",
"tcmf:grouping:ship:portcall_id:grieg:1556"
],
"messageId": "tcmf:message:677ff7cf-e4ea-44c6-94ec-e110d8634c29",
"reportedAt": "2023-09-01T07:48:52.100Z",
"reportedBy": "tcmf:user:grieg",
"version": "0.0.7"
}
Estimated time of departure is 2023-09-01 at 19:00
{
"payload": {
"@type": "LocationState",
"comment": "Column G",
"timeType": "estimated",
"referenceObject": "tcmf:reference_object:ship:name:SCA OBBOLA",
"timeSequence": "departed_from",
"location": "tcmf:location:port:SEUME",
"time": "2023-09-01T19:00:00.000Z"
},
"grouping": [
"tcmf:grouping:ship:name:SCA OBBOLA",
"tcmf:grouping:ship:portcall_id:grieg:1556"
],
"messageId": "tcmf:message:677ff7cf-e4ea-44c6-94ec-e110d8634c29",
"reportedAt": "2023-08-21T17:48:52.100Z",
"reportedBy": "tcmf:user:grieg",
"version": "0.0.7"
}
Actual departure
Actual time of departure is 2023-09-01 at 19:20
{
"payload": {
"@type": "LocationState",
"comment": "Column H, Column I",
"timeType": "actual",
"referenceObject": "tcmf:reference_object:ship:name:SCA OBBOLA",
"timeSequence": "departed_from",
"location": "tcmf:location:port:SEUME:Södra Kajen",
"time": "2023-09-01T19:20:00.000Z"
},
"grouping": [
"tcmf:grouping:ship:name:SCA OBBOLA",
"tcmf:grouping:ship:portcall_id:grieg:1556"
],
"messageId": "tcmf:message:677ff7cf-e4ea-44c6-94ec-e110d8634c29",
"reportedAt": "2023-09-01T19:20:52.100Z",
"reportedBy": "tcmf:user:grieg",
"version": "0.0.7"
}
For port call 1556, as identified by Grieg, the vessel is planned to be of type roro
{
"payload": {
"@type": "AttributeState",
"comment": "Column K (time from estimated in column D)",
"timeType": "planned",
"referenceObject": "tcmf:reference_object:ship:portcall_id:grieg:1556",
"attribute": "tcmf:attribute:vessel_type:roro",
"timeSequence": "set",
"time": "2023-09-01T07:22:00.000Z",
"location": "tcmf:location:port:SEUME"
},
"grouping": [
"tcmf:grouping:ship:name:SCA OBBOLA",
"tcmf:grouping:ship:portcall_id:1556"
],
"messageId": "tcmf:message:24bc2737-6500-4a5f-a197-950377d1e0b6",
"reportedAt": "2023-08-21T17:48:52.100Z",
"reportedBy": "tcmf:user:grieg",
"version": "0.0.7"
}
For port call 1556, the vessel name is planned to be SCA OBBOLA
{
"payload": {
"@type": "AttributeState",
"comment": "Column L (time from estimated in column D)",
"timeType": "planned",
"referenceObject": "tcmf:reference_object:ship:portcall_id:grieg:1556",
"attribute": "tcmf:attribute:vessel_name:SCA OBBOLA",
"timeSequence": "set",
"time": "2023-09-01T07:22:00.000Z",
"location": "tcmf:location:port:SEUME"
},
"grouping": [
"tcmf:grouping:ship:name:SCA OBBOLA",
"tcmf:grouping:ship:portcall_id:1556"
],
"messageId": "tcmf:message:24bc2737-6500-4a5f-a197-950377d1e0b6",
"reportedAt": "2023-08-21T17:48:52.100Z",
"reportedBy": "tcmf:user:grieg",
"version": "0.0.7"
}
For port call 1556, the estimated weight of Cargo is 8340.56 metric ton
{
"payload": {
"@type": "AttributeState",
"comment": "Column M (time from estimated in column D)",
"timeType": "estimated",
"referenceObject": "tcmf:reference_object:ship:portcall_id:grieg:1556",
"attribute": "tcmf:attribute:weight_ton:8340.56",
"timeSequence": "set",
"time": "2023-09-01T07:22:00.000Z",
"location": "tcmf:location:port:SEUME"
},
"grouping": [
"tcmf:grouping:ship:name:SCA OBBOLA",
"tcmf:grouping:ship:portcall_id:1556"
],
"messageId": "tcmf:message:24bc2737-6500-4a5f-a197-950377d1e0b6",
"reportedAt": "2023-08-21T17:48:52.100Z",
"reportedBy": "tcmf:user:grieg",
"version": "0.0.7"
}
For port call 1556, the actual weight of Cargo is 8040.196 metric ton
{
"payload": {
"@type": "AttributeState",
"comment": "Column N (time from actual in column F)",
"timeType": "actual",
"referenceObject": "tcmf:reference_object:ship:portcall_id:grieg:1556",
"attribute": "tcmf:attribute:weight_ton:8040.19",
"timeSequence": "set",
"time": "2023-09-01T07:48:00.000Z",
"location": "tcmf:location:port:SEUME"
},
"grouping": [
"tcmf:grouping:ship:name:SCA OBBOLA",
"tcmf:grouping:ship:portcall_id:1556"
],
"messageId": "tcmf:message:24bc2737-6500-4a5f-a197-950377d1e0b6",
"reportedAt": "2023-09-01T07:48:52.100Z",
"reportedBy": "tcmf:user:grieg",
"version": "0.0.7"
}
For port call 1556, the actual type of cargo is Kraftliner
{
"payload": {
"@type": "AttributeState",
"comment": "Column R (time from actual in column F)",
"timeType": "actual",
"referenceObject": "tcmf:reference_object:ship:portcall_id:grieg:1556",
"attribute": "tcmf:attribute:cargo_type:kraftliner",
"timeSequence": "set",
"time": "2023-09-01T07:48:00.000Z",
"location": "tcmf:location:port:SEUME"
},
"grouping": [
"tcmf:grouping:ship:name:SCA OBBOLA",
"tcmf:grouping:ship:portcall_id:1556"
],
"messageId": "tcmf:message:24bc2737-6500-4a5f-a197-950377d1e0b6",
"reportedAt": "2023-09-01T07:48:52.100Z",
"reportedBy": "tcmf:user:grieg",
"version": "0.0.7"
}
Wrapping the berth visit with service states
{
"payload": {
"@type": "ServiceState",
"comment": "Time from Column F, location specific from column I",
"timeType": "actual",
"referenceObject": "tcmf:reference_object:ship:portcall_id:grieg:1556",
"service": "tcmf:service:berth_visit:quay_visit_id:3036",
"timeSequence": "commenced",
"time": "2023-09-01T07:48:00.000Z",
"location": "tcmf:location:port:SEUME:Södra Kajen"
},
"grouping": [
"tcmf:grouping:ship:name:SCA OBBOLA",
"tcmf:grouping:ship:portcall_id:1556"
],
"messageId": "tcmf:message:b2734285-0e34-4e7e-89b5-3a8db99d67c2",
"reportedAt": "2024-06-13T12:33:41.000Z",
"reportedBy": "tcmf:user:grieg",
"version": "0.0.7"
}
{
"payload": {
"@type": "ServiceState",
"comment": "Time from Column H, location specific from column I",
"timeType": "actual",
"referenceObject": "tcmf:reference_object:ship:portcall_id:grieg:1556",
"service": "tcmf:service:berth_visit:quay_visit_id:3036",
"timeSequence": "completed",
"location": "tcmf:location:port:SEUME:Södra Kajen",
"time": "2023-09-01T19:20:00.000Z"
},
"grouping": [
"tcmf:grouping:ship:name:SCA OBBOLA",
"tcmf:grouping:ship:portcall_id:1556"
],
"messageId": "tcmf:message:b2734285-0e34-4e7e-89b5-3a8db99d67c2",
"reportedAt": "2024-06-13T12:33:41.000Z",
"reportedBy": "tcmf:user:grieg",
"version": "0.0.7"
}
Matching data with other data flows
From grieg.portcalls.tcmf
NB This data is not represented in the excel file Here, we can see that a minor update is needed to how we build port call ids, to avoid conflicting identifiers from different data sources
{
"payload": {
"@type": "LocationState",
"timeType": "actual",
"referenceObject": "tcmf:reference_object:ship:name:AURORA BOTNIA",
"timeSequence": "departed_from",
"location": "tcmf:location:port:SEUME",
"time": "2024-11-13T06:49:48.000Z"
},
"grouping": [
"tcmf:grouping:ship:name:AURORA BOTNIA",
"tcmf:grouping:ship:imo:9878319",
"tcmf:grouping:ship:mmsi:230040000",
"tcmf:grouping:ship:call_sign:OJTR",
"tcmf:grouping:ship:portcall_id:2757"
],
"messageId": "tcmf:message:58ff916c-8682-4b33-bfc1-a9f194de396a",
"reportedAt": "2024-11-13T07:37:00.693Z",
"reportedBy": "tcmf:user:grieg",
"version": "0.0.7"
}
From grieg.loadunits.tcmf
{
"payload": {
"@type": "AttributeState",
"timeType": "actual",
"referenceObject": "tcmf:reference_object:cargo:cargo_id:2219",
"attribute": "tcmf:attribute:weight_ton:1416.77",
"timeSequence": "set",
"time": "2024-11-08T13:01:56.000Z",
"location": "tcmf:location:port:SEUME"
},
"grouping": [
"tcmf:grouping:cargo_carrier:load_unit_id:706",
"tcmf:grouping:ship:portcall_id:2734",
"tcmf:grouping:ship:quay_visit_id:3036"
],
"messageId": "tcmf:message:24bc2737-6500-4a5f-a197-950377d1e0b6",
"reportedAt": "2024-11-18T11:55:58.293Z",
"reportedBy": "tcmf:user:grieg",
"version": "0.0.7"
}
Last modified: 11 March 2025