Topics

Suggestions on integrating OpenEEMeter


Si Chen
 

Hello,

I'd like to get your suggestions on integrating OpenEEMeter with our open source opentaps energy application (opentaps.org) 

opentaps is an open source application built in Django.  It allows the user to set up multiple buildings, each with a list of all the equipment.  It then uses VOLTTRON to get building-level energy data with BACNET and MODBUS.  Once the data is there, the users could build dashboards and visualizations with Grafana and develop and run applications on top of it.

Where I see a potentially very cool integration is to use OpenEEMeter to build baseline energy consumption model for any meter, physical or virtual, that we have a time series data.  This baseline could then be used for measurement and verification (M&V) and financing purposes.  The meter data would be stored in a time series database like Crate or Timescale which provide a SQL-compatible interface.

Does this make sense?  Does it sound like what OpenEEMeter is designed for?

If so, do you have suggestions on how to do the integration with Django and SQL databases?


ngo.phil@...
 

Great idea! The OpenEEmeter can certainly be integrated into a django application, and it sounds like you have the right idea of what the library can be used to do. It's also python of course, so just pip install eemeter and you'll be able to call the library directly from django code. What you'll need to do is to get your time series data into pandas DataFrames with the right columns and indexes.

If you haven't used the library before, I'd suggest checking out our new tutorial and paying special attention to the data formats section, where we call out the three main required inputs: 1) meter data, 2) temperature data, and 3) project or intervention dates, and show demonstrate how to create a datasets with necessary format.

Phil


Si Chen
 

Thanks!  The tutorial was very helpful.

We’ll look into the integration and let you know how it goes.

On Tue, Oct 1, 2019 at 8:37 PM <ngo.phil@...> wrote:

Great idea! The OpenEEmeter can certainly be integrated into a django application, and it sounds like you have the right idea of what the library can be used to do. It's also python of course, so just pip install eemeter and you'll be able to call the library directly from django code. What you'll need to do is to get your time series data into pandas DataFrames with the right columns and indexes.

If you haven't used the library before, I'd suggest checking out our new tutorial and paying special attention to the data formats section, where we call out the three main required inputs: 1) meter data, 2) temperature data, and 3) project or intervention dates, and show demonstrate how to create a datasets with necessary format.

Phil

--
-----
Si Chen
Open Source Strategies, Inc.

opentaps and open source business models
at the VOLTTRON conference: https://youtu.be/2jnyIOBHrkU