taxonomy().concept(ferc:ScheduleTransmissionLinesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2ScheduleTitle").text
Transmission Lines
|
taxonomy().concept(ferc:ScheduleTransmissionLinesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Instructions").text
- Report below, by state, the total miles of transmission lines of each transmission system operated by respondent at end of year.
- Report separately any lines held under a title other than full ownership. Designate such lines with an asterisk, in column (b) and in a footnote state the name of owner, or co-owner, nature of respondent's title, and percent ownership if jointly owned.
- Report separately any line that was not operated during the past year. Enter in a footnote the details and state whether the book cost of such a line, or any portion thereof, has been retired in the books of account, or what disposition of the line and its book costs are contemplated.
- Report the number of miles of pipe to one decimal point.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleTransmissionLinesAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "514 - Schedule - Transmission Lines")
$heading = list(for $ref in $headings
list($ref.part-by-name(ferc-part:Column).part-value, $ref.part-by-name(ferc-part:ColumnName).part-value, $ref.part-by-name(ferc-part:ElementName).part-value))
$heading_dict = dict(for $row in $heading
list("("+$row[1]+")",list($row[2],if $row[3] == none "" else taxonomy().concept(to-qname($row[3]))))
);
for $row in $heading_dict.keys.sort
$row
(a)
|
// adding a comment
$data2 = list(for $i in range(25)
list($i,none,none,none,none,none,"")
);
$data = if count(list([covered @ferc:DesignationOfTransmissionLinesAxis=* ])) > 0
list({covered @ferc:DesignationOfTransmissionLinesAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if list({@ferc:DesignationIdentificationOfLineOrGroupOfLines @unit @period=$currentDuration}).length > 0
first(list({@ferc:DesignationIdentificationOfLineOrGroupOfLines @unit @period=$currentDuration}))
else
none,
if list({@ferc:StateOfPipelineCompany @unit @period=$currentDuration}).length > 0
first(list({@ferc:StateOfPipelineCompany @unit @period=$currentDuration}))
else
none,
if list({@ferc:TypeOfOperationAndOwnership @unit @period=$currentDuration}).length > 0
first(list({@ferc:TypeOfOperationAndOwnership @unit @period=$currentDuration}))
else
none,
if list({@ferc:IndicationOfOwnerships @unit @period=$currentDuration}).length > 0
first(list({@ferc:IndicationOfOwnerships @unit @period=$currentDuration}))
else
none,
if list({@ferc:LengthOfTransmissionLinesOfTransmissionSystems @unit @period=$currentInstant}).length > 0
first(list({@ferc:LengthOfTransmissionLinesOfTransmissionSystems @unit @period=$currentInstant}))
else
none,
"Detail"
)}})
else $data2;
$cleanedDimData = list(for $z in $data
if $z == list(0,none,none,none,none,none, "Detail")
skip
else
$z
).sort
$dataOpsTotals = if count(list([covered @ferc:OperationTypeAxis=*])) > 0
list({covered @ferc:OperationTypeAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
none,
none,
none,
none,
if list({@ferc:LengthOfTransmissionLinesOfTransmissionSystems @unit @period=$currentInstant}).length > 0
first(list({@ferc:LengthOfTransmissionLinesOfTransmissionSystems @unit @period=$currentInstant}))
else
none,
"Subtotal" )}})
else skip;
$cleanedDataSubTotal = list(for $z in $dataOpsTotals
if $z == list(0,none,none,none,none,none,"Subtotal")
skip
else
$z
);
$cleanedData = $cleanedDimData + $cleanedDataSubTotal
for $row in $cleanedData.sort
1
|
if ($row[7] =="Detail") $row[2] else if ($row[7]=="Subtotal" and $row[2] == none) "Subtotal " + taxonomy().concept($row[6].dimension(ferc:OperationTypeAxis).name).label("http://ferc.gov/form/2020-01-01/roles/label/F2TransmissionLines").text else $row[2]
if ($row[7]=="Subtotal") "total_items" else ""
not($row[7]=="Subtotal" and $row[2] == none)
Wyoming
|
$row[3]
Wyoming
|
$row[4]
Wyoming
|
$row[5]
Wyoming
|
$row[6]
1160.9 Miles
|
25 |
taxonomy().concept(ferc:LengthOfTransmissionLinesOfTransmissionSystems).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
Total
|
|
|
|
max(list([covered @concept=ferc:LengthOfTransmissionLinesOfTransmissionSystems @period = $currentInstant]))
104,207 Miles
|