global-power-plant-database icon indicating copy to clipboard operation
global-power-plant-database copied to clipboard

Published 20 hours ago • verified publisher icon wri

Cross references for plant IDs of different databases

Open loganbyers opened this issue 6 years ago • 0 comments

Description

Existing databases like GEODB, CARMA, PLATTS-WEPP are already being used by different research organizations. For various reasons (migration, intercomparison, ...) it would be very useful to have information that matches the primary keys across all these databases.

Possible Steps

[TODO]

Possible Data Sources

  • GEODB
  • CARMA
  • ~~PLATTS-WEPP~~ - location ids are being tracked as of 383d6b3
  • Enipedia

Challenges

One-to-many and many-to-one relations here. Also need to track which plants we don't know matches for versus which plants we know don't have matches. (null vs NoData).

Additional Info

keywords: identity, identifiers, cross reference, foreign key,

loganbyers avatar Apr 12 '18 17:04 loganbyers