{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": { "ExecuteTime": { "end_time": "2018-03-16T18:17:22.583915Z", "start_time": "2018-03-16T18:17:20.252530Z" } }, "outputs": [], "source": [ "%matplotlib inline\n", "import matplotlib.pyplot as plt\n", "import seaborn as sns\n", "import numpy as np\n", "import geopandas as gpd\n", "# from shapely.geometry import Point\n", "# from geopandas import GeoDataFrame\n", "import os\n", "from os.path import join\n", "import pandas as pd\n", "import fiona\n", "# from cartopy import crs as ccrs\n", "# from urllib.request import urlopen\n", "# from zipfile import ZipFile\n", "# from io import BytesIO\n", "# from pathlib import Path\n", "\n", "sns.set(style='white')\n", "cwd = os.getcwd()\n", "data_path = join(cwd, '..', '..', 'Data storage')\n", "figure_path = join(cwd, '..', '..', 'Figures')\n", "file_date = '2018-03-06'" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "ExecuteTime": { "end_time": "2018-03-16T01:30:57.926475Z", "start_time": "2018-03-16T01:30:57.915320Z" } }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "CPython 3.6.4\n", "IPython 6.2.1\n", "\n", "pandas 0.22.0\n", "geopandas 0.3.0\n", "shapely 1.6.4.post1\n" ] } ], "source": [ "%load_ext watermark\n", "%watermark -v -p pandas,geopandas,shapely" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Read NERC regions shapefile\n", "[Link to the shapefile](https://github.com/gschivley/Index-variability/raw/master/Data%20storage/NERC_Regions_EIA) for local download" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "ExecuteTime": { "end_time": "2017-11-02T18:30:35.188878Z", "start_time": "2017-11-02T18:30:34.659422Z" } }, "outputs": [ { "data": { "text/plain": [ "{'init': 'epsg:4326'}" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# EIA NERC region shapefile, which has an \"Indeterminate\" region\n", "\n", "# path = os.path.join(data_path, 'NERC_Regions_EIA', 'NercRegions_201610.shp')\n", "# regions = gpd.read_file(path)\n", "# regions.crs" ] }, { "cell_type": "code", "execution_count": 149, "metadata": { "ExecuteTime": { "end_time": "2018-03-16T13:50:57.087464Z", "start_time": "2018-03-16T13:50:56.795701Z" } }, "outputs": [], "source": [ "path = os.path.join(data_path, 'nercregions', 'NERCregions.shp')\n", "regions_nerc = gpd.read_file(path)\n", "regions_nerc['nerc'] = regions_nerc['NERCregion']" ] }, { "cell_type": "code", "execution_count": 150, "metadata": { "ExecuteTime": { "end_time": "2018-03-16T13:51:08.346080Z", "start_time": "2018-03-16T13:51:08.307554Z" } }, "outputs": [ { "data": { "text/html": [ "
\n", " | OBJECTID | \n", "NERCregion | \n", "SHAPE_Leng | \n", "SHAPE_Area | \n", "geometry | \n", "nerc | \n", "
---|---|---|---|---|---|---|
0 | \n", "1 | \n", "FRCC | \n", "22.488030 | \n", "11.459289 | \n", "POLYGON ((-84.86300370899994 30.71266453000004... | \n", "FRCC | \n", "
1 | \n", "2 | \n", "MRO | \n", "76.997961 | \n", "130.425939 | \n", "POLYGON ((-94.8320392469999 49.33080593000005,... | \n", "MRO | \n", "
2 | \n", "3 | \n", "NPCC | \n", "48.574281 | \n", "32.754394 | \n", "(POLYGON ((-72.5509712409999 40.96617993100006... | \n", "NPCC | \n", "
3 | \n", "4 | \n", "RFC | \n", "99.332877 | \n", "71.157869 | \n", "(POLYGON ((-87.92640864299995 44.5391396020000... | \n", "RFC | \n", "
4 | \n", "5 | \n", "SERC | \n", "128.958444 | \n", "142.139208 | \n", "POLYGON ((-80.20680177299994 36.54903791300006... | \n", "SERC | \n", "
5 | \n", "6 | \n", "SPP | \n", "61.523164 | \n", "56.496471 | \n", "POLYGON ((-97.56098691099993 36.38533196100008... | \n", "SPP | \n", "
6 | \n", "7 | \n", "TRE | \n", "44.145641 | \n", "50.605118 | \n", "POLYGON ((-104.4498774409999 32.00686615000006... | \n", "TRE | \n", "
7 | \n", "8 | \n", "WECC | \n", "102.110211 | \n", "323.227276 | \n", "(POLYGON ((-122.6656125679999 48.3967777520000... | \n", "WECC | \n", "
\n", " | objectid | \n", "id | \n", "subname | \n", "name | \n", "address | \n", "city | \n", "state | \n", "zipcode | \n", "country | \n", "website | \n", "method | \n", "date | \n", "source | \n", "shape__are | \n", "shape__len | \n", "geometry | \n", "nerc | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "1 | \n", "0 | \n", "WECC SOUTHWEST | \n", "WESTERN ELECTRICITY COORDINATING COUNCIL (WECC) | \n", "155 NORTH 400 WEST SUITE 200 | \n", "SALT LAKE CITY | \n", "UT | \n", "84103 | \n", "USA | \n", "https://www.wecc.biz/Pages/home.aspx | \n", "OTHER | \n", "2017-04-21T00:00:00.000Z | \n", "EIA 861, eGRID 2010, http://www.nerc.com/ | \n", "84.129616 | \n", "60.209543 | \n", "(POLYGON ((-106.940414613533 38.5297752935145,... | \n", "WECC | \n", "
1 | \n", "2 | \n", "1 | \n", "WECC CALIFORNIA | \n", "WESTERN ELECTRICITY COORDINATING COUNCIL (WECC) | \n", "156 NORTH 400 WEST SUITE 200 | \n", "SALT LAKE CITY | \n", "UT | \n", "84103 | \n", "USA | \n", "https://www.wecc.biz/Pages/home.aspx | \n", "OTHER | \n", "2017-04-21T00:00:00.000Z | \n", "EIA 861, eGRID 2010, http://www.nerc.com/ | \n", "43.141024 | \n", "59.568593 | \n", "(POLYGON ((-124.166090785201 41.0947342364264,... | \n", "WECC | \n", "
2 | \n", "3 | \n", "2 | \n", "ERCOT ALL | \n", "TEXAS RELIABILITY ENTITY (TRE) | \n", "800 AIRPORT ROAD | \n", "TAYLOR | \n", "TX | \n", "76574 | \n", "USA | \n", "http://www.ercot.com/ | \n", "OTHER | \n", "2017-04-21T00:00:00.000Z | \n", "EIA 861, eGRID 2010, http://www.nerc.com/ | \n", "61.102506 | \n", "131.535864 | \n", "(POLYGON ((-123.715621602827 44.0113707388719,... | \n", "TRE | \n", "
3 | \n", "4 | \n", "3 | \n", "FRCC ALL | \n", "FLORIDA RELIABILITY COORDINATING COUNCIL (FRCC) | \n", "3000 BAYPORT DRIVE, SUITE 600 | \n", "TAMPA | \n", "FL | \n", "33607 | \n", "USA | \n", "https://www.frcc.com/default.aspx | \n", "OTHER | \n", "2017-04-21T00:00:00.000Z | \n", "EIA 861, eGRID 2010, http://www.nerc.com/ | \n", "12.385353 | \n", "170.579871 | \n", "(POLYGON ((-85.7661778899989 30.3156300105005,... | \n", "FRCC | \n", "
4 | \n", "5 | \n", "4 | \n", "NPCC NEW ENGLAND | \n", "NORTHEAST POWER COORDINATING COUNCIL (NPCC) | \n", "1040 AVENUE OF THE AMERICAS, 10TH FLOOR | \n", "NEW YORK | \n", "NY | \n", "10018 | \n", "USA | \n", "https://www.npcc.org/default.aspx | \n", "OTHER | \n", "2017-04-21T00:00:00.000Z | \n", "EIA 861, eGRID 2010, http://www.nerc.com/ | \n", "19.384108 | \n", "151.655607 | \n", "(POLYGON ((-67.1335131587897 45.1268843657456,... | \n", "NPCC | \n", "
\n", " | nerc | \n", "2001 | \n", "2017 | \n", "Reduction | \n", "Percent Reduction | \n", "Annual Reduction | \n", "
---|---|---|---|---|---|---|
0 | \n", "TRE | \n", "609.480997 | \n", "445.396025 | \n", "164.084972 | \n", "0.269221 | \n", "10.255311 | \n", "
1 | \n", "WECC | \n", "520.628493 | \n", "346.627554 | \n", "174.000939 | \n", "0.334213 | \n", "10.875059 | \n", "
2 | \n", "USA | \n", "629.016312 | \n", "438.047363 | \n", "190.968949 | \n", "0.303599 | \n", "11.935559 | \n", "
3 | \n", "SERC | \n", "633.368212 | \n", "426.814179 | \n", "206.554033 | \n", "0.326120 | \n", "12.909627 | \n", "
4 | \n", "RFC | \n", "676.181487 | \n", "461.065520 | \n", "215.115966 | \n", "0.318133 | \n", "13.444748 | \n", "
5 | \n", "FRCC | \n", "648.223415 | \n", "410.133060 | \n", "238.090355 | \n", "0.367297 | \n", "14.880647 | \n", "
6 | \n", "NPCC | \n", "414.395302 | \n", "172.744904 | \n", "241.650399 | \n", "0.583140 | \n", "15.103150 | \n", "
7 | \n", "MRO | \n", "855.109267 | \n", "541.516736 | \n", "313.592531 | \n", "0.366728 | \n", "19.599533 | \n", "
8 | \n", "SPP | \n", "853.801162 | \n", "494.664676 | \n", "359.136486 | \n", "0.420632 | \n", "22.446030 | \n", "
\n", " | OBJECTID | \n", "NERCregion | \n", "SHAPE_Leng | \n", "SHAPE_Area | \n", "geometry | \n", "nerc | \n", "2017 | \n", "2001 | \n", "reduction | \n", "reduction value | \n", "
---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "1 | \n", "FRCC | \n", "22.488030 | \n", "11.459289 | \n", "POLYGON ((-84.86300370899994 30.71266453000004... | \n", "FRCC | \n", "410.133060 | \n", "648.223415 | \n", "37% | \n", "0.367297 | \n", "
1 | \n", "2 | \n", "MRO | \n", "76.997961 | \n", "130.425939 | \n", "POLYGON ((-94.8320392469999 49.33080593000005,... | \n", "MRO | \n", "541.516736 | \n", "855.109267 | \n", "37% | \n", "0.366728 | \n", "
2 | \n", "3 | \n", "NPCC | \n", "48.574281 | \n", "32.754394 | \n", "(POLYGON ((-72.5509712409999 40.96617993100006... | \n", "NPCC | \n", "172.744904 | \n", "414.395302 | \n", "58% | \n", "0.583140 | \n", "
3 | \n", "4 | \n", "RFC | \n", "99.332877 | \n", "71.157869 | \n", "(POLYGON ((-87.92640864299995 44.5391396020000... | \n", "RFC | \n", "461.065520 | \n", "676.181487 | \n", "32% | \n", "0.318133 | \n", "
4 | \n", "5 | \n", "SERC | \n", "128.958444 | \n", "142.139208 | \n", "POLYGON ((-80.20680177299994 36.54903791300006... | \n", "SERC | \n", "426.814179 | \n", "633.368212 | \n", "33% | \n", "0.326120 | \n", "
5 | \n", "6 | \n", "SPP | \n", "61.523164 | \n", "56.496471 | \n", "POLYGON ((-97.56098691099993 36.38533196100008... | \n", "SPP | \n", "494.664676 | \n", "853.801162 | \n", "42% | \n", "0.420632 | \n", "
6 | \n", "7 | \n", "TRE | \n", "44.145641 | \n", "50.605118 | \n", "POLYGON ((-104.4498774409999 32.00686615000006... | \n", "TRE | \n", "445.396025 | \n", "609.480997 | \n", "27% | \n", "0.269221 | \n", "
7 | \n", "8 | \n", "WECC | \n", "102.110211 | \n", "323.227276 | \n", "(POLYGON ((-122.6656125679999 48.3967777520000... | \n", "WECC | \n", "346.627554 | \n", "520.628493 | \n", "33% | \n", "0.334213 | \n", "
\n", " | lat | \n", "lon | \n", "plant id | \n", "year | \n", "geometry | \n", "
---|---|---|---|---|---|
0 | \n", "44.4936 | \n", "-88.0303 | \n", "10360 | \n", "2017 | \n", "POINT (-88.0303 44.4936) | \n", "
6 | \n", "44.4936 | \n", "-88.0303 | \n", "10360 | \n", "2016 | \n", "POINT (-88.0303 44.4936) | \n", "
18 | \n", "44.4936 | \n", "-88.0303 | \n", "10360 | \n", "2015 | \n", "POINT (-88.0303 44.4936) | \n", "
30 | \n", "44.4936 | \n", "-88.0303 | \n", "10360 | \n", "2014 | \n", "POINT (-88.0303 44.4936) | \n", "
38 | \n", "44.4936 | \n", "-88.0303 | \n", "10360 | \n", "2008 | \n", "POINT (-88.0303 44.4936) | \n", "
\n", " | lat | \n", "lon | \n", "plant id | \n", "year | \n", "geometry | \n", "index_right | \n", "NERC | \n", "NERC_Label | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "44.4936 | \n", "-88.0303 | \n", "10360 | \n", "2017 | \n", "POINT (-88.0303 44.4936) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
6 | \n", "44.4936 | \n", "-88.0303 | \n", "10360 | \n", "2016 | \n", "POINT (-88.0303 44.4936) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
18 | \n", "44.4936 | \n", "-88.0303 | \n", "10360 | \n", "2015 | \n", "POINT (-88.0303 44.4936) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
30 | \n", "44.4936 | \n", "-88.0303 | \n", "10360 | \n", "2014 | \n", "POINT (-88.0303 44.4936) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
38 | \n", "44.4936 | \n", "-88.0303 | \n", "10360 | \n", "2008 | \n", "POINT (-88.0303 44.4936) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
\n", " | NERC | \n", "NERC_Label | \n", "geometry | \n", "index_right | \n", "lat | \n", "lon | \n", "plant id | \n", "year | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "- | \n", "Indeterminate - various NERC membership | \n", "(POLYGON ((-91.71222639199999 32.9756623780000... | \n", "1200931 | \n", "40.389167 | \n", "-91.394167 | \n", "57953 | \n", "2014 | \n", "
0 | \n", "- | \n", "Indeterminate - various NERC membership | \n", "(POLYGON ((-91.71222639199999 32.9756623780000... | \n", "1200919 | \n", "40.389167 | \n", "-91.394167 | \n", "57953 | \n", "2015 | \n", "
0 | \n", "- | \n", "Indeterminate - various NERC membership | \n", "(POLYGON ((-91.71222639199999 32.9756623780000... | \n", "1200907 | \n", "40.389167 | \n", "-91.394167 | \n", "57953 | \n", "2016 | \n", "
0 | \n", "- | \n", "Indeterminate - various NERC membership | \n", "(POLYGON ((-91.71222639199999 32.9756623780000... | \n", "1200904 | \n", "40.389167 | \n", "-91.394167 | \n", "57953 | \n", "2017 | \n", "
0 | \n", "- | \n", "Indeterminate - various NERC membership | \n", "(POLYGON ((-91.71222639199999 32.9756623780000... | \n", "1201030 | \n", "40.389167 | \n", "-91.394167 | \n", "57953 | \n", "2011 | \n", "
\n", " | NERC_Label | \n", "plant id | \n", "year | \n", "geometry | \n", "
---|---|---|---|---|
0 | \n", "Indeterminate - various NERC membership | \n", "57953 | \n", "2014 | \n", "POINT (-91.39416700000001 40.389167) | \n", "
0 | \n", "Indeterminate - various NERC membership | \n", "57953 | \n", "2015 | \n", "POINT (-91.39416700000001 40.389167) | \n", "
0 | \n", "Indeterminate - various NERC membership | \n", "57953 | \n", "2016 | \n", "POINT (-91.39416700000001 40.389167) | \n", "
0 | \n", "Indeterminate - various NERC membership | \n", "57953 | \n", "2017 | \n", "POINT (-91.39416700000001 40.389167) | \n", "
0 | \n", "Indeterminate - various NERC membership | \n", "57953 | \n", "2011 | \n", "POINT (-91.39416700000001 40.389167) | \n", "
\n", " | plant id | \n", "state | \n", "lat | \n", "lon | \n", "nerc | \n", "
---|---|---|---|---|---|
0 | \n", "2 | \n", "AL | \n", "33.458665 | \n", "-87.356823 | \n", "SERC | \n", "
1 | \n", "3 | \n", "AL | \n", "31.006900 | \n", "-88.010300 | \n", "SERC | \n", "
2 | \n", "4 | \n", "AL | \n", "32.583889 | \n", "-86.283056 | \n", "SERC | \n", "
3 | \n", "7 | \n", "AL | \n", "34.012800 | \n", "-85.970800 | \n", "SERC | \n", "
4 | \n", "8 | \n", "AL | \n", "33.644344 | \n", "-87.196486 | \n", "SERC | \n", "
\n", " | plant id | \n", "state | \n", "lat | \n", "lon | \n", "nerc | \n", "
---|
\n", " | plant id | \n", "state | \n", "lat | \n", "lon | \n", "nerc | \n", "geometry | \n", "
---|---|---|---|---|---|---|
0 | \n", "2 | \n", "AL | \n", "33.458665 | \n", "-87.356823 | \n", "SERC | \n", "POINT (-87.35682299999999 33.458665) | \n", "
1 | \n", "3 | \n", "AL | \n", "31.006900 | \n", "-88.010300 | \n", "SERC | \n", "POINT (-88.0103 31.0069) | \n", "
2 | \n", "4 | \n", "AL | \n", "32.583889 | \n", "-86.283056 | \n", "SERC | \n", "POINT (-86.283056 32.583889) | \n", "
3 | \n", "7 | \n", "AL | \n", "34.012800 | \n", "-85.970800 | \n", "SERC | \n", "POINT (-85.9708 34.0128) | \n", "
4 | \n", "8 | \n", "AL | \n", "33.644344 | \n", "-87.196486 | \n", "SERC | \n", "POINT (-87.19648599999999 33.644344) | \n", "
\n", " | NERC | \n", "NERC_Label | \n", "geometry | \n", "index_right | \n", "plant id | \n", "state | \n", "lat | \n", "lon | \n", "nerc | \n", "
---|---|---|---|---|---|---|---|---|---|
0 | \n", "- | \n", "Indeterminate - various NERC membership | \n", "(POLYGON ((-91.71222639199999 32.9756623780000... | \n", "4381 | \n", "54930 | \n", "IA | \n", "40.584150 | \n", "-91.424530 | \n", "- | \n", "
0 | \n", "- | \n", "Indeterminate - various NERC membership | \n", "(POLYGON ((-91.71222639199999 32.9756623780000... | \n", "639 | \n", "1127 | \n", "IA | \n", "40.703100 | \n", "-92.425300 | \n", "- | \n", "
0 | \n", "- | \n", "Indeterminate - various NERC membership | \n", "(POLYGON ((-91.71222639199999 32.9756623780000... | \n", "629 | \n", "1104 | \n", "IA | \n", "40.741200 | \n", "-91.116667 | \n", "- | \n", "
0 | \n", "- | \n", "Indeterminate - various NERC membership | \n", "(POLYGON ((-91.71222639199999 32.9756623780000... | \n", "630 | \n", "1105 | \n", "IA | \n", "40.747800 | \n", "-92.873056 | \n", "- | \n", "
0 | \n", "- | \n", "Indeterminate - various NERC membership | \n", "(POLYGON ((-91.71222639199999 32.9756623780000... | \n", "2562 | \n", "7706 | \n", "IA | \n", "40.816736 | \n", "-91.146667 | \n", "- | \n", "
\n", " | plant id | \n", "state | \n", "lat | \n", "lon | \n", "nerc | \n", "geometry | \n", "index_right | \n", "NERC | \n", "NERC_Label | \n", "
---|---|---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "AL | \n", "33.458665 | \n", "-87.356823 | \n", "SERC | \n", "POINT (-87.35682299999999 33.458665) | \n", "5 | \n", "SERC | \n", "SERC Reliability Corporation (SERC) | \n", "
1 | \n", "3 | \n", "AL | \n", "31.006900 | \n", "-88.010300 | \n", "SERC | \n", "POINT (-88.0103 31.0069) | \n", "5 | \n", "SERC | \n", "SERC Reliability Corporation (SERC) | \n", "
2 | \n", "4 | \n", "AL | \n", "32.583889 | \n", "-86.283056 | \n", "SERC | \n", "POINT (-86.283056 32.583889) | \n", "5 | \n", "SERC | \n", "SERC Reliability Corporation (SERC) | \n", "
3 | \n", "7 | \n", "AL | \n", "34.012800 | \n", "-85.970800 | \n", "SERC | \n", "POINT (-85.9708 34.0128) | \n", "5 | \n", "SERC | \n", "SERC Reliability Corporation (SERC) | \n", "
4 | \n", "8 | \n", "AL | \n", "33.644344 | \n", "-87.196486 | \n", "SERC | \n", "POINT (-87.19648599999999 33.644344) | \n", "5 | \n", "SERC | \n", "SERC Reliability Corporation (SERC) | \n", "
\n", " | NERC | \n", "NERC_Label | \n", "geometry | \n", "index_right | \n", "plant id | \n", "state | \n", "lat | \n", "lon | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "- | \n", "Indeterminate - various NERC membership | \n", "(POLYGON ((-91.71222639199999 32.9756623780000... | \n", "4387 | \n", "55340 | \n", "AR | \n", "35.861900 | \n", "-90.025300 | \n", "
0 | \n", "- | \n", "Indeterminate - various NERC membership | \n", "(POLYGON ((-91.71222639199999 32.9756623780000... | \n", "6136 | \n", "172 | \n", "AR | \n", "35.689300 | \n", "-89.994000 | \n", "
0 | \n", "- | \n", "Indeterminate - various NERC membership | \n", "(POLYGON ((-91.71222639199999 32.9756623780000... | \n", "152 | \n", "8055 | \n", "AR | \n", "35.311000 | \n", "-93.235100 | \n", "
0 | \n", "- | \n", "Indeterminate - various NERC membership | \n", "(POLYGON ((-91.71222639199999 32.9756623780000... | \n", "6217 | \n", "187 | \n", "AR | \n", "34.211913 | \n", "-93.110963 | \n", "
0 | \n", "- | \n", "Indeterminate - various NERC membership | \n", "(POLYGON ((-91.71222639199999 32.9756623780000... | \n", "2928 | \n", "59947 | \n", "AR | \n", "33.631538 | \n", "-92.703611 | \n", "
\n", " | NERC | \n", "NERC_Label | \n", "geometry | \n", "
---|---|---|---|
index_right | \n", "\n", " | \n", " | \n", " |
0 | \n", "- | \n", "Indeterminate - various NERC membership | \n", "(POLYGON ((-91.71222639199999 32.9756623780000... | \n", "
1 | \n", "FRCC | \n", "Florida Reliability Coordinating Council (FRCC) | \n", "(POLYGON ((-81.95506602699999 24.5196900770000... | \n", "
2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "POLYGON ((-95.07148604699995 49.36451082200006... | \n", "
3 | \n", "NPCC | \n", "Northeast Power Coordinating Council (NPCC) | \n", "(POLYGON ((-73.82134384999995 40.6045004290000... | \n", "
4 | \n", "RFC | \n", "ReliabilityFirst Corporation (RFC) | \n", "(POLYGON ((-90.89359863199996 29.0467829150000... | \n", "
5 | \n", "SERC | \n", "SERC Reliability Corporation (SERC) | \n", "(POLYGON ((-91.71222639199999 32.9756623780000... | \n", "
6 | \n", "SPP | \n", "Southwest Power Pool (SPP) | \n", "(POLYGON ((-93.73310749999996 30.4137588960000... | \n", "
7 | \n", "TRE | \n", "Texas Reliability Entity (TRE) | \n", "POLYGON ((-100.0008629659999 35.02950123100004... | \n", "
8 | \n", "WECC | \n", "Western Electricity Coordinating Council (WECC) | \n", "(POLYGON ((-117.215183729 32.77737140300007, -... | \n", "
\n", " | plant id | \n", "state | \n", "lat | \n", "lon | \n", "nerc | \n", "geometry | \n", "index_right | \n", "NERC | \n", "NERC_Label | \n", "
---|---|---|---|---|---|---|---|---|---|
406 | \n", "641 | \n", "FL | \n", "30.566100 | \n", "-87.224400 | \n", "FRCC | \n", "POINT (-87.2244 30.5661) | \n", "5 | \n", "SERC | \n", "SERC Reliability Corporation (SERC) | \n", "
406 | \n", "641 | \n", "FL | \n", "30.566100 | \n", "-87.224400 | \n", "FRCC | \n", "POINT (-87.2244 30.5661) | \n", "1 | \n", "FRCC | \n", "Florida Reliability Coordinating Council (FRCC) | \n", "
407 | \n", "642 | \n", "FL | \n", "30.669200 | \n", "-84.886900 | \n", "FRCC | \n", "POINT (-84.8869 30.6692) | \n", "5 | \n", "SERC | \n", "SERC Reliability Corporation (SERC) | \n", "
407 | \n", "642 | \n", "FL | \n", "30.669200 | \n", "-84.886900 | \n", "FRCC | \n", "POINT (-84.8869 30.6692) | \n", "1 | \n", "FRCC | \n", "Florida Reliability Coordinating Council (FRCC) | \n", "
408 | \n", "643 | \n", "FL | \n", "30.268600 | \n", "-85.700300 | \n", "FRCC | \n", "POINT (-85.7003 30.2686) | \n", "5 | \n", "SERC | \n", "SERC Reliability Corporation (SERC) | \n", "
408 | \n", "643 | \n", "FL | \n", "30.268600 | \n", "-85.700300 | \n", "FRCC | \n", "POINT (-85.7003 30.2686) | \n", "1 | \n", "FRCC | \n", "Florida Reliability Coordinating Council (FRCC) | \n", "
432 | \n", "690 | \n", "FL | \n", "30.708571 | \n", "-84.863869 | \n", "FRCC | \n", "POINT (-84.86386899999999 30.708571) | \n", "5 | \n", "SERC | \n", "SERC Reliability Corporation (SERC) | \n", "
432 | \n", "690 | \n", "FL | \n", "30.708571 | \n", "-84.863869 | \n", "FRCC | \n", "POINT (-84.86386899999999 30.708571) | \n", "1 | \n", "FRCC | \n", "Florida Reliability Coordinating Council (FRCC) | \n", "
963 | \n", "1773 | \n", "MI | \n", "46.726100 | \n", "-88.662500 | \n", "MRO | \n", "POINT (-88.66249999999999 46.7261) | \n", "4 | \n", "RFC | \n", "ReliabilityFirst Corporation (RFC) | \n", "
963 | \n", "1773 | \n", "MI | \n", "46.726100 | \n", "-88.662500 | \n", "MRO | \n", "POINT (-88.66249999999999 46.7261) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
964 | \n", "1774 | \n", "MI | \n", "46.696400 | \n", "-89.208900 | \n", "MRO | \n", "POINT (-89.2089 46.6964) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
964 | \n", "1774 | \n", "MI | \n", "46.696400 | \n", "-89.208900 | \n", "MRO | \n", "POINT (-89.2089 46.6964) | \n", "4 | \n", "RFC | \n", "ReliabilityFirst Corporation (RFC) | \n", "
965 | \n", "1775 | \n", "WI | \n", "45.947200 | \n", "-88.218900 | \n", "MRO | \n", "POINT (-88.2189 45.9472) | \n", "4 | \n", "RFC | \n", "ReliabilityFirst Corporation (RFC) | \n", "
965 | \n", "1775 | \n", "WI | \n", "45.947200 | \n", "-88.218900 | \n", "MRO | \n", "POINT (-88.2189 45.9472) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
967 | \n", "1777 | \n", "MI | \n", "46.131100 | \n", "-88.225000 | \n", "MRO | \n", "POINT (-88.22499999999999 46.1311) | \n", "4 | \n", "RFC | \n", "ReliabilityFirst Corporation (RFC) | \n", "
967 | \n", "1777 | \n", "MI | \n", "46.131100 | \n", "-88.225000 | \n", "MRO | \n", "POINT (-88.22499999999999 46.1311) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
969 | \n", "1780 | \n", "MI | \n", "45.955300 | \n", "-88.195800 | \n", "MRO | \n", "POINT (-88.19580000000001 45.9553) | \n", "4 | \n", "RFC | \n", "ReliabilityFirst Corporation (RFC) | \n", "
969 | \n", "1780 | \n", "MI | \n", "45.955300 | \n", "-88.195800 | \n", "MRO | \n", "POINT (-88.19580000000001 45.9553) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
970 | \n", "1781 | \n", "MI | \n", "45.990781 | \n", "-88.210514 | \n", "MRO | \n", "POINT (-88.210514 45.990781) | \n", "4 | \n", "RFC | \n", "ReliabilityFirst Corporation (RFC) | \n", "
970 | \n", "1781 | \n", "MI | \n", "45.990781 | \n", "-88.210514 | \n", "MRO | \n", "POINT (-88.210514 45.990781) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
971 | \n", "1784 | \n", "MI | \n", "45.871900 | \n", "-88.069400 | \n", "MRO | \n", "POINT (-88.0694 45.8719) | \n", "4 | \n", "RFC | \n", "ReliabilityFirst Corporation (RFC) | \n", "
971 | \n", "1784 | \n", "MI | \n", "45.871900 | \n", "-88.069400 | \n", "MRO | \n", "POINT (-88.0694 45.8719) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
972 | \n", "1785 | \n", "MI | \n", "46.159200 | \n", "-88.235300 | \n", "MRO | \n", "POINT (-88.2353 46.1592) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
972 | \n", "1785 | \n", "MI | \n", "46.159200 | \n", "-88.235300 | \n", "MRO | \n", "POINT (-88.2353 46.1592) | \n", "4 | \n", "RFC | \n", "ReliabilityFirst Corporation (RFC) | \n", "
977 | \n", "1821 | \n", "MI | \n", "46.106278 | \n", "-88.334531 | \n", "MRO | \n", "POINT (-88.33453100000001 46.106278) | \n", "4 | \n", "RFC | \n", "ReliabilityFirst Corporation (RFC) | \n", "
977 | \n", "1821 | \n", "MI | \n", "46.106278 | \n", "-88.334531 | \n", "MRO | \n", "POINT (-88.33453100000001 46.106278) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
992 | \n", "1848 | \n", "MI | \n", "45.788900 | \n", "-87.905800 | \n", "MRO | \n", "POINT (-87.9058 45.7889) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
992 | \n", "1848 | \n", "MI | \n", "45.788900 | \n", "-87.905800 | \n", "MRO | \n", "POINT (-87.9058 45.7889) | \n", "4 | \n", "RFC | \n", "ReliabilityFirst Corporation (RFC) | \n", "
1978 | \n", "4043 | \n", "WI | \n", "44.253930 | \n", "-88.409560 | \n", "MRO | \n", "POINT (-88.40956 44.25393) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
1978 | \n", "4043 | \n", "WI | \n", "44.253930 | \n", "-88.409560 | \n", "MRO | \n", "POINT (-88.40956 44.25393) | \n", "4 | \n", "RFC | \n", "ReliabilityFirst Corporation (RFC) | \n", "
2017 | \n", "4122 | \n", "WI | \n", "44.316400 | \n", "-88.314700 | \n", "MRO | \n", "POINT (-88.3147 44.3164) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
2017 | \n", "4122 | \n", "WI | \n", "44.316400 | \n", "-88.314700 | \n", "MRO | \n", "POINT (-88.3147 44.3164) | \n", "4 | \n", "RFC | \n", "ReliabilityFirst Corporation (RFC) | \n", "
2020 | \n", "4127 | \n", "WI | \n", "44.200020 | \n", "-88.458171 | \n", "MRO | \n", "POINT (-88.45817099999999 44.20002) | \n", "4 | \n", "RFC | \n", "ReliabilityFirst Corporation (RFC) | \n", "
2020 | \n", "4127 | \n", "WI | \n", "44.200020 | \n", "-88.458171 | \n", "MRO | \n", "POINT (-88.45817099999999 44.20002) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
2191 | \n", "6192 | \n", "FL | \n", "30.573611 | \n", "-86.215833 | \n", "FRCC | \n", "POINT (-86.21583299999999 30.573611) | \n", "1 | \n", "FRCC | \n", "Florida Reliability Coordinating Council (FRCC) | \n", "
2191 | \n", "6192 | \n", "FL | \n", "30.573611 | \n", "-86.215833 | \n", "FRCC | \n", "POINT (-86.21583299999999 30.573611) | \n", "5 | \n", "SERC | \n", "SERC Reliability Corporation (SERC) | \n", "
2565 | \n", "7715 | \n", "FL | \n", "30.592080 | \n", "-87.135391 | \n", "FRCC | \n", "POINT (-87.135391 30.59208) | \n", "1 | \n", "FRCC | \n", "Florida Reliability Coordinating Council (FRCC) | \n", "
2565 | \n", "7715 | \n", "FL | \n", "30.592080 | \n", "-87.135391 | \n", "FRCC | \n", "POINT (-87.135391 30.59208) | \n", "5 | \n", "SERC | \n", "SERC Reliability Corporation (SERC) | \n", "
2614 | \n", "7822 | \n", "WI | \n", "44.274582 | \n", "-88.319074 | \n", "MRO | \n", "POINT (-88.319074 44.274582) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
2614 | \n", "7822 | \n", "WI | \n", "44.274582 | \n", "-88.319074 | \n", "MRO | \n", "POINT (-88.319074 44.274582) | \n", "4 | \n", "RFC | \n", "ReliabilityFirst Corporation (RFC) | \n", "
2947 | \n", "10250 | \n", "FL | \n", "30.266057 | \n", "-85.520670 | \n", "FRCC | \n", "POINT (-85.52067 30.266057) | \n", "1 | \n", "FRCC | \n", "Florida Reliability Coordinating Council (FRCC) | \n", "
2947 | \n", "10250 | \n", "FL | \n", "30.266057 | \n", "-85.520670 | \n", "FRCC | \n", "POINT (-85.52067 30.266057) | \n", "5 | \n", "SERC | \n", "SERC Reliability Corporation (SERC) | \n", "
3027 | \n", "10416 | \n", "FL | \n", "30.595800 | \n", "-87.252500 | \n", "FRCC | \n", "POINT (-87.2525 30.5958) | \n", "5 | \n", "SERC | \n", "SERC Reliability Corporation (SERC) | \n", "
3027 | \n", "10416 | \n", "FL | \n", "30.595800 | \n", "-87.252500 | \n", "FRCC | \n", "POINT (-87.2525 30.5958) | \n", "1 | \n", "FRCC | \n", "Florida Reliability Coordinating Council (FRCC) | \n", "
3434 | \n", "50250 | \n", "FL | \n", "30.596600 | \n", "-87.326400 | \n", "FRCC | \n", "POINT (-87.32640000000001 30.5966) | \n", "5 | \n", "SERC | \n", "SERC Reliability Corporation (SERC) | \n", "
3434 | \n", "50250 | \n", "FL | \n", "30.596600 | \n", "-87.326400 | \n", "FRCC | \n", "POINT (-87.32640000000001 30.5966) | \n", "1 | \n", "FRCC | \n", "Florida Reliability Coordinating Council (FRCC) | \n", "
3435 | \n", "50251 | \n", "MI | \n", "45.795600 | \n", "-87.955600 | \n", "MRO | \n", "POINT (-87.9556 45.7956) | \n", "4 | \n", "RFC | \n", "ReliabilityFirst Corporation (RFC) | \n", "
3435 | \n", "50251 | \n", "MI | \n", "45.795600 | \n", "-87.955600 | \n", "MRO | \n", "POINT (-87.9556 45.7956) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
3471 | \n", "50310 | \n", "FL | \n", "30.473600 | \n", "-87.236100 | \n", "FRCC | \n", "POINT (-87.23609999999999 30.4736) | \n", "5 | \n", "SERC | \n", "SERC Reliability Corporation (SERC) | \n", "
3471 | \n", "50310 | \n", "FL | \n", "30.473600 | \n", "-87.236100 | \n", "FRCC | \n", "POINT (-87.23609999999999 30.4736) | \n", "1 | \n", "FRCC | \n", "Florida Reliability Coordinating Council (FRCC) | \n", "
3681 | \n", "50725 | \n", "FL | \n", "30.848333 | \n", "-87.113333 | \n", "FRCC | \n", "POINT (-87.113333 30.848333) | \n", "1 | \n", "FRCC | \n", "Florida Reliability Coordinating Council (FRCC) | \n", "
3681 | \n", "50725 | \n", "FL | \n", "30.848333 | \n", "-87.113333 | \n", "FRCC | \n", "POINT (-87.113333 30.848333) | \n", "5 | \n", "SERC | \n", "SERC Reliability Corporation (SERC) | \n", "
3723 | \n", "50807 | \n", "FL | \n", "30.141984 | \n", "-85.621103 | \n", "FRCC | \n", "POINT (-85.62110300000001 30.141984) | \n", "1 | \n", "FRCC | \n", "Florida Reliability Coordinating Council (FRCC) | \n", "
3723 | \n", "50807 | \n", "FL | \n", "30.141984 | \n", "-85.621103 | \n", "FRCC | \n", "POINT (-85.62110300000001 30.141984) | \n", "5 | \n", "SERC | \n", "SERC Reliability Corporation (SERC) | \n", "
4327 | \n", "54842 | \n", "WI | \n", "44.286900 | \n", "-88.333900 | \n", "MRO | \n", "POINT (-88.3339 44.2869) | \n", "4 | \n", "RFC | \n", "ReliabilityFirst Corporation (RFC) | \n", "
4327 | \n", "54842 | \n", "WI | \n", "44.286900 | \n", "-88.333900 | \n", "MRO | \n", "POINT (-88.3339 44.2869) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
4352 | \n", "54885 | \n", "WI | \n", "44.276900 | \n", "-88.334400 | \n", "MRO | \n", "POINT (-88.3344 44.2769) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
4352 | \n", "54885 | \n", "WI | \n", "44.276900 | \n", "-88.334400 | \n", "MRO | \n", "POINT (-88.3344 44.2769) | \n", "4 | \n", "RFC | \n", "ReliabilityFirst Corporation (RFC) | \n", "
4527 | \n", "55135 | \n", "WI | \n", "44.193600 | \n", "-88.506400 | \n", "MRO | \n", "POINT (-88.5064 44.1936) | \n", "4 | \n", "RFC | \n", "ReliabilityFirst Corporation (RFC) | \n", "
4527 | \n", "55135 | \n", "WI | \n", "44.193600 | \n", "-88.506400 | \n", "MRO | \n", "POINT (-88.5064 44.1936) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
4610 | \n", "55242 | \n", "FL | \n", "30.566400 | \n", "-87.115000 | \n", "FRCC | \n", "POINT (-87.11499999999999 30.5664) | \n", "1 | \n", "FRCC | \n", "Florida Reliability Coordinating Council (FRCC) | \n", "
4610 | \n", "55242 | \n", "FL | \n", "30.566400 | \n", "-87.115000 | \n", "FRCC | \n", "POINT (-87.11499999999999 30.5664) | \n", "5 | \n", "SERC | \n", "SERC Reliability Corporation (SERC) | \n", "
5022 | \n", "56037 | \n", "WI | \n", "44.189036 | \n", "-88.468492 | \n", "MRO | \n", "POINT (-88.468492 44.189036) | \n", "4 | \n", "RFC | \n", "ReliabilityFirst Corporation (RFC) | \n", "
5022 | \n", "56037 | \n", "WI | \n", "44.189036 | \n", "-88.468492 | \n", "MRO | \n", "POINT (-88.468492 44.189036) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
5397 | \n", "56522 | \n", "FL | \n", "30.928333 | \n", "-85.426111 | \n", "FRCC | \n", "POINT (-85.42611099999999 30.928333) | \n", "1 | \n", "FRCC | \n", "Florida Reliability Coordinating Council (FRCC) | \n", "
5397 | \n", "56522 | \n", "FL | \n", "30.928333 | \n", "-85.426111 | \n", "FRCC | \n", "POINT (-85.42611099999999 30.928333) | \n", "5 | \n", "SERC | \n", "SERC Reliability Corporation (SERC) | \n", "
6162 | \n", "57502 | \n", "FL | \n", "30.570000 | \n", "-87.390000 | \n", "FRCC | \n", "POINT (-87.39 30.57) | \n", "1 | \n", "FRCC | \n", "Florida Reliability Coordinating Council (FRCC) | \n", "
6162 | \n", "57502 | \n", "FL | \n", "30.570000 | \n", "-87.390000 | \n", "FRCC | \n", "POINT (-87.39 30.57) | \n", "5 | \n", "SERC | \n", "SERC Reliability Corporation (SERC) | \n", "
7160 | \n", "58663 | \n", "WI | \n", "44.115000 | \n", "-88.217222 | \n", "MRO | \n", "POINT (-88.21722199999999 44.115) | \n", "2 | \n", "MRO | \n", "Midwest Reliability Organization (MRO) | \n", "
7160 | \n", "58663 | \n", "WI | \n", "44.115000 | \n", "-88.217222 | \n", "MRO | \n", "POINT (-88.21722199999999 44.115) | \n", "4 | \n", "RFC | \n", "ReliabilityFirst Corporation (RFC) | \n", "
7859 | \n", "59689 | \n", "FL | \n", "30.515448 | \n", "-86.518407 | \n", "FRCC | \n", "POINT (-86.518407 30.515448) | \n", "5 | \n", "SERC | \n", "SERC Reliability Corporation (SERC) | \n", "
7859 | \n", "59689 | \n", "FL | \n", "30.515448 | \n", "-86.518407 | \n", "FRCC | \n", "POINT (-86.518407 30.515448) | \n", "1 | \n", "FRCC | \n", "Florida Reliability Coordinating Council (FRCC) | \n", "
\n", " | f | \n", "fuel | \n", "month | \n", "plant id | \n", "total fuel (mmbtu) | \n", "year | \n", "generation (MWh) | \n", "elec fuel (mmbtu) | \n", "geography | \n", "last_updated | \n", "lat | \n", "lon | \n", "prime mover | \n", "datetime | \n", "quarter | \n", "all fuel fossil CO2 (kg) | \n", "elec fuel fossil CO2 (kg) | \n", "all fuel total CO2 (kg) | \n", "elec fuel total CO2 (kg) | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "M | \n", "SUB | \n", "6 | \n", "10360 | \n", "0.0 | \n", "2017 | \n", "0.0 | \n", "0.0 | \n", "USA-WI | \n", "2017-08-24T11:46:12-04:00 | \n", "44.4936 | \n", "-88.0303 | \n", "ALL | \n", "2017-06-01 | \n", "2 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "
1 | \n", "M | \n", "SUB | \n", "5 | \n", "10360 | \n", "0.0 | \n", "2017 | \n", "0.0 | \n", "0.0 | \n", "USA-WI | \n", "2017-08-24T11:46:12-04:00 | \n", "44.4936 | \n", "-88.0303 | \n", "ALL | \n", "2017-05-01 | \n", "2 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "
2 | \n", "M | \n", "SUB | \n", "4 | \n", "10360 | \n", "0.0 | \n", "2017 | \n", "0.0 | \n", "0.0 | \n", "USA-WI | \n", "2017-08-24T11:46:12-04:00 | \n", "44.4936 | \n", "-88.0303 | \n", "ALL | \n", "2017-04-01 | \n", "2 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "
3 | \n", "M | \n", "SUB | \n", "3 | \n", "10360 | \n", "0.0 | \n", "2017 | \n", "0.0 | \n", "0.0 | \n", "USA-WI | \n", "2017-08-24T11:46:12-04:00 | \n", "44.4936 | \n", "-88.0303 | \n", "ALL | \n", "2017-03-01 | \n", "1 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "
4 | \n", "M | \n", "SUB | \n", "2 | \n", "10360 | \n", "0.0 | \n", "2017 | \n", "0.0 | \n", "0.0 | \n", "USA-WI | \n", "2017-08-24T11:46:12-04:00 | \n", "44.4936 | \n", "-88.0303 | \n", "ALL | \n", "2017-02-01 | \n", "1 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "
\n", " | plant id | \n", "nerc | \n", "
---|---|---|
0 | \n", "10867 | \n", "SERC | \n", "
1 | \n", "50903 | \n", "RFC | \n", "
2 | \n", "10671 | \n", "SPP | \n", "
3 | \n", "2527 | \n", "NPCC | \n", "
4 | \n", "3305 | \n", "SERC | \n", "
\n", " | plant id | \n", "year | \n", "lat | \n", "lon | \n", "
---|---|---|---|---|
1544548 | \n", "1275 | \n", "2006 | \n", "38.947222 | \n", "-99.528611 | \n", "
1544560 | \n", "1275 | \n", "2005 | \n", "38.947222 | \n", "-99.528611 | \n", "
1544572 | \n", "1275 | \n", "2004 | \n", "38.947222 | \n", "-99.528611 | \n", "
1544584 | \n", "1275 | \n", "2003 | \n", "38.947222 | \n", "-99.528611 | \n", "
1544596 | \n", "1275 | \n", "2002 | \n", "38.947222 | \n", "-99.528611 | \n", "
\n", " | plant id | \n", "nerc | \n", "
---|---|---|
8923 | \n", "60510 | \n", "SERC | \n", "
8924 | \n", "60511 | \n", "WECC | \n", "
8925 | \n", "60514 | \n", "SERC | \n", "
8926 | \n", "60550 | \n", "SERC | \n", "
8927 | \n", "60571 | \n", "WECC | \n", "
\n", " | plant id | \n", "year | \n", "lat | \n", "lon | \n", "nerc | \n", "
---|---|---|---|---|---|
89242 | \n", "1275 | \n", "2006 | \n", "38.947222 | \n", "-99.528611 | \n", "SPP | \n", "
89243 | \n", "1275 | \n", "2005 | \n", "38.947222 | \n", "-99.528611 | \n", "SPP | \n", "
89244 | \n", "1275 | \n", "2004 | \n", "38.947222 | \n", "-99.528611 | \n", "SPP | \n", "
89245 | \n", "1275 | \n", "2003 | \n", "38.947222 | \n", "-99.528611 | \n", "SPP | \n", "
89246 | \n", "1275 | \n", "2002 | \n", "38.947222 | \n", "-99.528611 | \n", "SPP | \n", "