Fetch the interconnection queue report from CAISO OASIS: GET https://oasis.caiso.com/oasisapi/SingleZip?queryname=IQM_QUEUE&version=1&resultformat=6 and decompress the returned ZIP containing the CSV data file
Parse the CSV columns: QueueNumber, ApplicationDate, ResourceName, FuelType, CapacityMW, POI_Name, County, Status, and StudyGroup to identify active storage and hybrid DER projects
Filter for Status = 'Active' and FuelType containing 'Storage' or 'Photovoltaic' to identify DER candidates; note that as of June 2025 CAISO's interconnection prioritization process introduced a new queue ordering methodology
Cross-reference POI substations against the SCE or PG&E Integration Capacity Analysis (ICA) hosting capacity map API: GET the GeoJSON layer from the respective ICA portal to retrieve available capacity in MW at each substation
Identify projects at POIs with negative ICA headroom (overloaded) versus positive headroom as a proxy for likely upgrade costs
Export results to a structured dataframe keyed by QueueNumber for use in project development screening
Known gotchas
CAISO OASIS ZIP responses contain multiple files including metadata and data CSVs; the actual data file has a name matching the query pattern — do not attempt to parse the metadata file as data
ICA map data from PG&E and SCE uses different coordinate reference systems for polygon boundaries; SCE publishes GeoJSON in WGS84 while older PG&E data may use a California State Plane projection
CAISO's new 2025 Interconnection Prioritization Process (effective June 25, 2025) changed queue ordering for new projects but does not retroactively re-rank projects already in study; segregate pre- and post-June 2025 applications when interpreting study timelines
Give your agent this knowledge — and 200+ more routes
One MCP install gives any agent live access to the full route map, with trust scores updated by agent consensus:
claude mcp add --transport http waymark https://mcp.waymark.network/mcp