taxonomy().concept(ferc:ScheduleTransmissionSystemPeakDeliveriesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2ScheduleTitle").text
Transmission System Peak Deliveries
|
taxonomy().concept(ferc:ScheduleTransmissionSystemPeakDeliveriesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Instructions").text
- Report below the total transmission system deliveries of gas (in Dth), excluding deliveries to storage, for the period of system peak deliveries indicated below, during the 12 months embracing the heating season overlapping the year's end for which this report is submitted. The season's peak normally will be reached before the due date of this report, April 30, which permits inclusion of the peak information required on this page. Add rows as necessary to report all data. Number additional rows 6.01, 6.02, etc.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleTransmissionSystemPeakDeliveriesAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "518 - Schedule - Transmission System Peak Deliveries - Single Day Peak Deliveries")
$headings = list(for $ref in $headings
list($ref.part-by-name(ferc-part:Column).part-value, $ref.part-by-name(ferc-part:ColumnName).part-value))
$heading_dict = dict(for $row in $headings
list("("+$row[1]+")",$row[2])
);
for $row in $heading_dict.keys.sort
$heading_dict[$row]
Description
$row
(a)
|
|
taxonomy().concept(ferc:SingleDayPeakDeliveriesMember).label("http://ferc.gov/form/2020-01-01/roles/label/F2PeakDeliveries").text
SECTION A: SINGLE DAY PEAK DELIVERIES
|
|
|
|
1 |
taxonomy().concept(ferc:StartDatePeakDeliveries).label("http://ferc.gov/form/2020-01-01/roles/label/F2PeakDeliveries").text
Dates:
max(list([covered @concept=ferc:DescriptiveStartDateForPeakDeliveries @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period=$currentDuration]))
Date: 5/25/2018
|
|
|
|
2 |
taxonomy().concept(ferc:VolumesOfGasTransportedAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2PeakDeliveries").text
Volumes of Gas Transported
|
|
|
|
$data = navigate parent-child descendants from ferc:VolumesOfGasTransportedAbstract role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/TransmissionSystemPeakDeliveriesSingleDay" returns list (target-name, preferred-label, result-order);
$data-labels = list(for $row in $data
$concept = taxonomy().concept($row[1]);
$row_num = (filter $concept.references("http://ferc.gov/form/2020-01-01/roles/reference/formLocation") where ($item.part-by-name(ferc-part:Schedule).part-value == "518 - Schedule - Transmission System Peak Deliveries - Single Day Peak Deliveries" and $item.part-by-name(ferc-part:ValueType).part-value.string == "Label")).to-list;
$total = if list([covered @concept = $row[1] @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period = $currentDuration]))
else
none
$interstate = if list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period = $currentDuration]))
else
none
$others = if list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period = $currentDuration]))
else
none
list($concept,
$concept.label($row[2].role.uri).text,
if ($row_num.part-by-name(ferc-part:Row)).length > 0
($row_num.part-by-name(ferc-part:Row))[1].part-value
else
"",
$interstate,
$others,
$total
));
for $rowl in $data-labels
$rowl[3]
1
|
|
$rowl[4]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[5]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[6]
if $rowl[1].is-abstract "gray-out" else ""
|
6 |
taxonomy().concept(ferc:OtherTransportationVolumesOfGasTransported).label("http://ferc.gov/form/2020-01-01/roles/label/F2PeakDeliveries").text
Other (describe)
|
|
|
|
// adding a comment
$data2 = list(for $i in range(1)
list($i,none,none,none,none)
);
$data = if count(list({covered @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=*})) > 0
list({covered @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @ferc:TransmissionSystemDeliveriesToAxis=* @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=* @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @ferc:TransmissionSystemDeliveriesToAxis=* @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=* @period=$currentDuration}))
else
0,
if exists({@ferc:DescriptionOfTransmissionSystemDeliveriesOfGasGasTransported @unit @ferc:TransmissionSystemDeliveriesToAxis!=* @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=* @period=$currentDuration})
first(list({@ferc:DescriptionOfTransmissionSystemDeliveriesOfGasGasTransported @unit @ferc:TransmissionSystemDeliveriesToAxis!=* @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=* @period=$currentDuration}))
else
none,
if exists({@ferc:OtherTransportationVolumesOfGasTransported @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=* @unit @period=$currentDuration})
first(list({@ferc:OtherTransportationVolumesOfGasTransported @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=* @unit @period=$currentDuration} ))
else
none,
if exists({@ferc:OtherTransportationVolumesOfGasTransported @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=* @unit @period=$currentDuration})
first(list({@ferc:OtherTransportationVolumesOfGasTransported @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=* @unit @period=$currentDuration} ))
else
none,
if exists({@ferc:OtherTransportationVolumesOfGasTransported @ferc:TransmissionSystemDeliveriesToAxis!=* @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=* @unit @period=$currentDuration})
first(list({@ferc:OtherTransportationVolumesOfGasTransported @ferc:TransmissionSystemDeliveriesToAxis!=* @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=* @unit @period=$currentDuration} ))
else
none,
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
6
1
|
$row[2]
Minor Project
|
$row[3]
10 dth
|
$row[4]
10 dth
|
$row[5]
10 dth
|
7 |
taxonomy().concept(ferc:VolumesOfGasTransported).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
TOTAL
|
max(list([covered @concept=ferc:VolumesOfGasTransported @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period=$currentDuration]))
100 Dth
|
max(list([covered @concept=ferc:VolumesOfGasTransported @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period=$currentDuration]))
100 Dth
|
max(list([covered @concept=ferc:VolumesOfGasTransported @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period=$currentDuration]))
100 Dth
|
8 |
taxonomy().concept(ferc:VolumesOfGasWithdrawnFromStorageUnderStorageContractAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2PeakDeliveries").text
Volumes of gas Withdrawn from Storage under Storage Contract
|
|
|
|
$data = navigate parent-child descendants from ferc:VolumesOfGasWithdrawnFromStorageUnderStorageContractAbstract role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/TransmissionSystemPeakDeliveriesSingleDay" returns list (target-name, preferred-label, result-order);
$data-labels = list(for $row in $data
$concept = taxonomy().concept($row[1]);
$row_num = (filter $concept.references("http://ferc.gov/form/2020-01-01/roles/reference/formLocation") where ($item.part-by-name(ferc-part:Schedule).part-value == "518 - Schedule - Transmission System Peak Deliveries - Single Day Peak Deliveries" and $item.part-by-name(ferc-part:ValueType).part-value.string == "Label")).to-list;
$total = if list([covered @concept = $row[1] @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period = $currentDuration]))
else
none
$interstate = if list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period = $currentDuration]))
else
none
$others = if list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period = $currentDuration]))
else
none
list($concept,
$concept.label($row[2].role.uri).text,
if ($row_num.part-by-name(ferc-part:Row)).length > 0
($row_num.part-by-name(ferc-part:Row))[1].part-value
else
"",
$interstate,
$others,
$total
));
for $rowl in $data-labels
$rowl[3]
1
|
|
$rowl[4]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[5]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[6]
if $rowl[1].is-abstract "gray-out" else ""
|
12 |
taxonomy().concept(ferc:OtherTransportationVolumesOfGasTransported).label("http://ferc.gov/form/2020-01-01/roles/label/F2PeakDeliveries").text
Other (describe)
|
|
|
|
// adding a comment
$data2 = list(for $i in range(1)
list($i,none,none,none,none)
);
$data = if count(list({covered @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasWithdrawnAxis=*})) > 0
list({covered @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasWithdrawnAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @ferc:TransmissionSystemDeliveriesToAxis=* @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasWithdrawnAxis=* @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @ferc:TransmissionSystemDeliveriesToAxis=* @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasWithdrawnAxis=* @period=$currentDuration}))
else
0,
if exists({@ferc:DescriptionOfTransmissionSystemDeliveriesOfGasGasTransported @unit @ferc:TransmissionSystemDeliveriesToAxis!=* @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasWithdrawnAxis=* @period=$currentDuration})
first(list({@ferc:DescriptionOfTransmissionSystemDeliveriesOfGasGasTransported @unit @ferc:TransmissionSystemDeliveriesToAxis!=* @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasWithdrawnAxis=* @period=$currentDuration} ))
else
none,
if exists({@ferc:OtherStorageVolumesOfGasWithdrawnFromStorageUnderStorageContract @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasWithdrawnAxis=* @unit @period=$currentDuration})
first(list({@ferc:OtherStorageVolumesOfGasWithdrawnFromStorageUnderStorageContract @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasWithdrawnAxis=* @unit @period=$currentDuration} ))
else
none,
if exists({@ferc:OtherStorageVolumesOfGasWithdrawnFromStorageUnderStorageContract @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasWithdrawnAxis=* @unit @period=$currentDuration})
first(list({@ferc:OtherStorageVolumesOfGasWithdrawnFromStorageUnderStorageContract @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasWithdrawnAxis=* @unit @period=$currentDuration}))
else
none,
if exists({@ferc:OtherStorageVolumesOfGasWithdrawnFromStorageUnderStorageContract @ferc:TransmissionSystemDeliveriesToAxis!=* @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasWithdrawnAxis=* @unit @period=$currentDuration})
first(list({@ferc:OtherStorageVolumesOfGasWithdrawnFromStorageUnderStorageContract @ferc:TransmissionSystemDeliveriesToAxis!=* @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasWithdrawnAxis=* @unit @period=$currentDuration} ))
else
none,
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
12
1
|
$row[2]
Minor Project
|
$row[3]
10 dth
|
$row[4]
10 dth
|
$row[5]
10 dth
|
13 |
taxonomy().concept(ferc:VolumesOfGasWithdrawnFromStorageUnderStorageContract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
TOTAL
|
max(list([covered @concept=ferc:VolumesOfGasWithdrawnFromStorageUnderStorageContract @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:VolumesOfGasWithdrawnFromStorageUnderStorageContract @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:VolumesOfGasWithdrawnFromStorageUnderStorageContract @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period=$currentDuration]))
$4,080,200
|
14 |
taxonomy().concept(ferc:OtherOperationalActivitiesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2PeakDeliveries").text
Other Operational Activities
|
|
|
|
$data = navigate parent-child descendants from ferc:OtherOperationalActivitiesAbstract role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/TransmissionSystemPeakDeliveriesSingleDay" returns list (target-name, preferred-label, result-order);
$data-labels = list(for $row in $data
$concept = taxonomy().concept($row[1]);
$row_num = (filter $concept.references("http://ferc.gov/form/2020-01-01/roles/reference/formLocation") where ($item.part-by-name(ferc-part:Schedule).part-value == "518 - Schedule - Transmission System Peak Deliveries - Single Day Peak Deliveries" and $item.part-by-name(ferc-part:ValueType).part-value.string == "Label")).to-list;
$total = if list([covered @concept = $row[1] @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period = $currentDuration]))
else
none
$interstate = if list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period = $currentDuration]))
else
none
$others = if list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period = $currentDuration]))
else
none
list($concept,
$concept.label($row[2].role.uri).text,
if ($row_num.part-by-name(ferc-part:Row)).length > 0
($row_num.part-by-name(ferc-part:Row))[1].part-value
else
"",
$interstate,
$others,
$total
));
for $rowl in $data-labels
$rowl[3]
1
|
|
$rowl[4]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[5]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[6]
if $rowl[1].is-abstract "gray-out" else ""
|
17 |
taxonomy().concept(ferc:OtherOtherOperationalActivities).label("http://ferc.gov/form/2020-01-01/roles/label/F2PeakDeliveries").text
Other (describe)
|
|
|
|
// adding a comment
$data2 = list(for $i in range(1)
list($i,none,none,none,none)
);
$data = if count(list({covered @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember
@ferc:TransmissionSystemDeliveriesOfGasOtherOperationalActivitiesAxis=*})) > 0
list({covered @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasOtherOperationalActivitiesAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @ferc:TransmissionSystemDeliveriesToAxis=* @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period=$currentDuration}))
else
0,
if exists({@ferc:DescriptionOfTransmissionSystemDeliveriesOfGasGasTransported @unit @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period=$currentDuration})
first(list({@ferc:DescriptionOfTransmissionSystemDeliveriesOfGasGasTransported @unit @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period=$currentDuration}))
else
none,
if exists({@ferc:OtherOtherOperationalActivities @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @unit @period=$currentDuration})
first(list({@ferc:OtherOtherOperationalActivities @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:OtherOtherOperationalActivities @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @unit @period=$currentDuration})
first(list({@ferc:OtherOtherOperationalActivities @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @unit @period=$currentDuration} ))
else
none,
if exists({@ferc:OtherOtherOperationalActivities @ferc:TransmissionSystemDeliveriesToAxis=none @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @unit @period=$currentDuration})
first(list({@ferc:OtherOtherOperationalActivities @ferc:TransmissionSystemDeliveriesToAxis=none @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @unit @period=$currentDuration}))
else
none,
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
17
1
|
$row[2]
Minor Project
|
$row[3]
10 dth
|
$row[4]
10 dth
|
$row[5]
10 dth
|
18 |
taxonomy().concept(ferc:OtherOperationalActivities).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
TOTAL
|
max(list([covered @concept=ferc:OtherOperationalActivities @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:OtherOperationalActivities @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:OtherOperationalActivities @ferc:PeakDeliveryDayTypeAxis=ferc:SingleDayPeakDeliveriesMember @period=$currentDuration]))
$4,080,200
|
19 |
taxonomy().concept(ferc:ThreeDayPeakDeliveriesMember).label("http://ferc.gov/form/2020-01-01/roles/label/F2PeakDeliveries").text
SECTION B: CONSECUTIVE THREE_DAY PEAK DELIVERIES
|
|
|
|
20 |
taxonomy().concept(ferc:StartDatePeakDeliveries).label("http://ferc.gov/form/2020-01-01/roles/label/F2PeakDeliveries").text
Dates:
max(list([covered @concept=ferc:DescriptiveStartDateForPeakDeliveries @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period=$currentDuration]))
Dates: 5/26/2018-5/28/2018
|
|
|
|
$data = navigate parent-child descendants from ferc:VolumesOfGasTransportedAbstract role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/TransmissionSystemPeakDeliveriesThreeDay" returns list (target-name, preferred-label, result-order);
$data-labels = list(for $row in $data
$concept = taxonomy().concept($row[1]);
$row_num = (filter $concept.references("http://ferc.gov/form/2020-01-01/roles/reference/formLocation") where ($item.part-by-name(ferc-part:Schedule).part-value == "518 - Schedule - Transmission System Peak Deliveries - Three-Day Peak Deliveries" and $item.part-by-name(ferc-part:ValueType).part-value.string == "Label")).to-list;
$total = if list([covered @concept = $row[1] @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period = $currentDuration]))
else
none
$interstate = if list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period = $currentDuration]))
else
none
$others = if list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period = $currentDuration]))
else
none
list($concept,
$concept.label($row[2].role.uri).text,
if ($row_num.part-by-name(ferc-part:Row)).length > 0
($row_num.part-by-name(ferc-part:Row))[1].part-value
else
"",
$interstate,
$others,
$total
));
for $rowl in $data-labels
$rowl[3]
1
|
|
$rowl[4]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[5]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[6]
if $rowl[1].is-abstract "gray-out" else ""
|
25 |
taxonomy().concept(ferc:OtherTransportationVolumesOfGasTransported).label("http://ferc.gov/form/2020-01-01/roles/label/F2PeakDeliveries").text
Other (describe)
|
|
|
|
// adding a comment
$data2 = list(for $i in range(1)
list($i,none,none,none,none)
);
$data = if count(list({covered @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=*})) > 0
list({covered @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @ferc:TransmissionSystemDeliveriesToAxis=* @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=* @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @ferc:TransmissionSystemDeliveriesToAxis=* @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=* @period=$currentDuration}))
else
0,
if exists({@ferc:DescriptionOfTransmissionSystemDeliveriesOfGasGasTransported @unit @ferc:TransmissionSystemDeliveriesToAxis!=* @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=* @period=$currentDuration})
first(list({@ferc:DescriptionOfTransmissionSystemDeliveriesOfGasGasTransported @unit @ferc:TransmissionSystemDeliveriesToAxis!=* @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=* @period=$currentDuration}))
else
none,
if exists({@ferc:OtherTransportationVolumesOfGasTransported @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=* @unit @period=$currentDuration})
first(list({@ferc:OtherTransportationVolumesOfGasTransported @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=* @unit @period=$currentDuration}))
else
none,
if exists({@ferc:OtherTransportationVolumesOfGasTransported @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=* @unit @period=$currentDuration})
first(list({@ferc:OtherTransportationVolumesOfGasTransported @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=* @unit @period=$currentDuration}))
else
none,
if exists({@ferc:OtherTransportationVolumesOfGasTransported @ferc:TransmissionSystemDeliveriesToAxis!=* @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=* @unit @period=$currentDuration})
first(list({@ferc:OtherTransportationVolumesOfGasTransported @ferc:TransmissionSystemDeliveriesToAxis!=* @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @ferc:TransmissionSystemDeliveriesOfGasGasTransportedAxis=* @unit @period=$currentDuration}))
else
none,
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
25
1
|
$row[2]
Minor Project
|
$row[3]
10 dth
|
$row[4]
10 dth
|
$row[5]
10 dth
|
26 |
taxonomy().concept(ferc:VolumesOfGasTransported).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
TOTAL
|
max(list([covered @concept=ferc:VolumesOfGasTransported @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:VolumesOfGasTransported @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period=$currentDuration]))
$4,080,200
|
max(list([covered @concept=ferc:VolumesOfGasTransported @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period=$currentDuration]))
$4,080,200
|
27 |
taxonomy().concept(ferc:VolumesOfGasWithdrawnFromStorageUnderStorageContractAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2PeakDeliveries").text
Volumes of gas Withdrawn from Storage under Storage Contract
|
|
|
|
$data = navigate parent-child descendants from ferc:VolumesOfGasWithdrawnFromStorageUnderStorageContractAbstract role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/TransmissionSystemPeakDeliveriesThreeDay" returns list (target-name, preferred-label, result-order);
$data-labels = list(for $row in $data
$concept = taxonomy().concept($row[1]);
$row_num = (filter $concept.references("http://ferc.gov/form/2020-01-01/roles/reference/formLocation") where ($item.part-by-name(ferc-part:Schedule).part-value == "518 - Schedule - Transmission System Peak Deliveries - Three-Day Peak Deliveries" and $item.part-by-name(ferc-part:ValueType).part-value.string == "Label")).to-list;
$total = if list([covered @concept = $row[1] @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period = $currentDuration]))
else
none
$interstate = if list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period = $currentDuration]))
else
none
$others = if list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period = $currentDuration]))
else
none
list($concept,
$concept.label($row[2].role.uri).text,
if ($row_num.part-by-name(ferc-part:Row)).length > 0
($row_num.part-by-name(ferc-part:Row))[1].part-value
else
"",
$interstate,
$others,
$total
));
for $rowl in $data-labels
$rowl[3]
1
|
|
$rowl[4]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[5]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[6]
if $rowl[1].is-abstract "gray-out" else ""
|
31 |
taxonomy().concept(ferc:OtherTransportationVolumesOfGasTransported).label("http://ferc.gov/form/2020-01-01/roles/label/F2PeakDeliveries").text
Other (describe)
|
|
|
|
// adding a comment
$data2 = list(for $i in range(1)
list($i,none,none,none,none)
);
$data = if count(list({covered @ferc:TransmissionSystemDeliveriesOfGasGasWithdrawnAxis=*})) > 0
list({covered @ferc:TransmissionSystemDeliveriesOfGasGasWithdrawnAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period=$currentDuration}))
else
0,
if exists({@ferc:DescriptionOfTransmissionSystemDeliveriesOfGasGasTransported @unit @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period=$currentDuration})
first(list({@ferc:DescriptionOfTransmissionSystemDeliveriesOfGasGasTransported @unit @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period=$currentDuration}))
else
none,
if exists({@ferc:OtherStorageVolumesOfGasWithdrawnFromStorageUnderStorageContract @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @unit @period=$currentDuration})
first(list({@ferc:OtherStorageVolumesOfGasWithdrawnFromStorageUnderStorageContract @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:OtherStorageVolumesOfGasWithdrawnFromStorageUnderStorageContract @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @unit @period=$currentDuration})
first(list({@ferc:OtherStorageVolumesOfGasWithdrawnFromStorageUnderStorageContract @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:OtherStorageVolumesOfGasWithdrawnFromStorageUnderStorageContract @ferc:TransmissionSystemDeliveriesToAxis=none @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @unit @period=$currentDuration})
first(list({@ferc:OtherStorageVolumesOfGasWithdrawnFromStorageUnderStorageContract @ferc:TransmissionSystemDeliveriesToAxis=none @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @unit @period=$currentDuration}))
else
none,
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
31
1
|
$row[2]
Minor Project
|
$row[3]
10 dth
|
$row[4]
10 dth
|
$row[5]
10 dth
|
32 |
taxonomy().concept(ferc:VolumesOfGasWithdrawnFromStorageUnderStorageContract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
TOTAL
|
max(list([covered @concept=ferc:VolumesOfGasWithdrawnFromStorageUnderStorageContract @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period=$currentDuration]))
4,080,200 Dth
|
max(list([covered @concept=ferc:VolumesOfGasWithdrawnFromStorageUnderStorageContract @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period=$currentDuration]))
4,080,200 Dth
|
max(list([covered @concept=ferc:VolumesOfGasWithdrawnFromStorageUnderStorageContract @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period=$currentDuration]))
4,080,200 Dth
|
33 |
taxonomy().concept(ferc:OtherOperationalActivitiesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2PeakDeliveries").text
Other Operational Activities
|
|
|
|
$data = navigate parent-child descendants from ferc:OtherOperationalActivitiesAbstract role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/TransmissionSystemPeakDeliveriesThreeDay" returns list (target-name, preferred-label, result-order);
$data-labels = list(for $row in $data
$concept = taxonomy().concept($row[1]);
$row_num = (filter $concept.references("http://ferc.gov/form/2020-01-01/roles/reference/formLocation") where ($item.part-by-name(ferc-part:Schedule).part-value == "518 - Schedule - Transmission System Peak Deliveries - Three-Day Peak Deliveries" and $item.part-by-name(ferc-part:ValueType).part-value.string == "Label")).to-list;
$total = if list([covered @concept = $row[1] @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period = $currentDuration]))
else
none
$interstate = if list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period = $currentDuration]))
else
none
$others = if list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period = $currentDuration]).length > 0
first(list([covered @concept = $row[1] @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period = $currentDuration]))
else
none
list($concept,
$concept.label($row[2].role.uri).text,
if ($row_num.part-by-name(ferc-part:Row)).length > 0
($row_num.part-by-name(ferc-part:Row))[1].part-value
else
"",
$interstate,
$others,
$total
));
for $rowl in $data-labels
$rowl[3]
1
|
|
$rowl[4]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[5]
if $rowl[1].is-abstract "gray-out" else ""
|
$rowl[6]
if $rowl[1].is-abstract "gray-out" else ""
|
36 |
taxonomy().concept(ferc:OtherOtherOperationalActivities).label("http://ferc.gov/form/2020-01-01/roles/label/F2PeakDeliveries").text
Other (describe)
|
|
|
|
// adding a comment
$data2 = list(for $i in range(1)
list($i,none,none,none,none)
);
$data = if count(list({covered @ferc:TransmissionSystemDeliveriesToAxis
@ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember
@ferc:TransmissionSystemDeliveriesOfGasOtherOperationalActivitiesAxis=*})) > 0
list({covered @ferc:TransmissionSystemDeliveriesOfGasOtherOperationalActivitiesAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period=$currentDuration}))
else
0,
if exists({@ferc:DescriptionOfTransmissionSystemDeliveriesOfGasGasTransported @unit @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period=$currentDuration})
first(list({@ferc:DescriptionOfTransmissionSystemDeliveriesOfGasGasTransported @unit @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period=$currentDuration}))
else
none,
if exists({@ferc:OtherOtherOperationalActivities @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @unit @period=$currentDuration})
first(list({@ferc:OtherOtherOperationalActivities @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:OtherOtherOperationalActivities @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @unit @period=$currentDuration})
first(list({@ferc:OtherOtherOperationalActivities @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:OtherOtherOperationalActivities @ferc:TransmissionSystemDeliveriesToAxis=none @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @unit @period=$currentDuration})
first(list({@ferc:OtherOtherOperationalActivities @ferc:TransmissionSystemDeliveriesToAxis=none @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @unit @period=$currentDuration}))
else
none,
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
36
1
|
$row[2]
Minor Project
|
$row[3]
10 dth
|
$row[4]
10 dth
|
$row[5]
10 dth
|
37 |
taxonomy().concept(ferc:OtherOperationalActivities).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
TOTAL
|
max(list([covered @concept=ferc:OtherOperationalActivities @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToInterstatePipelinesMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period=$currentDuration]))
4,080,200 Dth
|
max(list([covered @concept=ferc:OtherOperationalActivities @ferc:TransmissionSystemDeliveriesToAxis=ferc:DeliveredToOthersMember @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period=$currentDuration]))
4,080,200 Dth
|
max(list([covered @concept=ferc:OtherOperationalActivities @ferc:PeakDeliveryDayTypeAxis=ferc:ThreeDayPeakDeliveriesMember @period=$currentDuration]))
4,080,200 dth
|