This database was populated from the demo-run...
URL: https://data.nlr.gov/system/files/49/1711668799-demo.sqlite
This database was populated from the demo-run of VOLTTRON in ESIF, using the historian agent.
https://github.com/VOLTTRON/volttron/wiki/SQL-Historian
Format:
List of topics and their units. Attribute Unit datalogger/log/dac/EV_AC Watts datalogger/log/dac/evse Watts datalogger/log/dac/house Watts datalogger/log/dac/hpwh Watts datalogger/log/dac/hvac Watts datalogger/log/dac/light Watts datalogger/log/dac/poolpump Watts datalogger/log/evse_relay_set/max_charge_rate_set Watts datalogger/log/evse_relay_set/mode_set_CEA2045 string datalogger/log/evse_relay_state/max_charge_rate Watts datalogger/log/evse_relay_state/mode_CEA2045 String datalogger/log/frequency_regulation/frequency_regulation float datalogger/log/hpwh_relay_set/control_signals_API String datalogger/log/hpwh_relay_state_mode/hpwh_mode_API String datalogger/log/hpwh_relay_state/hpwh_temp_bottom F datalogger/log/hpwh_relay_state/hpwh_temp_top F datalogger/log/hvac_relay_setpoint_set/setpoint F datalogger/log/hvac_relay_state/air_temp F datalogger/log/hvac_relay_state/hvac_mode integer datalogger/log/hvac_relay_state/setpoint F datalogger/log/light_relay_mode_set/light_selector_set integer datalogger/log/light_relay_setpoint_set/light_intensity_set integer datalogger/log/light_relay_state/IntensityA integer datalogger/log/light_relay_state/IntensityB integer datalogger/log/light_relay_state/light_selector_mode integer datalogger/log/poolpump_relay_set/max_charge_rate_set Watts datalogger/log/poolpump_relay_set/mode_set integer datalogger/log/poolpump_relay_state/max_power Watts datalogger/log/poolpump_relay_state/mode_CEA2045 string datalogger/log/sc_house/provided_EV Watts datalogger/log/sc_house/provided_house Watts datalogger/log/sc_house/provided_HVAC Watts datalogger/log/sc_house/requested Watts datalogger/log/simulation/total_reg_provided Watts datalogger/log/simulation/total_reg_requested Watts
All timestamps are strings of the form "%Y-%m-%d %H:%M:%S"
All topics containing 'zz_simulation' are the power consumption of the simulated appliances in Watts.
The Topics table contains a list of availabe topics on the volttron message bus.
(topic_id INTEGER PRIMARY KEY, topic_name TEXT NOT NULL, UNIQUE(topic_name))
The data table is a timeseries database of the topics from the topics table mapped by topic_id.
(ts timestamp NOT NULL, topic_id INTEGER NOT NULL, value_string TEXT NOT NULL, UNIQUE(ts, topic_id))
Source: Grid Connected Functionality
About this Resource
| Last updated | unknown |
|---|---|
| Created | unknown |
| Name | This database was populated from the demo-run of VOLTTRON in ESIF, using the historian agent. https://github.com/VOLTTRON/volttron/wiki/SQL-Historian Format: List of topics and their units. Attribute Unit datalogger/log/dac/EV_AC Watts datalogger/log/dac/evse Watts datalogger/log/dac/house Watts datalogger/log/dac/hpwh Watts datalogger/log/dac/hvac Watts datalogger/log/dac/light Watts datalogger/log/dac/poolpump Watts datalogger/log/evse_relay_set/max_charge_rate_set Watts datalogger/log/evse_relay_set/mode_set_CEA2045 string datalogger/log/evse_relay_state/max_charge_rate Watts datalogger/log/evse_relay_state/mode_CEA2045 String datalogger/log/frequency_regulation/frequency_regulation float datalogger/log/hpwh_relay_set/control_signals_API String datalogger/log/hpwh_relay_state_mode/hpwh_mode_API String datalogger/log/hpwh_relay_state/hpwh_temp_bottom F datalogger/log/hpwh_relay_state/hpwh_temp_top F datalogger/log/hvac_relay_setpoint_set/setpoint F datalogger/log/hvac_relay_state/air_temp F datalogger/log/hvac_relay_state/hvac_mode integer datalogger/log/hvac_relay_state/setpoint F datalogger/log/light_relay_mode_set/light_selector_set integer datalogger/log/light_relay_setpoint_set/light_intensity_set integer datalogger/log/light_relay_state/IntensityA integer datalogger/log/light_relay_state/IntensityB integer datalogger/log/light_relay_state/light_selector_mode integer datalogger/log/poolpump_relay_set/max_charge_rate_set Watts datalogger/log/poolpump_relay_set/mode_set integer datalogger/log/poolpump_relay_state/max_power Watts datalogger/log/poolpump_relay_state/mode_CEA2045 string datalogger/log/sc_house/provided_EV Watts datalogger/log/sc_house/provided_house Watts datalogger/log/sc_house/provided_HVAC Watts datalogger/log/sc_house/requested Watts datalogger/log/simulation/total_reg_provided Watts datalogger/log/simulation/total_reg_requested Watts All timestamps are strings of the form "%Y-%m-%d %H:%M:%S" All topics containing 'zz_simulation' are the power consumption of the simulated appliances in Watts. The Topics table contains a list of availabe topics on the volttron message bus. (topic_id INTEGER PRIMARY KEY, topic_name TEXT NOT NULL, UNIQUE(topic_name)) The data table is a timeseries database of the topics from the topics table mapped by topic_id. (ts timestamp NOT NULL, topic_id INTEGER NOT NULL, value_string TEXT NOT NULL, UNIQUE(ts, topic_id)) |
| Format | Web Resource |
| License | Creative Commons Attribution |
| Created | 3 weeks ago |
| Media type | application/octet-stream |
| has views | False |
| id | 41a6b6ac-e6af-41a2-83a3-3b159f10339f |
| metadata modified | 3 weeks ago |
| package id | eca550a0-f346-47cb-bbdc-de91744cccaa |
| position | 0 |
| state | active |
| tracking summary | {'total': 0, 'recent': 0} |