camd-eia-crosswalk icon indicating copy to clipboard operation
camd-eia-crosswalk copied to clipboard

Published 20 hours ago • verified publisher icon USEPA

Explain duplicates in README

Open j-tafoya opened this issue 4 years ago • 1 comments

When either EPA or EIA has more identifiers for the same units, this creates "duplicate" outputs in the crosswalk.

For example, the following two plants, included in the manual match file, with IDs 52151 and 7903 have duplicates for CAMD units and EIA units respectively.

CAMD_PLANT_ID CAMD_UNIT_ID CAMD_GENERATOR_ID EIA_PLANT_ID EIA_BOILER_ID EIA_GENERATOR_ID
52151 001 GEN1 52151 PB1 GEN1
52151 001 GEN1 52151 RF1 GEN1
52151 001 GEN2 52151 PB2 GEN2
52151 001 GEN2 52151 RF2 GEN2
7903 MGS1A MGS1A 7903   MGS1
7903 MGS1B MGS1B 7903   MGS1
7903 MGS2A MGS2A 7903   MSG2
7903 MGS2B MGS2B 7903   MSG2

j-tafoya avatar Feb 19 '21 14:02 j-tafoya

Include explanation about these occurrences. See PLANT_ID 7903 and 52151 for an example

j-tafoya avatar Mar 01 '21 15:03 j-tafoya