DER Hosting Capacity by Grid Section

Every record on NYSERDA IEDR's New York hosting-capacity map, one row per weekly snapshot: `asset_type` is `segment` (a line section of a radial feeder), `feeder`, or Con Ed's `network`, `network-area`, `network-structure` and `transformer`; `parent_id` links a segment to its feeder.

NYSERDA IEDRInfrastructure data

Download data Open on map

Native record

event_time x asset_id

weekly snapshot publication cadence

Evidence

Observed market data

Published observations from the named source

In Ask the Grid

DER hosting capacity on the NYISO map

Values for the live grid surface

Overview

Each `*_max_hosting_capacity_mw` is the largest single project that could connect AT THAT POINT before upgrades, for generic DER, ESS charging, ESS discharging and EVSE. Points on a feeder share its capacity, so NEVER sum these values: count or rank locations instead (for example the share of a county's `segment` and `network-area` rows with `max_hosting_capacity_mw >= 1`). Utility methods differ: Central Hudson values stop at 6 MW and the rest at 10, Orange and Rockland publishes bands (0.99, 1.99, 2.99, 4.99), LIPA and Orange and Rockland publish no ESS values, and Con Ed `network` rows read like kW. Read one snapshot at a time: `event_time = (SELECT max(event_time) FROM iedr.hosting_capacity_assets)`.

Query contract

Preserve one canonical row per (event_time, asset_id) before aggregating.

Analysis rules

Group only after preserving the declared grain: event_time, asset_id.

Schema25

Column

Type

event_timeDateTime64(6, 'UTC')

asset_idString

asset_nameNullable(String)

asset_typeLowCardinality(Nullable(String))

parent_idNullable(String)

county_idLowCardinality(Nullable(String))

county_nameLowCardinality(Nullable(String))

utility_idLowCardinality(Nullable(String))

utility_nameLowCardinality(Nullable(String))

zip_codeLowCardinality(Nullable(String))

iso_zone_idLowCardinality(Nullable(String))

voltageLowCardinality(Nullable(String))

hc_estimatedNullable(Bool)

min_hosting_capacity_mwNullable(Float64)

max_hosting_capacity_mwNullable(Float64)

ess_charging_min_hosting_capacity_mwNullable(Float64)

ess_charging_max_hosting_capacity_mwNullable(Float64)

ess_discharging_min_hosting_capacity_mwNullable(Float64)

ess_discharging_max_hosting_capacity_mwNullable(Float64)

evse_min_hosting_capacity_mwNullable(Float64)

evse_max_hosting_capacity_mwNullable(Float64)

centroid_lonNullable(Float64)

centroid_latNullable(Float64)

source_timeDateTime64(6, 'UTC')

ingested_atDateTime64(6, 'UTC')

Sample data

event_time	asset_id	asset_name	asset_type	parent_id	county_id	county_name	utility_id	utility_name	zip_code	iso_zone_id	voltage	hc_estimated	min_hosting_capacity_mw	max_hosting_capacity_mw	ess_charging_min_hosting_capacity_mw	ess_charging_max_hosting_capacity_mw	ess_discharging_min_hosting_capacity_mw	ess_discharging_max_hosting_capacity_mw	evse_min_hosting_capacity_mw	evse_max_hosting_capacity_mw	centroid_lon	centroid_lat	source_time	ingested_at
2026-09-24 18:52:38.002805	CHG-602096.18_1037850.094	602096.18_1037850.094	segment	CHG-5012	974153	Ulster	chg-electricity	Central Hudson	12561	G	7.621023553	false	0	0	0	0	0	∅	∅	∅	-74.098399	41.682248	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602093.193_947486.254	602093.193_947486.254	segment	CHG-4095	974134	Orange	chg-electricity	Central Hudson	12553	G	7.621023553	false	0	0	0	0	0	∅	∅	∅	-74.0989	41.434161	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602092.251_1227378.071	602092.251_1227378.071	segment	CHG-2385	974118	Greene	chg-electricity	Central Hudson	12436	G	2.4017771198	false	0	0	0	0	0	∅	∅	∅	-74.09396	42.201761	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602091.59_1313227.462	602091.59_1313227.462	segment	CHG-2061	974099	Albany	chg-electricity	Central Hudson	12083	G	13.2	false	0.5	1.5	0.05	1	0.5	∅	∅	∅	-74.093391	42.437173	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602088.888_1100723.547	602088.888_1100723.547	segment	CHG-3021	974153	Ulster	chg-electricity	Central Hudson	12472	G	13.2	false	0.3	2.6	0.05	2.6	0.3	∅	∅	∅	-74.096526	41.853985	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602087.682_1155877.591	602087.682_1155877.591	segment	CHG-3014	974153	Ulster	chg-electricity	Central Hudson	12491	G	7.9674337148	false	0	0	0	0	0	∅	∅	∅	-74.095427	42.005946	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602085.061_1033248.58	602085.061_1033248.58	segment	CHG-5012	974153	Ulster	chg-electricity	Central Hudson	12548	G	13.2	false	0.6	4.9	0.6	5	0.1	∅	∅	∅	-74.0975	41.66914	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602082.891_985001.158	602082.891_985001.158	segment	CHG-4023	974134	Orange	chg-electricity	Central Hudson	12550	G	7.621023553	false	0	0	0	0	0	∅	∅	∅	-74.098692	41.536939	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602081.091_1028530.874	602081.091_1028530.874	segment	CHG-5013	974153	Ulster	chg-electricity	Central Hudson	12548	G	7.621023553	false	0	0	0	0	0	∅	∅	∅	-74.097922	41.655732	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602079.08_981878.769	602079.08_981878.769	segment	CHG-4022	974134	Orange	chg-electricity	Central Hudson	12550	G	13.8	false	6	6	3.5	6	5.9	∅	∅	∅	-74.099292	41.527667	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602075.928_1018826.564	602075.928_1018826.564	segment	CHG-5013	974153	Ulster	chg-electricity	Central Hudson	12589	G	13.2	false	0.8	3.9	1.2	3	0.5	∅	∅	∅	-74.098077	41.629689	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602075.518_1289259.356	602075.518_1289259.356	segment	CHG-2043	974118	Greene	chg-electricity	Central Hudson	12423	G	13.2	false	0.4	3	0.05	1.1	0.4	∅	∅	∅	-74.092817	42.371626	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602074.225_1116914.189	602074.225_1116914.189	segment	CHG-2094	974153	Ulster	chg-electricity	Central Hudson	12401	G	13.2	false	1.5	4.8	1.5	6	1.5	∅	∅	∅	-74.095959	41.898962	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602073.15_1013741.672	602073.15_1013741.672	segment	CHG-5013	974153	Ulster	chg-electricity	Central Hudson	12589	G	7.621023553	false	0	0	0	0	0	∅	∅	∅	-74.097997	41.61492	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602070.788_1091005.48	602070.788_1091005.48	segment	CHG-3022	974153	Ulster	chg-electricity	Central Hudson	12472	G	2.4017771198	false	0	0	0	0	0	∅	∅	∅	-74.097472	41.827282	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602067.675_946307.773	602067.675_946307.773	segment	CHG-4095	974134	Orange	chg-electricity	Central Hudson	12577	G	7.621023553	false	0	0	0	0	0	∅	∅	∅	-74.098519	41.430673	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602067.452_999262.926	602067.452_999262.926	segment	CHG-5041	974134	Orange	chg-electricity	Central Hudson	12550	G	13.2	false	0.05	3.6	0.05	2.6	0.05	∅	∅	∅	-74.098157	41.575881	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602066.802_1156266.328	602066.802_1156266.328	segment	CHG-3014	974153	Ulster	chg-electricity	Central Hudson	12491	G	7.9674337148	false	0	0	0	0	0	∅	∅	∅	-74.095462	42.00648	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602065.034_1349319.104	602065.034_1349319.104	segment	CHG-1091	974099	Albany	chg-electricity	Central Hudson	12023	G	13.2	false	0.05	1.6	0.05	0.5	0.05	∅	∅	∅	-74.091542	42.536586	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602064.344_999253.514	602064.344_999253.514	segment	CHG-5041	974134	Orange	chg-electricity	Central Hudson	12550	G	13.2	false	0.05	2.9	0.05	2.6	0.05	∅	∅	∅	-74.098155	41.575866	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602063.456_1013204.382	602063.456_1013204.382	segment	CHG-5013	974153	Ulster	chg-electricity	Central Hudson	12589	G	7.621023553	false	0	0	0	0	0	∅	∅	∅	-74.098038	41.614122	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602061.327_1292024.797	602061.327_1292024.797	segment	CHG-2043	974118	Greene	chg-electricity	Central Hudson	12423	G	7.621023553	false	0	0	0	0	0	∅	∅	∅	-74.092555	42.379154	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602060.894_965155.027	602060.894_965155.027	segment	CHG-4091	974134	Orange	chg-electricity	Central Hudson	12553	G	7.621023553	false	0	0	0	0	0	∅	∅	∅	-74.098417	41.482325	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602058.84_1158420.976	602058.84_1158420.976	segment	CHG-3013	974153	Ulster	chg-electricity	Central Hudson	12491	G	7.621023553	false	0	0	0	0	0	∅	∅	∅	-74.095697	42.012518	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972
2026-09-24 18:52:38.002805	CHG-602057.746_983754.339	602057.746_983754.339	segment	CHG-4023	974134	Orange	chg-electricity	Central Hudson	12550	G	13.2	false	0.05	2	0.05	1.9	0.05	∅	∅	∅	-74.098227	41.533111	2026-09-24 18:52:38.002805	2026-09-24 18:52:38.671972

Coverage

100.0% complete0 gap days1 days with data

Show coverage history

Coverage: 100.0%Days with data: 1Gaps: 0

2026

gaplessmore

Related infrastructure data

Related infrastructure data
Dataset	Description
DER Hosting Capacity by CountyNYSERDA IEDR · daily snapshot	NYSERDA Integrated Energy Data Resource (IEDR) per-county rollup for New York State's 62 counties: DER counts by status, county population and centroid, and IEDR's min/max/total hosting capacity for generic DER, ESS charging, ESS discharging, and EV load. `feeder_count` is NOT a feeder count: it counts every hosting-capacity record IEDR maps in the county (line segments, feeders and Con Ed network records). The `total_*` columns add up those records' per-location values, which share feeder capacity, so they are not capacity or headroom: never quote them as MW available. For how much of a county can take a project, count records in `iedr.hosting_capacity_assets` instead. `county_id` is an IEDR-internal identifier, NOT a FIPS code. Bitemporal snapshot: use argMax(..., event_time) per county_id for the current row.
BPA Anemometer TowersBPA · daily	BPA's anemometer towers with coordinates, elevation and sensor heights, active and retired.
BPA Interconnection QueueBPA · daily snapshot	BPA's public large-generator interconnection queue, with requested capacity, technology, county and state, proposed point of interconnection, BPA's status, and agreed in-service dates. Each posting is a snapshot: current totals must use one latest snapshot, and requested queue MW is not operating capacity, available transmission headroom, completed study work, or evidence that a project will be built. BPA runs line and load requests as a separate queue, held in interconnection_queue.bpat_load.
BPA Line and Load Interconnection QueueBPA · daily snapshot	BPA's public line and load interconnection queue: requests to connect new load, or a new line, to BPA's transmission system, with the requesting utility or customer, county, requested MW, BPA's status, and agreed in-service dates. Each posting is a snapshot: current totals must use one latest snapshot, and requested MW is neither approved nor connected load. Generator requests are a separate queue, held in interconnection_queue.bpat.