Transmission Line Report Documentation

Driver Description

The Transmission Line Report summarizes the information reported by FERC-regulated utilities for all transmission lines and substations. The report also includes the specific assets as reported by the utilities and filtering capabilities to narrow the list of lines by voltage, mileage, supporting structure, year, and company; or substations by attended type, delivery type, or primary voltage level.

• Industry: Electric
• Sub-Industry: Transmission
• Data Timeline: Annual
• Geography: National

Data Sources

FERC Form 1

• Schedule 422 Transmission Line Statistics
• Schedule 426 Substations

Usage

The Transmission Line Report focuses on the lines and substations reported by FERC-regulated utilities in the annual FERC Form 1. The report is designed to allow the user to get both summary-level metrics and dive into the specific assets. Users can compare assets by company and supporting structure and filter assets by those metrics.

Main Screen

The report starts with a high-level overview of key KPIs and metrics that assess the total dataset of transmission lines and substations. You may filter these metrics using the company filter at the top of the screen. The visualizations show all historical data from 2011 to the present. The two icons at the top-left of the screen will help you navigate to the Transmission Line Table and the Substation Table to view the particular assets.

Transmission Line Table

The second part of the report focuses on the particular lines as reported by utilities. The filters at the top of the screen impact both the summary table in the middle of the screen and the larger asset table at the bottom of the screen. The data feeding into this table was cleansed to remove discrepancies in the data and ensure data was similarly categorized. As such, "Supporting Structure" represents the categories as mandated by the FERC and cleaned by HData, while "As Reported Support Structure" is the information as reported verbatim by the utility in the FERC Form 1. The two icons at the top-left of the screen will help you navigate to the Transmission Overview and the Substation Table to view the particular assets.

Substation Table

The last part of the report focuses on substations as reported by utilities. The filters at the top of the screen impact both the summary table in the middle of the screen and the larger asset table at the bottom of the screen, exactly like the transmission table. The data feeding into this table was cleansed to remove discrepancies in the data reported under "delivery type" and "attended type" so it matches the standard set by the FERC. The two icons at the top-left of the screen will help you navigate to the Transmission Overview and the Transmission Table to view the particular assets.

Exporting Visuals and Data

There are several ways in which the driver can be exported. A visual export of the driver via PDF or PowerPoint can be generated via the export button () at the top-right corner of the report. Data can be exported via each card on the report. To export data, move your cursor over the card/table and another export () button will appear at the top-right of the card/table. The data will export into a csv file in a long-table format. An additional feature is the expand details icon on each card. Hovering your cursor over a card/table will show the expand details icon (). The expand details icon will give you a screen as seen below.

Once you click on the expand details icon, a screen will pop-up giving you a few options to interact with that particular card. You can click on the export button at the top-right of the pop-up to export the visualization either in a visual format or the data behind the visualization via CSV or Excel. Clicking the table icon at the top-right of the pop-up will show you the data feeding into the visualization.