-
Notifications
You must be signed in to change notification settings - Fork 4
/
methods.qmd
239 lines (170 loc) · 11.9 KB
/
methods.qmd
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
---
title: "Methods"
subtitle: "Data Sources, Region Definitions, and Description of the PCE Program"
---
```{r, echo=FALSE,warning=FALSE,message=FALSE}
# Function to make space regardless of execution format
# To use: write `r space() outside of a code block
# Modify globally at ./scripts/inline_functions/space.R
source("scripts/R/space.R")
```
`r space(br="", vspace="-3em")`
## Data Sources {#sec-sources}
The data in this report was collected from a variety of sources that are listed below. Most electric utilities throughout the state are not required to submit annual reports to the federal government due to their size and/or number of customers. Therefore, our data sources encompass federal, state, commercial, and local filings as well as direct communications with utilities and state program managers. Each section of the report pulls data from a variety of these sources. The data was downloaded directly from the original sources and concatenated to develop a dataset for this report. In some cases, a single observation is derived from multiple sources due to reporting limitations.
Below are relevant sources of data for the report.
### Federal
- Energy Information Administration
- [EIA-860](https://www.eia.gov/electricity/data/eia860/)
- [EIA-861](https://www.eia.gov/electricity/data/eia861/)
- [EIA-923](https://www.eia.gov/electricity/data/eia923/)
- Federal Energy Regulatory Commission
- [Form 1](https://www.ferc.gov/general-information-0/electric-industry-forms/form-1-electric-utility-annual-report)
### State
- Alaska Energy Authority
- [Power Cost Equalization Program](https://www.akenergyauthority.org/What-We-Do/Power-Cost-Equalization) Utility Monthly Reports
- Regulatory Authority of Alaska
- [Annual filings](https://rca.alaska.gov/RCAWeb/RCALibrary/RCAReports.aspx)
### Direct Communications
- Alaska Energy Authority
- Hydro/Wind Program Managers
- Village and Powerhouse Assessments
- Electric Utilities
### Commercial Sources
- [Intelligent Energy Systems](https://www.iesconnect.net)
### Compilation
Neil McMahon, first at AEA and then at [DOWL](https://www.dowl.com/), an Alaska engineering firm, did the preliminary compilation of data and developed the Excel workbooks that support this report. This step involved careful cross-referencing of assets between the various data sources and error checking by domain experts. At this point, aggregate calculations were created to match the tables found in previous _Alaska Energy Statistics Reports_. Data in this report were derived from those workbooks exported to CSV files; the original workbooks are available via a GitHub repo [ak-energy-statistics-2011_2021](https://acep-uaf.github.io/ak-energy-statistics-2011_2021/).
## Regional Summaries
For the purpose of energy planning, AEA has defined [eleven energy regions](https://dcra-cdo-dcced.opendata.arcgis.com/datasets/edb3e790ea4b40579f29e925afc061c5_0/explore?showTable=true) for the State of Alaska. Previous versions of the _Alaska Electric Energy Statistics_ reports presented data summarized by those regions. In order to provide visualizations that are easier to understand, we have condensed these eleven regions into three major energy regions: Coastal, Railbelt, and Rural Remote. @fig-regions-scheme shows the diagrammatic relationship between these two classification systems. `r if (knitr::is_html_output()) {"@fig-regions-map-html"} else if (knitr::is_latex_output()) {"@fig-regions-map-pdf-aea and @fig-regions-map-pdf-acep"}` displays this relationship cartographically.
We note that the Coastal and Rural Remote regions include mixtures of Power Cost Equalization (PCE) and non-PCE eligible communities. The Coastal region includes Copper River/Chugach and incorporates all communities served by Copper Valley Electric Association. PCE communities are largely dependent on diesel generation.
{width=50% #fig-regions-scheme}
<!-- {width=600 #fig-regions-map} -->
<br>
<br>
::: {.content-visible when-format="html"}
```{ojs}
// The OJS chunks below build the interactive map for the HTML version
// These chunks will not render for the PDF version, use PNG instead
stdlib = require("@observablehq/stdlib")
d3 = require("d3@7")
L = require('leaflet@1.9.4')
html`<link href='${resolve('leaflet@1.2.0/dist/leaflet.css')}' rel='stylesheet' />`
bootstrap=require("bootstrap")
// css=html`<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.0/dist/css/bootstrap.min.css" integrity="sha384-gH2yIJqKdNHPEq0n4Mqa/HGKIhSkIHeL5AyhkYV8i59U5AR6csBvApHHNl/vI1Bx" crossorigin="anonymous">`
// css=html`<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.0/dist/css/bootstrap.min.css" integrity="sha384-gH2yIJqKdNHPEq0n4Mqa/HGKIhSkIHeL5AyhkYV8i59U5AR6csBvApHHNl/vI1Bx" crossorigin="anonymous">`
```
```{ojs}
aea_regions = FileAttachment("data/final_data/aea_regions.geojson").json()
acep_regions = FileAttachment("data/final_data/acep_regions.geojson").json()
coords_json = FileAttachment("data/final_data/coordinates.geojson").json()
// coords_csv = FileAttachment("data/working/regions/coordinates_pce.csv").csv({typed: true})
```
```{ojs}
aea_regions_input = L.geoJSON(aea_regions, {
style: function(feature) {
switch (feature.properties.NAME) {
case 'Aleutians': return {color: "#FF5733"};
case 'Bering Straits': return {color: "#FF1493"};
case 'Bristol Bay': return {color: "#20B2AA"};
case 'Copper River Chugach': return {color: "#7D3C98"};
case 'Kodiak': return {color: "#C70039"};
case 'Lower Yukon Kuskokwim': return {color: "#00B4D8"};
case 'North Slope': return {color: "#4682B4"};
case 'Northwest Arctic': return {color: "#6A5ACD"};
case 'Railbelt': return {color: "#228B22"};
case 'Southeast': return {color: "#FFC300"};
case 'Yukon-Koyukuk Upper Tanana': return {color: "#FF8C00"};
}
}
}).bindTooltip(function (layer) {
return layer.feature.properties.NAME;
},
{
sticky: true,
offset: [10, 0],
direction: "right",
opacity: 0.75
});
acep_regions_input = L.geoJSON(acep_regions, {
style: function(feature) {
switch (feature.properties.NAME) {
case 'Rural Remote': return {color: "#FF0000"};
case 'Coastal': return {color: "#0000FF"};
case 'Railbelt': return {color: "#228B22"};
}
}
}).bindTooltip(function (layer) {
return layer.feature.properties.NAME;
},
{
sticky: true,
offset: [10, 0],
direction: "right",
opacity: 0.75
});
```
```{ojs}
// Code below builds community location points
points = L.geoJSON(coords_json, {
pointToLayer: function (feature, latlng) {
return L.circleMarker(latlng,
{radius: 5,
fillColor: "#808080",
color: "#000",
weight: 1,
opacity: 1,
fillOpacity: 0.8
});
}
}).bindTooltip(function (layer) {
return layer.feature.properties.name;
},
{
sticky: true,
offset: [10, 0],
direction: "right",
opacity: 0.75
});
```
```{ojs}
//| label: fig-regions-map-html
//| fig-cap: "Cartographic Relationship between Energy Regions as defined by AEA and ACEP"
viewof region_input = Inputs.select(new Map([
["AEA Regions", aea_regions_input],
["ACEP Regions", acep_regions_input]]),
{value: aea_regions_input, label: "Display below:"}
);
```
```{ojs}
// the order of the container calls is important, do first, don't mess with
map = {
let container = DOM.element('div', { style: `width:${width}px;height:${width/1.2}px` });
yield container;
// create map object
let map = L.map(container).setView([62.945279601222396, -155.5946697727831], 4);
// add basemap
var basemap = L.tileLayer(
'https://server.arcgisonline.com/ArcGIS/rest/services/World_Topo_Map/MapServer/tile/{z}/{y}/{x}',
{attribution: 'Tiles © Esri — Esri, DeLorme, NAVTEQ, TomTom, Intermap, iPC, USGS, FAO, NPS, NRCAN, GeoBase, Kadaster NL, Ordnance Survey, Esri Japan, METI, Esri China (Hong Kong), and the GIS User Community'});
basemap.addTo(map);
// // add dropdown input selection
region_input.addTo(map);
// add community points
points.addTo(map);
}
```
:::
::: {.content-visible when-format="pdf"}
{#fig-regions-map-pdf-aea}
{#fig-regions-map-pdf-acep}
:::
<br>
<br>
## Power Cost Equalization (PCE) {#sec-pce-description}
Alaska is famous for wide expanses of rugged terrain. Towns are often extremely distant from one another, or are separated by inaccessible mountains and glaciers. The utility landscape of Alaska resembles a sea of islands, very different from the interconnected grids of the contiguous United States.
In total, Alaska contains over 100 separate utilities, many of which serve a single, small community. Most rely on diesel generators connected to huge fuel tanks, which receive a barge shipment of fuel in the summer that must last through the winter. If the town runs out of fuel during winter months, additional fuel has to be flown in at extreme expense. Predictably, electricity in these remote towns is extremely expensive.
Some rural towns pay 3 to 5 times the rates of urban Alaska. Urban Alaska has greatly benefited from large state-subsidized energy projects, such as the Bradley Lake Hydroelectric Project, the Four Dam Pool Projects, and the Alaska Intertie. In an effort to confer similar benefits to rural Alaska, the state of Alaska developed the Power Cost Equalization Program (PCE).
The PCE program reimburses rural utilities for credits that have been provided to eligible customers. Eligibility is limited to residential customers and community facilities. The subsidy applies to the first 750 kWh per month of residential consumption. Community facilities are subsidized up to the first 70 kWh per month per resident. The program is administered by the Regulatory Commission of Alaska (RCA) and the Alaska Energy Authority (AEA).
Please visit the Alaska Energy Authority [PCE webpage](https://www.akenergyauthority.org/What-We-Do/Power-Cost-Equalization) for more information about the Power Cost Equalization program.
## Feedback Regarding Potential Errors
Since these data come from multiple sources, there is potential for errors in its compilation. An integral part of this effort is the creation of a high quality dataset that can constructively contribute to future work. Therefore, any discrepancies or noted errors should be reported by emailing [support](mailto:uaf-acep-dcm-support@alaska.edu) or submitting a GitHub issue via the links in the right hand navigation menu of every page of the web book. Alternatively, direct contact information for members of the DCM team is listed in @sec-contacts.