Electric DER siting shortlist

Electric DER siting shortlist

Rank substations by DER hosting capacity and export a GeoJSON shortlist

1. Capture the layer's edit timestamps. There is no changelog for this API, so editingInfo.dataLastEditDate is the only provenance a downstream report can cite.
2. One request summarizes the entire grid — max, average and segment count per substation, ordered by peak capacity. 135 rows instead of 880,623 features.
3. Within the chosen substation, return the single highest-capacity segment on each feeder. Note that queryTopFeatures requires BOTH topFilter and where — omitting where returns "No where clause specified." with HTTP 200.
4. Count before fetching. A single substation can hold tens of thousands of segments — the BONNYVILLE substation returned 34,009 on 2026-07-27.
5. Pull only the qualifying segments, reprojected to WGS84 so the output drops straight into a web map. Page on properties.exceededTransferLimit, ordering by OBJECTID for stable paging.

What you'll need to have ready

• substation: SUB_NAME to drill into. Leave empty on the first pass and fill it from step 2.
• minCapacityKw: Minimum DER_CAP_KW for a segment to make the shortlist.
• pageSize: Features per page. maxRecordCount is 1000 with geometry.

For your developer

Arazzo workflow atco:der-siting-shortlist, 5 operations: getHostingCapacityLayerInfo → queryHostingCapacity → queryTopHostingCapacityFeatures → queryHostingCapacityByPost → queryHostingCapacity. Specs on APIs.io.