- Deutsch: Diese Seite ist nicht ins Deutsche übersetzt
Import Requirements
To be able to perform inspections you must import your assets beforehand (through eSmart System Support or an integration), and upload images as part of "Collect" in the Project Manager in Grid Vision.
Data quality
Your assets must contain a globally unique identifier that makes it possible for you to identify it in your master asset data system. In addition it should contain a name that makes sense for the inspector (i.e a name that can be seen on the power line structure itself) and a correct gps coordinate of the location.
Connecting the assets to a grid segment is also beneficial for easier grouping of assets for the user within Grid Vision.
Images must contain a correct gps coordinate and preferably also information about capture time, camera heading (yaw), pitch and roll. These values are used to automatically connect images to the correct assets. This data can either be embedded as EXIF data in the images file or be stored in a metadata file as described below.
The images must be of good enough quality to visually inspect desired components. For detailed inspections of smaller components the quality must be higher.
Asset information file
The Asset Information file contains reference details about the asset captured in the image. It includes fields such as Identifier, Name, GroupIdentifier, GroupType, Latitude, Longitude, AssetType, SourceSystem, and Height. Grid Vision® uses the asset’s location information to both display the position in the map view and to automatically connect imported images to them. For this to work as intended and for the end user to be able to work efficiently it is important that the location information is as accurate as possible.
The Asset Information file must meet the following specifications:
- Supported formats: CSV, JSON
- Supported file separator: comma (,)
- Supported decimal separator: period (.)
CSV
This document describes the supported CSV format for importing power line structure information into Grid Vision®. Power line structures are the transmission towers (masts, pylons, poles) that supports an overhead power line. The power line structures are also referred to as assets in this document.
The information specified in this format is enough to build a simplified digital version of the asset that the functionality in Grid Vision® relies on. The asset information model, and thus this format, will be extended when needed.
The order of the rows in the file implies the inspection order of the assets in Grid Vision. It is possible to let Grid Vision automatically try to order the assets geographically in the import integration.
The supported file format is CSV using comma (,) as the value delimiter and period (.) as the decimal separator.
Format specification
| Field name | Definition | Supported names (first one is standard) | Field Value | Max Length | Required/Optional | Example |
|---|---|---|---|---|---|---|
| Identifier | A Unique Identifier (unique per source system) associated with the asset. The identifier is an external reference to the asset and not eSmarts internal asset id. | identifier | String | 256 | Required | 0001001 |
| Name | The name of the asset, e.g. the structure name/number. | name | string | 256 | Required | Pole 1 |
| GroupIdentifier | A asset grouping key could be used for line name or number. | group identifier | string | 256 | Required | Line1100 |
| GroupType | The type of component the asset should be grouped at. Only "Line" is supported | group type, grouptype | string | Optional | Line | |
| Latitude | Indicates the latitude of the item. The latitude is expressed as decimal degrees (-90 to 90). SRID: 4326 WGS 84 | latitude, lat (deg), lat(deg), lat | number | Required | 59.125832 | |
| Longitude | Indicates the longitude of the item. The longitude is expressed as decimal degrees (-180 to 180). SRID: 4326 WGS 84 | longitude, lon (deg), lon (deg), lon | number | Required | 11.38942 | |
| AssetType | The type of the asset as defined by eSmart. Only "PowerLineStructure" is supported | asset type, assettype | string | Required | PowerLineStructure | |
| SourceSystem | Source system refers to the name of the system where the asset originates from. Used to guarantee uniqueness in case the customer imports data from several systems with overlapping identifiers. e.g. "Workorder" or "ERP" | source system, sourcesystem | string | 256 | Required | ERPSystem |
| Height | Represents the height of the structure in meters. Measured from ground level. | height | number | Optional | 12.5 |
Flat file format
Identifier,Name,GroupIdentifier,GroupType,Latitude,Longitude,AssetType,SourceSystem,Height
0001001,Pole 1,Line1100,Line,59.125832,11.38942,PowerLineStructure,ERPSystem,12.5
0001002,Pole 2,Line1100,Line,59.125834,11.38942,PowerLineStructure,ERPSystem,12.65
0001003,Pole 3,Line1100,Line,59.125836,11.38942,PowerLineStructure,ERPSystem,12.66
0001004,Pole 4,Line1100,Line,59.125838,11.38942,PowerLineStructure,ERPSystem,12.67
0001010,Pole 10,Line1101,Line,59.125868,11.38962,PowerLineStructure,ERPSystem,12.77
0001011,Pole 11,Line1101,Line,59.125888,11.38964,PowerLineStructure,ERPSystem,12.8
| Identifier | Name | GroupIdentifier | GroupType | Latitude | Longitude | AssetType | SourceSystem | Height |
|---|---|---|---|---|---|---|---|---|
| 0001001 | Pole 1 | Line1100 | Line | 59.125832 | 11.38942 | PowerLineStructure | ERPSystem | 12.5 |
| 0001002 | Pole 2 | Line1100 | Line | 59.125834 | 11.38942 | PowerLineStructure | ERPSystem | 12.65 |
JSON
This document outlines the supported JSON format for importing power line structure information (assets) into Grid Vision®. Power line structures include transmission towers, masts, pylons, and poles supporting overhead power lines.
The provided information enables Grid Vision® to create a simplified digital version of each asset, with the format extending as needed. Accurate asset location data is essential for displaying positions on the map and linking imported images automatically.
The supported format is JSON, with a period (.) as the decimal separator.
Format specification
| Cardinality | Name | Type | Description |
|---|---|---|---|
| 1..1 | name | string | The name of the asset, e.g., the structure name/number. The name will be visible in Grid Vision® to easily find the asset. |
| 1..1 | structureType | string | The type of power line structure. Currently, only the value Tower is supported. Max length: 256 Required value: Tower |
| 1..1 | externalReference | - | A reference to a unique external identifier of the asset (not an internal Grid Vision® asset ID). The combination of externalId and sourceSystemId must be unique across a tenant/company. |
| └── externalId | string | An identifier associated with the asset from the source system defined by sourceSystemId and sourceSystemKind. Recommended max length: 36. Max length: 256 |
|
| └── sourceSystemId | string | Refers to the name or identifier of the system from where the identifier originates. Max length: 256 Example value: SAP or AA673993 |
|
| └── sourceSystemKind | string | Refers to the kind/type of source system from where the asset identifier originates. Max length: 256 Example value: ERP or NIS |
|
| 1..1 | lineExternalReference | - | A reference to a unique external identifier of the powerline that the asset belongs to. The combination of lineExternalId and lineSourceSystemId must be unique across a tenant/company. |
| └── lineExternalId | string | An identifier associated with the powerline from the source system defined by lineSourceSystemId and lineSourceSystemKind. Recommended max length: 36. Max length: 256 |
|
| └── lineSourceSystemId | string | Refers to the name or identifier of the system from where the identifier originates. Max length: 256 Example value: SAP or AA673993 |
|
| └── lineSourceSystemKind | string | Refers to the kind/type of source system from where the powerline identifier originates. Max length: 256 Example value: ERP or NIS |
|
| 0..1 | assetHeightInMeters | number | The height of the asset in meters measured from ground level. Example value: 12.5 |
| 1..1 | location | - | Specifies the location of the asset using latitude and longitude coordinates. Altitude can optionally be specified. |
| └── latitude | number | Indicates the latitude of the asset. The latitude is expressed as decimal degrees between -90 and 90. SRID: 4326 WGS 84. Example value: -10.522301 |
|
| └── longitude | number | Indicates the longitude of the asset. The longitude is expressed as decimal degrees between -180 and 180. SRID: 4326 WGS 84. Example value: 69.84455 |
|
| └── altitude | number | Indicates the altitude of the asset's base above sea level in meters. Example value: 126.3 |
|
| 0..1 | requirementExternalIds | - | A specification of requirements that applies to the asset. This information can be used by Grid Vision® to automatically identify suggestions, guide SME inspectors into what to look for, and add to the asset’s digital representation. Specified as an array of predefined requirement rule keys. Example value: SafetySignRequired, AntiClimbingDeviceRequired |
JSON schema
[
{
"$schema": "https://json-schema.org/draft/2020-12/schema#",
"type": "array",
"items": {
"$ref": "#/$defs/PowerLineStructure"
},
"$defs": {
"PowerLineStructure": {
"type": "object",
"additionalProperties": false,
"properties": {
"externalReference": {
"$ref": "#/$defs/ExternalReference"
},
"lineExternalReference": {
"$ref": "#/$defs/ExternalReference"
},
"assetHeightInMeters": {
"type": "number"
},
"location": {
"$ref": "#/$defs/Location"
},
"name": {
"type": "string"
},
"structureType": {
"type": "string"
},
"requirementExternalIds": {
"type": "array",
"items": {
"type": "string"
}
}
},
"required": [
"externalReference",
"lineExternalReference",
"location",
"name",
"structureType"
]
},
"ExternalReference": {
"type": "object",
"additionalProperties": false,
"properties": {
"externalId": {
"type": "string"
},
"sourceSystemId": {
"type": "string"
},
"sourceSystemKind": {
"type": "string"
}
},
"required": [
"externalId",
"sourceSystemId",
"sourceSystemKind"
],
"title": "ExternalReference"
},
"Location": {
"type": "object",
"additionalProperties": false,
"properties": {
"latitude": {
"type": "number",
"minimum": -90,
"maximum": 90
},
"longitude": {
"type": "number",
"minimum": -180,
"maximum": 180
},
"altitude": {
"type": "number"
}
},
"required": [
"latitude",
"longitude"
],
"title": "Location"
}
}
}
]
Missing required components
To determine if an asset contains components required by regulatory standards, it is necessary to create slightly different asset files. Currently, two components are used to identify any missing required elements: Safety Sign, Anti-Climbing Device
Note:The asset file must be adjusted to reflect any missing required components.
CSV
Identifier Name GroupIdentifier GroupType Latitude Longitude AssetType SourceSystem Height SafetySign.MinCount AntiClimbingDevice.MinCount
ID1 H-1 Line 60.7283977 11.1166493 PowerLineStructure Workorder 2 1
ID2 H-2 Line 60.7279055 11.1170625 PowerLineStructure Workorder 2 0
ID3 H-3 Line 60.7278896 11.117063 PowerLineStructure Workorder
0 1
ID4 H-4 Line 60.7271815 11.1175399 PowerLineStructure Workorder 2 1
Image information file
The Image Information file contains reference details about each image. It includes fields such as Filename, Latitude, Longitude, Altitude, CapturedAt, Yaw, Pitch, Roll, CameraTag, and AssetIdentifier.
This file should be used when the images lack embedded data for latitude, longitude, and capture date. Additionally, it can be utilized when users have specific knowledge of which images correspond to particular assets, in which case the relevant AssetIdentifier must be provided for each image.
The Image Information file must adhere to the following specifications:
- Supported formats: CSV, JSON
- Supported file separator: comma (,)
- Supported decimal separator: period (.)
Format specification
| Field name | Definition | Supported names (first one is standard) | Field Value | Max Length | Required/Optional | Example |
|---|---|---|---|---|---|---|
| Filename | The file name is case-insensitive. It may optionally contain the relative path within the container. It is not supported to do an import where multiple files have the same names within different sub folders (in such cases, it must be split into multiple imports) |
filename, file name, image name, imagename, image | String | Limitation is only in operating system (Windows and MAC) -> 255 | Required | MISSION1001_2020_000001.jpg |
| AssetIdentifier | The unique Identifier associated with the asset. The identifier is an external reference to the asset and not eSmarts internal asset id. | asset identifier, assetidentifier | string | 256 | Optional | 0001001 |
| CapturedAt | The date and time when the image was captured (in UTC). The date should be in conformance with ISO_8601. Format: YYYY-MM-DDTHH:MM:SS.SSSSSSSZ Y: year M: month W : week D : day T : time designator that precedes the time components of the representation. H : hour M : minute S : second |
captured at, capturedat | datetime | Required if Exif-tag does not contain the Capture-date | 2020-02-26T08:48:44.7747628Z | |
| Latitude | Indicates the latitude of the item. The latitude is expressed as decimal degrees (-90 to 90). SRID: 4326 WGS 84 | latitude, lat (deg), lat(deg), lat | number | Required if Exif-tag does not contain the value | 59.125832 | |
| Longitude | Indicates the longitude of the item. The longitude is expressed as decimal degrees (-180 to 180). SRID: 4326 WGS 84 | longitude, lon (deg), lon (deg), lon | number | Required if Exif-tag does not contain the value | 11.38942 | |
| Altitude | Indicates the altitude where the image is recorded. The reference unit meters. Measured from sea level. SRID: 4326 WGS 84 | altitude, alt (m), alt(m), alt | number | Optional | 1.53 | |
| Yaw | The cardinal direction in which the image is captured. Measured in degrees (-180 to 180). 0 degrees indicates North | camera heading, cameraheading, yaw (deg), yaw(deg), yaw | number | Optional | 122.5 | |
| Pitch | The camera's vertical angle (-90 to 90) at the capture time. | camera pitch, camerapitch, pitch (deg), pitch(deg), pitch | number | Optional | 10.2 | |
| Roll | The camera's horizontal angle (-180 to 180) at the capture time. | camera roll, camera roll, roll (deg), roll (deg), roll | number | Optional | 2.5 | |
| CameraTag | This is a free-text to be used for identifying the camera recording the image and will be used to make camera filters in Grid Vision. e.g. differentiating forward-facing or backward-facing cameras. | camera tag, cameratag | string | 36 | Optional | Thermal |
CSV
Filename,AssetIdentifier,CapturedAt,Latitude,Longitude,Altitude,Yaw,Pitch,Roll,CameraTag
MISSION1001_2020_000001.jpg,0001001,2020-02-26T08:48:44.7747628Z,59.125832,11.38942,1.53,122.5,10.2,2.5,Thermal
MISSION1001_2020_000002.jpg,0001001,2020-02-26T08:48:44.7749421Z,59.125842,11.38943,1.53,50.8,10.2,2.5,Camera1
| Filename | AssetIdentifier | CapturedAt | Latitude | Longitude | Altitude | Yaw | Pitch | Roll | CameraTag |
|---|---|---|---|---|---|---|---|---|---|
| MISSION1001_2020_000001.jpg | 0001001 | 2020-02-26T08:48:44.7747628Z | 59.125832 | 11.38942 | 1.53 | 122.5 | 10.2 | 2.5 | Thermal |
| MISSION1001_2020_000002.jpg | 0001001 | 2020-02-26T08:48:44.7749421Z | 59.125842 | 11.38943 | 1.53 | 50.8 | 10.2 | 2.5 | Camera1 |
JSON schema
[
{
"altitude": 1.53,
"assetIdentifier": "0001001",
"cameraTag": "Thermal",
"capturedAt": "2020-02-26T08:48:44.7747628Z",
"filename": "MISSION1001_2020_000001.jpg",
"latitude": 59.125832,
"longitude": 11.38942,
"pitch": 10.2,
"roll": 2.5,
"yaw": 122.5,
},
{
"altitude": 1.53,
"assetIdentifier": "0001001",
"cameraTag": "Camera1",
"capturedAt": "2020-02-26T08:48:44.7749421Z",
"filename": "MISSION1001_2020_000002.jpg",
"latitude": 59.125842,
"longitude": 11.38943,
"pitch": 10.2,
"roll": 2.5,
"yaw": 50.8,
}
]