wri / global-power-plant-database

A comprehensive, global, open source database of power plants
315 stars 96 forks source link

Cross references for plant IDs of different databases #6

Open loganbyers opened 6 years ago

loganbyers commented 6 years ago

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

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,