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.
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
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
[X] Electric
[ ] District heating
[ ] Forestry
[ ] Health
[ ] Hydrogen
[ ] Individual heating
[ ] Land use
[ ] Liquid fuels
[X] Natural Gas
[ ] Transportation
[ ] Water
Represented Behavior
[ ] Earth Systems
[ ] Employment
[X] Built Infrastructure
[ ] Financial
[ ] Macro-economy
[ ] Micro-economy
[ ] Policy
[ ] Social
Modeling Paradigm
[ ] Analytics
[X] Data
[ ] Discrete Simulation
[ ] Dynamic Simulation
[ ] Equilibrium
[ ] Engineering/Design
[ ] Optimization
[ ] Visualization
Capabilities
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
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
[X] Windows
[X] Mac OSX
[X] Linux
[ ] iOS
[ ] Android
User Interface
[ ] Programmatic
[ ] Command line
[X] 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?
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
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
Represented Behavior
Modeling Paradigm
Capabilities
Programming Language
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
User Interface
Parallel Computing Paradigm
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
modellingteam.sesit@uvic.ca
Interface, Integration, and Linkage
No response