search

USEPA / ElectricityLCI

Creative Commons Zero v1.0 Universal
24 stars 10 forks source link

Mexican balancing authority labeled as Canada in BA_Codes_930.xlsx #234

Open dt-woods opened 3 months ago

dt-woods commented 3 months ago

Inexplicably, Comision Federal de Electricidad (CFE) is listed under the Canadian balancing authorities (see 'Canada' worksheet in BA_Codes_930.xlsx).

m-jamieson commented 3 months ago

I agree that can be changed - can either add a new sheet for Mexico or change the "Canada" sheet to "International" or something. Are we updating this for the 2020+ results?

dt-woods commented 3 months ago

My personal preference is move away from Microsoft Excel-based data files, which present a certain accessibility limitation and are not particularly well suited for git-based repositories (as they are stored as binaries).

For a 2020+ update, what do you suggest? I could see a potential API call or data file(s) with balancing authority names.

m-jamieson commented 3 months ago

I don't think we're quite ready for API calls in the elci right? I know it's coming, but right now, I would want to avoid users having to get their own API key to use elci. This might be the last version for that though.

Having said all that, separate data files is okay with me.

dt-woods commented 3 months ago

FYI: https://github.com/USEPA/ElectricityLCI/issues/207 is currently solved using an API call.

dt-woods commented 3 months ago

I don't think we're quite ready for API calls in the elci right? I know it's coming, but right now, I would want to avoid users having to get their own API key to use elci. This might be the last version for that though.

Having said all that, separate data files is okay with me.

Where did you get this EIA Operations Report in BA_Codes_930.xlsx?

Best I could find is the "EIA-930 data reference tables" in the About tab here: https://www.eia.gov/electricity/gridmonitor/about

I'm not finding a great resource for the annual BA codes in operation.

@bl-young, can StEWI return a list of balancing authority names, codes (abbreviations), and country of origin for a given year?

bl-young commented 3 months ago

@bl-young, can StEWI return a list of balancing authority names, codes (abbreviations), and country of origin for a given year?

we don't currently access any EIA data in StEWI, only egrid (which I don't think has this information)

m-jamieson commented 3 months ago

It appears EIA doesn't publish the "old" version of this report. What you found looks to be the most up-to-date. I guess the added bonus there is some data to track inactive vs. active BAs, along with activation/retirement dates. Not sure whether there will be a need to explicitly address that though. Seems like the only place where we might do that is "quality checking" EIAs trading data, which I don't foresee doing.