catalyst-cooperative / pudl

The Public Utility Data Liberation Project provides analysis-ready energy system data to climate advocates, researchers, policymakers, and journalists.
https://catalyst.coop/pudl
MIT License
456 stars 105 forks source link

Retirements missing from EIA #321

Open gschivley opened 5 years ago

gschivley commented 5 years ago

So far I've come across one plant (7939) that looks like it might have retired (or maybe moved?) after 2014. It's in the 2014 860 Generators file as Operable but was never added to the Retired and Canceled sheet. EIA has fuel consumption data through 2014. This is a diesel unit, so maybe it moved?

I came across the issue because NEEDS lists it as operable but it wasn't available as a foreign key from plants_entities_eia with only 2017 EIA data loaded. Not sure if there's an action item but I want a place to track data errors like this.

gschivley commented 5 years ago

Plant 57717 disappears after 2016. Solar, installed 2012, last recorded generation value in 2016. Seems odd that it would disappear from both 923 and 860.

gschivley commented 5 years ago

The full list of plants in NEEDS but not in 2016/2017 EIA files is

{7939,
 56892,
 59089,
 59397,
 59398,
 59399,
 83001,
 83002,
 83003,
 83004,
 83005,
 83006,
 83007}

Will have to look into this more another time.

zaneselvans commented 1 year ago

Even with all years of data loaded, only some of these Plant IDs are showing up in plants_entity_eia.

plant_id_eia plant_name_eia city county latitude longitude state street_address zip_code timezone
3132 7939 Diesel Group 1 Accomack Accomack 37.7714 -75.6342 VA Chesapeake Bay Inlet 23421 America/New_York
6774 56892 Silver Creek Lift Station City of Morganton Burke 35.7386 -81.7114 NC 114 Greenlee Ford Road 28655 America/New_York
8916 59089 Townshend Hydro Townshend Windham 43.0533 -72.7025 VT 3845 Vermont Route 30 05353 America/New_York
9193 59397 LandPro-1 Silver Lakes San Bernardino 34.7622 -117.339 CA 28368 Smithson Rd 92342 America/Los_Angeles
9194 59398 LandPro-2 Silver Lakes San Bernardino 34.7622 -117.339 CA 28368 Smithson Rd 92342 America/Los_Angeles
9195 59399 LandPro-3 Silver Lakes San Bernardino 34.7622 -117.339 CA 28368 Smithson Rd 92342 America/Los_Angeles

None of these plants have resurfaced with any generation data post-2015. Maybe it's a change in what kind of reporting they are subject to?