Missing and incorrect latitude / longitude data in `plants_entity_eia`

Several related issues:

It appears that somewhere in the pudl pipeline, the latitude (but not longitude) data is being dropped from plants_entity_eia and other tables that contain lat/long data. As far as I can tell from manually inspecting the raw EIA-860 plants file from 2022, there are a small number of plants that are missing both lat/long data, but none that are only missing latitude data.
It also appears that there are several plants where the sign of the longitude is being flipped from negative to positive (which locates these plants in China)
There is one plant that is being assigned a nonsense longitude of -188 (plant 61445)
There are a handful of plants that are assigned seemingly made-up coordinates in the middle of the Atlantic ocean, generally around (42, -42)

Medium: With some effort, I can work around the bug.

I downloaded data from https://s3.us-west-2.amazonaws.com/pudl.catalyst.coop/v2023.12.01/pudl.sqlite.gz, and am loading the plants_entity_eia table using pd.read_sql("SELECT plant_id_eia, latitude, longitude FROM plants_entity_eia", PUDL_ENGINE)

213 plants are missing latitudes

16 plants have coordinates further east than the east coast of the US:

One plant has a non-existant coordinate:

Spot checking these plants revealed that they all appear to have valid/non-missing coordinates in the 2022 EIA-860 plants file.

I expect the lat/long data in plants_entity_eia to match the lat/long data in the most recent raw EIA-860 table for which lat/long data is available.

Add any other context about the problem here.

catalyst-cooperative / pudl