Interconnection Queues#

import gridstatus
import pandas as pd
import plotly.express as px

NYISO Interconnection Queue#

The get_interconnection_queue call returns projects that are “active”, “completed”, and “withdrawn”

iso = gridstatus.NYISO()
queue = iso.get_interconnection_queue()
queue.head()
Queue ID Project Name Interconnecting Entity County State Interconnection Location Transmission Owner Generation Type Capacity (MW) Summer Capacity (MW) ... Withdrawn Date Withdrawal Comment Actual Completion Date Proposed In-Service Proposed Initial-Sync Date Last Updated Date Z S Availability of Studies SGIA Tender Date
0 0276 Homer Solar Energy Center NaN Cortland NY NaN NM-NG Solar 90.0 90.0 ... NaN NaN NaN NaT 2023-09-01 9/30/2022 C 10.0 FES, SRIS, FS NaN
1 0393 Berrians East Replacement NaN Queens NY NaN CONED Dual Fuel 94.2 94.2 ... NaN NaN NaN NaT 2024-08-01 6/30/2022 J 11.0 FES, SRIS, FS NaN
2 0396 Baron Winds NaN Steuben NY NaN NYSEG Wind 238.4 238.4 ... NaN NaN NaN NaT 2022-11-29 12/31/2022 C 13.0 FES, SRIS, FS NaN
3 0396A Wood Street Transformer NaN Putnam NY NaN NYSEG AC Transmission 0.0 NaN ... NaN NaN NaN NaT NaT 4/30/2021 G 12.0 SIS NaN
4 0422 Eight Point Wind Energy Center NaN Steuben-Allegany NY NaN NYSEG Wind 101.8 101.8 ... NaN NaN NaN NaT 2022-11-01 3/31/2021 C 12.0 FES, SRIS, FS NaN

5 rows × 24 columns

status_distributions = queue["Status"].value_counts()
fig = px.bar(
    status_distributions,
    x=status_distributions.index,
    y="Status",
    title="Project by Status - NYISO",
)
fig.show("svg")
../../_images/a43896c1fa179cc727ef521c0a158a513fcad6001e84d06207c238ac89f091f6.svg

Days in Queue#

queue["Days in Queue"] = (pd.Timestamp.now() - queue["Queue Date"]).dt.days
active = queue[queue["Status"] == "Active"]
fig = px.histogram(
    active, x="Days in Queue", title="Days in Queue - Active Projects - NYISO"
)
fig.show("svg")
../../_images/c49f55fbfee9c3a55e50537464cfd7feefac5d93ffa468b746a75587b60de454.svg

Top Active Project Types#

generation_types = active["Generation Type"].value_counts()
fig = px.bar(
    generation_types,
    x=generation_types.index,
    y="Generation Type",
    title="Project by Type - NYISO",
)
fig.show("svg")
../../_images/5d875bfd613f36f296d841f0faa808abba594db6ccad16dbab0f5ca600dfc62c.svg

Proposed Completion Date#

fig = px.histogram(
    active,
    x="Proposed Completion Date",
    title="Proposed Completion Date - NYISO",
    color="Generation Type",
)
fig.show("svg")
../../_images/ed77aa600bfc2646aa2864102d8f134a32e30e30118ec8062745f42b996e7732.svg

Get Interconnection Queue Data from All ISOs#

all_queues = gridstatus.get_interconnection_queues()
all_queues
100%|██████████| 7/7 [00:22<00:00,  3.27s/it]
ISO Queue ID Project Name Interconnecting Entity County State Interconnection Location Transmission Owner Generation Type Capacity (MW) Summer Capacity (MW) Winter Capacity (MW) Queue Date Status Proposed Completion Date Withdrawn Date Withdrawal Comment Actual Completion Date
0 Midcontinent ISO E002 None None Pointe Coupee LA 500 kV switchyard at Big Cajon II Entergy Gas 15.000000 15.0 15.0 2013-09-13T04:00:00Z Done None None None None
1 Midcontinent ISO E291 None None TX Rich 138 kV substation Entergy Hydro 27.000000 27.0 27.0 2012-05-15T04:00:00Z Done 2016-01-31T05:00:00Z None None None
2 Midcontinent ISO G001 None None Brown County WI Unknown American Transmission Co. LLC 255.000000 255.0 255.0 1995-11-08T05:00:00Z Withdrawn 2014-11-17T05:00:00Z None None None
3 Midcontinent ISO G002 None None Trimble County KY Unknown LG&E and KU Services Company as agent for Loui... Coal 174.000000 174.0 174.0 1998-12-01T05:00:00Z Done 2016-01-01T05:00:00Z None None None
4 Midcontinent ISO G003 None None Trimble County KY Unknown LG&E and KU Services Company as agent for Loui... Coal 174.000000 174.0 174.0 1998-12-01T05:00:00Z Done 2004-01-01T05:00:00Z None None None
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
19870 ISO New England 1308 Uxbridge Substation – NG Hopedale West Group S... None Worcester MA NG Feeder 321W6, Uxbridge T2 NaN BAT 6.994000 6.994 6.994 2022-09-09 00:00:00 Withdrawn 2024-11-15 00:00:00 NaT None None
19871 ISO New England 1310 Battery Storage None Berkshire MA 115 kV Transmission line (1211 - Present betwe... NaN BAT 118.750000 118.75 118.75 2022-09-22 00:00:00 Withdrawn 2025-09-30 00:00:00 NaT None None
19872 ISO New England 1314 Offshore Wind None NaN MA Eversource 115kV Acushnet, lines 112/114 NaN WND 470.000000 470.0 470.0 2022-09-26 00:00:00 Withdrawn 2029-09-01 00:00:00 NaT None None
19873 ISO New England 1315 Battery Storage None Windham CT Eversource Killingly Substation,115kV BUS, Tra... NaN BAT 106.970001 106.970001 106.970001 2022-09-28 00:00:00 Withdrawn 2026-06-09 00:00:00 NaT None None
19874 ISO New England 1316 Solar plus Battery None Cheshire NH Eversource 115kV line L163 NaN SUN BAT 102.000000 102.0 102.0 2022-09-30 00:00:00 Withdrawn 2027-10-28 00:00:00 NaT None None

19875 rows × 18 columns

all_queues["Status"].value_counts()
Withdrawn                                    7464
Active                                       6624
WITHDRAWN                                    1606
In Service                                   1031
Done                                          763
Completed                                     758
ACTIVE                                        470
Engineering and Procurement                   322
Confirmed                                     223
COMPLETED                                     199
Retracted                                     131
Suspended                                      78
Deactivated                                    57
Partially in Service - Under Construction      55
Under Construction                             53
Annulled                                       24
Withdrawn - Pending Cure                        2
                                                1
Name: Status, dtype: int64