Ask the Grid
Ask the Grid
Open live grid
SPP logo

Settlement / EIR Source-Sink Mapping

Published settlement location to source/sink and PSE relationships, preserving effective/termination labels and source/sink direction.

Infrastructure dataSPP market
Query with the agent
Native record
complete source publication × source row ordinal; preserve BAA
source model publication publication cadence
Evidence
Reference data
Stable context used to interpret other datasets
Time basis
Point-in-time records
UTC · static reference

Overview

No exact DC-tie or physical-equipment join is inferred. Complete views require a matching receipt and mirrored row count; empty results are unknown coverage. Raw sources retain publication history internally.

Query contract

Published settlement location to source/sink and PSE relationships, preserving effective/termination labels and source/sink direction. No exact DC-tie or physical-equipment join is inferred. Complete views require a matching receipt and mirrored row count; empty results are unknown coverage. Raw sources retain publication history internally.

Analysis rules

  • Keep SPP East and SWPW West separate. Never combine a published Total with its footprint components.
  • Do not sum model rows, publication attempts, repeated forecast vintages or duplicate weekly report entries as physical capacity.

Interpretation

  • Published settlement location to source/sink and PSE relationships, preserving effective/termination labels and source/sink direction. No exact DC-tie or physical-equipment join is inferred. Complete views require a matching receipt and mirrored row count; empty results are unknown coverage. Raw sources retain publication history internally.
  • Model identities are not authoritative physical asset IDs, coordinates, outage attribution or nodal sensitivities.

Access

Query from your own tools

Use the guarded HTTP endpoint directly, or connect an MCP client and load the dataset contract with describe_data before calling query_data.

SPP MCP API reference
HTTP endpoint
POST /api/v1/datasets/spp_public_model_eir_mappings/query

Need the full history of this dataset in Snowflake, Databricks or your own storage? Data services delivers it on a schedule.

Schema17

Column
Type
event_timeDateTime64(6, 'UTC')
published_atDateTime64(6, 'UTC')
snapshot_timeDateTime64(6, 'UTC')
snapshot_idString
row_numberInt64
baaString
source_fileString
source_urlString
content_hashString
record_jsonString
settlement_locationNullable(String)
source_sinkNullable(String)
source_effective_dateNullable(String)
source_termination_dateNullable(String)
pseNullable(String)
directionNullable(String)
ingested_atDateTime64(6, 'UTC')

Sample data

event_timepublished_atsnapshot_timesnapshot_idrow_numberbaasource_filesource_urlcontent_hashrecord_jsonsettlement_locationsource_sinksource_effective_datesource_termination_datepsedirectioningested_at
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af41Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "ADA1_LD", "Source/Sink Name": "ADA1_LD", "EFFECTIVEDATE": "08/01/2024", "TERMINATIONDATE": "12/31/2999", "PSE": "PSE2", "SOURCE_SINK": "Source/Sink"}ADA1_LDADA1_LD08/01/202412/31/2999PSE2Source/Sink2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af42Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "ADACMNT_LD", "Source/Sink Name": "ADACMNT_LD", "EFFECTIVEDATE": "02/01/2022", "TERMINATIONDATE": "12/31/2999", "PSE": "VLT001", "SOURCE_SINK": "Source/Sink"}ADACMNT_LDADACMNT_LD02/01/202212/31/2999VLT001Source/Sink2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af43Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "AEC", "Source/Sink Name": "AEC", "EFFECTIVEDATE": "01/01/2014", "TERMINATIONDATE": "12/31/2999", "PSE": "SWPP01", "SOURCE_SINK": "Source/Sink"}AECAEC01/01/201412/31/2999SWPP01Source/Sink2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af44Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "AECC_CSWS", "Source/Sink Name": "AECC", "EFFECTIVEDATE": "01/01/2014", "TERMINATIONDATE": "12/31/2999", "PSE": "AECC01", "SOURCE_SINK": "Sink"}AECC_CSWSAECC01/01/201412/31/2999AECC01Sink2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af45Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "AECC_CSWS", "Source/Sink Name": "AREC_CSWS", "EFFECTIVEDATE": "01/01/2014", "TERMINATIONDATE": "12/31/2999", "PSE": "AECC01", "SOURCE_SINK": "Source/Sink"}AECC_CSWSAREC_CSWS01/01/201412/31/2999AECC01Source/Sink2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af46Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "AECC_CSWS", "Source/Sink Name": "CSWS.AECC", "EFFECTIVEDATE": "01/01/2014", "TERMINATIONDATE": "12/31/2999", "PSE": "AECC01", "SOURCE_SINK": "Source/Sink"}AECC_CSWSCSWS.AECC01/01/201412/31/2999AECC01Source/Sink2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af47Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "AECC_CSWS", "Source/Sink Name": "OKGE.AVCC", "EFFECTIVEDATE": "07/01/2015", "TERMINATIONDATE": "12/31/2999", "PSE": "AECC01", "SOURCE_SINK": "Source/Sink"}AECC_CSWSOKGE.AVCC07/01/201512/31/2999AECC01Source/Sink2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af48Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "AECC_ELKINS", "Source/Sink Name": "AECC.ELKINS", "EFFECTIVEDATE": "12/01/2015", "TERMINATIONDATE": "12/31/2999", "PSE": "AECC01", "SOURCE_SINK": "Source"}AECC_ELKINSAECC.ELKINS12/01/201512/31/2999AECC01Source2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af49Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "AECC_ELKINS", "Source/Sink Name": "AECC.ELKINS1", "EFFECTIVEDATE": "12/01/2015", "TERMINATIONDATE": "12/31/2999", "PSE": "AECC01", "SOURCE_SINK": "Source"}AECC_ELKINSAECC.ELKINS112/01/201512/31/2999AECC01Source2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af410Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "AECC_ELKINS", "Source/Sink Name": "AECC.ELKINS2", "EFFECTIVEDATE": "12/01/2015", "TERMINATIONDATE": "12/31/2999", "PSE": "AECC01", "SOURCE_SINK": "Source"}AECC_ELKINSAECC.ELKINS212/01/201512/31/2999AECC01Source2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af411Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "AECC_ELKINS", "Source/Sink Name": "AECC.ELKINS3", "EFFECTIVEDATE": "12/01/2015", "TERMINATIONDATE": "12/31/2999", "PSE": "AECC01", "SOURCE_SINK": "Source"}AECC_ELKINSAECC.ELKINS312/01/201512/31/2999AECC01Source2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af412Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "AECC_FITZHUGH", "Source/Sink Name": "AECC.FITZHUGH", "EFFECTIVEDATE": "01/01/2014", "TERMINATIONDATE": "12/31/2999", "PSE": "AECC01", "SOURCE_SINK": "Source"}AECC_FITZHUGHAECC.FITZHUGH01/01/201412/31/2999AECC01Source2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af413Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "AECC_FLTCREEK", "Source/Sink Name": "AECC.FLTCREEK", "EFFECTIVEDATE": "01/01/2014", "TERMINATIONDATE": "12/31/2999", "PSE": "AECC01", "SOURCE_SINK": "Source"}AECC_FLTCREEKAECC.FLTCREEK01/01/201412/31/2999AECC01Source2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af414Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "AECC_FULTON", "Source/Sink Name": "AECC.FULTON", "EFFECTIVEDATE": "01/01/2014", "TERMINATIONDATE": "12/31/2999", "PSE": "AECC01", "SOURCE_SINK": "Source"}AECC_FULTONAECC.FULTON01/01/201412/31/2999AECC01Source2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af415Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "AECC_HYDRO13", "Source/Sink Name": "AECC.HYDRO13", "EFFECTIVEDATE": "01/01/2014", "TERMINATIONDATE": "12/31/2999", "PSE": "AECC01", "SOURCE_SINK": "Source"}AECC_HYDRO13AECC.HYDRO1301/01/201412/31/2999AECC01Source2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af416Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "AECC_JWTURK", "Source/Sink Name": "AECC.JWTURK", "EFFECTIVEDATE": "01/01/2014", "TERMINATIONDATE": "12/31/2999", "PSE": "AECC01", "SOURCE_SINK": "Source"}AECC_JWTURKAECC.JWTURK01/01/201412/31/2999AECC01Source2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af417Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "AECI", "Source/Sink Name": "AECI", "EFFECTIVEDATE": "01/01/2014", "TERMINATIONDATE": "12/31/2999", "PSE": "SWPP01", "SOURCE_SINK": "Source/Sink"}AECIAECI01/01/201412/31/2999SWPP01Source/Sink2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af418Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "AECI", "Source/Sink Name": "AECI", "EFFECTIVEDATE": "04/01/2026", "TERMINATIONDATE": "12/31/2999", "PSE": "SWPW01", "SOURCE_SINK": "Source/Sink"}AECIAECI04/01/202612/31/2999SWPW01Source/Sink2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af419Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "AECI", "Source/Sink Name": "MOPEP_AECI", "EFFECTIVEDATE": "01/01/2014", "TERMINATIONDATE": "12/31/2999", "PSE": "WRGSRT", "SOURCE_SINK": "Source/Sink"}AECIMOPEP_AECI01/01/201412/31/2999WRGSRTSource/Sink2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af420Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "AECI", "Source/Sink Name": "OZMO", "EFFECTIVEDATE": "01/01/2014", "TERMINATIONDATE": "12/31/2999", "PSE": "WRGSRT", "SOURCE_SINK": "Source/Sink"}AECIOZMO01/01/201412/31/2999WRGSRTSource/Sink2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af421Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "AEPM_CSWS", "Source/Sink Name": "CSWS", "EFFECTIVEDATE": "01/01/2014", "TERMINATIONDATE": "12/31/2999", "PSE": "AEPMEA", "SOURCE_SINK": "Source/Sink"}AEPM_CSWSCSWS01/01/201412/31/2999AEPMEASource/Sink2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af422Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "AEPM_CSWS", "Source/Sink Name": "CSWS.ETEC", "EFFECTIVEDATE": "01/01/2014", "TERMINATIONDATE": "12/31/2999", "PSE": "ETEC03", "SOURCE_SINK": "Sink"}AEPM_CSWSCSWS.ETEC01/01/201412/31/2999ETEC03Sink2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af423Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "AEPM_CSWS", "Source/Sink Name": "CSWS.NTEC", "EFFECTIVEDATE": "01/01/2014", "TERMINATIONDATE": "12/31/2999", "PSE": "NTEC01", "SOURCE_SINK": "Sink"}AEPM_CSWSCSWS.NTEC01/01/201412/31/2999NTEC01Sink2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af424Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "AEPM_CSWS", "Source/Sink Name": "CSWS.TEXL", "EFFECTIVEDATE": "01/01/2014", "TERMINATIONDATE": "12/31/2999", "PSE": "TEXL01", "SOURCE_SINK": "Sink"}AEPM_CSWSCSWS.TEXL01/01/201412/31/2999TEXL01Sink2026-10-09 19:06:36.230596
2026-10-02 15:05:21.3070002026-10-02 15:05:21.3070002026-10-09 19:06:36.172980849acf22b4c91c24fa4f85058bba2aa45d2b913fc2ab5043c61bb7df75077af425Modeling_Reports/SL_EIR_Mapping.csvhttps://portal.spp.org/e40ab8d508a5f8827bc535e9768cc9d1bda8998362d39280584cbd2da2b1be0c{"Settlement Location Name": "AEPM_CSWS", "Source/Sink Name": "CSWS_ALLEN", "EFFECTIVEDATE": "12/01/2021", "TERMINATIONDATE": "12/31/2999", "PSE": "AEPMEA", "SOURCE_SINK": "Sink"}AEPM_CSWSCSWS_ALLEN12/01/202112/31/2999AEPMEASink2026-10-09 19:06:36.230596

Coverage

No time-indexed data — coverage isn’t applicable to this dataset.