CODERS database submission

[mseatle]

Name

CODERS

Screenshots

No response

Focus Topic

Canadian Open-source Database for Energy Research and Systems-Modelling (CODERS) is an extensive dataset that relates to generation facilities, transmission networks, substations and other system assets, as well as to system operations, demand, forecasts, imports, exports and costs in canadian electricity systems context.

Primary Purpose

The CODERS database houses energy data collected by the Sustainable Energy Systems Integration and Transitions (SESIT) group. This data is integral to populating a comprehensive suite of energy systems models, which encompass various vectors (such as power, transport, and building) and scales (including municipal, provincial, and federal levels), as well as sectors (like electricity, heat, and water). The dataset leverages the existing national and provincial databases made public by utilities, system operators, independent power producers, regulators, government agencies and energy associations.

Description

Canadian Open-source Database for Electricity Research and Systems-Modelling (CODERS) is an open-source database developed by the Sustainable Energy Systems Integration and Transition Group (SESIT). The database was built using MySQL which is an open-source relational database management system that uses Structured Query Language (SQL). The regular user has access to the database via an Application Programming Interface (API) which is the communication layer between the user and the database. Users will send HTTP requests to the API, and the requested data will be returned in JavaScript Object Notation (JSON) format. A regular user does not have direct access to the MySQL database and must request the data via the API.
CODERS is compartmentalized into two major databases:
Input Database: The database includes electricity generation, storage, transmission, substation and system operations data and parameters as well as hourly and annual data on provincial electricity demand, as well as interprovincial and international electricity transfers. The initial purpose of building up this database was to identify data suitable for populating our in-house energy models; a capacity expansion model (COPPER) and production cost model (SILVER).
Results Database: This database consists of pre-validated model output results that can be used directly for visualisation, analysis and research. The data is submitted to SESIT team using our API by users and upon validation is populated onto this database. One shall find COPPER and SILVER model run outputs for varied scenarios by varied organizations/uploaders under this database currently.

Mathematical Description

No response

Website

https://cme-emh.ca/en/coders/

Documentation

https://gitlab.com/sesit/m3-spine/-/wikis/4.-CODERS

Source

https://gitlab.com/sesit/m3-spine/-/tree/main/api_info?ref_type=heads

Year

2022

Institution

University of Victoria and University of Toronto

Funding Source

No response

Publications

3

Publication List

1. Miri, M., Saffari, M., Arjmand, R., & McPherson, M. (2022). Integrated models in action: Analyzing flexibility in the Canadian power system toward a zero-emission future. Energy, 261, 125181. https://doi.org/10.1016/j.energy.2022.125181
2. Miri, M., & McPherson, M. (2024). Demand response programs: Comparing price signals and direct load control. Energy, 288, 129673. https://doi.org/10.1016/j.energy.2023.129673
3. McPherson, M., Monroe, J., Jurasz, J., Rowe, A., Hendriks, R., Stanislaw, L., Awais, M., Seatle, M., Xu, R., Crownshaw, T., Miri, M., Aldana, D., Esfahlani, M., Arjmand, R., Saffari, M., Cusi, T., Toor, K. S., & Grieco, J. (2022). Open-source modelling infrastructure: Building decarbonization capacity in Canada. Energy Strategy Reviews, 44, 100961. https://doi.org/10.1016/j.esr.2022.100961

Use Cases

The database has been integrated with a modelling platform called M3 and is used to feed data for the energy models, namely COPPER and SILVER, within the project framework.

Infrastructure Sector

• Atmospheric dispersion
• Agriculture
• Biomass
• Buildings
• Communications
• Cooling
• Ecosystems
• Electric
• District heating
• Forestry
• Health
• Hydrogen
• Individual heating
• Land use
• Liquid fuels
• Natural Gas
• Transportation
• Water

Represented Behavior

• Earth Systems
• Employment
• Built Infrastructure
• Financial
• Macro-economy
• Micro-economy
• Policy
• Social

Modeling Paradigm

• Analytics
• Data
• Discrete Simulation
• Dynamic Simulation
• Equilibrium
• Engineering/Design
• Optimization
• Visualization

Capabilities

1. It allows for users to access database once they request their own API key and enables them to integrate this database in any of their research projects
2. It allows users to submit their model results and outputs to be integrated within the CODERS-Results Database which facilitates the academic community to use it to augment their research.

Programming Language

• C – ISO/IEC 9899
• C++ (C plus plus) – ISO/IEC 14882
• C# (C sharp) – ISO/IEC 23270
• Delphi
• GAMS (General Algebraic Modeling System)
• Go
• Haskell
• Java
• JavaScript(Scripting language)
• Julia
• Kotlin
• LabVIEW
• Lua
• MATLAB
• Modelica
• Nim
• Object Pascal
• Octave
• Pascal Script
• Python
• R
• Rust
• Simulink
• Swift (Apple programming language)
• WebAssembly
• Zig

Required Dependencies

Only thing required to get access to CODERS is signing an EULA(end user license agreement). Once our team gets your signed EULA we allocate a unique API key to you and you have full access to the database.

What is the software tool's license?

None

Operating System Support

• Windows
• Mac OSX
• Linux
• iOS
• Android

User Interface

• Programmatic
• Command line
• Web based
• Graphical user
• Menu driven
• Form based
• Natural language

Parallel Computing Paradigm

• Multi-threaded computing
• Multi-core computing
• Distributed computing
• Cluster computing
• Massively parallel computing
• Grid computing
• Reconfigurable computing with field-programmable gate arrays (FPGA)
• General-purpose computing on graphics processing units
• Application-specific integrated circuits
• Vector processors

What is the highest temporal resolution supported by the tool?

Hours

What is the typical temporal resolution supported by the tool?

None

What is the largest temporal scope supported by the tool?

Not Applicable

What is the typical temporal scope supported by the tool?

None

What is the highest spatial resolution supported by the tool?

Region

What is the typical spatial resolution supported by the tool?

None

What is the largest spatial scope supported by the tool?

Country

What is the typical spatial scope supported by the tool?

None

Input Data Format

SQL

Input Data Description

No response

Output Data Format

JSON

Output Data Description

No response

Contact Details

[email protected]

Interface, Integration, and Linkage

No response