taxonomy().concept(ferc:ScheduleMilesOfPipelineOperatedAtEndOfYearAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6ScheduleTitle").text
Miles of Pipeline Operated at end of Year
|
taxonomy().concept(ferc:ScheduleMilesOfPipelineOperatedAtEndOfYearAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6Instructions").text
- Give particulars (details) called for by State and termini, concerning the miles of all
pipeline operated, and size of each line at end of year, according to the
classifications given.
- Report miles of pipeline operated to the nearest whole mile adjusted to footings, i.e.,
count ½ mile and over as a whole mile disregarding any fraction less than ½ mile. Report
fractional size line in the next smaller whole size, e.g., report 2-1/2" and 6-5/8"
lines as 2" and 6" lines, respectively. Size of line is defined as inside diameter.
- Report under (A), the lines wholly owned and operated by respondent, including wholly
owned minor facilities temporarily idle or in standby service.
- Report under (B), the total miles of pipeline owned in undivided joint interests and
operated by respondent. Name each pipeline and give names of owning companies.
- Report under (C), the total miles of pipeline owned in undivided joint interests and
operated by others. Name each pipeline and give names of owning companies.
- Report under (D), the respondent operating lines not owned by it, but leased from
others, when leases are for reasonably long terms and consist of an imporant part of the
respondent's pipeline. The lessor company should omit from its schedule such mileages
leased to others.
- Omit minor gathering line facilities under temporary or short-term lease from this
classification; the lessor should include such lines in its wholly owned and operated
lines.
|
|
|
TERMINI |
OP AT END OF YR |
CHG IN MILES OPR DUR THE YR |
|
|
|
GATHERING LINES |
TRUNK LINES FOR CRUDE OIL |
TRUNK LINES FOR PRODUCTS |
INCREASES |
DECREASES |
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleMilesOfPipelineOperatedAtEndOfYearAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "602 - Schedule - Miles of Pipeline Operated at end of Year")
$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
$row[3]
else
taxonomy().concept(to-qname($row[3]))))
);
for $row in $heading_dict.keys.sort
$heading_dict[$row][2].name.local-name
$heading_dict[$row][1]
Nature of Payment
$row
(a)
|
|
(A) OWNED AND OPERATED BY RESPONDENT |
// adding a comment
$data2 = list(for $i in range(2)
list($i,none,none,none,none,none,none,none,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:MilesOfPipelineOperatedAxis=* @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember})) > 0
list({covered @ferc:MilesOfPipelineOperatedAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:NameAndStateOfCompany @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit@period=$currentDuration})
first(list({@ferc:NameAndStateOfCompany @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:PipelineStartPoint @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:PipelineStartPoint @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:PipelineEndPoint @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:PipelineEndPoint @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:MilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:MilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:SizeOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:SizeOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:MilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:MilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:SizeOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:SizeOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:MilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:MilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:SizeOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:SizeOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:IncreaseMilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:IncreaseMilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:IncreaseMilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:IncreaseMilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:IncreaseMilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:IncreaseMilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DecreaseMilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:DecreaseMilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DecreaseMilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:DecreaseMilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DecreaseMilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:DecreaseMilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list($x[1],none,none,none,none,none,none,none,none,none,none,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
ABC Pipeline - Maryland
|
$row[3]
Baltimore
|
$row[4]
Annapolis
|
$row[5]
140,000
|
$row[6]
920,000
|
$row[7]
820,000
|
$row[8]
420,000
|
$row[9]
220,000
|
$row[10]
760,000
|
$row[11]
726,000
|
$row[12]
917,000
|
$row[13]
625,000
|
$row[14]
142,000
|
$row[15]
928,000
|
$row[16]
276,000
|
40 |
Subtotal |
|
|
first(list([covered @concept=ferc:MilesOfGatheringLinesOperated
@ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @period = $currentDuration]))
27,666,233
|
|
first(list([covered @concept=ferc:MilesOfTrunkLinesForCrudeOilOperated
@ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @period = $currentDuration]))
81,982,726
|
|
first(list([covered @concept=ferc:MilesOfTrunkLinesForProductsOperated
@ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @period = $currentDuration]))
25,200,177
|
|
first(list([covered @concept=ferc:IncreaseMilesOfGatheringLinesOperated
@ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @period = $currentDuration]))
428,165,099
|
first(list([covered @concept=ferc:IncreaseMilesOfTrunkLinesForCrudeOilOperated
@ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @period = $currentDuration]))
187,091,726
|
first(list([covered @concept=ferc:IncreaseMilesOfTrunkLinesForProductsOperated
@ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @period = $currentDuration]))
109,837,144
|
first(list([covered @concept=ferc:DecreaseMilesOfGatheringLinesOperated
@ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @period = $currentDuration]))
276,294,299
|
first(list([covered @concept=ferc:DecreaseMilesOfTrunkLinesForCrudeOilOperated
@ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @period = $currentDuration]))
385,531,884
|
first(list([covered @concept=ferc:DecreaseMilesOfTrunkLinesForProductsOperated
@ferc:OwnershipAxis=ferc:WhollyOwnedAndOperatedByRespondentMember @period = $currentDuration]))
385,531,884
|
|
(B) OWNED IN UNDIVIDED JOINT INTEREST AND OPERATED BY RESPONDENT
|
// adding a comment
$data2 = list(for $i in range(2)
list($i,none,none,none,none,none,none,none,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:MilesOfPipelineOperatedAxis=* @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember})) > 0
list({covered @ferc:MilesOfPipelineOperatedAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:NameAndStateOfCompany @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit@period=$currentDuration})
first(list({@ferc:NameAndStateOfCompany @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:PipelineStartPoint @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:PipelineStartPoint @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:PipelineEndPoint @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:PipelineEndPoint @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:MilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:MilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:SizeOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:SizeOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:MilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:MilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:SizeOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:SizeOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:MilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:MilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:SizeOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:SizeOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:IncreaseMilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:IncreaseMilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:IncreaseMilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:IncreaseMilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:IncreaseMilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:IncreaseMilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DecreaseMilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:DecreaseMilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DecreaseMilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:DecreaseMilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DecreaseMilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:DecreaseMilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list($x[1],none,none,none,none,none,none,none,none,none,none,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
DEF Pipeline - California
|
$row[3]
San Francisco
|
$row[4]
Las Angelas
|
$row[5]
726,122
|
$row[6]
938,499
|
$row[7]
552,183
|
$row[8]
399,166
|
$row[9]
982,173
|
$row[10]
168,762
|
$row[11]
276,292
|
$row[12]
736,273
|
$row[13]
663,812
|
$row[14]
822,625
|
$row[15]
928,152
|
$row[16]
772,115
|
40 |
Subtotal |
|
|
first(list([covered @concept=ferc:MilesOfGatheringLinesOperated
@ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @period =
$currentDuration]))
827,721,289
|
|
first(list([covered @concept=ferc:MilesOfTrunkLinesForCrudeOilOperated
@ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @period =
$currentDuration]))
172,847,188
|
|
first(list([covered @concept=ferc:MilesOfTrunkLinesForProductsOperated
@ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @period =
$currentDuration]))
477,177,339
|
|
first(list([covered @concept=ferc:IncreaseMilesOfGatheringLinesOperated
@ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @period =
$currentDuration]))
857,273,948
|
first(list([covered @concept=ferc:IncreaseMilesOfTrunkLinesForCrudeOilOperated
@ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @period =
$currentDuration]))
726,003,827
|
first(list([covered @concept=ferc:IncreaseMilesOfTrunkLinesForProductsOperated
@ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @period =
$currentDuration]))
955,177,837
|
first(list([covered @concept=ferc:DecreaseMilesOfGatheringLinesOperated
@ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @period =
$currentDuration]))
383,576,298
|
first(list([covered @concept=ferc:DecreaseMilesOfTrunkLinesForCrudeOilOperated
@ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @period =
$currentDuration]))
555,999,333
|
first(list([covered @concept=ferc:DecreaseMilesOfTrunkLinesForProductsOperated
@ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByRespondentMember @period =
$currentDuration]))
555,999,333
|
|
(C) OWNED IN UNDIVIDED JOINT INTEREST AND OPERATED BY OTHERS |
// adding a comment
$data2 = list(for $i in range(2)
list($i,none,none,none,none,none,none,none,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:MilesOfPipelineOperatedAxis=* @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember})) > 0
list({covered @ferc:MilesOfPipelineOperatedAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:NameAndStateOfCompany @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit@period=$currentDuration})
first(list({@ferc:NameAndStateOfCompany @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:PipelineStartPoint @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration})
first(list({@ferc:PipelineStartPoint @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:PipelineEndPoint @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration})
first(list({@ferc:PipelineEndPoint @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:MilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration})
first(list({@ferc:MilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:SizeOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration})
first(list({@ferc:SizeOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:MilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration})
first(list({@ferc:MilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:SizeOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration})
first(list({@ferc:SizeOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:MilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration})
first(list({@ferc:MilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:SizeOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration})
first(list({@ferc:SizeOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:IncreaseMilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration})
first(list({@ferc:IncreaseMilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:IncreaseMilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration})
first(list({@ferc:IncreaseMilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:IncreaseMilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration})
first(list({@ferc:IncreaseMilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DecreaseMilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration})
first(list({@ferc:DecreaseMilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DecreaseMilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration})
first(list({@ferc:DecreaseMilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DecreaseMilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration})
first(list({@ferc:DecreaseMilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list($x[1],none,none,none,none,none,none,none,none,none,none,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
GHI Pipeline - Colorado
|
$row[3]
Denver
|
$row[4]
Breckenridge
|
$row[5]
837,666
|
$row[6]
111,111
|
$row[7]
222,222
|
$row[8]
333,333
|
$row[9]
444,444
|
$row[10]
555,555
|
$row[11]
666,666
|
$row[12]
777,777
|
$row[13]
888,888
|
$row[14]
999,999
|
$row[15]
111,000
|
$row[16]
222,000
|
40 |
Subtotal |
|
|
first(list([covered @concept=ferc:MilesOfGatheringLinesOperated
@ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @period =
$currentDuration]))
81,716,233
|
|
first(list([covered @concept=ferc:MilesOfTrunkLinesForCrudeOilOperated
@ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @period =
$currentDuration]))
83,982,726
|
|
first(list([covered @concept=ferc:MilesOfTrunkLinesForProductsOperated
@ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @period =
$currentDuration]))
25,999,166
|
|
first(list([covered @concept=ferc:IncreaseMilesOfGatheringLinesOperated
@ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @period =
$currentDuration]))
428,822,111
|
first(list([covered @concept=ferc:IncreaseMilesOfTrunkLinesForCrudeOilOperated
@ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @period =
$currentDuration]))
726,929,726
|
first(list([covered @concept=ferc:IncreaseMilesOfTrunkLinesForProductsOperated
@ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @period =
$currentDuration]))
626,938,019
|
first(list([covered @concept=ferc:DecreaseMilesOfGatheringLinesOperated
@ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @period =
$currentDuration]))
55,827,913
|
first(list([covered @concept=ferc:DecreaseMilesOfTrunkLinesForCrudeOilOperated
@ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @period =
$currentDuration]))
827,775,162
|
first(list([covered @concept=ferc:DecreaseMilesOfTrunkLinesForProductsOperated
@ferc:OwnershipAxis=ferc:OwnedInUndividedJointInterestsAndOperatedByOthersMember @period =
$currentDuration]))
827,162,726
|
|
(D) OWNED BY OTHERS BUT OPERATED BY RESPONDENT |
// adding a comment
$data2 = list(for $i in range(2)
list($i,none,none,none,none,none,none,none,none,none,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:MilesOfPipelineOperatedAxis=* @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember})) > 0
list({covered @ferc:MilesOfPipelineOperatedAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:NameAndStateOfCompany @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit@period=$currentDuration})
first(list({@ferc:NameAndStateOfCompany @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:PipelineStartPoint @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:PipelineStartPoint @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:PipelineEndPoint @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:PipelineEndPoint @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:MilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:MilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:SizeOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:SizeOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:MilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:MilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:SizeOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:SizeOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:MilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:MilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:SizeOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:SizeOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:IncreaseMilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:IncreaseMilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:IncreaseMilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:IncreaseMilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:IncreaseMilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:IncreaseMilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DecreaseMilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:DecreaseMilesOfGatheringLinesOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DecreaseMilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:DecreaseMilesOfTrunkLinesForCrudeOilOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:DecreaseMilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration})
first(list({@ferc:DecreaseMilesOfTrunkLinesForProductsOperated @ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list($x[1],none,none,none,none,none,none,none,none,none,none,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
JKL Pipeline - Florida
|
$row[3]
Jacksonville
|
$row[4]
Miami
|
$row[5]
226,111
|
$row[6]
123,123
|
$row[7]
456,456
|
$row[8]
789,789
|
$row[9]
101,101
|
$row[10]
202,202
|
$row[11]
303,303
|
$row[12]
505,505
|
$row[13]
404,404
|
$row[14]
606,606
|
$row[15]
707,707
|
$row[16]
808,808
|
40 |
Subtotal |
|
|
first(list([covered @concept=ferc:MilesOfGatheringLinesOperated
@ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @period =
$currentDuration]))
82,888,716
|
|
first(list([covered @concept=ferc:MilesOfTrunkLinesForCrudeOilOperated
@ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @period =
$currentDuration]))
777,019,827
|
|
first(list([covered @concept=ferc:MilesOfTrunkLinesForProductsOperated
@ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @period =
$currentDuration]))
662,883,994
|
|
first(list([covered @concept=ferc:IncreaseMilesOfGatheringLinesOperated
@ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @period =
$currentDuration]))
183,736,772
|
first(list([covered @concept=ferc:IncreaseMilesOfTrunkLinesForCrudeOilOperated
@ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @period =
$currentDuration]))
255,662,991
|
first(list([covered @concept=ferc:IncreaseMilesOfTrunkLinesForProductsOperated
@ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @period =
$currentDuration]))
827,665,998
|
first(list([covered @concept=ferc:DecreaseMilesOfGatheringLinesOperated
@ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @period =
$currentDuration]))
772,999,611
|
first(list([covered @concept=ferc:DecreaseMilesOfTrunkLinesForCrudeOilOperated
@ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @period =
$currentDuration]))
263,726,911
|
first(list([covered @concept=ferc:DecreaseMilesOfTrunkLinesForProductsOperated
@ferc:OwnershipAxis=ferc:OwnedByOthersAndOperatedByRespondentMember @period =
$currentDuration]))
833,622,113
|
|
GRAND TOTAL |
|
|
first(list([covered @concept=ferc:MilesOfGatheringLinesOperated @period = $currentDuration]))
982,888,911
|
|
first(list([covered @concept=ferc:MilesOfTrunkLinesForCrudeOilOperated @period =
$currentDuration]))
877,019,726
|
|
first(list([covered @concept=ferc:MilesOfTrunkLinesForProductsOperated @period =
$currentDuration]))
999,444,111
|
|
first(list([covered @concept=ferc:IncreaseMilesOfGatheringLinesOperated @period =
$currentDuration]))
827,827,827
|
first(list([covered @concept=ferc:IncreaseMilesOfTrunkLinesForCrudeOilOperated @period =
$currentDuration]))
221,331,441
|
first(list([covered @concept=ferc:IncreaseMilesOfTrunkLinesForProductsOperated @period =
$currentDuration]))
776,996,006
|
first(list([covered @concept=ferc:DecreaseMilesOfGatheringLinesOperated @period =
$currentDuration]))
333,123,654
|
first(list([covered @concept=ferc:DecreaseMilesOfTrunkLinesForCrudeOilOperated @period =
$currentDuration]))
123,321,123
|
first(list([covered @concept=ferc:DecreaseMilesOfTrunkLinesForProductsOperated @period =
$currentDuration]))
456,654,456
|