Provide Input Master Data for Grid Insights
The input master data specified in this section must be provided in CSV format to Oracle Energy and Water on a regular basis to support the Grid Insights data visualizations.
As an administrator, you can choose the frequency with which to provide this data, but it is recommended that you provide it once a month to keep it as current as possible. A complete snapshot of the specified input master data is required each time it is provided.
To provide this data to Oracle Energy and Water, place the CSV file in your Oracle Cloud Infrastructure Object Storage. Oracle Energy and Water will then sync the data to the Oracle Energy and Water Data Intelligence platform and use it for Grid Insights.
Transformer Geo Coordinates
| Column | Description |
|---|---|
|
TRANSFORMER_ID |
Transformer ID (unique key). Type: VARCHAR2(30 CHAR) Can be empty?: No. |
|
TRANSFORMER_TYPE |
Transformer type (underground or overhead). Type: VARCHAR2(90 CHAR) Can be empty?: No. |
|
STATUS |
Transformer status. Example Values:
Type: VARCHAR2(30 CHAR) Can be empty?: No. |
|
PHASE |
Transformer phase. Do not include any separators. For example, a single phase can be denoted as A. Three phases can be denoted as A, B, and C. Type: VARCHAR2(14 CHAR) Can be empty?: No. |
|
RATING |
Transformer rating (in kVA). Type: NUMBER(35,6) Can be empty?: No. |
|
GEO_LAT |
Transformer latitude. Type: NUMBER(35,6) Can be empty?: No. |
|
GEO_LONG |
Transformer longitude. Type: NUMBER(35,6) Can be empty?: No. |
Feeder Geo Coordinates
| Column | Description |
|---|---|
|
FEEDER_ID |
Feeder ID (unique key). Type: VARCHAR2(30 CHAR) Can be empty?: No. |
|
STATUS |
Feeder status. Example Values:
Type: VARCHAR2(30 CHAR) Can be empty?: No. |
|
GEO_LAT |
Feeder latitude. Type: NUMBER(35,6) Can be empty?: No. |
|
GEO_LONG |
Feeder longitude. Type: NUMBER(35,6) Can be empty?: No. |