Code Monkey home page Code Monkey logo

geonucleardata's Introduction

GeoNuclearData

This repository contains a database with information about Nuclear Power Plants worldwide.

Version

Database version: 0.17.0 (2020/04/19)
Dataset last updated in version: 0.17.17 (2024/03/03)

Changelog

See CHANGELOG file for details.

Data formats

Data is available in multiple formats (MySQL, JSON, and CSV).

Quick database summary (by reactor status)

Status Count Diff
Unknown 1
Planned 79 -1
Under Construction 61 +1
Operational 414 +3
Suspended Operation 25 -2
Shutdown 209
Suspended Construction 6
Cancelled Construction 4
Never Commissioned 2
Decommissioning Completed 3 0
Total 804 +1

Tables structure

countries

  • code - ISO 3166-1 alpha-2 country code
  • name - country name in English

nuclear_power_plant_status_type

  • id - numeric id key
  • type - nuclear power plant status

nuclear_reactor_type

  • id - numeric id key
  • type - nuclear reactor type acronym
  • description - nuclear reactor type long form

nuclear_power_plants

  • id - numeric id key
  • name - nuclear power plant name
  • latitude - latitude in decimal format
  • longitude - longitude in decimal format
  • country_code - ISO 3166-1 alpha-2 country code
  • status_id - nuclear power plant status id
  • reactor_type_id - nuclear reactor type id
  • reactor_model - nuclear reactor model
  • construction_start_at - date when nuclear power plant construction was started
  • operational_from - date when nuclear power plant became operational (also known as commercial operation date)
  • operational_to - date when nuclear power plant was shutdown (also known as permanent shutdown date)
  • capacity - nuclear power plant capacity (design net capacity in MWe)
  • source - source of the information
  • last_updated_at - date and time when information was last updated
  • iaea_id - IAEA PRIS reactor id

Notes

Data from source, last_updated_at, and iaea_id columns is for maintenance purposes only and is not recommended to be used.

Known Inconsistencies (GeoNuclearData vs. WNA vs. IAEA PRIS)

Operational Reactors

  • there are currently 414 reactors listed as being operational in the GeoNuclearData database, including China Experimental Fast Reactor (CEFR);
  • the PRIS database lists only 413 reactors as being operational (China Experimental Fast Reactor (CEFR) is not listed anymore) while the WNA's database has a slightly distinct category named Operable Reactors that probably also includes reactors in Suspended Operation.

Reactors Under Construction

  • The number of reactors listed as being under construction in the GeoNuclearData database does not match with either the number of reactors under construction from WNA's database or with the number from the PRIS database:
    • BALTIC-1 reactor (Russia) is shown as under construction in PRIS, but it was removed from the WNA's database in November 2000 (see here);
  • In addition to the list of reactors under construction from the PRIS database, the GeoNuclearData database also contains the following reactors (as in WNA's database):

Naming

  • The GeoNuclearData database usually follows the naming conventions from PRIS for reactors, but in WNA's database some nuclear reactors have completely different names. Some examples are:

Coordinates

  • the coordinates found in GeoNuclearData database are approximate;
  • the original source for the existing coordinates was an old Google Fusion Table dating back to March 2012 (probably sourced from WNA). Since the inception of this database some of the coordinates were manually corrected using Wikipedia/GeoHack and/or satellite imagery from Google Maps;
  • the operational Akademik Lomonosov-1 and 2 reactors (Russia) and planned Bohai Shipyard FNPP and Jiaodong Shipyard FNPP (China) reactors are floating nuclear power plants thus the coordinates from this database may not necessarily indicate their current location.

Usage

SELECT npp.`id`
    , npp.`name`
    , npp.latitude
    , npp.longitude
    , c.`name` 'country'
    , s.type 'status'
    , r.type 'reactor_type'
    , npp.reactor_model
    , npp.construction_start_at
    , npp.operational_from
    , npp.operational_to
FROM nuclear_power_plants npp
INNER JOIN countries AS c ON npp.country_code = c.`code`
INNER JOIN nuclear_power_plant_status_type AS s ON npp.status_id = s.id
LEFT OUTER JOIN nuclear_reactor_type AS r ON npp.reactor_type_id = r.id
ORDER BY npp.`id`

License

The GeoNuclearData database is made available under the Open Database License whose full text can be found at https://opendatacommons.org/licenses/odbl/1.0/.

Any rights in individual contents of the database are licensed under the Database Contents License whose full text can be found at https://opendatacommons.org/licenses/dbcl/1.0/.

Sources

Countries data is taken from Unicode Common Locale Data Repository.
Nuclear power plants data is taken from WNA/IAEA, but some other sources are used, e.g., Wikipedia.

WNA data is also taken from the IAEA PRIS reactor database, with more recent information added if available (see here).

geonucleardata's People

Contributors

ayrtonb avatar cristianst85 avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

geonucleardata's Issues

other formats: csv, json

Hi @cristianst85 !

There's a possibility you can put the data in other formats for easy import to other platforms? I can parse the data or create a db but I think this can be help other people use this data.

Thanks for the repo 😉.

keep CountryCode in denormalized json file

Hi,

could you keep "CountryCode" in denormalized json file ?

it could be very usefull because "Country" is english only but iso "CountryCode" is international to make relation with other data

ty ty

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.