taxonomy().concept(ferc:ScheduleGasStorageProjectsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2ScheduleTitle").text
Gas Storage Projects
|
taxonomy().concept(ferc:ScheduleGasStorageProjectsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Instructions").text
- Report injections and withdrawals of gas for all storage projects used by respondent.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleGasStorageProjectsAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "512 - Schedule - Gas Storage Projects by Months - Gas Delivered to Storage")
$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)
|
|
taxonomy().concept(ferc:GasStorageProjectsLineItems).label("http://ferc.gov/form/2020-01-01/roles/label/F2GasStorageDelivered").text
STORAGE OPERATIONS (in Dth)
|
|
|
|
1 |
taxonomy().concept(ferc:GasDeliveredToStorageAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2GasStorageDelivered").text
Gas Delivered to Storage
|
|
|
|
// adding a comment
$members = navigate parent-child descendants from ferc:MonthAxis role
"http://ferc.gov/form/2020-01-01/roles/Schedule/F2/GasStorageProjectsByMonthsDelivered" returns list (target-name, preferred-label, order);
$defaultDomain = navigate dimension-default children from ferc:MonthAxis role
"http://ferc.gov/form/2020-01-01/roles/Schedule/F2/GasStorageProjectsByMonthsDelivered" returns list (target-name)
$output = list(for $row in $members
$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 == "512 - Schedule - Gas Storage Projects by Months - Gas Delivered to Storage" and $item.part-by-name(ferc-part:ValueType).part-value.string == "Label")).to-list;
$rowID = if ($row_num.part-by-name(ferc-part:Row)).length > 0
($row_num.part-by-name(ferc-part:Row))[1].part-value
else
"";
$abstractLabel = list($rowID.number, $concept.label($row[2].role.uri).text);
$data = navigate parent-child descendants from ferc:GasDeliveredToStorageAbstract role
"http://ferc.gov/form/2020-01-01/roles/Schedule/F2/GasStorageProjectsByMonthsDelivered" returns list (target, preferred-label, order);
$dataRow2 = list(none, none, none);
$dataRow1 = list(for $y in $data
if $row[1] == $defaultDomain[1]
if list([covered @concept = $y[1] @period = $currentDuration]).length > 0
first(list([covered @concept = $y[1] @period = $currentDuration]))
else
none
else
if exists([covered @concept = $y[1].name @ferc:MonthAxis = $row[1] @period = $currentDuration])
first(list([covered @concept = $y[1].name @ferc:MonthAxis = $row[1] @period = $currentDuration]))
else
none);
$abstractLabel + $dataRow1
);
for $rowl in $output.sort
$rowl[1]
1
|
$rowl[2]
Gas
|
$rowl[3]
$300,000
|
$rowl[4]
$300,000
|
$rowl[5]
$300,000
|
15 |
taxonomy().concept(ferc:GasWithdrawnFromStorageAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2GasStorageWithdrawn").text
Gas Withdrawn from Storage
|
|
|
|
// adding a comment
$members = navigate parent-child descendants from ferc:MonthAxis role
"http://ferc.gov/form/2020-01-01/roles/Schedule/F2/GasStorageProjectsByMonthsWithdrawn" returns list (target-name, preferred-label, order);
$defaultDomain = navigate dimension-default children from ferc:MonthAxis role
"http://ferc.gov/form/2020-01-01/roles/Schedule/F2/GasStorageProjectsByMonthsDelivered" returns list (target-name)
$output = list(for $row in $members
$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 == "512 - Schedule - Gas Storage Projects by Months - Gas Withdrawn from Storage" and $item.part-by-name(ferc-part:ValueType).part-value.string == "Label")).to-list;
$rowID = if ($row_num.part-by-name(ferc-part:Row)).length > 0
($row_num.part-by-name(ferc-part:Row))[1].part-value
else
"";
$abstractLabel = list($rowID.number, $concept.label($row[2].role.uri).text);
$data = navigate parent-child descendants from ferc:GasWithdrawnFromStorageAbstract role
"http://ferc.gov/form/2020-01-01/roles/Schedule/F2/GasStorageProjectsByMonthsWithdrawn" returns list (target, preferred-label, order);
$dataRow2 = list(none, none, none);
$dataRow1 = list(for $y in $data
if $row[1] == $defaultDomain[1]
if list([covered @concept = $y[1] @period = $currentDuration]).length > 0
first(list([covered @concept = $y[1] @period = $currentDuration]))
else
none
else
if exists([covered @concept = $y[1].name @ferc:MonthAxis = $row[1] @period = $currentDuration])
first(list([covered @concept = $y[1].name @ferc:MonthAxis = $row[1] @period = $currentDuration]))
else
none);
$abstractLabel + $dataRow1
);
for $rowl in $output.sort
$rowl[1]
1
|
$rowl[2]
Gas
|
$rowl[3]
$300,000
|
$rowl[4]
$300,000
|
$rowl[5]
$300,000
|