Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Cross references for plant IDs of different databases #6

Open
loganbyers opened this issue Apr 12, 2018 · 0 comments
Open

Cross references for plant IDs of different databases #6

loganbyers opened this issue Apr 12, 2018 · 0 comments
Labels
enhancement New feature or request

Comments

@loganbyers
Copy link
Member

loganbyers commented Apr 12, 2018 •
edited
Loading

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 loganbyers added the enhancement New feature or request label Apr 12, 2018
loganbyers added a commit that referenced this issue Dec 10, 2018
@loganbyers
Add WEPP Location ID to database (PLATTS ID)
383d6b3 
Addressing part of Issue #6, add a new field (`wepp_id`) to the output
database. This field holds a reference to a unique plant identifier in
the widely-used PLATTS-WEPP dataset. This should allow for
intercomparisons with an independently derived dataset, and will be
helpful to users who want to build a composite dataset for their
analyses.

The `wepp_id` field is a delimited field, with LOCATIONID values
separated by the pipe character (|) if multiple LOCATIONIDs match to a
single plant.

With this update, there are 16460 plants with known `wepp_id`s, which
account for 4312.6 GW in total (about 80% of all capacity in the output
database).

There are no changes to plants in the database except for the addition
of this `wepp_id`.

Database Version: 1.1.10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@loganbyers